Skip to main content
client consulting with agent

How to Create a General Ledger Budget in Business Central

Do you want to learn how to create a general ledger budget in Business Central? If so, then this article is for you. See the steps here.
banner background

In Microsoft Dynamics 365 Business Central, you can create multiple budgets and copy, import, or export budgets. The steps outlined in this FORsights™ article show how to create a general ledger budget in Business Central. This can be an important tool for companies as the budget feature in Business Central can help measure the business’s actual financial operation against its forecast.

Steps to Create a New General Ledger Budget

  1. In the search bar, enter “G/L Budgets,” and then choose the related link.
  2. Select “New” to create a new budget.
  3. Name the budget and provide a description if needed; then add any applicable dimension information.

New General Ledger Budget

  1. Select “Process” and then “Edit Budget.”
  2. Next, the budget page will appear.
    1. Show as Lines and Columns automatically populate as G/L Account and Period, but these can be changed if needed.
    2. Also, the view defaults to Month, but this can be changed, too.

Edit-New General Ledger Budget

  1. The G/L Accounts listed in the Budget Matrix default to your Income Statement Accounts; use the Filters section below to update what appears in the Budget Matrix.

Update Filters New General Ledger Budget

Export & Import Data With Excel

Business Central includes an add-in for Microsoft Excel so you can edit data in Excel. You can export data on budget pages to Excel for further editing or processing.

  1. To export data, go to Process and then Export to Excel.

Export Data New General Ledger Budget

  1. A new screen will open where you can select the start date, number of periods you want to import, period length, column dimensions, and any other relevant filters.

Select Data Export New General Ledger Budget

  1. Select OK to continue.
  2. This will open an Excel sheet with all your G/L Accounts with columns for the Department Code and all the periods (in this example, “months”).

Excel Sheet With GL Accounts

  1. To enter the budget amounts, fill out this sheet, save it, and exit the file.
  2. Then, go back to Business Central in the same G/L Budget and select Process > Import from Excel.
  3. A pop-up screen will appear with Options fields to confirm the budget name, add or replace entries, and add description information.

Popup Screen Options to Confirm

  1. Enter the Options information and select OK.
  2. Next, upload the Excel file you saved.
  3. Once the data populates in Business Central, you can drill down into the blue numbers for further examination.

Budget Matrix Blue Numbers to Confirm

Now, you can use the budget in your account schedules to show budget versus actual figures.

While this article shows steps for how to create a general ledger budget in Business Central, the Business Technology Solutions team at Forvis Mazars can offer more guidance and services. As a Microsoft Dynamics Gold Partner and 2022–23 recipient of the Microsoft Inner Circle award, we’re here to assist with your Business Central and business technology needs. Use the Contact Us form below to send a message.


Related FORsights

Like what you see?
Subscribe to receive tailored insights directly to your inbox.