
DOCUMENT THE PROCESS
The posted items are sold and payment has been received. Plus, if applicable, the items were shipped or exchanged. Now it’s time to document the process. We can track items in various ways through this website, a spreadsheet, and in QuickBooks Online via JKL Worksk which we can document. The inventory tracking systems and reports are here along with tracking for QuickBooks Online.
NelsonFamilies.Net Inventory Report
Requires System Login
🏠 Nelson Family Reset Project
Inventory Management & Sales Tracker
0
Total Items
0
Listed for Sale
0
Items Sold
0
Items Donated
$0
Total Revenue
$0
Average Sale Price
Add/Edit Item
| ID | Item Name | Category | Location | Condition | Suggested Price | Disposition | Platform | Status | Actions |
|---|
QuickBooks Online Advanced Setup for Nelson Reset Project
1. Create Dedicated Class/Location
Navigate to: Settings → All Lists → Classes
- Create Class: “Reset Project 2025”
- Sub-classes:
- House 1 Inventory
- House 2 Inventory
- External Storage
- Garage/Workshop
- Donation Items
2. Set Up Income Accounts
Navigate to: Accounting → Chart of Accounts → New
Create these accounts:
- 4200 – Reset Project Sales (Income)
- 4201 – Facebook Marketplace Sales
- 4202 – eBay Sales
- 4203 – Website Sales
- 4204 – Garage Sale Revenue
- 4205 – Bulk Lot Sales
3. Create Products & Services
Navigate to: Sales → Products & Services
Quick Add Method for Bulk Items:
- Click “New” → “Non-inventory”
- Name: “RESET-[CATEGORY]-[###]”
- SKU: Auto-generate (NF + timestamp)
- Sales price: Your suggested price
- Income account: 4200 Reset Project Sales
- Sales tax: Check if applicable
Categories to Create:
- RESET-ELEC (Electronics)
- RESET-FURN (Furniture)
- RESET-TOOL (Tools)
- RESET-APPL (Appliances)
- RESET-COLL (Collectibles)
- RESET-MISC (Miscellaneous)
4. Custom Fields Setup
Navigate to: Settings → Custom Fields
Add these custom fields for Products:
- Platform (Dropdown: FB, eBay, Web, Craigslist, Garage)
- Condition (Dropdown: New, Like New, Good, Fair)
- Location (Text)
- Original Cost (Number)
- Date Listed (Date)
- Buyer Contact (Text)
5. Square Integration
Navigate to: Apps → Square
- Connect Square account
- Set sync preferences:
- Auto-import: Daily
- Match items by: SKU
- Default income account: 4200
- Auto-create customers: Yes
6. Sales Receipt Template
Customize for Reset Project:
- Go to Settings → Custom Form Styles
- Create new style: “Reset Project Receipt”
- Include:
- Item description
- SKU
- Pickup location
- Buyer phone
- Payment method
7. Reporting Dashboard Setup
Navigate to: Reports → Management Reports
Create custom report package:
“Reset Project Dashboard”
- Sales by Platform (weekly)
- Items Sold vs Listed
- Revenue by Category
- Top Performing Items
- Days to Sale Analysis
- Location Clearance Progress
8. Automated Workflows
Navigate to: Settings → Workflows
Create these automations:
- New Sale Alert: Email when item sells > $100
- Weekly Summary: Sunday email with week’s stats
- Donation Receipt: Auto-generate for tax purposes
- Low Performer Alert: Items listed > 14 days
9. Mobile App Configuration
For field inventory:
- Download QuickBooks Online app
- Enable: Receipt Snap, Mileage Tracking
- Create shortcut: “Quick Add Reset Item”
- Set default class: Reset Project 2025
10. Tax Deduction Tracking
For donations:
- Create Expense account: “Charitable Contributions”
- Sub-accounts by organization
- Attach photos of donated items
- Track fair market value
Daily Workflow in QuickBooks:
Morning (5 min):
- Check overnight sales from all platforms
- Mark items as “Sold” in Products
- Create sales receipts
When Item Sells:
- Mobile: Quick create sales receipt
- Select customer or “Cash Sale”
- Add product by SKU
- Select payment method (Square auto-syncs)
- Add pickup appointment in notes
End of Day (10 min):
- Reconcile Square deposits
- Update inventory status
- Run daily sales report
- Export next day’s listing batch
Integration with Square:
In-Person Sales Setup:
- Create item library in Square matching QBO SKUs
- Set up Square Reader for garage sale
- Enable digital receipts
- Turn on inventory tracking
Online Payment Links:
- Create Square Online checkout pages
- Generate QR codes for items
- Add payment links to all listings
- Auto-sync with QuickBooks
Reports You’ll Want Weekly:
- Profit & Loss: Class = Reset Project 2025
- Sales by Product: Top 20 performers
- Customer List: For repeat buyers
- Donation Summary: For tax records
