Process Lab 3 of 5

Payments, Reconciliation & Exception Management

Incoming and outgoing funds flow through controls, reconciliation and exception handling.

Illustrative simulation and training material. Not a production banking process.

What you can experience in this lab
Process a transaction→Trace the GL posting→Find a reconciliation break→Investigate an exception→Correct an error→Produce a management report
①

Process Flow

  1. 1Funds received or outgoing payment captured against a customer account
  2. 2Fee calculated per product / fee schedule
  3. 3Pending transaction created and balances checked
  4. 4Authorised officer approves — transaction posts
  5. 5Journal entry created and ledger updated (simulated)
  6. 6Daily reconciliation against expected settlements
  7. 7Exceptions identified and resolved or escalated
②

Roles / Responsibilities

Teller / Operations Clerk
Captures incoming and outgoing payment instructions.
Authorising Officer
Approves pending transactions and releases funds.
Reconciliation Officer
Matches posted transactions to expected settlements daily.
Exceptions Officer
Investigates unmatched items and posts corrections.
Finance Manager
Signs off the daily reconciliation pack.
③

Inputs

  • •Payment instruction (payer, payee, amount, account)
  • •Customer account and current balance
  • •Fee schedule (rate, min, max)
  • •Expected settlement file (simulated)
  • •Suspense account balance
④

System Actions

  • →Create pending Transaction record
  • →Compute fee and net amount
  • →On approval: post transaction, update account balance
  • →Create balanced JournalEntry (simulated ledger)
  • →Generate reconciliation report for the day
  • →Flag unmatched items to suspense
⑤

Control / Approval Points

  • ◆Outgoing payments require human approval before posting
  • ◆Insufficient balance blocks the outgoing payment
  • ◆Reversed items post as new reversal entries — originals stay immutable
  • ◆Suspense items older than N days escalate
⑥

AI-Assisted Opportunities

Identify reconciliation exceptions and probable cause
Suggest suspense clear-down entries for review
Flag duplicate or unusual payment patterns
Draft a reconciliation narrative for the daily pack

AI outputs in this simulator are advisory training examples only.

⑦

Illustrative Accounting Impact

Funds Received: Dr Cash / Cr Customer Deposit
Outgoing Payment: Dr Customer Deposit / Cr Cash
Fee: Dr Customer Deposit / Cr Fee Income
Suspense posting: Dr/Cr Suspense pending clear-down
⑧

Exceptions / Escalations

  • !Unmatched incoming settlement → suspense for investigation
  • !Insufficient funds on outgoing → on hold, returned to officer
  • !Duplicate payment detected → flagged for review
  • !Reversal required → new reversal entry, original remains posted
⑨

Expected Outputs

  • ✓Posted transactions with journal references
  • ✓Daily reconciliation pack
  • ✓Unmatched items report
  • ✓Suspense report
  • ✓Correction journals where approved
⑩

Management Reporting Output

  • ▸Daily funds in / out and fees collected
  • ▸Reconciliation first-pass match rate
  • ▸Suspense balance and ageing
  • ▸Exception counts by type and branch
  • ▸Reversal volume and value

Example Document Pack

(click to expand — all static simulation/training samples)
InstructionPayment Instruction (Example)
▾
PAYMENT INSTRUCTION — EXAMPLE SIMULATION
========================================
Ref: TXN-2026-089432
Type: Outgoing Payment
Payer Account: ACC-200145 (T. Moyo)
Recipient: A. Nkosi
Recipient Bank: Example Bank Zambia
Recipient Account: 0112233445
Amount: USD 650.00
Fee (3%): USD 19.50
Net to Customer Account: USD 669.50
Narration: Supplier payment — order #4521
Status: Pending approval
ReconciliationReconciliation (Example)
▾
DAILY RECONCILIATION — EXAMPLE SIMULATION
=========================================
Reporting Date: 2026-08-09
Funds Received (posted):        USD 18,420.00
Funds Received (settlement):    USD 18,420.00
Variance:                       USD 0.00     ✓

Outgoing (posted):              USD 11,260.00
Outgoing (settlement):          USD 11,280.00
Variance:                       USD 20.00    ✗ — see unmatched items

Fees Collected (posted):        USD 548.30
Fees (expected):                USD 548.30
Variance:                       USD 0.00     ✓

Sign-off: Reconciliation Officer — L. Phiri
ExceptionUnmatched Items Report (Example)
▾
UNMATCHED ITEMS REPORT — EXAMPLE SIMULATION
===========================================
Date: 2026-08-09
1. Ref TXN-2026-089421  USD 20.00  — Incoming settlement with no matching instruction. Suspense.
2. Ref TXN-2026-088904  USD 150.00 — Outgoing posted twice (suspected duplicate). Under review.
3. Ref TXN-2026-089332  USD 5.00   — Rounding difference on a bulk receipt. Auto-clear candidate.
Action: Investigate #1 and #2; auto-clear #3 pending officer sign-off.
SuspenseSuspense Report (Example)
▾
SUSPENSE REPORT — EXAMPLE SIMULATION
====================================
Suspense Account: ACC-990 (Internal - Suspense)
Opening Balance: USD 320.00
+ Items added today: USD 175.00
- Items cleared today: USD 150.00
Closing Balance: USD 345.00
Ageing: 0-7 days USD 145.00 | 8-30 days USD 200.00 | >30 days USD 0.00
Action: Clear 8-30 day items within 5 working days.
JournalCorrection Journal (Example)
▾
CORRECTION JOURNAL — EXAMPLE SIMULATION
=======================================
Ref: JE-COR-2026-0809-012
Narration: Clear-down of suspense item TXN-2026-089421 (incoming settlement misposted)
Dr Suspense Account        USD 20.00
   Cr Customer Deposit      USD 20.00
Posted by: Exceptions Officer — K. Mwanza
Approved by: Finance Manager — L. Phiri
Status: Posted (immutable; reversal only via new entry)
Sign-offSign-off (Example)
▾
DAILY RECONCILIATION SIGN-OFF — EXAMPLE SIMULATION
==================================================
Date: 2026-08-09
Prepared by: Reconciliation Officer — L. Phiri
Reviewed by: Finance Manager — S. Tembo
All exceptions raised have a documented action.
Suspense ageing: within policy.
Pack submitted to Finance for filing.
Status: SIGNED OFF

Continue Into the Controlled Simulator

Institutional and evaluation access is provisioned after verification. Request access for your university, college, banking school, bank or financial institution.