Free Self-Employed Profit and Loss Template for Google Sheets
Prove what your one-person business actually earned — without rebuilding a P&L every month.
- Who it’s for
- Freelancers, sole proprietors, consultants, and 1099 earners who need a clean self-employed P&L for taxes, loans, or clarity — without QuickBooks.
- Problem it solves
- Generic P&L sheets ignore Schedule C language and self-employment cash flow. Self-employed owners re-key numbers by hand, so the statement is stale when a lender or tax deadline hits.
We’ll email you a copy. No spam.
Key benefits
- Built for self-employed / Schedule C income and expense language
- Automatic gross profit, operating profit, and net profit with margins
- Monthly columns plus year-to-date totals
- Clean enough to share with a lender or CPA
- Syncs with Avery so bank transactions flow into a live P&L
The self-employed profit and loss template is a free Google Sheets P&L built for freelancers, sole proprietors, and 1099 earners. Enter business income and expenses — or let Avery sync them from your bank — and the sheet calculates gross profit, operating profit, net profit, and margins by month and year-to-date.
This is general information, not tax advice. Use the totals with your records and confirm anything specific with a qualified tax professional.
Who it's for
- Freelancers and consultants who need a current P&L for pricing, a loan, or a CPA.
- Sole proprietors and single-member LLCs who report business profit on Schedule C.
- 1099 and side-hustle earners who want business income and expenses separated from personal spending.
- Anyone tired of a generic small-business P&L that does not speak Schedule C language.
If you want a statement that fits any small business, use the profit and loss statement template instead. This page is the self-employed version of that sheet.
What's inside
- Revenue rows for each income stream (clients, products, other business income)
- Direct costs / COGS so gross profit is a real number, not a guess
- Operating expenses in self-employed, Schedule C–friendly categories
- Automatic gross profit, operating profit, and net profit, each with a margin
- Monthly columns plus a year-to-date total
- A layout you can export to PDF or Excel for a lender or preparer
The honest part
A spreadsheet only works if the data is in it. Most self-employed P&Ls die because nobody wants to retype a month of bank activity before a lender email or a tax deadline. Copy this sheet and fill it by hand for free — that path stays open. When you want the statement to stay current, connect Avery: read-only bank sync categorizes transactions into the P&L so you stop rebuilding it by hand. Avery Plus is $29.99 when you want that live layer. The Google Sheet itself stays free.
Go deeper
- Walk through the tax form: Schedule C profit and loss for freelancers.
- Short answers on setup, lenders, and taxes: self-employed P&L questions.
- The broader sheet, if you are not filing as self-employed: profit and loss statement template and its Google Sheets guide.
- Expense detail that feeds the P&L: freelancer expense tracker and self-employed expense tracker.
More Templates
See All Templates- BookkeepingFree
Profit & Loss Statement
A free profit and loss statement template for Google Sheets — track revenue, COGS, operating expenses, and net profit with automatic monthly and year-to-date totals.
- profit-and-loss
- p&l
- FreelanceFree
Freelancer Expense Tracker
A free Google Sheets expense tracker built for freelancers and self-employed people — IRS-ready categories, mileage and home office calculators, and tax-ready Schedule C totals.
- freelancers
- expenses
- FreelanceFree
Self-Employed Expense Tracker
A free Google Sheets expense tracker for self-employed people — sole proprietors, single-member LLCs, and gig and contract workers — with Schedule C categories, self-employment tax awareness, and tax-ready totals.
- self-employed
- expenses
Frequently Asked Questions
Is this self-employed P&L template free?
How is this different from Avery's generic profit and loss template?
Can I use this P&L for Schedule C or a loan?
Do I need Avery to use it?
Does it work in Excel?
Helpful next steps
Related guides
Questions & answers
11 answers on setup, deductions, categories, and taxes — written for answer engines and people in a hurry.
Browse all 11 Q&As →