Income Statement Template | Small Business Profit and Loss Spreadsheet | Excel & Google Sheets, Monthly and Annual, Net Profit and Margins

The income statement template that builds itself — so you finally know your true net profit.

Your bank balance isn't your profit. This Profit & Loss (income statement) spreadsheet turns your sales and costs into a clean, professional statement automatically. Log each sale and expense once on the Entries tab, and the Monthly P&L, Annual Summary and Overview dashboard fill themselves in — revenue, cost of goods sold, gross profit, operating expenses, margins, and the number that actually matters: your net profit, month by month.

No formulas to build. No accounting background needed. Type in the blue cells and read your numbers.

🎥 SEE IT IN ACTION
Watch the full tab-by-tab walkthrough on YouTube: https://youtu.be/Hv0zyREQCbo

WHAT YOU GET — 6 CONNECTED TABS
• Overview — total revenue, expenses, gross & net profit, your margins and your best month, with a "where the money goes" breakdown and a net-profit-by-month chart
• Monthly P&L — the full income statement: Revenue → COGS → Gross Profit → Operating Expenses → Net Profit, every month with a full-year column
• Entries — your one simple ledger; a dropdown tags each row Revenue, COGS or Operating, so the statement sorts itself
• Annual Summary — full-year totals, every line as a % of revenue (a true common-size statement), plus an optional compare-to-last-year column
• Settings — your business name, statement year, and the editable line-item list that feeds every dropdown
• Start Here — a quick guide so you're up and running in minutes

MADE FOR
Small business owners, the self-employed, freelancers, online & Etsy sellers, product and service businesses, side hustles, and anyone who needs a real profit and loss statement for planning, taxes, or a loan or grant application.

WHY THIS ONE
Works in Excel and Google Sheets (no subscription), auto-calculates gross and net profit and margins the moment you type, and lays out Revenue, Cost of Goods Sold and Operating Expenses the way a proper income statement should. Comes filled with sample data so you can see exactly how it works, then clear it in seconds.

HOW IT WORKS
Open in Excel or upload to Google Sheets → set your business name and year → log sales and costs on the Entries tab; every report fills itself in.

INSTANT DOWNLOAD
Your files are ready the moment your payment clears — nothing is shipped. Because this is a digital product, all sales are final, but if anything isn't clear just message me and I'll help.

Organizes your books; not tax, legal or accounting advice.