Profit and Loss Statement Template for Google Sheets
See whether your business actually made money — month by month, automatically.
- Who it’s for
- Small business owners, freelancers, bookkeepers, and side-hustlers who need a clean P&L without building one from scratch.
- Problem it solves
- Most profit and loss templates are static — you re-key every number by hand, so the statement is always out of date when you need it for a loan, a tax return, or a pricing decision.
We’ll email you a copy. No spam.
Key benefits
- Pre-built revenue, COGS, and operating expense sections
- Automatic gross profit, operating profit, and net profit margins
- Monthly columns with year-to-date totals that roll up on their own
- Works for sole proprietors, LLCs, and S-Corps
- Works with manual entry; optional Avery plans for bank imports and app features
The Profit & Loss Statement template gives you a real income statement in Google Sheets without the formula-building, the broken totals, or the blank-page paralysis. Enter your revenue and expenses — or sync them from your bank with Avery — and the template calculates gross profit, operating profit, net profit, and every margin across each month and year-to-date.
Who it's for
This profit and loss template is built for small business owners, freelancers, consultants, e-commerce sellers, and bookkeepers who need a clean P&L they can hand to an accountant, attach to a loan application, or use to make a pricing decision — without paying for accounting software they don't need yet.
What's inside
- A revenue section for every income stream
- A cost of goods sold (COGS) section that drives gross profit
- A fully categorized operating expenses section
- Automatic gross profit, operating profit, and net profit with margins
- Monthly columns plus a self-summing year-to-date total
- A layout that exports cleanly to PDF or Excel for lenders and tax prep
Go deeper
New to this? Read the full walkthrough in our profit and loss statement template guide, or jump straight to the most-asked profit and loss questions for quick, direct answers on setup, taxes, and margins.
Filing as a sole proprietor, freelancer, or 1099? Use the self-employed profit and loss template — Schedule C–friendly categories, a questions page, and the Schedule C profit and loss guide.
More Templates
See All Templates- BookkeepingFree
Self-Employed Profit & Loss
A free self-employed profit and loss template for Google Sheets — track freelance and sole-prop income, expenses, and net profit with monthly and year-to-date totals ready for Schedule C and lenders.
- self-employed
- profit-and-loss
- BookkeepingFree
Self-Employment Ledger
A free self-employment ledger template for Google Sheets — record income and expenses in one running book for sole props, with totals that feed Schedule C and your P&L.
- self-employment
- ledger
- SpendingFree
Business Expense Tracker
A free Google Sheets business expense tracker for small business owners — separate business spending, sort it into deductible categories, and keep clean records your accountant will love.
- business
- expenses
Frequently Asked Questions
What is a profit and loss statement?
Is this profit and loss template free?
Does it work in Excel as well as Google Sheets?
Can I use this P&L for my taxes or a loan application?
Do I have to enter every transaction by hand?
Helpful next steps
Related guides
Questions & answers
14 answers on setup, deductions, categories, and taxes — clear answers for your next review.
Browse all 14 Q&As →Bring your business finances together.
Use Avery Pro for accounts, expenses, invoices and reports. Prefer spreadsheets? Explore Avery for Google Sheets.