Financial reports and consolidation
Metrics and the Financial Report API
Use 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.
updated: applies-to: 1.0.0.0
Metrics are numbers that don't live on a G/L account, like open sales orders or overdue receivables. Financial report rows and workbooks can read them. The Financial Report API brings your financial reports into Power BI or Excel.
The metric library
Financial Report Metrics is the library.
- Load Standard Metrics adds 20 metrics, from posted sales invoices to employees at period end.
- Each metric reads a table and a field, with a method such as a sum or a count.
- New adds your own metric, and Copy Metric makes your own version of one, for example with another filter.
- Test calculates a metric for a period. Overdue receivables for 2026 come to 102,438.49, from 607 records.
- Import and Export move metrics to another environment.
- Block takes a metric out of use, and Unblock brings it back.
Metrics in a report
- Open a row definition, and under Actions choose Insert Metrics from Library.
- Pick a metric, and choose OK. It's added as a row, with the totaling type Metric and the metric's code.
From the same menu:
- Test Metric Row checks the selected row.
- Metric Card opens the metric's definition.
- Set Row to Metric turns the selected row into a metric row.
- Metrics opens the library.
Metrics in a workbook
- In a workbook, on the Formulas tab, choose Metric. The same button is on the Insert tab and the Business Central tab.
- Pick the metric. A metric such as Active customers needs no period.
- For a metric that reads dates, such as Customer balances, type the period, here 2026-01-01..2026-12-31, or point to a cell that holds it.
- Choose Insert.
The cell holds a Business Central formula, such as =BC.SUM or =BC.COUNT, so the number stays live.
The Financial Report API
For Power BI or Excel, start in Studio Setup. Under Integrations, the Financial Report API line shows whether it's set up.
- Open Financial Report API Setup and choose a Default Report, for example the income statement.
- API Addresses lists the addresses for the report cells, the rows, the reports and the metrics, each with the Power Query code to paste into Power BI or Excel.
- Snapshots store a report's cells, so scheduled refreshes read them fast. Choose New, then Publish Now to calculate one. The message says how many cells were published.
- Schedule sets up a job queue entry for the snapshot.
Back in Studio Setup, the Financial Report API line now says it's set up.
When to use it
Use metrics when a report needs numbers beyond the ledger, and the API when your reporting lives in Power BI or Excel. To run the reports in a sheet, see Financial reports and budgets.