Projects

Budget settings

Manage standard columns, accounts, cost units and reusable budget structures

System → Budget maintains shared foundations for project budgets. The menu item requires the permission Budget settings (module System settings); depending on your further permissions, you see General, Account management and Budget templates. Changes affect new budgets or the master data available in existing projects.

TabAdditionally required permission
GeneralGlobal budget access
Account managementGlobal budget access
Budget templatesView budget templates; for changes Edit budget templates

Because these settings directly control project budget work, this manual places them in the Projects chapter.

General: names of the first columns

General defines the names of the first three columns in newly created budget tables. Enter a clear name for each and confirm it with the tick. Empty names cannot be saved. The names apply only to newly created budget tables; existing project budgets keep their column names. If account management is activated, columns 1 and 2 become select fields for accounts and cost units, and the names entered here then only serve as headings.

Choose terms understood across the organisation. Also consider integrations: with Sage enabled, the first two columns can represent debit account and cost unit and their order can be defined in tool settings.

Enabling accounts and cost units

The global switch in Account management determines whether accounts and cost units are used in every project budget as the first and second columns. Enable this only when master data is maintained and the budget workflow requires it. In the budget rows, accounts and cost units then always appear as number – name; the account search in the cell is described under Project budget.

An account contains:

  • account number,
  • description,
  • account type Expense account or Revenue account.

The account type controls where the account is offered: the account search in a budget row only offers expense accounts in the Expenses section and only revenue accounts in the Revenue section. If an account is missing from the search, check its account type first.

A cost unit contains a number and description. Both lists can be searched, extended and edited directly. Numbers and descriptions must be meaningful; descriptions are limited to 255 characters.

Deleting accounts and cost units

Artwork asks for confirmation before deletion. Deleted accounts and cost units appear in the tabs Accounts and Cost Units of the recycle bin, where they can be restored or removed permanently. You see both tabs with Global budget access; opening them, restoring and permanently deleting additionally require the permission Budget settings.

Check usage before deleting

A master-data entry may be used in several project budgets. Before deletion, check whether historical assignments, imports or evaluations depend on it. Renaming is more appropriate when only its label needs correction.

Budget templates

Budget templates preserve a reusable table structure with columns, main and sub-positions, rows and existing calculations and comments. They let new projects begin with a consistent calculation.

In Budget templates, you can search, expand and edit templates with the familiar budget tools. New templates are not created here: open the budget of a project and choose Save as template in the menu of the budget table. This requires the permission Edit budget templates. The template then appears on this tab. It also takes over the values in the cells; empty the table of the sample project beforehand if new projects should start without amounts.

Important limits apply when creating and using templates:

  • The Sage column and its bookings are not copied, neither when saving as a template nor when importing a template or another project. In the target project the Sage column is created again as soon as the first booking is assigned to a row there. Sum or difference columns that include the Sage column are kept and calculate without the Sage share in the copy, as do columns that build on such a sum Coming with the next update. Saving and importing also work when such a column comes before its source columns.
  • Links to specific funding sources are not retained.
  • Verifications are not taken over: positions of a template and of a budget created from it start unverified.
  • Applying a template to a project replaces its existing budget structure. In the project, Import template is therefore only offered while the table still has the empty base structure; see Budget templates.

A template replaces the project budget

Before applying one, check whether the project already contains required positions, comments, calculations, assignments or imported data. This is not merely an addition of a few rows.

Agree organisation-wide names for the budget columns.
Decide whether accounts and cost units are used globally.
Maintain complete, duplicate-free account and cost-unit lists.
Build and review a realistic budget structure in a sample project.
Save it as a clearly named budget template.
Apply the template to a test project and verify totals, calculations and columns.
Only then use it as a standard for further projects.

Daily work with positions, calculations, comments, approvals, funding sources and exports is covered under Project budget.

On this page