Profit and Loss Statement Template (Free Excel) - Softotech

Profit and Loss Statement Template (Free Excel)

A free Excel profit and loss statement, also called an income statement. Enter monthly figures and see gross profit, operating profit and net profit.

Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 2 sheets.

What is inside the profit and loss statement template

SheetWhat it does
P&LMonthly columns for revenue, cost of goods sold, operating expenses, interest and taxes. Gross profit, operating profit, net profit, year totals, percent of revenue and a chart.
Read meShort instructions.

Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.

How to use it

  1. Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
  2. Replace the sample data in the yellow cells with your own.
  3. Read the totals and results that update automatically.
  4. Save a copy for each month, project or client, or print it from File > Print.

The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.

Free pricing tips for your business

Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.

    Built with Kit

    Frequently asked questions

    What is a profit and loss statement?

    It shows revenue minus costs and expenses over a period, ending with net profit. It is also called an income statement.

    Is a P&L the same as an income statement?

    Yes. Both terms describe the same report.

    How do I calculate gross profit?

    Gross profit is revenue minus cost of goods sold. The template does this for each month.

    Is this tax advice?

    No. It is a planning template. Ask an accountant for tax filing.

    Need a custom spreadsheet built for your business?

    Talk to us

    More free tools: All free Excel templates · Gross profit calculator · Balance sheet template · Cash flow template