Car Detailing Supply Reorder Tracker: What to Record and When to Reorder

The short answer

A car detailing supply reorder tracker is a running record of every product and consumable you stock. It shows what you have, how fast you use it, and the stock level that should trigger a new order. A useful tracker answers three questions at a glance: what is on the shelf right now, how much each job consumes, and which items have dropped to the point where you need to order before you run out.

The central idea is the reorder point: the quantity at which you place an order so new stock arrives before the old stock is gone. Your reorder points can only be as accurate as the usage you actually log. A tracker built on guesses will drift, so the per-job usage log does most of the work.

One condition changes the answer. If you store chemicals at a business premises, an inventory spreadsheet is an organizational tool, not proof of hazardous-material compliance. Workplace and environmental rules vary by jurisdiction, and you need to confirm them separately.

Fields worth including

Publicly shared detailing inventory spreadsheets record current stock of each supply as of a specific date. General chemical inventory templates add identification and storage fields, such as chemical name, manufacturer, CAS number (a unique registry number assigned to a chemical substance), storage location, container type, quantity, receipt date, concentration, intended use and hazard rating. A detailing tracker can combine both approaches:

• Product name and manufacturer, exactly as printed on the label
• Category, such as exterior wash, decontamination, polishing, protection, interior, glass, or towels and pads
• Container size and unit (keep one unit per item, for example ounces or liters, and do not mix them)
• Quantity on hand and the date counted
• Storage location, for example a shop shelf, a van, or a specific bin
• Receipt or opening date, useful for products the manufacturer says have a limited shelf life
• Average usage per job, taken from your job log
• Reorder point and reorder quantity
• Supplier and typical delivery time, from your own order history
• Safety data sheet on file (yes/no) and where it is kept
• Notes, such as a substitute product, discontinued item or label change

If you run interior work separately, or interior products move at a different pace, give them their own category or tab. Fabric and upholstery cleaners, leather products, plastic and vinyl dressings, and odor treatments can then be counted and reordered without searching through exterior stock.

A simple column template

These headers can be pasted into any spreadsheet as a starting point. Rename or remove columns that do not fit your operation.

Item,Manufacturer,Category,Unit,Container Size,On Hand,Count Date,Location,Opened/Received,Avg Use Per Job,Lead Time (days),Reorder Point,Reorder Qty,Supplier,SDS On File,Notes

Logging product usage per job

Detailers in online discussions ask how others keep track of what they did on each vehicle and which products they used. A per-job log answers that question and feeds the reorder sheet. Keep it short enough that you actually fill it in after every job:

Date,Job/Vehicle,Service Package,Item,Amount Used,Unit,Notes

Exact measurement is often impractical, so a consistent method matters more than precision. You can weigh a bottle before and after a job, mark fill lines on containers, or count how many full containers are used across a set number of jobs and divide. Use the same method every time, and record dilution products by the concentrate used rather than the diluted volume, so the figure matches what you reorder. Follow the manufacturer's label for actual dilution ratios. This guide does not supply them.

Usage varies with vehicle size, condition and the service performed. If you offer distinct packages, average consumption separately for each package instead of using one figure for all jobs.

Setting a reorder point

A common inventory method is to reorder when on-hand stock covers the expected usage during the supplier's delivery time, plus a safety buffer for busy periods or late shipments:

Reorder point = (average usage per day x lead time in days) + safety stock
Average usage per day = total used over a period / days in that period

All of these inputs come from your own records. There is no universal figure for detailing products, and none is supplied here. Lead time is the gap between placing an order and receiving it. Safety stock is a judgment call based on how variable your bookings and deliveries are. Review reorder points regularly, especially after adding services, changing products or switching suppliers.

Keeping the tracker accurate

• Count physical stock on a fixed schedule and correct the sheet to match what is actually there
• Count each storage location separately, such as a mobile van and a home base, so stock is not double-counted
• Update the sheet when deliveries arrive, not when orders are placed
• Mark reorder-point items with a status column, conditional formatting or a simple low-stock filter
• Record product changes in notes so usage history is not mixed across different formulas

What a tracker cannot do

An inventory record organizes what you own. It does not establish whether storage, labeling or quantities meet workplace safety, fire or environmental requirements. Those depend on your jurisdiction and the specific products, so check the applicable rules and each manufacturer's safety data sheet directly. The tracker also cannot tell you which products are compatible with each other or with a given vehicle surface, or the correct dilution or dwell time (how long a product stays on a surface before removal). Use the product instructions and vehicle manufacturer guidance for those decisions.

Gaps in this guide

The source material for this guide covers inventory fields and record-keeping practices. It contains no verified typical usage rates for detailing products, standard lead times, prices, or comparisons of tracking apps or printable templates. This guide therefore offers no benchmarks or product recommendations. Your own job logs are the reliable source for those numbers.