Home›Templates›Accounting & Small Business Spreadsheets›Profit and Loss Statement
Preview of the Profit and Loss Statement template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

Profit and Loss Statement Template — Income Statement Format (Excel & PDF)

A P&L (income statement) for a small business, comparing this period with the last, with every total calculated.

✓ A4✓ Auto totals✓ 2 periods✓ Excel & PDF

Opens in your browser. No Excel needed, no signup.

Free for personal and commercial use · No watermark · Updated November 2026

Guide

About this profit and loss statement template

A profit and loss statement (P&L, or income statement) shows whether a business made money over a period. It starts with revenue, takes away the cost of what was sold to give gross profit, then takes away running costs to give operating profit, and finally interest and tax to give net profit. This Excel sheet does every step for you, shows the net profit margin, and compares each line with the previous period so you can see what changed.

How to use this P&L template

  1. 1

    Click "Edit online", or download the Excel file.

  2. 2

    Set the period at the top: a month, a quarter or a financial year.

  3. 3

    Type your figures in the yellow cells for this period and the previous one. Enter costs as positive numbers.

  4. 4

    Rename or add lines to match your business, keeping new rows inside each section so the totals include them.

  5. 5

    Read gross profit, operating profit, net profit and the margin, and look at the change % column for big movements.

Tips for reading a P&L

Watch gross margin

If gross profit grows more slowly than sales, your direct costs or discounts are rising.

Profit isn't cash

A P&L can show a profit while the bank balance falls, for example when customers pay late. Track cash separately.

Compare like with like

Compare the same months year on year when your business is seasonal.

Use accrual figures

Record income when you earn it and costs when you incur them, not only when cash moves, for a truer picture.

Frequently Asked Questions

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

Gross profit = revenue − cost of sales. Net profit = gross profit − operating expenses − interest − tax.

Yes. Profit and loss statement, income statement and profit and loss account are names for the same report.

Yes. Set the period to a month and use "Previous period" for last month or the same month last year.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
%

Percentage Calculator

Calculate percentages, increase, decrease, and ratios

Use Tool→
💱

Currency Converter

Convert between 150+ world currencies with live rates

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Income & Expense Tracker template preview

Income & Expense Tracker

Small business money in and out, running balance, profit by category.

ExcelPDF
Balance Sheet template preview

Balance Sheet

Assets, liabilities and equity with a balance check.

ExcelPDF
Trial Balance template preview

Trial Balance

Every ledger balance in debit and credit, with totals that must agree.

ExcelPDF
Trading Account template preview

Trading Account

Dr/Cr trading account that works out gross profit or gross loss.

ExcelPDF
Cost Sheet template preview

Cost Sheet

Prime cost to sales, with cost per unit at every level.

ExcelPDF
Cash Flow Statement template preview

Cash Flow Statement

Indirect-method cash flow: operating, investing and financing.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF