Cash Reconciliation: A Step by Step Guide
Quick answer: Cash reconciliation is process of verifying that every cash account in your books matches its external source: bank statements for checking and savings, processor reports for merchant accounts, physical counts for petty cash. It's broader than bank reconciliation, which covers a single bank account. Cash reconciliation covers all accounts that hold or process cash, and confirms your total cash position is accurate.
When someone asks "how much cash do we have," answer pulls from every cash account business owns. The checking account. The savings account. The money market fund. The Stripe balance. The PayPal balance. Petty cash in office drawer.
Bank reconciliation verifies one of those. Cash reconciliation verifies all of them.
I've seen founders quote their checking account balance when asked about cash, forgetting $40,000 sitting in a Stripe pending balance and $15,000 in a savings account nobody connected to QBO. Their actual cash position was 40% higher than number they gave board. The opposite happens too: a founder quotes total bank deposits without subtracting Stripe processing fees, PayPal hold, and petty cash that was spent but never recorded.
Cash reconciliation fixes this. Every dollar that business owns in liquid form gets verified against an independent source. This guide covers what cash reconciliation is, which accounts are included, how to do it account by account, and a worked example.
What is cash reconciliation
Cash reconciliation is process of verifying that cash and cash equivalents balance on your balance sheet matches actual cash held across all accounts. Investopedia defines cash and cash equivalents as assets that are cash or can be converted to cash immediately, including bank deposits, money market funds, and short-term government bonds.
For most small businesses and startups, cash and cash equivalents include:
Cash reconciliation means reconciling every account on that list, not just primary checking account. The sum of all reconciled cash accounts should equal cash and cash equivalents line on your balance sheet.
Why cash reconciliation is more than bank reconciliation
Bank reconciliation is one piece of cash reconciliation. It's biggest piece for most businesses (checking accounts hold majority of cash), but it's not only piece.
If you only reconcile bank accounts and skip Stripe balance, PayPal balance, and petty cash, your cash position on balance sheet is unverified for those accounts. An audit will catch it. A cash crunch will expose it faster.
How to do cash reconciliation: account by account
Checking and savings accounts
This is standard bank reconciliation process. In QuickBooks Online, go to Accounting > Reconcile, select account, enter ending balance from bank statement, and check off matching transactions. The output is a reconciliation statement for each account.
For US businesses, checking and savings accounts at FDIC-insured institutions are insured up to $250,000 per depositor, per institution. If your startup holds more than $250,000 in cash (common post-fundraise), you should spread it across multiple banks or use a sweep network. Each account needs its own monthly reconciliation.
Common issue: Multiple checking accounts at same bank (operating account + payroll account + tax reserve account). Each one needs a separate bank rec. Don't consolidate them into one reconciliation.
Stripe and payment processor accounts
This is where cash reconciliation gets complicated for businesses that accept online payments. Stripe (and similar processors) introduce three timing gaps:
Gap 1: Gross vs. net. Your books might record a $100 sale at gross. Stripe deposits $97.10 after fees. The $2.90 difference is a processing fee that needs to be recorded.
Gap 2: Payout timing. Stripe batches payouts. A sale on Monday might hit your bank account Wednesday or Thursday. At month-end, transactions processed in last 2 to 3 days may not have been paid out yet. That pending balance is cash you own but your bank doesn't show.
Gap 3: Refunds and chargebacks. A refund processed in Stripe reduces next payout. If you recorded original sale as revenue, refund needs to be recorded and payout amount recalculated.
How to reconcile Stripe:
- Pull Stripe payout report for month (from Stripe dashboard)
- Match each Stripe payout to corresponding bank deposit
- Verify payout amount equals gross transactions minus fees minus refunds for that batch
- Record any Stripe balance still pending at month-end as "Cash in Transit" or "Funds in Transit" (a current asset)
For multi-processor setups (Stripe + PayPal + Amazon), see multi-processor reconciliation guide. For Stripe-specific reconciliation, see Stripe bank reconciliation guide.
Petty cash
Petty cash is a small amount of physical cash kept on-site for minor expenses (postage, office supplies, delivery tips). In US, most businesses keep $100 to $500 in petty cash.
How to reconcile petty cash:
- Count physical cash in petty cash box
- Add up all receipts for expenses paid from petty cash during period
- Cash count + total receipts should equal original petty cash fund amount
- If total is short, difference is either a missing receipt or a cash handling error
Cash reconciliation example for petty cash:
The $3.50 shortage is recorded as "Cash Over/Short" expense. It's a small but real discrepancy that should be tracked. Persistent shortages indicate a controls problem.
In QBO, petty cash is tracked as a separate "Cash on Hand" or "Petty Cash" account (account type: Bank). Record expenses as they're paid from petty cash, and replenish fund when it runs low.
Money market and sweep accounts
Post-fundraise startups often hold excess cash in money market accounts or use bank sweep networks that distribute cash across multiple institutions for FDIC coverage. These accounts:
- Earn interest (record monthly as interest income)
- May have transaction limits (6 withdrawals per month under some US banking regulations)
- Require monthly reconciliation against broker or bank statement
The reconciliation process is same as a bank account. Compare book balance to statement balance, identify differences, adjust.
Cash registers (retail and hospitality)
For businesses with physical point-of-sale locations, cash register is a cash account that needs daily reconciliation.
Daily process:
- Run end-of-day POS report (total cash sales)
- Count cash in register
- Cash in register minus starting float should equal cash sales for day
- Differences are recorded as cash over/short
At month-end, cumulative cash from register reconciliation should match cash deposited in bank plus any cash held on-site.
The consolidated cash reconciliation
After reconciling each individual account, build consolidated view. This is what tells you your actual cash position.
The adjusted total ($493,766.50) is verified cash position. That number should match cash and cash equivalents line on balance sheet. If it doesn't, there's an account missing from reconciliation or an adjustment that wasn't recorded.
This consolidated view is what CFO uses to report cash position to board. It's what startup financial modelconnects to for runway calculations. And it's what auditor verifies during cash confirmation procedures.
Cash reconciliation form: what to document
The cash reconciliation form for each account should include:
The "Reviewed by" field matters for audit purposes. Cash is a high-risk area. Having a second person review reconciliation is a basic internal control that auditors expect to see. This is especially relevant for businesses preparing for their first formal audit, as covered in audit risk assessment guide.
Common cash reconciliation mistakes
Forgetting processor balances. Stripe, PayPal, and Square all hold cash. If these accounts aren't in your chart of accounts and reconciled monthly, cash on your balance sheet is incomplete.
Netting processor fees incorrectly. If Stripe pays out $9,710 and your books show $10,000 in sales, $290 difference is processing fees. Some bookkeepers record net deposit ($9,710) as revenue, which understates both revenue and expenses. Record gross revenue ($10,000) and a separate processing fee expense ($290).
Ignoring small accounts. A $300 petty cash fund seems immaterial. But if nobody reconciles it for a year, fund might contain $50 in cash and $200 in unrecorded receipts, with $50 unaccounted for. Multiply that across 5 locations and it's a $250 unexplained difference that auditor will question.
Not reconciling day before a board meeting. When CEO says "we have $500K in cash" to board, that number should be current and verified. Running cash reconciliation week of board meeting (not just at month-end) ensures reported number is accurate.
Mixing restricted and unrestricted cash. If you have a security deposit held in a separate savings account, or a debt covenant requires a minimum cash reserve, that money is restricted. It's still cash, but it shouldn't be included in "available cash" when calculating runway. Separate restricted cash in your chart of accounts and your reconciliation.
How Finlens handles cash reconciliation
Finlens connects to all cash accounts through QBO and bank feeds, reconciles transactions automatically, and produces consolidated cash position in real-time. For payment processors like Stripe, Finlens matches payouts to deposits and flags fee discrepancies without manual comparison.
For accounting firms managing cash reconciliations across multiple clients, each client's full cash position (all accounts, all processors) is visible in one view. The bookkeeper reviews unmatched items instead of pulling reports from 5 different bank portals.
The consolidated cash table shown above updates automatically as each account is reconciled. The controller knows verified cash position at any point during month, not just after monthly reconciliation statement is complete.
FAQ
What is cash reconciliation?
Cash reconciliation is process of verifying that every cash account in your books (checking, savings, merchant processors, petty cash, money market) matches its external source. It's broader than bank reconciliation, which covers one bank account at a time.
What is a cash reconciliation?
A cash reconciliation is completed verification of a cash account balance. It compares book balance in your accounting system against bank statement, processor report, or physical count, identifies differences, and shows that adjusted balances match.
How do you do a cash reconciliation?
Account by account. Reconcile each bank account against its statement. Match each Stripe/PayPal payout to its bank deposit. Count petty cash and compare to receipts. Then build consolidated view showing all cash accounts and their reconciled balances. The total should match balance sheet.
What's difference between cash reconciliation and bank reconciliation?
Bank reconciliation verifies one bank account against its statement. Cash reconciliation verifies all cash accounts (bank accounts + payment processors + petty cash + money market). Bank reconciliation is a subset of cash reconciliation.
How often should cash reconciliation be done?
Monthly for bank and savings accounts. Monthly for payment processor balances. Daily for petty cash and cash registers. The consolidated cash position should be verified monthly at close and before any board meeting.
What is a cash reconciliation form?
A document that records reconciliation details for each cash account: account name, period, source balance, book balance, reconciling items, adjusted balance, and sign-off by preparer and reviewer.
