Sync financial data with accounting providers
Once your accounting provider is connected and data mapping is configured, Zenoti synchronises financial data on the configured schedule. This article covers the day-to-day workflow for monitoring sync runs, triggering manual syncs, editing or voiding synced invoices, handling refunds, and reconciling Zenoti against the provider.
On this page
- Before you begin
- Automatic sync
- Run a manual sync
- Monitor sync status
- Edit or void a synced record
- Refund a synced payment
- Handle a failed sync
- Reconciliation
- Tips
- Related articles
Before you begin
Permission: You need organization administrator access to run accounting syncs.
- Accounting provider must be connected. See Connect an accounting provider.
- Data mapping must be configured. See Configure accounting data mapping.
- Sync schedule must be configured. See Configure accounting sync schedules.
Automatic sync
Zenoti syncs financial data automatically according to the schedule you configured. Each sync type (Invoice, Payment, Items, PettyCash, Inventory, InventoryAdjustment) runs independently at the configured frequency. Sync direction is Zenoti β provider; the provider does not push data back to Zenoti.
Run a manual sync
Use the Manual Sync panel to refresh master data or to re-post a single business date after a mapping change or an outage. Its note says that once sync schedules are set up there is no need for a manual sync.
- Navigate to Configuration > Integrations > Integration settings, expand Accounting, and open Manual Sync.
- To refresh reference data, select Get on the relevant row (Locations, Payment Methods, Customers, Taxes, All Items, Journals, and the provider's other master-data rows).
- To re-post transactions, pick the business date in Choose a date and select Post on the row. A manual post processes one date at a time.
- Wait for the row to report
Successor a failure message.
Manual runs share the provider's API rate limits with the scheduled jobs. Let a large backfill finish before the next scheduled run.
Monitor sync status
Navigate to the accounting integration Sync Report or Activity Log.
Review records with their statuses.
Status Meaning Next step Pending Waiting for the next sync cycle. No action. Record picks up on next run. Synced Successfully transferred to the accounting provider. Record appears in the provider. Queued In the retry queue after a temporary failure. Retries on next cycle automatically. SyncFailed Failed. Error message available on the record. Correct the underlying issue and retry manually or wait for the next cycle. QueueFailed Could not be queued at all. Contact Zenoti Support. Usually an internal Zenoti error, not a provider error. For failed records, click the record to view the error returned by the provider.
After correcting the underlying issue, the record is automatically retried in the next sync cycle, or you can trigger an immediate manual sync.
Edit or void a synced record
Whether a record can be modified depends on its state in Zenoti and in the accounting provider.
Unsynced invoice (still Pending or SyncFailed in Zenoti)
If the invoice has not yet reached the provider (status is Pending, Queued, or SyncFailed), it behaves like any Zenoti invoice.
- Open the invoice in Zenoti.
- Edit or void it directly.
- On the next sync cycle, Zenoti transmits the corrected record. No reconciliation step is needed on the provider side because nothing was posted there.
Synced invoice (status is Synced in Zenoti and exists in the provider)
Once the invoice has been synced, the provider holds the authoritative copy. Zenoti does not push in-place edits to synced invoices because audit rules in both Xero and QuickBooks Online disallow silent amendments to posted invoices.
The correct path is void and reissue:
- In Zenoti, void the original invoice. Voiding creates a compensating entry that is picked up on the next sync.
- Zenoti posts a reversal to the provider β in Xero this is typically a credit note; in QBO it's either a credit memo or a voided invoice depending on the invoice state in QBO at the time.
- Create a new invoice in Zenoti with the correct details.
- On the next sync, the new invoice posts to the provider.
- The provider's ledger now shows: original invoice + credit note + new invoice. Net revenue is correct; audit trail is preserved.
If the provider has closed the accounting period that contains the original invoice, the reversal must post to the current open period. Work with finance to ensure period locks on both sides align.
Refund a synced payment
Refunds need to be documented from both sides because Zenoti and the accounting provider record them differently.
| Dimension | Zenoti behaviour | Provider behaviour |
|---|---|---|
| Trigger | Front desk issues a refund through the Zenoti invoice | Zenoti sends a negative payment (or refund) entry on the next Payment sync |
| Xero representation | β | Refund posted against the original payment; Xero links it back to the invoice |
| QBO representation | β | Refund receipt created referencing the customer and account; QBO does not auto-link to the invoice in all cases |
| Manual reconciliation | None in Zenoti β refund is visible on the invoice | On QBO, finance may need to manually apply the refund receipt to the original invoice if the link is missing |
| Bank settlement | Zenoti does not see the bank side | The clearing/bank account in the provider shows the refund after the processor settles |
If your workflow depends on the provider showing refunds tied to the original invoice (for example, for audit or tax return reporting), pick a provider that gives you that link automatically. On QBO, plan to run a monthly reconciliation step to check refund linking.
Handle a failed sync
| Failure mode | User-visible symptom | Resolution |
|---|---|---|
| Provider API unreachable | All records for a run stay in Queued | Retry on next cycle. Check status.xero.com, status.developer.intuit.com, or status.codat.io if persistent. |
| OAuth token expired | Records fail with "Authorization expired" | Re-authorise the provider connection. See Connect an accounting provider. |
| Target account inactive | Records fail with "Account not found" | Update the mapping in Configure accounting data mapping to an active account. |
| Accounting period closed | Records fail with "period closed" | Either re-open the period in the provider (with finance sign-off) or move the sync start date forward past the closed period and reconcile the gap manually. |
| Business rule rejection | Records fail with provider-specific validation error | Read the exact message. Common cases: required field missing (tax agency, reference number length limit, tracking dimension), currency mismatch. Fix in the relevant Zenoti configuration and retry. |
| Credit limit or duplicate reference | Records fail with "duplicate" or "limit exceeded" | Investigate in the provider. Duplicates usually indicate a manual entry in the provider for data Zenoti also syncs β never enter those records manually. |
| Financial Lock mismatch | Records that look eligible are not picked up | Confirm Financial Lock dates at both organisation and center level in Zenoti. See the troubleshooting articles linked below. |
Reconciliation
Accounting integrations live or die on reconciliation. Never assume a sync is clean β verify periodically against both sides.
Zenoti-side source of truth
Run the Collections by Invoices report in Zenoti, filtered to the relevant payment agents, for the reconciliation window. This report lists every invoice with:
- Invoice number (used as the reference in Xero and QBO)
- Amount and tax breakdown
- Payment agent
- Center
Supplement with the Accounting variance report (see Accounting variance report) for records that failed or diverged in amount.
Provider-side source of truth
| Provider | Report / view | Where to find it |
|---|---|---|
| Xero | Sales Invoices (filter by contact and date); Tax Summary for the period | Business > Invoices in Xero |
| QBO | Invoice List (by customer, by date); Sales Tax Liability | Sales > Invoices in QBO |
| Codat | Report name depends on the downstream provider | Check with the downstream provider's documentation |
If the provider report name varies for your deployment (for example, Codat-fronted providers with non-standard views), ask your accounting adviser for the equivalent report.
Match key
Match Zenoti invoices to provider invoices on the Zenoti invoice number. Zenoti writes the invoice number into the reference field in both Xero and QBO on creation. Any Zenoti invoice that does not appear in the provider report within one sync cycle is a sync failure β check the variance report first, then the activity log.
Recommended cadence
- Daily: check the sync report for any SyncFailed or QueueFailed records from the previous 24 hours.
- Weekly: run the variance report and compare totals.
- Monthly at close: full reconciliation against the provider's period summary before the period is locked.
Tips
- Run a manual sync after making changes to data mapping to verify the new mapping is working correctly.
- For large historical backlogs, sync in small date ranges (for example, one week at a time) to stay within API rate limits.
- The Financial Lock setting at both organization and center level must be aligned to ensure records are picked up for sync. Mismatched lock dates are the most common cause of silent sync misses.
- Treat the provider's posted invoice as the authoritative record once sync has succeeded. Never manually edit synced invoices in the provider β changes made there don't flow back to Zenoti.