Troubleshooting QuickBooks Sync Issues in LeanLaw
How to troubleshoot and fix common QuickBooks Online sync errors in LeanLaw — including disconnected clients, deleted customers, invalid product/service errors, closed period errors, and special character issues.
Most LeanLaw–QuickBooks sync errors fall into a small number of recognizable categories. This guide covers the most common ones — find your error type and follow the fix.
Running the QuickBooks Online Connection Validator
Before troubleshooting individual errors, use LeanLaw's built-in validator to scan all clients and matters for broken QuickBooks Online connections:
- Go to the Matters page (or Clients page).
- Click Validate QuickBooks Connections.
- A QuickBooks Online status icon appears next to every client and matter. Green = connected, Red = broken, Blank = not yet connected to QuickBooks Online.
- Click the Filter Connections dropdown → select Bad connection to QuickBooks to show only broken connections.
- Work through each red connection using the fixes below.
|
📋 Check both pages: If your firm uses client accounting, broken connections appear on the Clients page. If you use matter accounting, they appear on the Matters page. Check both when scanning for issues. |
Error: Client or Matter Shows as 'Deleted' in QuickBooks Online Tab
This error appears in the Matter's QuickBooks tab — the QuickBooks Online Customer field shows '(deleted)'. It means the corresponding QuickBooks Online customer has been made inactive in QuickBooks.
Fix: Reactivate the QuickBooks Online Customer
- In QuickBooks Online, go to Sales → Customers.
- Click the gear icon in the customer list and enable Include Inactive.
- Find the greyed-out/inactive customer and click Make Active.
- Return to LeanLaw and refresh — the connection restores automatically.
Error: Client or Matter Disconnected (Wrong QuickBooks Online Customer Linked)
If the QuickBooks Customer field on a matter shows the wrong name — or the connection was broken by a name change or type change in QuickBooks Online — you can reconnect it manually:
- Open the matter → QuickBooks tab.
- Click the dropdown arrow next to the incorrect QuickBooks Customer name.
- Select Open in QuickBooks to verify the issue, or select the correct customer from the dropdown.
- Warning: if the connector warns that the selected customer is already linked to another LeanLaw client or matter, do not save — this will cause duplicate billing issues. Contact LeanLaw Support.
- Click Save Changes and refresh.
Error: 'Invalid Reference ID — Product/Service has been deleted'
This error occurs when submitting an invoice to QuickBooks Online — the Product/Service assigned to the invoice no longer exists in QuickBooks Online because it was deleted or deactivated.
Fix
- In QuickBooks Online, go to Settings → Products and Services. Find the deleted service and reactivate it (or create a new one with the same name).
- In LeanLaw, go to Settings → QuickBooks → Edit Expense Settings. Verify that the Product/Service for expenses is set to a valid, active QuickBooks Online service.
- Also verify the Default QuickBooks Service is set to an active service.
- In LeanLaw, undo the failed invoice back to Ready to Bill.
- Recreate the draft and resubmit to QuickBooks Online.
Error: 'The account period has closed'
This error occurs when you try to sync an invoice dated within a locked accounting period in QuickBooks Online. If your QuickBooks Online has a 'Close the books' date set in Company Settings → Advanced → Accounting, invoices dated on or before that date cannot be modified through the API.
Fix — Option A: Change the Invoice Date
- In LeanLaw, undo the invoice back to Draft.
- Change the invoice date to a date after the closed period.
- Resubmit to QuickBooks Online.
Fix — Option B: Temporarily Reopen the Period
- In QuickBooks Online, go to Company Settings → Advanced → Accounting.
- Temporarily disable the 'Close the books' setting.
- Refresh LeanLaw and resubmit the invoice.
- Re-enable the closed period in QBO once the invoice is submitted.
|
⚠️ Use with care: Reopening a closed accounting period can affect financial reports and audits. Only do this if absolutely necessary and with your accountant's awareness. |
Error: 'Invalid Content' / Special Characters
This error occurs when a matter name, invoice description, or other field contains a special character that QuickBooks Online's API doesn't accept — most commonly a Unicode apostrophe (') instead of a standard ASCII apostrophe (').
Fix
- Identify which field contains the special character — usually the matter name or a time entry description.
- Edit the field and replace the special character with its standard equivalent (e.g., replace the curly apostrophe ' with a straight one ').
- Resubmit the invoice to QuickBooks Online.
|
💡 Prevention tip: Special character errors often occur when matter names or descriptions are pasted from Word, Outlook, or a PDF — these applications commonly use 'smart quotes' and curly apostrophes. Type field values directly when possible, or paste as plain text. |
Error: Insufficient Permissions
If a user gets errors when attempting to sync invoices or record payments, their LeanLaw user role may not have sufficient permissions for QuickBooks Online operations.
Fix
- Go to Settings → Users and open the affected user's profile.
- Verify their role — Timekeepers cannot submit invoices to QuickBooks Online. The user may need to be an Operator or have elevated billing permissions.
- Update the role or permissions as needed and have the user retry.
Error: Blank Required Fields
If an invoice contains a line item with a blank amount (for example, an expense with no dollar value entered), QuickBooks Online will reject the submission.
Fix
- Undo the invoice back to Draft.
- Find the line item with the blank amount and either enter a valid amount (or 0.00 if appropriate) or remove the item from the invoice.