TRANXACT.AI Help
Accounting › Budgeting

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

  1. Module: Accounting
  2. Group: Planning & Control
  3. Section: Budgeting
  4. 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.

ColumnKindField name
VersionCodecode
NameTextname
YearNumberfiscal_year
KindStatuskind
WorksheetsNumberworksheet_count
SubmittedNumbersubmitted_count
RequestedAmounttotal_requested
Submit byDatesubmit_by
LockedYes or nolocked
StatusStatusstatus

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.

FieldTypeChoicesNotes
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

On each row of the list. Offered only on records where it applies.

Asks for: Increase or decrease, % And a fixed amount per line

Adjust by % or amount

On each row of the list. Offered only on records where it applies.

Asks for: % Amount Only account type Only department Only account Only fund

Consolidation

On each row of the list.

By fund, with departments not yet submitted

By department

On each row of the list.

Town-wide (all worksheets)

On each row of the list.

History and proposal

On each row of the list.

Five past years, YTD, original, amended, projected, requested and adopted

One-time and annual requests

On each row of the list.

Lock

On each row of the list. Offered only on records where it applies.

Unlock

On each row of the list. Offered only on records where it applies.

Adopt

On each row of the list. Offered only on records where it applies.

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

On each row of the list.

Government-format budget document and GFOA checklist

Budget book (HTML)

On each row of the list.

Export for budget book platform (JSON)

On each row of the list.

Export accounts (CSV)

On each row of the list.

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:

Beside it in Budgeting