DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

Can You Combine Transactions in Xero? A Complete Guide to Consolidation and Reconciliation

Can You Combine Transactions in Xero? A Complete Guide to Consolidation and Reconciliation

by Kevin Wiegand

|

Aug 11, 2025

|

Xero

Managing multiple transactions efficiently is one of the biggest challenges finance teams face during month-end close. Can you combine transactions in Xero to save time and reduce errors? It’s a question many financial controllers ask, and the a

Xero Tax Consolidation: The Complete Guide to Multi-Entity Tax Reporting in 2025

Xero Tax Consolidation: The Complete Guide to Multi-Entity Tax Reporting in 2025

by Kevin Wiegand

|

Aug 11, 2025

|

Xero

Managing tax obligations across multiple Xero entities creates unique challenges for finance teams. You’re dealing with separate financial records, intercompany transactions, and complex compliance requirements – all while racing against tax...

How Does Xero to Xero Work? Understanding the Retired Feature and Modern Alternatives for Multi-Entity Data Transfer

How Does Xero to Xero Work? Understanding the Retired Feature and Modern Alternatives for Multi-Entity Data Transfer

by Kevin Wiegand

|

Aug 11, 2025

|

Xero

Your inter-company invoices are piling up. You’re copying data from one Xero account, switching tabs, and manually entering it into another. Each transaction takes 15 minutes when it should take seconds. If you’re asking how does Xero to Xero wo

Can I Combine Accounts in Xero? The Complete Guide to Account Management and Consolidation

Can I Combine Accounts in Xero? The Complete Guide to Account Management and Consolidation

by Kevin Wiegand

|

Aug 7, 2025

|

Xero

Can I combine accounts in Xero? It’s one of the most common questions finance teams ask when dealing with duplicate expense accounts or multiple entities. You’re facing hours of manual work because Xero lacks native account merging functionality

Can You File Accounts Through Xero? The Complete 2025 Guide to Xero Tax

Can You File Accounts Through Xero? The Complete 2025 Guide to Xero Tax

by Kevin Wiegand

|

Aug 7, 2025

|

Xero

Can you file accounts through Xero? It’s a question thousands of UK businesses are asking as Companies House moves toward mandatory software filing. If you’re wondering whether Xero explore can handle your statutory filings directly, you’re...

Xero API Examples: The Complete 2025 Developer Guide

Xero API Examples: The Complete 2025 Developer Guide

by Kevin Wiegand

|

Jul 31, 2025

|

Xero

Whether you’re building your first Xero integration or looking to automate complex financial workflows, understanding how to work with the Xero API can transform your accounting processes. With over 250 businesses already using automated solutio

Xero to Power Query: The Complete Guide to Connecting Your Financial Data

Xero to Power Query: The Complete Guide to Connecting Your Financial Data

by Kevin Wiegand

|

Jul 25, 2025

|

Xero

You’re exporting Xero data to CSV files every month, manually copying and pasting and fighting with VLOOKUP formulas that break when columns change. Your consolidations take 12 days instead of 2. Sound familiar? Power Query can transform your Xe

Can You Have Multiple Companies in Xero? The Complete Guide to Multi-Entity Management

Can You Have Multiple Companies in Xero? The Complete Guide to Multi-Entity Management

by Kevin Wiegand

|

Jul 24, 2025

|

Xero

Managing multiple companies shouldn’t mean juggling multiple accounting systems. If you’re wondering whether you can have multiple companies in Xero, the answer is yes – but there’s more to the story than a simple login. Setting up...

How to configure Excel Online connector by dataSights

How to configure Excel Online connector by dataSights

by Kevin Wiegand

|

Jan 22, 2024

|

Uncategorised

How to configure Excel Online connector by dataSights Hello, Excel enthusiasts and data wizards! Today, we’re diving into the exciting world of syncing Excel Online into your datalake, by exploring how to seamlessly integrate it into your workflow. T

How to Configure Google Analytics 4 connector by dataSights

How to Configure Google Analytics 4 connector by dataSights

by Kevin Wiegand

|

Jan 22, 2024

|

Uncategorised

A Step-by-Step Guide to Setting Up Google Analytics 4 data sync by dataSights Hello and welcome to our latest tutorial where we delve into the exciting world of data analytics with Google Analytics 4 (GA4). Whether you’re a beginner or an experienced