Home » Education » How to Import Data From Excel To Tally Prime | Import Sales and Purchases with VAT

How to Import Data From Excel To Tally Prime | Import Sales and Purchases with VAT

Written By HAAB Accounting Consultancy on Saturday, Nov 21, 2020 | 07:27 AM

 
This video is all about importing Sales and Purchases from Excel to Tally Prime. We are going to introduce, a Powerful, and easy to use TDL, to import Sales and Purchases from Excel to Tally. This TDL has two features: One is to "Create Masters". which used to import Sundry Debtors or Customers, and Sundry Creditors or Suppliers. Another one is called, "Import the Vouchers", which is for importing Purchases, and Sales Vouchers. You need to have an excel sheet, to import Sales and Purchases to Tally. The download link is here https://bit.ly/2IW5ZGF You can either download and use this template, or you can make it your own. This file you have to save in the Tally File Location. Secondly, You have to create the Ledger Accounts, for Sales Account, Purchase Account and VAT. and Finally, You have to change the Voucher numbering from Automatic to Manual. Once you complete these simple steps, you are good to go and import the Master and Vouchers Timestamp 0:00 Introduction on how to import data from Excel to Tally Prime with VAT 0:48 Introduction on TDL to import data from Excel to Tally Prime 1:10 Steps to remember before start import Sales and Purchases from Excel to Tally Prime 2:31 How to Import Purchases 3:02 How to Import Master or Suppliers from Excel to Tally with VAT 3:27 How to import the Purchase Vouchers from Excel to Tally 3:57 How to Import Sales from Excel to Tally Prime 4:39 How to Import Master or Customers from Excel to Tally 5:17 How to Import Sales vouchers from Excel to Tally with VAT Please contact us, for online classes, on Tally Prime, to be a Tally Expert. #tallyprime #learnaccounting Tally Prime download Page : https://tallysolutions.com/mena/downl... Related Links: Our Website : https://haabaccounting.com/ Blogs : https://haabaccounting.com/accounting... Facebook Page : https://www.facebook.com/haabaccounting/ Instagram Page : https://www.instagram.com/haabaccount... Pinterest Page : https://in.pinterest.com/haabaccounting/ Contact us for free Consultation: Call or WhatsApp : 00971 52 644 9667 Get a Quote : https://haabaccounting.com/free-consu... For Online Booking : https://haabaccounting.com/appointments/