1
UploadActual D-03 / YoY .xlsx workbook
2
ValidateSheets, columns & data quality
3
CalculateNAV, returns, risk, benchmark
4
ReviewConsultant sign-off
5
ExportReport pack
Workbook intake· actual worksheet family or legacy standardized template
Accepted workbook families
MainTransactionsReturns / Exposure / IRR when present
Legacy standardized-template uploads are still supported for synthetic regression testing:
Client_InfoPortfolio_SettingsHoldingsValuations
Data quality policy
Financial calculations must be deterministic, tested and auditable. A workbook must pass all blocking-level checks before it can proceed to calculation.
Warnings (e.g. empty optional sheets) are surfaced for the consultant but do not block the pipeline. Every value carries an audit trail through to export.
Errors blockWarnings advise