DataSights Logo

Blog

Latest articles, guides and insights from the dataSights team.

ero-inventory-management-cin7-core-datasights-flow

Xero Inventory Management: How to Connect Cin7 Core and Automate Reporting

by Kevin Wiegand

|

May 11, 2026

|

Cin7 Core

In our work with Cin7 Core customers consolidating Xero across multi-entity groups, the conversation almost always lands on the same friction point. Xero inventory management works for a single shop selling under 4,000 tracked or finished inventory items at...

financial-consolidation-software-multi-entity-finance-teams

Financial Consolidation Software: A Practical Guide for Multi-Entity Finance Teams

by Kevin Wiegand

|

May 11, 2026

|

Xero

In our work with mid-market finance teams running Xero across multi-entity groups, we keep seeing the same starting point: a Financial Controller who knows their entities individually balance, a CFO who needs a group P&L by Tuesday, and a workbook called...

joint-venture-consolidated-financial-statements-guide

Joint Venture Consolidated Financial Statements: A Practical Guide

by Kevin Wiegand

|

May 11, 2026

|

Xero

Your group owns 40% of an entity. You share control with two other partners. This catches finance teams out at month end. Joint venture consolidated financial statements do not follow the rules used for subsidiaries, and the equity method takes over instead. That...

data-consolidation-types-methods-automation

Data Consolidation: Types, Methods, and Automation Strategies

by Kevin Wiegand

|

May 11, 2026

|

Xero

You probably know the moment well. Month-end is approaching. Sales data sits in the CRM, transactions live across multiple Xero entities, and inventory updates are scattered across three different spreadsheets. Data consolidation is the process that pulls all of...

financial-dashboard-power-bi-example

Power BI Financial Dashboard: Examples, Templates, and Best Practices for Finance Teams

by Kevin Wiegand

|

Apr 24, 2026

|

Xero

Your finance team closes each month, wrestling with CSV exports, broken formulas, and reports that are already stale by the time directors read them. A well-built Power BI financial dashboard changes the rhythm of the month, replacing reconciliation marathons...

consolidation-accounting-multi-entity-guide

Consolidation Accounting: Methods, Examples and Journal Entries for Multi-Entity Groups

by Kevin Wiegand

|

Apr 23, 2026

|

Xero

Your subsidiaries’ numbers refuse to reconcile. Intercompany transactions create a maze of elimination entries, and month-end stretches past day 15. If you are managing consolidation accounting across multiple entities, you...

xero-connected-apps-2026-finance-teams

Xero Connected Apps: The Best Integrations for Finance Teams in 2026

by Kevin Wiegand

|

Apr 23, 2026

|

Xero

You are managing multiple Xero entities, drowning in manual data exports, and watching your month-end close stretch beyond 15 days in many multi-entity groups. Sound familiar? While Xero core accounting features handle individual organisations well, most finance...

steps-preparation-consolidated-financial-statements-guide-1

Steps in Preparation of Consolidated Financial Statements: Your Complete 2026 Guide

by Kevin Wiegand

|

Apr 18, 2026

|

Xero

You are staring at spreadsheets from eight different Xero entities, trying to eliminate intercompany transactions while the board pack is due in three days. Your balance sheet will not balance. Eliminations do not reconcile. Month-end has stretched into a second...

accounting-automation-software-datasights-xero-reporting

Accounting Automation Software: What It Is and How to Choose in 2026

by Kevin Wiegand

|

Apr 15, 2026

|

Xero

If your finance team still spends days each month copying data between spreadsheets, reconciling entities by hand, and chasing numbers that never quite balance, you are not alone. Most multi-entity businesses running Xero hit a...

financial-consolidation-complete-guide

Financial Consolidation: How to Automate Multi-Entity Reporting

by Kevin Wiegand

|

Apr 15, 2026

|

Xero

Your subsidiaries report different numbers. Your balance sheets do not reconcile across entities. Month-end close stretches past two weeks while the board waits for consolidated reports. Financial consolidation is the process that fixes this – combining...

Page 1 of 16