Restaurant Monthly Profit and Loss Statement Template for Excel
Restaurant P&L Template for MS Excel
Excel Templates
Business Templates
Invoice Templates
HR & Timesheet Templates
Retirement & Savings
Excel Tutorials & FAQs
Excel FAQs
If you are serious about making more money in your restaurant, you have got to know your business running costs and not just once a month, but at the end of every week. By having done so you will win yourself a huge amount of valuable time to act on arising problems.
Calculating Profit and Loss is a must for any restaurant serious about making profit.
The Restaurant Monthly Profit and Loss Template contains five P&L worksheets for every week of the month.
I have also included a Budget Tool that helps to allocate your Prime Cost amounts.
What is a Prime Cost?
Prime cost is cost of sales (food & beverages) plus all payroll related costs, including gross payroll of all management and hourly personnel and payroll taxes, benefits, worker's compensation, etc.
Prime cost usually runs 60% to 65% of total sales in a full service restaurant and 55% to 60% of sales in a quick service restaurant.
If you run a restaurant, I will also recommend you to take a look at Menu and Recipe Cost Template, Beverage Stock Take Template and Food Stock Take Template
 Screenshot Full template preview on DocStoc |
Restaurant Monthly Profit and Loss Statement Template for Excel that contains five weekly P&L Workbooks can be a real help when calculating your weekly and monthly profit and costs. The Profit and Loss Worksheet also has an integrated budget tool that allocates estimated revenue, profit and costs per set margin and also helps to compare to the actual cost of sales for every week of the month. Instructions are simple, just enter the amounts from you POS in to the blue cells and this is really all you have to do. The P&L Template can be customised to suit your business requirements. You can download and use or free restaurant monthly profit and loss statement template only for your personal use. Read our Limitation of Use Policy that are applicable to both free and unlocked version of this Restaurant Monthly Profit and Loss Statement Template. If you need to download this template for commercial use, then you may need to purchase unlocked version of the Restaurant Monthly Profit and Loss Statement spreadsheet, that will also allow you to customize this spreadsheet to your company specific requirements. You can also download Restaurant Monthly Profit and Loss Statement Template that works in OpenOffice.org Calc.  |
Version: RPLT 1 File Type: .xls Size: ~358.0 KB Required: Microsoft Excel® Not Required: Installation Macros Cost: $0.00 Free for personal use License: View EULA |
|
Buy unlocked version of Restaurant Profit & Loss Statement Template risk free with 30 day full money-back guaranty!  Cost: $14.95USD Download will start after your payment is processed. |
||
|
Disclaimer: This template and the information on this page is for educational purposes only. We do not guarantee the results. Use this template at your own risk. You should seek the advice of qualified professionals regarding financial decisions. |
||
Other Small Business Templates and Spreadsheets for ExcelRestaurant Menu and Recipe Cost Template - Prepare an accurate costing for all of the menu items. Restaurant or Bar Stock Take (Food) - In house food stock monitoring and control template for excel. Bar or Restaurant Beverage Stock Take Template - Beverage stock monitoring and control spreadsheet for excel. |
Links to other Excel or Restaurant Software Related Sites we Recommendwww.hotelsmartsuite.com - this site does offer a very well designed software and few services related to Hotel Business including Front Desk, Back Office, Online Booking, Marketing and many more. www.gomsg.com - Start accepting credit cards and other electronic payments now. Merchant Service Group has a solution for every business. |
Books related to Restaurant Management |
Share Our Monthly Profit and Loss Statement TemplateIf you have a web site or blog related to Excel, Restaurant or Hotel Software please link to this page to spread the word about our free Monthly Profit and Loss Statement spreadsheet resources. Please copy and paste the HTML code below. |
Spreadsheet123. All rights reserved.
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation. Spreadsheet123.com is not associated with Microsoft.
