Free Profit and Loss Statement Template for Freelancers (Excel)

By the JAJPO team · How we build our tools

A free profit and loss statement template for freelancers and sole proprietors. Enter your income and expenses month by month; the totals for each month, the year and your net profit work themselves out. The categories follow IRS Schedule C, so your year-end numbers are ready for your tax return.

Free template

Free Profit and Loss Statement Template (Excel)

Excel file (.xlsx) · opens in Excel, Google Sheets, Apple Numbers and LibreOffice · 2 sheets · formulas included

Shaded cells are for you to fill in; the totals work themselves out.

Preview: the Profit and loss sheet
Preview of the Profit and loss sheet
Profit and Loss Statement
Your business nameYear2026
Fill in the shaded cells; totals work themselves out. Prepared by the business owner from their own records. Unaudited.
CategorySch. C lineJanFebMarAprMayJunJul
Income
Client payments1
Platform or app payouts (Upwork, Uber, Etsy…)1
Other business income6
Total incomeautoautoautoautoautoautoauto
Expenses
Advertising and marketing8
Car and truck expenses9
Commissions and fees (incl. platform fees)10
Contract labor11

How to use the profit and loss template

  1. Download it and add your business name and the year at the top.
  2. Each month, total your income and expenses by category and type them in the shaded cells for that month. Leave a cell blank if there was nothing.
  3. Read the totals: total income, total expenses and net profit for each month and for the year.
  4. At tax time, the yearly totals line up with Schedule C, the form for self-employment income.

What is a profit and loss statement?

A profit and loss statement, also called a P&L or income statement, shows your income, your expenses and the difference for a period such as a month or a year. For a freelancer it answers three questions: how much came in, where it went, and what you actually made. That profit is also what your self-employment tax is based on.

What's in the template

  • Income lines for client payments, platform payouts and other business income.
  • 21 expense lines that follow IRS Schedule C, from advertising to utilities.
  • Twelve monthly columns, a yearly total, and net profit for each month.
  • Frozen headings, so the categories stay in view as you scroll.

Don't want to add up the months yourself?

Log each payment in the free Income & Expense Tracker as it happens. It makes this statement for you as a PDF or an Excel workbook, by month and by Schedule C category, and keeps your records only in your browser.

Frequently asked questions

Can I use this P&L as proof of income?

It's a summary of your own records, marked as prepared by you and unaudited. Some landlords and lenders accept one alongside other papers; many also ask for tax returns or bank statements. Ask them what they need, and never change the figures to make them look better.

Why are meals shown in full?

A profit and loss statement shows what you actually spent. For taxes, business meals are generally only 50% deductible, so your Schedule C may show a lower figure.

Is the template really free?

Yes. We ask for your email so we can send you tax-deadline reminders and new templates; you can unsubscribe at any time.

Related