DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

How to Set Up Xero to Power BI Connection: The Complete 2026 Guide

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

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

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

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

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

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

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

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

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

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