# Client Profitability Calculator · VBA

Source: https://denlennie.com/field-guides/client-profitability-calculator

Fast start

## Import your operating costs from your P&L

In Xero: **Accounting &rarr; Reports &rarr; 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.

**Get things off your plate.**Shooting, quoting, sales, the books: if every job still runs through you, there's no time left to grow the business. Bring the one you can't let go of to the Elite Boardroom and leave with one move. Between calls, you get an answer.

[Apply to the Boardroom](https://denlennie.com/apply/)

© 2026 Den Lennie. Free to read and use in your own business. Not for republishing or resale.
