Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
2 years ago

Eliminations between Balance & P&L accounts

Hi everyone; we have an application using standard elimination, we have been used eliminations between balance account and P&L accounts, I created a new account in Balance sheet accounts with plug account as Assets, create another P&L account (Revenue) using the same plug Asset account; now when runs the consolidation & Eliminations, there is a difference with balance, is unbalancing.

Is there an specific configuration that I need to setup into the accounts?

Thanks in advance and best Regards.

Mario GV

Consolidation
  • DJB's avatar
    DJB
    New Contributor II
    19 days ago

    We are using an Equity Balancing account as the plug account for 2 BS and 1 P&L account.  The balance sheet accounts work as expected. The P&L account, not so much.

    The oddest behavior is occurring. The first month that has a P&L value behaves as expected: eliminated on the P&L, amount reduced from BS plug account. Subsequent months are eliminated but the balancing account is not reduced. This causes the consolidated BS reports to be OOB for those periods. 

    Has anyone experienced a similar issue with BS & PL accounts sharing a BS plug? 

  • Henning's avatar
    Henning
    Valued Contributor II
    2 years ago

    Hi,

    This question has been raised before in this post:

    plug accounts using P&L and Balance sheet types - OneStream Community (onestreamsoftware.com)

    I hope this answers your question.

    Generally, try not to mix balance sheet and income statement accounts on the same plug account as this naturally leads to differences (unless you have a single currency solution). As said in the other post, this can be adjusted using various configurations, but the default way results in differences (down to math).

    • DJB's avatar
      DJB
      New Contributor II
      9 days ago

      Thanks. 

      I read that post earlier. But the Cube setting is the not the cause of our issue.  Nor is FX translation. Unless there is something else in the config, I assume a default set-up where a BR or formula is needed.

      • Henning's avatar
        Henning
        Valued Contributor II
        6 days ago

        Hi, this is a 2 year old post. Your chances of getting more responses are probably higher when you open a new post with a detailed description of what is happening in your case, possibly including some screenshots.

        Without more details, I would check if something in the source data has changed, maybe the data that is not eliminating anymore does not come with an IC partner information starting the month you observe this change in behavior.