Affinity, Carta, and the ledger
A reference architecture for keeping investment records reconciled continuously — not once a quarter under deadline.
Three systems, three jobs
Affinity holds relationships and deal context. Carta holds positions and cap table truth for many funds. The ledger holds accounting reality.
Problems start when any one of them is treated as the only source of truth — or when reconciliation is postponed until LP week.
A clean Affinity pipeline with a broken position feed still produces a bad pack. A perfect Carta export pasted into an unversioned workbook still produces a bad pack.
Where breaks usually appear
Deal stage says closed; the ledger has not booked. Carta shows a distribution; bank activity has not cleared. LP capital accounts disagree with admin files by a few basis points that become a week of email.
None of these are exotic. They are normal. What is exotic is discovering them after the LP letter has already been drafted.
Reconciliation delayed is risk deferred — then concentrated into the worst week of the quarter.
A practical control model
Define which fields are authoritative in each system. Deal stage lives in Affinity. Position amounts live in Carta. Booked entries live in the GL.
Run a cadence reconciliation with an exception queue — not a heroic workbook every ninety days. Exceptions escalate to named owners with deadlines.
Feed approved outputs into LP packs and dashboards only after exceptions clear. “Provisional” packs should be labeled as such — or not sent.
Where automation helps
Automate matching and variance flags. Keep humans on judgment and exception resolution.
Document owners and cutoffs so the process survives staff turnover and audit questions. If the only person who understands the bridge workbook leaves, you do not have a process — you have a single point of failure.
Wire the handoff: Affinity context informs what should exist; Carta informs what positions are; the ledger confirms what was booked. Automation watches the seams.
Cadence over heroics
Weekly light reconciliations beat quarterly archaeology. Small breaks stay small.
Publish a calendar. Track open exceptions. Close them before freeze. That is the entire game.
Funds that do this stop treating LP week as a surprise. The surprise was always the break they postponed.
A reference checklist you can steal
Authoritative field map across Affinity, Carta, and GL. Written. Shared.
Matching rules and materiality thresholds for variances. Named owners for each exception type.
Freeze dates for positions and portfolio metrics before pack assembly.
Evidence pack: who approved what, against which source file, on which date.
If you cannot produce that checklist, start there — before you buy another dashboard.
Want this mapped to your fund?
Book a 45-minute Ops Review. We leave you with a written recommendation — whether or not you engage us.
Book an Ops Review
