What Is the Tax by State Report?
The Shopify Tax by State Report organizes sales and tax information by the shipping state on an order. It brings Gross Sales, Total Sales, Tax, Duty Tax, Total Duties, and Total Tax Rate (%) into a state-level view, making geographic differences easier to review.
Use a selected reporting period to compare state-level amounts, identify states that warrant a closer check, and share a consistent export with your bookkeeper. The report is a review and reconciliation aid; it does not by itself determine tax nexus, validate taxability, or prepare a state tax return.
Report Overview
- Report period
- Select the date range relevant to your review.
- Data included
- Seven fields covering shipping state, sales, tax rate, tax and duties.
- Best for
- Comparing tax amounts across US shipping states and preparing records for review.
- Export
- Excel, CSV, TXT or PDF.
- Automation
- Schedule delivery by email daily, weekly or monthly.
What Can You Learn from State-Level Sales and Tax?
1. Which states account for more recorded tax
Compare the Tax amounts across shipping states to identify where the largest amounts appear in the selected period.
Example: For example, in one month, State A shows more Tax than State B.
What you can do: Review the higher-value state first and check the underlying transactions if needed.
2. How sales and tax amounts vary by destination
Compare Gross Sales and Total Sales alongside Tax to give context to differences between shipping states.
Example: For example, two states show similar sales totals but different tax amounts.
What you can do: Investigate differences in product mix, exemptions, destination rules, and report settings outside this summary.
3. Where displayed tax rates deserve a second look
Use Total Tax Rate (%) to flag unexpected percentages. A state can have different local rates, so this column should not be assumed to be one universal state rate.
Example: For example, a shipping-state row shows a rate unlike your expected reference.
What you can do: Check the rate definition and source orders before making any tax adjustments.
4. Whether duty-related amounts need separate review
Tax, Duty Tax and Total Duties appear as distinct fields, helping you avoid treating every duty-related amount as ordinary sales tax.
Example: For example, a state row includes both Tax and Duty Tax.
What you can do: Keep duty amounts separate during bookkeeping review and confirm their treatment with an advisor.
What Should You Check First in This Report?
Start with the columns that directly affect your state-by-state tax review.
- Shipping State: Check that orders are assigned to the intended shipping destination.
- Tax: Sort from highest to lowest to prioritize the largest recorded amounts.
- Total Tax Rate (%): Investigate unexpected values without assuming this is a statutory state-wide rate.
- Duty Tax and Total Duties: Review these separately from the ordinary Tax amount.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a monthly state tax review | Creates a consistent snapshot of sales, Tax and displayed rate by shipping state. |
| Checking tax amounts before sharing with an accountant | Puts state-level sales and tax fields together for faster review. |
| Investigating a state with an unusual tax total | Lets you compare Tax against Gross Sales and Total Sales in the same grouping. |
| Reviewing duty-related charges | Separates Duty Tax and Total Duties from the ordinary Tax column. |
| Comparing tax results between reporting periods | Use the same field selection and change the date range to compare exported snapshots. |
How to Create This Report in Data Export
Start from the existing Tax by State premade report rather than rebuilding every field.
- Open Data Export and find the premade Tax by State report.
- Open it and check the seven columns: Gross Sales, Total Sales, Shipping State, Total Tax Rate (%), Tax, Duty Tax and Total Duties.
- Set your reporting period; apply a shipping-state filter or rearrange fields if your review requires it.
- Save the report and export it in the format you need for review or sharing.
- If useful, schedule daily, weekly or monthly email delivery to the intended recipients.
Make the Most of This Report
A few checks can make the exported state breakdown easier to interpret.
01 / CONSISTENCY
Use comparable periods: Keep the date range and field selection consistent when comparing successive exports.
02 / RATE REVIEW
Validate rate meaning: Check how Total Tax Rate (%) is calculated before drawing conclusions about local taxation.
03 / DUTIES
Keep duty figures distinct: Do not add Tax, Duty Tax and Total Duties together without verifying their definitions.
04 / SHARING
Share only what is needed: Send the report to the appropriate accountant or finance recipient and review access to shared exports.
Frequently Asked Questions
Does this report group tax by billing state or shipping state?
It groups the displayed information by Shipping State.
Can I use this report to file state sales tax returns?
It can support preparation and review, but state filings may require additional transaction details, exemptions, jurisdiction breakdowns and tax advice not shown in the seven default fields.
What is the difference between Tax and Duty Tax?
They are separate report fields. Tax reflects the report’s tax amount, while Duty Tax identifies tax associated with duties; confirm specific calculation definitions before reconciliation.
Can I compare one state across different months?
Yes. Generate the report for separate date ranges and compare those state rows, keeping your field selection consistent.
Can I receive this report automatically?
You can schedule daily, weekly and monthly email delivery. Review your delivery settings and recipients before activating it.