Dear Members,
Please post your requirements, suggestions on using excel in Bank Branch Audits.
Thank you
7 Replies
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
Recent Topics
- Nznxnc call me at the end of the day of the
- Cp chod doob zoom vo book book
- Nsje snswk fjw ed le ene djff ne enje ejdd rejje
- Hxjcif the day I have been in touch with me and
- Iska djd djrbdsjebshe sir ur rei ejr reinr the jr
- GST registration for medical shop in Karnataka
- Hsshs me know if you are free number of the
- Chu Kang and the situation of the situation and I
- How to reverse wrong transaction payment in phonep
- Paytm wrong transaction
Related Threads
CAclubindia
