TRANXACT.AI Help
Accounting › Budgeting

Worksheet Lines

Each account on a worksheet: history beside it, the request by level, quantity x unit cost, a trend method, a link to another line, one-time or annual, a strategic goal, justification and a 500-character memo.

Where to find it

  1. Module: Accounting
  2. Group: Planning & Control
  3. Section: Budgeting
  4. Screen: Worksheet Lines

Address in the console: /accounting/budget-worksheet-lines

List · 12 columns · 18 fields on its form · 2 of them required · 2 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
WorksheetCodeworksheet_no
AccountCodeaccount_no
NameTextaccount_name
FundCodefund_code
LevelStatusrequest_level
Prior actualAmountprior_actual
Current budgetAmountcurrent_budget
RequestedAmountamount_requested
RecommendedAmountamount_recommended
One-timeYes or nois_one_time
ApprovedYes or noone_time_approved
GoalCodegoal_code

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
Worksheet required Choice Looked up from existing records
Account required Choice Looked up from existing records
Department Choice Looked up from existing records
Fund Choice Looked up from existing records
Level Choice Reduced, Current, Expanded
How the request is computed Choice Entered, % of last year's actual, % of last budget, Straight line (as last year), Quantity x unit cost, % of another line (e.g. benefits of salary)
Percentage Number
Quantity Number
Unit cost table Choice Looked up from existing records
Unit cost Number
Follows line Choice Looked up from existing records
% of that line Number
Requested Number
Recommended Number
One-time expenditure Yes or no
Strategic goal Choice Looked up from existing records
Justification Long text
Memo (500 characters) Long text

What you can do here

Approve one-time

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

Asks for: Approved

Move to another worksheet or level

On each row of the list.

Asks for: Worksheet Level

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