Stock
What you have, what it cost on average and what is running low. Every delivery, count and correction goes in a ledger per item, and a batch logged from the lye calculator takes what it used.
Stock belongs to an account, so it is there on every device you sign in on. Sign in or make an account to keep it.
Sign inSupplier lots, best-before dates, whole orders with their shipping shared out, and the search for a recall are part of Business.
Start free trial See plansThe first 30 days are free. Paddle takes your card at checkout and charges it only when they end; cancel before then and you pay nothing.
Shopping list
Everything at or below its reorder level, by supplier. The same list can come by mail on Mondays: switch it on in your account.
Your stock list, from a spreadsheet
Choose the sheet you keep your stock in, or paste its rows. Each row becomes an item, with what is on the shelf now as its first entry. Nothing is saved until you say so, and an item you already have is left as it is.
Which column is which
| Column | Read as | First rows |
|---|
What comes in
| Item | Kind | On hand | Paid | Supplier | Stands for |
|---|
No stock yet. Add the oils, lye and packaging you keep, and the batches you log will take from them.
| Item | On hand | Reorder at | Average cost | Value |
|---|
Average cost is the weighted average of what you paid, recalculated with each delivery. A batch takes stock out at the average.
Orders received
| Date | Supplier | Invoice or order number | Lines | Total |
|---|
Deliveries and where they went
Nothing has come in yet.
| Received | Supplier | Lot | Best before | In | Left | Went into |
|---|
Worked out oldest first. If a batch used a newer container, say so under its lots in the batch log. A missing lot number can be typed in here from the invoice.
Supplier documents
The certificate of analysis for a lot, and the safety data sheet or specification that came with a delivery: a PDF, or a photo of the paper. Kept with the delivery for the safety dossier. Only you and your team can open them.
No documents kept yet.
Record a delivery first. Its documents go with it.
Keeping supplier documents is part of Business. Those already kept stay readable and can be deleted on every plan.
Every entry
| Date | Entry | Quantity | Paid | Lot |
|---|
How it works
An item linked to an ingredient is where a batch takes that ingredient from. Log a batch on the lye calculator and its oils, lye and additives come off the shelf; anything not in your stock is listed rather than refused. Undo puts it all back.
Each delivery moves the average cost per gram by weight, the way the accounting standard for inventories describes it. Using stock does not move it. A delivery into stock that has gone below zero sets the price on its own, and stock added without a cost is taken to have cost what the next delivery did.
Lots are traced oldest first: each batch is taken to have used the oldest delivery still on the shelf, which is how stock is usually rotated. Where you name the lot a batch used, that comes first. Stock used before its delivery was recorded is traced to that delivery and marked as such. The cost is still the weighted average; the order only decides which lot went where.
IAS 2 Inventories, paragraphs 25 and 27, as adopted in the EU by Commission Regulation (EU) 2023/1803: the cost of interchangeable inventories is assigned by the first-in, first-out or the weighted average cost formula, and under the weighted average "the average may be calculated on a periodic basis, or as each additional shipment is received". This recalculates it as each shipment is received.
IAS 2 Inventories, paragraph 27, as adopted in the EU by Commission Regulation (EU) 2023/1803: "The FIFO formula assumes that the items of inventory that were purchased or produced first are sold first, and consequently the items remaining in inventory at the end of the period are those most recently purchased or produced." IAS 2 uses it to assign cost. This uses the same assumption only to say which delivery a batch most likely drew from; cost stays the weighted average.