Clinic Consumables Register with Batch Expiry, Use-First and Reorder

Clinic Consumables Register is an offline app (one HTML file in a zip). Each item has a minimum and a top-up level. Every delivery is entered as a batch with its number, expiry date, quantity and cost. Use is logged against the batch by room. The app works out the usable stock of each item (batches that have not expired), the days it will last at the recent rate of use, which batch to use first, and what to order.

The problem it removes: Gloves, disposables and materials are found expired when they are needed, and the shelf count is a guess. Expired boxes stay on the shelf and in the stock number, so the reorder is late. Nobody knows which batch was opened first or what is written off each year. This app keeps the stock by batch and counts only what is still usable.

What is inside:

• Items by category with a minimum level and a top-up level, and the quantity to order when usable stock reaches the minimum
• Batches received with batch number, expiry date, quantity and cost per unit
• A check that refuses a use or discard larger than what the batch holds, and use dated after the expiry
• Use by room, days of cover at the last 28 days rate, and the batch to use first for each item
• Expired stock that still counts on the shelf, with a button that writes it all off as a discard record
• Short-dated batches need a note when you accept them, and discards have a reason
• Printable order list, expiry report, stock list and discard record
• Example data you can load in one click, a Start here guide and an Honest limits panel
• JSON backup and restore, CSV export, and CSV import with a check of every row before anything is added

Who it is for: clinic managers, assistants and nurses who look after the supply store of a dental or small medical clinic.

What it is NOT: It is a supplies register only. It does not hold medicines, controlled items, patient details or clinical records, does not know what must be kept or reported under any health rule, and does not place orders. Expiry dates are the ones you enter from the box. It is not legal, tax or accounting advice, it is not connected to any government system, bank or messaging service, and it does not file or send anything by itself. UAE e-invoicing is not part of it.

Your data stays on this device in your browser. Back it up with Export; clearing browser data loses it otherwise.

Verified by us: scripted tests in Chromium (161 checks through the real screens: adding, editing and deleting records in every table, required-field messages, backup then clear then restore, CSV export then import, keyboard order, print layouts rendered to PDF, no horizontal scrolling at 375 and 1280 pixels, no network requests) and an independent recalculation by a separately written Python evaluator of 1556 calculated values (25 randomised rows plus the example data) with 0 mismatches. Safari engine (WebKit): smoke test passed; Firefox: could not be launched. Not tested: Firefox beyond what is stated here, and no real printer was used (print layouts were checked as PDF).