Posted in category BUSINESS & WORKFINANCIAL STATEMENTS
Choose the profit and loss template that suits your business needs. Exporting of Profit and Loss Statements into PDF and Excel format; Automatic Storage. As mentioned earlier, book keeping is an important function of the finance department of any organization. And the statement that gives an accurate idea of how much money has been spent and how much money has come into the firm as a result of the sales is the profit and loss statement.
A profit and loss statement is an important way of working out not only how your business has been performing in the past, but for predicting how it will perform in the future. It can be valuable in helping you create an annual income projection, and can be used to help show investors and creditors why they should get on board with your business.
This spreadsheet can record income from up to four different products or services, so can be used in a variety of areas. For restaurants, which have slightly different sales and expenses to other businesses, please see the specific restaurant profit and loss statement we have created. It is designed to work over a year, with four columns for entering data over each of the four quarters. Should you require a projection covering a longer period of time, this can always be altered to show data for whole years, rather than quarters, simply by changing the text. Please see our balance sheet spreadsheet if it is a balance sheet, rather than profit or loss statement that you require.
1
23Requirements
Microsoft Excel® 2003 or Higher (PC & Mac)
Microsoft Excel® 2003 or Higher (PC & Mac)
Installation
Not Required
Not Required
License
User License Agreement
User License Agreement
Description
There is space on the spreadsheet to enter everything you need in order to create a profit and loss statement. The only information you need to fill in is the white cells, where data from each quarter should go. The spreadsheet will automatically calculate percentages and totals based on this information.
Income
The income section allows you to keep track of any money you are bringing in through sales of your products and services. Names of your individual products and services can be entered in column B (in place of the Product/Service 1) text, simply by clicking in the cell and typing over it.
Your gross profit will be calculated automatically once you enter your sales revenue and cost of sales data.
If you receive any non-operation income, for example rental or interest, fill this out below, as this will be used to calculate your total income.
Your total income will be calculated by adding both your sales revenue and non-operation income, minus your cost of sales.
![Mac numbers profit and loss template Mac numbers profit and loss template](/uploads/1/2/5/8/125856930/640715605.jpg)
Expenses
The expenses section is split into two main parts: operating expenses and non-recurring expenses. The spreadsheet will combine all of this information and give you a total of your expenses. The operating expenses section is split into 3 subsections, making it easier to fill in. Each of these subsections has space for you to add up to 2 additional expenses in the Other expenses (specify). As with the products and services, this information can simply be typed over.
The marketing and advertising section covers things such as standard advertising and direct marketing.
The development section allows you to record details of expenses including technology licences and patents.
The administrative section is the biggest of the 3 subsections, allowing you to record everything from wages through to office supplies and building maintenance.
It is important to keep track of your non-recurring expenses separately, as when it comes to analysing the data in your profit and loss statement, if you have made a loss, or the profit margin is poor, it is easy to see how much you spent on things like computer software and hardware that is unlikely to need replacing for several years.
Taxes
The amount of tax paid varies by country, and in many cases even by region within the country. This spreadsheet therefore does not try and calculate the tax you have paid, rather there is space for you to fill out all of your tax information, covering income taxes, payroll taxes and real estate taxes. There is also space for you to specify and enter details of any other taxes that apply to you.
Net Income
There is nothing to be filled out in the net income section of the spreadsheet. It simply takes your total income, and subtracts all of your expenses, including taxes.
Share Distributions/Dividends
Depending on how your business has been set up, you may take dividends as an owner or shareholder instead of, or in addition to your wages. This information needs to be filled in so that the spreadsheet can calculate your net profit correctly.
Net Profit
As with the net income section, there is nothing here to be filled out. The spreadsheet takes your net income, minus any share distributions and dividends to calculate your net profit, both in terms of actual numbers and as a percentage of your sales. If you have filled in information for more than one quarter, this will be added together in order to create a total for the year so far (Year to Date). These details are useful for creating a financial plan projection.
Posted in category BUSINESS & WORKFINANCIAL 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.
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+1
Requirements
Microsoft Excel® 2003 or Higher (PC & Mac)
Microsoft Excel® 2003 or Higher (PC & Mac)
Installation
Not Required
Not Required
License
User License Agreement
User License Agreement
Restaurant Profit and Loss Statement Pro
Professional 1.0.2Purchase Now
Requirements
Microsoft Excel® 2003 or Higher (PC & Mac)
Microsoft Excel® 2003 or Higher (PC & Mac)
Installation
Not Required
Not Required
License
Commercial Use(Resale and distribution not permitted)
View License Agreement
Commercial Use(Resale and distribution not permitted)
View License Agreement
Support
Visit Support Page
Visit Support Page
- 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.