Quality Monitoring

This dashboard tracks variances between reported values (from fund administrators) and calculated values (from instrument-level cashflows) to identify potential data quality issues.

Variance Summary

Funds with Significant Variances

NAV Variance Analysis

NAV: Reported vs Calculated

NAV Variance Over Time

Called Capital Variance Analysis

Called Capital: Reported vs Calculated

Called Capital Variance Over Time

Distributions Variance Analysis

Distributions: Reported vs Calculated

Distributions Variance Over Time

Detailed Variance Data

Interpretation Guide

What do these variances mean?

• Small variances (less than 0.1%): Normal rounding differences or timing differences between systems
• Medium variances (0.1-2%): May indicate data entry errors or reconciliation issues - investigate
• Large variances (greater than 2%): Likely data quality issues - requires immediate attention

Common causes of variances:

1. Timing differences: Fund admin reports on different dates than instrument snapshots
2. Currency conversion: Different FX rates used in different systems
3. Data entry errors: Incorrect values entered in one system
4. Missing transactions: Cashflows not recorded in instrument system
5. Methodology differences: Different calculation methods between systems

Action items when variances are detected:

1. Review source data in both systems
2. Check for missing or duplicate transactions
3. Verify FX rates and currency conversions
4. Reconcile with fund administrator
5. Update data as needed and re-run pipeline