Accounting
Financial Management
Cash Reconciliation: How to Reconcile Cash Accounts at Month End
Last updated: October 9, 2026 · Independent guide · We do not sell rankings or coverage.
Cash reconciliation is the month-end check that every cash account in your general ledger agrees with an independent record: the bank statement for bank accounts, the processor settlement report for merchant clearing, the payroll register for payroll accounts, and a physical count for petty cash. You list the differences, sort them into timing items and errors, book the entries the errors require, and have someone other than the preparer review and sign the result. Because so many other accounts depend on cash, it is usually the first balance sheet account you close each month.
For the wider close across all accounts, see our guide to accounting close automation.
The cash reconciliation process at a glance
- Inventory every cash account and assign a preparer and reviewer to each.
- Collect the independent records, cut off at the same date as the ledger.
- Match transactions, automatically where possible and manually for the rest.
- Classify unmatched items as timing differences or errors, and investigate the rest.
- Clear the in-house cash accounts: merchant clearing, undeposited funds, payroll and petty cash.
- Post adjusting entries for bank-side items missing from the books and for book errors.
- Review, sign off and file the evidence so an auditor can reperform the work.
| Stage | Responsible | Accountable | Output |
|---|---|---|---|
| 1. Account inventory | Controller | CFO or owner | Account list with owners and due dates |
| 2 to 4. Collect, match, classify | Staff accountant | Controller | Saved statements and an aged reconciling item list |
| 5. Clear in-house accounts | AR, payroll and office staff | Controller | Clearing balances explained by transaction |
| 6. Adjusting entries | Staff accountant | Controller approves | Posted entries with support |
| 7. Review and sign-off | Controller | CFO for exceptions | Signed, dated package |
Stage 1: Build the cash account inventory
Start with the chart of accounts, not the list of bank logins. Pull every account classified as cash, plus the clearing accounts that hold cash on its way to the bank: operating, payroll, merchant clearing, undeposited funds, petty cash, and any savings or sweep accounts. Record the source, the last four digits of the account number, the preparer, the reviewer and the due date.
The usual failure is an account nobody owns, such as a dormant account at a second bank or a PayPal balance.
Stage 2: Collect bank and source records
Download the bank statement PDF rather than relying on the feed, because the statement carries the bank’s official ending balance. For merchant clearing, pull the processor’s payout report. Stripe’s payout reconciliation report groups the charges, refunds, disputes and fees in each automatic payout, but Stripe says it cannot identify which transactions are in an instant payout, so you reconcile those yourself (Stripe, no date shown).
For payroll, collect the payroll register and the provider’s funding report. For petty cash, the input is a count sheet signed by the custodian and a second person.
Stage 3: Match transactions
Run automatic matching first, then work the remainder by hand. Three traps cause most unmatched lines: one bank deposit that covers several customer payments, processor payouts that arrive net of fees, and checks that clear weeks after you record them.
Never change a ledger amount to force a match. If a recorded check is $1,980 and the bank cleared $980, leave it open and correct the entry in stage 6.
Stage 4: Classify and investigate reconciling items
Bank-side items are timing differences that will clear on their own. Book-side items are transactions the bank recorded that you have not, or errors in your records. Anything you cannot place is unexplained and must be investigated before sign-off.
| Reconciling item | Side adjusted | Action |
|---|---|---|
| Deposit in transit | Bank | Confirm it appears early on the next statement |
| Outstanding check or payment | Bank | Age it and follow up on stale checks |
| Bank fees and interest | Book | Post an entry or set a rule to post it |
| Returned (NSF) customer check | Book | Reverse the receipt and reopen the receivable |
| Processor fees, refunds, chargebacks | Book (clearing account) | Book from the processor report |
| Recording error or duplicate | Book | Correct with a documented entry |
| Unrecognized withdrawal | Neither until resolved | Escalate and notify the bank promptly |
Speed matters for that last row. Under the Uniform Commercial Code, a customer must examine statements with “reasonable promptness,” and one who does not report an unauthorized signature or alteration within one year after the statement is made available loses the claim against the bank (UCC § 4-406, no date shown). Your bank agreement may set shorter notice periods. For stale checks, a bank has no obligation to pay an uncertified check presented more than six months after its date, though it may do so in good faith (UCC § 4-404, no date shown). Contact payees and follow your state’s unclaimed property rules before you void them.
Illustration (constructed numbers). The September 30 statement shows $184,250.00 and the ledger shows $187,075.00.
| Bank side | Amount | Book side | Amount |
|---|---|---|---|
| Balance per bank | $184,250.00 | Balance per ledger | $187,075.00 |
| Add deposit in transit | $12,400.00 | Less bank service fee | ($45.00) |
| Less outstanding checks | ($9,830.00) | Less returned NSF check | ($1,210.00) |
| Add check booked at $1,980, cleared at $980 | $1,000.00 | ||
| Adjusted bank balance | $186,820.00 | Adjusted book balance | $186,820.00 |
The three book-side items become journal entries in stage 6. The reviewer checks next month that the bank-side items cleared.
Stage 5: Clear the in-house cash accounts
Clearing accounts have no bank statement, so unexplained balances build up in them. The target for each is a balance you can explain transaction by transaction.
Operating and payroll accounts
Reconcile the operating account as above and tie each transfer out to the matching entry in the receiving account. A payroll account funded per pay run should hold roughly the total of uncashed paychecks. Match each funding debit to the net pay and tax totals on the provider’s report. A balance that drifts upward usually means voided paychecks that were never reversed.
Merchant clearing
Record gross sales into clearing from the sales system, record fees, refunds and chargebacks from the processor report, and relieve the account by the net payout that reaches the bank. What remains should equal the processor’s unsettled balance. Booking the net payout as revenue is the most common error, because it understates both revenue and fee expense.
Undeposited funds
QuickBooks uses an Undeposited Funds account to hold customer payments until you group them into one deposit that matches the bank’s single entry (Intuit, August 3, 2026). At month end it should hold only the last day or two of receipts. Older items usually mean a payment was recorded twice, once from the bank feed and once from the receipt, which inflates cash and revenue.
Petty cash
Under an imprest system, cash on hand plus receipts must equal the fixed fund amount. Count it at month end with a second person present, book any shortage or overage to its own account, and replenish only from approved receipts.
Stage 6: Post adjusting entries
Post an entry for each book-side item, referencing the bank line or report that supports it. Never post a plug to suspense or miscellaneous expense; an unexplained difference stays on the reconciliation as an open item until its cause is found.
Stage 7: Review, sign-off and evidence
The reviewer confirms that the bank balance agrees to the statement, the ledger balance agrees to the trial balance, every reconciling item has support and an age, and last month’s timing items cleared. The signed package holds the statement or source report, the reconciliation, the item list, the entries, and both names with dates. Save a copy of any system report at sign-off, because some are static: QuickBooks says its reconciliation reports do not reflect later changes (Intuit, September 22, 2026).
This review is a COSO control activity. The 2013 framework says an organization “selects and develops control activities that contribute to the mitigation of risks” and deploys them “through policies that establish what is expected and procedures that put policies into action” (KPMG summary of COSO 2013, no date shown). Where segregation of duties is not practical, management selects alternative control activities (University of Arizona, citing COSO, no date shown), which in a small company usually means an owner review. Our guide to accounting software for internal controls covers the permissions that support this.
Auditors will expect more from your cash work. The AICPA’s SAS No. 150, External Confirmations, requires auditors to perform external confirmation procedures for cash and cash equivalents held by third parties unless certain conditions exist, and accepts direct access to a knowledgeable external source’s information. It amends AU-C 330 and AU-C 505 and takes effect for audits of periods ending on or after December 15, 2028 (Journal of Accountancy, July 14, 2026). Reconcile processor balances to the same standard as bank accounts.
Metrics to track
- On-time completion: share of cash accounts reconciled and reviewed by the close calendar date.
- Auto-match rate: bank lines matched by rules divided by total lines.
- Item age in buckets of 0 to 30, 31 to 60, 61 to 90 and over 90 days, with over-90 items explained in writing.
- Unexplained difference at sign-off, which should be zero.
- Post-close cash adjustments, which point to gaps in review.
How software supports each stage
Bank feeds cover stage 2 and matching rules cover stage 3.
| Product | How it auto-matches | Limit to know |
|---|---|---|
| Xero | Bank rules, suggested matches and JAX automatic reconciliation (Xero, no date shown) | JAX requires the Growing plan or above |
| Dynamics 365 Business Central | Match Automatically with a date tolerance in days (Microsoft, April 7, 2026) | Cannot post many-to-one matches with differences, even if they net to zero |
| Oracle NetSuite | Intelligent Transaction Matching applies rules on import (Oracle, no date shown) | Editing a matched transaction’s amount clears its matched status |
| Sage Intacct | Matching and creation rules, run on import, on feed receipt and every 4 hours (Sage, October 1, 2026) | Feed accounts need a rule set before reconciling |
| BlackLine Transaction Matching | Rules with one-to-one, many-to-one and many-to-many matching (BlackLine, no date shown) | Pricing not published (Vendr, February 2026) |
QuickBooks Online covers stages 3 and 7 for simpler businesses through its Reconcile screen, where the difference should reach zero before you finish (Intuit, September 22, 2026). For how ERPs tie reconciliations into the full close, see our guide to ERP for financial close. No tool removes stage 5: clearing accounts still need someone who understands the sales, payroll and processor data behind them.
How we researched this
On October 9, 2026 we read the top-ranking pages for “cash reconciliation,” including guides from Numeric, Syvantis and Hyperbots, all of which sell reconciliation or ERP products or services. We then checked vendor documentation, the AICPA’s SAS No. 150 announcement, a summary of COSO 2013 and the UCC text. No vendor paid for inclusion.
Related guides
- Positive Pay: How It Stops Check Fraud (2026)
- Prepaid Expense Amortization: Automate the Schedule
- AR Aging Report Template: Buckets, DSO and Bad-Debt Reserve
Frequently asked questions
What is the difference between cash reconciliation and bank reconciliation?
A bank reconciliation compares one bank account to its statement. Cash reconciliation covers every cash account in the ledger, including those with no statement, such as merchant clearing, undeposited funds and petty cash.
How often should cash accounts be reconciled?
Monthly at a minimum, early in the close. High-volume operating and merchant accounts benefit from weekly or daily matching, which also catches unauthorized withdrawals well within bank notice periods.
Who should sign off on a cash reconciliation?
Someone who did not prepare it and who does not handle receipts or release payments, usually the controller. In a very small business, the owner or an outside accountant can review it each month and sign and date the package.
What do I do with a difference I cannot explain?
Keep it on the reconciliation as an open item with the amount, date found and owner. Check for transpositions (differences divisible by 9), duplicates and wrong-period entries first. Do not plug it to suspense.
Can auto-matching replace manual review?
No. Rules can match the wrong transaction, which is why Xero lets you challenge or reject automatic matches. A person still has to review exceptions, clearing balances and the final reconciliation.
Sources
- Journal of Accountancy (AICPA & CIMA), “AICPA updates audit standards related to external confirmations,” July 14, 2026. journalofaccountancy.com
- AICPA & CIMA, Executive summary of SAS No. 150, posted October 1, 2026. aicpa-cima.com
- KPMG, “The COSO 2013 Framework summary,” no date shown. kpmg.com
- University of Arizona, “Control Activities,” no date shown. finance.arizona.edu
- Cornell LII, UCC § 4-406 and § 4-404, no date shown. 4-406, 4-404
- Intuit, “Reconcile an account in QuickBooks Online,” September 22, 2026, and “What’s the Undeposited Funds account?,” August 3, 2026 (vendor). reconcile, undeposited funds
- Xero, “Bank reconciliation,” no date shown (vendor). xero.com
- Microsoft, “Reconcile bank accounts,” April 7, 2026 (vendor). learn.microsoft.com
- Oracle NetSuite, “Matching Bank Data,” no date shown (vendor). docs.oracle.com
- Sage Intacct, “Matching and creation rules FAQs,” October 1, 2026 (vendor). intacct.com
- BlackLine, “Transaction Matching Module Overview,” no date shown (vendor). blackline.com
- Vendr, “BlackLine Software Pricing & Plans 2026,” February 2026. vendr.com
- Stripe, “Payout reconciliation report,” no date shown (vendor). docs.stripe.com
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
