How To Prepare A Profit & Loss Statement (Free Template) (2024)

Very few small business owners have an interest in accounting.

But as everyone finds out, understanding the basics of accounting can be the difference between the success and failure of your company.

There are three particular financial statements that all small business owners should understand: balance sheets, cash flow statements, andprofit and loss statements (P&L).You may want to check out ourSmall Business Financing Guidetoo.

They all seem rather annoying and complex on the surface, but if you break them down one at a time, they’re pretty simple.

This post focuses on P&L statements.

By the end of this post, you’ll know 99% of all you’ll ever need to know about P&L statements. And you can.

How To Prepare A Profit & Loss Statement (Free Template) (1)

What is a Profit and Loss Statement (P&L)?

A P&L statement, also referred to as an income statement, measures your business revenue (income or sales) and expenses during agiven time period.

Put another way, a profit and loss statement tells you whether or not your business is making money. Small business owners can use a P&L statement to assess business performance, identifying room for improvement and new strategies for growth.

It’s the “best tool for knowing if your business is profitable”, according to the U.S Small Business Administration.

Typically, a P&L statement is assessed over the following common time periods:

  • Monthly
  • Quarterly
  • Annually

Some P&L statements are very simple to create and understand, as they are just a few lines.

Others can span pages.

It depends on the size of your business, and how complex it is.

A small business that only has a few sources of income or expenses will have a short P&L, while a large business with multiple income streams will have a longer one.

Finally,what does a “statement” look like?A P&L statement is essentially just a table, usually created in any spreadsheet tool (Excel, Google Sheets, etc.).

What Is The Purpose of a Profit and Loss Statement?

How To Prepare A Profit & Loss Statement (Free Template) (2)

Ultimately, the purpose of a P&L statement is to calculate yournet operating profit or loss.

If you make a profit, great! You can re-invest it, save it, or make a variety of other decisions. If you end up with a loss, it’s a clear signal that your business is on an unsustainable trajectory, and you’ll need to find a way to turn things around.

But on top of that, a P&L can be used to help you make informed decisions like:

  • Can you afford to hire any new employees?
  • Can you afford to move to a bigger office?
  • How will you plan your taxes?
  • Is your current growth strategy effective?

The P&L statement can also have additional uses depending on who’s looking at it.

Investors and Lenders

For example, investors will look at your P&L statements from multiple time periods to see how profitable your business is over time. They can also glean information about the efficiency of your operations, your competitiveness, and the soundness of your business model.

Lenders will look at P&L statements to determine whether or not your business is likely to make a profit in the future big enough to pay back loans and interest.

One last important note about P&L statements is that theydo not represent your business’ financial health by themselves.They may reflect it in some cases, but they can be skewed (or misleading) by billing practices or fraudulent reporting of transactions (whether intentional or not).

That’s why it’s important to understand all three major financial statements that I mentioned at the beginning.

Understanding a Profit and Loss Statement

If it’s the first time you’re digging into profit and loss statements, parsing through these kinds of financial records can be daunting. There might be terms you’ve never seen before, so it’s useful to gain an understanding of what you’ll find in a profit and loss statement.

Fortunately, there are common line items that are generally included in most P&L statements. Understanding these concepts will help you put together, and analyze, profit and loss statements.

Let’s go through these terms one at a time.

1. Revenue

All P&L statements start with a summary of revenue from sales that occurred during the given time period.

Usually, this is detailed in a separate table and the sum total is imported into the P&L statement.

2. Expenditure

There are different types of expenditure. Check ourtableas an example. Usually, more detailed P&L statements will drill down, offering detail into the type of expenditure.

There are many expenses that may be included, but it will vary widely for each individual business.

3. Direct Costs/Costs of Goods Sold

Direct costs (also referred to as the cost of goods sold) refers to costs that can be exclusively attributed to the production or sale of a product or service.

This includes the costs of materials used in manufacturing a product and any labor directly involved in that process. If you don’t manufacture the product that you sell, your direct costs would include the cost of purchasing it from your supplier.

Direct costs exclude all other labor and indirect expenses, such as marketing, accounting, internet service, training, rent, and insurance.

4. Gross Profit (and Gross Margin)

You can subtract direct costs from revenue to determine your gross profit.

Revenue — Direct Costs = Gross Profit

Thegross marginis usually depicted as a percentage.

Use this formula to determine your gross margin percentage (also referred toas “gross profit margin”):

Gross Margin / Revenue = Gross Margin %Example: You purchased 100 bicycles from a supplier at a cost of $100 each: you incurred direct costs of $10,000. You sold them for $395 per piece, yielding a revenue of $39,500. Your gross profit would be $29,500. Your gross margin percentage would be 75%.

The gross margin is a key indicator of the financial health of your business and the soundness of your business model. The higher the percentage, the better.

Potential investors will quickly hone in on this number. This number also conveys information about how competitive your business is or can be in the near future.

5. Operating Expenses (OPEX)

Operating expenses (OPEX) are the costs of normal business operations

Operating expenses may include:

  • Payroll
  • Insurance
  • Utilities such as phone and internet service
  • Administrative costs
  • Advertising (and other marketing)
  • Rent
  • Office supplies

6. Depreciation

Depreciation is the reduction in the value of any of your business assets, like machinery or equipment.

Note that depreciation most commonly is an indirect expense, but depending upon the context,it may be a direct cost.

7. EBIT (Earnings Before Interest and Tax)

EBIT stands for earnings before interest and tax. It’s usually one of the last numbers on your statement. There are different EBIT formulas: a simple calculation is to subtract operating expenses and cost of goods (COG) from revenue.

8. EBT (Earnings Before Tax)

Earnings before Tax can tell you a lot about your business performance. Subtract COGs, OPEX, and depreciation from your total revenue to find EBT.

9. Net Income: Profit or Loss

Finally, you calculate the net income, by subtracting yourindirect expensesfromyour gross profit.

This is your net profit — or loss — and the famed “bottom line” of the P&L statement.

You use this to determine if your business is profitable or not, and by how much.

This shows your business’s profit or loss. If you show a loss, it means you spent more than you earned. If you show a profit, it means you made more than you spent.

How to Analyze a Profit and Loss Statement

It’s hard not to be intimidated by your P&L statement. Even if you know the terms, how do you pull together the data to make any significant statements on business progress?

But it’s critical to analyze your profit and loss statements.

A detailed analysis of your profit and loss statement can reveal insights into your business performance, flagging strengths, and weaknesses. Plus, you can also use your profit and loss statement to compare your company against similar businesses and create industry benchmarks.

In fact, the US Small Business Administration suggests printing your P&L statement regularly to monitor business performance.

Performing a P&L Analysis

We’ve gathered some of the most effective ways to perform a P&L statement analysis:

  • Year-on-year comparisons. Take a close look at drastic changes, e.g., drop in sales
  • Studying trends. What’s the trajectory of your business? Are your strategies paying off? Comparing annual performance will help you determine whether revenue is growing faster than expenses, for instance.
  • Projections. Consider using your P&L statement to help project future cash flows.
  • Evaluating margins, e.g., gross profit margin
  • Sales: study your standout months. Are there any particular drivers of success? For instance, did you double down on marketing, causing a bump in sales?
  • Expenses. Are there ways to reduce expenses? What are the biggest expenses? Does this make sense for your business?
  • Income. Are your income sources sustainable?

Examining these numbers can give you a good idea about the financial health of your business.

How Do You Prepare a Profit and Loss Statement?

By now, you might be ready to tackle your very own profit and loss statement. If you don’t feel ready to tackle it yourself, we highly recommend considering online accounting solutions likeQuickbooksorSage Business Cloud Accounting. Both can simplify the process and guide you through the steps we discuss below.

To make your own profit and loss statement, you’ll focus on two accounts:income and expenditure. We’ve collected commonbusiness incomeandexpenditure, provided by the Internal Revenue Service.

Here are some examples of the types of income sources and expenditures that go into these categories:

IncomeExpenditure
SalesCost of Goods Sold
RevenueSalaries
Interest incomeInsurance
Rental incomeTaxes
Fees for servicesRent
Interest on business loans

To present the information, you have two main options.

First, you can pull together your own statement and create the document using a spreadsheet. Tools like Excel and Google Sheets have templates. We’ve created a simpleprofit and loss statement templatefor you to use here.

Either way, you’ll need the same data. And the best thing is, you should already have all the data you need.

Let’s have a look at the basic tips to build a profit and loss statement:

  1. Choose a time frame. Will you be assessing business progress monthly, quarterly, or annually? Keep in mind that short time frames probably won’t yield any meaningful data, e.g., anything less than a month. On the other hand, you don’t want to overwhelm yourself by digging into years and years worth of data.
  2. List your business revenue for the time period, breaking the totals down by month. Include your income sources, by month.
  3. Calculate your expenses. Separate direct costs like COGS from OPEX.
  4. Determine your gross profit by subtracting your direct costs from your revenue.
  5. Figure out if you’re making money. Subtract your total expenses from your gross profit. If you get a positive number, your business is on the right track. If not, you’ve identified the biggest problems holding your small business back. Use this insight to set your business on the path to profitability.

Downloadable Profit and Loss Template

Here’s a working profit and loss template complete with gross margin calculation built-in.Simply add your own numbers to the spreadsheet.

Profit and Loss Statement Examples

That’s really all there is to it, to wrap up let’s take a look at some basic examples.

The Simplest P&L Example

If you run a solo business with little diversity in revenue or expenses, your P&L statement might be as simple as this:

Business Name P&L Statement – 2020
Revenue$1,000,000
Direct costs$600,000
Gross profit$400,000
Indirect expenses$300,000
Net profit$100,000

Thecost of goods soldwas subtracted from therevenueto give a gross profit of $400,000.

Theindirect expenseswere then subtracted from thegross profitto reveal a net income (or profit) of $100,000.

A More Typical Real Life P&L Example

Most small businesses are a bit more complex than that.

Here’s what a more realistic P&L statement might look like:

How To Prepare A Profit & Loss Statement (Free Template) (4)

I’ve used the same set of hypothetical data from the simple example to make it easy to see how they line up.

Those five main totals are all bolded, but theincome,cost of goods sold, andexpensesare all broken down into multiple line items.

There’s one final piece of terminology I’d like to point out in the example. Note that under income, there’s a line item labeled“Less: Returns.”

You will likely see “less” appear if you look up any other examples.

You can prepend “less” to items that are subtracted from the initial value in a section for clarity’s sake.

Frequently Asked Questions About P&L Statements

How To Prepare A Profit & Loss Statement (Free Template) (5)

Believe it or not, that’s really all there is to P&L statements.

But even though you understand the core concepts, you may have a few specific questions still. I have answered the most common questions about P&L statements below.

Where are salaries and wages included?

Salaries and wages are the most confusing part of P&L statements. Salaries of people in administrative roles are not directly related to revenue, so they are included as fixed expenses.

It can get tricky when it comes to manufacturing roles. The labor used to directly make a product is included in the cost of goods sold section once the product is sold.

Are unsold inventory labor costs included?

The labor that went into the unsold inventory is not included in the cost of goods sold section. And yet, they are not a fixed expense either, so the labor that went into unsold goods is not included at all in your current P&L statement.

Instead, you’ll include it under the cost of goods sold when that inventory is actually sold, and before then, it’ll be tracked on your balance sheet.

What is the difference between a profit and loss vs income statement?

There is no difference between these terms. Other synonyms for profit and loss statements include: earning statement, revenue statement, operating statement, and statement of financial performance. They all refer to the exact same report we’ve looked at in this article.

What is the difference between profit and loss and a balance sheet?

A profit and loss statement looks at whether or not your business is fundamentally profitable.

On the other hand, a balance sheet is another important financial report to report a business’ assets, liabilities, and shareholders’ equity. Combining the balance sheet with the P&L statement gives you a good overall snapshot of a company’s financial health.

What is a year-to-date profit and loss statement?

Since all P&L statements have to be over a certain time period, a “year-to-date” profit and loss statement covers the current year, up until the time of the statement. Year-to-date P&Ls are often required when filing taxes.

What’s the best time period to create P&L statements over?

Different people (you, investors, lenders) have different uses for your P&L statement.

As a business owner, you don’t necessarily need to create a P&L statement every month (but you can). What’s most important is that you’re checking if you’re on target to reach profitability at least once a month.

What is break-even analysis and how is it used?

Break-even analysiscan be performed by using profit and loss statements by working backward to determine how much you need to sell to be profitable in a given period. Since your indirect expenses are fixed, and the cost of goods sold is variable based on how much you sell.

Should you include interest paid on an annual basis in a monthly P&L?

Yes. Many loans have interest rates on an annual basis, so you’ll break down the amount of interest paid to add it to a monthly P&L.

For example, if you have a $100,000 loan at an annual interest rate of 12%, you’ll pay $12,000 of interest over the course of the year. Therefore, you’ll add $1,000 to a monthly P&L.

Where do you include large purchases or inventory on your P&L?

Inventory is not included in your P&L. Instead, it is tracked on your balance sheet as an asset.

What may be included in your P&L is any depreciation on inventory or large purchases, which, depending upon the context, may be included in your indirect expenses section or your direct costs section.

Summary

If all that makes sense, you know just about everything you’ll ever need to know about profit and loss statements for small businesses.

If you’d like to take your accounting basics further, learn howbalance sheetsandcash flow statementswork.

How To Prepare A Profit & Loss Statement (Free Template) (2024)

FAQs

How To Prepare A Profit & Loss Statement (Free Template)? ›

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.

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

To create a basic P&L manually, take the following steps:
  1. Gather necessary information about revenue and expenses (as noted above).
  2. List your sales. ...
  3. List your COGS.
  4. Subtract COGS (Step 3) from gross revenue (Step 2). ...
  5. List your expenses. ...
  6. Subtract the expenses (Step 5) from your gross profit (Step 4).
Oct 4, 2019

Can I make my own profit and loss statement? ›

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

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.

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.

What is the standard profit and loss statement? ›

The Profit and Loss Statement (P&L) is a financial statement that starts with revenue and deducts costs and expenses to arrive at net income, the profitability of a company, in a specified period.

What does a simple P&L look like? ›

A single-step profit and loss statement is a bit more straightforward. It adds up your total revenue, then subtracts your total expenses, and gives you your net income. Simple.

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.

What is a profit and loss statement for dummies? ›

A profit and loss statement (P&L), also called an income statement, is a financial report that shows your revenue, expenses, and profit for a specific time period. Your P&L can help you track your business performance over time and make informed decisions about where to allocate your resources.

Does the IRS require a profit and loss statement? ›

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. How do you know if the activity in which you're engaged qualifies as a business?

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 two things can be found on a profit and loss statement? ›

A company's statement of profit and loss is portrayed over a period of time, typically a month, quarter, or fiscal year. The main categories that can be found on the P&L include: Revenue (or Sales) Cost of Goods Sold (or Cost of Sales)

What is a profit and loss statement for self employed? ›

A simple P&L statement for a small business individual includes the following: Income: This includes all the revenue generated from the business or freelance work. Expenses: This includes all the costs incurred to generate the income, such as materials, utilities, and any other business-related expenses.

Is an income statement the same as a profit and loss? ›

P&L is short for profit and loss statement. A business profit and loss statement shows you how much money your business earned and lost within a period of time. There is no difference between income statement and profit and loss.

Where can I get a profit and loss statement? ›

The P&L is found in the annual financial reports that all publicly traded companies are required by law to issue and distribute to shareholders. 1 Annual financial reports include a company's P&L statement, balance sheet, and a statement of cash flow. Financial statements are found on a company's website.

Where can I get a profit and loss form? ›

Copies are available in the office of any District Director of Internal Revenue.

Top Articles
Latest Posts
Article information

Author: Duane Harber

Last Updated:

Views: 5774

Rating: 4 / 5 (51 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Duane Harber

Birthday: 1999-10-17

Address: Apt. 404 9899 Magnolia Roads, Port Royceville, ID 78186

Phone: +186911129794335

Job: Human Hospitality Planner

Hobby: Listening to music, Orienteering, Knapping, Dance, Mountain biking, Fishing, Pottery

Introduction: My name is Duane Harber, I am a modern, clever, handsome, fair, agreeable, inexpensive, beautiful person who loves writing and wants to share my knowledge and understanding with you.