Bank audit excel tool


This query is : Resolved 

04 April 2012 i am in want bank excel bank audit tool. ie., how to convert the zip format files given by the bank to excel format. CA. D.venkataraman Tamil Nadu has given a format for conversion of bank data in excel format, if any one having this format means send me to the following mail ID.

Mail ID : auditorsurya@gmail.com


05 April 2012 Dear Sir

I think the data given by the bank in Zip file is in ASCI code or in text format. You need to convert the same into excel with the help of excel import tool.

For getting the data in desired format in excel you have to work on excel import data which is not in orderly position.

Following steps require in these regard:
1. Import the date into excel.
2. Remove the garbage i.e unwanted lines etc (but care that wanted data not get deleted)
3. Order the scattered data in orderly columnar position.

Hope it helps you.....
If you unable to convert it correctly you may mail that data to me at agrawalnitinca@gmail.com, i will convert the same in excel and mail back to you.

Regards

07 April 2012 The expert has given some help in the matter. Try it I thing it will work


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details