What Is the USA Tax Collected Report?
The USA Tax Collected report brings US sales-tax collection details into one Shopify reporting view. It includes tax titles and amounts alongside state, city, county, and municipal tax fields, making it easier to review the different layers of tax recorded on sales.
Choose a reporting period to review tax amounts, taxable sales, non-taxable sales, and total sales together. The provided fields do not specify a fixed row grouping, so check the saved report layout before interpreting totals as one row per state, jurisdiction, or order.
Use this report to prepare organized figures for internal checks and accountant review. Collected tax is not automatically the same as tax legally owed or a ready-to-file state return.
Report Overview
- Report period
- choose the date range you need.
- Data included
- Tax 1–5 titles and amounts, jurisdiction tax amounts, sales tax, duties, taxable and non-taxable sales, and total sales.
- Best for
- reviewing US tax collections across state, city, county, and municipal layers.
- Export
- Excel, CSV, TXT, or PDF.
- Automation
- optional scheduled email delivery daily, weekly, or monthly.
What Can You Learn from US Tax Collection Data?
1. Compare levels of tax collected
State Tax Amount, City Tax Amount, County Tax Amount, and Municipal Tax Amount give separate views of tax assigned to different jurisdiction levels.
Example: For example, a report shows a larger state tax amount than its city tax amount.
What you can do: Review each tax layer separately when preparing an accountant handoff.
2. Review taxable versus non-taxable sales
Taxable Sales and Non-Taxable Sales help show the mix of sales recorded under each classification for the period.
Example: For example, a month includes both taxable and non-taxable sales.
What you can do: Investigate unexpected changes in the mix and check product tax settings where appropriate.
3. Inspect the tax components behind totals
Tax 1–5 titles and amounts let you examine named tax components rather than relying only on the overall Tax or Sales tax field.
Example: For example, a transaction includes two different tax-component titles.
What you can do: Identify what each component represents before aggregating or comparing totals.
4. Keep duties separate from sales tax
Duty Tax and Total Duties appear alongside sales-tax figures, so the report can support a clearer review of different charge types.
Example: For example, an export shows both Sales tax and Total Duties values.
What you can do: Present duties and sales tax as distinct categories unless your accounting rules require another treatment.
What Should You Check First in This Report?
Start with the figures most likely to affect the accuracy of your tax review:
- State, city, county, and municipal tax amounts: confirm which jurisdiction layers are represented.
- Taxable Sales and Non-Taxable Sales: look for unexpected shifts across the chosen period.
- Tax 1–5 titles and amounts: identify component labels and avoid double-counting alongside aggregate tax fields.
- Sales tax, Tax, Duty Tax, and Total Duties: confirm each definition before combining or sharing figures.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a US tax-collection review | Places named tax components, jurisdiction amounts, and sales measures in one report. |
| Checking city and county tax charges | Makes City Tax Amount and County Tax Amount easier to examine alongside their titles. |
| Reviewing taxable and non-taxable sales | Shows the two sales classifications for comparison within the selected period. |
| Investigating an unexpected tax total | Provides Tax 1–5 amounts and titles to support component-level checks. |
| Sharing period-end figures with an accountant | Creates a structured export with distinct sales-tax and duty fields. |
How to Create This Report in Data Export
Start from the premade USA Tax collected (Shopify) report rather than building all tax fields manually.
- Open Data Export and locate the premade “USA Tax collected (Shopify)” report.
- Open the report and review the state, city, county, municipal, and Tax 1–5 columns.
- Choose your reporting date range and add relevant filters or adjust columns if needed.
- Select Save, then review the results for the period you selected.
- Export to a supported file format or schedule email delivery for a daily, weekly, or monthly review.
Make the Most of This Report
Four practical ways to keep your tax review clear and consistent:
01 / PERIOD
Use consistent reporting dates: Compare matching periods when reviewing changes in collected tax.
02 / COMPONENTS
Check before totaling: Some tax component and jurisdiction fields may describe related amounts; avoid summing everything blindly.
03 / EXEMPT SALES
Review classifications: Look at Taxable Sales and Non-Taxable Sales side by side when checking unusual movements.
04 / SHARING
Share an auditable copy: Export the selected period and keep the date range and field definitions with your accountant handoff.
Frequently Asked Questions
Does this report show tax collected by state, city, and county?
It includes State Tax Amount, City Tax Amount, County Tax Amount, and Municipal Tax Amount, plus corresponding tax titles.
Can I compare taxable and non-taxable sales?
Yes. Taxable Sales and Non-Taxable Sales are both included, along with Total Sales.
Are tax components and jurisdiction amounts interchangeable?
Not necessarily. Tax 1–5 fields identify tax components, while the jurisdiction fields identify named tax layers. Check how your report calculates them before adding amounts together.
Can I export or schedule the report?
You can export Excel, CSV, TXT, and PDF files and schedule email delivery daily, weekly, or monthly.
Is this a ready-to-file sales tax return?
No. It is a tax-collection review report. Filing obligations, tax liability, exemptions, and adjustments should be checked with a qualified tax professional.