Home
Product
How It Works Security AI in BrizoConsol
Features
Analysis & Reporting Cell-Based Financial Reporting Insight Packages Common Chart of Accounts CTA / FCTR NCI Intercompany Eliminations Step Acquisitions / Partial Disposals Multi-Accounting Standards Month-End Status All Features
Integrations
Xero QuickBooks MYOB Zoho Books Excel Import Other Accounting Software
Solutions
For Accountants CFOs / Finance Leaders Business Owners Consolidated Profit and Loss Consolidated Balance Sheet Consolidated Cash Flow Multi-Entity Consolidation Multi-Currency Consolidation Group Reporting Management Reporting Board Reporting Pricing See It in Action
Resources
Documentation Tutorials Month-End Guide Webinar Blog
Login Start Free Trial

Xero Consolidation
Automated
Every Period

Connect multiple Xero organisations, automate eliminations and currency translation, and produce consolidated financial statements across your entire group.

  • Secure OAuth — reads only
  • No credit card required
  • Setup in under five minutes

Xero Is Great for Your Entities. But What About Your Group?

Xero works great for each entity individually. The problem starts when you need to see your whole group.

Xero reports one entity at a time

Standard Xero reporting is organised by individual organisation. Producing group financial statements across separate Xero organisations requires an additional consolidation workflow.

Mixed software across the group

Mixed software means no single source of truth. There's nowhere for the full group picture to come together.

Month-end becomes a manual project

Month-end means exporting, pasting, and manual eliminations. One wrong formula breaks everything.

Why Xero Users Choose BrizoConsol

Your Xero Data. Properly Consolidated. Every Period.

Connects via OAuth, syncs nightly, and consolidates all entities automatically. Real group financials — not just dashboards.

Works alongside any other accounting system your group uses
Intercompany eliminations applied automatically every period
Supports IFRS, US GAAP, UK GAAP, SFRS, AASB and Local GAAP
Reduces spreadsheet dependency and manual reconciliation.
Tracking Category SetupHoldCo SG · Xero
Tracking categorySuggested MappingConfirm Mapping
DepartmentSales · Operations · AdminDepartmentDepartment✓
RegionSingapore · MalaysiaRegional DivisionRegional Division✓
Save Tracking Category Setup
Department P&LDashboard · Oct 2026 YTD
Total Department RevenueSGD 4.2M
Total Department ExpensesSGD 3.3M
Total Department Net ProfitSGD 886K
Number of Departments3

Revenue by Department

Sales1.8M
Operations1.4M
Admin1.0M

Analyse Your Business Segments Across the Whole Group

If you use Xero tracking categories to tag transactions by department, region, project, or cost centre, BrizoConsol reads Xero's P&L for each category and puts it to work in dashboards and reports — so you can see performance by segment, not just by entity.

  • P&L by Tracking Category read straight from Xero, alongside your main financials (Pro and Premium)
  • Map a category to Department or Store and the Department P&L or Store Performance dashboard is ready to add
  • Each category is imported as operational data, by tracking option and P&L line, for the Operational Report and cell reports

Every Entity's Tracking Categories in One Report

Tracking categories come in as operational data. Under All Reports, the Operational Report reads the same category from every Xero entity as one consolidated report, in the group's currency, and lets you shape it like a pivot.

  • Opened on the group, every entity's tracking category data is read as one report, with Entity as a field (Pro and Premium)
  • Each entity's figures are translated at that month's average rate before any total; a month with no rate is named on the report
  • Put Tracking Option, P&L Line, Entity or Period on rows or columns, by month, quarter or year
  • Totals are never built down P&L lines, so Gross Profit is not added on top of Sales
  • Click any figure to see the rows behind it, export to PDF or Excel, or add the report to an Insight Package
HoldCo SGXero Tracking: Department · SGD
OpCo HKXero Tracking: Department · HKD
UK SubCoXero Tracking: Department · GBP
Xero Tracking: DepartmentHoldCo SG · 3 entities · 2026-01 to 2026-10
Operational Report
SelectionMeasureSum of ValueLevelMonthTotal column on
FieldsPeriodP&L Line · SalesScenario
LayoutRowsTracking OptionColumnsEntity
Tracking OptionHoldCo SGSGDOpCo HKHKD → SGDUK SubCoGBP → SGDTotalSGD
Sales812,400341,700455,8001,609,900
Operations604,200296,500287,6001,188,300
Admin238,900118,30096,400453,600
Total1,655,500756,500839,8003,251,800

From consolidated total to source transaction

Click any account balance in your consolidated Balance Sheet or P&L. BrizoConsol traces it back to the Xero invoices, bills and credit notes that posted to it, plus the ledger postings no document explains — opening balance, every movement, and closing balance.

Consolidated Profit and LossOct 2026 · Actual
Sales204,000
Cost of Sales(118,600)
Operating Expenses(52,300)
Net Profit33,100
All Reports / Consolidated Profit and LossSales
OrganisationAccountData TypeDateCurrencyIn LocalExchange RateAmount
▸HoldCo SG4000 - SalesXeroOct 2026SGD124,0001.0000124,000

5 source rows · trial balance as at 31 Oct 2026, imported 01 Nov 2026

DateSourceDocumentPartBasisTaxAmount
03/10/2026InvoiceINV-0412Consulting services—4,680.0052,000.00
09/10/2026InvoiceINV-0418Software licences—3,735.0041,500.00
14/10/2026Credit noteCN-0031Consulting services—216.00(2,400.00)
21/10/2026InvoiceINV-0425Support plan—3,033.0033,700.00
31/10/2026journal lineJournal 42Sales——(800.00)
Total of all 5 rows124,000.00
▸OpCo AU4000 - SalesXeroOct 2026AUD104,0000.875091,000
Demo Group4000 - SalesEliminationOct 2026SGD(11,000)1.0000(11,000)
Total204,000
🔍
Click any account
Balance Sheet, P&L or Cash Flow — every cell is a starting point.
📄
See the documents behind it
Invoices, bills and credit notes that posted to the account, each with its number, party, date and amount.
📒
See ledger postings too
Bank charges, currency gains and manual journals — the movements no document explains.
🏷️
Analyse by tracking category
If Xero tracking categories are set up, BrizoConsol reads P&L by category — revenue, expenses and net profit per segment.

Drill-through is available on Pro and Premium and explains each entity's local Actual figures. Ledger postings also need Xero's journals permission, which is approved separately from the standard connection.

Connect Xero. Get Your Whole Group Consolidated.

Connecting Xero is just the start. Here's what you actually get.

Consolidated P&L, Balance Sheet & Cash Flow

Proper consolidated statements across all entities, with automatic intercompany eliminations and multi-currency handling.

Audit Trail and Drill-Down

Trace consolidated balances through adjustments, currency translation and elimination entries, and open source invoices and bills directly in Xero. Journal-level detail on Pro and Premium.

Nightly Sync, Reduced Manual Handling

Data refreshes nightly, keeping dashboards and reports up to date without manual uploads or spreadsheet maintenance.

How to Connect Xero

1

Click Connect to Xero

Go to Organisation Settings → Organisation Details and click Connect to Xero.

2

Authorise via Xero's secure OAuth screen

Approve the connection on Xero's secure OAuth screen. BrizoConsol only reads your data, and your Xero password is never shared with or stored by BrizoConsol. On Pro and Premium you can also approve Xero's journals permission, which lets drill-through show ledger postings.

3

Data syncs automatically from that point

The first load starts immediately and brings in up to 24 months of history, then data refreshes nightly — no ongoing manual work required.

Watch how to connect Xero entities and get your group consolidated

What's Pulled from Xero

Data pulled from Xero into BrizoConsol
Data Type What You Get
Organisation Details Name, base currency, country and financial year start
Chart of Accounts Full account list with codes, names and account types
Trial Balance Monthly account balances, from which movements are calculated
Invoices and Bills Customer invoices and supplier bills with their balances
Payments and Credit Notes Payments, prepayments, overpayments and credit notes applied to invoices and bills (Pro and Premium)
Journals Ledger journal postings (Pro and Premium, with an additional Xero permission)
Profit and Loss by Tracking Category Segmented P&L by your Xero tracking categories (Pro and Premium)

Xero Consolidation — Frequently Asked Questions

Can Xero consolidate multiple organisations?

Standard Xero reporting is organised by individual organisation. Producing group financial statements across separate Xero organisations requires an additional consolidation workflow. BrizoConsol connects to each Xero organisation via OAuth and consolidates them automatically.

Can BrizoConsol connect to multiple Xero organisations?

Yes. You can connect multiple Xero organisations. Each one connects individually via its own OAuth authorisation.

Does BrizoConsol support Xero tracking categories?

Yes, on Pro and Premium. BrizoConsol pulls tracking category data alongside your main financials, so you can view P&L by department, region, project, or cost centre across the consolidated group — using whatever tracking structure you've set up in Xero.

Can I mix Xero with QuickBooks, MYOB, or Zoho Books?

Yes. BrizoConsol consolidates across Xero, QuickBooks, MYOB, and Zoho Books in the same group. Each entity connects via its own OAuth — there's no requirement for all entities to be on the same platform.

How often does Xero data sync to BrizoConsol?

Nightly automatic sync. The first load begins immediately after connecting and brings in up to 24 months of history. Your data then refreshes every night without any manual action.

Does BrizoConsol write any data back to Xero?

No. BrizoConsol only reads from Xero. It never writes back to, modifies, or creates any records in your Xero organisations.

Related Pages

Xero Consolidation Guide Group Consolidation Overview Connect MYOB Connect QuickBooks Connect Zoho Books Pricing Security

Connect Xero and See Your Full Group Picture.

Start your free trial and get your first consolidated group report today.

Start Free TrialSee It in Action
No credit card required · No onboarding call · Cancel anytime

Xero is a trademark of Xero Limited. Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission. MYOB is a trademark of MYOB Technology Pty Ltd. Zoho and Zoho Books are trademarks of Zoho Corporation Pvt. Ltd.