Skip to content
Tutorials Center
My learning

Topics

Lesson 20 of 38 ยท Inventory

Tally Prime Stock Items, Units of Measure and Opening Balances

Turn on inventory in Tally Prime, create units of measure and stock items, enter opening balances, and see how quantity, rate and value fit together.

Accounts tell you how much money moved. Inventory tells you what you physically hold: how many boxes, kilograms or pieces of each item, and what they are worth. In Tally Prime the two live in one company, and a single sales or purchase voucher updates both the ledgers and the stock.

Tally Prime is a desktop product and does not run on this site, so this lesson describes the menus precisely and uses small Python stand-ins, clearly labelled, to show the arithmetic Tally performs. Menu names can differ slightly between Prime releases; the ideas do not.

Inventory in Tally: the big picture

Tally keeps accounting and inventory masters side by side. You create stock items, optionally organize them in stock groups and categories (next lesson), and store them in godowns (locations). Then inventory-aware vouchers record quantity and rate against each item.

Inventory building blocks

Unit Nos, Kgs, Box
Stock item What you buy or sell
Godown Where it is kept
Voucher Moves quantity and value

Masters first, vouchers after.

1 / 2

Enable inventory features

Inventory vouchers appear only if the company is set up for them. Open the company's alteration screen (Gateway of Tally, press F11 for Features, or use the company alteration screen in your release) and check that Maintain inventory is set to Yes. Related switches you will meet in later lessons are Integrate accounts with inventory (so a sales voucher posts to ledgers and stock together), Use batches, Maintain expiry dates for batches and Enable bill of materials (BOM).

If you choose "accounts only" when you create a company, stock items and inventory vouchers are hidden. You can switch inventory on later without losing entries.

Units of measure

Every stock item needs a unit. Tally has two kinds:

  • Simple unit: one name and a formal name, for example symbol Nos, formal name Numbers; Kgs; Ltr; Box.
  • Compound unit: a relationship between two simple units, such as Box of 12 Nos (1 Box = 12 Nos). Use it when you buy in bulk and sell in pieces.

To create one: Gateway of Tally > Create > Unit (in the Inventory Info group). Type the symbol, the formal name and the number of decimal places (0 for pieces, 3 for weights). For a compound unit, pick the first unit, type of, pick the second unit, and enter the number of second units in one first unit.

The stand-in below shows what a compound unit means in arithmetic. It is not Tally itself, only the conversion.

Python Stand-in: simple and compound units

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Creating a stock item

Go to Gateway of Tally > Create > Stock Item. The main fields are:

Field What to enter
Name A unique item name, for example USB Cable 1m
Alias Optional short code, handy for fast entry
Under Stock group (defaults to Primary)
Category Optional category (see the next lesson)
Units The unit you created
Alternate units The compound unit, if you buy in one unit and sell in another
Set/alter GST details HSN/SAC, taxability and rate (see GST masters)
Opening balance Quantity, rate per unit and value at the start of the books

Press Ctrl+A to save. While you are inside a voucher you can create a missing item without leaving: press Alt+C on the stock item field to create it on the fly.

Opening balance: quantity, rate, value

The three opening fields are linked: value = quantity x rate. Type any two and Tally fills the third. If you migrate from another year, the opening values should match the closing stock of last year's books so the balance sheet carries forward correctly.

Python Stand-in: opening stock value and total

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The total of all opening stock values flows into the balance sheet as Closing/Opening Stock under current assets, and the opening balance of the same year appears in the profit and loss account as opening stock. If you also enter opening balances in ledgers, make sure the ledgers and the stock side agree on the same trial balance date.

Item behaviour and settings worth knowing

  • Costing method and valuation method decide how stock value is worked out when you sell (next lessons: Stock valuation methods).
  • Standard rates can be stored for cost and selling price, with a date from which they apply; Tally can pre-fill them in vouchers.
  • Reorder level and minimum order quantity are available under the item's reorder settings and feed the Reorder Status report.
  • Treat as a service? Some releases let you mark an item as having no stock-keeping (service). Services are usually better handled as ledgers or as items with a SAC code.
  • Items can be altered later (Gateway of Tally > Alter > Stock Item), but changing the unit of an item that already has transactions is restricted to protect your data.

Common mistakes

  1. Duplicate names that differ by a space or capital letter, which makes reports hard to read. Use a consistent naming pattern.
  2. Entering opening balance with a rate of zero, which makes later profit look too high.
  3. Forgetting to set the GST details, so a sales invoice shows no tax.
  4. Using Nos for an item you actually buy in boxes. Use a compound unit instead.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which of these is true about a compound unit such as 'Box of 12 Nos'?

    A compound unit links two simple units with a fixed conversion, so you can buy in boxes and sell in pieces.
  2. 2. You type quantity 40 and rate 520 in an item's opening balance. What does Tally calculate for value?

    Value = quantity x rate = 40 x 520 = 20,800.
  3. 3. Which key creates a missing stock item on the fly inside a voucher?

    Alt+C opens the creation screen from the field you are in. F11 opens Features.
  4. 4. What must be enabled before inventory vouchers appear?

    Without the Maintain inventory feature, Tally hides stock items and inventory-style vouchers.

Summary

  • Inventory in Tally Prime is built from units, stock items, godowns and vouchers.
  • Enable Maintain inventory (and integration with accounts) in company features first.
  • A simple unit is one measure; a compound unit links two (Box of 12 Nos).
  • A stock item has a name, unit, GST details and an opening balance where value = quantity x rate.
  • Use Alt+C to create masters on the fly; keep names consistent.

Next: Stock groups, categories and godowns