Free Profit and Loss Statement Template for Google Sheets [2026]

A profit and loss statement is the most important financial report most small business owners never look at — until a lender, an accountant, or a cash-flow scare forces the question. This guide gives you a free profit and loss statement template for Google Sheets and walks you through exactly how to build, read, and automate a P&L so you always know whether your business is actually making money.

What is a profit and loss statement?

A profit and loss statement — also called a P&L statement or an income statement — is a financial report that adds up your revenue and subtracts your costs and expenses over a period of time to reveal your net profit or net loss. If a balance sheet is a photograph of your finances at one moment, a profit and loss statement is the highlight reel of everything that happened over a month, a quarter, or a year.

Every profit and loss statement answers three questions in order:

1. How much money came in? (revenue)
2. What did it cost to earn that money? (cost of goods sold and expenses)
3. What was left over? (profit — or loss)

That last number, net profit, is the bottom line in the most literal sense: it sits at the bottom of the statement.

Profit and loss statement vs income statement

There is no difference between a profit and loss statement and an income statement. They are two names for the identical report. You will also see "statement of operations" and "P&L" used interchangeably. Accountants lean toward income statement; founders, freelancers, and banks lean toward profit and loss statement. The profit and loss template in this guide works no matter which term your accountant or lender uses.

Profit and loss statement vs balance sheet

These two reports are often confused but answer different questions. A profit and loss statement covers a period and measures profitability. A balance sheet is a snapshot at a single date and measures financial position — what you own (assets), what you owe (liabilities), and what's left for the owner (equity). Most businesses need both, and a profit and loss template is the right starting point because profitability is what keeps the lights on.

Why every small business needs a profit and loss template

You can run a business for a while on gut feel. You cannot scale, borrow, or survive a downturn on it. A profit and loss statement turns "I think we're doing okay" into a number you can act on. Here is what a good P&L template unlocks:

• Pricing decisions. If your gross margin is thin, your prices are too low or your costs are too high. The P&L makes that obvious.
• Tax preparation. A categorized profit and loss statement maps directly to the income and expense lines on a Schedule C or business return.
• Loans and funding. Banks ask self-employed borrowers for a profit and loss statement before approving a mortgage or business loan. A clean, dated P&L is exactly what underwriters want.
• Spotting trouble early. A monthly P&L shows a margin slipping in March instead of a nasty surprise in December.
• Knowing your real take-home. Revenue is vanity; net profit is what you actually earn.

The problem is that most free profit and loss templates are static. You re-type every figure by hand, the formulas break the moment you insert a row, and the statement is always weeks out of date. A profit and loss template is only useful if it stays current — which is the whole point of starting from a well-built sheet (and, ideally, automating the data entry).

What's inside a profit and loss statement

Every complete profit and loss statement is built from the same stack of sections. Understanding them is the difference between filling in a template and actually reading your numbers. Here is the anatomy of a P&L, top to bottom.

1. Revenue (sales / income)

Revenue is the total money your business earned from its core activity before any costs come out. On a profit and loss statement this is the top line, and it can be split into multiple streams — product sales, service income, subscriptions, and so on. Record revenue when it's earned, not necessarily when cash lands, if you use accrual accounting.

2. Cost of goods sold (COGS)

Cost of goods sold is the direct cost of producing what you sold: materials, manufacturing, wholesale product cost, payment processing, or the contractors who deliver a service. COGS does not include rent, software, or marketing — those are operating expenses. Getting COGS right is what makes the next line meaningful.

3. Gross profit

Gross profit = revenue − COGS. This is the money left after the direct cost of delivery, and it's the first true health check on a profit and loss statement. Divide it by revenue and you get gross margin — a percentage you can compare month to month and against your industry. A falling gross margin almost always means a pricing or sourcing problem.

4. Operating expenses

Operating expenses are the indirect costs of running the business regardless of how much you sold — rent, utilities, software subscriptions, marketing and advertising, insurance, professional fees, salaries, and office supplies. A good profit and loss template breaks these into clear categories so you can see where money leaks. These are often listed as SG&A (selling, general, and administrative expenses).

5. Operating profit

Operating profit = gross profit − operating expenses. Also called operating income or EBIT (earnings before interest and taxes), this line shows whether your core business is profitable before financing and tax effects. It's the number investors and lenders scrutinize most, because it strips out one-off and non-operating noise.

6. Net profit (the bottom line)

Net profit = operating profit − interest − taxes − any other expenses + any other income. This is the bottom line: the actual profit or loss for the period. Divide net profit by revenue and you get net profit margin, the single percentage that best summarizes how efficiently your business turns sales into money you keep.

A profit and loss template worth using calculates gross profit, operating profit, net profit, and all three margins for you — across every month and a year-to-date total — so you never compute a subtotal by hand.

How to make a profit and loss statement in Google Sheets

You can build a profit and loss statement from a blank Google Sheet, but you'll spend your time writing SUM ranges and margin formulas instead of reading your numbers. The faster path is to start from a profit and loss template and customize it. Here's the full process either way.

Step 1: Set up your time period and columns

Decide whether you're building a monthly profit and loss statement (recommended for most small businesses) or a quarterly or annual one. In a monthly P&L, create one column per month plus a year-to-date column that sums them. The template in this guide is already laid out this way.

Step 2: List your revenue streams

Add a row for each source of income under a Revenue header, then a Total Revenue row that sums them with =SUM(...). Keep streams separate if you ever want to see which product or service drives the business.

Step 3: Enter cost of goods sold

Under a Cost of Goods Sold header, list each direct cost and total them. Then add your first calculated line — Gross Profit — as Total Revenue − Total COGS.

Step 4: Build out operating expenses

Create a labeled row for every operating expense category — rent, software, marketing, insurance, professional fees, and so on — and sum them into Total Operating Expenses. The more honestly you categorize here, the more useful the statement becomes.

Step 5: Calculate operating profit and net profit

Add Operating Profit as Gross Profit − Total Operating Expenses. Then subtract interest and an estimate for taxes to reach Net Profit. Finally, add margin rows that divide gross, operating, and net profit by revenue and format them as percentages.

Step 6: Keep it current

A profit and loss statement is only as good as how recent it is. Either block 30 minutes at month-end to enter everything by hand, or connect your bank so transactions flow in automatically (more on that below). A live P&L is the one that actually changes decisions.

Profit and loss template: Google Sheets vs Excel

Should you use a profit and loss template in Google Sheets or Excel? Both produce an identical statement — the difference is workflow.

• Google Sheets is free, lives in the cloud, autosaves, keeps full version history, and is trivial to share with an accountant or business partner with a link. It's also what tools like Avery can sync transactions into directly.
• Excel is the standard if your accountant insists on it or you work offline. The good news: this Google Sheets profit and loss template downloads as a fully formatted .xlsx file with the formulas intact (File → Download → Microsoft Excel), so you get a profit and loss template for Excel out of the same source.

For most small businesses and freelancers, a Google Sheets P&L wins on convenience and is the easiest to keep up to date. If you live in spreadsheets already, our Google Sheets bookkeeping guide shows how a P&L fits into a full set of books.

Single-step vs multi-step profit and loss statement

There are two formats for a profit and loss statement, and it helps to know which you're using.

• A single-step P&L lumps all revenue together and all expenses together, then subtracts once: total revenue − total expenses = net profit. It's simple and fine for very small or service-only businesses.
• A multi-step P&L separates COGS from operating expenses, so it shows gross profit and operating profit as distinct lines on the way to net profit. This is the standard for any business that sells products and the format most lenders and investors expect.

The template in this guide is a multi-step profit and loss statement because the extra detail — gross margin and operating margin — is exactly where the useful decisions hide. You can always read it as single-step by focusing only on the bottom line.

How to read your profit and loss statement

Building the statement is half the job; reading it is where the value is. Three margins do most of the work:

• Gross margin (gross profit ÷ revenue) tells you whether your pricing and direct costs are healthy. Track it monthly — a downward trend is an early warning.
• Operating margin (operating profit ÷ revenue) tells you whether your overhead is under control relative to sales.
• Net profit margin (net profit ÷ revenue) is the headline efficiency number — how many cents of every dollar in revenue you actually keep.

The real insight comes from comparing these over time. A single month's profit and loss statement is a data point; twelve months side by side is a story. That's why a monthly layout with a year-to-date column beats a one-off annual P&L — you can see seasonality, catch a creeping expense, and prove a growth trend to a bank.

Common profit and loss statement mistakes to avoid

Even with a good profit and loss template, a few mistakes quietly distort the numbers:

• Mixing COGS with operating expenses. Putting rent in COGS or materials in operating expenses makes gross profit meaningless. Keep direct costs (COGS) separate from overhead.
• Forgetting non-cash and irregular costs. Annual software renewals, depreciation, and quarterly tax payments are easy to omit and they swing net profit.
• Recording revenue when cash arrives instead of when it's earned. If you invoice on terms, accrual timing matters for an accurate monthly P&L.
• Mixing personal and business spending. A single personal charge in the business expenses inflates your costs and understates profit. Use a separate account and a clean expense tracker.
• Letting it go stale. A profit and loss statement updated once a year can't change a decision. The fix is automation.

Profit and loss statement for taxes and loans

Two moments make a P&L non-negotiable.

Taxes. Whether you file a Schedule C as a sole proprietor or a return for an LLC or S-Corp, your tax forms ask for revenue and categorized expenses — which is exactly what a profit and loss statement contains. A well-categorized P&L means transferring totals instead of reconstructing a year of spending in April. Keep receipts and bank records to support every line.

Loans and mortgages. Self-employed borrowers are almost always asked for a current profit and loss statement, often year-to-date plus the prior one or two years. Underwriters use it to verify income that a W-2 would otherwise show. Exporting a clean, dated P&L as a PDF — or sharing the Google Sheet — can be the difference between an approval and a request for "more documentation."

Automate your profit and loss statement with Avery

The single biggest reason profit and loss statements go stale is manual data entry. Nobody wants to spend a Sunday re-typing three months of transactions into categories. That's the gap Avery closes.

Avery connects to your bank and card accounts, pulls in every transaction, categorizes it, and syncs it straight into your Google Sheets — including this profit and loss template. Instead of a month-end data-entry marathon, your revenue and expenses flow in continuously, your gross profit and net profit recalculate on their own, and your P&L is always ready when a lender or an accountant asks.

You keep the familiar spreadsheet. You lose the busywork. And because the statement is genuinely live, you actually look at it — which is the only way a profit and loss statement ever changes how you run the business.

Keep going

• See the template in detail: the Profit & Loss Statement template for Google Sheets.
• Quick answers to specific questions: the profit and loss statement Q&A.
• Build a full set of books: the complete Google Sheets bookkeeping guide.
• Keep costs clean before they hit your P&L with the expense tracker template.