How to Create a Profit and Loss Statement in Google Sheets
- Donna Roggio
- Jun 24
- 11 min read
A profit and loss statement in Google Sheets is a simple spreadsheet that lists your business income at the top, your expenses by category in the middle, and a single formula at the bottom subtracting expenses from income to show your net profit or loss. You can build a functional version in about twenty minutes using nothing but SUM() and basic cell references, and it will tell you more about your business than any bank balance ever could.
Your P&L is not a finance professional's secret weapon. It's a one-page answer to the question: did my business make money this month?
If the phrase "profit and loss statement" makes you feel like you should hand the spreadsheet to someone with a finance degree, that reaction is exactly the gap I want to close in this post. A P&L is arithmetic. Income minus expenses. Everything else is formatting.
By the end of this post you'll have built a working profit and loss statement in Google Sheets from a blank file, you'll know the exact formulas to use, you'll have a category structure that actually matches how your business operates, and you'll understand why most business owners eventually outgrow the spreadsheet and what to do when you get there.
What a Profit and Loss Statement Actually Tells You
A P&L (also called an income statement) summarizes your business's financial performance over a specific period, usually a month, a quarter, or a year. It answers three questions in one document: how much money came in, how much money went out, and what was left over.
The structure is the same whether you're a one-person consultancy or a Fortune 500. Income at the top. Cost of goods sold (if applicable). Operating expenses. Net profit or loss at the bottom. The numbers get bigger, the categories get more granular, the auditors get more involved, but the bones don't change.
According to data from the U.S. Bureau of Labor Statistics, roughly 20% of new businesses fail within the first year and about half are gone by year five. A meaningful share of those closures trace back to owners who couldn't tell you, in any given month, whether their business was actually profitable. A P&L answers that question on one screen.
Why Google Sheets Is the Right Tool to Start With
You don't need QuickBooks to build a P&L. You don't need an accountant. You don't need a course. You need a free spreadsheet and an honest list of what came in and what went out.
Google Sheets wins as the starting tool for four practical reasons. It's free. It lives in the cloud, so you can update it from a laptop, a phone, or while waiting in a car line. It shares cleanly with a CPA or bookkeeper without exporting anything. And the formulas you learn here transfer directly to Excel, Numbers, or any accounting software you graduate into later.
The trade-off is that you have to enter the data yourself, which is a feature, not a bug. Manual entry forces you to actually look at your numbers, which is the whole point. (If categorizing transactions is where you usually get stuck, our guide to business expense categories is the right companion read.)
Before You Build: What You'll Need
Pull these three things together before you open Sheets. It will save you an hour of bouncing between tabs.
A list of every business bank and credit card account, with statements or downloaded CSVs covering the period you want to track (start with one month if you're new to this).
A rough category list of how you spend. Software, contractors, marketing, professional fees, equipment, travel, meals, office supplies. Don't agonize over it. You'll refine as you go.
A clear separation between business and personal money. If your accounts are mixed, the P&L will be wrong before you start. If this is your situation, pause here and work through how to separate business and personal finances first. The P&L will still be here when you're ready.
How to Build a Profit and Loss Statement in Google Sheets, Step by Step
Open a new Google Sheet and follow these steps in order. The whole build takes about twenty minutes the first time and five minutes every month after.
Step 1: Set Up the Header
In cell A1, type your business name. In A2, type "Profit and Loss Statement." In A3, type the period (for example, "June 1 to June 30, 2026"). Bold these three rows and bump the font size on A1 to 16. This header is what makes the document look like a real financial statement when you send it to a CPA.
Step 2: Build the Income Section
In row 5, type "INCOME" in cell A5 and bold it. Starting in row 6, list each income source in column A and the amount in column B. For a service business, that might be client payments by client name. For a product business, that might be sales by channel (Shopify, Etsy, wholesale). Keep it simple: one line per meaningful source.
After your last income row, leave a blank row, then in column A type "Total Income." In the adjacent column B cell, enter the formula =SUM(B6:B[lastrow]), where [lastrow] is the row number of your final income line. Bold the total row.
Step 3: Build the Expense Section
Skip two rows, then type "EXPENSES" in column A and bold it. List each expense category on its own row. A solid starter list for a service business looks like this: software and subscriptions, contractors and freelancers, marketing and advertising, professional fees (legal, accounting), education and professional development, office supplies and equipment, travel and transportation, meals (business), bank and merchant fees, insurance, and other.
Enter the total spent in each category for the period in column B. Pull these numbers from your bank and credit card statements, not from memory. If you've never categorized transactions before, our walkthrough on tracking where your money goes covers the mechanics.
After your last expense row, leave a blank row, then in column A type "Total Expenses." In column B, enter =SUM(B[firstexpense]:B[lastexpense]).
Step 4: Add the Net Profit Formula
Skip two rows. In column A type "NET PROFIT (LOSS)." In the adjacent column B cell, enter:
=B[totalincome] - B[totalexpenses]
So if your Total Income cell is B10 and Total Expenses is B24, the formula is =B10-B24. Bold this row, increase the font size to 14, and apply conditional formatting so positive numbers turn green and negative numbers turn red. (Format menu → Conditional formatting → Format cells if less than 0 → red; greater than 0 → green.)
That's it. That's a working profit and loss statement.
Step 5: Format So It Looks Like a Real Statement
Select column B and format the cells as Currency (Format → Number → Currency). Add a thin border under each section total. Adjust column widths so nothing is cut off. Freeze the top three rows so your header stays visible as you scroll (View → Freeze → 3 rows).
When you're ready to send to an accountant, File → Download → PDF, and you've got a professional-looking statement.
A Visual Walkthrough of the Layout
Here's what the finished structure looks like, with example numbers for a small service business in a single month.
Row | Column A | Column B |
1 | Donna Roggio LLC | |
2 | Profit and Loss Statement | |
3 | June 1 to June 30, 2026 | |
5 | INCOME | |
6 | Client retainers | $8,400 |
7 | Project work | $3,200 |
8 | Course sales | $950 |
10 | Total Income | $12,550 |
12 | EXPENSES | |
13 | Software and subscriptions | $487 |
14 | Contractors | $2,100 |
15 | Marketing and advertising | $640 |
16 | Professional fees | $350 |
17 | Education | $197 |
18 | Office supplies | $84 |
19 | Travel | $312 |
20 | Meals | $76 |
21 | Bank and merchant fees | $148 |
22 | Insurance | $220 |
24 | Total Expenses | $4,614 |
26 | NET PROFIT (LOSS) | $7,936 |
You can copy this exact structure into your own sheet, swap the numbers, and you're done. The format is intentionally boring. Boring is what makes a financial statement readable.
Where Most DIY Profit and Loss Statements Go Wrong
Building the spreadsheet is the easy part. The places where DIY P&Ls fall apart are predictable, and most of them happen at the data layer, not the formula layer.
Counting credit card payments as expenses. The expense happened when you swiped the card. The payment to the credit card company is just moving money between accounts. Counting both double-counts the expense. (We have a whole post on this exact mistake, and it's the single most common error I see.)
Mixing personal expenses into business categories. Your gym membership is not "professional development." Your grocery run after a client meeting is not "business meals." This is where audits get ugly. (This is educational, not tax advice. Consult a CPA or Enrolled Agent for your specific situation.)
Forgetting to record owner pay correctly. Money you take out of the business as an owner is typically not an expense on a P&L (it's a draw or distribution, depending on your entity). Recording owner pay as an expense will artificially shrink your profit and confuse your tax preparer. Our guide on how to pay yourself as a business owner covers this in depth.
Using inconsistent categories month to month. If June's category is "Marketing" and July's is "Advertising" and August's is "Promo," you cannot compare across months. Lock your categories on day one.
Pulling numbers from memory. Every category total comes from a statement, not a guess. If you can't reconcile the spreadsheet to a real account balance, the P&L isn't done.
What a P&L Can't Tell You (and Why It Eventually Stops Being Enough)
A profit and loss statement is a snapshot. It's powerful precisely because it's simple. But that simplicity is also its ceiling.
A P&L tells you that you made $7,936 in June. It doesn't tell you which clients drove that profit, which services had the highest margin, which expense categories are quietly creeping up month over month, which months are pulling more weight than you realized, or which line items are subsidizing others. It doesn't tell you why one quarter was strong and the next one wasn't. It doesn't connect business performance to your personal financial picture, which is where most owner decisions actually live.
After three or four months of running a manual spreadsheet, most business owners hit the same wall. The numbers are clear. The decisions still aren't. That's not a spreadsheet problem. That's an analysis problem, and it's exactly why I built what comes next.
How Money Mastery Replaces This Spreadsheet Entirely
I want to be honest with you. The Google Sheets build above will work. Plenty of business owners run their numbers this way and do fine. But the reason I built Money Mastery is that for most women running a business, the spreadsheet isn't the bottleneck. The questions underneath the spreadsheet are.
Money Mastery generates detailed income reports, expense reports, and full profit and loss statements automatically from the data you're already entering during your weekly fifteen-minute review. There's no rebuilding the structure every month. There's no auditing your own formulas. The reports are formatted to send directly to your accountant or CPA from inside the system, which means tax season stops being a three-weekend catch-up project and becomes a five-minute handoff.
Where it goes beyond the spreadsheet is in the prompts. Each report comes with a layered set of questions designed to get to the heart of what's actually making your business profitable. Which clients have the highest margin. Which expense categories are quietly creeping up. Which months are pulling more weight than you realized. Which services are subsidizing other services. Whether your busiest month is actually your most profitable month (it usually isn't). A Google Sheet shows you that you made $7,936 in June. Money Mastery shows you which $7,936 you made, why, and what to do more of.
You can also run the same report structure on your personal life. The same engine that produces a business P&L will produce a personal income and spending report, which is where most owners realize the line between "business profitable" and "personally paid" was blurrier than they thought. Putting both reports next to each other once a quarter is one of the highest-leverage exercises I do with private clients, and it isn't something a spreadsheet can give you no matter how clean your formulas are.
If you've ever sat in front of a finished P&L thinking "okay, but now what," that's the gap Money Mastery closes. The spreadsheet is the data. The prompts are the decision.
Explore the full Money Mastery system at https://moneymastery-system.com/welcome. It includes the business P&L engine, the personal report engine, the weekly review structure, and the prompt library that turns reports into actual decisions.
How to Use Your P&L Once You Have It
A P&L only matters if it changes a decision. Whether you stay on the spreadsheet or graduate into Money Mastery, here's how to actually use the document.
Run it monthly, on the same day each month. The first business day works for most owners. Consistency is what creates pattern recognition.
Compare side by side. Once you have three months of P&Ls, lay them next to each other. Income trends, expense creep, and seasonality become obvious in a way no single month can show. (Our post on how to read a profit and loss statement walks through exactly what to look for.)
Ask one question per month. Resist the urge to overhaul everything when you see the first report. Pick one line that surprised you and investigate that one. Maybe it's a software category that doubled. Maybe it's a client that takes more time than they pay for. One question per month compounds.
Send it to your accountant quarterly, not annually. A CPA who sees your numbers four times a year will save you more in taxes than one who sees them once. The quarterly P&L is the document that makes that possible.
Your Next Step
You don't need to build the perfect spreadsheet tonight. You need to build a working one this week. Open a blank Google Sheet, put your business name at the top, and enter last month's numbers. Even if the categories are messy. Even if you're not sure where one expense belongs. The first imperfect P&L teaches you more than the tenth perfect one you keep meaning to start.
Once you have a month under your belt and you start hitting the wall the spreadsheet was never designed to break through, the door to Money Mastery is open.
Explore the full system here: https://moneymastery-system.com/welcome
Frequently Asked Questions
How do I create a profit and loss statement in Google Sheets?
Open a new Google Sheet, type your business name and the statement period at the top, then create three sections: Income (list each revenue source with a SUM total), Expenses (list each category with a SUM total), and Net Profit (a single formula subtracting total expenses from total income). Format column B as currency and apply conditional formatting to the net profit cell so positive numbers show green and negatives show red. The full build takes about twenty minutes the first time and five minutes each month after.
What categories should I include on a small business P&L?
Start with eleven categories that cover most service-based businesses: software and subscriptions, contractors, marketing and advertising, professional fees, education, office supplies, travel, business meals, bank and merchant fees, insurance, and other. Product businesses should add cost of goods sold above operating expenses. The exact list matters less than consistency. Whatever categories you choose in month one, use the same ones in month two so you can actually compare across periods.
Is Google Sheets good enough for a real business P&L?
For the first six to twelve months of a business, or for owners who want to understand their numbers from the ground up, Google Sheets is more than enough. It's free, shareable with an accountant, and forces you to actually look at your data. The limitations show up once you need cross-month analysis, margin by client, automated categorization, or reports you can hand off without rebuilding from scratch. That's the point where most owners move into a system like Money Mastery.
What's the difference between a P&L and a cash flow statement?
A profit and loss statement shows whether your business made money over a period (income minus expenses). A cash flow statement shows when money actually moved in and out of your accounts. The two can disagree dramatically: a business can be profitable on paper while running out of cash, or hold healthy cash while losing money each month. New business owners usually start with the P&L because it's simpler, then add cash flow tracking once revenue becomes more variable.
Can Money Mastery generate a P&L automatically?
Yes. Money Mastery generates detailed profit and loss statements, income reports, and expense reports automatically from the data you enter during your weekly fifteen-minute review. The reports are formatted to send directly to your accountant or CPA, and each one comes with a layered set of prompts designed to surface which clients, services, and categories are actually driving your profit. You can also run the same report structure on your personal finances, which is something a standalone spreadsheet can't replicate.
Comments