CPD · Accountancy

Reconciling accounts to a month-end standard

Matching records to statements and clearing differences before close.

about this course

What you will be able to do

L4 PractitionerAbout 4 hours (240 minutes) of CPDSelf-study plus role-playAccountancy

Matching records to statements and clearing differences before close.

Reconcile a bank account, given a statement and a ledger, with all differences explained and signed.
Identify timing and error differences, given 10 items, with at least 9 classified correctly.
Prepare a reconciliation sheet, given a template, with preparer, reviewer and date complete.
Escalate an unexplained difference, given a threshold, within the agreed time.

Task, condition and standard

Task

Reconcile a bank account to a ledger at month end, classify each difference, complete and sign the statement, and escalate anything unexplained.

Condition

Given a bank statement, a ledger, a statement template, an approval card and a set limit for small differences, working in a four-hour supervised session.

Standard

Produce a result with every difference explained, at least 9 of 10 items classified correctly, a difference after reconciling of zero, and preparer, reviewer and date complete.

These courses teach process, communication and recording. They give no clinical, legal, tax, financial or engineering sign-off. A named subject expert must review every line, and you must check your own professional body's current CPD rules, before you rely on a certificate.

sessions

8 modules

Module 1 Why reconcile and what "done" means 20 min

A reconciliation proves two records agree
Done = zero unexplained difference, signed and dated
A second person reviews it

Worked example. Worked-example figures: bank shows 10,000 and the ledger shows 9,700, a gap of 300. An uncleared cheque of 400 and a deposit of 100 not yet shown by the bank explain it. Done means the difference after reconciling is 0 and the statement is signed and dated.

Practise: Practise with a case card or template for "why reconcile and what "done" means": reconcile a bank account, given a statement and a ledger, with all differences explained and signed.

Standard to meet. Explain why a bank reconciliation is done every month and describe what a finished, fully explained reconciliation looks like, naming how it helps catch errors and fraud early.

Module 2 Reading a bank list and a ledger list 30 min

Bank list shows what the bank has processed
Ledger list shows what you have recorded
Read date, reference and amount on each line

Worked example. Bank line: 03 May, cheque 1042, debit 400.00. Ledger line: 02 May, payment to supplier, 400.00. Same amount, different dates, so read the dates and references before matching.

Practise: Practise with a case card or template for "reading a bank list and a ledger list": identify timing and error differences, given 10 items, with at least 9 classified correctly.

Standard to meet. Read a bank list and a ledger list side by side and identify each line, so that every entry on both lists is correctly understood before matching begins.

Module 3 Matching and timing differences 45 min

Tick matching lines on both lists
Timing items clear on their own next month
Anything left is an error to investigate

Worked example. Bank 10,000 minus ledger 9,700 = 300. Timing items: cheque issued 400 (bank side, still to clear) and deposit made 100 (bank side, still to arrive). 400 - 100 = 300, so both are timing differences and nothing is left unexplained.

Practise: Practise with a case card or template for "matching and timing differences": prepare a reconciliation sheet, given a template, with preparer, reviewer and date complete.

Standard to meet. Match the lines of a bank list to a ledger list and classify each difference as a timing item, such as an uncleared cheque or a deposit not yet recorded.

Module 4 The reconciliation statement layout 35 min

Use the set layout every month
Adjust the bank side for timing items and the ledger side for ledger items
End on zero or explain the rest

Worked example. Statement: bank balance 10,000, less uncleared cheque 400 = 9,600, plus deposit not yet cleared 100 = 9,700. Ledger balance 9,700. Difference after reconciling = 9,700 - 9,700 = 0. Sign and date it.

Practise: Practise with a case card or template for "the reconciliation statement layout": escalate an unexplained difference, given a threshold, within the agreed time.

Standard to meet. Complete the reconciliation statement in the set layout, adjusting both balances with timing and ledger items until the difference after reconciling is zero.

Module 5 Unusual items: spotting and explaining 30 min

Look for round sums, duplicates and odd dates
Compare each item with the set limit
Never write off an amount (remove it from the books) without the named approver

Worked example. Unusual items: an unexplained 50 against a set limit of 25 is above the limit, so record it and escalate. A round payment of 2,000.00 on a Sunday and two identical debits of 400.00 on the same day are also flagged and explained.

Practise: Practise with a case card or template for "unusual items: spotting and explaining": escalate an unexplained difference, given a threshold, within the agreed time. Use a new case this time (round 2).

Standard to meet. Spot unusual items such as unexplained small amounts, round sums or duplicates, then explain each one, record it against the set limit and escalate when required.

Module 6 Full practice file 40 min

Work line by line, ticking each match
List the three differences before adjusting
Check both sides end on the same figure

Worked example. Practice file: 12 bank lines, 12 ledger lines. Bank closing 8,420, ledger closing 8,295. Three planted differences: cheque 250 not cleared, bank charge 35 not recorded, and a receipt of 450 entered as 540. Bank 8,420 - 250 = 8,170. Ledger 8,295 - 35 - 90 = 8,170. Difference 0.

Practise: Practise with a case card or template for "full practice file": escalate an unexplained difference, given a threshold, within the agreed time. Use a new case this time (round 2).

Standard to meet. Reconcile a full practice file of twelve bank lines and twelve ledger lines, finding all three planted differences and finishing with a correct signed statement.

Module 7 Assessment 10 min

Timed, working alone
Use the checklist as you go
Leave no unexplained balance

Worked example. Assessment sample: bank 5,200, ledger 5,050. Uncleared cheque 180 and an unrecorded bank charge 30. Bank 5,200 - 180 = 5,020. Ledger 5,050 - 30 = 5,020. Difference 0. Checklist: items matched, statement written, every difference explained.

Practise: Practise with a case card or template for "assessment": escalate an unexplained difference, given a threshold, within the agreed time. Use a new case this time (round 2).

Standard to meet. Complete a timed assessment reconciliation by matching items, writing the statement and explaining every difference, meeting the checklist with no unexplained balance left.

Module 8 Second worked case and teach-back 30 min

Work a second case from the case card
Explain your result to a partner
Partner checks against the checklist

Worked example. Case card 2: bank 14,820.00, ledger 15,240.00. Cheque 600.00 unpresented (issued, not yet paid by the bank): 14,820 - 600 = 14,220. Bank charge 180.00 unrecorded: 15,240 - 180 = 15,060. Gap left = 840. A deposit of 840 not yet at the bank would close it (14,220 + 840 = 15,060); if none is found, escalate.

Practise: Practise with a case card or template for "second worked case and teach-back": escalate an unexplained difference, given a threshold, within the agreed time. Use a new case this time (round 2).

Standard to meet. Complete the second case card, find the remaining gap of 840, and explain each step to a partner so that they can confirm the statement ends on zero.

practice

Worked example and case cards

Worked example (figures invented)

Bank balance 10,000; ledger cash balance 9,700. Items: cheque issued, not yet cleared (400); deposit made, not yet shown by the bank (100). Check: 10,000 - 400 + 100 = 9,700; ledger 9,700. Difference after reconciling: 0.

Layout

balance per bank; add/less timing items; adjusted balance; balance per ledger; add/less ledger items; adjusted balance; difference.

Case card

a practice file of 12 bank lines and 12 ledger lines with 3 planted differences.

Case card 2

Bank shows 14,820.00; ledger shows 15,240.00. A cheque of 600.00 is unpresented (issued, not yet paid by the bank) and a fee of 180.00 is unrecorded. Learners find the remaining gap (840.00) and write the statement.

checks

10 check questions with model answers

Why reconcile monthly?

Model answer: To catch errors and fraud early. (Covered in module 1: Why reconcile and what "done" means. To pass that module: Explain why a bank reconciliation is done every month and describe what a finished, fully explained reconciliation looks like, naming how it helps catch errors and fraud early.)

A cheque issued but not cleared affects which balance?

Model answer: Bank balance side (deduct it). (Covered in module 3: Matching and timing differences. To pass that module: Match the lines of a bank list to a ledger list and classify each difference as a timing item, such as an uncleared cheque or a deposit not yet recorded.)

What do you do with an unexplained 50?

Model answer: Investigate, record it and escalate if above the limit. (Covered in module 5: Unusual items: spotting and explaining. To pass that module: Spot unusual items such as unexplained small amounts, round sums or duplicates, then explain each one, record it against the set limit and escalate when required.)

Who reviews?

Model answer: A second person, per your policy. (Covered in module 1: Why reconcile and what "done" means. To pass that module: Explain why a bank reconciliation is done every month and describe what a finished, fully explained reconciliation looks like, naming how it helps catch errors and fraud early.)

What is a timing difference?

Model answer: An item in one record this month and the other next month. (Covered in module 3: Matching and timing differences. To pass that module: Match the lines of a bank list to a ledger list and classify each difference as a timing item, such as an uncleared cheque or a deposit not yet recorded.)

What do you do with an unexplained 50 against a set limit of 25?

Model answer: It is above the limit: record it and escalate. (Covered in module 5: Unusual items: spotting and explaining. To pass that module: Spot unusual items such as unexplained small amounts, round sums or duplicates, then explain each one, record it against the set limit and escalate when required.)

Why keep the statement signed and dated?

Model answer: It proves who checked and when. (Covered in module 4: The reconciliation statement layout. To pass that module: Complete the reconciliation statement in the set layout, adjusting both balances with timing and ledger items until the difference after reconciling is zero.)

Name one unusual item.

Model answer: A round-sum payment, a duplicate, a payment on a weekend. (Covered in module 5: Unusual items: spotting and explaining. To pass that module: Spot unusual items such as unexplained small amounts, round sums or duplicates, then explain each one, record it against the set limit and escalate when required.)

Who approves a write-off?

Model answer: The person named in the approval card, never the preparer. (Covered in module 5: Unusual items: spotting and explaining. To pass that module: Spot unusual items such as unexplained small amounts, round sums or duplicates, then explain each one, record it against the set limit and escalate when required.)

Bank shows 4,000, ledger shows 3,700, and one cheque of 300 has not cleared. What is the difference after reconciling?

Model answer: Bank 4,000 - 300 = 3,700. Ledger is 3,700. The difference is 0. (Covered in module 3: Matching and timing differences. To pass that module: Match the lines of a bank list to a ledger list and classify each difference as a timing item, such as an uncleared cheque or a deposit not yet recorded.)

glossary

Words used in this course

reconciliation, unpresented cheque, timing difference, write-off, approval card.

marking

How the practice and assessment are marked

Level	Meaning	Marks of 4
Secure	Meets the standard in the outcome every time, no prompts	4
Meeting	Meets the standard with one small slip, corrected when prompted	3
Developing	Meets part of the standard; needs a re-attempt	2
Not yet	Standard not met	1

Pass = average 3 or more, and no outcome at 1. You may re-attempt after feedback. The subject expert sets any stricter pass mark.

where next

Ladder L1 to L7, slide by slide with notes

Slide 1: L1 Basic: What is a reconciliation. Speaker note: A reconciliation checks that two lists of the same money agree: what the bank says and what we recorded. Say it in one sentence. At this level the learner only knows the word and why monthly checks matter.
Slide 2: L2 Awareness: The two lists. Speaker note: Show a bank list and a ledger list side by side. Point out date, reference and amount. The learner at this level can name each column and say why the two closing balances often differ by small timing items.
Slide 3: L3 Foundation: Matching with a pencil. Speaker note: Learners tick matching lines under supervision and sort leftovers into timing items and errors. They follow a prepared example such as bank 10,000 against ledger 9,700 and see how 400 and 100 explain the gap.
Slide 4: L4 Practitioner: Reconcile to the month-end standard. Speaker note: This course sits here. The learner completes a full reconciliation alone: matches lines, classifies differences, writes the statement to zero, explains every item, signs and dates, and escalates anything above the set limit.
Slide 5: L5 Specialist: Many accounts and exceptions. Speaker note: The specialist reconciles several accounts, spots patterns such as repeat duplicates or round sums, designs the approval card and limits, and trains others to review. Emphasise judgement on unusual items, not only matching.
Slide 6: L6 Advanced: Controls and close. Speaker note: The advanced worker owns the month-end close timetable, sets reconciliation controls, reviews exceptions across teams and reports trends to finance leaders. Talk about root causes: why the same bank charge is unrecorded every month.
Slide 7: L7 Super expert: Designing the reconciliation system. Speaker note: The super expert designs how reconciliations run across the whole organisation: tools, limits, segregation of duties (the person who prepares is not the person who approves), audit evidence and training. They decide what good looks like and prove it with measures such as days to close.

This course sits at L4 Practitioner. Credits stack; aligned with, not accredited by, any framework.

jobs this leads to

Where this takes you

Accounts assistant
Bookkeeper
Finance clerk
Accounts payable clerk
Ledger clerk

assessment and certificate

How you are checked

Each outcome is checked against its standard with a checklist or a short test. A digital CPD record shows the hours. Keep evidence in My page. Aligned with common CPD practice; not accredited. Learners check their own body's rules.

ten locations and global

Your place

Use your own body's forms, units and currency. Local professional bodies set the rules for CPD hours; check them first.

India (Bengaluru)

Language: English, Hindi, Kannada. Personal data: Digital Personal Data Protection Act 2023. Credit and levels: National Skills Qualifications Framework (NSQF) and the national credit framework.

Netherlands (Eindhoven area)

Language: Dutch, English. Personal data: EU GDPR (Dutch: AVG), supervised by the Autoriteit Persoonsgegevens. Credit and levels: the Dutch qualification framework (NLQF) linked to the European Qualifications Framework.

UAE (Dubai and Abu Dhabi)

Language: Arabic, English. Personal data: Federal Decree-Law No. 45 of 2021 (personal data protection). Credit and levels: the emirate education and training regulators (for example KHDA in Dubai) and the national qualifications framework.

Brazil (Sao Paulo)

Language: Portuguese (Spanish and English support). Personal data: LGPD (Lei Geral de Protecao de Dados). Credit and levels: the national technical-education catalogue and the national S-system training bodies.

Canada (Toronto)

Language: English, French. Personal data: PIPEDA, with provincial rules where they apply. Credit and levels: the provincial colleges framework and the national credential-recognition guidance.

United States

Language: English, Spanish. Personal data: state privacy laws (for example California), and COPPA for children under 13. Credit and levels: state and community-college credit systems.

Singapore

Language: English, Mandarin, Malay, Tamil. Personal data: Personal Data Protection Act (PDPA). Credit and levels: the Singapore national skills frameworks and the national credit system.

Australia

Language: English. Personal data: the Privacy Act 1988 and the Australian Privacy Principles. Credit and levels: the Australian Qualifications Framework (AQF) levels.

Hong Kong (Eastern Asia)

Language: Chinese (Cantonese, Mandarin), English. Personal data: the Personal Data (Privacy) Ordinance. Credit and levels: the Hong Kong Qualifications Framework.

Georgia and Israel (Western Asia)

Language: Georgian, Hebrew, Arabic, English. Personal data: the personal data law of the country where the learner lives. Credit and levels: the national qualifications framework of that country.

Cayman Islands (Caribbean)

Language: English. Personal data: the Data Protection Act. Credit and levels: the local education and training framework.

Mexico

Language: Spanish, English. Personal data: the federal law on personal data held by private parties. Credit and levels: the national competency certification system and the education ministry levels.

Draft

Draft CPD course. It opens only after final checks. No fee is shown.

All CPD courses