Building project profitability reporting in a creative agency
Project-level profitability depends entirely on time capture, because staff cost is the largest cost in an agency and it cannot be allocated to a project that nobody recorded time against. This is an illustrative example of how Salt approaches agency profitability reporting, using a 20-person Australian creative agency as the profile.
Scenario — an illustrative example of how Salt approaches this problem. Not a description of a specific client engagement.
The business shape it describes: Australian creative agency, 20 staff, project-based.
- Scenario covers
- Bookkeeping and controller reporting on project and service-line profitability
- Jurisdiction
- Australia
- Sector
- Agencies
- Take an Australian creative agency of 20 staff measuring profitability at company level only, and assuming its service lines are broadly similar to each other.
- New business focuses on whichever work is easiest to sell, with no evidence about which work is actually worth winning.
- No time capture against projects, so staff cost, the largest cost in the business, cannot be allocated to anything.
- One service line consuming disproportionate senior time while priced as though it did not, which is invisible at company level because the profitable lines cover it.
- Rework not distinguished from first-time delivery, so a project delivered twice looks the same in the accounts as a project delivered once.
- Non-billable time uncategorised, so the difference between capacity and utilisation cannot be measured.
- Introduce project-level time capture with a small, stable set of codes, because a complex taxonomy is the fastest way to get unreliable data.
- Separate rework from first-time delivery in the capture design, since this cannot be retrofitted once the data has been collected without it.
- Allocate staff cost to projects on captured time and build per-project and per-service-line profitability reporting from it.
- Categorise non-billable time so utilisation is measured rather than assumed.
- Treat the first weeks of data as calibration rather than reporting, and say so in advance, so nobody makes a decision on numbers that are still settling.
- Project profitability rests entirely on time capture, and time capture is the part studio staff resist. Getting it to a standard where the allocation can be defended matters more than the reporting built on top of it.
- Separating rework from first-time delivery is a design decision that has to be made before the data is collected. Retrofitting it afterwards is not possible.
- The agency would be able to see profitability per project and per service line, so pricing and new business decisions rest on evidence.
- The true cost of rework would be visible as its own figure rather than absorbed into delivery cost.
- Utilisation would be measurable, which is what tells the agency whether it needs to hire or to reprice.
What we'd flag
Time capture is unpopular and takes time to become reliable. Until it is, the profitability numbers built on it cannot be trusted either, so the first period of reporting is calibration rather than evidence. Agencies that act on the first month's data usually act on noise.
Building project profitability reporting in a creative agency
Recognise this shape in your own books?
Tell us where you trade and what shape the books are in. You get scope, price and a start date in writing within one business day — no obligation.