A chocolate maker's inventory is four stocks on one sheet: beans by origin and harvest lot, the ingredients that go in with them (sugar, cocoa butter, milk powder, nuts), packaging (foil, sleeves, boxes), and finished bars by batch. Each row needs the amount on hand, a reorder amount, a unit cost, and where it's kept. Beans and bars also need a lot and a date. The sheet below does that for a made-up two-person bean-to-bar maker, and you can download it and type over the numbers.
The short version
- Four groups on one sheet: beans, other ingredients, packaging, finished bars.
- Beans are counted in pounds by origin and lot, never as "cacao, 190 lb".
- Milk powder and nuts sit on an allergen shelf, and the sheet says so.
- Every batch of bars gets a lot and a best-by date, so the oldest ships first.
- TaroStack takes the beans off stock when a batch is recorded and keeps the lots. More below.
An example sheet
Ten rows for the example maker in November. Six of them:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Cacao beans, Dominican Republic | lb | 150 | 60 | $4.60 | $690.00 | OK |
| Cacao beans, Ecuador | lb | 40 | 60 | $5.10 | $204.00 | REORDER |
| Cane sugar, organic | lb | 100 | 50 | $0.95 | $95.00 | OK |
| Cocoa butter, deodorized | lb | 22 | 10 | $9.75 | $214.50 | OK |
| Whole milk powder | lb | 25 | 10 | $4.30 | $107.50 | OK |
| Almonds, roasted | lb | 8 | 10 | $6.20 | $49.60 | REORDER |
The other four are flake salt, foil wraps, printed sleeves and 340 finished 70% dark bars at $2.35 each. The whole room is worth $2,462.60 at cost. Two rows say REORDER: the Ecuador beans and the almonds.
Look at where the money is. The finished bars ($799.00) and the Dominican beans ($690.00) are 60% of it. Those are the two rows to count carefully. The salt can be eyeballed.
Why beans need their own reorder math
Beans come by the sack, from an importer, on a lead time measured in weeks. The reorder amount has to cover that wait. This maker roasts about 15 lb of Ecuador a week and a new sack takes three weeks to arrive, so 45 lb is used while waiting. A week of cushion makes it 60. At 40 lb on hand, the order is already a week late, and the sheet has been red since 60.
Bars lose weight on the way from the sack, too. Sorting, roasting and winnowing take a share: shells, dust, the odd flat bean. If your yield from raw bean to nib is around three quarters, 15 lb of beans is about 11 lb of nibs. Count beans as beans and nibs as nibs, and don't mix the two in one row. Your own yield belongs on your batch record.
Lots and dates
The Lots sheet has a row for each sack and each batch:
| Received | Item | Lot | Quantity | Best by |
|---|---|---|---|---|
| Aug 20 | Cacao beans, Dominican Republic | DR-2026-B14 | 220 lb | Aug 31, 2027 |
| Mar 11 | Cacao beans, Ecuador | EC-2025-H07 | 154 lb | Dec 20, 2026 |
| Oct 22 | Almonds, roasted | AL-10221 | 25 lb | Jan 22, 2027 |
| Nov 3 | Finished bars, 70% dark | DK70-1103 | 480 | Nov 3, 2027 |
The importer's lot is on the sack tag. Yours goes on the bar: DK70-1103 is the 70% dark made on November 3. Roasted nuts are the short-dated row here, three months, and the sheet flags them USE FIRST inside 30 days.
Milk and tree nuts are major food allergens under federal law. A maker with one dark bar and one almond bar has to keep the two apart and clean between them, and "allergen shelf" in the Where kept column is a small start. What goes on the wrapper is in chocolate labeling requirements.
Get the spreadsheet
Download the chocolate inventory spreadsheet. Four sheets: the inventory with value and REORDER, lots with days left, a count sheet that fills itself, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Chocolate is slow. A batch is in the melanger for two or three days, then it's aged, tempered, molded, wrapped. At any moment there are beans roasted but not ground, chocolate made but not molded, and bars molded but not wrapped. A spreadsheet has no row for "in the grinder" unless you add one and remember to move the pounds each day.
How TaroStack does it
TaroStack follows the cacao from the sack to the sleeve.
Each step is a recipe. Roast and winnow is one: beans in, nibs out, with the loss built in. Chocolate is the next: nibs, sugar and cocoa butter in, a block out. Bars are the last: block, foil and sleeve in, wrapped bars out. Record a batch and its ingredients come off stock, from the oldest lot first.
Lots carry through. The batch record notes which sack lot and which almond lot it used. If the nut supplier recalls AL-10221, one report shows which bars it's in and which shops got them.
Your real yield shows up. From your own batch history, TaroStack shows whether a recipe yields what it claims, so a roast that's losing 30% instead of 25% doesn't hide.
Cost follows the beans. When the next sack costs more, the cost of the bars made from it moves, and margins are reported on what things cost you.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Beans on hand | Subtract by hand after roasting | Come off with the batch |
| Chocolate not yet molded | A row you remember to update | A lot in stock, like any other |
| Which sack is in which bar | Batch notes, if kept | On the batch record |
| What the bar costs now | Recalculate | Follows each lot's cost |
Recipes, batches, lots and true cost are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
