Define account and audit dimension members post intercompany elimination and intercompany booking entries.
Member names with leading zeroes aren't supported, for example, 0001.
Account
Most intercompany elimination regulations consist of four accounts: a debit account and a credit account, typically general ledger accounts, as well as two system accounts known as Intercompany Offset and Intercompany Automatic Booking.
Intercompany Offset
This system account is used to offset the elimination of the intercompany general ledger accounts. Both sides of an intercompany pairing will be eliminated via the offset account, which means that if the intercompany amounts are completely eliminated, the Offset account should be zero.
For example, when eliminating Intercompany Account Receivable against Intercompany Account Payable, there'll also be a system account called Intercompany AR/AP Offset account. The Intercompany Account Receivable and Intercompany Account Payable are often called an intercompany pair or pairing.
Intercompany Automatic Booking
It's a system account that is used during the Intercompany Matching and Reconciliation process to automatically book certain variances under a certain threshold to an Auto account.
| Intercompany Account | Category |
| Balance Sheet | BS |
| Total assets | Total assets |
| Current assets | Current assets |
| Cash | Cash |
| Receivables | Receivables |
| Intercompany receivable | Intercompany receivable |
| 1190 | Intercompany receivable |
| Income taxes recoverable | Income taxes recoverable |
| Inventories | Inventories |
| Prepaid expenses | Prepaid expenses |
| Future income asset | Future income asset |
| Financial instruments asset | Financial instrument asset |
| Non–Current assets | Non–Current assets |
| Total liabilities and equity | Total liabilities and equity |
| Total liabilities | Total liabilities |
| Current liabilities | Current liabilities |
| Bank loan | Bank loan |
| Payables | Payables |
| Intercompany payable | Intercompany payable |
| 2015 | Intercompany payable |
| 2015_AUTO | Intercompany payable – Automatic booking |
| 2015_OFF | Intercompany payable – Offset |
Audit
A system Audit member needs to be created to store the results of the intercompany elimination calculation. The preferable way to do this is to have one Audit member called Intercompany Eliminations for all accounts, but customers could have a specific Audit member for each intercompany account pairing that needs to be eliminated.
For example, customers can have AR and AP Intercompany Eliminations and another Audit member for Dividends Intercompany Eliminations.
| Members | Hierarchy |
| Statutory Reporting | Statutory Reporting |
| Management Reporting | Management Reporting |
| Local Reporting | Local Reporting |
| Corporate Adjustments | Corporate Adjustments |
| Consolidation Adjustments | Consolidation Adjustments |
| Manual Consolidation JE | Manual Consolidation JE |
| Goodwill and PPA | Goodwill and PPA |
| Total Intercompany | Total Intercompany |
| Invest Elim Manual | Invest Elim Manual |
| Intercos Elim Manual | Intercos Elim Manual |
| Intercompany Eliminations | Intercompany Eliminations |
| Investment Eliminations | Investment Eliminations |
| Total Other Automatic | Total Other Automatic |
| Stock Holder Equity | Stock Holder Equity |
| Equity Method | Equity Method |
| Sold Entity | Sold Entity |
| Exchange Difference | Exchange Difference |
Note: Customers can move the Intercompany Eliminations Audit member to another parent if needed.