No Monthly Cost Pay Once Use Lifetime, Free Trial

Excel to Tally Prime import

Upload GSTR1 from Tally/Excel

GSTR 2A/2B Reconciliation

Trusted Technical Support 

Excel to Tally Import Purchase Vouchers

Whats is Purchase Vouchers

This Voucher records all entries related to Purchase including Cash & Credit. You need to enter the item details if Inventory value gets effected due to Purchase. The entries for Cash Purchase are automatically entered in the Cash Book or Bank Book..(ref tallyerp9book )

How to import Purchase Voucher data using Excel-Tally Software in just a click ​

Step 1- Put Data In Template Using Smart Mapping

Excel-Tally software provides you smart data mapping functionality, that helps you to copy all your data from your file to a template without any mistakes. 

or simply copy-paste your data column-wise from your sheet to the software template file.


Step 2- Now Match Ledger & Items with Tally Before Importing


Software highlights you New Ledger by Red Color And Duplicate ledger by Green color by comparing with Tally data 

(for detail ledger Creation use SHEET 2 OPTION  while importing file using software)


Software highlights you New Stock Items by Red Color And Duplicate Stock items by Green color by comparing with Tally data (for detail Stock items Creation use SHEET 3 OPTION while importing file using software )


Step 3- Now Use Create GST Ledger Button

Software Auto Creates GST Ledgers by comparing Invoice GST Number & Place of Supply, Accordingly Create Ledgers as SGST & CGST or IGST also calculate their amours as per TAX RATE Specified.​

Software Create Other Ledger as per Headings specified in your data with its amounts in a single click.​


Open Excel-Tally Software, it will shows you Dashboard here you can select company in which you want to import data. 

Now All set just select template file in software using Purchase with Inventory Button & Click on Import Button, 

check the software dashboard it will show you Count of Ledgers, Stock items,Invoice Records created.

check in tally all your records are imported successfully

follow Same 4 step for import Purchase without Inventory data
using Excel-Tally Software

          (Don’t use Create stock item button because without inventory data does not contains any stock items & all other procedure same as above steps)

Invoice details

You can import data with Invoice Number, Invoice Date, Bill ref number & invoice Voucher Type.

Buyer Details

You can import data with Buyer Name, Address, state, City, Country & GSTN with place of supply

Consignee Details

You can import data with Consignee Name, Address, state, City, Country & GSTN with Destination

Dispatch Details

You can import data  with Delivery Note, Delivery Date, Doc No, Dispatched Through and Destination

Order Details

You can import data with Order No, Order Due Date, Tracking No, Other Ref Number,Mode of Payment

Transporter Details

Your can import  data with Terms of Delivery, LR/RR No, LR/RR Date, Vehicle No

Stock Item Details

You can import data with Item Name,Item Desc, HSN CODE, Godown, Batch No, ExpiryDate, MFG DATE, QTY, UOM, Item Rate

Tax & Other Ledgers details

You can import data with 25+ other ledgers & Tax ledgers with Auto Creation options in single invoice or multi invoice mode 

Cost Center & Narration

Your can import data Party ledger link with Cost center &  Cost Category, Also import Narrations in single or Multi invoice mode 

Can Import Multi Currency data using Same voucher Template

You can import Multi Currency data in same Voucher template by Providing Amount , Foreign Currency Symbol, Rate Of Exchange

100% Accuracy & Guaranteed Technical Support

90% Renewal ratio rewards us with the Most promising Service we provide

Trusted, Happy & Satisfied Clients

Sales Team

9373335929 / 93229 56608

India -Mumbai

Office : 187, Powai Plaza Powai Mumbai - 400076

Support Team

9137888216 / 9359533218

UAE- Dubai​

Office 114, 1st Floor, Al Abbal Building 2, Bank Street,Dubai

Operation Hours

Mon-Sat:10-6.30 (Sunday:off)

India - Ahmedabad​

Office 502,Ashwamegh, Ahmedabad-380006

Sales Team
Support Team

Our customer support team is here to answer your questions.