Shopify monthly tax summary report

How much tax was recorded on last month's orders, and where?

Install on Shopify

14-day free trial.

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.

Sample output, September 2026The built-in "Monthly tax summary" report. Made-up store, made-up numbers.
MonthBilling countryRegionTaxOrdersTax charged
Sep 2026United StatesCaliforniaCalifornia State Tax1,412$9,884.12
Sep 2026United StatesTexasTexas State Tax903$5,117.90
Sep 2026United KingdomVAT241$4,210.50
Sep 2026CanadaOntarioHST357$3,975.20
Sep 2026United StatesNew YorkNew York State Tax688$2,462.08
Sep 2026United StatesCaliforniaLos Angeles County Tax486$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.

Want this report for your store?

Install ReportNerds and run it on your own orders, or tell us the version you need and our nerds build it. 14-day free trial.

Install on Shopify