SheetMaster Hub

by Healora Studio

Profit and Loss Statement | Free Excel & Google Sheets Template [2026]

Table of Contents

You deposited $48,000 last quarter. Was the business actually profitable? Without a structured P&L, the honest answer is that you do not know. Revenue in your bank account feels like profit until you subtract materials, contractor invoices, software, insurance, and the tax bill you have not set aside.

The fixed answer is a properly ordered income statement: revenue, cost of goods sold, gross profit, operating expenses, operating income, other items, net profit. That order tells you where money is made or lost, which a single lump of expenses never will.

The Profit and Loss Statement template from SheetMaster Hub gives you that structure as a 12-month grid, with gross profit and operating income calculated, a Net Profit Margin % row, and a Trends sheet that charts revenue, expenses, and net profit together. This guide builds the whole statement step by step so you understand every formula.

[Insert Real Screenshot Here: The ‘Profit & Loss’ sheet showing the REVENUE block at top, the calculated GROSS PROFIT line, the OPERATING EXPENSES block, and the NET PROFIT and Net Profit Margin % rows at the bottom]

📥 Download the Profit and Loss Statement Template Stop building from scratch. The complete 12-month P&L — revenue through net profit, with gross profit, operating income, and net profit margin calculated for you — is ready to use in Excel or Google Sheets. Download Free Template (.xlsx)

Tested by our data analysts at Healora Studio. Every formula in this template was built and verified in Excel 365 and Google Sheets before release.

The Standard P&L Structure, Explained

An income statement reads top to bottom in a deliberate sequence:

Line What it measures Why it matters
Revenue Money earned from selling Sets the scale of the business
Cost of Goods Sold Direct cost of delivering Separates delivery cost from overhead
Gross Profit Revenue − COGS Tests whether pricing works at all
Operating Expenses Overhead to run the business Shows what growth costs you
Operating Income Gross profit − opex Profit from core operations only
Other Income/Expense Interest, depreciation, taxes Non-operating items
Net Profit The bottom line What is actually left

Step 1: Build the Grid and Section Skeleton

Create a sheet named Profit & Loss.

  • Column B — line item labels.
  • Columns C–N — Jan through Dec in row 4.
  • Column O — Year Total.

Type Jan in C4, drag right to N4, and add Year Total in O4. Block out the section headers in column B in bold caps: REVENUE, COST OF GOODS SOLD, OPERATING EXPENSES, OTHER, then freeze panes at C5 with View > Freeze Panes. Setting the skeleton first prevents burying an expense in the wrong block and misreading your margins all year.

Step 2: Enter the Revenue Block

Under REVENUE, add three lines: product sales, service revenue, and other revenue. Enter monthly figures as positive numbers. Below the block, add a bold Total Revenue row and use Alt + = (AutoSum) in the January column, then drag right — AutoSum reads the contiguous block above and writes the range for you.

Step 3: Enter Cost of Goods Sold and Calculate Gross Profit

COGS holds the direct costs of delivering what you sold: materials and inventory, direct labor, and shipping and fulfillment. Enter them as positive numbers — the statement subtracts them at the gross profit line. Add Total COGS with the same =SUM(...) pattern, then beneath it:

Gross Profit = Total Revenue − Total COGS

In cell terms: =C10-C14 — click the Total Revenue cell, type -, then click Total COGS.

Pro Tip from Healora Studio Analysts: Watch this one number more than any other. If gross profit percentage falls while revenue climbs, your pricing or supplier costs have broken, and no amount of marketing spend fixes it.

Step 4: Structure Operating Expenses with SUBTOTAL

Operating expenses are everything needed to run the business that is not a direct delivery cost:

  • Payroll and contractors
  • Rent and utilities
  • Software and subscriptions
  • Marketing and advertising
  • Professional fees
  • Insurance
  • Travel
  • Other operating expenses

Type each as a positive number. For Total Operating Expenses, use SUBTOTAL rather than plain SUM, found at Formulas > Math & Trig > SUBTOTAL with function number 9:

=SUBTOTAL(9,C20:C27)

Why SUBTOTAL? Function 9 (or 109 for “ignore hidden rows”) excludes rows hidden by an AutoFilter. Filter the sheet to review only marketing spend and a SUBTOTAL total recalculates to the visible rows, while a plain SUM keeps reporting everything.

Step 5: Calculate Operating Income

Operating income is profit from core operations, before interest and taxes:

=C16-C28

Step 6: Add the OTHER Section and Net Profit

Under OTHER, add interest expense, interest income, depreciation, and taxes. Enter interest income as a positive number and the other three as negatives so the sum behaves correctly. Total them with =SUM(...), then close the statement:

NET PROFIT = Operating Income + Total Other

=C30+C37

Format OPERATING INCOME and NET PROFIT in bold with a top border — accountants call that a single rule, and it marks a final figure.

Step 7: Add the Net Profit Margin % Row

The final row converts profit into a percentage so months of different sizes can be compared:

=IFERROR(C38/C10,0)

That is Net Profit divided by Total Revenue, with IFERROR returning zero for a month with no revenue rather than #DIV/0!. Format the row as a percentage with one decimal place: a 12% margin in a quiet January and a 12% margin in a busy November mean the same thing operationally.

Add a sheet named Trends and reference the P&L directly:

  • Total Revenue → ='Profit & Loss'!C10
  • Total Expenses → ='Profit & Loss'!C14+'Profit & Loss'!C28+'Profit & Loss'!C37
  • Net Profit → ='Profit & Loss'!C38

Lay the months down column A with those three rows beneath, then select the range and insert a line chart via Insert > Charts > Line. Add markers and label the vertical axis in currency.

Pro Tip from Healora Studio Analysts: Chart revenue, expenses, and net profit on the same axes. The gap that opens between the revenue and expense lines is your profit, so a margin squeeze becomes visible months before the net profit line turns negative.

Template Features

  • ✅ Three sheets: Instructions, Profit & Loss, Trends
  • ✅ 12-month grid (Jan–Dec) with a Year Total column
  • ✅ REVENUE section: product sales, service revenue, other revenue
  • ✅ COST OF GOODS SOLD section: materials and inventory, direct labor, shipping and fulfillment
  • ✅ Calculated Total Revenue, Total COGS, and GROSS PROFIT rows
  • ✅ OPERATING EXPENSES section: payroll and contractors, rent and utilities, software and subscriptions, marketing and advertising, professional fees, insurance, travel, other operating expenses
  • ✅ Calculated Total Operating Expenses and OPERATING INCOME rows
  • ✅ OTHER section: interest expense, interest income, depreciation, and taxes, with a Total Other row
  • ✅ Calculated NET PROFIT row and a Net Profit Margin % row
  • ✅ Trends sheet with revenue, total expenses, and net profit per month plus a line chart
  • ✅ Excel and Google Sheets compatible

When to Upgrade from Excel

The spreadsheet is right for planning, modelling, and analysis. It stops being right when you need bookkeeping automation, live bank reconciliation, or multi-entity consolidation.

QuickBooks Online — handles transaction entry, bank feeds, and generates a P&L from live data on demand. Plans begin around $30/month (Simple Start) and scale to roughly $115/month for Plus with inventory and project tracking. [Affiliate Link: QuickBooks Online accounting plans]

Xero — unlimited users on every plan and strong reporting for service businesses with international clients. Entry pricing sits around $20–$40/month by region and tier. [Affiliate Link: Xero small business accounting]

Fathom — imports from QuickBooks or Xero and turns your P&L into board-ready dashboards with multi-year comparisons. Pricing starts near $44/month for the smallest tier. [Affiliate Link: Fathom management reporting]

FAQ

What is the difference between gross profit and net profit? Gross profit is revenue minus the direct cost of delivering what you sold. Net profit is what remains after operating expenses, interest, depreciation, and taxes. A business can post strong gross profit and negative net profit if overhead is too heavy.

Where does owner’s salary go on a P&L? For a sole proprietor, owner draws are not a business expense and belong outside the P&L. If the business is an S-corp and the owner is on payroll, the salary appears under payroll and contractors within Operating Expenses.

Should I enter COGS as a negative number? No. Enter COGS and operating expenses as positive numbers and let the calculated lines subtract them. Mixed sign conventions are the most common source of broken P&L templates.

Get the Template

Download the free Profit and Loss Statement template (.xlsx), enter one month of real numbers, and read your gross margin before you enter the second. The structure will tell you something your bank balance cannot.

This tutorial and template are part of SheetMaster Hub by Healora Studio. For more data efficiency tools, visit healorastudio.com.