Scribd Logo
Upload

Welcome to Scribd!

  • 48 views

    2 Most Usefulcommands and Options Auditors

    Uploaded by

    Bhuvan
    This document provides guidance for bank branch auditors on useful commands and reports in the Core Banking System (CBS) for conducting audits. It lists SMA reports, special watch category reports, account details accessed by CIF number, and audit options in Finacle. It also provides lists of system generated reports in CBS for advances, NPAs, deposits, bills, loans, and returns. Finally, it outlines some commands in the BANCS software for verifying customer and account details, printing statements and repayment schedules, and getting balance breakups. The document is intended for guidance purposes only as menu codes and options may vary by bank.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    2 Most Usefulcommands and Options Auditors

    Uploaded by

    Bhuvan
    48 views5 pages
    This document provides guidance for bank branch auditors on useful commands and reports in the Core Banking System (CBS) for conducting audits. It lists SMA reports, special watch category reports, account details accessed by CIF number, and audit options in Finacle. It also provides lists of system generated reports in CBS for advances, NPAs, deposits, bills, loans, and returns. Finally, it outlines some commands in the BANCS software for verifying customer and account details, printing statements and repayment schedules, and getting balance breakups. The document is intended for guidance purposes only as menu codes and options may vary by bank.

    Original Description:

    Most Useful commands and Options Auditors Finacle Version 7

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides guidance for bank branch auditors on useful commands and reports in the Core Banking System (CBS) for conducting audits. It lists SMA reports, special watch category reports, account details accessed by CIF number, and audit options in Finacle. It also provides lists of system generated reports in CBS for advances, NPAs, deposits, bills, loans, and returns. Finally, it outlines some commands in the BANCS software for verifying customer and account details, printing statements and repayment schedules, and getting balance breakups. The document is intended for guidance purposes only as menu codes and options may vary by bank.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    48 views5 pages

    2 Most Usefulcommands and Options Auditors

    Uploaded by

    Bhuvan
    This document provides guidance for bank branch auditors on useful commands and reports in the Core Banking System (CBS) for conducting audits. It lists SMA reports, special watch category reports, account details accessed by CIF number, and audit options in Finacle. It also provides lists of system generated reports in CBS for advances, NPAs, deposits, bills, loans, and returns. Finally, it outlines some commands in the BANCS software for verifying customer and account details, printing statements and repayment schedules, and getting balance breakups. The document is intended for guidance purposes only as menu codes and options may vary by bank.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    P.

    Selvamoorthy

    Most useful commands / options for Bank Branch Auditors

    1. SMA Reports (Sl.No, GL Name, Account No, Account Name, NPA Date, New-IRAC,
    Old-IRAC, Balance, drawing limit, overdue, MOI, Security value, STK-EXP-DT)
    (Remarks interest not serviced / irregular, part recovery)
    SMA – 0 Not overdue for more than 30 days but account showing signs of stress
    SMA – 1 Overdue between 31 to 60 days
    SMA – 2 Overdue between 31 to 90 days
    Information to CRILC (Central Repository of Information on Large Credits) setup by
    RBI – Exposure greater than Rs.50 million
    2. Special watch category report
    3. Viewing details using CIF No (Unique Customer ID) from CBS server (Production
    server)
    a. In “60450” screen, enter Customer A/c No or CIF Number
    b. Two tabs will appear
    c. In first tab customer details can be viewed
    d. In second tab, all the accounts linked to the given CIF number can be viewed.
    4. Finacle – Audit options

    Verification Menu Code


    Account Scrutiny ACLI
    Customer Master CUMM
    Account Level Inquiry ACM / ACI
    Transaction Inquiry TI / TM
    Fin. Tran. Inquiry – Criterion Search FTI
    Inquire on Transaction (Office Accounts) IOT
    Bills Module (Inland) BM
    Foreign Bills Module – Single Case FBM
    Foreign Bills Inquiry – Criterion Search FBI
    Guarantee Inquiry GI
    Query on Documentary Credits - Criterion Search DCQRY
    Docu. Credits (LC) Maintenance Module ODCM

    1
    P.Selvamoorthy

    Account Search based on predefined Criteria – (May not be available ACS


    or Slow)
    TDS Inquiry TDSIP
    Pending Installment List PLIST
    Loan Overdue Position Inquiry LAOPI
    Account Turnover Report ATOR
    Verification Menu Code
    TOD Inquiry – Account specific ACTODI
    List of Pending and Dishonored Bills FBPADB
    Security Register Maintenance SRM
    Limit Tree Lookup LTL
    Limit Node Inquiry LNI
    Account Limit History Maintenance ALHM
    Balancing Report for Bills Purchased (Inland) BRBPR
    Balancing Report for Bills Purchased (Foreign) FBBR
    TOD Register Printing TODRP
    Customer wise TDS Report TDSREP
    Import Register Report FBIR
    Office Account Ledger Printout ACLPOA

    The list is only for guidance and the menu codes may not be applicable in all the banks.

    5. List of system generated reports

    Report Modified
    No CBS Report Report Generation Path
    Report No
    Report on monthly sanctions and
    ADA1BM rejections by ABREP/ADVANCES/ADA1BM
    BM
    NPAREC Statements of Recoveries in NPA ABREP/ADVANCES/NPAREC

    Statement of Excess Drawing


    STEDA Allowed ABREP/ADVANCES/STEDA

    BMR Basel Master Report ABREP/BASEL/BMR

    BGENC List of BGs Expired but not closed ABREP/BG/BGENC


    2
    P.Selvamoorthy

    LISTDUE List of import bills due for ABREP/IMP BILLS/LISTDUE


    crystallization/payment
    LCOUR List of outstanding LC ABREP/INLAND LC/LCOUR

    Age wise analysis of bills cheques


    AGEWISE O/S ABREP/INLD BILLS/AGEWISE

    CASHRET Cash Retention Exceeding limit ABREP/CASH/CASHRET

    PNLREP Profit & Loss Analysis Report ABREP/DAYRPT/PNLREP

    Accounts opened with Preferential


    TDPREF Rates ABREP/DEPOSIT/TDPREF

    Interest payment and TDS at


    TDSIPT source ABREP/DEPOSIT/TDSIPT

    AAOEBRP Party wise list of O/S Bills. ABREP/EXP BILLS/AAOEBRP

    PWOBD Party wise collection O/S Bills ABREP/EXP BILLS/PWOBD

    Clean Foreign Bills purchased


    CFBPO PCOSR outstanding. ABREP/I/W REMITT/PCOSR

    LCWISE List of Bills for L/C ABREP/IMP BILLS/LCWISE

    OUTIMP Outstanding Imports LC. ABREP/IMPORT L/C/OUTIMP

    LCEXP List of LC Expired Party wise. ABREP/INLAND LC/LCEXP

    CHRDBT Charges not debited report ABREP/INSPECTION/CHRDBT

    Applied interest is not in


    APPINT agreement with the ABREP/INSPECTION/APPINT
    interest table attached.
    Report of Deposit loans with
    DPLOAN security matured ABREP/INSPECTION/DPLOAN

    LOCKRENT Locker rent due report ABREP/LOCKER/LOCKRENT

    Statement of Potential NPA


    A.PNPA PNPA_NEW Accounts ABREP/NPAREP/PNPA_NEW

    K.NPAMOV G.1-Movement of NPA ABREP/NPAREP/K.NPAMOV

    OPCL Overdue PCL Advance ABREP/PC/OPCL

    OPKCL Outstanding PCl Loans ABREP/PC/OPKCL

    3
    P.Selvamoorthy

    Statement of Recoveries in
    RECWOFF NPA/Written off ABREP/RETURNS/RECWOFF
    Accounts
    AS17WRKI* AS17WRK1 Worksheet for Segment Report ABREP/RETURNS/AS17WRK1

    Overdues, breakup in Principal,


    ODILAC Interest, ABREP/ADVANCES/ODILAC
    Charges
    STEDA Excess Drawings ODCC ABREP/ADVANCES/STEDA

    ACRESUME Account resume for C.C.OD IT IS DIRECT OPTION.

    PCResume Account resume for PC IT IS DIRECT OPTION.

    CHRDBT Charges not Debited ABREP/INSPECTION/CHRDBT

    6. BANCS Software Commands

    Verification Menu Code

    To verify all accounts of one Customer --> Enquiries -->Search by


    CIF Number
    To verify the Account Master -->Enquiries -->Deposit / CC / OD Account
    Details

    Printing Statement of Account for a Deposit or -->Enquiries -->Statement Print


    CC / OD

    Basic details on Enquiry on Screen on Deposit -->Enquiries -->Short


    Accounts

    Additional Details on Enquiry Screen for -->Enquiries -->Long


    Deposit Accounts

    Report of Cash Transactions –Tellerwise -->Reports-->Printing


    Reports-->Cashier / Teller
    Cash Report
    To print Repayment schedule for a DL / TL -->DL/TL Accounts & Services
    Account Loan Processing-->Generate
    Repayment Schedules--> Action – “E”
    To view amount of Arrears & Breakup of -->DL/TL Accounts & Services
    Principal Interest Realized, Charges & Arrear of Enquiries-->Short-->Option
    Interest “Balance Breakup Enquiry”

    4
    P.Selvamoorthy

    To find Collateral Number -->DL/TL Accounts & Services


    Security (Primary / Collateral)
    Customer-->Enquiry--> Enquire--> Security
    Summary

    Disclaimer

    • These Commands / options in CBS Software are likely to vary entity to entity
    • Images, Logo, Screen Shots, Menu Codes, Software Name etc are the property of
    respective Software developer / Trademark owners.
    • The information contained in the presentation is not for commercial purpose. It is
    merely for guidance

    You might also like