This article explains how to review your Actual v Budget results under the Analysis tab after importing actual results. It covers the available comparison options, display settings, and export formats so you can tailor reports for your needs.
Use this report when you want to:
• Compare actual results to budgets or forecasts.
• Analyse year-to-date or prior-year performance.
• Review results across divisions, segments, or groups.
• Export formatted reports for client or management reporting.
The Actual v Budget report lets you analyse performance across multiple periods and reporting levels using flexible comparison and display options.
Go to Analysis → Actual v Budget.
Once you’ve imported your latest actual results, the report displays Actual and Budget figures side by side for the selected period.
Use the Compare drop-down to choose how results are compared:
YTD (default) – compares Actual v Budget for the current financial year to date.
A “YTD from month” field appears when this option is selected.
Magnifi remembers this setting for future reports, so you only need to change it if you wish to update the starting month.
Last Year – compares Actual v Budget v Last Year.
Blank – compares Actual v Budget only. Use this when you want to view results for a single period or avoid YTD comparisons.
The Display drop-down lets you choose how results are calculated and displayed. Common options include:
(Forecast incl YTD Actuals) v Budget
Creates a full-year forecast by combining actual results to date with budget values for the remaining months.
The forecast is then compared to the annual budget.
Example: If actuals exist to December 2025 and you select July 2025 – June 2026, Magnifi uses actuals to December and budgets from January to June.
Budget Next Yr v Forecast This Yr
Compares next year’s budget to the current year’s forecast (actuals to date + budget for the remaining period).
Example: Selecting July 2025 – June 2026 compares Budget July 2026 – June 2027 with Forecast July 2025 – June 2026.
Actual v Original Budget
Compares actual results to your Original Budget (if it has been saved).
You can also create your own report layout using the Actual and Budget drop-down filters.
Options include:
• Actual
• Budget
• Budget Last Year
• Last Year
• Act/Bud Forecast (actuals to date + remaining budgets)
• Budget Next Year
• Original Budget
Use the expand / collapse icons to switch between summary and detailed account views.
Choose how broadly you want to view results:
• Division – shows results for a single business unit.
• All Divisions – shows consolidated totals for all divisions within a single file.
•Segment – combines selected divisions into a single view.
•Group– consolidates multiple files (organisations) and can be exported for group-level reporting.
• Print to PDF – prints exactly as displayed. If Income is expanded and Expenses collapsed, the PDF keeps that format.
• Export to Excel – includes both Summary (by category) and Detailed (by account) worksheets.
At the All Divisions level, the export also includes:
• Divisions Actuals – summary of actual divisional results side by side.
• Divisions Actuals Detail – same as above, at account level.
• Divisions Budgets – summary of budgeted divisional results.
• Divisions Budgets Detail – detailed budget accounts.
• Actual v Budget Summary per Division – each division appears as a separate worksheet.
Tip: You’ll see an Unallocated line for accounts not assigned to a division.
Use this as a quick integrity check or to explain why the sum of divisions may not equal the organisation total.
At the Group level, the export includes:
• Organisation Actual – summary of actual organisation performance.
• Organisation Actuals Detail – detailed account results.
• Organisation Budgets – summary of organisation budgets.
• Organisation Budgets Detail – detailed account results.
Go to Dashboard for a high-level summary.
The Overview and Profit pages show Actual v Budget by category with interactive drill-downs:
a. Click a category to view the top 5 over- or under-performing accounts.
b. Click an account to view transactions (available if nightly imports are enabled).
Click on the chart icon next to the account category under Dashboard - Profit for trend analysis
• To compare Actual v Budget using your original projections, save an Original Budget before updating forecasts.
• If you use inter-entity or inter-group transactions, run Profit → Profit and Loss. The export includes a worksheet showing these balances, which should reconcile to nil.
• The reporting layout follows how your accounts are structured in the Chart of Accounts. See Account Categories for more detail.