Format
Excel + PDF
Price
Free
How to use this template
- 1Enter your revenue figures in the Revenue section for each month
- 2Enter cost of goods sold if applicable
- 3Enter operating expenses by category
- 4The template calculates gross profit, EBITDA, and net profit automatically
- 5Use the annual summary to see the full-year picture
- 6Share the PDF version with your accountant, bank, or investors
ReportsAccess free template
Profit & Loss Statement Template
Simple P&L template for monthly and annual reporting. Pre-formatted with revenue, COGS, gross profit, and net sections.
What's included
- Monthly P&L with annual comparison column
- Revenue section: product sales, services, other income
- COGS (Cost of Goods Sold) section
- Gross profit and gross margin % calculation
- Operating expenses broken down by category
- EBITDA and net profit calculations
- Year-over-year comparison sheet
- Excel + PDF versions
Who uses this template
- Presenting financial performance to investors or lenders
- Monthly management reporting for directors
- Year-end tax preparation and accountant review
- Benchmarking business performance month-over-month
Want to automate this entirely?
Note.now handles reports automatically - no spreadsheet required. Real-time data, one-click reports, and bank-connected accuracy.
Try free for 7 daysFrequently asked questions
What is the difference between EBITDA and net profit?
EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortisation) shows operating performance before non-cash items. Net profit is what remains after all costs including tax.
Should I use cash or accrual accounting?
This template supports either. For accrual accounting, enter revenue when earned and expenses when incurred. For cash accounting, record when money moves. Most growing businesses use accrual accounting.