QuickBooks & Xero Two-Way Sync
How DocuClipper validates required fields before export, keeps later edits in sync with QuickBooks Online and Xero, and lets you pick contacts, items, accounts, and tax codes straight from your connected company.
Last updated
DocuClipper doesn't just push invoices and bills into QuickBooks Online (QBO) and Xero once — it keeps them aligned. Once a project is linked to a connected company, approved invoices are created automatically as they're extracted, DocuClipper validates the required fields before each push, it lets you pick contacts, items, accounts, and tax codes directly from your connected company, and after a record has been synced it pushes your later classification edits back automatically — matched by ID, so it updates the existing record instead of creating a duplicate.
This article explains those behaviors. To connect a project in the first place, open the invoice's Export & Sync panel and choose Connect Integration; for the walkthrough, see Import invoices and receipts into QuickBooks Online and Export invoices to Xero.
Automatic creation on extraction
Linking a project to a QBO or Xero connection makes sync the default, not a manual step. As each document finishes extracting, DocuClipper creates it in the connected company automatically:
- Approved invoices only. If your project uses the approval workflow, an invoice syncs once it's approved. Purchase orders skip the approval gate and sync as draft POs.
- QuickBooks records post; Xero records land as drafts. In QuickBooks the bill, invoice, or expense is created as a normal posted record. In Xero the bill (ACCPAY) or sales invoice (ACCREC) is created in Draft status, so you review and approve it inside Xero before it hits your ledger.
- Document type sets the record type. A bill/payable becomes a QuickBooks Bill or Xero ACCPAY; a receivable becomes a QuickBooks Invoice or Xero ACCREC; an expense/purchase becomes a QuickBooks Purchase/expense; a purchase order becomes a draft PO. See Choose "Bills & Receipts" or "Sales Invoices" when you upload.
The reconciliation gate below applies to edits you make afterward, not to this extraction-time creation.
Pre-flight required-field validation
Before any push — whether automatic on extraction or a manual sync — DocuClipper validates the invoice against the target accounting system before it makes any API call. If a field that QuickBooks or Xero requires is missing, the sync is blocked and you get a specific message telling you exactly what to fix — including the line number for line-level problems — instead of a cryptic error coming back from the accounting system.
What's required depends on the document type and the target:
| Target & document type | Header requirement | Per-line requirement |
|---|---|---|
| QBO — Invoice (receivable) | Customer | A numeric amount on each line |
| QBO — Bill (payable) | Vendor | A category/account or a product/service item, plus a numeric amount |
| QBO — Expense / Purchase | Payment account | A category/account, plus a numeric amount |
| Xero — Bill (ACCPAY) | Contact (supplier) | An account code, plus an amount |
| Xero — Sales Invoice (ACCREC) | Contact (customer) | An account code, plus an amount |
A blocked sync reads, for example:
Cannot sync to QuickBooks Online: this bill is missing a required Vendor. Please set it before syncing.
or, for a line-level gap:
Cannot sync to Xero: line 2 (Office Supplies) is missing a category/account. Please set it before syncing.
Fix the flagged field on the invoice detail page and sync again. The invoice rules and per-project default account features exist largely to fill these required fields in for you so validation passes on the first try.
Pick contacts, items, accounts, and tax codes from your connected company
Once a project is linked to QuickBooks or Xero, the mapping fields on the invoice detail page become searchable dropdowns that pull live from your connected company — so you map to records that actually exist instead of typing free text that might not match.
- Contact — start typing to search your QBO customers/vendors or Xero contacts.
- Item / product-service — start typing to search the items and products defined in QBO or Xero. (Previously only the contact field was a connected dropdown; the item/product field now works the same way.)
- Category / account — pick from your chart of accounts.
- Tax code / tax rate — pick from the tax codes (QBO) or tax rates (Xero) configured in your company.
Each dropdown searches as you type. If the record you need doesn't exist yet, you can create it inline — type the new name and choose the "create" option, and DocuClipper creates it in QuickBooks or Xero on export.
Fixing what's missing also syncs it
The automatic push on extraction only goes through if the invoice already has everything the accounting system requires. On your first invoice from a new vendor that often isn't the case — no rule exists yet, so the vendor or a line's category may be blank, and the push is held.
You don't need to look for a Sync button. Fill in what the Export & Sync panel says is missing, and the moment nothing is blocking it, DocuClipper pushes the invoice on its own. If several lines need coding, it waits until the last one is done rather than retrying on every keystroke.
The same reconciliation and approval rules below apply to that first push.
Automatic re-sync of later edits
If you edit an invoice or bill after it has already been synced, DocuClipper pushes the change back to QuickBooks or Xero automatically — you don't have to remember to re-export it.
How it behaves:
- Update, never duplicate. Re-sync only updates the record that already exists in the accounting system (matched by its stored ID). It never creates a second copy.
- Classification fields only. Re-sync covers the fields you typically correct after the fact: category/account, product/service item, and tax code. Identity and amount fields (quantity, unit price, line description) are not re-pushed — change those before the first sync.
- Both systems. Works for QBO invoices, bills, and expenses, and for Xero bills and sales invoices. (Purchase orders are not re-synced.)
- Reconciliation-gated. If the invoice doesn't reconcile (subtotal + tax ≠ total, or lines don't sum to the subtotal), the automatic push is held so a broken record isn't sent to your books — including when a rule is what filled the fields in. The panel names the discrepancy, for example "Line items $34,901.92 ≠ Subtotal $35,156.13", the edit still saves in DocuClipper, and you can force the push with Sync anyway once you've reviewed it. This is usually worth investigating rather than overriding: it most often means a line didn't come through the extraction, so the total in your books would be short.
- Best-effort. Your edit always saves in DocuClipper immediately. The re-sync runs in the background; if the accounting system rejects it (for example a bill that's already locked or paid), the edit still sticks in DocuClipper and the failure is recorded so you can retry. The sync status badge and its timestamp update when the push succeeds.
This is what makes a bulk-apply of a category to every line, or a single corrected GL code, flow through to QuickBooks or Xero without a manual re-export.