What Is the Shopify Payout Report?
The Shopify Payout Report in Data Export gives you a payout-level view of the amounts being transferred from Shopify sales. Review the payout date, status, and ID alongside gross charges, gross refunds, gross adjustments, charge fees, and the payout amount for your chosen reporting period.
Use it to prepare payout records for bookkeeping, investigate changes in payout amounts, and organize a regular review of incoming funds. The report summarizes payouts rather than listing the individual orders behind each transfer. Compare its records with your bank statement when checking deposits; a payout date is not confirmation that the funds have reached your bank account.
Report Overview
- Report period
- Choose a date range for each report run.
- Data included
- Eight fields covering payout identifiers, timing, status, and amounts.
- Best for
- Reviewing payout components and preparing records for bank reconciliation.
- Export formats
- Excel, CSV, TXT, JSON, PDF or Google Sheets.
- Automation
- Schedule hourly, daily, weekly or monthly to email, Google Sheets, Google Drive, FTP or SFTP.
What Can You Learn from Your Payout Data?
1. Which payouts need a closer look
Read payout status alongside date and amount to identify records that deserve follow-up. Check the latest payout details before treating an amount as received.
Example: An expected payout still has a status that requires follow-up.
What you can do: Locate the payout in Shopify using its ID and review its current details.
2. Where payout components have changed
Compare gross charges, refunds, adjustments, and charge fees across payouts. These components help you investigate why transfer amounts differ.
Example: A smaller payout also shows a larger refund amount.
What you can do: Review the underlying payout transactions before explaining the difference in your books.
3. Which charge fees need review
The charge fee column keeps these costs visible alongside the payout amount. Compare records with similar charge volumes to spot differences worth investigating.
Example: Two payouts with similar gross charges show different charge fees.
What you can do: Check the transaction breakdown to understand the difference.
4. How to prepare a traceable reconciliation file
Payout IDs, dates, and amounts give you a consistent reference set for comparison with bank records. Review status as part of that comparison.
Example: A bank credit needs to be matched to a payout record.
What you can do: Compare the amount and timing, then retain the payout ID with your reconciliation notes.
What Should You Check First in This Report?
Start with the fields that establish what each payout represents.
- Payout Date and Payout Status: Check timing and the recorded state before including a payout in your received-funds review.
- Payout Id: Keep a unique reference for every payout you investigate or match.
- Payout Amount: Compare the transfer amount with bank records, allowing for differences in posting dates.
- Refunds, adjustments, and charge fees: Review these components when a payout amount changes unexpectedly.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Preparing a bank reconciliation | Collect payout dates, IDs, statuses, and amounts for comparison with bank statement entries. |
| Investigating a lower payout amount | Review charge, refund, adjustment, and fee amounts before checking the underlying transactions. |
| Following up on an expected transfer | Identify the payout record and its recorded status for a focused follow-up in Shopify. |
| Reviewing payout-related charge fees | Compare the recorded charge fees across payouts in your selected period. |
| Sending recurring bookkeeping records | Export or schedule a consistent payout-level file for your bookkeeping review. |
How to Create This Report in Data Export
Use the premade Shopify Payout Report to start with the eight payout fields already selected.
- Open Data Export from your Shopify admin and find the premade Shopify Payout Report.
- Open the report and review the payout date, status, ID, and amount columns.
- Set the reporting period and adjust available filters or sorting for the payouts you want to review.
- Generate the report, check the results, and save it with a recognizable name.
- Download the report, or schedule it hourly, daily, weekly or monthly to email, Google Sheets, Google Drive, FTP or SFTP for yourself or your accountant.
Make the Most of This Report
Keep payout reviews consistent with these four practical checks.
01 / TIMING
Compare payout dates with bank posting dates. Allow for processing time before investigating a transfer as missing.
02 / IDENTIFIERS
Keep Payout Id in every export. Dates alone may not distinguish the payouts you need to investigate.
03 / AMOUNT SIGNS
Check how refund and adjustment signs appear before building spreadsheet calculations. Avoid assuming a universal payout formula.
04 / FRESH RECORDS
Generate a fresh report before resolving an outstanding payout question. A previously saved export preserves an earlier view.
Frequently Asked Questions
Is the payout date the date money reaches my bank?
For Shopify Payments, the payout date is when Shopify sends the payout to your bank. Confirm receipt against your bank records because posting can occur later.
Can this report show the orders behind a payout?
The default fields provide payout-level amounts and identifiers. Individual order details are not included in these eight columns; use the payout ID to investigate the underlying records.
Why can the payout amount differ from gross charges?
Refunds, adjustments, and charge fees are recorded separately from gross charges. Review these components and the payout details rather than treating gross charges as the bank transfer amount.
Can I export and schedule this report?
Yes. Data Export downloads this report as Excel, CSV, TXT, JSON or PDF, and can schedule it hourly, daily, weekly or monthly to email, Google Sheets, Google Drive, FTP or SFTP.
Does the report automatically reconcile my bank account?
It supplies payout records for comparison with bank entries. Matching and confirming bank receipt remain part of your reconciliation process.