Dear Members,
Please post your requirements, suggestions on using excel in Bank Branch Audits.
Thank you
Menu
Bank branch audit 2015 using excel
Replies (7)
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.,
Recent Topics :
- GSTR 9 LATE FEE
- Best Online Mock Test Series for CA Inter January
- COST OF IMPROVEMENT
- Pillows and Mattresses
- GST Applicability for Reg. / Un-Reg. Indian custom
- Amended GST Act & Rules
- FAST DS 2026 MAIL QUERY
- Does Anyone need CA Foundation books of May2026 at
- Last day for ITR-U for AY 2023-2024 (FY 2022-2023)
- Sale of shares in indian company by a non resident
Related Topics :
CAclubindia
