Home
Product
How It Works Security AI in BrizoConsol Built on BRIZO
Features
CTA / FCTR NCI Intercompany Eliminations Step Acquisitions / Partial Disposals Multi-Accounting Standards All Features
Integrations
Xero QuickBooks MYOB Zoho Books Excel Import Other Accounting Software
Solutions
For Accountants CFOs / Finance Leaders Business Owners Multi-Entity Consolidation Group Reporting Multi-Currency Consolidation Board Reporting Management Reporting Pricing See It in Action
Resources
Documentation Tutorials Month-End Guide BRIZO Methodology Webinar Blog
Login Start Free Trial
Month-End Guide

What used to take 3–5 days
now takes a few hours.

Here is what actually happens at month-end consolidation — and what it looks like when BrizoConsol runs it.

❌ Before BrizoConsol

  • Export CSVs from every entity
  • Paste into the master workbook — pray nothing shifts
  • VLOOKUPs across 6 worksheets linking to 4 other workbooks
  • Apply exchange rates manually — wrong column, wrong rate
  • Rebuild IC eliminations from last month's template
  • Chase each entity to confirm IC balances agree
  • Recalculate NCI by hand every period
  • Post PPA amortisation journals — if the schedule is remembered
  • Balance sheet doesn't balance. Start hunting.

3–5 days. Every month. Same pain.

✓ After BrizoConsol

  • Data already pulled from Xero, QuickBooks, MYOB, Zoho Books
  • IAS 21 exchange rates applied automatically
  • CTA calculated and posted to equity
  • IC eliminations run — exceptions flagged for review
  • NCI updated based on period results
  • Standing journals posted automatically
  • Post any manual journals, review, sign off
  • Consolidated P&L, BS, and Cash Flow ready to share

Month-end closed in hours, not days.

The Process

What happens at month-end consolidation

Eight steps, every period. BrizoConsol automates the ones that used to take days.

1

Data cutoff & trial balance pull

  • Enforce posting cutoff across all entities
  • Pull closed trial balances from every system
  • Late postings are the #1 source of IC mismatches
✓ BrizoConsol: auto-pull overnight
2

Currency translation (IAS 21)

  • Balance sheet items at closing rate
  • P&L items at average rate for the period
  • CTA difference posted to equity (FCTR reserve)
✓ BrizoConsol: applied automatically
3

Intercompany reconciliation

  • IC receivables must match IC payables before eliminations
  • Mismatches: timing differences, FX lag, missed postings
  • Every unresolved pair leaves a residual on the BS
✓ BrizoConsol: IC pairs flagged for review
4

Intercompany eliminations

  • IC sales / purchases: remove intra-group revenue and cost
  • IC loans and receivables: eliminate debtor and creditor
  • IC dividends: eliminate income against retained earnings
✓ BrizoConsol: auto eliminations with exceptions
5

Manual consolidation journals

  • PPA / fair value amortisation (standing journal each period)
  • Goodwill impairment review and adjustment if required
  • Accounting policy harmonisation entries
✓ BrizoConsol: standing journals auto-post
6

Non-controlling interest (NCI)

  • NCI share of profit presented in consolidated P&L
  • NCI share of net assets presented in equity on BS
  • Recalculated every period based on ownership %
✓ BrizoConsol: NCI calculated automatically
7

Consolidated statements

  • P&L: all entities minus IC eliminations, NCI split
  • Balance Sheet: all entities plus goodwill, CTA, NCI equity
  • Cash Flow: indirect method from consolidated profit
✓ BrizoConsol: generated automatically
8

Review & period lock

  • Review variances vs prior period — explain material movements
  • Confirm CTA reconciles to period FX movement
  • Lock period — prevent retrospective changes
✓ BrizoConsol: period lock with audit trail
Day by Day

After BrizoConsol

Day 1
AM

Data is already there

  • BrizoConsol pulled from all connected systems overnight
  • IAS 21 exchange rates applied, CTA posted to equity
  • Check the dashboard for flagged IC variances or new transactions
  • Confirm exchange rates — override if needed
Day 1
PM

Eliminations run. Journals posted.

  • IC eliminations run automatically — review any flagged exceptions
  • Resolve any unmatched IC pairs with the relevant entity
  • Post manual journals: FV adjustments, management entries
  • NCI updates based on period results — confirm % is correct
  • Review Pulse health scores across entities
Day 2
AM

Review, sign off, done.

  • Consolidated P&L, Balance Sheet, and Cash Flow ready
  • Review material variances vs prior period — note explanations
  • Confirm CTA movement reconciles to period FX rates
  • Lock the period. Export or share directly from BrizoConsol.
Common Errors

What breaks month-end consolidation

These are the errors that waste the most time — and the ones BrizoConsol is designed to prevent.

⚠ Eliminations on unreconciled IC balances

Running eliminations before IC pairs agree leaves a residual on the consolidated BS. The balance sheet fails to balance and the cause has to be traced back manually.

⚠ Wrong rate applied to equity items

Equity items must use historical rates, not the closing rate. Applying the closing rate distorts the CTA reserve and the error compounds every period it goes uncorrected.

⚠ Missing PPA amortisation journal

Fair value adjustment amortisation is a manual standing journal — it doesn't come from any entity's books. Miss it and EBITDA and net assets are both overstated by the same amount.

⚠ Stale NCI percentage

If ownership changed during the period and the NCI % wasn't updated, both the NCI equity balance and the NCI share of profit are wrong for every period since the change.

⚠ No period lock

Without a period lock, a subsidiary can post to a closed period after consolidation runs. The next run picks it up as a current-period entry and distorts the comparatives.

How BrizoConsol helps
  • IC mismatches flagged before eliminations run
  • IAS 21 rate logic enforced automatically
  • Standing journals post every period without manual input
  • NCI recalculated from the ownership % you set
  • Period lock with full audit trail
Checklist

Month-End Consolidation Checklist

Day 1 — Data & Currency

Posting cutoff enforced across all entities
Trial balances pulled from all systems
Closing exchange rates set
Average exchange rates confirmed
IAS 21 translation applied to all foreign subsidiaries
CTA movement reconciled to period FX rates

Day 1 — Intercompany

All IC pairs identified
IC mismatches resolved or noted as in-transit
IC sales/purchases elimination posted
IC receivables/payables elimination posted
IC loan elimination posted
IC dividend elimination posted

Day 1 — Journals & NCI

PPA / FV amortisation journal posted
Goodwill impairment review completed
Policy harmonisation adjustments posted
Other standing manual journals posted
NCI % confirmed — updated if ownership changed
NCI share of profit and net assets calculated

Day 2 — Review & Lock

Consolidated P&L reviewed — variances explained
Consolidated BS reviewed — no unresolved residuals
Cash Flow reconciles to opening and closing cash
CTA reserve movement reconciled
Equity movement schedule complete
Period locked in BrizoConsol
Output exported or shared with board
Automated Every Month

What BrizoConsol handles vs what you control

What BrizoConsol handles
  • Data pull from all connected entities
  • IAS 21 currency translation — closing, average, historical rates
  • CTA calculation and posting to equity
  • Intercompany elimination detection and application
  • NCI attribution and equity movement
  • Standing journals (PPA amortisation, recurring adjustments)
  • Consolidated P&L, Balance Sheet, and Cash Flow generation
  • Audit trail on every consolidation adjustment
Still in Your Hands
  • Exchange rate review and override
  • IC exception investigation and resolution
  • Manual journal entries and adjustments
  • NCI percentage update if ownership changes
  • Variance review and commentary
  • Final sign-off before distribution
  • Period lock


Your next month-end starts here

Set up BrizoConsol once. Run month-end in hours from then on.

Start Free Trial Watch a Demo
No credit card required