UK groups on MYOB consolidating in Excel face version errors, manual GBP/EUR/USD currency lookups, and no audit trail for Companies House filing. BrizoConsol eliminates all of it — FRS 102-compliant, automated, same-day.
Excel is a powerful tool. But it was not designed for recurring group consolidation across multiple MYOB companies, and the gap shows in predictable ways.
A hardcoded value in the wrong cell, a SUM range that doesn't include a new row, a VLOOKUP that returns zero instead of throwing an error — Excel errors propagate silently through the consolidated statements and are often not caught until an auditor or CFO spots an anomaly.
When more than one person works on the consolidation — or when it's emailed between team members — version conflicts become inevitable. Consolidation_FINAL.xlsx, Consolidation_FINAL_v2.xlsx, Consolidation_FINAL_APPROVED.xlsx — the board may have received an earlier version.
Identifying all intercompany transactions across four or more MYOB companies requires manually cross-referencing every entity's transactions each period. A new intercompany arrangement — a management fee, a loan advance — is easily missed until it shows up in an audit query.
Every group consolidation involves judgement calls — FX rates chosen, elimination amounts adjusted, manual journal entries applied. In Excel, none of these leave a traceable record unless someone manually documents them. Auditors are increasingly unwilling to rely on Excel workpapers without extensive accompanying documentation.
IFRS (IAS 21) and US GAAP (ASC 830) require closing rates for balance sheet items and average rates for P&L items. In Excel, applying this correctly across multiple currencies and multiple periods requires formulas that are easy to misconfigure and hard to audit — particularly when exchange rate tables are maintained manually.
The hidden cost of Excel consolidation is time. The full cycle of export, remap, translate, eliminate, and assemble takes 3–5 working days per month for a typical MYOB group with 3–6 entities. That time is spent by senior finance staff who should be analysing the numbers, not assembling them.
A direct comparison across every dimension that matters for MYOB group consolidation.
| Capability | Excel | BrizoConsol |
|---|---|---|
| Direct connection to MYOB (no export needed) | Manual export | OAuth API |
| Automatic data refresh from MYOB | Manual each period | Nightly sync |
| AI-assisted account mapping | Manual VLOOKUP tables | AI Auto-Map |
| Automatic intercompany detection | Manual cross-reference | Auto-detected |
| Automatic intercompany elimination | ⚠ Manual journal entries | Automated |
| Mismatch alerts for unreconciled intercompany | Not available | Pre-close alerts |
| Multi-currency translation (closing + average rates) | ⚠ Manual formulas — error-prone | Auto per IFRS/GAAP |
| Currency translation adjustment (CTA/FCTR) | ⚠ Manual calculation | Auto-calculated |
| Non-controlling interest (NCI) | ⚠ Manual calculation | Auto per ownership % |
| Audit trail on all adjustments | No native trail | Full, permanent trail |
| Multi-user access with role controls | ⚠ File sharing only | Role-based access |
| Version control | File naming conventions | System-managed versions |
| Consolidated P&L, Balance Sheet, Cash Flow | Manual assembly | Auto-produced |
| Entity variance analysis vs prior period | ⚠ Manual pivot tables | Built-in dashboards |
| Support for non-MYOB entities (Xero, QBO, MYOB) | Manual — separate exports | Native integrations |
| Virtual Groups for management reporting | Separate spreadsheets | Built-in |
| IFRS / US GAAP / UK GAAP tagged output | Not available | Per-entry standard tags |
| Time to first consolidated report per period | 3–5 days | Same day |
The direct cost of Excel is zero. The true cost — in finance team time, error correction, and extended audits — is substantially higher. Here is a realistic annual cost comparison for a 4-entity MYOB group.
Switching doesn't require a migration project. BrizoConsol reads from MYOB directly — there's no data to move. Most groups have their first BrizoConsol-produced consolidation within the same day they connect.
Authorise each MYOB company via OAuth. BrizoConsol initiates an immediate data sync — all GL history available from the first connection.
~5 min per entityAI Auto-Map reads your chart of accounts and suggests mappings. Review the suggestions and adjust where needed — your Excel mapping table is a good reference here.
~20–30 min totalRun BrizoConsol's first consolidation and compare the output to your existing Excel model for the same period. Most teams spend 1–2 hours on this validation step before going live.
~1–2 hrsOnce validated, BrizoConsol becomes your source of truth for group consolidation. Your Excel model can be kept as a historical archive — you just don't need to update it every month anymore.
Same dayUK groups with Australian or New Zealand subsidiaries using MYOB AccountRight or MYOB Business need a consolidation layer that spans GBP, AUD, and NZD. BrizoConsol consolidates MYOB entities alongside any other platform your UK and international entities use — all currencies translated under FRS 102 Section 30 automatically.
UK-headquartered groups with Australian subsidiaries on MYOB AccountRight or MYOB Business consolidate GBP and AUD in BrizoConsol. FRS 102 Section 30 AUD→GBP translation is applied automatically — closing rates for Balance Sheet, average rates for P&L — with full intercompany elimination each period.
Groups spanning the UK, Australia, and New Zealand consolidate three currencies across three time zones. BrizoConsol handles GBP, AUD, and NZD under FRS 102 Section 30, producing a single consolidated view in GBP automatically each period.
BrizoConsol supports both MYOB AccountRight and MYOB Business — UK groups can consolidate Australian entities across both MYOB product lines in a single view. Whether your Australian subsidiaries use AccountRight or MYOB Business, BrizoConsol connects to both.
UK groups with MYOB in Australian entities and Xero or QuickBooks in UK or US entities can consolidate all platforms simultaneously. BrizoConsol connects to each platform independently — the group consolidation runs across all accounting systems in one view.
UK groups preparing consolidated financial statements must comply with FRS 102 Section 9 Consolidated and Separate Financial Statements under the Companies Act 2006. Listed companies on AIM or the LSE follow IFRS 10. BrizoConsol automates FRS 102-compliant consolidation for MYOB groups across the UK — including intercompany eliminations, GBP-based currency translation under FRS 102 Section 30, and NCI attribution.
FRS 102 Section 9 requires a UK parent entity to consolidate all subsidiaries it controls under the Companies Act 2006. BrizoConsol applies FRS 102 Section 9-compliant consolidation logic — including full intercompany elimination and NCI — across all connected MYOB entities automatically each period your companies close.
UK groups with foreign subsidiaries — in the EU (EUR), Australia (AUD), the US (USD), or Asia — apply FRS 102 Section 30 for currency translation. BrizoConsol translates each foreign entity at closing rates (Balance Sheet) and average rates (P&L), calculates the translation reserve, and includes it in equity — automatically each period.
UK parent companies must file consolidated financial statements with Companies House under the Companies Act 2006. The Financial Reporting Council (FRC) sets UK accounting standards. BrizoConsol produces audit-ready consolidated statements with a full elimination audit trail, ready for your auditors and Companies House submission.
UK-headquartered groups typically span entities in the EU (EUR), Australia (AUD), the US (USD), Asia, and the Middle East — each requiring GBP translation under FRS 102 Section 30. Many use MYOB in their UK holding entity alongside other platforms regionally. BrizoConsol consolidates GBP, EUR, USD, AUD, AED, and other currencies in a single run automatically.