Loading...
HortipriseKnowledge BaseStock Inward & Outward Report
See how much stock came in and went out over any date range, filtered by item and category, and export it to Excel
Updated 2026-10-16
6 min read
Stock Inward & Outward Report
The In / Out Report answers the question every nursery owner asks at month end: how much stock came in, how much went out, and what is left? It reads the same stock ledger that powers your live stock balance, so the report can never disagree with what the Stock screen shows.
Where to find it
Stock → In / Out Report
Open Stock from the sidebar. The screen has two tabs:
- Stock Items: what you have on hand right now, with Adjust Stock and transaction history
- In / Out Report: movement over a date range — the report described on this page
The report opens on the current month, so you always land on useful numbers without touching a filter.
What the numbers mean
The four summary tiles
Total Inward
Everything that came in during the range
Purchases, purchase returns, stock-in corrections
Total Outward
Everything that left during the range
Sowing, dispatches, direct sales, consumption
Net Movement
Inward minus outward
Positive = stock grew, negative = stock shrank
Items Moved
How many stock items had any movement
Across the whole range, not just this page
The tiles always total the entire filtered range — they are not recalculated from the rows visible on the current page.
The movement table
One row per stock item
- Item: name, with crop · variety and the unit it is counted in (bags, kg, trays, plants…)
- Category: Seeds, Trays, Growing Media, Fertilizer, Chemicals & Pesticides, Packaging, Greenhouse Material, Plants / Seedlings or Other
- Opening: what you held on the first day of the range
- Inward (+): total quantity received in the range
- Outward (−): total quantity issued or sold in the range
- Net: inward minus outward, signed
- Closing: what you held on the last day of the range
Opening + Net always equals Closing — a quick self-check when you reconcile with a physical count.
Items with no movement in the range are hidden. The report is about what moved; your full on-hand list lives in the Stock Items tab.
Rows are ordered by how much moved, biggest mover first, so the items worth looking at are always at the top.
Filters
Narrowing the report
- From / To dates: any range you like — a week, a month, a season. Days are counted in Indian Standard Time, so a bill entered at 11 pm belongs to that day
- Category: look at just the fertilizer spend or just the trays
- Item search: type part of an item name; the list refreshes as you type
- Clear: appears as soon as any filter is away from its default and resets everything to this month
Exporting to Excel
Export CSV
The Export CSV button downloads exactly what you are looking at — the same date range, category and item search, with no page limit. The file contains one row per item plus a TOTAL row, and opens cleanly in Excel or Google Sheets (quantities are plain numbers you can SUM; Hindi item names and the ₹ symbol render correctly).
File name: stock-movement-YYYY-MM-DD-to-YYYY-MM-DD.csv
Where the movement comes from
Nothing is typed twice
Every stock movement in Hortiprise is written to one ledger as it happens. The report simply totals that ledger:
- Inward — recording a purchase bill, and any manual "Stock In" correction
- Outward — consuming stock in a sowing batch, dispatching an order, a direct sale, and any manual "Stock Out" entry
- Corrections — Adjust Stock from the Stock Items tab, which shows up on the side it belongs to
So the report needs no separate data entry: keep recording purchases, sowing and dispatches as usual and the report stays correct.
Access
Who can see it
The report follows the same rules as the rest of the Stock screen: it is part of the Finance module, so it is available on plans that include finance features and is shared across your team's data. Viewing and exporting are read-only — nothing you do here changes a stock balance.
Tips
Getting the most from the report
- Run it at month end and export the CSV for your accountant alongside the Purchases export
- Compare Closing against a physical count — a gap means a movement was never recorded; fix it with Adjust Stock and a note
- Filter by Growing Media or Fertilizer to see how fast consumables really burn, then set a reorder level on the Stock Items tab
- A large Outward with a small Inward over several months is your signal to negotiate a bulk purchase
- Check items whose Net is strongly negative — they are the ones that will run out first