The Challenge
A hospitality group operating 12 locations across 3 countries was struggling with financial consolidation.
Each location maintained its own Xero company file, and the finance team spent days each month manually exporting
data from each location, converting currencies, and stitching together consolidated reports in Excel.
The process was error-prone, time-consuming, and provided limited visibility into group-level performance.
"We have 12 locations - hotels, restaurants, and event venues - each with their own Xero company file.
Every month, our finance team would spend 3-4 days manually pulling data from each location, converting
currencies, and trying to create consolidated reports. We had no real-time visibility into how the group
was performing as a whole. We needed a way to see true group-level performance without this manual nightmare."
The Solution
We implemented CountingKit to create an automated consolidation system:
-
Multi-Entity Integration: Connected all 12 Xero company files to CountingKit, creating a unified data pipeline.
-
Consolidated Google Sheets: Built a master Google Sheet that automatically aggregates data from all locations.
-
Multi-Currency Handling: Configured automatic currency conversion for locations in different countries.
-
Automated Daily Updates: Set up scheduled exports so consolidated reports stay current without manual intervention.
-
Location-Level Detail: Maintained ability to drill down into individual location performance while viewing consolidated totals.
The Results
By implementing CountingKit, the hospitality group achieved significant improvements:
- Time Savings: Eliminated 3-4 days of monthly manual consolidation work
- Real-Time Visibility: Group-level performance visible anytime without waiting for month-end
- Accuracy Improvement: Automated consolidation eliminated manual errors from currency conversion and data entry
- Better Decision Making: Real-time consolidated data enabled faster strategic decisions
- Cross-Location Benchmarking: Easy comparison of performance across different locations and countries
- Scalable Growth: System easily accommodates new locations without additional setup complexity
Key Features
The solution provides comprehensive multi-entity management:
- Multi-Entity Aggregation: Automatic consolidation of data from multiple Xero company files
- Currency Conversion: Automatic handling of multi-currency transactions
- Location-Level Detail: Ability to view both consolidated and individual location performance
- Automated Updates: Scheduled daily refreshes ensure data is always current
- Flexible Analysis: Raw data in Google Sheets enables custom formulas and cross-entity analysis
Consolidation Insights
The consolidated dashboard revealed valuable insights about their multi-entity operations:
- Top Performers: Clear identification of which locations drive the most revenue and profit
- Geographic Trends: Understanding of performance differences across countries and regions
- Seasonal Patterns: Consolidated view of seasonal trends across all locations
- Resource Allocation: Data-driven decisions about where to invest in growth
- Group-Level Metrics: True consolidated P&L, balance sheet, and cash flow visibility
Why It Works
Multi-entity businesses face unique challenges in financial consolidation. CountingKit solves this by providing
automated data aggregation from multiple accounting systems into a single Google Sheets reporting layer.
Instead of spending days on manual spreadsheet stitching, this hospitality group now has real-time visibility
into true group-level performance with automatic currency conversion and error-free consolidation.
