If
you are and auditor of any of the branches of State Bank of India, here
is a program an Excel Sheet named “Bank Audit SBI XL Tools” containing
some utility program for you to help in your audit work.
This file will be helpful for Auditors of State Bank of India to import text files namely Loan file, CC_OD file and NPA statement to a well formatted excel spread sheet within seconds. And you can also analyze other accounts of NPA borrowers
easily. Basically it is an Excel Worksheet programmed using macro and
Visual Basic. Before you start working with this program, please ensure that macros are not disabled in your system.
It is very important for the smooth functioning of this utility
program. If you are using Microsoft Excel 2003 you can find security
settings for macro from Tools>macro>security. If you want to get
any help to understand how to enable macro in your computer just press “F1”
Function key and type in the box provided “enabling macros” and press
enter. And do according to the instructions you receive form the help
topic of Microsoft Excel. This utility program is very useful in the
current scenario of Core Banking Solutions. And you can further analyze
the data using various tools of Excel (Sorting, Filtering, etc). Let me
know if it was helpful to you. I assure you that this program will save your 50% time and energy otherwise you should have to spend for the same work manually. Thank you for sending your feedback and supporting me.
(PS: The Data you receive from the Bank will be usually in a Data Compression Format (Generally *.gz Files). It can be extracted with WinRAR or any other similar programs. After extraction you get some text files; from those files choose the following text files:-
"CC_OD_Balance_File_depd0580.txt",
"Listof_NPA_Accounts_lond2572.txt", and
"LoansBalanceFile-lond2390.txt" .
These text files should be copied to your C:\ Drive before you use this Excel Sheet.)
You can download this program from the following link at free of cost.
By Mithun
1 comment:
Post a Comment