DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

Understanding the Complete Criteria for Consolidated Financial Statements Under IFRS, UK GAAP, and US GAAP

Understanding the Complete Criteria for Consolidated Financial Statements Under IFRS, UK GAAP, and US GAAP

by Kevin Wiegand

|

Jan 5, 2026

|

Xero

Which subsidiaries must appear in your consolidated financial statements? If the consolidation scope is wrong, finance teams often face audit queries, rework, and delayed reporting. The criteria for consolidated financial statements centre on co

How to Prepare Consolidated Financial Statements in Excel: The Complete 2026 Guide for Multi-Entity Finance Teams

How to Prepare Consolidated Financial Statements in Excel: The Complete 2026 Guide for Multi-Entity Finance Teams

by Kevin Wiegand

|

Jan 2, 2026

|

Xero

Does your month-end close feel like a never-ending battle with spreadsheets, manual exports, and formula errors? For CFOs and Financial Controllers managing multiple entities, learning how to prepare consolidated financial statements in Excel is

Condensed Financial Statements vs Consolidated: What Every Multi-Entity CFO Needs to Know

Condensed Financial Statements vs Consolidated: What Every Multi-Entity CFO Needs to Know

by Kevin Wiegand

|

Dec 30, 2025

|

Xero

When your CFO asks whether to prepare condensed or consolidated financial statements, how do you respond? Many finance professionals conflate these two fundamentally different reporting formats, creating confusion during month-end close and pote

Presentation of Minority Interest in Consolidated Financial Statements: The Complete 2026 Guide

Presentation of Minority Interest in Consolidated Financial Statements: The Complete 2026 Guide

by Kevin Wiegand

|

Dec 30, 2025

|

Xero

Ever closed the month only to have your consolidation tie out – until you split out minority interest? Presentation of minority interest in consolidated financial statements gets tricky when ownership percentages change, intercompany elimination

Financial Services Consolidation: How to Automate Multi-Entity Reporting and Cut Close Time to ~5 Business Days

Financial Services Consolidation: How to Automate Multi-Entity Reporting and Cut Close Time to ~5 Business Days

by Kevin Wiegand

|

Dec 22, 2025

|

Xero

Financial services consolidation across multiple entities often takes finance teams over 15 business days at month-end. You’re manually combining spreadsheets, eliminating intercompany transactions, and reconciling accounts that won’t balance. Y

Intercompany Transactions Consolidated Financial Statements: Best Practices for CFOs

Intercompany Transactions Consolidated Financial Statements: Best Practices for CFOs

by Kevin Wiegand

|

Dec 22, 2025

|

Xero

Managing a group of companies means dealing with internal transactions every day. One subsidiary sells to another. Your parent company loans money to a subsidiary. Shared services get allocated across entities. These intercompany transactions co

Xero Consolidation Management Reporting: Transform Multi-Entity Chaos Into Board-Ready Insights

Xero Consolidation Management Reporting: Transform Multi-Entity Chaos Into Board-Ready Insights

by Kevin Wiegand

|

Dec 12, 2025

|

Xero

You’re running multiple Xero entities, and every month-end feels like Groundhog Day. Export Trial Balances from each entity. Merge them in Excel. Create elimination journals. Build management reports. Check that everything balances. Then watch y

Consolidated Account: Your Complete Guide to Multi-Entity Financial Reporting

Consolidated Account: Your Complete Guide to Multi-Entity Financial Reporting

by Kevin Wiegand

|

Dec 11, 2025

|

Xero

Ever wondered why month-end consolidation drags on for weeks? For finance teams managing multiple entities, manual consolidation often takes over 15 business days – spent chasing mismatches and juggling spreadsheets. This guide explains what con

What GAAP Principles Govern the Consolidation of Financial Statements? The Complete 2026 Guide

What GAAP Principles Govern the Consolidation of Financial Statements? The Complete 2026 Guide

by Kevin Wiegand

|

Dec 11, 2025

|

Xero

Page 2 What GAAP principles govern the consolidation of financial statements is a question finance teams often face when juggling multiple entities, intercompany eliminations, and increasing audit scrutiny. Understanding when a controlling finan

How to Run Consolidated Group Financial Statements in Xero: The Complete 2026 Guide

How to Run Consolidated Group Financial Statements in Xero: The Complete 2026 Guide

by Kevin Wiegand

|

Dec 8, 2025

|

Xero

Page 2 If you’re searching for how to run consolidated group financial statements in Xero, there are two routes: a controlled Excel workflow or an automated approach via the Xero API. Excel can work for simple groups, but it quickly breaks down