Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Example: Use Attributes to Enter Intercompany Eliminations

Example: Use Attributes to Enter Intercompany Eliminations

This example illustrates how to enter intercompany eliminations when you use the attribute method with the Consolidation capability.
Parent Company is a level with 2 child levels: Company A and Company B, which represent subsidiaries of Parent Company. For the Current Budget version, you want to enter a $4,000 transaction for January 2023 that Company A paid Company B. You want the transaction eliminated at the Parent Company level.
To use the attributes method, you have a separate account for every possible trading partner pair. Always enter transactions for each pair in the same credit and debit accounts. The account structure looks like this:
  • Intercompany Payables
    • Co A to Co B
      , which has the
      Company B
       attribute.
    • Co B to Co A
      , which has the
      Company A
       attribute.
  • Intercompany Receivables
    • Co A from Co B
      , which has the
      Company B
       attribute.
    • Co B from Co A
      , which has the
      Company A
       attribute.
When the trading accounts are on standard sheets, you can't see the account attributes. The account names should be self-explanatory. When the trading accounts are on a cube sheet, you can see the account attributes. You can use the attributes to help you filter and pivot the sheet to get to the right cells. For this example, you track the intercompany transactions on a standard sheet called
Intercompany Transactions
. The accounts are in the rows.
  1. Select
    Sheets
     from the main menu.
  2. To open the sheet, click
    Intercompany Transactions
    .
  3. From the version prompt in the top menu, select
    Current Budget
    .
  4. From the
    Levels
     prompt, select
    Company A
    .
    You select
    Company A
     to enter the transaction for the paying partner.
  5. In the cell that corresponds to
    January 2023
     and
    Co A to Co B
    , enter
    4,000
    .
    The sheet looks like this:
    Levels
    :
    Company A
    Accounts
    January 2023
    Intercompany Payables
    -Co A to Co B
    4,000
    -Co B to Co A
    Intercompany Receivables
    -Co A from Co B
    -Co B from Co A
  6. From the toolbar, click
    Save
    .
  7. From the
    Levels
     prompt, select
    Company B
    .
    You select
    Company B
     to enter the transaction for the paid partner.
  8. In the cell that corresponds to
    January 2023
     and
    Co B from Co A
    , enter
    4,000
    .
    The sheet looks like this:
    Levels
    :
    Company B
    Accounts
    January 2023
    Intercompany Payables
    -Co A to Co B
    -Co B to Co A
    Intercompany Receivables
    -Co A from Co B
    -Co B from Co A
    4,000
  9. From the toolbar, click
    Save
    .
The 4,000 transaction doesn't contribute to
Accounts Receivable
 or
Accounts Payable
 at the Parent Company level.
You can either: