Excel to Tally Entry Software

Click here for the demo video

Click here for the download demo file

Excel to Tally Entry GST is a tool to import accounting entries from excel to tally. Kindly backup before importing data using this tool.

All you need to do is:

IN EXCEL

1. Enter the date, party name, ledger name and the amount in the excel.
2. Select the voucher type (multiple types are supported in single upload).
3. After entering all the vouchers, Click on 'Create Vouchers XML' & save the Vouchers xml file in an easily accessible location.
4. OPTIONAL: If you want to export masters also, then click on 'Filter Masters'.
5. List of masters to be exported will be displayed. Select the master type and then click on 'Export Masters XML'  & save the file in an easily accessible location

IN TALLY

1. Import the Masters xml first, if you have exported it from excel.
2. Import - Vouchers xml
3. DONE!!!!

IMPORTANT NOTE:

1. For successful importing of entries ensure Masters (ledgers) should already exist in tally before importing vouchers.xml
2. the date format in windows has to be in "dd-mm-yy" format  (to do that Click Start, point to Settings, click Control Panel, and then double-click Regional Settings. On the Date tab, click the date format you want to use in the Short date style box, and then click OK.)

INSTRUCTION

1. Click on enable content button, showing in excel.

2. After enabling content to save sheet and close and reopen sheet and fill -

ID - Admin

Password - 1234

If you are interested please fill out:-