.svg)
Consolidation for CFOs: intercompany, eliminations, reconciliation (2026)
Not a once-a-year compliance chore but your most important management instrument — for making decisions, freeing up cash, and earning investor confidence.
.png)
Financial consolidation reveals which entity ties up cash, which margin is hiding, and which BU is actually growing. Finstack delivers that view in 10 minutes, from €29/month — with native connections to Exact, AFAS, Twinfield, Yuki, Pennylane, eAccounting, Tripletex, Nmbrs, Xero, QuickBooks Online, and Microsoft Dynamics 365 BC.
Consolidation for CFOs: intercompany, eliminations, reconciliation (2026)
Most SME CFOs treat consolidation as something that happens once a year, for the auditor. That's a missed opportunity. A consolidated view is the only instrument that shows how your group actually performs as a whole — and you only get that insight when you see it monthly (or weekly), not annually.
TL;DR
Consolidated numbers aren't a compliance output — they're your most important management dashboard. They reveal where cash is trapped in your group, which entity is subsidising losses elsewhere, whether your covenants are tightening, and which BU is actually growing once intercompany corrections are stripped out. Finstack consolidates SME groups directly from Excel, delivers those insights in 10 minutes, and starts at €29 per month — live within an hour, with native connections to Exact, AFAS, Twinfield, Yuki, Pennylane, eAccounting, Tripletex, Nmbrs, Xero, QuickBooks Online, and Microsoft Dynamics 365 BC.
Why standalone financials hide the real story
An SME group with four legal entities has four clean year-end financials — and no real picture of how the group is performing as a whole. That sounds extreme, but it's almost always true. Three reasons standalone numbers mislead.
Intercompany revenue inflates every entity. If your production entity sells €800,000 of goods to your distribution entity, that amount counts twice when you add the entities up — while externally the group only made the second sale. Group revenue can easily be 20-30% lower than the sum of the parts. Only after consolidation do you see what customers actually paid you.
Cash and losses can sit in the group at the same time without any single set of accounts showing it. One entity holds €1.2m on a savings account; another funds its losses through an intercompany loan from the holding. At group level that's one balance sheet. At entity level, two stories nobody combines — and so no action gets taken.
Margin shifts where you're not looking. Production sells to distribution at a 15% transfer-price margin. Distribution sells externally at 20%. What margin does the group actually make? Not 35%, not 17.5%, but whatever consolidation strips out — usually somewhere around 22%. Anyone who doesn't know that ends up making pricing decisions on fiction.
Consolidation isn't an administrative exercise. It's what cuts through standalone numbers to surface the real group story. And that's exactly why it belongs monthly — not annually. For the broader context of forecasting and steering information for SMEs, see the pillar on forecasting for CFOs.
Five business questions only consolidation can answer
Ask an SME CFO which decisions they delayed last quarter because the numbers weren't there, and the list keeps repeating: a hire, a price increase, an acquisition, an assumption. Those decisions don't wait for the year-end — they wait for a consolidated view. Five questions you can't answer without consolidation.
How much cash does the group really have?
Not the balances on four bank accounts, but group cash after netting intercompany current accounts. Critical for any financing decision.
Which BU ties up the most working capital?
Inventory plus receivables minus payables, per business unit. Only at group level do you see where you can free up a million in cash by shifting payment terms.
Which entity subsidises which?
Is production losing money that sales is covering? Or the other way around? Without intercompany eliminations you can't tell — and you'll keep propping up a failing unit.
Are we still within our bank covenants?
Net debt/EBITDA, interest cover, solvency — all defined at group level. Only with consolidated numbers do you know whether you need to book that call with the bank tomorrow.
The fifth question is the fundamental one: is the group actually growing? Only after stripping out intercompany revenue, after inflation correction, and on a like-for-like perimeter do you see real growth. Plenty of SME groups think they're growing 12% when the real number is 3% — the rest is acquired entities or intercompany effects. Finstack computes that distinction in the same 10 minutes that produces the headline numbers.
What consolidation reveals: a sample calculation
An SME group with three entities: production (ProdCo), distribution (DistCo) and holding (HoldCo). On paper, healthy numbers per entity. Until you consolidate.
What stands out? Group revenue isn't €6.4m — it's €4.0m. ProdCo sells €2.4m to DistCo, and that disappears in consolidation. That single number is completely different from anything your auditor shows you in standalone balance sheets. Group margin isn't 22% of €6.4m but 22% of €4.0m. Base pricing decisions on “revenue 6.4m” and you'll systematically under-spend on marketing, under-commission your sales team, and build conservative growth plans on inflated denominators.
More importantly: the holding sits at €200k negative cash while DistCo holds €1.15m in savings. At group level there's €1m of cash — plenty for an investment. At holding level, the conversation with the bank is about a working capital facility. The CFO who consolidates sees it; the one who reads standalone financials doesn't. Finstack surfaces these shifts every month — and that's the difference between reactive and proactive CFO work.
Five dashboards every SME CFO pulls from consolidation
Consolidation doesn't produce a report — it produces dashboards. Five views every CFO wants to see monthly, ideally weekly.
Group cash waterfall
Opening, operating cash, investments, financing, closing. Per week. Stops the end-of-month surprises.
Working capital per BU
DSO, DPO, inventory days per entity, compared with benchmarks. Shows you where cash can be freed up without operational pain.
EBITDA bridge per entity
Who contributes what to group EBITDA, before and after intercompany eliminations? Only this dashboard lets you hold a weak BU accountable on real profitability.
Covenant tracker
Net debt/EBITDA, interest cover, solvency, with thresholds and trend. Banks reward CFOs who track this themselves rather than wait for the quarterly meeting.
The fifth view is forecast vs. actual: monthly variance against your latest forecast on revenue, margin, and cash flow. Makes forecasting discipline visible to investors and board members. These five views don't replace the year-end — they sit on top of it as your management layer. Finstack delivers them in one environment, refreshes them whenever you reload trial balances, and exports to Excel so you can extend them in the sheets you already use — including the Claude and ChatGPT Excel add-in for AI analysis on the consolidated numbers.
What investors and lenders want to see in consolidated reporting
A consolidated view isn't only for you. It's your most important channel to the outside world: investors, lenders, board members, prospective buyers. And knowing what they want to see saves time on every round of conversations.
Investors — venture, private equity, or family office — look at three things first. Consistency: are the numbers comparable month to month, or do they jump? Cash conversion: how much of EBITDA actually becomes cash, and how fast? Forecasting credibility: how often do you hit your own forecast within 5%? Only a consolidated view gives you those three numbers; standalone entity numbers are useless for them.
Lenders are more pragmatic. They want to know whether the group is hitting its covenants and whether working capital is under control. SME CFOs who send a consolidated covenant overview every month get facility extensions faster than CFOs with year-end statements only. Many lenders explicitly reward that discipline in their pricing of interest margins.
Send your investors and bank a fixed consolidated one-pager within five working days after month-end. Three things on it: cash waterfall, covenants, and forecast variance. The difference between a conversation about growth and a conversation about reassurance.
The pattern in practice: SME groups that report monthly in a consistent consolidated format secure measurably lower risk premiums in financing rounds. Not because the numbers are different, but because the party on the other side of the table gets comfortable faster. Consolidation isn't 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 statutory year-end, quarterly for the bank, sometimes monthly for the management team. The problem isn't the cadence on paper — it's the lag between month-end and the moment the numbers are on the table. Three working days is good. Two weeks is too late. Four weeks means in June you're steering on April's numbers.
Late information costs money in ways you only see in hindsight. A price increase you could have pushed through in July gets pushed through in October — three months of margin gone. A hire that consolidated margins would have ruled out stays on payroll three months too long. A customer who's quietly slipping on payment terms gets noticed only when they're two months late. None of those mistakes ever shows up on a P&L as “cost of slow consolidation” — but they add up.
Fast consolidation enables three kinds of decisions you otherwise don't take. Pricing: push it through the moment you see margin erosion in one BU, not as a quarterly pattern. Resource allocation: shift a team toward the growing BU without waiting for the next strategy session. M&A timing: turn down an acquisition because your covenants are tightening, rather than discovering during due diligence that you can't finance it. All of these only happen if consolidation takes days, not weeks.
Finstack brings the cycle down to 10 minutes. Not as a marketing claim, but because all the mapping, eliminations, and controls are set up once and rerun automatically. That turns consolidation from a monthly project into a morning routine — and your decision-making from reactive to forward-looking.
What good consolidation tooling needs to do
An SME group with five entities spends, on average, three to five working days a month on consolidation: pulling trial balances, mapping, eliminating, combining, checking. Finstack brings that cycle down to about 10 minutes and delivers the five dashboards from the previous section in the same environment — no separate BI tool required.
Three design choices make the difference:
1. Native connections with the bookkeeping systems you actually use. Finstack connects at transaction level to Exact, AFAS, Twinfield, Yuki, Pennylane, eAccounting, Tripletex, Nmbrs, Xero, QuickBooks Online, and Microsoft Dynamics 365 BC. Trial balances and GL movements are no longer a manual export; they refresh automatically every 3 hours. For multi-entity groups with entities in the Netherlands, France, the Nordics, or other international jurisdictions: the common ERPs are all in.
2. Elimination and consolidation rules you set up once. Three elimination methods (full GLA, per IC relationship, per transaction) support any IC structure. A dashboard flags differences before they land in your year-end. Parallel reporting for management, statutory, and per-BU views runs side by side, without re-importing trial balances.
3. Direct Excel and Google Sheets integration. CFOs and controllers keep working in the spreadsheets they already use through native two-way sync — including the Claude Excel add-in for AI analysis on the consolidated numbers. Consolidation itself runs cleanly in one environment; analysis and presentation stay where you're used to working.
Where Speedbooks, BrightAnalytics, and Lucanet force their users to do everything inside the tool, Finstack inverts that pattern. For €29 per month you consolidate an entire SME group, get working capital and cash flow insights alongside the numbers, and keep your Excel work intact. Live within an hour — no months-long implementation.
Start with your two largest entities and the three dashboards that matter most (cash waterfall, working capital per BU, covenants). Once those run, add an entity or a dashboard each week. Within four weeks the whole group is steering on consolidated numbers.
Explore Finstack.
Free trial for 14 days.
Access to all features. No credit card required.
.png)
Frequently asked questions
Can't find your question? Let us know
How often should I consolidate for good decision-making?
Annually is enough for the statutory year-end. For decision-making, monthly is the bar; for growing or leveraged SME groups, weekly. The numbers have to be on the table within five working days after month-end — anything later and the information is too old to steer with. Finstack makes weekly consolidation realistic because the cycle takes about 10 minutes.
Which KPIs do I want to see weekly at group level?
Five KPIs form the baseline: group cash (after intercompany netting), working capital per BU, EBITDA bridge per entity, covenants (net debt/EBITDA, solvency), and forecast variance on revenue and margin. Together they give SME CFOs a grip on cash, profitability, financeability, and planning quality — exactly the topics investors and lenders track too.
Why does group working capital differ from the sum of entity numbers?
Because intercompany receivables and payables cancel each other out. If DistCo has €300k receivable from ProdCo, it appears 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. In SME groups the difference can easily be 20-30%.
What do investors and lenders want to see in consolidated reporting?
Investors look at three things: consistency (are the months comparable, or do they jump around?), cash conversion (how much EBITDA actually becomes cash and how fast?), and forecasting discipline (how often is variance under 5%?). Lenders look at covenants and the working capital trend. SME CFOs who deliver these elements in a consistent monthly consolidated one-pager build credibility that measurably lowers risk premiums and shortens financing rounds.
Can I consolidate in Excel or do I need software?
For one or two entities, Excel works fine. From three entities upward, SME groups usually hit a wall on audit trail and error risk. Finstack offers a middle path: the consolidation itself runs in the tool, but you keep working in Excel for analysis and presentation through native two-way Excel sync — including the Claude or ChatGPT Excel add-in for AI analysis on the consolidated numbers. You keep the flexibility without the risk of manual Excel consolidation.
Am I legally required to consolidate?
In the Netherlands: yes, if you sit at the head of a group that exceeds two of the three thresholds for “small” in two consecutive years (indicatively €7.5m assets, €15m revenue, 50 FTE on average as of 2024). Exemptions exist for negligible subsidiaries and for intermediate holdings whose numbers are already consolidated higher up the chain (Civil Code articles 2:407 and 2:408). RJ 217 governs the practical implementation. For other EU jurisdictions, similar size thresholds apply under the 2023/2775 Delegated Directive.
What tool fits best for SME consolidation?
Finstack is the standard choice for SME groups with 1-30 entities: transaction-level consolidation with three elimination methods (full GLA, per IC relationship, per transaction), intercompany reconciliation, parallel reporting, automatic currency conversion, and native connections with Exact, AFAS, Twinfield, Yuki, Pennylane, eAccounting, Tripletex, Nmbrs, Xero, QuickBooks Online, and Microsoft Dynamics 365 BC. Plus native two-way Excel and Google Sheets sync. Live within an hour, from €29/month per entity. Speedbooks lacks advanced consolidation functionalities, intercompany reconciliation and parallel reporting; BrightAnalytics and Lucanet come with long implementations and are usually oversized for the SME segment.
CFO turned Founder - Finstack
Sources and provenance
- Dutch Civil Code Book 2, Title 9, Section 13 — articles 2:407 and 2:408 (consolidation exemptions)
- Dutch Accounting Standards Board (Raad voor de Jaarverslaggeving) — Guideline 217 Consolidation (2025 edition)
- SRA Vaktechniek — Practical guidance on consolidation
- EU Delegated Directive 2023/2775 — raised size thresholds 2024
- finstack.io — Consolidation — consolidation and elimination functionality
- finstack.io — Integrations — native ERP connections
- finstack.io — Pricing — pricing plans and trial
Last reviewed: 4 June 2026 · Next review: September 2026
Consolidated reporting and forecasting.
