Skip to main content

How much sales tax did I collect? Using the Sales Tax report

Find the sales tax figure for your filing in EasyTruckShop: Reports > Sales Tax, choose Cash or Accrual, and export the file that also shows your taxable sales.

Written by Vladimir

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.

  1. Click your profile icon — your initials in the circle at the top right of the screen.

  2. Choose Reports from the menu. The menu also holds Settings, TimeSheets, and My Profile.

  3. 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 EasyTruckShop profile icon menu open at the top right, with Reports listed beside Settings, TimeSheets and My Profile.

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.

The EasyTruckShop Sales Tax report with the Basis filter set to Cash, a single tax rate row showing the tax collected, and 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.

The Basis menu open on the EasyTruckShop Sales Tax report showing the Cash and Accrual options.

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.

Did this answer your question?