Skip to main content

Inventory Reports

Inventory → Inv. Reports (/inventory/reports) is the reporting centre for inventory. It has a library of ready-made reports you can download, three on-screen explorers, and the list of closed inventory periods.

Before you begin​

  • You need inventory.reports.view. The Warehouse Manager, Accountant and System Administrator roles have it.
  • Two reports — Inventory vs General Ledger and Annual Inventory List (BIR) — also need inventory.reports.compliance, which the Accountant and System Administrator roles hold but the Warehouse Manager role does not. They do not appear in your list.
  • Reports only include the warehouses you can see. If you are limited to some warehouses, you choose one when generating a report.

The tabs​

TabWhat it is for
ReportsThe report library: pick a report, set its options, download it.
Closed periodsWhich months finance has closed, and the report packs archived with them.
Explore: LedgerEvery movement of one item over a date range, on screen.
Explore: ValuationWhat stock is worth now, by item, optionally for one category.
Explore: MovementHow much came in and went out over a date range, per item.

The report library​

Reports are grouped into sections. Each card shows whether the report is ready to run (for example how many ledger movements it will read) or what setup is missing.

Stock management​

ReportWhat it shows
Stock on HandQuantity, moving-average cost and value per bin as of a date, by warehouse and category.
Inventory MovementOpening, received, issued, transferred, adjusted and closing quantity per item and warehouse.
Stock CardEvery movement of one item with running quantity and value.
Physical Count SheetA printable sheet for one count, in bin order, with a blank column for counters and signatures.
Count VarianceSystem versus counted quantity per bin for one count, with the variance and reason.
Stock TransfersTransfers between locations, valued at the moving average.
Purchase & ReceivingGoods received by supplier, with receipt and PO numbers and the cost booked.

Costing & valuation​

ReportWhat it shows
Inventory ValuationThe value of each item at moving weighted-average cost, by classification.
Cost of Goods SoldQuantity delivered and its cost per item, with invoiced revenue and gross margin.
Inventory RollforwardBeginning value + receipts − cost of sales ± adjustments − write-offs and write-downs = ending value.
Write-offs & Write-downsStock written off and written down, with reasons and amounts.
Inventory vs General Ledger(Finance only.) The stock ledger's value against the accounting books.

Monitoring​

ReportWhat it shows
Low Stock & ReorderItems at or below their reorder point with a suggested order quantity, grouped by supplier. A ready-made purchase list.
Safety Stock & AvailabilityPer warehouse: what is free once open sales orders ship, against safety stock and the reorder point.
Slow & Non-Moving StockStock with nothing going out for a set number of days (default 90), and the value tied up in it.
Expiring & Expired LotsLots already expired or expiring within a window (default 90 days), with quantity and value.

Compliance & audit​

ReportWhat it shows
Annual Inventory List (BIR)(Finance only.) The year-end inventory list for the BIR.
Adjustment HistoryEvery count variance, adjustment, write-off and write-down — who, when and why.
Inventory Audit TrailEvery stock ledger row: business date, posting time, source document, cost and user.

Analytics​

ReportWhat it shows
Inventory AnalyticsA PDF of key figures and charts: value by classification and warehouse, flow, top items and ageing.

Run a report​

  1. Open the Reports tab and select the report's card.
  2. Fill in the options the report asks for. Depending on the report this is an As of date, a From / To range, an Item, a Physical count, a Taxable year, a window in days, and a warehouse.
  3. Choose the format: PDF, Excel or CSV (not every report offers all three).

The file downloads. Close to go back.

Reports for a closed month

When a period is closed, reports as of its close date read the snapshot taken at closing, so they never change — even if someone later records a correction in a new period.

Explore the data on screen​

  • Explore: Ledger — pick an Item (required) and a From / To range to see each movement and the running balance.
  • Explore: Valuation — optionally pick a Category to see each item's quantity, average cost and value.
  • Explore: Movement — optionally pick an Item (or All items) and a date range to see what came in and went out.

Each explorer is a grid you can search, sort and export like any other list.

Closed periods​

Closing an inventory period freezes stock movements up to a date: nothing can be recorded on or before it afterwards. It is a month-end finance step and needs inventory.periods.close, which the Warehouse Manager role does not have. On this tab you can see:

  • the date the ledger is closed through — "The stock ledger is closed through [date]", or "No period has been closed yet";
  • each period with its status (Closed or Reopened) and a Year end badge for the annual period;
  • the Archived reports saved at closing, which you can open.

Before finance closes a month, make sure the month's counts are approved and all receipts, transfers and deliveries are posted.

Common issues​

ProblemWhat to check
"You don't have access to any inventory reports."You need inventory.reports.view.
A report is missing from the listIt needs the compliance permission (finance only).
A report asks you to choose a warehouseYou are limited to some warehouses, so "All warehouses" is not offered.
"Inventory is closed through …" on another pageA period has been closed. Record the movement with a later date, or ask finance.