Free Profit and Loss Statement Template for Freelancers (Excel)
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)
Shaded cells are for you to fill in; the totals work themselves out.
| Profit and Loss Statement | ||||||||
| Your business name | Year | 2026 | ||||||
| Fill in the shaded cells; totals work themselves out. Prepared by the business owner from their own records. Unaudited. | ||||||||
| Category | Sch. C line | Jan | Feb | Mar | Apr | May | Jun | Jul |
| Income | ||||||||
| Client payments | 1 | |||||||
| Platform or app payouts (Upwork, Uber, Etsy…) | 1 | |||||||
| Other business income | 6 | |||||||
| Total income | auto | auto | auto | auto | auto | auto | auto | |
| Expenses | ||||||||
| Advertising and marketing | 8 | |||||||
| Car and truck expenses | 9 | |||||||
| Commissions and fees (incl. platform fees) | 10 | |||||||
| Contract labor | 11 |
How to use the profit and loss template
- Download it and add your business name and the year at the top.
- 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.
- Read the totals: total income, total expenses and net profit for each month and for the year.
- 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
- Free income and expense spreadsheet: record each transaction, then see the totals.
- 1099 Tax Calculator: the tax on your net profit.
- Quarterly Estimated Tax Calculator: what to pay the IRS each quarter.