Client Analysis


Client Metadata

Account ID

1001371

Account Name

1001371
Associated Projects
Project ID Project Name
VER1177 VER1177
VER1929 VER1929
VER2012 VER2012
VER2211 VER2211
VER2331 VER2331
VER2374 VER2374
VER2432 VER2432
VER2588 VER2588

Flag Summary

Project Allocations, Resources Overallocated: 0 0

Timewriting (April 2025): Corrected: 1350.21h, Written: 1249.00h, Difference: 101.21h (93%)

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,248k

 

Planned Fees

£2,731k

Discount:
£-1,517k (-35.7%)

Corrected Fees

£2,705k

Scope Change:
£-25k (-0.9%)

Written Hours

£2,784k

Unrealised:
£79k (2.9%)

Revenue Assigned

£2,710k

Leakage:
£-74k (-2.7%)

Invoiced

£2,454k

Billing:
£-256k (-9.5%)

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)
£560k £360k £434k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£2,437k £1,502k £1,170k £988k £856k £601k
2024 £1,810k £1,229k £1,535k £1,797k £1,854k £1,853k
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)
£560k £-201k
(-35.8%)
£74k
(20.5%)
- - -
2025 (Actual)
(Up to July 2025)
£2,437k £-936k
(-38.4%)
£-332k
(-22.1%)
£-182k
(-15.6%)
£-131k
(-13.3%)
£-255k
(-29.8%)
2024 £1,810k £-581k
(-32.1%)
£307k
(25.0%)
£261k
(17.0%)
£57k
(3.2%)
£-1k
(-0.1%)
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 £474k £471k £445k £348k £341k £234k £126k £108k £113k £118k £103k £118k £2,998k
Planned £281k £288k £276k £220k £216k £141k £80k £69k £73k £76k £66k £76k £1,862k
Corrected £162k £188k £200k £186k £184k £155k £96k £84k £88k £92k £80k £92k £1,604k
Written £160k £174k £183k £173k £167k £127k £4k - - - - - £988k
Revenue £160k £174k £183k £173k £167k - - - - - - - £856k
Invoiced £3k £136k £219k £184k £59k - - - - - - - £601k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £75k £69k £69k £78k £315k £282k £168k £161k £154k £141k £141k £157k £1,810k
Planned £61k £56k £56k £62k £214k £191k £109k £104k £99k £88k £88k £101k £1,229k
Corrected £61k £56k £56k £62k £248k £227k £150k £144k £137k £130k £126k £140k £1,535k
Written £94k £89k £91k £124k £258k £253k £158k £167k £142k £174k £141k £106k £1,797k
Revenue £70k £121k £102k £126k £95k £450k £89k £233k £147k £174k £141k £106k £1,854k
Invoiced - £172k £139k - £211k £131k £54k £356k £148k £244k £237k £160k £1,853k
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
VER1177 VER1177-2 10157 NL Director No 2023-01-02 2024-06-29 12% 287.50 225.52 360.00 917.00
VER1177 VER1177-1 15003 NL Senior Manager No 2023-01-02 2024-06-29 45% 250.00 205.01 1404.00 1830.00
VER1177 VER1177-3 15280 NL Senior Consultant No 2023-01-02 2024-06-29 52% 197.50 157.86 1620.00 2269.00
VER1177 VER1177-4 15281 NL Consultant No 2023-01-02 2024-06-29 52% 165.00 135.31 1620.00 2258.00
VER1177 VER1177-8 15436 NL Senior Consultant No 2023-07-20 2024-06-29 38% 197.50 157.86 756.00 1494.00
VER1929 VER1929-1 15830 NL Manager No 2024-04-24 2025-01-01 64% 235.00 141.75 920.00 892.00
VER2012 VER2012-5 15941 NL Senior Manager No 2024-05-01 2025-01-01 18% 262.50 165.00 256.00 960.00
VER2012 VER2012-8 15954 NL Senior Manager No 2024-05-01 2025-01-01 85% 262.50 164.49 1192.00 859.00
VER2012 VER2012-4 15920 NL Senior Consultant No 2024-05-01 2025-01-01 18% 205.00 145.00 256.00 1134.00
VER2012 VER2012-7 15946 NL Senior Consultant No 2024-05-01 2024-06-29 93% 205.00 141.24 320.00 272.00
VER2012 VER2012-9 15949 NL Senior Consultant No 2024-05-01 2024-12-21 63% 205.00 141.23 840.00 1136.00
VER2012 VER2012-1 15905 NL Senior Consultant No 2024-05-01 2025-01-01 77% 205.00 140.24 1088.00 1136.00
VER2012 VER2012-11 15907 NL Consultant No 2024-05-01 2024-10-02 95% 172.50 129.48 840.00 210.00
VER2012 VER2012-6 15943 NL Consultant No 2024-05-01 2025-01-01 18% 172.50 115.00 256.00 265.00
VER2012 VER2012-10 15913 NL Consultant No 2024-05-01 2024-12-21 63% 172.50 70.00 840.00 1184.00
VER2012 VER2012-3 15919 NL Director No 2024-05-06 2024-06-29 80% 305.00 174.49 256.00 0.00
VER2012 VER2012-2 15908 NL Manager No 2024-05-13 2025-01-01 89% 235.00 165.00 1192.00 1002.00
VER2012 VER2012-13 15959 NL Consultant No 2024-11-18 2025-01-01 103% 172.50 114.48 272.00 192.00
VER2211 VER2211-4 15232 NL Manager No 2024-12-02 2024-12-04 50% 235.00 208.33 12.00 12.00
VER2211 VER2211-5 15610 GB Director No 2024-12-02 2024-12-12 17% 325.58 208.33 12.00 12.00
VER2331 VER2331-3 16042 NL Senior Manager No 2025-01-02 2025-07-01 71% 270.00 165.00 736.00 632.00
VER2331 VER2331-1 16049 NL Senior Manager No 2025-01-02 2025-07-01 62% 270.00 164.49 640.00 529.00
VER2331 VER2331-2 16064 NL Senior Manager No 2025-01-06 2025-02-11 73% 270.00 165.00 158.00 158.00
VER2331 VER2331-4 16044 NL Manager No 2025-01-06 2025-03-18 92% 242.50 145.00 384.00 384.00
VER2331 VER2331-5 16054 NL Manager No 2025-01-06 2025-04-02 94% 242.50 140.24 473.00 473.00
VER2374 VER2374-2 16047 NL Manager No 2025-01-02 2025-07-01 97% 242.50 141.23 1000.00 866.00
VER2374 VER2374-3 16072 NL Consultant No 2025-01-02 2025-07-01 97% 175.00 114.48 1000.00 876.00
VER2374 VER2374-1 16056 NL Consultant No 2025-01-02 2025-07-01 97% 175.00 73.50 1000.00 816.00
VER2432 VER2432-2 15974 NL Director No 2025-02-03 2026-01-01 31% 312.50 225.00 592.00 272.00
VER2432 VER2432-1 16064 NL Senior Manager No 2025-02-03 2026-01-01 54% 270.00 165.00 1032.00 486.00
VER2432 VER2432-4 16071 NL Consultant No 2025-02-03 2026-01-01 80% 175.00 120.00 1520.00 536.00
VER2432 VER2432-3 16053 NL Senior Consultant No 2025-02-13 2025-05-31 81% 210.00 150.00 500.00 500.00
VER2432 VER2432-6 16044 NL Manager No 2025-03-17 2026-01-01 89% 242.50 145.00 1488.00 560.00
VER2588 VER2588-1 16042 NL Senior Manager No 2025-07-01 2026-01-01 69% 270.00 165.00 736.00 24.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
VER1929 15830
5.08
0.00
5.08
- - - - - - - - - - -
5.08
0.00
5.08
VER2012 15941
1.45
0.00
1.45
- - - - - - - - - - -
1.45
0.00
1.45
VER2012 15954
6.77
0.00
6.77
- - - - - - - - - - -
6.77
0.00
6.77
VER2012 15920
1.45
0.00
1.45
- - - - - - - - - - -
1.45
0.00
1.45
VER2012 15905
6.18
0.00
6.18
- - - - - - - - - - -
6.18
0.00
6.18
VER2012 15943
1.45
0.00
1.45
- - - - - - - - - - -
1.45
0.00
1.45
VER2012 15908
7.09
0.00
7.09
- - - - - - - - - - -
7.09
0.00
7.09
VER2012 15959
8.24
0.00
8.24
- - - - - - - - - - -
8.24
0.00
8.24
VER2331 16042
125.52
128.00
-2.48
114.11
108.00
6.11
119.81
132.00
-12.19
125.52
56.00
69.52
125.52
112.00
13.52
119.81
96.00
23.81
5.71
0.00
5.71
- - - - -
736.00
632.00
104.00
VER2331 16049
109.15
122.00
-12.85
99.22
72.00
27.22
104.19
2.00
102.19
109.15
123.00
-13.85
109.14
90.00
19.14
104.19
120.00
-15.81
4.96
0.00
4.96
- - - - -
640.00
529.00
111.00
VER2331 16064
117.04
126.00
-8.96
40.96
32.00
8.96
- - - - - - - - - -
158.00
158.00
0.00
VER2331 16044
147.70
160.00
-12.30
147.68
144.00
3.68
88.62
80.00
8.62
- - - - - - - - -
384.00
384.00
0.00
VER2331 16054
150.16
160.00
-9.84
150.16
145.00
5.16
157.66
168.00
-10.34
15.02
0.00
15.02
- - - - - - - -
473.00
473.00
0.00
VER2374 16047
170.54
160.00
10.54
155.04
160.00
-4.96
162.79
160.00
2.79
170.54
136.00
34.54
170.54
152.00
18.54
162.80
98.00
64.80
7.75
0.00
7.75
- - - - -
1000.00
866.00
134.00
VER2374 16072
170.54
160.00
10.54
155.04
128.00
27.04
162.79
144.00
18.79
170.54
160.00
10.54
170.54
152.00
18.54
162.80
132.00
30.80
7.75
0.00
7.75
- - - - -
1000.00
876.00
124.00
VER2374 16056
170.54
160.00
10.54
155.04
144.00
11.04
162.79
104.00
58.79
170.54
152.00
18.54
170.54
152.00
18.54
162.80
104.00
58.80
7.75
0.00
7.75
- - - - -
1000.00
816.00
184.00
VER2432 15974 -
49.54
48.00
1.54
52.02
64.00
-11.98
54.49
56.00
-1.51
54.49
48.00
6.49
52.02
56.00
-3.98
56.97
0.00
56.97
52.02
0.00
52.02
54.49
0.00
54.49
56.97
0.00
56.97
49.54
0.00
49.54
56.97
0.00
56.97
589.52
272.00
317.52
VER2432 16064 -
86.36
100.00
-13.64
90.68
116.00
-25.32
95.00
114.00
-19.00
95.00
124.00
-29.00
90.68
32.00
58.68
99.31
0.00
99.31
90.68
0.00
90.68
94.99
0.00
94.99
99.31
0.00
99.31
86.36
0.00
86.36
99.31
0.00
99.31
1027.68
486.00
541.68
VER2432 16071 -
127.20
88.00
39.20
133.56
128.00
5.56
139.92
128.00
11.92
139.92
64.00
75.92
133.55
128.00
5.55
146.27
0.00
146.27
133.56
0.00
133.56
139.92
0.00
139.92
146.27
0.00
146.27
127.20
0.00
127.20
146.27
0.00
146.27
1513.64
536.00
977.64
VER2432 16053 -
77.92
80.00
-2.08
136.36
116.00
20.36
142.86
156.00
-13.14
142.86
148.00
-5.14
- - - - - - -
500.00
500.00
0.00
VER2432 16044 - -
78.32
88.00
-9.68
156.63
168.00
-11.37
156.64
152.00
4.64
149.51
152.00
-2.49
163.74
0.00
163.74
149.52
0.00
149.52
156.64
0.00
156.64
163.74
0.00
163.74
142.40
0.00
142.40
163.74
0.00
163.74
1480.88
560.00
920.88
VER2588 16042 - - - - - -
127.28
24.00
103.28
116.21
0.00
116.21
121.74
0.00
121.74
127.28
0.00
127.28
110.68
0.00
110.68
127.28
0.00
127.28
730.47
24.00
706.47