LIVE GST Certification Course by CA Arun Chhajer begins 21st April. Register Now!!

Bank branch audit 2015 using excel

Sanjan (Student) (50 Points)

12 March 2015

Dear Members,

Please post your requirements, suggestions on using excel in Bank Branch Audits.

Thank you

Reply
Follow
Share

7 Replies

Sanjan (Student) (50 Points)
Replied 12 March 2015

Nearly 130 Views and No single Reply?

C.A. P. HAREESH KUMAR (PRACTICE) (375 Points)
Replied 12 March 2015

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

CA ASHIT NATVERLAL DESAI (Chartered Accountants - Proprietor) (129 Points)
Replied 25 March 2015

Sajn

Any Updates on it?

Amit Agrawal (Chartered Accountant) (75 Points)
Replied 29 March 2015

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

sathianarayanan.t (chartered accountant) (267 Points)
Replied 29 March 2015

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.

Ravi Sekar Reddy (CA) (62 Points)
Replied 29 March 2015

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