How Cost Tracking Works
Understand how ProductionPal blends estimated and actual costs to give you the most accurate financial picture at every stage.
The problem with all-or-nothing
Imagine you've estimated $50,000 in costs across five budget lines. The first invoice comes in — a $1,000 location deposit. If the system switches entirely to "actual" costs, your displayed cost drops to $1,000. That makes your margin look amazing… but it's completely misleading.
ProductionPal avoids this by using line-level blending.
How line-level blending works
Instead of choosing between estimates or actuals as a whole, ProductionPal looks at each cost line individually:
- 1Each line is evaluated independentlyFor every expense or labor line in your budget, the system checks: does this line have an actual amount entered?
- 2Actual wins when presentIf a line has an actual value, that value is used — even if it's $0. The estimate for that line is ignored.
- 3Estimates fill the gapsLines without actuals continue using their estimated amounts. This prevents the "cliff drop" when only some costs have landed.
- 4Everything is summedThe displayed total is the sum of all lines, mixing actuals and estimates as needed.
Example
A project has five cost lines. Two invoices have come in so far:
| Cost Line | Estimated | Actual | Used |
|---|---|---|---|
| Camera rental | $20,000 | $18,500 | $18,500 Actual |
| Location fee | $15,000 | — | $15,000 Estimate |
| Catering | $5,000 | $4,800 | $4,800 Actual |
| Transport | $3,000 | — | $3,000 Estimate |
| Editor (labor) | $7,000 | — | $7,000 Estimate |
| Total | $50,000 | $23,300 | $48,300 Partial Actual |
The badge tells you the status
The cost badge next to your total updates as actuals arrive:
| Badge | Meaning |
|---|---|
| Budget Estimate | No actual costs entered yet. All lines use estimates. |
| Partial Actual | Some lines have actuals, others still use estimates (blended). |
| Actual | Every cost line has a real actual amount. |
| Quick Estimate | No budget lines exist. Using the quick estimate from the project info. |
When does it become fully "Actual"?
The badge switches from Partial Actual to Actual only when every single cost line in the budget has an actual value filled in. Until then, the system keeps blending to prevent misleading margins.