Most creative agencies track revenue. Few track profit at the project level. That gap is where good work quietly loses money, and where studios that seem busy end up with nothing in the bank. A project profitability report gives West Melbourne Studios, or any agency doing client work, the data to understand exactly which jobs are worth repeating and which ones are costing more than they return.
What a project profitability report actually measures
A project profitability report compares what a project earned against what it cost to deliver. That sounds simple. In practice, most agencies miss the cost side entirely. They invoice the client fee, see a positive number, and call it done. But a project that billed $12,000 and consumed 160 hours of senior talent, two rounds of unplanned revisions, and a freelance hire that wasn't in the original estimate may have returned almost nothing per hour of real effort.
The report covers four cost categories:
- Labour: every hour spent on the project by every person, priced at their true cost to the business (salary plus on-costs, not their billing rate).
- Direct expenses: equipment hire, location fees, talent fees, catering, travel, and any other cost purchased specifically for this job.
- Subcontractor fees: payments to freelancers, editors, sound designers, colourists, or any third party engaged on the project.
- Overhead allocation: a proportional share of your studio's fixed costs (rent, software, insurance, administration) attributed to this project based on the hours it consumed.
Subtract the sum of those four from the revenue invoiced, and the result is gross project profit. Divide that by revenue to get your project margin. That margin number is the one that matters most.
Why most agencies skip it
Time tracking is unpopular. Allocating overhead feels abstract. And when a studio is busy, reporting on finished work feels like looking backwards when there's new work to chase. But the agencies that don't run project profitability reports tend to discover their real margins only when cash flow collapses, usually because they've been repeating the same money-losing project types for years without knowing it.
The fix isn't complicated. It requires a time-tracking habit, a simple template, and a commitment to review the numbers within two weeks of project completion, while the detail is still fresh.
How to structure the report
Keep the report to a single page for most projects. A bloated document won't get read, and the goal is action, not audit. The structure should be consistent across every project so you can compare them over time.
Start with three headline figures at the top: invoiced revenue, total cost, and gross margin percentage. Below that, break costs into the four categories above. Then add a short narrative section (three to five sentences) that explains any variance between the estimated margin and the actual one. Was the project under-scoped at the brief stage? Did revision rounds run over? Did a subcontractor bill more than expected? Name the specific cause. Vague notes like "took longer than expected" aren't actionable.
The final section should list two things: what the studio would price differently on a similar project next time, and whether this client or project type should be prioritised or avoided going forward. That judgement call is the whole point of the exercise. A well-run project debrief covers the creative and delivery side; the profitability report covers the commercial side. Both belong in the post-project record.
Setting a baseline margin target
Before a report can tell you whether a project performed well, you need a target to measure against. For a video production studio or creative agency, a gross project margin of 40–55% is a reasonable working range. Below 30% and a project is unlikely to be covering its true overhead share. Below 15% and you're effectively subsidising the client's job.
Your overhead budget tells you the floor. If your monthly fixed costs are $18,000 and your studio generates $45,000 in monthly revenue, your overhead rate is 40%. Any project margin below that number is actually unprofitable once overhead is included. If you don't have a clear overhead figure, the overhead budget template is the right place to start before building this report.
Using the report to improve future pricing
A project profitability report is most valuable as a pricing tool. Once you have a dozen reports across different project types, patterns emerge fast. Documentary-style case study videos may consistently return 50% margin because they're scoped tightly. Social media content packages may consistently return 22% because each deliverable requires more iteration than the original estimate assumes. Neither of those insights is available from looking at revenue alone.
Feed the real cost data from completed projects back into your quoting process. If a three-minute brand film reliably takes 80 hours of post-production time rather than the 60 hours in your standard estimate, your rate for that deliverable needs to reflect 80 hours. Carrying a wrong assumption into every new quote locks in a permanent margin gap. That's also why how you calculate your hourly rate matters so much: if the rate itself is built on undercooked cost assumptions, no amount of accurate project tracking will close the gap.
How often to run the report
Run a project profitability report for every project above your minimum size threshold. For smaller deliverables below that threshold, batch them monthly and run a combined report. The cadence matters less than the consistency. A studio that reviews project margins quarterly has 4 data points per year. A studio that reviews every finished project has 30 or 40, and can identify pricing problems 6 months earlier.
Store the reports in a shared folder that's accessible to whoever sets prices and whoever runs client conversations. Margin data locked in one person's spreadsheet doesn't change anything. Shared data changes behaviour across the whole studio.
A note on transparency with clients
Project profitability data is internal. Clients don't need to see your margins, and sharing them creates negotiating problems that don't need to exist. What clients can see is the output of better pricing: more accurate estimates, fewer surprise change orders, and a studio that can clearly articulate why a project costs what it costs. Those outcomes come directly from running this report consistently.
A project profitability report won't fix a badly scoped brief or an underpriced rate card on its own. But it gives you the numbers to have those conversations with evidence, not instinct.