What "Real-Time" Production Cost Reporting Actually Replaces

Ask most production accountants what a Friday afternoon looks like during principal photography and you will hear some version of the same story. Export the purchase order log. Chase three heads of department for their outstanding commitments. Reconcile the crew timesheets against payroll. Merge it all into the master budget spreadsheet, check the formulas have not broken again, and send out a cost report that reflects Wednesday's spend, not Friday's.

That process has been standard for long enough that most people in production finance no longer question it. But it is worth being specific about what it actually involves, because "real-time" only means something once you understand what it is replacing.

How Most Production Cost Reports Still Get Built

On a typical mid-size production, cost data lives in several places that do not talk to each other. Purchase orders sit in one system or spreadsheet. Crew and freelancer timesheets sit in another. Invoices arrive by email and get logged manually, often days after the work they cover. Heads of department track their own commitments, usually in whatever format suits them, which means the production accountant is reconciling several different versions of "what we have spent" before a single production cost report can go out.

This creates two separate problems. The first is manual consolidation. Every cost report becomes a small project in itself, pulling numbers out of disconnected files, matching them against the budget structure, and checking nothing has been double counted or missed. The second, more damaging problem is the lag between spend and visibility. A cost only shows up once it has been invoiced and entered, which means anything agreed but not yet billed, a booked extra day, a location fee, a late-added crew member, is effectively invisible until it lands as a surprise weeks later.

For a production accountant, this is not a failure of diligence. It is what happens when a live process is being run on tools that were never built to be live.

What Changes Inside Business Central via Just-TV

Just-TV is built directly on Microsoft Dynamics 365 Business Central, which changes the mechanics of cost reporting rather than just the presentation of it. Instead of spend appearing only once it is invoiced, a cost registers the moment it is committed, whether that is a purchase order, a booked freelance day, or a facilities agreement. That single change closes the timing gap that causes most of the surprises in a traditional cost report.

Two things follow from that. The first is a live cost-to-complete figure for every budget line, updated as commitments and actuals move, rather than recalculated once a week from a spreadsheet snapshot. The production accountant, the line producer and the financier are all looking at the same current position, not three slightly different versions built at different points in the week.

The second is automatic coding to cost centres. When a cost is entered, it is allocated straight to the correct department and cost code within the production's chart of accounts, rather than waiting for someone to manually tag and reconcile it later. This is one of the quieter but more valuable changes, because it removes the inconsistency that creeps in when different heads of department log commitments in slightly different ways. On a production with several departments and a tight cost centre structure, that consistency is what makes a cost report trustworthy rather than merely tidy.

Why This Matters Most During Principal Photography

Cost reporting delays matter at every stage of a production, but the cost of that delay is not constant. During development or post, a report that lags by a few days is inconvenient. During principal photography, it is where budget decisions actually get made or missed.

A shoot moves quickly. A department trending over budget on day four of a two-week block needs to be flagged on day four, not discovered in the following Monday's report once three more shoot days have compounded the problem. Same-day visibility gives producers and line producers the chance to adjust a schedule, reallocate spend between departments, or have the difficult conversation with a head of department while there is still budget left to protect. Once that window closes, the options narrow to absorbing the overspend or explaining it after the fact, neither of which is a decision anyone wants to be making retrospectively.

This is also the period when the volume of committed-but-unbilled cost is highest. Crew deals, additional hire, extended days and last-minute location changes all generate financial exposure well before an invoice exists. A cost report built on invoiced spend alone will always understate the true position during a shoot, precisely when the true position matters most.

Before and After: A Mid-Size Unscripted Production Reconciling Weekly Costs

Consider a typical eight-part observational documentary series, shooting across multiple locations with a production team of around thirty crew and a handful of freelance specialists rotating in and out each week.

Under a traditional process, the production accountant spends most of Thursday and Friday building the weekly cost report. Purchase orders are pulled from a shared spreadsheet that three different assistant producers have been updating inconsistently. Freelancer timesheets arrive by email through the week and get entered manually. Any crew deal agreed verbally on set does not appear until the invoice lands, sometimes ten days later. By the time the report reaches the executive producer on Monday, it reflects the previous Wednesday's position, and at least one below-the-line department is already further over its allocation than anyone realised.

With cost tracking running through Just-TV inside Business Central, the same production sees a different week. Purchase orders and crew bookings are entered once, coded automatically to the correct department and cost centre, and appear as committed cost immediately rather than waiting for an invoice. The production accountant opens a live view on Thursday afternoon that already reflects everything agreed that week, rather than spending two days reconstructing it. When the locations department books an additional day on Tuesday, that cost shows up against the locations budget on Tuesday, not three weeks later. The report the executive producer sees on Monday is not last Wednesday's picture reconstructed under time pressure. It is the current one.

The difference is not simply less admin, though that matters. It is that decisions about where to pull back, where there is genuine headroom, and where a department needs a conversation now rather than at the wrap party, can be made while the series is still shooting rather than once it has moved on.

See It Working on a Live Production

If your production's cost reporting still depends on Friday afternoon spreadsheet exports and a week-old picture of what has actually been spent, it is worth seeing the alternative directly. Get in touch with Creative Total Media to book a Just-TV demo and see live cost-to-complete, automatic cost centre coding and same-day variance tracking working against real production data.