Budget Forecasts & Scenarios
Named forecasting models: straight line, % of last year's actual or budget, an average of past years or your own growth rates, 1 to 30 years ahead; lock a projection; what-if on a line or group.
Where to find it
- Module: Accounting
- Group: Planning & Control
- Section: Budgeting
- Screen: Budget Forecasts & Scenarios
Address in the console: /accounting/budget-forecast-models
List · 7 columns · 8 fields on its form · 2 of them required · 7 actions
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Model | Code | code |
| Name | Text | name |
| Method | Status | method |
| Growth % | Number | growth_pct |
| Years ahead | Number | horizon_years |
| Locked | Yes or no | locked |
| Run | Date and time | last_run_at |
The form
What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.
| Field | Type | Choices | Notes |
|---|---|---|---|
| Code required | Text | ||
| Name required | Text | ||
| Method | Choice | Straight line (trend), % of last year's actual, % of last budget, Average of 2 to 5 years, User-defined growth by account type | |
| Growth % a year | Number | ||
| Years of history | Number | ||
| Years ahead | Number | ||
| Base fiscal year | Number | ||
| Scenario assumptions | Long text |
What you can do here
Run primary
Five past and five future years
Ten-year outlook
Rest of this year
What if
Summary by category, nothing saved
Asks for: Change %* Only Accounts starting with
Lock projection
Unlock
* required
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.
- Creating a record — required fields, where choices come from, and how the number is allocated.
- Importing a spreadsheet — this screen accepts one, and it runs through the same rules as typing.