Client Analysis


Client Metadata

Account ID

1005662

Account Name

1005662
Associated Projects
Project ID Project Name
VER2159 VER2159

Flag Summary

Project Allocations, Resources Overallocated: 0 2

Timewriting (April 2025): Corrected: 180.60h, Written: 168.00h, Difference: 12.60h (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

£433k

 

Planned Fees

£433k

Discount:
£0k (0.0%)

Corrected Fees

£413k

Scope Change:
£-20k (-4.6%)

Written Hours

£362k

Unrealised:
£-51k (-12.4%)

Revenue Assigned

£322k

Leakage:
£-40k (-11.0%)

Invoiced

£322k

Billing:
£0k (0.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)
£215k £215k £215k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£301k £301k £292k £243k £203k £232k
2024 £132k £132k £122k £119k £119k £90k
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)
£215k £0k
(0.0%)
£0k
(0.0%)
- - -
2025 (Actual)
(Up to July 2025)
£301k £0k
(0.0%)
£-10k
(-3.3%)
£-49k
(-16.6%)
£-40k
(-16.5%)
£29k
(14.3%)
2024 £132k £0k
(0.0%)
£-10k
(-7.7%)
£-3k
(-2.3%)
£0k
(0.0%)
£-29k
(-24.4%)
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 £45k £39k £41k £45k £43k £41k £45k £41k £43k £45k £39k £45k £516k
Planned £45k £39k £41k £45k £43k £41k £45k £41k £43k £45k £39k £45k £516k
Corrected £42k £36k £38k £45k £43k £41k £45k £41k £43k £45k £39k £45k £506k
Written £44k £40k £37k £42k £40k £40k - - - - - - £243k
Revenue £44k £40k £37k £42k £40k - - - - - - - £203k
Invoiced - £29k £84k £37k £42k £40k - - - - - - £232k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target - - - - - - - - £2k £45k £41k £43k £132k
Planned - - - - - - - - £2k £45k £41k £43k £132k
Corrected - - - - - - - - £2k £42k £38k £40k £122k
Written - - - - - - - - £2k £46k £42k £29k £119k
Revenue - - - - - - - - - £48k £42k £29k £119k
Invoiced - - - - - - - - - - £48k £42k £90k
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
VER2159 VER2159-1 7000018 N/A N/A No 2024-09-30 2025-04-01 91% 250.00 250.00 960.00 960.00
VER2159 VER2159-3 15150 NL Interim No 2025-04-01 2026-01-01 98% 250.00 250.00 1560.00 488.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
VER2159 7000018
167.28
176.00
-8.72
145.46
160.00
-14.54
152.73
148.00
4.73
7.27
0.00
7.27
- - - - - - - -
472.74
484.00
-11.26
VER2159 15150 - - -
173.33
168.00
5.33
173.33
160.00
13.33
165.46
160.00
5.46
181.21
0.00
181.21
165.46
0.00
165.46
173.33
0.00
173.33
181.21
0.00
181.21
157.58
0.00
157.58
181.21
0.00
181.21
1552.12
488.00
1064.12