In this guide, we show How to Use the Budget Variances Report in the MAT Finance Module.
Access: The minimum permissions required to Use Budget Variances are found in the Finance Module section of Config > Setup > Roles & Permissions.
Data Access Controls (DAC): Users will only see data they are permitted to view, based on their assigned DAC filters for:
- Financial Years
- Sites
- Cost Centres
- Ledger Codes
If a User lacks access to any of the above elements, the relevant data rows and columns will be hidden from view.
Pre-requisites: In order to Use the Budget Variances Report, a Budget needs to be in place within the MAT Finance Module.
Related guides:
To begin, from the left Menu, go to Finance > Budgeting > Budget Variances.
If there is more than one Budget Scenario in place, choose which one to work with from the drop down.
Choose a Year up to Period. This is useful if Profile Models have been set, as spending against these can be monitored.
The Budget Variances Report is a very large table presented in an AG Grid. Columns can be removed to make it more manageable, or added to make it more detailed.
Similarly, Filters can be applied to reduce the number of rows.
The Report allows for the dragging and movement of Columns to reorder them to suit the user.
In addition, the Drag here to set row groups function allows for Column Headings to be dragged to the top left to set row groups.
In the example below, Columns and Filters have been selected to show the information required by the user.
Of note are the two editable Narrative Columns. The Variance Reason Column and Action Required Column can be used either as an aide-mémoire for the user, or as an explanation for other readers, such as the SLT or Governors.
The Report will always display Column Totals at the bottom of the page.
The Report is highly configurable. Report Parameters can be saved by clicking on the Save Icon and reset by clicking on the Reset Icon, both located at the top right of the screen.
The Report can be exported to CSV or Excel by Right Clicking within it and choosing the file type. The Report is sent to the Browser’s Downloads Folder.
Income toggle
To support different budgeting preferences, you can control how Income (IN Ledger Types) are displayed. This toggle affects totals, variances and percentages, ensuring figures remain accurate whichever view you choose.
When ON (default) income is displayed as positive values.
When OFF income is displayed as negative values, aligning with FMS-style reporting.
