Profit and loss statement template.

Use our free profit and loss statement template to review your business performance, and check out the Transferwise multi-currency business account as a smart way to cut your bank charges.

profit-loss-statement-template

What is a profit and loss statement?

A profit and loss statement (P&L) sets out your company income versus expenses, to help calculate profit. You’ll sometimes see profit and loss statements called an income statement, statement of operations, or statement of earnings.

P&L statements can be created to analyze and compare business performance over a month, a quarter or a year, and are an effective tool to review cash flow and predict future business performance.

Smart business owners use profit and loss statements alongside other key financial documents, like the balance sheet and cash flow statement, to check up on and improve the health of their businesses.

Download a profit and loss statement template.

Simple profit and loss statement

Simple profit and loss statement

Download your free simple profit and loss statement in Excel. Customize and plug in your business numbers, to make analyzing your company performance easy.

Profit and loss statement template Excel download →

Profit and loss statement for small business

Profit and loss statement for small business

This single step profit and loss statement is perfect for small businesses and sole proprietorships. Get your free template here, add your branding and create a tailor-made financial statement for your business.

Single-step profit and loss statement template download →

See an example of an income statement

Multi-step income statement

Multi-step income statement

Use the free template to create your multiple step profit and loss statement in Excel, and get an in depth report of your net business profit or loss.

Multi-step income statement template download →

Open a Wise business account online and just in a few minutes.

Wise Business is the smart and speedy way to pay and be paid in multiple currencies.

Are you invoicing clients overseas, or working with suppliers based abroad, but waiting around for slow international transfers to finally reach your account? Wise can cut down on the cost and time of international transfers into your multi-currency account.

You’ll get bank details for the US, UK, euro area, Poland, Australia and New Zealand, to receive fee-free payments from these regions. Hold 50+ different currencies, and switch between them using the mid-market exchange rate — and up to 19x cheaper than an alternative like PayPal.

Integrate your Wise business account with Xero online accounting, and make it easier than ever to watch your company grow.

Try Wise Business

Profit and loss statement format.

Revenue
Revenue, also called sales or business income, includes money received for the sale of the company’s goods or services.
Expenses
Expenses, are costs the company incurs related to sales. These might include the cost of goods for resale, property rental, and the price of consumables like printer ink and stamps.
Profit/loss
You can calculate your business profit or loss by subtracting the expenses incurred from your revenue. If the number is positive, you have a net profit. If it’s negative, your business has made a loss in that period.
Keep multiple currencies in one business account
With a Wise Business account you can keep multiple currencies in one account. Save time, cut costs, and connect with more customers all over the world, with Wise.

Profit and loss statement formula.

The single step profit and loss statement formula is:
Total Revenues - Total Expenses = Net Income

A P&L statement compares company revenue against expenses to determine the net income of the business.

Subtract operating expenses from business income to see your net profit or loss. If revenues are higher than total business expenses, you’re making a profit. If your business expenses over the period being examined were higher than your income, the company has made a loss.

This calculation is useful for business owners and investors as it shows the net profitability of a business, and how efficient a company is at generating net income.

Profit and loss statements give a snapshot view of business performance - create a monthly, quarterly or annual statement, which you can analyze and compare to performance over the same period in previous years.

How to create the profit and loss statement template?

Choose the time period.
Choose the time period used to generate the income statement - this could be a month, a quarter or a year, for example.
Add revenue and expenses.
Input your business income and expenditure numbers.
Add or remove line items as necessary.
Make sure the P&L statement fits your business by adding and removing line items as you go. Add a line where needed, or you can also easily delete lines from the template as required.
Double check the formulas.
Confirm that the formulas are working as intended.

FAQ

Both the profit and loss statement and balance sheet are important financial statements - but each has a different function for business owners and investors.

A balance sheet gives a point in time view of a company's assets and liabilities, while the P&L statement details income and expenses over an extended period of time (usually one year). A balance sheet helps determine a company's current financial situation and make important financial decisions. The profit loss statement can be run at any time of the fiscal year to determine profitability and compare one period of time to another to show growth.

A profit and lossstatement shows a company’s income versus expenses over a given period. It shows whether the company is making profit or is in loss, by subtracting total expenses from total income.

When you build your profit and loss statement you’ll need to customize the line items to suit your business. Here are some of the expenses to think about:

  • Cost of Goods Sold (COGS) - the price you pay your suppliers for raw materials, and direct labour, for example.

  • Selling, General and Administrative Expenses (SG&A) - this covers a wide range of items including business property rental, transportation, employee salaries, business rates and more.

  • Depreciation and amortization - known as non-cash expenses, depreciation reflects the cost of capital assets spread over time, while amortization is about the loss of value of intangible assets, like a patent for example.

  • Research & Development (R&D)- depending on your business type, you may need to add in any extra costs incurred for researching and developing new products you plan to launch.

A multiple step profit and loss statement is a more complex P&L statement which splits out different types of revenue and expense, allowing detailed analysis of the business. Operating revenues and expenses are segregated from nonoperating income and costs, for example. This document will also generate a gross profit figure for your business.

A contribution margin profit and loss statement is used to generate contribution margin, as well as overall net profit.

The company revenue is added to the statement, with fixed and variable expenses being split out, which allows this income statement format to show contribution margin alongside net business income.

Watch your business grow with Wise.

Pay international invoices, and receive payments from clients based abroad - making it easy, and cheap, to connect with more customers.

Get your Wise Business account