Skip to content

Dog Treat Inventory Spreadsheet: Bags, Lots, Dates

A dog treat inventory spreadsheet: ingredients, pouches and finished bags on one sheet, a lot code and best-by on every batch, and the xylitol check.

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 dog treat bakery has three kinds of stock, and its inventory spreadsheet keeps all three on one sheet: ingredients, packaging, and finished bags. The finished bags are the part that needs most care. Every batch gets a lot code and a best-by date, both printed on the bag, and the sheet's second tab lists each batch with how many bags are left and how many days they have. That's what lets you ship the oldest first, see a soft biscuit running out of time, and answer a shop that asks which bags came from which bake. One ingredient gets a check of its own at the door: peanut butter, for xylitol. Below is a sheet for a made-up bakery in November, the lots tab, and the file.

The short version

  • Ingredients, packaging and finished bags, each with a reorder level.
  • A lot code and best-by date on every bag.
  • Ship the oldest lot first.
  • Soft treats have short dates. Bake them to order or in small batches.
  • Check every peanut butter delivery's label for xylitol.
  • TaroStack gives each batch its code and takes the ingredients off stock. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Oat flour lb 42 40 $1.10 $46.20 OK
Peanut butter, no xylitol lb 18 15 $2.40 $43.20 OK
Pumpkin puree, #10 can can 5 6 $7.80 $39.00 REORDER
Eggs, large dozen 6 5 $4.20 $25.20 OK
Sweet potato, dried slices lb 9 6 $5.50 $49.50 OK
Resealable pouch, 6 oz each 260 300 $0.24 $62.40 REORDER

Ten rows in all, $712.40 of stock, with three to reorder: pumpkin puree, pouches, and the pumpkin biscuits themselves. For a finished product, "reorder" means bake.

Three kinds of stock

Kind Counted in Reorder level means
Ingredients Pounds, cans, dozens Order from the supplier
Packaging Eaches Order, and mind the lead time: printed pouches and labels take weeks
Finished bags Bags, by lot Bake a batch

Packaging is the one that catches people. Flour comes in two days. Printed pouches can take three weeks, and a bakery with ingredients and no bags can't sell anything. The pouch row is at 260 against a level of 300, set high for that reason.

Lots on the bag

Baked Product Lot Bags made Left Best by Note
Nov 4 Peanut butter biscuits PB-1104 120 36 May 4 Ship these first
Nov 18 Peanut butter biscuits PB-1118 60 60 May 18
Sep 2 Pumpkin biscuits PK-0902 90 38 Dec 2 11 days left

The lot code here is two letters for the product and the bake date. Any scheme works if every batch has its own and it's on every bag: see how to create lot numbers.

Oldest first. There are 96 bags of peanut butter biscuits: 36 from November 4 and 60 from November 18. The next order ships from PB-1104. Keep the older lot at the front of the shelf.

Short dates. The pumpkin biscuit is softer and this bakery gives it three months, against six for the crunchy ones. Thirty-eight bags have eleven days left. They're the bags to put in this week's market basket at a discount, and the reason to bake that product in batches of 45, not 90. How long each kind keeps is in dog treats shelf life.

The complaint. A shop calls about a bag. With the code, you know the bake, what went into it and which other shops got bags from it. Without the code, every bag of that product in every shop is in question.

The xylitol check

Xylitol is a sweetener used in some peanut butters and other sugar-free foods, and it's dangerous to dogs. A brand can change its recipe without changing its jar. So every delivery of peanut butter is checked at the door: read the ingredient list, write the supplier's lot number on the sheet, and note that it was checked. The same goes for any ingredient that's a blend made by someone else.

Dog treats sold in stores are animal feed under state law, with their own label and registration rules: see dog treat business license. Packaging is covered in how to package dog treats for sale, and pricing in how to price homemade dog treats.

Get the spreadsheet

Download the dog treat inventory spreadsheet. Four sheets: inventory with value and REORDER, lots 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

A batch of 120 bags changes eight rows: flour, peanut butter, eggs, pouches and labels go down, finished bags go up, and a new lot goes on the second tab. Then every order takes bags off, from one lot or two. The sheet is right if all of that is typed in every time. And it never records the link that matters in a complaint: which peanut butter delivery went into which bake.

How TaroStack does it

TaroStack makes the batch do the bookkeeping.

Each treat is a recipe. Record a batch and the flour, peanut butter, pouches and labels come off stock.

Every batch gets a lot code and a best-by date, and lot labels print with both.

The batch notes which ingredient lots it used, automatically: the peanut butter delivery is on the record of every bake it went into.

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

One report for a recall: which shops got a lot, how many bags, and what's still on your shelf.

The job Spreadsheet In TaroStack
Take ingredients off after a bake Eight rows by hand Recorded with the batch
Which lot to ship Read the second tab Oldest first, by default
Bags near their date Look for the flag The expiry alert
Which bakes used that peanut butter Not recorded The lots on each batch

Stock, lots, recipes and recalls are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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 dog treat inventory?

Keep ingredients, packaging and finished bags on one sheet, each with a reorder level, and list every batch with its lot code, best-by date and bags left.

Do dog treats need a lot number?

It's what lets you trace a complaint or a recalled ingredient to particular bags. Put a lot code and a best-by date on every bag, and keep a record of each batch.

How long do homemade dog treats last?

It depends on how dry they are. In this example crunchy biscuits get six months and a softer pumpkin biscuit three. Test your own recipe before you print a date.

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.