Profit and Loss Statement Template

Template of Profit and Loss Statement

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

Every business whether big or small needs to have income statement as it will help make the business owner make financial decisions. The income statement is required while raising investment from investors or taking loans from banks.

Income statement could be of any period, monthly, quarterly, half yearly or annually. The profit and loss excel templates provided in this article are for the monthly and annual income statement.

The two excel templates of the Profit and Loss statement can help businesses to generate their own income statement after entering a few financial numbers of their business. Both the templates are look alike in terms of the contents – just the period for which the numbers are put in the template vary.

Components of Profit and Loss Statement Excel Template

The major components to be filled by the user in the P&L Template in Excel are as below:

Gross Sales	It is the total sales done by the Company during the time period.
Other revenue	Any other revenue earned by the Company from various sources like interest income etc.
Cost of Goods Sold (COGS)	This line item includes the Cost of total goods sold by the Company.
Employees’ expense	Employees’ expense includes salaries, wages, benefits and other long term benefits provided to the employees which are a direct cost to the Company
Marketing Expenses	Marketing expenses done by the Company to improve sales are input in this line item.
Rent	This line item includes the rent paid by the Company for their office, factory, manufacturing units or warehouses
Office Supplies and General Expenses	This line item includes the expenses done on office supplies, utilities like electricity and other general expenses
Other expenses	Any other expense which is not mentioned in the above expenses is input in this line item
Depreciation and Amortization	This includes depreciation and amortization expense on assets acquired or bought by the Company
Interest Expense	This line item includes the interest expense paid by the Company for loans taken by it from banks
Income taxes	Income 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

All other line items which are bold in the following templates have excel formulas which will be calculated once the user inputs the financial data for other line items. The snapshots for both the excel templates of Profit Loss Statement are given below:

Monthly Profit and Loss Template in Excel

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

Annual Profit and Loss Template in Excel

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

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

Recommended Articles

This has been a guide to Profit Loss Statement Template. Here we provide you with the Profit and Loss statement excel template for the monthly and annual P&L Statement with examples. You can learn more about financing from the following articles – 

• Definition of Other Expenses
• How to create Inventory Template in Excel?
• Percent Error Formula | Examples | Steps
• Examples of Cost of Goods Manufactured (COGM)
• Download Personal Budget Template in Excel
• Basics of Income Statement
• What is a Multi-Step Income Statement?
• What is Pro Forma Income Statement?