Blog
Latest articles, guides and insights from the dataSights team.
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
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
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
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
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
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
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)
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
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
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
Page 5 of 17