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
Tables
Months, Expenses
Fields
19
Views
grid, calendar, dashboard
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.
9 fields · 2 sample rows
| MonthText | Food salesCurrency | Beverage salesCurrency | Total salesFormula | ExpensesLink to another table | Budgeted costsRollup | Actual costsRollup | ProfitFormula | MarginFormula |
|---|---|---|---|---|---|---|---|---|
| October | ₹14,50,000 | ₹3,80,000 | ₹18,30,000 | Produce & meat — Oct, Staff wages — Oct, Rent — Oct, Swiggy/Zomato commission — Oct | ₹12,20,000 | ₹12,64,000 | ₹5,66,000 | 30.9% |
| November | ₹13,20,000 | ₹3,45,000 | ₹16,65,000 | Produce & meat — Nov, Staff wages — Nov, Rent — Nov, Walk-in chiller repair | ₹11,15,000 | ₹9,65,500 | ₹6,99,500 | 42.0% |
10 fields · 8 sample rows
| ExpenseText | MonthLink to another table | CategorySingle select | VendorText | DateDate | BudgetedCurrency | ActualCurrency | VarianceFormula | PaidCheckbox | InvoiceAttachment |
|---|---|---|---|---|---|---|---|---|---|
| Produce & meat — Oct | October | Food cost | Metro Cash & Carry | 10 Oct 2026 | ₹4,60,000 | ₹4,92,000 | ₹-32,000 | Yes | |
| Staff wages — Oct | October | Labour | Payroll | 5 Oct 2026 | ₹4,20,000 | ₹4,18,000 | ₹2,000 | Yes | |
| Rent — Oct | October | Rent | Phoenix Mall | 4 Oct 2026 | ₹2,50,000 | ₹2,50,000 | ₹0 | Yes | |
| Swiggy/Zomato commission — Oct | October | Delivery commissions | Aggregators | 12 Oct 2026 | ₹90,000 | ₹1,04,000 | ₹-14,000 | Yes | |
| Produce & meat — Nov | November | Food cost | Metro Cash & Carry | 13 Nov 2026 | ₹4,30,000 | ₹2,68,000 | ₹1,62,000 | ||
| Staff wages — Nov | November | Labour | Payroll | 4 Nov 2026 | ₹4,20,000 | ₹4,20,000 | ₹0 | Yes | |
| Rent — Nov | November | Rent | Phoenix Mall | 4 Nov 2026 | ₹2,50,000 | ₹2,50,000 | ₹0 | Yes | |
| Walk-in chiller repair | November | Repairs & maintenance | CoolTech Services | 16 Nov 2026 | ₹15,000 | ₹27,500 | ₹-12,500 |
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.
Give each department an annual budget, log approved expenses against it and watch spend, remaining balance and quarterly burn update live.
2 tables · 19 fieldsFamily Budget TemplateOne shared sheet for the whole family’s income and spending, with plan-versus-actual per category and a running net for the month.
1 table · 11 fieldsFilm Budget TemplateProduction budget organised above and below the line, with rate × units × days estimates, actuals and variance per department.
1 table · 12 fieldsHome Budget TemplateTrack the running costs of your home alongside what you own, so monthly bills and net worth sit in one place.
2 tables · 18 fieldsHousehold Budget TemplateList every recurring living cost at its real frequency and see it normalised to monthly and yearly, split into needs, wants and savings.
1 table · 10 fieldsMonthly Budget TemplateEnvelope-style monthly budget: set a limit per category, log transactions as you spend and see what is left in each envelope.
2 tables · 13 fields