Store Item Tax Report

The Store Item Tax Report displays a report of total sales on items. This report is located under the Store (menu) > Store Reports > Store Item Tax.

  • Evaluate net sales for a selected time period.
  • Report on sales tax for a given month.
  • Analyze discounts given on merchandise.

Save this as a frequently used report! Click the heart (icon)next to a report name, the heart will change to redand the report will be listed under the Reports (menu) > My Reports for quick and easy access!

Business Scenario

Your accountant would like to know how much sales tax you collected for the previous month (e.g., September 2020). Run the Store Item Tax Report using the Date Paid From as 9/1/20 and Through as 9/30/20. Export the report to Excel and save. You can then email your accountant with the report attached.

Search Criteria

Use the Search Criteria to narrow the report results:

  • If you have multiple locations in your database, you have the option to look at items based on the location of where the item was sold using the Location drop-down.
  • Choose additional information you would like to filter the results by such as Vendor, Category 1, Transaction Date, etc.

Report Results

  • The Show/Hide Columns button allows you to customize your report by selecting which information to display. 
    • Select Apply to have these selections applied to only the report you are currently viewing. 
    • Select Apply & Save to have these selections applied and saved to your User ID. When logged in as your User ID, you will see only the columns of information you chose previously. Other Users will see the columns they selected and saved, which may differ from yours.
  • Use Restore Columns to view all available columns.
The Sales Tax comes from the actual tax from each transaction. If the tax was edited in a transaction, it is possible it may not calculate to be the same as the default tax rate multiplied by the total item price.