Pharmacy Shelf Expiry and Write-Off Log

Pharmacy Shelf Expiry and Write-Off Log is an offline app (one HTML file in a zip) for a pharmacy or health shop. You enter each product batch with its expiry date and the units counted on the shelf. The app shows what has expired, what expires soon, how much stock value is at risk, and for each batch the last date your supplier will accept a return. Every discount, supplier return and write-off is logged with its value.

The problem it removes: Stock is found expired on the shelf, near-expiry stock is noticed after the supplier return window has closed, and write-offs are tossed in a bin with nothing recorded about how much they cost. This app puts each batch on a dated list, shows the return deadline, and records what was lost.

What is inside:

• Batches with batch number, expiry date, units counted, cost per unit and place (shelf, fridge, dispensary, display or back store)
• Supplier return terms: you enter how many months before expiry each supplier takes stock back, and every batch shows its return by date
• Today page: expired on the shelf, expiring in your urgent days, near-expiry stock, return windows closing, and the stock value at risk
• Discount, supplier return and write-off log with quantity, reason and value, and a rule that a discount price must be lower than the shelf price
• Printable near-expiry list for a shelf walk, write-off record per entry and a monthly loss report
• CSV import for your product and batch lists
• 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: pharmacists, pharmacy managers and health shop owners who count stock by batch and want expiry dates, supplier return deadlines and write-off values in one place.

What it is NOT: It is not a patient or prescription system and is not a drug database: it has no dosing, no interactions, no medical content, and it stores product names, batch numbers and dates only. Do not enter patient names or prescription details. It is not full inventory: it does not record sales, so the unit count is the count you type at each shelf check. It does not follow supplier credit notes. 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 (119 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 1509 calculated values (25 randomised rows plus the example data) with 0 mismatches. Not tested: Safari and Firefox beyond what is stated here, and no real printer was used (print layouts were checked as PDF).