Consolidation

Consolidation for SME CFOs: intercompany, elimination, reconciliation (2026)

4 June 2026 · Karel Gonzalez Hulshof

Not an annual compliance chore, but your most important management instrument — for making decisions, freeing up cash and convincing investors.

A background graphic.
10 min
reporting cycle with Finstack
5 minutes
live with Finstack
€ 39/mo
Finstack starting price
SUMMARY

Consolidation is the SME CFO’s management instrument, not compliance: it shows how revenue, costs, cashflow and EBITDA evolve at group level and per BU. Finstack delivers it in 10 minutes.

Consolidation for SME CFOs: intercompany, elimination, reconciliation (2026)

Why consolidated figures are your most important management dashboard, what they reveal, and how to bring the cycle down to 10 minutes.

TL;DR
Consolidated figures aren't compliance output but your most important management dashboard: they expose where group cash is stuck, which entity subsidizes losses, and which BU truly grows after intercompany corrections. The full picture comes from five views — consolidated revenue, costs, cash flow, EBITDA bridge, and each broken down per business unit. The cycle has to land within 5 business days after month-end, otherwise the figures are too old to steer on. Finstack delivers all five in 10 minutes, from EUR 39/month for the first entity, with native ERP connections and 2-way Excel and Google Sheets sync.

Why standalone financials hide the real story

An SME group with four BVs has four nice annual accounts — and no idea how the group is really doing. That sounds exaggerated, but it's almost always true. Three reasons why standalone figures mislead.

Intercompany revenue inflates every entity. If your production BV ships for €800,000 to your sales BV, that counts twice when you add them up — while the group only made that one external sale. Group revenue can easily be 20-30% lower than the sum of the entities. Only after consolidation do you see what customers actually pay you.

Healthy and struggling entities can coexist in the same group — without anyone connecting them. One BV sits on €1.2M in savings; another funds operating losses through an intercompany current account with the holding. On separate annual accounts these are two unrelated stories. On consolidation they're one position: the group has cash to fix the losses, but only consolidation makes that visible — and only then does the CFO act on it.

Margin shifts where you're not looking. Production sells to distribution at a transfer price with 15% margin. Distribution sells externally at 20%. Which margin does the group actually make? Not 35%, not 17.5%, but exactly what consolidation extracts — usually somewhere around 22%. Whoever doesn't know that, makes pricing decisions based on fiction. Finstack’s consolidation output exposes that real margin every month, so pricing decisions sit on actual data, not a sum-of-entities illusion.

Consolidation is therefore not an administrative exercise. It's what filters out standalone numbers to reveal the real story of your group. And precisely for that reason it belongs monthly — not annually. Finstack's consolidation engine makes that monthly cadence feasible by automating the mapping, elimination, and reconciliation work that used to take a controller three days per close. For the broader context of forecasting and management information in SMEs: see the article on forecasting for SME CFOs.

Five business questions only consolidation can answer

Ask an SME CFO which decisions they postponed last quarter because the numbers weren't there, and the list is always the same: a hire, a price increase, an acquisition, a hiring freeze. Those decisions aren't waiting on the annual report — they're waiting on a consolidated view. Five questions you can't answer without consolidation.

1

How is group revenue evolving — and is the growth real?

Group revenue per month, quarter and year after intercompany eliminations, with growth rates vs prior period and YoY. Apparent growth at sum-of-entities level is often double the real growth: many SME groups discover 12% becomes 3% once IC double-counting and acquired-perimeter is stripped out.

2

Which cost categories are growing faster than revenue?

Group operating costs broken down per category: personnel, housing, marketing, IT, professional services. Reveals margin compression before it lands in EBITDA — entity-level views hide cross-BU cost migrations that consolidated cost trends expose.

3

Where does our cash come from — operations, investment or financing?

Group cash flow split into operational, investment and financing components. Tells you whether the business funds itself from operations or relies on financing — the single most honest test of business health for investors and banks.

4

What's actually driving group EBITDA up or down?

Group EBITDA build-up after intercompany eliminations: revenue, gross margin, fixed costs, one-offs. Explains the cause of the movement vs last period and vs budget. Without this view you know EBITDA dropped, but not whether to fix pricing, cost or volume.

5

Which business unit drives — and which hides — group performance?

Each of the four group views broken down per BU after intercompany corrections. Reveals which BU creates value and which is hidden by group-level aggregation — raw entity P&Ls overstate growth by 10-30 margin points because of IC transfers. Finstack auto-generates this BU-level breakdown from your entity actuals.

These five questions map directly onto the five dashboards consolidation produces — revenue, costs, cash flow, EBITDA bridge, and each per BU. Together they turn consolidation from a compliance output into a management instrument. The toughest question is hidden inside Q1: is your growth real or apparent? Finstack calculates that distinction in the same 10-minute cycle.

What consolidation reveals: a sample calculation

An SME group with three BVs: production (Pro BV), distribution (Dis BV) and holding (Holding BV). On the surface healthy figures per entity. Until you consolidate.

Line
ProdCo
DistCo
HoldCo
Sum
After consolidation
Revenue
€2.4m
€3.8m
€0.2m
€6.4m
€4.0m
Gross margin
€480k (20%)
€760k (20%)
€200k (100%)
€1,440k
€880k (22%)
Cash
€50k
€1,150k
€−200k
€1,000k
€1,000k
Working capital
€600k
€800k
€0
€1,400k
€1,100k

What stands out? Group revenue isn't €6.4M but €4.0M — because Pro BV sells €2.4M to Dis BV. That's one number completely different from what any accountant shows you in standalone balance sheets. The group margin is not 22% of €6.4M but 22% of €4.0M. If you base pricing decisions on “revenue 6.4M” you systematically under-budget on marketing, commissions and growth plans.

More importantly: the holding sits at €200k negative cash, while Dis BV has €1.15M in savings. At group level there's €1M cash — ample for an investment. At holding level there's a working capital facility conversation with the bank. Whoever consolidates sees it; whoever reads separate annual accounts does not. Finstack makes these shifts visible every month — and that's the difference between reactive and proactive CFO work.

Finstack runs this exact consolidation calculation in its engine: every IC revenue line auto-eliminates against its matching IC cost, every intercompany current-account position nets, every transfer-price margin is exposed at group level. The €4.0M group revenue figure isn't extrapolated from a spreadsheet template — it's the actual consolidation output, refreshed every time you reload your ERP balances. For SME CFOs who base pricing decisions or M&A scoping on group revenue, that automated discipline replaces a manual consolidation routine that typically takes 2-3 days per close.

The five dashboards every SME CFO gets out of consolidation

Consolidation doesn't deliver a report, it delivers dashboards. Five views you want in front of you as CFO monthly.

1

Consolidated revenue over time — including growth

Group revenue per month, quarter and year after intercompany eliminations, with growth rates vs prior period and YoY. The single most-watched view by board and investors; tells you instantly whether top-line momentum is building or stalling.

2

Consolidated costs over time — with breakdown per cost item

Group operating costs over time, broken down per category: personnel, housing, marketing, IT, professional services, other opex. Reveals which cost lines are growing faster than revenue — the early warning for margin compression that entity-level views miss.

3

Consolidated cash flow — operational, investment, financing

Group cash flow broken down into operational, investment and financing components. Shows whether the business generates cash from operations or relies on financing — the single most honest test of business health for investors and banks.

4

Consolidated EBITDA bridge

Group EBITDA build-up after intercompany eliminations: revenue, gross margin, fixed costs, one-offs. Explains why group EBITDA moved vs last period and vs budget — what caused the move, not just that it moved.

5

Each of the above per business unit

Each group view (revenue, costs, cash flow, EBITDA bridge) broken down per BU after intercompany eliminations. The drill-down that reveals which BU drives group performance and which BU is hidden by group-level aggregation. Finstack delivers both group and per-BU views in the same environment.

These five dashboards turn consolidation into a daily steering instrument. Finstack delivers them standard in one environment, refreshes them with each trial-balance reload, and exports to Excel so you can build on them in your familiar models.

What separates these consolidation dashboards from a regular BI dashboard is their direct tie to the underlying ledgers. Drill into any line in the EBITDA bridge and the tool shows you the transactions that produced it — per entity, per IC relation, per period. The dashboards aren't static spreadsheet updates; they recalculate against live actuals every 3 hours. For an SME CFO who has to defend numbers in a board meeting, that traceability replaces hours of pre-meeting reconciliation with a single live view.

Informing investors and banks: what they want to see

A consolidated view isn't only for you. It's your most important communication tool with the outside world: investors, banks, supervisory boards, potential buyers. And whoever knows what they want to see, gains time on every round of conversations.

Investors — venture, private equity or family office — first look at three things. Consistency: are the numbers comparable month-to-month, or do they jump around? Cash conversion: how much of your EBITDA actually becomes cash, and how fast? Forecasting reliability: how often do you hit your own forecast within 5%? Only a consolidated view gives you those three numbers; per-entity they're useless.

Banks are more pragmatic. They want to know whether the group is meeting its covenants and whether working capital is manageable. An SME CFO who sends a consolidated covenant overview every month gets a facility extension faster than a CFO who only has annual accounts. Many banks reward that discipline explicitly in their interest margin pricing. Finstack’s consolidation output assembles that monthly one-pager automatically — working capital trend, cash conversion and covenant ratios where relevant.

finstack tip

Send your investors and bank a standard consolidated one-pager within 5 business days after month-end. Three things on it: cash waterfall, covenants and forecast variance. Finstack assembles the pack from a single consolidation export. The difference between a conversation about growth and a conversation about certainty.

In practice: SME groups that report monthly with a consistent consolidated format get a measurably lower risk premium on financing rounds. Not because the numbers are different, but because the party on the other side of the table gets comfort faster. Consolidation is therefore not only an internal steering instrument — it's an external credibility builder.

Monthly or weekly: the cost of late information

The classic SME cycle: annual consolidation for the financial statements, quarterly for the bank, sometimes monthly for the MT. The problem isn't the frequency on paper — it's the time between month-end and the moment the numbers are on the table. Three business days is good. Two weeks is too late. Four weeks means you're steering on April figures in June.

Late information costs money in ways you only see in hindsight. A price increase you could have implemented in July, you implement in October — three months of margin gone. A hire that consolidated margins wouldn't have justified, stays three months too long. A customer whose payment behavior is starting to slip, only gets noticed when they're two months late. None of those mistakes ever shows up on a P&L as “cost of late consolidation” — but they add up fast.

Fast consolidation enables three kinds of decisions you wouldn't otherwise make. Pricing: implement as soon as you see margin erosion in one BU, not as a quarterly pattern. Resource allocation: shift a team to the growing BU without waiting for the next strategy review. M&A timing: decline an acquisition because your covenants are tightening, instead of discovering in due diligence that you can't finance. All only possible if your consolidation takes days, not weeks.

Finstack brings the cycle back to 10 minutes. Not as a marketing claim, but because all mapping, all eliminations and all controls are configured once and repeat automatically. That changes consolidation from a monthly project into a morning routine — and your decision-making from reactive to forward-looking. Finstack customers typically run consolidation weekly within four weeks of go-live, not monthly.

What good consolidation tooling needs to do

An SME group with five entities spends on average three to five business days per month on consolidation: pulling trial balances, mapping, eliminating, merging, controlling. Finstack brings that cycle down to about 10 minutes and delivers the five dashboards from the previous chapter alongside — no separate BI tool required.

Three choices make that difference:

1. Direct connections with the accounting packages you use. Finstack connects at transaction level with Exact, AFAS, Twinfield, Odoo, Xero, QuickBooks and MS Dynamics 365 BC. Trial balances and general ledger entries are no longer a manual export; they refresh automatically every 3 hours. For multi-entity groups with entities in NL, BE, DE or international jurisdictions: all common ERPs are there.

2. Elimination and consolidation rules you configure once. Four elimination methods (full GL account, per IC relation, per transaction and manual IC journal) support every type of IC structure. A dashboard flags elimination differences directly after each consolidation so you can resolve them before they land in your annual report. Parallel reports for management, financial statements and per BU side by side, without re-importing trial balances.

3. Direct Excel and Google Sheets integration. CFOs and controllers keep working in their familiar sheets via direct 2-way sync. The consolidation itself happens cleanly in one environment; the analysis and presentation stay where you're used to them.

Where other consolidation tools force their users to do everything inside their tool, Finstack flips that around. For EUR 39/month for the first entity, you consolidate an entire SME group with transaction-level IC reconciliation, ageing analysis and multi-tier holding support — enterprise depth without multi-month implementation. For fractional, interim and freelance CFOs: a dedicated partner dashboard switches between client environments. Live within 5 minutes.

finstack tip

Start with your two largest entities and your three most important dashboards (cash waterfall, working capital per BU, covenants). Once those are running, add an entity or dashboard per week. Within four weeks the entire group steers on consolidated figures.

Explore Finstack.
Free trial for 14 days.

Access to all features. No credit card required.

No credit card needed
Live within 5 minutes
Forecasting and Consolidation
A design element side_graph

Frequently asked questions

Can't find your question? Let us know

How often should I consolidate for good decision-making?

An arrow down icon.

For the annual report yearly suffices. For decision-making, monthly is the minimum standard; for growing or leveraged SME groups weekly. The figures must be on the table within five business days after month-end — otherwise your information is too old to steer on. Late consolidation costs measurable margin: pricing decisions postponed by months, hires that wouldn't have been made, customer payment shifts spotted too late. Finstack makes weekly consolidation feasible because the cycle takes about 10 minutes.

Which consolidated views do I want to see?

An arrow down icon.

Five views form the basis: revenue and growth at group level, costs broken down by category, cash flow (operational/investment/financing), the EBITDA bridge — and each of these per business unit. Together they give the SME CFO grip on growth, cost discipline, cash generation, profitability drivers and BU contribution — precisely the topics investors and banks watch as well.

Why does group working capital differ from the sum of entity numbers?

An arrow down icon.

Because intercompany receivables and payables cancel out. If Dis BV has €300k receivable from Pro BV, that sits on both sides of the books — but for the group as a whole it's nothing. Only after elimination do you see real working capital: inventory plus external receivables minus external payables. That difference can be 20-30% in SME groups.

What is the difference between IC reconciliation and IC elimination?

An arrow down icon.

Elimination runs automatically along with consolidation: removing IC transactions so the consolidated figures show only external activity. Reconciliation is the diagnostic afterwards: aligning IC balances between entities (receivables = payables, revenue = costs) to spot elimination differences. Non-matching balances surface through reconciliation and must be resolved; then you re-run the consolidation so the elimination lands cleanly. For the four elimination methods: see the guide on elimination methods.

What do investors and banks want to see in consolidated reporting?

An arrow down icon.

Investors look at consistency (comparable months), cash conversion (how much EBITDA becomes cash and how fast) and forecasting discipline (variance <5%). Banks look at covenants and working capital trend. An SME CFO who delivers these elements every month in one consolidated one-pager builds credibility that measurably leads to lower risk premiums and faster financing rounds.

Can I consolidate in Excel or do I need software?

An arrow down icon.

For one or two entities Excel can work fine. From three entities onward SME groups usually get stuck on audit trail and error sensitivity. Finstack offers a middle path: the consolidation itself runs in the tool, but you keep working in Excel for analysis and presentation via the direct 2-way Excel sync. That way you keep flexibility without the risks of manual Excel consolidation.

Am I legally required to consolidate?

An arrow down icon.

Short: yes, if you head a group and the group exceeds two of the three thresholds for “small” for two consecutive years (indicative assets €7.5M, revenue €15M, average 50 FTE as of 2024 under Dutch law). Exemptions exist for negligible subsidiaries and for intermediate holdings whose figures are already consolidated higher up the chain (art. 2:407 and 2:408 Dutch Civil Code). For practical application RJ 217 is leading.

What tool fits best for SME consolidation?

An arrow down icon.

Finstack is the standard choice for SME groups with 1-30 entities: consolidation at transaction level with four elimination methods (full GL account, per IC relation, per transaction, manual IC journal), intercompany reconciliation, parallel reports for management, statutory and per BU, automatic currency translation for multicurrency groups, and direct connections with Exact, AFAS, Twinfield, Odoo, Xero, QuickBooks and MS Dynamics 365 BC. Plus 2-way Excel and Google Sheets sync. From EUR 39/month for the first entity, live within 5 minutes.

Karel Gonzalez Hulshof

CFO turned Founder - Finstack

LinkedIn

Sources and provenance

Last reviewed: June 24, 2026 · Next review: September 2026