Free tool
Simple Profit and Loss Statement Template
A short P&L with revenue, expenses and net profit for service businesses and side hustles. Totals and margins are worked out for you. PDF and CSV, free.
- A short profit and loss statement with just revenue, expenses and net profit, ready to fill in.
- Perfect for service businesses, side hustles and first-year businesses without inventory.
- Add or remove lines in seconds; totals and margins update as you type.
- Download a one-page PDF or a CSV for Excel and Google Sheets. Free, no sign-up.
How to fill in a simple profit and loss statement
Add your income
List each kind of income, such as services, product sales or commissions. One or two lines is fine.
List your expenses
Add the costs you paid to run the business: rent, supplies, advertising, software, insurance, phone and so on.
Skip what you do not need
Leave Cost of goods sold, Other income and Other expenses empty if they do not apply. Empty sections stay off the PDF.
Download
Check net profit and margin in the summary, then download a one-page PDF or CSV.
The simple formula
Simple P&L
Net profit = total revenue − total expenses
Net margin = net profit ÷ total revenue × 100
If you later start selling products, add Cost of goods sold lines and the template will also show gross profit and gross margin.
A tutoring business
The simple template opens with this example of a small tutoring business for one year.
- Tutoring sessions $64,800
- Test prep workshops $9,600
- Total revenue $74,400
- Total expenses $23,630
- Net profit $50,770, a 68.2% net margin
Service businesses with low overhead often have high margins like this, because there is no inventory to buy.
Expense categories to start with
| Category | Examples |
|---|---|
| Rent and utilities | Office or studio rent, electricity, internet |
| Advertising | Online ads, flyers, website, directory listings |
| Supplies | Materials and small items used up in the work |
| Software | Booking, accounting, design and email tools |
| Insurance | General liability, professional liability |
| Professional fees | Accountant, lawyer, payment processing fees |
| Travel and vehicle | Business mileage, parking, travel costs |
Keep the list short at first. A simple P&L with eight honest lines is more useful than a long one with guesses. You can always split a category later.
When a simple P&L is enough
Side hustles
Track whether extra work is actually profitable after costs.
Service businesses
Consultants, tutors, cleaners and designers rarely need cost of goods sold.
Loan or lease applications
Many landlords and small lenders just want a clear yearly summary.
First year in business
Start simple and add detail once you know where the money goes.
A simple P&L is only accurate if business income and expenses are not mixed with personal spending. A separate bank account or card for the business makes the statement much easier to build and to trust.
Selling products or need monthly columns? Use the full profit and loss statement template. Self-employed? See the self-employed P&L.
Simple P&L vs full P&L
| Simple P&L | Full P&L | |
|---|---|---|
| Sections | Revenue and expenses | Revenue, cost of goods sold, operating expenses, other income and expenses |
| Shows | Net profit and net margin | Gross profit, operating income, net profit and three margins |
| Best for | Service businesses, side hustles, first year | Product sellers, growing businesses, lenders |
| Time to make | About 15 minutes | 30 minutes or more |
You can move from one to the other at any time. Add lines under Cost of goods sold and the template starts showing gross profit and gross margin automatically.
Build it from your bank statement
Download the statements
Get the business bank and card statements for the period, such as January to December.
Mark the deposits
Add up money customers paid you. Leave out transfers, loans and money you put in yourself.
Group the payments
Sort business payments into a few categories, such as rent, supplies and advertising, and total each one.
Enter and check
Type the totals into the template and compare net profit with what you expected. Big surprises usually mean a missed or doubled item.
A side hustle in one month
A weekend dog walker earns $1,840 in March. Expenses are $95 for app fees, $60 for treats and supplies and $45 for insurance.
- Revenue $1,840.00
- Expenses $200.00
- Net profit $1,640.00, an 89.1% net margin
Even a small side income benefits from a simple P&L at tax time, because it shows the profit you will owe tax on.
Simple P&L template FAQ
What is a simple profit and loss statement?
A short P&L that lists revenue and expenses and shows the net profit or loss, without the extra sections larger businesses use.
Do I need cost of goods sold?
Only if you sell products or materials. Service businesses can leave that section empty.
Can I print a blank simple P&L?
Yes. Press Print blank to print the template with the line names and empty amounts to fill in by hand.
Is the simple P&L template free?
Yes, with no sign-up or watermark. Your numbers are saved only in your browser.
Can I open it in Excel?
Yes. Press CSV and open the file in Excel or Google Sheets.
How often should I make one?
At least once a year for taxes. Many owners also make one every month or quarter to spot problems early.