Skip to Main Content
Return to Navigation

Defining Accounting Entries

Use the following components to set up accounting entries:

This topic provides an overview of accounting entry options, lists the pages used to set up accounting entries, and discusses how to:

Pages Used to Define Accounting Entry for PeopleSoft Asset Management

Page Name

Definition Name

Navigation

Usage

Asset Book

BOOK_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select Asset Books, then select Asset Books

Define asset books.

Accounting Entry Template ID

AMAE_TMPL_ID_PNL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Accounting, then select Accounting Entry Template IDs, then select Accounting Entry Template IDs

Create a template ID with options for depreciation features and distribution methods.

Accounting Entry Templates

DIST_TEMPLATE_DEFN

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Accounting, then select Accounting Entry Templates, then select Accounting Entry Templates

Add or modify accounting entry templates.

When accessing the Accounting Entry Templates page, you can use a transaction code as a key to determine what accounting entries to create.

Accounting Templates in Mass

RUN_AMAEMASS

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Accounting, then select Accounting Templates in Mass, then select Accounting Templates in Mass

Create one or multiple accounting entry templates for journal templates, cost types, transaction codes, and retirement disposal codes in a single process.

Accounting Entry Templates Report

RUN_AMAE1000

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Reports, then select Accounting Entry Templates, then select Accounting Entry Templates

Run a report showing a list of accounting entry templates.

InterUnit Transfer Definition

IU_TRF_DEFN_TBL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select InterUnit Transfer Definition, then select InterUnit Transfer Definition

Set up an InterUnit transfer definition.

Transaction Codes

TRANSACTION_CODE

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Financials, then select Transaction Codes, then select Transaction Codes

Review or modify the transaction codes.

Transaction Groups

TRANS_GROUP_PNL

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Accounting, then select Transaction Groups, then select Transaction Groups

Set up transaction groups for purposes of allocating depreciation. For example, depreciation and prior period depreciation may be treated the same for allocations, so you can combine them into one transaction group.

Book Code

BOOK_CODE

select Set Up Financials/Supply Chain, then select Common Definitions, then select Design ChartFields, then select Define Values, then select ChartField Values, then select Book Code

Add book codes in pairs to facilitate multiple GAAP within the same chart of accounts.

Acct Template Book Code Update

RUN_AM_BKC_RESET

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Accounting, then select Acct Template Book Code Update, then select Acct Template Book Code Update

Reset accounting templates book codes in accounting templates.

ChartField Mapping Template

AM_CF_MAPPING

select Set Up Financials/Supply Chain, then select Product Related, then select Asset Management, then select Accounting, then select ChartField Mapping Template, then select ChartField Mapping Template

Create a ChartField map template to map dissimilar charts of accounts when entities have different ChartField structures.

Understanding Accounting Entry Options

PeopleSoft uses tables to support accounting entries for PeopleSoft Asset Management. Some tables are required for accounting entry processing and are noted as such. All others are optional.

Accounting Books

Defining asset books is required for accounting entry processing. Asset books are used to store financial information about assets such as cost history, depreciation rules, and retirement information.

An unlimited number of asset books per business unit can be defined. The number of books that you use depends on your reporting needs. Using multiple books enables you to keep separate cost and depreciation rules for each asset. Typically, organizations use at least two books: corporate and tax, also known as financial and fiscal. Your organization may need additional books if it does business in more than one state or country or uses any of the United States-recognized special tax treatments of accelerated current earnings (ACE) and alternative minimum tax (AMT).

Note: The depreciation criteria for each book are specified when you add assets or create asset profiles.

Accounting Entry Templates

The Accounting Entry template is the central table used for creating accounting entries to general ledger journals. Each is defined by an accounting entry template ID. When you add an accounting entry template, PeopleSoft Asset Management populates it with standard accounting entry types, based on the asset category, cost type, and transaction type that you specify. It also identifies each entry as either a debit or credit.

To begin, create accounting entry template IDs and if applicable in your business, mark the cost types for impairment and revaluation. For the setID, create or select an existing accounting entry template to apply depreciation features and distribution methods. These features control what distribution types need to be set up in the accounting entry template.

PeopleSoft Asset Management enables you to create one or multiple accounting entry templates in a single operation. You may generate accounting entry templates for an asset category for all transaction types. You can generate templates for cost type, transaction code, and retirement disposal code.

Once you have defined the accounting entry template IDs, run the Create Accounting Templates in Mass Application Engine process (AMAEMASS) that generates accounting entry templates for all transaction types and user-defined cost type, transaction code, and disposal code.

Multiple GAAP and Book Codes

PeopleSoft delivers the ability to book accounting transactions according to different and often conflicting accounting principles for one Business Unit in one ledger and to maintain these entries in compliance with the rules of government and regulatory organizations. You can add book codes for PeopleSoft Asset Management to facilitate accounting entry processing.

Generally accepted accounting principles (GAAP) as determined in one country or jurisdiction often vary from country to country or by self-governing accounting bodies and jurisdictions. Consequently, organizations record and report their operations according to local accounting requirements as well as by rules applicable to parent corporations that are often under the rules of another national jurisdiction. PeopleSoft has provided the ability to maintain separate ledgers and ledger groups for different accounting principles, record transactions under varying statutory rules using Alternate Account and using MultiBook in PeopleSoft General Ledger and its subsystems for its automatic synchronization capabilities. A sometimes much favored method, especially within financial organizations, is defining book codes. This method enables you to simultaneously generate in one business unit and ledger all the relevant accounting entries for a transaction that addresses different local and corporate accounting rules.

You can use book codes to simultaneously generate sets of entries to record related transactions according to multiple GAAP for the same business unit in the same ledger. For example, where local and corporate accounting principles are not compatible, you define a local (L) and a corporate (C) book code. For those situations where requirements are alike, you define a code for both (B). You can attach these book codes to accounts as attributes. This results in separate permutations of accounts and book codes in which you simultaneously record related transactions under local, corporate, or both rules. You can choose to associate a single book code with one account value. Using this method, a unique account value must be created for each book code.

See Understanding Multiple GAAPs and Prior Period Adjustments.

Prerequisites

Before you can define accounting entry processing, you must first complete the following task:

  • Define overall installation options to enable Book Code functionality. Use the Installation Options Overall (INSTALLATION_FS1) page.

  • Define ChartField accounts.

  • Define journals, ledgers and ledger groups.

Transaction Codes Page

Use the Transaction Codes page (TRANSACTION_CODE) to review or modify the transaction codes.

Image: Transaction Codes page

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

Transaction Codes page

When you define accounting entry options for a book, you can choose to distribute by disposal code. If you choose this option, the disposal code appears by default as the transaction code. In this case, you must use the transaction codes from the delivered TableSet defined for the tubbiest that you are using. You must also define corresponding accounting entry templates.

Note: The standard transactions are predefined and delivered with PeopleSoft Asset Management. To modify the transaction types, use the Asset Management (INSTALLATION_AM) page of the Installation Options (INSTALLATION) component.

See Installation Options - Asset Management Page.

Accounting Entry Template IDs Page

Use the Accounting Entry Template IDs page (AMAE_TMPL_ID_PNL) to create a template ID with options for depreciation features and distribution methods.

Image: Accounting Entry Template IDs page

This example illustrates the fields and controls on the Accounting Entry Template IDs page. You can find definitions for the fields and controls later on this page.

Accounting Entry Template IDs page

Note: When setting up a new template or changing a template ID on a template that previously used either Gain/Loss or Net Book Value distribution, you may see a warning that the previous templates will be deleted. You have the option to go back and update the template instead.

Accounting Entry Templates Page

Use the Accounting Entry Templates page (DIST_TEMPLATE_DEFN) to add or modify accounting entry templates.

Image: Accounting Entry Templates page

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

Accounting Entry Templates page

Set up an accounting entry template for each possible combination of:

  • Asset category.

  • Cost type.

  • Transaction type.

  • Transaction code.

  • Accounting entry template ID.

Note: If you enter an asset into your system by using a combination of these values for which no accounting entry template exists, your accounting entry process fails when you next attempt to run it.

For each accounting entry type, select:

Accounting Entry Types

Accounting entry types are set by the system. Each asset event has an associated set of accounting entry types.

For each possible combination of category, cost type, and transaction code, you must set up an accounting entry template for each of the following transaction types:

  • ADD: Additions.

  • ADJ: Adjustments.

  • TRF: Transfers.

  • RCT: Recategorizations.

  • DPR: Depreciation expenses.

  • PDP: Prior period depreciation.

    Note: The DPR and PDP transaction types are used only on an accounting entry template with a blank transaction code.

  • RET: Retirements (also used for processing reinstatements).

  • LPY: Lease payments.

  • INF Inflation adjustment.

Book Code

Specify a book code for each account value.

The Allow Book Code Override option that is set on the Account (ACCOUNT) page determines whether this book code can be overridden on the transaction line. The Effective Date and Status fields on the Account page must match the settings for the account values to which the book code is attached. Assets take the most recent and active date to populate its templates. To avoid any situation where Book Code might generate unbalanced entries in General Ledger, a warning message is generated when the template is saved when there are paired distribution types with different Book Codes. Paired distribution types are those distribution types that play against other in order to balance the entry.

Accounting Templates in Mass Page

Use the Accounting Templates in Mass page (RUN_AMAEMASS) to create one or multiple accounting entry templates for journal templates, cost types, transaction codes, and retirement disposal codes in a single process.

Image: Accounting Templates in Mass page (1 of 3)

This example illustrates the fields and controls on the Accounting Templates in Mass page (1 of 3). You can find definitions for the fields and controls later on this page.

Accounting Templates in Mass page (1 of 3)

Image: Accounting Templates in Mass page (2 of 3)

This example illustrates the fields and controls on the Accounting Templates in Mass page (2 of 3). You can find definitions for the fields and controls later on this page.

Accounting Templates in Mass page (2 of 3)

Image: Accounting Templates in Mass page (3 of 3)

This example illustrates the fields and controls on the Accounting Templates in Mass page (3 of 3). You can find definitions for the fields and controls later on this page.

Accounting Templates in Mass page (3 of 3)

When you begin the process, the page displays your request ID and default process frequency. Select the setID, account entry template ID, and category. Three actions can be carried out:

Distribution Options

The page displays a distribution type list and corresponding account and alternate account specific to the template ID or category selected. The list is refreshed when these values change.

If Book Code functionality is set up at Accounting Entry Template ID level, the book code related to the account displays. The Allow Book Code Override option set on the Account page determines whether the book code can be overridden for each distribution type. This process populates the book codes using the criteria defined for the Accounting Entry Template.

If the book code column does not display, it is not selected at Accounting Entry Template ID level. The template uses the book code based on the accounts effective date set in the Account definition page.

SetID Options

The page includes expandable subpages of options determined by setID.

InterUnit Transfer Definition Page

Use the InterUnit Transfer Definition page (IU_TRF_DEFN_TBL) to set up an InterUnit transfer definition.

Image: InterUnit Transfer Definition page

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

InterUnit Transfer Definition page

To begin, from the search dialog page, select the books used by the To Business Unit business unit.

InterUnit transfer definitions act as templates to simplify performing InterUnit transfers.

InterUnit transfer definitions tell the system which books exist for the transfer from and transfer to business units, and what type of transactions the InterUnit transfer should generate for each book. If you are planning to perform many InterUnit transfers, it helps to first define all the possible InterUnit transfers.

For example, if you have three business units, US001, US002, and US003, and you expect to perform all possible InterUnit transfers, you would set up these six InterUnit transfer definitions:

Transfer From

Transfer To

US001

US002

US001

US003

US002

US001

US002

US003

US003

US001

US003

US002

When transferring from a business unit with two books to a business unit with three books, enter information into the extra To Book by using either the Add Book action or the Transfer Book action.

For example:

From Book

To Book

Action

Corporate

Local

Transfer Book

Federal

Reporting

Transfer Book

Corporate

Other

Add Book

The transactions generated to pass book information for InterUnit transfers differ depending on how many To Book entries a From Book is passing information to, and whether it is passing the information by using a transfer action or an add book action.

Note: Assets that are transferred to new business units by using the add action will have a cost row of zero on the new business unit until you run the Depreciation Calculation process (AM_DEPR_CALC). Running this process updates the asset's cost row with its net book value from the From Book.

When you use an asset profile, the book information appears by default from the profile.

Using a From Book Once

When a From Book is used once only, an add action generates a retirement for the From Book and an add to the To Book. A transfer action generates a transfer out for the From Book and a transfer in for the To Book.

The asset that is retired receives an asset status of Disposed.

Assets that are transferred between books by using the transfer action receive a status of Transferred:

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Transfer Out

CORPORATE

Transfer In

Transfer Book

FEDERAL

Transfer Out

FEDERAL

Transfer In

Transfer Book

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Transfer Out

CORPORATE

Transfer In

Transfer Book

FEDERAL

Retire

FEDERAL

Add

Add Book

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Retire

CORPORATE

Add

Add Book

FEDERAL

Retire

FEDERAL

Add

Add Book

Using a From Book for Two or More Transfers

When a From Book is used for two or more transfer book actions, only one transfer out transaction is generated. Because this takes care of the cost on the From Book, no additional transfer outs are generated for that book.

Assets that are transferred between books by using the transfer book action receive a status of Transferred:

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Transfer Out

CORPORATE

Transfer In

Transfer Book

CORPORATE

 

LOCAL

Transfer In

Transfer Book

Using a From Book for Both Transfer and Add

When a From Book is used for both a transfer and an add action, a transfer out is generated for the Transfer Book. Because this takes care of the cost on the From Book, the add action does not generate a retirement for that book.

Assets that are transferred between books by using the transfer book action receive a status of Transferred:

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Transfer Out

CORPORATE

Transfer In

Transfer Book

CORPORATE

 

LOCAL

Add

Add Book

Using a From Book for Two or More Adds

When a From Book is used for two or more add actions, a retirement is generated for the first add action. Because this takes care of the cost on the From Book, no further retirements are generated for it.

The asset that was retired receives a status of Disposed:

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Retire

CORPORATE

Add

Add Book

CORPORATE

 

LOCAL

Add

Add Book

Note: When you transfer from a business unit with three books to a business unit with two books, the cost information on the extra From Book is automatically retired. You do not need to enter an action.

See Understanding Adjusting, Transferring, and Evaluating Assets.

Retiring a Book

Assets that are retired receive a status of Disposed:

From Book

From Trans

To Book

To Trans

Action

CORPORATE

Transfer Out

CORPORATE

Transfer In

Transfer Book

LOCAL

Transfer Out

LOCAL

Transfer In

Transfer Book

FEDERAL

Retire

 

 

 

See Understanding Asset Retirement.