Managing Accounting Entries

Page Name

Definition Name

Usage

Accounting Entries Page

TRA_ACCTG_LINE

  • Review and adjust automated accounting entries.

  • Create manual accounting entries online.

Treasury VAT Information Page

TRV_ACCTG_LINE_VAT

Review VAT information for a VAT-applicable accounting entry line.

See the Accounting Entries Page.

View/Approve Entries Page

TRA_ACCTG_LINE

Approve accounting entries that are awaiting review.

Accounting Summary Page

TRA_ENT_SUM_PNL

View line-by-line accounting events. You can retrieve information according to ad hoc search criteria and navigate to all functional areas of accounting.

Reverse Accounting Request Page

REV_ACCTG_REQ

Run a process to create reversal accounting entries.

Note: Accounting entries can be reversed only one time.

Field or Control

Description

Created By

Displays the userID of the user who created the entry.

Created Dttm (created date and time)

Displays the entry creation date and time.

Last Changed By

Displays the userID of the most recent user to edit the entry.

Last Dttm (last updated date and time)

Displays the most recent modification date and time.

Source Code

Indicates the source for the accounting entry or fee. Values are:

  • (none)

  • BSP (bank statement processing)

  • Bank Xfers (bank transfers)

  • Deal Fees

  • Deals

  • EFT Fees (electronic funds transfer fees)

  • EFTs (electronic funds transfers)

  • Fac Fees (facilities fees)

  • Hedges

  • Interest

  • LC Fees (letter of credit fees)

  • Other

  • Pools

  • Securities

Use the Accounting Entries page (TRA_ACCTG_LINE) to review and adjust automated accounting entries.

Create manual accounting entries online.

Navigation:

Cash Management > Treasury Accounting > Accounting Entries

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

 Accounting Entries page

Field or Control

Description

Accounting ID

Displays the ID of the accounting entry.

Orig Accounting ID

Indicates the entry is a reversal entry. Click the link to view the original accounting entry in a separate window.

The Description field also identifies whether the entry is a Reversal Accounting Entry.

Event

Displays a descriptive label for the accounting entry, based on the source code value.

Source Code

Displays the accounting entry source, as processed by the Automated Accounting process, or entered on a manual accounting entry.

Source ID

Displays the unique identification number on the source side for the accounting entry.

Acctg Date (accounting date)

Displays the date that the entry was processed through Automated Accounting, or entered as a manual accounting entry.

Status

Indicates the current condition of the accounting entry. Values are:

Provisional: The entry is not finalized. You can make any required changes.

Error: An error exists within the accounting entry. The system assigns this status—you cannot select it. When you correct an error, change the status to Provisional. After the status has been changed to Provisional, use the View/Approve Entries page to change the status to Final. The entry is then ready for the Journal Generator process—you do not need to reprocess it.

Final: The entry is ready for Journal Generator processing and is free from errors.

Until the entry is processed through the Journal Generator process, you can continue to make changes to it, even if the status is Final. When the Journal Generator processes the entry, the distribution status changes to Distributed, indicating that it has been posted to a General Ledger journal and no further modifications can be made.

Acctg Template (accounting template)

Displays the name of the accounting template that is attached to the accounting entry. If the accounting template is missing or inactive, Automated Accounting sets the accounting event status to Error. You can reset the Error status for accounting events that have valid templates and reprocess the accounting entries.

Note: If you use General Ledger, you can automatically reverse any unrealized gain/loss accounting that is generated by Treasury Management at the next accounting period. You need to create a journal template for this type of treasury accounting and enable the feature for automatic journal reversal. You must assign this journal template to the treasury accounting template for General Ledger to perform the automatic reversals.

Error

Indicates the error source of an automated accounting entry. Values are:

None: No error condition exists. This appears when the status is provisional or final.

Unbalanced: Debits do not equal credits, or debits and credits are not equal, but refer to different General Ledger business units.

CF Combo Error (ChartField combination error): The ChartField generated is invalid.

No Exchange Rate: The currency exchange rate for the applicable currency pair is missing. The base amount could not be converted to the accounting entry currency.

Account Not Specified: The account was undefined, and the amounts cannot be distributed.

IU Processor Error: The centralized processor encountered an error. Review the accounting entries, correct any errors, and click the Update Accounting button to regenerate accounting.

Requires Review

Select this check box to require review of the accounting entries. A check box that is selected and grayed-out indicates that the Review Required check box was already selected on the Template page on which this was based or the Review Manual Updates check box was selected on the Treasury Options page for the Treasury business unit and the accounting entry has been manually updated.

Update Accounting

Click this button if you edit any of the information in the Accounting Entries grids to run the centralized interunit processor.

Note: If you are editing information only in the page header (Status field or Requires Review check box), do not click the Update Accounting button.

When you click the Update Accounting button on the Accounting Entries page, the system determines whether the Review Manual Updates check box has been selected on the Treasury Options page associated with the Treasury Business Unit. If the Review Manual Updates check box is selected for the business unit, the system sets the accounting event status to Provisional and selects the Requires Review check box.

VAT (value-added tax)

Click this link to access the Treasury VAT Information page (TRV_ACCTG_LINE_VAT). The VAT link appears for VAT-applicable accounting entries.

Integration Status

Displays the status of the integration between Treasury and JD Edwards General Accounting. This field appears only if the integration is enabled on the Installation Options - Treasury page. Values are:

  • Pending: The entry is ready to be sent to the Integration Broker for transmission to JD Edwards General Accounting.

  • Sent: The entry has been sent to the Integration Broker.

  • Received: The accounting entries have been loaded into the JD Edwards staging table.

  • Loaded: The accounting entries have been loaded into the JD Edwards application tables.

  • Posted: The accounting entries have been posted to JD Edwards General Accounting.

  • Error: Indicates that the accounting entry contains erroneous data or an error occurred during the data transmission process and must be resent.

Note: If an entry must be resent, the integration status can be changed to Pending unless the integration status is already displayed as Posted.

See Installation Options - Treasury Page.

See JD Edwards Application Integrations with PeopleSoft Applications, "Using the PeopleSoft Treasury with JD Edwards General Accounting Integration."

Line Detail Tab

Field or Control

Description

Line

Displays the line number of the automated accounting process.

Error

Displays this column and an X link next to the lines with ChartField combination editing errors. Click the X link to access an Accounting Entries secondary page, which contains a Line Errors grid that has these fields:

  • Line # identifies the accounting entry transaction line number.

    You can click a line number for an error and the system returns you to the specific line containing the error. You can correct the error and click the Update Accounting button on the Accounting Entries page to run the centralized interunit processor again.

  • Message Set Number identifies the message set to which the error message belongs.

  • Message Number identifies the specific number of the error message within the message set.

  • Message Text describes information about the error.

Note: The Errors column only appears in the Accounting Entries page when there is a ChartField combination editing error. A ChartField combination error does not stop the Accounting Entries creation process (ACCOUNTING_BUILD). You can review and fix the errors after the process has finished.

GL Unit

Displays the associated General Ledger unit.

Exchange Rate Detail icon

Click the Exchange Rate Detail button to view currency exchange rate information on the Exchange Rate Detail page (EXCH_RT_DTL).

Base Amount

Displays the GL BU (General Ledger business unit) amount in the base system currency.

IU Anchor (interunit anchor)

Specify one line of the template as the anchor. This is a required field, because the centralized processor uses it to generate interunit entries.

The system resets manually entered exchange rates when you change the business unit, foreign currency, or accounting date on the accounting entry page. The system resets the exchange rate as follows:

  • On all accounting lines when the accounting date is changed.

  • On an individual line when the business unit or foreign currency is changed for that line.

ChartFields Tab

Select the ChartFields tab.

This example illustrates the fields and controls on the Accounting Entries page - Chartfields tab. You can find definitions for the fields and controls later on this page.

 Accounting Entries page - Chartfields tab

Field or Control

Description

Stat (statistic)

If a statistics code is set for this accounting line on the template, the code appears here. You can edit this field. Select a statistics code—the associated unit of measure (UOM) appears for the selected code. You must also enter a statistic amount with which to measure the statistic.

IBAN

Displays the international bank account number (IBAN) in addition to the local, domestic bank account number when the country has been set up to display the IBAN on the IBAN Formats Page.

Important! If a ChartField combination editing error occurs, an Errors column will appear after the Line # column. An X link will appear next to an transaction line with a ChartField combination error. You click the X link to access an Accounting Entries secondary page, which contains a grid that describes the error message for each transaction. You can click on a transactions Line # link and access the accounting transaction with the ChartField combination error, and fix the problem. See the Accounting Entries subtopic in this section for additional details.

See ChartField Values.

Additional Details Tab

Select the Additional Details tab.

This example illustrates the fields and controls on the Accounting Entries page - Additional Details tab. You can find definitions for the fields and controls later on this page.

 Accounting Entries page - Additional Details tab

Field or Control

Description

Line Source

Displays either Treasury for accounting lines that are generated by the treasury accounting program, or System IU for accounting lines that are generated by the centralized processor.

Journal Tab

Select the Journal tab.

This example illustrates the fields and controls on the Accounting Entries page - Journal tab. You can find definitions for the fields and controls later on this page.

 Accounting Entries page - Journal tab

Field or Control

Description

Combo Status

Indicates whether the ChartField combination that the system built based on the accounting template is Valid or Invalid.

GL Status (General Ledger status)

Provides information about the posting status of the entry. Possible values include:

  • Distributed: Distributed to a General Ledger journal.

  • Hold: An error condition exists, the entry must be corrected before Journal Generator can process it, or the entry requires review.

  • None: The entry has been created without errors, but has not been processed by the Journal Generator process.

Ledger Group

Indicates the general ledger group that is associated with the General Ledger Unit on the accounting line.

Ledger

Indicates the general ledger that is associated with the General Ledger Unit on the account line.

On the Accounting Entries page, the Source Code, Source ID, Event, and Accounting Template fields are optional.

  • If you complete the Source Code, Source ID, and Event fields, the system can create a link between the manual and the automated accounting results.

  • If you enter entries manually on a recurring basis, you can create and use an accounting template to minimize the data entry process for these entries. Any template that you create appears in the Accounting Template field. When you select an accounting template for this ad hoc entry, the system automatically populates the accounting lines with the template data.

To create ad hoc accounting entries:

  1. Enter the business unit and optionally, an accounting ID. Click Add.

  2. Select an accounting event from the following values:

    • (none)

    • AOCI Adjustment

    • AOCI Reclassify

    • Amortize Adj of Carrying

    • Barrier Rebate Payment

    • Commodity Cash Difference

    • Commodity Settlement

    • Deal Booking

    • Deal Maturity

    • Derecognize Firm Commitment

    • Discount Accrual

    • Fair Value Hedged Item G/L

    • Fee Accrual

    • Firm Commitment to Carrying

    • Forward Points Accrual

    • Generic Cash Flow

    • Initial Payment

    • Interest Accrual

    • Interim Principal Payment

    • Mark to Market

    • Maturity Payment

    • Option Cash Difference

    • Option Exercise

    • Option Premium Accrual

    • Periodic Payment

    • Premium Payment

    • Sell / Buyback

    • Transaction Fee

    • Will Not Occur - AOCI Reclassify

  3. Specify a source code.

  4. Select a specific source ID of the selected source code.

  5. Review the accounting date for accuracy.

  6. Leave the default status for ad hoc entries as Provisional. Do not change this setting.

  7. The Require Review check box is automatically selected for ad hoc entries. You cannot deselect this check box.

  8. (Optional) Enter a description.

  9. Select an accounting template.

  10. Enter at least one debit and one credit line to balance the entry, and select one line as the IU anchor.

  11. Enter an account and any other ChartFields for each line.

  12. Select TR_ENTRIES for the journal template.

  13. Click Update Accounting to run the centralized processor function, which creates any necessary offset entry lines and saves the manual accounting entry.

If the debits and credits do not balance, you receive an error message and the accounting entry is not saved. Make the necessary corrections, and then save the page.

Note: When the Journal Generator processes the entry, the distribution status changes from None to Distributed, and no further changes can be made.

Use the View/Approve Entries page (TRA_ACCTG_LINE) to approve accounting entries that are awaiting review.

Navigation:

Cash Management > Treasury Accounting > View/Approve Entries

This example illustrates the fields and controls on the View/Approve Entries page. You can find definitions for the fields and controls later on this page.

 View/Approve Entries page

Field or Control

Description

Status

Initially displays the status of accounting entries that are displayed in the Accounting Entries grid. Values are:

  • Error: Accounting entries are in error and must be corrected before they can be posted to the general ledger. Possible causes of errors include unbalanced entries, currency exchange rate cannot be found, accounting template cannot be found, interunit errors, and so forth. Error status can be set only by the Automated Accounting process.

  • Needs Correction: Accounting entries are in error. Needs Correction status can only be set manually.

  • Provisional: Accounting entries passed system verifications, but require visual inspection. You can review the entry and save it with a new status of Final or Needs Correction.

  • Final: Accounting entries are ready to be posted to the general ledger.

Note: Use PeopleSoft Security functionality to identify which users have access and approval privileges to provisional accounting entries. You can define permission lists and accessible pages for a specific userID. See the product documentation for PeopleTools: Security Administration.

Use the Accounting Summary page (TRA_ENT_SUM_PNL) to view line-by-line accounting events.

You can retrieve information according to ad hoc search criteria and navigate to all functional areas of accounting.

Navigation:

Cash Management > Treasury Accounting > Accounting Summary

Field or Control

Description

Acctg Date (accounting date)

Displays the creation date of the accounting transaction.

Status

Select Error, Final, or Provisional.

Line

Click a link to access the Accounting Entries page for that event.

Event ID

Click to navigate back to the source transaction.

Accounting entries that need to be reversed can be identified using various identifiers, such as Accounting ID, Source, and Payment ID. The Reverse Accounting Entries Application Engine process (TR_RVSL_DRVR) does the following:

  • Selects the accounting data (header, lines, and VAT).

    The reversal accounting entry is not linked to a fiscal period.

  • Reverses the amounts and reset certain statuses and fields (for example, Journal Generator links).

  • Assigns a new accounting ID to each selected header, lines, and VAT.

    The process does not reset the accounting event status associated to the original accounting entry.

  • Calls document sequencing and ChartField combination editing, when applicable.

  • Populates the accounting tables with the new data (header, lines, and VAT).

  • Checks for errors (for example, combination edit, unbalanced entries) and updates the accounting header.

  • Logs messages summarizing the entries (including type of errors, number of entries created).

When deactivating a deal, you can automatically reverse the accounting entries on the Undo Deal Utility page. When you select the Reverse Accounting check box, you can use additional options to specify the Reversal Date Option and Combo Edit Template. The TRX_UNDO_DEAL Application Engine process uses the entered parameters and calls the Reverse Accounting process. When you create cumulative MTM accounting entries for deals, the Treasury Accounting Application Engine program (TR_ACCTG) processes cumulative fair value adjustments then initiates reverse accounting to reverse previous fair value adjustment accounting entries. For more information, see the documentation for the Deal Analytics page.

When an already accounted external transaction is unreconciled using semi-manual reconciliation, the system triggers the TR_RVSL_DRVR process to reverse the accounting entries. The external transaction status is set as Void to ensure that there is only one valid BSP transaction corresponding to the source Bank Statement transaction.

Use the Reverse Accounting Request page (REV_ACCTG_REQ) to run a process to create reversal accounting entries.

Note: Accounting entries can be reversed only one time.

Navigation:

Cash Management > Treasury Accounting > Reverse Accounting Request > Reverse Accounting Request

This example illustrates the fields and controls on the Reverse Accounting Request page.

 Reverse Accounting Request page to reverse by Accounting ID

Field or Control

Description

Reverse Accounting Option

Select from these values:

  • Reverse by Accounting ID

  • Reverse by Payment ID

  • Reverse by Source

The page will render differently depending on the selected Reverse Accounting Option. Each option has different criteria for identifying the accounting entries to be reversed.

Combo Template

Specify a combination editing template.

See Setting Up Combination Editing.

Reversal Date Option

Select the date to use as the accounting date for the reversal accounting entries.

The Reversal Date field is available for input when the reversal date option is Specify Date.

Select a reversal date from these values:

  • Current Date- Select to use the current date as the accounting date for the reversal accounting entries.

  • Specify Date - This option requires a value in the Reversal Date field, where you can enter a specific accounting date.

Accounting ID Criteria

This section appears when you select Reverse by Accounting ID in the Reverse Accounting Options field.

This example illustrates the fields and controls on the Reverse Accounting Request page to reverse by Accounting ID.

 Reverse Accounting Request page to reverse by Accounting ID

Field or Control

Description

Business Unit

Enter a business unit. This is a required field.

Accounting ID From and Accounting ID To

Identify one or more accounting IDs to be reversed. Accounting entries for the accounting ID range will be reversed. Accounting ID From is a required field.

Payment ID Criteria

This section appears when you select Reverse by Payment ID in the Reverse Accounting Options field.

This example illustrates the fields and controls on the Reverse Accounting Request page to reverse by Payment ID.

Reverse Accounting Request page to reverse by Payment ID

The following fields are required:

Field or Control

Description

Bank SetID

Enter the bank SetID.

Bank Code

Enter the bank code.

Bank Account

Enter the bank account.

Settle By

Select from these values:

  • Financial Gateway

  • Pay Cycle

Payment ID

Enter the ID for the payment to be reversed.

Source Criteria

This section appears when you select Reverse by Source in the Reverse Accounting Options field.

Accounting entries created for a source for a specific accounting date can be reversed.

This example illustrates the fields and controls on the Reverse Accounting Request page to reverse by source values. You can find definitions for the fields and controls later on this page.

 Reverse Accounting Request page to reverse by Source values

Business Unit, Source Code, and Source ID are required fields for all sources.

Field or Control

Description

Business Unit

Enter a business unit.

Source Code

Select from the values that appear in the following table.

Source Code Values

Criteria Used Identify Accounting Entries

Bank Transfers

EFT Requests

Hedges

Interest

Source ID

Accounting Event Type

Accounting Date

Deal Fees

EFT Fees

Facility Fees

Investment Pools

LC Fees

Source ID

Accounting Event Type

Accounting Date

Sequence Number

Deals

Source ID

Accounting Event Type

Accounting Date

Sequence Number

Line

Leg

Field or Control

Description

Source ID

Enter the source ID.

Accounting Event Type

Select an accounting event type from the list. The values available in the Accounting Event Type list depend on the Source Code selected.

Accounting Date

Enter the accounting date.

Sequence Number

Enter a sequence number.

The Sequence Number value is for multiple like events on the same date (that is, same Business Unit, Source Code, Source ID, Accounting Event Type, and Accounting Date).  For example, two Deal Interim Principal Payments or two Deal Fees.

Line

Enter a deal line to be reversed, if desired.

Leg

Enter a deal leg, if desired.