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.
- 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
- Works with manual entry; optional Avery plans for bank imports and app features
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
When to add Avery
Avery Pro brings accounts, expenses, invoices and reports together in the mobile and web apps. Business adds recurring invoices, payment reminders and advanced bookkeeping tools. If you prefer a spreadsheet workflow, Avery for Google Sheets imports transactions from supported accounts, with categories and rules for you to review. Compare the plans. The free template also works with manual entry.
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 starting point for freelancers and consultants to organise business expense records and review them with an accountant.
- freelancers
- expenses
- FreelanceFree
Self-Employed Expense Tracker
A free Google Sheets starting point for organising self-employed expense records, reviewing categories and keeping supporting documents ready for your accountant.
- 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 — clear answers for your next review.
Browse all 11 Q&As →Bring your business finances together.
Use Avery Pro for accounts, expenses, invoices and reports. Prefer spreadsheets? Explore Avery for Google Sheets.