|
|
|
|
|
|
This activity allows you to manually enter the bank statement for reconciliation. Tell me more.
Select the “Create Bank Statement” link under the “Bank Reconciliation” business component.
The “Create Bank Statement” page appears.
Select the following field in the “Statement Information” group box:
|
Bank Account No. |
Use the drop-down list box to select the code identifying the bank account. All the account numbers that have been defined in the “Bank / Cash Definition” business component for which the user has access rights will be available for selection. The system displays the first bank account by default. |
The system displays the following:
|
Bank Name |
The name of the bank. |
Enter the following fields:
|
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 unique number generated by the system at the time of creating the bank statement. |
Enter the following fields:
|
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.
Note: If the identifier selected is credit, then the derived closing balance is the corresponding negative value.
Click the “Download” pushbutton to retrieve the transaction details from the external source.
Enter the following fields 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 Debit” or “Service Charges”, then the derived amount is the corresponding negative value.
The system displays the following:
|
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.
Enter the following fields:
Note: The pay in slip must correspond to the bank account and the bank code.
|
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 (Alphanumeric, 18). The pay in slip must be defined in the “Create Pay-in-Slip” activity of the “Realize Receipt” business component. This field is mandatory if the “Transaction Type” selected is “Receipt” or “Service Charges”. |
|
|
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.
Check the box in the “Select” column of the multiline to mark the transaction type for deletion.
Click the “Compute Running Total” pushbutton to calculate the running number.
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.
Click the “Create Bank Statement” pushbutton to create the bank statement.
Note: The running balance in the last row must be equal to the derived closing balance.
The system generates a unique number identifying the bank statement. The system updates the status of the bank statement as “Active”. The system also stores the login ID of the user along with the statement details.
The bank account number must be defined in the “Bank Cash Definition” business component.
The check number must be defined in the “Release Payment” business component.
You can select the type of transaction for which you want to enter the transaction amount.
Set the “Transaction Type” field to “Payment” if you want to enter a payment transaction amount.
Set the “Transaction Type” field to “Check Payment” if you want to enter a check payment transaction amount.
Set the “Transaction Type” field to “Receipt” if you want to enter a receipt transaction amount.
Set the “Transaction Type” field to “Check Receipt” if you want to enter a check receipt transaction amount.
Set the “Transaction Type” field to “Interest Paid” if you want to enter a transaction amount for the interest paid.
Set the “Transaction Type” field to “Interest Received” if you want to enter a transaction amount for the interest received.
Set the “Transaction Type” field to “Service Charges” if you want to enter a service charges transaction amount.