The weekly cost report: ETC, EFC and variance

One document, one question

Everything in a cost report serves one question: where will this production finish financially? Answering it takes more than a list of what has been spent. For each budget account, the report carries the original budget, any approved revisions, the costs to date, the open commitments not yet invoiced, an estimate to complete, and the estimate of the final cost.

The last column is the one decision-makers read: the variance between the estimated final cost and the budget. A production can be under on spent-to-date and over on final cost, because the estimate to complete already contains the days, overtime and purchases everyone knows are still coming.

Actuals, commitments and accruals

Three kinds of numbers make up cost-to-date. Actuals are amounts invoiced and processed through accounts payable. Commitments are amounts the production is contractually obliged to pay but hasn't been invoiced for yet — open purchase orders, signed deals, worked-but-unpaid labor. Accruals are the costs that have been incurred with no paperwork at all, and estimating them honestly is what separates a report that warns from one that flatters.

A report built only from the checkbook is always behind the truth, and always behind by more as the shoot accelerates. The discipline is recognizing that cost happens when work happens, not when the invoice arrives.

• •Actuals: invoiced and processed costs — the hard numbers.
• •Commitments: promised but uninvoiced — POs, deals, worked labor.
• •Estimate to complete: judgment about the remainder, adjusted every week.

The estimate to complete is the skill

Budgets are arithmetic; the ETC is judgment. It has to absorb schedule slips, weather days, overtime trends, scope changes from the director or the client, and the difference between the bid's assumptions and the shoot's realities. A disciplined accountant adjusts it weekly with stated reasons; a lazy one lets it drift until wrap, at which point it is no longer an estimate, just a bill.

Hot costs compress the same logic into a daily shape: taking the day's labor and shooting data from the daily report and comparing the day's variable costs against the day's budget. It's the early-warning loop between the weekly reports, and it is only as accurate as the day's times and counts were captured.

Variance commentary and transfers

Numbers alone don't survive a financier's meeting. Every serious cost report ships with a written commentary: which accounts moved, why, and what — if anything — is being done. It also records budget transfers, the movements of money between accounts that keep individual accounts truthful while the total holds; transfers are legitimate management, but undocumented transfers are how reports stop reconciling.

The readership is broad and overlapping — producers, financiers, bond companies, incentive auditors — and each reads the same numbers for a different purpose. A report whose categories match the bid, whose commitments are visible, and whose commentary explains the movements serves all of them from one source.

How Clarice handles this

Clarice's reconciliation view is built as the cost report's moving parts: budget against actuals per account and category, with vendor invoices, purchase orders, petty cash and payroll actuals attributed to the lines they belong to, and overages tracked as dated, described change events on top.

Because every actual is linked to its budget line at entry, the variance is computed rather than retyped — and the project metrics and audit export draw from the same linked data, so the number a financier reads and the number the line producer manages are the same number.