Setup and manage your Budgets / Forecasts and understand the display
- Setup - click
Update


-
- choose Account Type(s) you wish to build a Budget for
- choose the Base you are building the Budget on:
- Previous year actual
- Previous year budget
- Same year actual
- set the Year for which you are building this Budget - This Year / Next Year
- establish a Nominal growth rate % or leave blank for no change from Base selected
- select number of decimals to Round to
- click OK
- View
- select from tabs Budget / Forecast / Actual (in this example, all are displaying)
- select which Year you wish to display (in this example, This Year is displaying)

- Indicators
- green - Actual is on Budget
- red - Actual is above Budget
- yellow - Actual is below Budget
Chart - on the selected GL Account for and instant status

-
Export the display to Excel using .xlsx or .csv formats
-
- choose the location File Name, and Save as type
- Save
- option to Open File right away
- from excel, make any changes or build any desired formulas
-