Actual Aur Billed Quantities (Buy 1 Get 1 Free)

Learning Objectives

Day 8 complete karne ke baad student:

  • Actual Quantity aur Billed Quantity ke beech ka fundamental difference samjhega.
  • Same transaction mein physical movement (Actual Qty) aur commercial charging (Billed Qty) ko separately enter karega.
  • Free/Bonus quantities (e.g., Buy 10 Get 1 Free) ka inventory aur effective cost par impact samjhega.
  • Purchase aur Sales mein Actual > Billed (Excess/Free) aur Actual < Billed (Short Receipt/Short Dispatch) scenarios record karega.
  • Inventory physical stock movement aur invoice value calculation ke relation ko master karega.
  • Purchase/Sales registers aur Stock Summary se actual vs billed quantities verify karega.

Core Concepts: Actual Quantity vs Billed Quantity

Advanced inventory management mein yeh ensure karna zaroori hota hai ki warehouse mein physically kitna maal aaya/gaya (Actual) aur invoice par kitne units ka bill bana (Billed):

  • Actual Quantity: Warehouse mein physically receive ya dispatch hone wali exact units (Inventory ledger impact).
  • Billed Quantity: Invoice par customer ya vendor dwara charge kiye jaane wali units (Financial/Billing ledger impact).

Comparison & Scenarios Matrix

Scenario Type Billed Quantity Actual Quantity Difference Meaning / Business Context
Normal Transaction 100 Nos 100 Nos No difference; standard purchase or sale.
Free / Bonus Qty (Actual > Billed) 100 Nos 110 Nos 10 units received free as promotional bonus. Effective unit cost decreases.
Short Receipt / Short Dispatch (Actual < Billed) 100 Nos 95 Nos 5 units short in transit or skipped during loading. Claims/adjustments required.
Golden Inventory Rule:
Actual Quantity hamesha physical stock inventory balance ko update karti hai.
Billed Quantity hamesha financial invoice value aur party ledger amount ko compute karti hai.

Practice Configuration & Feature Activation

TallyPrime mein separate actual aur billed quantities enter karne ke liye invoice configuration mein appropriate feature enabled hona chahiye (Use separate actual and billed quantities in invoices).

Practice Company Profile

  • Company: ABC Traders | State: Maharashtra | FY: 2026–27 | Inventory: Enabled

Practical Walkthroughs: Free Quantity & Short Receipts

Part A: Purchase with Free Quantity (Actual > Billed)

  1. Scenario: Purchased 100 Printers @ ₹8,000 from Tech Supplier under a promotional scheme where supplier gives 10 Printers completely free. Total physical units received = 110.
  2. TallyPrime Steps: Go to Vouchers → Select Purchase (F9) → Select Party: Tech Supplier → Item: Printer.
  3. Enter Billed Qty: 100, Rate: ₹8,000, and enter Actual Qty: 110.
  4. Financial Impact: Invoice basic value is calculated on 100 units (₹8,00,000), while physical stock ledger increases by 110 units, lowering the effective purchase cost per unit (₹8,00,000 ÷ 110 = ₹7,272.73).

Part B: Purchase with Short Receipt (Actual < Billed)

  1. Scenario: Supplier invoice states 200 Mouse @ ₹500 = ₹1,00,000, but physical verification reveals only 190 Mouse were delivered.
  2. TallyPrime Steps: In Purchase Voucher, enter Billed Qty: 200 and Actual Qty: 190 at rate ₹500.
  3. Result: Party ledger gets credited for the full billed invoice value (₹1,00,000), while physical stock increases by 190 units, leaving a 10-unit discrepancy to be resolved via debit note or vendor credit.

Complete Practice Sets

Practice Set (Mixed Actual & Billed Lab):

Transaction Item Name Billed Qty Actual Qty Rate (₹) Expected Stock Impact
Purchase 1 (Bonus) Printer 100 110 8,000 Stock increases by 110 units
Purchase 2 (Bonus) Keyboard 50 55 1,000 Stock increases by 55 units
Purchase 3 (Short) Mouse 200 190 500 Stock increases by 190 units
Sales 1 (Promotional) Printer 20 22 10,000 Stock decreases by 22 units
Sales 2 (Short Dispatch) Mouse 100 95 700 Stock decreases by 95 units

Verification Reports, Common Mistakes & FAQs

Verification Reports in TallyPrime:

  • Purchase Register & Sales Register: Check column splits showing Billed Quantity vs Actual Quantity alongside invoice values.
  • Stock Summary: Confirm that inventory closing balances reflect physical Actual Quantities rather than billed line items.

Common Mistakes:

  • Entering equal actual and billed quantities out of habit, ignoring promotional free items or short shipments.
  • Calculating inventory valuation based solely on billed quantities, leading to distorted unit cost averages.
  • Confusing a short receipt (Actual < Billed) with a standard purchase return entry.

Frequently Asked Questions:

  • Q: Actual Quantity aur Billed Quantity mein mukhya antar kya hai?
    A: Actual Quantity warehouse mein aane ya jaane wale physical stock ko represent karti hai, jabki Billed Quantity invoice par charge kiye jaane wale units hoti hai.
  • Q: Free quantity milne par effective cost per unit par kya asar padta hai?
    A: Total invoice value ko jab zyaada actual units se divide kiya jaata hai, toh effective acquisition cost per unit kam ho jaati hai.
  • Q: Kya yeh feature sales transactions mein bhi use ho sakta hai?
    A: Haan, jab business apne customers ko bonus ya promotional free units dispatch karta hai, tab Sales voucher mein bhi yeh use hota hai.

Quick Revision & Completion Checklist

Actual vs Billed Golden Workflow:
Record Voucher (Purchase/Sales) → Enter Billed Qty (For Financial Valuation) → Enter Actual Qty (For Physical Stock) → Verify Effective Unit Cost → Reconcile Stock Summary

Completion Checklist:

  • Actual vs Billed quantity concept understood
  • Purchase entries with free/bonus quantities (Actual > Billed) recorded
  • Purchase entries with short receipts (Actual < Billed) recorded
  • Sales dispatch entries with promotional free items practiced
  • Purchase/Sales registers and Stock Summary reconciled