Actual v Budget
After importing the actual results, you can view the results under the Analysis tab which will look like this;
The YTD start month is based on the start month that appears under Projections.
When you drop down the Actual & Budget boxes you will notice various reporting options including;
- Budget LY; This will report Last Years Budget which is useful when setting a budget if you want to compare the Budget to Budget LY (ie this year v last year budget)
- Actual LY; This will report Last Years Actuals which is useful if you want to compare Actual to Actual LY (this year v last year)
- Act/Bud Forecast; This will report the Forecast for this year based on actual results to date and budgets for the remainder of the year. Eg, if you select Jul 18 to Jun 19 and the Profit and Loss shows Actuals to 31 Dec, then it will report the projected profit for the year based on actuals for the first 6 months and budgets for the second 6 months.
- Budget NY; This will report Next Years Budget which is useful if you want to compare Budget NY to Budget (ie next year budget v this year budget)
- Original Budget; This will report the Original Budget values.
When you Print the Actual v Budget report to pdf, it will print in the same format that is displayed. For example, if you have the Income expanded (as per above) but the Expenses collapsed, then it will report in this format. Under the Reports tab, you have the option to Print "Actual v Budget - Detailed" (ie all accounts expanded) or "Actual v Budget - Summary" (ie all accounts collapsed).
If you have multiple Divisions, you will see an option in the top right hand corner to select the Divisions (or multi- divisions). Any accounts ticked as"Inter-Entity" under Chart of Accounts will be excluded from "All Divisions".