Bank branch audit 2015 using excel

Nearly 130 Views and No single Reply?
 

Yes Sajan I am keen to get  acquainted  with  use of  X/L  in identifying NPA  during Bank Audit  

For  Lot of others  also  it would be helpful 

Whatever way you can help  pl help  

Sajn

Any Updates on it?

Use of Excel for identifying areas of over exposure / above drawing limit is welcome area for us for reporting npas.

All the banks have different structures in their .txt file of important reports. It is difficult to create a single tool to be used in all the banks. Tool for converting .txt file into .xls is useful for audit analysis. Some analysis requires pivot table. Mr. Sanjan you have to create different macros for different banks.

Sathianarayanan Sir, i agree with your view.  But by analying the text file that is created already with some set of parameters in core data and our alalyses also will reveal the same result of NPA by whatever the tool used to analyse the data. We would not analyse the text reports we have to analyse the data from core with our tool to know the NPA from our side on different dates and compare.  Is there a possibility to change the parameters on 31st and after day end is our they can restore the parameters again to original position.  How to check these things if  it happens,

Members can through light on this.

Regards

The text files are useful not only for identification of NPA, but also other reporting requirements like TDS Complaince, Cash Certificate etc.,