Free Bank Reconciliation Template

What is on the template

Balance per bank statement, plus deposits in transit, less outstanding checks and payments.
Balance per your books, plus interest or deposits not yet booked, less bank fees not yet booked.
Both adjusted balances and the difference, which should be 0.00. The spreadsheet shows Balanced or Check items.
Space for who prepared it and the statement date.

Open the spreadsheet and type the closing balance from the bank statement.
List deposits in transit and outstanding checks, with date and amount.
Type your book balance and any interest or bank fees that are on the statement but not yet in your books.
If the difference is not 0.00, check each line against the statement again.

Is it really free?

Yes. No sign-up, no email, no watermark.

What is a deposit in transit?

Money you have booked as received that has not appeared on the bank statement yet.

What is an outstanding check?

A payment you have booked that has not cleared the bank yet.

Is this accounting advice?

No. It is a blank worksheet. Check every figure against your statement and ask your accountant when in doubt.

Can I use it for many accounts?

Yes. Save one copy per account and month.