Leakage Analysis

Reset
Target Fees

£54.5m

 

Planned Fees

£41.4m

Discount:
£-13.1m (-24.0%)

Corrected Fees

£44.8m

Scope Change:
£3.4m (8.1%)

Written Hours

£36.3m

Unrealised Revenue:
£-8.5m (-19.0%)

Revenue Assigned

£29.3m

Leakage:
£-6.9m (-23.6%)

Invoiced

£32.9m

Billing:
£3.5m (12.0%)

Project Leakage Summary
1146 / 1146 projects
Account ID Project ID Project Name Contract Start Month Target Fees Planned Fees Corrected Fees Written Hours Revenue Assigned Invoiced Discount Scope Change Unrealised Revenue Leakage Billing Discount (%) Scope Change (%) Unrealised Rev (%) Leakage (%) Billing (%)
1002395 VER2269 VER2269 Time & Material 2025-01 £5k £4k £4k £0k £0k £0k £-0k - £-4k - - -9.7% 0.0% -97.4% 0.0% 0.0%
1002185 VER1920 VER1920 Fixed Price 2024-05 £1k £1k £1k - £0k £25k £-0k £-0k £-1k £0k £25k -39.1% -0.7% -100.0% 100.0% 999.0%
1004843 VER1943 VER1943 Time & Material 2024-05 £18k £17k £17k £1k £0k £12k £-1k - £-16k £-0k £12k -7.5% 0.0% -96.9% -450.6% 999.0%
1001734 VER1699 VER1699 Fixed Price 2024-01 £1k £1k £1k £0k £0k £0k £-0k - £-0k £-0k - -30.3% 0.0% -50.0% -200.0% 0.0%
1004832 VER2169 VER2169 Time & Material 2024-11 £11k £11k £11k £0k £0k £0k £0k - £-11k £-0k £0k 0.1% 0.0% -99.6% -3.6% 103.3%
1001155 VER1345 VER1345 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003967 VER1359 VER1359 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003289 VER1368 VER1368 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003003 VER1370 VER1370 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000685 VER1376 VER1376 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003534 VER1383 VER1383 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004077 VER1388 VER1388 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004054 VER1398 VER1398 Fixed Price 2024-01 £23k £23k £73k - - £0k - £49k £-73k - £0k 0.0% 211.0% -100.0% 0.0% 0.0%
1000302 VER1399 VER1399 Fixed Price 2024-01 £17k £17k £27k - - £3k £-1k £11k £-27k - £3k -3.9% 64.6% -100.0% 0.0% 0.0%
1003978 VER1406 VER1406 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000138 VER1413 VER1413 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002396 VER1414 VER1414 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000534 VER1422 VER1422 Fixed Price 2024-01 £0k £0k £0k - - - - £-0k £-0k - - 0.0% -57.1% -100.0% 0.0% 0.0%
1004006 VER1423 VER1423 Fixed Price 2024-01 £14k £12k £22k - - £45k £-2k £9k £-22k - £45k -13.3% 73.7% -100.0% 0.0% 0.0%
1004162 VER1427 VER1427 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001223 VER1431 VER1431 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002469 VER1438 VER1438 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004172 VER1439 VER1439 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003651 VER1440 VER1440 Fixed Price 2024-01 £0k £0k £0k £8k - - - £0k £7k £-8k - 0.0% 302.3% 999.0% 0.0% 0.0%
1002261 VER1442 VER1442 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
Client Leakage Summary
511 / 511 clients
Account ID / Project ID Account Name / Project Name Project Count Target Fees Planned Fees Corrected Fees Written Hours Revenue Assigned Invoiced Discount Scope Change Unrealised Revenue Leakage Billing Discount (%) Scope Change (%) Unrealised Rev (%) Leakage (%) Billing (%)
1003967 1003967 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1359 VER1359 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002326 1002326 1 £0k £0k £0k - - £0k £0k £-0k £-0k - £0k 0.9% -72.7% -100.0% 0.0% 0.0%
VER1714 VER1714 £0k £0k £0k - - £0k £0k £-0k £-0k - £0k 0.9% -72.7% -100.0% 0.0% 0.0%
1002898 1002898 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1205 VER1205 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001382 1001382 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1473 VER1473 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006274 1006274 1 £98k - - - - - £-98k - - - - -100.0% 0.0% 0.0% 0.0% 0.0%
VER2514 VER2514 £98k - - - - - £-98k - - - - -100.0% 0.0% 0.0% 0.0% 0.0%
1002263 1002263 2 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1539 VER1539 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1808 VER1808 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000055 1000055 1 £6k £5k - - - - £-1k £-5k - - - -15.3% -100.0% 0.0% 0.0% 0.0%
VER2473 VER2473 £6k £5k - - - - £-1k £-5k - - - -15.3% -100.0% 0.0% 0.0% 0.0%
1005381 1005381 2 £26k £17k £10k £10k - - £-9k £-7k - £-10k - -35.2% -41.7% 0.0% 0.0% 0.0%
VER2046 VER2046 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2474 VER2474 £26k £17k £10k £10k - - £-9k £-7k - £-10k - -35.2% -41.7% 0.0% 0.0% 0.0%
1004455 1004455 2 £0k £0k £0k - - £3k £-0k £-0k £-0k - £3k -22.4% -4.9% -100.0% 0.0% 0.0%
VER2034 VER2034 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1897 VER1897 £0k £0k £0k - - £3k £-0k £-0k £-0k - £3k -22.4% -4.9% -100.0% 0.0% 0.0%
1006532 1006532 1 £78k £27k £27k £8k - - £-51k - £-20k £-8k - -65.0% 0.0% -71.9% 0.0% 0.0%
VER2583 VER2583 £78k £27k £27k £8k - - £-51k - £-20k £-8k - -65.0% 0.0% -71.9% 0.0% 0.0%
1000928 1000928 1 £1k £1k £1k £1k - - - - - £-1k - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2406 VER2406 £1k £1k £1k £1k - - - - - £-1k - 0.0% 0.0% 0.0% 0.0% 0.0%
1002469 1002469 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1438 VER1438 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006431 1006431 1 £4k £4k £4k £4k - - £-0k - - £-4k - -0.9% 0.0% 0.0% 0.0% 0.0%
VER2559 VER2559 £4k £4k £4k £4k - - £-0k - - £-4k - -0.9% 0.0% 0.0% 0.0% 0.0%
1002590 1002590 2 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2006 VER2006 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1482 VER1482 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004984 1004984 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1844 VER1844 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002841 1002841 2 £25k £24k £24k £7k - - £-2k - £-16k £-7k - -6.2% 0.0% -68.3% 0.0% 0.0%
VER2576 VER2576 £25k £24k £24k £7k - - £-2k - £-16k £-7k - -6.2% 0.0% -68.3% 0.0% 0.0%
VER1715 VER1715 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005180 1005180 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1960 VER1960 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004841 1004841 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1814 VER1814 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001084 1001084 5 £9k £9k £9k - - £35k £-0k - £-9k - £35k -4.4% 0.0% -100.0% 0.0% 0.0%
VER1959 VER1959 £9k £9k £9k - - £35k £-0k - £-9k - £35k -4.4% 0.0% -100.0% 0.0% 0.0%
VER1939 VER1939 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1641 VER1641 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1336 VER1336 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1842 VER1842 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005115 1005115 2 £2k £1k £1k - - - £-1k - £-1k - - -34.8% 0.0% -100.0% 0.0% 0.0%
VER2090 VER2090 £2k £1k £1k - - - £-1k - £-1k - - -34.8% 0.0% -100.0% 0.0% 0.0%
VER1908 VER1908 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004753 1004753 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1848 VER1848 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000291 1000291 1 £2k £1k £0k - - - £-0k £-1k £-0k - - -20.7% -91.7% -100.0% 0.0% 0.0%
VER50 VER50 £2k £1k £0k - - - £-0k £-1k £-0k - - -20.7% -91.7% -100.0% 0.0% 0.0%
1004865 1004865 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1880 VER1880 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003627 1003627 1 £11k £10k £10k - - - £-1k - £-10k - - -6.7% 0.0% -100.0% 0.0% 0.0%
VER2528 VER2528 £11k £10k £10k - - - £-1k - £-10k - - -6.7% 0.0% -100.0% 0.0% 0.0%
1005689 1005689 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2122 VER2122 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%