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
| Tab | What it is for |
|---|---|
| Reports | The report library: pick a report, set its options, download it. |
| Closed periods | Which months finance has closed, and the report packs archived with them. |
| Explore: Ledger | Every movement of one item over a date range, on screen. |
| Explore: Valuation | What stock is worth now, by item, optionally for one category. |
| Explore: Movement | How 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
| Report | What it shows |
|---|---|
| Stock on Hand | Quantity, moving-average cost and value per bin as of a date, by warehouse and category. |
| Inventory Movement | Opening, received, issued, transferred, adjusted and closing quantity per item and warehouse. |
| Stock Card | Every movement of one item with running quantity and value. |
| Physical Count Sheet | A printable sheet for one count, in bin order, with a blank column for counters and signatures. |
| Count Variance | System versus counted quantity per bin for one count, with the variance and reason. |
| Stock Transfers | Transfers between locations, valued at the moving average. |
| Purchase & Receiving | Goods received by supplier, with receipt and PO numbers and the cost booked. |
Costing & valuation
| Report | What it shows |
|---|---|
| Inventory Valuation | The value of each item at moving weighted-average cost, by classification. |
| Cost of Goods Sold | Quantity delivered and its cost per item, with invoiced revenue and gross margin. |
| Inventory Rollforward | Beginning value + receipts − cost of sales ± adjustments − write-offs and write-downs = ending value. |
| Write-offs & Write-downs | Stock 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
| Report | What it shows |
|---|---|
| Low Stock & Reorder | Items at or below their reorder point with a suggested order quantity, grouped by supplier. A ready-made purchase list. |
| Safety Stock & Availability | Per warehouse: what is free once open sales orders ship, against safety stock and the reorder point. |
| Slow & Non-Moving Stock | Stock with nothing going out for a set number of days (default 90), and the value tied up in it. |
| Expiring & Expired Lots | Lots already expired or expiring within a window (default 90 days), with quantity and value. |
Compliance & audit
| Report | What it shows |
|---|---|
| Annual Inventory List (BIR) | (Finance only.) The year-end inventory list for the BIR. |
| Adjustment History | Every count variance, adjustment, write-off and write-down — who, when and why. |
| Inventory Audit Trail | Every stock ledger row: business date, posting time, source document, cost and user. |
Analytics
| Report | What it shows |
|---|---|
| Inventory Analytics | A PDF of key figures and charts: value by classification and warehouse, flow, top items and ageing. |
Run a report
- Open the Reports tab and select the report's card.
- 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.
- Choose the format: PDF, Excel or CSV (not every report offers all three).
The file downloads. Close to go back.
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
| Problem | What to check |
|---|---|
| "You don't have access to any inventory reports." | You need inventory.reports.view. |
| A report is missing from the list | It needs the compliance permission (finance only). |
| A report asks you to choose a warehouse | You are limited to some warehouses, so "All warehouses" is not offered. |
| "Inventory is closed through …" on another page | A period has been closed. Record the movement with a later date, or ask finance. |
Related pages
- Profit Analysis — profit by item on screen.
- Physical Counts — the source of count sheets and variances.
- Transactions — the ledger these reports read.