Free profit and loss statement template for Excel

A 12-month profit and loss statement (P&L) template: revenue, cost of sales, gross profit, operating expenses, net profit and margins.

What's in this template

Profit and loss sheet

131 formulas and colour highlights.

  • Revenue
  • Jan
  • Feb
  • Mar
  • Apr
  • May
  • Jun
  • Jul
  • Aug
  • Sep
  • Oct
  • Nov
  • Dec
  • Year
  • Total revenue
  • Cost of sales
  • Total cost of sales
  • Gross profit
  • Operating expenses
  • Total operating expenses
  • Operating profit
  • Net profit

Find it in: Profit and loss statement template

More budgets & finance templates ยท All templates