Estimate vs Actual: Why Does Anyone Care?
Welcome to the job after you landed it. Your AICP bid looked tight, the agency signed off, everyone cheered. Now the real horrors begin. Every cost drifts. The client wants three extra setups in the same 12-hour day. Your DP insists on a steadicam. Locations want more deposit. Suddenly, the estimate isn’t even in the rearview mirror, it's three exits back, and you’re not turning around.
Some producers blissfully ignore the difference until wrap. Others track every coffee receipt and still get blindsided. For agency producers and commercial shops, matching estimate to actual is your only hope of keeping the client from melt-down mode (and keeping your job next season).
Pre-Award: Lock the Estimate
Before tracking anything, you need a firm starting line. That’s your awarded bid, not your wild first version from the 2am fever dream. If you use AICP forms, make sure the client-signed version is locked (sections A through O, the works). Save that PDF in six places. Staple it to your monitor if you have to.
- Do not start tracking based on the "We’re thinking under $350k" call. Only the signed bid matters.
- Be relentless about revisions: every client-requested change, every agency creative note, new PDF. Number them. Don’t send a new quote in the body of your email.
Step 1: Set Up Your Live Tracker
Old school: Print the bid, scribble real payments in a column titled “Regret.”
21st century: Use tools that tie every real expense to the original bid line (so "Location, Rental" means the same on both).
Your tracker, whether Excel, Google Sheets, or something built for commercial production, should:
- List every original bid line (from your AICP or custom budget)
- Show the estimated amount
- Log "actuals" as rates are locked, invoices hit, purchases happen
- Automatically sum every section, flag overages in red, and show the overall variance
- Let you attach backup (invoices, notes, emails) per line, even if your desktop now looks like "FinalFinalForRealThisTime.pdf"
Track at the Right Detail
Do yourself a favor: Track on the same lines you bid. If you lumped "Set Dress & Props" in one, you can’t explain why you’re $2k over except to say, “Stuff got expensive.” Granular bidding saves future you.
Step 2: Hit Every Payment
Nothing blows up a job like late, missing or phantom payments. Real hours matter. If your crew signs out at midnight, the OT better be on your actuals by next day. Location holds, camera rentals, post costs, all hit at weird times, not always in the order you want.
Best practices:
- Reconcile at least every few days. Don’t wait for wrap. Friday morning is your friend.
- Build a habit: every invoice, every timecard, logged against its budget line today.
- Track POs, credit cards, e-transfers, plus cash. Small line items add up. Crafty for $40/day seems like nothing until you’re ten days deep.
- Don’t let “we’ll fix it in post” turn into “post spent triple.”
Step 3: Spot Fires Early
If you’re terrified to check the budget mid-shoot, you’re not alone. But catching overruns now is better than explaining them in front of twenty people after the client has already seen the number.
- Flag any budget line going over, even by $200. It’s easier to get sign-off now than beg forgiveness later.
- On big jobs, send a quick update email to agency/client: “Art department trending $1,500 over due to prop changes. Here’s a PDF. Any guidance?”
- If you’re saving on another line (under time, under crew), show math. Clients hate vague “it’ll even out.”
- When in doubt, document. If the client wants to approve an overage on the phone, follow up in writing.
Step 4: Wrap, Report, Survive
End of shoot. Your inbox is credits, timecards, forgotten receipts, blame. Now is when "estimate vs actual" earns its keep.
- Finalize all actuals, every single expense, not just the big ones.
- Export a clean PDF or share a read-only link to the agency/client, showing estimated, actual and variance per line.
- Brief summary at the top: “Job wrapped $3,450 over, driven by 2 days extra OT, new location fees, under on art.” (Don’t write a novel. Save it for the group therapy session.)
- If you came in under, circle in thick red marker. If not, line up your reasoning before you hit send.
Save these docs for the next bid. Nothing teaches realism like your own pain.
Why It Matters (Yes, Even If No One Checks)
Tracking estimate vs actual is torture because it removes all excuses. You’re forced to see the $500 you agreed on for "Lunch: burritos" became $180 in kombucha. It lets you answer the two questions every agency producer will ask at wrap:
- Where did we blow it this time?
- How do we not do it again?
The upside: When you track for real, you can justify your costs, get the next job (or the next raise) and protect your entire crew from those infamous, unpaid "gotchas." You become the person who actually knows where the money went. The only superpower anyone cares about in this business.
Do it in Pericles
If you’re already bidding commercials, Pericles does the estimate vs actual work as you go. When you create your AICP bid, every line becomes a live budget line in the project. As you spend (crew timecards, vendor payments, crafty, extras, delivery), Pericles tracks the actuals on each bid line. Overages go red, nothing slips. The estimate, every actual and the variance are all exportable, no retyping.
You can share a read-only report link with your client or agency, attach proof, and keep it for next time. Pericles keeps your wrap-out clean, even if the shoot wasn't.