When a family-owned group grows from one company into four, the paperwork multiplies faster than the profit. I worked with a holding group that had a distribution arm, an installation service firm, a small manufacturing line, and a leasing entity that owned the vehicles and machines. Altogether about 150 employees, three sets of shareholders, and two currencies. Every month, the finance team spent six days consolidating numbers in spreadsheets, and every month, the family asked more questions than the numbers could answer.
The issues were not glamorous. Loans between the companies had no clear repayment schedule, one company charged rent to another but the invoice was never booked in the right month, and the leased equipment was carrying depreciation in the wrong entity. The owner, a sharp woman in her late fifties, summed it up in a single sentence: “I know total revenue, but I don’t know what each business actually earns.” That’s the sentence that brought ERPNext Consulting into the group.
Why consolidation fails when you run a multi-company group
Spreadsheets are fine for one company. The disaster begins the moment you need to eliminate balances between companies, revalue one currency inside another, and prepare a combined report where the numbers add up. The finance team tried to build reconciliation tables, but every month some invoice went missing or a sale between companies was recorded only on one side. The solution wasn’t to hire more people to feed the spreadsheet; it was to change the setup so that every entity logged its transactions into the same chart of accounts, with the same rules, against the same calendar.
- Set one fixed closing calendar: all four companies close their books on the same day every month, no exceptions, so the consolidation starts on a clean date.
- Create a single chart of accounts that everyone uses, and resist the urge to let each director customize their own account names, or the consolidation becomes a translation exercise instead of an arithmetic one.
- Book every transaction between companies immediately, with a document reference, so the balance between two companies can be verified in minutes instead of days.
The finance team’s consolidation time dropped from six days to half a day. More importantly, the quarterly family meeting changed its character: instead of debating whose numbers were right, they started debating which business deserved more capital, which is a much better problem to have. ERPNext Consulting‘s role was not to build an elaborate reporting palace, but to make the foundation clean enough that the family could finally see its own reality.
The one practice that made all the difference
Every invoice between companies, every loan repayment, every rental charge between entities, was given a document number and posted within 48 hours. That single rule eliminated more than half of the reconciliation problems in the first two months. The finance team was skeptical at first, because they were used to catching up at month end, and the thought of continuous posting required a discipline shift. But the shift paid off in a ratio they could immediately appreciate: one day of finance work per month, instead of nearly a week.
If your business has more than one legal entity, and you feel queasy when someone asks “what did each part of the group actually earn?”, then your first step is to run a single balance sheet between all entities involved. List every loan, rental, and service charge, and note which ones have a matching entry on the other side. The missing matches are your top two fixes for the next month. Once those are clean, your consolidation will start to feel like math instead of detective work, and that’s exactly the feeling a growing family business deserves.