+91 93584 44502 | +91 92160 90617 | support@quick2tally.com
Quick2Tally

Import Stock Items or Ledgers

Create or alter hundreds of stock items and ledgers in Tally in one go, with GST details, HSN, units, addresses and opening balances.

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

Import stock items

  1. Open your company in Tally.
  2. Open QuikAccount and go to the sheet you want to use.
  3. 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.
  4. Open the ItemCreation sheet and paste your items under the headings. Item Name and Unit are compulsory; add stock group, HSN, GST rate, MRP and opening stock as needed.
  5. Click Validate. Duplicate or invalid values turn red.
  6. Click Export to Tally.
  7. To change existing items, fill only the columns to update and click Alter in Tally.
ItemCreation sheet for creating stock items in Tally

Import ledgers

  1. Click Connect Tally.
  2. Open the LedgerCreation sheet and paste your ledgers. Ledger Name and Parent Group are compulsory; add address, state, GSTIN, PAN, opening balance and bank details as needed.
  3. Have only GSTINs? Click Get Name, Addr from GSTIN to fill names and addresses. Auto Fill PAN fills PAN from the GSTIN.
  4. Click Validate, then Export to Tally. Use Alter in Tally to update existing ledgers.
LedgerCreation sheet with customers and suppliers

Advantages

Create and Alter

Create new masters or update existing ones in bulk.

GSTIN lookup

Name, address and state filled from the GSTIN.

Fetch from Tally

Fetch Items / Fetch Ledgers brings existing masters into the sheet for editing.

Name Changer

Rename many items or ledgers at once.

Bill of Material

Enable BOM to create items with their components.

Duplicate check

Duplicate names are highlighted before export.

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

Kamal Jain, FCA, CCA
Kamal Jain, FCA, CCA 1 review

Great software, User friendly & Superb support. All GST reports show accurate results. Multiple formats for each voucher to suit our needs. Whatever format of data you have, you can export it to Tally. Good job, QuikAccount team!

Sanjay Jain
Sanjay Jain 1 review

The software is user-friendly. It provides a lot of options to cater to your needs and gives results in desired format. It also asks for minimum data and most of the fields are either auto-calculated or imported from Tally, which makes working on this software much faster.

Prachi Shah, Senior Executive
Prachi Shah, Senior Executive 1 review

Superb tool to integrate Excel data with Tally. We have imported complex e-commerce reports with this tool and it imported large data accurately and very fast. The company provides a one-click import option for multiple e-commerce platforms.

Get in touch

Share your details and we will get back to you.