Back to Samridhi's profile
23views

Tokri: Daily cash reconciliation

The cash on delivery numbers don't match this morning. Find out why, to the rupee.

Samridhi nirayanwal

Overview

The problem

A Wooble FastTrack work simulation for the AI-enabled Data & Finance Analyst role. The cash on delivery numbers don't match this morning. Find out why, to the rupee.

Tokri is a fictional grocery delivery company. The data was built for me alone and my answers were checked by Wooble; I passed on hand-in 2.

The result

Hi Priya Mam I’ve completed the Delhi NCR COD reconciliation for 29 September and attached the Excel workbook for your review.

It covers the expected COD vs. rider-reported collections, bank pickup and deposit verification, exceptions, and the supporting source data. The key observations include a provisional ₹13,204 reconciliation gap, two deposit shortfalls requiring verification, a potentially duplicated pickup record, and four delivered-date orders marked as returned.

My recommendations are to verify the pickup handover records and bank deposit proofs, confirm the potentially duplicated entry, resolve the order-status inconsistencies, and maintain a daily rider-to-bank reconciliation with clear handover acknowledgements.

I’ve kept unverified items flagged rather than treating them as confirmed losses. I’d appreciate your feedback on my approach and any improvements you’d recommend. Thank you for the opportunity

Links & files

Artifacts

1