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
- Introduction
- Getting Started
- Key Reconciliation Concepts
- Workspace Overview
- Core Workflow
- Trust Reconciliation Rules
- Recommended Month-End Routine
- 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:
- the bank statement balance;
- the general ledger bank balance in the system; and
- 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:
- the correct bank statement for the month-end date;
- the right bank account selected;
- access to the imported or posted transactions for the same period; and
- authority to finalise the reconciliation if you are the person responsible for closing the month.
Best practice before reconciling
- Finish posting all known receipts and payments for the period.
- Confirm that transaction dates fall into the correct accounting period.
- For trust accounts, resolve unusual trust postings before attempting final close.
- Reconcile one bank account at a time.
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:
- deposits in transit;
- EFTs captured in the system after the bank cut-off;
- cheques or payments not yet reflected on the statement;
- bank charges not yet posted in the system.
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:
- entered statement balance (after reconciliation adjustments);
- trust bank GL balance; and
- trust liability total for the same bank account.
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
- Open Bank Reconciliation.
- Choose the relevant bank account.
- 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:
- Use the statement closing date that belongs to the selected period.
- Include the sign correctly. An overdraft or negative balance must be entered as negative if the bank statement presents it that way.
- If you update the value, refresh the summary so the variance is recalculated.
5.3 Import the Bank Statement
Click Import Bank Statement and select the statement file supplied by the bank.
Typical use:
- Choose the correct CSV or statement import file.
- Confirm the account and statement date.
- Complete the import.
- 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:
- deposits on the statement that are not yet in the system;
- bank charges or interest lines needing journals;
- duplicated or suspicious statement lines.
Use the System Transactions panel to look for:
- uncleared payments from the end of the month;
- late deposits still in transit;
- incorrect posting dates;
- transactions posted to the wrong bank account.
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:
- Select the bank line(s).
- Select the matching system transaction(s).
- Use Match if the workflow requires an explicit pair.
- Use Mark Cleared once you are satisfied the item is genuinely on the statement.
- 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:
- dates are close;
- references are consistent;
- amounts are exact; and
- there are no duplicate values causing ambiguity.
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:
- Review the summary figures.
- Confirm there are no unexplained uncleared items.
- Click Finalize & Lock Period.
- Read the confirmation message carefully.
- Confirm the finalisation.
Finalisation performs the decisive compliance check:
- the statement balance must equal the system bank balance after adjustments; and
- for trust accounts, the trust liability total must also agree with the trust bank balance.
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:
- statement date;
- entered bank balance;
- trust ledger / GL bank balance;
- trust liability total;
- deposits in transit;
- outstanding payments; and
- resulting variance.
A trust reconciliation is only considered balanced when:
- the adjusted statement balance equals the trust bank GL balance; and
- 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:
- a trust receipt posted to the wrong matter or wrong bank account;
- a trust disbursement reversed incorrectly;
- an unposted or duplicated correction journal;
- imported bank charges incorrectly treated as trust movements.
Investigate the source transaction before trying to force the reconciliation through. The system is designed to prevent that shortcut.
7. Recommended Month-End Routine
A practical month-end routine for South African legal practice is:
- Post all known month-end receipts and payments.
- Import the latest bank statement.
- Reconcile easy matches first using Auto Match.
- Review remaining uncleared items manually.
- Post any legitimate bank-only items such as charges or interest.
- Re-run the reconciliation summary.
- Confirm trust asset and trust liability agreement.
- Finalise the reconciliation.
- 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:
- the bank statement;
- the trust reconciliation summary;
- trust balance or trust integrity reports; and
- any explanatory schedules for uncleared items.
8. Troubleshooting
The statement balance does not match the system balance
Check:
- whether all relevant system transactions were posted before reconciliation;
- whether any bank charges or interest are still missing from the system;
- whether transactions were posted to the wrong bank account or date;
- whether items were marked cleared incorrectly.
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:
- the variance is not zero;
- the trust liability total does not equal the trust bank balance;
- the statement balance was captured incorrectly;
- you do not have the required authority.
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.