ZenotiHelp

Accounting variance report

ZTZenoti Docs Team Updated August 19, 2026 4 min readReference

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

Permission: Organization administrator access is required to view accounting reports.

  1. Navigate to Configuration > Integrations > Integration settings, then search and expand Accounting.
  2. Open the Sync Report or Activity Log — the variance view is a filtered version of the same dataset.
  3. Filter by date range, center, and sync type.
  4. 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

  1. Filter the report to show records with a SyncFailed or QueueFailed status.
  2. Click a failed record to view the error details returned by the provider.
  3. Correct the underlying issue (account mapping, currency mismatch, expired authorization, period closed, and so on). Use the troubleshooting guides:
  1. 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
  • 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.

Was this article helpful?
Your feedback helps us improve our documentation.