Skip to content

Feed Store Inventory Template: Bags, Bales, Mill Dates

A feed store inventory template: bagged feed by the pallet with mill dates, hay and bedding, pet food and fencing, value and reorder levels, 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

A feed store's stock is heavy, cheap by the pound and sold by the pallet, and half of it has a date. A feed store inventory template has a row for each product, counted in bags and bales, with what's on hand, what one cost and a level to reorder at. Bagged feed gets one thing more: the date it was milled, from the tag sewn into the bag. Feed loses quality as it sits, and the pallet at the back of the row is always older than the one at the front. The rest of the store, hay, bedding, pet food, salt blocks, fencing, is ordinary counting, with reorder levels that follow the season. Below is a sheet for a made-up feed store, the mill dates, and the file.

The short version

  • Count in bags and bales. Count full pallets first, then the loose bags.
  • Write each delivery's mill date. Sell the oldest first.
  • Bagged feed is about half the value on the floor, at the thinnest margin.
  • Reorder levels move with the season: chick starter in spring, hay in winter.
  • Torn bags, mice and spoiled hay are shrink. Write them off with a reason.
  • Keep feed with a drug in it apart, and labeled.
  • TaroStack keeps feed by lot and date, counted on a phone. More below.

An example sheet

Counted on a Saturday after closing.

Item Unit On hand Reorder at Unit cost Value Status
Layer pellets, 50 lb bag 140 120 $15.20 $2,128.00 OK
All-stock sweet feed, 50 lb bag 96 80 $13.40 $1,286.40 OK
Senior horse feed, 50 lb bag 62 60 $22.50 $1,395.00 OK
Scratch grains, 50 lb bag 44 60 $12.10 $532.40 REORDER
Alfalfa hay bale 85 100 $14.00 $1,190.00 REORDER
Field fence, 330 ft roll roll 7 6 $189.00 $1,323.00 OK

Ten rows in all, $10,357.00 at cost, with two to reorder: scratch grains and alfalfa hay. Bagged feed is $5,341.80 of it, a little over half.

Counting pallets. This store's pallets hold 40 bags of 50 lb when they're full. Count the full pallets, multiply, and add the loose bags on the open one. Three full pallets and twenty bags is 140.

Unit cost is what a bag cost you delivered, freight included. On feed the margin is a few dollars a bag, so a freight bill left out of the cost is most of the profit left out of the sum.

Mill dates

Received Item Milled Bags Sell by Note
Oct 14 Layer pellets Oct 12 80 Jan 12 Sell these first
Nov 5 Layer pellets Nov 3 60 Feb 3
Oct 22 Senior horse feed Oct 20 62 Jan 20
Sep 30 Dog food, 40 lb 38 Aug 15 next year Best by on the bag

The 140 bags of layer pellets are two deliveries, three weeks apart. The older 80 go out first, and they will only if they're in front. New pallets go behind or beside the old ones, never in front of them. That's the whole of stock rotation, and it's the first thing to slip on a busy delivery day.

The "sell by" here is this store's own rule, three months from milling. Ask your mill what it advises for each feed: pellets, sweet feeds with molasses and feeds with added fat don't keep alike, and heat and damp shorten all of them. Read the tag when the pallet arrives. A pallet that was already two months old at the mill's warehouse is a conversation to have that day, not in January.

Medicated feed. Feed with a drug in it has its own label and its own rules. Keep it on its own pallet, clearly marked, and never refill an open bin from a bag without reading the tag. Check the rules that apply to you with your mill and your state's feed program.

Shrink

What happens Where it shows
A bag torn by the forklift Loose feed on the floor, a bag short
Mice and birds Chewed corners; bags that weigh light
Hay that got wet Bales that can't be sold
A bag loaded and not rung up Nothing, until the count

Write each one off when it happens, with the reason. A torn bag sold at half price is a sale and a write-off of the other half. At the count, what's still missing after the write-offs is the part to worry about. The department margins and what shrink costs are in feed store profit margin, and the business in feed store business plan.

Get the template

Download the feed store inventory template. Four sheets: inventory with value and REORDER, deliveries with mill dates and 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

A feed store carries a few hundred items, and every sale changes one of them. The register knows what was rung up. The spreadsheet knows what was counted three Saturdays ago. Between them is everything that happened in the warehouse: the pallet that came in, the six bags loaded for a delivery, the bale that got rained on. And nobody at the register can see that the pellets on the front pallet were milled in July.

How TaroStack does it

TaroStack keeps each delivery of feed as its own lot, with its date.

Receiving records each delivery's lot and date, with or without a purchase order.

Oldest first. Stock goes out first-expired-first-out by default, with an alert before a date arrives.

Counting works on a phone with no signal, in the warehouse or the hay barn. A count shows what a difference is worth.

Every adjustment carries a reason: torn, spoiled, missing.

A reorder list in days of cover, with each supplier's lead time and minimum, such as a full truck from the mill.

The job Spreadsheet In TaroStack
Which pellets are oldest Read the tags Lots by date
Feed near its date Found by a customer An alert
What shrink cost this month Unknown Adjustments by reason
When to order the next truck When a row looks empty Days of cover, with the mill's minimum

TaroStack doesn't run the register. It connects to Square. Stock, lots, counts and reordering are on every plan. A store with a few hundred items fits Growth at $39 a month (3,000 items). 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 inventory in a feed store?

Count bags and bales, pallets first and then loose bags, with a reorder level for each product. For bagged feed, record each delivery's mill date and sell the oldest first.

How long does bagged feed keep?

It depends on the feed and how it's stored. The store in this example sells within three months of milling as its own rule. Ask your mill what it advises for each product.

How do I read the date on a feed bag?

Look at the tag sewn into the bag or printed on it. Mills print a manufacture date or a lot code that includes it. If you can't read it, ask the mill for the key.

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.