For Microsoft Dynamics 365 Business Central

Ask for a report. Get it live in Excel.

Type what you need in plain English, “income statement for last quarter”, “AP aging as of last month end”, and IBB Reports builds it from your live Business Central data, tied to the ledger. Prefer a formula? Drop an IBB.* function in any cell. No exports, no copy-paste.

Start your 14-day free trial See the functions

Full feature trial Nothing leaves your tenant Single sign-on

The IBB Reports task pane in Excel: type 'income statement for last quarter' in plain English and it builds the report live from Business Central

Everything finance teams ask for

Reporting that lives where you already work

Stop rebuilding the same spreadsheets every month. IBB Reports turns Excel into a live window onto Business Central, by asking, by clicking, or from a formula.

New · Ask IBB

Reports in plain English

Describe the report and IBB Reports works out the statement, period, and company, then builds it live. Deterministic and auditable, and the interpreter runs inside your own tenant, no external AI.

Live data, from a formula

Type =IBB.NL or =IBB.GL in any cell and get real Business Central values back. Refresh and they update.

Financial statements

P&L, Balance Sheet, and Trial Balance built from your own Business Central account categories. They tie out to the penny.

New

Design your own reports

Build a layout once, columns like budget vs actual, prior period, % of row, or by dimension, save it to your license, and your whole team can run it.

Dimensions & consolidation

Filter and break out by any dimension, and roll up multiple companies into one consolidated view, with an eliminations column for your intercompany accounts.

AR & AP aging, with detail

One click for a fully formatted receivables or payables aging report, by due or posting date, with the Business Central entry number on every line.

Scheduled & burst delivery

Run a report on a schedule, split it by department or entity, and drop each slice to the right inbox automatically.

Drill down to the source

Click a general ledger figure to see the exact Business Central entries behind it. Your auditors will thank you.

Secure by design

Microsoft single sign-on, and every access to your Business Central data is logged.

The IBB.* function library

Ask it, click it, or write the formula

Everything the pane builds is also a function you can drop straight into a cell.

' Count of customers, live from BC
=IBB.NL("Count", "customers")

' Revenue accounts, this year
=IBB.GL("40000..49999", "", "2026-01-01", "2026-12-31")

' A full Balance Sheet that spills
=IBB.FS("balance", "", "2026-12-31")

' Sales by department dimension
=IBB.GL("40000..49999", "DEPARTMENT=SALES")

IBB.NL: rows, counts, and filtered lists from any Business Central table.
IBB.GL: general-ledger balances by account range, period, and dimension.
IBB.FS: complete financial statements that spill into a range.
IBB.AR & IBB.AP: receivables and payables aging detail that spills into a range.
IBB.NF & IBB.NP: single field lookups and reporting helpers.

New to functions? Start in the redesigned pane, ask for a report or pick one, and IBB Reports writes the formula for you.

Up and running today

Three steps from install to insight

Get it from AppSource

Install IBB Reports into Excel for your whole team in a couple of clicks. Aging reports also need our Business Central extension.

Sign in once

Ask, or write a formula

Type income statement for last quarter in the pane, or drop =IBB.NL("Count","customers") in a cell, and watch live Business Central data appear.