Payout Reconciliation for Bank Deposits, Payment Providers, and Export Files
Broader payout reconciliation guide for bank deposits, payment providers, marketplaces, and platform export files. Review payout-level vs transaction-level differences before accounting review.
Payout reconciliation means comparing payout records from payment providers, marketplaces, or platforms with the actual deposits shown in your bank statement.
A payout may include multiple payments, fees, refunds, disputes, tax, adjustments, reserves, currency conversion, or timing differences. That is why payout-level data usually does not match individual transaction-level rows one to one.
Try with sample files | View sample report
Why payouts often do not match individual payments
- The bank deposit is usually a net payout, while dashboards often highlight gross transaction totals.
- One payout can include many payments, refunds, disputes, fees, reserves, and adjustments from different dates.
- Payout date and bank deposit date can differ even when the payout is correct.
- Currency conversion, reserve holds, and weak references can create a possible payout difference that still needs review.
- A local file review workflow is safer than forcing unsupported explanations into one spreadsheet formula.
Numeric examples
| Line item | Amount or note |
|---|
| Gross payments | $2,500.00 |
| Refunds | -$200.00 |
| Processing fees | -$78.50 |
| Adjustment | -$10.00 |
| Expected payout | $2,211.50 |
| Bank deposit | $2,211.50 |
| Provider payout report | $1,420.00 |
| Bank deposit under review | $1,395.00 |
| Possible payout difference | $25.00 needs review |
What files to export
- Payout report from the provider or marketplace with payout ID, payout date, net payout amount, status, and payout-level references.
- Transactions or activity export with gross payments, transaction IDs, and activity rows that explain what sits inside the payout.
- Refunds, disputes, or adjustments export when the main payout file does not fully explain the payout reduction.
- Bank statement CSV/XLSX with deposit date, amount, and bank description for the deposit you are reviewing.
- Optional order or invoice export when you also need customer-facing references behind a provider payout.
Manual workflow
- Export payout and transaction data.
- Export the matching bank statement period.
- Identify payout IDs, payout dates, and bank deposit dates.
- Compare gross payments, fees, refunds, adjustments, and net payout.
- Match the expected net payout to the bank deposit.
- Flag amount differences, possible grouped payments, and unknown deposits.
- Review unresolved rows manually.
- Export a final reconciliation report.
How Reconcile Locally helps
- Reviews bank, payout, order, invoice, and provider CSV/XLSX exports locally in the browser.
- Highlights clear matches without hiding amount differences and review rows.
- Shows unknown bank payments, unpaid items, and possible grouped payments in one workflow.
- Exports a reconciliation report with matched rows first, review rows next, and unresolved cases kept visible.
What still needs manual review
- Exact fee, tax, refund, reserve, and currency conversion breakdowns may still require manual review depending on the available exports.
- Some payout differences stay as amount differences or needs-review rows until another export confirms the cause.
- Reconcile Locally is a reconciliation review tool and should not be treated as a full accounting automation workflow.
Frequently asked questions
What does payout reconciliation mean?
It means comparing payout records from payment providers, marketplaces, or platforms with the deposits that reached your bank statement, then reviewing the transactions behind the net payout.
Why does a bank deposit not match individual payments?
Because the deposit is usually a payout-level net amount after fees, refunds, disputes, reserves, tax, adjustments, currency conversion, or timing differences. Individual payments are transaction-level rows.
Can one bank deposit relate to multiple records?
Yes. A single deposit can reflect many transactions or a possible grouped payment, so it may need payout-level review rather than one-to-one matching.
Common payout sources
Start with the provider, marketplace, or platform that created the bank deposit.
Common issues and review categories
Use these pages when the payout amount, payout timing, or bank deposit reference still does not make sense.
Related guides
Use these broader guides when you need a bank-first, ecommerce-specific, or sample-report view.