Microsoft D365 Business Central General Ledger (GL) is a set of numbered accounts a business uses to keep track of its financial transactions and to prepare financial reports. Each account is a unique record summarizing each type of asset, liability, equity, revenue and expense.
Budgets play an important role in business intelligence, such as in financial statement based on account schedules that include budget entries or when analyzing budgeted versus actual amounts in the chart of accounts.
You can have multiple budgets for identical time periods by creating budgets with separate names. Initially setup the budget name and enter the budget figures. The budget name is then appended on all the budget entries you create.
When you create a budget, you can define four dimensions for each budget. These budget-specific dimensions are called budget dimensions. Choose the budget dimensions for each budget from among the dimensions you have already set up. Budget dimensions can be used to set filters on a budget and to add dimension information to budget entries.
MS D365 Business Central General Ledger Budgets Creation
- Choose the search icon, enter G/L Budgets and then select the related link.
- Select the Edit List action and then fill in the fields as necessary. Go 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 shown.
Only entries that contain the budget name that you entered in the budget Name field are displayed. Since the budget name has just been created, there are no entries that match the filter. Hence, the page is empty.
- To enter an amount, choose the relevant cell in the matrix. The G/L Budget Entries page gets displayed.
- Create a new line and fill in the Amount field. Close the G/L Budget Entries page.
- Repeat steps 5 and 6 until you have entered all of the budget amounts.
Exporting and Importing G/L Budgets with Excel
As for practically all other pages, it is possible to export data on budget pages to Excel for further processing or analysis. If required you can work with your data from Business Central in Excel, you can open all lists in Excel and work with it there. Similarly, if you want to cancel your subscription for Business Central, you can export your data to Excel so that you can take it with you.
1. Opening Lists in Excel
Data in Excel can be opened from any journal, list, or worksheet. Just open the page that you want, and then select Open in Excel. For example, open the list of customers and then select Open in Excel. Your browser will open a pop up and ask you to open or save the generated Excel workbook.
Each list includes a number of columns, and the export to Excel will add any columns that are in your current view. If you want to add or remove the columns before you open the list in Excel, open the shortcut menu for any column and then specify which columns that you want to see.
2. Exporting Data to Other Finance Systems
If you decide to cancel your subscription for Microsoft Dynamics 365 Business Central, you can export your data to Excel and take it with you to your next finance system.
You can export all pages, of course, but that might be more than you really need. So consider exporting the following essential pages, and remember to add all columns:
- Chart of Accounts
If you want all your financial transactions as well, this is a large amount of data, so the export will often take more than a few minutes of time. For more information on Microsoft D365 Business Central General Ledger Budgets, please contact us.