Import Excel Sheet in Tally

QuikAccount imports almost any Excel data into TallyPrime or Tally.ERP 9: sales, purchases, debit and credit notes, bank statements, journals, stock items and ledgers. Every sheet works the same way: fill → Validate → Export to Tally.

Need help? Call or WhatsApp +91 93584 44502. Free installation and demo support.

Step 1 – Install QuikAccount and connect Tally

  1. Download and install QuikAccount, then activate your free trial (see How to Install and Configure).
  2. Open your company in Tally.
  3. Open QuikAccount and go to the sheet you want to use.
  4. Click Connect Tally on the QuikAccount ribbon. The Tally Company box at the top right shows the company name, GSTIN, state and books start date. Check it is the right company.

Step 2 – Paste your data in the right sheet

What you want in TallyTypeSheet
Stock itemsMasterItemCreation
Ledgers (customers, suppliers, expenses)MasterLedgerCreation
Sales, purchases, debit / credit notesVoucherPurchase_Sales (+ Stock for items)
Marketplace sales, GSTR-2A / 2B purchasesVoucherE-Com
Bank statement, cash receipts and paymentsVoucherCASH & BANK
Journals, contra, multi-ledger vouchersVoucherMULTI
Journals with inventory or foreign currencyVoucherbJournal

Copy the data from your Excel file and paste it under the matching column headings. Grey columns are calculated by QuikAccount.

Purchase_Sales sheet with sample sales invoices

Step 3 – Validate and export

  1. Click Validate (or press Alt+Shift+V). Cells with errors turn red and are listed on the Error sheet with links to each cell.
  2. New ledgers are copied to the LedgerCreation sheet and new items to the ItemCreation sheet. Open that sheet, click Validate, then Export to Tally, and come back.
  3. Validate again until you see Validation Success.
  4. Click Export to Tally (or press Alt+Shift+E). The Report sheet shows every voucher with its status.

FAQ – Can I get a Tally XML file instead?

Yes. When you click Export to Tally, answer No to the question about sending data to Tally. Then click Software Folder on the Registration tab. The file is filexml.xml. Import it in Tally with Import → Transactions.

Trusted by Businesses Across India

Happy Clients

10,000

Transactions Processed

25,15,40,200

Partners

105

Trusted by 10,000+ Tally Users

For Utility, Support and Service

Trusted by Tally users

4.9-star Google rating based on 300+ reviews

Get in touch

Share your details and we will get back to you.