Log the batch. The sheet does the rest.
Cost per jar, preserved value, best-by dates and what to use next, calculated the moment you type.
Works in Google Sheets · Excel · Apple Numbers. Instant download, no formulas to write.
Most canning spreadsheets are a log. This one calculates.
You type what you already know: the ingredients, the cost, how many jars came out. Every number you would normally work out by hand is already on the dashboard.
1. Log a batch
Date, recipe, ingredient cost, jar count. Each batch gets its own traceable lot code automatically.
2. It does the math
Cost per jar, total preserved value, best-by dates and color-coded expiring-soon flags, with no formulas to write.
3. Read the dashboard
Jars in stock, what is expiring, and a use-next list so nothing spoils forgotten at the back of the pantry.
- Cost per jar and total preserved value, from ingredient cost and jar count.
- Best-by dates and a use-next list, so the oldest jars get opened first.
- Automatic lot codes on every batch.
- One file, three apps: Google Sheets, Excel and Apple Numbers.
Ten trackers, one homestead.
Every one is a finished spreadsheet, delivered instantly on Gumroad. Start with canning; the rest follow the same idea.
The Homestead Kitchen Bundle
Canning Tracker plus Pantry Inventory together, $6 less than buying both. What you put up, what is on the shelf, what to use next.
The Canning & Preservation Tracker
Batches, cost per jar, lot codes, best-by dates and the pantry dashboard.
Get the trackerPantry & Kitchen Inventory Tracker
Log what you have; it tracks pantry value, flags what is expiring, and fills a shopping list with anything below your minimum.
Get the inventoryPreservation Yield & Cost Calculator
Enter what you are putting up and what you paid: finished yield, true cost per jar and per pound, and canning vs. freezing vs. dehydrating side by side.
Get the calculatorHomestead Money Tracker
Tag income and expenses to an enterprise (eggs, garden, preserves) and see which parts of the homestead pay, with tax-prep category totals.
Get the trackerRecipe Cost & Seller Kit
Enter ingredients once, build recipes from them, and get true cost per unit, a suggested price at your margin, and real profit per sale.
Get the kitGarden Planner & Planting Calendar
Enter your beds and last-frost date: how many plants fit each bed, and when to start seeds, plant out and expect harvest.
Get the plannerMeal Planner & Auto Grocery List
Drop recipes onto a weekly plan and the shopping list fills itself, repeats summed, with an estimated grocery total.
Get the plannerChicken Cost & Profit Calculator
Track feed, supplies and eggs: true cost per dozen, break-even egg price, and a countdown to the day the coop is paid off.
Get the calculatorSeed-Starting Scheduler
Set your last-frost date, pick your crops, and get each seed's start-indoors and transplant-out dates with a live countdown.
Get the scheduler