Posted in

5 Free Profit and Loss Statement Templates in Excel

5 Free Profit and Loss Statement Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 6, 2026

A profit and loss statement template shows, on one page, how much money your business brought in, what it spent and what was left over. It is the report owners, lenders and accountants look at first. On this page you can download five free profit and loss statement templates in Excel: a monthly profit and loss statement that compares this month with last month, a 12-month profit and loss that shows the whole year side by side, and a simple profit and loss for self-employed people and very small businesses that also sets money aside for tax, plus a quarterly profit and loss statement and a department profit and loss sheet.

Each file is a real, editable .xlsx workbook created for this page. Type your figures into the yellow cells and the subtotals, gross profit, operating profit, net profit and margins calculate automatically. The files also open in Google Sheets, LibreOffice Calc and Numbers, and they print cleanly on a single page.

Budget vs Actual Variance Calculator

LineBudgetActualVarianceVar %
Total budget:   Total actual:  
Total variance:

Runs in your browser; nothing is sent or saved. Variance = actual minus budget. For costs, a positive variance means overspending.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Profit and Loss Statement?

A profit and loss statement, also called a P&L, an income statement or a statement of operations, summarizes revenue and expenses over a period of time, such as a month, a quarter or a year. It starts with revenue, subtracts the direct cost of producing what you sold to give gross profit, subtracts operating expenses to give operating profit, and finally subtracts interest and taxes to give net profit, which is the famous bottom line.

The P&L is different from a balance sheet. A balance sheet is a snapshot of what the business owns and owes on one date. The P&L covers a period and tells you whether the business made or lost money during it. It is also different from a cash flow statement: a P&L can show a profit even when cash is tight, for example when customers have not paid their invoices yet.

Why Use a Profit and Loss Template in Excel?

  • The structure is already correct. Revenue, cost of goods sold, gross profit, operating expenses and net profit are laid out in the standard order, so you only fill in numbers.
  • Every total is a formula. Subtotals, profits and margins update the moment you change a figure, which removes adding-up mistakes.
  • Comparisons are built in. The monthly template shows the change from last month as a percentage, and the 12-month template shows trends across the year.
  • It is ready to share. A clean, one-page statement is exactly what a bank, investor or tax preparer will ask for.
  • It is free and flexible. Rename lines, add rows for your own expense categories or change the colors without paying for accounting software.

Download the Free Profit and Loss Statement Templates

All five P&L templates are hosted on this website and free to download. The preview shows the layout of each file.

1. Monthly Profit and Loss Statement

Monthly profit and loss statement template in Excel with revenue, COGS, expenses and margins

This is a full, standard income statement for one month with a comparison column. Revenue is split into product sales, service revenue and other income. Cost of goods sold covers materials and inventory, direct labor and freight in. Operating expenses include salaries and wages, rent, utilities, marketing, software and subscriptions, insurance, office supplies and depreciation. Below operating profit you enter interest expense and income tax to arrive at net profit.

For every line the template shows This month, Last month and Change %, so you can see at a glance which costs have grown and which revenue streams are improving. At the bottom, gross margin and net profit margin are calculated as a percentage of total revenue. The sample figures show how the statement reads when it is filled in; replace them with your own numbers.

2. 12-Month Profit and Loss

12-month profit and loss template in Excel with monthly columns and net margin

The 12-month P&L puts January to December side by side with a year total column. It uses a condensed set of lines that suits most small businesses: revenue, cost of goods sold, gross profit, salaries, rent, marketing, utilities, other expenses, total expenses and net profit. A net margin row under the table shows the profit margin for every month and for the full year.

Months with a loss are highlighted in red automatically, which makes seasonal dips easy to see. Use this template to track actual results through the year, or fill it in as a forecast before the year starts and compare it with your monthly statements as the year goes on. It prints in landscape on one page.

3. Simple Profit and Loss for Self-Employed

Simple profit and loss template in Excel for self-employed with tax reserve

Freelancers, sole traders and side businesses rarely need the full statement. This simple P&L puts income on the left and expenses on the right, with room for eight lines each. Income lines cover client work or sales, online sales and other income; expense lines cover supplies, phone and internet, vehicle and travel, advertising, fees and commissions, home office and equipment.

Below the two columns, net profit before tax is calculated, and you can enter the percentage you want to set aside for tax. The template shows the tax reserve and the profit left after it. The rate is your own estimate, so check it with a tax professional, but keeping a reserve from every period avoids an unpleasant surprise when the tax bill arrives.

4. Quarterly Profit and Loss Statement

Quarterly profit and loss statement template in Excel with Q1–Q4 columns and year totals

A four-quarter P&L for the full year. Enter product sales, service revenue and other income for each quarter, then materials, direct labour and operating costs. The sheet works out total revenue, COGS, gross profit, total operating expenses, operating profit and net profit for each quarter and for the year. Gross and net margin percentages sit at the bottom so you can see which quarters were strongest. Use it for board packs and lender updates when a single monthly sheet is not enough. The sample year shows growing product sales and a clear seasonal lift in Q4.

5. Department Profit and Loss

Department profit and loss template in Excel comparing Sales, Ops and Admin

Splits the same P&L lines across Sales, Ops and Admin so you can see which area is carrying the business. Enter revenue and cost of sales where they belong, then salaries, rent, marketing and other expenses by department. Gross profit, total expenses and department profit calculate across the columns, with a total column on the right. This is the sheet finance teams use before cutting budgets: if Admin is fine but Ops is losing money, you know where to look. Change the three department names to match your own structure.

How to Prepare a Profit and Loss Statement

  1. Choose the period. Decide whether the statement covers a month, a quarter or a year, and write the end date at the top.
  2. Collect your records. Gather sales reports, invoices, bank statements, receipts and payroll reports for that period.
  3. Enter revenue. Record all sales and other income earned in the period, split into the lines that matter to you.
  4. Enter the cost of goods sold. Include only costs directly tied to what you sold, such as materials, inventory and direct labor.
  5. Check gross profit. The template subtracts cost of goods sold from revenue. If gross margin looks unusual, re-check the first two sections.
  6. Enter operating expenses. Add rent, wages, marketing, utilities and other overheads.
  7. Add interest and taxes. Enter interest on loans and income tax for the period to reach net profit.
  8. Review margins and changes. Look at the Change % column and the margins to spot problems early.

Cash Basis vs. Accrual Basis

There are two common ways to record figures on a P&L. On a cash basis, you record income when money arrives and expenses when you pay them. It is simple and popular with very small businesses. On an accrual basis, you record income when you earn it and expenses when you incur them, even if no money has moved yet. Accrual gives a more accurate view of performance and is required for larger businesses in many countries. The templates work for either method; just be consistent from period to period so comparisons make sense.

How to Read Your P&L

Start at the top and work down. Revenue tells you whether sales are growing. Gross margin, which is gross profit divided by revenue, tells you how much you keep from each sale after direct costs; if it falls, your prices may be too low or your costs too high. Operating expenses show the cost of running the business regardless of sales, and they are often where savings are found. Net profit margin shows how much of every dollar of revenue ends up as profit. Comparing these numbers month by month is more useful than looking at any single month on its own.

Common Mistakes to Avoid

  • Mixing personal and business spending. Keep a separate business bank account so the P&L only shows business costs.
  • Putting loan repayments in expenses. Only the interest on a loan is an expense. The principal repayment reduces the loan balance instead.
  • Treating big equipment purchases as one month’s cost. Long-lived assets are usually spread over several years as depreciation.
  • Forgetting owner wages. If you pay yourself a salary through the business, include it, otherwise profit will look higher than it really is.

You can also check these important templates like the balance sheet template for showing what your business owns and owes, and the monthly budget template for planning spending before the month starts.

You may also like the expense report template for collecting staff expenses, and the sales report template for breaking down the revenue that feeds your P&L.

Frequently Asked Questions

What is a profit and loss statement template?

It is a ready-made spreadsheet that lists revenue, cost of goods sold and expenses in the standard order and calculates gross profit, operating profit, net profit and margins automatically.

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

Yes. Profit and loss statement, P&L, income statement and statement of operations are different names for the same financial report.

How often should I prepare a P&L?

Most small businesses prepare one every month and a full-year statement at year end. The 12-month template lets you keep the whole year on one sheet.

Can I use these templates in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, formatting and print area carry over.

What is a good profit margin?

It depends heavily on the industry. Compare your margins with your own past periods and with typical figures for your sector rather than a single universal number.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.