Shopify Payout Statements: Your Guide to Printing Detailed Financial Records
Hey everyone! I’ve been diving deep into the Shopify community forums lately, and a recurring theme that keeps popping up is around managing payout statements. Specifically, how to get a complete, printable PDF statement for each individual payout. It seems like the recent UI changes to Shopify Payments and Payouts have left some store owners, like iahmadraza, scratching their heads and looking for that old, convenient one-click print option.
It’s a totally valid concern, especially when you’re trying to keep your books tidy for accounting and record-keeping. The original post laid out exactly what many of you are looking for: a single PDF for each payout, detailing the payout date, amount, order/transaction number, gross amount, fees, and net amount. It’s all about having that clear, comprehensive document for every bank deposit.
The Payout Puzzle: What Shopify Offers Now
After sifting through the excellent contributions from fellow merchants and experts like Report_Pundit1, ecom-4all, and Mustafa_Ali, it’s clear there isn’t a single, magic button that gives you a detailed, per-payout PDF combining summary and all underlying transactions anymore. That said, Shopify does offer a couple of valuable reports, and knowing how to use them can save you a lot of headache.
1. The Shopify Payments Activity Report (Your Accountant's Best Friend)
As ecom-4all and Mustafa_Ali pointed out, for a broader financial overview, you absolutely need to check out the Shopify Payments activity report. This is a fantastic resource, especially for your monthly or quarterly accounting needs.
- Go to Finance > Documents.
- Open the Shopify Payments activity report.
- Set your desired date range and payout currency.
- Hit Export to PDF.
This report provides a great summary: starting balance, gross activity, fees, payouts, net movement, and ending balance for the period. It’s exactly what many accountants need to reconcile your Shopify Payments activity against your bank statements. However, and this is the crucial part, it doesn't give you the order-level breakdown for a *single specific payout*.
2. The Browser Print Workaround (A Quick Fix, But Flawed)
Mustafa_Ali mentioned that you can try using your browser’s print function (Ctrl/Cmd+P) directly on the payout detail page. While it might seem like a quick solution, some users have reported needing manual scaling to fit everything, especially after recent backend changes. It’s not the cleanest PDF, but it might work in a pinch if you just need a quick snapshot.
The DIY Solution: Crafting Your Own Detailed Payout PDF
Since that one-click, per-payout detailed PDF is currently elusive, the community has rallied to provide a robust workaround. Both Report_Pundit1 and Afzal-ubbais shared excellent, detailed steps for creating your own complete per-payout PDF. This method gives you exactly what iahmadraza was asking for: detailed, order-level information tied to each specific bank deposit.
Here’s how you can build a complete, per-payout PDF yourself:
- Navigate to the Payout: In your Shopify admin, go to Finance > Payouts. Select the specific payout date, then click into the individual payout you want to document.
- Export the Transactions: Before you do anything else, make sure to clear any search terms or filters you might have active on that payout page. You want to capture all transactions related to this payout. Then, from the payout details menu, choose Export payout transactions. This will give you a CSV file.
- Open in a Spreadsheet Program: Download and open this CSV file in a spreadsheet program like Excel or Google Sheets. You’ll see columns for payout date, order number, transaction date and type, amount, fee, and net.
- Add a Summary (Crucial for Clarity): At the very top of your sheet, add a clear summary. Include the specific payout date, the actual amount that was deposited into your bank account, and the currency. It’s super important to keep all transaction types in the sheet – sales, refunds, adjustments, chargebacks – so that your final net total accurately matches your bank deposit.
- Format for Printing: Now, get it ready for a clean PDF. Set your page orientation to landscape, and if your program allows, set it to repeat the header row on every page. This makes multi-page reports much easier to read.
- Print or Export as PDF: Once formatted, use your spreadsheet program’s print function (usually File > Print) and choose the option to “Save as PDF” or “Export as PDF.” Afzal-ubbais specifically recommended using “Fit to page width” to ensure no columns get cut off, which is a great tip!
Quick Check: Before you archive that PDF, make sure the “net” total at the bottom of your spreadsheet equals the actual payout amount. If there’s a discrepancy, it’s usually due to a refund, chargeback, or other adjustment that occurred within that specific payout period. This self-check ensures your records are spot on.
When to Look at Apps for Automation
If you find yourself doing this for every single payout, it can definitely get repetitive and time-consuming. Report_Pundit1 correctly pointed out that some reporting apps available on the Shopify App Store can generate these payout reconciliation reports for you. These apps often link each payout to its orders, fees, and refunds, and can export them as PDF or Excel in one go. If this is a regular monthly or even daily task for your bookkeeping, investing in an app might be a smart move to streamline your process.
Making Your Voice Heard
It’s clear from the community discussion that many merchants would love to see a dedicated “one-click Print / PDF statement option per payout” brought back, or perhaps introduced in a more robust way. Report_Pundit1 and Mustafa_Ali both encouraged sending this as a feature request to Shopify Support. The more store owners who share exactly what they need – a summary, every transaction row, order references, fees, refunds, and adjustments all in one clean PDF – the better chance we have of seeing this functionality return or be developed.
So, while there isn’t a perfect out-of-the-box solution for that detailed, per-payout PDF right now, you’ve got solid community-tested methods to get the records you need. Whether it’s leveraging the activity report, doing a little DIY spreadsheet work, or exploring third-party apps, maintaining accurate financial records is crucial for any successful store. Keep those feature requests coming, and let’s keep helping each other navigate the ever-evolving Shopify landscape!