Build a rate sheet for your services and gear

One list of everything you sell, with what you charge and what it costs you. It keeps your pricing consistent from one estimate to the next, and a free template gets you started.

If you price each job from memory, two clients can get two different day rates for the same work. A rate sheet fixes that. It is one list of every service you offer and every piece of gear you rent out, with what you charge for each and what each costs you.

Build it once and every estimate starts from the same numbers.

Price, cost and profit#

Give every line three numbers:

  • Price is what you bill the client.
  • Cost is what it costs you: what you pay the crew member, or what you pay to rent the item in.
  • Profit is price minus cost.

Write the cost down beside the price. Without it you cannot see the margin on a job until the job is over.

Each line also needs a unit: by the day or by the hour. Production work is typically billed by the day, and pre-production and post-production by the hour.

Your services#

List every role and service you put on an estimate: producer, director of photography, grip, editor and so on. For each one, record:

What to recordWhy
NameWhat the client sees on the estimate
DescriptionA note for your own team, not for the client
Price, cost and unitThe three numbers above, per day or per hour
Subcontracted?Whether you hire this role in, so you know which lines carry an outside cost
On every job?Whether it belongs on every estimate by default
More than one?Whether a job can need several, such as three grips

Your gear#

List the main items only: camera bodies, lenses, lights, tripods, audio recorders. Leave kits and small accessories such as batteries, cards and cables off this list. A kit is a bundle of items you have already listed, and accessories are easier to track on a list of their own.

For each item, record:

What to recordWhy
Manufacturer and modelSpelled the same way every time
Short nameWhat the client sees, such as "C400"
Purchase date and priceWhat you paid, and when
Rental priceWhat you charge per day
Rental costWhat it costs you per day. Zero if you own it outright
Replacement costWhat it would cost to replace today if it were destroyed
Serial numberUnique to the item

Put it in order#

A long list is hard to use, so group it. Three levels are enough:

  1. Category, such as Production
  2. Group, such as Camera Equipment
  3. Subgroup, such as Bodies or Lenses

The same groups then organise every estimate and every printout you send, so the client reads them in a sensible order.

Start with the free template#

You can build this in any spreadsheet. To save you laying it out, here is the Google Sheets template Project Binder uses, with a tab for services and a tab for gear:

Open the Google Sheets template

Google will ask to make a copy in your own account. Each tab has example rows to overwrite, and the profit column fills itself in.

The services tab of the template, with example rows for a producer, a director of photography and a production assistant
The services tab, with example data

Used on its own, the sheet is your reference: open it beside each estimate and copy the rates across. That keeps your prices consistent. The margin on each job is still yours to work out by hand, and when a rate changes you need to remember which open estimates were built on the old one.

Keep reading

  • The method

    The five stages of a production job

    Every job moves through the same five stages, from a first inquiry to closed books. Know which stage a job is in and you know what to do next.

    3 min read

All guides