Reconciling Externally Generated Transactions

This section discusses how to enter external transactions for reconciliation and reconcile the external transactions automatically.

Page Name

Definition Name

Usage

External Transactions Page

BNK_RCN_TRAN_UPDT

Modify or insert additional external transactions for a bank account. You also use this page to add new external transactions.

Process Reconciliation Page

BANK_RECON_REQUEST

Run the Bank Reconciliation process to reconcile the transactions automatically.

See the Process Bank Reconciliation Page for more information.

To enter external transactions for reconciliation, use the External Transactions component (GEN_TRAN_UPDT).

Use the TR_EXTERNAL_TRANSACTIONS_CI_V2 component interface to load data into the External Transactions tables.

The Bank Reconciliation process flags bank transactions (such as overdraft fees, interest, or other miscellaneous fees) as MISC (miscellaneous) exception items because there are no corresponding system transactions. By associating statement activity types with these items, Treasury Management generates accounting entries for them when you force them to reconcile based on the ChartFields that are specified in the accounting template that is assigned to the statement activity type.

In addition to processing these types of transactions, you can also enter transactions online using the External Transactions page or insert them into the Bank Reconciled Transactions (BNK_RCN_TRAN) table, which corresponds to the External Transactions page. After you enter the transactions, you run the Bank Reconciliation process to reconcile them automatically. The process tries to match them to corresponding bank transactions.

Use the External Transactions page (BNK_RCN_TRAN_UPDT) to modify or insert additional external transactions for a bank account.

You also use this page to add new external transactions.

Navigation:

Banking > Reconcile Statements > External Transactions

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

 External Transactions page - Transaction Header tab

Search Criteria

To view a list of external transactions, enter your search criteria and click Search.

External Transactions

The External Transactions grid displays existing transactions that meet your search criteria.

A transaction is unavailable for edit if you have reconciled it.

Transaction Details

Select the Transaction Details tab.

This example illustrates the fields and controls on the Transaction Details tab of the External Transactions page. You can find definitions for the fields and controls later on this page.

 External Transactions page - Transaction Details tab

Field or Control

Description

Tran Code (transaction code)

Indicates the type of transaction, such as fee or interest.

Accounting Template ID

Specify the accounting template that the system uses to generate the correct accounting entries.

VAT

Click to view information on the Treasury VAT Processing page. This link is available only when the transaction meets the following conditions:

  • The business unit is VAT enabled.

  • A VAT-enabled transaction code is defined for the transaction type (currently limited to fee, F).

  • A VAT-enabled accounting template is defined for the accounting template.