Reconcile accounting reports
This guide explains how to cross-reconcile the three primary finance reports in Zenoti β the Accounting Report (also called Accounting Summary), the Sales-Accrual Report, and the Collections Report β to verify that your financial data is consistent across revenue recognition, accrual accounting, and cash collection perspectives.
Use this guide for month-end close, financial audits, or when you notice discrepancies between reports.
Before you begin
- You need access to the Accounting Report, Sales-Accrual Report, and Collections Report.
- Run all three reports for the same date range and the same set of centers.
- Export each report to Excel for side-by-side comparison.
Understanding the three reports
| Report | What it measures | Date basis | Key use |
|---|---|---|---|
| Accounting Report | Revenue summary by category (services, products, memberships, packages, gift cards) | Invoice close date | Month-end accounting entries |
| Sales-Accrual Report | Revenue recognized at the time of sale, regardless of when payment is collected | Sale date (accrual basis) | Accrual-based revenue recognition |
| Collections Report | Cash and payment actually collected | Collection/payment date | Cash flow tracking, bank reconciliation |
Step 1: Compare Accounting Report to Collections Report
The Accounting Report and Collections Report should align when viewed on the same date basis (invoice close date). Key reconciliation points:
- Total revenue (Accounting) should equal total collections (Collections) for fully paid invoices.
- Differences arise from:
- Open invoices β Revenue appears in Accounting but not in Collections until payment is collected.
- Advance payments β Collections may include advance payments not yet recognized as revenue.
- Refunds β Check that refunds are reflected in both reports for the same period.
Step 2: Compare Accounting Report to Sales-Accrual Report
The Sales-Accrual Report uses the sale date, while the Accounting Report uses the invoice close date. These dates are the same for most transactions but diverge when:
- Package redemptions β The Sales-Accrual Report shows the price at the time the package was sold (original sale price), while the Accounting Report shows the current price at the time of redemption. If prices have changed since the package was sold, these amounts differ.
- Membership credit redemptions β Similar to packages, the accrual value may differ from the current price.
- Multi-date invoices β Invoices closed on a different date than the sale date appear in different periods in each report.
Understanding the redemptions line in the Accounting Summary
The Accounting Summary report contains a redemptions line under the Center Redemption section. This line excludes gift cards used to pay tips β those tip-related gift card amounts appear instead under the miscellaneous detail section of the report.
This split is intentional and creates an apparent gap when you compare the Accounting Summary to the Membership Liability report or other liability reports. To reconcile the two reports correctly, add the redemptions line to the miscellaneous detail amount that represents gift-card-funded tips. The combined total equals the redemption total shown in the liability report exactly.
Important: If you compare the Accounting Summary redemptions line directly to the liability report redemption total without adding the miscellaneous gift-card-tip detail, the difference will appear to be missing data. It is not β the amounts are split across two lines in the Accounting Summary by design.
Step 3: Compare Collections to Sales-Accrual
This comparison highlights timing differences:
- Same-day transactions β For invoices paid immediately, both reports agree.
- Scheduled payments β Package or membership scheduled payments appear in Collections when collected but in Sales-Accrual on the original sale date.
- Payment failures and retries β Failed payments appear in Sales-Accrual (accrued) but not in Collections until successfully collected.
Step 4: Interpret a zero balance on the Membership Liability report
The Membership Liability report can legitimately show zero for a given period. Before escalating a zero balance as a data issue, verify whether any of the following conditions apply:
- No memberships sold or redeemed in the period β If no membership invoices were closed and no credits were consumed during the selected date range, a zero balance is correct.
- All memberships are fully consumed β If every active membership has been fully redeemed with no remaining credit balance, the outstanding liability is zero.
- Date range does not include active membership activity β A future date range or a historical range before your organization began selling memberships produces a zero.
- Center filter excludes the relevant center β If memberships were sold at a different center than the one selected in the filter, the report shows zero for the filtered center.
- Memberships with only discounts or only service benefits β Memberships that carry no credit-amount balance do not contribute to the liability total. A portfolio consisting entirely of discount-only or service-benefit-only memberships can produce a zero credit-liability balance even when memberships are active.
If none of the above conditions apply and you expect a non-zero balance, contact Zenoti Support with the exported report and the date range used.
Step 5: Reconcile membership totals between the Accounting Summary and the Membership Liability report
The Accounting Summary and the Membership Liability report can show different membership totals for the same dates and the same centers. This is a difference in the period each report counts a membership in β not missing data.
Important: This explanation applies only when Liability Type is set to Value on the Membership Liability report. With Liability Type set to Sale, both reports use the sale invoice, so the difference described here does not arise.
Compare the two reports as follows:
- Run both reports for the same date range and the same centers.
- On the Membership Liability report, check which option is selected for Liability Type.
- If Liability Type is Sale, the two reports use the same basis β the sale invoice. Any remaining difference is not a sale-date versus accrual-date difference, so continue with the other steps in this guide.
- If Liability Type is Value, apply the period rules below.
With Liability Type set to Value, each report counts a membership in a different period:
- The Accounting Summary counts a membership in the period of its sale invoice.
- The Membership Liability report counts membership value in the period in which the benefits accrue to the membership.
Where a membership's benefits accrue after its sale date, that membership appears in the Accounting Summary in the sale period and in the Membership Liability report in the later period in which its benefits accrue. The same membership is therefore counted in two different periods across the two reports, and the totals for a single period do not match.
To find the remaining amount, run the Membership Liability report for the following period or periods. The value that is missing from the current period appears in the period in which the benefits accrue.
Note: Both the Accounting Summary and the Membership Liability report are period reports. Each one covers the date range you select rather than a balance as of a single date, so widening or shifting the date range changes which memberships are counted.
Common reconciliation issues
| Issue | Cause | Resolution |
|---|---|---|
| Sales-Accrual shows $0 for redeemed services | Package was sold at a different price than the current service price; accrual uses original sale price | Expected behavior β compare against the package sale price, not the current service price |
| Accounting total exceeds Collections total | Open invoices with unpaid balances | Run the Open Invoices report to identify unpaid amounts |
| Collections total exceeds Accounting total | Advance payments or deposits collected but not yet recognized | Check for advance payment invoices in the Collections report |
| Numbers match for individual centers but not at org level | Cross-center transactions (redemptions at a different center than the sale) | Filter by sale center vs. redemption center to isolate cross-center activity |
| Accounting Summary redemptions line does not match liability report redemption total | Gift cards used to pay tips are excluded from the redemptions line and appear in miscellaneous detail instead | Add the miscellaneous gift-card-tip detail to the redemptions line β the sum equals the liability report total |
| Membership Liability report shows zero | No membership activity in the period, all credits consumed, date range or center filter mismatch, or memberships carry only discounts or service benefits with no credit balance | Verify each condition listed in Step 4 before escalating |
| Accounting Summary membership total does not match the Membership Liability report for the same dates and centers | With Liability Type set to Value, the Accounting Summary counts a membership in its sale period while the Membership Liability report counts it in the period the benefits accrue | Run the Membership Liability report for the following period or periods to find the remaining amount. With Liability Type set to Sale, both reports use the sale invoice and this difference does not occur |
Tips
- Always use the same date range, center selection, and filters across all three reports.
- Export to Excel and use VLOOKUP or pivot tables for large data sets.
- For package and membership reconciliation, use the dedicated Package Liability and Membership Liability reports alongside these three reports.
- When the Accounting Summary redemptions line and the liability report redemption total do not match, check the miscellaneous detail section for gift-card-funded tip amounts before assuming a data error.
- When membership totals differ between the Accounting Summary and the Membership Liability report, check the Liability Type filter first. The sale-period versus accrual-period difference applies to Liability Type = Value only.
- Because both reports cover a period rather than a single date, run the Membership Liability report for consecutive periods when you are tracing a membership amount that appears in one report but not the other.
- If a discrepancy persists after checking the above, contact Zenoti Support with the exported reports for investigation.