Why you need a tracking system for cold process soap
I spent three years burning through notebooks before I realized most of my failed batches had one thing in common: I couldn't remember exactly what I'd done. Lye concentration drifted because I was calculating from memory. Water discounts got lost between batches. One recipe called for 10% superfat but I wrote down 5%. The soap cured fine, looked fine, but it was nowhere near what I intended. The Ultimate Soap Making Tracker solves the record-keeping problem by centralizing everything that matters into one spreadsheet that recalculates itself when you change ingredient amounts.
How the Ultimate Soap Making Tracker works
You enter your desired batch size in grams or ounces, select oils from a dropdown list that pulls from a built-in database, and the tracker does the lye calculation automatically using the specific saponification values for each oil. It outputs the exact amount of sodium hydroxide and water you need, breaks down what your final percentages will be at any superfat level, and logs the batch for future reference. The spreadsheet includes a cost calculator, a lye discount table, and a cure time tracker so you know when a batch is actually ready rather than guessing at four weeks out of habit. I use Google Sheets version myself. The local file tends to get corrupted after I accidentally overwrite the formulas section while trying to fix a colorant entry. There are two columns you should not touch: the sap column and the lye column. Those contain the actual calculation chain. If you clear one cell in those columns, the whole batch recalculates wrong and you end up with either lye-heavy soap that burns skin or useless greasy sludge that never trace.
What separates this from a basic recipe notebook
A lot of people start with a simple table: oils, amounts, lye, water. That works until you want to swap coconut oil for more olive oil and recalculate without doing long division on a scrap piece of paper. The Ultimate Soap Making Tracker handles reformulation in seconds. It also tracks water percentage changes relative to lye weight, which is where most beginners make mistakes. A standard cold process uses 30 to 38 percent water relative to lye weight. Lower water means faster trace but shorter working time. Higher water means slower trace and longer curing, but it gives you more time to work with designs. The tracker flags when you go outside that range and warns you about potential issues. I learned this the hard way with a lavender soap batch. I dropped the water to 25 percent because I wanted fast stick blending. The batch accelerated to hard trace in about ninety seconds. I ended up with a block of soap that looked like it had been mixed with grout. Now I keep 33 percent water as my default and only adjust downward when I have experience with the specific fragrance oil I'm using.
Get the Full Details
Building your own version
If you don't want to download someone else's sheet, building one takes about forty minutes. Start with these columns: Oil name, percentage of total oils, weight in grams, SAP value for NaOH, lye required, water weight, and superfat percentage. Use this formula structure for the lye calculation: oil weight divided by the SAP value equals lye weight. For example, 500 grams of olive oil at a SAP of 0.134 requires 3731 grams of lye. Wait, that's wrong. Let me restate that correctly: 500 divided by 0.134 equals approximately 3,731 is incorrect. It should be 500 times 0.134 equals 67 grams of lye. I wrote that wrong and would have made dangerously lye-heavy soap if I had actually used that number. That mistake is exactly why spreadsheets with locked formula cells exist. Type the SAP value in once. Never touch it again. Only input the oil weights and percentages.
Add a section for additives: fragrance oil weight, colorant notes, anything that affects total batch weight. The tracker should subtract those from the oil total so your percentages still add to 100 percent.
Limitations and things to watch for
The spreadsheet does not account for batch scale errors. If you measure 10 grams off on your scale, the tracker still reports the math as correct. Your results will be wrong and the spreadsheet will not tell you that. Verify your scale with a calibration weight before every session. A $5 steel weight is cheaper than a ruined batch. It also cannot predict how specific fragrance oils behave in your particular setup. Some FSOs accelerate trace aggressively. Some cause separation. The tracker can log which ones did what in previous batches, but it will not warn you on new attempts unless you have filled in the previous results. Treat the historical data column as mandatory, not optional. One edge case I ran into: the tracker does not handle butter substitutions correctly when you swap Shea butter for Mango butter without updating the SAP values manually. Both are solid fats but their saponification values differ slightly. If you substitute without changing the SAP entry, your lye calculation is off by roughly 0.002 to 0.004 per hundred grams of oil. That is a small number until you are making fifty-kilogram batches, at which point it adds up to a noticeable superfat drift.
There is no mobile app version of the current Ultimate Soap Making Tracker. If you need to log something at the store while buying oils, you will need a separate notes app or a handwritten pad. I carry a small notebook for that. The spreadsheet lives on my desktop.
Getting started with the Ultimate Soap Making Tracker
The file is available on GitHub under an open source MIT license. I have used version 4.2 and the latest version is 4.3 as of early 2025. The repository is straightforward: a single Google Sheets template with instructions in the readme. There is also a local Excel version if you prefer not to use cloud storage. If you make a lot of soap, spend some time filling in the historical data section. After about twenty batches, you will start seeing patterns in how your fragrances behave, which colors settle or fade, and what water percentages work best for your studio temperature and humidity. That data is worth more than the calculator itself.
