LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

How to Tally Import from Excel

Seema Jain (Manager) (25 Points)

03 November 2022

How do we import data from excel to tally? Is possible to import data in Tally without any TDL and XML generator utility. Please provide suitable explanation.

Thanks in advance.

Reply
Follow
Share

3 Replies

Shri Mathur (CA) (8 Points)
Replied 03 November 2022

There are many ways to import bank statements, vouchers and masters in Tally. Also there are different banks having different statement formats. You have to use third party tool utility to import Bank statements, vouchers and masters in Tally 9, ERP, Prime, from Excel or PDF.

You can use this Free Utility Click - www.nikash.in | www.xltally.in | www.xltool.in

How to import data in Tally -

Voucher and Master in the XML format can be imported into Tally using the Import Vouchers and Master option. You can import vouchers from one company to another in Tally. Some of the scenarios are:

Importing data from third-party applications
Migrating to a later release
Data corruption/loss

How to import Masters and Transactions in Tally -

Press Alt+O (Import) / Go to Import Option
Select Masters / Voucher Option
Select the Path of XML file
Enter the File Name
Press OK to Import

sabyasachi mukherjee (26041 Points)
Replied 04 November 2022

Importing masters from tally is EASY.

Ahmed Malik (55 Points)
Replied 10 November 2022

Electronic Invoicing is an https://etechups.com/ electronic authentication mechanism under GST. 2. Under the mechanism, all the B2B invoices generated.