Tracking Watercolor Supplies Actually Works When You Stop Overcomplicating It
I've been buying and using watercolor supplies for over a decade, and I went through three different systems before landing on something that actually stuck. Most people try to build elaborate spreadsheets or buy overpriced dedicated journals and quit after two weeks. The ones who keep at it usually do it with something painfully simple. The phrase comes up a lot in forums and Reddit threads, but there isn't one single product everyone agrees on. Most people recommending a Best Watercolor Tracker are talking about a structured system rather than a branded app. That system usually combines a basic spreadsheet or notebook with a consistent set of fields: pan size, brand, color name, pigment code, opacity level, lightfastness rating, price paid, and date purchased. The reason this matters is that watercolor paints behave completely differently from tube to tube, even within the same brand. A Daniel Smith Quinacridone Rose from 2018 can stain noticeably more than the same color bought in 2023 due to batch variation. Without records, you are flying blind when you try to recreate a painting six months later.
The Fields That Actually Matter
Here is what I learned from trial and error. Most beginners track too much useless data and neglect the stuff that actually affects their work. Pigment code is non-negotiable. PW15 for phthalo blue tells you more about how a paint will behave than any brand name ever will. If you only remember that your paint is "phthalo blue" and not that it's PB15:3 versus PB15:1, you will have problems mixing. Pigment codes are public information from the Artists' Colouring Agents index. Lightfastness ratings matter more than people expect. An IRIS-rated pigment in a student-grade paint will disappear on your sketchbook page within a year regardless of what the tube says. Always check the manufacturer's rating card. Most major brands post this on their websites now.
Opacity classification is where most online tracking systems fall short. Transparency, semi-transparent, opaque, and staining categories directly affect how you layer glazes. I used to skip this field because it felt obvious, then realized I had painted over a transparent wash eight months later and could not remember whether it was going to lift cleanly or bind permanently into the paper. Price per milliliter is the metric that separates impulse buyers from people with functioning studios. A 15ml pan of Schmincke Horadam at roughly $18 per color works out to about $1.20 per ml. A 12ml tube of Winsor & Newton Cotman at $6 works out to $0.50 per ml. The Cotman is half the price per volume, and for many applications it performs acceptably. You need the data to make that call objectively instead of emotionally.
Get the Full Details
The Spreadsheet Method That Actually Sticks
I tried dedicated apps, bullet journals, and custom Notion databases. They all died because they required too much maintenance after a purchase. The system I still use takes about four minutes total for an entire order. A single Google Sheet with columns for date, brand, color name, pigment code, opacity, lightfastness, pan or tube size, quantity, price, and notes. That is it. Ten columns. You fill it out once per transaction, not per individual color, which saves time when you buy a full set. The notes column is where you capture things that do not fit anywhere else. A specific batch number if the manufacturer lists it. Whether you bought it on sale. How the color performed after your first session with it. One entry in my sheet from 2021 notes that a particular Holbein Dual Flow pan dried out within six months, which saved me from buying another one.
When Tracking Fails Completely
There are real limitations to this approach. It does not help you when you borrow someone else's paints and forget what you used. It does not replace physical labeling, which remains important because digital records get corrupted, lost, or forgotten on old hard drives. Tracking also becomes nearly useless for handmade or obscure studio paints where pigment information is not publicly disclosed. Some small artists blend pigments without listing exact compositions, and you cannot track what you cannot identify. In those cases, swatching every new color immediately is the only reliable practice. Another limitation I encountered involved travel-sized sample pans. These often come in tins that do not match standard pan sizes, making it awkward to record physical inventory alongside your digital tracker. I solve this by keeping a separate low-priority sheet just for samples and irregular formats. It is not elegant, but it prevents those purchases from corrupting the main tracking data.
What I Would Do Differently Starting Over
I would start tracking pigment codes on day one instead of waiting until I had built up a collection large enough to feel overwhelmed. The earlier you enter a PW number into your system, the more useful your data becomes over time. Within a year, you will notice patterns in which pigments you reach for most often and which ones sit unused. That pattern recognition is the actual payoff of tracking, not just having a list of what you own. Most importantly, do not wait for the perfect tool. A free spreadsheet with the right columns will outperform any paid app within six months because you will actually use it. The best system is the one you maintain when you are tired and just want to paint.
