NelsonFamilies Reset Project Documents Logo

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

QuickBooks Tracking

  Using JKL Works Account

Nelson Family Inventory & Sales Tracker

🏠 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

IDItem NameCategoryLocationConditionSuggested PriceDispositionPlatformStatusActions

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:

  1. Click “New” → “Non-inventory”
  2. Name: “RESET-[CATEGORY]-[###]”
  3. SKU: Auto-generate (NF + timestamp)
  4. Sales price: Your suggested price
  5. Income account: 4200 Reset Project Sales
  6. 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

  1. Connect Square account
  2. 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:

  1. Go to Settings → Custom Form Styles
  2. Create new style: “Reset Project Receipt”
  3. 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:

  1. New Sale Alert: Email when item sells > $100
  2. Weekly Summary: Sunday email with week’s stats
  3. Donation Receipt: Auto-generate for tax purposes
  4. Low Performer Alert: Items listed > 14 days

9. Mobile App Configuration

For field inventory:

  1. Download QuickBooks Online app
  2. Enable: Receipt Snap, Mileage Tracking
  3. Create shortcut: “Quick Add Reset Item”
  4. 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):

  1. Check overnight sales from all platforms
  2. Mark items as “Sold” in Products
  3. Create sales receipts

When Item Sells:

  1. Mobile: Quick create sales receipt
  2. Select customer or “Cash Sale”
  3. Add product by SKU
  4. Select payment method (Square auto-syncs)
  5. Add pickup appointment in notes

End of Day (10 min):

  1. Reconcile Square deposits
  2. Update inventory status
  3. Run daily sales report
  4. Export next day’s listing batch

Integration with Square:

In-Person Sales Setup:

  1. Create item library in Square matching QBO SKUs
  2. Set up Square Reader for garage sale
  3. Enable digital receipts
  4. Turn on inventory tracking

Online Payment Links:

  1. Create Square Online checkout pages
  2. Generate QR codes for items
  3. Add payment links to all listings
  4. 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