Stock Ledger
Shows, for each item and location, the stock you opened the period with, what came in, what went out, and what you closed with, plus the value at the start and end. Use it for a period-end stock statement or to find out why an item's stock changed.
Quick look
- Go to Reports › Inventory Reports and click the Stock Ledger card.
- Set the Date Range. It starts on the first of this month up to today.
- Pick an Item if you want just one.
- Click Run Report.
Done. You see opening, inward, outward and closing stock for the period, with totals under the table.
Full guide
Filters
Click the filter button beside Run Report to show or hide the filters.
Fields in this section
| Field | Required | What to enter |
|---|---|---|
| Reports | No | Switch to another Inventory report. |
| Location | No | All locations or one location. |
| Date Range | Yes | A start and an end day, at most 366 days. Future days cannot be picked. It starts on the first of this month up to today. |
| Store | No | All stores, Unassigned, or one store of the chosen location. It stays greyed out until you pick a location. |
| Item | No | Search and pick one item. Empty means All items. |
| Show batches | No | Tick to list one row per batch. |
| Hide items with no stock or movement | No | Ticked at the start. Untick to list items that had nothing in the period. |
Columns
Fields in this section
| Column | What it shows |
|---|---|
| Item Name | The item. |
| Location | Where the stock is. Not shown when you pick one location. |
| Batch | The batch. Shown only with Show batches ticked. |
| UoM | The unit of measure. |
| Opening | Stock at the start of the first day. |
| Inward | Stock that came in during the period. |
| Outward | Stock that went out during the period. |
| Closing | Stock at the end of the last day. |
| Opening Value, Closing Value | The value of the opening and closing stock. Shown as a dash when it cannot be worked out. Not shown when you pick a store, because value is kept per location, not per store. |
Under the table a bar shows the totals of the four quantity columns and the two values. If the items use different units, it says the quantity totals are not shown.
A note above the table says what the ledger counts. The report opens sorted by Item Name, A to Z. Click a heading to sort by it; the arrow shows the direction. The sort is done on the whole report and is remembered. UoM cannot be sorted. Use the column chooser in the table header to hide, show, drag into a new order or reset the columns. The pager at the bottom has Go to page and Items per page.
Drill-down
None. Rows do not open anything.
Export, print, PDF and email
Not available.
Who can see it
Open the report with View on Inventory Reports. Without it the report list shows a No Access page. Inventory Reports has only View and Add/Edit, and Delete comes with Add/Edit. A report changes no record, so Add/Edit and Delete make no difference here. The report shows all stock of the business units you can open, not only records you created.
On mobile
Not available yet. The card is listed under Reports, Inventory Reports in the mobile app, but the report does not load there and opens empty. Use the web app. Same on iPhone and Android.
The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
I am told the date range is too long
The ledger covers at most 366 days at a time. Run it for shorter periods.
The report is empty
"Hide items with no stock or movement" is ticked at the start, so items with nothing in the period are left out. Untick it, widen the Date Range, or clear Item and Store.
The value columns are missing
You have a Store picked. Value is kept per location, so it is hidden for a store. Set Store to All stores.
The report page says No Access
Your role does not have View on Inventory Reports. Ask an administrator to turn it on.