Client Analysis


Client Metadata

Account ID

1005674

Account Name

1005674
Associated Projects
Project ID Project Name
VER2119 VER2119

Flag Summary

Project Allocations, Resources Overallocated: 0 0

Timewriting (April 2025): Corrected: 127.60h, Written: 65.00h, Difference: 62.60h (51%)

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

£478k

 

Planned Fees

£495k

Discount:
£17k (3.5%)

Corrected Fees

£297k

Scope Change:
£-198k (-40.0%)

Written Hours

£268k

Unrealised:
£-29k (-9.7%)

Revenue Assigned

£269k

Leakage:
£1k (0.4%)

Invoiced

£256k

Billing:
£-14k (-5.0%)

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)
£0k £0k £0k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£218k £232k £147k £118k £119k £256k
2024 £260k £263k £149k £150k £150k £0k
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)
£0k £0k
(0.0%)
£0k
(0.0%)
- - -
2025 (Actual)
(Up to July 2025)
£218k £14k
(6.4%)
£-84k
(-36.4%)
£-29k
(-19.9%)
£1k
(1.0%)
£136k
(114.5%)
2024 £260k £3k
(1.1%)
£-114k
(-43.3%)
£1k
(0.4%)
£0k
(0.0%)
£-150k
(-100.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 £76k £33k £35k £37k £37k - - - - - - - £218k
Planned £82k £35k £37k £39k £39k - - - - - - - £232k
Corrected £36k £26k £27k £29k £29k - - - - - - - £147k
Written £35k £26k £29k £15k £14k - - - - - - - £118k
Revenue £35k £26k £29k £15k £14k - - - - - - - £119k
Invoiced £150k £35k £26k - £44k - - - - - - - £256k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target - - - - - - £10k £18k £17k £64k £79k £73k £260k
Planned - - - - - - £10k £16k £16k £60k £83k £79k £263k
Corrected - - - - - - £11k £18k £17k £31k £37k £35k £149k
Written - - - - - - £7k £12k £13k £37k £48k £34k £150k
Revenue - - - - - - - - - - - £150k £150k
Invoiced - - - - - - - - - - - - £0k
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
VER2119 VER2119-1 15557 DE Director No 2024-07-15 2025-05-31 2% 305.00 225.00 39.00 39.00
VER2119 VER2119-2 15636 DE Manager No 2024-07-15 2025-05-31 44% 235.00 225.00 812.00 759.50
VER2119 VER2119-8 15772 CH Consultant No 2024-10-10 2024-11-09 30% 270.83 225.00 52.00 52.00
VER2119 VER2119-9 15982 DE Senior Consultant No 2024-10-15 2025-02-01 16% 205.00 225.00 99.00 99.00
VER2119 VER2119-11 15991 DE Consultant No 2024-11-01 2025-05-31 5% 172.50 225.00 64.50 64.50
VER2119 VER2119-10 15894 DE Manager No 2024-11-01 2025-05-31 21% 235.00 225.00 252.50 177.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
VER2119 15557
3.90
4.00
-0.10
3.39
7.00
-3.61
3.56
4.00
-0.44
3.73
5.00
-1.27
3.73
1.00
2.73
- - - - - - -
18.31
21.00
-2.69
VER2119 15636
81.20
105.50
-24.30
70.61
60.00
10.61
74.14
108.00
-33.86
77.68
60.00
17.68
77.66
59.00
18.66
- - - - - - -
381.29
392.50
-11.21
VER2119 15982
28.83
0.00
28.83
- - - - - - - - - - -
28.83
0.00
28.83
VER2119 15991
9.82
0.00
9.82
8.55
0.00
8.55
8.97
0.00
8.97
9.40
0.00
9.40
9.40
0.00
9.40
- - - - - - -
46.14
0.00
46.14
VER2119 15894
38.46
48.00
-9.54
33.44
48.00
-14.56
35.12
15.00
20.12
36.79
0.00
36.79
36.79
0.00
36.79
- - - - - - -
180.60
111.00
69.60