How to Make a Profit and Loss Statement in Google Sheets
Looking for a tool?
A profit and loss statement (also called an income statement) shows your revenue minus your expenses over a period of time, ending in one number: net profit. To build one in Google Sheets, list your revenue, subtract your direct costs to get gross profit, subtract your operating expenses, and the bottom line is your profit. Below is the exact structure, the formulas, and how to read it — free, in Google Sheets or Excel, no accounting software.
What a profit and loss statement actually is
A P&L answers one question: over this month/quarter/year, did the business make money, and where did it go? It's different from a bank balance (that's a snapshot of cash right now) and from a balance sheet (assets vs. liabilities). The P&L is about a period — it's the scoreboard for how the business performed.
The structure, top to bottom
| Line | What it is |
|---|---|
| Revenue (income) | All money earned from sales/services in the period |
| − Cost of goods sold (direct costs) | Materials, product cost, subcontractors — costs tied directly to the work |
| = Gross profit | What's left after the direct cost of delivering |
| − Operating expenses | Overhead: software, marketing, insurance, fees, office, travel |
| = Net profit | The bottom line — your actual profit for the period |
Service businesses with few direct costs can skip the COGS section and go straight from revenue to operating expenses — the bottom line is the same.
Build it in Google Sheets, step by step
Set up a simple sheet with a label column and a number column (add one column per month to compare over time):
- Revenue: pull from your income log with
=SUM(Income!D:D), or type your total. - Cost of goods sold: total your direct-cost rows, e.g.
=SUMIF(Expenses!D:D,"Materials & supplies",Expenses!E:E). - Gross profit:
=Revenue - COGS(point at the two cells). - Operating expenses:
=SUM()of your overhead category totals. - Net profit:
=Gross profit - Operating expenses.
That's the entire statement — five formulas. Because they reference your logs, the P&L updates itself every time you record a sale or an expense.
Add monthly columns to see the trend
Give each month its own column and use a Month helper on your logs
(=TEXT(A2,"YYYY-MM")), then make your SUMIFs month-aware. Now you can see net profit climbing
(or slipping) month over month — the single most useful view a small business owner can have.
How to read your P&L
- Gross margin (gross profit ÷ revenue) tells you whether your pricing covers the cost of delivering. Thin margin here means you're underpricing or overpaying for materials.
- Net profit is what the business actually earned. If revenue is high but net profit is low, your overhead is eating the business — look at operating expenses.
- Net profit is also your tax base. Your self-employed tax set-aside should be a percentage of this number, not your revenue.
Common mistakes
- Counting invoiced-but-unpaid work as revenue. Record revenue when the money arrives, or your profit is fiction.
- Lumping direct costs and overhead together. Keeping them separate is what reveals your gross margin — the most diagnostic number on the page.
- Only doing it once a year. A P&L you update monthly catches problems while you can still fix them.
Quick FAQ
What's the difference between a P&L and a balance sheet?
A profit and loss statement covers a period of time and shows revenue minus expenses (did you make money this month?). A balance sheet is a snapshot of one moment and shows what you own vs. what you owe. Most small businesses live by the P&L.
Can I make a profit and loss statement in Google Sheets for free?
Yes. Google Sheets is free and handles everything a P&L needs — a few SUM and
SUMIF formulas. You don't need accounting software until you have payroll or inventory.
How often should I update my P&L?
Monthly is the sweet spot for a small business. If your income and expenses are logged as they happen, a monthly P&L is essentially automatic and lets you spot trends early.
Do I need accounting software for a profit and loss statement?
No. For most solo and small businesses a spreadsheet P&L is simpler, free, and gives your accountant a clean record. Software earns its place once the business gets genuinely complex.
Keep going: set up the logs that feed this in a small business income and expenses spreadsheet, learn the underlying bookkeeping setup, and pair it with cash flow tracking so you watch both profit and timing.