跳至主要內容
文件
文件
Adaptive Planning
Example: Set Up Net Assets for Full Consolidation

Example: Set Up Net Assets for Full Consolidation

This example illustrates how to set up accounts in the general ledger Equity account for full consolidation. You use default formulas and the weighted-average translation settings. When completed as part of full consolidation, the data rolls up in the level hierarchy with the appropriate minority adjustments.
Parent Company owns 80% of a subsidiary called Child Company. You want the Net Income account in the Income Statement to flow properly into the Net Asset account in the Balance Sheet. You also want data to roll up to the parent company with adjustments based on ownership.
Your model:
  • Actuals version.
  • Calendar set up with Months, Quarters, and Years.
  • Your Income Statement is a standard sheet that includes the Net Income general ledger account.
  • Your Balance Sheet is a standard sheet that includes the Equity general ledger account.
  1. Go to
    Modeling
     and click
    General Ledger Accounts
    .
  2. From the general ledger account list, highlight
    Equity
    .
  3. Click
    Create new account
     and in the settings for:
    • Code
      , enter
      NetAssets
    • Name
      , enter
      Net Assets
      .
  4. From the toolbar, click
    Save
    .
  5. From the account list, highlight
    Net Assets
    .
  6. Click
    Create new account
     and in the settings for:
    • Code
      , enter
      NetAssets_Beg
      .
    • Name
      , enter
      Net Assets, Beginning
      .
    • Planned by
      and
      Actuals by
      , click
      Delta
      .
    • Default Formula
      , enter the number
      0
       (zero).
      The zero in the formula makes this account read-only in sheets.
    • Weighted-Average Translation
      , click the check box.
    • Exchange Rate
      : select
      Avg: Monthly Average
      .
  7. Click
    Save
    .
  8. From the account list, highlight
    Net Assets
    .
  9. From the toolbar, click
    Create new account
     and in the settings for:
    • Code
      , enter
      YTD_MI
      .
    • Name
      , enter
      YTD Minority Interest
       .
    • Planned by
       and
      Actuals by
      , select
      Delta
      .
    • Default Formula
      , enter
      -ACCT.MI_Adj
      .
    • Weighted Average Translation
      , click the check box.
    • Reset Balance
      , click the check box and select
      Year
      .
    • Transfer Balance on Reset
      , click the check box and select
      Net Assets, Beginning
      .
    • Exchange Rate
      , select
      Avg: Monthly Average
      .
  10. Click
    Save
    .
The new accounts display automatically in the Balance Sheet standard sheet because Equity already exists on the sheet.
The formula in
YTD Minority Interest
 account pulls in the data and swaps the sign of the value of the Minority Interest Adjustment account. Because it's a cumulative account, the value accumulates through the time periods.
The weighted-average translation settings move the end of year value to the
Net Assets, Beginning
 account at the start of the next year. At the start of the year, the
YTD Minority Interest
 resets to zero and starts accumulating again.
Both accounts roll up to the
Net Assets
account as part of your
Equity
.
To automate the minority adjustments, set up the full consolidation method and assign ownership percentages.