Applied AI at work / Module 5
Module 5. Reconciliations and checks with AI
Your role: General (any role). The exercises open on its variant. Change role
Time: 3.5 hours (13 minutes of video lessons, 145 minutes of exercise, 20 minutes of quiz). Your task in this module: reconcile two lists that should agree and explain every difference. Sections 1 to 5 work through one example in depth, a NAV check in a fund; section 6 gives the same workflow for every other role, and the exercise has a variant for each role.
In the finance variant you reconcile the book of a fictional equity sub-fund (120 positions) against the custodian statement, an independent price file and the official FX rates for 30 October 2026. Twelve differences are planted: stale prices, wrong FX rates, corporate actions not booked, duplicate trades, a sale never booked, and two timing differences that are not errors at all. The AI writes the formulas; you explain every difference, compute the impact on the NAV and compare it with the CSSF tolerance threshold.
The fund is Pinecrest Meridian European Equity, the equity sub-fund of the fictional SICAV you met in module 1. All data is fictional. You may paste it into any tool.
What you will be able to do
- Explain when a reconciliation break is a NAV error and when it is a timing difference
- Apply the tolerance thresholds of Circular CSSF 24/856 (Tables 1 and 2) and the rules on errors below the threshold and on aggregation
- Get lookup, difference and flag formulas from an AI tool with a structure-only prompt, and test them by hand
- Classify differences as stale price, FX rate, corporate action, duplicate trade, missing trade or timing from the evidence
- Compute the net and gross impact, the impact in % of NAV and the corrected NAV in Excel
- Check AI-drafted break explanations line by line before they enter the NAV file
3 video lessons, 13 minutes
- 5.1 What a NAV check is for, and when an error matters 3:59
- 5.2 The seven-step reconciliation workflow 4:36
- 5.3 The same reconciliation in every role, and what to tell your manager 4:33
Exercise: Reconcile two lists and explain every break
A variant for each role, opening on yours: General (any role). Fictional data, scored automatically against the answer key, with the model answer after you submit.
Module quiz
8 questions, pass mark 6. Passing it counts towards your course certificate.
Sources
- Circular CSSF 24/856 of 28 March 2024 (English), points 23, 28 to 35 (Tables 1 and 2) and 38: https://www.cssf.lu/wp-content/uploads/CSSF24_856eng.pdf (page: https://www.cssf.lu/en/Document/circular-cssf-24-856/)
- Microsoft Support, Get started with Copilot in Excel: https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel