Inventory / Stock Reports
Stock is money sitting on your shelves. These reports tell you exactly how much is there, what it's worth, what's selling fast, and what's quietly gathering dust — so you buy smarter and free up cash. Most are built automatically from the items and transactions you've already recorded.
Read this first
- They're computed, not maintained. Quantities and values come from your invoices (out) and bills (in) — you don't update them by hand.
- Value uses weighted-average cost (WAC). A consistent, CA-acceptable basis for what your stock is worth.
- They answer real questions: What's low? What's dead? Which items earn most? What's my closing stock for the bank/CA?
What's covered
| Report | Answers | Plan |
|---|---|---|
| Stock Summary | Item-wise quantity, HSN and value on hand | Shuruat |
| HSN / SAC Summary | Rate-wise HSN totals (for GST) | Shuruat |
| Stock Aging | Days since last movement — Fresh / 31-90 / 91-180 / Dead | Samridhi |
| ABC Analysis | A=top 70% revenue · B=next 20% · C=bottom 10% | Samridhi |
| Closing Stock Certificate | CA-certifiable closing-stock statement (WAC/AS-2) | Unnati |
| Cost Centre / Category | Revenue & expense by product category | Unnati |
- Accuracy depends on recording purchases and sales against the right items — and on entering opening stock when you start.
- Value is WAC-based, which may differ from FIFO/last-purchase methods your CA might use elsewhere.
- Stock Aging, ABC are Samridhi+; Closing Stock Certificate & Cost Centre are Unnati+. Stock Summary & HSN are free.
The reports, in plain terms
Stock Summary Free
Your master list: each item's current quantity, HSN, and stock value. The fastest way to see "what do I have and what's it worth?"
help-shots/ir-01-summary.pngStock Aging & ABC Analysis Samridhi+
Stock Aging buckets items by how long since they last moved (Fresh / 31-90 / 91-180 / Dead stock) — so you spot money trapped in slow movers. ABC Analysis ranks items by revenue contribution (A/B/C), so you focus on the items that matter.
help-shots/ir-02-aging-abc.pngClosing Stock Certificate Unnati+
A CA-certifiable closing-stock statement valued on WAC/AS-2 — exactly what banks and auditors ask for at year-end. Print it to PDF.
help-shots/ir-03-closing-cert.pngKeeping stock accurate
Stock updates automatically as you sell and buy. After a physical count, use a stock adjustment to correct any difference (breakage, shrinkage, counting errors), and the stock movement history shows every in/out for an item so you can trace discrepancies.
Real situations
📖 After a stocktake
Riya counts her shelves and finds 3 fewer units than the system. She records a stock adjustment; valuation and reports correct instantly.
📖 Clearing dead stock
She opens Stock Aging, filters the "Dead" bucket, and runs a clearance offer on those items — turning trapped cash back into money.
📖 Bank wants a stock statement
For her cash-credit limit, the bank needs closing stock. Riya prints the Closing Stock Certificate (Unnati) to PDF and emails it.
Words you'll see, in plain language
| Term | What it means |
|---|---|
| WAC | Weighted Average Cost — the averaged cost used to value stock. |
| Dead stock | Items that haven't moved for a long time. |
| Aging bucket | Groups of items by days since last movement. |
| ABC analysis | Ranking items A/B/C by revenue contribution. |
| Closing stock | Value of stock on hand at period/year end. |
| Stock adjustment | A manual correction to recorded quantity (e.g. after a count). |
Troubleshooting
| What you notice | Why | What to do |
|---|---|---|
| Quantity doesn't match the shelf | Breakage/shrinkage or an un-recorded movement | Record a stock adjustment; check stock movements |
| Stock value looks off | Purchase price/opening stock not set | Set the item's cost and opening stock |
| Aging/ABC/Certificate locked | They're Samridhi+/Unnati+ | Use the free Stock Summary, or upgrade |
| An item not tracked in stock | Track Stock is off for it | Turn on Track Stock on the item |
Best practices
- Set opening stock and purchase price so values are right from day one.
- Do periodic stock counts and adjust differences promptly.
- Review Stock Aging monthly to clear dead stock before it ties up cash.
- Use ABC to prioritise your best sellers for reordering.
FAQ
How is stock value calculated?
On a weighted-average (WAC) basis, used across the stock and closing-stock reports.
How do I correct a wrong quantity?
Record a stock adjustment; the reports and valuation update immediately.
Which reports are free?
Stock Summary and HSN Summary. Aging/ABC are Samridhi+, Closing Stock Certificate & Cost Centre are Unnati+.
- Items & Inventory → item costs, opening stock, reorder levels.
- Sales & Purchases → stock out/in that move the numbers.
- Reports → the full library, incl. these — see CA Reports.
📸 Screenshot capture checklist
Drop each PNG into help-shots/ with the exact filename and it appears automatically.
| # | Screen to capture | Save as |
|---|---|---|
| IR-01 | Stock Summary | help-shots/ir-01-summary.png |
| IR-02 | Stock Aging buckets / ABC Analysis | help-shots/ir-02-aging-abc.png |
| IR-03 | Closing Stock Certificate | help-shots/ir-03-closing-cert.png |
Tip: use a populated demo company so aging and ABC look meaningful.