Every wedding photographer has a shot list. Almost nobody looks at it during the day — it's a PDF on a phone, the ceremony ran twenty minutes late, and the planner is asking where the couple went. The list fails not because it's wrong but because it's disconnected from the clock.

Below is the shot list that matters, distilled from the shots that come up in post-wedding complaints and gallery requests, plus the three calculations that keep the list attached to the actual timeline. Everything here works in any spreadsheet.

The 24 shots that get asked for afterwards

These are the ones couples notice are missing. Everything else is bonus.

Getting ready (4)

  1. The dress or suit hanging in window light — it's the first image in every album.
  2. Rings, shoes and invitation suite as a flat-lay. Clients send this to the stationer and the jeweller.
  3. The final make-up touch, eyes close-up.
  4. Mother or best friend helping with the dress — the one that makes parents cry.

Ceremony (8)

  1. The venue empty: aisle, arch, florals. Shoot it before guests sit down or you never get it.
  2. Partner B's face as partner A enters. Second shooter, or you lose the entrance.
  3. The entrance, wide from the back.
  4. Vow exchange, close-up, both faces.
  5. Ring exchange, hands macro.
  6. Parents' reactions during the vows.
  7. The first kiss — and the two seconds after it.
  8. Recessional / confetti exit.

Family formals (3)

  1. Couple with both sets of parents.
  2. Couple with each immediate family.
  3. Couple with grandparents — this is the one that gets printed and framed.

Couple session (3)

  1. Golden-hour wide, environmental.
  2. Close portrait at 85mm, each partner.
  3. Ring detail on hands with the bouquet.

Reception (6)

  1. The room empty: tables, centrepieces, place cards. Ten minutes during cocktail hour.
  2. First dance, wide then close.
  3. Speeches with the couple's reaction in the same frame.
  4. Cake cutting.
  5. Parent dances.
  6. The send-off.

Mark these "Must". Everything else on your list is "Nice". On the day, the only question is whether the Must column is done.

Check 1: does the timeline still end when you think it does?

A timeline where every start time is typed by hand is wrong by 14:00. The fix is to type only durations and let the start times chain:

A7 = start time (from a settings cell) A8 = IF(C8="", "", A7 + B7/1440)

B is minutes, C is the block name, and dividing by 1440 converts minutes to a fraction of a day, which is how spreadsheets store time. Copy A8 down. When the ceremony runs 20 minutes over, you change one number and every block below it moves.

The end time is the last non-empty row plus its duration:

= INDEX(A7:A66, COUNTA(C7:C66)) + INDEX(B7:B66, COUNTA(C7:C66)) / 1440

Compare total hours (SUM(B7:B66)/60) with your contracted hours and you know, at 9 a.m., whether you're going to be asked to stay for free.

Check 2: are the portraits before sunset?

The most common mistake in a hand-made timeline is golden-hour portraits scheduled at 14:30 in November, when golden hour starts at 16:42. Give each block a light type (Daylight / Indoor / Flash) and check whether any Daylight block starts within the hour before sunset:

= IF(COUNTIFS(E7:E66, "Daylight", A7:A66, ">=" & (Sunset - 1/24), A7:A66, "<" & Sunset) > 0, "Golden-hour portraits scheduled", "No daylight block in the hour before sunset — move couple portraits")

Add a conditional-format rule that turns a Daylight block red when its start time is after sunset. It is a surprisingly loud warning when you're building the timeline with a planner on a call.

Check 3: do the family formals fit the block?

List every grouping with the minutes it needs — three minutes each with a planner calling names, five without — and sum them. Then look up the minutes you actually allocated:

= INDEX(Timeline!B7:B66, MATCH("Family formals", Timeline!C7:C66, 0))

If needed > scheduled, the sheet tells you by how much. Twelve groupings in a twenty-minute block is how formals eat the couple session; seeing "add 13 minutes or cut groupings" before the wedding is how you avoid it. Put the biggest groups first and release people as you go.

Putting it together

The whole thing is five sheets: an Event sheet that everything reads from (couple, date, venues, sunset, start time, contracted hours), the chained timeline, the shot list with a Must/Nice column and a per-section summary (COUNTIFS(section, "Must", done, "✓")), the family-formals budget, and a contact sheet for the day. Print the timeline and contacts for the team, keep the shot list for yourself.

If you'd rather not build it, I packaged exactly this as a $6 workbook — Wedding Day Timeline & Shot List 2026 — with the 60-shot list, the sunset check, the formals budget and a sample wedding so you can see each flag fire before you clear it. The full studio version with bookings, deposits and deliverables is the Photographer Booking & Shot-List Pack.