What the Sales Tax report tells you
The Sales Tax report in EasyTruckShop gives you the sales tax figure for a period, broken out by tax rate. This is the number you use when you file a sales tax return.
The report has one row per tax rate you have set up, showing the rate name, the percentage, and the tax amount. The exported file adds a fourth piece your tax return usually asks for: the taxable sales the tax was calculated on.
Where the Sales Tax report is
Reports is not in the top menu bar. It lives under your profile icon, which is the most common reason people cannot find it.
Click your profile icon — your initials in the circle at the top right of the screen.
Choose Reports from the menu. The menu also holds Settings, TimeSheets, and My Profile.
Click the Sales Tax tab. It sits between Fees and Part Revenue.
In the screenshot below: 1 is the profile icon at the top right, and 2 is Reports in the menu that opens.
The image below shows the Sales Tax tab: 1 is the Basis filter, 2 is the tax rate row with the amount, and 3 is the Export button.
What permission you need
You need permission to view Reports. If Reports does not appear in your profile icon menu, ask your shop owner or administrator to grant it.
Cash or Accrual — pick the one your state asks for
This is the most important setting on the Sales Tax report, and it changes the number substantially.
Cash — tax counted when the customer's payment came in. This is what most shops on cash-basis reporting file.
Accrual — tax counted when you invoiced the job, paid or not.
The Sales Tax report opens on Cash. Note that this is the opposite default from the Fees report, which opens on Accrual — so always look at the Basis button before you copy a number.
Here is the same month in one shop on both settings:
Basis | Tax figure for the month |
Cash (tax on payments received) | $708.89 |
Accrual (tax on invoices issued) | $499.25 |
Cash is higher in this example because payments received during the month included tax on invoices that were issued in earlier months. Neither figure is wrong — they answer different questions. Your state or province tells you which basis to file on; if you are not sure, ask your bookkeeper before filing.
To change it: click Basis in the filter row and choose Cash or Accrual. In the screenshot below: 1 is the Basis menu open showing Cash and Accrual.
Why the column says "Tax Collected" even on Accrual
The column heading on the Sales Tax report reads TAX COLLECTED in both modes. On Accrual that label is misleading — the figure is tax you have billed, including tax on invoices nobody has paid yet. Read the Basis button, not the column heading, to know which one you are looking at.
Setting the period for your filing
Click the date button on the far left. It opens on This Month. Choose the month, quarter, or year your return covers. Most shops filing quarterly set a custom range covering the three months of the quarter.
Exporting the Sales Tax report
Click Export at the top right. EasyTruckShop downloads a spreadsheet whose name states the basis you used — for example Sales Tax Report (Cash).xlsx. That name is useful: it is your record of which basis the figure came from.
The file contains these four columns:
Name — the tax rate's name
Rate — the percentage
Taxable — the sales amount the tax was calculated on
Tax Collected — the tax amount
The Taxable column is only in the file. The on-screen report does not show it. Most sales tax returns ask for gross sales, non-taxable sales, and taxable sales before the tax figure, so export the file rather than reading the screen when you are actually filing.
I have more than one location
The Shop filter defaults to the shop you are currently working in, not all of them. If your locations file separate returns, run the report once per shop. If they file together, set the Shop filter to include both before you export.
What the Sales Tax report does not do
It does not file anything. It produces the figures; you or your bookkeeper still file the return.
It does not show invoice-level tax. For tax per invoice, use Reports > Sales > Export > Invoice List, which has Tax Rate and Tax columns on every invoice row.
It does not show which customers were tax exempt. Exempt customers simply do not appear in the taxable amount. To check an individual customer's tax setting, open the customer record.
It does not break tax out by state or jurisdiction beyond the tax rates you have set up. If you need city and state split separately, they need to be separate rates in your settings.
It does not include use tax on parts you bought. That is a purchasing question — see the Orders report for vendor spend.
Accounting words and what they are called in EasyTruckShop
What your accountant says | What EasyTruckShop calls it |
Sales tax payable / tax liability | Tax Collected on the Sales Tax report (Cash basis) |
Taxable sales | The Taxable column — in the exported file only |
Gross sales | Net Sales on the Sales report (which excludes tax) |
Exempt sales | Not reported separately — it is net sales minus Taxable |
Tax jurisdiction / rate table | Your tax rates, one row each on this report |
Cash basis filing | Basis > Cash |
Accrual basis filing | Basis > Accrual |
Other ways shops ask this question
"How much tax do I owe the state?" — profile icon > Reports > Sales Tax, set the period, set Basis to what your state requires, read TAX COLLECTED.
"I need my quarterly sales tax numbers" — same report, set a custom date range for the quarter, then Export for the Taxable column.
"What were my taxable sales?" — that figure is in the exported file, not on screen.
"My tax number changed and I didn't change anything" — check the Basis button; a new payment on an old invoice moves the Cash figure.
"Where's my tax report for last year?" — same report, set the date range to that year.
Working with the exported file
The Sales Tax export is a short file — usually one row per rate. If you want to reconcile it against your invoices, export Reports > Sales > Export > Invoice List for the same period and basis, then total its Tax column. You can also upload both files to ChatGPT or another AI assistant and ask it to compare the totals and list any invoice where the tax does not match the rate.
If the tax figure looks wrong
Higher or lower than you expected — check the Basis button first. That is the cause most of the time.
A customer's tax is missing — check whether that customer is marked tax exempt on their customer record.
Tax on labor looks off — labor is taxed only if the labor line's tax box is ticked on the invoice. Open the invoice and check the line.
The total does not match another location — check the Shop filter.
Still off — export both the Sales Tax file and the Sales Invoice List for the same period and basis, and send both to support with the date range you used.



