Selecting transactions for unreconciling

This page allows you to search and select bank statements that must be unreconciled. You can carry out a search by specifying the number identifying the bank account, the date range for which the statement must be unreconciled and the range of reference numbers that have been assigned to the transactions after reconciliation. You can also select whether you want to retrieve the details of the bank book or the bank statement. The system retrieves the reconciled details based on the search criteria entered.

This page also allows you to select multiple bank statements or reference numbers that you want to reconcile. The system updates the status of the transactions as “Unreconciled”. The system also unassigns the reference numbers that have been assigned to the transactions after unreconciliation. The system also stores the login ID of the user and the system date along with the transaction details.

Select the “Unreconcile Transactions” link under the “Bank Reconciliation” business component.

The “Select Transactions” page appears.

Select the following fields in the “Search Criteria” group box to search for the transactions in the statement.

Bank Account No.

Use the drop-down list box to select the code identifying the bank account for which you want to unreconcile bank statements and the bank book. All the bank accounts that have been defined in the “Bank Cash Definition” business component for which the user has access rights will be available for selection in the alphabetical order.

The system displays the following:

Bank Name

The name of the bank.

Enter the following fields in the “Search Criteria” group box to search for the transactions in the statement.

Statement No.

The number identifying the bank statement for which you want to unreconcile the transactions (Alphanumeric, 6). The system retrieves all the reconciled bank statements that are in the “Active” status

Note: If a date range has been entered in the “Start Date” and “End Date” fields, the system retrieves all the transactions that fall within the date range.

Start Date

The start date of the period for which you want to retrieve the transaction details of the account (Date Format).

Note: The date entered in this field must be before the date entered in the “End Date” field.

End Date	The end date of the period for which you want to retrieve the transaction details of the account (Date Format).
Display	Use the drop-down list box to select whether you want to view the reconciled transactions in bank statement or the bank book. You can select from “Bank Statement” or “Bank Book”. The system displays the “Bank Statement” by default on launch of the page.
Reference No. From	The starting number identifying the reference in the range of reference number, from which you want to retrieve the reconciled transaction (Alphanumeric, 18).
To	The ending number of the reference number in the range of reference number till which you want to retrieve the reconciled transactions (Alphanumeric, 18). The number entered here must be greater than the number entered in the “Reference No. From” field.

Note: If the statement number is not entered and the start date and end date is entered, then the system retrieves all the reference number falling in that period.

Click the “Search” pushbutton to retrieve the transaction details.

The system retrieves and displays the following in the “Search Results” multiline based on the search criteria entered:

Bank Code	The code identifying the bank.
Statement No.	The number identifying the bank statement.
Reference No.	The reference number assigned to the transaction after reconciliation.
Date	The date on which the transactions were posted.
Transaction Amount	The total transaction amount.
Reconciled On	The date on which the transactions were reconciled.
Reconciled By	The login ID of the user who reconciled the transaction.

Note: Atleast one row in the multiline must be selected for unreconciliation.

Check the box in the “Select” column of the multiline to mark the bank statements that must be reconciled.

Note: You cannot unreconcile transactions that form part of a bank statement or bank book for which the reconciliation has been completed.

Click the “Unreconcile Transactions” pushbutton to unreconcile the selected transactions

The system updates the status of the transactions as “Unreconciled” in the bank statement or the bank book. The system removes the reference number assigned to the reconciled transaction. The system stores the login ID of the user and the system date along with the modified details.

To proceed, carry out the following

Select the “Un Reconcile Transactions” link at the bottom of the page to unreconcile transactions.

Prerequisite

The transactions must be reconciled in the “Reconcile Transactions” activity of this business component.

What you can do in this page

Retrieve transaction details depending on the selection

You can retrieve the transaction details in the multiline for unreconciliation based on the selection in the “Display” field.

Select the “Bank Statement” option in the “Display” field for retrieving the statement details.
Select the “Bank Book” option in the “Display” field for retrieving the bank book details.