Inventory Accounting in TallyPrime: Complete Step-by-Step Guide with Practical Examples & Free PPT
Inventory management is an essential part of business accounting. Whether you operate a retail shop, wholesale business, manufacturing unit or trading company, maintaining accurate stock records helps you control inventory, track purchases and sales, and prepare reliable financial statements.
TallyPrime simplifies inventory accounting by integrating stock transactions with your accounting records.
We have also provided a free PowerPoint presentation (PPT) to help accounting students, professionals and business owners understand inventory accounting.
What Is Inventory Accounting in TallyPrime?
Inventory Accounting is the process of recording, monitoring and valuing the goods purchased, sold, stored or transferred by a business.
It involves maintaining records of:
- Opening Stock
- Purchases and Sales
- Stock Items and Stock Groups
- Godown and Warehouse Transfers
- Physical Stock Adjustments
- Closing Stock Valuation
- Inventory Reports
Benefits of Inventory Accounting
Accurate Stock Tracking: Monitor the available quantity of each stock item.
Better Purchase Planning: Identify when products need to be reordered.
Improved Financial Reporting: Maintain stock values that support the preparation of the Profit & Loss Account and Balance Sheet.
Reduced Stock Differences: Compare actual warehouse quantities with accounting records.
Better Business Decisions: Identify slow-moving stock, stock shortages and inventory levels.
How to Enable Inventory Accounting in TallyPrime
Before recording inventory transactions, check the company’s inventory settings.
Step-by-Step Process
- Open your company in TallyPrime.
- Go to Gateway of Tally.
- Press F11 (Features).
- Check that Maintain Inventory is set to Yes.
- Enable Integrate Accounts with Inventory if you want inventory values linked with accounting reports.
- Save the settings using Ctrl + A.
Important: Maintain Inventory is generally enabled by default in current TallyPrime versions. The accounts-inventory integration option can be enabled according to business requirements.
Businesses managing multiple warehouses or batches should also configure the relevant godown and batch features.
Inventory Masters in TallyPrime
Inventory Masters form the foundation of stock accounting. Creating the correct masters helps avoid duplicate items and incorrect inventory records.
A. Stock Group
A Stock Group classifies similar inventory items.
Example:
Stock Group: Electrical Goods
Stock Items:
- Ceiling Fan 1200mm
- LED Bulb
- Electric Switch
Stock Groups help businesses generate category-wise inventory reports.
B. Stock Category
Stock Categories provide another way to classify inventory independently of Stock Groups.
For example, electrical products may be categorized according to brand or product characteristics.
C. Stock Item
A Stock Item represents an individual product purchased, sold or stored.
Examples include Ceiling Fan 1200mm, LED Bulb 9W and Copper Wire.
D. Units of Measurement
Units define how stock quantities are measured.
Common examples:
| Unit | Meaning |
| Nos | Numbers |
| Kg | Kilograms |
| Ltr | Litres |
| Box | Boxes |
| Mtr | Metres |
TallyPrime also supports compound units, such as:
1 Box = 12 Nos
For GST reporting, use the appropriate Unit Quantity Code (UQC).
E. Godown / Location
Godowns represent the locations where inventory is stored.
Examples:
- Main Location
- Pune Warehouse
- Nashik Shop
Godown-wise inventory management helps businesses identify available stock at different locations.
How to Create a Stock Item in TallyPrime
Let’s understand stock item creation with a practical example.
Example: Ceiling Fan 1200mm
| Particulars | Details |
| Stock Item | Ceiling Fan 1200mm |
| Stock Group | Electrical Goods |
| Unit | Nos |
| Opening Quantity | 50 Nos |
| Opening Rate | ₹1,000 |
| Opening Value | ₹50,000 |
| Godown | Main Location |
Steps to Create a Stock Item
- Go to Gateway of Tally → Create → Stock Item.
- Enter the stock item name.
- Select the appropriate Stock Group.
- Select the Unit of Measurement.
- Enter applicable GST details.
- Enter opening quantity and rate.
- Select the godown, if applicable.
- Press Ctrl + A to save.
Opening Stock Value = Quantity × Rate
50 × ₹1,000 = ₹50,000
Ensure that the correct HSN classification and applicable GST rate are entered for the product.
Purchase Entry in TallyPrime (F9)
When goods are purchased, the available inventory quantity increases.
Practical Purchase Example
A business purchases 100 ceiling fans from Shree Traders, Pune.
| Particulars | Details |
| Supplier | Shree Traders |
| Invoice Number | SI/1045 |
| Stock Item | Ceiling Fan 1200mm |
| Purchase Quantity | 100 Nos |
| Rate | ₹1,100 |
| Purchase Value | ₹1,10,000 |
How to Record a Purchase Voucher
- Open Gateway of Tally → Vouchers.
- Press F9 (Purchase).
- Select Item Invoice mode using Ctrl + H if necessary.
- Select the supplier and purchase ledger.
- Enter the stock item, quantity and rate.
- Select the appropriate godown.
- Complete the applicable GST details.
- Save the voucher.
After recording this transaction:
Opening Stock: 50 Nos
Purchase: 100 Nos
Total Available Stock: 150 Nos
Sales Entry in TallyPrime (F8)
Sales vouchers record goods sold to customers and reduce inventory quantities.
Practical Sales Example
A business sells 80 ceiling fans to Ganesh Electric Stores, Sangamner.
| Particulars | Details |
| Customer | Ganesh Electric Stores |
| Sales Quantity | 80 Nos |
| Selling Rate | ₹1,500 |
| Sales Amount | ₹1,20,000 |
Steps for Sales Entry
- Open Gateway of Tally → Vouchers.
- Press F8 (Sales).
- Select Item Invoice mode.
- Select the customer and sales ledger.
- Enter stock item details.
- Enter quantity and selling rate.
- Select the godown.
- Add applicable GST details and save.
Stock Position After Sales
Opening Stock = 50 Nos
Add: Purchases = 100 Nos
Less: Sales = 80 Nos
Closing Stock = 70 Nos
TallyPrime updates stock quantities based on the inventory transactions recorded.
Stock Journal in TallyPrime (Alt + F7)
Stock Journal is an inventory voucher used for recording stock transfers, material consumption, production and certain stock adjustments.
Example: Godown Transfer
A business transfers 20 ceiling fans from Main Location to Nashik Shop.
Before Transfer
Main Location: 70 Nos
Nashik Shop: 0 Nos
After Transfer
Main Location: 50 Nos
Nashik Shop: 20 Nos
Total Inventory: 70 Nos
How to Record the Transfer
- Open the Stock Journal voucher using Alt + F7.
- Under Source, select the item and source godown.
- Enter 20 Nos.
- Under Destination, select the same item and destination godown.
- Enter the transferred quantity and relevant values.
- Save the voucher.
Important: A normal godown transfer changes the stock location, not the overall stock quantity.
Physical Stock Verification in TallyPrime
Physical stock verification means counting the goods actually available in the warehouse and comparing them with the quantity recorded in TallyPrime.
Practical Example
Book Stock: 50 Nos
Actual Physical Stock: 48 Nos
Difference: 2 Nos Shortage
Steps to Record Physical Stock
- Open Gateway of Tally → Vouchers.
- Press Ctrl + F7 (Physical Stock).
- Select the stock item and godown.
- Enter the physically verified quantity.
- Mention the reason for any difference in the narration.
- Save the voucher.
After the adjustment, the inventory record reflects the physical quantity.
Why Is Physical Stock Verification Important?
Regular verification helps identify stock shortages, recording errors, damages and discrepancies between warehouse records and accounting books.
Businesses should perform stock reconciliation periodically, based on transaction volume and inventory risk.
Closing Stock Calculation in TallyPrime
| Transaction | Quantity |
| Opening Stock | 50 Nos |
| Add: Purchases | 100 Nos |
| Less: Sales | (80 Nos) |
| Less: Physical Shortage | (2 Nos) |
Closing Stock | 68 Nos |
Closing Stock Formula
Opening Stock + Purchases − Sales − Stock Shortage = Closing Stock
50 + 100 − 80 − 2 = 68 Nos
If the applicable weighted average cost is approximately ₹1,066.67 per unit, the illustrative closing stock value is approximately ₹72,533.
The actual value reported by TallyPrime depends on the selected valuation method, transaction details and rounding.
Physical Stock Verification in TallyPrime
Stock Valuation Methods in TallyPrime
Stock valuation determines the monetary value assigned to inventory.
TallyPrime supports various costing methods, including Average Cost and FIFO.
A. Weighted Average Cost Method
Under this method, stock is valued using the average cost of available inventory.
Example
Opening Stock: 50 Nos × ₹1,000 = ₹50,000
Purchase: 100 Nos × ₹1,100 = ₹1,10,000
Total Quantity: 150 Nos
Total Cost: ₹1,60,000
Average Cost = ₹1,60,000 ÷ 150
Average Cost = ₹1,066.67 per unit
Before physical stock adjustment, closing quantity is 70 Nos.
Closing Stock Value = Approximately ₹74,666.67
B. FIFO Method (First In, First Out)
Under FIFO, the earliest purchased inventory is considered sold first.
In our example, the remaining 70 ceiling fans are valued at ₹1,100 per unit.
70 × ₹1,100 = ₹77,000
Comparison of Stock Valuation
| Particulars | Weighted Average | FIFO |
| Closing Stock Qty | 70 Nos | 70 Nos |
| Closing Stock Value | ₹74,666.67 | ₹77,000 |
| Cost of Goods Sold | ₹85,333.33 | ₹83,000 |
| Gross Profit | ₹34,666.67 | ₹37,000 |
This comparison is before the 2-unit physical stock adjustment and excludes GST and other expenses.
For financial reporting, applicable accounting standards generally require inventories to be valued at the lower of cost and net realisable value, with permitted cost formulas applied consistently
Important Inventory Reports in TallyPrime
Stock Summary
Displays stock quantity, rate and value.
Godown Summary
Shows available inventory at different storage locations.
Movement Analysis
Helps analyze inward and outward movements of stock items.
Stock Ageing Analysis
Identifies inventory that has remained unsold or unused for extended periods.
Reorder Status
Helps determine which items require replenishment based on configured reorder levels.
Stock Query
Provides details relating to a selected stock item.
Reviewing these reports regularly can improve stock control, purchasing decisions and working capital management.
Important TallyPrime Inventory Shortcut Keys
| Function | Shortcut |
| Purchase Voucher | F9 |
| Sales Voucher | F8 |
| Receipt Note | Alt + F9 |
| Delivery Note | Alt + F8 |
| Rejection In | Ctrl + F6 |
| Rejection Out | Ctrl + F5 |
| Stock Journal | Alt + F7 |
| Physical Stock | Ctrl + F7 |
| Change Voucher Mode | Ctrl + H |
| Save Voucher | Ctrl + A |
Shortcut availability may depend on your TallyPrime version, voucher configuration and the screen being used.
Best Practices for Inventory Accounting
For accurate inventory management, businesses should follow a systematic accounting process.
- Create standardized Stock Groups, Stock Items and Units.
- Avoid duplicate stock masters.
- Record purchases and sales promptly.
- Maintain proper godown-wise records.
- Reconcile physical stock with book stock.
- Review stock valuation methods and accounting policies.
- Monitor slow-moving and obsolete inventory.
- Verify stock values before financial statement finalization.
- Maintain proper supporting documents for stock adjustments.
- Review inventory reports regularly.
These practices help create reliable inventory records and improve business control.
Download Free Inventory Accounting in TallyPrime PPT
Want to learn Inventory Accounting in TallyPrime with practical examples and visual explanations?
SLH Advisors Pvt. Ltd. has prepared a PowerPoint presentation covering:
- Inventory Accounting Basics
- Inventory Configuration
- Stock Groups, Items and Units
- Purchase and Sales Entries
- Stock Journal and Godown Transfer
- Physical Stock Verification
- Stock Valuation Methods
- Inventory Reports
- Practical TallyPrime Examples
Physical Stock Verification in TallyPrime
Physical Stock Verification in TallyPrime