Blog
Latest articles, guides and insights from the dataSights team.
Consolidated Financial Statements Subsequent to Date of Acquisition: Your Step-by-Step 2026 Breakdown
by Kevin Wiegand
|Feb 25, 2026
|Xero
You closed the deal, recorded the fair values, and prepared your first consolidated accounts. Now you have to do it again next month – and every month after. Preparing consolidated financial statements subsequent to date of acquisition follows different rules from the acquisition-date consolidation.
How to Calculate Goodwill in Consolidated Financial Statements (IFRS and FRS 102): Step-by-Step for Finance Teams
by Kevin Wiegand
|Feb 25, 2026
|Xero
Goodwill is one of those numbers that looks simple, then breaks your consolidation when one input is off by £1. If you're searching for how to calculate goodwill in consolidated financial statements, you need the acquisition-date fair values, the consideration transferred, and the NCI measurement choice.
Goodwill in Consolidated Financial Statements: How to Calculate It and Avoid Impairment Surprises
by Kevin Wiegand
|Feb 25, 2026
|Xero
When your group acquires a subsidiary for more than the fair value of its net assets, the excess becomes goodwill on your consolidated balance sheet. This intangible asset sits exclusively in the consolidated financial statements and requires annual impairment testing.
Standalone vs Consolidated Financials: What Multi-Entity Finance Teams Need to Know
by Kevin Wiegand
|Feb 19, 2026
|Xero
Are you running month-end close across multiple entities and still relying on standalone reports to tell the full story? If your business has grown beyond a single company, understanding standalone vs consolidated financials is not optional – it determines whether your reporting is accurate.
First Time Consolidation of Financial Statements: A Step-by-Step Guide for Finance Teams
by Kevin Wiegand
|Feb 19, 2026
|Xero
Your group just acquired a new subsidiary. Or your business has grown from a single entity into a multi-company structure. Either way, the task ahead is clear: you need to prepare consolidated financial statements, and you have never done it before.
Consolidated Financial Corporation: A Practical Guide to Group Consolidation for Multi-Entity Finance Teams
by Kevin Wiegand
|Feb 19, 2026
|Xero
If you manage multiple entities, consolidation usually fails in the same places every month: mismatched intercompany balances, FX translation, and eliminations living in fragile spreadsheets. A consolidated financial corporation is simply a group that reports as a single economic entity.
Auditors Report on Consolidated Financial Statements: What Every Multi-Entity Finance Team Should Know
by Kevin Wiegand
|Feb 16, 2026
|Xero
You have spent weeks pulling together subsidiary data, processing elimination entries, and reconciling intercompany balances – then the auditors arrive and every formula, journal, and assumption faces fresh scrutiny. If your consolidation process cannot withstand that level of review, audit season becomes your most stressful month.
Treatment of Dividend in Consolidated Financial Statements: What Every CFO Needs to Know
by Kevin Wiegand
|Feb 16, 2026
|Xero
Your subsidiary declares a £200,000 dividend to the parent company, retained earnings drop on one side, and dividend income appears on the other. Simple enough on each entity's books, but what happens when you consolidate? The treatment of dividend in consolidated financial statements eliminates this entirely.
Multi-Entity Xero Reporting in Looker Studio: From Setup to Consolidated Dashboards
by Kevin Wiegand
|Feb 13, 2026
|Xero
If you're trying to deliver multi-entity Xero reporting in Looker Studio, you'll quickly hit the limits of connect-and-go setups – especially once you have multiple Xero organisations to roll up. Looker Studio doesn't provide a Google-built Xero connector.
Xero to Looker Studio: From Manual Exports to SQL Database Automation
by Kevin Wiegand
|Feb 4, 2026
|Xero
Ever wondered why your Xero financial data seems trapped inside your accounting software while your team builds dashboards in Looker Studio? You're not alone. Finance teams across the UK, Australia, and New Zealand face this exact challenge every month-end.
Page 4 of 16