InvestorsFree
Capital Call Tracking Spreadsheet for LPs
Send the notices your managers sent you, and get one sheet where every call, due date and unfunded commitment reconciles to your bank record.
Auchendrane Family Office holds 54 fund commitments across 31 managers, 412,000,000 committed and 268,400,000 wired. Its tracking spreadsheet prints 143,600,000 of unfunded commitment, because unfunded commitment is commitment less what has been wired. The reconciled figure is 170,032,050.00, so the sheet is 26,432,050.00 low, which is 18.4 percent of what it says. Three of the four funds it shows as fully called can still call 6,240,000 between them. Nobody decided that. It is what the formula does.
Page one for this query is spreadsheets, and every one of them derives unfunded commitment that same way. Two are built for the general partner issuing a call rather than the investor receiving one. The commercial platforms have moved past the hard part: reading a notice whose layout changes every quarter is solved, and the leading one handles a call listing one investment or seven. What comes back is structured data. Reconciling it against your own bank record is still yours.
There is no standard notice to receive, either. ILPA released an updated capital call template in 2025 to improve uniformity, and it is not first delivered until the first quarter of 2027. Until then each manager sends what it sends, on a due date its own side letters may have moved. Auchendrane took in 487 documents last year, 118 of them capital calls, which is 9.4 a week landing in an inbox beside everything else.
Your unfunded commitment, the manager's unfunded commitment, and the one that is callable
The gap decomposes into five things. Nine funds returned capital designated recallable, 21,600,000 of it, which the sheet treats as gone and the notice on the other side restores. Recycling caps in three of them block 3,750,000, so 17,850,000 actually comes back. Fourteen wires arrived short after a correspondent bank took a fee, 4,970.00 in total, which the managers credited and the sheet still carries at the notice amount. Three commitments were increased at a later closing and 7,850,000 never reached the tracker.
The fifth is currency. Two euro funds carry 14,600,000 of unfunded commitment at a 1.0742 blend of the rates already wired, and at the 1.1240 closing rate that exposure is 727,080.00 larger. Together the five take the reconciled figure to 170,032,050.00. Then a third number appears: the managers' own stated unfunded figures sum to 170,612,050.00. The 580,000 difference is a wire a correspondent bank returned and the office re-sent, which one manager credited on neither leg.
Auchendrane reserves cash against unfunded commitment at last year's draw rate of 21.5 percent. On the sheet's figure that is 30,943,481.63 and on the reconciled figure 36,639,161.66, so the reserve runs 5,695,680.03 short. In its worst week seven calls fell due together, 9,180,000 against 6,400,000 of operating cash, and the difference came off a credit line. The 216 quarterly statements behind the performance figures arrive on their own clock. SEC exam staff have found advisers whose fee calculations left investors paying more than the fund documents required.
How it works
Send the notices
Every call, distribution, statement and letter your managers sent, in whatever format each of them used.
Match to the bank
Each wire against its notice and its debit, so a short settlement is named rather than absorbed.
Rebuild the unfunded figure
Recallable capital restored inside each recycling cap, later closings added, foreign currency at the closing rate.
Forecast and query
What the next ninety days will call, and every figure that disagrees with your own record.
What you get
- Every notice as one row: fund, manager, type, amount, purpose, due date and wire reference
- Unfunded commitment three ways: your own record, the manager's stated figure, and what is callable
- Recallable distributions carried against each fund's recycling cap, so restored commitment shows up early
- Each wire matched to its notice and its bank debit, with short settlements named rather than absorbed
- Commitments denominated in another currency held in that currency and translated at the closing rate
- A ninety-day call forecast off your own draw history, flagging the weeks where notices overlap
- Every discrepancy to query, with the notice, the bank record and the amount between them
Common questions
Is unfunded commitment not commitment less what I have paid?
Only when nothing has come back recallable and every wire was credited in full. In the worked example neither holds. Recallable capital restores 17,850,000 inside the recycling caps, and fourteen wires were credited short of the notice. The two-term version prints 143,600,000 against a callable figure of 170,032,050.00.
Does extraction from all these layouts not already exist?
It does, and it is the wrong thing to build on. The commercial platforms read a notice whether it lists one investment or seven, and they cross-check the wire details before anybody sends money. What they hand back is structured data. The reconciliation against your own bank record and commitment history is the part still left.
Why does a recallable distribution matter this much?
Because it restores capacity the sheet has already written off. Nine funds returned 21,600,000 designated recallable, and 17,850,000 of that sits inside the recycling caps and can come back. It is why three funds showing as fully called can still call 6,240,000, and why a call arrives the sheet said was impossible.
How can the manager's own stated figure be wrong?
The same way anybody's is. One wire in the worked example was returned by a correspondent bank and re-sent the next day, and the manager credited neither leg, so its stated unfunded runs 580,000 high. The three-way match against the bank statement is what proves it, and the answer is a query rather than an adjustment.
What happens with commitments in another currency?
They stay in that currency and the unfunded balance is translated at the closing rate, because it is a future obligation rather than a past one. Two euro funds carry 14,600,000 of it, and the difference between the 1.0742 blend already wired and the 1.1240 closing rate is 727,080.00.
Does this replace my administrator or my accountant?
No. It hands both of them a reconciled starting point instead of a spreadsheet and a folder of PDFs. The unfunded figure ties to your bank record in one direction and to each manager's stated figure in the other, so a disagreement arrives named rather than as a question inside somebody's audit.
What does the ninety-day forecast run on?
Your own draw history, fund by fund, applied to the reconciled unfunded figure rather than the sheet's. Auchendrane drew 21.5 percent of unfunded commitment last year across 118 calls averaging 354,237.29. The output is week by week, because seven of those calls fell due in the same week once.
Capital Call Tracking Spreadsheet for LPs
Fill in the form and your workspace opens with the work already underway.