Inventory reports
Stock value, low stock, usage, every stock movement, room moves and expiring lots — at every site, with CSV and print.
Open Reports in the clinical workspace and pick a report under Inventory. Each reads the stock you keep in Inventory, at every site, in your practice's currency. Stock is valued at average cost: a lot is worth its share of its item's value, so 10 boxes of a 40-box item worth £200 are worth £50.
The inventory reports show to people who can see both reports and inventory. Someone without inventory access doesn't see them in the hub, can't open them, can't schedule them by email, and the API refuses them. An email scheduled for someone who later loses inventory access is not sent. None of their rows names a patient.
Stock summary
What is in stock right now: Items, Units in stock and Stock value, then the same three figures By room, By category and By tag.
- An item with several tags counts under each of them, so the tag table can add up to more than the total. Items with no tag are under No tag.
- An item whose cost isn't known yet is valued at nothing until you set one.
- Archived items are left out. The date filter does not apply; filter by Location or Room.
Low stock
Every item that has run out, or is at or below its minimum level — the same rule as the Low stock and Out of stock pills on the Inventory page. The tiles count Out of stock and Low stock; the table lists each item with its site, room, quantity, minimum and unit, out of stock first and then by name. An item without a minimum level shows only once it runs out.
Usage over time
What was used in the window: everything taken by your team or when a procedure was completed, in Units used and Value used, each against the previous period. The two charts show the trend at the Day, Week or Month grain, and Usage by item lists every item used, most value first.
A shop delivery correction or a return to the supplier is not usage. Value counts the average cost the stock left at, so stock with no cost counts in units only.
Transactions
Every change to stock in the window, newest first: takes, restocks, counts, room moves and cost changes. Each row shows when, the item, its site and room, the movement, its Source (by the team, a completed procedure, or a shop delivery, check-in or return), the change, what was left afterwards, the change in value and who did it. The tiles total the movements, the Units in and Units out (counts included) and the Value change.
Filter by Location, Room, Item, Movement, Source or Done by. Room is the item's room today.
Moves & transfers
Every time an item changed room in the window, newest first: from which room to which, and who moved it. Moving an item changes where it is kept, never how many there are. The tiles count the Moves and the Items moved.
Expiry
Every lot still in stock that has passed its expiry date, or expires in the next 30 days, soonest first. Each row shows the lot, its expiry date, Expired or Expiring, the days left (negative once expired), the quantity and its value. The tiles total the units and value of each. Expired stock stays usable and is only flagged, as on the Inventory page.
Download CSV
Every table on a report page has Download CSV. For a table that loads a page at a time — Transactions, Usage by item, Low stock, Expiry and Moves, and the rows of the money and clinical reports — Smileline fetches every page for the filters you have set before it saves the file, showing how many rows it has fetched so far. You get the complete table, not just the rows on screen.
If a page can't be fetched, nothing is saved and Smileline says so: click Download CSV again. Numbers are saved as plain numbers and money in your practice's currency, with the currency in the column heading. A text cell that starts with =, +, - or @ gets a leading apostrophe, so a spreadsheet shows it as text and never runs it as a formula.
Print or save as PDF
Click the printer icon (Print) or the PDF icon (Export PDF) beside the report's title. Smileline first fetches every row of the report's tables for the filters you have set, then opens your browser's print dialog; for a file, choose Save as PDF there. The page prints landscape in its colours, without the rail, the top bar and controls, each chart and table kept whole on a page where it fits, and wide tables wrapped to the page.