When stock expires and is thrown away, it stops being an asset, and the books have to say so. The journal entry is a debit to an expense account and a credit to inventory, for what the stock cost you:
| Debit | Credit | |
|---|---|---|
| Inventory write-offs (expense) | $162.13 | |
| Inventory (asset) | $162.13 |
That's the whole entry. The work is in the number: which lots, how many, at what cost, and why. A business that throws things away without recording them still has the loss. It just finds it at the next stock count as "shrinkage", with no idea what caused it. Below is the entry, a month's write-offs, the log that produces the total, and a file. This is general information: ask your own accountant how to set it up in your books.
The short version
- Debit an expense, credit inventory.
- Use cost, not selling price.
- Record each write-off when it happens: item, lot, quantity, cost, reason.
- Post one entry a month from the log.
- Keep the log. It's your evidence, and it shows where the waste is.
- TaroStack records every write-off with its lot, its cost and a reason. More below.
The entry, and where the debit goes
The credit is always to inventory. The debit has two common homes, and which you use changes where the loss shows on the profit and loss statement.
| Debit to | Shows as | When it's used |
|---|---|---|
| Cost of goods sold | Part of the cost of sales | Small, routine spoilage that's a normal cost of selling fresh goods |
| A separate account: "Inventory write-offs" or "Spoilage" | Its own line | When you want to see the waste, or it's unusually large |
For a small business, a separate account is usually more useful. Buried in cost of goods sold, $160 of waste disappears into a margin that's two points worse than expected. On its own line it's a number you can manage. Your accountant will tell you which presentation suits your accounts and your tax return: the tax side is in expired inventory tax write-off.
Larger businesses sometimes estimate losses in advance, with a reserve, and charge write-offs against it. That's a choice for your accountant, and most small businesses don't need it.
A month of write-offs
A made-up small food business, November.
| Date | Item | Lot | Quantity | Cost a unit | Written off | Reason |
|---|---|---|---|---|---|---|
| Nov 3 | Greek yogurt, 32 lb pail | GY-1008 | 1 | $49.00 | $49.00 | Expired |
| Nov 10 | Spinach, 2.5 lb bag | SP-1031 | 3 | $7.25 | $21.75 | Expired |
| Nov 14 | Granola, 12 oz, Maple Pecan | MP-0810 | 14 | $3.49 | $48.86 | Past best-by, unsold |
| Nov 18 | Almonds, sliced | AL-0612 | 2.4 kg | $14.30 | $34.32 | Rancid at opening |
| Nov 28 | Whole milk, gallon | Nov 28 | 2 | $4.10 | $8.20 | Expired |
| Total | $162.13 |
Getting the number right
Cost, not price. The 14 bags of granola would have sold for $140. They're written off at $48.86, what the ingredients and pouches cost. The books lose the asset you had, not the sale you hoped for.
Which cost. If the business uses first in, first out, the cost is that lot's own cost. That's another reason to write the lot on the log: the yogurt from the October delivery may have cost less than this week's. The methods are compared in FEFO vs FIFO.
Finished goods carry their ingredients' cost. The granola's $3.49 is oats, syrup, nuts and a pouch. If your books also add labor and overhead to finished goods, the write-off includes them. Ask how yours are set up.
A supplier credit isn't a write-off. The rancid almonds were written off, and a credit was asked for. If it comes, it's recorded when received, against the same expense account, so the net loss is what you really bore.
Write it down the day it happens. A log kept at the bin is accurate. A list rebuilt at month end from memory isn't, and the difference turns up as an unexplained variance at the next count.
One entry a month
Post the log's total once a month, with a description that points back to the log:
| Date | Account | Debit | Credit |
|---|---|---|---|
| Nov 30 | Inventory write-offs | $162.13 | |
| Nov 30 | Inventory | $162.13 | |
| To write off expired and spoiled stock, November 2026 (see the write-off log) |
If your inventory figure in the books comes from a system that tracks stock continuously, each write-off reduces inventory as it's recorded and there may be nothing to post by hand. If you count stock periodically and adjust the books to the count, the write-offs are already inside the count difference, and the log explains how much of that difference was waste. Either way the log is worth keeping. The related entry for goods sold is in cost of goods sold journal entry.
What the log tells you
Add the month up by reason and by item, and it stops being bookkeeping.
| November | |
|---|---|
| Expired before use (yogurt, spinach, milk) | $78.95 |
| Finished goods unsold | $48.86 |
| Bad on arrival or at opening | $34.32 |
Nearly half is fresh ingredients bought in quantities the kitchen didn't use. That's an ordering problem, not an accounting one, and the fix is smaller, more frequent orders. A stock list that shows dates before they pass is in inventory list with expiration dates, and the form for any stock correction in inventory adjustment form.
Get the log
Download the expired stock write-off log. Two sheets and a read-me: the log, where the value of each write-off works itself out, and a Month sheet that adds it into the journal entry. The account names are examples. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The log needs a cost for every line, and the person at the bin doesn't know what a pail of yogurt cost. So the quantity gets written and the cost column is filled in later, from a recent invoice, by someone guessing which delivery it was. The total is roughly right and the lot costs aren't.
How TaroStack does it
TaroStack knows what each lot cost, so the person at the bin only says what and why.
A write-off is an adjustment with a reason. Choose the lot, the quantity and the reason: expired, damaged, spoiled. Nothing is deleted.
The cost is the lot's own. Stock is costed in layers, first in first out or moving average, freight included. The write-off takes the value of the units that were actually thrown away.
Waste by reason, in dollars. The month's write-offs add up by reason and by item, which is the table above without the adding.
Stock value by month. What's on hand is valued at cost, by site and month, for your accountant.
Before it happens. An alert flags lots close to their date with their value, and a forecast shows what will expire unsold, in time to use it or mark it down.
| The job | Write-off log | In TaroStack |
|---|---|---|
| Cost of what was thrown away | Looked up, roughly | The lot's own cost |
| Total for the journal entry | Add the log | Waste by reason, for the month |
| Why did it expire? | A column, if filled in | A reason on every adjustment |
| Stop it next month | Notice the pattern | An alert before the date |
TaroStack isn't an accounting system and doesn't post journal entries. It gives your accountant the figures. Stock, lots and expiry are on every plan, from $9.99 a month. 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.
