Templates

Consolidation Workbook

A consolidated income statement built from five entities, intercompany sales, fees, interest and dividends eliminated, unrealized profit in inventory, a noncontrolling interest rolled forward and proved two ways, a purchase of minority shares, a loss of control with its retained interest, and a Canadian subsidiary translated with its cumulative translation adjustment explained: eleven tabs, one fictional group, no macros.

Enter your entities, transfer prices, ownership and exchange rates. The workbook eliminates $42,900,000 of intercompany sales, defers $1,360,500 of unrealized profit, attributes $556,062.50 of income to the noncontrolling interest and ends it at $2,747,750, measures a $2,350,000 gain on a loss of control and explains a cumulative translation adjustment of -$411,464. A Checks tab ties 40 figures to the book.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 147 free models.

Consolidation_Workbook.xlsx (25 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind the workbook: The Consolidation Accounting Handbook, PDF and paperback, with the full case, the IFRS notes and the checklists.

What is in the workbook

Inputs
the Ridgeline acquisition (price, fair value of the NCI, book equity, step-ups and lives), Ridgeline's earnings and dividends for 2023 and 2024, the 2025 income statement lines of each entity, the exchange rates, the intercompany inventories and margins, the Ridgeline purchase of 1 October, the Harlow Logistics sale, Harlow Canada's balance sheet, Brook Street's figures and the opening consolidated equity.
Entities
the 2025 income statement of each entity, with Harlow Canada translated at the average rate and Harlow Logistics for six months, and each entity's pretax income, tax and net income.
Eliminations
the consolidated income statement worksheet, from the sum of the entities to consolidated revenue, pretax income, tax and net income, with each elimination on its own line.
Inventory
the unrealized profit in inventory for the three intercompany flows, opening and closing, with the change charged to cost of sales and the split of Ridgeline's upstream profit, and the equipment transfer illustration.
NCI
the acquisition-date goodwill and its split, the NCI at 1 January 2025 by roll-forward and by the direct check, Ridgeline's adjusted income, the attribution by period and the roll-forward to 31 December.
Ownership
the purchase of 10% of Ridgeline: NCI at 30 September, carrying amount transferred, charge to paid-in capital, and the schedule of the effect on Harlow's equity.
Deconsolidation
the gain on the loss of control of Harlow Logistics, the remeasurement portion, the comparison with Harlow's own gain, and the equity-method investment to year-end.
Translation
Harlow Canada's balance sheet translated at the closing rate, equity at historical rates, the cumulative translation adjustment and its components, the long-term loan and consolidated other comprehensive income.
VIE
Brook Street's balance sheet and income, the equity ratio, and the effect of consolidating it on the balance sheet, net income and income attributable to Harlow.
Bridge
the reconciliation from Harlow's own net income to net income attributable to Harlow, and the consolidated equity roll-forward.
Checks
a list of controls that compare the workbook's results with the figures printed in the book, ending in a single cell that reads ALL CHECKS OK when every one passes.

Every assumption is shaded in a light color on the Inputs tab; every other cell is a formula, with no macros, no links to other files and no circular references. Every ratio is guarded against an empty divisor. Replace the inputs with your own group's figures; the Checks tab will then show differences from the book by design.

From The Consolidation Accounting Handbook. To read: intercompany eliminations, worked · the noncontrolling interest, calculated · the cumulative translation adjustment, explained.