Tax & Banking · US / Canada

Sales tax — split by state,
county and local rate.

A filing-ready sales-tax report for US and Canadian sellers. Every transaction split by state, county, city, and special-district rate — with rollups by jurisdiction, locality, and combined rate.

Explore More Tools
No signup, ever 100% local · nothing uploaded 4-tier rate stack Esc to close
US+CA
30 jurisdictions
4-tier
State / county / city / district
By state
County · rate rollups
Free
Always · no signup

01 — What you create

Transactions in jurisdictional report out.

Each sale carries its state, county, and rate stack. The tool computes per-transaction tax then rolls up by state, county, and combined rate — ready for filing or accountant hand-off.

Sales Tax Form
6 txns · Q2 2026
Seller
Sonchoy Studio LLC · EIN 12-3456789
Period
Apr–Jun 2026 · Quarterly
Transactions
6 (across CA, TX, NY, FL, ON)
Gross sales
USD 112,800.00
Exempt
USD 6,500.00 (resale certs)
Taxable
USD 106,300.00
Rate stack
State + county + city + special
Total tax
USD 9,610.00
Total tax dueUSD 9,610.00
OUTPUT.PDF
Filing-ready

SALES TAX REPORT

Sales Tax Report — Q2 2026

Apr–Jun 2026 · Quarterly · Filing prep

GROSS

USD 112,800

EXEMPT

USD 6,500

TAXABLE

USD 106,300

TAX DUE

USD 8,789

BY STATE / PROVINCE

CODESTATETAXABLERATETAX
CACalifornia38,500~9.0%3,361
TXTexas16,0008.25%1,320
NYNew York29,5008.875%2,618
FLFlorida9,8007.0%686
ONOntario12,50013%1,625
TOTALS106,3009,610

+ county and rate rollups + per-transaction detail in the full PDF

Need more power?

When this tool isn't enough, pdfFiller takes over.

Scanned invoices, multi-page batches, multi-currency stacks, and direct push into your accounting system. Free for 30 days, no card required.

Try Premium Free

Free 30 days · no credit card · cancel anytime

02 — How it works

One report, every filing.

US sales tax is jurisdiction-stacked: state, county, city, and sometimes a transit or stadium district. Most accountants want the rollups by state for filing, by county for compliance, and by rate for the audit trail. This tool produces all three.

01

Drop in the sales

Per transaction: date, invoice number, jurisdiction, county, gross, exempt amount. Then the rate stack — state, county, city, special-district.

02

Auto-roll-up

The tool computes per-transaction tax, then rolls up three ways — by state, by county within state, and by combined rate. Every number ties back to the detail.

03

Export PDF + XLSX

PDF with summary cards, state rollup, county rollup, rate rollup, and per-transaction detail. XLSX has 5 sheets — Summary, Transactions, By State, By County, By Rate.

03 — Built for multi-state sellers

Every column the state portal asks for.

30 jurisdictions

20 US states (the most sales-tax-active) plus all 10 Canadian provinces. Each labelled with its tax system (HST, GST+PST, GST+QST, GST only).

4-tier rate stack

State, county, city, and special-district rates as separate columns. They sum to the combined rate that's actually charged to the buyer.

Exempt-amount column

Subtract resale-certificate sales, services, and other exempt amounts before computing tax. Keeps your taxable base clean for the return.

Three rollups

By state (the way you file), by county (the way you reconcile to local jurisdictions), by combined rate (the way you audit).

Quarterly / monthly / annual

Pick the filing frequency that matches your nexus and state of registration. The period label appears in the footer of every page.

PDF + 5-sheet XLSX

PDF: summary cards + state, county, and rate rollups + transaction detail. XLSX: Summary, Transactions, By State, By County, By Rate.

PdfFiller · 30-Day Free Trial

When one-off documents aren't enough.

Bulk OCR, batch invoicing, multi-party e-signing, redaction, audit logs — pdfFiller picks up where Sonchoy ends. Free for 30 days, no credit card.

Try Premium FreeNo card · Cancel anytime

Batch & bulk

Run 100+ invoices, statements, or conversions in one go.

OCR scanned PDFs

Turn paper invoices into searchable, exportable data.

E-sign & request

Multi-party signatures with full audit trails.

Redact & approve

Mask sensitive ledger lines before sending to auditors.

04 — Common questions

Everything about sales tax reports.

01How is this different from the GST or VAT tools?

GST (Indian) splits into CGST/SGST/IGST and operates within one country. VAT is typically a single rate per country. US/CA sales tax is jurisdiction-stacked — state + county + city + district — and varies street-by-street. This tool models that stack.

02Do I need separate reports for each state?

Yes — when filing. Each state has its own return, due date, and portal. Use this tool to model your full activity for the period, then filter by state in the XLSX (or print the state rollup page) for each filing.

03Where do I look up the right rates?

The tool doesn't hard-code rates — you enter them per transaction. Use Avalara, TaxJar, or your state's DOR website to look up rates by ZIP code or address. For sellers with serious volume, integrate a tax-engine API; this tool is for working out the numbers manually or auditing the API's output.

04What's a "special district" rate?

On top of state/county/city, some areas levy additional sales tax for transit (NYC MCTD 0.375%), stadiums, conventions, or tourism. They're bundled into the rate the buyer sees but reported separately to the state. This tool tracks them in their own column.

05Does this handle marketplace facilitator rules?

Not directly — marketplace facilitator sales (Amazon, eBay, Etsy collecting tax on your behalf) should be excluded from your direct sales totals. Add them as separate transactions with the exempt-amount column populated, or just leave them out of the report.

06Output formats?

PDF (summary cards + state/county/rate rollups + full transaction table with totals row + page footers) and XLSX (5 sheets: Summary, Transactions, By State, By County, By Rate). All numeric — ready for pivots, charts, or formulas.

05 — Related tools

Often used together.

Browse all 91 tools