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.
£240k
£224k
Discount:
£-17k (-6.9%)
£219k
Scope Change:
£-5k (-2.2%)
£190k
Unrealised:
£-29k (-13.1%)
£170k
Leakage:
£-20k (-10.5%)
£65k
Billing:
£-105k (-61.8%)
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) |
£1k | £1k | £1k | £0k | £1k | £0k |
| 2024 | £239k | £223k | £218k | £190k | £170k | £65k |
| 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) |
£1k |
£-0k (-3.9%) |
£0k (0.0%) |
£-1k (-100.0%) |
£1k (0.0%) |
£-1k (-100.0%) |
| 2024 | £239k |
£-17k (-6.9%) |
£-5k (-2.2%) |
£-27k (-12.6%) |
£-20k (-10.8%) |
£-105k (-61.7%) |
| 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 | £1k | - | - | - | - | - | - | - | - | - | - | - | £1k |
| Planned | £1k | - | - | - | - | - | - | - | - | - | - | - | £1k |
| Corrected | £1k | - | - | - | - | - | - | - | - | - | - | - | £1k |
| Written | - | - | - | - | - | - | - | - | - | - | - | - | £0k |
| Revenue | £1k | - | - | - | - | - | - | - | - | - | - | - | £1k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | - | - | £0k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | - | - | - | £27k | £28k | £24k | £29k | £28k | £27k | £27k | £24k | £25k | £239k |
| Planned | - | - | - | £25k | £26k | £22k | £27k | £26k | £24k | £26k | £23k | £24k | £223k |
| Corrected | - | - | - | £25k | £26k | £22k | £25k | £24k | £23k | £26k | £23k | £24k | £218k |
| Written | - | - | - | £25k | £21k | £21k | £22k | £20k | £18k | £22k | £22k | £19k | £190k |
| Revenue | - | - | - | £28k | £20k | £11k | £1k | - | £58k | £24k | £10k | £17k | £170k |
| Invoiced | - | - | - | £22k | £22k | £22k | - | - | - | - | - | - | £65k |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER1864 | VER1864-20 | 7000026 | N/A | N/A | No | 2024-04-01 | 2025-01-01 | 2% | 280.25 | 280.25 | 30.00 | 1.00 | |
| VER1864 | VER1864-2 | 15552 | JP | Senior Manager | No | 2024-04-01 | 2024-06-29 | 29% | 224.52 | 212.32 | 150.00 | 150.00 | |
| VER1864 | VER1864-4 | 15413 | CH | Senior Consultant | No | 2024-04-01 | 2024-06-29 | 6% | 296.88 | 165.60 | 30.00 | 0.00 | |
| VER1864 | VER1864-3 | 15617 | JP | Senior Consultant | No | 2024-04-01 | 2024-06-29 | 33% | 171.18 | 165.60 | 170.00 | 213.00 | |
| VER1864 | VER1864-18 | 7000026 | N/A | N/A | No | 2024-04-01 | 2025-01-01 | 3% | 163.06 | 163.06 | 40.00 | 5.00 | |
| VER1864 | VER1864-19 | 7000026 | N/A | N/A | No | 2024-04-01 | 2025-01-01 | 3% | 148.41 | 148.41 | 40.00 | 5.25 | |
| VER1864 | VER1864-21 | 7000026 | N/A | N/A | No | 2024-04-01 | 2025-01-01 | 1% | 140.13 | 140.13 | 20.00 | 2.50 | |
| VER1864 | VER1864-10 | 15552 | JP | Senior Manager | No | 2024-07-01 | 2024-10-01 | 9% | 224.52 | 212.32 | 50.00 | 30.00 | |
| VER1864 | VER1864-6 | 15552 | JP | Senior Manager | No | 2024-07-01 | 2024-10-01 | 19% | 224.52 | 212.32 | 101.00 | 96.00 | |
| VER1864 | VER1864-8 | 15413 | CH | Senior Consultant | No | 2024-07-01 | 2024-10-01 | 0% | 296.88 | 165.60 | 0.00 | 0.00 | |
| VER1864 | VER1864-11 | 15617 | JP | Senior Consultant | No | 2024-07-01 | 2024-10-01 | 12% | 171.18 | 165.60 | 63.00 | 61.00 | |
| VER1864 | VER1864-7 | 15617 | JP | Senior Consultant | No | 2024-07-01 | 2024-10-01 | 25% | 171.18 | 165.60 | 136.00 | 136.00 | |
| VER1864 | VER1864-16 | 15552 | JP | Senior Manager | No | 2024-10-01 | 2025-01-01 | 9% | 224.52 | 212.32 | 50.00 | 39.00 | |
| VER1864 | VER1864-13 | 15552 | JP | Senior Manager | No | 2024-10-01 | 2025-01-01 | 19% | 224.52 | 212.32 | 101.00 | 99.75 | |
| VER1864 | VER1864-17 | 15617 | JP | Senior Consultant | No | 2024-10-01 | 2025-01-01 | 12% | 171.18 | 165.60 | 63.00 | 57.50 | |
| VER1864 | VER1864-14 | 15617 | JP | Senior Consultant | No | 2024-10-01 | 2025-01-01 | 25% | 171.18 | 165.60 | 136.00 | 135.25 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7000026 |
0.15
0.00
0.15
|
- | - | - | - | - | - | - | - | - | - | - |
0.15
0.00
0.15
|
| 15552 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15413 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15617 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 7000026 |
0.20
0.00
0.20
|
- | - | - | - | - | - | - | - | - | - | - |
0.20
0.00
0.20
|
| 7000026 |
0.20
0.00
0.20
|
- | - | - | - | - | - | - | - | - | - | - |
0.20
0.00
0.20
|
| 7000026 |
0.10
0.00
0.10
|
- | - | - | - | - | - | - | - | - | - | - |
0.10
0.00
0.10
|
| 15552 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15552 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15413 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15617 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15617 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 15552 |
0.75
0.00
0.75
|
- | - | - | - | - | - | - | - | - | - | - |
0.75
0.00
0.75
|
| 15552 |
1.51
0.00
1.51
|
- | - | - | - | - | - | - | - | - | - | - |
1.51
0.00
1.51
|
| 15617 |
0.94
0.00
0.94
|
- | - | - | - | - | - | - | - | - | - | - |
0.94
0.00
0.94
|
| 15617 |
2.03
0.00
2.03
|
- | - | - | - | - | - | - | - | - | - | - |
2.03
0.00
2.03
|