How to Export Tax Summary from Shopify (2026 Guide)
Follow these steps to export your Shopify tax summary as a CSV file. Once exported, you can use any of our converter tools to transform the data for your target system.
Export Steps
Log in to your Shopify admin
Open your browser and go to your-store.myshopify.com/admin. Sign in with your credentials. You need at least the Reports permission to access the Analytics section. Tax reports are available on the Shopify plan and above; they are not available on the Basic Shopify plan.
Navigate to Analytics then Reports
From the left-hand sidebar, click on Analytics, then click Reports. This opens the reports dashboard showing all available report categories including Sales, Finances, Customers, Acquisition, Behavior, and Taxes.
Open the Taxes report
Scroll down to the Taxes section in the reports list and click on the tax report you need. The primary options are 'United States sales tax' for US-based tax reporting and 'Taxes Finance Report' for a broader view of tax collected by country and region. Choose the report that matches your tax filing jurisdiction.
Set the date range for your reporting period
At the top of the report, use the date range selector to choose the period you need. You can select preset ranges like 'Last 30 days', 'Last quarter', or 'Last year', or set a custom date range by specifying exact start and end dates. Make sure the date range matches your tax filing period.
Review the report data
Before exporting, review the on-screen report to verify it shows the correct jurisdictions, tax rates, and amounts. The report breaks down tax collected by state or province, showing gross sales, taxable sales, non-taxable sales, and the tax amount collected for each jurisdiction.
Click Export and select CSV format
Click the Export button in the upper-right corner of the report. Choose CSV as the export format. The file will download to your browser containing all the data currently displayed in the report, including any applied filters and the selected date range.
Review and organize the exported data
Open the exported CSV in your spreadsheet application. Each row represents a tax jurisdiction with its associated sales and tax totals. Map the columns to your accounting needs: Taxable Sales is the sales base, Tax Collected is your liability, and if applicable, Marketplace Tax Withheld shows tax that Shopify already remitted on your behalf for marketplace orders.
Required Tax Summary Fields
| Field | Type | Description | Example |
|---|---|---|---|
| Period Start | Date | Report period start date | 2025-01-01 |
| Period End | Date | Report period end date | 2025-01-31 |
| Tax Jurisdiction | Text | Tax authority name (State, Province, Country) | California |
| Taxable Sales | Currency | Total taxable sales amount | 10000.00 |
| Tax Collected | Currency | Sales tax collected from customers | 725.00 |
Your Shopify export must include these fields for successful conversion.