Journal Entry Actions

Use the Journal Entry Actions window to define the General Ledger accounts that are used to generate accounting entries for each combination of deal type, deal subtype, product type, and portfolio within a company. To ensure a balanced ledger, it is critical that accounts and journals are set up completely and correctly.

Note: For some miscellaneous cashflows reported by your bank, you may find the Journal Entry Creation program useful to create journal entries automatically based on information provided in the bank statement.

Defining General Ledger Accounts

Use the GL Accounts tab region of the Journal Entry Actions window to define General Ledger accounts to be used for journaling for each company. You can add new accounts and review existing accounts, but you cannot change or delete existing accounts. Only general ledger accounts defined on the GL Accounts tab region can be selected in the Journal Structures tab.

The available General Ledger accounts derive from the ledger associated with the company.

To review and define general ledger accounts

  1. Navigate to the Journal Entry Actions window.

  2. Query the Company that you want.

  3. If you want to define a new General Ledger account, enter a General Ledger account alias in the GL Account column. Treasury populates the fields with the General Ledger account number and description.

  4. In the Treasury Reference field, you can enter your own description to identify this GL account. The Treasury reference that you enter appears alongside the GL account number in the list of values throughout Treasury.

  5. Save your work.

Defining Intercompany General Ledger Accounts

Use the Intercompany Accounts tab region of the Journal Entry Actions window to review and update the intercompany accounts for intercompany funding deals within a company. These intercompany accounts are used for intercompany transfers and interest charges.

The bank code, currency, account number, and account name of each intercompany funding deal is the counterparty bank account that is used in intercompany deals between the company and the counterparty.

To define intercompany general ledger accounts

  1. Navigate to the Journal Entry Actions window.

  2. Query the Company that you want.

  3. Choose the Intercompany Accounts tab. Treasury displays information for each existing intercompany funding deal.

  4. In the Principal GL field, enter the General Ledger account that you want to use for posting the principal for that company.

  5. In the Interest GL field, enter the General Ledger account that you want to use to posting interest for that company.

  6. Save your work.

Defining the Journal Structure

Use the Journal Structures tab region of the Journal Entry Actions window to set up your journal structure. You define, for each applicable company name, the daily journal entries that you want to generate automatically for each combination of deal type, deal subtype, product type, and portfolio.

You must update journal entries whenever you create a new product type or portfolio, or when you un-authorize a product type.

Attention: To maintain balanced journals, ensure that your debit and credit GL accounts are set up correctly. See: Defining General Ledger Accounts.

To define the journal structure

  1. Navigate to the Journal Entry Actions window.

  2. Query the Company that you want.

  3. Choose the Journal Structures tab.

  4. Query the first Deal Type, Deal Subtype, Product Type and Portfolio combination that you want.

  5. If the journal values do not appear for the selected combination, you can copy values from another combination that has the same deal type by placing your cursor in the Date Type field and choosing the Copy Journal Details button.

  6. Enter or change the Date Type, Amount Type, and Action Code as required.

  7. If you want the journal action to refer to the general ledger number related to the company's cash flow bank account, select the Bank GL check box. Otherwise, enter an account number in the GL Account field.

  8. If this is an intercompany funding deal, direct journal actions to either the principal or the interest General Ledger account number by selecting the Prin GL or the Int GL check box.

  9. These check boxes are only available for non-accrual and non-revaluation date types.

  10. Identify the action as a Debit or Credit.

  11. If necessary, enter the effective dates for this journal action. You can enter a future date in the Effective From field to pre-define a journal action. You can use the Effective To field to deactivate a journal action after the date you specify.

  12. Enter any related Comments.

  13. Save your work.

  14. Repeat steps 5 to 12 for each GL account that applies to this combination.

  15. Repeat steps 4 to 13 for each deal type, deal subtype, product type, and portfolio combination that you want.

Querying General Ledger Accounts

You can review the deal combinations that were set up for a specific General Ledger account.

To query by general ledger account

  1. Navigate to the Journal Entry Actions window.

  2. Enter the company code of the company whose General Ledger account you want to review and choose the Query by GL Account tab. The Find GL Accounts window appears.

  3. Select a General Ledger account and choose the Find button. The journal entry actions for that General Ledger account appear.

Copying General Ledger Accounts

If you are setting up several companies with similar sets of journals, you can copy a set of journals from a company you have already set up.

To copy a general ledger account

  1. Navigate to the Journal Entry Actions window.

  2. Enter the company code of the company you are setting up and choose the Copy GL Accounts tab.

  3. In the Copy From Company field, select the company that has the journals you want to copy.

  4. Choose the Copy Journals button.

  5. Update the appropriate General Ledger accounts and the effective dates.

  6. Save your work.

Defining Hedge Item Accounts

If you are using the Hedging feature of Oralce Treasury to hedge your firm commitments, use the Hedge Item Accounts tab region to enter the GL accounts to journal the underlying exposure's gains or losses. The accounting for the derivative's offsetting losses or gains will be defined on the Journal Structures tab region.

Related Topics