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
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
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
- Is Aadhar PAN linking required for opening bank account?
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Where to show the RCM on Rent paid to unregistered landlord
- Offsetting interest income against derivative trading losses
- RCM - commercial rent paid to URP under GST
- Gst Sales of FY 2023-24
- Whether still royalty
- Legal heir raised refund , but refund issued to the closed account of deceased.
- GST Annual Returns filing due date
- TDS NUMBER SURRENDER
- Need help with business structure for setting up a new business
- TDS applicability on Service through ECO
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
