Profit and Loss Statement Template - Free Download (2024)

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

Download templateLearn more - Business account

Profit and Loss Statement Template - Free Download (1)

Profit and Loss Statement Template - Free Download (2)

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 simple proft and loss statement for small business

Download a multi-step profit and loss statement

Profit and Loss Statement Template - Free Download (3)

Profit and Loss Statement Template - Free Download (4)

Download your profit and loss statement template.

To receive the download link on your email, please enter your email address. When you enter your email, you’ll also be signed up to receive the Wise Business newsletter, our free monthly email packed with handy guides and tips on how to grow your business internationally. You can unsubscribe at any time.

By subscribing, you agree to receive marketing communications from Wise. You can unsubscribe at any time using the link in the footer of our emails. See our privacy policy

The cheap & easy way to manage your international business.

Wise for 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 40+ different currencies, and switch between them using the mid-market exchange rate.

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 Template - Free Download (5)

Profit and Loss Statement Template - Free Download (6)

Profit and Loss Statement Template - Free Download (7)

Profit and loss statement format.

Profit and Loss Statement Template - Free Download (8)
Profit and Loss Statement Template - Free Download (9)
Revenue
Revenue, also called sales or business income, includes money received for the sale of the company’s goods or services.
Profit and Loss Statement Template - Free Download (10)
Profit and Loss Statement Template - Free Download (11)
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 and Loss Statement Template - Free Download (12)
Profit and Loss Statement Template - Free Download (13)
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.
Profit and Loss Statement Template - Free Download (14)
Profit and Loss Statement Template - Free Download (15)
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.

Profit and Loss Statement Template - Free Download (16)

Profit and Loss Statement Template - Free Download (17)

Profit and Loss Statement Template - Free Download (18)

How to create the profit and loss statement template?

Profit and Loss Statement Template - Free Download (19)
Profit and Loss Statement Template - Free Download (20)
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.
Profit and Loss Statement Template - Free Download (21)
Profit and Loss Statement Template - Free Download (22)
Add revenue and expenses.
Input your business income and expenditure numbers.
Profit and Loss Statement Template - Free Download (23)
Profit and Loss Statement Template - Free Download (24)
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.
Profit and Loss Statement Template - Free Download (25)
Profit and Loss Statement Template - Free Download (26)
Double check the formulas.
Confirm that the formulas are working as intended.

Profit and Loss Statement Template - Free Download (27)

Download your multi step P&L statement template.

To receive the download link on your email, please enter your email address. When you enter your email, you’ll also be signed up to receive the Wise Business newsletter, our free monthly email packed with handy guides and tips on how to grow your business internationally. You can unsubscribe at any time.

By subscribing, you agree to receive marketing communications from Wise. You can unsubscribe at any time using the link in the footer of our emails. See our privacy policy

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

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.

More free online templates for businesses.

Profit and Loss Statement Template - Free Download (28)

More free online templates for businesses.

Invoice Template

Freelance Contract Template

Income Statement Template

Inventory Management Template

Balance Sheet Template

Independent Contractor Agreement Template

Cash Flow Statement Template

Receipt templates

Purchase order template

Business plan template

Business proposal template

Profit and Loss Statement Template - Free Download (2024)

FAQs

Can I make my own profit and loss statement? ›

How To Create a Profit and Loss Statement
  • Choose a reporting period. ...
  • Gather financial statements and information. ...
  • Add up revenue. ...
  • List your COGS. ...
  • Record your expenses. ...
  • Figure your EBITDA. ...
  • Calculate interest, taxes, depreciation, and amortization. ...
  • Determine net income.
Apr 25, 2024

Is there a profit and loss template in Excel? ›

Yes, there is a profit and loss template in Excel that you can use to create your own statement. The template includes formulas to calculate revenue, expenses, and net income. You can enter your own data to get started.

What is the basic formula for a profit and loss statement? ›

Net Sales (or Revenue) – Cost of Sales (or Cost of Goods Sold) = Gross Profit (or Gross Margin) Gross Profit – Operating Expenses = Net Operating Profit. Net Operating Profit + Other Income – Other Expenses = Net Profit Before Taxes. Net Profit Before Taxes – Income Taxes = Net Profit or Loss.

What is a very simple profit and loss statement? ›

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.

Does the IRS require a profit and loss statement? ›

Profit or loss from business (sole proprietorship): Schedule C (Form 1040) The IRS requires sole proprietors to use Profit or Loss From Business (Sole Proprietorship) (Schedule C (Form 1040)), to report either income or loss from their businesses.

What is a good profit and loss statement? ›

It begins with an entry for revenue, known as the top line, and subtracts the costs of doing business, including the cost of goods sold, operating expenses, tax expenses, and interest expenses. The difference, known as the bottom line, is net income, also referred to as profit or earnings.

How do you understand profit and loss for dummies? ›

Profit (or loss) is the difference between your total revenue and total expenses for a specific time period. If your revenue is greater than your expenses, you have a profit. If your expenses are greater than your revenue, you have a loss.

How does a P&L statement look like? ›

A profit and loss statement (P&L) statement includes a business's revenue, cost of goods and services sold, operating expenses, interest, taxes, net income and any other gains and losses. Revenue is known as the top line, and net income is called the bottom line.

What is a P&L statement template? ›

A profit and loss statement, also known as an income statement, is a financial report summary that shows a company's expenses and revenue for a specific period of time. The information in this summary helps determine whether the company or organization is generating profit, losing money, or breaking even.

Who prepares a P&L statement? ›

You can ask your accountant to prepare a profit and loss statement for your company or you can build one yourself using the steps below.

How do I create a profit and loss statement? ›

How to Write a Profit and Loss Statement
  1. Step 1 – Track Your Revenue. ...
  2. Step 2 – Determine the Cost of Sales. ...
  3. Step 3 – Figure Out Your Gross Profit. ...
  4. Step 4 – Add Up Your Overhead. ...
  5. Step 5 – Calculate Your Operating Income. ...
  6. Step 6 – Adjust for Other Income and/or Expenses. ...
  7. Step 7 – Net Profit: The Bottom Line.

What is the best chart to show profit and loss in Excel? ›

A Stacked Column Chart is typically the best Excel chart to display profit and loss. It allows you to visualize revenue and expenses, showing the net profit or loss as the column's height.

Where can I get a profit and loss statement? ›

The P&L statement can be found on a company's website and is one of the financial statements that public companies are required to issue by law to shareholders. 1. The P&Ls for different periods should be looked at in conjunction with the cash flow statement for a more accurate picture of a company's financial health.

How do I create a profit and loss statement in Google Sheets? ›

How Do I Create a P&L in Google Sheets?
  1. Open Google Sheets.
  2. Setup P&L layout.
  3. Enter data.
  4. Calculate subtotal.
  5. Format your P&L statement.
  6. Review and update.
  7. Add additional information (optional)
  8. Save and share.

How do you write a profit and loss account statement? ›

How to create a profit and loss statement
  1. Choose how often you intend to create a P&L statement. Deciding on how often you create this report is the first step. ...
  2. Write the revenue. ...
  3. Cost of the goods sold. ...
  4. Get the gross profit. ...
  5. Operational costs and EBITDA. ...
  6. Net income. ...
  7. P&L at a regular interval. ...
  8. Pro Forma P&L.
Jul 2, 2024

How do I create a profit and loss account in Word? ›

Creating a Profit and Loss Statement:
  1. Step 1: Choose a Template. The first thing for you to do would be to choose the right template to create your statement. ...
  2. Step 2: Create a Basic Structure. ...
  3. Step 3: Mention Your Revenue Sources. ...
  4. Step 4: Calculate Net Income and Expenses. ...
  5. Step 5: Calculate Profit and Loss.

References

Top Articles
Latest Posts
Recommended Articles
Article information

Author: Jamar Nader

Last Updated:

Views: 5574

Rating: 4.4 / 5 (55 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Jamar Nader

Birthday: 1995-02-28

Address: Apt. 536 6162 Reichel Greens, Port Zackaryside, CT 22682-9804

Phone: +9958384818317

Job: IT Representative

Hobby: Scrapbooking, Hiking, Hunting, Kite flying, Blacksmithing, Video gaming, Foraging

Introduction: My name is Jamar Nader, I am a fine, shiny, colorful, bright, nice, perfect, curious person who loves writing and wants to share my knowledge and understanding with you.