Consolidate your group numbers without the Excel work around it
Smartbooks is consolidation software for multi-entity groups. The platform automates intercompany elimination, currency translation and group reporting, with direct integrations to Exact Online, AFAS, Twinfield and more.
60+ customers · multi-entity consolidation · live within 14 days
Consolidating in Excel works — until the company grows
With two or three entities you can keep an overview. With eight, fifteen or more entities, consolidation turns from a monthly routine into a multi-day project — with version control, manual IC reconciliation and the constant question whether the numbers are right. At some point it's no longer about working smarter in Excel, but about a different foundation.
"Which version was the latest one?"
The consolidation Excel circulates between multiple people. Someone works in a local copy. A formula gets overwritten by accident. At the end of the month no one knows for sure which version is the right one.
"Why don't these IC entries match?"
One entity books a charge, the other posts it in a different period or for a different amount. The difference shows up in the consolidated numbers. You trace it manually, entry by entry, until it ties out.
"Every entity books things slightly differently."
The general ledgers of different entities have grown organically. For consolidation, everything needs to map to a standardised layout. That mapping lives in a tab maintained by one person — and when they're gone, it stalls.
"Is this report actually correct?"
The numbers go to the management team and the board. They drive decisions. But you know there's a manual step somewhere in the chain that can go wrong — and you don't have time to double-check everything.
One platform for the full consolidation
Smartbooks connects directly to your accounting package and consolidates the numbers of all your entities in one environment. The full consolidation process — ingesting, structuring, intercompany elimination, final reporting — runs inside Smartbooks, with no Excel in between.
One source, always up to date
Smartbooks pulls ledger data straight from Exact Online, Exact Globe, AFAS, Twinfield, QuickBooks and Odoo. Changes in the accounting package show up in the consolidated numbers within minutes. No exports, no intermediate files, no stray versions.
Adding an entity to the consolidation takes around 10 minutes.
Group structure and currencies without manual work
Group structures are rarely flat. Smartbooks supports sub-consolidations so you can group entities by region, business unit or legal structure — and report on every level. Ownership percentages are set per entity for correct consolidation.
For groups with foreign entities, Smartbooks automatically applies currency translation at trial balance level. The P&L is translated per period at the prevailing rate; the balance sheet at the closing rate. The difference between both methods is calculated automatically and posted as a translation difference — so cumulative P&L ties to the balance sheet.
What is intercompany elimination?
Intercompany elimination is the removal of intra-group transactions from the consolidated numbers, so the group figures reflect only external activity. Without elimination, internal charges, loans and revenue appear duplicated or distorted in the group report.
How Smartbooks handles it
Intercompany transactions booked to designated accounts are automatically eliminated against each other. Differences between entities — caused by timing, missing counter-entries or mismatched amounts — surface as IC Difference, with direct drill-down to the underlying transactions so you can resolve the gap instead of searching for it.
For entities whose chart of accounts isn't IC-friendly, you can still create intercompany accounts through reclassification — without changing anything in the source system.
Smartbooks does more than just consolidation. Also check out Reporting, Planning & Cashflow and Close.
How Intermax consolidates ten entities in a fraction of the time
Karel van den Bos
Finance, Intermax
10 entities · Exact Globe
Finance team of 7 · Multiple days saved per month
"Don't make the implementation a big project, because it goes really fast. During the free trial month, the entire setup is already done and everything is ready to use."
— Karel van den Bos, Finance, Intermax
Intermax consolidates ten entities on Exact Globe every month. Previously, producing the group report took multiple days of manual work in Excel sheets, with the related error risk. With Smartbooks, consolidation is significantly faster, the reports are more reliable, and the seven-person finance team has more time for analysis and interpretation.
Read the full customer caseFrequently asked questions about consolidation software
See your own consolidation in Smartbooks
- Personal 30-minute demo
- We show Smartbooks on a setup that resembles yours
- No commitments, no sales talk
- Fully live within 14 days if you want to proceed
You'll speak with Michel van Wijngaarden — he tailors the demo to your situation.