Tax Report

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 selecting the Set Columns drop-down field and then selecting the checkbox next to each column you would like to include. 
  • The columns in the Tax Report include:
    • Tax Name: the name of the tax
    • Tax Rate: the rate that the tax is applied from the total amount
    • Taxable Amount: Total Sales – Non-Taxable Amount – Tax Collected – Refunds
    • Tax Collected: the total monetary amount of the tax collected
    • Tax Agency: the Tax Agency that manages the tax

 

  • You can filter taxes by Store(s) or Tax Agency in the corresponding drop-down menus after selecting the Search button.


 

  • You can filter by date by selecting one of the options in the date range drop-down menu. The default will say Today.
    • Only up to 3 months can be filtered at a time. To filter by a customized date range within a 3 month period, select the Custom Range option and then the dates you would like to filter for in the calendars that appear. If you would like to view data for more than 3 months, export the report after choosing a custom range and then select a new custom range, export it, and combine the data from the exported reports.


Note: If item was sold yesterday and refunded today, the updated data will only appear when the current day is included in the filter. If Yesterday is selected, it will still be counted as a sale for that day. If both days are included in filter, the tax data will be updated to include the refund. 

 

  • On the top of the screen, you can view:
    • Total Sales:  Taxable Amount + Non-Taxable Amount + Tax Collected + Refunds
    • Non-Taxable Amount: Total Sales - Taxable Amount - Tax Collected - Refunds
  • Sort by individual columns by clicking on the triangle to the right of the column you want to sort.
  • Export the Tax Report by clicking the Export button and then click on the download to open it.



    • Related Articles

    • Exporting Reports

      Overview The reports in eHopper that can be exported to a .CSV file are: Tips Report Z Report Product Mix Report Tax Report Time Clock Report Transactions Report Inventory Report Orders Report Instructions To export, click on the Export button on the ...

    • 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 ...

    • Modifiers Report

      Overview You can view info on all modifiers sold with products in the Modifiers Report. Instructions To access, go to Reporting--->Modifiers Report in the left navigation menu. You can customize which columns you would like displayed in the report by ...

    • Transactions Report

      Overview This report contains information on all payments processed (including voided and refunded) during a selected time period. Transactions can also be filtered by customer, employee, store, register, and dollar amount. To view the report, you ...

    • 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 ...