Guides · SAP Business One

What financial consolidation and reporting tools work with SAP Business One?

The realistic options for groups on SAP Business One, compared fairly, and which fits which group.

By Mark Richardson FCCA, founder and CEO of Mondial · Updated November 18, 2026

Short answer

SAP Business One has no built-in group consolidation. Its branch feature and financial report templates work inside one company database. Groups with several SAP Business One companies, or SAP Business One alongside other ERPs, usually choose between five kinds of tool: Excel workbooks, SAP Business One add-ons that link companies (such as Vision33 InterCompany), Excel reporting add-ins (such as Spreadsheet Server), consolidation software that connects to SAP Business One (such as Solver, Codestone INSIGHTS, Zap Data Hub and Mondial), and enterprise performance management suites (such as OneStream, Lucanet, Prophix or Vena). The right choice depends on how many companies you have, whether they all run SAP Business One, how many currencies and accounting standards you report under, and whether your team wants to keep its Excel reports.

What SAP Business One does on its own

SAP Business One handles one company per database very well. Two features are often mistaken for consolidation:

  • Multiple branches. Several branches inside one company database, with branch-level documents, payments and filtering in reports. It is not consolidation: there are no eliminations, no currency translation between companies and no ownership percentages, and once switched on it cannot be switched off.
  • Financial report templates and Excel Report and Interactive Analysis. Good for formatting one company's balance sheet, profit and loss and trial balance, and for analysis in Excel. They report on one company at a time.

SAP's own Intercompany Integration Solution for SAP Business One once added multilevel consolidation, but Vision33 reports that SAP no longer sells or supports it. So a group needs something outside the core product.

The options compared

TypeExamplesBest forLimits
Excel workbooksExports from each company, linked workbooksTwo or three companies, one currencyManual and error-prone, no audit trail, slow close
SAP Business One intercompany add-onsVision33 InterCompany; Boyum B1 InterCompany (transaction syncing only)Groups where every company runs SAP Business One and trades with the othersSAP Business One only; companies on other ERPs are left out
Excel reporting add-insinsightsoftware Spreadsheet ServerLive, refreshable Excel reports with drill-downReporting, not consolidation: no central chart of accounts, eliminations or currency translation adjustments
Data hubs with consolidated reportingZap Data HubDashboards and Excel or Power BI reports across several ERPsLighter on the accounting side: check how adjustments, CTA and minority interest are handled
Consolidation and planning platformsSolver; Codestone INSIGHTS (on SAP Analytics Cloud, from £2,800 a month including implementation, support and hosting, per Codestone)Groups that want consolidation and budgeting in one productA larger project and a new reporting tool for the team to learn
Enterprise performance management suitesOneStream, Lucanet, Prophix, VenaLarge groups with complex consolidation and planningCost, months-long projects, specialist skills; none names SAP Business One as a standard connector on its integrations page
Consolidation that feeds your Excel reportsMondialGroups of 2 to 25 companies on SAP Business One alone or alongside other ERPs, wanting to keep their Excel reportsNo budgeting or planning module

Product details are taken from each vendor's own website as of November 2026. If anything here is out of date, please tell us and we will correct it.

Which option fits which group

  • One company with several locations: SAP Business One's branches may be all you need.
  • Several companies, all on SAP Business One, mostly one currency: an intercompany add-on such as Vision33 InterCompany keeps the companies in step inside SAP Business One.
  • You only need better Excel reports from one company: an Excel add-in such as Spreadsheet Server is the simplest step.
  • You want budgeting and consolidation together: look at Solver or Codestone INSIGHTS.
  • A large group with hundreds of entities and a dedicated systems team: the enterprise suites are built for you.
  • Several companies, some not on SAP Business One, in several currencies or under different accounting standards, and a team that wants to keep its Excel reports: this is the gap Mondial was built for.

Where Mondial fits

Mondial is consolidation and group reporting software for mid-market groups, whether they run one ERP or several, that feeds your existing Excel reports with consolidated, auditable figures, typically live in about a week.

Mondial has a ready connector for SAP Business One and imports transaction-level general ledger, payables and receivables data from every company, including companies on other ERPs such as Microsoft Dynamics 365 Business Central, Acumatica, Syspro and Plex. It maps each company to one group chart of accounts, including statutory charts, and translates every transaction into each reporting currency you need, with the cumulative translation adjustment calculated for you. Eliminations, statutory adjustments and adjustments between accounting standards are posted as auditable journals rather than spreadsheet formulas. It also imports the values of SAP Business One's dimension fields on every transaction line, so management reports can be filtered by department, region or product line across the group.

Your team keeps its Excel reports. Any figure in them can be traced back to the exact SAP Business One transactions behind it. Mondial is a monthly subscription at a mid-market price, a fraction of what enterprise consolidation software costs, with no lengthy implementation project. RECARO Automotive closes about four days faster on average with Mondial.

More detail: Mondial for SAP Business One and What Mondial does.

Mondial is not the right choice if you need a budgeting and planning module in the same product, or if your group is a large enterprise with hundreds of entities.

Questions to ask any vendor

  1. Does it connect to SAP Business One with a standard connector, or does it need a custom integration?
  2. Does it import transactions or only balances? Can I drill down from a consolidated figure to the source transaction?
  3. Can it bring in companies on other ERPs, including ones we might acquire?
  4. How does it handle intercompany eliminations, currency translation and the cumulative translation adjustment, and adjustments between local GAAP and group GAAP?
  5. Are adjustments recorded as journals with an audit trail, or as spreadsheet formulas?
  6. Can my team keep its existing Excel reports, or do we have to rebuild them in a new tool?
  7. How long does a typical implementation take, and who does the work?

See Mondial with your own reports

If your group runs SAP Business One, with or without other ERPs, Mark Richardson can show you Mondial in a 30-minute video walkthrough using your own reports.

Book a walkthrough
MR

Mark Richardson FCCA is the founder and CEO of Mondial. He has spent more than 30 years in financial software, including at SAP, Sage, Epicor, Plex and Avalara.

Copyright ©2026 Mondial Software. All rights reserved.