It is very if we can prepare vouchers in excel and then import it into tally. It can save time and is also very convenient. What if we have 1000+ transactions in a bank statement, it will be a very hard task to enter all transactions into tally. Also, accuracy needs to be checked again. There are a number of applications, add-ons and TCPs are available in the market.
This tool is very easy to use. The tool consists of two files, one excel template to enter or prepare transactions to be converted and the converting tool.
How to use this tool?
- Open “Template.xlsx” and enter values in the respective columns. (Don’t enter anything in “grey colored” columns.)
- Save the file and close it.
- Open “Excel to Tally XML Tool”
- If the application shows a dialog box saying Data Source Error press “No”.
- Enable macros once the file opened.
- Then a file open dialog will appear to choose the “Template.xlsx” file / your file with the same template.
- If there is no error you will get a “Success” message. Press “Ok”.
- Next, a dialog box will appear. Give a file name for your output file. Press “Ok”.
- Voila! The converted file will be saved into (eg: “output file.txt”) the same folder from where you choose the Template.xlsx file.
- Open Tally. Go to Gateway of Tally –> Import Data –> Vouchers. Give the output filename with the file path and extension.
- Your vouchers are imported in to tally. Check daybook or ledgers to confirm.
Always keep a backup of tally data before trying this tool.
This Article Is For Educational Purpose Only. Use At Your Own Risk.
To get file password and for help mail to firstname.lastname@example.org or connect through live chat.