How to Import Excel Data to Tally ERP - Step by Step Guide

Manually entering hundreds of invoices in Tally ERP is time-consuming and error-prone. Importing Excel data to Tally can save hours of work and reduce mistakes. Here's how to do it efficiently.

Why Import Excel to Tally?

• Save hours of manual data entry time
• Reduce errors from manual typing
• Import bulk invoices in minutes
• Maintain accurate records
• Works for sales, purchase, journal entries and masters

Methods to Import Excel into Tally

• ODBC Connection: Direct database connection from Excel to Tally
• XML Import: Convert Excel data to TDL XML format and import
• Third-party tools: Tools like Excel to Tally, TallyConnect etc.
• TallyPrime Connect: Built-in Excel integration in TallyPrime

Step by Step - Import Sales Invoice via XML

1. Prepare your Excel sheet with correct column headers: Date, Party Name, Invoice No, Amount, GST Rate, etc.
2. Use a converter tool or Excel macro to convert to Tally XML format
3. Open Tally ERP 9 or TallyPrime
4. Go to Gateway of Tally > Import Data
5. Select "Vouchers" and browse to your XML file
6. Click Import - Tally will process and import all records
7. Check for any errors in the import log
8. Verify imported vouchers in the relevant register

Common Data Types You Can Import

• Sales Invoices (with GST details)
• Purchase Invoices
• Ledger Master creation in bulk
• Stock Item masters
• Bank statement entries
• Journal entries
• Credit and Debit notes

Tips for Successful Import

• Always take a backup of Tally data before importing
• Ensure party names in Excel exactly match Tally ledger names
• Verify GST numbers and tax rates before import
• Import in small batches first to test
• Check the import log file for any errors