Skip to the content.

Free Profit and Loss Statement Template

For owners who want a monthly profit and loss they can read in two minutes, built from their own numbers rather than a year end surprise.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Profit and Loss Totals and views built from Transactions and Monthly Entry, no typing needed.
Transactions Columns Transaction ID, Date, Vendor or customer, Description, Category, Amount, Client or job (optional), Payment method and Notes.
Monthly Entry Columns Entry ID, Month (any date in month), Category, Amount and Notes.
Settings Your own dropdown lists (category, group and allowed group), so the choices match how you work.

How to fill it in

  1. Check the categories on Settings and match them to how your accountant groups things.
  2. Enter income and costs on Transactions, or monthly totals on Monthly Entry.
  3. Read Profit and Loss for each month, the year to date and the same month last year.
  4. Use Needs attention to find entries with a missing or unknown category.

A tip from the field

Pick one method per category. Daily transactions plus a monthly total for the same category count it twice.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle’s reports show revenue by service, and its accountant export sends sales, payments and expenses in one zip. See how it works on smarfle.com.

All free templates