Bank reconciliation for small business is the monthly process of matching every transaction in your accounting records to the transactions on a bank or credit-card statement. A complete reconciliation explains timing differences, records missing fees or income, corrects errors, and ends with the adjusted book balance equal to the adjusted statement balance.
This is more than an accounting tidy-up. It tells you whether the cash number in your books can be trusted before you pay bills, review profit, prepare a tax return, or update a 13-week cash flow forecast. The workflow below works with a spreadsheet or accounting software and is designed for owners who need a repeatable monthly close, not a pile of unexplained adjustments.
Table of Contents
Understand what a bank reconciliation proves
Your bank and your books observe the same cash from different positions. The bank statement records what the financial institution processed by its closing date. Your ledger records what the business entered, which may include a customer payment not yet deposited or a check the recipient has not cashed. A difference is therefore not automatically an error.
Reconciliation separates legitimate timing items from omissions, duplicates, wrong amounts and unauthorized activity. The IRS’s current Publication 583 on business records advises business owners to make the statement, checkbook and books agree, and specifically recommends reconciling the checking account each month. It also explains that good records support financial statements, tax returns and the source of receipts.
A completed reconciliation supports one narrow but important conclusion: the recorded cash balance can be traced to an independent statement at a particular date. It does not prove that every purchase was legitimate, correctly classified or tax-deductible. An owner can reconcile a duplicate software subscription perfectly while still wasting money on it. Classification and approval reviews remain separate tasks.
Gather a complete reconciliation packet
Choose one account and one statement period. Download the final statement issued by the bank, not a mid-month balance from a dashboard. Then export the account register or general-ledger detail for the same period. Include transactions through the statement closing date even when the books are maintained on a different reporting schedule.
- Bank evidence: the statement, deposit images, canceled-check images when available, and notices for returned items or fees.
- Book records: the cash ledger, prior reconciliation, bank-feed exceptions, journal entries and the list of uncleared transactions.
- Supporting documents: invoices, receipts, payment-processor reports, loan schedules and merchant-settlement reports for bundled deposits.
- Review notes: an exception log showing the owner, next action and due date for every unresolved item.
Keep business and personal activity separate. Publication 583 recommends a business checking account used only for business purposes because mixed activity makes both recordkeeping and explanation harder. If personal spending does appear, classify it correctly as an owner draw, distribution, contribution or another account appropriate to the entity. Ask a qualified accountant when the treatment is uncertain.
Use the bank reconciliation formula
The goal is to bring two starting balances to the same adjusted balance. On the bank side, add deposits in transit and subtract outstanding payments. On the book side, add bank credits not yet recorded, subtract bank charges and returned receipts, and correct book errors.
| Side | Starting balance | Typical additions | Typical subtractions | Target |
|---|---|---|---|---|
| Bank | Statement closing balance | Deposits in transit | Outstanding checks or payments | Adjusted bank balance |
| Books | Ledger balance | Interest, refunds or direct deposits not recorded | Fees, returned deposits or direct debits not recorded | Adjusted book balance |
Suppose a statement closes at $18,420. The business has a $2,300 deposit in transit and $1,125 of outstanding payments, producing an adjusted bank balance of $19,595. The ledger shows $19,670 but is missing a $25 bank fee and a $50 merchant chargeback. After recording both, the adjusted book balance is also $19,595. The timing items stay on the reconciliation; the bank-only items become book entries.
Follow this eight-step monthly workflow
1. Lock the period and verify the opening balance
Start with the ending date and balance printed on the statement. Confirm that the current beginning balance equals the prior reconciliation’s ending balance. A changed opening balance often means someone edited, deleted, moved or unreconciled a previously cleared transaction. Intuit’s current guidance on beginning-balance discrepancies recommends reviewing the discrepancy report and tracing changes before continuing.
2. Match deposits and other money in
Match by date, amount and source. Do not assume two equal amounts are the same transaction. Payment processors may combine several customer receipts, subtract fees and send one net deposit. Use the settlement report to connect that deposit to the underlying sales, fees, refunds and chargebacks. Mark genuinely undeposited receipts as deposits in transit.
3. Match payments and other money out
Compare checks, card payments, transfers, automatic debits and payroll withdrawals. Match the amount and payee, then confirm the date is plausible. A check recorded this month but clearing next month is an outstanding payment. A withdrawal with no book entry needs investigation and, if legitimate, a correctly classified entry.
4. Record bank-only transactions
Enter service charges, interest, direct debits, electronic receipts, returned payments and chargebacks that first appeared on the statement. Attach evidence and use the correct account rather than a vague reconciliation-expense category. When an amount affects a loan, separate principal, interest and fees according to the lender statement.
5. Identify genuine timing differences
List deposits in transit and outstanding payments individually with their dates. Carry them forward only if they clear after the statement date. An item that remains outstanding for several cycles deserves follow-up: the payee may have lost a check, a customer receipt may never have reached the bank, or an entry may be duplicated.
6. Investigate the remaining difference
Search by exact difference first. Then test common clues: a difference divisible by nine can indicate transposed digits; twice a transaction amount can mean it was entered on the wrong side; and a round amount may point to an opening balance or transfer. Review duplicate entries, split deposits, foreign-currency conversions and transactions posted to the wrong bank account.
7. Finish at zero without forcing it
The unexplained difference should be zero. Do not create a plug entry simply to make the screen turn green. A forced adjustment hides the underlying problem and can put revenue, expenses, tax or customer balances in the wrong period. If an immaterial difference truly cannot be resolved, document the research and obtain appropriate accounting approval before any adjustment.
8. Save evidence and review exceptions
Save the reconciliation report, statement and exception log under a consistent name. Record who prepared and reviewed it and when. A reviewer should focus on old outstanding items, unusual payees, manual journal entries, transfers between related accounts and changes to previously reconciled periods.
Diagnose common reconciliation differences
- Missing bank fee: record the fee in the books with the statement as evidence.
- Deposit appears lower than sales: trace processor fees, refunds and chargebacks through the settlement report.
- Duplicate bank-feed entry: determine whether the feed item was added instead of matched to an existing book transaction, then correct the duplicate.
- Old outstanding check: contact the payee and follow the bank’s stop-payment process when appropriate; do not delete it solely because it is old.
- Transfer recorded once: confirm equal and opposite entries in both bank accounts and reconcile each account separately.
- Unknown withdrawal: preserve the evidence, restrict compromised access if suspected and contact the financial institution promptly. Reconciliation identifies the item; it does not by itself establish fraud.
- Prior period changed: use an audit log or discrepancy report to find who changed what, then restore the correct accounting treatment with approval.
Use software without surrendering judgment
Bank feeds reduce data entry, but a downloaded transaction is not automatically categorized correctly. Software may suggest a match because the amounts are equal even when the payee, date or account differs. Review proposed matches, avoid training rules on ambiguous transactions and restrict who can create, approve and reconcile payments.
Xero’s official reconciliation guidance describes the core choice clearly: match a statement line to an existing transaction or create the missing transaction. That distinction prevents a common duplicate, where a user adds the bank-feed line even though the invoice payment or expense already exists in the books.
Automation should accelerate matching and exception detection while leaving an evidence trail. Use read-only bank connections where available, multifactor authentication, role-based access and alerts for changed bank details. The access, logging, testing and rollback practices in Globe Onward’s secure workflow automation guide are directly useful when bookkeeping rules or integrations can create financial entries.
Build controls around the monthly close
Reconcile every active bank, credit-card and payment-processor clearing account on a fixed schedule. Monthly is a practical minimum for many small businesses; high-volume or higher-risk accounts may need weekly review. The U.S. Small Business Administration includes bank reconciliation among core bookkeeping functions and notes that the right level of accounting help depends on the business’s needs.
Where staffing permits, separate payment authority from reconciliation review. In a very small operation, the owner can compensate by reviewing the unopened statement, bank alerts, canceled-check images, new payees and changes to vendor bank details. Close or formally document dormant accounts so they do not disappear from the schedule.
Track a few operational signals rather than celebrating only a zero difference: days to complete the close, number and age of outstanding items, manual adjustments, duplicate entries, unreconciled accounts and exceptions without owners. These measures expose a fragile process before it produces a misleading cash report.
Use this bank reconciliation checklist
- Obtain the final statement and the ledger for the identical account and period.
- Confirm the opening balance agrees with the prior completed reconciliation.
- Match deposits by amount, source and settlement detail.
- Match payments by amount, payee and plausible clearing date.
- Record legitimate fees, interest, direct debits, returns and chargebacks missing from the books.
- List deposits in transit and outstanding payments separately.
- Investigate duplicates, transpositions, split deposits, transfers and prior-period edits.
- Require a zero unexplained difference and avoid unsupported plug entries.
- Review aged items, unusual transactions and manual adjustments.
- Save the report, statement, evidence and exception log with preparer and reviewer sign-off.
A good reconciliation is boring in the best sense: the opening balance is stable, matches are traceable, exceptions have owners, and the adjusted balances meet without invention. Build that routine before relying on cash dashboards or forecasts. When the numbers do not meet, treat the difference as information to investigate rather than an inconvenience to erase.