How to import vouchers, transactions excel into tally erp.

i have stored full invoices, bank statements list, reciepts, payments  inforamtion in excel format. we have to create or update in tally erp. it takes us time of days

i heard that possible by convertinginto into X M L or excel special format can be import to tally erp. manually.. ready made softwares suggested some of them, can possible without ready made softwares.

please give me any information if anybody have regarding above query.

thank you..dear friends & professionals.

Replies (4)
Originally posted by : Manjunath
i have stored full invoices, bank statements list, reciepts, payments  inforamtion in excel format. we have to create or update in tally erp. it takes us time of days

i heard that possible by convertinginto into X M L or excel special format can be import to tally erp. manually.. ready made softwares suggested some of them, can possible without ready made softwares.

please give me any information if anybody have regarding above query.

thank you..dear friends & professionals.

 

Dear Manjunath,

You will need to buy a third party software, which will help you import excel data into tally erp.The said third party softwares are available at https://www.exceltotally.in/ site. 

 

Hello,

It is possible and very easy. We have developed excel based utility to import all voucher types from Excel to Tally.

Plz visit www.excelintally.in to download free demo.

 

Regards

Hitesh Khandhadia

EXCELINTALLY.in

Work Smart, Work Excellently

 

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 -

  1. Press Alt+O (Import) / Go to Import Option
  2. Select Masters / Voucher Option
  3. Select the Path of XML file
  4. Enter the File Name
  5. Press OK to Import

See Image below.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
10 October 2026
Accounts Associate Level 1

Abic and Mani Chartered Accountants

Kottayam

B.Com

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details