Dynamic Cost Center Financial Reporting with Power BI & Microsoft Fabric

689 GL Code Cost Centers | Level 1–3 Cost Center Mapping | Financial Variance Analysis | Governed Data Access

When Financial Reporting Needs to Work at Cost Center Level

Financial reporting becomes more complex when an organization needs to analyze performance across a large number of GL code cost centers while maintaining a consistent reporting structure.

For this project, the reporting environment covers 689 GL Code Cost Centers, supported by a customized cost center mapping structure across Levels 1, 2 and 3.

The objective was to provide a financial reporting solution that could bring detailed cost center information into a common analytical environment while allowing users to examine performance across different periods, budgets, and organizational dimensions.

The solution brings together data from:

• Snowflake Data Warehouse
• Info R - M3 System
• Customized Excel Cost Center Mapping

The resulting Power BI reporting environment supports financial analysis across current periods, budgets, previous periods, year-to-date performance, and variance measures, with Microsoft Fabric Row-Level Security incorporated to govern access to financial information.

Project Scale

From GL Codes to a Unified Cost Center View

Organizing Financial Information Through Levels 1, 2 and 3

With 689 GL Code Cost Centers, the underlying financial information needs a consistent structure before it can be meaningfully analyzed.

The solution uses a customized Excel cost center mapping with Levels 1, 2 and 3, providing the classification structure required for cost center reporting.

This mapping organizes cost center information into the reporting structure required for financial analysis and provides the foundation for bringing detailed GL-level information into the broader reporting environment.

The result is a reporting model that connects detailed cost center information with financial performance and period-based comparisons.

Financial Performance Across Cost Centers

A Financial Summary Built for Detailed Analysis

The Financial Performance Summary provides the primary analytical view of the reporting environment.

Rather than presenting a single overall financial result, the dashboard organizes performance across business categories including:

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

The summary brings together:

• Net Revenue
• Net Profit
• Budget
• Previous Month
• Actual YTD
• Budget YTD
• Previous-Year Performance

Financial Performance Summary — Current Period, Budget, Previous Month, YTD and Previous-Year Performance

This gives users a common starting point for examining financial results before moving into more detailed period and variance comparisons.

Comparing Current Performance With the Previous Month

Identifying Month-to-Month Movement

Cost center financial reporting becomes more useful when current results can be compared with the immediately preceding period.

The Comparative Last Month view places current-month performance alongside the previous month's results.

The analysis includes:

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

Financial Performance Summary — Comparative Last Month

This allows users to examine changes in financial performance while retaining the same business-category structure used in the broader reporting model.

Comparing Current Performance With the Previous Year

Adding Historical Context to Cost Center Reporting

Month-to-month movement provides a short-term perspective. Comparing the current period with the corresponding period from the previous year provides a longer-term reference point.

The Comparative Last Year view provides this historical comparison across revenue, gross profit, expenses, other income or expense, and net profit.

Financial Performance Summary — Comparative Last Year

Together, these views provide two distinct comparison perspectives:

Current Period → Previous Month

and

Current Period → Previous Year

This gives users more context when reviewing financial performance across the reporting structure.

Actual vs Budget at Reporting Level

Measuring Performance Against Planned Financial Results

Actual financial performance needs to be considered alongside the corresponding budget.

The dashboard provides an operating statement that places current-month actuals alongside the current-month budget, allowing users to examine differences across revenue, gross profit, expenses, other income or expense, and net profit.

Operating Statement — Current Month Actual vs Current Month Budget

The same financial structure can then be extended into the year-to-date view, allowing users to examine cumulative performance against the planned figures.

Related Offerings

Year-to-Date Cost Center Performance

Moving From Monthly Results to Cumulative Performance

Monthly reporting shows performance within a specific accounting period. Year-to-date analysis provides a broader view of cumulative financial performance.

The dashboard supports two important YTD perspectives.

Actual YTD vs Previous Year

The March 2021 operating statement compares year-to-date actual performance with the corresponding previous-year figures.

Operating Statement — YTD Actual Performance Compared With the Previous Year

Actual YTD vs Budget YTD

The December 2025 view provides another perspective by comparing Actual YTD with Budget YTD.

Operating Statement — Actual YTD Compared With Budget YTD

These two views allow cumulative performance to be considered against both:

Historical Performance and Planned Performance

Multi-Point Variance Analysis

Examining Financial Movement From Multiple Reference Points

For detailed financial reporting, variance analysis cannot always be reduced to a single comparison.

The November 2025 reporting view brings several reference points together:

• Actual MTD
• Budget MTD
• Budget Variance %
• Last Month
• Last Month Variance %
• Actual YTD
• Budget YTD
• YTD Variance %
• Last Year
• Last-Year Variance %

Multi-Point Financial Variance Analysis — MTD, Budget, Last Month, YTD and Last-Year Comparisons

This provides a broader view of financial movement across both monthly and cumulative reporting periods.

The analytical flow becomes:

Actual Performance → Budget → Previous Month → YTD → Previous Year

This is particularly useful when reviewing financial movement across a large cost center reporting structure.

Analyzing Financial Performance Across Business Dimensions

From Cost Center Detail to Organizational Context

Cost center information becomes more meaningful when it can be examined within its broader organizational context.

The dashboard provides filters for:

• Company
• Region
• Division
• Branch

Financial Performance Analysis Across Company, Region, Division and Branch

These filters provide the organizational context needed to examine financial performance at different levels while retaining the underlying financial measures and comparison framework.

689 GL Code Cost Centers

Built Around Detailed Cost Center Reporting

The defining scale of this project is 689 GL Code Cost Centers.

The customized mapping structure across Levels 1, 2 and 3 provides the classification framework for organizing this information within the reporting environment.

Rather than treating the cost centers as an isolated list of GL codes, the mapping provides a structured way to organize them for financial analysis.

This creates the foundation for connecting:

GL Code Cost Centers → Cost Center Mapping → Financial Performance

The cost center structure is therefore a core part of the reporting solution, supporting detailed financial analysis while the dashboard provides broader period and organizational comparisons.

Controlled Financial Access With Microsoft Fabric

Governing Access to Financial Information

Detailed cost center reporting also requires appropriate control over access to financial data.

For this solution, Microsoft Fabric Row-Level Security is used to govern access to financial information.

This is particularly relevant to a reporting environment covering 689 GL Code Cost Centers and multiple organizational reporting dimensions.

The access model forms part of the reporting solution, helping govern which financial information is available within the defined access boundaries.

The solution therefore brings together:

Detailed Cost Center Reporting + Financial Analysis + Governed Data Access

Data Foundation

Bringing the Reporting Sources Together

The cost center reporting environment is supported by three stated data sources:

Snowflake Data Warehouse

Snowflake provides the data warehouse component of the reporting foundation.

Info R - M3 System

Info R - M3 System contributes source information used within the financial reporting environment.

Customized Excel Cost Center Mapping

The Excel mapping file provides the customized Level 1, Level 2 and Level 3 cost center structure supporting the reporting of the 689 GL Code Cost Centers.

Together, these sources provide the data foundation for the Power BI and Microsoft Fabric reporting environment.

Recommended Website Architecture

Project Outcome

A Cost Center-Centric View of Financial Performance

The solution brings detailed cost center reporting and broader financial analysis into one reporting environment.

At its core, the project combines:

• 689 GL Code Cost Centers
• Level 1–3 Cost Center Mapping
• Current-period financial reporting
• Budget comparison
• Previous-month comparison
• Previous-year comparison
• YTD analysis
• Multi-point variance analysis
• Company, Region, Division and Branch filtering
• Fabric Row-Level Security
• Snowflake data
• Info R - M3 data
• Customized Excel cost center mapping

The result is a reporting environment built around the requirements of cost-center-level financial analysis, allowing users to examine financial performance across periods and organizational dimensions while maintaining the defined cost center structure and access controls.

From Cost Center Structure to Financial Insight

Explore the Dashboard

Explore the dynamic financial reporting dashboard and see how 689 GL Code Cost Centers, multi-level mapping, financial comparisons, variance analysis and governed access come together in one Power BI and Microsoft Fabric reporting environment.

[View the Interactive Dashboard →]