PNL Reporting Automation for 100+ Branches Using Power BI and Microsoft Fabric

Enterprise Financial Analytics Across 4 Regions, 689 Cost Centers & 20+ Subsidiaries

100+ Branches | 4 Regions | 689 Cost Centers | 20+ Subsidiaries

When Financial Reporting Has to Work at Enterprise Scale

Financial reporting becomes increasingly complex when an organization operates across multiple branches, regions, cost centers, and subsidiaries. Finance teams need to understand overall performance while also being able to examine the financial contribution of individual business areas.

For an organization spanning 100+ branches, 4 regions, 689 cost centers, and 20+ subsidiaries, the reporting environment needed to support multiple levels of financial analysis while maintaining consistent business definitions and appropriate access to financial information.

The objective was to bring these requirements together within a single, interactive Power BI reporting environment.

The Business Requirements

The reporting solution was designed to support:

• Consolidated P&L reporting across multiple organizational entities
• Financial analysis across branches, regions, divisions, and cost centers
• Actual versus budget comparison
• Previous-month and previous-year analysis
• Year-to-date financial reporting
• Three-year P&L trend analysis
• Consistent financial logic through a business-defined semantic model
• Controlled access to financial information based on user permissions

The requirement was not simply to present financial figures. The solution needed to provide a structured way to explore, compare, and understand financial performance across a complex organizational structure.

The Power BI Solution

Team Academy developed a single-page P&L reporting solution using Microsoft Power BI and Microsoft Fabric.

The solution is built around a business-defined semantic model, providing a structured foundation for financial measures and reporting logic.

Users can interact with the dashboard using filters such as:

Accounting Period | Company | Region | Division | Branch

This allows users to move from an overall financial view to a more focused analysis of specific business areas within the same reporting environment.

Financial Performance at a Glance

A P&L dashboard needs to bring together the financial measures that matter most to the business.

The solution provides a structured view of key financial indicators, including:

• Net Revenue
• Gross Profit
• Gross Profit %
• Operating Expenses
• Other Income / Expenses
• Net Profit / Loss

The dashboard also incorporates comparative measures, allowing users to review current financial performance alongside budget and historical figures.

The financial matrix provides a detailed view of the P&L while maintaining a structured format familiar to finance users. Revenue, costs, profitability, and comparative measures can be reviewed within the same financial reporting view.

Financial Performance Across Time

A financial figure becomes more meaningful when it can be viewed in context.

The dashboard supports multiple comparison perspectives, allowing users to examine current performance against previous-month, previous-year, budget, and year-to-date figures.

This provides a broader view of financial movement rather than limiting analysis to a single reporting period.

 Previous-Month Comparison

The comparison provides visibility into changes across key measures such as revenue, gross profit, gross profit percentage, expenses, other income or expenses, and net profit.

Previous-Year Comparison

The year-over-year view allows users to examine changes in key financial measures against the corresponding previous-year period.

Actual Performance vs Budget

Budget analysis is an important part of financial performance management.

The dashboard brings actual and budgeted figures together, allowing users to examine how financial performance compares with planned values.

Users can review budget performance across areas including:

• Net Revenue
• Gross Profit
• Gross Profit %
• Expenses
• Other Income / Expenses
• Net Profit

By presenting actual and budget figures within the same reporting environment, the dashboard provides a structured view of financial variance.

Year-to-Date Performance vs Last Year

Financial performance is not always assessed on a single-month basis. Year-to-date reporting provides a broader view of how the business is performing throughout the financial year.

The dashboard supports analysis across business categories such as:

• Prime Products
• Parts
• Service
• Rental / Leasing
• Projects / Contracts
• Operating Management

This allows users to examine how different areas contribute to the overall financial result.

Related Offerings

 Three-Year P&L Trend Analysis

Current-period results provide only one part of the financial picture.

The solution includes row-level P&L trend analysis covering the last three years, providing historical context for individual financial categories.

The historical view allows users to examine how individual P&L lines have developed over time and provides additional context when reviewing current financial performance.

Interactive Financial Analysis by Business Unit

The dashboard is designed to support financial analysis across multiple organizational dimensions.

Users can move from the consolidated financial view toward more detailed analysis across:

Company → Region → Division → Branch

This structure allows users to examine financial performance at the level relevant to their reporting responsibilities while maintaining a common reporting framework.

Secure Financial Reporting With Row-Level Access

Financial reporting across multiple branches, regions, cost centers, and subsidiaries requires appropriate access controls.

The solution incorporates Row-Level Security (RLS) to control access to financial information based on user permissions.

This allows the organization to maintain a common reporting environment while ensuring that users only access the financial data within their authorized scope.

One reporting environment. Controlled access to the data within it.

Connecting Multiple Data Sources

The reporting solution brings together data from multiple sources to support the financial reporting model.

Snowflake Data Warehouse

Snowflake provides the data warehouse source for the financial reporting environment.

Microsoft Fabric Dataflows

Fabric Dataflows support the integration and preparation of data for reporting.

Excel

Excel sheets are incorporated as supporting business data sources where required.

SharePoint Lists

SharePoint Lists provide additional business-managed information used within the reporting solution.

These sources feed into a business-defined semantic model, which provides the foundation for the Power BI reporting layer.

Business-Defined Semantic Model

A strong financial dashboard depends on more than its visual design. The underlying model needs to reflect the way the business defines and analyzes its financial information.

The solution uses a business-defined semantic model to provide a consistent structure for financial measures and reporting logic.

This supports consistent analysis across the organization's branches, regions, cost centers, and subsidiaries while allowing users to interact with the data through the Power BI dashboard.

Custom Financial Visualization With Deneb

Financial statements often require a structured presentation that goes beyond standard charts and KPI cards.

The solution uses a Deneb Financial Matrix custom visual to provide a financial-reporting-style presentation within Power BI.

The financial matrix brings multiple financial categories and measures together in a format designed for detailed P&L analysis, while retaining the interactive capabilities of Power BI.

Built for a Complex Financial Structure

The scale of the reporting requirement is a key part of this project.

Subsidiaries

The solution provides a common reporting framework for analyzing financial performance across this organizational structure.

Rather than maintaining separate reporting environments for different business areas, the project brings these dimensions into a connected Power BI reporting solution.

From Multiple Data Sources to One Financial Reporting Experience

The overall reporting flow brings together the project's data, business logic, visualization, and security layers.

This architecture provides the foundation for a reporting environment that can support detailed financial analysis across a complex organizational structure.

Project Outcome

The resulting solution provides a centralized environment for analyzing P&L performance across 100+ branches, 4 regions, 689 cost centers, and 20+ subsidiaries.

It brings together:

• Multiple Data Sources
• Business-Defined Financial Logic
• Interactive P&L Reporting
• Actual vs Budget Analysis
• Previous-Period Comparisons
• Three-Year Trend Analysis
• Controlled Data Access

into one connected Power BI reporting solution.

Explore the P&L Dashboard

See how this Power BI solution brings enterprise financial reporting, P&L analysis, budget comparisons, historical performance, and interactive business-level analysis together in one reporting environment.

[View the Interactive Dashboard ]

Explore the dashboard and see the reporting experience in action.