For Microsoft Dynamics 365 Finance and Operations and 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 Dynamics 365 data, tied to the ledger. Prefer a formula? Drop an IBB.* function in any cell. No exports, no copy-paste.

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
Available on Microsoft AppSource Works in Excel on Windows, Mac, and the web Built by IBB Innovations LLC
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 Finance and Operations (F&O) and Business Central (BC), 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.GL or =IBB.FS in any cell and get real values back from your ledger. Refresh and they update.

Financial statements

P&L, Balance Sheet, and Trial Balance built from your own chart of accounts and its 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 source 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 ledger entries behind it. Your auditors will thank you.

Secure by design

Microsoft single sign-on, read-only access, and every access to your Dynamics 365 data is logged.

New

Per-user report access

Give each person only the reports they need, for example AR and AP aging for a receivables clerk. It's enforced on IBB's servers, in-cell formulas included, not just hidden in the menu. IBB sets it up on request, and every change is logged for your auditors.

On Finance and Operations today: income statement, balance sheet, trial balance and cash flow, AR and AP aging, GL entries, drill-down, Budget vs Actual for one legal entity, reports across several legal entities, dimensions, saved and scheduled reports, Ask IBB, and IBB.GL, IBB.FS, IBB.NL, IBB.NF and IBB.NP. Not yet on Finance and Operations: P&L by partner, intercompany eliminations and client report packs.

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.

What our clients say

Finance teams use it every morning

“A pleasure to use this tool! It makes the morning routine much more efficient!”
SHShevy H.
Finance team, Business Central client
“The tool looks great.”
MSMelissa S.
Finance team, Business Central client
Up and running today

Three steps from install to insight

1

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. Finance and Operations needs our FO-connect extension.

2

Sign in once

Sign in with your Microsoft account. Your 14-day full-feature trial starts automatically, no card required.

3

Ask, or write a formula

Type income statement for last quarter in the pane, or drop =IBB.FS("balance","","2026-12-31") in a cell, and watch live Dynamics 365 data appear.

Plain English
Ask for any report
14 days
Full free trial
0
Exports or copy-paste
100%
Live Dynamics 365 data

Close the month from a spreadsheet you already trust

Start your free trial of IBB Reports and pull your first live report in under five minutes, just ask for it.