Accounting variance report
The Accounting Variance report shows discrepancies between Zenoti financial records and the data synced to your accounting provider (Xero, QuickBooks Online, or Codat). Use it to catch sync failures, amount mismatches, and unsynced records before they turn into reconciliation problems at period close.
Audience: Finance leads and organization administrators reconciling Zenoti revenue against the provider ledger.
On this page
- Access the report
- Report columns
- Interpreting sync statuses
- Resolving variances
- Reconciliation workflow
- Tips
- Related articles
Access the report
Permission: Organization administrator access is required to view accounting reports.
- Navigate to Configuration > Integrations > Integration settings, then search and expand Accounting.
- Open the Sync Report or Activity Log — the variance view is a filtered version of the same dataset.
- Filter by date range, center, and sync type.
- Optionally filter by Sync Status to focus on failures (SyncFailed, QueueFailed).
Report columns
| Column | Description | Source |
|---|---|---|
| Date | Date of the transaction or sync event | Zenoti invoice / payment date |
| Center | Center associated with the record | Zenoti center |
| Sync Type | Invoice, Payment, Items, PettyCash, Inventory, or InventoryAdjustment | Zenoti sync engine |
| Zenoti Amount | Amount recorded in Zenoti | Zenoti invoice / payment |
| Provider Amount | Amount recorded in the accounting provider | Retrieved from Xero, QBO, or Codat |
| Variance | Difference between Zenoti and provider amounts | Computed |
| Sync Status | Pending, Synced, Queued, SyncFailed, or QueueFailed | Zenoti sync engine |
| Error Message | Error returned by the provider if the sync failed | Provider API response |
| Provider Reference | The provider-side invoice or payment ID | Provider API response |
Interpreting sync statuses
| Status | Meaning | Recommended action |
|---|---|---|
| Pending | Waiting for the next scheduled sync cycle | No action. Check again after the next run. |
| Synced | Successfully transferred to the accounting provider | No action. Verify match in provider-side report. |
| Queued | Retry queue after a temporary failure | No action. Retries next cycle. Investigate if it stays queued across multiple cycles. |
| SyncFailed | Sync attempt failed | Review the error message; take corrective action; re-run. |
| QueueFailed | Record could not be queued at all | Rare. Contact Zenoti Support. |
Resolving variances
- Filter the report to show records with a SyncFailed or QueueFailed status.
- Click a failed record to view the error details returned by the provider.
- Correct the underlying issue (account mapping, currency mismatch, expired authorization, period closed, and so on). Use the troubleshooting guides:
- Failed records are automatically retried in the next scheduled sync cycle. To retry immediately, run a manual sync for the affected date range.
Non-zero variance on Synced records
A record marked Synced with a non-zero variance means the amount in the provider does not match Zenoti. Causes:
- Manual edit in the provider after Zenoti posted the invoice.
- Rounding differences between tax-inclusive Zenoti pricing and tax-exclusive provider configuration.
- Currency conversion applied in the provider but not in Zenoti.
- Double-post caused by a manual entry in the provider that duplicated the Zenoti sync.
Never edit the provider-side record to match Zenoti without a reconciling journal — it hides the discrepancy.
Reconciliation workflow
Use this report as the variance view — pair it with Zenoti's transactional reports and the provider's native reports for full reconciliation.
Match key
Every Zenoti invoice or payment synced to the provider carries the Zenoti invoice number in the provider's reference field. This is the match key. Match on:
- Xero: Invoice reference
- QuickBooks Online: Doc Number / reference
- Codat-fronted providers: Reference (varies by downstream provider; confirm with your Codat account manager)
Zenoti-side reports
| Report | When to use |
|---|---|
| Collections by Invoices | Primary list of invoices collected during the period, with payment agent breakdown |
| Payment Agent report | Totals per payment method, used to reconcile clearing accounts |
| Accounting variance report (this report) | Failures, queued records, and amount variances |
Provider-side reports
| Provider | Report | Notes |
|---|---|---|
| Xero | Business > Invoices (filter by contact / date); Tax Summary for the period | VAT return relies on the Tax Summary |
| QuickBooks Online | Sales > Invoices; Sales Tax Liability | Tax Liability used for filing |
| Codat | Depends on the downstream provider | Ask your Codat account manager for the equivalent view |
Recommended cadence
- Daily: review SyncFailed and QueueFailed for the past 24 hours.
- Weekly: run the variance report and match totals against the Zenoti Collections by Invoices report.
- Monthly at close: full reconciliation Zenoti ↔ provider, invoice-by-invoice if material variances exist.
Tips
- Run this report weekly to catch sync failures before they accumulate.
- If you see widespread failures after a period of inactivity, your OAuth token may have expired. Re-authorise the connection.
- For Xero, refresh tokens expire after 60 days of inactivity. For QuickBooks Online, re-authorise if you see "Authorization expired" errors.
- Filter by center when reconciling a specific location — group totals can hide per-center issues.
- Save the variance export before closing a period. It's your audit trail if the provider-side record changes later.