This feature is only available for ShopKeep merchants on select pricing packages.

Sales by Tax Rate Report

Use the Sales by Tax Rate report to see total taxable sales, non-taxable sales, an estimate of sales tax due, and a breakdown of estimated taxes by tax rate over any time period.

Table of Contents

Run the Report

From BackOffice, run the Sales by Tax Rate report for an overview of taxable sales, non-taxable sales, and estimated amount of tax due for a specific time period.

To learn how tax is calculated in ShopKeep, visit the Understanding Sales Tax in ShopKeep section below.

  1. Click 'Reports' and select 'Tax Rates'.

    Don’t see ‘Tax Rates’? Click ‘Tax Groups’ instead to access the same report.

    Click to Enlarge
  2. Click the Date icon to choose a preset or custom range, then click 'Retrieve'.
    Click to Enlarge

Read the Report

Learn to read the Sales by Tax Rate report to understand the impact taxes have on the business.

Important Tax Information: Taxes are estimated based on how you have set up your tax rates and tax groups in BackOffice. For official filings, always verify your current local rates, then manually calculate tax using net taxable and non-taxable revenues. Tax laws can change at any time and you should contact a professional to obtain specific tax advice for your business. To learn how tax is calculated in ShopKeep, visit the Understanding Sales Tax section below.

Summary Tiles

The summary tiles display an overview of sales and estimated sales tax due for the selected date range.

Estimated sales tax reflects the tax amounts charged and refunded at the register at the time that each transaction was performed.

Net Taxable Sales | Total pre-tax sales minus pre-tax returns for transactions where tax was charged.
Net Non-Taxable Sales | Total amount of untaxed sales minus total untaxed returns.
Estimated Sales Tax Due | Estimated tax amount collected based on Net Taxable Sales & related tax rates.
*Multiplying ‘Net Taxable Sales’ by a single tax rate may NOT equal ‘Estimated Sales Tax Due’ due to differences introduced by rounding and other factors. Visit this section below to learn how tax is calculated.

Table View

The table view provides details about individual tax rates over the selected date range.

Estimated sales tax reflects the tax amounts charged and refunded at the register at the time that each transaction was performed.

Click to Enlarge

Tax Rate | Name of the tax rate as it is currently entered in BackOffice. Tax rates for ShopKeep eCommerce orders processed at the register and supported orders marked ‘Paid’ in the eCommerce Dashboard will appear in reporting as tax rates starting with the word ‘Online’.
Percentage | Percentage of the tax rate as it is currently entered in BackOffice.
Taxable Amount | Amount of Net Taxable Sales from items charged this tax rate.
Estimated Sales Tax Due | Estimated amount of tax collected for the tax rate.
*Multiplying ‘Taxable Amount’ by a single tax rate may NOT equal ‘Estimated Tax Due’ due to differences introduced by rounding and other factors. Visit this section below to learn how tax is calculated.

  1. Click any header with arrows to sort the table ascending/descending.
    Click to Enlarge

Filter the Report

Filter the report by tax rate to hide rates you don’t want to see or to display only specific ones. Filter by column to customize which table columns appear on the report.

  1. Click 'Filter'.
    Click to Enlarge
  2. To hide a tax rate, uncheck the box.

    To show the tax rate again, re-check the box.
    Tax rate filters apply to the Table View and Print View.

    Click to Enlarge
  3. To hide a table column, click 'Show/Hide Columns' and uncheck each box.

    To show the column again, re-check the box.
    Column filters apply to the Table View and Print View.

    Click to Enlarge

Export the Report

Download a copy of the Sales by Tax Rate report to analyze and filter its data using spreadsheet software.

  1. On the Table View, click 'Export'.
    Click to Enlarge
  2. Wait for the export to be generated. Check the box to be notified by email when exports are ready for download (optional).

    Exports ready in a few seconds will automatically download. Click ‘Close’ to close the message box.

    Click to Enlarge

    Exports taking more than a few seconds to generate are downloadable via the Export Center when ready. Click ‘OK’ to close the message box.

    Click to Enlarge
  3. After downloading, the export is ready to open in any spreadsheet software.
    Click to Enlarge

Use the Print feature to generate the report in a printer-friendly format that can be printed or saved.

  1. Click 'Print'.
    Click to Enlarge
  2. Wait for the report to open in a new browser tab.
    Click to Enlarge
  3. Click 'File' on the web browser’s menu and select 'Print'.

    Or save the print view as a PDF for easy sharing.

    Click to Enlarge

Understanding Sales Tax in ShopKeep

Review the basics of sales tax and how it impacts a business. Learn how sales tax is calculated in ShopKeep and why it is calculated that way.

IMPORTANT: Sales tax on this report is an estimate based on how you have configured the business’s tax rates and tax groups in BackOffice. For official filings, always verify current local rates, then manually calculate tax using net taxable and non-taxable revenues. Be aware that tax laws can change at any time and you should contact a tax professional for specific tax advice regarding your business.

Sales Tax in ShopKeep
Tax figures in reporting are estimates based on how you have set up the tax rates, tax groups, and their assignments in your ShopKeep account. Tax laws can change at any time, so it is important to verify local rates and manually calculate tax due before making any official filings. We recommend contacting a tax professional for specific tax advice regarding your business.

How Tax is Calculated
Sales tax is currently calculated at the item-level using the tax rates and tax groups you have configured in BackOffice. At the register, the relevant tax rate is applied individually to each item and rounded to the nearest penny. If an item is assigned to a tax group containing multiple tax rates, each rate in the group is applied separately to the item price and rounded, then the totals for each rate are summed.

Calculation Examples
Consider the examples below of a sale with two items, each priced at $5.50 and charged a single 9% tax rate.

  • Item-Level Tax (Current Calculation Method)
  • Item 1: $5.50, 9% tax
  • Tax on item = $5.50 x 0.09 = $0.495
  • Item’s tax is rounded to $0.50
  • Item 2: $5.50, 9% tax
  • Tax on item = $5.50 x 0.09 = $0.495
  • Item’s tax is rounded to $0.50
  • Total tax collected on sale = $1.00
  • Transaction-Level Tax
  • Item 1: $5.50, 9% tax
  • Item 2: $5.50, 9% tax
  • Subtotal of tax rate = $5.50 + $5.50 = $11.00
  • Subtotal’s tax = $11.00 x 0.09 = $0.99
  • Total tax collected on sale = $0.99
  • Item-Level vs. Transaction-Level Tax
    Item-level tax makes it possible to return individual items, calculate taxable and non-taxable sales by tax rate, and develop certain reporting features.

    In the example above, sales tax would be $0.99 if calculated at the transaction-level. If one item was returned, how much tax would need to be refunded: $0.49 or $0.50? Which item gets the extra penny? With transaction-level tax, there can be many “extra pennies” randomly assigned to items. When each sold item’s tax is summed, you may end up with a different total than what was actually collected at the register.