Property Groups · Track 1 · Tutorial 2 of 2

Clear intercompany items in a property group

The same items come round every month. This is how to clear each one in BrizoConsol, in the order that closes the month cleanly, with links to the accounting behind them.

You will needThe types set up, as in Set up intercompany types for a property group. The month loaded for every company.
By the endEvery typical intercompany item of a property group cleared for the month, with nothing left in Elimination Review.

1Know the items

Intercompany flows in a property group: Holding company to SPVs: Loans and interest; Management company to SPVs: Management fees on rent collected; SPV to Group company: Rent for space in an SPV’s building; SPVs to Holding company: Dividends; Development company to SPV: A completed building sold at a profit
Each arrow is an item to clear every month.

Each item is cleared under the type set up for it in Set up intercompany types for a property group.

2Clear each item

ItemTypeHow to clear itSee
Loans from the holding company to SPVs, and their interestSPV LoansA rule per SPV on the loan and interest accounts. Reconcile both sides first: accrued interest and repayment dates often differ.Eliminate loans and interest
Management fees on rent collectedManagement ChargesA rule on the fee accounts. Resolve an accrual booked on one side only before the month is posted.Eliminate management charges
Rent between group companiesRental / Lease AdjustmentsA rule for rent against rent; an entry from the lease schedule when the tenant recognises a right-of-use asset.Make rental and lease adjustments
Dividends from SPVsDividendsA GL entry in the month each dividend is recorded.Eliminate intercompany dividends
A building sold by the development company to an SPVFixed AssetsA GL entry taking the development profit out of the building. If the building is in a Non Current Asset account, which Fixed Assets doesn’t accept, use Other Eliminations.Eliminate fixed asset transfers
Unpaid fees and rentTrade Receivables / PayablesA document entry at each month end.Eliminate trade receivables and payables

A rule suits an item that recurs on accounts holding nothing else; see the Automate with rules track. When the accounts also hold outside business, clear the item from its invoices and bills instead.

3Close the month in order

  1. Load every company’s month, so the rules run on the consolidation with both sides in place.
  2. Enter the document entries for unpaid balances at the month end.
  3. Enter the GL entries for one-off items in the month: dividends, asset transfers, new loans.
  4. Clear Intercompany → Elimination Review, as in Work through Elimination Review.
  5. Check each type on Review → Month End Status, as in Check eliminations on Month End Status.

Check

On the group’s Balance Sheet and Profit & Loss with Show Entities on, every intercompany line is zero in the group column, and nothing for the month is waiting in Elimination Review.

4Read more about the accounting

The BrizoConsol blog goes through the accounting behind these items for a property group, with worked examples:

Financial Consolidation for Property Groups: SPVs, Intercompany Loans, and Investment Property
How to Consolidate a Multi-SPV Property Group When Each Vehicle Has Its Own Intercompany Loan From the Holding Company
The Disposal Gain That Doesn’t Exist: Eliminating Intragroup Development Profits When Your DevCo Sells to Your PropCo
The Same Building, Counted Twice: Eliminating Ghost Assets From Intragroup Leases in Property Groups

5If something goes wrong

An item is still in the group figuresIts accounts aren’t in a rule or entry, or one company booked it in another month. Check both companies’ books for the month.
The same rule waits in Elimination Review every monthIts method or tolerance doesn’t suit the usual difference. See Explain and clear intercompany differences.
A rule also eliminates outside businessThe account isn’t only intercompany. Delete the rule and clear the item from its invoices and bills.

Want more detail? See the documentation