Setting Up Account Information

This topic provides an overview of account information setup and discusses how to:

Define account types.
Define accounts.
Define account nodes.

Pages Used to Set Up Account Information

Page Name	Definition Name	Navigation	Usage
Account Types	ACCT_TYPE	select EPM Foundation, then select Business Metadata, then select Business Framework, then select Account Types	Define the account types to which you will later assign accounts. Account types describe the various categories of accounts that correspond to those on your balance sheet or income statement.
Accounts	ACCOUNT_TBL1	select EPM Foundation, then select Business Metadata, then select Business Framework, then select Accounts	Define new PeopleSoft EPM accounts.
Account Nodes	PF_ACCT_NODE_DFN	select EPM Foundation, then select Business Metadata, then select Business Framework, then select Account Nodes	Define the accounts nodes to which you will later assign accounts.

Understanding Accounts

Like general ledger accounts, accounts in PeopleSoft EPM hold the key to monetary values stored in ledgers. These values are held in certain buckets—accounts—according to their function.

If you have PeopleSoft General Ledger you can duplicate your general ledger account structure from your transaction system using PeopleTools Data Mover to move your accounts to your PeopleSoft EPM database. If you use another online transaction processing (OLTP) system or a legacy system, you can migrate your structure using data migration tools.

PeopleSoft EPM contains a couple of important account tables:

GL_ACCOUNT_TBL

Contains all currently active general ledger and performance (PF) accounts, keyed by SetID.

PF_ACCOUNT_VW

View of the account table that filters for performance (PF) accounts only.

Account Types Page

Use the Account Types page (ACCT_TYPE) to define the account types to which you will later assign accounts. Account types describe the various categories of accounts that correspond to those on your balance sheet or income statement.

Navigation

select EPM Foundation, then select Business Metadata, then select Business Framework, then select Account Types

Image: Account Types page

This example illustrates the fields and controls on the Account Types page. You can find definitions for the fields and controls later on this page.

Account Type

Displays a letter-code that identifies each account type. You assign account codes to new accounts (those not migrated from other systems) that you enter on the Account page.

Values include:

A: Asset

E: Expense

L: Liability

Q: Equity

R: Revenue

F: Force Balancing

D: Detail

Balance Forward

Select if you use this account type primarily to determine whether to store balance forward amounts. How you track balance forward amounts is completely up to you. For example, in your regular accounting system, you may want asset, liability, and equity accounts specified as balance forward accounts, but not revenue or expense accounts. The accounts you define later on the Accounts page will take on the balance forward attribute of the account type you assign to them.

Warning! For accounts that you use with PeopleSoft financial services industry applications it is important that you not deviate from the account type codes mentioned here. All asset accounts must be tagged with an A, expense accounts with an E, and so on.

Accounts Page

Use the Accounts page (ACCOUNT_TBL1) to define new PeopleSoft EPM accounts.

Navigation

select EPM Foundation, then select Business Metadata, then select Business Framework, then select Accounts

Image: Accounts page

This example illustrates the fields and controls on the Accounts page. You can find definitions for the fields and controls later on this page.

Monetary Account Type

Select from the account types defined on the Account Types page.

Note: To obtain account information on reports, you need to add those accounts to the system. In PeopleSoft EPM, you set up a base of general ledger accounts by migrating them from your transaction accounting system. However, when your data migration is complete, you may find that you need to add new accounts to your system.

Warning! For accounts that you will use with financial services applications—PeopleSoft Funds Transfer Pricing and Risk-Weighted Capital—it is important that you not deviate from the standard account type codes. All asset accounts must be tagged with an A, expense accounts with an E, and so on.

GL Account

Select if the account is a transaction-based account.

PF Account

Select if the account is performance (PF) ledger.

ABM Account

An account tagged as an ABM account creates more detailed information within the performance (PF) ledger. The ABM-specific fields on this page enable you to specify that the performance ledger contain both the appropriate profitability dimension (cost object), and the activity that contributed costs to the cost object.

Object Type

When you select the ABM Account check box, a drop-down list box for object type appears. Select a default object type for the account.

Activity ID

When you select the ABM Account check box, a drop-down list box for activity ID appears. Select a default activity for the account.

Statistical Account

If you are establishing a statistical account, select the check box and select a unit of measure. Statistical accounts store only statistical amounts, not monetary amounts.

Unit of Measure

If you want to track statistical amounts, select a unit measure.

Warning! Although monetary amounts are assigned to performance (PF) accounts, there is no reconciliation per se, as there is in PeopleSoft General Ledger. The performance (PF) account and source dimensions are used to store and reconcile amount facts to the same amounts stored by a general ledger account. Performance (PF) accounts can differ significantly from general ledger accounts.

Account Nodes Page

Use the Account Nodes page (PF_ACCT_NODE_DFN) to define the accounts nodes to which you will later assign accounts.

Navigation

select EPM Foundation, then select Business Metadata, then select Business Framework, then select Account Nodes

Image: Account Nodes page

This example illustrates the fields and controls on the Account Nodes page.

You can define accounts nodes to which you will later assign accounts. The page displays an effective date, status, and description for each node.