What Is the Shopify Tax Report?
The Shopify Tax Report in Data Export organizes tax collected on individual orders alongside taxable sales, non-taxable sales, and total sales. Each record includes an order name and date, giving you a practical way to review the tax amounts associated with transactions.
The report also provides up to five pairs of tax titles and amounts (Tax 1 through Tax 5). This is useful when a transaction has more than one tax component. The fields identify the components recorded for the order; they do not, by themselves, establish a tax jurisdiction or filing obligation.
Use a selected reporting period to check individual transactions, investigate unexpected tax values, or prepare a review file for your bookkeeper or tax adviser.
Report Overview
- Report period
- Choose the date range relevant to your review.
- Data included
- Date, order name, five tax title/amount pairs, tax, taxable sales, non-taxable sales, and total sales.
- Best for
- Reviewing tax charged per order and spotting transactions requiring a closer look.
- Available exports
- Excel, CSV, TXT, and PDF.
- Automation
- Schedule email delivery daily, weekly, or monthly.
What Can You Learn from Your Order Tax Data?
1. Find orders with unexpectedly high tax
Compare the Tax amount with Total Sales and the recorded tax components to identify transactions worth investigating.
Example: For example, an order shows a much larger tax amount than similar transactions.
What you can do: Open the order and check the tax setup and applicable transaction details.
2. Understand multiple tax components
Tax 1–Tax 5 titles and amounts help you see which separately recorded components contribute to an order’s tax.
Example: For example, a transaction lists two named tax components instead of one.
What you can do: Check the titles and amounts before grouping or sharing tax figures.
3. Review taxable versus non-taxable sales
Separate taxable and non-taxable sales amounts to examine how the store is classifying sales in the period.
Example: For example, some transactions show non-taxable sales while others do not.
What you can do: Review the relevant products and tax configuration for unusual classifications.
4. Prepare transaction-level tax support
Date and Order Name let you trace reported amounts back to particular transactions during a bookkeeping review.
Example: For example, your accountant questions the tax on an order from last month.
What you can do: Use the order name to find the record and share the matching report row.
What Should You Check First in This Report?
Begin with the figures that most directly explain a transaction’s tax treatment:
- Tax: Scan for zero, unusually large, or otherwise unexpected tax amounts.
- Tax 1–Tax 5 Titles and Amounts: Verify that named components and their values are consistent with the order’s tax treatment.
- Taxable Sales versus Non-Taxable Sales: Look for classifications that deserve a product or order review.
- Date and Order Name: Use these to retrieve the source transaction before making corrections.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a period-end tax review | Brings each order’s tax and sales amounts into one date-range report for reconciliation and review. |
| Investigating a tax amount on an order | Uses Order Name, Tax, and component amounts to isolate the transaction and examine the recorded figures. |
| Checking orders with multiple tax components | Shows the separate tax titles and values recorded in Tax 1 through Tax 5. |
| Reviewing taxable and exempt sales classifications | Lets you compare Taxable Sales and Non-Taxable Sales and identify entries to verify. |
| Sharing transaction detail with a tax professional | Provides dates, order identifiers, tax titles, and amounts as supporting transaction-level information. |
How to Create This Report in Data Export
Start with the available premade Tax Report and adjust the view to fit your review period.
- Open Data Export and locate the premade Tax Report.
- Open the report and review the columns, including Tax 1–Tax 5 and the sales totals.
- Choose the date range and apply relevant available filters or sorting if needed.
- Save the report, then export the results in your preferred supported format.
- If you need repeat delivery, configure a daily, weekly, or monthly email schedule for the intended recipients.
Make the Most of This Report
Use these four checks to make exported tax data easier to interpret and share.
01 / PERIOD / Keep reporting dates consistent Use the same date range for a repeat review, and label the export with the period covered.
02 / COMPONENTS / Read tax titles before totaling Do not assume Tax 1–Tax 5 always represent the same taxes across all transactions.
03 / VALIDATION / Verify unusual zero-tax orders Review transactions with non-taxable sales or no tax before treating them as errors.
04 / SHARING / Send only what is needed Share a filtered file with an accountant and restrict access to order-level transaction details.
Frequently Asked Questions
Does this report show tax for each order?
Yes. It includes Date, Order Name, Tax, and tax component titles and amounts so you can review tax at the order level.
What do Tax 1 through Tax 5 mean?
They are up to five separately listed tax components, each with a title and amount. The applicable titles depend on what is recorded for the transaction.
Can I distinguish taxable and non-taxable sales?
Yes. Taxable Sales and Non-Taxable Sales are separate fields, alongside Total Sales.
Can I export this report for my accountant?
You can export Excel, CSV, TXT, and PDF files. Select a suitable format and review the report before sharing.
Can the Tax Report be sent automatically?
You can schedule email delivery on a daily, weekly, or monthly basis. Choose the schedule and recipient list in Data Export.