Profit and Loss Template for Excel and Google Sheets: Free Download With Formulas (2026)
Three template variants - simple, standard, and detailed - each pre-filled with realistic example data and formulas. Download for Excel (.xlsx), copy to Google Sheets, or customize online. No email required.
Three Template Variants
Choose the right level of detail for your business size and complexity.
Simple Template
Best for Freelancers5 expense categories, single monthGross margin: 87.4% | Net margin: 71.6% | Typical for a freelance design business.
Standard Template
Most Popular12 expense categories, monthly columnsThe standard template adds 12 monthly columns with automatic year-to-date totals. Each revenue and expense row shows both the dollar amount and the percentage of total revenue. Includes a gross profit subtotal row and EBITDA calculation.
- 12 monthly columns (Jan through Dec) + YTD column
- Revenue: 3 rows (primary, secondary, other)
- COGS: 4 rows (materials, direct labor, shipping, other direct)
- Operating expenses: 8 rows (rent, salaries, marketing, software, insurance, professional fees, utilities, other)
- Gross profit, EBITDA, and net income rows with formulas
- Percentage of revenue column for every line item
- Month-over-month change row (shows % change from prior month)
Detailed Template
For Growing Businesses20+ categories, quarterly + annual viewThe detailed template is for businesses with multiple revenue streams, a larger team, or investors who need formal financial reporting. It includes a quarterly summary tab, a budget vs actual comparison, and department-level expense tracking.
- Revenue: up to 6 streams with product/service breakdown
- COGS: 8 categories including depreciation on production equipment
- Operating expenses: 15+ categories broken into Sales, Marketing, G&A
- EBITDA, EBIT, and net income calculations
- Quarterly summary tab (Q1-Q4 + Annual)
- Budget vs Actual variance column
- Year-over-year comparison (current year vs prior year)
P&L Formulas Explained
Every formula used in the templates, explained in plain English.
=SUM(B2:B4)Adds up all revenue rows. If you add more revenue rows, expand the range to include them.
=B5-SUM(B8:B10)Total Revenue minus total COGS. Keep COGS rows grouped so you can easily update this formula.
=B11/B5Divide Gross Profit by Total Revenue. Format as percentage. This is the most important profitability ratio for most businesses.
=B11-SUM(B14:B21)Gross Profit minus all Operating Expenses. This is the bottom line.
=B22/B5Net Income divided by Total Revenue. Compare this to industry benchmarks to assess performance.
=B22-B22previousCurrent month net income minus prior month. Shows whether the business is growing or shrinking month to month.
Common P&L Mistakes in Excel
Gross profit = Revenue minus COGS only. Net profit = Gross profit minus all operating expenses. Never subtract rent or salaries from revenue directly to get 'gross profit'.
COGS should only include costs that directly produce your product or service. Rent, insurance, and admin salaries are operating expenses, not COGS - even if you think of them as 'costs of doing business'.
If you pay yourself through owner's draw rather than salary, this does not appear on the P&L (it is a balance sheet transaction). Your P&L will look profitable even if you are drawing down cash. Track this separately.
Lumping all revenue into one line hides important information. A business with product revenue, service revenue, and subscription revenue should track each separately to understand which is growing.
Always use SUM() formulas for totals, not manually typed numbers. When you add a new expense row, a hardcoded total will not update automatically and your P&L will show wrong figures.
Cash accounting records revenue when paid and expenses when paid. Accrual records when earned/incurred. For businesses over $25M revenue, the IRS requires accrual. Mixing methods creates misleading P&Ls.
Google Sheets-Specific Tips
Select the net income row, then Format > Conditional Formatting. Set the format to 'Less than 0' and choose a red background. Negative months will now visually stand out.
Right-click on your formula rows (totals, margins), select 'Protect range'. This prevents accidentally overwriting a formula when entering data in adjacent cells.
Click Share, enter your accountant's email, set permission to 'Viewer'. They can see and comment but cannot change data. For collaboration, use 'Commenter' so they can annotate without editing.
If you have separate sheets for each cost center, use =IMPORTRANGE('sheet_url','Sheet1!B5') to pull totals into a master P&L without copying and pasting data manually.