A Shopify Order Export Your Accountant Can Actually Use

At the end of each month, someone has to hand the accountant a file that explains where the money came from. Most stores start by exporting orders from Shopify and sending the CSV. The accountant then spends an hour working out why the order totals do not match the bank, the payouts or the sales report.

The orders are not wrong. Shopify simply has several views of the same money, and each one answers a different question. This guide covers which fields belong in an accounting export, when Shopify’s finance reports are the better source, a monthly routine, and the reconciliation traps that cause most of the back-and-forth.

This is practical guidance on getting data out of Shopify, not tax or accounting advice. Agree the final format and treatment with your accountant.

Three views of the same money

Source	Answers	Dated by
Order export	What was each order, and what is its state now?	Order creation
Finance reports	What were sales, returns, taxes and payments in this period?	When each sale, return or payment happened
Payout export	What did the payment provider pay into the bank, and what fees did it take?	Transaction and payout dates

Mixing them up is the root of most mismatches. An order placed on 30 September and refunded on 5 October shows its refund on the order row whenever you export it. Shopify’s finance reports instead record that return as a negative amount on the date it was processed, in October.

Fields an accounting export should include

If your accountant wants order-level data, these are the fields to agree on. The column names below are the ones in Shopify’s order export.

Need	Shopify export column	What to know
Order reference	Name, Id	Name is the order number customers see
Dates	Created at, Paid at, Canceled at	Created at is when the customer completed the order
Status	Financial Status	Paid, partially refunded, refunded and so on, as of the export
Currency	Currency	Shopify describes it as the store’s base currency at the time of the order
Goods	Subtotal	The subtotal before shipping and taxes
Shipping	Shipping	Total shipping charged on the order
Tax	Taxes, Tax # Name, Tax # Value	Order tax total, plus up to five named line taxes
Discounts	Discount Code, Discount Amount, Lineitem discount	The code column does not include automatic discounts
Total	Total	The total cost of the order
Refunds	Refunded Amount	Any refund applied to the order, regardless of when
Payment	Payment Method, Payment References	References are the IDs sent to the payment provider

Two notes from Shopify’s column descriptions are worth repeating to your accountant:

Discount Code shows codes and manual discounts on draft orders only. Automatic discounts are not listed there, so do not use that column to explain every discount.
Payment References contains all payment IDs linked to an order, including failed payments, refunds and captures. Shopify suggests using it to match orders between Shopify and your payment provider.

Keep one row per order

Shopify’s standard export puts each line item on its own row, with the order totals on the first row only. For accounting, one row per order is easier: totals are not repeated, and a sum of each column is meaningful. If you need product-level revenue as well, export it as a separate file. Our guide to one row per line item explains when that layout is the right one.

When the finance reports are the better source

For period totals, Shopify’s reports under Analytics > Reports are usually what the accountant actually needs. According to Shopify’s finance reports page:

Finance summary shows sales, payments, gift cards, tips and gross profit for the selected period.
Total sales breakdown lists gross sales, net sales, discounts, taxes and related metrics, which Shopify says are the values you’ll most likely need for bookkeeping.
Total sales by order lists each sale and return by date, with each product and shipping charge on its own line.
Taxes shows each tax type, its rate and the amount charged in the period.
Payments reports show gross payments, refunds and net payments by method and gateway.

Shopify also spells out the date rules: sales are dated when the order was placed, returns when they were processed, and gift card sales are not counted as sales when sold, because the card is a liability until it is redeemed. You can export most reports as CSV from the report’s menu.

If you use Shopify Tax in the United States or Canada, the sales tax reports have their own limits: on screen they show up to 1,000 rows, and a CSV export covers at most one month. For longer periods, Shopify points you to the Taxes report. See Shopify’s tax reports page.

Payouts: the bridge to the bank

Orders and sales reports do not show what landed in the bank. If you use Shopify Payments, the payout export does. Shopify’s payout details guide explains how to export one payout’s transactions from Finance > Payouts, or all balance transactions for a date range. The CSV is emailed to you and the store owner, and includes columns such as Transaction Date, Type, Order, Amount, Fee, Net, Payout Status and Payout Date.

Shopify’s finance reports page also notes that the Shopify Payments activity report reflects funds you received, not revenue for accounting purposes. That is the distinction to keep: payouts reconcile the bank, sales reports measure revenue, order exports explain individual orders.

A monthly routine

Run the same steps on the same day each month, so every file covers the same period in the same way.

Fix the period. Use full calendar months and the store’s time zone. Write the start and end dates in the file names.
Export the finance reports. Total sales breakdown, Total sales by order and Taxes for the month, as CSV.
Export orders. On the Orders page, filter by the month’s dates and export. Keep the original file untouched; work in a copy.
Export payouts. Export the payout transactions for the month if you use Shopify Payments, or the equivalent report from your other payment providers.
Check the totals. Compare net sales from the sales report with what your order sheet suggests, and payouts with the bank statement. Write down any difference and its reason.
Send one folder. All files, a short note listing known differences, and anything unusual: a big refund, a chargeback, a manual order.

If you opened the order CSV in Excel, make sure order IDs and payment references are imported as text so long numbers are not rounded. Our guide to exporting Shopify orders to Excel covers the import settings.

Reconciliation pitfalls

Refunds in a different month

The order export shows the refund on the original order, even if it happened weeks later. The sales report shows it on the date it was processed. Agree with your accountant which one drives the books, and use the other only to explain individual orders. Our returns and refunds process guide covers how refunds are recorded in the first place.

Paid in a different month from the order

Shopify notes that an order placed in one period and paid in the next appears in different reports. Payment terms, bank transfers and manual payments are where this shows up most.

Gift cards

Gift card sales are liabilities, not sales, until redeemed. An order export that includes gift card products will look like more revenue than the sales report shows.

Fees are not on the order

Order totals are gross. Payment processing fees appear on payout transactions as Fee, and the bank receives Net. If the accountant reconciles orders to the bank directly, the fees look like missing money.

Several stores or currencies

Each store exports in its own base currency. If you run more than one store, keep one folder per store and do not add totals across currencies in the same column. Our guide to refund and order reports across stores covers the multi-store side.

Cancelled orders

Cancelled orders stay in the order export with a Canceled at date. Filter them out, or at least mark them, before anyone sums the Total column.

Checklist before you send the file

Same date range and time zone across every file
One row per order in the accounting export
Taxes, discounts, shipping and refunds as separate columns
Currency column included
Payment references kept as text
Cancelled orders marked or removed
Finance reports and payout export attached
A note explaining known differences

Building the accounting export with StoreFleet: Order Export

StoreFleet: Order Export is a Shopify app, currently in review for the Shopify App Store, that exports orders to CSV or Excel (XLSX) from a saved template. Its sales summary template puts one row per order with order number, date, financial status, currency, subtotal, discounts, shipping, taxes, total, refunded amount and payment gateways, in the shop’s currency. You can filter by date range, payment status, fulfillment status and tags, and money columns in XLSX files are written as numbers so they can be summed. It does not replace the finance reports or payout exports; it gives the order-level file a fixed shape each month.

FAQ

Should I send my accountant the order export or the sales report?

Usually both. The sales and tax reports give period totals dated the way accounting expects, and the order export explains individual orders when a number needs checking. Agree with your accountant which one drives the books.

Why doesn’t my order export match the Total sales report?

The order export shows each order’s current state, including refunds made later, dated by when the order was placed. The sales report records returns on the date they were processed and treats gift card sales as liabilities, so the two rarely match line for line.

Where do I find payment processing fees?

Not on the order. If you use Shopify Payments, export payout transactions from Finance > Payouts. Each row shows the amount, the fee and the net amount.

Does the order export include automatic discounts?

The Discount Amount column shows the discount applied to the order, but the Discount Code column lists only codes and manual discounts on draft orders, not automatic discounts.

Is this tax advice?

No. This guide explains where data lives in Shopify and how to export it. How you record sales, refunds and taxes depends on your jurisdiction and your accountant.