Free template

Check register template, for Excel

Log every check, payment and deposit, and the running balance updates itself. Mark each line cleared when it shows on your bank statement, and the cleared balance tells you what the bank should show. No signup.

Check register (.xlsx)

One sheet, 500 rows, ordinary formulas. Opens in Excel, Google Sheets, Numbers and LibreOffice.

Download the template

Reconciling the month? Use the bank reconciliation template.

How it works

Start from your balance

Type the account's opening balance at the top. Every row below works from it.

One row per transaction

Date, check number, description, then the amount under Payment or Deposit. The Balance column shows the running total.

Clear as the bank does

Put an x under Cleared when a line appears on your statement. The cleared balance at the bottom adds only those lines.

Have the bank's PDF statement?

Turn it into Excel or CSV, checked against its own balances, instead of retyping it. Try the free converter or start a free account.

Questions

What is in the template?

One sheet with an opening balance, 500 rows for date, check number, description, payment, deposit and a cleared mark, a running balance that fills itself, and a cleared balance at the bottom.

Does it need macros?

No. It uses ordinary formulas, so it works in Excel, Google Sheets, Numbers and LibreOffice.

What is the cleared balance for?

It adds only the rows you marked cleared, so you can compare it with the balance your bank shows.

QuickBooks, Quicken and Xero are trademarks of their respective owners. StatementLoom is not affiliated with or endorsed by them; their names describe file compatibility only.