Budget Preparation
One pass of the budget: next year's proposal, a re-forecast or a what-if. Build department worksheets from zero, the original or amended budget, prior actuals or a multi-year average; adjust by % or amount; consolidate; adopt.
Where to find it
- Module: Accounting
- Group: Planning & Control
- Section: Budgeting
- Screen: Budget Preparation
Address in the console: /accounting/budget-versions
List · 10 columns · 14 fields on its form · 2 of them required · 14 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 |
|---|---|---|
| Version | Code | code |
| Name | Text | name |
| Year | Number | fiscal_year |
| Kind | Status | kind |
| Worksheets | Number | worksheet_count |
| Submitted | Number | submitted_count |
| Requested | Amount | total_requested |
| Submit by | Date | submit_by |
| Locked | Yes or no | locked |
| Status | Status | status |
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 |
|---|---|---|---|
| Name required | Text | ||
| Fiscal year required | Number | ||
| Kind | Choice | Proposed, Next year, Re-forecast (current year), What-if, Multi-year plan | |
| Start worksheets from | Choice | Zero (zero-based), Original budget, Amended budget, Current year budget, Prior year actuals, Average of past years' actuals | |
| From fiscal year | Number | ||
| Years in the average | Number | ||
| Budget type | Choice | operating, capital, project, grant, personnel | |
| Worksheets open | Date | ||
| Departments submit by (cut-off) | Date | ||
| Review by | Date | ||
| Adopt by | Date | ||
| Transmittal letter | Long text | Merge fields update themselves: {{fiscal_year}}, {{total:revenue}}, {{total:expense}}, {{fund:GF}}, {{account:5100}}, {{change_pct:expense}}. | |
| Adopting ordinance | Text | ||
| Notes | Long text |
What you can do here
Build worksheets primary
Asks for: Increase or decrease, % And a fixed amount per line
Adjust by % or amount
Asks for: % Amount Only account type Only department Only account Only fund
Consolidation
By fund, with departments not yet submitted
By department
Town-wide (all worksheets)
History and proposal
Five past years, YTD, original, amended, projected, requested and adopted
One-time and annual requests
Lock
Unlock
Adopt
Asks for confirmation: Adopt this version? It becomes the active budget; one-time items must be decided first.
Asks for: Spread to months Profile: twelve percentages
Budget book
Government-format budget document and GFOA checklist
Budget book (HTML)
Export for budget book platform (JSON)
Export accounts (CSV)
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.