Skip to content
The title slide and first slides of the Photographer Business Expense Tracker template

Photographer Business Expense Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Working photographers use this photographer business expense tracker to know what each booking is worth and what the business costs. The Sessions tab holds the client, shoot date, fee, amount received and a status from Booked to Paid. The Costs tab covers software, storage, studio rental, travel, insurance and education. The Gear tab lists cameras, lenses and lights with a business-use share. The Dashboard totals fees, balances due and costs by kind.

Add a booking when the retainer arrives, not when the gallery is delivered. Keep the status current so the balances due figure tells you who still owes you. Record gear when you buy it and keep the invoice with the serial number, which also helps with insurance. Before you file, bring the totals to a tax professional to learn how larger equipment is handled.

Useful for

  • Find clients who still owe a balance
  • Total software, travel and studio costs
  • Keep a dated list of cameras and lenses

What's included

  • 5 tabs: Dashboard, Sessions, Costs, Gear, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Sessions: a table
  • Costs: a table
  • Gear: a table
  • 2 charts 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 Sessions 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

What records should a photographer keep for taxes?

Keep contracts, invoices, payment records and receipts for gear and running costs. A booking list with dates and amounts, plus saved receipts, covers the usual requests from a preparer.

How do I track deposits and balances?

Enter the fee and the amount received so far on each session. The Balance column shows what is still due, and the Dashboard adds up all open balances.

Should camera gear be tracked separately?

A gear register helps because large purchases can be treated differently from everyday costs. List each item with its date, cost and business use, then have a tax professional advise on reporting.

  • #tax-tracker
  • #photographer-business-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…