Universal topic learning · Practical workbook

Bank Reconciliation Workbook

Tick the checklist and type your answers; they stay in this browser. Print or save as PDF with the button below. The review guide prints on a separate page.

Use fictional information to document the plan and its evidence. Apply your approved procedures for real work.

Practise with fictional information. Use your approved procedures for real work.

Before you begin

Define the task, purpose and boundaries.
Use approved tools and suitable information.
Complete each relevant planning field and mark unknowns.
Test normal, missing, conflicting and denied cases as relevant.
Record evidence, limitations and the review decision.
Name an owner and retest meaningful changes.

Your planning worksheet

Type your answers below. They are saved in this browser only; download or print them when you finish.

Sources, period and versions

Normalisation of dates, references and spaces

Matching rule and date tolerance

Many-to-one matches allowed

Matched count and total

In bank, not in ledger

In ledger, not in bank

Likely reason and owner for each break

Headline, reviewer and approved adjustments

Practice scenario

A fictional month: one RM3,000 bank receipt pays three RM1,000 invoices, a RM15 bank fee is missing from the ledger and one supplier payment is recorded twice in the ledger. Plan and record the reconciliation.

Review guide

Match the RM3,000 receipt to the three RM1,000 invoices as one group.
The RM15 fee appears in the bank only; record it after review.
The duplicate payment appears in the ledger only; investigate before reversing it.
Never delete unmatched rows; a person approves every adjustment.

Primary references

NIST Generative AI Risk Profile

Project-authored exercises. References support the underlying principles; this workbook does not prescribe company procedures.

Bank Reconciliation Workbook

Before you begin

Your planning worksheet

Practice scenario

Primary references

Practice scenario: review guide