Shopify Payout Report: How to Find and Export It

Shopify publishes two payout reports, not one. The payout reconciliation report lives at Finance, then Documents, then Payout Reconciliation Report, and gives you a period summary of starting balance, activity, fees, payouts, and ending balance, exported as a PDF. The balance transactions export lives at Settings, then Payments, then View payouts, then View Transactions, and gives you a CSV with amount, fee, and net for every individual transaction. Most sellers only ever find the second one, then wonder why the numbers do not tie out. Here is how to pull both, what each column means, and how to make the total agree with your bank.

This guide covers US stores on Shopify Payments. If the money has not arrived at all, the guide to a Shopify payout stuck on pending covers that case, and the Shopify payout schedule explains the normal timing.

Where is the Shopify payout report?

Shopify moved reporting around enough over the years that most of the advice you will find points at a menu that no longer exists. As of August 2026 there are two live paths and they produce different documents.

Which one you want depends on the question. If your accountant asked for a monthly summary, take the reconciliation report. If you are chasing a specific deposit that does not match, take the CSV.

How to get the Shopify payout reconciliation report

This is the document Shopify built specifically to answer "how did money move through my account this month," and it is the one almost nobody opens.

1. In the Shopify admin, open Finance, then Documents, then Payout Reconciliation Report.
2. Choose a date range. The quick options are last month, last 3 months, and last 6 months. Custom ranges are available from January 1, 2025 onward, so anything earlier has to come from the transactions export instead.
3. If you sell in more than one currency, select the payout currency. Each currency is grouped and reported separately.
4. Read the summary block before anything else.
5. Click Export to PDF to download the summary and activity sections.

The summary block is seven lines, and once you understand them the rest of the report is detail:

Below the summary, the activity section breaks the same money out by type: charges, refunds, disputes, adjustments, duties and taxes, reserves and holds, shipping, Shopify Capital, Shop Cash, Shopify Collective, promotions and credits, internal transfers, installments recovery, Managed Markets, and payouts. That list is worth reading once even if you never use it again, because it names every category of thing Shopify can do to your balance, and one of them is usually the reason your month looks strange.

The one catch: the report has a 3-day data delay. A transaction captured yesterday will not appear. If you pull the report on the 1st for the month just ended, the last few days of that month may still be missing, which is the single most common reason a seller decides the report is wrong. Wait until the 4th or 5th.

How to export Shopify payout transactions to CSV

The reconciliation report exports as a PDF, which is fine for handing to an accountant and useless for arithmetic. When you need a spreadsheet, use the transactions export.

1. Go to Settings, then Payments.
2. Click View payouts, then View Transactions.
3. Filter as needed. You can filter by transaction type, payout status, payment method, card type, transaction date, payout date, and currency. Filtered searches can be saved, which is worth doing if you reconcile monthly.
4. Select your date range and CSV type, then click Export balance transactions.

The file does not download in your browser. It is emailed to you and to the store owner, which catches people out the first time. Check your inbox, not your downloads folder.

The export carries roughly eleven columns: transaction date, type, order number, card brand, source, payout status, payout date, available-on date, amount, fee, and net. Three of those do the real work.

The mistake that costs money is recording Net as income. Net is already reduced by fees, and Shopify reports your gross to the IRS on Form 1099-K. Report gross as income, deduct the fees as an expense, and you land on the same taxable profit while your books agree with the form the IRS already holds.

How to read the Shopify payout fees report

There is no document actually named "fees report," which is why searching for one goes nowhere. Fees show up in two places and the right one depends on the granularity you need.

For a monthly total, the Fees line in the reconciliation report summary is your number, and the Fees section in the activity breakdown shows what made it up. For fees per sale, the Fee column in the transactions CSV is your number, and summing it for a payout date gives you the fee total for that specific batch.

Worth knowing what is and is not in that column. Shopify Payments processing in the US is 2.9% plus $0.30 on online credit card orders for stores on the Basic plan at $39 a month, and the percentage drops on higher plans. That is what lands in the Fee column. Your monthly Shopify subscription, your app subscriptions, your shipping label purchases, and third-party gateway fees are not in the payout report at all, because they are not deducted from the payout. They bill separately. If you are building a true cost picture rather than reconciling a deposit, you need those from your Shopify invoices as well, and the breakdown of Shopify fees covers the full list.

Making the report agree with your bank deposit

Here is the whole reconciliation in six lines. Take the deposit amount off your bank statement. In the transactions export, filter by payout date rather than transaction date. Sum the Net column for that payout date. The total should equal the deposit exactly. If it does not, the difference is a refund dated outside your filter, a dispute, or a reserve movement, and all three appear by name in the activity section of the reconciliation report.

Filtering by transaction date instead of payout date is the error behind most "the report is wrong" complaints. A payout on Thursday settles transactions captured Monday and Tuesday, so filtering to Thursday's transactions returns a completely different set of sales from the batch Thursday actually paid.

Once the batch ties out, the entry in your books is gross to sales income, fees to expense, net matched against the bank line. If you would rather a tool posted that entry for you, connectors like A2X (from US$29 a month per sales channel) and Synder ($65 a month on Basic) build the split journal entry automatically into QuickBooks Online or Xero. And if your bank hands you statements in an older format your accounting software refuses to read, you can turn a Quicken QIF file into a clean QBO import rather than retyping the transactions by hand. The full comparison of what each of these tools reconciles, and what none of them cover, is on our payout reconciliation page.

What the Shopify payout report will not tell you

Three things, and they matter more than they sound.

It stops at Shopify. If you also sell on Etsy, run a Patreon, take sponsor invoices through Stripe, or sell digital products on Gumroad, none of that is in this report and none of those platforms publishes an equivalent one. Etsy gives monthly statements. Patreon and Gumroad show a running balance. There is no cross-platform version of the reconciliation report, which is why sellers running three or four income sources end up rebuilding one by hand in a spreadsheet each month.

It is backward-looking by design. The report tells you what settled. It does not tell you what is coming, when it lands, or what you should expect next month, and with a 3-day delay it does not even tell you about this week.

It does not compare anything. Knowing Shopify paid you $18,400 net last month is useful. Knowing that Shopify netted 91 cents on the dollar while Etsy netted 78 after Offsite Ads is what changes how you spend your time, and no single-platform report can show you that. That comparison is what the Shopify payouts tracker and the platform fees calculator are built for, alongside the payout calendar for expected pay dates across every platform at once.

A monthly routine that takes ten minutes

Pull the reconciliation report after the 4th so the 3-day delay has cleared. Export the transactions CSV for the same period and save it somewhere permanent, because custom ranges only reach back to January 1, 2025 and one day you will need older data. Sum Net by payout date and tick off each deposit against the bank. Post gross to income and fees to expense, not net to income. Then note the fee percentage for the month, because a number that drifts up is telling you something about your product mix, your refund rate, or your Offsite Ads exposure long before your profit and loss does.

Do that twelve times and tax season stops being an archaeology project. Skip it and you will spend a February afternoon trying to work out why a 1099-K says you earned $9,000 more than your bank account ever saw.