DK Agency
All toolsTools / Excel templates
Excel templates

Ready-made Excel templates for restaurants

Profit and loss, stock, payroll, budget, balance sheet, waste and invoice prices — formulas built in, in Azerbaijani. Enter your numbers; the template does the rest.

  • Formulas ready
  • Opens in Excel, Google Sheets and Numbers
  • A «how to use» page in every file
  • Free for members

Join for free to download

Sign-up takes a minute. Previews are open to everyone; downloads are for members.

Preview of the «12-month profit and loss» template (sample numbers)

Excel · .xlsx

12-month profit and loss

Revenue, costs and profit for every month in one sheet, with the year total and each line as a share of sales.

  • Gross, operating, pre-tax and net profit
  • Prime cost (cost of sales + payroll) month by month
  • Loss-making months turn red
Preview of the «Inventory and cost of sales» template (sample numbers)

Excel · .xlsx

Inventory and cost of sales

Opening stock, purchases and the closing count give the cost of food used and your food cost %.

  • 40 item rows with category and unit
  • «Reorder» alert at the reorder level
  • Food cost % calculated automatically
Preview of the «Payroll costs» template (sample numbers)

Excel · .xlsx

Payroll costs

Wages by position, overtime and employer insurance contributions; payroll as a share of sales.

  • Front and kitchen separately
  • Payroll per guest and guests per labour hour
  • Prime cost % together with food cost
Preview of the «Budget vs actual» template (sample numbers)

Excel · .xlsx

Budget vs actual

Put the monthly plan next to actual spend: variance in ₼ and %, overspend in red.

  • 21 lines from rent to delivery commission
  • Group subtotals and grand total
  • A note column for every line
Preview of the «Balance sheet» template (sample numbers)

Excel · .xlsx

Balance sheet

Assets, liabilities and equity for two years, with a check row and ratios showing the ability to pay debts.

  • Current and non-current assets and liabilities
  • Current ratio and debt ratio
  • The «check» row flags mistakes at once
Theoretical vs actual usage
ItemOpening stockPurchasesCountActual usageTheoretical usageGapGap value (₼)Status

Excel · .xlsx

Theoretical vs actual usage

How much food the recipes say should have gone, how much the stock count says did go — the gap is waste in money.

  • Gap per item: quantity, ₼ and %
  • Actual and theoretical food cost side by side
  • You set the warning threshold
Invoice price tracker
DateSupplierItemQuantityUnit priceAmountPrevious priceChange (%)Status

Excel · .xlsx

Invoice price tracker

Enter invoice lines: the previous price of the same item is found automatically and a warning shows when it rises.

  • 100 invoice lines
  • Extra cost of increases in ₼
  • Works in Excel, Google Sheets and Numbers
Count by storage place
Storage placeShelf orderItemUnitUnit priceCountValue (₼)

Excel · .xlsx

Count by storage place

Items in the order they sit on the shelves: the counter goes shelf by shelf and misses nothing.

  • Fridge, freezer, dry store, bar — the list is editable
  • Value per place and stock total
  • The total feeds the «Stock and cost of goods» template

The numbers in the templates are examples — replace them with your own. Confirm tax and insurance contribution rates with your accountant. You may use the templates freely in your business; selling them or sharing them under another name is not allowed.