What Is a Consolidation Schedule? How Multi-Entity Financials Become One Set of Books

A consolidation schedule — also called a consolidation worksheet — is the accounting tool that combines the financial statements of several related companies into one unified report, presenting the group as if it were a single business. It is also where most multi-entity bookkeeping quietly falls apart, because the schedule only works if the underlying books agree with each other.

What the schedule actually looks like

Strip away the software and a consolidation schedule is a wide spreadsheet. One column per entity, holding that company’s trial balance. Then a pair of elimination columns — debits and credits. Then a final column: the consolidated group.

Every row is an account. Read left to right and you can see exactly how the group total was arrived at, and precisely which entries were removed on the way. That audit trail is the whole point. A consolidated total that nobody can trace back to the entities is not a consolidation, it is an assertion.

• Entity columns — each company’s trial balance, on a consistent chart of accounts
• Elimination columns — the adjustments that remove internal activity
• Consolidated column — the group as a single reporting entity

Note that the eliminations live only on the worksheet. They are not posted to any entity’s own books. Each company’s standalone accounts stay exactly as they were, which is why the schedule has to be rebuilt every period.

Consolidated or combined? The distinction decides everything

These two words get used interchangeably and they are not the same thing. The test is control.

Consolidated statements

Required when a parent holds a controlling financial interest in its subsidiaries. There is a parent, there are subsidiaries, and the parent’s investment in each subsidiary gets eliminated against that subsidiary’s equity. This is the ground covered by ASC 810.

Combined statements

Used where entities are economically linked by common ownership or common management but no entity controls another — three LLCs owned by the same two people, say, with no holding company above them. There is no parent investment to eliminate, because there is no parent. Everything else works the same way: the accounting policies for combined statements should match those used for consolidated statements, and intra-entity transactions and profits are eliminated identically.

Getting this wrong is common and consequential. A group of sister companies with no holding structure cannot produce “consolidated” statements no matter how the owner describes them, and a lender who asked for consolidated statements may not accept combined ones.

The elimination entries

Eliminations exist to answer one question: if this group were genuinely a single company, would this transaction exist at all? If the answer is no — because it happened between two parts of the same group — it comes out.

Intercompany receivables and payables

If Company A is owed $40,000 by Company B, the group as a whole is owed nothing. The receivable and the payable are removed against each other. This is the most common elimination and the one most likely to reveal that the books do not agree.

Intercompany sales, purchases, interest and dividends

Revenue that one group company earned from another is not group revenue. Management fees charged between entities, interest on intercompany loans, and dividends paid up to a parent all get removed. Leaving these in inflates both revenue and expenses, which flatters the top line without changing profit — a distortion lenders notice.

Unrealised profit on assets still inside the group

This is the subtle one. If A sells inventory to B at a markup and B still holds that inventory at period end, the profit has not been realised from the group’s point of view — the goods simply moved shelves. The profit sitting in B’s inventory value has to be stripped out. The concept normally applied is gross profit.

Investment in subsidiary against subsidiary equity

In a true consolidation, the parent’s investment account is eliminated against the subsidiary’s equity. Without this, the same net assets would be counted twice — once as the parent’s investment and again as the subsidiary’s underlying assets.

Non-controlling interest

When a parent owns less than 100% of a subsidiary, the slice it does not own is non-controlling interest, presented within equity. The group still consolidates the subsidiary in full — control, not percentage, drives consolidation — and then shows the portion attributable to outside owners.

One technical point that trips people up: the amount of intercompany profit or loss eliminated is not affected by the existence of a non-controlling interest. You eliminate the whole thing. The elimination may then be allocated between the parent and the non-controlling interest, but you do not eliminate only the parent’s share.

In combined statements, non-controlling interest usually does not arise from the sister-company relationship itself, since no entity holds an interest in another. It appears only if a member of the combined group has its own partly-owned subsidiary.

Also worth knowing: if a parent changes its ownership percentage but keeps control, that is accounted for as an equity transaction rather than a gain or loss.

Where consolidation schedules go wrong in practice

Intercompany accounts that do not agree

This is the number one problem, and it is a bookkeeping problem rather than a technical accounting one. Company A says it is owed $40,000; Company B shows $37,500. Until that $2,500 is explained, the schedule will not balance, and the difference is usually a timing cut-off, a payment posted to the wrong entity, or a transaction one side never recorded at all.

Different charts of accounts

If each entity has evolved its own account structure, every consolidation becomes a mapping exercise done from memory. The fix is a common chart of accounts across the group, with entity-specific accounts only where genuinely necessary.

Nobody owns the intercompany reconciliation

Each bookkeeper closes their own entity and assumes someone else checks the cross-entity balances. Often nobody does, and the differences compound quietly for years until a lender, a buyer or an auditor asks.

Different fiscal periods or currencies

Entities on different year-ends, or operating in different currencies, need alignment before anything can be combined. This is solvable but it needs deciding deliberately, not discovered at year end.

Treating it as a year-end job

A consolidation attempted once a year, from twelve months of unreconciled intercompany activity, is a reconstruction project. Done monthly it is a routine step, because the differences are small and recent enough to explain.

Who can prepare a consolidation schedule?

Building the schedule itself is bookkeeping and accounting work — no licence is required to prepare one, and most groups have theirs produced internally or by their bookkeeper. What requires a CPA is assurance: if a lender, investor or regulator wants audited or reviewed consolidated statements, that opinion can only come from a licensed CPA firm.

We are a bookkeeping and tax preparation company, not a CPA firm. We build and maintain the schedule, keep intercompany accounts reconciled month by month, and hand your CPA a package they can work from rather than rebuild. Where an audit is needed, the cleaner that package is, the less the audit costs.

What good multi-entity bookkeeping looks like

Groups that consolidate easily tend to do the same handful of things. A shared chart of accounts. Intercompany accounts that are matched and agreed every month, not every year. Intercompany transactions recorded on both sides at the time they happen. A consistent close calendar across entities. And an elimination schedule carried forward period to period, so last month’s reasoning is visible this month.

Our plans start at $75 a month for 5 hours, with additional hours at $15 an hour; multi-entity groups generally sit on the $300 a month, 20-hour Enterprise plan, which exists for exactly this kind of volume. Every plan carries a 100% money-back guarantee on your 1st retainer, refundable on the unused balance.

If one of the entities in your group ends up in a Chapter 11 filing, be aware the reporting logic reverses: jointly administered debtors generally file separate, non-consolidated monthly operating reports.