How to Run Budget and Actuals Analysis-"Step-by-Step Guide"

The Budget vs Actual Report allows you to compare budgeted figures with actual results across three different time periods:

  • Selected Month - figures for the specific month chosen.
  • Year to Date - cumulative figures from the start of the financial year to the end of the selected reporting month.
  • Full-Year Budget - the total budget for the entire financial year.

Running Budget Analysis

To run a budget analysis, navigate to Budgeting -> Analysis -> New Analysis.


New Analysis Item

The following dialog box will be displayed:


New Analysis Input Parameters Dialogue

Select the budget, financial year, and month for which you want to generate the analysis.

The analysis will then be displayed on the screen.


Budget Analysis Report

To obtain a full-year comparison if actuals vs budget, you need to run the report for the final month of your financial year (e.g., December). When you do this, the figures will cover the entire financial year.

Example 1: Full-Year Comparison

  • Financial year: 01/01/2025 - 31/12/2025
  • Report run for: December (01/12/2025 - 31/12/2025)
  • Actual YTD: Total actuals from 01/01/2025 to 31/12/2025 (12 months)
  • Budget YTD: Total budget from 01/01/2025 to 31/12/2025 (12 months)
  • Variance: Difference between actuals and budget for the full financial year (01/01/2025 - 31/12/2025)

Example 2: First 5 Months Comparison

  • Financial year: 01/01/2025 - 31/12/2025
  • Report run for: May (01/05/2025 - 31/05/2025)
  • Actual YTD: Total actuals from 01/01/2025 to 31/05/2025 (5 months)
  • Budget YTD: Total budget from 01/01/2025 to 31/05/2025 (5 months)
  • Variance: Difference between actuals and budget from the start of the financial year to 31/05/2025 (5 months)
Choose report from the LHS tree view.

In the dialog box, select the budget, financial year, and specify how many months should use actual data and how many should use budget data.

>
New Actuals + Budget Report Input Parameter Dialog

The Actuals + Budget analysis will be displayed on the screen.


Actuals + Budget Profit & Loss Report

Use Budgeting -> Actuals+Budget ->New Actuals+Budget

Choose report from the LHS tree view.

Select Budget to use, Financial Year  and how many months should be actuals and how many budgets.

Actuals & Budget Report monthly.

The Actual + Budget analysis is displayed on screen.

Actuals & Budget Report