Capital call tracker
What you have committed, what has been drawn, and what a manager can still call tomorrow. Across every fund, with the recallable portion counted back in.
Sample book · six positions
Invented funds and invented figures, so the tool has something in it
These are made-up funds and made-up numbers, here to show what the tool does. Overwrite them or clear the grid before you use it for anything real.
| Fund | Vintage | Commitment | Called | Distributed | Recallable | Unfunded | |
|---|---|---|---|---|---|---|---|
| 1 | Muster Ventures II | 2019 | 2,000,000.00 | 1,800,000.00 | 1,340,000.00 | 0.00 | 200,000.00 |
| 2 | Beispiel Buyout III | 2017 | 1,500,000.00 | 1,500,000.00 | 2,100,000.00 | 0.00 | 0.00 |
| 3 | Platzhalter Growth I | 2021 | 1,250,000.00 | 1,000,000.00 | 320,000.00 | 150,000.00 | 400,000.00 |
| 4 | Mustermann Secondaries | 2022 | 1,000,000.00 | 550,000.00 | 90,000.00 | 0.00 | 450,000.00 |
| 5 | Beispiel Infrastruktur | 2023 | 2,000,000.00 | 300,000.00 | 0.00 | 0.00 | 1,700,000.00 |
| 6 | Muster Co-Invest SPV | 2024 | 1,500,000.00 | 40,000.00 | 0.00 | 0.00 | 1,460,000.00 |
Our sample figuresYour figures
This works from the figures you type. Wealth Management by Zahlenwerk works from the notice itself, and keeps the unfunded figure current without anyone maintaining it.
What this works out
Unfunded commitment is the amount your managers can still legally draw from you, and it is the number liquidity planning in private markets runs on. It is not simply commitment minus called. A distribution marked recallable in the notice goes back into what the fund may draw again, so leaving it out understates your exposure by exactly that amount — and the fund is entitled to call it. This tool takes one row per position and gives you the figure per fund and for the whole book.
How to use it
- 01
Enter one row per fund
Fund name, vintage, and the commitment you signed. Sample rows are loaded so you can see the shape; overwrite them or clear the grid and start clean.
- 02
Add called and distributed to date
Cumulative figures, not individual movements — the last capital account statement usually has both. If you need per-cashflow detail and performance metrics, that is the IRR, TVPI and DPI calculator instead.
- 03
Enter the recallable portion
Of the distributions you have received, how much was marked recallable. This is the column that changes the answer, and the one most spreadsheets do not have.
- 04
Read the total, then export
Unfunded per fund appears in the last column and the book total in the card above. Export to Excel or CSV, with the arithmetic intact so your own model can carry on from it.
Why recallable distributions change the number
Say you committed 1.25m, 1.0m has been called, and 320k has come back — of which 150k was recallable. A spreadsheet doing commitment minus called shows 250k unfunded. The real figure is 400k, because the recallable 150k returned to the amount the fund can draw. That gap is small enough to ignore on one position and large enough to miss a wire on ten. Recycling provisions vary: some LPAs cap the recallable amount, some allow it only during the investment period, and some define it against distributions of return of capital only. This tool takes the permissive reading — everything you mark recallable goes back into unfunded — because that is the version that does not surprise you. Your LPA is the authority.
Capital callCommitmentCapital account statementYou missed a capital call — what happens next
What this cannot tell you
It cannot tell you a call is due. Nothing here knows what arrived in your inbox this morning, so this is a picture of your exposure as of the figures you typed, not a deadline you will be warned about. It also holds one currency at a time and no per-cashflow dates, which means no IRR — that is a different tool. And it is a snapshot in a browser tab: close it and the figures are gone.
Where your figures go
Nowhere. Everything runs in your browser — nothing is uploaded, nothing is stored, and there is no account. Close the tab and it is gone, which is also why you should export before you do.
Questions
Is unfunded commitment the same as remaining commitment?
Usually the same thing in practice, though people use both loosely. What matters is whether the figure includes recallable distributions. Two people using the same words and different treatments of recycling will produce different numbers, which is the disagreement this tool tries to make visible rather than settle.
Can unfunded be negative?
Yes, and it is shown rather than clamped to zero. More can be called than was committed where recycling provisions allow it, and a negative figure is a real state, not an input error. If you did not expect it, check the recallable column first.
What if fees were drawn outside the commitment?
Then they should not go in the called column, because they do not reduce what the fund can still draw against your commitment. Enter only capital called against the commitment. Whether fees count as paid-in capital is a separate question and it matters for TVPI and DPI, not for this.
Can I use several currencies?
Not in one grid — everything here is in a single currency and there is no FX conversion. Run one grid per currency, or convert before entering. Adding a currency column that silently added euros to dollars would be worse than not having one.
Does it handle capital calls that are due but not yet paid?
Not as a separate state. A call you have received but not wired is still unfunded commitment as far as this arithmetic is concerned, which is correct for exposure and useless as a reminder. Tracking the due date itself is what the product does.
The version that knows a call arrived
This tool works from what you type. Wealth Management by Zahlenwerk works from the notice itself: forward it, or connect the mailbox, and the call becomes a record against the commitment it draws on — with the due date visible to your whole team rather than sitting in one inbox.
Wealth Management →