Restaurant Profit and Loss Statement

Determine restaurants profitability and analyse costs with ease using this spreadsheet by Alex Bejanishvili
Posted in category BUSINESS & WORK FINANCIAL STATEMENTS

The restaurant profit and loss statement makes it easy for restaurant and cafe owners to keep track of their sales, costs and profits. With space to fill in weekly information over a five week period, it is ideal for recording profit and loss over a one month period. With spaces to compare your actual sales against your budget and last year, it is easy to see whether you are staying on track.

Advertisement


Each week has just three sections to complete: cover data, sales and costs. From this, your costs share distribution, average sale per cover and net profit will be calculated, and summarised in a shareholder scores section at the top of the page. On each sheet is space to enter your company name, address and logo, as well as the date covered, making the statement look your own.

Restaurant Profit and Loss Statement

for Excel® 2003+
Restaurant Profit and Loss Statement Screenshot
Screenshots
1
Excel 2003(XP)
File: XLS
Excel 2007 +
File: XLSX
Template Specifications
Version
1.0.2
Requirements
Microsoft Excel® 2003 or Higher (PC & Mac)
Macros
Not Used
Installation
Not Required
Author
of Spreadsheet123.com
Help & Questions?
Contact Us

Advertisement

Restaurant Profit and Loss Statement Pro

Professional 1.0.2
Restaurant Profit and Loss Statement Pro Screenshot
$14.95
Purchase Now
via clickbank or paypal
Instant Download
Details and Requirements
File Type
.ZIP
Requirements
Microsoft Excel® 2003 or Higher (PC & Mac)
Macros
Not Used
Installation
Not Required
License
Commercial Use (Resale and distribution not permitted)
View License Agreement
Help & Questions?
via Email 24x7
Support
Visit Support Page
Specifications of the Commercial Version
  • Unlocked - so that you can customize it just a little more.
  • Contains Fields for Logo & Company info
  • Ability to insert more rows
  • Technical Support (for 90 days)

Cover Data

Use this section to enter the number of customers for breakfast, lunch and dinner. Simply enter your cover numbers into the actual column for breakfast, lunch and dinner. To compare against plan and last year, ensure you fill these columns in too, and the comparison against both your budget and last year will be automatically completed for you. Green text and arrows indicate in increase compared to your budget or last year, while red text and arrows indicate you are down against budget or the previous years. If your actual cover numbers match your budget or last year cover numbers, you will see a blue arrow.

Sales Data

As with the cover data section, there is space here to fill out your actual, budget and last year data. There are rows, for filling in your food sales for breakfast, lunch and dinner separately, as well as a line for beverages, and one for any other sales you may make. Once all sections are complete, the comparison against budget and last year will be automatically generated for you, with the same colour scheme as in cover data visible.

Costs

The costs section provides spaces to fill in a wide variety of costs that can be expected in a restaurant. The costs list is grouped into sections, starting with labour costs, such as managers salary, kitchen labour cost, bar labour cost, breakfast labour cost, dinner labour cost and other labour costs. Food is split into food inventory opening, food cost and food inventory closing. Similarly, beverages are split into beverage inventory opening, beverage cost and beverage inventory closing. Aside from food and drink costs, there is space to enter any other expenditure, including cleaning materials, glassware and cutlery, kitchen replacement, guest supplies, printing and stationary, miscellaneous, music and entertainment, and equipment hire. If any of these do not apply, simply enter 0, and a dash will be displayed in the cell, indicating there is no information to display for this category.

As with the cover and sales data, completing the budget and last year columns will allow the spreadsheet to calculate a comparison against each, and these will be colour coded with arrows to indicate whether or they are an increase or decrease.

Costs share distribution

The cost share distribution calculates a total cost from each of the four categories: food, beverages, labour and other, giving a gross profit margin from each category based on this. There is nothing to enter in this section, as figures are calculated automatically based on the data entered in the cover data, sales data and costs section.

Average sale per cover

The average sale per cover section calculates the average spend per customer in each of the beverage, dinner (lunch and dinner) and breakfast categories. Again, this information is automatically calculated based on information entered elsewhere on the spreadsheet.

Net profit

The net profit section automatically creates three calculations for you. The first, net profit, simply shows sales minus costs. The net profit percentage shows your profit as a proportion of all sales, while the net profit per cover calculates the net profit per customer.

Shareholder scores

The shareholder scores section at the top of each worksheet shows a summary of the vital details found elsewhere on the sheet. Sales, costs, net profit, net profit percentage, food gross profit margin and beverage gross profit margin are all found here, allowing you to compare weekly figures at a glance.

P&L period summary

The P&L period summary is a separate sheet that can be found at after the weekly worksheets. It adds together cover, sales and costs data found on the five weekly worksheets, calculating shareholder scores, cost share distribution, average sale per cover and net profit across the entire five week period.

Related Content


Advertisement