What Is the Payout Order Report?
The Payout Order Report connects payout records with the orders and transactions behind them. It brings order sales, discounts, refunds, shipping, transaction amounts, fees and net amounts into one export, helping you investigate how order activity contributes to a payout.
The report runs by Payout Date. Select the settlement period you want to review, then use Payout Id, Source order id and Source Transaction id to trace the underlying records. Order Date remains available so you can see when each associated order was placed, even if it falls outside that payout period.
Report Overview
- Report period
- Selected Payout Date range, with Order Date shown separately.
- Data included
- 17 fields covering payout references, order references, sales and transaction amounts.
- Best for
- Tracing payout entries to orders and preparing reconciliation exports.
- 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 Payout and Order Details?
1. Trace a payout entry back to an order
Use Payout Id alongside Order Name and the source identifiers to investigate which order activity appears within a payout.
Example: A hypothetical payout contains an entry for order #1048 that needs checking.
What you can do: Look up the source order and transaction before resolving the query.
2. See why sales and payout amounts differ
Review sales figures alongside Amount, Fee, Net and Total Refunded. These fields give you specific amounts to investigate when a sales total differs from the payout records.
Example: A hypothetical order has a fee recorded against its payout transaction.
What you can do: Inspect the fee and transaction type before comparing the net amount with sales.
3. Recognize orders settled in a later period
Payout Date and Order Date support different views of the same activity. Looking at both helps explain why a payout includes orders placed in an earlier reporting period.
Example: A hypothetical October order appears in a November payout.
What you can do: Retain both dates in the export so the period difference is clear.
What Should You Check First in This Report?
Start with the date basis and identifiers before adding up financial columns.
- Payout Date: Confirm that the selected range matches the payout period you are reviewing.
- Payout Id and Source Transaction id: Establish which payout and transaction each record belongs to.
- Amount, Fee and Net: Review transaction amounts together, including the signs shown on each entry.
- Repeated order references: Check how sales figures repeat across transaction records before summing order-level columns.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Reviewing the orders behind a payout | Connect payout references to order names and source identifiers. |
| Investigating a sales and payout difference | Review sales figures alongside transaction amounts, fees and refunds. |
| Checking activity across month end | Compare Payout Date with Order Date to explain timing differences. |
| Preparing records for a bookkeeper | Export order and transaction references with the amounts needed for review. |
| Following up on a specific transaction | Use Source Transaction id and Transaction Type to locate the entry in context. |
How to Create This Report in Data Export
Start with the premade Payout Order Report so the relevant fields are already available.
- Open Data Export and find the premade Payout Order Report.
- Open the report and review the payout, order and transaction columns.
- Choose your Payout Date range and apply available filters for the records you need.
- Save the report, generate it and download your preferred export format.
- For recurring reviews, schedule it hourly, daily, weekly or monthly to email, Google Sheets, Google Drive, FTP or SFTP for yourself or your bookkeeper.
Make the Most of This Report
Use these checks to make each payout export easier to review.
01 / PERIOD
Keep both dates visible. Include Order Date when reviewing a payout period that crosses month end.
02 / COUNTING
Check repeated values. An order can be referenced in multiple transaction records; review the structure before totaling sales.
03 / REFERENCES
Preserve source identifiers. Keep payout, order and transaction IDs in spreadsheet exports so entries remain traceable.
04 / DELIVERY
Choose a useful schedule. Send the payout period your bookkeeper needs and check the recipient list before enabling recurring emails.
Frequently Asked Questions
Does this report run by order date or payout date?
It runs by Payout Date. Order Date is a separate column that helps explain when the underlying order was placed.
How can I find the order behind a payout transaction?
Use Payout Id to identify the payout, then review Order Name, Source order id and Source Transaction id to trace the related records.
Is Net Sales the same as Net?
They are separate fields. Net Sales is a sales measure, while Net is recorded with the payout transaction. Review their context before comparing or totaling them.
Can I export and schedule the 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.
Will this report automatically confirm a bank deposit?
It provides payout and underlying order details for reconciliation. Confirm the deposit against your bank records separately; there is no bank confirmation field in this report.