Blog
Latest articles, guides and insights from the dataSights team.
How to Set Up Xero to Power BI Connection: The Complete 2026 Guide
by Kevin Wiegand
|Jan 14, 2026
|PowerBI
If you’re searching for how to setup xero to power bi connection, this guide walks you through the most reliable approach: land Xero data in a secure cloud database first, then connect with Power BI’s native SQL connectors. This staging pattern
Annual Consolidated Financial Statements: The Complete 2026 Guide
by Kevin Wiegand
|Jan 14, 2026
|Xero
You’re managing multiple entities, and month-end consolidation feels like piecing together a jigsaw puzzle in the dark. Parent company books show one story, subsidiaries another, and intercompany transactions create a reconciliation nightmare. A
Holding Company Consolidated Financial Statements: Control, Eliminations, and Automation
by Kevin Wiegand
|Jan 13, 2026
|Xero
When you control multiple subsidiaries through a holding company structure, understanding consolidated financial statement requirements isn’t optional. Parent companies that control one or more entities must combine their financial data into uni
Consolidated Group Accounts: The Complete UK Guide for CFOs
by Kevin Wiegand
|Jan 13, 2026
|Xero
Managing several entities means juggling separate Trial Balances, delayed reporting, and constant audit queries. If you need clear group-level visibility, consolidated group accounts become essential for accurate reporting and compliance. This g
How to Prepare Consolidation of Financial Statements with Examples: The Complete 2026 Guide
by Kevin Wiegand
|Jan 13, 2026
|Xero
Your month-end close stretches beyond two weeks. Balance sheets don’t reconcile. Elimination entries consume days of manual work. Understanding how to prepare consolidation of financial statements with examples transforms this complex process in
Employment Hero Payroll vs Manual Payroll Reporting: The 2026 Complete Comparison
by Kevin Wiegand
|Jan 13, 2026
|Employment Hero Payroll
Employment Hero Payroll vs Manual Payroll Reporting comes down to time investment and compliance risk. Manual payroll processing takes anywhere from several hours to an entire week per pay period, requiring you to calculate wages, determine ATO
Power BI Financial Reporting: The Complete Guide for CFOs and Finance Teams
by Kevin Wiegand
|Jan 7, 2026
|PowerBI
Spending hours each month wrestling with spreadsheets and manual data exports? Many finance teams across Australia, the UK and New Zealand face the same challenge: turning raw accounting data into reports that actually drive decisions. Power BI
Interim Consolidated Financial Statements: The Complete IAS 34 Compliance Guide for 2026
by Kevin Wiegand
|Jan 7, 2026
|Xero
Your quarter-end close deadline is approaching. You manage twelve Xero entities across three countries, and the board wants interim consolidated results by next Tuesday. Sound familiar? Interim consolidated financial statements use the same cons
Presentation of Consolidated Financial Statements: Everything You Need to Know in 2026
by Kevin Wiegand
|Jan 7, 2026
|PowerBI
Tomorrow’s board meeting depends on one thing – accurate, reconciled consolidated financial statements. Yet intercompany eliminations, non-controlling interest mismatches, and version-chaos Excel files often derail accuracy. This guide explains
Exemption from Consolidation of Financial Statements: UK Thresholds and Conditions
by Kevin Wiegand
|Jan 7, 2026
|Xero
Does your group qualify for an exemption from consolidation of financial statements? For many UK parent companies, this question determines whether finance teams spend days each month on group reporting or avoid it entirely. Getting the answer w
Page 6 of 16