Payout reconciliation report
The payout reconciliation report gives you a detailed breakdown of your Shopify Payments balance activity, including transactions, fees, refunds, chargebacks, adjustments, and payouts, for a selected date range and payout currency. You can use the report to understand how funds moved through your Shopify Payments account, and reconcile those amounts with your bank deposits.
Your Shopify Payments payouts might not match your sales totals because payouts reflect balance activity after deductions, holds, currency conversion, and adjustments. The report reflects funds that you received through Shopify Payments. The report isn't a statement of revenue for accounting purposes. Revenue in your Finance reports is based on orders and sales activity, which might not match the timing or totals in the payout reconciliation report.
On this page
Requirements for viewing the payout reconciliation report
Review the following requirements before you use the payout reconciliation report:
- You must use Shopify Payments as your payment provider.
- You must be the store owner, or a staff member with permission to view payouts.
If you sell in multiple currencies and receive payouts in multiple currencies, then select the payout currency that you want to reconcile. Each currency has a separate report.
Understanding the payout reconciliation report
Before you view or export the payout reconciliation report, review how the report organizes your Shopify Payments balance activity.
Summary section
The Summary section of the payout reconciliation report displays how your Shopify Payments balance changed during the selected date range.
| Field | Description |
|---|---|
| Starting balance | Your Shopify Payments balance at the start of the selected date range. |
| Balance change from activity | The net change to your balance from transactions and fees during the date range, before payouts. |
| Account activity before fees | The total gross amount from balance activity before fees are deducted. |
| Fees | The total fees deducted from your balance during the date range. |
| Net amount | The net change from activity after fees. |
| Total payouts | The total amount paid out from your Shopify Payments balance to your bank account during the date range. |
| Ending balance | Your Shopify Payments balance at the end of the selected date range. |
Activity section
The Activity section of the payout reconciliation report lists Shopify Payments balance activity grouped by type. Each group displays a gross amount, fees, and net amount. You can expand a group to review individual line items, such as card payments, refunds, or processing fees.
The report can include the following activity groups when they apply to your store during the selected date range.
| Activity group | Description |
|---|---|
| Charges | Payments that customers made using Shopify Payments, including related processing fees. |
| Refunds | Refunds issued to customers and related fee adjustments. |
| Disputes | Chargebacks, dispute holds, dispute fees, and related adjustments. |
| Managed Markets | Balance activity related to Managed Markets. |
| Adjustments | Manual or system balance adjustments. |
| Shopify Capital | Activity related to Shopify Capital remittances and funding. |
| Duties & Taxes | Import taxes, customs duties, and related tax adjustments. |
| Installments Recovery | Balance recovery activity related to Shop Pay Installments. |
| Internal Transfers | Internal balance transfers within your Shopify Payments account. |
| Fees | Other fees that aren't grouped under another activity type. |
| Promotions & Credits | Promotional credits and goodwill credits applied to your balance. |
| Reserves & Holds | Reserved funds, risk holds, and related reversals. Learn more about reserves and holds. |
| Shipping | Shipping label charges and related adjustments. |
| Shop Cash | Activity related to Shop Cash. |
| Shopify Collective | Activity related to the Shopify Collective app. |
| Payouts | Funds transferred from your Shopify Payments balance to your payout bank account. |
| Other | Balance activity that doesn't match another activity group. |
Reserves and holds in the payout reconciliation report
The payout reconciliation report includes reserves and holds as separate line items in the Reserves & Holds activity group. Reserved or held funds remain in your Shopify Payments balance until they're released or paid out. These amounts represent funds that Shopify is holding on your behalf, not revenue from new sales.
If you have questions about a specific reserve or hold, then refer to Shopify Payments reserves and account holds.
View the payout reconciliation report
You can access the payout reconciliation report from the Finance page of your Shopify admin.
Steps:
Desktop
From your Shopify admin, go to Finance.
Click Documents.
Click Payout Reconciliation Report.
Optional: To change the report's date range, select Last month, Last 3 months, Last 6 months, or Other to choose a custom range. Custom date ranges are available from January 1, 2025 onward.
Optional: To change the payout currency, select the currency that you want to review. The currencies that are available depend on the payout currencies that your store uses.
Mobile
From the Shopify app, tap the
icon.Tap Finance.
In the Finance section, tap
.In the Documents menu, tap Payout Reconciliation Report.
Optional: To change the report's date range, select Last month, Last 3 months, Last 6 months, or Other to choose a custom range. Custom date ranges are available from January 1, 2025 onward.
Optional: To change the payout currency, select the currency that you want to review. The currencies that are available depend on the payout currencies that your store uses.
Export the payout reconciliation report to PDF
You can export the report that you're viewing to a PDF file. The PDF includes the same Summary and Activity information that displays in your Shopify admin.
Steps:
- On the Payout Reconciliation Report page, set the date range and payout currency that you want to export a report for.
- Click Export to PDF.
Reconciling with other reports
You can use the payout reconciliation report together with the following financial reports and payout tools:
- Finance reports display sales and payment activity based on orders and captured payments. These reports might display different totals or timings than the payout reconciliation report.
- The Payouts page displays individual payouts and lets you export payout transactions to CSV. Use the payout reconciliation report when you need a reconciled summary across a date range. Use the Payouts page when you need order-level detail for a specific payout.
- Lower or missing Shopify Payments payouts explains common reasons why a specific payout might be lower than expected or missing from your bank account.
Troubleshooting report discrepancies
If the totals in the payout reconciliation report don't match another report or your bank deposits, then review the following common causes:
- Different date ranges: Finance reports and payout exports might use different date ranges or time zones than the payout reconciliation report.
- Payout timing: The report reflects captured transactions and fees, not individual payouts to your bank account. Because payout timing follows a separate schedule, the report totals for a given date range might not match your bank deposits for the same period. Also, the report has a 3-day data delay, so recent captured transactions might not appear immediately.
- Currency: Make sure that you're comparing amounts in the same payout currency.
- Third-party payment methods: Payments processed outside Shopify Payments, such as third-party buy now, pay later providers, aren't included in this report.
- Revenue vs funds received: Finance reports reflect sales and payment activity. The payout reconciliation report reflects balance activity and payouts from Shopify Payments.
If you've reviewed these factors and the report still doesn't match your records, then contact Shopify Support.