Client Analysis


Client Metadata

Account ID

1003751

Account Name

1003751
Associated Projects
Project ID Project Name
VER1563 VER1563
VER1616 VER1616
VER1945 VER1945
VER1968 VER1968
VER2284 VER2284

Flag Summary

Project Allocations, Resources Overallocated: 0 0

Timewriting (April 2025): Corrected: 769.27h, Written: 603.50h, Difference: 165.77h (78%)

Client Financials (Aggregated)
Overall Financial Summary (Actual to July 2025)

Note: Overall totals include all historical data up to and including July 2025.

Target Fees

£4,078k

 

Planned Fees

£3,398k

Discount:
£-679k (-16.7%)

Corrected Fees

£2,869k

Scope Change:
£-529k (-15.6%)

Written Hours

£1,957k

Unrealised:
£-912k (-31.8%)

Revenue Assigned

£1,779k

Leakage:
£-178k (-9.1%)

Invoiced

£1,438k

Billing:
£-341k (-19.2%)

Revenue Summary by Period

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)
£607k £514k £393k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£1,349k £1,155k £950k £774k £629k £265k
2024 £2,728k £2,243k £1,920k £1,183k £1,150k £1,173k
Pre-2024 £0k £0k £0k £0k £0k £0k
Difference Summary by Period

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)
£607k £-93k
(-15.3%)
£-121k
(-23.6%)
- - -
2025 (Actual)
(Up to July 2025)
£1,349k £-194k
(-14.4%)
£-205k
(-17.8%)
£-176k
(-18.5%)
£-145k
(-18.7%)
£-364k
(-57.9%)
2024 £2,728k £-485k
(-17.8%)
£-324k
(-14.4%)
£-737k
(-38.4%)
£-33k
(-2.8%)
£24k
(2.0%)
Pre-2024 £0k £0k
(0.0%)
£0k
(0.0%)
£0k
(0.0%)
£0k
(0.0%)
£0k
(0.0%)
Monthly Financial Data (Aggregated)
2025 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £285k £244k £209k £207k £154k £122k £128k £117k £123k £128k £111k £128k £1,956k
Planned £241k £208k £183k £179k £133k £103k £109k £99k £104k £108k £94k £108k £1,669k
Corrected £190k £165k £162k £157k £111k £82k £83k £76k £79k £83k £72k £83k £1,342k
Written £120k £125k £132k £125k £131k £127k £14k - - - - - £774k
Revenue £105k £149k £104k £119k £153k - - - - - - - £629k
Invoiced - - - £46k £218k - - - - - - - £265k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £170k £156k £156k £163k £111k £201k £235k £248k £281k £308k £291k £408k £2,728k
Planned £154k £141k £141k £147k £97k £160k £189k £198k £220k £241k £230k £325k £2,243k
Corrected £154k £141k £141k £147k £97k £139k £162k £166k £169k £185k £177k £243k £1,920k
Written £95k £102k £71k £91k £55k £79k £79k £118k £135k £142k £126k £91k £1,183k
Revenue £97k £115k £46k £82k £54k £78k £86k £98k £135k £139k £127k £94k £1,150k
Invoiced - - - £98k £16k £14k £3k £136k £106k £259k - £542k £1,173k
Project Allocations (Aggregated)

Note: This table lists all allocation tasks for the client's projects. 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
VER1563 VER1563-1 15556 DE Partner No 2023-10-02 2024-05-01 2% 375.00 340.31 20.00 0.00
VER1563 VER1563-2 15124 NL Partner No 2023-10-02 2024-05-01 3% 375.00 340.31 36.00 0.00
VER1563 VER1563-4 15323 CH Senior Manager No 2023-10-02 2024-05-01 40% 371.09 323.30 488.00 0.00
VER1563 VER1563-5 82 NL Senior Manager No 2023-10-02 2024-05-01 24% 250.00 226.88 296.00 0.00
VER1563 VER1563-3 15245 GB Senior Manager No 2023-10-02 2024-05-01 14% 276.16 215.53 176.00 0.00
VER1563 VER1563-8 15273 GB Business Associate No 2023-10-02 2024-05-01 48% 198.00 198.00 584.00 0.00
VER1563 VER1563-7 15405 NL Senior Consultant No 2023-10-02 2024-05-01 9% 197.50 179.23 104.00 0.00
VER1563 VER1563-6 15353 NL Senior Consultant No 2023-10-02 2024-05-01 41% 197.50 179.23 496.00 0.00
VER1616 VER1616-3 15124 NL Partner No 2023-10-02 2024-05-30 3% 375.00 340.31 36.00 31.00
VER1616 VER1616-6 82 NL Senior Manager No 2023-10-02 2024-05-30 22% 250.00 226.88 306.00 306.00
VER1616 VER1616-4 15245 GB Senior Manager No 2023-10-02 2024-05-30 6% 276.16 215.53 87.00 81.50
VER1616 VER1616-9 15273 GB Business Associate No 2023-10-02 2024-05-30 47% 198.00 198.00 648.00 648.00
VER1616 VER1616-5 15323 CH Senior Manager No 2023-10-16 2024-05-30 52% 371.09 323.30 680.00 651.20
VER1616 VER1616-7 15353 NL Senior Consultant No 2023-10-16 2024-05-30 44% 197.50 179.23 578.00 550.50
VER1616 VER1616-8 15405 NL Senior Consultant No 2023-10-18 2024-05-30 5% 197.50 179.23 64.00 23.00
VER1616 VER1616-2 15556 DE Partner No 2023-10-25 2024-05-30 2% 375.00 340.31 20.00 10.50
VER1945 VER1945-1 15865 DE Manager No 2024-05-06 2024-07-20 25% 235.00 180.00 112.00 112.00
VER1945 VER1945-2 15857 GB Senior Consultant No 2024-05-06 2024-07-13 28% 238.37 158.00 112.50 112.50
VER1945 VER1945-4 15857 GB Senior Consultant No 2024-07-15 2025-07-01 12% 238.37 158.00 239.00 238.00
VER1945 VER1945-3 15865 DE Manager No 2024-07-22 2025-07-01 10% 235.00 180.00 192.00 191.50
VER1945 VER1945-7 16026 ZA Senior Consultant No 2024-11-28 2025-07-01 1% 115.00 158.00 17.00 17.00
VER1968 VER1968-15 16029 CH Business Associate No 2024-05-29 2026-04-01 37% 295.75 295.75 1419.00 493.40
VER1968 VER1968-16 15603 ZA Senior Manager No 2024-05-29 2026-04-01 5% 172.50 220.00 202.00 18.50
VER1968 VER1968-6 15273 GB Business Associate No 2024-05-29 2025-01-01 16% 207.55 207.55 205.00 205.00
VER1968 VER1968-5 82 NL Senior Manager No 2024-05-31 2026-04-01 37% 262.50 207.55 1404.00 691.00
VER1968 VER1968-7 15353 NL Manager No 2024-06-03 2026-04-01 51% 235.00 186.79 1943.50 984.50
VER1968 VER1968-4 15323 CH Senior Manager No 2024-06-04 2025-01-01 155% 390.63 295.75 1880.00 461.00
VER1968 VER1968-2 15124 NL Partner No 2024-06-06 2026-04-01 3% 397.50 311.32 105.00 23.00
VER1968 VER1968-3 15245 GB Senior Manager No 2024-06-10 2026-04-01 2% 290.70 207.55 58.00 58.00
VER1968 VER1968-8 15899 ZA Senior Consultant No 2024-06-18 2026-04-01 8% 115.00 163.92 315.50 315.50
VER1968 VER1968-1 15556 DE Partner No 2024-07-03 2026-04-01 2% 397.50 311.32 56.50 16.50
VER1968 VER1968-9 15393 NL Business Associate No 2024-08-01 2024-12-14 25% 186.79 186.79 192.00 184.00
VER1968 VER1968-10 15964 US Senior Manager No 2024-08-12 2026-04-01 7% 358.49 207.55 223.00 223.00
VER1968 VER1968-11 15595 NL Senior Consultant No 2024-08-12 2026-04-01 29% 205.00 163.92 1009.00 389.50
VER1968 VER1968-12 15405 NL Manager No 2024-08-29 2025-01-01 29% 235.00 163.92 208.00 208.00
VER1968 VER1968-14 15706 US Interim No 2024-11-01 2026-04-01 19% 207.55 207.55 565.00 174.00
VER1968 VER1968-13 16026 ZA Senior Consultant No 2024-11-25 2026-04-01 16% 115.00 163.92 463.00 314.50
VER2284 VER2284-4 15323 CH Senior Manager No 2024-12-02 2025-03-01 20% 390.63 295.75 106.40 106.40
VER2284 VER2284-8 15964 US Senior Manager No 2024-12-02 2025-03-01 2% 358.49 207.55 10.00 10.00
VER2284 VER2284-5 82 NL Senior Manager No 2024-12-02 2025-05-01 33% 262.50 207.55 292.00 292.00
VER2284 VER2284-10 15393 NL Business Associate No 2024-12-02 2025-03-01 2% 186.79 186.79 8.00 8.00
VER2284 VER2284-7 15899 ZA Senior Consultant No 2024-12-02 2025-03-01 0% 115.00 163.92 1.50 1.50
VER2284 VER2284-15 15595 NL Senior Consultant No 2024-12-02 2025-05-31 33% 205.00 163.92 341.00 341.00
VER2284 VER2284-11 15405 NL Manager No 2024-12-03 2025-05-01 5% 235.00 163.92 42.00 42.00
VER2284 VER2284-6 15353 NL Manager No 2024-12-04 2025-05-01 42% 235.00 186.79 360.50 360.50
VER2284 VER2284-2 15556 DE Partner No 2024-12-05 2025-05-01 1% 397.50 311.32 7.50 7.50
VER2284 VER2284-3 15245 GB Senior Manager No 2024-12-06 2025-05-31 6% 290.70 207.55 60.00 60.00
VER2284 VER2284-1 15124 NL Partner No 2024-12-09 2025-05-31 2% 397.50 311.32 15.00 15.00
VER2284 VER2284-12 16026 ZA Senior Consultant No 2024-12-09 2025-05-31 37% 115.00 163.92 372.00 372.00
VER2284 VER2284-9 15706 US Interim No 2025-01-02 2025-04-01 39% 196.43 196.43 198.00 198.00
VER2284 VER2284-16 16029 CH Business Associate No 2025-01-07 2025-05-01 38% 279.91 279.91 253.60 253.60
Monthly Project Allocations (Aggregated)
2025 Project Allocations

Table cells show: Corrected Hours (Planned + Correction) / Actual Hours (Timesheet) / Difference

Project ID Resource ID Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
VER1945 15857
21.81
6.00
15.81
18.96
17.00
1.96
19.92
27.00
-7.08
20.87
6.00
14.87
20.86
11.00
9.86
19.91
3.00
16.91
0.95
0.00
0.95
- - - - -
123.28
70.00
53.28
VER1945 15865
17.88
20.50
-2.62
15.55
24.00
-8.45
16.32
0.00
16.32
17.10
0.00
17.10
17.11
0.00
17.11
16.32
0.00
16.32
0.78
0.00
0.78
- - - - -
101.06
44.50
56.56
VER1945 16026
2.54
6.00
-3.46
2.21
0.00
2.21
2.31
3.00
-0.69
2.43
0.00
2.43
2.43
0.00
2.43
2.31
0.00
2.31
0.11
0.00
0.11
- - - - -
14.34
9.00
5.34
VER1968 16029
67.85
0.00
67.85
59.00
0.00
59.00
61.95
122.40
-60.45
64.90
120.00
-55.10
64.90
128.00
-63.10
61.95
123.00
-61.05
67.86
0.00
67.86
61.95
0.00
61.95
64.91
0.00
64.91
67.86
0.00
67.86
59.00
0.00
59.00
67.86
0.00
67.86
769.99
493.40
276.59
VER1968 15603
9.66
0.00
9.66
8.40
0.00
8.40
8.82
0.00
8.82
9.24
0.00
9.24
9.24
6.00
3.24
8.82
12.50
-3.68
9.66
0.00
9.66
8.82
0.00
8.82
9.24
0.00
9.24
9.66
0.00
9.66
8.40
0.00
8.40
9.65
0.00
9.65
109.61
18.50
91.11
VER1968 15273
1.31
0.00
1.31
- - - - - - - - - - -
1.31
0.00
1.31
VER1968 82
67.42
0.00
67.42
58.62
0.00
58.62
61.55
8.00
53.55
64.49
83.50
-19.01
64.49
80.00
-15.51
61.55
89.00
-27.45
67.42
21.00
46.42
61.55
0.00
61.55
64.49
0.00
64.49
67.42
0.00
67.42
58.61
0.00
58.61
67.42
0.00
67.42
765.03
281.50
483.53
VER1968 15353
93.51
0.00
93.51
81.32
0.00
81.32
85.38
44.50
40.88
89.45
129.50
-40.05
89.45
118.00
-28.55
85.38
82.50
2.88
93.51
27.50
66.01
85.38
0.00
85.38
89.46
0.00
89.46
93.53
0.00
93.53
81.32
0.00
81.32
93.52
0.00
93.52
1061.21
402.00
659.21
VER1968 15323
12.37
0.00
12.37
- - - - - - - - - - -
12.37
0.00
12.37
VER1968 15124
5.08
0.00
5.08
4.42
0.00
4.42
4.64
0.00
4.64
4.86
0.00
4.86
4.87
2.00
2.87
4.64
4.00
0.64
5.08
0.00
5.08
4.65
0.00
4.65
4.86
0.00
4.86
5.08
0.00
5.08
4.42
0.00
4.42
5.08
0.00
5.08
57.68
6.00
51.68
VER1968 15245
2.82
0.00
2.82
2.45
0.00
2.45
2.58
0.00
2.58
2.69
0.00
2.69
2.69
0.00
2.69
2.58
0.00
2.58
2.82
0.00
2.82
2.58
0.00
2.58
2.70
0.00
2.70
2.82
0.00
2.82
2.45
0.00
2.45
2.82
0.00
2.82
32.00
0.00
32.00
VER1968 15899
15.54
0.00
15.54
13.51
0.00
13.51
14.19
0.00
14.19
14.87
0.00
14.87
14.86
0.00
14.86
14.19
0.00
14.19
15.54
0.00
15.54
14.18
0.00
14.18
14.87
0.00
14.87
15.54
0.00
15.54
13.50
0.00
13.50
15.54
0.00
15.54
176.33
0.00
176.33
VER1968 15556
2.85
0.00
2.85
2.48
0.00
2.48
2.60
0.00
2.60
2.73
0.00
2.73
2.73
3.00
-0.27
2.60
5.00
-2.40
2.85
0.00
2.85
2.59
0.00
2.59
2.73
0.00
2.73
2.85
0.00
2.85
2.47
0.00
2.47
2.85
0.00
2.85
32.33
8.00
24.33
VER1968 15964
11.98
0.00
11.98
10.42
0.00
10.42
10.95
0.00
10.95
11.46
0.00
11.46
11.46
0.00
11.46
10.94
0.00
10.94
11.98
0.00
11.98
10.95
0.00
10.95
11.46
0.00
11.46
11.98
0.00
11.98
10.42
0.00
10.42
11.98
0.00
11.98
135.98
0.00
135.98
VER1968 15595
54.22
0.00
54.22
47.15
0.00
47.15
49.51
0.00
49.51
51.86
0.00
51.86
51.86
39.00
12.86
49.51
73.00
-23.49
54.22
0.00
54.22
49.51
0.00
49.51
51.86
0.00
51.86
54.23
0.00
54.23
47.14
0.00
47.14
54.23
0.00
54.23
615.30
112.00
503.30
VER1968 15405
2.31
0.00
2.31
- - - - - - - - - - -
2.31
0.00
2.31
VER1968 15706
35.22
0.00
35.22
30.63
0.00
30.63
32.15
14.00
18.15
33.68
72.00
-38.32
33.69
88.00
-54.31
32.15
110.00
-77.85
35.22
0.00
35.22
32.15
0.00
32.15
33.68
0.00
33.68
35.22
0.00
35.22
30.63
0.00
30.63
35.22
0.00
35.22
399.64
284.00
115.64
VER1968 16026
30.16
0.00
30.16
26.23
0.00
26.23
27.55
0.00
27.55
28.85
90.50
-61.65
28.86
122.00
-93.14
27.55
95.00
-67.45
30.16
25.00
5.16
27.55
0.00
27.55
28.85
0.00
28.85
30.16
0.00
30.16
26.23
0.00
26.23
30.17
0.00
30.17
342.32
332.50
9.82
VER2284 15323
37.64
0.00
37.64
32.74
0.00
32.74
- - - - - - - - - -
70.38
0.00
70.38
VER2284 15964
3.54
0.00
3.54
3.08
0.00
3.08
- - - - - - - - - -
6.62
0.00
6.62
VER2284 82
61.61
96.00
-34.39
53.58
55.50
-1.92
56.26
80.50
-24.24
58.93
0.00
58.93
2.68
0.00
2.68
- - - - - - -
233.06
232.00
1.06
VER2284 15393
2.83
0.00
2.83
2.46
0.00
2.46
- - - - - - - - - -
5.29
0.00
5.29
VER2284 15899
0.53
0.00
0.53
0.46
0.00
0.46
- - - - - - - - - -
0.99
0.00
0.99
VER2284 15595
60.33
74.00
-13.67
52.46
74.00
-21.54
55.08
64.00
-8.92
57.71
80.00
-22.29
57.71
6.00
51.71
- - - - - - -
283.29
298.00
-14.71
VER2284 15405
8.94
6.00
2.94
7.78
4.00
3.78
8.18
0.00
8.18
8.56
0.00
8.56
0.38
0.00
0.38
- - - - - - -
33.84
10.00
23.84
VER2284 15353
77.49
79.00
-1.51
67.38
126.50
-59.12
70.76
69.50
1.26
74.12
0.00
74.12
3.37
0.00
3.37
- - - - - - -
293.12
275.00
18.12
VER2284 15556
1.63
0.50
1.13
1.42
2.00
-0.58
1.48
2.50
-1.02
1.56
1.00
0.56
0.07
0.00
0.07
- - - - - - -
6.16
6.00
0.16
VER2284 15245
10.95
16.00
-5.05
9.52
6.00
3.52
10.00
7.50
2.50
10.48
1.00
9.48
10.48
14.50
-4.02
- - - - - - -
51.43
45.00
6.43
VER2284 15124
2.76
2.00
0.76
2.40
2.00
0.40
2.52
4.00
-1.48
2.64
2.00
0.64
2.64
1.00
1.64
- - - - - - -
12.96
11.00
1.96
VER2284 16026
68.44
80.00
-11.56
59.52
122.00
-62.48
62.50
136.00
-73.50
65.48
18.00
47.48
65.46
6.00
59.46
- - - - - - -
321.40
362.00
-40.60
VER2284 15706
68.06
80.00
-11.94
61.88
64.00
-2.12
64.97
54.00
10.97
3.09
0.00
3.09
- - - - - - - -
198.00
198.00
0.00
VER2284 16029
58.05
122.00
-63.95
61.11
126.00
-64.89
64.16
5.60
58.56
67.22
0.00
67.22
3.06
0.00
3.06
- - - - - - -
253.60
253.60
0.00