Ecom Store Pro

How to Get a US Sales Tax Report From Shopify

Where Shopify's US sales tax report lives, which stores can open it, how to export a quarter past the one-month CSV limit, and what its totals leave out.

Listen to a short brief of this article
Hands-free while you multitask

The short version

Shopify's United States sales tax report, in Analytics > Reports, breaks your US sales down by state, then by tax jurisdiction and rate, then by transaction.

Shopify makes it available only to stores located in the United States that use Shopify Tax and have USD as the store currency; other stores work from the Taxes and Total sales by order reports, and a store on Shopify Tax in Canada with CAD as the store currency also has a Canada sales tax report.

Each CSV export from it holds at most one month of data, so a quarterly return takes three exports; for more than a month in one file, Shopify points you to the Taxes report.

The totals keep tax on custom refund amounts, leave tax-exempt customers and products out of net sales, and skip marketplace orders such as Amazon in the state and jurisdiction views, so check those before the files go to whoever files your return.

If a sales tax return is due, its figures come out of Analytics > Reports in your Shopify admin.

Two things decide which report you open and how many files you export: whether your store qualifies for the United States sales tax report at all, and how much time one export can hold. This guide walks both, then the gaps in the totals worth checking before the files go to you, your accountant or a filing service. Shopify Help Center pages and our test store's admin were read on November 6, 2026.

Which Shopify Tax Report Can You Open?

Key takeaway

Access follows your tax service: Shopify Tax in the United States is what gives you the US sales tax report. The report's own help page adds two more conditions, and all three have to hold:

  • The store is located in the United States.
  • The store uses Shopify Tax.
  • The store's currency is set to USD.
Find your row: which tax report your store works from
Your storeReport to openWhat to know
Located in the US, on Shopify Tax, store currency USDUnited States sales taxState, jurisdiction and transaction views; data from July 1, 2024; each CSV export holds up to one month
Located in the US, on Manual TaxTaxes, and Total sales by orderShopify lists Tax reports for Manual Tax, but not Advanced tax reports
Located outside the USTaxes, and Total sales by order (a store on Shopify Tax in Canada with CAD as the store currency also has a Canada sales tax report)The US report needs a store located in the US
Store currency is not USDTaxes, and Total sales by orderThe US report needs USD as the store currency
You need tax data from before July 1, 2024TaxesThe US report sends you to the Taxes report for anything earlier
You want one file for more than a monthTaxesThe US report's CSV stops at one month of data; the Taxes report exports more than a month in one file, without the jurisdiction view

Shopify Help Center: Tax reports, Finance reports and Choose a tax service, read November 6, 2026.

The Manual Tax row comes from Shopify's US comparison of tax services, which marks Tax reports as available on both Shopify Tax and Manual Tax, and advanced tax reports on Shopify Tax only. Shopify describes those advanced reports as having additional details about the tax you collect, for use when you file with tax authorities.

A store in Canada has its own Canada sales tax report, available with Shopify Tax in Canada and CAD as the store currency; our guide to sales tax in Canada covers the rest of that setup.

Selling from India? GST data comes out of the Taxes and Total sales by order reports, and our answer on getting a GST report from Shopify walks that export.

How to Open the US Sales Tax Report

Key takeaway

Shopify's finance reports documentation starts the path in the same place for every store; the search in step 2 is what our test admin showed as of November 6, 2026:

  1. From your Shopify admin, go to Analytics > Reports.
  2. Search the list for United States sales tax and open it.
  3. Set the date range to the period you need.
  4. Read the state overview, then click a state to open its jurisdiction view.
In Shopify adminOpen in your store
  1. Analytics
  2. Reports
Search the list for United States sales tax; Taxes sits beside it in the Finances category.
What our test store showed
In our test store on November 6, 2026, the United States sales tax report was listed under the Sales category of the Reports list, while the Help Center groups it with the Finances reports. The same store showed a Detailed transactions button at the top of the state view. In that store, searching the list by the report's name found it.

The report opens on the state overview by default. From there, Shopify describes two deeper views you reach by clicking a state: the Jurisdiction report and the Detailed transactions report.

The state overview: one row per state you sold to

Key takeaway
State overview columns
ColumnWhat it holds
Destination stateEach state your sales were made to; click one to open its jurisdictions
Total net item salesLine-item sales after discounts and sales reversals, without shipping
Total item tax amountTax collected on sales, summed across the state, county, city and special jurisdictions; no tax on shipping
Total shippingWhat you charged customers in that state for shipping
Total shipping tax amountTax collected on shipping

Column definitions from Shopify's Finance reports help page, read November 6, 2026.

Two rows you might expect are missing by design. A state you made no sales to isn't listed, and orders made through third-party marketplaces such as Amazon aren't included in the overview.

If the report shows no rows at all, check the limits the help page sets: only sales to customers with US shipping addresses are included, and tax data from before July 1, 2024 sits in the Taxes report.

Net item sales are counted after sales reversals, which in Shopify's reports cover more than returns; our answer on what sales reversals are lists what counts as one.

The jurisdiction view: the one built for a state return

Key takeaway

Clicking a state opens the Jurisdiction report. It breaks out each tax jurisdiction and rate (a state, county, city or special district) and aggregates the sales and tax collected for each jurisdiction–rate combination, which is why Shopify points merchants who prepare a return themselves here:

This format matches with how most state returns expect you to report sales and tax by jurisdiction.
Shopify Help Center — Tax reports ·

One pattern looks like a duplicate and isn't. If a jurisdiction's rate changes inside the date range you picked, the jurisdiction view lists that jurisdiction once per rate, each on its own row.

Detailed transactions: line items for audits and imports

Key takeaway

To open it, click a state, then View Transactions in its jurisdiction view, as Shopify's help page describes. The Detailed transactions report is the line-item layer: each line item, including shipping or returns, sits on a separate row, so a single order is likely to take several. Shopify names three jobs for its export: importing into other software, recalculating taxes elsewhere and supporting an audit.

Marketplace orders behave differently here than in the summaries. In the detailed transaction report, orders from third-party marketplaces such as Amazon are hidden by default, and the filter button displays them.

How to Export It for a Filing Period

Key takeaway

Exporting works the same way across Shopify reports; for the US report it goes like this, with the More actions menu our test admin showed as of November 6, 2026:

  1. Open United States sales tax and set the date range to one month at most.
  2. Open the report's More actions menu (Shopify's help page shows it as a horizontal-menu icon) and choose Export.
  3. If the Export report dialog asks for a file format, choose CSV.
  4. Click Export.
In Shopify adminOpen in your store
  1. Analytics
  2. Reports
  3. United States sales tax
In our test store Export sat in the More actions menu; the table is empty because the test store has no US sales.

Two limits shape every export. On screen the report shows a maximum of 1,000 rows, so the full data only comes out as a CSV, and a CSV exported from this report has a maximum amount of one month of data.

Take a quarterly return for January through March 2026. From the US report that is three exports, one CSV each for January, February and March. For more than a month in one file, Shopify sends you to the Taxes report instead. An annual return works the same way: twelve monthly files from the US report, or one CSV exported from the Taxes report.

The Taxes report's single file has a cost: it gives up the drill-down from state to jurisdiction.

Quarterly and annual periods in one file: the Taxes report

Key takeaway

The Taxes report trades the drill-down for one flat list: each row includes a tax type, such as a state tax or a county tax, its rate, and the total amount of tax charged in the selected time-frame. It is also where the US report sends you for tax data from before July 1, 2024.

Its location logic is destination-first. The shipping address sets the tax country and region; if there is none, the billing address is used, and failing that, the point-of-sale address.

Origin-based states show the destination
Shopify notes that the Taxes report can include destination information even for origin-based sales tax jurisdictions. For origin-based jurisdictions such as California, it currently displays the destination instead of the region the tax applies to, so keep that in mind before you total those rows by region.

One column matters if you sell on marketplaces: Filed by channel shows which taxes a marketplace channel has filed on your behalf.

In Shopify adminOpen in your store
  1. Analytics
  2. Reports
  3. Taxes
The Taxes report groups tax by channel, country, region, tax name and rate for the period you pick.

A second export for your accountant: Total sales by order

Total sales by order is the other report Shopify lists for sales tax work. Its CSV export carries gross sales, net sales, taxes, returns and shipping charges, and Shopify asks you to choose the correct time period, such as the calendar year, so the file holds what you or your accountant need for the return.

What the Report Counts, and What It Leaves Out

Key takeaway

Before the numbers leave the admin, check the period for the situations below. The table says how the US report treats each one and where to look; what any of it means for your return is a question for you and whoever files it.

How the US sales tax report treats each case
In your periodHow the US report treats itWhere to look
A refund on a specific line itemOnly that line item's tax is refunded; the state and jurisdiction views drop by the refundA separate refund row in Detailed transactions
A custom refund amount, not tied to a line itemThe tax isn't refunded and stays in the reportOrders refunded with a custom amount
A tax-exempt customerTheir sales aren't part of Net salesThe customers you set up as tax exempt; separately, the jurisdiction view has Exempt item sales and Total exempt sales columns
A product exempt from sales taxIts sales aren't part of Net salesYour product tax exemptions; separately, Detailed transactions shows Exempt amount and Shopify tax exemptions
A deleted orderIncluded as of May 15, 2025No separate step: they're part of the totals
A marketplace order, such as AmazonNot in the state or jurisdiction viewsDetailed transactions, after the filter button
A sale to a customer whose shipping address isn't in the United StatesNot in the report: only sales to customers with US shipping addresses are includedThe Taxes report, which has a Tax country column

Shopify Help Center: United States sales tax report considerations and view definitions, read November 6, 2026.

If Shopify manages your US sales tax

Key takeaway

Some newer stores split the work differently. As of November 2026, managing US sales tax with Shopify is in early access for certain stores opened after October 27, 2026, and sales tax on their eligible online orders is collected and remitted for them. Shopify lists the order types the merchant still registers for, collects and files:

  • Orders from the Point of Sale sales channel, including quick sales.
  • Orders created by third-party apps, such as return and exchange apps.
  • B2B orders, including B2B orders placed on your online store.

Who files what on each of Shopify's routes, this one included, is the subject of our answer on whether Shopify files sales tax for you.

Why the Totals Won't Match Your Payouts

Key takeaway

Shopify's help page gives two reasons why its Sales and Payments reports might show different numbers. The first is scope: Sales reports cover orders placed and Payments reports cover payments customers made, so an order whose payment hasn't been captured yet can show in the sales figures before it shows in payments.

The second is timing. Reports display data by time-frame, so an order placed in May and paid in June counts in the May sales figures and the June payments.

If you use Shopify Payments, the Shopify Payments activity report reconciles your balance with bank deposits, and Shopify warns that it can still differ from the Sales or Payments reports because it reflects balance activity and payout timing. Why your books run on two clocks, the order date and the payout date, is a question our accounting guide answers in one section.

For the deposit side of what you hand over, our answer on exporting a Shopify payout for your accountant covers the activity report and single-payout exports.

What the Report Doesn't Decide for You

Key takeaway

The report shows where you collected tax, not where you should have. Whether you owe in a state you never collected in is a nexus question, and the tax liability insights in your admin are where Shopify flags it, as a signal from your data rather than a ruling.

Turning these files into a return is also where Shopify draws its own line:

It's your responsibility to consult with tax authorities or tax professionals to ensure that you file and remit your taxes correctly.
Shopify Help Center — Filing your taxes after automated filing ends ·

Shopify names three ways to get from reports to a filed return: file yourself with your Shopify Tax reports, work with a tax professional, or use another filing service. Its page for stores leaving automated filing adds that, if you file yourself, Shopify Tax keeps calculating your sales tax and keeps your tax reports current at no extra cost.

Automated filing is no route for a store that isn't already in it: it is closed to new enrollment, and as of November 2026 it files returns for enrolled stores for sales made through December 31, 2026, with filing records downloadable until April 30, 2027. In New York, it also files the December 2026–February 2027 quarterly return. Enrolled stores can read our answer on what to do when automated filing ends.

Independently of your store's tax settings, as of January 1, 2025, the Shop channel collects, remits and files tax on orders placed in the Shop app or on shop.com that ship to or within the US; you might still need to include those orders in your reporting to your local or state authority, and if you use automated filing, it includes them where required.

Pull Your Filing-Period Report in This Order

Key takeaway

Tick the steps as you go; progress is saved in this browser, so the list is there again next quarter. Steps one and two decide which report you work from.

Pull a filing-period sales tax report from ShopifyTick each step as you settle it. Progress is saved in this browser.

Pull a filing-period sales tax report from Shopify

Tick each step as you settle it. Progress is saved in this browser.

0 of 8 done
  1. The United States sales tax report needs a store located in the United States, on Shopify Tax, with USD as the store currency.

  2. Each CSV export from the US report holds at most one month of data, so the number of months is the number of exports.

  3. On the US report: in Analytics > Reports, search for United States sales tax and set the date range.

  4. On the US report: click the state to see its jurisdiction view, one row per jurisdiction and rate.

  5. Export a CSV per month from the US report, or one Taxes report export for a longer period or for data before July 1, 2024.

  6. On the US report: tax on custom refund amounts stays in the report, and tax-exempt customers and products aren't part of net sales.

  7. Marketplace orders are outside the state and jurisdiction views, and on Shopify-managed sales tax some order types stay yours.

  8. Export Total sales by order for the same period and pass every file to whoever prepares the return.

The Bottom Line

Key takeaway

Shopify gives stores located in the US, on Shopify Tax and with USD as the store currency a report whose jurisdiction view, by Shopify's account, matches how most state returns expect figures, and the Taxes report exports more than a month in one file. The work around them is mostly bookkeeping: matching exports to the months of the return and noting what the totals treat differently.

Work from the jurisdiction view if your store has it, export by the month, and read the gaps before anyone signs. The report is the record of what you collected, not the return itself. Custom refunds, exempt sales, marketplace orders and, on managed sales tax, Point of Sale, app-created and B2B orders are the places where that record and your return can part ways.
Your Next Step by Stage
A tax line looks wrongCheck why an order's tax differs from what you expected before you trust the report built on it.See why the tax amount can be wrong
Year-end paperworkFind out who gets a 1099-K from Shopify Payments and why its figure isn't your sales tax total.Read about the 1099-K
On Shopify-managed sales taxWeigh whether your Point of Sale, app or B2B orders make the Self-directed setting the better fit.Compare Managed and Self-directed

Questions About Your Shopify Reports Between Filings?

Expert Shopify consulting is included in Ecom Store Pro's monthly Support & Maintenance plan: which report and view holds the data you need, and how to export it. What to file and how stays with you and your tax professional; we don't prepare returns.

See the support plan

Frequently Asked Questions

Go to Analytics > Reports in your Shopify admin and search the list for United States sales tax. It opens on a state overview, and clicking a state shows its jurisdictions. Stores without it work from the Taxes report and Total sales by order, which sit in the same Reports list.
Shopify makes it available only to stores that meet three conditions: the store is located in the United States, it uses Shopify Tax, and its currency is set to USD. A store on Manual Tax, or with another store currency, uses the Taxes report and Total sales by order instead.
Not in one file from the US report: a CSV exported from it holds at most one month of data. For a quarter, export three monthly files, one per month. For more than one month in one file, Shopify says to export a CSV from the Taxes finance report instead.
That is the on-screen limit: the United States sales tax report displays a maximum of 1,000 rows. To get every row, export it as a CSV, which carries all the data in the report for the date range you picked, up to one month per export.
It depends on how you refunded. A refund on a specific line item refunds only that item's tax and lowers the state and jurisdiction totals, with its own row in Detailed transactions. A custom refund amount not tied to a line item doesn't refund the tax, so that tax stays in the report.
Not in net sales. Shopify's description of the US sales tax report says net sales doesn't include customers that are tax exempt or products that are exempt from sales tax. Separately, the jurisdiction view has Exempt item sales and Total exempt sales columns, and Detailed transactions shows Exempt amount and Shopify tax exemptions.
Not in the state overview or the jurisdiction view: orders made through third-party marketplaces such as Amazon aren't included there. In the detailed transaction report they're hidden by default, and the filter button displays them. The Taxes report also has a Filed by channel column for taxes a marketplace filed for you.
The jurisdiction view. Click a state in the US sales tax report, and each row shows one tax jurisdiction and rate with the sales and tax collected for it. Shopify says the Jurisdiction report can be used when you prepare a sales tax return yourself and matches how most state returns expect figures.
Use the Taxes report. The United States sales tax report sends you there for tax data from before July 1, 2024. In the Taxes report, each row is a tax type with its rate and the tax charged in the time-frame you select, and the tax country and region come from the destination.
Its tax rate changed during the date range you selected for your report. Shopify lists a jurisdiction once per rate in that case, so each rate has its own row with its own sales and tax. Those rows all belong to the same jurisdiction, so they aren't duplicates.
Usually not. As of November 2026, automated filing serves only enrolled stores, for sales through December 31, 2026; the Shop channel files for its US-bound orders, which you might need to report; and managed sales tax early access, for certain stores opened after October 27, 2026, collects and remits tax on eligible online orders. Otherwise, file yourself or through a tax professional or filing service.
They count different events. Sales reports count orders by when they were placed; payment reports count payments by when they were made, so an order placed in May and paid in June falls in two months. The Shopify Payments activity report follows balance activity and payout timing, so it can differ again.
About This Article
Shopify Developer & Editorial Director
9+ years with Shopify since 2017

Front-end developer specializing in Shopify since 2017. Experienced in building custom Liquid themes, optimizing storefront performance, and integrating third-party apps. Directs the editorial process behind Ecom Store Pro: sets its topics and the rules every AI-written page must pass before publication.

This page was written by AI. Separate AI agents that did not write it check its figures and claims against official sources and test its links and interactive tools. A human editor sets the site's editorial direction, topics and rules and checks that pages are complete and display correctly, but does not check their facts or edit their text. Details may change — always confirm critical data at shopify.com.

Editorial Policy

Some links in this article are affiliate links. If you sign up for a Shopify store through these links, we may earn a commission at no extra cost to you. Read our full advertising policy.

Continue Learning

What to Read Next

Stay updated

Get notified about new articles

Subscribe to receive updates when we publish new Shopify guides and insights.