Tally - Auto Entry Utility

Hi guys,

For those making year end entries in tally and those having huge volume of entries carrying some frequencies (daily/weekly/monthly) like rent, shop expenses, etc., to make in tally, this excel add-on might suit you well.

Making the entries in excel is quite easier than making it in tally as you have copy-paste, fill down, formulae, etc.

So you can make all the entries in excel and export the entries to tally in flash. Saves a lot of time.



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: For successful importing of entries ensure

• Masters (ledgers) already exist in tally before importing vouchers.xml

• the date format in windows has to be in "dd-mm-yy" format.

The Exported xml can be imported to Tally 7.2, 9 and ERP.

If you want this Excel utility Please comment your Email in the comment.

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email