Bank audit excel tool

Whether this utility would work for all state bank group  ( using BaNCS)

Sir,

     Yes this utility will work both for SBI ,SBH and associated Banks using BaNCS provided the data struture is same during this year also. I have tested the utility on Tweleve Different branches and had no issues till now. I will update the utility if any new problems are found during this year audit.

Mr. Suresh  

Request you to kindly elaborate  the various analysis  to be done after converting into X/L 

It would be really helpful for  members who are  new to Bank Audit  and  those who are not savvy

You may please familarise  us  the use of pivot tables / VLookup  to identify NPAs 

Thanking you  

I have spent significant time in making the utility.Anyway as and when time permits i will surely update the file and make it more advanced.

Follow the blog  for upcoming updates.

I found this excel utility very useful it saved me lot of time, looking forward for more r&d on these type of utilities 

hoping the best

Thank you very much

dear suresh,

i am not able to open yhe link you mentioned.pl.send to murashillin @ gmail.com, if you can.thanks

Upcoming updates..

New link as the old link is not opening properly.

https://auditutilities.blogspot.in

Audit Utility Updated for Allahabad Bank Text files.

Http://auditutilities.blogspot.com

Namasthe,

I am CA Gopi krishna, the link which you have provided is not working. Please send the working link to dsvgopikrishna @ yahoo.co.in

Thank you

i am ca manoj sampat do not able to open link

Sorry, the blog is discontinued. Last year we were alloted a PSB using Flexcube. Most of the banks are providing the files in excel format, So I felt that there is no need of excel utilities for converting text files.