We use cookies to run the site, measure visits, show you our ads on other platforms, and credit the partner who sent you to us. Learn more in our Privacy Policy.

See your true profit through Black Friday. Try Growth, free until 1 December.BFCM '26 | Try Growth, free until 1 Dec.Claim Offer

TOOLS

Export Report

Building a spreadsheet from any combination of tools, and what to know before you send it on.

Updated 20 Nov 2026 · 2 min read

Export Report builds one Excel workbook from whichever tools you tick. Each tool becomes its own sheet, after a Contents sheet that says what each one answers. So you can hand your accountant the expenses and the profit and loss in a single file, or keep a monthly record without copying anything out by hand.

Export Report comes with the Growth plan and above, and with the free trial. It is not part of Starter.

Building one

Click Export Report in the sidebar, under Reporting. It opens on the period you were already looking at, with every tool ticked. Untick what you do not need, or pick one of the Templates, and export. That is the whole process.

The templates are Revenue, Marketing, Customers, Operations, Performance, Bookkeeping and Monthly close. Bookkeeping and Monthly close open with a summary sheet in Shopify's own terms, made for an accountant or a board.

Some sheets do not follow the period you picked, on purpose

Every sheet says which period it covers at the top.

Inventory: a snapshot of your stock right now. There is no historical version of "how much is on the shelf".

Reviews: your reviews, whatever period you picked.

Bookkeeping: whole calendar months. It covers every month your period touches, from its first day to its last, with the current month to date.

Cohorts does follow your period, but retention needs at least 90 days to show. Ticking it stretches a shorter period to 90 days. If you typed your own dates, we warn you instead of changing them.

Before you forward it

Two things travel differently on paper than on screen.

How refunds are counted. The Contents sheet says it. Most sheets take a refund off the day its order was placed, so they will not tie to a Shopify report. The Bookkeeping and Refunds & Returns sheets count a refund on the day it was issued, the way Shopify does. If the file is for your accountant, the Bookkeeping report is the one built for that.

Blanks are not zeros. On the Profit & Loss sheet, any figure that could not be calculated shows a dash rather than a zero. A dash means unknown, not none. It is worth saying out loud when you send the file, because on screen there is a sentence explaining why, and in a spreadsheet there is only the dash.

What your plan includes

The list only offers tools you can open in the app. If you are on a team seat, it only offers the tools your account owner has given you. If a sheet could not be loaded, the Contents sheet says so rather than leaving it out without a word.

Was this guide helpful?

CONTACT

Still stuck? Ask a person.

Tell us what’s happening and we’ll reply by email, usually the same day. Signed in to Aplon? The help button inside the app is quicker: it sends your store and plan with the message.

Send a Message