Business Central reporting and consolidation inside Excel

Business Central reporting in Excel

Build a report once in the Excel you already know, then refresh it with live Business Central data in one click. No exports, no data warehouse, and every query runs with your own Business Central permissions.

Build a report once in the Excel you already know, then refresh it with live Business Central data in one click. No exports, no data warehouse, and every query runs with your own Business Central permissions.

Exsion365 add-in running in Excel on a laptop

1,200+

customers

25,000+

users

694,000+

monthly retrievals

monthly retrievals

51+

53

countries

50+

50+

partners worldwide

1998

1998

Exsion product since

  • Kingspan customer logo
  • Agromart customer logo
  • Boro customer logo
  • GLi customer logo

Three products, one Excel

Exporting to Excel gives you a copy. Exsion updates inside your workbook.

Export to Excel compared with Exsion
FeatureExport to ExcelExsion
Data freshnessStatic snapshot at time of exportLive connection, 1-click refresh
Recurring effortRebuild formulas and layouts every monthBuild once, refresh every period
Access control & securityStatic file exposes all exported dataPreserves native Business Central permissions on refresh
  • Data freshness

    Live connection, 1-click refresh

  • Recurring effort

    Build once, refresh every period

  • Access control & security

    Preserves native Business Central permissions on refresh

Finance teams that stopped exporting

Hear it from the people who use it

Mary Ellen Rosinski, Controller at AASK, on what changed in her reporting. No script, just her answers.

Why clients say Exsion pays for itself

Reporting before vs after Exsion

What would you miss most without Exsion?

We rebuild one of your Jet reports, free of charge

Our AI maps your Jet syntax straight into an Exsion query grid, so you see how your own report carries over without rewriting a single formula.

Get my Jet report rebuilt

Ready in 48 hours ยท Dummy data accepted ยท No obligation

How it works

  1. Send your key Jet report

    Upload the workbook or share the template your team relies on most.

  2. We map it into Exsion

    AI translates every Jet function into an Exsion query grid. We check the result.

  3. Review the live workbook

    Compare the mapping side by side, then refresh it on your own Business Central data.

Your data stays in Business Central

Exsion is not a data warehouse and keeps no copy of your figures. The only copy is the workbook you save.

No data stored at Exsion

Reporting data stays in your Business Central tenant.

Your permissions, on every refresh

Queries execute strictly under the active userโ€™s credentials, inheriting native Business Central roles with no separate permission scheme to manage.

Microsoftโ€™s own interface

Connects directly via standard Microsoft APIs and OData feeds across both Business Central cloud and on-premises environments.

Data processing agreement

Fully GDPR-compliant agreements available to ensure your corporate governance and audit requirements are completely covered.

WHO IS BEHIND EXSION

Built for controllers, led by one

Thomas Werkhoven is CEO of Exsion365. He is a registered accountant and worked as group controller and CFO before Exsion.

Fast enough for the whole ledger

< 5 sec

Loading time for 700,000 G/L Entry rows.

+25.000.000

Business Central rows loaded into one Excel pivot table.

~5 min

To install from Microsoft AppSource.

See your own Business Central data in Excel

Start a free trial from Microsoft AppSource, or book a demo and weโ€™ll help you build your first report.