The spreadsheet nobody told you about
I used to price my watercolor pieces by guessing. Then I started losing money on commission work and took it personally. I built a simple tracking sheet in Google Sheets that now handles everything from paper costs to framing markup. It saved me about four hours a week and stopped me from charging $40 for a painting that needed $90 in materials and three days of work. You can find free templates online, but the ones most people download are built for acrylics or oils. They overestimate drying time, misjudge medium costs, and completely miss the watercolor-specific variables like paper bloom and wet-on-wet failure rates. I ended up rewriting three columns just to account for layering time. The core columns you need are: date started, date completed, piece dimensions, paper type and weight, number of wash layers, time spent on underpainting, time spent on detail layers, time lost to corrections or reworks, material cost per layer (pigment plus medium), paper cost, framing cost, your hourly rate, and final sale price. Everything else is noise.
I track pigment cost per layer because watercolor uses paint differently than other mediums. A single Alizarin Crimson wash might cost $0.80 in tube paint if you're using a professional grade like Schmincke or Winsor & Newton. If you buy cheap student grade, you'll use twice as much to get the same opacity, which flips your margins overnight. Write down the actual paint brand and what you paid per milliliter, not just "red paint." The column that caught me off guard was rework time. Watercolor doesn't allow mistakes the way acrylic does. You can't just paint over something. I had a piece where a hard edge formed in the sky wash, so I spent forty minutes lifting it out with a damp brush and tissue, then let it dry, then painted a second layer. That's an hour of work that adds nothing to the final piece but still eats into your day. My worksheet now has a separate field for rework time, and I log it honestly. It usually adds 15 to 30 percent to the total time on a given piece. Here is how the math works in practice. I recently finished a 11 by 14 inch watercolor on 300 pound cold press paper. Paper cost was $4.50. Pigments ran about $6.20 across five wash layers. Framing came to $22. My hourly rate is $35. Total time was six hours, including forty minutes of lifting corrections. That gives you $35 times 6, which is $210 labor, plus $32.70 in materials, for a total of $242.70. I priced it at $380 because it was for a gallery consignment that takes a 40 percent cut. Without the gallery markup factored in, I would have left $150 on the table.
The trick that most people skip is accounting for paper warping and trimming. I buy sheets that are 22 by 30 inches, tape them down, paint, let them dry completely, then trim to final size. The trimming step wastes roughly 15 percent of the sheet. So if a full sheet costs me $9, my usable area cost is closer to $10.50 per trimmed piece. That sounds small until you are selling eight pieces a month. I keep a separate running tab for each pigment I use regularly. Cadmium yellow light, ultramarine blue, phthalo green, the usual suspects. Each one has a column for cost per gram, estimated usage per wash, and how many washes I can get from a tube before it is empty. I update this every time I buy new paint. Your spreadsheets will drift without regular maintenance, and then they become worse than useless because you will trust numbers that are wrong. One more thing that will save you. Track which papers you actually enjoy working on. I went through a stretch where I bought expensive Fabriano paper because reviews said it was the best for wet-on-wet technique. It was not. The sizing was too aggressive for my style and I spent extra time fighting the surface. I switched to Arches and the speed of my work improved noticeably. The worksheet now has a quality rating column per paper brand, and I only reorder anything that scores a 7 or higher over six months of use.
Get the Full Details
If you want a starting point, search for a blank inventory and pricing spreadsheet template and strip it down to the columns I listed above. Anything with fifty fields is a trap. You will not maintain it. Keep it stupidly simple and fill in real numbers every time you finish a piece. After about ten entries, the patterns will show up and you will know exactly which pigments are eating your profit and which paper brands are worth the premium.
