Blog
Latest articles, guides and insights from the dataSights team.
Consolidated and Non Consolidated Financial Statements: The Complete 2026 Guide for Multi-Entity Businesses
by Kevin Wiegand
|Dec 8, 2025
|Xero
Page 5 Running multiple entities means messy close cycles and spreadsheets that never quite balance. This guide explains consolidated and non consolidated financial statements in plain English, so your group reports reconcile first time. You wil
Financial Consolidation Process: The Complete 2026 Guide for Multi-Entity Businesses
by Kevin Wiegand
|Dec 8, 2025
|Xero
Page 6 Your finance team is buried in spreadsheets two weeks after month-end, trying to make the consolidated Trial Balance balance. One entity’s figures keep changing. Intercompany eliminations don’t reconcile. Your CFO needs the group P&L...
Consolidated Audited Financial Statements: The Complete Guide for Multi-Entity Groups
by Kevin Wiegand
|Nov 27, 2025
|Xero
Your auditors have requested consolidated financial statements for the year-end review, and the clock is ticking. For CFOs managing multiple entities across different systems, the challenge isn’t just producing consolidated figures – it’s...
Limitations of Consolidated Financial Statements: What Every CFO Must Know in 2026
by Kevin Wiegand
|Nov 27, 2025
|Xero
Page 2 Your month-end consolidation took 15 days, everything balanced, and you presented the results to the board. Then someone asked which subsidiary drove the profit decline – and your consolidated statements couldn’t answer. This scenario pla
Financial Consolidation and Close: The Complete 2026 Guide
by Kevin Wiegand
|Nov 26, 2025
|Xero
Page 6 Managing financial consolidation and close across multiple entities shouldn’t mean spending weeks in spreadsheets hunting for elimination entries that won’t balance. The financial consolidation and close process combines data from all you
Employment Hero Payroll Excel Reporting Automation: Complete 2026 Integration Guide
by Kevin Wiegand
|Nov 24, 2025
|Employment Hero Payroll
Employment Hero Payroll You export CSVs from Employment Hero Payroll, manually import to Excel, format columns, fix errors, and then repeat next week. Manual payroll administration is time-consuming, and errors attract penalties – in the UK, HMR
How to Connect Employment Hero Payroll to Power BI: Your Complete 2026 Guide
by Kevin Wiegand
|Nov 21, 2025
|Employment Hero Payroll
Employment Hero Payroll Your finance team exports Employment Hero payroll reports to CSV, manually imports them to Excel, then copy-pastes into Power BI, and you want to know how to connect Employment Hero Payroll to Power BI without custom code
How to Automate Employment Hero Payroll: Connect Power BI, Excel and SQL for Real-Time Reporting
by Kevin Wiegand
|Nov 21, 2025
|Xero
You process Employment Hero Payroll, but then spend hours exporting CSVs, combining data in spreadsheets, and manually building reports your finance team actually needs. You know there’s a better way. Employment Hero Payroll handles pay runs eff
Non Controlling Interest in Consolidated Financial Statements: The Complete 2025 Guide
by Kevin Wiegand
|Nov 21, 2025
|Xero
You own 75% of a subsidiary but consolidate 100% of its financials – then your accountant creates something called “non controlling interest in consolidated financial statements” for the remaining 25%. This represents the equity and earnings...
Power BI With Xero Data – OData vs SQL Database: The Complete Technical Guide
by Kevin Wiegand
|Nov 21, 2025
|Xero
You’re connecting Xero to Power BI and facing a critical decision: OData or SQL database? When implementing Power BI with Xero data – OData vs SQL Database architectures offer vastly different capabilities for report performance and multi-entity
Page 8 of 16