Actual v Budget in Magnifi

Actual v Budget

After importing the actual results, you can view the results under the Analysis tab which will look like this;




There are various options available when viewing this report including:
  1. Option to compare YTD (current option select) or Last Year. If you select Last Year, it will compare Actual v Budget v Last Year. If you only want to compare actual v budget, select the blank option.
  2. Various Display options including:
    1. (Forecast incl YTD Actuals) v Budget. Eg, if you select date range July 2023 to June 2024 and have actual results to December 2023, it will report the forecast values based on actuals to December and budgets for the remainder of the year. This value will then be compared to the budget for the year. 
    2. Budget Next Yr v Forecast This Yr. Eg, if you select date range July 2023 to June 2024 it will compare budget from July 2024 to June 2025 with forecast from July 2023 to June 2024 (based on actuals to date and budgets for remaining period).
    3. Actual v Original Budget. If the Original Budget has been saved, it will compare the actual results to the original budget 
  3. You can also select your own display option by dropping down the filter that appears within the Actual & Budget options.
  4. The report can be ran at a divisional or All Divisions (ie group) basis. If you have combined divisions to form segments, it can also be ran at a Segment level. 
When you Print the Actual v Budget report to pdf, it will print in the same format that is displayed. For example, if you have the Income expanded (as per above) but the Expenses collapsed, it will report in this format. If you export to excel it will include a summary & detailed worksheet. If you export at the "All Divisions" level, it will include other worksheets including a divisional summary.