Skip to content
Self-Employed Profit and Loss cover: a sample sheet with money in, business expenses and profit before tax and a bar chart, beside the Dashboard tab

Self-Employed Profit and Loss

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This sheet is for freelancers, contractors and sole traders who need one place for business money. The Transactions tab takes each payment received or cost paid, with a date, description, type (income or expense), category and amount. A Deductible amount column applies the half-rate rule for meals, so you see the business cost at a glance.

The Dashboard totals money in, business expenses, profit before tax and deductible costs. A bar chart compares what you spent with what is deductible in each expense category, which helps you spot gaps before filing. The sample rows cover six weeks of freelance work, swap in your records before you rely on it.

Useful for

  • Tracking client payments against business costs
  • Preparing expense totals for a tax preparer
  • Seeing which expense categories cost the most

What's included

  • 3 tabs: Dashboard, Transactions, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Transactions: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Transactions tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is the profit on this sheet the same as taxable income?

Not exactly. Profit before tax is income minus business expenses as you have logged them. Taxable income can differ because of adjustments, deductions and personal allowances, so check current IRS guidance or ask a tax preparer before you file.

How should I record a cost I pay partly for business?

Enter only the business share as the amount, and say in the description what share you used and why. Keep the receipt with the entry. Mixed-use costs such as a phone plan or a car need records that support the split.

What if I receive a payment before the work is done?

Record it on the date you receive it, as an income row, and add a note in the description. Accounting rules for prepaid income depend on your method, so confirm the approach with an accountant.

  • #profit-and-loss
  • #self-employed-profit-and-loss
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…