🏦 Free Bank Reconciliation Template

Below is a bank reconciliation worksheet: match every transaction in your ledger against your bank statement, spot the differences, and confirm the adjusted balance. Copy it into a spreadsheet and reconcile monthly.

Bank reconciliation is how you confirm that the money you think you have matches what the bank says you have. The most common differences are timing — cheques not yet cleared, bank fees not yet recorded, or deposits in transit. This template walks you through the process line by line so nothing is missed.

Reconciliation Header

Fields	Description
Account Name*	The bank account being reconciled.
Account Number (last 4)	For identification — avoid full numbers.
Statement Period*	e.g. “1–31 January 2026”.
Statement Ending Balance*	The balance shown on the bank statement.
Reconciliation Date*	When you are performing the reconciliation.

Adjustments to Bank Balance

Fields	Description
Deposits in Transit	Money you’ve received but the bank hasn’t cleared yet.
Outstanding Cheques / Payments	Payments you’ve recorded that haven’t cleared the bank.
Bank Errors	Mistakes on the bank’s side — rare but possible.
Adjusted Bank Balance*	Statement balance + deposits in transit − outstanding payments.

Adjustments to Book Balance

Fields	Description
Bank Fees / Charges	Fees deducted by the bank not yet in your books.
Interest Earned	Interest credited by the bank.
NSF / Bounced Cheques	Payments that failed to clear.
Book Errors	Recording mistakes in your ledger.
Adjusted Book Balance*	Your ledger balance + interest − fees − NSF ± corrections.

Final Check

Fields	Description
Match?*	Adjusted Bank Balance = Adjusted Book Balance.
Difference*	Should be zero. If not, investigate line by line.
Reconciled By*	Name and date of the person completing it.

How to use

1Download or print your bank statement for the period.
2Export your ledger transactions for the same period into the spreadsheet.
3Tick off every transaction that appears in both — start with the largest amounts.
4List deposits in transit and outstanding payments under Adjustments to Bank Balance.
5Add bank fees, interest, and NSF items under Adjustments to Book Balance.
6Confirm the Adjusted Bank Balance equals the Adjusted Book Balance — if not, re-check line by line.

Or automate this

Manual reconciliation can take hours, and a single missed fee throws everything off. Nika can import your bank feed, match it against your ledger, and flag discrepancies automatically — from {price} per month. She finds the differences so you don’t have to.

Questions

How often should I reconcile?

Monthly at minimum. Businesses with high transaction volumes benefit from weekly or even daily reconciliation. The more frequently you reconcile, the easier it is to catch errors while the details are fresh.

What if the balances don’t match?

A non-zero difference means something is unrecorded or misrecorded. Check for bank fees you haven’t logged, transposed digits, duplicate entries, or transactions in the wrong period. Work through unmatched transactions one at a time until the difference is zero.

Automate with Nika