Skip to content

Seafood Market Inventory Sheet: Weights, Dates, Tags

A seafood market inventory sheet: fish by weight with sell-by dates, yield from whole fish, a nightly write-off, shellfish tags kept 90 days, and a free file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

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.

Questions people also ask

How do you keep inventory in a fish market?

By weight, every morning, with each delivery on its own row and a sell-by date. At night, write off trim and unsold fish with a reason and compare what's left with what the scale says was sold.

How long do shellfish tags have to be kept?

Under the FDA Food Code, 90 calendar days from the date the container was emptied, which is written on the tag. Your state's code sets the rule that applies to you.

How do you work out the cost of a fillet from a whole fish?

Divide the whole fish's cost by the weight of fillet it yields. In the example, 22 lb of snapper at $6.90 gives 9.2 lb of fillet, so a pound of fillet costs $16.50.

Sources

  1. FDA Food Code 2026: 3-202.18 (molluscan shellfish packaging and identification), 3-203.11 (original container; no commingling of shellfish with different certification numbers, harvest dates or growing areas), 3-203.12 (tags kept 90 calendar days from the date the container is emptied) · read November 21, 2026
  2. 21 CFR 1240.60 (molluscan shellfish: all shellstock bear a tag with the date and place harvested, type and quantity, and the harvester) · read November 21, 2026

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.