Tuesday, November 13, 2012

Finacle Commands for Auditors in Bank

Auditors are often review the available reports in the CBS software of the bank branch.They audit through the audit menu and/or with the help of the bank officials. The following list of finacle commands is  only for guidance may little bit vary from Bank to Bank. 
(i) Interest Report for Accounts :  AINTRPT
(ii) Loan Interest Details Inquiry : AITINQ
(iii) Abnormal Transaction Inquiry : ATI
(iv) Bills Inquiry : BI
(v) Rate List History Query : RTHQRY
(vi) Standing Instructions Inquiry : SII
(vii) TDS Inquiry & Printing : TDSIP
(viii) Transactions Exceptions Inquiry : TEI
(ix) Customer Unutilised Limit Inquiry : CULI
(x) Charges Income Report: CHGIR
(xi) Exceptions Report : EXCPRPT
(xii) Report for Matured OD/FD Accounts : ODFDREP
(xiii) Loans Overdue Position Inquiry : LAOPI
(xiv) Loans Repayment Schedule Report : LARSH
(xv) PCFC Balancing Report : PCFCBAL
(xvi) Pending Installments List : PLIST
(xvii) BG Margin Printing : BGMARGIN 

Above referred menus will help in generating the respective reports directly.Besides above certain menus used for verification account wise in system directly as below:
1. ACLI (Account Ledger Inquiry):This function helps to verify the ledger of customers for a given period.
2. ACI (Account Inquiry):
(xviii) Account TOD Inquiry : ACTODI
(xix) Accounts Turnover Report : ATOR
(xx) Insurance Expired Yesterday : INSEXPD
(xxi)Loan Overdue Details : LOANODUE
(xxii)List of Pending and Dishonored Bills : FBPADB
(xxiii)Overdue Foreign Bills : ODFB
(xxiv)Guarantees Expired but not Reversed :  GENR
(xxv)Guarantees Invoked or not Paid : GIPNP
(xxvi)Guarantees Issued Cum Liability Register : GILR
(xxvii)Loan Sanction Limit Review :  LAROR
(xxviii)Insurance Expiry List : INSTOEXP
(xxix)Loan document expiry date :INQLAC
(xxx)Change in sanction limit : CHLMT
(xxxi)Non submitted stock statement : STKSTMT/SRM
(xxxii)Loan account Master report : LAMP
 


This function helps in verifying master data of particular account e.g. in a particular loan account we can verify its Repayment schedule, EMIs, Rate of interest, Overdue Principals, Asset Classification, etc.
 This function is very useful for verification of Loan & Advances. Auditors should invariably verify the data entered in particular account the sanctioned terms even if a single parameter entered incorrectly by Bank, the end report generated will always give wrong information.
 3. LAOPI (Loans & Advances Overdue Position Inquiry):
In the ACI function mentioned above, it gives overdue position in respect of principal
amount only. With the help of LAOPI we can verify Principal as well as Interest
Overdue for a given account.

33 comments:

  1. Thanks a lot for Helping us by sharing this very useful information.

    Anupam

    ReplyDelete
  2. very useful information...thanks a lot...

    ReplyDelete
  3. Very useful to me

    ReplyDelete
  4. can u explain the procedurre of rtgs/neft in my mail id with pdf file....

    abhimanyuraunak@gmail.com

    ReplyDelete
  5. how to print all debit and credit part detail of a single transaction in finacle

    ReplyDelete
    Replies
    1. Use VHCR menu---then give the date---- then put the tran id-------f4-----foreground F----- print advice N-----then press F10. after this you go to PR menu----- then see that tran downloaded report----- the give CTRL+E...... it will take you to the printing section..... there you set the printing parameters----- then----- P---- then F10.
      but for this let ilink should be always open.
      ALL the best

      Delete
  6. how to print all office account credit / debit details between given dates?

    ReplyDelete
  7. can somebody tell me how to post any cash transaction even after day end process is over if cash is not tallied????? some process is der i was thought in training but i forgot can somebody explain frnzzz

    ReplyDelete
  8. F1 report generates excess report .It picks up the excess as given in ACTODM menu. It does not give the true picture since from what date the excess(in case of limits account) or TOD starts.Is there any report which gives the dtae from which the excess or TOD starts.

    Frequently we need to know month wise loan/advances granted by a branch in the category of MSME/Agl/Retail/others. Which menu gives details ?

    ReplyDelete
  9. tell me the proces of bill purchase (BP) in finacle
    step by step

    ReplyDelete
    Replies
    1. in B M menu option P then enter Bill no f4
      then it will show transactions check the a/c no
      then option `A` f4
      note down dc no
      HOPE THIS HELPS : )

      Delete
    2. NPA report which t- code finacle

      Delete
  10. can any1 tell me hw to generate form 15h in finacle (exact procedure)..????

    ReplyDelete
  11. Thanks for sharing sir. What about sbi and allhabad banks. They r not using fonacle. Can u help us plz.

    ReplyDelete
  12. Thank you again for all the knowledge you distribute,Good post. I was very interested in the article, it's quite inspiring I should admit. I like visiting you site since I always come across interesting articles like this one.Great Job, I greatly appreciate that.Do Keep sharing! Regards,
    stopandsaveautorepair.com

    ReplyDelete
  13. How to get report of list of accounts due for review / renewal ? Please help

    ReplyDelete
    Replies
    1. START FROM THE MAIN MENU
      MISREP -ENTER
      BRREP
      CC OD BALANCING
      HERE YOU CAN SEE LIMIT SANCTION DATE & EXPIRY DATE.

      Delete
    2. You can also use LAROR

      Delete
  14. which command help to raise power of user.when officer is on leave any clerk is use his power ,which is officiating which command is use for giving officiatlng

    ReplyDelete
  15. ex: kcc case- sanctioned on 31/3/2017, disbursed on 1/4/2017 , expire date- 31/3/2018. suppose a customer zerorise his limit account with interest on 31/06/2018 and ask for renewal in aclhm menu what shd we do?
    1) shd we consider his next year from 31/3/2018 to 31/03/2019 or 31/06/2108 to 31/06/2019...please explain this in detail ...

    ReplyDelete
  16. Sir plz tell Insurance expired in loans

    ReplyDelete
  17. We are authorized Financial consulting firm that work directly with
    A rated banks eg Lloyds Bank,Barclays Bank,hsbc bank etc
    We provide BG, SBLC, LC, LOAN and lots more for client all over the world.
    Equally,we are ready to work with Brokers and financial
    consultants/consulting firms in their respective countries.
    We are equally ready to pay commission to those Brokers and financial
    consultants/consulting firms.
    Awaiting a favourable response from you.
    Best regards
    WALSH SMITH, ROBERT
    email : info.iqfinanceplc@gmail.com
    skype: cpt_young1

    ReplyDelete
  18. We are authorized Financial consulting firm that work directly with
    A rated banks eg Lloyds Bank,Barclays Bank,hsbc bank etc
    We provide BG, SBLC, LC, LOAN and lots more for client all over the world.
    Equally,we are ready to work with Brokers and financial
    consultants/consulting firms in their respective countries.
    We are equally ready to pay commission to those Brokers and financial
    consultants/consulting firms.
    Awaiting a favourable response from you.
    Best regards
    WALSH SMITH, ROBERT
    email : info.iqfinanceplc@gmail.com
    skype: cpt_young1

    ReplyDelete
  19. We offer certified and verifiable bank instruments via Swift Transmission from a genuine provider capable of taking up time bound transactions.

    BANK INSTRUMENT PARTICULARS

    Instruments :Fully Cash Backed, Fresh Cut Bank Guarantee(Standard ICC format)
    Age :One (1) years and One (1) day
    Rate :Leasing: 4+2, Purchase: 32+2
    Currency :USD/Euro
    Bank :Top A Rated banks
    Amount :As Advised by Beneficiary
    Intermediary Fees : Two Percent (2%) of Face Value payable by Beneficiary
    Tranches : As per agreed tranches schedule
    Delivery : Swift MT799/MT760
    Payment : Swift MT103 (Wire Transfer)

    Contact Name: Thomas Cronin
    Email:dpfinanciallimited@gmail.com
    Whatsapp:+44 151 946 1204

    ReplyDelete
  20. We offer certified and verifiable financial bank instruments via Swift Transmission from a genuine provider capable
    of taking up time bound transactions.
    FOR LEASING OF FRESH CUT BG/SBLC
    MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M
    LEASING PRICE = 4%+2%
    FOR PURCHASE OF FRESH CUT BG/SBLC
    MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M
    PURCHASE PRICE = 32%+2%
    Our BG/SBLC Financing can help you get your project funded,
    loan financing by providing you with yearly.
    RWA ready to close leasing with any interested client in few banking days
    I will be glad to share with you our working procedures.
    Name : Christopher Liam
    Email : trustedfinancemandate@gmail.com
    Skype : trustedfinancemandate@gmail.com
    WhatsApp: +13475948294

    ReplyDelete
  21. We are genuine certified Financial Instrument providers. Presently, we only focus on BG/SBLC for Lease and purchase purposes. Our Lease BG/SBLC is 4+2% and purchase at 32+2%.

    Kindly contact us for our procedures and be sure that we would respond within 48hrs maximum.

    For further inquiry contact: BERRIDGE, Ian

    Email: bizfinleasingltd@gmail.com

    ReplyDelete
  22. We Offer Swift MT760 BG/SBLC, FC MTN,Loan, Letter of Credit { LC }, MT103Etc.

    N/B: Provider's Bank move first.

    Let me know if you have any need for the above offers.

    Thanks

    Whatsapp: +16135085843

    Email: inquiry.trustedfinanceplc@gmail.com

    Skype : inquiry.trustedfinance@gmail.com

    ReplyDelete
  23. Investment is super profiting with the help of a Expert trader runing the trading affairs for you investors has been benefiting , you too can participate and start earning 700% profit weekly from with out stress on USDT, Bitcoin, Ethereum and more . for example

    Invest 200 Euros get 1400 Euros
    Invest 500 Euros get 3500 Euros
    Invest 1000 Euros get 7000 Euros
    invest 2000 euros to get 14,000 Euros

    Platform is 100% genuine contact on WhatsApp: +27633586789 or Email: wilsontradeszone@gmail.com to start earning

    ReplyDelete

Posts Category wise :

      CBS Manual – Finacle Menus/ Commands for your ready reference

 

·         Huge Collection of 938 Finacle Menus

·         286 Selective Finacle Menu options

·         Category wise Commonly used Finacle Menus

·         Finacle Menu options/ Commands for Bank Auditors

·         Frequently used Function keys in Finacle

 

      Customer ID & Account Opening related Menu Options / Commands

 

·         Customer ID creation and Verification in Finacle by using CUMM menu

·         Customer ID creation in finacle in short by using CUMM menu

·         Changing Customer ID of a Customer

·         Account Opening (Savings/Current) in Finacle using menu option OAAC

·         Account opening in Finacle – in short

·         Frequently asked questions related to Customer ID  and Account Opening

 

      Demand Draft / Pay Order related Menu Options / Commands

 

·         Issuing a Demand Draft using Finacle Menu options TM

·         Issuing Multiple Demand Draft / PO using Finacle menu option TM

·         Printing Demand Draft / PO using menu option DDPRNT

·         Cancellation of Demand Draft  in Finacle using menu option DDC

·         Marking a Demand Draft Lost and issuing Duplicate DD

·         Inquiry and Reports finacle Menu related to Demand Draft

 

      Miscellaneous Finacle Menu Options / Commands

 

·         Standing Instruction Maintenance using Finacle Menu Options SIM.

·         Creating a Memo Pad in Finacle Part - I.

·         Creating a Memo Pad in Finacle Part - II.

·         Deleting Memo Pad in Finacle

·         Mass Transaction Posting in Finacle using Finacle Menu option TTUM.

·         Freezing & Unfreezing of accounts in finacle using Finacle Menu AFSM

·         Passbook Printing in Finacle

·         Finacle Teller Cash account Maintenance using Finacle Menu GECM

·         Finacle Menu option TM  for Transaction Posting and Maintenance