Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to import vouchers from Excel to Tally?

I am using XLTOOL Excel to Tally software. But I want to know how to import multi ledger vouchers in Tally from Excel. Kindly help.

user-image
Question added by Devdat Pandye
Date Posted: 2017/10/10

 

Follow these steps for import vouchers Excel to Tally -

  • Download Excel template from - www.xltally.in
  • Enable ODBC port in Tally application.
  • Open one Tally application
  • Open only one company.
  • In XLTOOL software ​fillup the data in vMulti voucher template.
  • Open MY MENU by F1 Key.
  • click START button.
  • Data will be imported in Tally.
  • If any errors occurred see the details on REPORT template.
  • Read software in-built HELP template for more details.

Also see videos for details - www.xltally.in/videos

Thanks.

Nitin Darge
by Nitin Darge , Mumbai, India as Chief Accountant , Dgflick Solution Pvt.Ltd

  • Download Excel template from - www.xltally.in
  • Enable ODBC port in Tally application.
  • Open one Tally application & open only one company.
  • In XLTOOL software ​fillup the data in appropriate voucher template.
  • Open MY MENU by F1 Key.
  • click START button.
  • Data will be imported in Tally.
  • If any errors occurred see the details on REPORT template.
  • Read software in-built HELP template for more details.

If any Error then you can get alert in software REPORT template. Rectify the errors and process same steps.

Follow these steps for import vouchers Excel to Tally -

  • Download Excel template from - www.xltally.in
  • Enable ODBC port in Tally application.
  • Open one Tally application
  • Open only one company.
  • In XLTOOL software fillup the data invMulti voucher template.
  • Open MY MENU by F1 Key.
  • click START button.
  • Data will be imported in Tally.

Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

you can think of the types of files that Excel can export like: csv, which is commonly used in most of the programs.

Hope that help.

More Questions Like This