Monthly group reporting pack

1. 01Problem

   Each month the subsidiary submitted eight or more uploads to group head office, drawn from two systems and mapped to the group's structure through intermediate spreadsheets with undocumented logic.

2. 02Scope

   Management accounts mapped to more than 90 group cost elements; more than 2,000 inventory lines; a 12-month sales analysis; a revenue upload of almost 3,000 invoices and more than 29,000 order lines; SG&A across more than 20 cost centres.

3. 03Monsoon's contribution

   • Rebuilt the pack as an eight-step workflow on raw source data.
   • Documented each step's mapping, with reconciliation checks to the trial balance at each stage.
   • Produces a reconciliation report each cycle.

   Monthly group pack · componentsFrom the engagement scope

   • Management accounts mapped to group cost elements90+ cost elementsReconciled to TB
   • Inventory2,000+ linesReconciled to TB
   • Sales analysis12 monthsReconciled to TB
   • Revenue upload~3,000 invoices · 29,000+ order linesReconciled to TB
   • SG&A20+ cost centresReconciled to TB

4. 04Professional oversight

   confirm: who reviews and approves each monthly pack before submission

5. 05Evidenced outcome

   The pack is produced in the group's format as a single workflow each cycle, with figures traceable to source. source: time returned to the finance team (current site says about a week a month); resubmission history; client consent

Client anonymised. Outputs were prepared for professional review and sign-off. confirm: client consent (E1) Related: Core platform.