Stock Items & Masters Setup
Prerequisite: Day 13 - Units of Measure
🎯 Learning Objectives:
- Create Stock Items with applicable units & groups
- Set opening inventory quantities and rate valuations
- Configure godowns/locations in TallyPrime
- Verify Stock Summary report
2. What is this?
Simple Layman Definition: Stock Items & Masters Setup is an essential component of TallyPrime Basics, providing structured operational procedures to ensure commercial compliance and financial clarity.
Professional Accounting Definition: Stock Items & Masters Setup represents a standardized accounting and enterprise resource management methodology governed by Indian Accounting Standards (Ind-AS) and statutory regulatory mandates in TallyPrime.
| Aspect | Details & Practical Relevance |
|---|---|
| Primary Purpose | To systematically process, control, audit, and report stock items & masters setup transactions with maximum financial accuracy and operational efficiency. |
| Where It Is Used | Implemented across corporate enterprises, SME trading houses, manufacturing plants, distribution networks, and chartered accountancy firms in India. |
| Who Uses It | Senior Accountants, Tally Operators, Accounts Executives, Finance Controllers, and Tax Auditors. |
| Why It Matters in Accounting Jobs | Mastery of Stock Items & Masters Setup is directly tested in accounting employment interviews and required in day-to-day corporate accounts administration. |
📌 Real-Life Workplace Example:
A registered trading firm in Mumbai executes stock items & masters setup to maintain real-time compliance with suppliers, clients, and GST authorities.
3. Why is this Important?
- Why Businesses Use It: Prevents revenue leakage, optimizes capital utilization, satisfies statutory audits, and preserves accurate corporate ledger history.
- Why Accountants Need It: Provides a structured protocol to record entries correctly on the first attempt without risking post-audit adjustments.
- Why Required in TallyPrime: TallyPrime automates report compilation, GST triangulation, and ledger balancing when Stock Items & Masters Setup is configured properly.
- What Problem It Solves: Eliminates manual calculation errors, reconciles discrepancy gaps, and prevents non-compliance penalties under tax regulations.
- What Happens If Not Used Correctly: Incorrect handling causes erroneous financial statements, misleading management reports, and statutory penalties under GST/Income Tax Acts.
4. When is it Used?
Executed whenever relevant commercial events occur during the daily billing, payment, inventory movement, or period-end closing cycles.
⚖️ Decision-Making Rule:
Whenever evaluating this transaction, verify whether it represents an Asset, Liability, Revenue, or Expense. Apply double-entry rules strictly: Total Debits must equal Total Credits before confirming in TallyPrime.
5. How Does it Work?
The operational flow for Stock Items & Masters Setup follows a clear sequential procedure:
1. Source Document Verification
➔
2. Identify Debit & Credit Ledgers
➔
3. Input in TallyPrime
➔
4. Audit & Reconcile Reports
- 1. Verify authorization and underlying source document (invoice, challan, advice, or receipt).
- 2. Identify the applicable accounts or inventory items affected by the stock items & masters setup transaction.
- 3. Apply appropriate accounting rules, tax slabs, or inventory valuation parameters.
- 4. Navigate to the designated menu in TallyPrime and input mandatory master/voucher parameters.
- 5. Verify arithmetical balance, GST/TDS tax calculations, and bill-wise reference allocations.
- 6. Accept and save the entry; verify report reflections in Trial Balance, Stock Summary, or Day Book.
6. Accounting Logic & Journal Entry
Representative Transaction
Double-Entry Standard
"Created new ledger 'Godrej Appliances' under Sundry Creditors with ₹1,20,000 opening credit balance."
Identified Accounts: Godrej Appliances (Sundry Creditor) | Opening Balance (Equity/Liability)
Applied Rule: Credit opening balances of creditors and liabilities; Debit opening balances of debtors and assets.
Applied Rule: Credit opening balances of creditors and liabilities; Debit opening balances of debtors and assets.
| Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
| Difference in Opening Balances | ₹1,20,000 | |
| To Godrej Appliances A/c | ₹1,20,000 |
(Being opening balance entered from previous financial year balance sheet.)
Why This Logic Works: The primary account is debited to recognize asset addition or operating expense; the bank account is credited to reflect the reduction in liquid funds.
7. TallyPrime Practical Execution (Step-by-Step)
1
Open Gateway of Tally
Launch TallyPrime
Load Active Company
2
Open Target Function
Press Alt+G (Go To) or select required menu for Stock Items & Masters Setup
3
Select Mode / Voucher
Press designated shortcut key (e.g. F2 for Date, F4-F9 for Vouchers)
4
Input Party / Account
Select Debit and Credit ledgers or relevant item masters
5
Verify Values & Tax
Ensure invoice value, quantity, and statutory duty match source bills
6
Enter Bill-wise Reference
Allocate New Ref, Agst Ref, or Advance with credit terms
7
Save & Verify
Press Ctrl+A to save; inspect Trial Balance or Day Book to audit posting
8. Field-by-Field Screen Breakdown
| Field Name | Meaning & Significance | What to Enter | Accounting / Compliance Rule |
|---|---|---|---|
| Date | Effective transaction date | Current transaction date |
Must fall within active Financial Year |
| Particulars | Target ledger account | Applicable master ledger |
Select from pre-configured Chart of Accounts |
| Amount | Monetary transaction value | Exact invoice/voucher value |
Must balance exactly between Dr and Cr |
| Narration | Audit transaction description | Description for Stock Items & Masters Setup |
Document voucher/instrument numbers for audit trail |
| Tax / Duty | Statutory deduction or tax | Applicable GST/TDS head |
Auto-computed or selected as per tax rate |
9. Real-World Business Case Scenarios
🏢 Indian Corporate Scenario:
Zenith Enterprises (Noida, UP) maintains computerized accounting for Stock Items & Masters Setup across its trading operations with monthly turnover of ₹45 Lakhs.
10. Dedicated Practice Set & Tally Datasets
📝 Practical Assignment: Inventory Stock Items Creation Practice Set
Record the following transactions in TallyPrime and verify ledger postings.
| Stock Item Name | Stock Group | Unit (UoM) | HSN Code | GST % | Opening Qty | Rate (₹) | Opening Value (₹) |
|---|---|---|---|---|---|---|---|
| Samsung 43" Smart LED TV | Television | Nos | 8528 | 18% | 10 Nos | 22,000 | 2,20,000 |
| LG 55" 4K OLED Smart TV | Television | Nos | 8528 | 18% | 5 Nos | 58,000 | 2,90,000 |
| Sony Bravia 65" Ultra HD TV | Television | Nos | 8528 | 18% | 4 Nos | 75,000 | 3,00,000 |
| LG 1.5 Ton 5-Star Split AC | Air Conditioners | Nos | 8415 | 28% | 8 Nos | 31,000 | 2,48,000 |
| Daikin 1.0 Ton 3-Star Inverter AC | Air Conditioners | Nos | 8415 | 28% | 6 Nos | 27,500 | 1,65,000 |
| Voltas 2.0 Ton Cassette AC | Air Conditioners | Nos | 8415 | 28% | 3 Nos | 46,000 | 1,38,000 |
| Dell Inspiron Core i5 Laptop | Computers | Nos | 8471 | 18% | 12 Nos | 44,000 | 5,28,000 |
| HP Pavilion Core i7 Laptop | Computers | Nos | 8471 | 18% | 7 Nos | 62,000 | 4,34,000 |
| Canon ImageRunner 2006 MFD | Printers | Nos | 8443 | 18% | 4 Nos | 38,000 | 1,52,000 |
| Epson EcoTank L3210 Printer | Printers | Nos | 8443 | 18% | 15 Nos | 11,500 | 1,72,500 |
🔍 Checking Effect & Report Verification in TallyPrime:
Navigation Path:
Gateway of Tally → Stock Summary (Press Alt + F1 or Alt + F5 for Detailed View)
(Shortcut: Press Alt + G → Type 'Statistics' → Drill down into voucher type)
Audit Checkpoint: Check that Total Closing Stock Valuation matches exactly ₹26,47,500 across 74 total units in inventory.
🟢 Level 1 – Basic Knowledge & Mechanics (5 Questions)
Q1: What are the 3 mandatory masters required before creating a Stock Item in TallyPrime?
Standard Solution & Accounting Treatment:
1. Unit of Measure (UoM), e.g. Nos, Pcs, Kgs. 2. Stock Group (category). 3. Tax / GST Rate configuration.
1. Unit of Measure (UoM), e.g. Nos, Pcs, Kgs. 2. Stock Group (category). 3. Tax / GST Rate configuration.
Q2: What is the difference between Simple Unit and Compound Unit?
Standard Solution & Accounting Treatment:
Simple unit has a single measure (e.g. Nos, Box). Compound unit expresses a relationship between two simple units (e.g. 1 Box = 20 Nos).
Simple unit has a single measure (e.g. Nos, Box). Compound unit expresses a relationship between two simple units (e.g. 1 Box = 20 Nos).
Q3: What is an HSN Code?
Standard Solution & Accounting Treatment:
Harmonized System of Nomenclature: an 8-digit international code used under GST to standardize commodity classifications.
Harmonized System of Nomenclature: an 8-digit international code used under GST to standardize commodity classifications.
Q4: Where can you see the consolidated value of all stock items?
Standard Solution & Accounting Treatment:
Gateway of Tally → Stock Summary.
Gateway of Tally → Stock Summary.
Q5: What shortcut key allows instant creation of a new unit while creating a stock item?
Standard Solution & Accounting Treatment:
Press Alt + C in the Unit selection field.
Press Alt + C in the Unit selection field.
🟡 Level 2 – Intermediate Practical Voucher Problems (5 Questions)
Q1: Configure a stock item with 18% GST and HSN 8528 in TallyPrime.
Standard Solution & Accounting Treatment:
Create Stock Item → Specify Details: Statutory Details → Set 'GST Applicable' to Applicable → HSN: 8528 → Taxability: Taxable → Integrated Tax: 18% (Central 9%, State 9%).
Create Stock Item → Specify Details: Statutory Details → Set 'GST Applicable' to Applicable → HSN: 8528 → Taxability: Taxable → Integrated Tax: 18% (Central 9%, State 9%).
Q2: How do you enable Godowns (Locations) in TallyPrime?
Standard Solution & Accounting Treatment:
Press F11 (Features) or Gateway of Tally → Create → Godowns → Enter Name (e.g. Warehouse A, Shop Floor).
Press F11 (Features) or Gateway of Tally → Create → Godowns → Enter Name (e.g. Warehouse A, Shop Floor).
Q3: Explain the effect of entering Opening Stock quantity and rate.
Standard Solution & Accounting Treatment:
Tally automatically updates Opening Stock in Trading Account and Current Assets on the Balance Sheet.
Tally automatically updates Opening Stock in Trading Account and Current Assets on the Balance Sheet.
Q4: How do you set a Minimum Reorder Level for an item?
Standard Solution & Accounting Treatment:
F11 → Enable 'Reorder Levels' → Gateway of Tally → Alter → Reorder Levels → Stock Items.
F11 → Enable 'Reorder Levels' → Gateway of Tally → Alter → Reorder Levels → Stock Items.
Q5: How do you change stock valuation method from Average Cost to FIFO in TallyPrime?
Standard Solution & Accounting Treatment:
Gateway of Tally → Alter → Stock Item → Press F12 (Configure) → Set 'Costing Method' to FIFO.
Gateway of Tally → Alter → Stock Item → Press F12 (Configure) → Set 'Costing Method' to FIFO.
🔴 Level 3 – Job & Industry Audit Scenarios (5 Questions)
Q1: Why should negative stock balance warnings never be ignored by an accountant?
Standard Solution & Accounting Treatment:
Negative stock indicates sales recorded before purchases or data-entry omissions, corrupting cost of goods sold and distorting GST input-output balances.
Negative stock indicates sales recorded before purchases or data-entry omissions, corrupting cost of goods sold and distorting GST input-output balances.
Q2: How do you record physical stock verification discrepancies (damaged or missing items) in Tally?
Standard Solution & Accounting Treatment:
Gateway of Tally → Vouchers → Other Vouchers (F10) → Physical Stock (Ctrl + F7) → Enter actual physical counted quantity. Tally passes automatic adjustment.
Gateway of Tally → Vouchers → Other Vouchers (F10) → Physical Stock (Ctrl + F7) → Enter actual physical counted quantity. Tally passes automatic adjustment.
Q3: How do you track inventory stored in multiple godowns during invoice billing?
Standard Solution & Accounting Treatment:
In Item Allocation sub-screen, select Godown (e.g. Main Godown or Retail Counter) for each item line.
In Item Allocation sub-screen, select Godown (e.g. Main Godown or Retail Counter) for each item line.
Q4: What is the Unit Quantity Code (UQC) and why is it mandatory for e-Invoicing?
Standard Solution & Accounting Treatment:
UQC is the 3-letter statutory unit code (e.g. NOS, KGS, BOX) required by the GST portal schema for e-Invoicing and e-Way Bills.
UQC is the 3-letter statutory unit code (e.g. NOS, KGS, BOX) required by the GST portal schema for e-Invoicing and e-Way Bills.
Q5: How do you view item movement analysis in TallyPrime?
Standard Solution & Accounting Treatment:
Gateway of Tally → Display More Reports → Inventory Books → Movement Analysis → Stock Item Analysis.
Gateway of Tally → Display More Reports → Inventory Books → Movement Analysis → Stock Item Analysis.
⚡ Industry Challenge Scenarios (2 Complex Cases)
Challenge 1: Create a compound unit 'Box of 24 Cans' and record a purchase of 50 Boxes @ ₹1,200/Box. Then sell 120 Cans @ ₹65/Can. Show remaining stock.
Detailed Professional Solution:
Purchase = 50 Boxes = 1,200 Cans @ ₹50/Can. Sale = 120 Cans. Remaining Stock = 1,080 Cans (45 Boxes) valued at ₹54,000.
Purchase = 50 Boxes = 1,200 Cans @ ₹50/Can. Sale = 120 Cans. Remaining Stock = 1,080 Cans (45 Boxes) valued at ₹54,000.
Challenge 2: An item purchased for ₹1,000 is valued at FIFO. Next batch purchased for ₹1,200. 1 unit sold. Compare FIFO vs LIFO cost of goods sold.
Detailed Professional Solution:
FIFO COGS = ₹1,000 (first batch consumed, higher closing stock ₹1,200). LIFO COGS = ₹1,200 (latest batch consumed, lower closing stock ₹1,000).
FIFO COGS = ₹1,000 (first batch consumed, higher closing stock ₹1,200). LIFO COGS = ₹1,200 (latest batch consumed, lower closing stock ₹1,000).
11. Practical Company Simulation Scenario
🏢 Company Case Study: Sharma Enterprises Pvt. Ltd.
Financial Year: 01-Apr-2026 to 31-Mar-2027 | Location: Delhi (State Code: 07)
Starting Balances: Cash in Hand ₹75,000 | State Bank of India ₹3,50,000 | Capital ₹5,00,000 | Anil InfoTech (Creditor) ₹1,27,500 | Deepak Creation (Debtor) ₹1,55,000
Dated Transaction Schedule for TallyPrime:
- 01-Apr-2026: Settle pending payment to Anil InfoTech of ₹1,27,500 against Bill # P-106 via SBI Bank cheque # 500101.
- 02-Apr-2026: Collect ₹1,55,000 from Deepak Creation against Bill # 102 deposited directly into SBI Current Account.
- 04-Apr-2026: Execute transaction for Stock Items & Masters Setup valued at ₹45,000.
- 07-Apr-2026: Paid monthly shop rent ₹25,000 by cheque and stationery ₹2,400 in cash.
- 10-Apr-2026: Audit voucher postings in Day Book and confirm that no entries remain unallocated.
12. Expected Reports & Verification Keys
| Voucher Type | Debit Account | Credit Account | Amount (₹) | Audit Verification Key |
|---|---|---|---|---|
| F5 / F6 / F7 | Target Expense / Asset A/c | Bank / Cash / Creditor | ₹45,000.00 | Reflected in Day Book & Statistics register |
13. Common Mistakes & How to Avoid Them
❌ WRONG: Executing Stock Items & Masters Setup under incorrect ledger group in TallyPrime
✅ CORRECT: Verify group classification in Chart of Accounts before recording entry
❌ WRONG: Omitting narration and source document reference numbers
✅ CORRECT: Always input invoice, challan, or cheque numbers in the narration field
❌ WRONG: Failing to select bill-wise reference details for debtor/creditor entries
✅ CORRECT: Always allocate against specific bill numbers to avoid 'On Account' ambiguity
❌ WRONG: Recording transactions without verifying applicable GST/TDS rates
✅ CORRECT: Confirm tax rates against latest CBIC notifications or party PAN status
❌ WRONG: Bypassing bank date allocation during reconciliation
✅ CORRECT: Input actual date from bank passbook statement to preserve BRS accuracy
14. Job-Oriented Interview Questions & Answers
Basic Interview Questions
1. What is the role of Stock Items & Masters Setup in financial accounting? ▾
2. Which menu in TallyPrime provides access to Stock Items & Masters Setup? ▾
3. Why is accurate source documentation mandatory for this topic? ▾
4. How does TallyPrime prevent unbalanced entries here? ▾
5. What is the consequence of selecting the wrong ledger group? ▾
Practical Interview Questions
1. Explain the step-by-step Tally procedure to configure Stock Items & Masters Setup. ▾
2. How do you verify that Stock Items & Masters Setup has been correctly posted? ▾
3. Which shortcut key is most vital when executing this task? ▾
4. How do statutory taxes integrate with Stock Items & Masters Setup? ▾
5. What report is reviewed by management to inspect this area? ▾
Scenario-Based Interview Questions
1. Your auditor notices a mismatch in Stock Items & Masters Setup during year-end finalization. How do you resolve it? ▾
2. A client requests an instant statement for Stock Items & Masters Setup. How do you generate it? ▾
3. An entry for Stock Items & Masters Setup was recorded with the wrong date. How do you correct it? ▾
15. Examination & Knowledge Assessment
16. Quick Revision & Key Takeaways
⚡ Essential Points to Remember:
- Core Concept: Stock Items & Masters Setup is an essential component of TallyPrime Basics, providing structured operational procedures to ensure commercial compliance and financial clarity.
- Accounting Law: Every transaction impacts at least two accounts in opposite directions (Dr = Cr).
- Master Navigation: Gateway of Tally → Vouchers or Masters → Save with
Ctrl + A. - Audit Verification: Always cross-reference Day Book postings against physical source bills.
- Compliance Focus: Adhere strictly to Indian Accounting Standards and GST/TDS provisions.
💡 Golden Takeaway: Always audit your entries before closing the day. Accurate bookkeeping today prevents severe audit and tax liabilities tomorrow!
17. Calculation Formulas & Logic
📐 Applicable Formula:
Financial Equilibrium: Total Debits (Dr) = Total Credits (Cr) | Net Value = Gross Amount - Discounts + Applicable Taxes
18. Practical Execution Checklist
Daily Practical Task Milestones (Saved in Browser)
0 / 5 Completed