Build a Simple Supplier Document Tracker Spreadsheet

Every maker hits the same moment eventually: someone asks for a safety data sheet on an ingredient you bought two years ago, and you spend an hour digging through email attachments trying to figure out if you ever actually got one. A tracker spreadsheet fixes this permanently, and it takes about twenty minutes to set up properly.

Why a tracker beats a folder full of PDFs

A folder of documents tells you what you have. It doesn't tell you what you're missing. The whole value of a tracker is that it surfaces gaps, the ingredient you've been using for a year without ever pinning down a current safety data sheet, the supplier who sent you a spec sheet but never followed up with a certificate of analysis. You can't see a gap in a pile of files. You can see it instantly in a spreadsheet row that's sitting empty.

The columns that actually matter

Here's a structure that covers what you genuinely need, without turning into a project of its own to maintain:

Column	What goes here	Why it matters
Ingredient (as purchased)	The trade name or product name from the supplier	This is what's on your invoice and packaging
INCI name	The standardized cosmetic ingredient name	What actually goes on a label and a filing
CAS number	The registry number for the substance, if it has one	Needed for accurate ingredient identification, some botanicals won't have one
Supplier	Who you bought it from	Ties documents to a specific source, since the same INCI name from two suppliers isn't guaranteed identical
SDS on file? (Y/N + date)	Whether you have a current safety data sheet	SDS documents can go stale, track the date you received it
COA on file? (Y/N + date)	Certificate of analysis, if applicable	Especially relevant for essential oils and actives where batch variation matters
Spec sheet on file? (Y/N)	Supplier's technical specification	Useful for concentration ranges within blends
Is this a blend? (Y/N)	Whether the purchased ingredient is itself a mix of components	Flags anything that needs component-level expansion
Blend components (if applicable)	The individual INCI names inside a supplier blend	Critical for concentration math and allergen screening
Last verified date	When you last confirmed the document is still current	Documents don't automatically expire, but suppliers do update formulations
Notes	Anything unusual, restricted status, allergen flags, pending renewal	Catch-all for context that doesn't fit elsewhere

Why the blend columns deserve their own attention

This is the part people skip and regret skipping. A lot of what you buy from suppliers, fragrance oils, preservative systems, some active complexes, isn't a single ingredient. It's a blend sold under one trade name. If your tracker only has a row for "Fragrance Oil X" without breaking out what's actually inside it, you have no way to check any individual component against a restricted or prohibited substance list, and no way to calculate an allergen's real concentration in your finished product.

Whenever you get documentation on a blend, pull the component breakdown, usually from the SDS section 3 or a supplier-provided composition sheet, and give each component its own line, noting what percentage it represents within the blend. That's what lets you later multiply the component's share of the blend by the blend's share of your finished product to get the real, finished-product concentration.

Setting a review cadence

A tracker only stays useful if someone actually looks at it periodically. A few habits that keep it alive rather than stale:

• Add a row the moment you order a new ingredient, before the first shipment even arrives, so the gap is visible immediately if documentation is slow to follow.
• Set a recurring reminder, quarterly is reasonable for most small operations, to spot-check "last verified" dates and follow up with suppliers whose documents are aging.
• Flag anything restricted or concentration-limited directly in the notes column, so it's visible at a glance rather than requiring you to cross-reference a separate list every time.
• Update the sheet immediately when you switch suppliers for the same ingredient. Same INCI name, different supplier, is a new row, not an edit to the old one, since sourcing and composition can differ.

What this sets you up for

A clean supplier document tracker isn't just about being organized for its own sake. It's the raw material that makes an actual filing fast instead of a scramble. When every ingredient row already has its INCI name, CAS number, and blend components sitting there, ready to go, converting that into a notification is mostly assembly work rather than research work.

That's more or less what Cosmetic Comply automates on the filing side, taking your ingredient list, matching it to INCI names and CAS numbers, expanding blends into their real components with percentages carried through, and screening the result against your market's restricted and prohibited lists. Keeping a tracker like this yourself is the habit that makes that process fast rather than a scavenger hunt through old supplier emails.