Profit and Loss Statement Template

Template of Profit and Loss Statement

The profit and loss statement or the income statementIncome StatementThe income statement is one of the company's financial reports that summarizes all of the company's revenues and expenses over time in order to determine the company's profit or loss and measure its business activity over time based on user requirements.read more is one of the most important financial statements of the CompanyFinancial Statements Of The CompanyFinancial statements are written reports prepared by a company's management to present the company's financial affairs over a given period (quarter, six monthly or yearly). These statements, which include the Balance Sheet, Income Statement, Cash Flows, and Shareholders Equity Statement, must be prepared in accordance with prescribed and standardized accounting standards to ensure uniformity in reporting at all levels.read more, which provides the details of the Companies’ revenues and expenses during the particular period the income statement is created. Income statement could be of any period, monthly, quarterly, half-yearly, or annually. The Profit and Loss Statement excel templates provided here discuss the monthly and annual income statement.

The two excel can help businesses to generate their 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.

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Profit and Loss Statement Template (wallstreetmojo.com)

Components of Profit and Loss Statement

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 incomeInterest IncomeInterest Income is the amount of revenue generated by interest-yielding investments like certificates of deposit, savings accounts, or other investments & it is reported in the Company’s income statement. read more etc.;
Cost of Goods Sold (COGS)	This line item includes the Cost of total goods sold by the CompanyCost Of Total Goods Sold By The CompanyThe Cost of Goods Sold (COGS) is the cumulative total of direct costs incurred for the goods or services sold, including direct expenses like raw material, direct labour cost and other direct costs. However, it excludes all the indirect expenses incurred by the company. read more.
Employees’ expense	Employees’ expense includes salaries, wages, benefits and other long term benefits provided to the employees which are a direct costDirect CostDirect costs are costs incurred by an organization while performing its core business activity and can be attributed directly in the production cost, such as raw material costs, wages paid to factory staff, power & fuel expenses in a factory, and so on, but do not include indirect costs such as advertisement costs, administrative costs, etc.read more 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 additional expense which is not mentioned in the above expenses is input in this line item
Depreciation and Amortization	It includes depreciationDepreciationDepreciation is a systematic allocation method used to account for the costs of any physical or tangible asset throughout its useful life. Its value indicates how much of an asset’s worth has been utilized. Depreciation enables companies to generate revenue from their assets while only charging a fraction of the cost of the asset in use each year. read more and amortization expense on assets acquired or bought by the Company
Interest Expense	This line item consists of the interest expense paidInterest Expense PaidInterest expense is the amount of interest payable on any borrowings, such as loans, bonds, or other lines of credit, and the costs associated with it are shown on the income statement as interest expense.read more 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 different 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 P&L Template in Excel

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

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

Recommended Articles

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

• Examples of Profit & Loss Statement
• Basics of Income Statement
• Multi-Step Income Statement
• Pro Forma Income Statement