Chemical Inventory Share Sheet: Track Stocks Free & Online

Running out of a common reagent mid-experiment wastes a day, and over-ordering wastes a budget. This free inventory sheet tracks chemical stocks with low-stock flags, so reordering happens before the bottle runs dry, not after.

What the tool does

You paste inventory rows as Name | Quantity | Unit | Low-stock threshold, and the tool returns a table marking each item OK or LOW STOCK. An item counts as low when its quantity is at or below its threshold, which lets you set generous thresholds for slow-delivery chemicals and tight ones for staples. The sheet is local to the page: nothing is sent anywhere, and the flags are computed from the rows you paste each time you press the button.

How to use it

List every chemical you actually use, with quantities in consistent units, and set thresholds from delivery times, not from habit: a chemical that takes six weeks to arrive needs a higher threshold than one the stores hold next door. Paste the list, press the button, and order every LOW STOCK item the same day. Re-paste the updated list after deliveries, and review thresholds quarterly, since usage changes as projects start and end.

Worked example

A lab lists ethanol at 500 mL with a threshold of 200, marked OK, and acetone at 150 mL with a threshold of 200, marked LOW STOCK. One low-stock item out of two is an easy decision: order acetone now, and ethanol can wait. If the lab had set the acetone threshold at 100 instead, the same 150 mL would read OK, and the lab might run out before the next order cycle. Thresholds are the real skill in this tool, and they deserve more thought than the quantities themselves.

Reading the results honestly

A flag is only as accurate as the quantity you typed. Shared bottles are used between counts, concentrations differ, and a quantity in millilitres does not tell you whether the bottle is open, expired, or contaminated. Treat LOW STOCK as an instruction to go and look at the bottle, not as a fact about it. For hazardous chemicals, this sheet never replaces the institution’s official inventory, safety data sheets, or storage rules.

Honest limits

This is a local sheet, and that limit is stated plainly: it cannot share inventory with a team in real time, because sharing needs a backend with accounts and a database, which this page does not have. It also does not track expiry dates, locations, or hazard classes, and it forgets your rows when you close the page unless you paste them again. If your lab needs a shared, audited inventory, use a proper system; this sheet is for quick personal checks.

Practical tips

Keep the pasted list in a lab notebook or shared document, so re-checking takes seconds instead of a fresh stocktake. Assign one person to update quantities weekly, and put the low-stock list on the lab’s order board, where ordering becomes a habit rather than a crisis. Review rarely used chemicals annually and dispose of expired stock through proper channels.

When a chemical is both low and hazardous

Low stock of a hazardous chemical deserves faster action than low stock of a harmless one, because running out mid-procedure can tempt unsafe substitutions or rushed ordering. Flag hazardous items separately in your ordering routine, and never let a hazardous stock hit zero while an experiment that needs it is running. Store the safety data sheet with the ordering note, so the person reordering sees the hazards as well as the quantity, and check storage conditions when the new stock arrives rather than shelving it unexamined.

Embed this tool on your website — free

Copy the code below to add this working tool to your own page. A small credit link stays with it — that’s all we ask.