Note: Overall totals include all historical data up to and including July 2025.
£590k
£408k
Discount:
£-182k (-30.9%)
£345k
Scope Change:
£-63k (-15.4%)
£348k
Unrealised:
£3k (1.0%)
£243k
Leakage:
£-105k (-30.3%)
£234k
Billing:
£-9k (-3.6%)
Note: '2025 (Actual)' includes data up to and including July 2025. '2025 (Forecast)' includes data after this date.
| Time Period | Target Fees | Planned Fees | Corrected Fees | Written Hours | Revenue Assigned | Invoiced |
|---|---|---|---|---|---|---|
| 2025 (Forecast) (After July 2025) |
£167k | £100k | £76k | £0k | £0k | £0k |
| 2025 (Actual) (Up to July 2025) |
£208k | £127k | £96k | £104k | £39k | £0k |
| 2024 | £382k | £281k | £249k | £244k | £204k | £234k |
| Pre-2024 | £0k | £0k | £0k | £0k | £0k | £0k |
Note: '2025 (Actual)' includes data up to and including July 2025. '2025 (Planned)' includes data after this date.
| Time Period | Target Fees | Discount | Scope Change | Unrealised Revenue | Leakage | Billing |
|---|---|---|---|---|---|---|
| 2025 (Forecast) (After July 2025) |
£167k |
£-67k (-40.1%) |
£-25k (-24.5%) |
- | - | - |
| 2025 (Actual) (Up to July 2025) |
£208k |
£-81k (-39.0%) |
£-31k (-24.3%) |
£8k (8.6%) |
£-65k (-62.5%) |
£-39k (-100.0%) |
| 2024 | £382k |
£-101k (-26.5%) |
£-32k (-11.3%) |
£-5k (-2.0%) |
£-40k (-16.5%) |
£30k (14.9%) |
| Pre-2024 | £0k |
£0k (0.0%) |
£0k (0.0%) |
£0k (0.0%) |
£0k (0.0%) |
£0k (0.0%) |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | £2k | - | £6k | £33k | £56k | £53k | £58k | £53k | £56k | £58k | - | - | £375k |
| Planned | £2k | - | £4k | £21k | £33k | £32k | £35k | £32k | £33k | £35k | - | - | £227k |
| Corrected | £2k | - | £3k | £16k | £25k | £24k | £26k | £24k | £25k | £26k | - | - | £172k |
| Written | - | - | - | £13k | £30k | £59k | £2k | - | - | - | - | - | £104k |
| Revenue | - | - | - | £14k | £26k | - | - | - | - | - | - | - | £39k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | - | - | £0k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | - | - | - | - | £19k | £48k | £55k | £52k | £50k | £55k | £50k | £52k | £382k |
| Planned | - | - | - | - | £14k | £35k | £40k | £39k | £37k | £40k | £37k | £39k | £281k |
| Corrected | - | - | - | - | £12k | £31k | £36k | £34k | £33k | £36k | £33k | £34k | £249k |
| Written | - | - | - | - | £0k | £64k | £88k | £40k | £29k | £18k | £5k | - | £244k |
| Revenue | - | - | - | - | - | £66k | £68k | £52k | £28k | £-0k | £0k | £-9k | £204k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | £164k | £70k | £234k |
Note: This table lists all allocation tasks for the client's projects. Non-billable tasks and tasks without an assigned resource are excluded from financial summaries but are shown here for completeness.
| Project ID | Task ID | Resource ID | Country | Grade | Billable | Start Date | End Date | Allocations (%) | Target Price | Agreed Price | Corrected Hours | Actual Hours | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER1980 | VER1980-15 | 15566 | NL | Business Associate | No | 2024-05-22 | 2025-01-01 | 13% | 210.00 | 210.00 | 161.00 | 161.00 | |
| VER1980 | VER1980-3 | 15696 | NL | Consultant | No | 2024-05-22 | 2025-01-01 | 0% | 165.00 | 192.00 | 1.00 | 0.00 | |
| VER1980 | VER1980-6 | 10211 | CH | Partner | No | 2024-05-22 | 2025-01-01 | 0% | 494.79 | 192.00 | 0.00 | 20.00 | |
| VER1980 | VER1980-7 | 18 | NL | Partner | No | 2024-05-22 | 2025-01-01 | 6% | 397.50 | 192.00 | 80.00 | 51.00 | |
| VER1980 | VER1980-8 | 15744 | NL | Senior Manager | No | 2024-05-22 | 2025-01-01 | 29% | 262.50 | 192.00 | 378.00 | 378.00 | |
| VER1980 | VER1980-10 | 15606 | NL | Manager | No | 2024-05-22 | 2025-01-01 | 17% | 235.00 | 171.00 | 220.00 | 220.00 | |
| VER1980 | VER1980-9 | 15647 | NL | Senior Consultant | No | 2024-05-22 | 2025-01-01 | 19% | 205.00 | 150.00 | 250.00 | 250.00 | |
| VER1980 | VER1980-16 | 15503 | NL | Senior Consultant | No | 2024-05-22 | 2025-01-01 | 5% | 205.00 | 126.00 | 68.00 | 32.00 | |
| VER1980 | VER1980-5 | 15817 | BE | Consultant | No | 2024-05-22 | 2025-01-01 | 10% | 172.50 | 126.00 | 132.00 | 132.00 | |
| VER1980 | VER1980-4 | 15839 | NL | Consultant | No | 2024-05-22 | 2025-01-01 | 21% | 172.50 | 103.00 | 274.00 | 274.00 | |
| VER2517 | VER2517-4 | 15566 | NL | Business Associate | No | 2025-03-21 | 2025-11-01 | 6% | 212.50 | 212.50 | 80.00 | 48.00 | |
| VER2517 | VER2517-7 | 15829 | DE | Senior Consultant | No | 2025-03-21 | 2025-11-01 | 0% | 210.00 | 150.00 | 0.00 | 0.00 | |
| VER2517 | VER2517-10 | 15762 | NL | Manager | No | 2025-03-21 | 2025-11-01 | 29% | 242.50 | 150.00 | 368.00 | 172.00 | |
| VER2517 | VER2517-2 | 15250 | NL | Director | No | 2025-04-16 | 2025-11-01 | 24% | 312.50 | 212.50 | 280.00 | 187.00 | |
| VER2517 | VER2517-3 | 18 | NL | Partner | No | 2025-04-22 | 2025-11-01 | 1% | 407.50 | 212.50 | 16.00 | 29.00 | |
| VER2517 | VER2517-6 | 16031 | DE | Senior Consultant | No | 2025-04-22 | 2025-11-01 | 3% | 210.00 | 150.00 | 32.00 | 32.00 | |
| VER2517 | VER2517-8 | 15723 | NL | Consultant | No | 2025-04-22 | 2025-11-01 | 22% | 175.00 | 0.00 | 240.00 | 114.50 | |
| VER2517 | VER2517-5 | 15791 | DE | Partner | No | 2025-04-25 | 2025-11-01 | 13% | 407.50 | 212.50 | 142.00 | 80.00 |
Table cells show: Corrected Hours (Planned + Correction) / Actual Hours (Timesheet) / Difference
| Project ID | Resource ID | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER1980 | 15566 |
1.00
0.00
1.00
|
- | - | - | - | - | - | - | - | - | - | - |
1.00
0.00
1.00
|
|
| VER1980 | 15696 |
0.01
0.00
0.01
|
- | - | - | - | - | - | - | - | - | - | - |
0.01
0.00
0.01
|
|
| VER1980 | 18 |
0.50
0.00
0.50
|
- | - | - | - | - | - | - | - | - | - | - |
0.50
0.00
0.50
|
|
| VER1980 | 15744 |
2.35
0.00
2.35
|
- | - | - | - | - | - | - | - | - | - | - |
2.35
0.00
2.35
|
|
| VER1980 | 15606 |
1.37
0.00
1.37
|
- | - | - | - | - | - | - | - | - | - | - |
1.37
0.00
1.37
|
|
| VER1980 | 15647 |
1.55
0.00
1.55
|
- | - | - | - | - | - | - | - | - | - | - |
1.55
0.00
1.55
|
|
| VER1980 | 15503 |
0.42
0.00
0.42
|
- | - | - | - | - | - | - | - | - | - | - |
0.42
0.00
0.42
|
|
| VER1980 | 15817 |
0.82
0.00
0.82
|
- | - | - | - | - | - | - | - | - | - | - |
0.82
0.00
0.82
|
|
| VER1980 | 15839 |
1.70
0.00
1.70
|
- | - | - | - | - | - | - | - | - | - | - |
1.70
0.00
1.70
|
|
| VER2517 | 15566 | - | - |
3.48
0.00
3.48
|
10.93
0.00
10.93
|
10.93
2.00
8.93
|
10.44
46.00
-35.56
|
11.43
0.00
11.43
|
10.43
0.00
10.43
|
10.93
0.00
10.93
|
11.43
0.00
11.43
|
- | - |
80.00
48.00
32.00
|
|
| VER2517 | 15762 | - | - |
16.00
0.00
16.00
|
50.29
0.00
50.29
|
50.29
24.00
26.29
|
48.00
148.00
-100.00
|
52.57
0.00
52.57
|
48.00
0.00
48.00
|
50.28
0.00
50.28
|
52.57
0.00
52.57
|
- | - |
368.00
172.00
196.00
|
|
| VER2517 | 15250 | - | - | - |
21.54
34.00
-12.46
|
43.08
75.00
-31.92
|
41.12
71.00
-29.88
|
45.03
7.00
38.03
|
41.12
0.00
41.12
|
43.08
0.00
43.08
|
45.03
0.00
45.03
|
- | - |
280.00
187.00
93.00
|
|
| VER2517 | 18 | - | - | - |
0.81
2.00
-1.19
|
2.53
10.00
-7.47
|
2.42
17.00
-14.58
|
2.65
3.00
-0.35
|
2.42
0.00
2.42
|
2.53
0.00
2.53
|
2.64
0.00
2.64
|
- | - |
16.00
32.00
-16.00
|
|
| VER2517 | 16031 | - | - | - |
1.61
32.00
-30.39
|
5.06
0.00
5.06
|
4.83
0.00
4.83
|
5.30
0.00
5.30
|
4.83
0.00
4.83
|
5.07
0.00
5.07
|
5.30
0.00
5.30
|
- | - |
32.00
32.00
0.00
|
|
| VER2517 | 15723 | - | - | - |
12.09
0.00
12.09
|
37.99
0.00
37.99
|
36.26
0.00
36.26
|
39.71
0.00
39.71
|
36.26
0.00
36.26
|
37.98
0.00
37.98
|
39.71
0.00
39.71
|
- | - |
240.00
0.00
240.00
|
|
| VER2517 | 15791 | - | - | - |
4.18
2.00
2.18
|
22.97
38.00
-15.03
|
21.93
40.00
-18.07
|
24.01
0.00
24.01
|
21.93
0.00
21.93
|
22.97
0.00
22.97
|
24.01
0.00
24.01
|
- | - |
142.00
80.00
62.00
|