Cleaning Supplies Inventory

Who this is for

A stock sheet for the cleaning cupboard. Every item gets a line with where it is kept, how many are on hand, the level at which you reorder it and its unit cost; the sheet flags what needs buying, works out the value on the shelf and totals the cost of the restock.

Households that keep finding three of one thing and none of another, shared homes splitting the cost of supplies, holiday lets, and small cleaning businesses that stock a van.

What this helps you track

• What is in stock and where, so nothing is bought twice
• Which items are at or below the level you set for reordering
• The value of what is sitting on the shelf
• What the next shop will cost, before you go

How to use it

1. Write where the supplies are kept and the date you counted them at the top.
2. List each item — cloths, bags, sponges, refills, whatever you use — with its location and the number on hand.
3. Set your own reorder level for each item: the count at which you want to be told to buy more.
4. Enter a unit cost from your last receipt. The browser and spreadsheet versions flag anything at or below its reorder level and total the value and the restock.
5. Write the number to buy against each flagged item and take the sheet, or the browser version on your phone, shopping.
6. On paper, work out the reorder column by comparing the two counts, and total the cost columns at the foot.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What should my reorder level be?

Your choice, item by item. It depends on how fast you use something and how far the shop is. A number is only a prompt — the sheet flags the item when the count on hand is at or below it.

Why is there no list of products?

Because what you use is your business and changes from home to home. The sheet is for whatever is in your cupboard, named however you name it.

Does it track what I used, or just what I have?

Just what you have, at each count. Compare two dated sheets to see what went. A log of usage per clean is a different sheet — for a business, the cleaning job sheet records what was used on each job.

What does the number in the reorder column mean?

A 1 means the count on hand is at or below the reorder level you set; a 0 means it is above it. The summary adds the ones up to give the number of items to buy.