Excel to tally

Enabling Excel Add-in

  • Download Excel Add-in from My Blog
  • Go to Excel Add -ins in Developer Tab and Click on browse
  • Select the Excel file downloaded and enable permissions if asked
  • Make sure that Checkbox for Excel To Tally is Checked.
  • Now You Can see new Ribbon Menu Named Tally.
  • Click On Help To View Instructions.(Don't Delete This Sheet )
 

 

Configuring Tally ERP9

  • Open Tally As Administrator
  • Click F12 and Navigate to Advance Configuration
  • Set Tally ERP9 Acting is acting as Both
  • Enable ODBC Server Yes
  • Port 9000 (For Premium you can Change Port and mention port in Excel sheet)
 
 

 

Using Add-In

  • On Instructions Sheet Cell B1 Give 32 bit or 64 bit as per your Office version
  • Click On Masters template to Create Masters
  • Click On Voucher Template to Create Vouchers Like sales , Purchase , Payment , Receipt or any custom vouchers.
  • After entering data Click on Export Masters to Create Ledgers and Export Vouchers to Create Vouchers
  • For Premium users response is shown beside entry in Excel sheet
  • For demo Users response is shown in calculator in tally.
 
 
 
 
 
Replies (2)

Thanks for sharing.
Download XLTOOL Excel To Tally FREE 100% version. 
Import All Vouchers and Masters in Tally PRime, ERP 9, Tally 7.2
Also Export Tally data to Excel.
Source: www.xltool.in.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details