The Management Report displays the selected period's actuals vs budgets, as well as the original budget vs current budget, against ledger codes. This article explains how to set up the required configuration and how the report is structured.
Prerequisites: Enable Ledger Groups
The Management Report requires Ledger Groups to be enabled before it can be used. To enable this:
Go to System Set-Up.
Click Ledger Options.
Select Use Ledger Groups.
Ledger Groups can be disabled at any time by unticking Use Ledger Groups.
Create and Order Ledger Groups
Once Ledger Groups are enabled, you can create them by:
Go to Codes, then click Chart of Accounts.
Select Ledger Groups.
Groups can be reordered by dragging the move icon to arrange them in the required order.
Map Ledger Groups to Ledger Codes
Ledger Groups can then be assigned to the relevant ledger codes by:
Go to Codes, then click Chart of Accounts.
Select Ledger Group Mapping.
Once mapped, ledger codes will be grouped under their assigned group heading in the report.
How the Report is Structured
When the report is generated, it separates income and expenditure into three subgroups:
Income.
Staffing Expenditure.
Other Expenditure.
Further analysis by individual ledger codes is available by clicking the + icon to the left of a ledger group name.
The report is broken down into three columns:
Period — actuals for the selected period vs the current budget (as set under Budgets > Manage Budgets). For example, if Period 4 is selected, actuals will be shown for Period 4.
YTD Totals — actuals for Periods 0 through to the selected period, vs the current budget for the same period range.
Full Year — the Original Budget vs the Current Budget (Forecast) for Periods 0 through to the selected period.
📌 Note: This report will include any balance sheet ledger codes that are assigned to a ledger group. If these should not be displayed, set the ledger group for those codes to MISC - Unmapped Codes.