Skip to content
Bitta Apps

Chapter 3 of 4Page 4 of 4

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.
Financial Report Metrics with the 20 standard metrics and the actions Load Standard Metrics, Copy Metric, Test and Import and Export
Test Metric for Overdue receivables over 2026 with the value 102,438.49 from 607 records

Metrics in a report

  1. Open a row definition, and under Actions choose Insert Metrics from Library.
  2. Pick a metric, and choose OK. It's added as a row, with the totaling type Metric and the metric's code.
Row definition with three metric rows and the Actions menu with Metric Card, Test Metric Row, Insert Metrics from Library, Set Row to Metric and Metrics

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.
Metric card for AR-OVERDUE, Overdue receivables, reading the remaining amount of customer ledger entries as a sum

Metrics in a workbook

  1. In a workbook, on the Formulas tab, choose Metric. The same button is on the Insert tab and the Business Central tab.
  2. Pick the metric. A metric such as Active customers needs no period.
  3. 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.
  4. Choose Insert.
Insert metric dialog with Customer balances and the period 2026-01-01..2026-12-31

The cell holds a Business Central formula, such as =BC.SUM or =BC.COUNT, so the number stays live.

Workbook with Active customers 32 and Customer balances for 2026 as a live BC.SUM formula

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.

Studio Setup Integrations with the Financial Report API set up
  1. Open Financial Report API Setup and choose a Default Report, for example the income statement.
  2. 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.
  3. 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.
  4. Schedule sets up a job queue entry for the snapshot.
Financial Report API Setup with the default report IS and the actions API Addresses and Snapshots
Financial Report API Addresses with a description and entity set for the report cells, rows, reports and metrics
Message that snapshot IS-YTD was published with 30 cells

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.

Next step

Ready to try Bitta Sheets?