How to Reconcile Stripe Payouts with a Bank Statement in Excel
Stripe reconciliation answers a simple question: does the money recorded in Stripe agree with the cash that arrived in the bank? The process becomes confusing when a single payout contains many customer transactions and the bank statement shows only one net deposit. A structured spreadsheet makes the connection visible.
Gather the source records
Download the bank statement for the period and the relevant Stripe payout or balance reports. Keep the original files unchanged.
Convert the statement to Excel or CSV and save a working copy for reconciliation. Never edit the raw export directly, because you will want something clean to return to when a formula or a sort goes wrong.
Create a payout matching sheet
Use columns such as Bank Date, Bank Description, Bank Amount, Stripe Payout ID, Stripe Payout Date, Payout Amount, Currency, Status, Difference, and Notes.
Match deposits first by exact amount, then by nearby date. Do not require the dates to be identical, because banks often post a payout a day or more after Stripe sends it.
Break down the payout
For each automatic payout, review the transactions included in the settlement batch. Separate gross payments, refunds, disputes, fees, and adjustments. The arithmetic should lead to the net payout amount you see in the bank.
This breakdown is what supports accurate revenue and fee reporting. Recording the deposit as a single revenue line understates both revenue and costs.
Investigate differences systematically
If the bank amount differs from the payout amount, check currency conversion, bank charges, partial deposits, returned payouts, duplicates, and data-entry errors.
Work from the original reports rather than inserting an unexplained adjustment. Leave the item marked unreconciled until the reason is documented.
Useful Excel formulas
A difference column can be a simple subtraction of the payout amount from the bank amount. Use XLOOKUP where payout IDs or unique references are available, and COUNTIFS to flag repeated amount-and-date combinations that could be duplicates.
Formulas speed up review, but they do not replace checking ambiguous matches by hand.
Close the month with controls
Confirm that every bank deposit for the period is either matched or explained. Compare the total of matched bank deposits with the total payout amount for the same scope. Protect formula cells, save a final copy, and retain the source PDF and exports according to your record-keeping policy.
If the deposit itself is what confused you, read what a Stripe deposit on a bank statement means before starting the match.
Frequently asked questions
Can I match payouts using the amount only?
Use amount plus date, currency, destination account, and payout ID where possible. Amount alone produces false matches in busy months.
Why are manual payouts harder to reconcile?
The user controls their timing and amount, so the transaction-to-payout association may require manual work.
Should fees be deducted from sales?
Bookkeeping treatment should normally show gross revenue and processing fees separately. Consult an accountant for your specific reporting requirements.
Use BankConvert to review statement data faster
BankConvert turns bank statement files into structured Excel or CSV data so you can filter descriptions, compare dates and amounts, and support reconciliation. Always verify converted data against the original statement before relying on it for accounting, tax, lending, dispute, or compliance work.
Convert your bank statement and start the payout match in Excel.