dataSights

Blog

Latest articles, guides and insights from the dataSights team.

Xero to Looker Studio: From Manual Exports to SQL Database Automation

Xero to Looker Studio: From Manual Exports to SQL Database Automation

by Kevin Wiegand

|

Feb 4, 2026

|

Xero

Ever wondered why your Xero financial data seems trapped inside your accounting software while your team builds dashboards in Looker Studio? You're not alone. Finance teams across the UK, Australia, and New Zealand face this exact challenge every month-end.

Looker Studio vs Power BI: The Complete 2026 Comparison for Xero Users

Looker Studio vs Power BI: The Complete 2026 Comparison for Xero Users

by Kevin Wiegand

|

Feb 4, 2026

|

Xero

Your Xero data needs to reach a dashboard, but Looker Studio has no native Xero connector. Power BI’s built-in options still often require a connector or staging layer once you add multi-entity reporting and consolidation rules. This forces fina

Consolidated Financial Statements After Acquisition: Complete Post-Acquisition Guide for Finance Teams

Consolidated Financial Statements After Acquisition: Complete Post-Acquisition Guide for Finance Teams

by Kevin Wiegand

|

Jan 30, 2026

|

Xero

You’ve just completed an acquisition. Now the priority is producing consolidated financial statements after acquisition that present the group as a single economic entity from the date you obtained control. That means eliminating the investment,

Consolidated Financial Statements Foreign Subsidiary: What Finance Teams Need to Know

Consolidated Financial Statements Foreign Subsidiary: What Finance Teams Need to Know

by Kevin Wiegand

|

Jan 30, 2026

|

Xero

Your group operates across five countries, each subsidiary reporting in its local currency. Month-end arrives and your finance team faces the familiar challenge: producing consolidated financial statements foreign subsidiary reporting that prese

Consolidated Financial Reporting System: The Complete Guide for Multi-Entity Businesses

Consolidated Financial Reporting System: The Complete Guide for Multi-Entity Businesses

by Kevin Wiegand

|

Jan 29, 2026

|

Xero

Managing financial data across multiple entities without a consolidated financial reporting system is like navigating with outdated maps. Each subsidiary operates in isolation, month-end becomes a manual marathon, and your balance sheets rarely

Global Financial Consolidation: The Complete 2026 Guide for Multinational Groups

Global Financial Consolidation: The Complete 2026 Guide for Multinational Groups

by Kevin Wiegand

|

Jan 25, 2026

|

Xero

Global financial consolidation gets messy fast when your group spans currencies, time zones, and reporting rules. One close, you’re translating USD, AUD, and SGD into GBP; the next, you’re reconciling intercompany balances that won’t eliminate..

Consolidated Financial Statements Example Questions and Answers: Worked Examples + Journal Entries

Consolidated Financial Statements Example Questions and Answers: Worked Examples + Journal Entries

by Kevin Wiegand

|

Jan 23, 2026

|

Xero

​When your group’s balance sheet won’t reconcile across entities, consolidation quickly becomes a month-end bottleneck. This guide covers the most common consolidated financial statements example questions and answers CFOs and Financial Controll

Consolidated Financial Statements Accounting Standard: IFRS 10 vs FRS 102 vs ASC 810 (UK Focus)

Consolidated Financial Statements Accounting Standard: IFRS 10 vs FRS 102 vs ASC 810 (UK Focus)

by Kevin Wiegand

|

Jan 23, 2026

|

Xero

Your group has 15 entities in Xero. Month-end arrives, and you’re staring at 5-10 business days of exports, spreadsheet formulas, and elimination journals that never quite balance. The problem isn’t your team’s skill – it’s that...

Employment Hero Payroll: The Complete 2026 Guide to Automated Workforce Management

Employment Hero Payroll: The Complete 2026 Guide to Automated Workforce Management

by Kevin Wiegand

|

Jan 23, 2026

|

Employment Hero Payroll

You spend hours each week processing payroll across multiple spreadsheets, manually calculating award rates, and exporting CSVs for reporting. Your finance team needs real-time labour cost visibility, but Employment Hero Payroll’s native reports

Consolidated Financial Statements and Outside Ownership: A Complete Guide to Non-Controlling Interests

Consolidated Financial Statements and Outside Ownership: A Complete Guide to Non-Controlling Interests

by Kevin Wiegand

|

Jan 19, 2026

|

Xero

Consolidated financial statements and outside ownership raise one core question: if you own 80% of a subsidiary, what happens to the other 20%? That remaining stake is outside ownership (non-controlling interest, or NCI). It affects how you pres