Restaurant Invoice Template
Invoice catering clients and corporate accounts with a template built for food service — per-person pricing, gratuity, deposit tracking, and a log of every outstanding bill.
What's Inside This Restaurant Invoice Template
This template includes 5 worksheets, each designed for a specific part of your restaurant financial workflow:
Invoice
The main printable invoice for catering events, corporate dining accounts, and wholesale food orders. The header holds your restaurant's name, address, phone, and a logo placeholder. Below that is the Bill To section for client and event details, including event date, venue, and guest count. The line items table handles the billing structures restaurants actually use: per-person packages with a quantity and rate, à la carte food and beverage items, flat-fee services like delivery or equipment rental, and a dedicated row for service charges and gratuity calculated as a percentage of the food and beverage subtotal. The totals block calculates subtotal, service charge, tax, any deposit received, and the final balance due — all automatically. Payment terms and wire/check instructions appear in an editable text block at the bottom.
Invoice Log
A running register of every invoice issued, designed for catering departments and restaurants with multiple active accounts. Each row captures the invoice number, client name, event date, invoice date, due date, total amount, deposit received, balance due, and payment status (Paid, Deposit Received, Outstanding, Overdue). Formulas calculate the total outstanding balance and total collected year-to-date automatically. Conditional formatting highlights overdue invoices so you can spot collections follow-ups without scanning the full list. For restaurants running 10–20 events a month, this sheet is where you start — it shows exactly who owes what and what's already been deposited.
Client List
A directory of your catering clients and wholesale accounts that populates the Invoice sheet via dropdown. For each client, store the company or contact name, billing address, event coordinator name, phone, email, default payment terms, and whether a deposit is required. Selecting a client on the Invoice sheet auto-fills the Bill To section — no retyping addresses for repeat corporate clients or regular event venues. Keeping this list current also makes it easy to track clients who have negotiated specific terms, like a corporate account on Net 30 or a venue that always requires a 50% deposit at booking.
Catering Menu & Rates
A lookup table of your standard catering packages, per-person rates, and à la carte items. Organized by category — breakfast packages, lunch buffets, dinner packages, beverage packages, staffing, equipment, and delivery — each row has a description, unit (per person, per hour, flat fee), and rate. The Invoice sheet references this table via dropdown: select an item and the unit and rate auto-fill, so you're not retyping prices or risking quoting inconsistent rates across events. When you update pricing seasonally, change it once in the Catering Menu sheet and it flows through to all future invoices. The sheet doubles as a quick reference for staff who field catering inquiries by phone.
Deposit Tracker
A dedicated sheet for managing deposits on booked events — the financial piece of catering operations that most generic invoice templates ignore. Each row represents a booked event with the client, event date, total contract value, deposit required (calculated as a percentage you set), deposit amount received, deposit received date, and the remaining balance due on the event date. The sheet flags events where the deposit is overdue based on a booking lead time you configure. For catering operations with 30+ days between booking and event, tracking deposits separately from invoices prevents the situation where an event is fully staffed and prepped before anyone notices the deposit check never arrived.
Restaurant Invoice Template Features
- Per-person pricing with auto-calculated subtotals for events of any size
- Gratuity and service charge calculated as a configurable percentage of food and beverage
- Deposit tracking: balance due updates automatically when deposit is applied
- Client dropdown that auto-fills billing address and payment terms
- Catering menu and rate card to enforce consistent pricing across events
- Invoice log with outstanding balance and overdue flagging for active accounts
How to Use This Restaurant Invoice Spreadsheet
Setup takes about 20 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins needed. Start with the Catering Menu & Rates sheet: enter your standard packages, per-person rates, à la carte items, and any flat-fee services like delivery or staffing. Then populate the Client List with your regular corporate accounts and event venues. Once those two tables are complete, creating any new invoice is a matter of selecting from dropdowns rather than typing from scratch.
To create an invoice, go to the Invoice sheet, enter the invoice number and event details (date, venue, guest count), and select the client from the dropdown. In the line items section, pick each item from the Catering Menu dropdown, enter the quantity or headcount, and the rate and total fill in automatically. Add your service charge percentage and the gratuity calculates itself. If a deposit has been received, enter it in the deposit field and the balance due updates immediately. Print or export to PDF to send — the layout is formatted to look clean on a standard page.
After sending, log the invoice in the Invoice Log and set the status to Outstanding or Deposit Received depending on where things stand. Update to Paid when the final payment clears. For events booked weeks in advance, use the Deposit Tracker sheet to monitor which upcoming events still have outstanding deposits — this is where catering operations most often lose money, by running an event before confirming the deposit is in hand. A weekly 10-minute check of the Invoice Log and Deposit Tracker keeps your receivables current without letting anything slip through the cracks.
Send your next catering invoice in under 10 minutes
Set up your catering menu and client list once, then create professional invoices for any event — with per-person pricing, gratuity, deposit tracking, and a full log of outstanding bills.
Why Restaurants Need a Dedicated Invoice Template
Most restaurants use invoices in one of three situations: catering and private events billed to corporate clients or event hosts, wholesale food supply to other businesses, and on-account dining for corporate accounts. In all three cases, a generic invoice template creates friction. Catering invoices need per-person pricing, gratuity, and deposit tracking — none of which appear on a standard business invoice. Wholesale food orders need itemized product lines with unit prices and delivery charges. The result is that most restaurant operators either cobble something together in Word or spend 30 minutes reformatting a generic spreadsheet before every event.
Restaurant catering invoices carry two risks that don't apply to most service businesses. The first is pricing errors: quoting a 200-person event at the wrong per-person rate, forgetting to include gratuity, or applying tax to non-taxable catering services are all costly mistakes that are hard to correct after the fact. The second is deposit exposure: catering operations routinely commit food costs, labor, and equipment rental weeks before the event date. Without a system to confirm deposits are received before you start prepping, you're extending unsecured credit to clients who haven't yet committed. This template addresses both by building the deposit workflow into the invoice system rather than treating it as a separate accounting task.
The operational workflow for catering invoicing works in three stages. At booking, create the invoice with the estimated headcount and menu, calculate the required deposit (typically 25–50% of the total), and send it immediately. When the deposit clears, mark it in the Deposit Tracker and update the Invoice Log status. After the event, adjust the invoice for the final guest count and any additions, apply the deposit already received, and send the final balance. This three-stage workflow — estimate, deposit, final — is standard in the catering industry and is exactly what this template is structured around.
Restaurant Industry at a Glance
Financial templates built for restaurants — from fast-casual to fine dining. Pre-loaded with food cost categories, labor splits, and industry-standard KPIs.
Revenue Drivers
- Dine-in sales
- Takeout & delivery
- Catering
- Alcohol sales
Key Cost Categories
- Food costs (COGS)
- Labor
- Rent & occupancy
- Utilities
- Marketing
- Equipment & maintenance
Typical Margins
Gross: 60-70% · Net: 3-9%
Seasonality
Higher revenue in summer and holiday seasons; January-February typically slowest months.
Key Performance Indicators
Restaurant Invoice Template FAQ
More Restaurant Templates
Restaurant Balance Sheet Template for Excel
$29
Restaurant Budget Template for Excel
$29
Restaurant Cash Flow Template for Excel
$29
Restaurant Expense Tracker Template for Excel
$29
Restaurant Financial Model Template for Excel
$29
Restaurant Income Statement Template for Excel
$29
Restaurant KPI Dashboard Template for Excel
$29
Restaurant P&L Template for Excel
$29
Restaurant Pro Forma Template for Excel
$29
Restaurant Project Budget Template for Excel
$29
Restaurant Sales Forecast Template for Excel
$29
Restaurant Valuation Template for Excel
$29
Restaurant Invoice Template
$29