Become a Govt. Certified GST Practitioner. Batch begins 18th Nov. Register Now!

Want to import master payroll in tally from excel.?

CA Ashwini (Practice) (46 Points)

27 July 2015

Dear,

Kindly send me link or software names which provide payroll import facility from Excel to Tally.

I have more than 200 hundred data want to timport in tally.

Kindly Help..!

Reply
Follow
Share

4 Replies

Neha Shah (B.Com) (48 Points)
Replied 24 December 2016

In XLtool there is very simple steps to import Excel data in Tally application.

Download the latest software at - www.xltally.in

Follow these steps for import vouchers Excel to Tally -

First 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.

Upgrade to CAclubindia Pro. Subscribe Now!

Neha Shah (B.Com) (48 Points)
Replied 24 December 2016

In XLtool there is very simple steps to import Excel data in Tally application.

Download the latest software at - www.xltally.in

Follow these steps for import vouchers Excel to Tally -

First 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.

Shweta Softwares (Business) (115 Points)
Replied 19 November 2017

Import attendance data from excel to Tally using udi-Magic Software.

Start Tally ERP and Open a Company.
Start udi-Magic software
Select the option Excel to Tally > Import data into Tally
Click the Browse button and select Standard Excel template (for attendance) provided with udi-Magic converter
Click the Start button

Download link : https://www.rtslink.com/downloads

For more information refer : https://www.udimagic.com

E Tax (38 Points)
Replied 27 December 2023

Tally recently announced Tally version 4 for downloading all payroll data from excel to tally. I have tested the same. If u are facing problem, please mail me at etaxcochin @ gmail.com