Spreadsheets

A shoot-wise profit sheet for photographers in Google Sheets

A Google Sheets template for photographers: one row per shoot with fee, advance, balance, costs and profit, plus a pending-balance list that updates itself.

Editorial illustration for A shoot-wise profit sheet for photographers in Google Sheets

A shoot-wise profit sheet needs one row per shoot, a fee column, an advance column and one column for each cost, with profit calculated by formula. Another formula lists every shoot where a balance is still pending. Built in Google Sheets it takes about half an hour, and it answers the two questions that matter: which shoots paid well, and who still owes you.

What columns should each shoot row have?

ColumnHeadingNotes
ADateShoot date as a real date
BClientFirst name or a short code
CTypeWedding, pre-wedding, product, event
DFeeAgreed total
EAdvanceReceived so far
FBalance=D2-E2
GTravelFuel, tickets, stay
HAssistantSecond shooter or helper
IEditingOutsourced editor
JAlbum and printsPrinting and binding
KTotal cost=SUM(G2:J2)
LProfit=D2-K2
MMargin=IF(D2=0, "", L2/D2)

What does one shoot look like in numbers?

Say a wedding shoot is booked for ₹60,000 with ₹20,000 as an advance. The balance is ₹40,000. Travel is ₹3,500, the assistant ₹4,000, the editor ₹6,000 and the album ₹9,000. Total cost is 3,500 + 4,000 + 6,000 + 9,000 = ₹22,500. Profit is 60,000 - 22,500 = ₹37,500, a margin of 62.5%. These figures are an example, not a typical price.

That profit has not yet paid for your camera, lenses, laptop and insurance, or your own time. Keep a separate sheet for those running costs and compare it with the monthly profit total.

How do you see which balances are still pending?

On a second tab, use FILTER to pull only the rows with money due:

=FILTER(Shoots!A2:F500, Shoots!F2:F500>0)

That lists date, client, type, fee, advance and balance for every shoot with a balance above zero. To see the total owed, use =SUMIF(Shoots!F2:F500, ">0"). For older dues, add a status column: =IF(AND(F2>0, A2<TODAY()-30), "Chase", "") flags balances more than 30 days after the shoot.

How do you roll it up by month?

Put the first day of each month in column A of a Summary tab. For monthly profit use:

=SUMIFS(Shoots!$L$2:$L$500, Shoots!$A$2:$A$500, ">="&A2, Shoots!$A$2:$A$500, "<"&EDATE(A2,1))

Use the same pattern on Fee and Total cost columns to see how much came in and how much went out. A column for cash actually received (advances and balances paid in the month) shows a different story from profit by shoot date, which is useful when a wedding is booked in November and delivered in March.

What small habits keep the sheet honest?

  • Update the advance column the day money arrives, not at month end.
  • Add costs the same week, even a rough figure, and correct them when the final bill comes.
  • Add a column for the due date of the balance, so the Chase flag uses the promised date instead of the shoot date.

How do you price the next shoot with this sheet?

Sort the Shoots tab by Type and look at the margin column. If pre-wedding shoots keep coming out at a lower margin than weddings, the travel or editing cost is probably higher than your quote allowed for. Use the actual cost columns from past shoots of the same kind as the starting point for the next quote, and add a cushion for your own time. The point is to quote from your records instead of from memory.

Do the same with the Balance column: if the same kind of client is always slow to pay, ask for a larger advance or an earlier second instalment when you quote.

Your card and bank statements are where most of these costs hide. SpendixAI can import them and let you categorise each line, so you can copy the totals for travel or editing into the right column.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports