Discrepancies Between Tax Amounts in Tax and Z Reports

Discrepancies Between Tax Amounts in Tax and Z Reports

Sometimes you can see different tax amounts in your Tax and Z/X report or Product Mix report for a certain period of time. 
This is an expected system behavior. Tax calculation rule in Z report is the following: if there was a refunded transaction of previous batch, Z report deducts tax amount of returned transaction form current batch instead of original one.
At the same time, Tax report for a particular day doesn't include refunded transactions for previous days.

For example:
During current shift 2 items were sold using current register, and tax collected was $3. Tax report will show this $3 amount, the same as Product Mix Report.
During the same shift, 2 items for a previous day were refunded, and then current POS register was closed. Tax report and Product Mix report will be the same, they will show the amount of $3, but Z report will be different in terms of tax amount, as it includes refunded tax (-$2).
So tax amount in Z report is equal to actual tax amount minus refunded tax: $3 - $2 = $1.


At the same time Tax report for the day the refunded transactions were run will show the actual tax amount: [actual tax] = [tax collected] - [tax refunded].

When paying taxes, please run Tax reports as they contain the most precise information.

    • Related Articles

    • Z Report

      Overview In the Z Report, you can view data on all of the transactions completed during specific shifts on each register of a store or stores. A shift represents the time a register was opened to the time it was closed. In the Z Report, you can: ...

    • Tax Report

      Overview In the Tax Report, you can view information on all orders where a tax was added. Instructions To access, go to Reporting--->Tax Report in the left navigation menu. You can customize which columns you would like displayed in the report by ...

    • Product Mix Report

      Overview In the Product Mix Report, you can view data about each product sold in a selected time period. Instructions To access, go to Reporting--->Product Mix Report in the left navigation menu. You can customize which columns you would like ...

    • Exporting Reports

      Overview The reports in eHopper that can be exported to a .CSV file are: Tips Report Z Report Product Mix Report; Ingredients Report; Modifiers Report Tax Report; Merchant Fee and Cash Discount Report Time Clock Report Transactions Report Inventory ...

    • Adding Taxes with Tax Agencies and Tax Manager

      Overview To add a tax, you will first need to add a Tax Agency and then create the tax in the Tax Manager.  To apply a tax to a store, you will need to add the tax to the Taxes tab in the store's Store Settings page. To apply a tax to a product, you ...