Draft the quarterly LP letter
Portfolio metrics gathered from founder updates and dashboards, drafted into your quarterly letter, with every figure carrying the date it was reported.
- Starts
- Quarterly schedule
- Steps
- 5
- Checks and gates
- 0
- A person decides
- Never, runs alone
Trigger · Schedule
Quarterly schedule
The run starts at quarter end, once founder updates for the period have had time to arrive.
Claude runs the rest autonomously
- 1
AI gathers each company's dated figures.
GmailGmail
Every portfolio company's figures come out of the quarter's founder updates, each one carrying the date it was reported.
- 2
AI names companies that did not report.
Every company with no update is named with its last reporting date, and no stale figures are carried forward.
- 3
AI reconciles figures, flags disagreements.
Google SheetsGoogle Sheets
Self-reported figures are checked against the fund's holdings and carrying values, and any disagreement is flagged, not resolved.
- 4
AI drafts a letter with dated figures.
NotionNotion
The draft letter has every figure carrying its source and date, and no forward claims beyond what founders stated.
- 5
AI queues the exceptions for a partner.
A partner gets a work queue first, listing non-reporters, disagreements and any total that failed to reconcile.
The quarterly LP letter is three days of gathering and an afternoon of writing. Someone searches the mailbox for every founder update, copies figures into a sheet, notices that four companies have not reported, chases them, reconciles what came back against the fund's own records, and only then starts drafting. The gathering is where the time goes and where the errors enter.
The updates are all in one mailbox and the fund's records are in one sheet. The join between them is mechanical, and so is the check that the quarter's totals still add up. What any of it means is not, and that is where a partner's afternoon should go.
What you get
A quarterly draft where every portfolio figure carries the date and source it came from, companies that reported nothing are named rather than omitted, and the fund-level numbers reconcile.
Gathering portfolio updates for the quarter
The run starts at quarter end, once founder updates for the period have had time to arrive. It searches the mailbox in Gmail for each portfolio company's updates covering the quarter, matching on the company's domain rather than on a founder's name. Founders change, and forwarded updates arrive from whichever partner received them.
From each update it extracts what was reported and when: revenue, growth, runway in months, headcount, and any financing event. Every portfolio company with no update this quarter goes on a separate list, with the date of its last one.
The fund's side comes from its holdings in Google Sheets: ownership, cost basis, current carrying value, and any valuation change in the quarter.
What keeps an LP letter accurate
Every figure carries the date it was reported, not the date of the quarter it appears under. Founder updates arrive on their own schedules, and an update sent in the sixth week of a quarter contains numbers from the fifth. Presented under a quarter-end heading with no date attached, those become quarter-end numbers, and the letter drifts away from accuracy without anyone having decided anything. The date is a single extra field that keeps the whole document defensible.
Companies that did not report stay in the letter by name. The instinct is to carry last quarter's figures forward, because a gap looks like an omission and a number looks complete. But a company that stopped reporting is the one an LP most needs to hear about, and carrying its figures means it keeps appearing at a valuation nobody has revisited for a year.
Discrepancies are handed to a partner rather than resolved. A founder reporting strong growth against a carrying value the fund has not moved is either a stale valuation or an optimistic founder, and which one it is has consequences. A draft that averages the two, or silently prefers the fund's number, removes the question from view at the exact moment somebody should be asking it.
Fund-level numbers that reconcile
From the holdings, the run computes the fund-level position: total value, unrealised gains, realisations in the quarter, and remaining capital. It then checks that those totals equal the previous quarter plus this quarter's movements. When they do not, the letter reports the difference instead of a total, because a total that fails to reconcile is the one figure LPs will check first.
How the quarterly LP letter draft is built
The letter is written into Notion as a draft, in a set order: fund-level position, material changes this quarter, company-by-company notes, then realisations and outlook. Every figure carries its source and its reporting date. Companies with no update appear with their last reporting date and no old figures. No forward-looking claim about a company goes beyond what its founder stated, and anything a founder did state is attributed to them.
Before the letter, a partner gets a short work queue: the companies that did not report, the figures that disagree with fund records, and any fund-level total that failed to reconcile. That list is meant to be cleared before the letter goes out. The judgement about what the quarter means is left to the partners, which is the part LPs are actually paying for.
The prompt
The real prompt behind the steps above, detailed enough that an agent with the same tools can run it as written. The Run buttons copy the full version, which also carries the steps for connecting those tools.
# Draft the quarterly LP letter
You have access to email, a spreadsheet, and a documentation tool. Run
this at **[quarter end]**.
## 1. Gather each company's dated figures for the quarter
Search the mailbox for updates from each portfolio company covering
the quarter. Match on the company's domain rather than on a founder's
name, since founders change and forwarded updates arrive from
whichever partner received them.
For each company, extract what was reported and the date it was
reported: revenue, growth, runway in months, headcount, and any
financing event.
Record the reporting date alongside every figure. A revenue number
from an update sent six weeks into the quarter is not a quarter-end
number, and presenting it as one is the most common way these letters
become quietly wrong.
## 2. Name companies that did not report
List every portfolio company with no update this quarter, with the
date of their last one.
Do not fill the gap from the previous quarter's figures, and do not
drop them from the letter. Silently carrying a stale number forward is
how a company that stopped reporting six months ago keeps appearing at
a valuation nobody has checked. Non-reporting is itself information
and LPs are entitled to it.
## 3. Reconcile figures, flag disagreements
Pull the fund's holdings from the spreadsheet: ownership, cost basis,
current carrying value, and any valuation change in the quarter.
Cross-check every company's self-reported figures against what the
fund has recorded. Where they disagree, flag it rather than choosing
one. A founder reporting growth against a carrying value that has not
moved is a discrepancy a partner should resolve, not something a draft
should quietly average.
Compute the fund-level numbers: total value, unrealised gains,
realisations in the quarter, and remaining capital. Check they
reconcile with the previous quarter plus this quarter's movements. If
they do not, report the difference rather than the total.
## 4. Draft a letter with dated figures
Structure it: fund-level position, material changes this quarter,
company-by-company notes, then realisations and outlook.
Rules:
- Every figure carries its source and its reporting date.
- Companies with no update appear with their last reporting date, not
with old figures.
- Discrepancies between founder-reported and fund-recorded numbers are
listed for a partner, not resolved in the draft.
- No forward-looking claims about a company beyond what the founder
themselves stated, attributed to them.
Write it into the documentation tool as a draft. Partners add the
judgement, which is the part LPs are actually paying for.
## 5. Queue the exceptions for a partner
Produce a short list before the letter: companies that did not report,
figures that disagree with fund records, and any fund-level total that
failed to reconcile. That list is the partner's work queue and should
be dealt with before the letter goes out.
## Output
Report: companies with updates found, companies that did not report
and their last reporting date, figures whose reporting date falls
outside the quarter, discrepancies against fund records, whether the
fund-level numbers reconciled, and the draft's location.
Why run it with Tulina
A prompt helps one person. A process moves a team.
Pasted into a chat, the prompt above works once, for whoever pasted it. In Tulina, "Draft the quarterly LP letter" becomes a process the team shares, that keeps its history, runs on its own, and stays inside the same security perimeter as the tools it calls.
The whole team works on the same one
PersonalTeamOrganisation
A process lives where it belongs: yours, your team's or the whole organisation's. Whoever runs it can improve it, and everyone starts from the best version instead of explaining the job again.
Every edit is a version
v1v2v3
Each change is a new version with the previous one kept, so a bad edit is undone by restoring an earlier one. Every run records the version it followed, and what a run teaches goes back into the process.
It runs without you
schedulewebhookon demand
A hosted agent runs the process on Tulina's own infrastructure, on a schedule or when an event arrives, and keeps going when you close the chat. Nothing to host. Every run is tracked to its outcome.
Inside the same security perimeter
vaultrolesrun log
Credentials stay in the vault, never in the prompt. Roles decide who may run what, every call is logged, and a step a person has to approve waits for that person.
Questions about drafting LP letters with AI
Related processes
Processes that share tools with this one. The shared tools are lit.
Draft the monthly investor update
Revenue, pipeline, the plan's own targets, and last month's commitments are pulled together into a draft with the numbers already in it.
- Shares
- Google Sheets, Gmail
Monthly schedule5 steps →
Keep your knowledge base current
An AI knowledge base kept current each morning: yesterday's activity in your tools is read, stale pages are rewritten in place, and a missed day sends an alert.
- Shares
- Gmail, Notion
Daily schedule7 steps →
Chase failed direct debits
Each failed direct debit is matched to its invoice, skipped if paid, retrying or already chased, and given a reminder draft that fits why it failed.
- Shares
- Gmail
When you ask7 steps →