Report this item to Etsy

Catering Spreadsheet Template Excel Google Sheets | Private Chef Event Costing, Menu Pricing, Quote Builder and Booking Tracker

Price:$18.99

Loading
ReadySheetGo  

You can only make an offer when buying a single item

Star Seller. This seller consistently earned 5-star reviews, shipped on time, and replied quickly to any messages they received.

Highlights

  • Designed by ReadySheetGo
  • Digital download
  • Digital file type(s): 2 Files

YOU ARE NOT UNDERPRICING THE FOOD. YOU ARE UNDERPRICING THE LABOUR.

Ask a caterer why a big event lost money and they will tell you the beef went up. It almost never did.

Here is a real event out of the sample file in this workbook. A wedding dinner, 120 guests, quoted at a 33.4 per cent gross margin. Food came in 11 per cent over, which anybody would have shrugged at. Labour came in 18 per cent over, because two servers stayed ninety minutes past the contracted finish and nobody billed for it. That is 766 dollars. The event actually delivered 24.3 per cent.

9.1 points of margin, on one job, and the quote never saw it coming.

This workbook is built to see it coming.


WHAT IT DOES

Prices your food from the bottom up. Enter what a pack costs and how much is in it, once. The workbook works out the unit cost, the batch cost, the cost per portion, the waste-adjusted true cost, the margin on every dish and the food cost percentage, and flags anything priced too thin. Change one pack price and every dish, every quote and every margin in the file moves with it.

Counts every hour you will actually pay for. Not just service hours. Prep. Travel. Load-out. The extra body you always end up needing. Then it adds employer taxes and insurance on top, because the wage is not the cost.

Then it tells you the truth about the quote before you send it. Cost per head against price per head. Gross margin against the floor you set. A THIN MARGIN flag on anything that falls short, and an OVER CAPACITY warning when you have said yes to a third event on a Saturday you can only physically cover twice.


WHAT IS INSIDE - 16 LINKED TABS, 15,839 WORKING FORMULAS, 28 DATA CHECKS

Dashboard - booked revenue, gross margin, food cost percentage, labour percentage, quote to booking rate, deposits banked, money still to collect, guests and events in the next thirty days, and then 28 checks that read your own entries and tell you what needs doing. Nothing on this tab is typed in

Events - one row per enquiry. Type the ID, the client, the date, the guest count, the service style and the status. Everything else calculates: food revenue, food cost, labour, rentals, travel, subtotal, service charge, sales tax, client total, revenue excluding tax, total cost, gross profit, margin, cost per head, price per head, deposit due, money received, still outstanding, balance due date, final headcount deadline

Quote Lines - the quote itself. Pick a Dish ID and the menu price and the true cost per portion arrive on their own. Leave the Dish ID blank for a one-off line and fill the two custom columns

Menu Items - dish, course, portions per batch, batch cost, cost per portion, your own waste override, true cost, menu price, margin per portion, food cost percentage, dietary tags, allergens, prep station

Recipe Lines - one row per ingredient in a dish, with the quantity for a full batch, priced straight from the Ingredients tab

Ingredients - your buying list. Pack cost and pack size in, cost per unit out, with the supplier and the allergen against every line

Clients - events, booked revenue, average booked value and what each one still owes you

Staffing - role, headcount, on-site hours, prep and travel hours, hourly rate, payroll burden, total labour cost, and guests per staff member so you can sanity check the ratio before the day

Rentals and Equipment - what you need against what you already own. You only pay for the shortfall, and you decide per line what gets recharged and at what markup. Delivery dates, return-by dates, damage deposits, and a flag on anything still out past its return date

Prep Timeline - task, station, assignee, how many days before the event, and it works the do-by date out for you. Change the event date and every task moves with it. Anything late is raised as OVERDUE

Payments - deposits, progress payments, balances and refunds. The amount due fills itself in from the event. It tells you what is Paid, Part paid, Due or OVERDUE, and how many days late

Actuals vs Quote - the loop. Quoted against actual on food, labour, rentals and travel and other direct costs, the variance on each, and the margin you really made. It will not report a total until you have filled in all four, because a row with three of the four would tell you that you beat the quote

Settings, Lists, Start Here and Disclaimer - twelve numbers that drive the workbook, your dropdowns, a four-step setup and plain language about what this file is and is not


THE THING NO OTHER CATERING SHEET DOES

Catering software runs a hundred dollars a month and is built for a twenty-person operation. Every catering spreadsheet on the market is a quote form. A quote form tells you what you charged. It does not tell you what it cost.

This one closes the loop. After the event you put the real food, labour, rental and travel figures in, and the quoted and actual sides compare exactly the same four costs, so the variance is real and not an artefact. Then there is a column headed What Happened, for one sentence in your own words.

That sentence is worth more than the spreadsheet. It is why the next wedding is priced properly.


BUILT FOR

Solo caterers and private chefs. Personal chefs cooking in clients' homes. Home-based and cottage-food catering businesses. Drop-off and corporate lunch caterers. Anyone doing two to twenty events a month who is currently quoting from memory and finding out afterwards.

Pairs with our Home Bakery Pricing Calculator and our Farmers Market and Craft Fair Vendor Tracker if you sell across more than one channel.


HOW IT WORKS

1. Open Settings and set your target food cost, waste, payroll burden, service charge, local sales tax, deposit percentage, travel rate, minimum margin and how many events you can physically cover in a day
2. Load your ingredients, your recipes and your menu prices. The costing is automatic from there
3. Add a client and an event, pick the dishes and the portions, plan the staffing and the rentals
4. Open the Dashboard whenever you sit down to work

There is not a single tax figure, mileage rate or government constant anywhere in this workbook that can go out of date. Every rate on the Settings tab is a decision about your own business.


WHAT YOU GET IN THE SAMPLE FILE

A costed catering business you can pull apart: 20 events across the full pipeline from enquiry to paid, 6 clients, 27 costed dishes, 64 ingredients, 128 recipe lines, 125 quote lines and 70 staffing rows. Every date in it is relative, so the file reads sensibly on whatever day you open it. Delete it all and start with your own, or keep it alongside while you learn the shape of the thing.


COMPATIBILITY

Microsoft Excel 2016, 2019 and 365, Windows and Mac
Google Sheets - File, Import, Upload, Replace spreadsheet
LibreOffice Calc and Apple Numbers

No macros. No add-ons. No array formulas. No subscription. Works offline. The file is yours forever.


PLEASE READ BEFORE BUYING

This is a costing and booking workbook. It is a planning tool, not accounting software, not a contract and not tax advice.

The sales tax rate on the Settings tab is one number you set yourself. Real catering tax is not one number - prepared food, alcohol, delivery and service charges are often taxed differently, and the rules change by state and county. Treat the tax line as an estimate for quoting and check the real position before you invoice.

The service charge is treated as your revenue, which is what it usually is in law. Several states require you to say so plainly on the quote and the invoice so a client does not read it as gratuity for the staff. Say what it is, in writing, every time.

The payroll burden percentage is your own estimate of employer taxes, workers compensation and insurance. It is not a calculation of what you owe. Overtime, tipped wage rules, travel time and employee versus contractor status are set by law, not by this file.

The dietary tags and allergen notes are a place for you to record what you know. This workbook cannot verify any of them, does not read your recipes for allergens, and knows nothing about cross-contact in your kitchen. Allergen information given to a guest is your responsibility.

Every check in the file compares your entries against each other. A clear check means your entries are internally consistent. It does not mean they are correct. A dish costed from a stale pack price will produce a confident, well formatted and entirely wrong margin.

Gross profit here is revenue less food, labour with burden, rentals, travel and other direct costs. It is before rent, vehicle, insurance, marketing, your own draw and tax.

Every client, event, supplier and price in the sample file was invented to show you the shape of a working workbook.


WHAT YOU GET

One .xlsx file, delivered instantly on purchase. Free updates. Free customisation help - message the shop with any question about this file and you will get a real answer.

This is a digital download. Nothing is posted.

📗 HOW TO OPEN IN GOOGLE SHEETS (free & easy):
This is one file that works in BOTH Excel and Google Sheets — there's no separate file to find, you just import the download once:
1. Go to sheets.google.com and open a blank spreadsheet
2. Click File ▸ Import ▸ Upload
3. Drag in the .xlsx file you downloaded from this order
4. Choose "Replace spreadsheet" and click Import data
All tabs load as a full Google Sheet saved in your Drive — edit it on any device. (Prefer Excel? Just double-click the file to open.)

———————————————
VIDEO TUTORIAL INCLUDED
This template comes with a step-by-step video walkthrough to help you get set up in minutes. Your tutorial link is included with the instant download.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

Be the first to review this item

No reviews yet. See what customers say about other items from this shop.

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Sep 7, 2026