Profit and Loss Statement Excel Template

Track your business's financial performance with our free P&L statement template

Download Template

Get instant access to our professional P&L statement template

Access Template

Available in Google Sheets format. Can be exported to Excel.

Track Your Business's Financial Health

Get a clear overview of your business's profitability with our comprehensive P&L statement template. Track revenue, expenses, and see your bottom line at a glance.

Revenue

Enter your business income:

  • Sales revenue
  • Other income sources
  • Total revenue (calculated automatically)

Cost of Goods Sold (COGS)

Enter the costs directly associated with producing your goods or services. This will be subtracted from revenue to calculate gross profit.

Operating Expenses

Input your business operating costs:

  • Salaries and wages
  • Rent and utilities
  • Marketing and advertising
  • Office supplies
  • Other miscellaneous costs

Operating Profit

Automatically calculated by subtracting operating expenses from gross profit. This shows your business's operational performance before other expenses.

Other Expenses

  • Interest expenses
  • Taxes

Net Profit

The final bottom line is calculated automatically as Operating Profit minus Total Other Expenses. This shows your business's true profitability after all expenses.

Benefits of Using Our Template

  • Automatic calculations
  • Clear financial overview
  • Professional formatting
  • Easy to customize