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'

Via User Interface

You can either upload a pre-defined template (such as this file) or use tabsheet 'Budget Accounts' our google sheets template to define your Cash flow statement.

Definition

Complete the folowing fields in the template

• Name [string]: This is a unique name
• Mapping [string]: The Account Mapping Name of the Mapping to which the Budget Account is linked. Used to link the Budgets to the Balance Sheet and Profit & Loss statement.

Validation

Make sure these validations rules are respected:

The Name of the Budget Account should be unique
A mapping to a reporting line needs to be made in Reporting ID

Upload your template

1. Make sure the status of all validation rules in the tabsheet 'Budget Accounts' of the template is 'TRUE'.
2. Copy the definition (columns with a dark blue header) in to a csv file and save it on your computer.
3. Go to tab 'Reporting' - 'Budget Accounts'.
4. Click
5. Browse to the CSV file on your computer and select and click 'Open'.
6. Click
7. If any errors occur they will be highlighted in red. Your report will not be saved.
8. Fix the errors and click untill the report is succelfully saved

Via CSV

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

Validation

The following validation checks are performed:

The name of the Budget Account should be unique