RBTERP

Guides › Bank Reconciliation, Step by Step

Bank Reconciliation, Step by Step

RBTERP team · · 4 min read

How to reconcile your cash book with the bank statement every month: what to match, what to post, and what a difference really means.

RBTERP Bank & Cash screen: Cash today, and where it is heading

Bank & Cash in RBTERP, with a sample company and fictional data.

A bank reconciliation proves that the bank balance in your books and the balance on the bank's statement describe the same money. They are rarely equal on any given day, and that is normal. The reconciliation explains the gap item by item. When every item is explained, you can trust the cash figure in your accounts.

Why the two balances differ

There are only a few honest reasons for a difference:

Anything that does not fit one of these needs investigating before you close the month.

Before you start

You need the bank's statement for the period and the closing balance printed on it. Reconcile one bank account at a time, and reconcile every month. A reconciliation left for six months is ten times the work of six monthly ones, because one unexplained item hides the next.

The steps

  1. Bring in the statement. Enter the statement lines or import the file your bank gives you. Check that the opening balance on the statement equals the closing balance of your last reconciliation. If it does not, stop: something was changed in a period you had already reconciled.
  2. Match what agrees. Pair each statement line with the entry in your books that has the same amount and a nearby date. A cheque number or payment reference that agrees makes the match certain.
  3. Record what only the bank knows. For bank charges, post an expense. For interest received, post income. For a returned cheque, reverse the receipt so the customer owes you again.
  4. Investigate what is left on the statement. A deposit you cannot identify is usually a customer paying directly into the account. Find out who paid before posting it; do not park it in a suspense account and forget it.
  5. List what is left in your books. These are your outstanding cheques and deposits in transit. They should clear on next month's statement.
  6. Check the arithmetic. Statement balance, plus deposits in transit, minus outstanding cheques, should equal the balance in your books. The difference must be exactly zero.
  7. Lock it. Once it agrees, complete the reconciliation so the matched entries cannot be changed.

What to look at twice

Doing it in RBTERP

The bank reconciliation workbench: balances, unreconciled items and the matching tools
The bank reconciliation workbench: balances, unreconciled items and the matching tools

In RBTERP the reconciliation workbench is under Banking, then Reconciliation. Choose the bank account, then:

  1. Import the statement as a CSV, Excel or text file, or paste the rows. The importer detects the columns, shows a preview and skips rows it has already imported.
  2. Set a tolerance in days and amount, and press Auto Match. Each statement line is paired with a bank transaction by amount and date, preferring matches where the cheque number or reference also agrees.
  3. Press Auto Classify to post routine items: bank charges, interest income and returned cheques each get a balanced journal entry. Anything it cannot recognise with certainty goes to a review queue, where you choose the account yourself.
  4. Match the rest by hand. One statement line can be matched to several book entries, a line can be matched in part, split into pieces or merged with another, and supporting documents can be attached.
  5. Press Reconcile when the difference is zero. The reconciliation is stored and the matched entries are locked. A reconciliation that does not agree is refused, and the screen shows the difference.

The cards at the top show the statement balance, the adjusted balance, the difference, outstanding cheques and deposits in transit as you work, so you can see how much is still unexplained.

How often

Monthly at least, and before you close the month. Businesses with many daily receipts reconcile weekly. The more often you do it, the smaller each one is.

This guide uses the Bank & Cash module of RBTERP: Every bank and cash account in one place, with a 30/60/90-day cash-flow forecast and alerts for unusual transactions.

More guides

Approvals and Workflows: Who Signs Off What

How to design approval rules for purchases, payments and other documents: approval levels, amount limits, delegation, escalation and maker-checker.

16 November 2026 · 3 min read

See RBTERP working with your own business

Pick a plan and request it, or tell us about your company and we will help you choose.