Saltar al contenido principal
Documentación
Documentación
Adaptive Planning
Steps: Build Intercompany Trading Sheet

Steps: Build Intercompany Trading Sheet

The intercompany trading sheet is a standard sheet that you build if you use the splits method for intercompany elimination. It can be either user-assigned or level-assigned. Use it to enter and track elimination data between trading partners.

Prerequisites

Navigation

Compass.png From the nav menu, select
Modeling
. In the
Sheets
menu, select
User Assigned Sheets
 or
Level Assigned Sheets
to view the list of sheets in your model.

Create Sheet

You can create one sheet for all intercompany data or several sheets for specific levels and accounts. If the sheet already exists, from the sheet list, click
Edit
next to the sheet name. This opens the
Sheet Summary
 page. From there, click the links to edit the sheet.
Have a list of
  • Intercompany accounts
  • Trading partner levels
  • Elimination levels
To create the sheet:
  1. Click the
    New Sheet
     button at the bottom of the sheet list.
  2. Enter a name for the sheet in the
    Sheet name
    field. Make the name match the purpose. For example, call it Intercompany Transactions.
  3. Click the
    Create new sheet
     radio button and select
    Standard
    from the dropdown.
  4. Click
    Next
    .

Create Groups and Add Accounts

As a best practice, think about grouping accounts. You can group the debit accounts with their associated credit accounts, or you can group all the debit accounts together and all the credit accounts together.
You should also add the difference system account.

Create Accounts Groups

  1. If the sheet already exists, click
    Account Groups
     from the
    Sheet Summary
    .
  2. Click the
    New Group
     button below the
    Accounts for Sheet
     tab.
  3. In the
    Group Details
     section, enter a name, such as Debits or Credits, for the group in the
    Heading
    field.
  4. (Optional) As a best practice, click the
    Show Heading
    checkbox. Now the group heading name appears on the sheet.
  5. Click the
    Save
    button right below the
    Heading
    field.

Add Accounts

  • When you add a parent account, you add all its child accounts.
  • You can't remove a child account unless you remove the parent.
  • You can't add the same account to more than one group.
  • Best practice: Add only intercompany accounts to the sheet.
To add the accounts:
  1. In the
    Accounts for Sheet
    tab, highlight the group. This is the group you will add the accounts to.
  2. From the
    Select Accounts
    section, use the
    Type
    filter or the
    Search
    field to find accounts.
  3. Highlight the account and click the
    Add To Group
     button. Add the credit, debit, and system difference accounts.
  4. Once you add all accounts, click
    Next
    .

Add the Trading Partner Dimension

  1. If the sheet already exists, click
    Dimensions
    from the
    Sheet Summary
     screen.
  2. From the
    Available Dimensions
     list, find the trading partner dimension.
  3. Highlight the dimension and click the forward arrows to add it to the
    Selected Dimensions
     list.
  4. Click
    Next
    if you're building a new sheet, or
    Save
    if you're editing.
The trading partner dimension name might be different for your instance. Your admin entered the name in the General Setup. See Change the Trading Partner Label.

Set the Initial View

The initial view sets how the sheet appears when a user opens it. You can have either levels or accounts down the rows of the sheets. Your users can switch between the two. Accounts down the rows provides an easy way for users to see all the account data per level. Levels down the rows provides an easy way for users to audit their data -- they can make sure that levels aren't tracking data in the wrong accounts.
To display levels down the rows, click
Start in view by level mode
. Uncheck the option to display accounts down then row. Then click
Next
if you're building a new sheet or
Save
if you're editing.

Add Levels

Have a list of all your model's trading partner and elimination levels. Best practice: add elimination levels so you can see that the rules successfully eliminated at the appropriate level.
  1. If you're editing the sheet, click
    Level Availability
     from the
    Sheet Summary
    .
  2. Click the arrows in the tree to expand the entire level list.
  3. Select the checkboxes next to the levels that are trading partners and elimination levels.
  4. Click
    Save
    .