Financial Data Reporting for a Business Spin-Off

A client preparing to spin off part of their business needed reliable, entity-level balance sheets. Their finance team was working with raw Excel extracts that were difficult to consolidate and prone to errors. They wanted a repeatable way to produce dynamic balance sheet reports for each legal entity, without days of manual spreadsheet work.

The Challenge

• Finance relied on multiple inconsistent Excel files.
• Account hierarchies were buried in indentation and formatting.
• Consolidating data for each legal entity was slow and error-prone.
• Manual processes created compliance risk during a sensitive restructuring.

Our Approach

• Flattened and cleaned raw Excel data into a consistent tabular format.
• Built dimension and fact tables (Accounts, Time, Entities) in a SQL database using a star schema.
• Automated data modelling so account hierarchies and entity structures were reusable across reports.
• Connected SQL to Excel to deliver dynamic, refreshable pivot-based balance sheets.

Results

• Finance leaders now generate accurate, drill-down reports in minutes instead of days.
• Reports are entity-specific, enabling clarity during the spin-off process.
• The SQL-backed model ensures data consistency, auditability, and scalability for future reporting needs.
• Manual work was eliminated, freeing the finance team to focus on decision-making instead of spreadsheet wrangling.