Free Profit and Loss Template (Excel)

Your profit and loss statement (P&L) is the single report that answers "am I actually making money?" This free template calculates Gross Profit, Operating Income, and Net Income automatically as you enter your numbers — no formulas to build, no accounting background required.

Download Free — XLSX See the Full Library

No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Business owners who want to see real profit, not just bank balance
Freelancers and solo operators tracking monthly performance
Students learning how revenue and expenses roll up into net income
Anyone preparing numbers for a lender, investor, or accountant

What's included

Revenue section with room for multiple income streams
Cost of Goods Sold with automatic Gross Profit and Gross Margin % calculation
10 pre-built Operating Expense categories, ready to rename
Automatic Operating Income, Net Income, and Net Margin % calculations
Built-in AI prompt that reviews your finished numbers and flags what's trending in the wrong direction

Why use a template instead of starting from scratch?

Building a P&L from scratch means getting the formulas right for gross margin, operating income, and net margin, every single time you update it. This template has those calculations already built in and tested, so you just enter your numbers and trust the output — no risk of a broken formula quietly handing you the wrong profit figure.

How to Use This Template

Download and open in Excel or Google Sheets

Works identically in either — no macros or add-ins needed.

Enter your revenue by stream, for the period you're reporting

Break out revenue into separate lines if you sell more than one thing — it makes the trends easier to see later.

Enter your Cost of Goods Sold, if you have any

Skip this section entirely if you're a service business with no direct product costs.

Fill in your operating expenses by category

Rename the 10 pre-built categories to match how you actually spend — the template recalculates Net Income automatically as you go.

Run the built-in AI prompt on your finished numbers

Attach the saved file to ChatGPT or Claude and ask what's trending in the right or wrong direction.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on what's trending in the right or wrong direction, which expense categories look unusually high, and one concrete action to consider, no accounting background required.

Common Mistakes to Avoid

Confusing "profit" with "cash in the bank"

A P&L shows profit on paper, not what's actually available to spend. Pair it with a cash flow view for the full picture — a profitable month can still be a cash-tight month.

Lumping owner draws in with expenses

An owner's draw isn't a business expense, it's a distribution of equity. Including it on the P&L will understate your real profit.

Not separating one-time expenses from recurring ones

A single big one-off purchase can make a month look far worse than the underlying trend actually is — note it so you don't misread the pattern.

Comparing mismatched periods

Comparing a partial month to a full month, or a slow season to a peak one without context, makes trends look misleading. Always compare like periods.

Frequently Asked Questions

What's the difference between a P&L and a balance sheet?

A profit and loss statement shows performance over a period of time — revenue minus expenses equals profit, for a month, quarter, or year. A balance sheet shows financial position at a single point in time — what you own, owe, and what's left over. They answer different questions and are meant to be read together.

How often should I update my P&L?

Monthly is the standard for most small businesses — often enough to catch problems early, not so often that it becomes a chore. Some fast-moving businesses review weekly.

What if I don't have Cost of Goods Sold?

Service businesses often don't. Leave that section at zero and your Gross Profit will simply equal your Revenue — the rest of the template still works exactly the same.

Is this template really free?

Yes, completely free, no email required. iLuvAccounting also has a paid Tools Club with 70+ templates if you want the full library.

What's a healthy net margin for a small business?

It varies a lot by industry — service businesses often run 10-20% net margin, while retail and restaurants often run much thinner, 2-6%. Compare yourself against your own trend over time and your specific industry, not one universal number.

Should I run a P&L monthly or quarterly?

Monthly, if you're actively managing the business day to day — it catches problems like an expense spike or a slow sales month early enough to actually act on. Quarterly is a fine addition for a bigger-picture check-in.

Can I use this for a multi-owner business?

Yes — the structure works the same regardless of ownership. If you need to track draws or distributions by individual owner, note that detail in the Instructions tab or a separate schedule.

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club