Chapter 3 of 4
Financial reports and consolidation
Build financial reports and budgets on live data, write budgets back to the G/L, and consolidate several companies.
In this chapter
- 01Financial reports and budgetsRun Business Central financial reports in a sheet by period and department, drill down to the G/L entries, and change a G/L budget and write it back.
- 02Consolidate companiesConsolidate group companies in one Business Central workbook: set up companies, period and group chart, map accounts, handle ownership, rates and eliminations.
- 03Budgets with write-backOpen a G/L budget in a sheet, start from last year's actuals, change it by a percentage, type amounts and formulas, then check and write it back to the budget.
- 04Metrics and the Financial Report APIUse Business Central financial report metrics in reports and workbooks, and set up the Financial Report API with addresses and snapshots for Power BI or Excel.
- No steps for this role in this part of the guide. Choose All to see every step.
next step