Rounding Robin

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.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsCompany details, dates and the source data. All entry cells are shaded.
ScheduleDeposits in transit, outstanding checks and payments, bank errors, and book adjustments such as fees, interest and returned checks.
Journal EntryThe entry produced from the schedule, with a check that debits equal credits.
ReconciliationSchedule balances compared with the general ledger, with differences flagged.
ListsAccount mappings and dropdown values, editable to match your chart of accounts.

Features

Instructions

  1. On the Inputs tab, enter the statement date, the balance per bank statement and the balance per general ledger.
  2. On the Schedule tab, list deposits in transit, outstanding checks and any book adjustments.
  3. Confirm the Reconciliation tab shows a difference of zero.
  4. 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

More accounting templates

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.