Tax Included & How to Back Out Sales Tax
Inventory items can be taxable or non-taxable, but not tax inclusive. This workaround allows you to include tax in pricing and figure out at a later time the total tax amount due.
IMPORTANT: If you follow this guide, tax will not show up on customer receipts or in BackOffice reporting because it will be included in the price of items. Be aware that tax laws can change at any time and you should contact a tax professional for specific tax advice regarding your business.
Table of Contents
Include Tax in Pricing
Because inventory items cannot be set as tax-inclusive, we recommend the following workaround to price items in this manner:
- Adjust the sales price and taxable status of items.
- Update each item’s price to include tax.
- Set these items to be non-taxable.
- Move each group of items taxed at a different rate into its own separate department.
Drinks taxed at 8.75% in a “DRINKS” department and food taxed at 7.75% in a “FOOD” department.
- Move all untaxed items into yet another department to keep them separate.
- On the business's receipt, add a line telling customers that tax is included in prices.
- Follow the steps below to back the tax out of each department's total sales.
Back Out Tax Amount
Follow these steps to back the sales tax amount out of the total sales for each department.
- Run the Sales by Department report.
- To get the pre-tax sales amount, divide each department's net sales by 1 plus that department's tax rate.
- Tax rate for the FOOD department: 7.75% or .0775
- Total FOOD net sales (including sales tax): $18,295
- Total pre-tax sales amount = $18,295 / 1.0775 = $16,979.12
- Total FOOD sales tax = $18,295 – $16,979.12 = $1,315.88