Skip to content

Meat Inventory Spreadsheet: Cuts, Freezers, Dates

A meat inventory spreadsheet for a farm selling by the cut: pounds of each cut by freezer, processing dates as lots, and why ribeyes run out first.

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 · 7 min read

A farm that sells meat by the cut doesn't stock products. It stocks animals that have been taken apart. A meat inventory spreadsheet has a row for each cut, counted in pounds, with which freezer it's in and what a pound cost you. Behind the rows are the processing dates: each trip to the processor is a lot, named for the animals that went, with a date to sell by. And the sheet has one job that an ordinary inventory doesn't. When a cut runs low you can't order more of it. Ribeyes come back with the next steer, along with seven times their weight in ground beef. So the reorder level here is a warning to change the price or the bundle, not a note to call a supplier. Below is a sheet for a made-up farm in November, the cut arithmetic, and the file.

The short version

  • One row for each cut, in pounds, with its freezer.
  • Each processing date is a lot. Sell the oldest first.
  • A steer is mostly ground beef and roasts. Steaks are a small part and sell first.
  • When a cut runs low, raise its price or sell it only in bundles.
  • Count each freezer on its own. A chest freezer hides things.
  • TaroStack keeps cuts by lot and freezer, with the orders beside them. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Ground beef, 1 lb packs lb 142 100 $6.10 $866.20 OK
Ribeye steaks lb 18 20 $14.50 $261.00 REORDER
Chuck roast lb 64 30 $7.20 $460.80 OK
Stew meat, 1 lb packs lb 38 20 $6.80 $258.40 OK
Short ribs lb 12 15 $8.40 $100.80 REORDER
Soup bones lb 55 10 $2.50 $137.50 OK

Ten rows in all, $3,251.90 in three freezers, with three cuts running low: ribeye steaks, short ribs and bacon.

You can't reorder a ribeye

From two steers, processed Oct 28 Came back Left on Nov 20 Sold
Ground beef 310 lb 142 lb 54%
Ribeye steaks 44 lb 18 lb 59%

Two steers gave 44 pounds of ribeye and 310 pounds of ground beef: seven pounds of ground for every pound of ribeye. Three weeks later both are a little over half sold, which is this farm doing it right. On most farms the ribeyes are gone in ten days and the ground beef is still there when the next animals come back.

The sheet can't make a steer grow more ribeye. It can tell you early that a cut is running ahead of the others, while there's time to act:

  • Price by scarcity. If steaks sell out first at your price, the price is too low. Raise it until they last about as long as the ground beef.
  • Bundle. A box with two ribeyes, a roast and five pounds of ground beef sells the animal in the proportions it came in.
  • Limit. Two packs of steaks an order, or steaks only with a bundle.
  • Don't list what you don't have. The online shop's quantity for a cut should be what's in the freezer, less what's already promised.

The reorder level on each row is set with that in mind: it's the point at which you stop selling the cut on its own. The next processing date is the "delivery". Selling by the half or whole avoids all of this: see how to price beef by hanging weight.

Processing dates are lots

Processed What Lot Came back Left Sell by
Oct 28 Ground beef Steers 26-07 and 26-08 310 lb 142 lb Oct 28 next year
Oct 28 Ribeye steaks Steers 26-07 and 26-08 44 lb 18 lb Oct 28 next year
Sep 15 Bacon Hogs 26-P3 and 26-P4 62 lb 9 lb Mar 15
Nov 6 Whole chicken Chickens, Nov 6 160 lb 120 lb May 6

Every package from the processor carries its date, and the plant's label where the meat was inspected. On the sheet, each processing date is a lot named for the animals that went. That gives you three things. You sell the oldest first. You can tell a customer which animals their beef came from, which is part of what they're paying for. And if a package is ever in question, you know which others came back with it.

The sell-by dates here are this farm's own: a year for frozen beef, six months for cured pork and poultry. Frozen meat stays safe longer than that, but its quality falls, and a customer who opens freezer-burned bacon doesn't reorder.

Freezers

Count each freezer as its own place. Upright freezers with one cut to a shelf can be counted in minutes. Chest freezers need baskets or labeled bags by cut, or the count becomes an excavation. Keep the oldest lot on top or in front.

A freezer is also a risk the sheet should record. If one fails, you want to know by the end of the day exactly what was in it and what it was worth, for the insurer and for your own decisions. Put an alarm thermometer on each.

What a meat label needs is in meat labeling requirements. Whether the year pays is worked through in is pig farming profitable and is goat farming profitable. A shop that cuts and sells fresh meat counts differently: see butcher shop inventory.

Get the spreadsheet

Download the meat inventory spreadsheet. Four sheets: inventory by cut with value and low-stock flags, processing dates 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

Saturday's market sells forty packages from two coolers. Online orders come in all week for Thursday pickup. Every one of those takes pounds off a row, from a particular lot, in a particular freezer. The sheet is right on the morning it's counted. By Wednesday the shop is offering ribeyes that were sold at the market, and a customer orders six that aren't there.

How TaroStack does it

TaroStack keeps the freezer and the orders in the same place.

Each cut is an item, in pounds. Each processing date is a lot with its date, and the animals it came from in its notes.

Stock is held by place, so each freezer has its own count.

Customers and sales orders, with one picking list for pickup day and a delivery note for each order.

Oldest first. Picking takes the first-expired lot by default, and an alert comes before a sell-by date.

Count on a phone, at the freezer, with no signal. A count shows what each difference is worth.

The job Spreadsheet In TaroStack
Ribeye left after the market Friday's number Stock, less what was sold
Which lot a customer got Unknown Recorded as it ships
What's in freezer 2 Open it Stock by place
Packages near their date Read labels The expiry alert

TaroStack isn't a herd record and doesn't run an online shop. It connects to Square. Stock, lots, customers and orders 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 I keep track of meat inventory?

Give each cut a row in pounds with the freezer it's in, record each processing date as a lot with the animals it came from, and count each freezer on a set day.

Why do I always run out of steaks first?

Because an animal gives far less steak than ground beef and roasts, and customers ask for steak first. Price the steaks higher, sell them in bundles, or limit them per order.

How long can frozen meat be sold?

Frozen meat stays safe for a long time, but quality falls. The farm in this example sells frozen beef within a year of processing and cured pork and poultry within six months.

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.