# Tally Stock Item Import Template (Excel)

> Source: https://netray.co/tools/tally-stock-item-import-template-excel
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable stock item master sheet with HSN, GST rate, unit and opening balance that calculates opening value and exports to Excel.

## Category

regional

## Erp

Tally Prime

## Region

India

## Audience

- Accountant
- Tally consultant
- Inventory manager
- Data migration lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Stock item name

**Key:** name

**Type:** text

#### Alias or part code

**Key:** alias

**Type:** text

#### Stock group

**Key:** group

**Type:** select

**Options:**

- Raw Material
- Finished Goods
- Consumables
- Packing Material
- Spares
- Trading Goods

#### Unit

**Key:** unit

**Type:** select

**Options:**

- Nos
- Kgs
- Mtr
- Ltr
- Box
- Set
- Pcs

#### HSN code

**Key:** hsn

**Type:** text

#### GST rate

**Key:** gst

**Type:** select

**Options:**

- 0
- 5
- 12
- 18
- 28

**Unit:** %

#### Opening quantity

**Key:** qty

**Type:** number

#### Opening rate

**Key:** rate

**Type:** number

**Format:** currency

#### Opening value

**Key:** value

**Type:** number

**Expr:** qty * rate

**Format:** currency

#### GST on opening (info)

**Key:** gst_amt

**Type:** number

**Expr:** qty * rate * gst / 100

**Format:** currency

**Rows:**

#### MS Round Bar 20mm

**Alias:** RM-001

**Group:** Raw Material

**Unit:** Kgs

**Hsn:** 7214

**Gst:** 18

**Qty:** 1200

**Rate:** 62.5

#### Hex Bolt M10 x 40

**Alias:** SP-014

**Group:** Spares

**Unit:** Nos

**Hsn:** 7318

**Gst:** 18

**Qty:** 5000

**Rate:** 3.2

#### Corrugated Carton 5 Ply

**Alias:** PK-007

**Group:** Packing Material

**Unit:** Nos

**Hsn:** 4819

**Gst:** 12

**Qty:** 800

**Rate:** 28

#### Bearing Housing Assembly

**Alias:** FG-102

**Group:** Finished Goods

**Unit:** Nos

**Hsn:** 8483

**Gst:** 18

**Qty:** 240

**Rate:** 410

#### Cutting Oil

**Alias:** CN-003

**Group:** Consumables

**Unit:** Ltr

**Hsn:** 2710

**Gst:** 18

**Qty:** 150

**Rate:** 135

**Totals:**

#### Total opening stock value

**Key:** value

**Agg:** sum

**Format:** currency

#### Total quantity (mixed units)

**Key:** qty

**Agg:** sum

**Format:** number

#### Number of items

**Key:** name

**Agg:** count

**Format:** integer

**Notes:** Stock group and unit names must already exist in Tally, or be created first, otherwise the import will fail or create new masters. Check HSN codes and GST rates against your latest notifications before importing. Always import into a test company first. Opening value here equals quantity times rate and is not a valuation opinion.

## Content

**Intro:** Creating stock items one by one in Tally Prime is slow and error prone. This worksheet gives you a clean master layout with HSN, GST rate, unit and opening balance, calculates opening value, and exports to Excel so you can load it with an import utility or a TDL based import.

**Sections:**

#### How to use the template

**Body:** Replace the sample rows with your items. Keep one row per stock item, pick the stock group and unit from the lists, and enter HSN and GST rate. Opening quantity and rate give the opening value, which you should reconcile to the closing stock in your last audited balance sheet. Export to Excel, then map the columns to your import tool.

**Bullets:**

- One row per item, no merged cells
- Use consistent naming so searches in Tally work
- Keep part codes in the alias column
- Reconcile the total to the balance sheet before importing

#### What Tally expects

**Body:** A stock item in Tally needs a unique name, a stock group, a unit of measure and optionally GST details such as HSN and rate. Opening balances go in as quantity, rate and value. Units and groups are separate masters and must exist before items refer to them. Tally Prime can import Excel through its own import feature or through tools and TDL developed by consultants, and each expects a particular column layout.

#### Checking the result

**Body:** After import, open the stock summary and compare item count, quantity and value with this sheet. Spot check five items with different units and GST rates. If values differ, the usual causes are rounding of rates, items imported twice with slightly different spellings, or opening stock already present from an earlier partial entry.

#### Common mistakes

**Body:** Frequent problems are trailing spaces in names, mixed case duplicates, units spelled differently from the Tally master, and HSN codes stored by Excel as numbers so leading zeros disappear. Another mistake is importing opening stock into a live company without a backup. Clean the sheet first and always test on a copy of the company data.

**Cta:** If you are planning a bigger master data clean up before moving from Tally to an ERP, Netray can help profile and de-duplicate item data and map it to the target system.

**Faq:**

#### Can I import stock items into Tally Prime from Excel?

**Answer:** Yes. Tally Prime supports importing masters from Excel using its import feature or consultant built tools. The sheet must match the expected layout, and units and groups must exist first. Test on a copy of the company before importing live data.

#### What columns does a Tally stock item import need?

**Answer:** At minimum the item name, stock group and unit. For a useful master add alias, HSN code, GST rate, opening quantity, rate and value. Exact column headings depend on the import method you use.

#### How do I avoid duplicate stock items on import?

**Answer:** Sort the sheet by name, remove trailing spaces and case differences, and check that no two rows share a name or alias. Compare the item count in Tally to the count in this sheet after import.

#### Do I need to enter GST on opening stock?

**Answer:** No. GST on opening stock is informational here. Opening stock is usually carried at cost without GST. The rate and HSN on the master matter for future sales and purchase vouchers.

## Search terms

tally stock item import excel, tally stock item master template, import stock items in tally prime, tally opening stock excel format, tally inventory master excel, tally hsn gst item excel, bulk stock item creation tally, tally excel import format

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json