Microsoft Dynamics 365 Business Central | Create Budget from History (G/L Balances)

Microsoft Dynamics 365 Business Central | Create Budget from History (G/L Balances)

Article by: Carlos Lozano – Microsoft Dynamics 365 Business Central Consultant

Creating a budget manually or from an Excel import file can be cumbersome, luckily there are a few excellent hidden features that allow you to quickly create a budget based on actual entries from the previous year and use that as the starting point for your budgets going forward.

Steps to Create a Budget from History:

Use the Alt+Q (Tell Me search tool) to search for G/L Budgets and select it from the list.

Select +New to create a new G/L Budget. Then, enter a Budget Name, on Show as Lines enter G/L Account, and complete the other options. Add or remove filters as need.

Select Balance under Budget Matrix and G/L Account Balance/Budget.

  • On the G/L Account Balance/Budget window, select Actions > Functions > Create Budget > From History…
  • On History Beginning Date enter the first day of your prior fiscal or calendar year.
  • On Budget Beginning Date enter the first day of the new budget year.
  • On of Periods, enter the number of periods for the Budget.
  • On Period Length select the Length of each Period.
  • On Percent Change specify if you want the Budget to increase in relation to the corresponding historical period.
  • On Round To specify the nearest value you want the Budget to be rounded to.
  • On Income/Balance, select if you want to create the Budget for Income Statement or Balance Sheet or both.
  • On enter a G/L Account to create a budget for one account or clear value to create it for all accounts.
  • On Filter totals by, specify any required filter, for example, Customer Group Small, if the Budget needs to be different for Dimension Customer Group.
  • Click OK to create the Budget.

Review the newly created Budget and make adjustments if necessary.

For adjustments, on the main Budget screen, select Budget > Export to Excel, make adjustments and click on Budget > Import from Excel to replace or add entries.

Now you can see actual entries for the new Budget with this useful, neat feature in Dynamics 365 Business Central.