Once you have converted your Excel data into an XML file using our tools, the next step is importing that file into Tally Prime. The process is straightforward, but taking a few precautions beforehand is highly recommended.

Crucial First Step: Take a Backup!

Before importing any bulk data, always take a backup of your Tally Company Data. If you accidentally import the same file twice, or if the ledgers are incorrect, having a backup allows you to restore instantly instead of manually deleting hundreds of vouchers.

Step 1: Ensure Masters (Ledgers) Exist

Before importing vouchers, Tally requires that the ledgers used in those vouchers already exist in the company. For example, if your XML contains a sale to "ABC Corp", the ledger "ABC Corp" must exist in Tally under Sundry Debtors.

  • Ensure all Party Ledgers exist.
  • Ensure Sales/Purchase account ledgers exist.
  • Ensure Tax Ledgers (IGST, CGST, SGST) exist.

Step 2: Note the Path of Your XML File

Save the downloaded XML file to a location that is easy to access, such as D:\TallyData\imports\purchase.xml. You will need to paste this path into Tally.

Step 3: Open the Import Menu

For Tally Prime:

  1. Look at the top menu bar and click on Import (Alt+O).
  2. From the dropdown menu, select Transactions.

Note: For older Tally ERP 9, go to Gateway of Tally → Import of Data → Vouchers.

Step 4: Specify the File Path

A small window will open asking for the file path.

  1. In the File Path field, select "Specify Path" or paste the folder path (e.g., D:\TallyData\imports\).
  2. In the File to import (XML) field, select your XML file from the list (e.g., purchase.xml).
  3. Press Enter.

Step 5: Review the Import Log

Once you press Enter, Tally will begin importing. Depending on the size of the file, this can take a few seconds to a minute.

If the import is successful, the vouchers will seamlessly appear in your Day Book. You will not get a "Success" message; the window will simply close.

If there is an error: Tally will display a message at the bottom of the screen (e.g., "Import completed with errors"). You can view the exact error by opening the Tally.imp file located in your Tally installation folder. See our guide on fixing common import errors for more help.

Step 6: Verify the Data

Always go to your Day Book or relevant registers (Purchase Register / Sales Register) and verify that the imported vouchers match your original Excel data in total value and count.