A Simple Profit and Loss (P&L) Statement Template for Businesses to Use

Posted at April 17, 2020 » By : » Categories : Managing A Business »
profit and loss statement template

As a business owner, you’ll be responsible for ensuring the financial health of your business. From tackling the accounting duties yourself to sharing those duties with a dedicated team. If you’re outsourcing these services then it pays to know your way around the most important documents. One of the more important documents for any type of a business is a profit and loss statement template.

Revealing your company’s revenue and expenses during a particular period, this form offers key insights into the economic health of your business.

Not sure how to create one? Today, we’re sharing a simple profit and loss statement template that’s flexible enough to work for most industry types. Read on to discover the details you need to know.

What Is a Profit and Loss Statement Template?

Also known as an income statement, a P&L statement is a critical business document that provides a “snapshot” of how your company performed over a set period of time.

In most cases, this timeframe covers one quarter of a company’s fiscal year. The two most important categories displayed on the statement include:

  • Accounts Receivable (money owed to your business)
  • Accounts Payable (money your business owes to suppliers)

Let’s take a look at how these two figures can help reveal your business’ profits and losses.

Business Profit

The formula to calculate business profit is relatively straightforward.

Profit is how much money you’ll have available once you subtract all of your accounts payable (expenses) from your incoming funds (accounts receivable).

Business Losses

A business loss occurs when you spend more money than you make. In other words, you invest in an item but the return is not great enough to generate a profit.

Two of the most common types of business losses are delinquent accounts and asset depreciation.

Why Use a P&L Statement Template?

There are multiple reasons why it’s important to generate a P&L statement every quarter.

Key executives in your business, including your C-suite, company owner and corporate officers, rely on this document to understand the direction of your company.

If your P&L statement shows consistent losses, this is a red flag. It signals that it’s time to make major changes to your business model to ensure future sustainability. At the same time, this document can also reveal areas of improvement and growth within your company.

In addition to executives, company shareholders are also privy to this data, as the financial performance of your company directly affects their own accounts.

Finally, you might also generate a P&L statement when you’re looking for people to financially support your company. From investors to loan officers, anyone who’s considering providing such support will want to make sure your business is viable and financially stable enough to pay back the money over time.

Key Elements of a P&L Statement Template

Now that we’ve covered what a P&L statement is and why you need one, let’s get into our template!

First, let’s review the key components that should be included. While each company has its own unique data, these elements are consistent throughout and help give the document its defined structure.

The main categories to include are:

  • Net sales
  • Cost of goods sold/cost of services rendered
  • Gross margin
  • Operating expenses
  • Actual net profit
  • Returns or discounts
  • Utilities
  • Rent
  • Salaries, Benefits, Wages
  • Depreciation of assets

While some of these numbers will be simple to pull from other documents, others will require calculations before moving forward. These include:

  • Gross margin
  • Net operating profit
  • Net profit before taxes
  • Actual net profit

As you’ll notice, only actual net profit is included in your P&L statement. However, to reach this number, you’ll need to calculate your net operating profit and net profit before taxes.

Here are the simple formulas to remember:

Gross Margin

To calculate gross margin, subtract your total cost of goods sold (COGS, or cost of services sold) from your net sales.

A healthy gross margin reveals that your company is retaining a significant amount of capital on each dollar of sales. You can apply these excess funds toward your debt obligations or use them to pay other costs.

Net Operating Profit

You can calculate net operating profit by subtracting your operating expenses from your gross margin. For this reason, you’ll need to calculate gross margin first in the formulaic sequence.

Net Profit Before Taxes

Calculating net profit before taxes is a twofold step.

First, take your net operating profit and add any other source of business income to that figure.

Then, subtract all of your other expenses. In addition to COGS, these additional expenses might also include other operating expenses, as well as interest expenses.

Actual Net Profit

With those more cumbersome calculations behind you, actual net profit is more straightforward.

You’ll find this number by subtracting your taxes owed from your net profit before taxes.

Understanding Accrual Accounting

The basic formula of your P&L statement is revenue minus expenses.

The most effective way to measure these incoming and outgoing funds is through accrual accounting. This is a form of basic accounting wherein you’ll post revenue as you earn it. Likewise, you’ll post expenses as your business incurs them.

By following the data in real-time this way, you can ensure that your revenue and expenses line up. You’ll also keep the data fresh and ensure that your quarterly P&L statement reflects only figures for that given timeframe.

A Simple but Effective Profit and Loss (P&L) Statement Template

Are you ready to begin preparing your P&L template? Let’s go through the steps required to set one up.

1. Add a Header to Your Profit and Loss Statement Template

The header of your P&L statement should include basic identifying information, including the name of your company and the timeline of the statement.

The latter will normally read: Profit and Loss Statement for the (Week, Month, Quarter, Year), Ended (Date Began) and (Date Ended).

2. Add Revenues

Start by listing your revenues for the timeframe. Under your bolded “Revenues” row, create a row titled “Revenue from Primary Activities”. Here, you’ll list your total revenue earned from your company’s primary activities.

Label the next row “Minus Returns and Allowances”. Here, you’ll debit your company for any returns, refunds, rebates or discounts extended to customers.

Add a bolded “Total Revenue” line to add up the sub-rows above. The section should look like this:

  • Revenues
  • Revenue Earned From Primary Activity
  • Minus Returns and Allowances
  • Total Revenue

3. List Costs

Next, you’ll list your costs. Under a bolded “Costs” header, add a row that reads “Cost of Revenue”.

This is all of the money you’ve spent on items pertaining to your business’s primary activities. For instance, if you own a bakery, these costs might include all the ingredients you bought during that quarter, as well as the paper products you purchased.

Note that if you operate a service-based company, you might not have as many tangible assets to purchase. As such, most of your costs will be included lower on the statement, in the “Operating Expenses” category.

This section will look like this:

  • Costs
  • Cost of Revenue

4. Add Gross Profit

Next, make a line for your gross profit. You’ll get this number using the calculation described above.

5. List Operating Expenses

Operating expenses are any expenses that are unrelated to the direct, primary activities of your business. Feel free to adjust these categories as required to fit your specific business needs or scenario.

This section will look similar to this:

  • Operating Expenses
  • Employee salaries and wages
  • Rent payments
  • Insurance
  • Payroll taxes
  • Utilities
  • General and administrative costs
  • Research and development costs
  • Marketing and advertising costs
  • Total Operating Expenses

6. Add Operating Income

Next, it’s time to calculate your operating income.

To do so, subtract your total operating expenses from your operating income. This will be a single line item on your P&L statement.

7. List Non-Operating or Other

Here, you’ll list any income that your business generated during the quarter that was not related to its primary activities. A few examples of such atypical income include:

  • Interest revenue
  • Gain on sale of assets
  • Gain from legal action
  • Other gains

You’ll also use this section to list any atypical losses that your company experienced. These might include:

  • Interest expense
  • Loss on sale of assets
  • Loss from legal action
  • Depreciation and amortization
  • Other losses

On the statement, you’ll list revenues first, with related expenses directly below in parentheses. That means the final list would look like:

  • Non-Operating or Other
  • Interest revenue
  • (Interest expense)
  • Gain on sale of assets
  • (Loss on sale of assets)
  • Gain from legal action
  • (Loss from legal action)
  • (Depreciation and amortization)
  • Other gains
  • (Other losses)
  • Total Non-Operating or Other

8. List Discontinued Operations

Did your company discontinue any goods or services during this timeframe? If so, list any resulting gains or losses here. The lines will look like this:

  • Discontinued Operations
  • Gain/(Loss)

9. List Extraordinary Items

Did any unique or extraordinary circumstances occur at your business during this timeframe? If so, list any resulting gains or losses here. The lines will look like this:

  • Extraordinary Items
  • Gain/(Loss)

10. Add Pre-Tax Income

Next, include a single line item for your pre-tax income. To calculate this figure, find the sum of your operating expenses and non-operating expenses (except income taxes). Then, add your interest income to that figure and subtract that total from your gross revenue.

Gross Revenue – (Operating Expenses + Non-Operating Expenses+ Interest Income)

11. List Taxes

On the next line, list your income tax expenses. The lines will look like this:

  • Taxes
  • Income tax expense

12. Add Net Income

This is the final figure and the crux of your P&L statement.

To calculate net income, you’ll subtract your income tax expenses from your pre-tax income.

This final figure reveals your company’s profits or losses for the timeframe.

A Simple Profit and Loss (P&L) Statement Template Resource for Most Businesses

Understanding how to use a profit and loss statement template is one of the first steps required to set up your new business. However, it is not the only thing needed to successfully start a new business.

As you grow your team and expand your business, you might require access to many other forms of support, from lending to insurance. That’s where we come in.

From business loans to web service solutions, we do it all. Browse our comprehensive Professional Business Services to learn more and connect today.