Inventory and Order Management

Introduction

Inventory is the stock of goods and materials held for production, resale, or consumption. In an accounting system, inventory management connects physical movement with financial records. A purchase increases available stock and usually creates a liability; a sale decreases stock and creates revenue and a receivable or cash inflow. Proper configuration is therefore essential for reliable stock quantities, valuation, gross profit, reorder decisions, and audit evidence.

Tally-based systems normally record inventory through masters and vouchers. Masters describe the structure of inventory—stock groups, categories, items, units, godowns, and valuation methods. Vouchers record events such as purchases, sales, receipts, deliveries, and stock transfers. The exact menu names may differ between Tally versions and company configurations, but the underlying accounting logic remains substantially the same.

Learning Objectives

After studying this chapter, the learner should be able to:

• distinguish stock groups, categories, items, units, and godowns;
• create a logical inventory master structure;
• select and apply an appropriate valuation method;
• record purchase, sales, receipt, delivery, and stock-transfer transactions;
• reconcile voucher records with physical stock and accounting ledgers;
• identify control, tax, documentation, and ethical issues in inventory processing.

1. The Inventory Information Model

An inventory system answers five connected questions:

1. What is being held?—stock items.
2. How is it classified?—stock groups and categories.
3. In what quantity?—units of measure.
4. Where is it located?—godowns or warehouses.
5. At what amount is it reported?—valuation method.

A useful conceptual model is:

Figure: Inventory masters support transaction entry, which produces management and accounting reports.

Stock Groups

A stock group is a classification based on common characteristics, such as product line, function, or reporting requirement. Examples include Electronics, Office Furniture, and Finished Goods. Groups may be arranged hierarchically—for example, Finished Goods → Appliances → Refrigerators. A group should be meaningful for reporting, not merely a duplicate of an item name.

Stock Categories

A stock category is an additional, parallel classification. For example, items may be grouped by product line and simultaneously categorised by brand, size, or usage. Categories are particularly useful when management wants alternative analyses without changing the primary group structure. A business should avoid creating categories that are never used in reports because unnecessary classifications increase maintenance and error risk.

Stock Items

A stock item is the specific product or material being bought, sold, stored, or consumed. Its master may include item name, group, category, unit, opening balance, tax details, reorder information, and applicable valuation method. Item names should be unique, consistent, and sufficiently descriptive. “Cable” is weak; “Copper Cable 2.5 mm, 90 m Roll” is more useful.

Units of Measure

A unit defines how quantity is recorded. Common units are numbers, kilograms, litres, metres, boxes, and pieces. A simple unit has one measurement, while a compound unit combines two units, such as dozen-pieces or kilograms-bags. Conversion must be documented. If one carton contains 24 pieces, the system should consistently apply 1 carton = 24 pieces. Mixing units without conversion causes materially incorrect stock balances.

Godowns and Locations

A godown is a physical or logical storage location. Examples include Main Warehouse, Showroom, Damaged Stock, Transit, and Branch Warehouse. Godowns allow quantity and value to be analysed by location. A godown hierarchy can represent region, branch, warehouse, and bin. Damaged or restricted stock should not be combined with saleable stock if that would mislead users about available inventory.

2. Valuation of Inventory

Inventory quantity is usually straightforward; inventory value requires a policy. The closing inventory amount affects current assets, cost of goods sold, and profit. The basic relationship is:

This identity assumes a periodic measurement framework and that the relevant purchases, returns, freight treatment, and inventory adjustments have been properly included. Under a perpetual system, cost is assigned when each sale is recorded, but the identity remains a useful reconciliation relationship.

Common Methods

FIFO (First In, First Out) assigns the oldest available cost to issues first. It is often intuitive for goods that physically move in age order, although the accounting flow need not exactly match physical flow.

Weighted average assigns an average cost to available units. The periodic form is:

The formula applies when units are homogeneous and costs are combined for the relevant period. Under a moving-average system, the average is recalculated after each receipt:

Specific identification assigns the actual cost to an identifiable item, such as a unique vehicle, artwork, or customised machine. It is unsuitable where interchangeable units cannot be individually tracked.

A system may also support standard cost or other methods for internal control. The selected method should comply with the applicable accounting framework and be applied consistently. Financial reporting may require inventory to be measured at the lower of cost and net realisable value. Net realisable value is generally the estimated selling price less costs necessary to complete and sell the item; it should not be confused with an automatic discount to inventory value without evidence.

Worked Example: Moving Average

A business has 100 units at ₹20 each. It receives 50 units at ₹26 each.

Old cost = 100 × ₹20 = ₹2,000.

Receipt cost = 50 × ₹26 = ₹1,300.

New average cost = (₹2,000 + ₹1,300) ÷ 150 = ₹22 per unit.

If 80 units are issued after the receipt, the cost assigned is 80 × ₹22 = ₹1,760, leaving 70 units at ₹22, or ₹1,540. The example assumes no additional receipts, returns, write-downs, or unit-conversion issues.

3. Configuring Inventory in a Tally-Based System

Configuration should be planned before transactions are entered.

Step 1: Enable Relevant Features

Activate inventory integration, multiple godowns, batches, order processing, invoicing, and tax features only when required. Excessive features can confuse users and create incomplete fields. Where financial and inventory records are integrated, confirm whether accounts-only or inventory-plus-accounts mode is selected.

Step 2: Create Units

Create simple or compound units first. Define decimal places where fractional quantities are valid—for example, kilograms may require three decimal places, while sealed cartons may require none. Test conversions before entering opening balances.

Step 3: Create Groups and Categories

Design a short coding or naming policy. Decide whether classification is by product family, business segment, brand, or reporting responsibility. The same item should not be created twice merely because it is stored in different locations; location is normally handled through godowns.

Step 4: Create Godowns

Create the main location and subordinate locations. Decide whether transit, quarantine, damaged, and consignment stock require separate locations. Restrict user access where stock is sensitive.

Step 5: Create Stock Items

Enter the item’s group, category, unit, opening balance, rate, value, tax information, and reorder details. Opening quantities and values should be supported by an approved stock count and valuation statement.

Step 6: Select Valuation and Test

Select the valuation method appropriate to the item and accounting policy. Enter test receipts and issues in a training company or controlled period. Compare the stock summary with an independent calculation before live use.

4. Order and Inventory Transactions

An order expresses an intention or commitment; an invoice records a financial transaction; a receipt or delivery records physical movement. These events may occur at different times.

Purchase Order

A purchase order records supplier, item, quantity, agreed rate, delivery date, and terms. It normally does not increase stock or create a payable. It supports commitment monitoring and later comparison with receipt and invoice quantities.

Receipt Note

A receipt note records goods received from a supplier before or independently of the invoice. It should identify the receiving location and quantities accepted, rejected, or pending inspection. Depending on configuration, it may update stock while leaving the supplier account unaffected until the purchase invoice is recorded.

Purchase Invoice

A purchase invoice records the financial purchase. A typical entry is:

• Debit Purchase or Inventory account;
• Debit recoverable input tax, where applicable;
• Credit supplier or cash account.

Freight, insurance, discounts, and tax must be treated according to the organisation’s accounting policy and applicable law. A purchase return reverses or adjusts the relevant quantity and financial amount.

Sales Order

A sales order records a customer’s request or confirmed commitment. It normally does not reduce stock. It helps identify pending demand and supports delivery planning.

Delivery Note

A delivery note records goods sent to the customer. It reduces available stock when inventory is issued, but may not create revenue until the sales invoice is issued, depending on the system design. The delivery should be matched with the sales order and authorised dispatch documentation.

Sales Invoice

A sales invoice records revenue and the customer’s receivable or cash due. A simplified entry is:

• Debit customer or cash;
• Credit sales revenue;
• Credit output tax, where applicable.

The cost side is also recorded in an integrated perpetual system:

• Debit cost of goods sold;
• Credit inventory.

Sales returns reverse the relevant sale and restore stock only when the goods are physically received and saleable, subject to inspection.

Stock Transfer

A stock transfer moves goods between godowns without being a sale or purchase. It should reduce quantity at the source and increase quantity at the destination. A stock journal or transfer voucher should include item, quantity, source, destination, date, and authorisation. Inter-branch transfers may require additional financial, tax, or legal treatment and should not be assumed to be simple internal movements.

Physical Stock Voucher

A physical stock voucher records the result of a count. It is not a substitute for investigating differences. Variances should be traced to unrecorded receipts, dispatches, damage, theft, unit errors, duplicate entries, or timing differences before an adjustment is approved.

5. Worked Transaction Cycle

Consider an illustrative business, GreenTech Office Supplies:

1. It orders 100 printers from a supplier at ₹8,000 each.
2. It receives 96 printers; four are short-shipped.
3. The supplier invoice is issued for 96 printers plus applicable tax.
4. The business sells 10 printers to a customer and dispatches them.
5. Eight printers are transferred from the main warehouse to the showroom.

The order records a commitment of 100 units but does not itself increase stock. The receipt records 96 units. The purchase invoice records the liability for 96 units. The delivery and sales invoice reduce saleable stock by 10 units. The transfer changes location but not total company stock. Before considering other movements, total stock is:

96 − 10 = 86 printers.

The location report should show 78 units in the main warehouse and 8 in the showroom if all 10 sold units were dispatched from the main warehouse. The purchase order should show four units outstanding or cancelled, depending on supplier confirmation. This example illustrates why order, receipt, invoice, and location records must be linked rather than treated as interchangeable documents.

6. Detailed Applied Case: Sunrise Home Appliances

This is an illustrative case designed for learning.

Background

Sunrise sells refrigerators, washing machines, and spare parts through a warehouse and two showrooms. It previously used spreadsheets. Management could not explain differences between physical quantities and accounting records, and sales staff sometimes promised goods that were actually held in a damaged-stock area.

Problem

The business had duplicate item names, inconsistent units, no separate godown for damaged goods, and no reliable connection between purchase orders and receipts. Its reported gross profit varied because different staff members used different cost assumptions.

Analysis

The first task was to determine the reporting needs. Product family was selected as the stock-group structure. Brand was selected as a category because management wanted reports by both product family and brand. Each sellable model became a stock item. Spare parts were recorded in pieces, while certain materials were recorded in metres. The damaged area was created as a separate godown, and showroom locations were created as subordinate godowns.

The company adopted a documented weighted-average method for interchangeable products. Serial-number or specific identification controls were retained for high-value appliances where individual identification was operationally important. Opening stock was counted jointly by warehouse staff and accounts staff, and differences were approved by a manager.

Solution

Purchase orders were made mandatory for planned purchases above an internal threshold. Receipt notes were entered by receiving staff and were matched with supplier invoices by accounts staff. Delivery notes were generated only against approved sales orders. A stock transfer voucher was required for warehouse-to-showroom movements. Damaged items were prohibited from being included in saleable-stock promises.

User roles were separated: purchasing staff could create orders, receiving staff could record receipts, sales staff could create orders, and finance staff could approve invoices and adjustments. Daily exception reports identified negative stock, overdue orders, unmatched receipts, and unusual adjustments.

Outcome

The business obtained location-wise stock balances, could identify supplier shortages, reduced duplicate item creation, and produced more consistent gross-profit information. The system did not eliminate the need for physical counts; instead, it made count differences easier to investigate.

Learning Points

The case demonstrates that software accuracy depends on master-data design, disciplined procedures, user responsibility, and periodic verification. A technically correct voucher entered against an incorrect item or godown still produces misleading information.

7. Controls, Governance, and Ethical Practice

Inventory records influence tax, financial reporting, lending decisions, and employee performance measures. Important controls include:

• authorisation limits for purchases, sales discounts, transfers, and write-offs;
• separation of ordering, receiving, custody, invoicing, and approval duties;
• sequential and complete voucher numbering;
• restricted back-dated entries and logged alterations;
• regular physical counts, cycle counts, and reconciliation;
• review of negative stock, unusual margins, dormant items, and large adjustments;
• documented treatment of obsolete, damaged, expired, and consignment goods;
• secure backups and role-based access.

Ethically, staff must not manipulate quantities or valuation to inflate profit, conceal shortages, meet sales targets, or avoid tax. The system operator should preserve audit trails rather than deleting inconvenient entries. Privacy also matters: supplier and customer information should be accessible only to authorised users.

8. Challenges and Limitations

Inventory systems can produce false confidence. Common limitations include incorrect opening balances, duplicate masters, poor unit conversions, delayed data entry, unreliable barcode scans, and stock held at third-party locations. Valuation methods are estimates of cost allocation; they do not by themselves prove that goods exist or are saleable. Automated reorder levels may also be inappropriate when demand is seasonal or supplier lead times are unstable.

A system should therefore be supported by physical controls, documented policies, exception review, staff training, and periodic independent checking. Technology improves visibility, but accountability remains a management responsibility.

9. Technology and Contemporary Practice

Barcode scanners, mobile receiving, batch and serial tracking, and cloud reporting can reduce manual entry. Integration with e-commerce and procurement platforms can connect orders, dispatches, and customer notifications. Artificial intelligence may assist with demand forecasting, anomaly detection, and item-name standardisation, but its outputs require human review. Poor historical data can produce poor forecasts, and automated recommendations should not override accounting policy, physical inspection, or authorised approval.

Chapter Summary

Inventory and order management combines structured masters with controlled transaction processing. Stock groups and categories classify items; stock items identify the goods; units define quantity; godowns define location; and valuation methods determine reported cost. Purchase and sales orders record commitments, while receipt and delivery documents record physical movement. Purchase and sales invoices record financial consequences, and stock transfers move goods between locations without necessarily creating revenue or expense. FIFO, weighted average, and specific identification allocate cost under different circumstances. Reliable results require consistent configuration, reconciliations, segregation of duties, audit trails, physical counts, and ethical governance. Tally can improve integration and reporting, but it cannot compensate for inaccurate master data or weak operating controls.

Key Terms

Stock item: A specific good or material tracked in the inventory system.

Stock group: A primary classification of similar stock items.

Stock category: A parallel classification used for alternative analysis.

Unit of measure: The basis used to quantify an item.

Compound unit: A unit formed by combining or relating two units.

Godown: A physical or logical inventory storage location.

Purchase order: An authorised request or commitment to buy goods.

Sales order: A customer order or commitment to purchase goods.

Receipt note: A document recording goods received from a supplier.

Delivery note: A document recording goods dispatched to a customer.

Stock transfer: Movement of goods from one location to another.

FIFO: A cost-allocation method assigning oldest available costs first.

Weighted average: A method assigning average cost to homogeneous units.

Specific identification: Assignment of actual cost to individually identifiable goods.

Cost of goods sold: Cost assigned to goods sold during a period.

Net realisable value: Expected selling price less completion and selling costs.

Physical stock voucher: A record of counted quantity and inventory adjustment.

Reorder level: A stock level used to trigger replenishment action.

Audit trail: A record of transaction creation, change, approval, and timing.

Review Questions

Short Answer Questions

1. Distinguish a stock group from a stock category.
2. What is the purpose of a godown in inventory accounting?
3. Why does a purchase order normally not increase stock?
4. State the weighted-average cost formula.
5. What is the purpose of a physical stock count?

Long Answer Questions

1. Explain the relationship among stock groups, categories, items, units, and godowns.
2. Compare FIFO, weighted average, and specific identification.
3. Describe the complete purchase cycle from order to invoice.
4. Explain how sales orders, delivery notes, and sales invoices differ.
5. Discuss the internal controls required for reliable inventory records.

Analytical / Application Questions

1. A company has duplicate item names, damaged goods mixed with saleable stock, and unexplained negative balances. Propose a master-data and control improvement plan.
2. A warehouse receives 500 units but the invoice covers 480 units. Explain which documents should be entered and how the difference should be investigated.
3. A business transfers goods between two warehouses and later sells them. Explain the vouchers, location effects, and accounting considerations in sequence.

Multiple Choice Questions with Answers

Question 1

Which master identifies the specific product being purchased or sold?

A. Stock item

B. Godown

C. Stock category

D. Voucher type

Correct Answer: A. Stock item

Question 2

A purchase order normally records:

A. A completed cash payment

B. A commitment to purchase

C. A stock write-off

D. A sales return

Correct Answer: B. A commitment to purchase

Question 3

Which document primarily records goods dispatched to a customer?

A. Receipt note

B. Purchase order

C. Delivery note

D. Stock journal

Correct Answer: C. Delivery note

Question 4

Under moving average, 100 units at ₹20 and 50 units at ₹26 produce an average cost of:

A. ₹20

B. ₹21

C. ₹22

D. ₹26

Correct Answer: C. ₹22

Question 5

A transfer from one godown to another normally:

A. Increases total company stock

B. Decreases total company stock

C. Changes location but not total company stock

D. Creates sales revenue

Correct Answer: C. Changes location but not total company stock

Question 6

Which method assigns the oldest available cost to issues first?

A. FIFO

B. Specific identification

C. Standard costing only

D. Last-in, first-out exclusively

Correct Answer: A. FIFO

Question 7

If 96 units are received and 10 are sold, with no other movement, remaining stock is:

A. 86 units

B. 90 units

C. 96 units

D. 106 units

Correct Answer: A. 86 units

Question 8

A damaged-stock godown is useful because it:

A. Automatically converts damage into profit

B. Separates potentially unavailable goods from saleable stock

C. Eliminates the need for physical counts

D. Prevents all stock losses

Correct Answer: B. Separates potentially unavailable goods from saleable stock

Question 9

Which control best reduces the risk that one employee can order, receive, and approve payment for goods?

A. Using longer item names

B. Segregation of duties

C. Removing voucher numbers

D. Allowing unrestricted back-dated entries

Correct Answer: B. Segregation of duties

Question 10

Specific identification is most appropriate for:

A. Interchangeable identical screws

B. Bulk grains with common costs

C. Individually identifiable customised equipment

D. All low-value consumables

Correct Answer: C. Individually identifiable customised equipment