Tax Reports — What Goes Where on Your State Filing

Using Suprata's tax reports to file sales-tax returns. Which numbers map to which boxes, the difference between accrual and cash bases, and the audit trail you should keep.

Updated 15 hours ago 3 views compliance taxes reports remittance

Tax Reports — What Goes Where on Your State Filing

Sales tax is one of those things that looks easy until you actually file your first return and realize the form has eight boxes and you only know what two of them mean. Suprata's tax reports give you the numbers; this article is about getting those numbers into the right boxes on your state's form, and surviving an audit if you ever face one.

The most important thing to understand first: the tax money you collect is not your money. It's a liability you hold for the state until your filing date. Treat it that way mentally and operationally — don't spend it.

When you'd use this

  • Monthly, quarterly, or annually, depending on your state's filing schedule for your business size.
  • Before any sales-tax remittance — pull the report for the period, reconcile, file.
  • During an audit, when you're producing evidence of what you collected and from whom.
  • When setting up a new tax category, to verify it's reporting under the right tax type.
  • Before changing tax rates, to take a snapshot of pre-change behavior.

If you operate in multiple states or jurisdictions, you'll run multiple reports — one per filing entity — and be careful not to mix them.

What the tax reports show

There are a few related views in the reports area, each answering a different question:

  • Tax collected by period — for a date range, how much sales tax did you collect, broken down by tax category and rate? This is your headline filing number.
  • Tax collected by jurisdiction — for states with multi-jurisdiction filing (state + county + city), the breakdown by jurisdiction.
  • Taxable vs. non-taxable sales — the denominator and numerator for your effective tax rate. Most state forms ask for both gross sales and taxable sales separately.
  • Tax-exempt transactions — invoices marked tax-exempt, with the reason. Keep this. Auditors ask.

Tax report showing sales by tax category for a filing period

Pulling the right report comes down to knowing what your state's form asks for. Read your state's filing instructions once carefully; the boxes you need to fill are the same boxes every filing period.

Mapping report numbers to a typical state return

Most state sales-tax returns ask for some version of these numbers. Yours may differ — read your form — but this is the common pattern:

  1. Gross sales (total sales for the period, taxable + non-taxable). Use the sales column from the Billing & Sales Report for the same period.
  2. Non-taxable sales (sales that fell into a non-taxable category — out-of-state shipments, exempt customers, certain service categories). Pull from the taxable-vs-non-taxable view.
  3. Taxable sales = (1) − (2). Most state forms compute this for you, but check it.
  4. Tax due = taxable sales × rate, broken down by jurisdiction if applicable.
  5. Tax collected — what your reports show. This should match (4) closely. If it doesn't, something is configured wrong; investigate before filing.
  6. Vendor's compensation / collection allowance — many states give you a small percentage of the tax you remit as compensation for collecting it. Apply if eligible.
  7. Penalty / interest — only if you're late.
  8. Net amount due — what you write the check for.

If your tax collected (5) is meaningfully different from what (4) says it should be, you have a setup problem in your tax categories or your tax tables. Don't file until you understand why. Filing wrong is worse than filing late.

Accrual versus cash basis

Most states require sales-tax remittance on an accrual basis — you owe tax on what you invoiced in the period, regardless of whether the customer has paid. A few states allow cash basis (you owe on what you collected). Read your state's rules.

This matters because the Billing & Sales Report can be filtered by invoice date or by payment date. For tax filing on accrual basis, always filter by invoice date. The numbers you get from a payment-date filter are not the right ones for accrual filing.

A common error: filing accrual-basis returns with cash-basis report data. The numbers will be smaller — you might even get a refund — but it's wrong, and it surfaces during an audit. Don't take the easy money.

Tax-exempt transactions and the audit trail

Every tax-exempt sale needs a defensible reason. Common categories:

  • Resale exemption — the customer is reselling and has provided a resale certificate. Keep the certificate on file.
  • Government exemption — sales to federal/state/municipal entities. Keep the exempt purchase order.
  • Non-profit exemption — qualifying 501(c)(3) organizations with valid exemption certificates.
  • Out-of-state shipment — goods shipped to a state where you don't have nexus. Keep shipping records.
  • Service exemption — pure-service sales in states that don't tax services.

For each exemption, attach the supporting document to the customer's account. When an auditor asks "why didn't you collect tax on this $4,800 sale?", you produce the certificate, and the conversation ends. If you can't produce it, you owe the tax — plus penalty.

A monthly close routine that makes filing painless

Done in this order, the monthly tax close takes 20 minutes:

  1. Run the Billing & Sales Report for the month, filtered by invoice date.
  2. Run the tax report for the same period.
  3. Reconcile: gross sales on (1) should match gross sales on (2). If not, find the difference before filing.
  4. Identify any tax-exempt transactions and verify each has a documented reason on the account.
  5. Compute the amount due using your state's form.
  6. File and remit.
  7. Save a PDF of both reports, the form you submitted, and the remittance confirmation in your records folder. Date the folder by filing period.

That archive is your audit defense. Keep it for the period your state requires (commonly 3–6 years, sometimes longer).

Common mistakes

  • Filing on payment-date basis when the state requires accrual. Always check your state's rules first. Most states are accrual.
  • Not capturing tax-exemption certificates. A sale you marked exempt without a certificate is, on audit, a sale you owed tax on. The state will assess the tax, plus penalty, plus interest. Capture the paperwork at the time of sale.
  • Mixing jurisdictions. If you sell into multiple counties or cities with different rates, your tax categories must distinguish them, or your filing will under- or over-collect. Set the tax tables up correctly before you have many invoices to fix.
  • Spending the tax money. It's not yours. Move tax collected to a separate account or earmark it in your books. Companies that fail to remit usually didn't decide not to pay — they spent the money on operations and didn't have it when filing day arrived.
  • Not reconciling reports against the Billing & Sales Report. They should agree on gross sales for the same period. If they don't, your tax setup has a leak. Find it before the auditor does.
  • Treating one report as authoritative. Cross-check tax reports against the revenue report and against your bank deposits. Three numbers that all agree are trustworthy. One number alone is a guess.

Related articles