Track them per shoot, not just per month. Photography mixes three things a monthly total can't separate: capital gear that lasts years, per-shoot variable costs that decide whether a job was worth taking, and income landing months after the booking. The result is that you can have a busy year and a bad year at the same time and not find out until spring.
How to work it:
- Tag every cost to the shoot. Create tags under Expense Tags with a recognised prefix —
Client – Alvarez(en-dash, space each side). Assign from the Tag column in your sheet, when photographing a receipt, or by writingtag:Alvarezon the receipt itself. - Tag the booking fee the same way so both sides carry the job.
- Ask the chat for per-tag P&L — each job comes back with income, costs, net profit and margin, ranked. A job that lost money shows as "expenses 1.2× revenue" rather than a negative percentage.
What to tag to a shoot: second shooter fee, gear rental, travel and parking, prints and albums, assistant, meals on a long day.
Gear: buying a body or lens may be an expense in-year or an asset written down over time, depending on cost and country — keep the receipt with the price visible and let your accountant place it. Renting for one job is the cleanest case and the clearest demonstration of why per-shoot tagging matters. Kit insurance and the liability cover many venues require are ongoing overhead.
Paying people: money paid to a second shooter or an outsourced editor is a business expense, and depending on amount and country may create a reporting obligation (1099-NEC in the US). Raise it with your accountant before year end. Record who, how much, which shoot, and how you paid.
The subscriptions nobody counts: editing software, cloud storage and backup, the delivery gallery, the booking/CRM tool, the portfolio site, music licensing, preset packs. Small individually, collectively one of the largest annual lines — and all recurring email receipts, which is exactly what Gmail capture handles.
Mileage: venue visits, engagement sessions and scouting trips count differently from the drive to a regular place of work — check which miles qualify before logging a season of them.
Full guide: Photographer Expense Tracker · reporting: Profit by Client · if you take money up front to spend for a client: Cash Advance Expense Tracker. Estimates — confirm with your tax professional.
