Profit and Loss Excel Template


By downloading this free Profit and Loss template, you will be able to easily create your own income statement. Once you have downloaded this tool, simply enter your own information in all of the blue font color cells. This will automatically produce a monthly or annual statement as the output. The Excel file contains four tabs which each include a different template.

A profit and loss statement (P&L), also known as an income statement, summarizes the income and expenses of a company over a specific period of time to arrive at its net earnings for the period.


There are two types of template included in the Excel file:

  • Monthly P&L template
  • Annual P&L template

Components of the P&L Template

  • Revenue streams (also called sales streams)
  • Returns, Refunds, Discounts
  • Total Net Revenue
  • Cost of Goods Sold
  • Gross Profit
  • Advertising & Promotion
  • Depreciation & Amortization
  • Rent and Office
  • Salaries, Benefits & Wages
  • Telecommunication
  • Travel
  • Utilities
  • Selling, General & Administrative (SG&A)
  • Earnings Before Interest & Taxes (EBIT)
  • Interest Expense
  • Earnings Before Taxes (EBT)
  • Income Taxes
  • Net Earnings

All worksheets in this profit and loss template can be altered to suit your business' needs. If you need to add any more line items, simply insert a new row - just make sure the formulas adding up the totals capture those new rows.

Recently Viewed Templates