Finance in practice
Stripe Reconciliation: Why Payouts Don’t Match Your Ledger
Stripe reconciliation helps you trace payouts, fees, and refunds to your accounting ledger before unresolved differences delay month-end close.
The problem
Your customers paid. Stripe sent the money. The deposit is in the bank. Yet when you sit down to close the month, the numbers in your accounting ledger still don’t tie out. Stripe reconciliation starts with finding out where those numbers stopped lining up.
That can hold up a decision at a growing software company. For example, the founder may need to know whether there’s room for the next hire. Meanwhile, finance is still checking which invoices were paid, where the fees went, and whether the books reflect all of last month’s activity.
Stripe reconciliation connects three records: what happened in Stripe, what arrived in the bank, and what was recorded in the accounting ledger. When those records agree, you can explain the deposit and get on with the close.
Why Stripe reconciliation starts with the payout
A payout can combine several customer payments and reflect refunds, processing fees, and other adjustments. It can also reach the bank in a different month from the underlying payments. As a result, comparing a month’s invoices directly with its bank deposits can leave a difference even when the records are correct.
For example, suppose customers pay $10,000 through Stripe in November. After $500 in refunds and $300 in processing fees, $9,200 is still in Stripe on November 30.
At the November close, finance traces the $9,200 to the Ending balance reconciliation section of Stripe’s payout report. The team then checks that the accounting ledger includes it in the Stripe balance.
On December 2, the $9,200 arrives in the bank. Finance then matches the deposit to the payout and records the transfer from the Stripe balance to the bank account. If the underlying sales were already recorded, booking the deposit as a new sale would count them twice.
| Debit | Credit |
|---|---|
November customer payments$10,000 | November refunds$500 November processing fees$300 Dec. 2 transfer to bank$9,200 |
| Debit | Credit |
|---|---|
Dec. 2 deposit from Stripe$9,200 |
Common reasons Stripe payouts don’t match
The checks below help you find the source of an amount that doesn’t tie out or a deposit you can’t locate.
| Possible cause | Where to look |
|---|---|
| Batched payments | For automatic payouts, open the itemized Payout reconciliation report to see the transactions Stripe grouped into that payout. The batch can also include payments made before the report’s date range. |
| Stripe fees | Compare the gross, fee, and net amounts in the itemized report. Check whether the fees are recorded in the ledger. |
| Refunds and disputes | Look for refunds, disputes, and dispute reversals in the itemized report, then trace those adjustments to the ledger. |
| Currency conversion | Match the deposit to the payout in its settlement currency. For example, if a USD charge settles in CAD, use the CAD payout amount. |
| Timing differences | Find the payout by Stripe’s estimated arrival date and compare it with the bank’s posting date. At month-end, also check Ending balance reconciliation for transactions that hadn’t settled by the cutoff. |
| Wrong payout report | Use Stripe’s Balance report for manual payouts. For instant payouts, reconcile against your Stripe transaction history because Stripe can’t identify which transactions each payout includes. |
| Missing deposit | If Stripe shows the payout as paid, verify the destination bank account and expected arrival date. If five business days have passed since that date, ask your bank to trace the payout. Provide the exact amount and the Trace ID, if available. |
| Failed payout | Check the payout’s status in Stripe. Failed automatic payouts appear in the Failed payouts section of the Payout reconciliation report for the selected period. |
How Stripe reconciliation works at month-end
Start with one payout you can see on the bank statement. Then use Stripe’s itemized Payout reconciliation report to see which transactions make up an automatic payout. For manual payouts, start with Stripe’s Balance report instead.
| Check | What to verify |
|---|---|
| Bank deposit | Match the payout amount to the deposit. Check when it landed if the dates cross month-end. |
| Ledger | Trace payments, refunds, and fees to the ledger. Then look for missing or duplicate entries. |
| Stripe balance | Use the Balance report to check the full month. Opening Stripe balance + net activity − payouts = ending Stripe balance. Then compare the ending balance with the Stripe clearing account in your ledger for the same period and currency. |
| Open items | Explain what’s still in Stripe or on its way to the bank. Finally, give each unexplained difference an owner and a due date. |
Who should own Stripe reconciliation?
After tracing one payout, check whether the same issue appears in earlier months. If the team has handled payouts the same way for months, the current close may depend on clearing an older backlog.
If your team rebuilds the same spreadsheet every month, someone needs to own the process from billing to bank deposit to ledger. That means resolving discrepancies as they come up so leadership can see which numbers are ready to use.
How Finalytics can help
Finalytics can help software companies reconcile Stripe payouts and close the month with an accurate ledger. Activities we can tackle include:
- Match payouts to deposits and explain differences.
- Catch up prior months and correct ledger entries.
- Reconcile Stripe each month and resolve open differences.