Film Production – Your Daily Report Card

hotcost The Hot Cost measures the daily cost of labor (Cast and Crew) with the budgeted amount of daily labor – along with the page shot compared to the page count planned to be shot that day. It goes to all financiers, studio execs, the completion guarantor, etc – establishing your credentials as a Producer/Production Manager. You could call this your daily financial report card.


The Film Production Accountant prepares it, usually without too much input from the UPM or assistant accountants. Some key film production accountants involve their payroll accountant; however, I have found that unsuccessful – it simply puts too much burden on the payroll accountant. The Hot Cost should be prepared with enough information to be checked by the UPM.


Each day the Assistant Director’s prepare a “Daily Production Report”. The In/Out times, as well as the lunch break, is recorded on the DPR. Every person who worked on set is named along with their title. In addition, the DPR shows all the times related to each and every actor, the number of lunch plates, the page count shot (per the Script Supervisor),any notations of accidents/delivery of major equipment/illnesses, etc. From the DPR the Key Film Production Accountant calculates the actual costs of cast and crew for the day and compares it to the budgeted  daily cost.


You really need to have a grasp of the cast and crew union rules for calculating payroll in order to effectively manage the hot cost reports. Once you get a grasp the union rules you’ll start to wonder what all the fuss was about. No matter what union contracts you’re dealing with, each Union has broken down their rules into the following 4 categories:

1. The “Basic Day” and Overtime Rules

2. The penalties associated with “Rest Violations” (also called “Turnaround”).

3. The penalties associated with violating Meal Periods (called “Meal Penalties”).

4. The various circumstances associated with Travel – whether to a “Distant Location” (i.e. staying in a hotel), or travelling outside of a defined “Studio Zone” (also often referred to in each locale as “The Circle”).

For those of you newly exposed to Screen Actors Guild, the various IATSE (crew) Locals and the Teamster (driver) Locals, it may seem a little too much; however, it’s MUCH easier than learning to use Excel – so, have a little patience, do a lot of practice time cards, and you’ll have it.


The solution to understanding any Hot Cost is to find a central source of contracts for SAG, DGA and IATSE then summarize the four rules mentioned above. Then have someone show you their version of Excel formulas which comply with these central rules. At the risk of shameless self-promotion, I have done that, one union at a time for each of SAG, DGA, IATSE National Low Budget (any feature or TV production in North America less than $13Mil) and IATSE Area Standards (any feature or TV production greater than $13Mil outside of the Los Angeles and New York zones). I have a general Teamster contract for the non-LA/NY areas, but, honestly, it’s child’s play to understand after learning the above. Actually, it is not a problem for me to say that if you understand SAG, DGA, IATSE Low Budget and IATSE Area Standards you can work anywhere in America or Canada – it would only be necessary to get a copy of the local contracts in those higher production centers and you’d be ready in a day or so.


I’ve found that a full weekend practicing the film and television payroll rules, followed up by on-line links to all the materials, is plenty for your average person to learn how to calculate the union/guild payrolls to “gross” (i.e. to the gross amount of pay due before union and government benefits/deductions). I also supply templates (yes, with the formulas) which are “helpers” ad which you can use to develop your own Hot Costs, no matter the circumstances. I leave you with on-line links to all of the materials – see this link to get an idea of what I mean.

Have a look at this link to a short video of how my SAG on-line course works.

Check out  for live weekend payroll workshops, as well as workshops on Film Accounting.

If you are already a film accountant and would like to learn more about Hot Costs, see this short video.




About filmproduction
I have worked in the film production industry since 1985, working on over 50 different productions of every size in 6 different countries. My self-published book, "Walk The Talk" is written in an easy to read manner for film students and working professionals who haven't had the chance to learn how to 'Direct the Money'.

4 Responses to Film Production – Your Daily Report Card

  1. Thank you again John for being the best source of this very specialized film accounting knowledge. Your course gave me a great career boost; I would heartily recommend it to anyone.

  2. Thx for the nice comment, Andrew. I appreciate it.

  3. Jessica says:

    John – This excel hot cost sheet is actually exactly like the one I’m trying to create right now. Would you share this template?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: