SIMULATED CASE · Palmridge, GridView and everyone named here are fictional. The dataset was generated for this exercise; the cleaning, pivots and findings are my own work.

Client: Palmridge Consumer Products Ltd.  ·  Scope: 150,000-row Sales Ledger  ·  Analyst: Semilore James  ·  Engagement: GridView Analytics (simulated), June 2026

ACT I · The Audit:
150,000 rows. 18 columns. Handed over after Mr. Tunde's sudden emergency medical leave, two weeks before the scheduled audit. Surface cleaning exposed mixed date formats, 13 promo flag variants, missing unit prices across 7,664 rows, and 19,045 blank revenue entries.

ACT II · Structural Sabotage:
Building the Account Manager's 5 Q2 pivot questions revealed far deeper corruption. Store codes were mapped to 10+ different store names. Region labels were randomly paired across all 21 Nigerian states in 14 different variants. 12,543 duplicate transactions sat hidden in the data. And buried beneath it all, 1,656 rows tagged INF carrying ₦337,974,601 in ghost revenue with no product identity attached.

ACT III · The Verdict:
Initial suspicion fell on sales reps. Statistical analysis cleared them: the ghost revenue was distributed too evenly across all 40+ reps and 6 regions to be any individual's doing. Suspicion pivoted to Mrs. Folake Adebayo, Chief Accountant. How did ₦337M in unattached journal entries pass through monthly reconciliations bearing her signature without a single discrepancy ticket?

Investigation status: OPEN · further forensic analysis ongoing.

The Breakdown: Auditing the sale_date column revealed chaos. Three date formats: DD/MM/YYYY, YYYY-MM-DD, and raw Excel serial integers (like 44607).

The Sabotage Clue: 12,400 rows had quarter values that contradicted the actual transaction month (e.g. July = Q3 was tagged Q2).

The Solution: Constructed Excel formulas using DATE, LEFT, MID, and RIGHT to parse all formats, then derived clean quarter flags.

The Breakdown: 6 standard regions were written in 14 different ways. North-West alone appeared as NW, North West, NORTH WEST, and north west. Region labels were randomly paired with all 21 states.

The Sabotage Clue: Splitting regions masks distributor performance. Sales totals get divided, preventing managers from spotting underperforming territories.

The Solution: Rebuilt using official Nigeria State → Geopolitical Zone lookup table with nested IFS and UPPER checks.

The Breakdown: Promo indicator was flooded with variants. Plus 13,094 rows left blank entirely.

The Sabotage Clue: Bypassing standardized promo flags allows hidden discounts to escape audit checks.

The Solution: Cleaned all promo variants using logical Excel sweeps, mapping everything to a strict binary 1 or 0.

The Breakdown: 19,045 rows lacked Total Revenue, 7,664 rows lacked Unit Price. Total sales volume heavily understated.

The Sabotage Clue: Blanks allow cash transactions to vanish. Impossible to balance bank sheets against inventory.

The Solution: Cross-referenced product SKUs against master price sheet to populate missing values mathematically.

The Breakdown: In 14,447 rows, recorded total_revenue did not equal units_sold × unit_price. Variance spanned millions.

The Sabotage Clue: Classic double-entry manipulation. Revenue formulas were overridden to misreport performance or cover inventory shrinkage.

The Solution: Automated Excel verification checks to isolate mismatches and compute true expected revenue.

Role: Senior Commercial Analyst, Palmridge Account Lead

Status: PRIMARY SUSPECT

Last Known Activity: Emergency medical leave, 2 weeks before scheduled audit

The Profile: Mr. Tunde was the sole custodian of the Palmridge sales sheet for two years. He designed the original reporting structures. Two weeks before the annual audit, he applied for emergency leave and handed over a raw, un-audited CSV of 150,000 chaotic rows.

Why He's Flagged:

• He signed off on monthly reports showing 100% data integrity, yet the underlying ledger is full of mismatches.
• He was the last user to access the CSV before the system logged a bulk database edit.
• Multiple reps reported region and discount discrepancies to him, and none were logged or resolved.

Investigation Verdict: Suspicious. Either hiding massive operational negligence, or actively cooperating with external parties to misreport. Investigation remains open.

The official offer of engagement sent to Semilore James in June 2026. What was supposed to be a routine data cleansing task quickly evolved into a full-scale corporate investigation.

The Account Manager's Mandate: 5 critical performance questions before the Q2 board meeting.

Key Pivot Discoveries:

• Top Revenue: PR Dishwash Liquid at ₦520M+, PR Vegetable Oil 1L at ₦480M+.
• Geographic Heavyweight: South-West dominated (peaking above ₦30M/quarter), North-East under ₦5M.
• Sales Rep Leaderboard: Mrs. Mandy Barrett led at ₦500M+ volume.

Forensic Insight: Creating these pivots exposed the deeper structural randomization: store codes linked to 10+ names, mismatched states, and ghost transactions that surface cleaning never caught.

The Anomaly: 1,656 rows had blank product identities tagged INF, yet contained valid transaction IDs, stores, reps, and ₦337,974,601 in revenue.

Why Reps Weren't Blamed: INF ghost revenue was distributed almost evenly across all 40+ reps, all 6 regions, all channels. No individual spike.

The Sabotage Mechanism: Ghost entries passed through centralized journal reconciliations, pointing directly to administrative and accounting oversight.

Role: Chief Financial Accountant, Palmridge Account

Status: PRIMARY ACCOUNTABILITY SUSPECT

Key Responsibility: Final authorization on GL reconciliations and multi-store transfer journals.

The Interrogation Pivot: When sales rep audits proved inconclusive, the focus turned to central accounting. Mrs. Folake had overseen Palmridge's financial approvals for 4 years.

The Unanswered Questions:

• How didn't she know? ₦337,974,601 in unattached INF revenue passed through monthly balances bearing her signature.
• Scrambled Stores: One store code → 10+ names across multiple states, facilitating phantom inventory transfers.
• Systemic Override: 14,447 revenue mismatches manually cleared without discrepancy tickets.

Investigation Status: The case remains OPEN. Further forensic analysis is ongoing.