Account ID
Account Name
Project ID
Project Name
Type
Manager ID
Sales Currency
Project Category
Competency
Area of Expertise
Contract Start
Allocations Start
Contract End
Allocations End
Note: Overall totals include all historical data up to and including July 2025.
£427k
£369k
Discount:
£-58k (-13.7%)
£348k
Scope Change:
£-21k (-5.6%)
£259k
Unrealised:
£-89k (-25.5%)
£144k
Leakage:
£-116k (-44.6%)
£202k
Billing:
£58k (40.3%)
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) |
£207k | £168k | £146k | £104k | £26k | £57k |
| 2024 | £220k | £200k | £202k | £156k | £118k | £145k |
| 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) |
£207k |
£-39k (-18.7%) |
£-22k (-13.2%) |
£-43k (-29.1%) |
£-77k (-74.8%) |
£31k (118.2%) |
| 2024 | £220k |
£-20k (-9.0%) |
£2k (0.8%) |
£-46k (-22.9%) |
£-38k (-24.5%) |
£27k (23.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 | £26k | £25k | £26k | £28k | £53k | £47k | £2k | - | - | - | - | - | £207k |
| Planned | £22k | £21k | £22k | £23k | £42k | £37k | £2k | - | - | - | - | - | £168k |
| Corrected | £19k | £17k | £18k | £18k | £38k | £35k | £2k | - | - | - | - | - | £146k |
| Written | £14k | £16k | £17k | £7k | £20k | £28k | - | - | - | - | - | - | £104k |
| Revenue | £9k | £9k | £2k | £1k | £6k | - | - | - | - | - | - | - | £26k |
| Invoiced | £11k | £11k | £11k | - | £11k | £11k | - | - | - | - | - | - | £57k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | £18k | £17k | £17k | £19k | £20k | £17k | £20k | £19k | £18k | £20k | £18k | £19k | £220k |
| Planned | £16k | £15k | £16k | £17k | £18k | £16k | £18k | £17k | £16k | £18k | £16k | £17k | £200k |
| Corrected | £16k | £15k | £16k | £17k | £18k | £16k | £18k | £17k | £17k | £18k | £17k | £17k | £202k |
| Written | £19k | £18k | £18k | £20k | £13k | £13k | £10k | £13k | £11k | £7k | £8k | £5k | £156k |
| Revenue | £11k | £11k | £9k | £18k | £7k | £25k | £-2k | £8k | £4k | £10k | £10k | £6k | £118k |
| Invoiced | £12k | £12k | £12k | £12k | £12k | £12k | £12k | £12k | £12k | £12k | £12k | £12k | £145k |
Note: This table lists all allocation tasks for the project. 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER1428 | VER1428-5 | 15369 | US | Director | No | 2023-06-01 | 2025-05-31 | 1% | 393.75 | 393.75 | 50.00 | 0.00 | |
| VER1428 | VER1428-8 | 15592 | US | Consultant | No | 2023-06-01 | 2025-07-01 | 21% | 256.25 | 180.00 | 934.00 | 860.00 | |
| VER1428 | VER1428-7 | 15549 | GB | Consultant | No | 2023-06-01 | 2025-05-31 | 0% | 203.49 | 158.00 | 0.00 | 0.00 | |
| VER1428 | VER1428-9 | 15546 | ZA | Consultant | No | 2023-06-09 | 2025-05-31 | 1% | 97.50 | 110.00 | 25.50 | 25.50 | |
| VER1428 | VER1428-4 | 15296 | GB | Senior Manager | No | 2023-06-12 | 2025-07-01 | 9% | 276.16 | 237.50 | 400.00 | 370.50 | |
| VER1428 | VER1428-6 | 15519 | ZA | Senior Manager | No | 2023-07-03 | 2025-07-01 | 3% | 162.50 | 162.50 | 114.50 | 84.50 | |
| VER1428 | VER1428-11 | 15710 | ZA | Senior Consultant | No | 2023-08-03 | 2025-07-01 | 5% | 110.00 | 162.50 | 208.50 | 207.50 | |
| VER1428 | VER1428-12 | 15435 | ZA | Business Associate | No | 2023-08-09 | 2025-07-01 | 3% | 232.25 | 232.25 | 100.00 | 8.00 | |
| VER1428 | VER1428-10 | 15547 | ZA | Senior Consultant | No | 2023-09-13 | 2025-07-01 | 3% | 110.00 | 110.00 | 97.00 | 77.00 | |
| VER1428 | VER1428-13 | 15706 | US | Interim | No | 2024-03-18 | 2025-07-01 | 7% | 146.23 | 146.23 | 200.00 | 181.00 | |
| VER1428 | VER1428-14 | 15596 | US | Consultant | No | 2025-01-13 | 2025-07-01 | 4% | 246.65 | 160.71 | 36.00 | 6.00 | |
| VER1428 | VER1428-19 | 16104 | ZA | Senior Consultant | No | 2025-05-01 | 2025-07-01 | 18% | 123.75 | 145.09 | 64.00 | 10.50 | |
| VER1428 | VER1428-18 | 15871 | IN | Senior Consultant | No | 2025-05-01 | 2025-07-01 | 28% | 210.00 | 98.21 | 100.00 | 71.50 | |
| VER1428 | VER1428-15 | 15897 | ZA | Consultant | No | 2025-05-01 | 2025-07-01 | 28% | 108.75 | 98.21 | 100.00 | 87.00 | |
| VER1428 | VER1428-16 | 15961 | ZA | Consultant | No | 2025-05-01 | 2025-07-01 | 28% | 108.75 | 98.21 | 100.00 | 96.00 |
Table cells show: Corrected Hours (Planned + Correction) / Actual Hours (Timesheet) / Difference
| Resource ID | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15369 |
2.20
0.00
2.20
|
1.92
0.00
1.92
|
2.01
0.00
2.01
|
2.11
0.00
2.11
|
2.11
0.00
2.11
|
- | - | - | - | - | - | - |
10.35
0.00
10.35
|
| 15592 |
39.49
52.00
-12.51
|
34.35
41.00
-6.65
|
36.05
29.50
6.55
|
37.77
12.00
25.77
|
37.78
12.50
25.28
|
36.06
23.50
12.56
|
1.72
0.00
1.72
|
- | - | - | - | - |
223.22
170.50
52.72
|
| 15549 |
0.00
0.00
0.00
|
0.00
0.00
0.00
|
0.00
0.00
0.00
|
0.00
0.00
0.00
|
0.00
0.00
0.00
|
- | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15546 |
1.13
0.00
1.13
|
0.99
0.00
0.99
|
1.04
0.00
1.04
|
1.10
0.00
1.10
|
1.08
0.00
1.08
|
- | - | - | - | - | - | - |
5.34
0.00
5.34
|
| 15296 |
17.13
17.00
0.13
|
14.90
19.50
-4.60
|
15.64
21.00
-5.36
|
16.38
20.50
-4.12
|
16.40
16.00
0.40
|
15.63
49.00
-33.37
|
0.75
0.00
0.75
|
- | - | - | - | - |
96.83
143.00
-46.17
|
| 15519 |
5.04
0.00
5.04
|
4.39
18.00
-13.61
|
4.61
0.00
4.61
|
4.82
0.00
4.82
|
4.82
0.00
4.82
|
4.62
0.00
4.62
|
0.21
0.00
0.21
|
- | - | - | - | - |
28.51
18.00
10.51
|
| 15710 |
9.62
0.00
9.62
|
8.36
0.00
8.36
|
8.77
0.00
8.77
|
9.20
0.00
9.20
|
9.20
0.00
9.20
|
8.78
0.00
8.78
|
0.42
0.00
0.42
|
- | - | - | - | - |
54.35
0.00
54.35
|
| 15435 |
4.65
0.00
4.65
|
4.04
0.00
4.04
|
4.24
0.00
4.24
|
4.45
0.00
4.45
|
4.44
0.00
4.44
|
4.25
0.00
4.25
|
0.20
0.00
0.20
|
- | - | - | - | - |
26.27
0.00
26.27
|
| 15547 |
4.74
0.00
4.74
|
4.13
3.00
1.13
|
4.34
0.00
4.34
|
4.54
0.00
4.54
|
4.55
0.00
4.55
|
4.34
0.00
4.34
|
0.20
0.00
0.20
|
- | - | - | - | - |
26.84
3.00
23.84
|
| 15706 |
13.65
0.00
13.65
|
11.87
8.00
3.87
|
12.47
48.00
-35.53
|
13.05
0.00
13.05
|
13.05
0.00
13.05
|
12.46
0.00
12.46
|
0.60
0.00
0.60
|
- | - | - | - | - |
77.15
56.00
21.15
|
| 15596 |
4.43
6.00
-1.57
|
5.90
0.00
5.90
|
6.20
0.00
6.20
|
6.49
0.00
6.49
|
6.48
0.00
6.48
|
6.20
0.00
6.20
|
0.30
0.00
0.30
|
- | - | - | - | - |
36.00
6.00
30.00
|
| 16104 | - | - | - | - |
32.00
0.00
32.00
|
30.55
10.50
20.05
|
1.45
0.00
1.45
|
- | - | - | - | - |
64.00
10.50
53.50
|
| 15871 | - | - | - | - |
50.00
33.00
17.00
|
47.73
38.50
9.23
|
2.27
0.00
2.27
|
- | - | - | - | - |
100.00
71.50
28.50
|
| 15897 | - | - | - | - |
50.00
13.00
37.00
|
47.73
74.00
-26.27
|
2.27
0.00
2.27
|
- | - | - | - | - |
100.00
87.00
13.00
|
| 15961 | - | - | - | - |
50.00
96.00
-46.00
|
47.73
0.00
47.73
|
2.27
0.00
2.27
|
- | - | - | - | - |
100.00
96.00
4.00
|