Home › Templates › Bank Reconciliation Template
Bank Reconciliation Template
A standard two-sided bank reconciliation: the bank balance adjusted for timing items, the book balance adjusted for items not yet recorded, and a check that the two agree.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result. |
| Inputs | Company details, dates and the source data. All entry cells are shaded. |
| Schedule | Deposits in transit, outstanding checks and payments, bank errors, and book adjustments such as fees, interest and returned checks. |
| Journal Entry | The entry produced from the schedule, with a check that debits equal credits. |
| Reconciliation | Schedule balances compared with the general ledger, with differences flagged. |
| Lists | Account mappings and dropdown values, editable to match your chart of accounts. |
Features
- Adjusted bank balance and adjusted book balance are compared, with the difference flagged.
- Outstanding items are aged, and those older than a limit you set are highlighted for follow-up.
- Each book adjustment type maps to an offset account and to an increase or decrease in cash.
- The journal entry for book-side items lists only the lines that have an amount.
- Includes preparer and reviewer sign-off.
Instructions
- On the Inputs tab, enter the statement date, the balance per bank statement and the balance per general ledger.
- On the Schedule tab, list deposits in transit, outstanding checks and any book adjustments.
- Confirm the Reconciliation tab shows a difference of zero.
- Post the entry on the Journal Entry tab so the ledger equals the adjusted book balance.
Notes
Capacity is 30 deposits in transit, 120 outstanding items, 6 bank errors and 30 book adjustments. Use one copy of the workbook per bank account.
Related calculators
- Current Ratio and Working Capital CalculatorCalculate working capital, current ratio and quick ratio from current assets, inventory and current liabilities.
- Cash Conversion Cycle CalculatorCalculate the cash conversion cycle from inventory, receivables and payables: days inventory, days sales and days payable outstanding.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
- 13-Week Cash Flow Forecast TemplateWeekly receipts and disbursements for one quarter, with closing cash, minimum balance alerts and forecast-to-actual tracking.
Need a version built for your process? Request a custom template quote.
To report an error or request a calculator or template, send feedback.
Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.