Purchase with Inventory

Import purchase bills with stock items, quantity, rate, godown, batch and expiry, so stock is updated with every bill.

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

Step 1 – Connect Tally

Open your company in Tally.
Open QuikAccount and go to the sheet you want to use.
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 – Invoice headers on Purchase_Sales

Open Purchase_Sales, set Transaction Type = Purchase and the Voucher Type.
Click Inventory Mode so it is on. The taxable columns turn grey – they are filled from the Stock sheet.
Enter one row per invoice: INV NO, INV DATE, PARTY NAME, State, GSTIN.

Step 3 – Item lines on the Stock sheet

Open the Stock sheet. Enter one row per item: Inv No (same as Purchase_Sales), Item Name, Godown, Qty, Rate and GST Rate.
Leave Unit blank – it is filled from Tally on validation.
Optional: discount %, batch no., expiry date, item description, cess / TCS.
To enter the value instead of the rate, tick Disable Rate. Click Import GST Rate to take each item’s GST rate from Tally.

Stock sheet with item lines linked by invoice number

Step 4 – Validate Stock

Click Validate Sheet on the Stock ribbon.
Items not in Tally are copied to ItemCreation. Export them from there, or pick the right name from the drop-down.
Other errors: GST rate or godown not in the list, too many decimals.

Step 5 – Validate Purchase_Sales and export

Taxable values per GST rate are totalled from the Stock sheet automatically.
Click Validate (or press Alt+Shift+V). Cells with errors turn red and are listed on the Error sheet with links to each cell.
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.
Validate again until you see Validation Success.
Click Export to Tally (or press Alt+Shift+E). The Report sheet shows every voucher with its status.

Advantages

Invoice details

Invoice no., date, reference no. and date, bill reference.

Multiple tax rates

Several GST rates and ledgers in one voucher.

Buyer and consignee

Separate name, address and state.

Additional ledgers

Freight, packing, discount, round off.

Custom voucher type

e.g. "GST Purchase"; several types in one run.

Cost centre and narration

At voucher or ledger level.

Order and dispatch details

Order no., date, dispatch doc., vehicle no., destination.

e-Way Bill and e-Invoice

IRN, ack no. and e-way bill details carried to Tally.

Cess and TCS

Cess and TCS ledgers supported.

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

4.9-star Google rating based on 300+ reviews

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 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 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.

`Alt+Shift+V`	Validate
`Alt+C` or `Alt+Shift+C`	Clear the sheet
`Alt+Shift+E`	Export to Tally
`Ctrl+Shift+S` or double-click	Search a drop-down list