Shopify Order Export for Your Accountant: One Row per Order

A Shopify order export for your accountant works best as one row per order, with the same money columns every month: order number, date, currency, subtotal, discounts, shipping, taxes, total and refunded amount. You can build that from Shopify’s own order CSV by hand each month, or save it once as a template in an export app and change only the date range. This guide covers both, and how to set up the second with Columna: Order Export & Sheets.

It’s the end of the month. Your accountant asks for every order with subtotal, tax and total. You export orders, paste them into Excel, delete columns, merge line-item rows and fix things by hand. Next month you do it all again.

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

Why does the manual month-end report keep going wrong?

The usual routine is Shopify’s order export followed by edits in Excel or Sheets. The problems are predictable:

• Too many columns. Shopify’s order CSV is built for every use. Your accountant only wants a handful of money fields, so you delete the rest each time.
• Several rows per order. The standard export puts each line item on its own row, with the order totals on the first row only. Summing a column without cleaning up first gives the wrong answer.
• Hand edits you can’t repeat. Every fix you make in the spreadsheet is a fix you have to remember next month.
• Different dates for the same money. The order export shows a refund on the original order, while Shopify’s finance reports record it on the date it was processed. Mixing the two files is where many mismatches come from.

None of this is hard, but it takes time every month and leaves room for the small differences that make an accountant write back with questions.

Which columns does my accountant need on each row?

Ask your accountant for the exact list, because every firm is a little different. In most cases the core is the same:

1. Order number and date
2. Financial status
3. Currency
4. Subtotal
5. Discounts
6. Shipping
7. Taxes
8. Total
9. Refunded amount
10. Payment gateway

With these side by side on one row, your accountant can check any single order at a glance, and a sum of each column means something. If they also want revenue per product, send that as a separate file in a one row per line item layout rather than mixing both in one sheet.

How do I export one row per order with Columna?

Columna includes a sales summary template that puts one row per order with order number, date, financial status, currency, subtotal, discounts, shipping, taxes, total, refunded amount and payment gateways. Check that list against what your accountant asked for before the first export.

1. Install Columna: Order Export & Sheets and open it from your Shopify admin.
2. Pick the sales summary template. If your accountant wants other fields or a different order, build your own template: pick the columns, put them in the order they expect and rename the headers. Choose one row per order, then save it. The template is stored in your store.
3. Set the date range to the month you’re closing. You can also filter by payment status, fulfillment status and tags. Use the same filters each month so the files stay comparable.
4. Download the file as XLSX. The file is built in your browser and saved to your computer.
5. Spot-check two or three orders: open them in Shopify and compare subtotal, taxes and total with the file. It takes a minute and builds trust in the export.
6. Send the file to your accountant.

Next month, open the same template, change the date range and download again.

Can I get the report every week without rebuilding it?

Yes. Keep the same template and change only the date range. If you’d rather not download it yourself, Columna’s Pro plan can email scheduled exports to you, and Columna can also sync orders to Google Sheets. Our guide to sending Shopify orders to Google Sheets every week walks through that setup, and the post on Google Sheets without duplicate rows covers the common pitfall.

If you’ve paid for an export app before and found refunds missing or figures drifting, the same spot-check applies: compare the refunded column with a few refunded orders in Shopify before you rely on the file. We wrote more about why paid export apps lose reliability or value.

Manual edits or a saved template: which should I use?

	Shopify order CSV + Excel edits	Saved template in Columna
Columns	Delete and reorder each month	Chosen once, same every time
Rows	Line items on separate rows; merge by hand	One row per order
Headers	Renamed by hand	Renamed once in the template
Repeating it	Depends on remembering each step	Same template, new date range
Cost	Free, your time	Exports to CSV and Excel are free; scheduled email exports are Pro

If you only need this once, the manual route is fine. Our free Shopify order CSV to Excel converter also turns Shopify’s own export into one row per order in the browser. A saved template pays off when you send the same file every week or month.

For period totals, dated the way bookkeeping usually expects, Shopify’s finance reports are still the source to use. Our longer guide to a Shopify order export your accountant can actually use explains when to send the order export, the finance reports and the payout export.

FAQ

Should I send my accountant the order export or Shopify’s finance reports?

Often both. The finance reports give period totals dated by when each sale or return happened, and the order export explains individual orders when a number needs checking. Agree with your accountant which one drives the books.

Why do my order export totals not match the 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, so the two rarely match line for line.

Does Columna send the file to my accounting software?

No. Columna does not connect to accounting software. You download the CSV or XLSX file, or receive it by scheduled email on Pro, and send it on.

Do my orders pass through Columna’s servers?

No. Columna builds export files in your browser, so your orders never reach our servers.

Can I change the column names to match my accountant’s spreadsheet?

Yes. In a template you pick the columns, set their order and rename the headers, so the file matches the layout your accountant already uses.

Try Columna: Order Export & Sheets

Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX from a saved template, with line-item properties such as engraving and gift messages in their own columns, processed in your browser. It’s built for shops that hand orders to production, fulfilment or accounting.

Ready to stop rebuilding the month by hand? Install Columna: Order Export & Sheets and run your first sales summary export on last month’s orders.