Soap Making Tracker Aesthetic

Tracking your soap batches doesn't need to be ugly

Most soap makers I talk to either use a battered notebook that gets ruined by lye burns or they're flying blind and losing track of which batch caused the ricing. The Soap Making Tracker Aesthetic is really about organizing your formulas, notes, and results in a way that is both visually clear and functionally useful. It started as a community-driven style in online forums where people shared spreadsheets and Notion templates. Now it's a recognizable approach to logging everything from SAP values to supercharge percentages. At its core it is a spreadsheet or digital log with specific columns that matter to cold process soap makers. You will see columns for each oil, its percentage, SAP value, cost per ounce, supercharge amount, water discount, fragrance load, and the date the soap came out of the mold. The aesthetic part is about readability. Clean headers, color coding for different oil types, and a consistent format that lets you scan quickly when you are trying to remember why that lavender batch turned out weird. I keep mine in Google Sheets because it syncs across my phone and laptop and I can access it in the kitchen without worrying about paper getting splashed with oils. The visual setup matters more than you might think. When your spreadsheet is clean, you actually look at it before making soap instead of avoiding the whole thing. A messy tracker becomes a digital graveyard where old formulas go to die because updating it feels like homework.

Setting up your tracker from scratch

Start with the basic column structure. The essentials are batch number, date made, oils and their percentages, SAP values for each oil, total SAP, supercharges, water to oil ratio, fragrance oil with load percentage, any add-ins like clays or botanicals, cure length, and a notes column for observations. That is the minimum viable tracker. Everything else is polish. Here is where people mess up. They build trackers with too many columns for data they never actually record. I spent weeks on a version that had separate columns for fragrance burn rates, color fading potential, and hardness ratings. I filled out maybe three of those columns across twenty batches. The simpler version that just tracks oils, SAP, water discount, fragrance, add-ins, and notes ended up being infinitely more useful because I actually maintained it. For SAP values, you can either look them up manually or pull them from a reliable database. I use the values from The Soapmaker's Companion and cross reference with MadMimi's SAP calculator when something looks off. The numbers vary slightly between sources depending on whether they use the Lovibond or other methods. Pick one reference and stick with it. Mixing sources will give you false confidence in your calculations.

The practical workflow

Before you make a batch, open your tracker and either create a new entry or clone a previous successful formula. Type in your oil percentages. Make sure they add to one hundred. Double check that SAP column auto-calculates or calculate it manually. Set your water discount if you are doing one. Log your fragrance and any Supercharge amounts. Then make the soap. After the soap comes out of the mold, fill in the hardening date and initial observations. After cure, go back and add your final notes. Did the colors bleed? Did it sweat? Did the scent hold? This is the part most people skip because they move on to the next batch. But the post-cure notes are where you learn what actually worked. The moment of soap making is chaotic. Two weeks later when the bar is cured and you are packaging it, you remember the flaws clearly. I learned this the hard way after a batch of my coffee scrub soap separated in the mold and I had no idea why. I realized I never recorded that I had used a water discount on that specific batch while also adding instant coffee powder, which absorbs liquid. The tracker showed the original water amount but not the absorption factor. I went back and added a column for liquid adjusters and thickeners that need extra water. That single addition prevented the same mistake on the next five batches.

Tools and templates

You do not need to build this from nothing. There are several free options floating around. The SoapCalc website offers a basic logging feature. Several people on Reddit and Facebook groups share Google Sheet templates that range from simple to extremely elaborate. I started with a template from a maker called SoapyWarlock and modified it heavily over three years to fit my own workflow. If you want something ready to download, search for "soap tracker spreadsheet" on Etsy. There are hundreds of paid options ranging from fifteen to forty dollars that include pre-formatted columns, automatic SAP calculations, and cost tracking. Some are worth it if you hate building things yourself. Some are overpriced templates with ten extra columns nobody uses. Read the reviews and look for screenshots of the actual sheet before buying. For the completely DIY approach, a blank Google Sheet with the column structure I described takes about twenty minutes to set up. Add conditional formatting to highlight batches above a certain supercharge or below a certain SAP value. Freeze the top row so headers stay visible. That is basically it.

Where this approach breaks down

Spreadsheets are not perfect for everything. If you make a lot of small experimental batches where you tweak one variable at a time, the linear log structure gets awkward. You end up with twenty nearly identical entries that differ by one oil percentage point. In those cases a simpler method like a dedicated app or even a photo-based journal with tags works better. Also, spreadsheets do not capture visual data well. A photo of the batter at trace or the finished bar next to a ruler for dimension reference gives you information a text cell never will. Cost tracking through spreadsheets is also only as accurate as your input data. If you buy a bulk order of shea butter at one price and then reorder at a higher price six months later, your historical cost columns become lies. Update the unit prices quarterly or your average cost per batch will drift significantly from reality. I stopped trying to track exact costs per ingredient and switched to tracking cost per batch total. Much less maintenance and close enough for practical purposes.

A few things I wish I knew before starting

First, include a column for batch size. A formula that works at five pounds may behave differently at two pounds because of thermal dynamics. Second, track your room temperature and humidity if you live in a place with seasonal changes. My soap traces differently in July than it does in January and the tracker finally made that pattern obvious. Third, do not overcomplicate the first version. You will revise it. Everyone does. I am on version four of my tracker and it is still not perfect but it is functional. The real value of maintaining a Soap Making Tracker Aesthetic is not the organization itself. It is the pattern recognition that comes from having enough data points to see what is actually happening. After about twelve batches logged properly, you start noticing things like "every time I use more than fifteen percent castor oil and a thirty percent water discount, the soap sweats on day three of cure." That kind of insight does not come from memory. It comes from a system that forces you to record the variables.