What this article covers: How to manage intercompany elimination entries in BrizoConsol — choosing the elimination type, adding entries manually, importing from a file, and reviewing posted eliminations. For rules that run automatically each period, see Auto Eliminations.
Intercompany elimination entries remove balances that arise from transactions between entities in your group — loans, management charges, dividends, intercompany receivables and payables, and similar. Each entry is posted to a specific scenario and period and can be entered manually or imported in bulk from a file.
1. Accessing Elimination Entries
Open the Intercompany menu in the left navigation and choose the elimination type — for example Intercompany Loans. Each type has its own page, titled with its name. The page is available to users with Administrator or Journals & Eliminations Admin access.
An entry belongs to the group selected when it is entered. It is in that group’s reports and those of every group above it, and not in a sub-group below or beside it — so in a group with sub-groups, enter it on the lowest group that has both companies in it. See Eliminate at the right level.
2. Choosing Scenario, Type, and Period
Control
Description
Scenario
Choose Actual, Forecast, or Budget. Entries are scenario-specific.
Elimination type
Chosen from the Intercompany menu — each type lists only its own entries. See Section 3 for the full type list.
Period
Select a month from the dropdown, or use the Previous period and Next period arrows to step one month at a time. Switch By month to By year to list a whole fiscal year, or to Custom to choose a from and to month.
3. Elimination Types
Each intercompany transaction category has its own entry view. Choose one from the Intercompany menu to switch between them:
Type
Use for
Trade receivables / payables
Intercompany receivable and payable balances between two group entities.
Sales / Purchases / Services
Internal goods and service revenue against the matching purchases, direct costs or expenses.
Inventory Transfers
Intercompany sales and purchases for inventory still held inside the group.
Unrealised Profit
Profit still in inventory that has not yet been sold outside the group.
Intercompany Loans
Loan, accrued interest, and related funding balances between group entities.
Management Charges
Management fees and shared service charges billed between entities.
Dividends
Dividend income recorded by the parent against the distribution in the subsidiary.
Fixed Assets
Gains, losses, or carrying amounts arising from fixed asset transfers between entities.
Rental / Lease Adjustments
Manual consolidation adjustments for internal rentals and leases, based on the lease schedules.
Other Income / Expenses
Other intercompany income and expense not covered by the standard categories.
Other Eliminations
Any intercompany balance that does not fit the categories above.
4. Adding an Entry Manually
Click + Add entry (Add Elimination Entry when the period has no entries yet) to open the entry form. Complete the following fields:
Field
Description
Elimination ID
A unique reference for this entry. Must not duplicate an existing ID for the selected period.
Date
The posting date. Defaults to the last day of the selected period.
Description
A free-text note describing the elimination.
Debit lines
One or more debit lines — each with an entity, account, currency, and amount.
Credit lines
One or more credit lines — each with an entity, account, currency, and amount.
💡 Tip: Any difference between the debit and credit base totals can be allocated using FX, timing, or write-off treatments on the entry. This avoids needing the two sides to match exactly when exchange rates differ.
For Trade receivables / payables, Sales / Purchases / Services, Inventory Transfers and Management Charges, the form offers two ways to build the entry: GL entry, where you enter the lines yourself, and Documents, where the lines come from the invoices and counterpart bills you select. Documents is available for the Actual scenario only.
Automatic reversal
Two kinds of entry state what is outstanding at a date rather than the month’s movement: a Trade receivables / payables entry built from Documents, and every Unrealised Profit entry. For each one, BrizoConsol posts a mirror entry dated the 1st of the next month, with the Elimination ID REV- followed by the entry’s ID, and marks it Auto reversal. October’s position clears on 1 November, and November’s own entry states November’s position. A trade entry made as a GL entry is not reversed.
The reversal follows its entry: editing the entry rewrites it, and deleting the entry removes it. It can’t be edited or deleted on its own. An entry whose reversal would land in a locked month can’t be saved, changed or deleted, with the message Period … is locked. Contact administrator.
5. Importing from a File
Click the ⋯ (More actions) button and choose Import entries from a file (Import from file when the period has no entries yet) to open the import panel. You can drag a file onto the drop zone or click to browse.
Detail
Notes
File formats
Standard plan: CSV only. Other editions: CSV, XLSX, or TXT.
Row structure
One row = one elimination line. Rows that share the same Elimination ID form a single entry.
Validation
All-or-nothing — the entire file is rejected if any entry has a problem. All errors are shown at once so you can fix the file in one step.
Template
Click Download the import template in the import panel to get a file with the correct column headings pre-filled.
🛈 One row is one elimination line. Rows sharing an Elimination ID make up one entry, and the whole file is rejected unless every entry is valid. Download the template for the correct column headings.
6. The Eliminations Table
Above the table, a summary counts the period’s entries (auto and manual), those with a difference, and any entries waiting for approval, with a link to Elimination Review →. Entries for the period are grouped under Auto — posted by elimination rules and rebuilt on every consolidation, so change the rule, not the entry — and Manual — entered or imported, and editable while the period is open.
Column
Description
Date
The posting date of the entry.
Description
The description entered on the entry. An auto entry also names its rule, with an edit rule link.
Between
The entities involved in the elimination.
Amount
The total amount in the group reporting currency.
Difference
The residual difference between debit and credit base totals, if any.
Status
Balanced when debit equals credit; otherwise the difference treatment applied — FX gain/loss, Timing difference, or Write off.
Last update
When the entry was last modified.
Actions
Edit or delete a manual entry, and show its lines. Entries in locked periods cannot be edited or deleted. An Auto reversal has no edit or delete: change the entry it reverses.
Click a row to see its lines and any difference treatments. Use the All entities and All statuses lists to narrow the list, or type in the Search… box to find a specific entry.