What Is the Shopify USA Tax collected (Shopify) Report?
The USA Tax collected (Shopify) report breaks the tax on your Shopify orders into the separate US jurisdiction layers that a sales tax return actually asks for: state, city, county, and municipal. Instead of one lump tax figure, each layer gets its own title and amount column, so you can see where the tax was generated and how each level adds up to the total.
This is the distinction most merchants miss. A single order can carry tax from several jurisdictions at once. A customer in one city may pay a state rate plus a county rate plus a local municipal rate on the same purchase, and this report keeps those pieces apart rather than merging them.
It also holds the generic Tax 1 through Tax 5 lines, duty fields, and a split of taxable versus non-taxable sales. Reach for this report when you file US returns by jurisdiction and need the tax already separated the way each authority expects it, rather than a flat total you have to unpack by hand.
Which Fields Are Included in the USA Tax collected (Shopify) Report?
These fields let you see each jurisdiction layer on its own, tie those layers back to the total tax, and separate the sales base that tax was calculated on
You can adjust the pre-made report by adding, removing, or reordering columns so it matches the jurisdictions and tax lines your store actually collects.
Important Insights You Can Find in This Report
Which jurisdiction layer is generating most of your collected tax?
Line up the State, City, County, and Municipal amount columns side by side. When one layer carries the bulk of your tax, that is the return you cannot afford to get wrong, and it tells you which jurisdictions to prioritize when you register or reconcile. A county or municipal figure that quietly grows over several periods can also signal that you now have meaningful activity in a jurisdiction you had not been tracking.
Do the named jurisdiction amounts fully account for the total in the Tax column?
Add up State, City, County, and Municipal amounts and compare that against the Tax total for the same orders. A gap usually means tax landed in the generic Tax 1 to Tax 5 lines instead, often a special district or a combined rate Shopify recorded separately. Finding that gap before filing is what stops a jurisdiction from being under-reported.
Is a shift in the taxable to non-taxable split explaining a change in tax collected?
If collected tax drops but Total Sales holds steady, compare Taxable Sales against Non-Taxable Sales. A rising non-taxable share can be legitimate, such as more exempt products or exempt customers, or it can point to items misconfigured as exempt. Either way, the split tells you whether lower tax reflects your catalog or a setup problem worth fixing.
THE ANALYST'S READ: The Signal Most Merchants Miss
The four named columns, State, City, County, and Municipal, look complete, but they will not always reconcile to the Tax total on their own. US orders frequently include a special tax district or a combined local rate that Shopify writes into the generic Tax 1 to Tax 5 lines rather than into one of the named layers. If you file using only the four named columns, that residual tax can go unreported.
Before you treat this report as filing-ready, check the named jurisdiction amounts and the Tax 1 to Tax 5 amounts together against the Tax total, and keep an eye on Duty Tax and Total Duties on any international orders that slipped into the period. Where the pieces do not add up, the missing value is almost always sitting in a Tax line you have not mapped to a jurisdiction yet. Resolve that mapping once and the report becomes something you file from directly rather than re-check every quarter.
How Can You Automate the USA Tax collected (Shopify) Report?
Open the pre-made USA Tax collected (Shopify) report in Report Pundit. The columns are already set, so you can save it as is, or rebuild it under Custom Reports by adding the fields above and setting your date range and filters. Once saved, schedule it to email automatically on a daily, weekly, or monthly cycle, and send the same run to your team, VA, or accountant. You can export it as CSV, Excel, or PDF, or push it to Google Sheets or Google Drive so the numbers arrive already prepared.
Frequently Asked Questions
How is the USA Tax collected report different from the Tax by State report?
The USA Tax collected report separates tax into four named US layers, state, city, county, and municipal, on each order. Tax by State groups everything under a single shipping-state dimension. Use this report when a return needs the jurisdiction layers split apart, and Tax by State when you only need a state-level rollup.
Why don't the State, City, County, and Municipal amounts always add up to the Tax total?
Because some collected tax is recorded in the generic Tax 1 to Tax 5 lines instead, typically a special district or a combined local rate. Compare the named columns and the Tax 1 to Tax 5 columns together against the Tax total to account for the difference before filing.
Does this report separate taxable and non-taxable sales?
Yes. Taxable Sales shows the order value tax was charged on, Non-Taxable Sales shows the exempt portion, and Total Sales combines both. This lets you show exactly which sales were taxed and which were exempt.
What are the Tax 1 to Tax 5 columns for?
They hold the individual tax lines Shopify records when more than one rate applies to a single order. Each Title names the tax and each Amount shows what was collected, which is where district-level or combined rates usually appear.
Can I schedule this report to send to my accountant automatically?
Yes. Save the report, set a daily, weekly, or monthly schedule, and add your accountant as a recipient. Report Pundit can deliver it by email or push it to Google Sheets or Google Drive on the same cycle, so filing detail arrives without a manual export.