How to Track Your Small Business P&L Without an Accounting Degree
If you can't answer "how much money did my business make last month" in under 30 seconds, you're flying blind. Here's the simple system that fixes that.
A profit and loss statement sounds like something your accountant deals with at tax time. And yes, they do. But waiting until April to find out whether your business made money last November is like waiting until you run out of gas to check the fuel gauge.
A monthly P&L takes 10 minutes to update and answers the only question that actually matters: is this business making money, and if so, how much?
The Structure
A P&L has three sections: revenue (money in), costs of goods sold (direct costs of what you sell), and expenses (everything else it costs to operate). The math is simple.
Revenue minus cost of goods sold equals gross profit. That's how much money your product or service generates before overhead. Gross margin (gross profit divided by revenue) tells you what percentage of each dollar you keep after direct costs.
Gross profit minus expenses equals net profit. That's what's actually left. Net margin (net profit divided by revenue) is the number that determines whether your business is viable.
Revenue Categories
Break your revenue into 3-5 categories that match how your business actually makes money. A café might use: coffee sales, food sales, merchandise, other. A freelancer might use: project work, retainer clients, consulting, passive income. A gym might use: memberships, personal training, class packs, day passes, merchandise.
Don't over-categorize. Five categories is plenty. The goal is seeing where the money comes from, not building a tax return.
Cost of Goods Sold
COGS are the direct costs of delivering what you sell. For a café: coffee beans, milk, food ingredients, cups, lids. For a freelancer: subcontractor costs, stock assets, printing costs. For a gym: not much — maybe towels and cleaning supplies.
The key distinction: COGS go up when you sell more and down when you sell less. Rent doesn't change if you sell 100 coffees or 1,000. Beans do. Rent is an expense. Beans are COGS.
Expenses
These are your fixed and semi-fixed operating costs: rent, payroll, utilities, insurance, marketing, equipment, software, and a catch-all "other" category. Break these into 5-8 categories that cover your actual spending.
The 10-Minute Monthly Routine
At the end of each month, sit down with your bank statement and your POS reports. Enter the numbers. The formulas calculate the rest.
Total your revenue by category. Total your COGS. Total your expenses. The spreadsheet gives you gross profit, gross margin, net profit, and net margin automatically.
Then look at the result. Is net profit positive? How does gross margin compare to last month? Are any expense categories growing faster than revenue? These are the questions that tell you whether to celebrate, adjust, or panic.
What the Numbers Tell You
A café with a 65% gross margin is healthy. Below 55% means ingredient costs are too high or prices are too low. A freelancer should see 70-90% gross margins since COGS are minimal. A gym typically runs 80%+ gross margins on memberships.
Net margins vary wildly by business type, but as a general rule: above 15% is good, above 20% is excellent, and below 5% means you're working for free after accounting for your own time.
If gross margin is fine but net profit is low, the problem is overhead — too much rent, too many staff hours, or expenses creeping up. If gross margin itself is low, the problem is pricing or product cost.
Start This Month
You don't need QuickBooks. You don't need an accountant (yet). You need a spreadsheet with three sections and 15 minutes per month.
We built a monthly P&L tracker with all the formulas, categories, and margins pre-calculated into both the Notion and spreadsheet versions of our operations packs. The Coffee Shop Pack, Freelance Pack, and Fitness Pack each include a P&L dashboard customized with the revenue and expense categories for that industry. $9 launch price.
But any spreadsheet with Revenue - COGS - Expenses = Profit works. The format doesn't matter. Knowing your numbers does.
Operations in a Box — complete Notion + spreadsheet systems for small businesses. 3 industry packs available. $9 launch price. → ops.andyunpacks.com