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
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.
>> Download Now
Version: RPLT 1
File Type: .xls
Size: ~358.0 KB
2002(XP), 2003, 2007
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 Excel
Restaurant 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 Recommend
www.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.
- Start accepting credit cards and other electronic payments now. Merchant
Service Group has a solution for every business.
Share Our Monthly Profit and Loss Statement Template
If 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