This activity allows you to view and confirm the bank reconciliation statement. This activity allows you to confirm the completion of the reconciliation of the bank statement and the bank book. You can select the number identifying the bank account for which you want to confirm the reconciliation for a particular date. You can also set whether you want to view the details of the additions or deductions that have been made to the balances. The system updates the status of the reconciliation as “Completed”. The system also stores the date of reconciliation along with the reconciliation details..
Select the “Confirm Reconciliation” link under the “Bank Reconciliation” business component.
The “Confirm Bank Reconciliation Statement” page appears.
Enter the following field in the “Bank Information” group box:
Bank Account No. |
Use the drop-down list box to select the code identifying the bank account. The bank account number must be defined in the “Bank Cash Definition” business component. All the bank accounts that have been defined 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:
Display |
Use the drop-down list box to select whether you want to view the details of the addition or the deductions made to the bank balance. You can select from “Addition To Bank Balance” or “Deduct From Bank Balance”. |
As On Date |
The date on which the bank reconciliation takes place (Date Format). Mandatory. |
The system displays the following:
Bank Balance |
The balance as per the bank statement. |
Total Addition |
The amount that has been added to the balances subsequent to receipts of payments from suppliers, customers or services. |
Note: The system displays sum total amount from the “Supplier Receipt”, “Sundry Receipt”, “Customer Receipt”, “Realized Receipt”, “Service Charges” and “Payments” that have been included to the balances.
Total Deduction |
The amount that has been deducted from the balances subsequent to payments made to suppliers, customers or interests. |
Note: The system displays sum total amount from the “Supplier Payment”, “Sundry Payment”, “Customer Payment”, “Interest Received” and “Receipts” that have been deducted from the balances.
Book Balance |
The total balance as per the bank book. The system displays the total of the posting accounts from the finance book processing business component. |
Difference |
The difference arising on reconciliation. The system displays the difference as the sum of the bank balance, total additions less the total deductions and the bank book balance. |
The system displays the following in the multiline:
Note: The system retrieves the transaction details based on the option selected in the “Display” field.
Transaction Type |
Indicates the type of the transaction. It could be “Payment”, “Check Payment”, “Receipt”, “Check Receipt”, “Interest Paid”, “Interest Received” or “Service Charges”. |
Date |
The date on which the transaction occurred. |
Depositing Point |
The code identifying the organization unit in which the transaction occurred. |
Pay-In-Slip No. |
The number identifying the pay in slip. |
Prefix |
The prefix identifying the check number. |
Check No. |
The number identifying the check. |
Amount |
The transaction amount. |
Remarks |
Any comments given during reconciliation. |
Company Reference |
The code identifying the company that is involved in the transaction. |
Click the “Complete Reconciliation” pushbutton to complete the reconciliation.
The system updates the reconciliation status to “Completed”. The system updates the date of reconciliation to the date entered in the “As On Date”.
Click the “Print BRS” pushbutton to print the reconciliation details.
You can view the reconciled statement.