Note: Overall totals include all historical data up to and including July 2025.
£493k
£367k
Discount:
£-125k (-25.5%)
£355k
Scope Change:
£-12k (-3.3%)
£322k
Unrealised:
£-33k (-9.3%)
£309k
Leakage:
£-13k (-4.0%)
£54k
Billing:
£-255k (-82.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) |
£0k | £0k | £0k | £0k | £0k | £0k |
| 2025 (Actual) (Up to July 2025) |
£212k | £157k | £159k | £187k | £171k | £0k |
| 2024 | £281k | £210k | £196k | £135k | £138k | £54k |
| 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) |
£0k |
£0k (0.0%) |
£0k (0.0%) |
- | - | - |
| 2025 (Actual) (Up to July 2025) |
£212k |
£-55k (-25.8%) |
£1k (0.9%) |
£28k (17.8%) |
£-16k (-8.4%) |
£-171k (-100.0%) |
| 2024 | £281k |
£-71k (-25.2%) |
£-13k (-6.4%) |
£-61k (-31.1%) |
£3k (2.0%) |
£-84k (-61.0%) |
| 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 | £69k | £27k | £28k | £29k | £29k | £28k | £1k | - | - | - | - | - | £212k |
| Planned | £52k | £20k | £21k | £22k | £22k | £21k | £1k | - | - | - | - | - | £157k |
| Corrected | £53k | £20k | £21k | £22k | £22k | £21k | £1k | - | - | - | - | - | £159k |
| Written | £67k | £71k | £28k | £14k | £6k | £0k | - | - | - | - | - | - | £187k |
| Revenue | £52k | £85k | £18k | £14k | £1k | - | - | - | - | - | - | - | £171k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | - | - | £0k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | - | - | - | - | - | - | - | - | - | £101k | £114k | £66k | £281k |
| Planned | - | - | - | - | - | - | - | - | - | £75k | £85k | £50k | £210k |
| Corrected | - | - | - | - | - | - | - | - | - | £67k | £79k | £51k | £196k |
| Written | - | - | - | - | - | - | - | - | - | £23k | £60k | £53k | £135k |
| Revenue | - | - | - | - | - | - | - | - | - | - | - | £138k | £138k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | - | £54k | £54k |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER2138 | VER2138-5 | 15500 | NL | Senior Consultant | No | 2024-10-07 | 2024-11-09 | 166% | 205.00 | 156.69 | 331.00 | 53.00 | |
| VER2138 | VER2138-3 | 15888 | GB | Director | No | 2024-10-09 | 2025-02-01 | 17% | 325.58 | 257.42 | 116.00 | 46.00 | |
| VER2138 | VER2138-4 | 15798 | GB | Manager | No | 2024-10-16 | 2025-02-01 | 31% | 267.44 | 190.27 | 192.00 | 160.00 | |
| VER2138 | VER2138-6 | 15833 | NL | Consultant | No | 2024-10-28 | 2024-11-09 | 390% | 172.50 | 123.12 | 312.00 | 32.00 | |
| VER2138 | VER2138-11 | 15888 | GB | Director | No | 2024-11-13 | 2025-02-01 | 0% | 325.58 | 257.42 | 0.00 | 86.00 | |
| VER2138 | VER2138-12 | 15798 | GB | Manager | No | 2024-11-13 | 2025-02-01 | 0% | 267.44 | 190.27 | 0.00 | 136.00 | |
| VER2251 | VER2251-2 | 15833 | NL | Consultant | No | 2024-11-01 | 2025-02-01 | 59% | 172.50 | 127.00 | 312.00 | 364.00 | |
| VER2251 | VER2251-1 | 15500 | NL | Senior Consultant | No | 2024-11-11 | 2025-02-01 | 69% | 205.00 | 161.75 | 331.00 | 331.00 | |
| VER2446 | VER2446-4 | 15888 | GB | Director | No | 2025-02-03 | 2025-07-01 | 3% | 343.75 | 263.10 | 24.00 | 24.00 | |
| VER2446 | VER2446-5 | 15798 | GB | Manager | No | 2025-02-03 | 2025-07-01 | 15% | 278.27 | 195.24 | 132.00 | 272.00 | |
| VER2446 | VER2446-6 | 15500 | NL | Senior Consultant | No | 2025-02-03 | 2025-07-01 | 29% | 210.00 | 160.71 | 248.00 | 238.00 | |
| VER2446 | VER2446-7 | 15833 | NL | Consultant | No | 2025-02-03 | 2025-07-01 | 31% | 175.00 | 126.19 | 264.00 | 176.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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER2138 | 15888 |
32.14
8.00
24.14
|
- | - | - | - | - | - | - | - | - | - | - |
32.14
8.00
24.14
|
|
| VER2138 | 15798 |
56.62
80.00
-23.38
|
- | - | - | - | - | - | - | - | - | - | - |
56.62
80.00
-23.38
|
|
| VER2138 | 15888 |
0.00
8.00
-8.00
|
- | - | - | - | - | - | - | - | - | - | - |
0.00
8.00
-8.00
|
|
| VER2138 | 15798 |
0.00
60.00
-60.00
|
- | - | - | - | - | - | - | - | - | - | - |
0.00
60.00
-60.00
|
|
| VER2251 | 15833 |
108.73
136.00
-27.27
|
- | - | - | - | - | - | - | - | - | - | - |
108.73
136.00
-27.27
|
|
| VER2251 | 15500 |
126.88
117.00
9.88
|
- | - | - | - | - | - | - | - | - | - | - |
126.88
117.00
9.88
|
|
| VER2446 | 15888 | - |
4.49
24.00
-19.51
|
4.71
0.00
4.71
|
4.93
0.00
4.93
|
4.94
0.00
4.94
|
4.71
0.00
4.71
|
0.22
0.00
0.22
|
- | - | - | - | - |
24.00
24.00
0.00
|
|
| VER2446 | 15798 | - |
24.67
120.00
-95.33
|
25.91
80.00
-54.09
|
27.14
48.00
-20.86
|
27.14
24.00
3.14
|
25.91
0.00
25.91
|
1.23
0.00
1.23
|
- | - | - | - | - |
132.00
272.00
-140.00
|
|
| VER2446 | 15500 | - |
46.36
152.00
-105.64
|
48.67
48.00
0.67
|
50.99
26.00
24.99
|
50.99
10.00
40.99
|
48.67
2.00
46.67
|
2.32
0.00
2.32
|
- | - | - | - | - |
248.00
238.00
10.00
|
|
| VER2446 | 15833 | - |
49.35
136.00
-86.65
|
51.81
40.00
11.81
|
54.28
0.00
54.28
|
54.28
0.00
54.28
|
51.81
0.00
51.81
|
2.47
0.00
2.47
|
- | - | - | - | - |
264.00
176.00
88.00
|