Free Profit and Loss Template for Small Businesses and Startups
A 12-month projected P&L spreadsheet. Enter your pricing, cost of goods sold, operating expenses, and expected growth rates, and it calculates monthly revenue, margins, break-even point, and total investment needed.
Read the instructions and examples for different business types (product, service, SaaS, digital).
List one-time expenses: equipment, inventory, registration, legal, initial marketing.
Add revenue streams with pricing, starting volume, monthly growth rate, and COGS per unit. Add monthly operating expenses.
The spreadsheet calculates monthly profit/loss, break-even month, and total investment needed.
What This Profit and Loss Template Shows You
This is a projected P&L, not a record of past transactions. You enter your assumptions — pricing, unit volume, monthly growth rates, cost of goods sold, and operating expenses — and the spreadsheet calculates a 12-month forecast.
It shows you monthly revenue, gross margin, net margin, cumulative profit or loss, when you'll break even, and how much total investment you'll need before the business becomes profitable.
Who This Profit and Loss Template Is For
Founders building financial projections before launch, small business owners planning their first year, and anyone applying for funding who needs a credible forward-looking P&L.
Works for products, services, SaaS, and digital products. The Start Here tab explains how to think about COGS and growth rates for each type.
What's Inside This Profit and Loss Template
Start Here
Instructions and explanations of key concepts like cost of goods sold and growth rates, with examples for products, services, SaaS, and digital products.
Startup Costs
One-time launch expenses: equipment, inventory, registration, legal, initial marketing.
Assumptions
All your inputs: up to 3 revenue streams with pricing, starting volume, monthly growth rate, and cost of goods sold per unit. Plus 15 categories of monthly operating expenses.
Revenue
12-month projection of units sold and revenue, calculated from your pricing, volume, and growth assumptions.
Expenses
Cost of goods sold plus operating expenses by month, including credit card processing fees at 2.9%.
P&L Summary
Monthly profit or loss, cumulative P&L, break-even month, total investment needed, gross margin, and net margin.
Download the free 12-month projected P&L template.
Frequently Asked Questions
Common questions about profit and loss templates.
A profit and loss statement template is a spreadsheet that projects your business revenue, costs, and expenses over a set period — typically 12 months. It calculates whether your business will be profitable, when you'll break even, and how much money you'll need to get there. A good template does the math for you once you enter your assumptions.
Start by listing your revenue streams with pricing and expected volume. Add your cost of goods sold (what it costs to deliver each unit). Then list your monthly operating expenses: rent, software, marketing, payroll, and so on. The template calculates gross profit (revenue minus cost of goods) and net profit (gross profit minus operating expenses) for each month.
Google Sheets has basic P&L templates, but they're designed for recording past transactions rather than projecting future performance. This template is built for projections — you enter your assumptions (pricing, volume, growth rate, expenses) and it calculates a 12-month forecast with break-even analysis and investment requirements.
A profit and loss statement records what already happened — revenue and expenses from a past period. A profit and loss projection estimates what will happen — forecasted revenue and expenses for a future period. Startups and new businesses need projections to plan their launch; established businesses use statements to track performance and projections to plan ahead.
A startup P&L template should include one-time startup costs (equipment, inventory, legal, initial marketing), multiple revenue streams with different pricing and growth rates, cost of goods sold per unit, monthly operating expenses by category, and summary calculations for gross margin, net margin, break-even point, and total investment needed before profitability.
Break-even is the point where total revenue equals total costs. In a P&L template, break-even is calculated by tracking cumulative profit and loss month over month. The break-even month is when cumulative profit turns positive. The template also shows total investment required: the sum of all losses before break-even plus startup costs.