Template Overview
A profit and loss statement (also called an income statement or P&L) shows whether your business made money over a period. It is one of the most important reports for any small business, and the basis for filing taxes and understanding your margins. This template lays it out cleanly: list your revenue, your cost of goods sold, and your operating expenses, and the spreadsheet calculates Total Revenue, Gross Profit, Total Expenses, and your final Net Profit automatically. Just replace the sample figures with your own — perfect for small businesses that want a clear financial picture without paying for accounting software.
Features
- Auto-calculates gross profit and net profit
- Clear revenue, COGS and expense sections
- Totals update as you type
- Spare lines to add your own items
- Works in Excel, Google Sheets and LibreOffice
Instructions
- Download the file and open it in Excel, Google Sheets, or LibreOffice.
- Add your business name and the period at the top.
- Enter your revenue lines under REVENUE.
- Enter your cost of goods sold and operating expenses in their sections.
- Gross Profit and Net Profit calculate automatically at the bottom.
- Use the spare '[Add line]' rows for anything specific to your business.
FAQ
Is this P&L template free?
Yes. It is free to download and edit for personal and business use.
What is the difference between gross profit and net profit?
Gross profit is revenue minus the cost of goods sold. Net profit is gross profit minus all operating expenses — your actual bottom line.
Does it calculate automatically?
Yes. Totals, gross profit, and net profit are all formula-driven and update as you enter figures.
Does it work in Google Sheets?
Yes. Upload it to Google Sheets and the formulas carry over.