AnaCap Fund Finance Update Tool

Automated aggregation and validation of fund NAV, cashflow, and performance metrics from quarterly returns and capital notice files. All processing runs locally in this browser — no data is uploaded or retained.

What this tool updates: NAV for Bridge, Fund IV and Andromeda's portfolio companies (from their quarterly returns files); Andromeda's cumulative Invested figures per company (from the same returns file's Invested Capital tab, summed by deal codename); and Bridge and Fund IV Cashflow (Invested & Distributed), read from each fund's capital call and distribution notice files, classified line-by-line and cross-checked against every notice's own stated total before being accepted. Cashflow updates are added on top of the master's existing balance — never a wholesale replacement — so only genuinely new notices affect the numbers. Fund-level lines (Partnership/Organisational Expenses, Management Fees, GP items) are summed into the matching fund's "Fund Expenses" row on 4_Fund_Performance instead of a company row. Matching cells are updated in the master's 2_NAV_AUM, 3_Cashflow and 4_Fund_Performance sheets.
Not yet covered: Fund I, Fund II, Fund III, QIA, Co-Inv; Andromeda Distributed (no real distribution has happened yet to validate against). Any notice line that doesn't resolve to a known company (e.g. "Fintus", "Fiduciaire Jean-Marc Faber") is flagged for manual review rather than guessed or silently dropped — see the flagged rows below. Nothing is written until you review every row and tick confirm. A backup and audit log are produced automatically alongside every write.
1

Select the master workbook (a copy — never the live original)

e.g. AnaCap_Fund_Finance_DataPack_v3_1.xlsx

No file selected.
2

Select the mini spreadsheets

Sign in to load files directly from SharePoint (Returns, Calls and Dists), or select a folder manually.

3

Scan

Reads both files and builds the proposed changes below. Nothing is written at this step.