Create G/L budgets
You can have multiple budgets for identical time periods by creating budgets with separate names. First, you set up the budget name and enter the budget figures. The budget name is then included on all the budget entries you create.
When you create a budget, you can assign budget-specific dimensions, called budget dimensions, for it. You can use budget dimensions to set filters on a budget and to add dimension information to budget entries. Learn more at Work with Dimensions.
Budgets play an important role in business intelligence. Examples include a financial statement based on financial reports that include budget entries or when analyzing budgeted versus actual amounts in the chart of accounts. Learn more at Business Intelligence.
In cost accounting, you work with cost budgets in a similar way. Learn more at Creating Cost Budgets.
To create a new G/L budget
Choose the
icon, enter G/L Budgets, and then choose the related link.
Choose the Edit List action, then fill in the fields as necessary. Hover over a field to read a short description.
Choose the Edit Budget action.
At the top of the Budget page, fill in the fields as necessary to define what is displayed.
The page shows only entries that contain the budget name you entered in the Budget Name field. Because you just created the budget name, there are no entries that match the filter. Therefore, the page is empty.
To enter an amount, choose the relevant cell in the matrix. The G/L Budget Entries page opens.
Create a new line and fill in the Amount field. Close the G/L Budget Entries page.
Repeat steps 5 and 6 for all amounts in the budget.
Note
On the Filters FastTab, you can filter the budget information by the budget dimensions you set up under the budget name.
Exporting and importing G/L budgets with Excel
As for practically all other pages, you can export data on budget pages to Microsoft Excel for further processing or analysis. Learn more at Exporting Your Business Data to Excel.
Note
The chart of accounts, which general ledger (G/L) budgets are based on, has lines of the account type Heading. These lines contain the total of the lines below it. When you export a G/L budget, you export data on all lines regardless of the account type. However, you can only import data on lines of the Posting account type.
Similarly, when you import a G/L budget, any values on Heading lines are deleted. They're deleted to avoid incorrect totals after you import data that was created or edited in Excel.
Scenario
You know that the new budgeted salaries cost is going to be local currency (LCY) 1.200.000. You want to enable the Salaries department to budget for the three specific lines (of the Posting account type) for full-time employees, part-time employees, and temp help. The three lines are grouped under a Salaries heading line.
You enter 1.200.000 on the Heading line, export the budget to Excel, then send it to the Salaries department, telling them to distribute the LCY 1.200.000.
The Salaries department distributes the amount on the three posting accounts. When you import back into the G/L budget, the three accounts are filled in with the new Excel data, summing to LCY 1.200.000, and the Heading line is blank.
See also
Exporting Your Business Data to Excel
Finance
Business Intelligence
Setting Up Finance
The General Ledger and the Chart of Accounts
Work with Business Central
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for