MAT Finance - Management Accounts Reports - By Cost Centre Update
Reports > Finance > Management Accounts
A new reporting option has been introduced to Management Accounts(MA), allowing users to view data by Cost Centre instead of MA Ledger Mappings. This enhances financial reporting by enabling targeted analysis at the Cost Centre level.
Feature Overview
New "Report By" radio button options have been added to the Management Accounts criteria page.Users can choose between:
MA Mappings – retains the existing report format.
Cost Centre – activates the new cost centre based format.
Criteria Page Changes
Cost Centre Group multi-select dropdown is shown when "Cost Centre" is selected.
Default selection includes all Cost Centre Groups.
Existing options such as Financial Year, Site, Periods, Budget, and Commitments remain.
Report Format by Cost Centre
The report displays each Cost Centre Group as a heading, with listed Cost Centres underneath.Columns include:
Previous Year Actuals
Actuals
Commitments
Budgets
Variance
Spent %
Black for positive/surplus values
Red and brackets for negative/deficit values
Budget column differentiates income and expenditure:
Income shown as negative (black)
Expenditure shown as positive (red)
Totals and Calculations
Totals are shown:At Cost Centre Group level
At the bottom of the report under "Surplus / (Deficit)"
Each numeric column includes subtotals and overall totals.
Spent % calculated as:
(Actual + Commitments) / Budget
This enhancement offers a more granular view of Management Accounts, making it easier for MAT finance users to analyse and report financial activity by Cost Centre.