How To Create a Profit and Loss Statement (2024)

Jan. 25, 2023 | Posted by The Alternative Board

A profit and loss statement, also often referred to as an income statement, revenue statement, P&L statement, or P&L, provides business owners and potential investors a comprehensive and easy to digest view of a company’s financial standing. Profit and loss statements are relatively simple documents, almost always presented in the form of a table, that record a company's income, costs, overhead, and net profit. In short, a P&L lets you and relevant parties know whether your business is earning a profit or losing money, and by how much. P&L statements, balance sheets, and cash flow statements are widely considered the trifecta of finance documents every business should maintain. They are usually generated monthly, quarterly, or annually.

Business owners leverage their P&L statements when determining budgets, growth strategies, need for investors, and numerous other aspects related to the health and sustainability of their companies. The concept is incredibly simple. A P&L statement allows you see how much revenue you are bringing in, how much money you are spending, and where you are spending it. It is a repository for the data needed to make informed decisions about things like profit drivers, underperforming revenue streams, high expenditures, and ultimately the health and profitability of your business.

Click here to watch our free webinar titled “Linking Your Actions to Financial Impact.”

There is some great accounting software out there, like QuickBooks, Peachtree, and others, that can generate a profit and loss statement for your business. But if you are a small business owner building a P&L on your own, even a simple Excel spreadsheet will suffice.

The following are easy steps in creating a comprehensive Profit and Loss Statement for your business:

  1. Track Operating Revenue
    Keep a thorough and continuous record of all payments received related to the sale of your goods and services, as well as any other incoming revenue.
  2. Record Cost of Sales
    Cost of sales is also commonly called the cost of goods sold. Either way, it refers to fluctuating expenses like inventory and raw materials, rather than fixed expenses like payroll or leases. Income tax may be included in cost of sales for some businesses. However, business owners of sole proprietorships, partnerships, LLCs, and S corps remit this as part of their individual income taxes.
  3. Calculate Gross Profit
    To calculate gross profit, simply subtract cost of sales from total revenue for the month, quarter, or year.
  4. Determine Overhead
    Overhead refers to fixed expenses like lease payments, payroll, advertising, equipment rentals, utilities, and insurance.
  5. Add Up Operating Income
    To ascertain your operating income, subtract your overhead from your gross profit.
  6. Consider Other Income and Expenses
    This includes income to the business not directly related to the goods and services offered. On the income side, this might include things like dividends from company investments. Expenses could relate to loan interest, finance charges, or in the case of a C corporation, tax payments from pre-tax income.
  7. Finally Arrive at Your Net Profit
    Calculate your net profit by adding or subtracting your other income and expenses from your operating income.

While profit and loss statements are relatively simple in construct and easy to produce, they provide business owners and other key stakeholders a tremendous amount of insight into the health, stability, and sustainability of a company.

How To Create a Profit and Loss Statement (2)

Read our 19 Reasons You Need a Business Owner Advisory Board

How To Create a Profit and Loss Statement (3)

How To Create a Profit and Loss Statement (2024)

FAQs

How To Create a Profit and Loss Statement? ›

Below are some formulas used in profit and loss statements: Net Sales (or Revenue) – Cost of Sales (or Cost of Goods Sold) = Gross Profit (or Gross Margin) Gross Profit – Operating Expenses = Net Operating Profit.

How to generate a profit and loss statement? ›

The following are easy steps in creating a comprehensive Profit and Loss Statement for your business:
  1. Track Operating Revenue. ...
  2. Record Cost of Sales. ...
  3. Calculate Gross Profit. ...
  4. Determine Overhead. ...
  5. Add Up Operating Income. ...
  6. Consider Other Income and Expenses. ...
  7. Finally Arrive at Your Net Profit.
Jan 25, 2023

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

Below are some formulas used in profit and loss statements: Net Sales (or Revenue) – Cost of Sales (or Cost of Goods Sold) = Gross Profit (or Gross Margin) Gross Profit – Operating Expenses = Net Operating Profit.

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

Use these seven steps to help you read and analyze a P&L report:
  1. Define the revenue. ...
  2. Understand the expenses. ...
  3. Calculate the gross margin. ...
  4. Calculate the operating income. ...
  5. Use budget vs. ...
  6. Check the year-over-year (YoY) ...
  7. Determine net profit.
Mar 10, 2023

What information is needed for a profit and loss statement? ›

A profit and loss statement includes a business's total revenue, expenses, gains, and losses, arriving at net income for a specific accounting period. Management analyzes a P&L to determine how to increase profitability by increasing revenue, lowering costs or both.

What is a P&L model? ›

A profit and loss (P&L) statement, also known as an income statement, is a financial statement that summarizes the revenues, costs, expenses, and profits/losses of a company during a specified period. These records provide information about a company's ability to generate revenues, manage costs, and make profits.

What are the three most important parts of a P&L? ›

The main categories that can be found on the P&L include: Revenue (or Sales) Cost of Goods Sold (or Cost of Sales) Selling, General & Administrative (SG&A) Expenses.

What is a P&L for dummies? ›

The P&L statement is made up of three components: revenue, expenses, and net income. Revenue is the total amount of money that a company brings in from its sales. Expenses are the costs incurred by a company to generate revenue. Net income is the difference between revenue and expenses.

What is a good P&L percentage? ›

As a rule of thumb, 5% is a low margin, 10% is a healthy margin, and 20% is a high margin. But a one-size-fits-all approach isn't the best way to set goals for your business profitability. First, some companies are inherently high-margin or low-margin ventures. For instance, grocery stores and retailers are low-margin.

What is the P&L breakdown? ›

Key Takeaways. A P&L statement shows a company's revenues and expenses related to running the business, such as rent, cost of goods sold, freight, and payroll. Each entry on a P&L statement provides insight into how much money a company made and spent.

How to create P&L? ›

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

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

Profit and Loss Formulas

The profit or gain is equal to the selling price minus the cost price. Loss is equal to the cost price minus the selling price.

How do you calculate P&L? ›

A profit and loss statement is calculated by totaling all of a business's revenue sources and subtracting from that all the business's expenses that are related to revenue.

Does Word have a profit and loss template? ›

There are many statement templates in Word that will help you create the best statement for the organization you work for. You can either make spreadsheets or make a word document statement. Enter the values, subtract expenses from the revenue that you get. This way you can make the right statement you need to be made.

How to show P&L in a chart? ›

One of the best graphs to show profit and loss is the Sankey Diagram. Let's visualize tabular data below using the Sankey Chart. To get started with the best graph to show profit and loss, follow the easy steps below: Open your Google Sheets application.

Top Articles
Latest Posts
Article information

Author: Kieth Sipes

Last Updated:

Views: 6529

Rating: 4.7 / 5 (67 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Kieth Sipes

Birthday: 2001-04-14

Address: Suite 492 62479 Champlin Loop, South Catrice, MS 57271

Phone: +9663362133320

Job: District Sales Analyst

Hobby: Digital arts, Dance, Ghost hunting, Worldbuilding, Kayaking, Table tennis, 3D printing

Introduction: My name is Kieth Sipes, I am a zany, rich, courageous, powerful, faithful, jolly, excited person who loves writing and wants to share my knowledge and understanding with you.