Skip to main content

Budget accounts

What are budget accounts?

Budget accounts are used to allocate your budgets to your reporting. This is done by linking them to mappings.

E.g. in my budget I have a caption 'Personnel Costs - SLS'. To allocate this to the reporting line 'Personnel Costs - Sales' I link the Budget account 'Personnel Costs - SLS' to '620200 - SLS' in column mapping. The Mapping '620200 - SLS' is allocated to the Report line 'Personnel costs - Sales' in the mapping table

The table Budget Accounts contains the following required fields:

  • Budget Account: Unique name of the budget account.
  • Mapping: a link to the mapping where you want to allocate the budgets linked to the budget account to.

Next to this there are optional fields that are used for automated forecasts or are just imformative:

  • Payment term: Used for the automated forecast "net working capital budget". This field is used to indicate the number of months delay a cash flow has versus revenue and costs in the respective budget account. E.g. If budget revenue in period 1, but the payment of this revenue will only be in period 3. Set this field to 2 months.
  • Budget account payment: Used for the automated forecast "net working capital budget". This field is used to select the budget account that is use to forecast the cash flow mutation of the payment terms. E.g. the example above: the revenue is made in period 1, but cash is only expected in period 3. Set this field to the budget account linked to your accounts receivable. This way we will decrease your cashflow in period 1 and increase it in period 3 when using "net working capital budget".
  • Comment: optional comment
Make sure that the name used as Budget Account is identical to the Budget Accounts used in the Budgets. Make sure not to have spaces at the start or the end of your Budget Accounts.

You upload your Budget accounts via CSV or enter them via the user interface via the tab 'Budget Accounts'

To create a Budget Accounts via the Monitr user interface:

  1. Go to tab 'Budget Accounts'.
  2. Add rows by clicking ' insert row'
  3. Give the Budget Accounts a name link it to a Mapping
  4. Repeat this untill you have made the Budget Accounts you need . Click
  5. If any errors occur they will be highlighted in red. Your data will not be saved.
  6. Fix the errors and click untill the report is succelfully saved


The following validation checks are performed:

The name of the Budget Account should be unique