If in Cash Management you have defined bank accounts for use in Treasury, you can enter the bank statements for such bank accounts manually in Treasury

It is recommended that you import or enter manually bank statements for reconciliation in Cash Management, see: Importing Bank Statements. However, if you want to reconcile the Retail Term Money deals, you will need to record bank statements in Treasury.

Entering Bank Statements Manually

Use the Manual Statement Input window to manually enter bank statement information. You can also use this window to enter a sub-statement for a transaction on your bank account. For example if your statement includes an employee loans item, you can create a sub-statement to break that item down into individual loan amounts, by employee.

You can only input one bank statement per date for each account number.

You can add information to or change a statement anytime before it is transferred for reconciliation. Once you transfer a statement for reconciliation you cannot make any further changes.

To enter a bank statement manually

1. In the Source field of the Manual Statement Input window, select the bank account for which you are entering information. Values appear in the Account Name, Account Number, Currency, and Created By fields based on the account you selected and your user id.

2. In the Value Date field, enter the date the statement was issued. The date in the Created Date field is the current system date.

3. For each transaction on the statement, enter the transaction details as follows:

   • Complete either the Cparty field or the Particulars field. If the bank statement lists the counterparty for the transaction, in the Cparty field, select the counterparty. If the bank statement does not list the counterparty but does list another way to identify the transaction, such as a deal number, in the Particulars enter that value.

   • Select a transaction type.

   • In the Amount field, enter the amount of the transaction.

   • Enter comments for the transaction as needed.

4. Save your work. The total amount of debits and credits appears in the Trailer region of the window. This region also displays the total number of transactions in the statement.

Transferring Bank Statements

If you want to reconcile your bank statements in Treasury, you must run a concurrent request to transfer those bank statement.

To transfer a statement for reconciliation

1. In the Manual Statement Input window, query the statement you want to transfer.

2. Choose the Transfer File button. A concurrent process transfers your bank statements for reconciliation.

3. If your bank statement transfer is unsuccessful you must correct the statement in the Manual Input Statement window and re-transfer it. Once a bank statement is successfully transferred you cannot make any further changes to it.

Viewing a Summary of Unsuccessfully Transferred Bank Statements

Use the Transfer Errors window to view a list of bank statements that were not transferred successfully.

To view a list of statements which were not transferred successfully

• In the Manual Statement Input window, choose the Show Errors button. The Transfer Errors window appears, listing details for each incorrect record and a description of each error.

Viewing Bank Statements

Use the Manual Statement Input window to view the details for a bank statement. You can only view bank statements that have not yet been transferred for reconciliation.

To view the details for a bank statement

• In the Manual Statement Input window, query the bank statement you want to view.