91-93584-44502    support@quick2tally.com

How to Import Excel Data in Tally Prime

QuikAccount provides the simplest way to import your any excel data into Tally ERP.9 or Tally Prime. It comes with multiple format to import your excel data which may be purchases, sales, bank statements, journal entries or any other voucher or master. We have served almost 5000 clients till data across the country and have converted more than 10 crores transactions into tally.

Common Steps to Import any Excel Data into Tally Prime using QuikAccount

Step 1. Install QuikAccount and Connect with tally

1.    Download QuikAccount basic version from here.

2.    Install this setup file and open software.

3.    This will automatic redirect you to registartion sheet, go and actviate your trial.

4.    Open company in tally simultanrously.

5.    Go to help sheet of QuikAccount software and click on connect tally.

Copy data in relevant sheet

1.    Once you connected with tally using above steps, you need to decide which type of data you want to create in tally.

2.    We have provided seperate sheets for seperate type of data as below:

Nature of data to be imported Type QuikAccount Sheet Name
Stock Item Creation Master ItemImports
Ledger Creation Master Ledger
Sales Import Voucher Purchase_sales
Purchase Import Voucher Purchase_sales
Debit Note Import Voucher Purchase_sales
Credit Import Voucher Purchase_sales
Bank Statement Import Voucher CashBank
Journal Import Voucher Multi

3.    Choose relevant sheet based on your data type and copy your data there.

Advantage

Global Network Of

Happy Clients

0

Transaction Processed

0

Partners

0

What our client says

heading line white
whats app
;