Note: Overall totals include all historical data up to and including July 2025.
£142k
£118k
Discount:
£-25k (-17.2%)
£95k
Scope Change:
£-23k (-19.7%)
£65k
Unrealised:
£-29k (-31.1%)
£64k
Leakage:
£-1k (-1.6%)
£75k
Billing:
£11k (17.4%)
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) |
£37k | £30k | £32k | £30k | £29k | £56k |
| 2024 | £105k | £88k | £63k | £35k | £35k | £19k |
| 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) |
£37k |
£-7k (-19.6%) |
£1k (4.8%) |
£-2k (-5.2%) |
£-1k (-3.4%) |
£27k (94.0%) |
| 2024 | £105k |
£-17k (-16.4%) |
£-25k (-28.1%) |
£-28k (-44.1%) |
£0k (0.0%) |
£-16k (-45.2%) |
| 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 | £16k | £7k | £7k | £7k | £0k | - | - | - | - | - | - | - | £37k |
| Planned | £14k | £5k | £5k | £6k | £0k | - | - | - | - | - | - | - | £30k |
| Corrected | £10k | £7k | £7k | £8k | £0k | - | - | - | - | - | - | - | £32k |
| Written | £11k | £8k | £1k | £9k | - | - | - | - | - | - | - | - | £30k |
| Revenue | £4k | £15k | £1k | £6k | £3k | - | - | - | - | - | - | - | £29k |
| Invoiced | £31k | - | - | - | £25k | - | - | - | - | - | - | - | £56k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | £17k | £10k | £10k | - | - | - | - | - | £10k | £20k | £19k | £19k | £105k |
| Planned | £15k | £8k | £8k | - | - | - | - | - | £8k | £17k | £16k | £16k | £88k |
| Corrected | £15k | £8k | £8k | - | - | - | - | - | £5k | £10k | £9k | £9k | £63k |
| Written | £5k | - | - | - | - | - | - | - | £3k | £9k | £12k | £8k | £35k |
| Revenue | £5k | £-1k | - | - | - | - | - | - | £3k | £9k | £12k | £8k | £35k |
| Invoiced | £15k | £5k | - | - | - | - | - | - | - | - | - | - | £19k |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER1532 | VER1532-1 | 15382 | NL | Senior Consultant | No | 2023-09-01 | 2024-03-30 | 30% | 197.50 | 158.00 | 368.00 | 368.00 | |
| VER1579 | VER1579-1 | 15273 | GB | Business Associate | No | 2023-10-16 | 2024-01-31 | 15% | 200.00 | 200.00 | 96.00 | 84.00 | |
| VER2117 | VER2117-1 | 15614 | NL | Consultant | No | 2024-09-16 | 2025-01-21 | 5% | 172.50 | 158.00 | 35.00 | 35.00 | |
| VER2117 | VER2117-3 | 15328 | NL | Senior Consultant | No | 2024-09-16 | 2025-01-21 | 29% | 205.00 | 158.00 | 210.00 | 189.25 | |
| VER2429 | VER2429-3 | 15571 | NL | Business Associate | No | 2025-01-16 | 2025-05-01 | 3% | 200.00 | 200.00 | 16.00 | 16.00 | |
| VER2429 | VER2429-1 | 15328 | NL | Senior Consultant | No | 2025-01-21 | 2025-05-01 | 24% | 210.00 | 158.00 | 139.50 | 139.50 |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER2117 | 15614 |
5.71
0.00
5.71
|
- | - | - | - | - | - | - | - | - | - | - |
5.71
0.00
5.71
|
|
| VER2117 | 15328 |
34.24
29.50
4.74
|
- | - | - | - | - | - | - | - | - | - | - |
34.24
29.50
4.74
|
|
| VER2429 | 15571 |
2.53
0.00
2.53
|
4.21
0.00
4.21
|
4.42
0.00
4.42
|
4.63
16.00
-11.37
|
0.21
0.00
0.21
|
- | - | - | - | - | - | - |
16.00
16.00
0.00
|
|
| VER2429 | 15328 |
17.20
43.00
-25.80
|
38.22
49.00
-10.78
|
40.13
8.00
32.13
|
42.04
39.50
2.54
|
1.91
0.00
1.91
|
- | - | - | - | - | - | - |
139.50
139.50
0.00
|