A common practice when preparing new year's budgets is to compare these new budgets to prior year values. Calxa has a number of report variations with either full year values, or monthly comparisons to achieve this.
Report Templates
Use the report builder to select one of the following report templates or variants.
Budget vs Last Year Actual
vs Last Year Budget
Budget vs Last Year Actual (12 Months)
vs Last Year Budget
& LY Actual & LY Budget
P&L vs Last Year Actual/Forecast (12 Months)
vs Last Year Budget (12 Months)
Report Date Criteria
Below are some suggested criteria for each report assuming you are preparing next year's budget in advance. That's why we are starting the reports in FY Start = 13.
Budget vs Last Year Actual
The period range From & To relates to the Budget dates, so you will set these to the new budget date range. In the example below it's the full next year range.
From: start of your budget period.
To: end of your budget period.
Using actuals up to: use this option to determine how the Last Year Forecast column is calculated based on available actuals and then budgets for the remaining months. Note the actual period set here is prior to the From or start of budget period.
Budget vs Last Year Actual (12 Months) & P&L vs Last Year Actual/Forecast (12 Months)
Set the start period for the 12 month budget you want to compare to the prior year.
Period: first period of your 12 month budget.
Using actuals up to: use this option to determine how the Last Year Forecast column is calculated based on available actuals and then budgets for remaining months. Note the actual period set here is prior to the From or start of budget period.
