1.Statutory Bank Branch Audit through remote location.
2.Reports which we can consider from bank branch for identification of sample through various analysis from remote location.
| S.No. | Report description from Core Banking Environment | Details for Analysis |
|---|---|---|
| 1. |
Balance Report (BR) in Details
(This file covered all account which belong to fund base of the branch) (please ensure that this file required in details format which approx 750 to 1000 pages) - |
Balance Report covers all fund base accounts in branch, we can convert these report into excel format and then we can arrange date wise balance reports (either month wise or Qtr wise etc) with various excel commends for analysis … Major head in which we can take as
|
| 2. | BG/LC/FLC/Bill Balance /Non Fund Business Report (Opened during the year) & (as on Balance Sheet Date) | Converted into tabular format and co- related account with BR Account and applied link with revenue in respective A/c ledger |
| 3. | GL/PL/BS (General Leger Balance Report/Profit and Loss /Balance Sheet) |
This is summary of BR which we can Analysis on month- on-month or quarter-on -quarter.. Converted respective month report in tabular format and analysis trend, with respective details can again verified in BR report, if after that still not clear about that, might be covered for sample verification. |
| 4. | Advance Account dump with mandatory details of ROI, Scheme Code, Security, Last Renewal, Sanction Amount, Sanction Date… | Advance details to analysis with conversion in excel with identification of file for details verification in branch as well as remotely.. Most of Big Note prepare in soft format so we can verified details note on remotely also…further we can link BR Analysis for trend analysis in account to find status of SMA or PNPA with actual recovery/repayment made in account |
| 5. | Jotting of new advances account sanctioned renewed, enhanced, disbursement made during the year (for the Year) | Month on Month NPA report converted into excel and through VLookup function we can analysis of Trend about NPA Movement. |
| 6. | NPA | Best to cover every month/quarter ended report in tabular format. Also link with BR report about any movement in balance by month – on – month… in case of major change need to cover full leger account about adjustment of credit in account i.e. against interest or principal… |
| 7. | Interest Failure Report (as on 31.03.2020) | Check about any account skip for application on applied interest |
| 8. | List of dormant accounts/ Non Active Account as on 31.03.2020 and report of Dormant to Active and Active to Dormant (During the year 01.04.2019 to 31.03.2020) | Link with BR Report and analysis trend in these account if any normal and ab-normal difference month to month |
Copyright ©2024 Data Bolta Hai
0 Comments