Create Budget from Historical GL Balances in Business Central

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.

 

 

Privacy Preference Center