Client Analysis


Client Metadata

Account ID

1000628

Account Name

1000628
Associated Projects
Project ID Project Name
VER1457 VER1457
VER1948 VER1948
VER2021 VER2021
VER2050 VER2050
VER2065 VER2065
VER2142 VER2142
VER2387 VER2387
VER2399 VER2399
VER2404 VER2404
VER2460 VER2460
VER2498 VER2498
VER2503 VER2503
VER2534 VER2534
VER2547 VER2547
VER2568 VER2568
VER2580 VER2580
VER2595 VER2595

Flag Summary

Project Allocations, Resources Overallocated: 1 0

Timewriting (April 2025): Corrected: 1482.11h, Written: 1434.00h, Difference: 48.11h (97%)

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

£3,739k

 

Planned Fees

£2,544k

Discount:
£-1,195k (-32.0%)

Corrected Fees

£2,560k

Scope Change:
£15k (0.6%)

Written Hours

£1,878k

Unrealised:
£-682k (-26.6%)

Revenue Assigned

£1,604k

Leakage:
£-274k (-14.6%)

Invoiced

£1,586k

Billing:
£-18k (-1.1%)

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)
£1,045k £651k £651k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£2,119k £1,405k £1,497k £1,113k £840k £962k
2024 £1,620k £1,139k £1,062k £764k £764k £625k
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)
£1,045k £-393k
(-37.6%)
£0k
(0.0%)
- - -
2025 (Actual)
(Up to July 2025)
£2,119k £-714k
(-33.7%)
£92k
(6.6%)
£-384k
(-25.6%)
£-273k
(-24.5%)
£121k
(14.4%)
2024 £1,620k £-481k
(-29.7%)
£-77k
(-6.7%)
£-298k
(-28.1%)
£-0k
(-0.1%)
£-139k
(-18.2%)
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 £229k £232k £225k £251k £337k £417k £428k £279k £234k £206k £152k £175k £3,164k
Planned £151k £152k £150k £164k £230k £282k £276k £178k £147k £124k £94k £108k £2,056k
Corrected £151k £152k £187k £217k £232k £282k £276k £178k £147k £124k £94k £108k £2,149k
Written £139k £132k £186k £205k £195k £233k £24k - - - - - £1,113k
Revenue £62k £208k £200k £123k £247k - - - - - - - £840k
Invoiced £190k £25k £267k £171k £116k £165k £28k - - - - - £962k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £20k £18k £1k £13k £26k £22k £114k £285k £288k £316k £287k £230k £1,620k
Planned £20k £18k £1k £13k £26k £22k £85k £199k £201k £220k £191k £144k £1,139k
Corrected £23k £21k £1k £14k £27k £24k £72k £173k £176k £193k £188k £151k £1,062k
Written £1k £26k - £15k £26k £25k £52k £143k £133k £141k £128k £75k £764k
Revenue £-0k £1k £26k - £40k £25k £21k £65k £220k £163k £128k £75k £764k
Invoiced £63k £1k £26k - - - - £79k £34k £232k £188k - £625k
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
VER1457 VER1457-3 15704 NL Interim No 2023-06-07 2024-03-01 78% 160.00 160.00 1209.00 1164.50
VER1948 VER1948-1 15704 NL Interim No 2024-04-15 2024-11-30 88% 170.00 170.00 1160.00 1087.50
VER2021 VER2021-1 15618 NL Consultant No 2024-07-01 2025-01-01 113% 172.50 101.90 1200.00 0.00
VER2050 VER2050-9 7000018 N/A N/A No 2024-07-15 2024-11-09 12% 175.00 175.00 80.00 80.00
VER2050 VER2050-8 7000018 N/A N/A No 2024-07-15 2024-11-09 1% 0.00 0.00 5.00 5.00
VER2050 VER2050-3 15625 NL Manager No 2024-08-05 2025-01-01 67% 235.00 160.00 581.50 581.50
VER2050 VER2050-1 15924 NL Senior Manager No 2024-08-05 2025-01-01 70% 262.50 160.00 608.00 608.00
VER2050 VER2050-4 15922 NL Senior Consultant No 2024-08-05 2024-11-09 72% 205.00 140.00 404.00 404.00
VER2050 VER2050-6 15723 NL Consultant No 2024-08-05 2024-11-09 72% 172.50 110.00 405.00 405.00
VER2050 VER2050-5 15926 NL Consultant No 2024-08-05 2024-11-09 91% 172.50 110.00 508.00 508.00
VER2050 VER2050-2 15955 NL Senior Manager No 2024-08-12 2025-01-01 20% 262.50 160.00 161.00 161.00
VER2050 VER2050-10 15958 NL Partner No 2024-11-04 2024-12-21 37% 397.50 190.00 104.00 104.00
VER2050 VER2050-11 15900 NL Manager No 2024-11-04 2024-12-21 94% 235.00 160.00 264.00 264.00
VER2050 VER2050-12 15943 NL Consultant No 2024-11-11 2025-01-01 87% 172.50 125.00 264.00 264.00
VER2065 VER2065-1 15618 NL Consultant No 2024-07-01 2025-01-01 113% 172.50 101.90 1200.00 479.00
VER2142 VER2142-1 15938 NL Senior Consultant No 2024-08-05 2025-08-01 88% 205.00 130.00 1836.00 160.00
VER2387 VER2387-3 16052 NL Senior Consultant No 2025-01-02 2026-01-01 78% 210.00 131.53 1620.00 880.00
VER2387 VER2387-5 16051 NL Consultant No 2025-01-02 2025-05-01 78% 175.00 121.10 536.00 632.00
VER2387 VER2387-4 16069 NL Senior Consultant No 2025-01-06 2025-08-01 87% 210.00 147.42 1048.00 888.00
VER2387 VER2387-1 16077 NL Consultant No 2025-01-13 2025-03-01 96% 175.00 110.57 269.00 203.00
VER2399 VER2399-3 16041 NL Manager No 2025-01-06 2025-04-01 89% 242.50 164.80 443.00 428.50
VER2399 VER2399-4 16066 NL Consultant No 2025-01-06 2025-04-01 64% 175.00 128.80 318.00 304.00
VER2399 VER2399-1 15958 NL Partner No 2025-01-08 2025-04-01 18% 407.50 195.70 87.00 64.00
VER2399 VER2399-2 16055 NL Director No 2025-02-03 2025-04-01 26% 312.50 195.70 87.00 128.00
VER2404 VER2404-1 16060 NL Consultant No 2025-01-02 2026-01-01 78% 175.00 115.83 1620.00 896.00
VER2460 VER2460-5 16019 NL Senior Manager No 2025-03-10 2025-05-01 38% 270.00 215.00 120.00 122.00
VER2460 VER2460-4 15833 NL Consultant No 2025-03-10 2025-05-01 77% 175.00 135.00 240.00 240.00
VER2460 VER2460-3 16001 NL Other No 2025-03-10 2025-04-30 79% 135.00 135.00 240.00 240.00
VER2460 VER2460-6 15828 NL Director No 2025-03-11 2025-05-01 28% 312.50 235.00 84.00 84.00
VER2460 VER2460-13 15828 NL Director No 2025-04-28 2025-05-24 33% 312.50 235.00 52.00 52.00
VER2460 VER2460-14 16019 NL Senior Manager No 2025-04-28 2025-05-24 25% 270.00 215.00 40.00 40.00
VER2460 VER2460-16 16001 NL Other No 2025-04-30 2025-05-24 75% 135.00 135.00 108.00 96.00
VER2460 VER2460-15 15833 NL Consultant No 2025-05-01 2025-05-24 106% 175.00 135.00 144.00 112.00
VER2498 VER2498-1 15945 NL Partner No 2025-04-01 2025-11-01 39% 407.50 200.07 480.00 37.00
VER2503 VER2503-1 15625 NL Manager No 2025-04-23 2026-01-01 77% 242.50 130.00 1120.00 192.00
VER2534 VER2534-2 16041 NL Manager No 2025-04-01 2025-08-30 55% 242.50 164.00 480.00 464.00
VER2534 VER2534-3 16066 NL Consultant No 2025-04-01 2025-08-30 55% 175.00 128.00 480.00 424.00
VER2534 VER2534-1 16055 NL Director No 2025-04-02 2025-08-30 22% 312.50 195.00 192.00 176.00
VER2547 VER2547-1 18 NL Partner No 2025-05-12 2025-10-01 25% 407.50 300.00 207.00 66.00
VER2547 VER2547-2 15192 NL Senior Manager No 2025-05-12 2025-10-01 44% 270.00 215.00 364.00 132.00
VER2568 VER2568-3 15828 NL Director No 2025-05-26 2025-06-07 20% 312.50 235.00 16.00 16.00
VER2568 VER2568-6 16019 NL Senior Manager No 2025-05-26 2025-06-07 25% 270.00 215.00 20.00 12.00
VER2568 VER2568-4 16001 NL Other No 2025-05-26 2025-06-07 90% 135.00 135.00 72.00 68.00
VER2568 VER2568-5 15833 NL Consultant No 2025-05-26 2025-06-07 90% 175.00 135.00 72.00 72.00
VER2568 VER2568-8 15828 NL Director No 2025-06-09 2025-06-21 58% 312.50 235.00 46.00 44.00
VER2568 VER2568-11 16019 NL Senior Manager No 2025-06-09 2025-06-21 25% 270.00 215.00 20.00 20.00
VER2568 VER2568-10 15833 NL Consultant No 2025-06-09 2025-06-21 90% 175.00 135.00 72.00 24.00
VER2568 VER2568-9 16001 NL Other No 2025-06-09 2025-06-21 90% 135.00 135.00 72.00 68.00
VER2568 VER2568-16 15828 NL Director No 2025-06-23 2025-07-05 70% 312.50 235.00 56.00 56.00
VER2568 VER2568-14 15833 NL Consultant No 2025-06-23 2025-07-05 0% 175.00 215.00 0.00 0.00
VER2568 VER2568-15 16019 NL Senior Manager No 2025-06-23 2025-07-05 25% 270.00 215.00 20.00 10.00
VER2568 VER2568-13 16001 NL Other No 2025-06-23 2025-07-05 90% 135.00 135.00 72.00 44.00
VER2580 VER2580-1 15958 NL Partner No 2025-06-09 2025-08-01 15% 407.50 190.00 48.00 24.00
VER2580 VER2580-2 16055 NL Director No 2025-06-09 2025-08-01 15% 312.50 180.00 48.00 24.00
VER2580 VER2580-4 16040 SE Manager No 2025-06-09 2025-08-01 4% 247.19 160.00 12.00 6.00
VER2580 VER2580-3 15414 NL Manager No 2025-06-09 2025-08-01 60% 242.50 160.00 192.00 70.00
VER2595 VER2595-3 16056 NL Consultant No 2025-06-12 2026-07-01 89% 175.00 115.00 1968.00 0.00
VER2595 VER2595-2 16072 NL Consultant No 2025-06-12 2026-07-01 89% 175.00 115.00 1968.00 0.00
VER2595 VER2595-1 16062 NL Consultant No 2025-06-12 2026-07-01 86% 175.00 105.00 1896.00 88.00
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
VER2021 15618
9.02
0.00
9.02
- - - - - - - - - - -
9.02
0.00
9.02
VER2050 15625
5.38
0.00
5.38
- - - - - - - - - - -
5.38
0.00
5.38
VER2050 15924
5.62
0.00
5.62
- - - - - - - - - - -
5.62
0.00
5.62
VER2050 15955
1.56
0.00
1.56
- - - - - - - - - - -
1.56
0.00
1.56
VER2050 15943
6.95
0.00
6.95
- - - - - - - - - - -
6.95
0.00
6.95
VER2065 15618
9.02
0.00
9.02
- - - - - - - - - - -
9.02
0.00
9.02
VER2142 15938
162.42
0.00
162.42
141.23
0.00
141.23
148.29
0.00
148.29
155.35
0.00
155.35
155.36
0.00
155.36
148.29
0.00
148.29
162.42
0.00
162.42
7.06
0.00
7.06
- - - -
1080.42
0.00
1080.42
VER2387 16052
136.55
176.00
-39.45
124.14
160.00
-35.86
130.34
128.00
2.34
136.55
152.00
-15.45
136.55
152.00
-15.45
130.35
104.00
26.35
142.76
8.00
134.76
130.35
0.00
130.35
136.55
0.00
136.55
142.76
0.00
142.76
124.14
0.00
124.14
142.75
0.00
142.75
1613.79
880.00
733.79
VER2387 16051
137.12
176.00
-38.88
124.65
152.00
-27.35
130.88
136.00
-5.12
137.12
168.00
-30.88
6.23
0.00
6.23
- - - - - - -
536.00
632.00
-96.00
VER2387 16069
139.73
160.00
-20.27
139.73
120.00
19.73
146.72
136.00
10.72
153.71
168.00
-14.29
153.71
168.00
-14.29
146.72
136.00
10.72
160.69
0.00
160.69
6.99
0.00
6.99
- - - -
1048.00
888.00
160.00
VER2387 16077
115.29
80.00
35.29
153.71
123.00
30.71
- - - - - - - - - -
269.00
203.00
66.00
VER2399 16041
142.90
160.00
-17.10
142.90
142.00
0.90
150.05
126.50
23.55
7.15
0.00
7.15
- - - - - - - -
443.00
428.50
14.50
VER2399 16066
102.58
24.00
78.58
102.58
136.00
-33.42
107.71
144.00
-36.29
5.13
0.00
5.13
- - - - - - - -
318.00
304.00
14.00
VER2399 15958
26.10
64.00
-37.90
29.00
0.00
29.00
30.45
0.00
30.45
1.45
0.00
1.45
- - - - - - - -
87.00
64.00
23.00
VER2399 16055 -
41.43
64.00
-22.57
43.50
64.00
-20.50
2.07
0.00
2.07
- - - - - - - -
87.00
128.00
-41.00
VER2404 16060
136.55
176.00
-39.45
124.14
64.00
60.14
130.34
168.00
-37.66
136.55
168.00
-31.45
136.55
160.00
-23.45
130.35
160.00
-29.65
142.76
0.00
142.76
130.35
0.00
130.35
136.55
0.00
136.55
142.76
0.00
142.76
124.14
0.00
124.14
142.75
0.00
142.75
1613.79
896.00
717.79
VER2460 16019 - -
49.24
86.00
-36.76
67.69
36.00
31.69
3.07
0.00
3.07
- - - - - - -
120.00
122.00
-2.00
VER2460 15833 - -
98.46
112.00
-13.54
135.38
128.00
7.38
6.16
0.00
6.16
- - - - - - -
240.00
240.00
0.00
VER2460 16001 - -
101.05
120.00
-18.95
138.95
120.00
18.95
- - - - - - - -
240.00
240.00
0.00
VER2460 15828 - -
33.16
50.00
-16.84
48.63
34.00
14.63
2.21
0.00
2.21
- - - - - - -
84.00
84.00
0.00
VER2460 15828 - - -
7.80
8.00
-0.20
44.20
44.00
0.20
- - - - - - -
52.00
52.00
0.00
VER2460 16019 - - -
6.00
4.00
2.00
34.00
36.00
-2.00
- - - - - - -
40.00
40.00
0.00
VER2460 16001 - - -
6.00
8.00
-2.00
102.00
88.00
14.00
- - - - - - -
108.00
96.00
12.00
VER2460 15833 - - - -
144.00
112.00
32.00
- - - - - - -
144.00
112.00
32.00
VER2498 15945 - - -
68.57
0.00
68.57
68.57
34.00
34.57
65.46
3.00
62.46
71.69
0.00
71.69
65.45
0.00
65.45
68.57
0.00
68.57
71.69
0.00
71.69
- -
480.00
37.00
443.00
VER2503 15625 - - -
36.92
24.00
12.92
135.38
40.00
95.38
129.23
128.00
1.23
141.54
0.00
141.54
129.23
0.00
129.23
135.39
0.00
135.39
141.54
0.00
141.54
123.08
0.00
123.08
141.54
0.00
141.54
1113.85
192.00
921.85
VER2534 16041 - - -
96.88
168.00
-71.12
96.88
152.00
-55.12
92.48
144.00
-51.52
101.28
0.00
101.28
92.48
0.00
92.48
- - - -
480.00
464.00
16.00
VER2534 16066 - - -
96.88
168.00
-71.12
96.88
152.00
-55.12
92.48
104.00
-11.52
101.28
0.00
101.28
92.48
0.00
92.48
- - - -
480.00
424.00
56.00
VER2534 16055 - - -
37.33
80.00
-42.67
39.11
40.00
-0.89
37.33
56.00
-18.67
40.89
0.00
40.89
37.34
0.00
37.34
- - - -
192.00
176.00
16.00
VER2547 18 - - - -
30.15
22.00
8.15
42.20
33.00
9.20
46.22
11.00
35.22
42.21
0.00
42.21
44.21
0.00
44.21
2.01
0.00
2.01
- -
207.00
66.00
141.00
VER2547 15192 - - - -
53.01
21.00
32.01
74.21
87.00
-12.79
81.28
24.00
57.28
74.22
0.00
74.22
77.75
0.00
77.75
3.53
0.00
3.53
- -
364.00
132.00
232.00
VER2568 15828 - - - -
8.00
8.00
0.00
8.00
8.00
0.00
- - - - - -
16.00
16.00
0.00
VER2568 16019 - - - -
10.00
2.00
8.00
10.00
10.00
0.00
- - - - - -
20.00
12.00
8.00
VER2568 16001 - - - -
36.00
32.00
4.00
36.00
36.00
0.00
- - - - - -
72.00
68.00
4.00
VER2568 15833 - - - -
36.00
32.00
4.00
36.00
40.00
-4.00
- - - - - -
72.00
72.00
0.00
VER2568 15828 - - - - -
46.00
44.00
2.00
- - - - - -
46.00
44.00
2.00
VER2568 16019 - - - - -
20.00
20.00
0.00
- - - - - -
20.00
20.00
0.00
VER2568 15833 - - - - -
72.00
24.00
48.00
- - - - - -
72.00
24.00
48.00
VER2568 16001 - - - - -
72.00
68.00
4.00
- - - - - -
72.00
68.00
4.00
VER2568 15828 - - - - -
33.60
36.00
-2.40
22.40
20.00
2.40
- - - - -
56.00
56.00
0.00
VER2568 16019 - - - - -
12.00
10.00
2.00
8.00
0.00
8.00
- - - - -
20.00
10.00
10.00
VER2568 16001 - - - - -
43.20
44.00
-0.80
28.80
28.00
0.80
- - - - -
72.00
72.00
0.00
VER2580 15958 - - - - -
19.20
16.00
3.20
27.60
8.00
19.60
1.20
0.00
1.20
- - - -
48.00
24.00
24.00
VER2580 16055 - - - - -
19.20
24.00
-4.80
27.60
0.00
27.60
1.20
0.00
1.20
- - - -
48.00
24.00
24.00
VER2580 16040 - - - - -
4.80
6.00
-1.20
6.90
0.00
6.90
0.30
0.00
0.30
- - - -
12.00
6.00
6.00
VER2580 15414 - - - - -
76.80
70.00
6.80
110.40
26.00
84.40
4.80
0.00
4.80
- - - -
192.00
96.00
96.00
VER2595 16056 - - - - -
93.03
0.00
93.03
164.60
0.00
164.60
150.28
0.00
150.28
157.44
0.00
157.44
164.60
0.00
164.60
143.13
0.00
143.13
164.60
0.00
164.60
1037.68
0.00
1037.68
VER2595 16072 - - - - -
93.03
0.00
93.03
164.60
0.00
164.60
150.28
0.00
150.28
157.44
0.00
157.44
164.60
0.00
164.60
143.13
0.00
143.13
164.60
0.00
164.60
1037.68
0.00
1037.68
VER2595 16062 - - - - -
89.63
88.00
1.63
158.57
0.00
158.57
144.79
0.00
144.79
151.68
0.00
151.68
158.57
0.00
158.57
137.89
0.00
137.89
158.58
0.00
158.58
999.71
88.00
911.71