Skip to content

Pizzeria Inventory Template: Cheese, Dough, Boxes, Pars

A free pizzeria inventory template: cheese and toppings by the pound, dough balls by the day they were made, boxes, par levels, and what each case makes.

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

A pizzeria's inventory is short, and three rows on it decide the week: cheese, which is the biggest cost on the shelf; dough balls, which you make yourself and which are only good for a few days; and boxes, which cost 48 cents and can end a Friday night. A pizzeria inventory template needs each item with its count, a par to reorder at and a cost, and a second sheet where every batch of dough has the day it was made. Here's one, filled in for a made-up neighborhood shop on a Tuesday before the truck.

The short version

  • Cheese and toppings in pounds, sauce by the can, boxes and dough in eaches.
  • A par for each: what you use until the next delivery lands, and a day spare.
  • Dough balls by batch, with a use-by.
  • Know what a case makes: pizzas per bag of cheese is the check on waste.
  • TaroStack takes cheese, sauce and a box off stock for every batch of pizzas recorded. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Mozzarella, shredded lb 60 80 $3.45 $207.00 REORDER
Flour, high gluten lb 300 200 $0.52 $156.00 OK
Dough balls, 14 oz each 140 120 $0.41 $57.40 OK
Pizza sauce #10 can 18 12 $6.90 $124.20 OK
Pepperoni, sliced lb 22 25 $5.80 $127.60 REORDER
Italian sausage lb 15 10 $4.60 $69.00 OK

With mushrooms, boxes and olive oil, nine rows hold $1,044.40. Mozzarella, pepperoni and boxes are under par.

Pars from pizzas

The shop sells about 500 pizzas a week, half of them Friday and Saturday. A 14-inch pie takes 7 oz of cheese.

Cheese a week: 500 × 7 oz 219 lb
Truck comes Tuesday and Friday
Used Friday to Tuesday (about 60% of the week) 131 lb
Used Tuesday to Friday 88 lb

The par of 80 lb is roughly the lighter half-week. Sixty pounds on a Tuesday morning means the order going in today has to cover the weekend: 131 lb plus a cushion, less what's left.

Boxes use the same sum without the ounces. If 70% of pies go out the door, that's 350 boxes a week, and 350 on hand with a par of 400 is a week's supply and no more.

The cheese check

A 7 oz portion means a pound of cheese makes 2.3 pizzas, and the week's 219 lb should make 500. If the count says 250 lb went and the till says 500 pizzas, 31 lb of mozzarella is unaccounted for. At $3.45 that's $107 a week, or $5,560 a year, from heavy hands on the line. A scale or a portion cup fixes it. You only find it by counting.

Dough by the day

Made Lot Balls Use by
Mon, Nov 16 DB-1116 96 Thu, Nov 19
Tue, Nov 17 DB-1117 96 Fri, Nov 20

This shop gives its dough three days in the walk-in. Yours may be longer or shorter; the point is that every tray carries its day, and the oldest tray is used first. The sheet says USE FIRST when a batch is inside three days. Dough past its day goes to garlic knots or the bin, and gets written down either way.

Open containers of cheese, sauce and meats follow your health code's date marking: see date marking under the Food Code.

Get the template

Download the pizzeria inventory template. Four sheets: inventory with value and REORDER, 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. What a pie costs is in how to price pizza.

Where this stops working

Counting 60 lb of cheese is quick. Knowing whether 60 is right, given what was sold since the last count, takes the recipe math for every size and topping, and nobody does that by hand on a Tuesday.

How TaroStack does it

TaroStack does the recipe math and keeps the dough dated.

Each pizza is a recipe. A 14-inch pepperoni is a dough ball, 5 oz of sauce, 7 oz of cheese, 2 oz of pepperoni and a box. Dough is its own recipe: flour, water, yeast, salt in, 96 balls out, with a lot and a use-by.

What the week should have used. Record what was made and each ingredient comes off stock. Count the walk-in on a phone, and the difference between what the recipes say and what's there shows in dollars, before you post it.

Oldest dough first. Lots are used first-expired-first-out, and an alert flags a tray about to pass its day.

The order writes itself. The reorder list shows what's under its reorder point, in days of cover.

At the till. TaroStack connects to Square.

The job Template In TaroStack
Cheese that should be left Portion math by hand From recipes
Count versus expected Not seen A variance in dollars
Dough by day A marker on the tray Lots with use-by dates
Tuesday's order Compare to pars A reorder list

Recipes, batches, lots and counting 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 cheese, meats, sauce, dough and boxes before each order, compare with par, and once a week compare what was used with what the pizzas sold should have used.

How much cheese goes on a pizza?

It's the shop's choice. This example uses 7 oz on a 14-inch pie, which makes 2.3 pizzas from a pound.

How long do dough balls last?

A few days refrigerated, depending on the recipe. Date every batch and use the oldest first. The numbers for opening a shop are in pizza shop business plan.

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.