Free to read β’ Save or share with one click
A Bank Reconciliation is an operational accounting document that systematically matches a company's internal cash book balance β the figure recorded in the general ledger β against the closing balance on the official bank statement for the same period. The process works in two directions simultaneously: the bank balance is adjusted for timing differences (deposits in transit and outstanding checks) that the bank hasn't yet processed, while the book balance is adjusted for items the bank has already processed but the company hasn't yet recorded (service charges, NSF checks, interest earned). When both adjusted balances agree, the reconciliation is complete and the cash balance on the financial statements is confirmed as accurate.
A cash balance that hasn't been reconciled against the bank is an assumption, not a fact β and acting on incorrect cash figures leads to overdrafts, missed payments, and financial statements that misrepresent the company's position to lenders, investors, and tax authorities. Beyond accuracy, bank reconciliation is the most effective routine control against cash theft and unauthorized transactions: it is far harder to conceal a missing payment or a fraudulent disbursement when every transaction must reconcile to an independent third-party source every month. For businesses subject to audit, a complete set of signed monthly reconciliations is one of the first items auditors request. This template gives you a clear, repeatable format that satisfies both the bookkeeping requirement and the internal-control documentation requirement in a single document.
| If your situation is⦠| Use this template |
|---|---|
| Monthly close for a single operating account | Bank Reconciliation (Monthly) |
| Reconciling a petty cash fund rather than a bank account | Petty Cash Reconciliation |
| Matching a credit card statement to internal records | Credit Card Reconciliation |
| Multi-account reconciliation for a larger accounting close | Account Reconciliation Worksheet |
| Tracking outstanding checks issued to vendors | Outstanding Check Register |
| Documenting cash receipts before depositing | Cash Receipt Log |
| Summarizing all cash positions across accounts for management | Cash Flow Statement |
Why it matters: Online balances include transactions that occurred after the statement date, making it impossible to reconcile accurately β you will always show unexplained differences.
Fix: Always start from the official statement closing balance. Download the PDF statement and lock it as your source document for the period.
Why it matters: Writing NSF checks or bank charges on the reconciliation form without posting the journal entry means the GL balance remains wrong β the error carries forward into every future period.
Fix: Post all book-side adjustments in the accounting system before finalizing the reconciliation, then confirm the updated GL balance matches your adjusted book balance.
Why it matters: Checks outstanding for more than 6 months inflate the outstanding list, understate available cash, and in many US states trigger unclaimed property (escheatment) reporting requirements.
Fix: Review outstanding items older than 90 days monthly. Void stale checks, reverse the original entry, and reissue if the payment is still owed.
Why it matters: Bank reconciliation is a key internal control specifically designed to catch errors or fraud by the person managing cash. A single preparer-approver eliminates the control entirely.
Fix: Establish a policy requiring a second person β a supervisor, controller, or owner β to review and sign off on every completed reconciliation before it is filed.
Why it matters: A forced balance hides an error, a recording omission, or potentially a misappropriation β and the underlying problem compounds each period it goes undetected.
Fix: Treat any unexplained variance as an open item: document it, assign it to someone to investigate, and do not sign off on the reconciliation until it is resolved or formally accepted with a written explanation.
Why it matters: A single quarter contains three months of transactions to untangle. Errors and fraud become much harder to trace, and the cumulative difference compounds each month it goes uninvestigated.
Fix: Complete a bank reconciliation at the end of every calendar or fiscal month, even if the account is low-volume. The discipline is more important than the volume.
Print or download the bank statement for the period and pull the corresponding cash account ledger report from your accounting software as of the same closing date. Both must cover exactly the same date range.
π‘ Export the GL transaction detail β not just the ending balance β so you can cross-reference individual transactions when a discrepancy appears.
Complete the company name, bank name, account number (last four digits is sufficient for most internal documents), statement period, preparer name, and preparation date.
π‘ If you reconcile multiple accounts, include the account nickname (e.g., 'Operating β Chase 4821') so the file is identifiable without opening it.
Enter the official closing balance from the bank statement β not the current online balance. This is your starting figure for the bank side of the reconciliation.
π‘ Verify the opening balance on this statement matches the closing balance on last month's reconciliation before proceeding.
Compare deposits recorded in your books on or before the statement date against deposits shown on the bank statement. List every deposit that appears in the books but not on the statement, with its date and amount.
π‘ Any deposit in transit that also appeared on last month's list should be flagged immediately β it should have cleared by now.
Pull your check register and mark off every check that appears on the bank statement. List all checks issued on or before the statement date that did not clear, including check number, payee, date, and amount.
π‘ Review checks outstanding for more than 90 days. Contact the payee to confirm receipt, or void and reissue. Flag checks over 6 months old as potential stale checks.
Add deposits in transit to the bank ending balance, subtract outstanding checks, and add or subtract any documented bank errors. Record this subtotal clearly as the adjusted bank balance.
π‘ This number represents what the bank balance would be if all timing differences were resolved today β it should be close to your book balance before book-side adjustments.
Identify every item on the bank statement that hasn't been recorded in the books yet β service charges, NSF checks, interest, direct debits. Enter each as a book-side adjustment and post the corresponding journal entry in your accounting system before finalizing the reconciliation.
π‘ Post journal entries first, then refresh the GL balance in your reconciliation β never adjust the reconciliation to compensate for unposted entries.
Confirm the adjusted bank balance equals the adjusted book balance. Document any remaining variance with a clear explanation and resolution timeline. Have a reviewer β someone other than the preparer β approve and date the completed reconciliation.
π‘ Store the signed reconciliation with the supporting bank statement and GL report as a single PDF package. Auditors request all three together.
A bank reconciliation is a process β and the document that records it β that matches a company's internal cash book balance to the closing balance on its bank statement for the same period. The goal is to identify and explain every difference between the two, post any required accounting adjustments, and confirm that both adjusted balances agree. It is one of the most important routine internal controls in accounting.
Bank reconciliation catches recording errors, bank errors, NSF checks, unauthorized debits, and potential fraud before they compound. It ensures the cash balance on your financial statements is accurate, which is critical for loan covenants, investor reporting, and tax filing. Without regular reconciliation, small discrepancies accumulate into material misstatements that are expensive and time-consuming to untangle.
Monthly is the standard minimum for any active business account. High-volume accounts β those processing hundreds of transactions per week β benefit from weekly reconciliation. Quarterly reconciliation is a common shortcut that consistently creates larger problems: three months of undetected errors, stale checks that exceed state escheatment thresholds, and NSF items that have long since been sent to collections.
The four most frequent reconciling items are outstanding checks (issued but not yet cleared), deposits in transit (recorded in the books but not yet credited by the bank), bank service charges not yet recorded in the books, and NSF checks that were deposited but returned. Interest earned on the account and direct-debit payments set up by the bank are also common book-side items.
An unbalanced reconciliation means there is at least one unresolved difference β an entry recorded in the wrong amount, a transaction recorded twice, a missing entry, a bank error, or potentially a misappropriation. Do not force a balance by plugging a miscellaneous adjustment. Systematically compare each item on the bank statement to the GL transaction detail until you locate the source of the variance, then correct it or formally document it as an open item for investigation.
No β a structured Word or Excel template works for most small businesses with fewer than 100 transactions per month. Accounting software like QuickBooks, Xero, or Wave automates the matching step and reduces manual error, but the reconciliation logic is identical. The template is useful for documenting the reconciliation formally for auditors and reviewers regardless of which tool you use to do the underlying matching.
A bank reconciliation confirms that a specific bank account balance is accurately recorded in the general ledger at a point in time β it is a control document. A cash flow statement summarizes cash inflows and outflows across all accounts over a period β it is a financial reporting document. An accurate bank reconciliation is a prerequisite for a reliable cash flow statement, but the two serve entirely different purposes.
The reconciliation should be reviewed and signed off by someone other than the person who prepared it β typically a controller, CFO, owner, or finance manager. Segregation of duties between the preparer and the approver is the primary internal control the reconciliation is designed to enforce. A reconciliation signed only by the preparer provides no meaningful fraud deterrence.
Retain completed bank reconciliations β along with the supporting bank statement and GL report β for a minimum of seven years in most jurisdictions, consistent with general tax record-retention requirements. Auditors routinely request reconciliations for prior periods, and they are primary evidence in fraud investigations. Store them as a single PDF package (reconciliation form plus supporting documents) in a secure, organized filing system.
A cash flow statement summarizes all cash inflows and outflows across a period for financial reporting purposes. A bank reconciliation confirms that a specific account balance in the GL matches the bank statement at a point in time β it is a control document, not a reporting document. You need the reconciliation to be confident the cash line on your cash flow statement is accurate.
A general ledger report shows all transactions recorded in the accounting system. A bank reconciliation uses the GL cash balance as its starting point, then explains the differences between it and the bank statement. The GL cannot self-verify β only the reconciliation against an independent third-party source (the bank) provides that confirmation.
An account reconciliation worksheet covers any balance sheet account β accounts receivable, accounts payable, prepaid expenses β against supporting schedules. A bank reconciliation is the specific subset that compares the cash account against a bank statement. Bank reconciliation is typically the highest-priority account reconciliation because cash is the most liquid and most fraud-exposed asset.
An expense report documents individual employee spending for reimbursement. A bank reconciliation operates at the account level, confirming that the total of all recorded transactions matches the bank's record. Unreimbursed or unrecorded expense report items can appear as reconciling differences on the bank reconciliation if the reimbursement check has not yet cleared.
Multiple client trust accounts or operating accounts must be reconciled separately each month, and trust account reconciliation often carries professional regulatory obligations.
High transaction volumes from POS systems and payment processors mean daily or weekly reconciliation is practical, and timing differences between processor settlements and bank credits are the dominant reconciling item.
Grant audits and board reporting require documented monthly reconciliations as evidence of cash controls, and restricted fund accounts must be reconciled separately from operating accounts.
Progress billings, retainage holdbacks, and subcontractor payments create a high volume of outstanding checks, making systematic reconciliation critical to knowing true available cash on active projects.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small businesses, bookkeepers, and owner-operators reconciling one or two accounts with under 200 transactions per month | Free | 30β90 minutes per account per month |
| Template + professional review | Growing businesses that want a controller or CPA to review the completed reconciliation and post adjusting entries | $75β$300 per month (bookkeeper or outsourced accounting review) | 1β2 hours total including review |
| Custom drafted | Multi-entity businesses, audit-required organizations, or companies implementing a formal month-end close package with documented procedures | $500β$2,000 to set up a documented reconciliation procedure and chart of accounts structure | 1β2 weeks for initial setup |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
