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.

The problem

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.

Net payouts

One deposit, hundreds of charges

Stripe pays out net of fees, refunds and disputes, so the bank deposit never equals the sales you recorded.

Timing

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.

Leftovers

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.

How it works

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.

  1. 01 · Rule

    Normalize

    Bank, Stripe and ledger lines are cleaned into one shape: sign, currency, dates and counterparty.

  2. 02 · Rule

    Exact

    Shared IDs and references first, such as the Stripe payout ID in the bank memo or an invoice number.

  3. 03 · Rule

    Payout

    Each payout is tied to its balance transactions: charges minus fees and refunds. Any residual is explained.

  4. 04 · Rule

    Window

    Same amount within a date window you set (±3 days by default), only when there is exactly one candidate.

  5. 05 · Agent

    Fuzzy

    Similar counterparty and amount. Ambiguous cases go to the Recon analyst with the evidence; anything left becomes an exception.

BillVerge APP · 8:30 AM

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.

Review exceptionsApprove fee journalSnooze to Monday
Example message. Example data.
In Slack

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.

Inputs and outputs

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
Pricing

From $79 a month

Founding-customer pricing$79 /mo1,000 transactions a monthGrowth: $199/mo for 5,000Over plan: $0.04 per transaction

Unlimited users, no setup fee, 14-day free trial. Exceptions is included.

See all pricing
Guides

Related 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 guide

How 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 guide

Why 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 guide
Questions

Common 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.