What Is the Tax Without Cancelled Orders Report?
The Shopify Tax Without Cancelled Orders Report brings tax amounts and sales values into one order-based view while excluding cancelled orders. It is designed for merchants who need to review tax connected to orders that remain in their sales records, rather than mixing in cancelled transactions.
For your selected reporting period, the report includes an order date and name, up to five tax titles with their corresponding amounts, total tax, taxable sales, non-taxable sales, and total sales. You can check the components behind an order’s tax and prepare a more focused export for bookkeeping.
Excluding cancelled orders does not, by itself, establish final tax liability: refunds, adjustments, jurisdictional rules, and filing-period treatment may still require separate review.
Report Overview
- Report period
- Select the period you want to review using the Date field.
- Data included
- Order identity, five tax title/amount pairs, total tax, taxable sales, non-taxable sales, and total sales.
- Best for
- Reviewing taxes on non-cancelled orders and preparing order-level tax records.
- Export options
- Excel, CSV, TXT, and PDF.
- Delivery
- Save the premade report and schedule email delivery daily, weekly, or monthly.
What Can You Learn from Non-Cancelled Order Tax Data?
1. Identify orders with multiple tax components
Tax 1–5 titles and amounts reveal how different tax components appear on an order.
Example: For example, an order has two separate named tax amounts.
What you can do: Check that each component is expected for the transaction.
2. Separate taxable and non-taxable sales
Taxable Sales and Non-Taxable Sales help you review the sales values presented in each category without relying only on total sales.
Example: For example, an order has both taxable and non-taxable sales values.
What you can do: Investigate unusual classifications before preparing tax paperwork.
3. Spot high-tax transactions for review
The Tax field and Order Name help you locate transactions with larger reported tax amounts.
Example: For example, one order shows a higher tax amount than comparable orders.
What you can do: Open that order and check its taxable sales and tax titles.
4. Keep cancelled orders out of routine tax exports
Using this report reduces confusion from including cancelled transactions in the same extract as your remaining orders.
Example: For example, a cancelled order does not appear in the export.
What you can do: Compare the report’s exclusion rule with the cancellation records for your period.
What Should You Check First in This Report?
Start with figures and labels that can materially affect how you interpret the export.
- Total Tax: Review the Tax column for unexpectedly large or small amounts.
- Taxable vs. Non-Taxable Sales: Check that the split agrees with the order’s tax treatment.
- Tax Titles and Component Amounts: Review the five tax slots for unexpected labels or amounts.
- Date and Order Name: Verify the period and trace noteworthy entries back to their source orders.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a tax-period order extract | Provides dated tax and sales details for orders that are not cancelled. |
| Reviewing mixed taxable and non-taxable sales | Shows the reported taxable and non-taxable sales values together. |
| Checking orders with several tax components | Lists up to five tax titles alongside their amounts for closer inspection. |
| Investigating unusually high tax on an order | Connects total tax to a specific order name and its component figures. |
| Sharing tax details with a bookkeeper | Offers a focused, exportable view without cancelled order records. |
How to Create This Report in Data Export
Start with the premade report so the tax fields are already arranged for review.
- Open Data Export and find the premade “Tax report without cancelled orders.”
- Open the report and confirm that cancelled orders are excluded as intended.
- Set your reporting date range; review the tax titles, amounts, and sales columns, and adjust fields or filters if required.
- Save the report and export it in an available format for your records.
- Optionally schedule delivery daily, weekly, or monthly to the appropriate recipients.
Make the Most of This Report
Small checks make the resulting export easier to explain and reuse.
01 / PERIOD
Use a consistent filing window: Align the selected Date range with your review period.
02 / EXCLUSIONS
Verify cancelled-order filtering: Recheck the exclusion before sharing totals.
03 / COMPONENTS
Read tax labels alongside amounts: Similar totals can contain different tax components.
04 / SHARING
Share only what is needed: Keep order identifiers and tax records with appropriate recipients.
Frequently Asked Questions
Does the report include cancelled orders?
No. The premade report excludes cancelled orders; verify that its filter remains in place if you customize it.
Can I see different tax types on a single order?
Yes. The report includes Tax 1 Title through Tax 5 Title and the corresponding five amount fields.
Does the Tax column show the amount I must remit?
Not necessarily. It shows reported tax, but refunds, adjustments, tax obligations, and filing rules may require additional reconciliation.
Can I distinguish taxable and non-taxable sales?
Yes. Both Taxable Sales and Non-Taxable Sales are included as separate fields.
Can I schedule or export this report?
You can export Excel, CSV, TXT, and PDF files and schedule daily, weekly, or monthly email delivery.