A common practice near the end of the financial year is to compare your budgets for next year against your actuals from this year. If this year has not finished yet then you may want to compare against an end of year forecast. Calxa has the perfect report to do this. In the Spreadsheet Profit & Loss report group, you should use the Spreadsheet Variance with Last Year Forecast template. The trick is to start the report at the beginning of next year and use actuals up to your current actuals date. Calxa will forecast the remaining months in the current year and compare this to the next 12 months budgets.


Compare Next Year’s Budget to This Year’s Actuals


Let’s look at an example where June 2015 is the last month in your financial year and you have 10 months of actuals (up to April 2015). To run a report which compares your 2016 financial year budget to your 2015 actuals (10 months actuals, 2 months budget/forecast), here are the steps to follow:

  1. Go to Reports and select the Spreadsheet Profit & Loss report.
  2. Select the Spreadsheet Variance with Last Year Forecast template from the Report Templates.
  3. Set the Report Month to the start of your 2016 financial year, which is July 2015.
  4. In report criteria, set the Starting From date to FY Period 1 (Jul 2015).
  5. In report criteria, select Using Actual figures up to Fixed Date of Apr 2015. * To run a report at year end including the full year’s 2015 actuals, set actuals up to Jun 2015.
  6. In report criteria under Budget Versions, Forecast Budget Version, select the budget version you want to use for both the next year’s budget and current year’s forecast months.

compareNYB2TYA  1


Click on Display Report.  The layout of the report is as shown below:

compareNYB2TYA  2


Compare Next Year’s Budget to This Year’s Budget


Another report you may wish to run at the end of the financial year is to compare your budgets for next year against this year’s budget. In this example the last month in the financial year is June. To run a report which compares your 2016 financial year Budget to your 2015 Budget follow these steps:

  1. Go to Reports and select the Spreadsheet Profit & Loss report.
  2. Select the Spreadsheet Variance with Last Year Budget template from the Report Templates.
  3. Set the Report Month to the start of your 2016 financial year, which is July 2015.
  4. In report criteria, set the Starting From date to FY Period 1 (Jul 2015).
  5. In report criteria, do not select Using Actual figures up to check box.
  6. In report criteria under Budget Versions, Forecast Budget Version, select the budget version you want to use for both the next year and current years’ Budgets.

compareNYB2TYA  3



Click on Display Report.  The layout of the report is as shown below:


compareNYB2TYA  4