Profit and Loss Statement Template

Last Updated :

21 Aug, 2024

Blog Author :

Wallstreetmojo Team

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya

Table Of Contents

arrow

 

What Is Profit And Loss Statement Template?

The profit and loss statement or the income statement is one of the most important financial statements of the Company, which provides the details of the Company's revenues and expenses during the particular period the income statement is created.

Profit and Loss Statement Template

The income statement could be of any period, monthly, quarterly, half-yearly, or annually. The Profit and Loss Statement excel templates here discuss the monthly and annual income statements. The two can help businesses generate their income statement after entering a few financial numbers of their business. Both the templates look alike in terms of the contents – the period for which the numbers are put in the template varies.

Table of contents

Profit and Loss Statement Template Explained

The statement of profit and loss template is the document which gives a stakeholder a summary of the financial condition of the company. It displays the net income or loss as well as the revenues earned, and the expenses incurred during the course of the business.

Based on the information given in this template, the investors can take informed decision regarding whether to invest in the company or not. Even other stakeholders like the creditors can take decisions regarding the financial status of the business and accordingly lend money by evaluation the creditworthiness.

The profitability and the financial performance of the business is clearly shown in the simple profit and loss statement template.

 

Components

The major components to be filled by the user in the P&L Template in Excel are as below which may be profit and loss statement template for small business or established companies.

Gross SalesIt is the total sales done by the Company during the time period.
Other revenueAny other revenue earned by the Company from various sources like interest income, etc.; It represents the total earning of the company within that period. The revenue may come from the primary operation or from secondary sources, or from any income from interest and sale of assets.
Cost of Goods Sold (COGS)This line item includes the Cost of total goods sold by the Company. This cost represents the direct cost incurred from producing or acquiring the products and services that are sold by the company. They include expenses related to raw material, direct labour or any overheads related to manufacturing that can be directly attributed to the process of production.
Employees' expenseEmployees’ expense includes salaries, wages, benefits and other long term benefits provided to the employees which are a direct cost to the Company
Marketing ExpensesMarketing expenses done by the Company to improve sales are input in this line item.
RentThis line item includes the rent paid by the Company for their office, factory, manufacturing units, or warehouses,
Office Supplies and General ExpensesThis line item includes the expenses done on office supplies, utilities like electricity, and other general expenses.
Other expensesAny additional expense which is not mentioned in the above expenses is input in this line item
Depreciation and AmortizationIt includes depreciation and amortization expense on assets acquired or bought by the Company
Interest ExpenseThis line item consists of the interest expense paid by the Company for loans taken by it from banks
Income taxesIncome tax is the tax paid on the income earned by the Company. The user can set this to (percentage tax rate* Earning Before Taxes) depending on the tax rate of his Country. It represents the tax expense as per the applicable tax rates of the country and the amount of tax liability on the income generated.

Thus, the above are some of the important components of the statement of profit and loss template that are commonly used by the stateholders from financial information related to the business. These components provide a comprehensive view about the ability of the business to generate profits through proper control of its cost. This template is used to compare the company performance with its peers and is acts as a benchmark to make financial decisions.

How To Make?

Creating a template for the profit and loss of an organization requires a designed and structured format which will be able to capture the relevant financial and accounting information of the business in a systematic way.

The below mentioned steps will give a clear idea about how to create the structure of a profit and loss statement template for small business or established companies.

  • Time period – It is necessary to identify the time period which will be covered in the template. The may be a month, a quarter or an year.
  • The header – The header of the template will include information like the name of the company, the title of the document and the time period.
  • Revenue section – This will include the area of recording revenue like the sales revenue, service revenue and income. A separate line for a subtotal cam be included.
  • Cost of goods sold section – This will include various cost components like direct labor, manufacturing overheads, inventory, etc.
  • Separate sections for operating income and expenses – Item under the operating expense should be recorded in details and then subtracted from the gross profit to get the operating income.
  • Non-operating items -They should also be recorded as per the items like interest income/expense, investment income/expense, etc.
  • Income before tax – Then comes income before tax by subtracting or adding the non-operating income/expense form the operating income expense.
  • Tax – In the next step, the tax amount is calculated based on the above income.
  • Net Income – In the next step, the net imcome is arrived at by subtracting the tax amount form the Income from tax.

At the end if the template, the business may include any additional information or disclosure or notes that are relevant to the accounting period. This will include some short explanations about any particular event or transaction which may impact the financial data, relevant for audit purpose and important for stakeholders.

Examples

Let us try to understand the concept of simple profit and loss statement template with the help of some suitable examples.

Example #1

Monthly Profit and Loss Template in Excel

The monthly P&L Template in Excel will look like the following:

Profit and Loss Statement Template (Monthly PnL Statement (Mn $))

 

Example#2

Annual P&L Template in Excel

The annual basic profit and loss statement template in Excel will look like the following:

Profit and Loss Statement Template (Annual PnL Statement (Mn $))

You can download this Template from here - Profit and Loss Statement Excel Template