Bank Reconciliation Module — User Manual

Audience: Bookkeepers, trust account administrators, finance managers, and compliance officers
Version: 1.0 — October 2026
Module: Mod-Bank-Reconciliation
Jurisdiction: South Africa (trust account and firm banking controls)


Table of Contents

  1. Introduction
  2. Getting Started
  3. Key Reconciliation Concepts
  4. Workspace Overview
  5. Core Workflow
  6. Trust Reconciliation Rules
  7. Recommended Month-End Routine
  8. Troubleshooting

1. Introduction

The Bank Reconciliation module is the audit anchor for the firm’s banking records. It is used to compare the bank statement against the system’s own entries and confirm that every cleared transaction is reflected accurately in the ledger.

For trust bank accounts, reconciliation is more than a bookkeeping task. It is a compliance control that checks three things together:

  1. the bank statement balance;
  2. the general ledger bank balance in the system; and
  3. the matter trust liability total for that trust bank account.

For a trust account to be healthy, the trust bank asset and trust liability side must agree. The reconciliation workspace helps the operator prove that agreement at month end and keeps a permanent audit trail of who reconciled which account and when.

For business / operating bank accounts, the module performs a conventional bank-to-ledger reconciliation without the matter trust liability comparison.


2. Getting Started

Open the reconciliation screen from:

Accounting → Banking → Bank Reconciliation

Before you begin, make sure you have:

Best practice before reconciling


3. Key Reconciliation Concepts

Bank items vs system items

The screen compares two lists:

List Meaning
Bank Statement Imported statement lines from the actual bank statement
System Transactions Transactions already posted in the application for that bank account

Cleared vs uncleared

A cleared item is a transaction that appears both on the bank statement and in the system, and has been marked as reconciled.

An uncleared item is still outstanding. Typical examples are:

Variance

The module calculates a variance between the adjusted bank balance and the system balance. Finalisation requires the variance to be zero.

Trust three-way agreement

For a trust bank account, the following must agree at finalisation:

If they do not agree, the period must not be closed until the difference is explained and corrected.


4. Workspace Overview

The reconciliation window contains the following main controls:

Area Purpose
Account selector Choose the bank account to reconcile
Period selector Choose the accounting period / statement month
Statement Balance Enter the closing balance from the bank statement
Unreconciled Only Filter system items to focus on open items
Bank Statement panel Imported bank lines
System Transactions panel Posted system-side transactions
Summary cards Bank balance, system balance, variance, control balance, matter balance, uncleared count
Action buttons Import, Auto Match, Match, Unmatch, Mark Cleared, Unmark, Finalize & Lock Period

This layout is designed to let the operator work left to right: import the bank side, inspect the system side, then clear and finalise.


5. Core Workflow

5.1 Select the Bank Account and Period

  1. Open Bank Reconciliation.
  2. Choose the relevant bank account.
  3. Choose the relevant accounting period.

Always confirm both selections before importing or clearing items. Reconciliation data is stored per account and per period.

5.2 Capture the Statement Balance

Enter the closing statement balance exactly as it appears on the bank statement.

Tips:

5.3 Import the Bank Statement

Click Import Bank Statement and select the statement file supplied by the bank.

Typical use:

  1. Choose the correct CSV or statement import file.
  2. Confirm the account and statement date.
  3. Complete the import.
  4. Review the imported lines in the Bank Statement panel.

After import, the bank panel becomes the authoritative list of statement lines for matching in that reconciliation cycle.

5.4 Review Bank and System Items

Read both panels together.

Use the Bank Statement panel to look for:

Use the System Transactions panel to look for:

The Unreconciled Only tick box is especially useful during the clearing stage because it hides items already reconciled and reduces clutter.

5.5 Match and Clear Items

There are two related actions:

Action Use it when
Match / Unmatch You want to pair a statement line with a system transaction
Mark Cleared / Unmark You want to mark selected system items as reconciled or reverse that marking

Typical manual clearing flow:

  1. Select the bank line(s).
  2. Select the matching system transaction(s).
  3. Use Match if the workflow requires an explicit pair.
  4. Use Mark Cleared once you are satisfied the item is genuinely on the statement.
  5. If a mistake was made, use Unmatch or Unmark before finalisation.

Only clear items that truly appear on the statement. Do not clear items merely because you expect them to appear soon.

5.6 Auto Match

Use Auto Match to let the system attempt straightforward matches based on the imported statement data and posted system transactions.

Auto Match works best where:

You should still review the result manually. Auto Match is a time-saver, not a substitute for operator judgement.

5.7 Finalise and Lock the Period

Once the variance is zero and the cleared items are correct:

  1. Review the summary figures.
  2. Confirm there are no unexplained uncleared items.
  3. Click Finalize & Lock Period.
  4. Read the confirmation message carefully.
  5. Confirm the finalisation.

Finalisation performs the decisive compliance check:

If the reconciliation succeeds, the period is locked or advanced in line with the reconciliation service rules, and the draft reconciliation is converted into an audit record.


6. Trust Reconciliation Rules

Trust reconciliation is stricter than ordinary bank reconciliation.

What the module enforces

For trust accounts, the system builds a reconciliation snapshot containing:

A trust reconciliation is only considered balanced when:

  1. the adjusted statement balance equals the trust bank GL balance; and
  2. the trust bank GL balance equals the trust liability total.

What this means operationally

If a trust account finalises with a difference between bank assets and trust liabilities, there is a serious data problem. Common causes include:

Investigate the source transaction before trying to force the reconciliation through. The system is designed to prevent that shortcut.


A practical month-end routine for South African legal practice is:

  1. Post all known month-end receipts and payments.
  2. Import the latest bank statement.
  3. Reconcile easy matches first using Auto Match.
  4. Review remaining uncleared items manually.
  5. Post any legitimate bank-only items such as charges or interest.
  6. Re-run the reconciliation summary.
  7. Confirm trust asset and trust liability agreement.
  8. Finalise the reconciliation.
  9. File the statement and reconciliation pack according to the firm’s audit policy.

For trust accounts, it is good practice to print or export supporting reports for the audit file, including:


8. Troubleshooting

The statement balance does not match the system balance

Check:

Trust liability does not equal trust bank balance

This usually points to a trust posting problem, not a bank import problem. Review recent trust receipts, trust payments, reversals, and inter-bank movements for the affected bank account.

I cannot finalise the reconciliation

Possible causes:

Items disappeared from the system list

Check whether Unreconciled Only is enabled. Cleared items are hidden when that filter is ticked.

A bank line imported twice

Do not clear both copies. Investigate the import source and remove or ignore the duplicate according to your firm’s reconciliation procedure before finalisation.