Business Templates
Profit and loss statement template

What is a profit and loss statement template?

A profit and loss statement (P&L) template can be used to create a record that measures and shows all the revenue and expenses a company incurred during a specific period of time.

Do small businesses need a profit and loss statement template?

Yes, a profit/loss statement, otherwise known as an income statement, is one of three main financial statements used to determine a business’ financial health. Our profit and loss Excel template makes it easy to create a P&L with your own company’s financial information.

The P&L Excel template contains sections for revenue and expenses, which include net sales, gross profit, cost of goods sold, selling expenses, general and administrative expenses, and net profit. This statement should be prepared and reviewed monthly to evaluate performance and make adjustments as needed to stay on track with financial budgets and goals.

Why should businesses use a profit and loss statement template?

A profit and loss statement is used both internally and externally for different purposes. Internally, it can be viewed at the corporate level, department level, product level or even customer level. By evaluating the P&L statement at each level, the company can gain insightful understanding of how profitable a product, customer relationship or department is and adjust as needed.

This document is considered one of the most important financial statements due to the amount of information that can be pulled out of it. Externally, a P&L is used by investors, creditors, and stakeholders to understand how the company is making money and how they are allocating the revenue. It acts as the first impression to investors and creditors as a proof of business success or failure.

How to prepare a profit and loss statement template?

Here’s how to do a profit and loss statement in Excel:

Step 1: Download the P&L Excel template.
Step 2: Determine the reporting period (monthly, quarterly, yearly).
Step 3: Export the trial balance from your accounting system for the specified time period.
Step 4: Copy exported trial balance into the “Trial Balance” tab.
Step 5: Calculate net income.

You can find more detailed instructions on how to use our profit/loss statement template upon download. If you’re uncertain about financial reporting or have complex accounting needs, consulting with a qualified accountant or financial professional is recommended.

How often should a profit and loss statement template be prepared?

P&L statement templates are typically prepared on a monthly, quarterly, or yearly basis.

Download this template for additional instructions.


What is the purpose of a P&L statement template?

The purpose of a profit/loss statement template is to provide a standardized format for summarizing the revenues, costs, and expenses incurred by a business during a given period. The P&L statement template aids in assessing financial performance and supporting decision making.

What information does a profit and loss statement template include?

P&L statement templates can vary depending on industry, company size, and accounting practices. A typical profit and loss statement template will include the following information:

  • Specified time period
  • Revenue
  • Cost of goods sold (COGS)
  • Gross profit
  • Operating expenses
  • Operating income
  • Other income/expenses
  • Net income
  • Taxes
  • Total net income after taxes
  • Earnings per Share (if applicable, for publicly traded companies)

Can this profit and loss statement template be used in Google Sheets?

Yes, download our profit and loss statement Excel template. Then in Google Sheets, follow these steps:

  1. Create a new or open an existing spreadsheet.
  2. Click File. Import.
  3. Choose the Excel profit and loss statement template file and click Select.
  4. Choose an import location option:
    Create new spreadsheet,
    Insert new sheet(s),
    or Replace spreadsheet.
  5. Click Import data and you should have this profit and loss statement template in Google Sheets.
The content and templates are provided for informational purposes only and are provided as-is and as available basis. You should not construe any such information or other material as legal, tax, investment, financial, or other advice. All content on this site is information of a general nature and does not address the circumstances of any particular individual or entity. For questions or advice regarding your business’s specific circumstances, please consult your business financial advisor. Nothing in the site constitutes professional and/or financial advice, nor does any information on the site constitute a comprehensive or complete statement of the matters discussed or the law relating thereto. BILL is not a fiduciary by virtue of any person’s use of or access to the site or the templates provided herein. You alone assume the sole responsibility of evaluating the merits and risks associated with the use of any information or other content on the site before using the templates provided or making any decisions based on such information or other content. You agree not to hold BILL, its affiliates or any third party service provider liable for any possible claim for damages arising from your use of the templates provided herein or any decision you make based on information or other content made available to you through the site.