Saturday, 27 December 2014

Finacle Commands for concurrent auditors Page 6: How to Check “General Ledger” of a bank

                With the help of finacle dealing with complex banking transactions has become much easier but as a concurrent auditor if you don’t know how to use it, its utility is nil to you and it will make your head to ache. In my first experience with finacle during the initial days of conducting ConcurrentAaudit of a bank I also faced the same scenario. I was on the first interaction page wondering what to do with this software, but with the help of my Principal I developed a smooth hand on its use and learnt a lot about it. It is much easier to use than it seems to you when you first visit a bank for audit purposes. Here I’m going to share its use and help those who are at the same stage this time as I was before a couple of years.

Some of the aspects Concurrent Auditors have to take care of:
  • Overdrafts:
  • Cash:
  • Documentation and KYC:
  • Pending Installments of Term loans:
  • Cash Credit accounts operating conditions:
  • Observation on information system(maintenance, operating, internal control etc):
  •  Verification of high value and unusual transactions:
  • Insurance Business:

And more based on the type of bank and type of branch in the bank.



Most Used Finacle Commands which are a must to learn for beginners.
  • Acs – Account selection
  • Acli – Account ledger inquiry
  • Ato – Account turnover
  • FTI -  Financial Transaction inquiry
  • Laopi – Loans and advances outstanding position inquiry
  • Lrp    -   Limit liability report
  • CUMI  -  Customer Master Inquiry

How to Check “General Ledger” of a bank
Concurrent Auditors need to check the balances of different accounts, at the end of each Month and report the same in banks Comparative Position and other fields during the course of audit.
Following if the bird’s eye view of what will be covered through this section.
Total Balance of Deposits at the Month End.
Total Balance of Advances at the Month End.
Total Balance of Assets at the Month End. And more
Lets check out how to open GL in Finacle:
Step 2. On the first interaction page of Finacle enter “gr”  in the menu options’ option box and press ENTER
Step 3. Generate report menu will open up, Enter Report No. as GL (or GLNET) and Report To. as M and press F4
Step 4.  Next page will open up with first option as GL Balance Date enter Date of last day in the month (31/12/2014 in case of DEC 2014), Enter Y or N as per your need in Net Bal. (if you need net balances enter Y if not press N) and Enter INR in CCY for which GL is required and Press F10.
                Now a new sub menu will open up, with first option as Fore/Background enter F (which stands for Fore) also enter N in Print required Field (Recommended but keep it on Y if you want to take a hard copy print) and Press F10 again.
Step 5. Now press F5, Background Menu will open up, enter Option 9 and press F4.
Step 6. Above Step will lead you to next page, enter T (which stands for type) and Press F10.

                Here you are, this is the General ledger, Now Press + to go to next page, - to go to prev page, q to quit:

2 comments:

  1. Cusmor not kyc complaint error while running stcon menu

    ReplyDelete
  2. How to get a list of NPA accounts with IRAC status of each account on any recent date ? Also how to generate a list of "Special Mention Accounts" demarcating S-0, S-1, S-2, etc. on any recent date.

    ReplyDelete

Tell Us What You've Got...