Bank Reconciliation Worksheet Template

Bank reconciliation worksheet template matters most when the owner needs a straight answer quickly and the file cannot provide one. We see this in South African SMEs when reconciliations, ledger support, management pack notes, and working papers that tie back to source records is still incomplete and the next monthly close or SARS request is already close.

A bank reconciliation template is one of the most practical control documents in accounting.

It helps the business prove that the cash balance in the accounting records agrees to the bank statement after valid timing differences are considered. If that control is weak, the rest of the reporting stack usually becomes weaker as well.

The numbers first

That is the core structure every bank rec template needs.

A practical reconciliation template

This layout is simple, but it forces the accountant to explain the difference clearly.

Add a supporting-items table

This keeps the reconciling items visible instead of hidden inside one total.

What should never sit on the template for too long

The template should not become a place where unexplained items live indefinitely.

Watch for:

1. old reconciling items that never clear
2. owner transactions without support
3. bank charges or interest not posted
4. duplicated or reversed entries without explanation

If those items keep recurring, the real issue is process quality.

Include sign-off fields

A useful template should also show:

• preparer
• review date
• reviewer
• comments on unresolved items

That makes the reconciliation easier to rely on later, especially during year-end or tax review.

Why the template matters beyond cash

The bank reconciliation affects more than the cash line.

It also helps support:

• expense completeness
• debtor and creditor allocations
• VAT review
• management cash-flow reporting

So it sits close to the center of strong accounting and bank reconciliation services.

Step 1: Start from the bank statement balance

Use the statement balance from the bank as the fixed starting point. The date matters. A reconciliation prepared to the wrong statement date can look neat while still failing the control test.

For South African SMEs, this is especially important where the business uses more than one bank account, payment gateway, credit card, or cash deposit process. Each account should have its own reconciliation before management relies on the combined cash number.

Step 2: Compare the ledger balance to real bank activity

The accounting ledger should reflect the real cash movement for the same period. Differences usually come from timing items, missing postings, duplicate entries, bank charges, interest, reversals, or owner transactions coded incorrectly.

A useful template should make those differences visible instead of hiding them in one unexplained number. If the ledger balance does not agree after valid reconciling items, the issue is not the template. The issue is the bookkeeping behind it.

Step 3: Clear reconciling items and keep support

Reconciling items should be temporary and explainable. Deposits in transit and unpresented payments can be valid, but they should clear within a reasonable period. Old items need follow-up.

Before sign-off, check:

• whether every reconciling item has a reference
• whether expected clear dates are still realistic
• whether bank charges and interest have been posted
• whether unreconciled items affect VAT, debtors, creditors, or owner balances
• whether the reviewer can follow the file without asking for a verbal explanation

This links directly to the month-end close template, because bank reconciliation is usually one of the first controls that should be completed.

How the template should be used each month

The template is most useful when it is part of a fixed monthly routine. Download the bank statement, lock the statement date, update the cash book, list reconciling items, and then clear or explain anything that does not belong.

The reviewer should be able to see the statement, ledger extract, reconciliation, and support for reconciling items in one file. If the reviewer has to ask what a difference means, the template is not doing enough work yet.

For a small business, this monthly habit protects more than the bank line. It helps catch sales receipts posted to the wrong customer, supplier payments left unallocated, VAT-sensitive payments without documents, duplicate bank-feed entries, and owner transactions that need a separate note. Those are the kinds of issues that become expensive when they are left until year-end.

When a template is not enough

A template cannot fix a weak ledger by itself. If the bank feed is duplicated, old unreconciled items never clear, or large payments have no source documents, the business needs cleanup work before the reconciliation can be trusted.

In that situation, the template should still be used, but it becomes a working paper for the cleanup process. It shows where the difference is and which accounts need attention first.

Practical SME example

Assume the bank statement balance is R125,400 and the ledger shows R128,150. The difference may be valid if there are deposits not yet reflected by the bank or payments not yet presented. But if the same R2,750 difference appears for three months, it is no longer a simple timing item.

The reviewer should then check the bank feed, cash-book postings, receipts, supplier payments, reversals, and any manual journals. The answer may be a duplicated receipt, a bank charge never posted, or a payment allocated to the wrong supplier. The template helps by keeping the difference visible until it is cleared.

For a business owner, the practical value is simple: the cash number becomes more reliable. That matters when deciding whether to pay suppliers, draw funds, chase debtors, or submit VAT using records that depend on bank activity.

Monthly review questions

Before signing off, ask:

1. Does the statement date match the reconciliation date?
2. Are all bank accounts and credit cards reconciled separately?
3. Are reconciling items valid timing differences rather than unexplained balances?
4. Have bank charges, interest, merchant fees, and reversals been posted?
5. Do deposits and payments agree to debtors, creditors, VAT, and owner accounts?
6. Is there evidence for unusual transactions?

These checks keep the template from becoming a tick-box exercise. A bank reconciliation is only useful if the reviewer can see what is still open and why it has not cleared.

For high-volume businesses, weekly review may be more practical than waiting for month-end. The longer unexplained bank differences sit, the harder they become to investigate because supporting documents and staff memory fade quickly.

The same logic applies to payment gateways and card facilities. They may not look like ordinary bank accounts, but they still affect cash, VAT, debtor allocations, and monthly reporting.

Internal links to use next

• Bank account format in accounting for how the bank account appears in the records
• Bank reconciliation checklist for the control review around the template
• Business accounting services where the reconciliation problem is part of a wider monthly accounting gap

What the reviewer should sign off

The reviewer should not sign off only because the difference is zero. They should check that the statement date is correct, reconciling items are valid, old items have been followed up, and unusual bank movements have support.

For owner-managed businesses, the reviewer should pay special attention to transfers between personal and business accounts, cash withdrawals, loan movements, and card transactions. These items often reconcile mathematically while still needing accounting explanation. A good template keeps those explanations visible before the month closes.

The sign-off should also leave a short note for the next month. If an item is expected to clear later, the note should say when and what evidence will prove it. That makes old reconciling items easier to challenge instead of allowing them to roll forward unnoticed.