Investech Workbench
Data intake
Upload & validate workbook
Internal · Non-prod
Last refresh
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

The bundled sample workbook is synthetic sample data — illustrative only, not real client or market data.

Accepted workbook families

  • Main
  • Transactions
  • Returns / Exposure / IRR when present

Legacy standardized-template uploads are still supported for synthetic regression testing:

  • Client_Info
  • Portfolio_Settings
  • Holdings
  • Valuations

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