Sheet template · Finance
Profit & Loss Statement
Summarize revenue, cost of goods sold, operating expenses, and net profit by period.
Owner-led businesses and operators who need a readable monthly income statement before a formal accounting close.
Sign in to start an independent editable workbook from this Sheets template.
Structured preview
Profit & Loss Statement at a glance
Preview only6 columns · 3 sample rows
| Period | Revenue | Cost of goods sold | Gross profit | Operating expenses | Net profit |
|---|---|---|---|---|---|
| October 2026 | $42,000 | $12,500 | =B4-C4 | $17,800 | =D4-E4 |
| November 2026 | $45,500 | $13,800 | =B5-C5 | $18,100 | =D5-E5 |
| Period total | =SUM(B4:B6) | =SUM(C4:C6) | =SUM(D4:D6) | =SUM(E4:E6) | =SUM(F4:F6) |
Use this as a planning and reporting starting point; confirm categories and figures with your accounting workflow.
What's included
- Revenue and cost-of-goods-sold fields
- Gross and net profit formulas
- Operating expense column
- Period total row for a small-business review
How to use it
- 1Replace the sample periods and figures with your own reporting data.
- 2Keep revenue, direct costs, and operating expenses categorized consistently.
- 3Review the result with the person responsible for your books; this template is not accounting or tax advice.
Continue exploring