Pricing spreadsheet template

Photography pricing spreadsheet template — what to track and how to structure it

A five-tab spreadsheet structure for calculating your cost floor, session scope, package margins, add-on pricing, and the buyer-facing quote check that converts profitable math into actual bookings.

Get my quote reviewed for $29 →Calculate cost floor

Copy-and-adapt structure

Photography pricing spreadsheet — five-tab structure

Spreadsheet structure

PHOTOGRAPHY PRICING SPREADSHEET — TEMPLATE STRUCTURE

—

TAB 1: COST FLOOR

Fixed costs (monthly — divide by sessions/month):
  Studio/office rent or share: $[X]
  Software subscriptions (editing, gallery, CRM, accounting): $[X]
  Insurance (general liability + equipment): $[X]
  Marketing and advertising: $[X]
  Professional development: $[X]
  Gear depreciation (annual cost ÷ 12): $[X]
  TOTAL FIXED/MONTH: $[X]
  FIXED COST PER SESSION (÷ avg sessions/month): $[X]

Variable costs (per session):
  Editing time: [X] hrs × $[rate/hr] = $[X]
  Shoot time: [X] hrs × $[rate/hr] = $[X]
  Travel/mileage: $[X]
  Culling and admin: [X] hrs × $[rate/hr] = $[X]
  Outsourcing (retouching, second shooter): $[X]
  TOTAL VARIABLE PER SESSION: $[X]

  COST FLOOR (fixed + variable): $[X]
  COST FLOOR + TARGET PROFIT MARGIN ([X]%): $[X] ← minimum rate

—

TAB 2: SESSION SCOPE ASSUMPTIONS

Session type: [Portrait / Wedding / Event / Headshot]
Shoot hours: [X]
Travel (round trip): [X] hours
Culling time (approx): [X] hours
Editing: [X] images at [X] min/image = [X] hours
Client communication (pre + post): [X] hours
Gallery delivery and admin: [X] hours
TOTAL HOURS PER SESSION: [X]

—

TAB 3: PACKAGE MARGINS

              Entry     Mid (★ Recommended)  Premium
Price:        $[X]      $[Y]                 $[Z]
Cost floor:   $[X]      $[X]                 $[X]
Variable:     $[X]      $[X]                 $[X]
PROFIT:       $[X]      $[X]                 $[X]
MARGIN (%):   [X]%      [X]%                 [X]%

Target: Mid > Entry margin. Premium ≥ Mid margin.

—

TAB 4: ADD-ONS

Add-on                         Unit cost   Your cost   Markup
Additional edited image         per image   $[X]        $[Y]
Rush delivery ([X]-day)         per job     $[X]        $[Y]
Second location                 per job     $[X]        $[Y]
Album / print product           per item    $[X]        $[Y]
Travel beyond [X] miles         per mile    $[X]        $[Y]

—

TAB 5: QUOTE CHECK FLAGS

□ Session scope stated (length, location count, image count)
□ "Not included" items visible
□ Delivery timeline stated
□ Retainer and payment schedule clear
□ Recommended package labeled
□ Add-ons priced separately
□ One booking next step present

Note: Replace all [bracketed] fields. The quote check in Tab 5 is not optional — a profitable margin does not close the booking if the buyer-facing quote is unclear.

Five tab guide

What each spreadsheet tab must capture

Tab 1 — Cost floor

Track fixed monthly costs (insurance, software, gear depreciation) and variable per-session costs (editing time, shooting time, delivery, travel). Divide fixed costs by sessions per month to get the fixed cost per session. Add variable costs. That sum is your floor — any package priced below it loses money before profit.

Tab 2 — Session scope assumptions

Document the time inputs that drive your cost floor: shoot hours, travel time, culling, editing hours per image, client communication, gallery delivery. When scope expands (longer shoot, more images, multiple locations), update these inputs and the cost floor recalculates.

Tab 3 — Package margins

Run the margin calculation for all three tiers. Entry package should cover the floor with a slim margin. Mid-tier should generate meaningfully more profit per session. Premium should justify the scope increase with proportional margin. Common error: premium is 2x the price but 3x the scope — it barely breaks even on time.

Tab 4 — Add-on pricing

Price each add-on individually: unit cost to you, what you charge the buyer, and margin. Extra images, rush delivery, second locations, travel beyond a mileage threshold, print products. Visible add-on prices prevent verbal upgrades that have no paper trail.

Tab 5 — Quote check flags

Before a quote goes out, check: session scope stated with specifics, "not included" items visible, delivery timeline stated, retainer and payment terms clear, recommended package labeled, one booking next step present. A profitable number on the spreadsheet can still lose the booking if the quote fails the check.

Spreadsheet to quote review

The spreadsheet can be correct while the quote still loses the booking.

The $29 Pricing Audit reviews one real spreadsheet-based price, package page, or quote — and identifies the specific gap between what the math says and what a buyer actually sees.

Start the $29 pricing audit See audit scope

Best paid next step

+Cost floor and margin calculation accuracy

+Package scope clarity and deliverable language

+Quote check flags and booking next step

Frequently asked questions

What should a photography pricing spreadsheet include?

A photography pricing spreadsheet should include at minimum: a cost floor tab (fixed and variable costs per session), a session scope assumptions tab (hours per shoot, edit time, travel), a package margins tab (entry, mid, premium with profit calculations), an add-on pricing tab, and a quote check tab. The math tells you whether the price is profitable. The quote check tells you whether the buyer-facing package is clear enough to convert.

How do I calculate my cost floor as a photographer?

Add all monthly fixed costs (studio, software, insurance, gear depreciation, marketing) and divide by the number of sessions you book per month. That gives you the fixed cost per session. Then add all variable costs per session (editing hours, shooting hours, travel, culling). The total is your cost floor — the minimum a session needs to generate before you have made a dollar of profit.

Is a pricing spreadsheet enough to set photography rates?

A spreadsheet protects the math — it ensures you are not booking sessions below cost. But a profitable number does not automatically produce a booking. The buyer-facing quote needs: package scope stated clearly, a recommended option labeled, add-ons priced separately, a delivery timeline, and a specific booking next step. Photographers who trust the math but skip the buyer-facing check end up with profitable rates and a low booking rate.

How often should I update my photography pricing spreadsheet?

Review the cost floor at least once per year, or immediately after any change that affects costs: a new software subscription, a gear purchase, a studio rate change, or a change in editing workflow. Review the package margins whenever you raise rates or restructure packages. A spreadsheet based on last year's costs will understate your actual cost floor — the most common reason photographers discover they have been undercharging.

What is the biggest mistake photographers make when building a pricing spreadsheet?

Forgetting to include their own time in the cost floor. A photography pricing spreadsheet that accounts for equipment, software, insurance, and marketing — but not the photographer's hourly rate for shooting, editing, communication, and administrative work — will produce a cost floor that is significantly below the real break-even rate. A full wedding, for example, typically requires 30–50 hours of total work including pre-wedding communication, the shooting day, and post-production. That time must be valued and included in the cost floor, or the rate it produces does not actually cover the cost of doing business.

How do I use a photography pricing spreadsheet to identify if I am undercharging?

Compare your current booking rate per session to your calculated cost floor (total annual costs divided by annual bookings, plus time cost per session). If your current rate is below the cost floor, you are losing money on every booking. If your rate is above the cost floor but you are fully booked and not meeting your income goal, the issue is capacity — you need fewer sessions at higher rates. If your rate is above cost floor but you have a low booking rate, either the rate exceeds your market tier or your buyer-facing quote is not converting. Each scenario has a different fix: the spreadsheet identifies which problem you actually have.

Related resources

Cost of doing business Package pricing calculator All pricing calculators $29 quote review Pricing mistakes Photography pricing help

From the ShootRate blog

Keep the pricing decision moving.

Each step supports the same job: turn a vague client inquiry into a price, package, and proposal that feels easier to approve.

Photography pricing helpDiagnose rates, packages, discount requests, and quotes that are not converting.Open workflow ->Pricing second opinionSend one real quote or pricing page before the buyer decides.Open workflow ->Pricing calculatorStart with scope, market, and experience before you quote.Open workflow ->Quote generatorTurn a live inquiry into client-ready pricing logic.Open workflow ->Pricing emailsSend quotes, follow-ups, and price replies that move buyers forward.Open workflow ->Inquiry replyQualify the lead before your first pricing answer creates price shopping.Open workflow ->Quote reviewGet one real quote checked before the buyer decides.Open workflow ->Follow-up templateMove a quiet buyer toward a clear yes, no, or scope tradeoff.Open workflow ->Objection responsesAnswer budget pushback without discounting the same package.Open workflow ->Discount replyTrade scope instead of cutting the exact same package.Open workflow ->Package pricing templateStructure starter, signature, and premium package tiers.Open workflow ->Proposal softwareBuild the price, package, and sales language together.Open workflow ->

Pricing second opinion

Have a real quote or package going out?

Send one live pricing moment before the buyer decides. The $29 review checks the first friction point and the next step to fix.

Start the $29 review See sample audit