THE 12 MONTH AUDIT / 01
Client Profitability Calculator
Two things this proves. Revenue is not profit. And every job has a cost base: crew at real day rates, plus gear and travel, with profit sitting on top. Rank your clients by that profit per day, not by what they invoice.
Fast start
Import your operating costs from your P&L
In Xero: Accounting → Reports → Profit and Loss, set the date range to the last 12 months, then Export to Excel or CSV. Drop the file below. It is read in your browser and nothing is uploaded anywhere.
Crew day rates
Your rate card
What you would pay to bring each role in for a day. Use these to work out the crew cost of each job. Cost your own days too.
Your breakeven line
The line to clear
Operating costs means running costs plus what your gear costs to replace, not just the bills that arrive. The workbook helps you total it.
Your jobs, last 12 months
One row per job. Crew cost is what it cost to supply the crew. Other costs is gear hire, travel, expendables and outsourced edit. Days is how long the job tied up your capacity. Profit is what is left, and it is not the same as the revenue.
| Job | Client | Revenue | Days | Crew cost | Other costs | Profit | Profit/day |
|---|
Revenue is not profit
Revenue invoiced
$0
across your clients
Cost base
$0
crew + other
Profit before overheads
$0
what the work left you
In every dollar
0c
the rest went out the door
Clients ranked by profit per day
| Profit # | Client | Revenue | Jobs | Days | Cost base | Profit | Profit / day | Value of 50 days | Same 50 days | Status |
|---|
The grey figure under each client is its rank by revenue. Compare it to the profit rank on the left. They rarely match. Green clears your target per day. Orange sits below breakeven, which means the rest of your book is subsidising it.