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
- Check the categories on Settings and match them to how your accountant groups things.
- Enter income and costs on Transactions, or monthly totals on Monthly Entry.
- Read Profit and Loss for each month, the year to date and the same month last year.
- 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.
- Transactions (36 sample rows)
- Monthly Entry (6 sample rows)
Related templates
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.