Financial reports and consolidation
Financial reports and budgets
Run 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.
updated: applies-to: 1.0.0.0
Bitta Sheets runs your Business Central financial reports in a sheet. Pick the columns, the period and the departments, then drill into any number.
Open a report in a sheet
- On the Financial Reports page, select a report, for example the income statement.
- Under Actions, choose Open in Sheet.
- You get a workbook with the report's title, a period filter, and a filter for each dimension.
The numbers are the ones Business Central's financial report calculates, and every cell is read-only. Refresh the report at any time to read the latest postings.
Insert a report into any workbook
In a workbook, on the Insert tab, choose Financial report. To change a report that's already in the sheet, open its block settings. The settings are the same:
- Report: the financial report, its Columns preset, and the Budget the budget columns read.
- Period and filters: the period, a filter for each dimension, and a budget filter.
- Display: the rounding, how negative amounts look, whether zero amounts and the lines the report hides show, a Title, and the Company. Leave Company blank for the workbook's company.
- Name and place: the block's name and its top-left cell.
Columns
Columns has nine presets, such as actual, actual against budget, actual against last year, and twelve months:
- Four quarters and total splits the period into quarters, with a total.
- Actual vs prior year with variance puts the period next to the year before, with the variance.
- One column per company and consolidated shows each company of a group side by side, with the consolidated total. Consolidate companies chooses the companies, the ownership and the exchange rates.
A report can have up to 200 columns.
Want the same columns in Business Central's own financial reports? On the Financial Reports page, New Column Definition from Preset creates one in a single step: pick the preset, name the column definition, and choose OK.
Filter and drill down
Every dimension has its own filter above the report. Choose a department, for example Sales, and every number follows.
Double-click any amount, for example fourth quarter sales, and Business Central opens the G/L entries behind it.
See how a number is calculated
Double-click a total, such as net income, to see how it's calculated: the rows behind it, the calculation, and the result. When the report shows a row with the opposite sign, the last line says so: Result, with the opposite sign as the report shows it.
Budgets
A Budget block shows a G/L budget by period and dimension. Change amounts in the grid, copy them from actuals or change them by a percentage, and write them back to the G/L budget after a review. The steps are in Budgets with write-back.
Write-back goes through the Security Guard of Bitta Apps Studio and is recorded in the Studio Audit Log.
KPIs and charts
Add a KPI card or a Chart next to the report to show the numbers that matter at a glance.
Financial Report API
To read Business Central financial reports from Excel or Power BI, use the Financial Report API pages under bittaApps/financialReporting/v1.0.
When to use it
Use it for monthly and quarterly reporting, board packs, and any number someone asks you to explain. For a group, see Consolidate companies.