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, You can use the Start Period that best represents your needs:
For example, if your financial year starts on July 1, ensure that this date aligns with the Start Period settings in your report to accurately reflect the desired year's data for comparison.
Budget vs Last Year Actual
This Financial Year Budget
Next Financial Year Budget
Budget vs Last Year Actual (12 Months) & P&L vs Last Year Actual/Forecast (12 Months)
This Financial Year Budget
Start Next Financial Year
Additionally, to compare 'Budget for 12 Months' with 'Last Year Budget,' make sure both budgets are present in the same version for a precise evaluation.
Identifying and Viewing KPI Values in Reports
To include KPI or Account Group values in your reports for a specific financial year:
Choose a Suitable Template: Opt for 'Actual vs Budget' or 'P&L with Projected Total' templates to enable the addition of KPIs.
Set the Time Frame: Match the report's date range with your financial year (e.g., July 1, 2023, to June 30, 2024).
Activate KPIs: Toggle the KPI settings through the cog icon and select KPIs relevant to your needs.
Customize Formatting: Modify KPI settings such as removing decimal places or symbols for better alignment with the report.
Additional Customization Tips
Utilize Filters: Isolate specific accounts or KPIs for a focused report.
Explore Templates: Try templates like 'Actual vs Budget with P&L' for diverse reporting needs.
Export Options: Export your reports to formats such as PDF or Excel for further customization.