When syncing invoices from Docket into QuickBooks Online (QBO), Product & Service line items must be set up correctly. If names or mappings don’t match, revenue may appear in the wrong category or default to “Services.” This guide shows how to set up, map, and troubleshoot Products & Services.
Before You Start
- Confirm access to Products & Services in QBO.
- Have Docket’s Pricing Matrix and Billing Templates exported.
- Decide how you want revenue reported (all in one account, or broken down by service type).
How Mapping Works
- QBO matches on Name only (case-sensitive, punctuation and spacing must match exactly).
- Each Product/Service item in QBO must be assigned to an Income account.
- Customer names must also match between Docket and QBO for invoices to sync successfully.
Step 1: Set Up Products & Services in QBO
- Go to Sales > Products and Services.
- Click New, or edit an existing item.
- In the Name field, paste the exact service name from Docket.
- Assign the correct Income Account.
- Save. Repeat for all Docket services.
Step 2: Choose Income Account Structure
Option 1: General Income Account
- Assign all services to one account (e.g., “Services”).
- Use when: you only need total income, not detail by service type.
- Example:
- Docket item: Half Bedload – Commercial
- QBO mapping: Income Account = Services
- P&L shows one line “Services.”
Option 2: Sub-Account Structure
- Assign services to sub-accounts for detailed reporting (e.g., Residential vs. Commercial).
- Use when: you want revenue broken down by service category.
- Example Chart of Accounts:
Services (Parent)
├── Commercial
│ ├── Commercial Dumpsters
│ └── Commercial Junk Removal
└── Residential
├── Residential Dumpsters
└── Residential Junk Removal
- Example:
- Docket item: Half Bedload – Commercial
- QBO mapping: Services > Commercial > Commercial Junk Removal
- P&L shows revenue under “Commercial Junk Removal.”
Step 3: Test Mapping
- In QBO, create/update a Product/Service with the correct name and account.
- In Docket, create an invoice with that item.
- Sync the invoice to QBO.
- Open the invoice in QBO:
- Does the name match?
- Is revenue in the correct income account?
Step 4: Handle Historical Invoices
- After updating QBO Products & Services, go to Invoices in Docket.
- Select invoices to resync > Actions > QuickBooks Sync.
- Start with a few tests before bulk resyncing.
⚠️ Note: Deleting invoices in Docket does not remove them from QBO. To clean up test data, delete the invoice and payment manually in QBO.
Troubleshooting Common Issues
| Problem | Cause | Fix |
| Services map to generic “Services” | Name mismatch between Docket and QBO | Update QBO Product/Service name to match Docket exactly |
| P&L shows too much detail (every line item) | Each item mapped individually | Use sub-accounts to group services |
| Invoice didn’t sync | Customer or Product/Service name mismatch | Confirm exact matches across both systems |
| Old invoices show wrong category | They synced before mapping was fixed | Bulk resync after correcting mapping |
Checklist for Setup
- Export Billing Templates and Pricing Matrix from Docket
- Confirm Product/Service names match in QBO
- Assign each item to the correct Income account
- Test one invoice for accuracy
- Resync historical invoices if needed
- Clean up test invoices manually in QBO
Summary
- Product & Service names must match exactly between Docket and QBO.
- Income accounts can be simple (all in one) or structured (by sub-category).
- Test with one invoice before bulk syncing.
- Resync historical invoices after corrections.