A profit and loss statement is not a personality test. It is a short story about money in, money out, and what is left. You do not need a 40-tab workbook to read it — you need a calm view that updates when the bank does.
- Revenue: what landed in the business for the period.
- Expenses by category: where the money went, labeled in language you reuse.
- Net: what remains after ordinary costs — the number owners actually feel.
If you only open a spreadsheet when you are scared, you will only ever see bad news. A running P&L turns fear into a weekly glance.
Start at the bottom, then work up
Many owners jump to revenue because it feels like progress. Start with net instead. If net is thin, ask which expense buckets grew. If net is healthy, check whether revenue is concentrated in one client or one week — concentration is fragile even when the total looks strong.
- Software that renewed annually but was never labeled as software.
- Owner transfers miscategorized as expenses.
- Contractor invoices sitting in Uncategorized for six weeks.
- Seasonal inventory spikes with no note for your future self.
A 12-minute Friday ritual
Open Books. Filter Needs review. Clear the queue. Open the P&L for the current month. Ask one question: does this match how the business felt this week? If freight felt heavy and Freight is quiet, something is mislabeled. Fix it while the week is still fresh.
Membership adds monthly reports and expense summaries when you want a cleaner close package for a licensed pro. Free already shows the running P&L so you are not flying blind between exports.
What a spreadsheet still does well
Scenarios, forecasts, and “what if we hire” models belong in a sheet. Day-to-day categorization and period truth belong in Books. Mixing those jobs is how tabs multiply and trust disappears.
- Use Books for what happened.
- Use a sheet for what might happen.
- Hand a licensed bookkeeper a clean period package — not a maze of macros.
Language that keeps the P&L readable
Name categories like a human will search them next month: Materials, Subcontractors, Software, Meals, Freight, Rent, Draws. Avoid catch-alls like Misc unless you enjoy archaeology. The P&L is only as clear as the labels underneath it.
When the story on the P&L matches the week you lived, you stop dreading the report. That is the point — not prettier charts, just a truthful page you can finish before lunch.
Teach one other person on your team how to read the same P&L page. Shared language beats a hero spreadsheet only one person understands. When both of you can point at Freight and nod, the business gets easier to steer.
