Wooble FastTrack · Level 1: Foundational
Cash reconciliation exercise
Daily cash reconciliation, at TokriSimulation
Daily cash reconciliation, at TokriThe cash on delivery numbers don't match this morning. Find out why, to the rupee.
- You're the AI-enabled Data & Finance Analyst
- About 45 minutes, no timer
- 5 days to hand in
- Checked the moment you hand in
- Free
Free. Sign up in a minute and you go straight to it.
The situation
Hi, and welcome to the finance team!
Your first job is the one we do every morning: the cash reconciliation for Delhi NCR, for yesterday, Tuesday 29 September.
The numbers don't match this morning. What our orders say we should have collected in cash, what the riders say they collected, and what the agency deposited are all different. I need to know by end of day:
- How much cash on delivery we should have collected in Delhi NCR yesterday.
- How much the riders reported collecting yesterday.
- How much the agency deposited against yesterday's collections. Only count what you can trace to one of yesterday's handovers.
- The gap: what we should have collected minus what was deposited.
- Every record that explains the gap or needs someone to look at it, and why.
- Your short note to me: what happened, what's still unresolved, and what we should change so this happens less.
Use whatever tools you like: a spreadsheet, SQL, Python, AI. I care that the numbers are right and that you can show how you got them. If you make an assumption, write it down.
Thanks, Priya
When you start, you get Tokri's handbook and your own data: the same story as everyone else's, with different records, so your answers are yours alone.
What you hand in
- 1Expected COD: Cash on delivery we should have collected in Delhi NCR on 29 September (in whole rupees)
- 2Rider reported: Cash the riders reported collecting that day (in whole rupees)
- 3Deposited: Cash the agency deposited against that day's collections (in whole rupees)
- 4Unreconciled: Expected minus deposited (in whole rupees)
- 5Exceptions: A table with two columns, record_id and cause, uploaded as a CSV or pasted.
- 6Your working: The spreadsheet, SQL or notebook that produces your answers, as a link anyone can open.
- 7A note to Priya: 200 words at most.
- 8How you used AI: Your prompts or the chat, if you used it.
Your figures and your exception table are checked against your own data the moment you hand in. The pass mark is 70 of 100, and the expected and deposited cash must both be right. Hand in as often as you need; every hand-in is counted.
What passing earns
- A step to your AI-enabled Data & Finance Analyst · Level 1 badge: 1 of the 2 passes it needs, and the next level opens with it.
- A badge page that anyone can check, which you can add to LinkedIn as a certification.
- A project on your Wooble profile made from your hand-in, when you choose to add it.
- 50 points for the pass.
- Finish every level for the track certificate: Wooble FastTrack Certified: AI-enabled Data & Finance Analyst.