Consolidating companies that use different accounting systems
One group chart of accounts, mapped once, whatever each company keeps its books in. What a trial balance needs, what to check before loading it, and what changes each month.
In this post 7 sections
In short
A group whose companies keep their books in different systems can still produce one set of accounts. Map each company’s accounts once to a single group chart of accounts, then load each month’s balances as a trial balance for the same period and in the company’s own currency, and compare intercompany balances by counterparty.
Key takeaways
- Map once, not every month. Each company’s accounts go to one group chart, and only new accounts need attention afterwards.
- A trial balance is enough. It needs a period, a currency, account codes and balances that net to zero.
- Check before you load. A wrong period, a wrong currency or a trial balance that does not net to zero causes most failed loads.
- Compare intercompany by counterparty, in the transaction currency, before anyone translates anything.
Can a group consolidate companies that use different accounting systems?
Yes. Picture a group of four companies. Zenvara, the parentParentA company that controls one or more other companies.Open the glossary entry in the United Kingdom, keeps its books in Zoho Books. Fernhollow, a subsidiarySubsidiaryA company that is controlled by another company, its parent.Open the glossary entry in the United States, is on QuickBooks. Kestrelwick in Singapore is on Xero. Palmridge in Dubai keeps its books in another system and sends a trial balance each month. Four systems, four currencies, four ways of naming the same expense.
The systems do not need to talk to each other. The group needs the same few facts from every company: balances for the same period, in a known currency, against accounts that can be matched to one common list. Each accountant keeps working in the system they already know.
In Finconsol, Zoho Books connects directly. Xero and QuickBooks companies come in by trial balance upload today, and a direct connection for both is coming soon. Any other system, spreadsheets included, comes in the same way: as a trial balance exported to Excel or CSV.
What does one group chart of accounts do?
A group chart of accountsGroup chart of accountsOne list of accounts that every company's own accounts are mapped to, so that figures from different companies and systems add up line by line.Open the glossary entry is one list of accounts that every company’s own accounts are matched to. Zenvara’s “Service income”, Fernhollow’s “Sales” and Palmridge’s “Room and food revenue” are three names for one group line, Revenue. Once they are matched, the amounts add up line by line, whatever each system calls them.
The matching is done once for each account. After that only new accounts need a decision, which is a short list each month. Exhibit 1 shows the revenue line for September 2026, with each company’s figure translated at the group’s average rate for the month1.
| Zenvara, Zoho BooksGBP, as booked | 625,000 |
| Fernhollow, QuickBooksUSD 460,000 at the average rate 0.7540 | 346,840 |
| Palmridge, trial balanceAED 4,800,000 at the average rate 0.2025 | 972,000 |
| Revenue before eliminations | 1,943,840 |
| Less: services sold to PalmridgeZenvara’s invoices of AED 400,000 at 0.2025, removed on consolidation | (81,000) |
| Group revenue | 1,862,840 |
Example group used across Finconsol guides. Figures rounded to the pound.
The removal of 81,000 matters. Zenvara counted the sale as revenue and Palmridge counted it as a cost. Inside the group nothing was sold, so both go2, and group profit does not change.
What does a trial balance upload need?
A trial balanceTrial balanceA list of every account balance at a date, with total debits equal to total credits. It is the starting point for consolidating a company's figures.Open the glossary entry is a list of every account balance at a date, with debits equal to credits. For a consolidation it has to carry four things.
- The period. The month-end date the balances are as at, such as 30 September 2026. Not the day the file was exported.
- The currency. The currency the company keeps its books in, stated once for the file.
- The account codes and names. Codes are what the matching to the group chart hangs on, so each account needs one that stays the same from month to month.
- Balances that net to zero. The debits and credits in the file add up to the same total. If they do not, something is missing.
Most systems export income and expense accounts for the year to date. Decide once whether you load year to date or the month alone, and keep to it for every company.
What should you check before loading a trial balance?
A few minutes of checks save a rerun on day three of the close. The same list works for every system.
- The period is the month-end date and not the export date.
- The currency is the company’s own, not the group’s.
- Total debits equal total credits.
- The opening balances agree with last month’s closing balances.
- Every account has a code, and any new code is on the list for matching.
- The intercompany accounts are there, and each balance names its counterparty.
- The company has booked everything up to the cut-off, so the month is complete.
How do currencies and intercompany work across systems?
Each company reports in its own currency. The group translates: assets and liabilities at the closing rateClosing rateThe spot exchange rate on the last day of the reporting period, used to translate a foreign subsidiary's assets and liabilities.Open the glossary entry and income and expenses at the average rateAverage rateThe exchange rate for a period, usually the month, used to translate a foreign subsidiary's income and expenses into the group's presentation currency.Open the glossary entry for the month1. The difference between the two goes to the translation reserveTranslation reserveThe part of group equity that holds exchange differences from translating a foreign subsidiary into the group's currency.Open the glossary entry. Because one set of group rates is used for every company, it does not matter which system a balance came from.
Intercompany needs a little more care, because each side comes from a different system. Ask every company to list its intercompany balances by counterpartyCounterpartyThe other group company in an intercompany balance or transaction.Open the glossary entry and in the currency of the transaction. Compare the pairs in that currency first, then in the group currency. The routine in why intercompany balances never agree works unchanged when the two sides sit in different systems.
What changes from month to month?
Very little, which is the point. The matching of accounts stays. What changes is short and the same every month.
- The trial balances for the new month. Zoho Books refreshes by itself overnight. For every other system the accountant uploads the file at month-end.
- A few new accounts or counterparties to match.
- The month’s closing and average rates.
- The intercompany differences, which should be fewer once each company reports by counterparty.
A group that moves one company to a different system does not start again. The new system’s accounts are matched to the same group chart, and last month’s figures stay where they are.
Questions
Can I consolidate a company that only keeps a spreadsheet?
Yes, if the spreadsheet can produce a trial balance: account codes, names and balances that net to zero for the month. The group chart of accounts does the rest. If the spreadsheet cannot produce one, building a simple trial balance from the ledger is a small price for group numbers.
Do all the companies need the same chart of accounts?
No. Each company keeps its own chart and the group matches it once to the group chart. What must be the same is the group chart itself and the way the companies apply accounting policies to like transactions.
Does Finconsol connect directly to Xero and QuickBooks?
Zoho Books connects directly. Xero and QuickBooks companies come in by trial balance upload today, and a direct connection is coming soon. Any other system comes in by trial balance as well.
Which exchange rate applies to a trial balance in a foreign currency?
Assets and liabilities are translated at the closing rate and income and expenses at the rate on the transaction date, for which a monthly average is often used. Equity is kept at the rates when it arose. The difference goes to the translation reserve. This follows IAS 21.
Sources
- IAS 21 The Effects of Changes in Foreign Exchange Rates, paragraphs 39 and 40 (translation at the closing rate and at the average rate) and paragraph 41 (exchange differences to other comprehensive income).
- IFRS 10 Consolidated Financial Statements, paragraph B86(c) (intragroup assets, liabilities, income and expenses are eliminated in full).
Prabhu, A. (2026, 14 October). Consolidating companies that use different accounting systems. The Finconsol Blog. https://finconsol.com/blog/consolidating-different-accounting-systems/
Amit Prabhu leads Finconsol at Aaxonix Tech, a Zoho and NetSuite implementation partner based in Pune, India. He works with multi-company groups and the accountants who serve them on closing many sets of books into one set of group numbers.