Skip to content

Egg Inventory Template: Cartons by Pack Date, Feed

A free egg inventory template for a small egg farm: cartons in the cooler by pack date, eggs waiting to be packed, empty cartons, feed, and what to reorder.

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 19, 2026 · 5 min read

An egg farm's inventory turns over in days, and the mistake it makes is always the same one: this morning's cartons go in the front of the cooler and get sold first, while last week's sit behind them. An egg inventory template is built to stop that. It counts cartons in the cooler by pack date, eggs still waiting to be washed and packed, empty cartons and flats, and feed. Then it tells you which pack date to sell first and when you'll run out of cartons. Here's one with a made-up 400-hen farm's numbers.

The short version

  • Cartons in dozens, by the date they were packed.
  • Loose eggs waiting to be packed, in eaches.
  • Empty cartons, flats and labels, with reorder amounts.
  • Feed in pounds, with the mill date.
  • TaroStack keeps each day's pack as a lot and sends the oldest out first. More below.

An example sheet

Clover Hollow Farm is a made-up pastured egg farm in Franklin, Tennessee:

Item Unit On hand Reorder at Unit cost Value Status
Eggs, large, cartons of 12 dozen 96 60 $4.63 $444.48 OK
Eggs, mixed sizes, flats of 30 flat 9 6 $9.80 $88.20 OK
Eggs, unwashed, to pack each 310 0 $0.30 $93.00 OK
Cartons, pulp, printed each 420 500 $0.35 $147.00 REORDER
Flats, 30 count each 150 100 $0.22 $33.00 OK
Carton labels each 900 500 $0.03 $27.00 OK

Layer feed and oyster shell complete it at $1,297.48. Printed cartons are under their reorder amount.

The $4.63 is what a dozen costs this farm to produce, feed, carton and labor together; how it's worked out is in how to price eggs.

Cartons run out before eggs do

The farm packs about 175 dozen a week. Printed cartons take three weeks from the supplier.

Cartons used while waiting (3 weeks × 175) 525
On hand 420
Short by 105

So the order is already late, and the reorder amount of 500 was a little low. Raising it to 700 (four weeks) costs nothing but shelf space. An egg farm with eggs and no cartons has nothing to sell on Saturday.

Pack dates in the cooler

Three of the lots in the cooler:

Packed Lot Dozens packed Sell by Left
Nov 9 P-1109 24 Dec 9 6
Nov 12 P-1112 21 Dec 12 21
Nov 13 P-1113 24 Dec 13 24

P-1109 has six dozen left, and they go first: to the front of the cooler, onto the market table, into today's store order. The sheet flags a lot USE FIRST when it's within a week of its sell-by.

The 30 days here is this farm's own rule. States set their own dating and labeling rules for eggs, and some are shorter. Check yours in egg business license. The pack lot on the carton is your traceability either way: it ties a carton to a day, and the day's row in your egg production log to a flock.

Feed is inventory too

Fourteen hundred pounds is two weeks at 100 lb a day. The mill delivers weekly with a 2,000 lb minimum, so 1,000 lb is the level to call at. Write the mill date and lot from the tag. Feed loses quality as it sits, and if hens go off their lay, a new lot of feed is the first suspect.

Get the template

Download the egg inventory template. Four sheets: inventory with value and REORDER, pack lots with days left, a count sheet that fills itself, 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

Eggs leave in three directions every week: the market, the egg share, the store. Each takes a few dozen from whatever lot is nearest the cooler door, and the "left" column is only right if someone updates it after every one.

How TaroStack does it

TaroStack decides which carton leaves, and remembers where it went.

A day's pack is a lot. A dozen is a recipe: twelve eggs and a carton. Record the day's packing and the cartons come off stock; the dozens go in with a pack lot and a sell-by.

Oldest first, by default. An order for the store takes P-1109 before P-1112 without anyone reading dates. A lot close to its sell-by raises an alert.

Where each lot went. Each delivery records the lots it took. If there's ever a question about one day's eggs, one report lists who got them.

Cartons on the reorder list. With the supplier's lead time on file, the list shows cartons in days of cover.

The market has no signal. Record sales on a phone offline; it sends itself later.

The job Template In TaroStack
Which cartons to sell first Read the dates The oldest lot, by default
Dozens left by pack date Update by hand Comes off with each sale
Who got Nov 9's eggs Memory One report
When to order cartons Arithmetic Days of cover

Lots, expiry and the reorder list 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 track of egg inventory?

Count cartons by pack date, sell the oldest date first, and keep empty cartons and feed on the same sheet.

How long can eggs be sold after packing?

It depends on your state's rules. This example uses 30 days from packing as the farm's own limit.

How many cartons should an egg farm keep on hand?

At least what you pack during your supplier's lead time, and a week more. For 175 dozen a week and a three-week wait, that's about 700.

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.