Profit and Loss Spreadsheet for Sole Traders

Hey folks, it’s Ren here. A friend who runs a little catering business told me over coffee at her kitchen table that she had her best month ever.

Biggest takings she had seen. Then she went quiet and said the bank account did not feel any different.

The flour, the casual help, the petrol, the packaging had all eaten the difference, and she had no single page that showed it. That page is a profit and loss spreadsheet.

"Revenue is vanity, profit is sanity, but cash is king." — Common business saying

🔍 Why a busy month can still lose money

Revenue tells you how busy you were, not whether you made anything, and the two come apart more often than people expect. A record month of takings can still end in a thin profit.

It happens because costs scale with the work. More orders means more materials, more hours and more packaging, and all of it comes out before a cent is profit.

Without one page that separates the lines, you feel the busyness and trust it. The P&L is what turns that feeling into a number you can check.

• Revenue measures activity, not profit.
• Costs rise with the work, quietly.
• Only the net line tells the truth.

📐 What a profit and loss spreadsheet shows

A profit and loss spreadsheet shows revenue at the top, the costs taken out in order and the net profit at the bottom. It reads like a story from what came in to what you actually kept.

Here are the five lines as the sheet lays them out:

Line	This month	Margin
Revenue	$9,000
Cost of goods	$2,700	30%
Gross profit	$6,300	70%
Operating costs	$3,800
Net profit	$2,500	28%

💰 The line most sole traders leave out

The single most common mistake I see is a P&L with no wage for the owner. This is the insight that changes how the whole page reads.

If you do not put your own pay in as an operating cost, the profit you see is really your unpaid labour dressed up as success. A business that only profits because the owner works for free is not profitable, it is subsidised by you. Add a fair wage for yourself as a cost, and the true margin appears, sometimes uncomfortably, but honestly.

📈 Margin is the number to watch

Net margin, the percentage of revenue you keep, is the single most useful number on the page. A dollar figure flatters a big month; the percentage tells you how efficient that month really was.

Because margins vary so much by trade, the comparison that counts is your own trend over time, not someone else’s benchmark.

A margin that climbs while revenue holds means the business is getting healthier. A margin that slides while revenue grows is the early warning to revisit your pricing before the busyness hides the problem.

A worked example makes it concrete. If you lift prices by five percent and lose only two or three percent of orders, revenue dips a little but margin rises, and you take home more for less work. Watching the percentage is what lets you see that trade clearly instead of fearing every price change.

✅ How to build your profit and loss spreadsheet

1. Set up the five P&L lines down one column. Revenue, cost of goods, gross profit, operating costs and net profit, in that order, so the page reads top to bottom.
2. Total your revenue for the month. Every sale and every invoice paid, before any costs come out, goes on the top line.
3. Subtract your cost of goods to get gross profit. The direct cost of what you sold, materials and the like, comes off revenue to show the profit on the work itself.
4. List your operating costs and take them off. Rent, software, marketing and, crucially, a wage for yourself, subtracted to reveal what you actually keep.
5. Read the net profit and the net margin. The dollar figure and the percentage together tell you whether the month actually worked, not just whether it was busy.
6. Log it each month and watch the margin trend. One row a month builds the trend line that tells you if the business is getting healthier or just bigger.

📅 How often should you update a profit and loss?

A profit and loss spreadsheet is most useful when you update it monthly, soon after the month closes. Monthly is frequent enough to catch a slipping margin early, and rare enough that the habit survives a busy stretch.

Run it the same way each month. Total the revenue, take out cost of goods, then operating costs, and read the net profit and margin off the bottom two lines.

Keep every month in one place so the rows stack into a trend. A single month answers whether you made money; twelve rows answer whether the business is getting healthier or just busier.

At the end of the year those same rows add up to an annual profit and loss, which is most of what an accountant wants at tax time anyway. One small monthly habit quietly does your year-end for you.

Please do not be hard on yourself if the first honest margin looks thin. A clear number you can act on beats a flattering one you cannot.

🚧 Mistakes to sidestep

• Reading revenue as profit. Fix it: always look to the net line, never the top line.
• Leaving out your own wage. Fix it: add it as a cost so the margin is honest.
• Tracking dollars but not margin. Fix it: watch the percentage trend month on month.
• Mixing cost of goods with operating costs. Fix it: keep them separate so gross and net both make sense.

The P&L is one tool inside a bigger picture, and the small business budget template that surrounds the P&L shows how it sits alongside cash flow and tax.

🎯 Your action steps this week

• Set up the five P&L lines in a fresh tab.
• Fill in last month’s revenue and costs.
• Add a fair wage for yourself as an operating cost.
• Work out your net margin and note it.
• Pair it with a self-employed budget spreadsheet for paying yourself so you are paying yourself properly.

❓ Frequently asked questions

What is a profit and loss spreadsheet?

A profit and loss spreadsheet is a one-page summary of revenue, cost of goods, operating costs and the net profit left at the end. It shows on a single screen whether your business actually made money in a period, which a full budget tends to bury.

What is the difference between revenue and profit?

Revenue is everything that came in before costs; profit is what is left after every cost comes out. Confusing the two is the classic trap, because a busy month with high revenue can still end in a thin or negative profit.

Should I pay myself a wage in the P&L?

Yes, put your own wage in as an operating cost. If you leave it out, the profit you see is really your unpaid labour in disguise, and it makes the business look healthier than it is.

What is a good net margin?

It varies widely by industry, so the useful comparison is your own trend rather than a single benchmark. A margin that climbs month on month means the business is getting healthier; one that slides while revenue grows is a warning to check your pricing and costs.

My friend built her five lines that weekend, added her own wage, and finally understood why her best month had not felt like one. The page does not lie, and that is the point.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.