Free profit and loss template (Excel and Google Sheets)

What's inside the template

The file has two sheets, and they do two different jobs.

The "Profit and Loss" sheet is a full statement for a single period, usually a month, a quarter, or a year. It follows the standard layout accountants use, top to bottom:

• Income: rows for Sales, Services, Shipping charged to customers, and Other income.
• Cost of goods sold: rows for Materials and stock purchases, Packaging, and Other direct costs.
• Gross profit: calculated for you, income minus cost of goods sold.
• Operating expenses: rows for Rent, Software and subscriptions, Advertising, Insurance, Office and shop supplies, Phone and internet, Travel and vehicle, Professional fees, Bank and payment fees, and Other expenses.
• Net profit: also calculated for you, gross profit minus operating expenses.

You type numbers into the category rows and the totals, gross profit, and net profit update on their own. There are no formulas to build and nothing to wire up.

The "Monthly" sheet is the year at a glance. It runs Income, Cost of goods sold, Gross profit, Operating expenses, and Net profit across columns for January through December, with a Year total column at the end. The gross profit and net profit rows calculate automatically here too. You fill in three numbers per month and the sheet shows you the shape of your whole year.

The file opens directly in Excel. If you'd rather work in Google Sheets, upload it to Google Drive and open it there; the formulas carry across fine. It also works in LibreOffice if that's what you use.

What a profit and loss statement tells you

In one breath: a profit and loss statement (also called an income statement, or just a P&L) lists everything you earned in a period, subtracts everything it cost you to earn it, and shows what's left. That leftover number is your profit, and it's the single most honest measure of whether the business works.

It's worth being clear about what it is not. It's not your bank balance. Money can sit in your account from a loan, a tax refund, or last month's sales, none of which say anything about whether this month was profitable. And a P&L is not a cash flow forecast either: it looks backward at what happened, not forward at what's coming. If you want the forward-looking view too, grab the free cash flow forecast template as a companion; the two together cover both questions.

If you want the full picture of how the statement works, what each line means, and how businesses use it to make decisions, read our plain-English guide to what a profit and loss statement is. For this article, the short version above is enough to fill in the template properly.

How to fill in each section

Open the "Profit and Loss" sheet, pick your period (last month is the natural place to start), and work top to bottom.

Income

Enter what you earned during the period, split across the four rows. Sales is money from products you sold. Services is money from work you did: freelance projects, consulting hours, repairs, commissions. Shipping charged to customers is any delivery cost you passed on to buyers; it counts as income because customers paid it to you, even though most of it goes back out as postage. Other income catches the rest: interest, a one-off equipment sale, an affiliate payout.

Use what you earned before any fees came off. If a customer paid $100 and the payment processor kept $3, your income is $100 and the $3 belongs down in Bank and payment fees. Recording the $97 hides a real cost and understates both numbers.

Cost of goods sold

This section is only for costs tied directly to the things you sold. Materials and stock purchases covers the products or raw materials behind the sales in this period. Packaging is boxes, mailers, tape, labels. Other direct costs is anything else that scales with each sale, like a per-unit production fee. If you sell services only and buy no materials, it's fine for this whole section to be zero.

Operating expenses

Everything it costs to keep the business running, whether you sold anything or not. Rent, software subscriptions, advertising, insurance, your phone and internet (the business share of it), travel, your accountant, bank fees. Go through your business bank and card statements for the period and put each charge in the closest row. Don't agonize over categories: whether a charge lands in Office and shop supplies or Other expenses barely matters. What matters is that every business cost lands somewhere, because a missed expense inflates your profit and gives you a rosier picture than reality.

That's it. Gross profit and net profit calculate themselves as you type. If you're starting from a pile of receipts and bank rows rather than tidy totals, our guide on turning a spreadsheet into a profit and loss statement covers that messier first step.

The two mistakes that wreck a DIY P&L

Most homemade profit and loss statements go wrong in one of two specific ways. Both produce a statement that looks finished but tells you the wrong number.

Mistake 1: personal spending mixed in

If your groceries, your streaming subscriptions, or your family phone plan flow through the same account as the business and get typed into the expense rows, your P&L stops measuring the business. Profit looks worse than it is, and you can't tell whether a bad month was the business or just a big personal week. The fix is a boundary: only costs the business would still have if you weren't in the picture personally go on the statement. A separate business bank account makes this nearly automatic, because everything on that statement belongs in the P&L and nothing else does. For shared costs like a phone or a home office, put in a consistent business-use share and keep it the same every period.

Mistake 2: treating stock purchases as a straight expense

This one is sneakier. Say you spend $2,000 on stock in March and sell half of it. If you write the full $2,000 into March as an expense, March looks terrible and April, when you sell the rest with no purchase against it, looks amazing. Neither month is telling the truth. The cost of stock belongs against the period in which you sell it, not the period in which you buy it. That's the whole idea behind cost of goods sold, and it's why the template gives COGS its own section above gross profit instead of burying it in expenses. A simple way to get close: count what the stock you actually sold this period cost you, and put that in Materials and stock purchases. Our guide to cost of goods sold explains the idea properly, with the standard formula for working it out from opening stock, purchases, and closing stock.

Get these two things right and a homemade P&L is genuinely trustworthy. Get either wrong and the bottom line is decoration.

How to read the result: gross profit vs net profit

Once the numbers are in, the template hands you two profit figures, and they answer different questions.

Gross profit is income minus cost of goods sold. It asks: is the thing I sell worth selling? If your gross profit is thin, no amount of trimming subscriptions or renegotiating rent will save you, because the product itself isn't earning enough over what it costs you. Thin gross profit points at pricing, supplier costs, or shipping you're eating.

Net profit is gross profit minus operating expenses. It asks: does the business as a whole make money? Healthy gross profit with weak net profit means the products are fine but the overhead is eating the margin: too much rent, too many subscriptions, advertising that isn't paying for itself.

Reading the two together is the diagnostic. Weak gross profit means fix the selling side. Strong gross but weak net means fix the running-costs side. Both weak means both, and both strong means you can stop guessing and start deciding what to do with the profit. For a deeper walkthrough with examples, see gross profit vs net profit.

One more habit worth building: look at the percentages, not just the dollars. Gross profit divided by income is your gross margin. If income grows but that percentage shrinks, you're working harder for less on every sale, and that trend is easy to miss when the raw dollar figures are all going up.

Use the Monthly sheet to spot trends

A single statement is a snapshot. The "Monthly" sheet turns twelve snapshots into a film, and that's where the interesting answers live.

At the end of each month, copy your totals across: income, cost of goods sold, and operating expenses into that month's column. The gross profit and net profit rows fill in on their own, and the Year total column keeps a running picture of the whole year.

Once you have three or four months in a row, read across the rows instead of down the columns:

• Income climbing while net profit stays flat means costs are growing exactly as fast as sales. You're getting busier, not richer.
• Gross profit shrinking as a share of income usually means supplier prices crept up or discounting crept in, and neither made it into your prices.
• An expense row that only moves one direction is worth a look. Subscriptions in particular tend to stack up quietly until the row is double what you'd guess.
• Repeating strong and weak months reveal your seasonality, which changes how you read any single month. A slow February isn't a problem if February is always slow; it's a problem if last February was strong.

This monthly habit takes maybe ten minutes once the single-period statement is filled in, and it's the difference between a P&L you made once and a P&L that actually steers the business.

When the spreadsheet stops being enough

An honest note to end on: this template has a natural lifespan. The statement itself never stops being useful, but the way you produce it does.

The template works beautifully while your months are small enough to total up by hand. The strain shows as volume grows: every month you're re-reading bank statements, re-sorting charges into categories, and re-typing totals, and every one of those manual steps is a chance for a number to go astray. When the monthly fill-in stretches past an hour, or you catch a figure that doesn't match your bank, or you skip a month because you're busy (and then two), the spreadsheet has quietly turned from a tool into a chore. We've written up the full set of warning signs in why your bookkeeping spreadsheet stops working.

The step up isn't a fancier spreadsheet, it's keeping your records in one place so the statement builds itself. That's how Argo Books handles it: you record income and expenses (or import them from a bank statement or CSV), and the report builder puts together your profit and loss statement from those records automatically, with cost of goods sold handled properly instead of by hand. No monthly re-typing, and the gross-vs-net reading you've learned here works exactly the same on the generated report. It's free to start and runs as a desktop app on your own machine, so your books stay local.

But don't rush there. Filling this template in by hand for a few months is the best accounting education a small business owner can get for free, because you see exactly where every number comes from. Start with the spreadsheet, learn what your P&L is telling you, and move up when the upkeep costs more than it teaches.