How to Build a Profit & Loss Statement in Google Sheets

A Profit & Loss statement (P&L) tells you whether your business made or lost money over a period of time. Bankers require them for loans. Accountants need them for taxes. And you need them to understand whether you’re actually building a profitable business.

The good news: you don’t need QuickBooks to make one. A clean Google Sheets P&L will satisfy most lenders, accountants, and your own financial visibility needs.

What a P&L Actually Shows

A P&L has three sections:

1. Revenue — all the money your business brought in
2. Cost of Goods Sold (COGS) — direct costs to produce what you sell
3. Operating Expenses — indirect costs to run the business

The math: Revenue − COGS = Gross Profit, then Gross Profit − Operating Expenses = Net Profit (or Loss)

That final number — net profit or loss — is the one that matters most.

Setting Up Your Google Sheet

Step 1: Create the Header

Start in cell A1. Set up a simple header structure:

Row 1:  [Business Name] — Profit & Loss Statement
Row 2:  Period: January 1, 2025 – December 31, 2025
Row 3:  (blank)
Row 4:  Category | Amount

Format row 4 as bold. This creates a clean two-column layout that’s easy to read and scan.

Step 2: Revenue Section

Starting in row 5:

REVENUE
  Product Sales          $___
  Service Revenue        $___
  Other Income           $___
TOTAL REVENUE            =SUM(above)

Tip: If you have multiple revenue streams, list each separately. This lets you see which part of the business is actually growing.

Step 3: Cost of Goods Sold

Directly below Total Revenue:

COST OF GOODS SOLD
  Materials / Inventory    $___
  Direct Labor             $___
  Shipping / Fulfillment   $___
TOTAL COGS                 =SUM(above)

GROSS PROFIT               =Total Revenue - Total COGS

What belongs in COGS vs. expenses? COGS = costs that exist only because you made a sale. If you sell custom mugs, the blank mug is COGS. Your internet bill is an operating expense.

Service businesses often have little or no COGS — if that’s you, you can simplify and skip this section.

Step 4: Operating Expenses

OPERATING EXPENSES
  Rent / Lease             $___
  Payroll / Wages          $___
  Software & Subscriptions $___
  Marketing & Advertising  $___
  Professional Services    $___
  Insurance                $___
  Utilities                $___
  Mileage / Travel         $___
  Office Supplies          $___
  Miscellaneous            $___
TOTAL OPERATING EXPENSES   =SUM(above)

Be specific with your categories. Lumping everything into “miscellaneous” defeats the purpose — you want to see where the money actually goes.

Step 5: Net Profit

NET PROFIT (LOSS)          =Gross Profit - Total Operating Expenses

Format this row with a bold border and a conditional fill: green if positive, red if negative. In Google Sheets:

• Select the cell → Format → Conditional formatting
• “Greater than 0” → green fill
• “Less than 0” → red fill

Step 6: Format for Readability

A few formatting moves that make this look professional:

• Bold all section headers (REVENUE, COGS, OPERATING EXPENSES)
• Add a thin border above each Total row
• Right-align the number column and format as currency ($)
• Shade alternating rows lightly — makes it much easier to read across the sheet
• Add the period date at the top — this matters when you’re generating monthly P&Ls

Monthly vs. Annual P&L

The template above works for a single period. For ongoing business management, set up a monthly P&L tab for each month and a YTD summary tab that pulls totals from each month.

In the YTD tab, use =SheetName!CellRef to pull the Net Profit from each monthly tab into a running annual view. This lets you compare January vs. March vs. September at a glance — and spot seasonal patterns.

What to Do With Your P&L

Once you have a P&L, use it to answer these questions monthly:

Is gross margin healthy? Gross profit ÷ revenue should be above 50% for most service businesses, 30%+ for most product businesses. If it’s lower, your pricing or costs need attention.

Which expense category is growing fastest? Compare this month to 3 months ago. Unexpected spikes in any category warrant investigation.

Is net profit positive? If yes, great — but is it growing? If no, which expense category would have the biggest impact if reduced?

Frequently Asked Questions

Do I need separate tabs for each month? Yes, if you want to track trends over time. A single annual P&L is fine for tax purposes, but monthly tabs give you operational visibility that’s far more useful.

What’s the difference between a P&L and a cash flow statement? A P&L shows profitability (revenue minus expenses) regardless of when cash changes hands. A cash flow statement shows actual money moving in and out of your bank account. A business can be profitable on paper but cash-flow negative — which is why you need both.

Should owner draws appear on the P&L? Owner draws (distributions) generally don’t appear on a P&L — they’re balance sheet items. However, if you pay yourself a salary (as an S-Corp, for example), that salary appears under payroll in operating expenses.

My accountant wants a P&L — is this format acceptable? This basic format is acceptable for most accountants. If your accountant needs a specific format (like GAAP-compliant statements for a loan), ask them to share a template and populate your numbers into their preferred structure.