For Microsoft Dynamics 365 Business Central

Your Business Central numbers, live in Excel.

IBB Reports adds simple IBB.* functions to Excel that pull real-time Business Central data straight into your worksheets. Build financial statements, slice by dimension, consolidate companies, and schedule the whole thing. No exports, no copy-paste.

Start your 14-day free trial See the functions

Full feature trial No data leaves your tenant Single sign-on

IBB Reports running inside Excel with live Business Central data

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.

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.

Dimensions & consolidation

Filter and break out by any dimension, and roll up multiple companies into one consolidated view with eliminations.

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

If you can write a formula, you can build a report

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

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

' A full Balance Sheet that spills
=IBB.FS("balance", "", "2025-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.NF & IBB.NP — single field lookups and reporting helpers.

Coming from Jet Reports? The function model will feel familiar, and the move takes minutes, not migrations.

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

Write a formula

Drop =IBB.NL("Count","customers") into a cell and watch live Business Central data appear.