Table of Contents

Account

Applies to: img Planner 4.x, 5.0 or 5.1

Overview

Here you can edit the Account dimension.

  1. Account
    This will filter accounts on the hierarchical node selected.

  2. Change Account Dimension
    This table is showing the list of accounts and some attributes to be edited here.

  3. Publish
    Push this button to apply changes to Account dimension.

Often accounts are imported from an external source. In this case the default priority between the local edits and external source are as follows:

  • External source will have priority for Account Description and translations and will add new accounts.
  • Local edits will have priority for "Allow Input", "Sign Factor", "Acc. Type" and hierarchical information contained in the Hierarchy level 1 to 3 (see below). Local edits can also add accounts and delete accounts.

If you choose to edit account description or translations and delete an account that is imported from external source, the edits will be overwritten, and the deleted account will be added from external source.

Hierarchy

The account dimension hierarchy by default consists of 4 levels, including the actual account, in the following order:

  • Hierarchy level 1
  • Hierarchy level 2
  • Hierarchy level 3
  • Account

This is reflected in the positioning of the columns from left (lowest level, i.e. Account) to right (highest level, i.e. Hierarchy level 1).

Note that all levels must be filled in, but padding - that is repeating - levels from one level to the next level up should be used if the actual hierarchy does not contain all levels, as shown in the example below, considering the account level contains actual accounts.

In the example, Account 3790 is padded - repeated - to hierarchy levels 3. This means that Planner renders the hierarchy skipping hierarchy levels 3 so that when expanding level 2 at the 37 node, 3790 renders immediately below as shown in the left margin.

The number of hierarchical levels can be changed but has to be done using the Profitbase InVision designer. Legal entity does not have to be a level in the hierarchy, but it has to be present in the table and filled in.

The account dimension hierarchy is used for defining Finance settings and not for reporting.

When designing this hierarchy, the main consideration should therefore be the granularity most suitable for defining finance settings.

Column Descriptions

  • Account
    The account identifier.
  • Account Description
    The descriptive name of the account.
  • Allow Input
    Set to true for accounts that will be available for Forecast or Budget input.
  • Sign Factor
    Set this to tell how the sign on accounts will be used. For example, it is normal that sales account is using negative sign and as such Sign Factor will be -1.0. Sign factor is relevant in two scenarios:
  1. Account sign factor (this field): a sign factor of -1 tied to an account will:
    o Switch the sign of any historical data
    o Switch the sign of any input data
    This would typically apply to income accounts booked with a credit sign that one would like to see and input as a positive amount in an input form.
  2. Report line sign factor (see Setup Report): a report line nets a range of accounts or is a calculation of other report lines.
    The report line sign factor indicates whether this net amount should be presented "as is" (sign factor +1) or with the opposite sign (sign factor -1) in this particular report.
    Note that any report lines that act as calculations of other report lines will perform that calculation based on the values displayed, i.e. after the sign factor has been applied.
  • EN: Account Description
    Text for English translation for Account Description.
  • NO: Account Description
    Text for Norwegian translation for Account Description.
  • Acc.Type
    Dropdown list to set the type of account ("Balance" or "Profit Loss") is the 12 period columns showing amounts.

Hierarchy level 3

  • ID
    ID for hierarchical level 3 (level above account)
  • Descr.
    Description for hierarchical level 3 (level above account)
  • EN: Descr.
    Description for hierarchical level 3 in English
  • NO: Descr.
    Description for hierarchical level 3 in Norwegian

Hierarchy level 2

  • ID
    ID for hierarchical level 2
  • Descr.
    Description for hierarchical level 2
  • EN: Descr.
    Description for hierarchical level 2 in English
  • NO: Descr.
    Description for hierarchical level 2 in Norwegian

Hierarchy level 1

  • ID
    ID for hierarchical level 1 (highest level)
  • Descr.
    Description for hierarchical level 1 (highest level)
  • EN: Descr.
    Description for hierarchical level 1 in English
  • NO: Descr.
    Description for hierarchical level 1 in Norwegian
Edit this page