Budgets can be created and tracked for reporting purposes to ensure expenditure is managed. There are several steps required to create budgets for analytical accounting dimensions.
The first step is to create a budget tree, which contains the selected dimensions. To create one, perform the following steps:
2017 MARKETING
in the Budget Tree ID field.2017 Marketing Budget
in the Description field.2017 Marketing Budget
, and click the Insert>> button to move it to the Selected Dimensions list.As many dimensions as required can be selected in the budget tree, so that a budget value can be assigned, and dimensions can be included in more than one budget tree.
Once the budget tree has been created, the budget tree codes need to be assigned. To do this, perform the following steps:
2017 MARKETING
in the Budget Tree ID field.<FIRST>
and <LAST>
respectively, but can be changed by either entering new values or performing a lookup.In this example, we'll assign budgets to all codes within the Marketing Channels dimension, so leave them as they are, and click on the Assign button.
This will add the selected dimension codes to the Dimension Code Tree list in the lower-right corner of the window; codes can be removed or added using the controls to the left.
With the budget tree set up and dimensions assigned, the budget amounts can now be entered. This is done in the Analytical Accounting Budget Maintenance window. To add budget amounts, perform the following steps:
2017MARKETING
in the Budget ID field.2017 Marketing Channels Budget
in the Description field.2017
.2017MARKETING
.$48,000.00
in the Amount field.$48,000.00
budget value will be evenly distributed in the Node Budget Amounts list.$2,000.00
, and the Period5 5/1/2017 value to $6,000.00
.$48,000.00
is at the top level of the budget, and needs to be rolled down to the dimension codes. To do this, click on the Node button to open the Node Budget Roll Down window.20.00%
in Facebook10.00%
in Google+40.00%
in Online Adverts30.00%
in TwitterThe budget that we have created is at dimension code level. Once a budget has been created and saved, it can be amended, and have more details applied to the budget by changing the Budget Level from Tree to Account. When this is done, each node in the Dimension Code Tree will need to have an account assigned.
If only a single account is required for a particular node, then this can be done by entering it in the Account field. If a range of nodes need to have the budget amount distributed, then open the Account Budget Roll Down window by clicking on the Account button.
The Analytical Accounting Budget Maintenance window is used to create budgets within Microsoft Dynamics GP, but can also be used to export a budget to Microsoft Excel, and then import it again.
To export a budget to Microsoft Excel, follow these steps:
2017MARKETING
in the Budget ID field.2017MARKETING
in the File name, and then click on Open.18.191.235.176