Sheetfold

Free bank reconciliation template for Excel

A ready-made workbook with the formulas already in, a worked example you can change below, and the quickest way to get the statement side filled in.

Updated Oct 21, 2026 · 6 min read

Bank reconciliation template (.xlsx)

Two sheets: the reconciliation, and a statement sheet that checks every row. Excel, Google Sheets, LibreOffice. 20 KB.

Download free

The template does the arithmetic for you. Type the balance from your bank statement and the balance from your books, list what has not cleared yet, and the difference cell tells you whether the two agree. Here is the same reconciliation worked live, with an example you can change:

Bank side

Adjusted bank balance 11,414.60

Book side

Adjusted book balance 11,414.60
Reconciled: both sides agree Change any amount to see how the difference moves.

What a bank reconciliation does

A bank reconciliation proves that the cash balance in your books and the balance on your bank statement describe the same money. They rarely match on the day the statement is printed, and that is normal: a deposit made on the 31st may reach the bank on the 2nd, and a check you wrote last week may not have been cashed yet. Those are timing differences, and the reconciliation lists them so that both sides end on the same adjusted balance.

Everything else is something to fix. Fees, interest and returned payments appear on the statement before anyone records them, so they go on the book side and into your books. And if a difference is left after all of that, there is an error somewhere: on the statement data you started from, or in your records.

How to fill in the template

  1. Balance per bank statement. The closing balance printed on the statement, for the date you are reconciling to.
  2. Deposits in transit. Money you recorded as received that the statement does not show yet. List each one under Deposits in transit; the total flows up.
  3. Outstanding checks and payments. Payments you recorded that have not cleared the bank. List them the same way.
  4. Bank errors. Rare, but if the bank charged or credited something wrongly, enter the correction here (a minus sign to subtract).
  5. Balance per books. Your cash account's balance in the general ledger on the same date.
  6. Items only the bank has recorded. Interest earned, bank fees and charges, and returned (NSF) payments. Record each one in your books as well, so next month starts clean.
  7. Read the difference. When it shows 0.00, the status cell turns to Reconciled. Anything else is a difference to find.

How to find a difference fast

The amount itself usually says what kind of mistake it is:

  • It matches one transaction. Something is missing on one side, or recorded twice on the other. Search for that exact amount first.
  • It is twice a transaction. An amount was entered with the wrong sign: a payment recorded as a deposit, or the reverse. Look for a transaction of half the difference.
  • It divides evenly by 9. Often two digits were swapped: 54.00 typed as 45.00 leaves 9.00, and 1,520.00 instead of 1,250.00 leaves 270.00. Check amounts that contain the digits involved.
  • It is small and odd. A fee, interest or a rounding difference the books have not caught yet.

Before you search your books, make sure the statement data itself is right. If you typed or copied the transactions from a PDF, one misread digit on the statement side looks exactly like an error in your books. The template's second sheet, Statement, catches that: paste the rows with the running balance, and the Check column shows 0.00 on every row that agrees with the balance the bank printed, and the exact difference on the row that does not.

Get the statement side done in a minute

Typing a month of transactions from a PDF is the slow part, and the one where most mistakes come from. Sheetfold reads the statement PDF, from any bank and in any language, and checks every row against the balances the bank printed before you download anything. If a row does not add up, it tells you which one and shows the page beside it. The Excel file it gives you has the transactions and a reconciliation sheet of its own (opening balance plus money in, minus money out, equals the closing balance), ready for this template: copy its Date, Description, Money out and Money in columns into columns A to D of the Statement sheet, and Balance into column E.

The bank-to-books part stays with you: only you know which checks are outstanding. But you start from statement data that is proven, so any difference left is one worth looking for.

The layout follows the standard bank reconciliation as taught in accounting courses; see AccountingCoach or the Corporate Finance Institute for a longer worked example.

Questions

How often should I reconcile a bank account?
At least once a month, when the statement arrives, and before any month-end or year-end close. Busy accounts are easier to keep right weekly, because a small difference is quicker to find in a few days of transactions than in a month of them.
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or use File, then Import. The formulas are standard (SUM, ROUND, IF), so they work in Google Sheets and LibreOffice as well as Excel.
What causes a difference in a bank reconciliation?
Most differences are timing: deposits you recorded that the bank had not yet credited, and payments that had not cleared. The rest are items the bank recorded and your books do not have yet (fees, interest, returned payments), or plain errors: a missing transaction, a duplicate, transposed digits, or an amount entered with the wrong sign.
Is a bank reconciliation the same as checking the bank statement?
No. Checking the statement means making sure its rows add up to the balances the bank printed. A reconciliation compares that statement with your own records. Both matter: if the statement data you start from is wrong, the reconciliation looks off for a reason that is not in your books at all.

Try it on your own statement

Drop a PDF here and Sheetfold reads it, then checks every row against the balances your bank printed. A free account converts 5 pages a day.

or drop it here

All guides