Skip to content
Bitta Apps

Chapter 3 of 4Page 1 of 4

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

  1. On the Financial Reports page, select a report, for example the income statement.
  2. Under Actions, choose Open in Sheet.
  3. 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.

Income statement for 2026 in a sheet by quarter with a total, and the period, department and customer group filters above it

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.
Insert financial report dialog with the budget filter, the display options, the title and company, Consolidate companies, and the name and place of the block

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.

General Ledger Entries for account 40140 Resale of Goods behind the fourth quarter sales

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.

Net Income calculation with the formula F0018+F0036, the gross profit and total expense rows, the calculated value and the result with the opposite sign

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.

Next step

Ready to try Bitta Sheets?