Inventory Reports
Udyot ERP’s inventory reports give you a real-time and historical view of your stock — what you have on hand, how much it is worth, where it sits across your godowns, and which items are running low. Whether you are preparing financial statements under NAS 2, filing VAT with the IRD, or simply deciding what to reorder this week, these reports are your starting point.
Where to Find the Reports
All inventory reports are grouped under Inventory → Reports in the left navigation. The date pickers use Bikram Sambat (BS) format, and the active fiscal-year pill in the top-right header determines which year’s data loads by default. If a figure looks unexpectedly low, check the FY pill first — switching it resets the report’s default date range to that year.
Stock Summary
The Stock Summary is the headline report for inventory. It shows one row per stock item with opening quantity, total inbound, total outbound, closing quantity, and closing value for the period you select.
- Go to Inventory → Stock Summary.
- Set the From and To dates in BS format (for example, 2081-04-01 to 2081-07-32 for the first quarter of FY 2081/82).
- Optionally filter by stock group or godown.
- The footer row shows the grand total inventory value. This figure should match the Stock-in-Hand balance in your Trial Balance if perpetual inventory is enabled.
- Click any item row to drill down into its Stock Ledger.
The report header shows the cost formula in use — for example, “Cost formula: Weighted Average (NAS 2 §25 disclosure)” — so your auditor can confirm the valuation basis. You can change the formula (Weighted Average or FIFO) in Settings → Account Settings → Cost Formula.
Stock Valuation
Stock Valuation gives a point-in-time snapshot of how much your inventory is worth — quantity multiplied by the current weighted-average (or FIFO) rate for each item.
- Go to Inventory → Reports → Stock Valuation.
- Pick a date. The report shows value as of that date, not just for the current day.
- The grand total equals the Stock-in-Hand line on your Balance Sheet.
This report is commonly used for insurance valuations, balance-sheet sign-off, and NAS 2 compliance reviews at each reporting period.
Stock Ledger
The Stock Ledger is the full audit trail for a single item. Every purchase, sale, delivery note, receipt note, stock journal, and physical stock adjustment appears here in chronological order with a running balance.
- Go to Inventory → Reports → Stock Ledger.
- Select the item and the date range.
- Each row shows the BS date, voucher type and number, direction (IN or OUT), quantity, rate, and running balance.
- Click any voucher number to open the original document.
Use this report whenever a stock balance looks wrong — trace every entry backwards to find the discrepancy.
Stock Movement
Stock Movement is similar to the Stock Ledger but shows all items at once, one row per voucher line. It is useful for “what happened across the whole warehouse in the last 30 days” audit queries.
- Go to Inventory → Reports → Stock Movement.
- Filter by item, godown, voucher type, and date range as needed.
- Use it to identify unusually large outward movements or to cross-check a specific voucher type (for example, all Delivery Notes in a week).
Stock Balance
Stock Balance is a simplified snapshot view — item, quantity on hand, rate, and total value — without the movement breakdown of Stock Summary. It answers the single question: how much of each item do I have right now, and what is it worth?
- Go to Inventory → Reports → Stock Balance.
- Filter by item or group if needed.
- Export to Excel for a quick inventory list to share with management or external auditors.
Godown-wise Stock
If your business operates multiple stores, branches, or warehouse locations, the Godown-wise Stock report shows exactly where each item sits. Items transferred between locations appear correctly split across columns.
- Go to Inventory → Reports → Godown Stock.
- The report displays a matrix: rows are items, columns are godowns.
- Each row total matches the on-hand quantity in Stock Summary.
- Pick a past date to see how stock was distributed at that point in time.
This is especially useful when you have a Main godown plus secondary stores, or when stock is held at a subcontractor’s premises during job-work. For more on managing locations, see Warehouses and Godowns.
Low Stock
The Low Stock report flags items whose current on-hand quantity has fallen below the reorder point you configured on the item master.
- Go to Inventory → Low Stock.
- Any item with total on-hand quantity below its reorder point appears with a Below reorder point indicator.
- Use this list to create purchase orders or trigger procurement with your vendors.
To set or change a reorder point, open the item in Masters → Stock Items, edit it, and update the Reorder Qty field. For automated reorder rules, see Reorder Rules and Low Stock Alerts.
Stock Ageing
Stock Ageing helps you identify slow-moving or stagnant inventory — stock that has been sitting in your godown for a long time without being sold. It splits each item’s on-hand quantity across five age buckets based on when the stock arrived (FIFO lot dating).
| Age Bucket | What it means |
|---|---|
| 0 – 30 days | Fresh stock — received recently |
| 31 – 60 days | Moving towards slow |
| 61 – 90 days | Slow-moving — review required |
| 91 – 180 days | Very slow — consider markdown or return to vendor |
| 180+ days | Potentially obsolete — check NRV |
- Go to Inventory → Reports → Stock Aging.
- Select a date — the report ages all on-hand lots relative to that date.
- Items whose opening stock was seeded at the start of the fiscal year will fall into the older buckets as the year progresses.
Nepal-specific note: Under NAS 2 (Nepal Accounting Standard 2), inventories must be valued at the lower of cost or net realisable value (NRV). If the Stock Ageing report reveals items sitting for 180+ days, it is good practice to check whether those items need an NRV write-down before you close the financial year. Udyot ERP has a built-in NRV tool that computes the write-down amount and posts the adjusting journal automatically. The five-bucket layout is aligned with standard NAS 2 review periods used by Nepali auditors.
Tips for Getting Accurate Reports
- Check the FY pill. Every report defaults to the active fiscal year. If you see zero stock on a date that should have stock, switch the FY pill to the correct year and re-run.
- Perpetual inventory must be on for GL alignment. If Integrate Accounts with Inventory is enabled in Settings → Account Settings, the Stock Valuation total and the Stock-in-Hand Trial Balance balance will always match. If it was ever turned off mid-year, a gap may exist — post a reconciliation journal to close it.
- Use Stock Ledger to investigate discrepancies. Any unexpected balance is traceable through the Stock Ledger. Every SLE (stock ledger entry) is linked back to its source voucher.
- Export for external use. All reports have an Export button. Export to Excel when sharing data with auditors, banks, or for your VAT purchase/sales book filings.