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.
£63k
£58k
Discount:
£-5k (-7.8%)
£28k
Scope Change:
£-30k (-51.7%)
£11k
Unrealised:
£-17k (-61.2%)
£13k
Leakage:
£2k (15.4%)
£41k
Billing:
£28k (225.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) |
£41k | £36k | £18k | £0k | £0k | £0k |
| 2025 (Actual) (Up to July 2025) |
£45k | £41k | £19k | £5k | £1k | £20k |
| 2024 | £18k | £18k | £9k | £6k | £12k | £21k |
| 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) |
£41k |
£-5k (-13.1%) |
£-18k (-50.1%) |
- | - | - |
| 2025 (Actual) (Up to July 2025) |
£45k |
£-4k (-9.3%) |
£-21k (-52.2%) |
£-14k (-73.6%) |
£-5k (-88.9%) |
£19k (3416.3%) |
| 2024 | £18k |
£-1k (-4.0%) |
£-9k (-50.5%) |
£-3k (-33.2%) |
£6k (107.8%) |
£9k (75.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 | £4k | £4k | £4k | £8k | £8k | £8k | £9k | £8k | £8k | £9k | £8k | £9k | £86k |
| Planned | £4k | £4k | £4k | £7k | £7k | £7k | £8k | £7k | £7k | £8k | £7k | £8k | £77k |
| Corrected | £2k | £2k | £2k | £4k | £4k | £3k | £4k | £3k | £4k | £4k | £3k | £4k | £37k |
| Written | £1k | £0k | £1k | £1k | £2k | £0k | - | - | - | - | - | - | £5k |
| Revenue | £1k | £1k | £2k | £-6k | £3k | - | - | - | - | - | - | - | £1k |
| Invoiced | £3k | £3k | £3k | £3k | £3k | £3k | - | - | - | - | - | - | £20k |
| Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Target | - | - | - | - | - | £2k | £2k | £2k | £2k | £2k | £4k | £4k | £18k |
| Planned | - | - | - | - | - | £2k | £2k | £2k | £2k | £2k | £4k | £4k | £18k |
| Corrected | - | - | - | - | - | £1k | £1k | £1k | £1k | £1k | £2k | £2k | £9k |
| Written | - | - | - | - | - | - | £1k | £1k | £1k | £1k | £1k | £1k | £6k |
| Revenue | - | - | - | - | - | - | - | - | - | - | £10k | £2k | £12k |
| Invoiced | - | - | - | - | - | - | - | - | - | - | £18k | £4k | £21k |
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| VER2191 | VER2191-2 | 15296 | GB | Senior Manager | No | 2024-06-03 | 2026-05-30 | 2% | 290.70 | 263.21 | 82.00 | 34.00 | |
| VER2191 | VER2191-6 | 15404 | SE | Manager | No | 2024-08-16 | 2024-10-01 | 1% | 237.27 | 263.21 | 3.00 | 3.00 | |
| VER2191 | VER2191-3 | 16016 | NL | Manager | No | 2024-11-01 | 2026-05-30 | 2% | 235.00 | 263.21 | 57.00 | 0.00 | |
| VER2191 | VER2191-4 | 15710 | ZA | Senior Consultant | No | 2025-04-01 | 2026-05-30 | 2% | 115.00 | 147.32 | 58.00 | 0.00 | |
| VER2191 | VER2191-5 | 15873 | IN | Manager | No | 2025-04-01 | 2026-05-30 | 5% | 242.50 | 147.32 | 120.00 | 8.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15296 |
3.63
3.00
0.63
|
3.15
1.50
1.65
|
3.31
4.00
-0.69
|
3.47
3.00
0.47
|
3.47
2.00
1.47
|
3.31
1.50
1.81
|
3.63
0.00
3.63
|
3.31
0.00
3.31
|
3.47
0.00
3.47
|
3.63
0.00
3.63
|
3.15
0.00
3.15
|
3.63
0.00
3.63
|
41.16
15.00
26.16
|
| 15404 | - | - | - | - | - | - | - | - | - | - | - | - |
0.00
0.00
0.00
|
| 16016 |
3.19
0.00
3.19
|
2.78
0.00
2.78
|
2.92
0.00
2.92
|
3.05
0.00
3.05
|
3.05
0.00
3.05
|
2.92
0.00
2.92
|
3.18
0.00
3.18
|
2.92
0.00
2.92
|
3.04
0.00
3.04
|
3.18
0.00
3.18
|
2.78
0.00
2.78
|
3.18
0.00
3.18
|
36.19
0.00
36.19
|
| 15710 | - | - | - |
4.20
0.00
4.20
|
4.20
0.00
4.20
|
4.01
0.00
4.01
|
4.38
0.00
4.38
|
4.01
0.00
4.01
|
4.20
0.00
4.20
|
4.38
0.00
4.38
|
3.82
0.00
3.82
|
4.39
0.00
4.39
|
37.59
0.00
37.59
|
| 15873 | - | - | - |
8.68
0.00
8.68
|
8.68
8.00
0.68
|
8.29
0.00
8.29
|
9.08
0.00
9.08
|
8.29
0.00
8.29
|
8.68
0.00
8.68
|
9.08
0.00
9.08
|
7.90
0.00
7.90
|
9.08
0.00
9.08
|
77.76
8.00
69.76
|