This article will show you how to view your sales tax using the Cash Report
Under the Financial reports select Sales Report
Choose Cash Basis
Select a preset date range or custom dates from the date dropdown
The top of the report displays tax totals
You can also export the report
Choose Export report
Import the report to a spreadsheet platform (Google Sheets or Excel)
Once your report is imported, refer to the column titled Amount Taxed to review sales tax information
Apply a filter to the Amount Taxed column and filter out all $0.00 cells
β
βFilter your data using Google Sheets
1. On your computer, open a spreadsheet in Google Sheets
2. Select a range of cells
3. Click Data
4. Select create a filter
β
βFilter your data using Excel
1. Select any cells in a range or table you want to add filter
2. Click Data and choose Filter
3. After applying one of the above operations, you can see drop down arrows are added in the column headers of selected cells
Important: The Cash Report, the Sales Report, and the Transactions Export each use a different accounting basis. You do not want to compare these reports because you will get different values.