How to Import 100+ Purchase Entries Into TallyPrime From Excel

Have 100, 200, or even 500 purchase entries sitting in an Excel file?

Entering every purchase voucher manually into TallyPrime can quickly become a time-consuming task. A purchase invoice may contain the date, supplier, invoice number, purchase ledger, amount, GST details, and other information. When this has to be repeated hundreds of times, even small mistakes can create bigger accounting problems.

Solution for this is that you can take your purchase data from Excel, convert it into Tally-compatitble XML file and then import transactions into TallyPrime.

This guide explains how to convert Excel to Tally, a complete process in simple terms.

Why 100+ Purchase Entries Become a Problem

Let’s say you have 150 purchase invoices for month. If each invoice requires checking and entering just 8 important fields, you are already dealing with around 1,200 individual data points.

Purchase entry may include:

• Purchase date
• Supplier or vendor name
• Invoice number
• Purchase ledger
• Taxable amount
• CGST
• SGST
• IGST
• Total amount
• Narration or reference

Inventory purchases can have even more information, such as item name, quantity unit, rate, discount and stock details. The problem is not only amount of work. Manual entry can lead to common mistakes. For example:

Excel: ₹25,800
Tally entry: ₹28,500

or

Excel: Invoice No. INV-1045
Tally entry: Invoice No. INV-1054

common issues

• Selecting the wrong supplier ledger
• Entering the wrong invoice date
• Missing GST amounts
• Using the wrong purchase ledger
• Entering the same invoice twice
• Missing a purchase entry completely
• Making debit and credit totals unequal

When there are only 5 or 10 invoices, there mistake are easier to find. With 100+ entities, checking everything manually takes much more effort.

How Can You Import 100+ Purchase Entries?

The basic solution is to convert your Excel to Tally. The process of converting Excel purchase data into Tally-compatible XML file:

Excel Purchase Data → Convert to Tally XML → Download XML → Import into TallyPrime → Verify Entries

Instead of creating every purchase voucher manually, Excel data is structured and converted into XML format that TallyPrime can read. TallyPrime supports importing transaction data through XML and its current versions also support Excel-based imports.

The Solution: Convert Excel to Tally XML

If your purchase entries are already available in Excel, you can use the Excel to Tally XML Converter to convert the spreadsheet into a Tally-compatible XML file. The process is simple:

• Prepare your Excel purchase file.
• Select the purchase data type.
• Upload the Excel file.
• Convert the data into XML.
• Download the XML file.
• Import the XML into TallyPrime.

The converter supports purchase entries without inventory and can handle purchase-related GST fields such as CGST, SGST, and IGST. It also maps vendor and expense ledgers while creating the XML file.

This is particularly useful when the main requirement is to move a large number of accounting purchase entries from Excel into TallyPrime without manually creating every voucher.

What Should Your Excel File Contain?

Before converting file, your Excel data should be clean and properly arranged. For basic purchase entry, useful columns can include:

Excel Column	Example
Date	15/09/2026
Voucher Type	Purchase
Vendor/Ledger Name	ABC Traders
Invoice Number	PUR-1052
Purchase Ledger	Purchase A/c
Amount	50,000
CGST	4,500
SGST	4,500
IGST	0
Narration	Office supplies

The exact columns depend on type of purchase entries you are importing. If you don’t have excel file ready, you can download sample Excel file add data and then convert it.

Step-by-Step: Excel to TallyPrime process

Step 1: Clean your Excel data

Before uploading the file, check:

• Supplier names
• Invoice numbers
• Dates
• Purchase ledger names
• Amounts
• GST values
• Duplicate entries
• Blank or incomplete rows

Step 2: Prepare the purchase sheet

Keep the purchase information in columns rather than scattered across different parts of the workbook. A clean spreadsheet makes the conversion easier and also makes it easier to find errors before importing.

Step 3: Convert the Excel file to XML

Open the Excel-to-Tally XML converter and select the Purchase Without Inventory option. Upload your .xls or .xlsx file.

The tool processes the purchase data and generates a Tally-compatible XML file. The available workflow is essentially: select data type → upload Excel → download XML.

Step 4: Download the XML file

Once conversion is complete, download the generated XML file. This is the file you will use for the TallyPrime import.

Step 5: Import XML into TallyPrime

Open the required company in TallyPrime.
Go to: Alt+O → Import → Transactions
Select the XML file and start the import.

Step 6: Check the imported purchases

Open the Purchase Register or relevant transaction report and compare the imported entries with the Excel file. Check:

Number of purchase vouchers

• Supplier names
• Invoice numbers
• Dates
• Purchase amounts
• CGST
• SGST
• IGST
• Ledger postings

What If You Have 500+ Entries?

The same basic workflow can be used for a larger number of entries:
Prepare → Check → Convert → Import → Verify

The important thing is to keep the Excel data structured. If you have 500 entries, it can also be useful to divide the work into logical batches, such as:

• Week 1 purchases
• Week 2 purchases
• Week 3 purchases
• Week 4 purchases

Or separate files by month. This makes it easier to identify where an error occurred if something needs to be corrected later.

Final thoughts

If you have 100+ purchase entries in Excel, manually entering every voucher into TallyPrime can create unnecessary repetitive work. Importing 100+ purchase entries into TallyPrime does not have to mean entering every invoice manually. If your purchase data is already available in Excel, you can prepare and check the data, convert it into Tally-compatible XML, and then import the file into TallyPrime. This can make bulk entry more organized and reduce repetitive data entry.

The important part is to keep your Excel file clean before conversion. Check supplier names, invoice numbers, dates, purchase amounts, GST details, and duplicate entries. It is also a good idea to test a few entries first and verify them in TallyPrime before processing the complete file.

For businesses and accountants handling large numbers of purchase entries, the Excel-to-XML approach provides a simple way to move structured purchase data into TallyPrime. The process is straightforward: prepare the Excel file, convert it to Tally XML, import the XML, and verify the results. With the right data structure and a quick final check, even 100+ purchase entries can be handled without entering every voucher from scratch.