White-Label Multi-Entity Financial Consolidation for CPA Firms and CFOs

Day nine of the close. The consolidated balance sheet is out by $14,812, and nobody can say why. Three people spent two days on it. When the answer finally turns up, it's boring. The UK sub booked a management fee from the US parent at one exchange rate, the parent booked it at another, and the elimination entry only matched half of it.

If you've ever consolidated more than two entities in more than one currency, you've lived some version of that. And more of your clients are getting there. A US company opens a UK office for its European customers. A Canadian sub shows up after an acquisition. Suddenly a client that used to need one set of books needs three, plus a consolidation, plus filings in countries your team has never filed in. Call it global accounting or don't. The client just wants one set of numbers they can trust.

This post is about doing that work well, behind your firm's name. Not the textbook version. The version where rates don't line up and somebody forgot the intercompany loan.

A three-entity example, start to finish

Take a made-up but very ordinary group. A US parent reporting in dollars. A UK subsidiary that runs in pounds. A Canadian subsidiary that runs in Canadian dollars. Each has its own books, in its own currency, kept by whoever the client found locally.

Step one happens before any consolidation: each sub has to close its own month properly. Local bank recs, local payroll, VAT in the UK, GST/HST in Canada. If those books are a mess, nothing downstream fixes it.

Step two is translation. Under ASC 830, a sub whose functional currency is pounds gets translated into dollars like this: assets and liabilities at the rate on the balance sheet date, income and expenses at the rates when they happened (an average rate is fine), and equity at historical rates. Whatever doesn't balance after that goes to the cumulative translation adjustment, inside other comprehensive income (Deloitte's ASC 830 roadmap walks through it).

Here's the UK sub at year-end, with illustrative rates of 1.35 at close, 1.30 average and 1.25 when the shares were issued.

That $22,500 isn't an error. It's the pound strengthening during the year, and it sits in equity, not the P&L. People also go wrong by translating equity at the closing rate. Do that, and the CTA nearly vanishes. Nothing looks wrong, because the balance sheet still balances. We've seen that one sit untouched for three years.

Step three is eliminations. Anything the group did with itself has to come out, so the consolidated numbers only show business with the outside world.

Eliminations that actually eliminate

Back to that $14,812. The US parent charges the UK sub a $20,000 management fee every month. The parent books a $20,000 receivable. The UK bookkeeper records a payable in pounds at whatever rate was on the screen that day and never touches it again.

Now the month end arrives. The pound has moved. Translated at the closing rate, the UK payable no longer equals $20,000, so the elimination leaves a few hundred dollars hanging. Twelve months of that, plus a couple of fees booked in the wrong month, and you've got your mystery number.

The fix isn't clever. Pick a currency for every intercompany charge, and put it in writing. Say the fee is billed in dollars. Then the UK books hold a dollar payable, and each month-end it gets restated in pounds, with any gain or loss landing in the UK P&L. And before anyone starts consolidating, both sides agree on their balances. Day four is a good target: one invoice, one cutoff, one date.

Two more that trip people up. First, intercompany sales of inventory. If the Canadian sub buys a product from the parent at a markup and hasn't sold it yet, that markup is profit the group hasn't earned, so it comes out of inventory and out of income. Second, intercompany loans. A loan the parent has no plan to collect in the foreseeable future can be treated as part of its investment. Then the FX swings on it go to the CTA instead of running through earnings. That's a judgment call, so write down the reasoning in a memo before year-end, not after.

The filings that come along for the ride

Consolidation is a reporting problem. Owning foreign subs is also a tax-filing problem, and the two tend to land on the same desk.

A US parent with a controlled foreign corporation generally files Form 5471, and the penalty for skipping it starts at $10,000 per form, per year. Flip it around: if a foreign parent owns a US company, Form 5472 applies, with a $25,000 starting penalty. Up north, a Canadian sub with more than CAD 1 million of transactions with related non-residents files a T106, or pays $25 a day up to $2,500 per form (Mondaq has a handy side-by-side).

None of those forms get filled in from scratch. They're built from the intercompany ledger. If the intercompany balances are clean and documented every month, the tax team's job in March gets a lot shorter. If they aren't, the tax team ends up doing the consolidation's homework. That management fee needs transfer pricing support too, even something simple, because both tax authorities can ask why it's $20,000 and not $12,000.

How white-label consolidation support runs

Here's roughly how we'd run it month to month for a CPA firm or a client's finance lead.

The entity books come first. Plenty of firms find us by searching for white-label bookkeeping support, international or worldwide, and honestly that's the right place to start. One team keeping the US, UK and Canadian books to the same chart of accounts, the same cutoff and the same close calendar removes most of the problems above before they happen. We're writing a separate piece on global bookkeeping support across the US, UK, Australia and Canada, and we'll link it here.

Then the tooling. A QuickBooks Online or Xero file won't consolidate by itself. Smaller groups mostly get by with a consolidation workbook, or an add-on that pulls the files together. Once a client outgrows that, NetSuite OneWorld and Intuit Enterprise Suite both handle eliminations inside the system. Honestly, any of these is fine if the account mapping is right. None of them is if it isn't.

A typical calendar looks like this. Days one to three, each entity closes locally. On day four, intercompany balances are confirmed, and any differences are chased. Day five: translation, eliminations and the consolidated draft. Day six, a second reviewer on the white-label team checks the CTA rollforward and the elimination schedule. Then it goes to your manager, and out under your name.

If you're weighing offshore teams more broadly, our roundup of top offshore accounting firms for CPA practices covers what else is out there.

Questions we hear about multi-entity consolidation

Do small groups really need a formal consolidation? Once the parent controls a sub, usually by owning more than half of it, and a bank or investor is reading the numbers, expect them to ask for consolidated statements. If nobody outside sees them, you can keep it lighter. You still want the eliminations, though. Otherwise nobody knows what the business really made.

Translation or remeasurement, what's the difference? Translation is the whole-company step. The UK sub's pound statements get turned into dollars, and the leftover goes to the CTA. Remeasurement is smaller. It's the UK sub fixing up a dollar payable in its own pound books each month, and that one hits its P&L. When a small group's numbers won't tie, this mix-up is the first place we'd look.

Can one white-label team keep books in several countries? For most of it, yes. The bookkeeping travels fine, and so do intercompany, translation and the consolidation itself. Local statutory work is different. UK statutory accounts or a Canadian corporate return usually belong with an accountant on the ground in that country, and any partner worth hiring tells you that on day one.

Work with DNA Growth

DNA Growth is the team behind a lot of CPA firms, fractional CFOs and finance leaders when a client goes multi-entity. We keep every entity's books to one standard. Intercompany gets confirmed early, before it turns into a $14,812 mystery. You get a consolidation ready for review, with your name on it. See how our white-label consolidation support for CFOs and finance leaders works, or talk to our team.