Accounting variance report
You can use the accounting variance report to compare the existing data in your system with the posted data in the accounting application, providing insights into any discrepancies. For example, if the data in the Sales Accrual report does not match the posted data, then you can use the accounting variance report to identify those discrepancies and fix them accordingly. You can view the report based on your preference using the provided filters. For example, you can view the posted items data and the current items data, by selecting Invoices as Report Type and Items as the Sub-report Type.
At the organization or center level, click the Reports icon.
On the Reports page, search for and select the Accounting Variance Report.
If the report has many columns, scroll horizontally to the right or left to view all columns.
To view specific data on the report, select the desired filters. For more information, refer to report features on Zenoti.
Click Refresh.
If you generate the report for over a year, click the Email button.
Below are the columns featured in the report, with their corresponding descriptions:
Column | Description |
Summary Invoice Number | Summary invoice number of the posted data. You can click the hyperlink to view the details of the posted data. If the summary invoice number column is empty for a record, it means that the corresponding data has not yet been posted. |
Summary Status | Status of the summary invoice number. |
Date | Date on which the request for summary invoice number is processed. |
Current Date | Current date of the Zenoti invoice. |
Created date | Date on which the transaction was made. This appears only in the Miscellaneous journal entry sub-report. |
Journal type | Type of journal transaction such as cash pay in, cash payout, or tips. |
Item Type | Type of item such as products or services. Helps classify the source of variance. |
Item Code | Unique code of the item as configured in Zenoti. |
Item Name | Display name of the item. |
Item Category | The category under which the item falls. |
Payment method status | Displays whether the payment method used in the current system aligns with what was posted to accounting. |
Posted Payment Date | Date when the payment was posted to the accounting application. |
Current Payment Date | Actual transaction date of payment in Zenoti. |
Posted Payment Method | Payment method posted to the accounting application. |
Current Payment Method | Actual payment method recorded in Zenoti. |
Mapped To | Account to which the data is mapped. This appears only in the Payments sub-report. |
Posted amount | Amount posted to the accounting application. |
Current amount | Actual amount reflecting in the Zenoti invoice. |
Amount Variance | Difference between the posted payment amount and the current payment amount. Amount variance = Current amount - Posted amount This appears only in the Payments sub-report. |
Price Variance | Difference between the posted price for an item and the current price. Price variance = Current price - Posted price This appears only in the Items sub-report. |
Posted Price | Price posted to the accounting application. |
Current Price | Current price reflecting in the Zenoti invoice. |
Credit Amount Variance | Credit amount variance is the difference between what was expected to be credited and what was actually credited. Credit Amount Variance = Current credit amount - Posted credit amount This appears only in the Miscellaneous journal entry sub-report. |
Debit Amount Variance | Debit amount variance is the difference between the expected debit amount and the actual debit amount recorded in financial transactions. Debit Amount Variance = Current debit amount - Posted debit amount This appears only in the Miscellaneous journal entry sub-report. |
Tax Variance | Difference between the posted tax amount and the current tax amount. Tax = Current tax - Posted tax This appears only in the Items sub-report. |
Posted Tax | Tax posted to the accounting application. |
Current Tax | Tax reflecting in the Zenoti invoice. |
Posted quantity | Quantity posted to the accounting application. |
Current quantity | Quantity reflected in Zenoti. |
Quantity variance | Difference between the posted quantity and current quantity. Quantity variance = Current quantity - Posted quantity This appears only in the Items sub-report. |