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
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
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
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
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
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
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
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
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
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
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
Page 7 of 16