What Is the Product Tax Report?
The Shopify Product Tax Report shows tax amounts alongside product sales, duties, and net quantities. It brings product names and variant SKUs into the same view, making it easier to see which items are associated with tax collected during a selected reporting period.
Rather than checking tax totals one order at a time, merchants can review differences between products and variants, identify rows worth investigating, and share a focused export with a bookkeeper or accountant.
This is a product-level review, not a tax return or a breakdown by tax jurisdiction. The listed columns do not identify the tax rate, customer location, exemption reason, or individual order.
Report Overview
- Report period
- Select the dates you need to review.
- Data included
- Product name, variant SKU, net quantity, gross sales, total duties, tax and total sales.
- Best for
- Product and variant-level tax review, reconciliation checks and export preparation.
- Export options
- Excel, CSV, TXT and PDF.
- Automation
- Scheduled email delivery on a daily, weekly or monthly basis.
What Can You Learn from Product-Level Tax Data?
1. Which products account for more tax
Compare the Tax column across product rows to identify items contributing larger tax amounts. A high figure may reflect sales volume rather than a different tax rate.
Example: For example, a bestselling shirt shows more total tax than a slower-selling accessory.
What you can do: Review its quantity and sales alongside tax before investigating the difference.
2. Whether variants need a closer look
Variant SKU lets you compare closely related products without combining every variation into one figure. This can help surface unexpected differences for the same product family.
Example: For example, two sizes of one item have similar sales but noticeably different tax totals.
What you can do: Check the underlying transactions and product tax settings for those SKUs.
3. Where duties add to the amount under review
Total Duties and Tax are separate columns. Reading them side by side helps keep these charges distinct when reviewing product-level amounts.
Example: For example, an imported accessory has duties recorded while a domestic item does not.
What you can do: Review duties separately from tax in the export shared with your finance team.
4. Which rows deserve a sales-to-tax check
Gross Sales, Total Sales and Tax provide useful context for reviewing a product’s reported amounts. The report alone does not explain every adjustment between sales measures.
Example: For example, one variant has substantial sales but little reported tax.
What you can do: Verify the source transactions and applicable product tax treatment before drawing conclusions.
What Should You Check First in This Report?
Begin with the fields that help locate meaningful differences without assuming the cause.
- Tax: Sort high to low to identify the product rows representing the largest amounts.
- Variant SKU: Check that similarly named variants are not being reviewed as one item.
- Net Quantity and Gross Sales: Use both to understand whether tax differences coincide with activity.
- Total Duties versus Tax: Keep these separate when preparing a review or accountant handoff.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a product-level tax review | Places product identity, sales, tax and duties in one export. |
| Investigating unexpected tax totals | Helps prioritize products with unusual tax amounts relative to their sales. |
| Comparing variants of the same product | Uses Variant SKU to keep variant-level rows distinguishable. |
| Checking tax and duties separately | Shows Tax and Total Duties as distinct values. |
| Sharing a focused period with an accountant | Produces a date-specific list of product-level amounts for further verification. |
How to Create This Report in Data Export
Start from the premade Product Tax Report rather than assembling the seven columns manually.
- Open Data Export and find the premade Product Tax Report.
- Open the report and confirm Product Name, Variant SKU, Net Quantity, Gross Sales, Total Duties, Tax and Total Sales.
- Choose the reporting period, and apply any relevant product or SKU filters.
- Save the report, then export it in the available format that suits your review.
- If regular delivery is useful, configure the daily, weekly or monthly email schedule described in the source guide.
Make the Most of This Report
Use these four small checks to make the product-level figures easier to interpret and share.
01 / TIME WINDOW
Keep periods consistent: Compare equivalent reporting windows when looking for changes in product tax.
02 / VARIANT REVIEW
Use SKUs: Check variant identifiers before merging or comparing rows with similar product names.
03 / TAX AND DUTIES
Separate the charges: Preserve both Tax and Total Duties when sending a financial review.
04 / SHARING
Share with context: Include the date range and explain that the report is product-level, not a jurisdiction-level filing summary.
Frequently Asked Questions
Does this report show tax by product or by order?
It is described as a product-wise report using Product Name and Variant SKU. Individual order identifiers are not among its seven listed columns.
Can I review tax for a particular variant?
Yes. Use Variant SKU to distinguish variants and apply an appropriate filter when available.
Does the Tax column show which state or country collected the tax?
No. No geographic fields are included in this premade layout. A location-based tax view would need different fields or a separate report.
Is Total Duties the same as Tax?
No. They are separate report fields and should remain distinct when reviewing charges.
Can I schedule the Product Tax Report?
You can schedule email delivery daily, weekly or monthly after saving the report.