Entry system · $49 · single-organisation licence

Bank Reconciliation Template

The bank balance and the cashbook agree by coincidence, not by control.

Bank Reconciliation Template: product box and Overview dashboard

A bank reconciliation that balances doesn't mean every transaction was coded correctly — two errors can cancel each other out and the total still looks clean. That is exactly how a miscoded transaction sits in the cashbook for months without anyone noticing.

$49
One-time payment · single-organisation licence
  • Download links emailed within minutes
  • Blank master + worked example included
  • Excel (.xlsx) — no macros, no add-ins
  • Faulty file? Fixed or refunded — terms
Inside the system

Opens on a live dashboard

Headline figures, charts and an action list of what to fix first, then the tabs where the work happens. Shown here with the worked example that comes with your download.

Bank Reconciliation Template Overview dashboard

Real screenshot of the Overview tab. Every figure is calculated by the workbook.

The fix

How it solves it

This bank reconciliation template covers five bank accounts across eight transaction categories, with an allocation check that confirms every transaction is coded before the reconciliation is treated as clean — and real date fields throughout, so ageing and monthly reporting actually work.

5Bank accounts
8Categories
v1.2Build version
.xlsxFormat

Replaces the single-account bank rec tab that gets copied and renamed every month.

What it tests

Controls this system runs

  • 5 accounts, 8 categories — structured to match how a real cashbook is actually coded.
  • Allocation check — confirms every transaction is coded before the reconciliation is treated as clean.
  • Real date fields — throughout, so ageing and monthly reporting work correctly.
Built for

Who this is for

Built for bookkeepers and accountants reconciling several bank accounts to the cashbook every month.

Questions

Before you buy

Can it handle more than one currency or entity?

It handles five bank accounts in one workbook. For separate entities, run one copy per entity — the single-organisation licence covers unlimited copies inside your own organisation.

Do I need Excel, or will it work in Google Sheets?

Every system is built as a standard Excel (.xlsx) workbook using formulas only — no macros, no add-ins, nothing to install. Because there are no macros, the files also open in Google Sheets and LibreOffice.

What happens straight after I pay?

Checkout is processed by Paddle. Within a few minutes of payment clearing, your download links are emailed automatically from info@appiqfinance.com. You get the blank master workbook and a fully worked example.

What if it doesn't do what this page says?

Report it within 14 days with the file, tab and cell, and we fix it and redeliver — or refund you in full if we can't. See the refund policy for the exact terms.

Free guides

Learn the control, step by step

Practical guides on the problem this system solves. Free to read, no sign-up.

How to Do a Bank Reconciliation in Excel

A step-by-step bank reconciliation in Excel: the layout, matching formulas, adjusting both balances, ageing open items and the review that makes it a control.

Read the guide →

How to Match Transactions in Excel for a Reconciliation (XLOOKUP and COUNTIFS)

Match bank, ledger or supplier transactions in Excel with a matching key, COUNTIFS and XLOOKUP, including repeated amounts, and list what is left unmatched.

Read the guide →

Balance Sheet Reconciliation: Process, Evidence and Sign-Off

How to run balance sheet reconciliations every month: account ownership, risk rating, the evidence each account needs, handling reconciling items and review.

Read the guide →
Free tool

Test your current process first

Run the free check on your own numbers today. If it finds gaps, this system closes them every period.

Month-End Close Scorecard

12 questions on how strong your close controls are. Free to use online.

Use the free tool
Also in the catalogue

Other control systems

Month-End Close & Controls

Close finishes when the file gets sent, not when the numbers are proven right.

View system →

Accounts Payable Control

The first place a duplicate payment gets caught is the bank statement.

View system →

Credit Control & Receivables

Your cash is sitting in a customer's bank account, and nobody can say for how many days.

View system →

See all systems & The Controller's Vault