BV Recon
Match Stripe payouts, bank lines and your ledger, and see why the rest didn’t
Recon ties each Stripe payout to the charges, fees and refunds inside it, matches bank lines to your ledger, and turns whatever is left into an exception with an explanation.
Early access. Stripe, bank CSV, and QuickBooks Online or Xero by direct sync or CSV export.
Reconciliation is three exports and a lot of lookups
The bank, Stripe and the ledger each tell part of the story. Tying them out by hand is slow, and the hard lines are the ones a spreadsheet cannot explain.
One deposit, hundreds of charges
Stripe pays out net of fees, refunds and disputes, so the bank deposit never equals the sales you recorded.
Dates never line up
Payouts arrive days after the charges and the bank posts them on its own schedule, so simple date-and-amount matching breaks at month end.
The last lines take the longest
What does not match is what needs research: a dispute, a fee, a deposit nobody recorded. That is where the time goes.
Rules first, the agent for the rest
Each pass only takes matches it is sure of. Whatever is left moves to the next pass, and the end of the line is an exception, never a guess.
- 01 · Rule
Normalize
Bank, Stripe and ledger lines are cleaned into one shape: sign, currency, dates and counterparty.
- 02 · Rule
Exact
Shared IDs and references first, such as the Stripe payout ID in the bank memo or an invoice number.
- 03 · Rule
Payout
Each payout is tied to its balance transactions: charges minus fees and refunds. Any residual is explained.
- 04 · Rule
Window
Same amount within a date window you set (±3 days by default), only when there is exactly one candidate.
- 05 · Agent
Fuzzy
Similar counterparty and amount. Ambiguous cases go to the Recon analyst with the evidence; anything left becomes an exception.
Oct 27 bank reconciliation: 241 of 246 lines matched. Five need you:
| 2 payout residuals · dispute fees | $30.00 |
| 1 deposit · no ledger entry | $1,980.00 |
| 2 ledger entries · no bank line yet | $4,115.50 |
Suggested: post the dispute fees to 6150 Merchant fees; ask AR about the $1,980.00 deposit from Halden & Co.
A daily summary, and only the lines that need a person
Matched lines stay out of your way. Unmatched ones arrive with the closest candidates and the reason they did not match.
Anything that would write to your ledger waits for someone on your team to approve it.
What Recon reads and what you get back
Sources
- Stripe balance transactions and payouts (API or CSV)
- Bank statements (CSV)
- Ledger exports from QuickBooks Online or Xero (CSV)
Matching passes
- Exact reference or ID
- Payout to charges, net of fees and refunds
- Amount within a date window
- Counterparty similarity, with an agent tiebreak
Results
- Match rate by account and period
- Every unmatched line as an exception
- Drafted adjusting journals, for approval
From $79 a month
Unlimited users, no setup fee, 14-day free trial. Exceptions is included.
See all pricingRelated guides
How to reconcile Stripe payouts in QuickBooks Online
Record Stripe sales gross, fees and refunds through a clearing account, then match each net payout to the bank deposit in QuickBooks Online.
Read the guideHow to reconcile Stripe payouts in Xero
Set up a Stripe clearing account in Xero, reconcile charges, fees and refunds against it, and treat each payout as a transfer to your bank.
Read the guideWhy your Stripe payout doesn't match your bank deposit
Fees, refunds, disputes, reserves, payout timing and currency conversion: why a Stripe payout differs from what you expected, and how to trace each one.
Read the guideCommon questions
Does Recon post entries to my ledger?
Not on its own. Recon drafts adjusting journals and a person on your team approves them. Once approved, the journal is posted to QuickBooks Online or Xero, and never into a month you have closed in BV Close.
What does the free Payout Reconciler do?
It runs Recon’s payout matching on a Stripe payout report and a bank CSV and gives you a gap report, for up to three payouts a month.
Is Recon available now?
Recon is in early access. Book a demo and we will set it up on one of your real months.
See it on your own data
Book a 30-minute walkthrough, or run the free Payout Reconciler on one of last month’s Stripe payouts first.