Client Analysis


Client Metadata

Account ID

1001419

Account Name

1001419
Associated Projects
Project ID Project Name
VER1663 VER1663
VER1669 VER1669
VER1706 VER1706
VER1868 VER1868
VER2028 VER2028
VER2177 VER2177
VER2259 VER2259
VER2318 VER2318
VER2444 VER2444

Flag Summary

Project Allocations, Resources Overallocated: 0 0

Timewriting (April 2025): Corrected: 1668.82h, Written: 1538.50h, Difference: 130.32h (92%)

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

£5,294k

 

Planned Fees

£4,414k

Discount:
£-880k (-16.6%)

Corrected Fees

£4,498k

Scope Change:
£84k (1.9%)

Written Hours

£4,110k

Unrealised:
£-388k (-8.6%)

Revenue Assigned

£3,917k

Leakage:
£-193k (-4.7%)

Invoiced

£3,901k

Billing:
£-16k (-0.4%)

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,248k £999k £999k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£1,821k £1,474k £1,474k £1,237k £986k £1,049k
2024 £3,473k £2,940k £3,024k £2,873k £2,931k £2,852k
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,248k £-248k
(-19.9%)
£0k
(0.0%)
- - -
2025 (Actual)
(Up to July 2025)
£1,821k £-347k
(-19.0%)
£-0k
(0.0%)
£-237k
(-16.1%)
£-251k
(-20.3%)
£63k
(6.4%)
2024 £3,473k £-533k
(-15.4%)
£84k
(2.9%)
£-151k
(-5.0%)
£57k
(2.0%)
£-79k
(-2.7%)
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 £266k £238k £254k £266k £266k £254k £278k £244k £251k £262k £228k £262k £3,068k
Planned £213k £193k £206k £216k £216k £206k £225k £196k £201k £210k £183k £210k £2,473k
Corrected £213k £193k £206k £216k £216k £206k £225k £196k £201k £210k £183k £210k £2,473k
Written £202k £203k £202k £204k £202k £217k £8k - - - - - £1,237k
Revenue £171k £217k £214k £178k £206k - - - - - - - £986k
Invoiced - - £429k £215k £405k - - - - - - - £1,049k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £346k £299k £311k £302k £316k £248k £274k £224k £249k £304k £283k £318k £3,473k
Planned £290k £255k £268k £257k £268k £216k £237k £198k £216k £244k £230k £262k £2,940k
Corrected £300k £269k £285k £277k £290k £231k £247k £203k £207k £232k £225k £258k £3,024k
Written £297k £288k £252k £247k £276k £233k £241k £233k £241k £224k £214k £128k £2,873k
Revenue £294k £294k £241k £261k £278k £236k £260k £193k £257k £232k £176k £209k £2,931k
Invoiced - £57k £57k £28k £62k £69k £1,769k £21k £174k £174k £250k £191k £2,852k
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
VER1663 VER1663-1 15498 N/A N/A No 2024-01-02 2024-03-30 100% 83.58 83.58 512.00 496.00
VER1663 VER1663-2 15526 N/A N/A No 2024-01-02 2024-03-30 100% 82.85 82.85 512.00 500.00
VER1669 VER1669-1 15122 GB Partner No 2024-01-02 2025-01-01 1% 383.72 220.93 16.00 16.00
VER1669 VER1669-3 10006 BE Senior Manager No 2024-01-02 2024-11-01 57% 262.50 197.67 1007.00 1007.00
VER1669 VER1669-4 15438 GB Senior Manager No 2024-01-02 2024-08-01 104% 290.70 197.67 1278.00 1278.00
VER1669 VER1669-8 158 BE Business Associate No 2024-01-02 2025-01-01 92% 197.67 197.67 1920.00 1844.00
VER1669 VER1669-13 15273 GB Business Associate No 2024-01-02 2025-01-01 0% 168.60 168.60 8.00 8.00
VER1669 VER1669-5 15490 NL Senior Manager No 2024-01-02 2024-08-01 97% 262.50 168.60 1184.00 904.00
VER1669 VER1669-2 15336 GB Interim No 2024-01-02 2025-01-01 92% 168.60 168.60 1920.00 1920.00
VER1669 VER1669-7 15496 NL Senior Consultant No 2024-01-02 2024-02-01 78% 205.00 139.53 144.00 144.00
VER1669 VER1669-6 15493 BE Senior Consultant No 2024-01-02 2024-06-01 93% 205.00 139.53 808.00 808.00
VER1669 VER1669-9 15482 GB Interim No 2024-01-02 2024-08-01 92% 130.81 130.81 1124.50 1124.50
VER1669 VER1669-11 15231 GB Interim No 2024-01-02 2024-06-29 92% 113.37 113.37 953.00 953.00
VER1669 VER1669-10 15483 GB Interim No 2024-01-02 2024-06-29 79% 94.48 94.48 816.00 816.00
VER1706 VER1706-1 15509 GB Interim No 2024-01-02 2024-06-29 101% 98.10 98.10 1040.00 1008.00
VER1706 VER1706-2 15335 GB Interim No 2024-01-02 2024-06-29 101% 78.49 78.49 1040.00 968.00
VER1868 VER1868-1 15498 N/A N/A No 2024-03-01 2024-06-29 0% 83.58 83.58 0.00 0.00
VER1868 VER1868-2 15524 GB Interim No 2024-03-11 2025-01-01 127% 115.56 115.56 2158.00 1432.00
VER1868 VER1868-3 15483 GB Interim No 2024-12-02 2025-01-01 33% 94.48 94.48 60.00 60.00
VER1868 VER1868-4 15336 GB Interim No 2024-12-11 2025-01-01 88% 168.60 168.60 112.00 92.00
VER2028 VER2028-3 15231 GB Interim No 2024-07-01 2025-01-01 75% 113.37 113.37 800.00 800.00
VER2028 VER2028-1 15509 GB Interim No 2024-07-01 2025-01-01 60% 98.10 98.10 642.00 642.00
VER2028 VER2028-2 15483 GB Interim No 2024-07-01 2025-01-01 56% 94.48 94.48 600.00 596.00
VER2028 VER2028-4 15335 GB Interim No 2024-07-01 2025-01-01 75% 78.49 78.49 800.00 800.00
VER2028 VER2028-5 15438 GB Senior Manager No 2024-08-01 2025-01-01 36% 290.70 197.67 320.00 320.00
VER2028 VER2028-7 15490 NL Senior Manager No 2024-08-01 2025-01-01 78% 262.50 168.60 684.00 676.00
VER2028 VER2028-6 15482 GB Interim No 2024-08-01 2025-01-01 54% 130.81 130.81 478.00 476.00
VER2028 VER2028-8 10006 BE Senior Manager No 2024-09-02 2025-01-01 51% 262.50 197.67 361.00 361.00
VER2177 VER2177-2 15708 BE Consultant No 2024-10-01 2025-01-01 72% 172.50 43.60 384.00 384.00
VER2259 VER2259-6 15438 GB Senior Manager No 2024-11-01 2025-01-01 45% 290.70 197.67 160.00 160.00
VER2259 VER2259-4 15482 GB Interim No 2024-11-01 2025-01-01 41% 130.81 130.81 144.00 144.00
VER2259 VER2259-5 15509 GB Interim No 2024-11-01 2025-01-01 45% 98.10 98.10 160.00 160.00
VER2318 VER2318-5 10006 BE Director No 2025-01-02 2026-01-01 80% 312.50 202.38 1672.00 824.00
VER2318 VER2318-6 158 BE Business Associate No 2025-01-02 2026-01-01 80% 202.38 202.38 1680.00 838.00
VER2318 VER2318-12 15490 NL Senior Manager No 2025-01-02 2026-01-01 40% 270.00 172.62 840.00 766.50
VER2318 VER2318-14 15336 GB Interim No 2025-01-02 2026-01-01 84% 172.62 172.62 1760.00 936.00
VER2318 VER2318-9 15482 GB Interim No 2025-01-02 2026-01-01 84% 133.93 133.93 1760.00 792.00
VER2318 VER2318-15 15524 GB Interim No 2025-01-02 2026-01-01 84% 118.31 118.31 1760.00 856.00
VER2318 VER2318-11 15231 GB Interim No 2025-01-02 2026-01-01 84% 116.07 116.07 1760.00 920.00
VER2318 VER2318-8 15509 GB Interim No 2025-01-02 2026-01-01 84% 100.44 100.44 1760.00 918.00
VER2318 VER2318-10 15483 GB Interim No 2025-01-02 2026-01-01 84% 96.73 96.73 1760.00 804.00
VER2318 VER2318-7 15708 BE Consultant No 2025-01-02 2026-01-01 81% 175.00 89.29 1688.00 840.00
VER2318 VER2318-13 15966 BE Consultant No 2025-01-02 2026-01-01 80% 175.00 65.48 1680.00 683.00
VER2444 VER2444-2 16086 IN Interim No 2025-02-10 2025-08-09 80% 104.17 104.17 836.00 0.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
VER1669 15122
0.06
0.00
0.06
- - - - - - - - - - -
0.06
0.00
0.06
VER1669 158
7.33
0.00
7.33
- - - - - - - - - - -
7.33
0.00
7.33
VER1669 15273
0.03
0.00
0.03
- - - - - - - - - - -
0.03
0.00
0.03
VER1669 15336
7.33
0.00
7.33
- - - - - - - - - - -
7.33
0.00
7.33
VER1868 15524
10.13
0.00
10.13
- - - - - - - - - - -
10.13
0.00
10.13
VER1868 15483
2.61
0.00
2.61
- - - - - - - - - - -
2.61
0.00
2.61
VER1868 15336
7.00
0.00
7.00
- - - - - - - - - - -
7.00
0.00
7.00
VER2028 15231
6.01
0.00
6.01
- - - - - - - - - - -
6.01
0.00
6.01
VER2028 15509
4.82
0.00
4.82
- - - - - - - - - - -
4.82
0.00
4.82
VER2028 15483
4.51
0.00
4.51
- - - - - - - - - - -
4.51
0.00
4.51
VER2028 15335
6.01
0.00
6.01
- - - - - - - - - - -
6.01
0.00
6.01
VER2028 15438
2.91
0.00
2.91
- - - - - - - - - - -
2.91
0.00
2.91
VER2028 15490
6.21
0.00
6.21
- - - - - - - - - - -
6.21
0.00
6.21
VER2028 15482
4.34
0.00
4.34
- - - - - - - - - - -
4.34
0.00
4.34
VER2028 10006
4.10
0.00
4.10
- - - - - - - - - - -
4.10
0.00
4.10
VER2177 15708
5.73
0.00
5.73
- - - - - - - - - - -
5.73
0.00
5.73
VER2259 15438
3.64
0.00
3.64
- - - - - - - - - - -
3.64
0.00
3.64
VER2259 15482
3.28
0.00
3.28
- - - - - - - - - - -
3.28
0.00
3.28
VER2259 15509
3.64
0.00
3.64
- - - - - - - - - - -
3.64
0.00
3.64
VER2318 10006
140.93
132.00
8.93
128.12
128.00
0.12
134.53
131.00
3.53
140.94
137.00
3.94
140.94
112.00
28.94
134.53
160.00
-25.47
147.34
24.00
123.34
134.53
0.00
134.53
140.93
0.00
140.93
147.34
0.00
147.34
128.12
0.00
128.12
147.34
0.00
147.34
1665.59
824.00
841.59
VER2318 158
141.61
144.00
-2.39
128.74
152.00
-23.26
135.17
152.00
-16.83
141.61
128.00
13.61
141.61
108.00
33.61
135.17
154.00
-18.83
148.05
0.00
148.05
135.17
0.00
135.17
141.61
0.00
141.61
148.04
0.00
148.04
128.74
0.00
128.74
148.04
0.00
148.04
1673.56
838.00
835.56
VER2318 15490
70.80
111.00
-40.20
64.37
120.00
-55.63
67.59
137.00
-69.41
70.80
120.50
-49.70
70.80
134.00
-63.20
67.59
144.00
-76.41
74.02
0.00
74.02
67.59
0.00
67.59
70.81
0.00
70.81
74.02
0.00
74.02
64.37
0.00
64.37
74.02
0.00
74.02
836.78
766.50
70.28
VER2318 15336
148.35
176.00
-27.65
134.87
144.00
-9.13
141.61
168.00
-26.39
148.35
152.00
-3.65
148.35
160.00
-11.65
141.61
136.00
5.61
155.10
0.00
155.10
141.61
0.00
141.61
148.35
0.00
148.35
155.10
0.00
155.10
134.86
0.00
134.86
155.10
0.00
155.10
1753.26
936.00
817.26
VER2318 15482
148.35
136.00
12.35
134.87
128.00
6.87
141.61
112.00
29.61
148.35
136.00
12.35
148.35
144.00
4.35
141.61
136.00
5.61
155.10
0.00
155.10
141.61
0.00
141.61
148.35
0.00
148.35
155.10
0.00
155.10
134.86
0.00
134.86
155.10
0.00
155.10
1753.26
792.00
961.26
VER2318 15524
148.35
80.00
68.35
134.87
160.00
-25.13
141.61
160.00
-18.39
148.35
160.00
-11.65
148.35
160.00
-11.65
141.61
136.00
5.61
155.10
0.00
155.10
141.61
0.00
141.61
148.35
0.00
148.35
155.10
0.00
155.10
134.86
0.00
134.86
155.10
0.00
155.10
1753.26
856.00
897.26
VER2318 15231
148.35
160.00
-11.65
134.87
160.00
-25.13
141.61
128.00
13.61
148.35
144.00
4.35
148.35
160.00
-11.65
141.61
168.00
-26.39
155.10
0.00
155.10
141.61
0.00
141.61
148.35
0.00
148.35
155.10
0.00
155.10
134.86
0.00
134.86
155.10
0.00
155.10
1753.26
920.00
833.26
VER2318 15509
148.35
162.00
-13.65
134.87
154.00
-19.13
141.61
156.00
-14.39
148.35
144.00
4.35
148.35
160.00
-11.65
141.61
142.00
-0.39
155.10
0.00
155.10
141.61
0.00
141.61
148.35
0.00
148.35
155.10
0.00
155.10
134.86
0.00
134.86
155.10
0.00
155.10
1753.26
918.00
835.26
VER2318 15483
148.35
128.00
20.35
134.87
108.00
26.87
141.61
152.00
-10.39
148.35
128.00
20.35
148.35
136.00
12.35
141.61
152.00
-10.39
155.10
0.00
155.10
141.61
0.00
141.61
148.35
0.00
148.35
155.10
0.00
155.10
134.86
0.00
134.86
155.10
0.00
155.10
1753.26
804.00
949.26
VER2318 15708
142.28
152.00
-9.72
129.35
140.00
-10.65
135.82
116.00
19.82
142.28
136.00
6.28
142.28
140.00
2.28
135.82
156.00
-20.18
148.75
32.00
116.75
135.82
0.00
135.82
142.28
0.00
142.28
148.75
0.00
148.75
129.35
0.00
129.35
148.75
0.00
148.75
1681.53
872.00
809.53
VER2318 15966
141.61
120.00
21.61
128.74
116.00
12.74
135.17
42.00
93.17
141.61
153.00
-11.39
141.61
120.00
21.61
135.17
132.00
3.17
148.05
0.00
148.05
135.17
0.00
135.17
141.61
0.00
141.61
148.04
0.00
148.04
128.74
0.00
128.74
148.04
0.00
148.04
1673.56
683.00
990.56
VER2444 16086 -
96.46
0.00
96.46
135.05
0.00
135.05
141.48
0.00
141.48
141.48
0.00
141.48
135.04
0.00
135.04
147.91
0.00
147.91
38.58
0.00
38.58
- - - -
836.00
0.00
836.00