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 file into Tally Prime using QuikAccount - (Tally में Excel शीट इम्पोर्ट कैसे करे)
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.
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.
1. Once you have copied entire data you need to click on Validate button. Such button is given on each sheet.
2. When you click on validate button, system will check entire data and highlight the errors of any. Do necessary corrections and validate data again.
3. Once entire validation is resolved, system will give you message 'Validation Success'.
4. After you receive 'Validation Success' message, please click on export to tally button to create all entries in tally.
Q.1 How to convert excel to tally xml file?
Ans: QuikAccount software provides option to generate xml file from excel data. In the steps explained above when you click on Export to Tally button, it propmts you for
"XML file has been generated, Do you want to export it to Tally?"
On such prompt click on No button --> Go to Help Sheet of QuikAcount --> Click on software folder button--> There you can search filexml.xml
0
0
0
Great software, User friendly & Superb support. All GST reports shows accurate results. Multiple formats for each voucher to suit our need. Whatever format of data you have, you can export that to tally. Good Job... QuikAccount Team!
Kamal Jain, FCA, CCA
Software is user-friendly. It provide lot of option to cater your need and give results in desired format. Also it ask for minimum data and most of the fields are either auto-calculated or imported from tally which makes working on this software very faster.
Sanjay Jain
Superb tool to integrate excel data in Tally. We have imported complex e-commerce reports with this tool and it has imported large data accurately and very fast too. Company provided one click import option for multiple e-commerce platforms.
Prachi Shah, Senior Executive
