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.
£864k
£686k
Discount:
£-178k (-20.6%)
£430k
Scope Change:
£-256k (-37.4%)
£456k
Unrealised:
£26k (6.1%)
£466k
Leakage:
£10k (2.2%)
£432k
Billing:
£-34k (-7.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) |
£182k | £147k | £0k | £0k | £0k | £0k |
| 2025 (Actual) (Up to July 2025) |
£536k | £431k | £230k | £259k | £269k | £325k |
| 2024 | £328k | £255k | £199k | £197k | £197k | £107k |
| 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) |
£182k |
£-35k (-19.3%) |
£-147k (-100.0%) |
- | - | - |
| 2025 (Actual) (Up to July 2025) |
£536k |
£-105k (-19.6%) |
£-201k (-46.6%) |
£28k (12.3%) |
£10k (3.9%) |
£56k (20.8%) |
| 2024 | £328k |
£-73k (-22.2%) |
£-56k (-21.9%) |
£-2k (-1.1%) |
£0k (0.0%) |
£-90k (-45.6%) |
| 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 | £103k | £117k | £124k | £52k | £47k | £44k | £49k | £44k | £47k | £49k | £42k | - | £718k |
| Planned | £85k | £93k | £99k | £42k | £38k | £36k | £39k | £36k | £38k | £39k | £34k | - | £578k |
| Corrected | £70k | £76k | £80k | £4k | - | - | - | - | - | - | - | - | £230k |
| Written | £91k | £89k | £79k | - | - | - | - | - | - | - | - | - | £259k |
| Revenue | £94k | £89k | £76k | £10k | - | - | - | - | - | - | - | - | £269k |
| Invoiced | £52k | £58k | £159k | £53k | £2k | - | - | - | - | - | - | - | £325k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | - | - | - | - | - | - | - | - | - | £88k | £117k | £123k | £328k |
| Planned | - | - | - | - | - | - | - | - | - | £67k | £91k | £97k | £255k |
| Corrected | - | - | - | - | - | - | - | - | - | £48k | £73k | £78k | £199k |
| Written | - | - | - | - | - | - | - | - | - | £54k | £80k | £63k | £197k |
| Revenue | - | - | - | - | - | - | - | - | - | - | £119k | £78k | £197k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | £54k | £53k | £107k |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER2100 | VER2100-10 | 15647 | NL | Senior Consultant | No | 2024-10-01 | 2025-11-29 | 0% | 205.00 | 150.00 | 0.00 | 0.00 | |
| VER2100 | VER2100-2 | 16012 | NL | Consultant | No | 2024-10-04 | 2025-04-01 | 70% | 172.50 | 150.00 | 720.00 | 819.25 | |
| VER2100 | VER2100-1 | 15909 | NL | Manager | No | 2024-10-07 | 2025-01-01 | 63% | 235.00 | 150.00 | 316.00 | 316.00 | |
| VER2100 | VER2100-3 | 15880 | NL | Consultant | No | 2024-10-07 | 2025-04-01 | 74% | 172.50 | 150.00 | 752.00 | 820.00 | |
| VER2100 | VER2100-4 | 15752 | NL | Consultant | No | 2024-11-04 | 2025-04-01 | 88% | 172.50 | 150.00 | 756.00 | 680.00 | |
| VER2100 | VER2100-7 | 16043 | NL | Manager | No | 2025-01-02 | 2025-04-01 | 20% | 242.50 | 150.00 | 100.00 | 212.00 | |
| VER2100 | VER2100-8 | 15647 | NL | Senior Consultant | No | 2025-02-04 | 2025-04-01 | 67% | 210.00 | 150.00 | 220.00 | 192.00 | |
| VER2100 | VER2100-9 | 15880 | NL | Consultant | No | 2025-04-01 | 2025-11-29 | 0% | 175.00 | 150.00 | 0.00 | 0.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15647 |
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
|
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
|
| 16012 |
129.38
160.00
-30.62
|
112.50
144.00
-31.50
|
118.12
136.00
-17.88
|
5.63
0.00
5.63
|
- | - | - | - | - | - | - | - |
365.63
440.00
-74.37
|
| 15909 |
5.01
0.00
5.01
|
- | - | - | - | - | - | - | - | - | - | - |
5.01
0.00
5.01
|
| 15880 |
136.19
160.00
-23.81
|
118.42
176.00
-57.58
|
124.35
108.00
16.35
|
5.92
0.00
5.92
|
- | - | - | - | - | - | - | - |
384.88
444.00
-59.12
|
| 15752 |
162.50
140.00
22.50
|
141.31
136.00
5.31
|
148.37
160.00
-11.63
|
7.07
0.00
7.07
|
- | - | - | - | - | - | - | - |
459.25
436.00
23.25
|
| 16043 |
34.38
148.00
-113.62
|
31.25
64.00
-32.75
|
32.81
0.00
32.81
|
1.56
0.00
1.56
|
- | - | - | - | - | - | - | - |
100.00
212.00
-112.00
|
| 15647 | - |
101.95
72.00
29.95
|
112.69
120.00
-7.31
|
5.36
0.00
5.36
|
- | - | - | - | - | - | - | - |
220.00
192.00
28.00
|
| 15880 | - | - | - |
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
|
0.00
0.00
0.00
|
0.00
0.00
0.00
|
- |
0.00
0.00
0.00
|