Demo for Project Accountants — private equity / fund administration support. Multi-fund portfolio view with a NAV bridge, performance multiples, capital activity and a data-quality exception log. Every headline figure is derived from cleaned transaction data and cross-checked below; the full pipeline, SQL and Excel model are at the bottom of the page.
As at 30 September 2026 · Q3 2026 · USD| Fund | Strategy | Vintage | Commitment | % Called | Paid-in | NAV | DPI | RVPI | TVPI | Net IRR | DQ Status | Exceptions |
|---|
| Ref | Fund | Category | Description | Value | Age (days) | Owner |
|---|
128 raw cash-flow rows: four date formats, eight type spellings, fund names vs IDs, sign-flipped amounts, 3 double-postings.
Normalises to 125 clean rows, then runs 7 validation rules: bridge closure, over-calls, dating, referential checks.
Paid-in, distributions, DPI/RVPI/TVPI, DQ status and the 8-quarter cash-flow series, loaded to SQLite.
This page, plus a formula-driven workbook (SUMIFS/INDEX-MATCH, as-at date driver, 7 integrity checks).
Loading…