How to import data from excel to tally

How can I import sales data from Excel to Tally ? The same should support Master & Ledger import.

 

If any one come across the solutions let me know.

 

Thanks in Advance.

 

Replies (3)

Hi Jenish,
You can import your Excel Sales Data and Masters from Excel to Tally with EazyAUTO4 Excel to Tally Data Converter.
You can DOWNLOAD this from https://www.exceltotally.in/download.php?id=Auto4Setup

Hi Jenish,

visit www.excel2tally.in and sign up for 30 Day's free trial.

it practically imports all masters & vouchers from Excel to Tally.

Listed by Tally Solutions Pvt Ltd

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 03 October 2026
Accountant

A P Lodha and Associates

Jalna

B.Com

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

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

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
07 October 2026
Senior Account Manager

Amplio Invest

Mumbai

M.Com

View Details
Company
ARTICLESHIP 17 October 2026
Articled Assistant

RRPM & Associates LLP

Chennai

CA Inter

View Details