The AccountType property is used to define the GL account type for Account Dimension members. More specifically, configuring this property defines the account aggregation behavior of a Member within an Account Hierarchy. Examples of values for this field include but are not limited to: Unit, Header, Expense, Liability, Equity, Asset, Cash, Income, and Rate.
Account Type Behavior
Account aggregation is determined by the relationship of a child Member to its parent Member. For instance, an Account Member that is a Credit will sum to its parent if its parent is also a Credit. However, an Account Member that is a Credit will subtract from its parent if its parent is a Debit.
The table below shows the aggregation behavior between a child Member and its parent in the Account Dimension:
When an Account Member is tagged with an Account Type, the system then knows how to handle its aggregation behavior. The table below lists out the associated properties by each Account Type:
Let’s analyze an example Account hierarchy with the following Account Types specified. In order to determine how the aggregation will work for each Member, we first need to identify the child and parent Members in the hierarchy.
Once the child and parent Members are identified, you can look up the Debit/Credit properties for each Member based on the Account Types table. Follow the Debit/Credit Aggregation Rule to determine the correct aggregation behavior.