SOI Builder (Claude Skill)

At every quarter-end and audit, someone has to build the Schedule of Investments: every position the fund holds, with cost, fair value, unrealized gain, and percent of NAV. Then they have to tie it out, explain every mark, and get it into a format the fund administrator and auditors will accept. This skill builds that schedule for you, one tab per fund, with formulas instead of hardcoded numbers and a source trail behind every line.

Your funds, investments, securities, and marks come straight from Visible, so there’s no mapping step.

Tell Claude something like:

If you don’t say which fund, Claude asks. The default as-of date is the most recent quarter-end. If you don’t say Google Sheets or Excel, Claude asks once.

The instructions below are packaged into the skill file. You don’t need them to use it, but here’s what’s happening under the hood.

Matching your existing SOI. If you have a prior-quarter SOI, from your fund admin or your own team, share it and Claude will match its tabs, column order, grouping, and formatting. Auditors compare quarters, so a schedule that changes shape from one quarter to the next creates questions. With nothing to start from, Claude uses a standard layout grouped by security type, with subtotals.

Building the schedule as of the right date. Every number reflects the as-of date, not today. Claude rebuilds each position from dated transactions and marks in Visible. Investments made after the as-of date are left out, positions exited before it are excluded, and a mark recorded after the as-of date isn’t used, even if it’s the latest one in Visible.

Using formulas for everything calculated. Unrealized gain, percent of NAV, subtotals, and totals are all spreadsheet formulas. If an input changes, the schedule recalculates.

Leaving a trail auditors can follow. Every row includes the Visible record IDs it came from, plus the valuation date and the methodology behind the mark. A Detail tab holds the underlying records, and the schedule’s cost and fair value cells link to it. Pick any line, and you can trace it back to its source.

Tying out to Visible. A Tie-out tab reconciles each fund’s investment count, total cost, and total fair value against Visible, with a check cell that reads “Ties” or “Check differences.” Any difference gets explained in the Notes tab rather than adjusted away.

Handling NAV correctly. Percent of NAV needs the fund’s full net asset value, including cash and liabilities, which Visible usually doesn’t track. Claude asks for NAV from your fund administrator’s statements or general ledger and puts it in a labeled input cell with its source. If NAV isn’t available, Claude won’t quietly divide by total investments under a NAV label. It relabels the column “% of total investments at fair value,” so nobody mistakes one for the other.

Flagging what auditors will ask about. Before building, Claude checks the data and flags:

Claude reports these rather than fixing them silently.

Checking in before building. Before creating the workbook, Claude confirms the funds, as-of date, NAV source, number of investments, any exclusions, and the flagged issues. Say “just build it” up front and this step is skipped, but the flags still lead the final summary.

Claude shares the file, summarizes the investments and totals for each fund, confirms the NAV source, and lists any issues to resolve before the schedule goes to your fund administrator or auditors.