Profit & Loss Statement Template
Free P&L statement template for Excel and PDF. Track revenue, expenses, and net income with auto-calculations.
| Line Item | Q1 2025 | Q2 2025 | Q3 2025 | Q4 2025 |
|---|---|---|---|---|
| Revenue | ||||
| Product Sales | $125,000 | $138,500 | $142,000 | $156,200 |
| Service Revenue | $45,000 | $48,200 | $52,100 | $58,400 |
| Other Income | $5,000 | $5,500 | $6,200 | $7,100 |
| Total Revenue | $175,000 | $192,200 | $200,300 | $221,700 |
| Expenses | ||||
| Cost of Goods Sold | $70,000 | $76,880 | $80,120 | $88,680 |
| Operating Expenses | $35,000 | $37,200 | $39,800 | $42,500 |
| Marketing | $12,000 | $13,500 | $15,000 | $18,200 |
| Administrative | $8,000 | $8,600 | $9,200 | $10,400 |
| Total Expenses | $125,000 | $136,180 | $144,120 | $159,780 |
| Net Income | $50,000 | $56,020 | $56,180 | $61,920 |
Profit & Loss Statement Template
Get New Templates in Your Inbox
Join 2,000+ others getting free finance templates. No spam, unsubscribe anytime.
Four Quarters
Full year quarterly breakdown
Auto-Calculations
Totals computed automatically
Year-over-Year
Compare multiple periods
Profit Margins
Gross and net margin %
How to Use
1. Download the template in Excel or PDF format.
2. Enter your revenue by category.
3. Input all expenses by category.
The spreadsheet automatically calculates gross profit, total expenses, and net income.
What's Included
Complete P&L template with sections for:
Related Templates