BusinessPlanHub

Free Profit and Loss Template for Excel

A profit and loss template is an Excel sheet that shows what your business earned, spent and kept over a period. This one is a free monthly P&L, also called an income statement, with twelve months and a yearly total.

Download the free template Arrange a free call

Free · Excel (.xlsx) · Works in Google Sheets · Includes a filled-in example

What is a profit and loss statement?

A profit and loss statement is a report of revenue, costs and profit over a period of time. It answers one question: did the business make money in that month or year?

Accountants call it an income statement. It is the first of the three core statements, and the other two (the balance sheet and the cash flow forecast) both lean on it.

This template runs for twelve months, one column each, with a Year total at the end. If you want five years of monthly statements built from assumptions, use a full financial model template instead.

What is in this profit and loss template?

The file has three sheets: How to use, P&L and Example. You type into the yellow cells on the P&L sheet, and the blue cells calculate themselves.

SectionRowsWhat it tells you
RevenueProduct sales, service income, other income, total revenueWhat you earned in the month
Cost of salesMaterials and stock, direct labor, other direct costsWhat it cost to make or deliver those sales
Gross profitGross profit and gross margin %What is left to pay for the rest of the business
Operating expensesSalaries, payroll taxes, rent, utilities, insurance, marketing, software, accounting and legal, office, travel, otherThe costs you carry whether you sell or not
EBITDAProfit before interest, tax, depreciation and amortizationProfit from operations alone
Below the lineDepreciation, interest, income taxCosts of owning assets, debt and tax
Net profitNet profit and net margin %What the owner keeps

Net profit turns red in any month where it is negative, so a loss is hard to miss.

The Example sheet shows the layout filled in for a made-up café. Its sales ramp up over the year and it turns profitable from month 3. The figures are invented, so use them to see where a cost belongs, not as targets.

How do you fill in a profit and loss template?

You fill it in from revenue downward, one section at a time.

  1. Type your business name and the month your year starts.
  2. Enter revenue by the month you earned it, not the month the customer paid.
  3. Enter cost of sales: the costs that rise and fall with each sale.
  4. Enter operating expenses, renaming lines where they do not fit.
  5. Enter depreciation, interest and income tax. Leave a line blank if it does not apply.
  6. Read the blue rows: gross margin, EBITDA, net profit and net margin.
  7. Compare with the Example sheet if you are unsure where a cost belongs.

If you do not have actuals yet, start from your own quotes and price lists. The startup costs worksheet helps you find the costs you have not thought of.

What does a lender or investor check on a P&L?

They check whether the margins are believable and whether the costs are complete. A P&L is read for what is missing as much as for what is there.

Expect questions like these:

  • Is gross margin consistent with how your type of business normally works?
  • Where is the owner’s own pay? A P&L with no wages for the founder looks too good.
  • Do costs grow as sales grow, or does revenue climb while every cost stays flat?
  • Is EBITDA enough to cover the interest on any loan?

Many lenders read EBITDA as a quick view of whether the business can carry debt. Our guide to business plan financial projections shows how these figures sit inside a plan.

Net profit from the P&L flows into the balance sheet as profit for the year to date, which is the line that keeps the balance sheet in balance. In the template’s Example, the balance sheet’s profit-to-date matches the P&L example.

The P&L does not show cash. A sale on credit is revenue now and money later. A loan repayment or a piece of equipment barely touches profit but takes real cash. That gap is what the cash flow forecast is for. Read the three together from the financial statement templates hub.

What are the common mistakes on a P&L?

The usual errors are timing and classification, not arithmetic.

  • Recording cash instead of revenue. Enter sales when you earned them, not when you were paid.
  • Putting overhead in cost of sales. Rent in cost of sales shrinks gross margin and misleads whoever reads it.
  • Leaving out the owner’s pay. Put it in salaries, even if you take it as draws for now.
  • Skipping depreciation. It is not cash, but it is a real cost of the equipment you use.
  • Treating profit as cash. A profitable month can still end with less money in the bank.

What do we think a P&L is for?

We think most owners look at the bottom line and stop, which is the least useful place to look. The row we read first is gross margin. If it is wrong, nothing below it can save you, and a lender who sees a margin that does not match your industry will go straight to it.

We also think a P&L should be easy enough to rebuild every month. A statement you only produce when the bank asks is a statement nobody trusts, including you. Update it monthly, keep your assumptions written down, and the numbers will survive questioning.

The P&L is one part of a forecast. If you are writing for a lender or investor, our business plan template and financial forecasts pages show where it fits, and the resources hub has more free tools. Want a second pair of eyes on your numbers? Our team offers a free 30-minute call.

Get the file

Free. Enter your details and the download opens on this page.

Want to talk it through?

Arrange a free 30-minute call with BusinessPlanHub. Bring your plan, your forecast or the question you are stuck on.

Arrange a call →

Profit and loss template: common questions

Is a profit and loss statement the same as an income statement?

Yes. Profit and loss statement, P&L and income statement are three names for the same report: revenue minus costs over a period, ending in net profit.

Does the P&L template work for a business that has not started trading?

Yes. Type forecast figures instead of actuals and treat the sheet as a projection. Label it as a forecast so nobody mistakes it for results.

Can I rename the expense lines?

Yes. The yellow label cells can be renamed to fit your business. Keep each cost in the right section, because gross profit and EBITDA depend on where a cost sits.

Will the template work in Google Sheets?

It is an .xlsx file, so Excel opens it directly. Google Sheets can import it through File > Import. Check the formulas once it is in.

Are the figures on the Example sheet benchmarks?

No. The Example sheet uses a made-up café so you can see the layout filled in. Its numbers are for illustration only.