Restaurant Budget Template

Monthly P&L-style budget for a restaurant: sales in, expenses by category out, with food-cost and profit margin percentages.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Budget Sheets

Tables

Months, Expenses

Fields

19

Views

grid, calendar, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Months

9 fields · 2 sample rows

  • P&L (Grid)
MonthTextFood salesCurrencyBeverage salesCurrencyTotal salesFormulaExpensesLink to another tableBudgeted costsRollupActual costsRollupProfitFormulaMarginFormula
October₹14,50,000₹3,80,000₹18,30,000Produce & meat — Oct, Staff wages — Oct, Rent — Oct, Swiggy/Zomato commission — Oct₹12,20,000₹12,64,000₹5,66,00030.9%
November₹13,20,000₹3,45,000₹16,65,000Produce & meat — Nov, Staff wages — Nov, Rent — Nov, Walk-in chiller repair₹11,15,000₹9,65,500₹6,99,50042.0%
Field details
Month · Text
Food sales · Currency
INR
Beverage sales · Currency
INR
Total sales · Formula
{Food sales} + {Beverage sales}
Expenses · Link to another table
Links to Expenses
Budgeted costs · Rollup
sum of Budgeted via Expenses
Actual costs · Rollup
sum of Actual via Expenses
Profit · Formula
{Total sales} - {Actual costs}
Margin · Formula
IF({Total sales}, {Profit} / {Total sales}, BLANK())

Expenses

10 fields · 8 sample rows

  • Expenses (Grid)
  • Calendar (Calendar)
  • Cost dashboard (Dashboard)
ExpenseTextMonthLink to another tableCategorySingle selectVendorTextDateDateBudgetedCurrencyActualCurrencyVarianceFormulaPaidCheckboxInvoiceAttachment
Produce & meat — OctOctoberFood costMetro Cash & Carry10 Oct 2026₹4,60,000₹4,92,000₹-32,000Yes
Staff wages — OctOctoberLabourPayroll5 Oct 2026₹4,20,000₹4,18,000₹2,000Yes
Rent — OctOctoberRentPhoenix Mall4 Oct 2026₹2,50,000₹2,50,000₹0Yes
Swiggy/Zomato commission — OctOctoberDelivery commissionsAggregators12 Oct 2026₹90,000₹1,04,000₹-14,000Yes
Produce & meat — NovNovemberFood costMetro Cash & Carry13 Nov 2026₹4,30,000₹2,68,000₹1,62,000
Staff wages — NovNovemberLabourPayroll4 Nov 2026₹4,20,000₹4,20,000₹0Yes
Rent — NovNovemberRentPhoenix Mall4 Nov 2026₹2,50,000₹2,50,000₹0Yes
Walk-in chiller repairNovemberRepairs & maintenanceCoolTech Services16 Nov 2026₹15,000₹27,500₹-12,500
Field details
Expense · Text
Month · Link to another table
Links to Months
Category · Single select
Food cost, Beverage cost, Labour, Rent, Utilities, Marketing, Repairs & maintenance, Licences & fees and 1 more
Vendor · Text
Date · Date
Budgeted · Currency
INR
Actual · Currency
INR
Variance · Formula
IF({Actual}, {Budgeted} - {Actual}, BLANK())
Paid · Checkbox
Invoice · Attachment

Restaurant Budget Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates