Free Profit and Loss Statement Template

What a profit and loss statement shows

A profit and loss statement (P&L, also called an income statement) summarizes what your business earned and spent over a period, such as a month, a quarter or a year. It answers one question: did you make a profit? It works top to bottom:

• Revenue: everything you billed or received for your products and services, minus refunds and discounts.
• Cost of goods sold (COGS): the direct costs of what you sold, such as materials, inventory and subcontractors. See cost of goods sold.
• Gross profit: revenue minus COGS. Divide by revenue to get your gross margin.
• Operating expenses: the costs of running the business, like rent, software, insurance, wages and marketing.
• Operating income: gross profit minus operating expenses.
• Other income and expenses: interest earned, interest paid on loans and one-off items.
• Net income: the bottom line after everything, including income tax. See net income.

A P&L is different from a balance sheet, which shows what you own and owe on one date, and from a cash flow statement, which tracks money moving in and out of the bank.

How to use this profit and loss statement template

1. Set up the header. Type your business name in cell A2 and the first month of your year in B3. The 12 month columns update automatically, so a July–June fiscal year works too.
2. Pick a basis and stick to it. On cash basis, record money when it lands in or leaves your account. On an accrual basis, record sales when you invoice and costs when you're billed. Mixing the two makes months impossible to compare.
3. Enter revenue. Use the pale yellow cells. Put refunds, returns and discounts on their own line as a positive number; the formula subtracts them.
4. Enter COGS. Only costs directly tied to what you sold. A consultant with no direct costs can leave this section blank, and gross profit will equal revenue.
5. Enter operating expenses. Rename the lines to match your business. To add a line, insert a row inside the section above its total so the SUM formula picks it up.
6. Enter other items and tax. Interest, one-off gains or losses, and income tax expense.
7. Read the results. Gross profit, operating income, net income and both margins calculate for every month and the year. The "Annual summary" sheet rolls everything into quarters and a full year, with each line as a percentage of revenue.

Enter every number as a positive amount. The template already knows which lines to add and which to subtract.

Worked example: a small online shop

Here's one month for a small business selling handmade candles online, as the profit and loss statement Excel template would total it:

The gross margin tells the owner that pricing covers product costs comfortably; the operating expenses are where most of the money goes. Tracked for 12 months, the template shows whether that holds through slow and busy seasons.

Choosing your expense categories

The template comes with common expense lines, but the best categories are the ones that match how you'll file your taxes and make decisions. Keep them broad enough that each month has a handful of entries per line, and specific enough that a jump in one line tells you something. If you already use a chart of accounts or your accountant gave you a category list, rename the template's lines to match it, so the year-end handover is a copy and paste rather than a re-sort.

Reading your P&L: three numbers to watch

Once a few months are filled in, the template gives you more than a bottom line. Three figures are worth checking every month:

• Gross margin %. If it slips while sales hold steady, your direct costs are rising faster than your prices. That's usually the first sign you need to reprice or renegotiate with a supplier.
• Operating expenses as a share of revenue. The "Annual summary" sheet shows every line as a percentage of revenue. A cost that creeps from 4% to 8% of sales deserves a closer look, even if the dollar amount still feels small.
• Net profit margin %. This is what's left from each dollar of sales after everything. Compare the same month across years rather than one month with the next, because most businesses have seasonal swings.

Use the "Annual summary" sheet at year end, or when a lender, landlord or partner asks how the business is doing. It rolls the 12 months into four quarters and a full-year total without any extra work, so the figures always match the monthly sheet.

Common mistakes on a homemade P&L

• Counting owner withdrawals as expenses. Money you take out for yourself as a sole proprietor is an owner's draw, not an expense, and doesn't belong on the P&L.
• Putting loan repayments in expenses. Only the interest is an expense. The principal reduces a liability.
• Expensing big equipment in one month. Longer-lived assets are usually spread over their useful life through depreciation. Ask your accountant how to treat them for tax.
• Leaving out small, regular costs. Payment processing fees and subscriptions add up. Pull them from your bank statements.
• Mixing personal and business spending. A separate business bank account makes the P&L far easier to fill in and trust.

When a spreadsheet P&L stops being enough

A free profit and loss statement template is a good way to understand your numbers. Its weakness is that it's only as accurate as what you type, and nothing checks it against your invoices, bills or bank balance. Each month you re-total transactions from somewhere else, and a missed receipt quietly changes your profit.

Financial reporting software builds the P&L from the transactions themselves. In PilotLedger, invoices, bills, expenses and payments post to a double-entry general ledger, so the Profit & Loss report always ties to your Balance Sheet and Trial Balance. You can run it for any date range and export it. When you reconcile your bank accounts statement by statement, you know nothing is missing. PilotLedger doesn't connect to bank feeds, so transactions are entered or imported by you rather than pulled from the bank automatically. For a deeper walk-through of each line, read what is a profit and loss statement.

This template is general information, not tax or accounting advice.