The short version: An income statement in a spreadsheet is just three sections stacked on top of each other, revenue, costs, and expenses, with subtractions between them until you land on profit, and you can build a working one in under an hour with nothing fancier than Google Sheets and the SUM function. The bit nobody tells you is that the spreadsheet will only tell you the truth if you’re brutally consistent about what counts as revenue and when, and most people aren’t.
Why I built mine on a Tuesday night, two years too late
I went five years without a proper income statement for my own business. Not because I didn’t know how to build one, I’ve built them for clients for two decades, but because I was avoiding what it would tell me. When I finally sat down and built one in Google Sheets in fifty minutes, it showed me that my speaking income was running at roughly 55% margin after travel and prep time, and my digital course income, which I’d been proudly telling people about, was break-even once I counted my own hours.
That’s the thing about an income statement. It doesn’t care how the business feels. It only cares what the numbers say. And once you build one, you can’t unsee what it shows you.
What an income statement is, in plain terms
An income statement, sometimes called a profit and loss statement or P&L, is a summary of what came in, what went out, and what’s left over, over a specific period. Usually a month, a quarter, or a year. It’s different from a balance sheet, which is a snapshot of what you own and owe on a single date, and different from a cash flow statement, which tracks actual cash moving in and out.
An income statement has three main blocks:
- Revenue, everything you earned, before any costs are taken out
- Cost of goods sold (COGS), the direct costs of delivering what you sold
- Operating expenses, everything else it costs to run the business
Subtract COGS from revenue and you get gross profit. Subtract operating expenses from gross profit and you get net profit, or net loss if the number goes negative. That’s the whole structure. Everything else is detail.
Step by step: building it in Google Sheets or Excel
Here’s exactly how I build one, using real row and column references so you can copy this straight into your own sheet.
Step 1: Set up your columns
Column A is your line item labels. Columns B onward are your time periods, Jan, Feb, Mar, or Q1, Q2, Q3, Q4, or just “This Month” if you’re only tracking one period for now. I’d always recommend monthly columns even if you only look at them quarterly, because monthly detail catches problems faster.
Step 2: List your revenue lines
Don’t lump everything into one “sales” row. Break it out by source. For my own business that looks like:
- Row 3: Speaking fees
- Row 4: Consulting retainers
- Row 5: Course sales
- Row 6: Affiliate income
Row 7 is Total Revenue, using the formula =SUM(B3:B6). This matters more than people think. If you lump everything together you lose the ability to see which part of the business is working, and I’ve written before about how many passive income ideas that work for beginners look great in a bank statement but terrible once you separate them out and see the real hourly return.
Step 3: List your cost of goods sold
These are costs that scale directly with what you sell. For a physical product, that’s materials and manufacturing. For a service business like mine, it’s things like payment processing fees on course sales, contractor fees for a specific project, or printing costs for a specific event.
- Row 9: Payment processing fees
- Row 10: Contractor delivery costs
- Row 11: Total COGS, =SUM(B9:B10)
Row 13: Gross Profit, =B7-B11
Step 4: List your operating expenses
Everything that keeps the lights on regardless of how much you sold that month.
- Row 15: Software subscriptions
- Row 16: Website and hosting
- Row 17: Marketing and ads
- Row 18: Insurance
- Row 19: Admin and bookkeeping
- Row 20: Total Operating Expenses, =SUM(B15:B19)
Step 5: Calculate net profit
Row 22: Net Profit, =B13-B20
That single number is what most people rush to look at first, and it’s the least useful number on the whole sheet without the rows above it. A net profit of two thousand pounds means something completely different if revenue was three thousand versus if it was thirty thousand.
Step 6: Add margin percentages
This is the step almost everyone skips, and it’s the one that changes decisions. Add a column that shows gross margin as a percentage: =B13/B7, formatted as a percentage. Do the same for net margin: =B22/B7. When I did this for my own business, the speaking income showed a 55% margin. The course income showed 4%. Same revenue column, wildly different story, and you’d never see it just by looking at the pound figures.
The real example: what my first honest income statement showed me
Back in 2023, when I was rebuilding my business publicly after five rough years, I built a spreadsheet income statement for the previous twelve months using bank statements and invoices. It took me an afternoon, not the hour it takes now that I have the template, because I had to go back through everything.
Revenue for the year came to just under 140,000 pounds across speaking, consulting, and courses. Total operating expenses came to 38,000 pounds. On paper, a decent year. But when I broke it down by line, consulting retainers were carrying almost everything. Speaking was profitable but sporadic. And the course business, which I’d spent the most hours on, had made 9,000 pounds in sales against nearly 8,600 pounds in ad spend, tech costs, and contractor design fees. A margin of under 5%, for the thing I’d been telling myself was my future.
That spreadsheet is the reason I killed that course and doubled down on consulting instead. I’ve written the full story of what happened to my income once I made that call in I Let Everything Go. Five Months Later, My Passive Income Is Up 573%, and none of that decision happens without a spreadsheet showing me the ugly truth in black and white.
The uncomfortable bit nobody mentions
Here’s what most guides on this topic won’t say plainly. An income statement is only as honest as your definition of revenue, and most small business owners quietly fudge that definition without realising it.
Do you count revenue when you invoice it, or when it lands in your bank account? Do you count a client’s deposit for a project that hasn’t started yet? Do you count a refund in the month you gave it, or subtract it from the month you originally recorded the sale? These aren’t small technicalities. I’ve seen freelancers show a “great month” on their income statement purely because three invoices happened to clear in the same thirty days, with nothing to do with actual business performance. Pick one method, cash basis (count it when the money moves) or accrual basis (count it when it’s earned, regardless of when it’s paid), write it at the top of your sheet, and never switch between them depending on which one makes the month look better. That temptation is real and it’s the single biggest reason DIY income statements end up lying to the person who built them.
The second uncomfortable truth is that a profitable income statement doesn’t mean you have money in the bank. Profit and cash are not the same thing, and plenty of businesses look great on the P&L while the owner can’t pay themselves that month because money is tied up in unpaid invoices or prepaid expenses. If you want to see the cash side of the picture as well, pairing your income statement with a proper household budget spreadsheet that works for your personal finances, or a monthly budget built in an Excel template for the business side, gives you the cash flow view the income statement deliberately leaves out.
Formatting choices that make it usable, not just accurate
A technically correct income statement that nobody reads is worthless. A few formatting habits make the difference:
- Bold every subtotal row (Total Revenue, Gross Profit, Total Operating Expenses, Net Profit) so your eye finds them instantly
- Use negative number formatting in red or brackets for expenses, so a loss month is visually obvious, not just a small font difference
- Freeze the top row and the label column so long sheets stay readable when you scroll
- Add a simple year-to-date column at the far right, =SUM of the monthly columns, so you’re not doing mental maths every time someone asks how the year is going
- Keep a separate tab for the raw transaction data and only bring totals into the income statement tab, so one messy import doesn’t break your formulas
What to do once the spreadsheet exists
Building it is the easy part. The habit that pays off is opening it monthly, not quarterly, and asking three questions every single time: which revenue line grew or shrank and why, which expense line crept up without me noticing, and what’s my net margin doing compared to three months ago. I set a recurring reminder on the first Monday of every month. It takes fifteen minutes once the sheet exists, and it’s caught things for me that would otherwise have taken six months to notice, like a software subscription I’d forgotten to cancel that had quietly cost me 840 pounds over a year.
If you’re running several income streams and trying to work out which ones deserve more of your time, this is also the moment to revisit what passive income means for your situation. I go into that in What Is Passive Income and What Does It Mean for You, because the income statement will show you margin, but it won’t tell you how many hours you personally poured in to earn it, and that’s a separate conversation you need to have with yourself.
A simple template you can copy right now
If you want the bare bones version to start from today, here’s the row structure in order:
- Total Revenue (with sub-lines by source above it)
- Cost of Goods Sold (with sub-lines above it)
- Gross Profit
- Gross Margin %
- Operating Expenses (with sub-lines above it)
- Net Profit
- Net Margin %
Seven rows, once you’re done. Everything above them is just supporting detail. Build that structure once in Google Sheets, save it as a template, and every future month is copy, paste, update the numbers.
Frequently asked questions
What’s the difference between an income statement and a profit and loss statement?
Nothing. They’re the same document, just two names for it. Accountants tend to say income statement in formal reporting and small business owners tend to say P&L in everyday conversation, but the structure, revenue minus costs minus expenses equals net profit, is identical either way.
Can I build an income statement without accounting software?
Yes, entirely. A spreadsheet with SUM and subtraction formulas does exactly the same job as software for a small or single-owner business, and it’s often clearer because you built it yourself and know exactly what every row means. Software becomes more useful once you have employees, inventory, or multiple bank accounts to reconcile automatically.
How often should I update my income statement?
Monthly, at minimum. Quarterly is common in bigger businesses but for a small business or solo operator, a month is short enough to catch a problem early and long enough to see a real trend, rather than reacting to a single good or bad week.
Why does my spreadsheet show a profit but I have no cash?
Because profit and cash are different things. Your income statement might count revenue the moment you invoice it, even if the client hasn’t paid yet, and it might not show a large expense like a tax bill or loan repayment if that’s tracked separately. To see actual cash in hand, you need a cash flow view alongside your income statement, not instead of it.
Further reading
Related reading: How to Plan a Project Timeline Using a Spreadsheet Template and How to Write an Objective Statement for Your Resume.
