Use this template to build your own profit and loss account.
This article, originally produced for SmallBusiness.co.uk on 05/08/2005, was updated on 17/06/2015 to include further reading advice and XLS sample templates for downloading.
A profit and loss account template is important whether you are running a business or in the process of setting one up. If the latter, as a part of P&L forecasting, it forms a required part of a business plan (see our article What should be in your business plan).
A profit and loss sheet shows business performance over a specific period of time,recording incomings and outgoings and sales income generated, including estimates of work in progress but not yet invoiced.
As part of your annual accounting
A P&L statement is usually prepared annually and shows revenues and costs and how much profit has been made over the period. It should form part of your overall bookkeeping set of documents - along with a Balance Sheet and Cash Flow Forecast.
For limited companies, and sole traders earning over £50,000 a year, a Profit and Loss Statement is required for HMRC.
As part of a business plan
The financial analysis section within a business plan should be about three pages - with data in an optional appendix. The first parts should consist of:
Summary of forecasts.
Monthly profit and loss forecast for two years.
Profit forecast for further three years.
Monthly cash flow forecast for two years.
Cash flow forecast for further three years (optional).
Use the templates below to build your own profit and loss account.
The templates are done to be in line with HMRC reporting requirements for self-employed professionals. The numbers are for illustration purposes only and completely random.
PDF template examples
- Click here to download the profit and loss pdf template for companies with under £77,000 turnover. Click here to download the profit and loss pdf template for companies with over £77,000 turnover.
XLS template examples
- Click here to download the profit and loss XLS template for companies with under £77,000 turnover. Click here to download the profit and loss XLS template for companies with over £77,000 turnover.
All income from sales should be added for the period the P&L is being prepared for whether or not your have received payment. Sales with no received payment should be added to the debtors account in your balance sheet.
Cost of sales
Includes any direct costs involved in making and selling the product purchased, including the wages of those involved in making the product and purchases made from suppliers for goods or raw materials used in the accounting period.
Includes general expenses and all other costs you have been invoiced for during the period, such as: rent, rates, professional fees, vehicle costs, national insurance and pensions, utlilities etc. Items invoiced for but not yet paid are added to your creditors account on your balance sheet.
It is a judgement call on how long a period fixed assets should be depreciated over but be consistent in your application of it.
Further reading on accounting and managing cash flow
- Accounting tips for small businesses
- Managing your books and keeping control of your accounts as a small company
- Late payment and how to ease the cash flow pressure
See also: Balance sheet template