Bank Reconciliation Statement in Retail POS Accounts

Bank reconciliation menu screen is used to update the clear date to bank cheque payment and also this screen will show all the transaction which is done through the bank.

Business rules

• There should be the bank reconciliation menu under the banking module for user to update and view the bank transactions.
• User will open that bank reconciliation statement screen to update clear date for bank cheque numbers and also user can find other bank transaction with cleared date.
• In this screen user can find the filters like bank name, bank statement date range (from and to date), cheque date (from and to date) and clearance type (All, cleared cheque, uncleared cheque).
• After filter, system will load the cheque details, user can find the column to update clear date for each uncleared cheque.
• User can enter the clear date and press enter to update the clear date.
• If user wants to edit the clear date, user just need to remove entered cleared date and press enter to update.
• This bank reconciliation statement (BRS) and real time bank statement from the bank should be matched for better bank transaction tracking.

Auto reconciliation

Auto reconciliation is the process of uploading the downloaded E-statement from the bank to our accounts BRS screen. So system will update the clear date automatically from the uploaded E-statement.

Business rules

• In BRS screen, user can find the function key called “auto reconcile”, press that function key.
• Once auto reconcile is pressed, then there should be a popup where user can browse the E-statement in excel or csv format.
• The browsed excel data should be shown in popup screen with every column.
• Then user will map the system column name against each excel column.
• The created E-statement excel sheet should have the columns like cheque number, cleared date, amount, Cr amount, Dr amount and Cr/Dr.
• After mapping the columns, user will press the function key called “update” which is in popup screen.
• Then system will automatically show the number of cleared date is matched and updated. Also user can find the auto updated cleared date.
• For cleared date not updated rows, user need to update the details manually.