What Is the Shopify Payment Transactions Export?
The Shopify Payment Transactions Export gives you a detailed record of the financial movements processed through Shopify Payments. It brings transaction dates, transaction and source types, order references, payout details, amounts, fees, and net values into one export for your selected reporting period.
Use it to investigate the entries behind a payment total and prepare supporting records for bookkeeping. The detail is organized around transaction entries, so an order can appear more than once when it has multiple related movements. Review the transaction type before treating an entry as a sale or refund.
Report Overview
- Report period
- Choose the date range for your review; check the date basis before comparing exports.
- Data included
- Nine fields covering transaction details, order references, payout timing, and monetary values.
- Best for
- Reviewing individual Shopify Payments entries and preparing transaction records for 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 Payment Transactions?
1. Which movements explain a payment total
Transaction Type and Source Type help you separate sales from refunds and other recorded events. This gives you context before adding up the exported values.
Example: A refund entry appears alongside the original sale for one order.
What you can do: Review each type separately before calculating a combined total.
2. How fees affect individual entries
Amount, Fee, and Net let you inspect the monetary effect of a transaction. Compare similar transaction types when investigating an unexpected net value.
Example: One sale has a lower net value because a fee is recorded.
What you can do: Use the fee and net columns to explain the difference in your bookkeeping records.
3. How transactions relate to payout timing
Transaction Date, Payout Date, and Payout Status help you review when an entry occurred and the payout information recorded against it.
Example: A transaction recorded near month end has a payout date in the following month.
What you can do: Keep transaction-period and payout-period reviews separate when comparing records.
What Should You Check First in This Report?
Start with these checks before using the export for a reconciliation review.
- Date basis: Confirm whether the selected period applies to Transaction Date or another configured date field.
- Transaction classifications: Inspect Transaction Type and Source Type before grouping or totaling entries.
- Monetary values: Review Amount, Fee, and Net together, retaining negative values and any adjustment entries.
- Payout details: Check Payout Status and Payout Date; a recorded payout date alone does not confirm that your bank received the funds.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Investigating a transaction amount | Review Amount, Fee, and Net for the same entry. |
| Checking a refund against an order | Use Order Name and Transaction Type to locate relevant movements. |
| Reviewing entries around month end | Compare transaction dates with associated payout dates. |
| Preparing records for your accountant | Export a consistent set of transaction details for a selected period. |
| Investigating an unexpected payout total | Review underlying transactions and payout details before comparing with a separate payout statement. |
How to Create This Report in Data Export
Start with the premade template described in your report library as Shopify Payment Transactions Export.
- Open Data Export and locate the Shopify Payment Transactions Export premade report.
- Open the template and review its nine default columns, including payout details and monetary values.
- Choose your reporting period and apply available filters for the entries you want to review. Confirm the date basis.
- Save the report, then generate and download it in the format you need.
- Optionally 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
Use these checks to keep recurring exports consistent and easy to interpret.
01 / PERIODS
Compare matching date ranges and date bases. A transaction period and its related payout period can cover different days.
02 / ENTRY COUNTS
Count transaction entries separately from orders. Multiple rows with the same Order Name do not necessarily represent duplicate sales.
03 / EXPORT SETTINGS
Use Excel or CSV for analysis. Keep signed values intact when importing the file into another spreadsheet or bookkeeping workflow.
04 / DELIVERY
Schedule delivery after your regular review period closes, and restrict recipients to people who need access to financial records.
Frequently Asked Questions
Does this report cover every payment gateway?
The template focuses on Shopify Payments transactions. Do not assume it includes transactions from every gateway used by your store.
Can one order appear more than once?
Yes. An order can have multiple transaction entries, such as a sale and a later refund. Use the transaction classifications to interpret repeated order references.
Is Net the same as profit?
No. Net is the monetary value recorded for a payment transaction after its applicable fee treatment. The report does not include the product costs and other expenses needed to calculate profit.
Can this report confirm that a payout reached my bank?
It shows the recorded payout status and date. Compare the relevant entries with your payout statement and bank records to confirm receipt; the report does not include bank statement data.
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.