Bank audit excel tool
This query is : Resolved
CA G. SURYANARAYANAN
(Querist)
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
Mail ID : auditorsurya@gmail.com
CA. Nitin Agrawal
(Expert)
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
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- EPF ECR NEW FILE SEP 17TH 2026
- Under marginal scheme
- Oct 2025 Invoices
- TAX AUDIT ON PROFESSIONAL INCOME
- Capitalgain tax purposes for valuation report compulsory
- Import of Software Service.
- SECTION 393(3) TAX ON CASH WITHDRAWAL
- Utilisation Fy 25-26 TDS challans in Fy 26-27 TDS Return
- TDS on Fixed Assets purchased
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- Capital Gail Exemption Certificate
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
