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? ›

How do you calculate P&L? Your P&L statement will draw on the following data points and calculations: 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 create a profit and loss statement? ›

How To Create a Profit and Loss Statement
  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 formula for profit and loss statement? ›

How do you calculate P&L? Your P&L statement will draw on the following data points and calculations: Net Sales (or revenue) – Cost of Sales (or Cost of Goods Sold) = Gross Profit (or Gross Margin) Gross Profit – Operating Expenses = Net Operating Profit.

What is the easiest way to calculate profit and loss? ›

Every business needs to know how to figure out its profit and loss. Business owners can figure out if they are making a profit or a loss by using the formula: total revenue minus total costs = profit or loss. To make sure the business is profitable, it is important to keep track of all expenses and income.

What is an example of a profit and loss? ›

If a shopkeeper brings a cloth for Rs.100 and sells it for Rs.120, he has made a profit of Rs.20/-. If a salesperson has bought a textile material for Rs.300 and has to sell it for Rs.250/-, he has gone through a loss of Rs.50/-.

What is a profit and loss statement for dummies? ›

It's a snapshot of your whole business as it stands at a specific point in time. A profit and loss statement describes how profitable your business is. It shows you how much money flowed into and out of your business over a certain period of time.

How to calculate profit example? ›

Example of profit calculation

Total expenses: $1,000 of direct costs + $500 indirect costs = $1,500 By subtracting $1,500 of total expenses from their total revenue of $10,000, Francis can calculate that their profit is equal to $8,500.

What are the red flags on a P&L statement? ›

If you notice a steady decline in profits or shrinking margins, this is a red flag, and it's one that you want to catch as early as possible.

What should not be included in the statement of profit and loss? ›

Preparation of the profit and loss account

This means income such as grants, cash injected by the owners and bank loans received are generally not shown here, and any purchases of significant equipment, loan repayments, drawings, HM Revenue & Customs payments etc won't be shown either.

How to write a profit and loss statement template? ›

How To Create a Profit & Loss Statement
  1. Step 1: Choose a timeframe. ...
  2. Step 2: Gather your financial information. ...
  3. Step 3: Use a P&L Statement template. ...
  4. Step 4: List your revenues. ...
  5. Step 5: List your cost of goods sold. ...
  6. Step 6: List your expenses. ...
  7. Step 7: List interest, taxes, depreciation, and amortization.
Feb 2, 2022

What does a P&L sheet look like? ›

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.

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.

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.

References

Top Articles
Latest Posts
Article information

Author: Lakeisha Bayer VM

Last Updated:

Views: 6403

Rating: 4.9 / 5 (69 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Lakeisha Bayer VM

Birthday: 1997-10-17

Address: Suite 835 34136 Adrian Mountains, Floydton, UT 81036

Phone: +3571527672278

Job: Manufacturing Agent

Hobby: Skimboarding, Photography, Roller skating, Knife making, Paintball, Embroidery, Gunsmithing

Introduction: My name is Lakeisha Bayer VM, I am a brainy, kind, enchanting, healthy, lovely, clean, witty person who loves writing and wants to share my knowledge and understanding with you.