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”, “AR aging as of 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 eliminations.

AR aging, with detail

One click for a fully formatted Accounts Receivable aging report, by due or posting date, down to the customer detail your collections team needs.

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 any figure to see the exact Business Central entries behind it. Your auditors will thank you.

Secure by design

Microsoft single sign-on, each user sees only what their Business Central permissions allow, and every access 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: a formatted Accounts Receivable aging report on its own sheet.
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. Nothing to deploy inside Business Central.

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.