Income and Expense Spreadsheet for Freelance Photographers
A photographer's year swings between packed shoot weekends and quiet editing weeks, and the biggest costs are gear and the second shooters hired on the day. The sheet has to tie payments to event dates and keep every gear purchase visible.
How a photographer gets paid, and what that means for the sheet
Wedding and event photographers are usually paid a booking retainer to hold the date, then the balance before or on the day. Portrait and real estate work is often paid per session or per listing. Gallery sales and print orders arrive later, as payouts from the platform rather than from the client directly.
Log each retainer and balance as Income on the day it clears, with the event date in the Description so a booking is easy to find later. Gallery payouts usually arrive net of the platform's fee, so log the amount that lands and put the order number in the Description. A usage license sold later is its own Income line.
One example month, logged
Invented numbers, to show the shape. Each row below is one line on the Transactions tab.
| Client | What it was | Income |
|---|---|---|
| Harper & Diaz Wedding | Wedding package, booking retainer | $1,500 |
| Brightside Realty | Listing photos, six homes | $840 |
| Oakridge High PTA | School event coverage | $450 |
| Lena Okafor | Family session and prints, gallery payout | $310 |
| Income total | $3,100 | |
| Category | What it was | Expense |
|---|---|---|
| Equipment | 35mm prime lens | $1,100 |
| Equipment | Memory cards, 128 GB pair | $60 |
| Equipment | External drive for wedding archive | $140 |
| Contractors | Second shooter, Harper wedding | $450 |
| Software & subscriptions | Photo editing subscription, monthly | $22 |
| Software & subscriptions | Online gallery platform, annual plan | $190 |
| Travel | Gas and parking, venue scouting trips | $64 |
| Marketing | Printed sample album | $180 |
| Other expense | Studio rental for headshot day | $150 |
| Expense total | $2,356 | |
In this example the month ends with $3,100 in, $2,356 out and $744 left before you set anything aside for tax.
The P&L tab sorts the same rows by category:
| Expense category | Month total |
|---|---|
| Software & subscriptions | $212 |
| Equipment | $1,300 |
| Contractors | $450 |
| Marketing | $180 |
| Travel | $64 |
| Other expense | $150 |
| Expense total | $2,356 |
Where a photographer's purchases go
- Equipment: Bodies, lenses, flashes, memory cards and backup drives all go in Equipment. When one receipt mixes a lens with a camera bag and a cleaning cloth, split it into lines so a large item is not buried under small ones.
- Contractors: A second shooter, an assistant or a retoucher hired for a job goes in Contractors. Put the person's name in the Client / Vendor column and the event in the Description, so you can filter by event and see what each wedding or shoot cost to deliver.
- Software & subscriptions: Editing software, cloud storage for archives and the online gallery platform are recurring bills. If a platform bills a yearly plan upfront, enter it on the billing date as one row rather than splitting it into twelve.
- Travel: Gas, parking, flights and hotel nights for a destination shoot go in Travel. Put the shoot name in the Description so each trip can be matched to its booking. Venue scouting trips before a wedding belong here too, even though no photos were taken.
Four tracking tips for a photographer
- Add a row for the second shooter's payment the day you send it, not when the couple's balance arrives. To see how tight that gets, type both into the Cash Flow tab under the months they will land, then check its lowest month.
- Keep a separate Income row for album and print upsells, with a Description such as 'Parent album, Harper wedding'. Over a season you can see whether albums, prints or session fees are carrying the year.
- Keep one Invoices row for each wedding balance and put the event date in the Invoice # cell, since the tab has no notes column. Photographers often invoice weeks ahead, so the due date and shoot date differ, and mixing them up misses reminders.
- At the end of busy season, sort the Transactions tab by Category and scan the Equipment rows. Small items scattered across the year, such as cards, cables and bags, are easy to forget until you look at them together.
Two formulas worth a cell of their own
These use the kit's Transactions tab (Type in column B, Category in C, Client / Vendor in E, Amount in F). Excel and Google Sheets both support SUMIFS.
- Spend in your biggest category, here Equipment:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Expense",Transactions!C:C,"Equipment")returns $1,300 on the example month. - Income from one client:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Income",Transactions!E:E,"Harper & Diaz Wedding")returns $1,500 on the example month.
Questions
How do I track print sales and gallery payouts that arrive weeks after a session?
Log each payout as Income on the day it lands, with the platform in Client / Vendor and the session name in the Description. If one payout covers several sessions, add a single row and list the session names in the Description.
Should I track each lens and camera body as its own row?
Yes, one row per item with the model in the Description. That keeps Equipment readable and shows when each piece was purchased. Small accessories from the same receipt can share one row if you note what they are.
Already built
The Freelancer Finance Spreadsheet Kit has the Transactions, Invoices, P&L, Cash Flow and Tax Set-Aside tabs wired together, with this kind of example data on every tab. One Excel file, $29.
Free: the Tax Set-Aside tab as a standalone Excel file
One working tab: type your quarterly income, expenses and the rate you choose, and it shows what is still to put aside. Confirm your email and the file arrives right away, plus an occasional note (at most one a week) on tracking freelance money. Unsubscribe in one click. Privacy.
The same sheet for other freelancers
- All freelancer spreadsheet guides by profession
- Freelance Consultant Income and Expense Spreadsheet Template
- Freelance Graphic Designer Income and Expense Spreadsheet
- Freelance Social Media Manager Income and Expense Spreadsheet
- Freelance Translator Spreadsheet for Per-Word Income and Costs
- Freelance UX Designer Income and Expense Spreadsheet
- Freelance Video Editor Spreadsheet for Income and Expenses
- Freelance Virtual Assistant Income and Expense Spreadsheet
- Freelance Voice-Over Artist Income and Expense Spreadsheet
- Income and Expense Spreadsheet for Freelance Web Developers
- Freelance Writer Income and Expense Spreadsheet for Articles
- Online Tutor Income and Expense Spreadsheet for Lesson Payouts
More freelancer finance guides
- Excel or Google Sheets for freelancer finances? What actually differs
- Freelance expense categories for a spreadsheet: a starter list that stays short
- How to build a freelance income and expense tracker in a spreadsheet
- A simple 12-month cash flow forecast for freelancers
- Freelancer profit and loss (P&L) in a spreadsheet: a one-page layout
- Freelancer runway: three spreadsheet formulas for how long your cash lasts
- Freelancer tax set-aside: what goes into the number, and how to track it
- Invoice tracker spreadsheet: formulas for paid, due and overdue
- Budgeting on irregular freelance income: the baseline-pay method
- How to track freelance income by client in a spreadsheet
General information about using spreadsheets, not financial, tax or accounting advice. Example numbers are invented. Categories are for tracking and do not say what is deductible.