Exercise - Create and copy budgets
This exercise is written to use the Cronus sample company from the US version of Business Central. You might need to make adjustments to the steps if you use the sample company from your country or region.
Create a budget
You are the CFO at CRONUS and you need to set up a new January 2025 expense budget by department.
Name the budget EXP2025-Expenses by department 2025 and use the Budget Dimensions Department. The budgeted expenses are as shown in the following table.
| Department | G/L Account | Budgeted Amount |
|---|---|---|
| ADM | 61200 | 40,000.00 |
| PROD | 61200 | 56,000.00 |
| SALES | 61200 | 24,000.00 |
| ADM | 61300 | 8,900.00 |
| PROD | 61300 | 18,980.00 |
| SALES | 61300 | 21,000.00 |
Task
Set up the budget.
Steps
Select the Search for Page icon in the top-right corner of the page, enter G/L budgets, and then select the related link.
Select New.
In the Name field, enter EXP2025.
In the Description field, enter Expenses by department 2025.
Select Edit Budget.
In the Show as Columns field, select DEPARTMENT.
In the View by field, select Year.
Expand the Filters FastTab.
In the Date Filter field, enter 01/01/2025..12/31/2025.
In the G/L Account Filter field, enter 61200..61300.
In the Budget Matrix area, enter the amounts by using the table from the exercise introduction.
Close the Budget page.
Copy a budget
Now that you have entered the expense budget for 2025, you want to configure the 2026 budget by using the copy function. Because you expect to have higher expenses in 2026, you want to increase the 2025 budget amounts by 10 percent.
Task
Use the copy function to create the 2026 budget.
Steps
Select the Search for Page icon in the top-right corner of the page, enter G/L budgets, and then select the related link.
Select the EXP2025 budget.
Select Edit Budget.
Select Home> Copy Budget.
In the Copy from area of the Copy G/L Budget page, in the Source field, select G/L Budget Entry.
In the Budget Name field, enter EXP2025.
In the Date field, enter 01/01/2025..12/31/2025.
In the Dimensions field, select AssistEdit and then select the Selected option for dimension DEPARTMENT. Select Close.
In the Copy to area of the Copy G/L Budget page, in the Budget Name field, select the Lookup Value and then select New.
In the Name field, enter EXP2026.
In the Description field, enter Expenses by department 2026.
Select OK.
In the Apply area of the Copy G/L Budget page, in the Adjustment Factor field, enter 1.1.
In the Date Change Formula field, enter +1Y.
Select OK.
Select Yes.
Select OK.