Skip to content

Pizza Shop Inventory Sheet: Cheese, Dough, Boxes

A pizza shop inventory sheet: cheese used against cheese sold, dough by the day it was made, toppings with dates, boxes by size, and a free spreadsheet.

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 pizza shop has a short list of things to count, and three of them decide whether the week made money. Cheese is the largest food cost on a pizza and the easiest to over-portion, so the sheet's first job is comparing the cheese that was used with the cheese the pizzas sold should have taken. Dough is made in the shop and lives about three days, so each day's dough is counted separately and the oldest is stretched first. And boxes, by size, are the item a shop runs out of on a Friday night. Around them are flour, tomatoes, meats and vegetables, each with a reorder level and, for what's fresh, a use-by date. Below is a sheet for a made-up shop on a Friday afternoon, the cheese sum, and the file.

The short version

  • Count on the same day each week, before the rush.
  • Cheese: used should match pizzas sold × the portion. Check it weekly.
  • Dough by the day it was made. Oldest first.
  • A row for each box size.
  • Fresh toppings get a use-by date.
  • TaroStack takes ingredients off stock from what you made and flags dates. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Pizza flour, 50 lb bags lb 350 300 $0.52 $182.00 OK
Mozzarella, shredded, 5 lb bags lb 85 100 $3.10 $263.50 REORDER
Crushed tomatoes, #10 can can 22 18 $6.50 $143.00 OK
Pepperoni, sliced, 5 lb bags lb 30 25 $4.90 $147.00 OK
Italian sausage, bulk lb 14 15 $4.20 $58.80 REORDER
Mushrooms, sliced lb 8 10 $2.80 $22.40 REORDER

Eleven rows in all, $1,074.06 of stock, with four to reorder: mozzarella, sausage, mushrooms and 14 inch boxes.

The cheese sum

Every pizza has a cheese portion. Multiply the portion by the pizzas sold and you have what the week should have used. The counts say what it did use.

Mozzarella, last week
Opening count 95 lb
Delivered 320 lb
Closing count 85 lb
Used 330 lb
14 inch pizzas sold: 610 at 7 oz 266.9 lb
10 inch pizzas sold: 180 at 4 oz 45.0 lb
Should have used 311.9 lb
Over 18.1 lb

Eighteen pounds over is about $56 of cheese in a week, nearly 6% more than the recipes call for. On 610 large pizzas that's less than half an ounce each: a hand that's a little heavy, every time. It adds up to about $2,900 a year.

The fix is cheap: a portion cup or a scale on the make line, and this sum done every Monday. Extra-cheese orders and cheese used on other items (garlic bread, salads) go into the "should have used" side, or they'll look like waste. The same sum works for pepperoni. What a pizza costs to make is in how to price pizza and pizza profit margin.

Dough by the day

Made Dough balls Left Use by Note
Thursday 120 24 Sunday Use before Friday's
Friday 72 so far 72 Monday

Dough gets better for a day or two in the cooler and then worse. This shop gives it three days. Tray each day's dough together and mark the tray with the day, so the make line pulls Thursday's before Friday's. At close, count what's left of each day. Dough past its day is waste, and the count of it tells you whether you're making too much on slow days.

The sheet values a dough ball at what's in it: flour, yeast, salt, oil. Ninety-six on hand at 46 cents is $44.16.

Boxes

A shop that runs out of 14 inch boxes at eight on a Friday is putting large pizzas in two small boxes or sending someone to a competitor to borrow a bundle. Boxes are cheap, bulky and ordered in bundles with a lead time. Give each size its own row and a level that covers a busy weekend and the wait for the delivery. The 14 inch row is at 180 against a level of 200.

Fresh toppings

Mushrooms, peppers, onions and opened bags of meat and cheese have dates. The second tab lists each delivery with a use-by date and flags what's within three days: today, 8 pounds of mushrooms delivered Tuesday. Use the oldest first, and keep opened bags dated. Food safety for a pizza line is in HACCP plan for pizza, and how much stock a kitchen should hold in how much inventory should a restaurant carry.

Get the spreadsheet

Download the pizza shop inventory sheet. Four sheets: inventory with value and REORDER, dated items 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

The cheese sum needs last week's closing count, this week's invoices, the register's pizza counts by size and this week's count, all in one place on a Monday morning. In a busy shop one of the four is missing most weeks. So the sum doesn't get done, and the first sign of a heavy hand on the cheese is the order creeping up a case a week.

How TaroStack does it

TaroStack keeps the counts and the deliveries, and works out what the recipes should have used.

Each pizza is a recipe: dough, sauce, 7 ounces of cheese, a box. Record what you made and the ingredients come off stock.

Count on a phone, in the walk-in, with no signal. A count shows what each difference is worth, so cheese used beyond the recipes is a number.

Each delivery and each day's dough is a lot with its date. The oldest goes out first by default, and an alert comes before a date arrives.

A reorder list in days of cover, so boxes are ordered before the weekend that needs them.

A price-creep report by supplier, for the cheese.

The job Spreadsheet In TaroStack
Cheese that should have been used A sum from four sources From the recipes and what was made
What the difference is worth Multiply by hand On the count
Which dough to pull The marked tray Oldest lot first
Boxes before Friday Noticed on Friday The reorder list

TaroStack doesn't weigh portions or run the register. It connects to Square. Stock, recipes and counts 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 you do inventory for a pizza shop?

Count everything on the same day each week before service: flour, cheese, tomatoes, meats, vegetables, dough by the day it was made, and boxes by size. Record every delivery in between.

How much cheese should go on a pizza?

Whatever your recipe says, weighed. This example uses 7 ounces on a 14 inch pizza and 4 ounces on a 10 inch, and checks the week's use against that.

How long does pizza dough last in the cooler?

It depends on the recipe. The shop in this example gives its dough three days and marks each tray with the day it was made.

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.