Automated Financial Reporting Suite

The Challenge

Month-end financial reporting — trading P&L, statutory P&L, balance sheet, and GL transaction reporting — relied heavily on manual intervention from FP&A and finance business partners. The goal was to automate this reporting so the finance team could close faster and spend less time compiling numbers by hand.

The Approach

• Data pipeline: a Synapse Link connection surfaced the required tables directly from D365 F&O.
• Warehouse structure: surfaced tables were loaded into a designated Dataverse warehouse, with the table viewer used to understand how each underlying model was derived.
• Reference data: legal entities, RecId, and global option sets were used as reference tables, so every transaction could be correctly attributed and categorised.
• Core financial logic: general ledger actuals and budgets from D365 F&O were combined with forecasts and period-level adjustments for each GL account and accounting period.
• Reporting outputs: the structure supports trading P&L, statutory P&L, balance sheet, and GL transaction reporting, extending to EBITDA, shareholder revenue, COGS, and sales.

The Outcome

• Month-end close time cut by 8 days — the trading P&L alone had carried heavy cumulative calculations run manually throughout the month.
• 17 reports built in 5 months, including statutory P&L, operations reporting, balance sheet, and purchase order reporting.
• Freed up finance business partners and FP&A to focus on analysis instead of report assembly.