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.
£345k
£238k
Discount:
£-107k (-31.1%)
£197k
Scope Change:
£-41k (-17.2%)
£206k
Unrealised:
£10k (4.8%)
£203k
Leakage:
£-3k (-1.4%)
£170k
Billing:
£-34k (-16.7%)
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) |
£82k | £53k | £46k | £0k | £0k | £0k |
| 2025 (Actual) (Up to July 2025) |
£129k | £91k | £77k | £46k | £41k | £50k |
| 2024 | £216k | £147k | £120k | £161k | £163k | £120k |
| 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) |
£82k |
£-30k (-36.3%) |
£-7k (-12.8%) |
- | - | - |
| 2025 (Actual) (Up to July 2025) |
£129k |
£-38k (-29.6%) |
£-14k (-15.7%) |
£-31k (-40.6%) |
£-5k (-10.6%) |
£9k (22.5%) |
| 2024 | £216k |
£-69k (-32.0%) |
£-27k (-18.1%) |
£41k (33.8%) |
£2k (1.2%) |
£-43k (-26.5%) |
| 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 | £20k | £18k | £19k | £20k | £20k | £16k | £17k | £16k | £17k | £17k | £15k | £17k | £212k |
| Planned | £15k | £13k | £14k | £14k | £14k | £10k | £11k | £10k | £11k | £11k | £10k | £11k | £143k |
| Corrected | £12k | £11k | £11k | £12k | £12k | £9k | £10k | £9k | £9k | £10k | £8k | £10k | £122k |
| Written | £10k | £10k | £12k | £10k | £2k | £1k | - | - | - | - | - | - | £46k |
| Revenue | £10k | £7k | £14k | £10k | £0k | - | - | - | - | - | - | - | £41k |
| Invoiced | - | £10k | £10k | - | £20k | £10k | - | - | - | - | - | - | £50k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | £15k | £16k | £17k | £18k | £19k | £17k | £19k | £18k | £17k | £20k | £19k | £20k | £216k |
| Planned | £9k | £11k | £12k | £12k | £13k | £11k | £13k | £12k | £12k | £15k | £14k | £14k | £147k |
| Corrected | £7k | £9k | £9k | £10k | £10k | £9k | £10k | £10k | £9k | £12k | £11k | £12k | £120k |
| Written | £1k | £10k | £12k | £12k | £14k | £12k | £20k | £19k | £14k | £19k | £16k | £12k | £161k |
| Revenue | - | £10k | £12k | £12k | £14k | £12k | £22k | £7k | £24k | £19k | £17k | £14k | £163k |
| Invoiced | - | £20k | - | £20k | £10k | - | £10k | - | £20k | £10k | £20k | £10k | £120k |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER1689 | VER1689-10 | 15547 | ZA | Senior Consultant | No | 2024-01-02 | 2026-01-01 | 0% | 115.00 | 142.50 | 1.00 | 0.00 | |
| VER1689 | VER1689-8 | 15701 | US | Manager | No | 2024-01-02 | 2026-01-01 | 0% | 327.83 | 142.50 | 20.00 | 0.00 | |
| VER1689 | VER1689-7 | 15592 | US | Consultant | No | 2024-01-02 | 2026-01-01 | 5% | 252.36 | 142.50 | 222.50 | 108.50 | |
| VER1689 | VER1689-4 | 15296 | GB | Senior Manager | No | 2024-01-02 | 2026-01-01 | 8% | 290.70 | 142.50 | 340.00 | 257.50 | |
| VER1689 | VER1689-9 | 15639 | GB | Consultant | No | 2024-01-02 | 2026-01-01 | 15% | 212.21 | 142.50 | 640.00 | 639.00 | |
| VER1689 | VER1689-6 | 15710 | ZA | Senior Consultant | No | 2024-02-12 | 2025-05-31 | 10% | 115.00 | 142.50 | 282.50 | 282.50 | |
| VER1689 | VER1689-11 | 15897 | ZA | Consultant | No | 2024-10-01 | 2026-01-01 | 4% | 101.25 | 142.50 | 100.00 | 77.00 | |
| VER1689 | VER1689-12 | 15961 | ZA | Consultant | No | 2024-10-01 | 2026-01-01 | 4% | 101.25 | 142.50 | 100.00 | 100.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15547 |
0.05
0.00
0.05
|
0.04
0.00
0.04
|
0.03
0.00
0.03
|
0.04
0.00
0.04
|
0.04
0.00
0.04
|
0.05
0.00
0.05
|
0.05
0.00
0.05
|
0.03
0.00
0.03
|
0.04
0.00
0.04
|
0.05
0.00
0.05
|
0.04
0.00
0.04
|
0.03
0.00
0.03
|
0.49
0.00
0.49
|
| 15701 |
0.88
0.00
0.88
|
0.76
0.00
0.76
|
0.80
0.00
0.80
|
0.85
0.00
0.85
|
0.84
0.00
0.84
|
0.80
0.00
0.80
|
0.88
0.00
0.88
|
0.80
0.00
0.80
|
0.85
0.00
0.85
|
0.88
0.00
0.88
|
0.77
0.00
0.77
|
0.88
0.00
0.88
|
9.99
0.00
9.99
|
| 15592 |
9.78
1.50
8.28
|
8.51
1.00
7.51
|
8.94
3.00
5.94
|
9.36
6.50
2.86
|
9.36
0.50
8.86
|
8.94
0.00
8.94
|
9.78
0.00
9.78
|
8.94
0.00
8.94
|
9.36
0.00
9.36
|
9.78
0.00
9.78
|
8.52
0.00
8.52
|
9.78
0.00
9.78
|
111.05
12.50
98.55
|
| 15296 |
14.95
21.00
-6.05
|
13.00
16.00
-3.00
|
13.65
13.00
0.65
|
14.31
11.50
2.81
|
14.30
9.00
5.30
|
13.65
6.50
7.15
|
14.95
0.00
14.95
|
13.65
0.00
13.65
|
14.31
0.00
14.31
|
14.95
0.00
14.95
|
13.00
0.00
13.00
|
14.95
0.00
14.95
|
169.67
77.00
92.67
|
| 15639 |
28.14
18.00
10.14
|
24.47
34.00
-9.53
|
25.70
46.50
-20.80
|
26.93
18.50
8.43
|
26.92
0.00
26.92
|
25.70
0.00
25.70
|
28.14
0.00
28.14
|
25.70
0.00
25.70
|
26.93
0.00
26.93
|
28.14
0.00
28.14
|
24.48
0.00
24.48
|
28.14
0.00
28.14
|
319.39
117.00
202.39
|
| 15710 |
19.11
0.00
19.11
|
16.62
0.00
16.62
|
17.45
0.00
17.45
|
18.28
0.00
18.28
|
18.28
0.00
18.28
|
- | - | - | - | - | - | - |
89.74
0.00
89.74
|
| 15897 |
7.01
12.50
-5.49
|
6.10
3.00
3.10
|
6.40
7.00
-0.60
|
6.71
4.50
2.21
|
6.71
0.00
6.71
|
6.40
3.00
3.40
|
7.01
0.00
7.01
|
6.40
0.00
6.40
|
6.71
0.00
6.71
|
7.01
0.00
7.01
|
6.10
0.00
6.10
|
7.02
0.00
7.02
|
79.58
30.00
49.58
|
| 15961 |
7.01
16.00
-8.99
|
6.10
18.00
-11.90
|
6.40
18.00
-11.60
|
6.71
26.50
-19.79
|
6.71
4.50
2.21
|
6.40
0.00
6.40
|
7.01
0.00
7.01
|
6.40
0.00
6.40
|
6.71
0.00
6.71
|
7.01
0.00
7.01
|
6.10
0.00
6.10
|
7.02
0.00
7.02
|
79.58
83.00
-3.42
|