Modifying bank statement

This page allows you to modify the statement information and the transaction details of the bank statement. This page allows you to modify the details of the selected bank statement. You can modify bank statements that are in the “Active” status. This page also allows you to add new transactions to the statement. You can modify the opening / closing balance and the date range of the statement. You can also modify all the transaction details. The system saves the modifications made. The system recomputes the running balance for each of the transaction based on the modifications made. The system stores the login ID of the user and the system date along with the modified details..

Select the data hyperlink available in the “Select Bank Statement” page.

The “Edit Bank Statement” page appears.

The system displays the following in the “Statement Information” group box:

Bank Account No.	The number identifying the bank account.
Bank Name	The name of the bank.

Modify the following fields if required:

Statement Start Date	The start date of the statement (Date Format). Mandatory. The date entered in this field must be before the date entered in the “Statement End Date” field.
Opening Balance	The opening balance of the bank statement as on the date entered in the “Statement Start Date” field (Decimal). Mandatory.

Use the drop-down list box to select the type of opening balance. You can select “Debit” or “Credit” based on the type of the opening balance. The system displays “Dr” by default on launch of the page.

Note: If the identifier selected is credit, then the derived opening balance is the corresponding negative value.

The system displays the following:

Statement No.

The number identifying the bank statement.

Modify the following fields if required:

Statement End Date	The statement end date (Date Format). Mandatory. The date entered in this field must be before or the same as the system date.
Closing Balance	The closing balance of the bank statement as on the date entered in the “Statement End Date” field (Decimal). Mandatory.

Use the drop-down list box to select the type of closing balance. You can select “Debit” or “Credit” based on the type of the closing balance. The system displays “Dr” by default on launch of the page.

Modify the following fields if required in the “Transaction Details” multiline:

Transaction Type	Use the drop-down list box to select the type of the transaction that has taken place in the account. You can select from “Payments”, “Check Payment”, “Receipt”, “Check Receipt”, “Interest Paid”, “Interest Received” or “Service Charges”.
Date	The date when the transaction occurred (Date Format). Mandatory. The date entered in this field must be after the start date of the statement but before the current system date.

Note: The first date entered could be the same or after the start date of the statement. The date entered in the second or third row of the multiline could be the same or after the date entered in the previous row.

Remarks	Any comment pertaining to the transaction type (Alphanumeric, 256).
Check No.	A unique number identifying the check (Alphanumeric, 30). The check number must have been defined in the “Release Payment” business component.

Note: This field must not be left blank if “Check Payment” has been selected in the “Transaction Type” field.

Amount

The transaction amount (Decimal). Mandatory. This amount must be less than the pay in slip amount.

Note: If the transaction type selected is “Payment”, “Interest Paid” or “Service Charges”, then the derived amount is the corresponding negative value.

The system displays the following field:

Running Balance

The running balance of the account. The system calculates the running balance in the first row as the sum of derived opening balance and the derived amount in the first row. The running balance in the other rows is the aggregate of the running balance in the preceding row and the derived amount in that row.

Note: The running balance in the last row must be equal to the closing balance.

Modify the following fields if required in the “Transaction Details” multiline:

Depositing Point

The code identifying the organization unit in which the transaction has occurred (Alphanumeric, 16).

Note: This field must not be left blank if “Receipt” or “Service Charges” is selected in the “Transaction Type” field.

Pay-In-Slip No.	The number identifying the pay-in-slip through which the payment has been deposited in the bank (Alphanumeric, 18). The pay-in-slip must have been defined in the “Realize Receipt” business component. The number entered in this field must belong to the selected bank account number.
	Help facility available.

Note: This field must not be left blank if “Receipt” or “Service Charges” have been selected in the “Transaction Type” field.

Company Ref./LC Number/EFT No

The code identifying the company/ LC Number/EFT No that is involved in the transaction (Alphanumeric, 30).

Note: This field must not be left blank if “Payment” or “Service Charges” have been selected in the “Transaction Type” field.

The system displays the following:

Status

The status of the transaction. It could be either Reconciled or Un-Reconciled.

Click the “Compute Running Total” pushbutton to calculate the running balance of the account.

The system calculates the running balance in the first row as the sum of derived opening balance and the derived amount in the first row. The running balance in the other rows is the aggregate of the running balance in the preceding row and the derived amount in that row.

Note: The running balance in the last row must be equal to the derived closing balance.

Note: Opening Balance and Closing Balance cannot be modified if a subsequent bank statement exists in reconciled status.

Click the “Edit Bank Statement” pushbutton to save the modification made.

The system saves the modifications that have been made to the bank statement. The system also updates the login ID of the user and the system date to the “Last Modified By” and “Last Modified Date” field.

The system displays the following:

Created By	The login ID of the user who created the bank statement.
Created Date	The date on which the bank statement was created.
Last Modified By	The login ID of the user who last modified the bank statement.
Last Modified Date	The date on which the bank statement was last modified.