CPD lab · Close
Bank reconciliation exceptions
A month's bank statement against the cash book: match every line with your AI tool, then catch the timing items, the returned payment, the bank charges, a transposed figure and a payment posted twice.
Comes with Month-end close and controls, and with the year. 29 labs open now.
The brief
You are the assistant accountant at Fenwick Hollow Joinery Ltd, a joinery and fit-out business. It is Monday 2 November 2026 and the October bank reconciliation for the current account is due today.
The pack has the October bank statement (18 lines), the October cash book (16 lines), last month's signed reconciliation and the list of direct debit mandates. Money in is positive and money out is negative in both files. Every company and figure is invented, so you can paste it into any AI tool.
Use your AI tool to reconcile the bank statement to the cash book. Post nothing: your job is the reconciliation table, for the financial controller to review.
Give one line for every bank statement line (B-01 to B-18) and every cash book line (C-01 to C-16). In matched_to, give the line it agrees to on the other side, or the item on September's reconciliation it clears (BF-1 or BF-2). Leave matched_to blank when there is nothing to match.
Action, one per line. MATCH: the line agrees to a line on the other side, or clears an item on last month's reconciliation; dates may differ by a few days. TIMING: in the cash book but not yet on the bank by 31 October, so it goes on the reconciliation and needs no entry. POST: on the bank, not in the cash book, and it belongs to the business, so it is posted to the cash book. CORRECT: the cash book line is wrong and needs a correcting entry. QUERY: on the bank but you can't tell from the pack that it belongs to the business, so it is not posted until a person has asked the bank.
adjust_gbp is the change to the cash book balance from that line: the amount for POST, the correction for CORRECT (minus to reduce the balance), and 0.00 for everything else. The bank is never corrected by you. Where a cash book line and a bank line differ in amount, the cash book line is CORRECT and its bank partner is MATCH. Where the cash book has the same payment twice, the first posting is MATCH and the repeat is CORRECT.
Check that the reconciliation balances to the penny: bank balance, plus outstanding lodgements, less unpresented payments, plus any debit under query, equals the cash book balance after your adjustments.
Then write a short review note: what the AI got wrong, what you checked, and what goes to a person.
Objective: To be able to use an AI assistant to prepare a month-end bank reconciliation, separating timing items from errors, deciding which items are posted, corrected or queried, and proving the reconciliation balances to the penny.
What's in the pack
Every name, figure and email in the pack is invented. Use your own AI tool: Claude, ChatGPT, Copilot or Gemini.
bank-statement-october.csv
Current account ending 0472, 1-31 October 2026 (18 lines)
cash-book-october.csv
Cash book for the same account, October 2026 (16 lines)
reconciliation-september-2026.txt
Last month's bank reconciliation, signed off
direct-debit-mandates.txt
Direct debits and standing orders the company has set up
The traps
The pack has 8 deliberate traps: cases where AI tools often get it wrong and a person must check. We don't list them here. Finding them is the job, and your feedback names each one you missed.
What you submit
- Your result, as a table with the columns line_ref, matched_to, action, adjust_gbp, note.
- The prompt you used.
- A short review note, 150 to 350 words: what the AI got wrong, what you checked, and what goes to a person.
How it's marked
- Your result, checked line by line against the answer key60%
- Your review note, marked on traits40%
The review note's traits:
- Timing items told apart from errors
- Right items posted, unknown items queried
- Reconciliation proved to the penny
- Clear follow-up with owners
- Bank data kept out of personal accounts
Pass at 80. Under 80, read the feedback and try again. Then write your reflection and copy the entry for your CPD record.
Price
- Month-end close and controls, £79. The role track and its labs, this one included. No end date.
- Everything for a year, £199. Every course, role track and lab for 365 days.
- Monthly, £19.99 a month, cancel any time. Every lesson, plus 8 marked tasks a month, across every course, role track and lab.
Buying for a team, or want a lab built on your own process? CPD for employers.