Book a demo

Financial consolidation software for groups with several companies

Financial consolidation software turns the books of several companies into one set of group accounts. Finconsol brings each company in, maps its accounts to one group chart, translates currencies, removes intercompany balances and shows the group statements. Zoho Books connects directly. Other systems join by trial balance.

Book a demo Get pricing

Map once

Each company keeps its own account names. You tie them to the group's lines one time.

Revenue accounts from five companies are mapped to the group line Revenue. A new account in Zenvara UK Ltd, Consulting income, is not mapped yet, and a button maps it to Revenue.

  • Zenvara TechnologiesRevenue from operations
  • Zenvara Inc.Sales
  • Zenvara UK LtdTurnover
  • Zenvara UK LtdConsulting income
  • Zenvara FZ-LLCRevenue - Services
  • Zenvara Pte. Ltd.Sales - Domestic
Group lineRevenue

September stopped: 1 account in Zenvara UK Ltd not mapped

Every company closes. The group does not.

A group with three, five or fifteen companies usually has three, five or fifteen sets of books. Each is correct for its own company. The board wants one set of numbers for the whole group, and nobody owns the work between the two.

So after every month end, someone in finance spends days exporting, re-keying and checking, and the group accounts are late by the time they are read.

  • Different charts. Each company names and numbers its accounts its own way.
  • Different currencies. Each foreign company needs the right rate for each part of its statements.
  • Intercompany counted twice. Fees, loans and investments between companies inflate revenue, costs and assets.
  • Part-owned companies. The share that belongs to outside owners has to be shown separately.
  • No trail. Nobody can say who changed a number after the board read it.

How groups do it today

Most groups rebuild the consolidation every month in a spreadsheet, or move every company onto one accounting system. Both work until the group grows.

Spreadsheet, one shared accounting system and Finconsol compared
SpreadsheetOne accounting system for allFinconsol
Existing booksExported and pasted in each monthReplaced, company by companyKept as they are; read or uploaded
New accountsFound by a broken total, if at allControlled in one chartMapped once; an unmapped account stops the month
CurrenciesRates looked up and typedDepends on the systemClosing, average and historical rates applied
IntercompanyMatched by eyeNeeds every company on the systemCompared every month and eliminated
ControlsNone built inPer the systemLocked months, change log

How Finconsol consolidates a group

  1. Bring the books in

    Zoho Books organizations connect directly, read-only, and refresh every night. Companies on Xero, QuickBooks or any other system upload a monthly trial balance, and every row is checked before it is used. See integrations, including Zoho Books, Xero and QuickBooks.

  2. Map once

    Each company's accounts are mapped to one group chart. After that the mapping holds. A new account that is not mapped stops that month and is named, so nothing drops out silently.

  3. Translate

    Each foreign company is translated into the group's currency: closing rate for the balance sheet, average rate for profit and loss, historical rates for equity. The translation reserve makes the balance sheet balance. See multi-currency consolidation.

  4. Eliminate and adjust

    Balances between companies are compared pair by pair and eliminated, and group adjustments are entered as journals in Finconsol. Part-owned companies carry their minority interest. See intercompany eliminations.

  5. Report and lock

    The group statements, worksheet and trial balance are ready for any month, quarter or year. When they are final, the month is locked. See group reporting and close controls.

The consolidation worksheet, column by column

Zenvara Group, September 2026, USD thousands

A consolidation worksheet for the Zenvara Group with a column for each of the five companies, a column for eliminations and a group column. Revenue of 6,376 across the companies less 420 of intercompany fees gives group revenue of 5,956. Costs of 5,360 less the same 420 give 4,940. Net profit of 1,016 is unchanged by the elimination and ties to the statements.

Revenue, costs and net profit by company, eliminations and group, in USD thousands
Line TechnologiesInc.UKFZ-LLCPte.EliminationsGroup
Revenue 1,842 2,310 968 744 512 (420) 5,956
Costs (1,507) (2,004) (812) (610) (427) 420 (4,940)
Net profit 335 306 156 134 85 0 1,016

Swipe sideways to see the Eliminations and Group columns.

Ties to the statements

What you get

  • Group statements: balance sheet, profit and loss, cash flow (indirect method, reconciled to cash) and fund flow, each with its own balance check.
  • A consolidation worksheet with a column per company, the adjustment columns and the group column, tied to the statements.
  • A group trial balance on one chart of accounts.
  • Comparisons against the previous period and the same period last year.
  • Budget against actual, dashboards, your own report layouts and board packs.
  • Export of whatever is on screen to Excel and PDF.

The work around the statements is covered too: intercompany comparisons, statistical accounts such as headcount next to the numbers, and a close screen that shows what stops a month from being finished.

If your group is still on a spreadsheet, this comparison shows what changes. For an overview of the process itself, see the guide to consolidating financial statements.

Try it: switch to Profit & Loss, then open an intercompany elimination.

Consolidation worksheet for Hartwell Precision Industries Group, September 2026, four companies in INR. The tie-out shows every total agreeing with the published statements: total assets ₹4,30,15,32,593.42, income ₹48,45,74,520.55, expense ₹44,64,37,632.50 and net profit ₹3,81,36,888.05. The balance sheet view shows each company, the intercompany eliminations and the consolidated column, with intercompany receivables, the loan and investments in group companies eliminated to ₹0.00. The profit and loss view adds currency translation and other journals, and the intercompany income and expense of ₹15,34,95,138.20 eliminate to ₹0.00.

Consolidation worksheet Ready
Consolidation worksheetSeptember 2026 · Hartwell Precision Industries Group (whole group) · balance sheet as at the period end, profit and loss for the month
4 companies · amounts in INR
Tie-out Foots across and down
LineWorksheet consolidated columnStatement as publishedAgrees
Total assets ₹4,30,15,32,593.42 ₹4,30,15,32,593.42 Yes
Total liabilities & equity ₹4,30,15,32,593.42 ₹4,30,15,32,593.42 Yes
Income ₹48,45,74,520.55 ₹48,45,74,520.55 Yes
Expense ₹44,64,37,632.50 ₹44,64,37,632.50 Yes
Net profit ₹3,81,36,888.05 ₹3,81,36,888.05 Yes
Journal register agrees with the worksheet columns - - Yes

Every row adds across: the entity columns plus the adjustment columns equal the consolidated column.

AccountHartwell Precision Industries Pvt LtdHartwell Americas Inc.from USDHartwell Europe GmbHfrom EURHartwell Gulf Trading FZEfrom AEDIntercompany eliminationsConsolidated
Assets
1100.01Bank accounts ₹4,79,63,560.03 ₹6,28,54,188.50 ₹10,20,04,435.26 ₹3,39,60,365.26 - ₹24,67,82,549.05
1200Trade Receivables ₹60,90,67,734.19 ₹8,92,99,933.66 ₹22,63,67,571.31 ₹4,71,48,531.71 - ₹97,18,83,770.87
1250.01Raw materials and components ₹43,41,78,270.58 - - - - ₹43,41,78,270.58
1250.02Work in progress ₹11,27,36,010.77 - - - - ₹11,27,36,010.77
1250.03Finished goods ₹25,62,18,206.30 ₹6,76,62,064.94 ₹15,99,72,505.37 ₹3,43,40,306.22 - ₹51,81,93,082.83
1250.04Stores, spares and packing ₹1,05,69,109.24 - - - - ₹1,05,69,109.24
1310Intercompany Receivables ₹21,21,05,557.86 - - - (₹21,21,05,557.86) ₹0.00
1320Intercompany Loan Receivable ₹6,36,30,000.00 - - - (₹6,36,30,000.00) ₹0.00
1400Prepaid Expenses ₹2,88,27,840.02 ₹33,30,741.44 ₹85,01,344.79 ₹17,46,766.89 - ₹4,24,06,693.14
1450.01Statutory credits and input tax ₹2,01,79,488.01 ₹12,32,851.25 ₹30,12,722.93 ₹6,82,419.87 - ₹2,51,07,482.06
1450.02Advances to suppliers ₹1,44,13,920.01 - - - - ₹1,44,13,920.01
1510Investments in Group Companies ₹35,24,40,000.00 - - - (₹35,24,40,000.00) ₹0.00
1600.01Land and buildings ₹43,90,54,739.70 - - - - ₹43,90,54,739.70
1600.02Plant and machinery ₹2,26,85,75,358.23 ₹1,09,08,000.00 ₹1,90,33,200.00 ₹99,00,000.00 - ₹2,30,84,16,558.23
1600.03Tools, dies and moulds ₹30,84,50,619.34 - - - - ₹30,84,50,619.34
1600.04Office and IT equipment ₹10,03,83,983.70 ₹2,57,01,267.80 ₹4,58,04,709.09 ₹2,15,98,625.57 - ₹19,34,88,586.16
1690Accumulated depreciation (₹1,23,03,99,506.86) (₹2,62,50,959.19) (₹4,47,81,198.76) (₹2,27,17,133.75) - (₹1,32,41,48,798.56)
Total Assets ₹4,04,83,94,891.12 ₹23,47,38,088.40 ₹51,99,15,289.99 ₹12,66,59,881.77 (₹62,81,75,557.86) ₹4,30,15,32,593.42

Consolidation worksheet, a four-company manufacturing group, September 2026

Good to know

  • Zoho Books is the one direct connection today. Xero and QuickBooks join by trial balance upload, with direct connections coming soon.
  • For companies that join by trial balance, figures are at account level. Drilling down to the individual transaction works for Zoho Books companies.
  • Finconsol reads your books and never writes to them. Eliminations and adjustments live in Finconsol.
  • The group reports in one currency, chosen when the group is set up.

Questions

What is financial consolidation software?
It combines the books of several companies into one set of group accounts. It maps each company's accounts to a common chart, translates foreign currencies, removes what the companies owe each other, and produces the group balance sheet, profit and loss and cash flow.
What does consolidation software do that a spreadsheet cannot?
A spreadsheet can do the arithmetic, but it does not stop you when something changes. Finconsol stops a month when an account is unmapped, keeps intercompany balances on a list until they are resolved, keeps adjustments in Finconsol apart from the companies' books, locks finished months and records every change.
Which accounting systems does it work with?
Zoho Books connects directly, read-only, and refreshes every night. Xero, QuickBooks, Excel and any system that can export a trial balance join by monthly upload. Xero and QuickBooks direct connections are coming soon. One group can mix all of these.
Is it suitable for a small business with a few companies?
Yes. A group of two or three companies has the same problems as a larger one: different charts, different currencies and intercompany balances counted twice. Pricing depends on the number of companies and users, and most groups are live in a day.
How does it handle intercompany eliminations?
Every month Finconsol compares what each company holds against the other, pair by pair. The smaller side is eliminated by default, in an entry in Finconsol, apart from the companies' books. Anything not eliminated stays in the statements and on the list until it is resolved.
Do we need consolidation software if every company uses one currency?
Often yes. The intercompany balances, the different charts of accounts and the part-owned companies still need handling every month. Translation is only one of the steps, and a group with a single currency simply has nothing to translate.
How long does it take to set up?
Most groups are live in a day: connect or upload each company, map its accounts once, and see the first group accounts the same day. Past months can be loaded once so comparisons work from the start.
Does it replace our accounting software?
No. Each company keeps its own books in the system it already uses. Finconsol reads them and builds the group on top. Nothing is written back to Zoho Books or any other system.

Related

See your group in one picture

Thirty minutes, on a group shaped like yours.

Book a demo Get pricing