Your tax numbers, ready before your bookkeeper asks
Laid out like the return
Month and country only, or month, region and rate. Save the version your bookkeeper wants and it is the same every time.
On the bookkeeper's desk on the 1st
Schedule it monthly, filtered to the previous month, as CSV or Excel. The monthly export stops being a task.
Detail when a number needs checking
"Tax detail" breaks any figure down by tax title, rate and billing geography. "Taxes by title" shows tax moving with refunds.
Or we build it to match your filing
A layout that mirrors a specific return, or tax and sales in one sheet? Describe it in the app and our team builds it. How it works.
What it looks like
One row per month, billing country, region and tax: the orders that carried it and the amount charged, in the shape the return asks for. This version of the built-in groups order dates by month and adds billing region.
| Month | Billing country | Region | Tax | Orders | Tax charged |
|---|---|---|---|---|---|
| Sep 2026 | United States | California | California State Tax | 1,412 | $9,884.12 |
| Sep 2026 | United States | Texas | Texas State Tax | 903 | $5,117.90 |
| Sep 2026 | United Kingdom | VAT | 241 | $4,210.50 | |
| Sep 2026 | Canada | Ontario | HST | 357 | $3,975.20 |
| Sep 2026 | United States | New York | New York State Tax | 688 | $2,462.08 |
| Sep 2026 | United States | California | Los Angeles County Tax | 486 | $1,106.33 |
| Total | $26,756.13 |
What each number means
So the figure means the same thing to everyone who reads it.
- Month
- The month the order was created.
- Billing country and region
- From the order's billing address.
- Tax
- The tax line's title as Shopify recorded it on the order. Rate is a separate field you can add.
- Orders
- Distinct orders carrying that tax line. One order can carry a state tax and a county tax, so the total row leaves this blank rather than double count.
- Tax charged
- The sum of that tax line across those orders, as recorded on the order lines.
- Refunds
- This report reads the tax on orders as they stand today. "Taxes by title" gives the event-dated view, where a refund reduces tax in the month it was processed.
Already have Shopify's reports?
Shopify's own reports can be edited, saved and exported to a spreadsheet (Shopify Help). That covers a one-off. ReportNerds keeps the exact version your team needs, sends it on a schedule, and our nerds build the ones you would rather not.
More reports
Sales by product
What did each product actually earn after discounts and refunds?
Inventory value
What is the stock we hold worth right now, at cost and at retail?
Gross margin by product
Which products make money after the cost of goods, and which only look like they do?
Sales by vendor
Which vendors' products earned the most after discounts and refunds?
Inventory by location
How many units of each SKU sit at each location, and how many are already spoken for?
Inventory on a date
What did we hold, where, and what was it worth, on any past day?
Custom reporting
Your reports, your shape, on schedule. Or our team builds them for you.