How to Reconcile Stripe Payouts with POS Sales
Card takings and bank deposits never match, because they are not the same number
A day of card sales becomes one bank deposit two days later, smaller than the sales total because the processor took its fee first.
Finance books the deposit as revenue, so takings are understated by exactly the fees and nobody can say by how much.
Refunds and chargebacks net off inside a later payout, making the arithmetic worse rather than better.
Why this happens
- Posting card sales straight to a bank account that will not see the money for days.
- Treating processor fees as a bank charge instead of a cost of the sale.
- No holding account, so money in transit is invisible on the balance sheet.
- Reconciling a date range against a running balance, which cannot agree by construction.
Biznsbook addresses this through Stripe Clearing account, payout posts bank and fees, three-way reconciliation report when the POS module is licensed — terminal and back-office checkout share unified SaleBill posting.
Finance teams lose days each month reconciling versions that should never have diverged. Naming Biznsbook screens as the system of record — and closing periods when agreed — prevents silent edits that auditors flag immediately.
Step-by-step: Reconcile Stripe Payouts with POS Sales
Built for retailers who need a fast till, float discipline, and the same INV-* sale bill in stock and GL — not a standalone cash register.
- Set the payout bank account. In the Stripe Terminal connector settings choose the ledger account Stripe deposits into. Until this is set, payouts are recorded but not posted.
- Let the sale post to clearing. Each card sale debits Stripe Clearing rather than Undeposited Funds. That is money earned but not yet received.
- Let the payout post itself. When Stripe pays out, Biznsbook debits your bank for the net, debits Payment Processing Fees, and credits Stripe Clearing for the gross.
- Open the reconciliation report. Payments → Card payout reconciliation shows captured, refunded, paid out, and the clearing balance, with the variance.
- Clear any unposted payouts. Unposted payouts are almost always a missing bank account. Set it, then press Post on each row.
- Check the Z-report line. The session Z-report shows Stripe captured against the till card total. Balanced means the processor and the till agree for that shift.
Review results after the first full weekly cycle. Adjust roles, mappings, or approvals where the same exception repeats.
Screen-level flows live in the Help Center. This guide focuses on the business process; help articles cover click-by-click navigation.
Common mistakes to avoid
- Mistake 1: Posting card sales straight to a bank account that will not see the money for days. Repeating this each month usually shows up first in cash reconciliation and till speed.
- Mistake 2: Treating processor fees as a bank charge instead of a cost of the sale. Repeating this each month usually shows up first in cash reconciliation and till speed.
- Mistake 3: No holding account, so money in transit is invisible on the balance sheet. Repeating this each month usually shows up first in cash reconciliation and till speed.
- Mistake 4: Reconciling a date range against a running balance, which cannot agree by construction. Repeating this each month usually shows up first in cash reconciliation and till speed.
Track recurring exceptions in month-end notes; each should map to a control above.
Best practices that hold up as you scale
- Set the payout bank account — In the Stripe Terminal connector settings choose the ledger account Stripe deposits into.
- Let the sale post to clearing — Each card sale debits Stripe Clearing rather than Undeposited Funds.
- Let the payout post itself — When Stripe pays out, Biznsbook debits your bank for the net, debits Payment Processing Fees, and credits Stripe Clearing for the gross.
- Open the reconciliation report — Payments → Card payout reconciliation shows captured, refunded, paid out, and the clearing balance, with the variance.
- Clear any unposted payouts — Unposted payouts are almost always a missing bank account.
Teams that open on a named register, park holds, and close with expected cash keep variance disputes short.
How Biznsbook supports this workflow
Stripe Clearing account is documented in Biznsbook POS capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
payout posts bank and fees is documented in Biznsbook POS capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
three-way reconciliation report is documented in Biznsbook POS capabilities. Use it as part of a controlled finance process — posting, review, and period close — not as an isolated export. When Sales, Purchase, Inventory, Taxation, Expense, or Finance Management modules are enabled, related documents can post through the central accounting posting service with double-entry validation.
Sessions, barcode, split tender, X/Z reports, and receipt branding are covered in Docs/POS — use Help Center for click-level screens.
Suggested implementation timeline
- Week 1: Document current process gaps and configure Stripe Clearing account with finance owner sign-off.
- Weeks 2–3: Pilot on one month or one entity; post all test transactions through Biznsbook; freeze parallel spreadsheet journals.
- Week 4: Run first trial balance or report tie-out; fix mapping and permission issues.
- Month 2–3: Roll out to full team; add approvals and period close cadence from this guide.
- Ongoing: Monthly review using the identity to remember and leadership dashboard.
Metrics to track monthly
- Open sessions with a selected POS terminal
- Cash sales with ClientRequestId retries that stay single INV-*
- Parked bills resolved before close
- X-reports run mid-shift without closing
- Terminal Z generated per register/day
Start with three metrics; trend direction matters more than a single point-in-time snapshot.
Spreadsheet / manual books vs integrated ERP
Compare typical manual finance work with Biznsbook Stripe Clearing account and related capabilities.
| Capability | Manual / Spreadsheet | Biznsbook |
|---|---|---|
| Money in transit | ❌ Invisible until it lands | ✅ Stripe Clearing on the balance sheet |
| Processor fees | ❌ Bank charge, found later | ✅ Payment Processing Fees at payout |
| Deposit vs takings | ❌ Manually explained | ✅ Gross, fee, and net posted together |
| Refunds | ❌ Net off inside a payout | ✅ Relieve clearing when they are issued |
| Reconciliation | ❌ Spreadsheet against statements | ✅ Three-way check inside the ERP |
| Tolerance | ❌ Chase every cent | ✅ Agreement within 0.01, matching the ledger |
The identity to remember
Captured, minus refunded, minus paid-out gross, should equal the Stripe Clearing balance. When it does, every card sale, refund, and payout has posted. When it does not, the difference is the amount still unaccounted for — and the reconciliation page usually names the cause.
Document this in your finance SOP and revisit each quarter as transaction volume or entity structure changes.
Frequently asked questions
Why not post card sales straight to the bank?
Because the money is not in the bank yet. Posting it there overstates cash for several days and leaves nothing to match the deposit against when it arrives net of fees.
Do I have to create the accounts myself?
No. Stripe Clearing and Payment Processing Fees are created for you the first time a card payment is started, placed alongside your existing cash and expense accounts.
Why does my variance show a figure?
Most often a payout was recorded but never posted, because the payout bank account was not set. The report names the reason and gives you a Post button.
Why are the totals all-time rather than for my date range?
The clearing balance is a running total, so it can only be checked against all-time captures and payouts. Date-range figures are shown separately as detail.
What happens if a payout fails?
Nothing is posted, because the money never left Stripe and the clearing balance is still correct. The failure is recorded against the payout.
How this differs by industry
Retail
Multi-till shops see one clearing balance across every register instead of reconciling each card machine separately.
Wholesale & distribution
Counter sales paid by card sit in clearing alongside credit terms without confusing the receivables ledger.
Manufacturing
Outlet card takings reconcile on the same basis as the rest of the finished-goods ledger.