Skip to main content

Sales Reports: Tax Rate Analysis

  • Updated

The Tax Rate Analysis report presents a comprehensive breakdown of sales totals per tax rate, meticulously organised by product group or price level when relevant.

This invaluable report serves as a strategic tool for ensuring the accurate setup of tax rates at the point of sale, offering a crucial resource for meticulous validation and precise financial oversight.

For companies with multiple sites, this can be split per site or can be consolidated for all sites.

If required, this report can be created as a Saved Report and set up to send out periodically. 

Note that due to rounding, you may notice small variations in the tax rate shown. Click Here for more details.  

 

Report Filters

Access the Tax Rate Analysis report via: Reports & Analysis > Sales > Tax Rate Analysis.

Select the required report parameter options from:

Select Sites

Select which sites and/or site groups to include in the report.
Date Range

Select which date range to include sales for.
View Type

Select whether to view the report as:

  • Consolidated: To combine multiple sites into one consolidated output.
  • Split By Site: To produce a separate output per site, if multiple sites are selected.
Analysis Style

Select whether to view the report as:

  • Consolidated: To view sales by tax rate.
  • By Price Level: To view sales by tax rate, by price level.
  • By Product Group: To view sales by tax rate, by product group.
Show Detailed

Select this if you wish to run the report in expanded format, displaying product sales per tax rate. If not selected, summary level data is shown, but you can expand into detail where required.

 

Report Output

The Tax Summary report has two levels: 

 

Level 1 - Total Sales By Tax Rate

The first level of the tax rate analysis report provides sales information per tax rate. 

The data is split into different sections, as per the selected Analysis Style, displaying: 

Tax Rate

The tax rate being reported on.
Gross Sales

Displays the total gross sale value. (Excludes discount.)
Net Sales

Displays the total net sale value. (Excludes discount and tax.)
Sales Tax

Displays the total tax value.

 

Level 2 - Product Sales By Tax Rate

The second level of the Tax Rate Analysis provides a summary of products sold that make up the sales against the selected row, displaying:

Product Name

Displays the name and PLU of the product sold on this tax rate.
Gross Sales

Displays the total gross sale value. (Excludes discount.)
Net Sales

Displays the total net sale value. (Excludes discount and tax.)
Sales Tax

Displays the total tax value.
Quantity

Displays the number of times the product has been sold at that tax rate.

Related articles