Bookkeeping

How to Read a Profit and Loss Template

A free profit and loss template is one month, not a year of accounts. Bright Mop Cleaning in March 2026 typed three income lines and five costs. Recurring home cleans were $4,200 for the month. The sheet adds income, adds expenses, and subtracts. Profit is that green result.

Free profit and loss template Excel

The free profit and loss template Excel file has two columns that matter: the line name and the amount. Income sits above expenses. Total income and total expenses are formulas. You do not type them.

Wages, supplies, fuel, insurance, and the phone are the sample costs. A yearly insurance bill should be the part that belongs to this month, or the month looks worse than it was. If expenses are higher than income, profit is negative. That is still a true result.

Budget, snapshot, and receipts

The free small business budget template is the plan you wrote first. This sheet is the month that happened. The free balance sheet template is one date, not the month. Receipts belong on the free expense report template Excel. Copy the actuals across when you close the month. Do not expect the files to sync themselves.

  1. Download the free profit and loss template.
  2. Replace the income names if your work is different.
  3. Type amounts. Leave the profit cell alone.
  4. If you add a row, extend the SUM.
  • Typing profit by hand to make the month look better.
  • Putting a customer deposit in the expense block.
  • Treating the sheet as a tax return.

Open the free profit and loss template. The budget guide and the other bookkeeping notes are on the blog.

Common questions

Is this profit and loss template free?

Yes. The free profit and loss template is one month of income and costs.

What is profit on the sheet?

Total income minus total expenses. The green cell does that subtraction.

Is this a tax return?

No. It adds the month you type. It does not file anything.