Fish is the most perishable thing anyone sells by the pound, and a seafood market's inventory sheet is built around that. Stock is counted by weight, on a scale, every morning. Every delivery is a row with the day it came in and the day it has to be sold by, because Tuesday's salmon and Thursday's salmon aren't the same stock. What's trimmed, frozen for another use or thrown away each night is written off with a reason, since that's where a fish market's margin goes. And live shellfish bring a record of their own: the dealer's tag stays with the bag until it's empty, then gets dated and kept for 90 days. Below is a sheet for a made-up fish market, the nightly sums, and the file.
The short version
- Weigh, don't estimate. Count every morning before opening.
- Each delivery is its own row, with a sell-by date.
- Know your yield: a pound of whole fish isn't a pound of fillet.
- Write off trim and unsold fish each night, with the reason.
- Shellfish: keep each bag's tag on it, and don't mix bags.
- Date the tag when the bag is empty and file it for 90 days.
- TaroStack keeps each delivery as a lot and sends the oldest out first. More below.
An example sheet
Friday morning, before opening.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Salmon fillet | lb | 42 | 30 | $9.80 | $411.60 | OK |
| Cod fillet | lb | 28 | 25 | $7.40 | $207.20 | OK |
| Ahi loin | lb | 18 | 15 | $14.50 | $261.00 | OK |
| Shrimp, 16/20, frozen | lb | 60 | 40 | $8.20 | $492.00 | OK |
| Oysters, 100 count bag | bag | 3 | 2 | $62.00 | $186.00 | OK |
| Littleneck clams, 50 lb bag | bag | 1 | 1 | $95.00 | $95.00 | REORDER |
Ten rows in all, $2,060.20 at cost, with clams to reorder. For fresh fish the reorder level matters less than the dates: nobody restocks salmon to a level. They buy for the next two days' sales.
Dates
| Received | Item | Invoice, ticket or tag | Received | Left | Sell by |
|---|---|---|---|---|---|
| Nov 18 | Ahi loin | Boat ticket 4471 | 30 lb | 18 lb | Nov 21 |
| Nov 19 | Salmon fillet | Inv. 77120 | 50 lb | 42 lb | Nov 22 |
| Nov 17 | Oysters | Tag: harvested Nov 15, area 3 | 2 bags | 2 bags | Nov 25 |
| Nov 19 | Oysters | Tag: harvested Nov 17, area 3 | 1 bag | 1 bag | Nov 27 |
The sell-by dates are this market's own. The ahi came in on the 18th, and today is its third day. By this market's rule it sells today, or it's cut and frozen for poke tonight and comes off the fresh count. The sheet's lots tab flags it. A case card that says "fresh today" doesn't.
Yield
A whole fish costs less a pound than a fillet because much of it isn't fillet.
| Whole snapper | |
|---|---|
| Bought, whole | 22 lb at $6.90: $151.80 |
| Fillet, skin on, after cutting | 9.2 lb |
| Yield | 42% |
| Cost of a pound of fillet | $16.50 |
The 42% is this market's own number for this fish, from weighing before and after. Every species and every cutter has one. Without it the fillet gets priced from the whole-fish cost, and a $6.90 fish sold as $13 fillet loses money on every pound. Heads and frames sold for stock bring a little back. The test is the same one butchers use: see butcher yield test.
The nightly sum
| Salmon fillet, Friday | Pounds |
|---|---|
| On hand at opening | 42.0 |
| Received | 0.0 |
| Sold, by the scale | 26.5 |
| Trimmed and written off | 2.0 |
| Should be left | 13.5 |
| Weighed at closing | 13.1 |
| Unexplained | 0.4 |
Four tenths of a pound on 42 is drip and ice. Two pounds written off is the number to watch: at $9.80 that's $19.60 tonight, and over a month across the case it's the difference between a good market and a struggling one. Write the reason each time: trim, past its date, dropped, sampled.
Shellfish tags
Live oysters, clams and mussels arrive with a dealer's tag on every bag. Federal rules require the tag to show when and where the shellfish were harvested, the type and quantity, and who harvested them (21 CFR 1240.60). The FDA Food Code then puts three duties on the market:
- Keep the tag on the container until it's empty.
- Don't mix shellfish from one tagged container with those from another that has a different harvest date, growing area or dealer certification number. This market has oysters harvested November 15 and November 17: two bins, two tags.
- When a container is empty, write that date on the tag and keep it 90 days, filed in date order.
The tags are how a health department traces an illness back to a harvest area, weeks later. Your state's code is what binds you: check it with your inspector. This is general information, not legal advice. Serving them raw is covered in HACCP plan for raw oysters, and the wider plan in seafood HACCP plan.
Get the sheet
Download the seafood market inventory sheet. Four sheets: inventory with value and REORDER, deliveries with days left, a count sheet that works out each difference and what it's worth, 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
Fish moves faster than a spreadsheet. Three deliveries a week, a dozen species, each with its own date, each partly sold, trimmed or frozen every day. By Thursday the sheet's "salmon, 42 lb" is two deliveries mixed together, and nobody at the counter knows which side of the pan is older. The markdown that should have happened at noon happens the next morning, as a write-off.
How TaroStack does it
TaroStack keeps each delivery apart, by date.
Each delivery is a lot with its use-by. Stock goes out first-expired-first-out by default, and an alert comes before a date arrives.
Weights convert: fish bought by the case and sold by the pound is one item.
Cutting is a recipe with scrap, so 22 pounds of whole snapper becomes 9.2 of fillet at what it really cost.
Every adjustment carries a reason, so trim, past-date and dropped are separate numbers.
Counting works on a phone, in the walk-in. A count shows what a difference is worth.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which salmon is older | One row, mixed | Lots by delivery |
| Fish near its date | Remembered, or not | An alert |
| What a fillet cost | Whole-fish price | From the yield |
| What was written off, and why | A total | Adjustments by reason |
TaroStack doesn't file shellfish tags or run the scale at the counter. It connects to Square. Stock, lots and counts 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.
