This guide outlines the configuration of basic budgeting in dynamics 365 FO and explains how the whole budgeting process works. It suggests action points to configure your basic budgeting seamlessly and explains different components of the configurations involved.

Using Basic Budgeting, the benefit you get is tracking the budget versus actual amounts. It doesn’t control your budgets neither it has anything to do with planning or forecasting the budgets. We will cover that in other articles related to budgeting.

Prerequisites

Before we get started with basic budget configuration, we need to ensure the following prerequisite configurations are taken care of.

Prerequisites for basic budgeting in dynamics 365 for finance and operations

1 Account Structures
Configuration of account structure is the first prerequisite, which needs to be configured properly along with the financial dimensions.

Navigate to General ledger > chart of accounts > structure > configure account structure

Account Structures setup for dynamics 365 for finance and operations

If you have specified multiple account structure, you need to click on each structure, ensure that all the structures are validated and dimensions are mapped properly.

2 Exchange Rates
For budget transactions pertaining to foreign currency accounts, the exchange rates are picked from the budget exchange rate type which is mapped in the ledger form. Specify the exchange rates if needed.

Navigate to General ledger > Currencies > Currency Exchange Rates

Currency Exchange Rate types setup for dynamics 365 for finance and operations

3 Ledger Setup
Here in this step we verify the budget exchange rate type is setup on the Ledger form, along with the fiscal calendar.

Navigate to General ledger >Ledger Setup > Ledger 

Ledger setup for dynamics 365 for finance and operations

4 Budget Journal
The budget data is entered through the Budget register entry form. A budget journal of Journal type Budget is setup in the journal form, to use the budget register entries.

Navigate to General ledger > Journal Setup > Journal Names

Journal setup for dynamics 365 for finance and operations

Basic Budgeting Setup

Now that we’ve setup the basic budgeting prerequisites, let’s get into the basic budgeting configuration. Here’s a diagram depicting all the setup components we need to configure.

1 Define Budgeting Parameters
The Budget parameters form allows you to enable budget transfers, and specify options for revenue budgets and subledger budget transfers.

Navigate to Budgeting > Setup > Basic Budgeting > Budgeting Parameters

  1. Select the budget journal that will be used for budget register entries.
  2. Time period for budget balances configuration takes care of the variance calculation in terms of budget versus actual amounts. We have 3 options here, let’s see how we can make use of it.
    1. Fiscal Period
      Restricts the balance to be used within a fiscal period. for example, The budget balance allocated to the month of January, will only be available for use in the month of January. It doesn’t take any previous period’s balance in consideration. Hence, if you overrun the allocated budget, it will be considered as variance.

      Available Budget Balance = Assigned Balance of the fiscal period – Actual Transactions posted.
    2. Fiscal Year
      if you want the system to look at the fiscal year’s budget, regardless of which fiscal period you’re in. If you have enough balance available for the year, the system will consider it as an available balance at any given date within the fiscal year.

      Available Budget Balance = Assigned Balance of the fiscal year – Actual Transactions posted.
    3. Fiscal Year to date
      if you want the balance of previous fiscal periods to carry forward to the current fiscal period (as of today). For instance, if there’s a balance $500 remaining in the previous periods budget, it will carry forward to the current fiscal period and will be available for use.

      Available Budget Balance = (Assigned Balance of the fiscal period + Previous Fiscal Period’s Balances) – Actual Transactions posted.

Find out more about how to configure the budgeting parameters here

2 Define Budgeting Dimensions
Use the Dimension for Budgeting form to specify which financial dimensions in the account structures that are associated with the chart of accounts are available for Budgeting.

Navigate to Budgeting > Setup > Basic Budgeting > Dimensions for Budgeting

3 Define Budget Models
Budget Models are the identifier of budget, whose budget balance is affected by the processing of a budget transaction.

Navigate to Budgeting > Setup > Basic Budgeting > Budget Models

Budget Models in dynamics 365 for finance and operations.

You can create a budget model that has submodels that represents various departments of the legal entity. For simplicity, we’ll create one model called ‘Default’.

4 Define Budget Codes
Budget Codes are used to categorize budget types. Budget Codes can be used to classify your budget transactions into different types.

Navigate to Budgeting > Setup > Basic Budgeting > Budget Codes

5 Define Budget Allocation Terms
Budget allocation terms provide an automated way to distribute percentages of budget amounts across financial dimension values.

Navigate to Budgeting > Setup > Basic Budgeting > Budget Allocation Terms

6 Define Budget Transfer Rules
In Budget transfer rules form you can define budget transfer rules to determine when budget transfers are allowed between financial dimension values.

Navigate to Budgeting > Setup > Basic Budgeting > Budget Transfer Rules

For example, budget transfers in a specific department might be allowed without approval, but transfers across departments might have to be reviewed and approved before the budget balance is adjusted. When a budget register entry is submitted and it violates the budget transfer rules, the transfer can be completed only if it is approved through a Budgeting workflow.

If you see the error message: No budget transfers are allowed outside of these rule lines unless you use workflow to approve the transfer. select Use rules for budget transfers in the Budget parameters form.

7 Define Budgeting Workflows
Some organizations require that budget register entries and budget account
entries be approved by a user other than the person who entered them. You can
require manual approval, workflow approval, or no approval.

Navigate to Budgeting > Setup > Basic Budgeting > Budgeting Workflows

That’s all for the configuration, let’s see the budgeting process in action.

Basic Budgeting Process

Budget Register Entries

All the budget related transactions are posted through budget register entry form. We will create the budget for a single main account, Telephone expenses to demonstrate how the process works.

Navigate to Budgeting > Budget register entries and click New from the ribbon.

Budget register entry for dynamics 365 for finance and operations
Make all the selections as shown here and select the desired Main Account.

Budget Allocation

After creating the line, you can perform the allocation on this line in a variety of ways.

1. Create Recurring Budget Entry

The Line Amount on the budget register entry can be replicated till the expiration date based on the specified interval. Simply asking the system, to duplicate the line by x times, so we don’t have to enter it manually.

  • Click on Enter Recurrence option as show above.
  • Specify the interval on which you would like the system to repeat the transaction
  • Specify the Interval type.
  • Enter the expiration date when you want the system to stop the recurrence pattern.
  • Hit the Create button once done.
System replicates the transactions for each period based on the recurrence pattern specified above.

2. Allocate Budget to dimensions

Amounts on budget register line can be allocated to different budget dimensions based on the specified percentages, as specified above in the configuration section.

click the Allocate to dimensions option to select the dimension allocation configured in the previous section.
  • Click on Allocate to dimensions option as show above.
  • Select the desired Budget Allocation Term
  • Hit the Allocate button.
Budget allocation in budget register entries in dynamics 365 for finance and operations.
Allocation is done by reversing the original line amounts, and then allocating the values to the dimensions.

3. Allocate Budget to Periods

Using the allocate across period button, you can allocate the amounts across specified periods.

Allocation the line amount based on the period allocation key selection.

Upon selection of the period allocation key, the system allocates the selected line amount to different periods.

Period allocation in budget register entries

So using the different allocation methods we have available within the budget register entries form, you can perform an efficient allocation of budgetary amount. Once you are satisfied with the desired results of your budget entries, click Update Budget balance button on the top of the register.

Update budget balance button updates the selected ledger account balances in the system as budget amounts.

Once the balances have been updated, you can see the verify the budget balances by going to the Budgeting > Inquiries and Reports > Basic Budgeting > Actual Vs. Budget

Actual vs. budget can be generated based on different dimensions sets
  • Select the desired financial dimension set
  • Select the Budget model, on which the budget register entry was created.
  • Select the start and end dates.
  • Click on Apply Parameters
  • To see the period balances for the selected budget, click on Period balances Button.
Specify the parameters on the parameter fast tab to apply different parameters

That’s all about the basic budgeting for now. I’ll be covering other parts of the budgeting with a more deeper dive into the budgeting capabilities of dynamics 365FO in terms of budget controls and advanced budget planning.

Till then, see you next time šŸ™‚

Posted by:Ahmed Saif

I'm a Microsoft Certified Solution Architect with over 15 years of full life cycle ERP/BI implementations experience. I have worked on several projects as a Solution Architect with implementation across various industries for Enterprise Resource Planning and Business Intelligence Systems.

4 replies on “Basic Budgeting in Dynamics 365 FO

  1. Hi Ahmed,

    your article for Budget is user friendly. thanks for this. However, a while ago you also had an article on Budget planning. But however, I do not see the link for that anymore.

    Request you to please update the same as it really help us.

    Regards,

Leave a Reply

Your email address will not be published. Required fields are marked *