How to Use a Bank Reconciliation Template

A bank reconciliation template is a structured worksheet — usually a spreadsheet — that walks you through comparing your own records against your bank statement and explaining the difference between the two ending balances. The structure does the thinking for you: instead of staring at two columns of numbers, you fill in a few defined sections and the template guides you to a single reconciled figure. If you are new to the idea itself, start with what a bank reconciliation is and then come back here for the mechanics of the worksheet.

This guide explains what a reconciliation template contains and how to fill each part out. It is not a download — it is a walkthrough of how the layout works so you can use any template (or build your own in a spreadsheet) with confidence.

The sections of a reconciliation template

Most templates are organized into two halves — the bank side and the book side — that you adjust separately until they meet at the same number. A typical layout has these sections:

• Ending balances — the closing bank statement balance and the closing book balance for the period. These are the two figures the reconciliation works from. (Last period's reconciled balance carries forward as context, but the math starts from this period's ending numbers.)
• Cleared items — transactions that appear on both your records and the statement.
• Outstanding checks — payments recorded in your books that have not cleared the bank yet.
• Deposits in transit — money you recorded as received that the bank has not posted yet.
• Adjustments — bank fees, interest, and corrections you had not yet recorded.
• Reconciled balance — the final figure both sides must agree on.

Understanding what each section is for is the key to filling it out without second-guessing.

How to fill out each section

1. Enter the ending balances

A period-end reconciliation works from the ending figures, not the opening ones. At the top of each side, record the closing balance for the period: on the bank side, the ending balance shown on this period's statement; on the book side, the cash balance your records show as of the same date. These two ending balances are what every adjustment below is applied to in order to reach the reconciled figure. Last period's reconciled balance is useful context — it should match where this period's records began — but it is a carry-forward, not the number the formula starts from.

2. List cleared items

Cleared items are transactions that match on both sides — a check that you wrote and the bank has paid, or a deposit you recorded that has posted. Most templates do not need you to retype every cleared line; instead you tick or mark each one as you confirm it appears in both places. The point of this step is to surface what is left over — the unmatched items become your reconciling adjustments below.

The matching step is where most of the time goes, and it is far easier when the statement is sitting in spreadsheet rows next to your books rather than locked inside a PDF. You can turn a statement into clean, sortable rows with the bank statement converter, then paste those rows alongside your records to tick off matches quickly.

3. Record outstanding checks

In the outstanding-checks section, list every payment you have already entered in your books but that has not yet been deducted by the bank. For each one, note the check number or reference, the date, and the amount. Because you have already reduced your book balance for these, the bank side is temporarily too high — the template subtracts the total outstanding checks from the bank balance.

4. Record deposits in transit

Deposits in transit are the mirror image: money you recorded as received but that the bank has not posted yet (for example, a deposit made late in the period). List each with its date and amount. The template adds these to the bank balance, because the bank will eventually show money your books already reflect.

5. Enter adjustments

The adjustments section is for items the bank knew about but you did not — typically bank fees, service charges, or interest the bank credited. These belong on the book side: you reduce your book balance for fees and increase it for interest, because the bank has already accounted for them and your records have not. This is also where you correct any recording errors you find while matching, such as a transposed amount.

6. Confirm the reconciled balance

Once the adjustments are entered, the template calculates both totals:

• Bank balance − outstanding checks + deposits in transit = adjusted bank balance
• Book balance − fees + interest ± corrections = adjusted book balance

When these two figures are equal, that number is your reconciled balance, and the template will usually show a difference of zero. If the difference is not zero, you have a reconciling item still unaccounted for — recheck for a missed outstanding check, an unposted deposit, an unrecorded fee, or a typo in an amount.

A quick worked illustration

Imagine your book balance is $4,800 and the statement balance is $5,000. You enter a $250 check that has not cleared in the outstanding-checks section, and a $50 service fee in the adjustments section:

• Adjusted bank balance: $5,000 − $250 = $4,750
• Adjusted book balance: $4,800 − $50 = $4,750

Both halves of the template now read $4,750, so the difference is zero and the worksheet is reconciled.

Tips for using a template well

• Reconcile every period. A template is most useful when you run it on a regular cadence so few items accumulate between reconciliations.
• Carry forward the closing balance. This period's reconciled balance becomes next period's opening balance, which keeps the chain consistent.
• Keep your supporting rows. Save the matched transaction list alongside the completed template so you can trace any figure later.
• Investigate before you adjust. An adjustment should explain a real reconciling item, not force the two sides to agree.

A template only organizes the work — you still need to understand the underlying steps it is guiding you through. For the full procedure behind the worksheet, see how to do a bank reconciliation. And when you are ready to fill in the rows, getting your statement into a spreadsheet first with the bank statement converter makes every section faster to complete.