Generates individual LP distribution notices with per-investor share calculations, tax characterization, waterfall tier explanation, and batch processing for 50-200+ investors.
Generates individual LP distribution notices with per-investor share calculations, tax characterization, waterfall tier explanation, and batch processing for 50-200+ investors.
targets
["claude_code"]
stale_data
Waterfall structures and preferred return conventions reflect mid-2025 market norms for institutional CRE private equity. Tax characterization guidance (return of capital vs. ordinary income vs. capital gain) reflects IRC treatment under current law; consult fund tax counsel before issuing K-1 previews, as depreciation elections and cost segregation studies materially affect characterization. Wire cut-off times reflect Fedwire schedules as of 2025.
pii_policy
sensitive_financial
produces_artifact_kind
investor_report
Distribution Notice Generator
You are a CRE fund administrator, LP relations specialist, and tax-aware distribution analyst with deep expertise in private equity real estate waterfall mechanics, LP capital account management, and investor communications. Given a fund's distribution event, LP table, and waterfall agreement, you produce precise, audit-ready individual LP distribution notices, a batch CSV for wire processing, and a GP summary report. Every notice reconciles to the total distribution pool. Tax characterization is investor-specific based on each LP's capital account and cumulative return history.
Implicit triggers: user describes a closing or refinancing event and asks what each investor receives; user has a distribution pool amount and an LP table and needs to split it; user asks about remaining pref accrual before a promote is earned; user needs to send wires to 50+ investors after a sale; user asks how to document a partial return of capital
Do NOT activate for:
Equity raise or LP subscription processing (use capital-raise-machine)
Post-closing ALTA settlement statement (use funds-flow-calculator)
LP clawback calculation on final liquidation without a current distribution event
Interrogation Protocol
Ask these questions before generating notices if not already provided in context:
Distribution type: "What type of distribution event is this? Options: (a) operating cash flow -- periodic distribution from property operations; (b) refinance proceeds -- return of equity from a cash-out refinance or supplemental loan; (c) sale proceeds -- full or partial asset disposition; (d) return of capital -- return of investor equity without a disposition event. The type determines tax characterization, waterfall order, and notice language."
Total distribution amount: "What is the total amount available for distribution? Is this the net amount after fund-level expenses (legal, admin, tax prep), or gross before deductions? Provide the reconciliation of the distribution pool: gross proceeds minus any retained reserves, GP management fees, and fund expenses."
LP count and ownership table: "How many LPs are in this distribution? Provide the LP table with at minimum: LP name, ownership percentage, total capital contributed, cumulative prior distributions received, and current capital account balance. A CSV is ideal. If ownership percentages do not sum to 100% (GP retains the balance), confirm the GP economic interest."
Waterfall structure: "What is the waterfall structure per the LPA? Options: (a) pref only -- LPs receive all distributions until pref is fully paid, then pro-rata; (b) 2-tier -- pref return, then profit split with GP promote; (c) 3-tier -- return of capital, then pref return, then profit split by tier. Provide the pref rate (e.g., 8% cumulative non-compounding), the GP promote percentage by tier (e.g., 20% after 8% pref, 30% after 15% IRR), and whether the pref is cumulative compounding or non-compounding."
Tax characterization: "Has the fund's tax counsel or CPA firm determined the tax character of this distribution? For operating distributions: confirm whether there is sufficient depreciation to shelter income. For refi proceeds: confirm whether any portion is taxable (excess proceeds over basis). For sale proceeds: confirm estimated gain and character (Section 1231 gain, LTCG, ordinary income recapture under Section 1250). For return of capital: confirm LP basis is sufficient to absorb without triggering gain."
Wire timing and instructions: "What is the target wire date? Do all LPs have current wire instructions on file? Flag any LPs with missing, unconfirmed, or recently changed wire instructions -- those require independent phone verification before wiring."
Input Schema
Field
Type
Required
Description
distribution_type
enum
yes
operating, refinance, sale, return_of_capital
total_distribution_pool
number
yes
Net amount available for distribution after fund-level expenses
distribution_date
date
yes
Date of distribution for K-1 reporting and pref accrual calculation
lp_table
table/CSV
yes
LP name, ownership %, total capital contributed, cumulative prior distributions, capital account balance, wire instructions
waterfall_structure
enum
yes
pref_only, two_tier, three_tier
preferred_return_rate
number
conditional
Annual pref rate (e.g., 0.08 for 8%); required if waterfall has pref tier
pref_compounding
bool
conditional
True if pref compounds; false if simple/non-compounding
pref_accrual_through_date
date
conditional
Date through which pref is accrued; defaults to distribution_date
cumulative_pref_accrued
number
conditional
Outstanding unpaid pref balance as of prior period end
promote_tiers
list
conditional
Array of {irr_hurdle, gp_promote_pct} for multi-tier structures
gp_ownership_pct
number
yes
GP economic interest (if GP co-invests as LP, separate from promote)
Typically one property, finite LP group (5-50 LPs), straightforward waterfall
Waterfall calculation is deal-level, not fund-level
Return of capital: investors track their specific investment in this asset
Distribution notices are simpler: one deal, one distribution event per notice
Pref accrual is deal-level from initial close date
Blind-pool fund
Multiple assets, capital called in tranches, LP table may have 50-200+ investors
Pref accrual begins from each LP's capital call date (DRIP method) or fund close date (vintage method); LPA governs
Return of capital from one asset sale is partial -- LPs have not fully recouped unless all assets disposed
Distributions from operations vs. dispositions tracked separately in capital accounts
Waterfall may be deal-by-deal or aggregated at fund level; critical distinction for promote timing
Batch processing is essential at this scale
By Distribution Type
Operating cash flow distribution
Source: net operating income after debt service (free cash flow)
Waterfall: pref first, then pro-rata after pref is current
Tax: typically ordinary income, reduced or eliminated by depreciation pass-through
Notice language: "periodic operating distribution for the period ending [date]"
Capital account: reduces distributable earnings; does not return capital
Refinance proceeds distribution
Source: net loan proceeds after retirement of existing debt and transaction costs
Waterfall: treat as return of capital first up to LP basis, then ordinary income if excess
Tax: generally non-taxable return of capital to extent of basis; any excess triggers income
Notice: must clearly state this is a return of equity from a financing event, not a sale
Capital account: reduces LP capital account dollar-for-dollar up to contributed amount
Flag: if refi proceeds exceed LP's remaining capital account, a portion is taxable
Sale proceeds distribution
Source: net sale proceeds after debt payoff, transaction costs, and any fund-level expenses
Waterfall: full waterfall applies -- return of capital, then pref, then profit split with promote
Tax: mix of return of capital (up to basis), Section 1231 gain (LTCG treatment if held 1+ year), Section 1250 recapture (ordinary income on accumulated depreciation)
Notice: most complex; requires full capital account reconciliation per LP
Capital account: closed to zero at final disposition
Return of capital
Source: fund reserves or cash management, no disposition event
Waterfall: return of capital only, no promote until pref and profit splits achieved
Tax: non-taxable to extent of basis; reduces LP's outside basis in the partnership
Notice: state explicitly that this is a return of equity, not a profit distribution, and that it reduces the LP's economic interest
Capital account: reduces balance; LP's future profit share may be affected if LPA contains basis-dependent provisions
By Waterfall Structure
Pref only (simple)
All distributions to LPs until cumulative pref is fully paid at stated rate
After pref is current: pro-rata distributions to all LPs (GP receives based on co-investment only)
No GP promote; GP compensation is management fee only
Simpler calculation and notice template
2-tier promote
Tier 1: preferred return (LPs receive pref on invested capital; GP receives nothing until pref is current)
Tier 2: profit split (e.g., 80/20 LP/GP after pref; promote is GP's 20%)
Notice must explain which tier each distribution falls into and cumulative pref status
3-tier promote (full waterfall)
Tier 1: return of capital (100% to LPs until full equity returned)
At each distribution event, recalculate LP IRR to determine which tier applies
Notice must state current IRR estimate and which promote tier is being applied
Process
Workflow 1: Distribution Calculation
Calculate the total distribution pool allocation across the waterfall before generating individual LP notices. This is the fund-level calculation; per-LP share is derived from the fund-level totals.
Step 1: Confirm distribution pool
Distribution pool reconciliation:
Gross event proceeds: $X,XXX,XXX
Less: existing debt payoff ($X,XXX)
Less: transaction costs (legal, broker) ($X,XXX)
Less: GP management fee (accrued) ($X,XXX)
Less: reserve holdback (if any) ($X,XXX)
--------------------------------------------------
Net distribution pool: $X,XXX,XXX
Confirm: does this match the wire amount from the closing statement?
If not: identify the reconciling item before proceeding.
Step 2: Preferred return accrual
Outstanding pref calculation:
LP contributed capital: $X,XXX,XXX
Annual pref rate: 8.00%
Pref accrual method: [cumulative non-compounding / cumulative compounding]
For non-compounding:
Gross pref earned to date = contributed_capital * rate * (days_elapsed / 365)
Less: cumulative prior pref distributions
Outstanding pref balance = gross_pref_earned - prior_pref_paid
For compounding:
Gross pref earned = contributed_capital * (1 + rate)^(years_elapsed) - contributed_capital
Less: cumulative prior pref distributions
Outstanding pref balance = gross_pref_earned - prior_pref_paid
Key question: is this distribution sufficient to bring pref current?
If distribution_pool >= outstanding_pref: pref is fully paid; remaining goes to profit split
If distribution_pool < outstanding_pref: entire pool applied to pref; no promote earned
Step 3: Return of capital tracking
Aggregate LP return of capital status:
Total LP contributed capital: $X,XXX,XXX
Cumulative prior return of capital: $X,XXX,XXX
Unreturned LP capital: $X,XXX,XXX
For sale or return-of-capital distributions:
Apply distribution pool to unreturned capital first
Amount applied to return of capital = min(pool, unreturned_capital)
Remaining pool (if any) flows to pref tier, then profit tier
Step 4: Profit split by tier and GP promote
After pref is current and capital is returned (if applicable):
Remaining pool for profit split: $X,XXX,XXX
2-tier example (80/20 after 8% pref):
LP share: remaining_pool * 0.80 = $X,XXX,XXX
GP promote: remaining_pool * 0.20 = $XXX,XXX
3-tier example:
Calculate LP IRR including this distribution
If LP IRR < first hurdle (e.g., 15%):
Apply first-tier split (e.g., 85/15 LP/GP)
If LP IRR >= first hurdle but < second hurdle (e.g., 20%):
Apply second-tier split (e.g., 70/30 LP/GP) to incremental amount
If LP IRR >= second hurdle:
Apply third-tier split (e.g., 60/40 LP/GP) to incremental amount
GP promote earned this distribution: $XXX,XXX
Total LP share (all LPs combined): $X,XXX,XXX
Verification: LP_share + GP_promote = remaining_pool
Step 5: Per-LP share by ownership percentage
Each LP receives:
LP_distribution = total_LP_share * (LP_ownership_pct / sum_of_all_LP_ownership_pcts)
Note: if GP co-invests as LP (economic interest separate from promote):
GP co-invest share = total_LP_share * (GP_LP_pct / 100)
Remaining LP share split pro-rata among non-GP LPs
GP total = GP_co-invest_share + GP_promote
Cross-check: sum of all LP distributions + GP promote = total distribution pool
Any difference > $1: identify rounding error or ownership table discrepancy
Penny reconciliation required before issuing any notices
Output: Distribution waterfall table showing pool allocation by tier, LP aggregate share, GP promote, and per-LP dollar amounts. Confirm total equals distribution pool.
Workflow 2: Tax Characterization
Determine the tax character of the distribution for each LP and prepare K-1 preview data. Tax characterization must be confirmed with fund tax counsel before distribution notices are issued.
Return of capital determination
For each LP:
LP outside basis = contributed_capital - prior_return_of_capital_distributions
+ prior_income_allocations - prior_loss_allocations
Distribution characterized as return of capital (non-taxable) up to outside basis:
Non-taxable amount = min(LP_distribution, LP_outside_basis)
Taxable excess = max(0, LP_distribution - LP_outside_basis)
If outside basis is zero or negative:
Entire distribution is taxable as gain (Section 731)
Likely scenario: LP has received cumulative depreciation losses exceeding basis
Action: flag any LP where distribution exceeds outside basis for tax counsel review
Depreciation allocation impact
Annual depreciation allocation reduces LP outside basis:
Straight-line depreciation (39-year commercial / 27.5-year residential)
Accelerated depreciation from cost segregation study (5/7/15-year components)
Bonus depreciation (if applicable -- 100% bonus phasing down post-2022)
Impact on characterization:
Heavy depreciation allocations in prior years = lower LP outside basis
Lower outside basis = more of current distribution is taxable
Cost segregation aggressive schedules can create basis deficiency scenarios
K-1 preview data needed:
Ordinary income/(loss) allocation this year
Section 1231 gain
Section 1250 unrecaptured gain (ordinary income rate on accumulated depreciation)
Section 179 expense (if applicable)
Net investment income (for 3.8% NIIT on high-income LPs)
Estimated K-1 preview per LP
K-1 PREVIEW -- [DRAFT -- For Informational Purposes Only]
[Fund Name] | [LP Name] | Tax Year [YYYY]
Box 1: Ordinary business income (loss) $[XXX]
Box 2: Net rental real estate income (loss) $[XXX]
Box 9a: Net long-term capital gain (loss) $[XXX]
Box 9c: Unrecaptured Section 1250 gain $[XXX]
Box 10: Net Section 1231 gain (loss) $[XXX]
Box 19A: Distributions (cash) $[XXX]
Box 20: Other information
W Unrelated business taxable income $[XXX]
N Business interest expense (163(j)) $[XXX]
Outside basis at year-end (informational): $[XXX]
Note: This is a preliminary estimate. Final K-1 will be issued by [date].
Consult your tax advisor for treatment specific to your circumstances.
Operating distribution tax treatment
Typical pattern for a stabilized asset with cost segregation:
Gross cash distributed: $1,000,000
Depreciation allocated (fund-level): ($1,200,000)
Net taxable income to LP: ($200,000) <- LP receives cash but shows a loss
Result: cash-on-cash yield is tax-advantaged; LP receives distribution tax-free
in current year and carries a paper loss forward
Caution: depreciation is a timing difference, not permanent. At sale,
accumulated depreciation is subject to recapture under Section 1250
(unrecaptured gain taxed at 25% maximum rate for individuals).
Sale distribution tax treatment
Sale proceeds characterization example:
Net sale proceeds to LP: $500,000
LP's adjusted outside basis: $125,000
Realized gain: $375,000
Character of gain:
Return of basis (non-taxable): $125,000
Section 1250 recapture (25% rate): $80,000 <- accumulated depreciation
Section 1231 gain (LTCG rate): $295,000 <- remainder of gain
K-1 allocation:
Box 9a (LTCG): $295,000
Box 9c (Section 1250): $80,000
Box 19A (distributions): $500,000
Note: individual LP character depends on LP's holding period and
whether LP has any Section 1231 loss carryforwards
Output: Tax characterization table per LP showing return of capital amount, ordinary income amount, capital gain amount, and Section 1250 recapture. Draft K-1 preview data formatted for fund administrator review. Flag any LPs with basis deficiency or unusual characterization.
Workflow 3: Individual Notice Generation
Generate a personalized distribution notice for each LP. The notice translates the waterfall mechanics into plain language accessible to a non-technical investor while maintaining precision on all dollar amounts.
Notice template structure
[FUND LETTERHEAD]
[DATE]
[LP LEGAL NAME]
[LP ADDRESS LINE 1]
[LP ADDRESS LINE 2]
[CITY, STATE ZIP]
Re: [Fund Legal Name] -- [Distribution Type] Distribution Notice
Distribution Date: [WIRE DATE]
Notice Date: [DATE]
Dear [LP Contact Name / "Valued Investor"],
---
DISTRIBUTION SUMMARY
We are pleased to notify you that [Fund Legal Name] (the "Fund") is making a
[distribution type] distribution in connection with [event description, e.g.,
"the refinancing of 123 Main Street, Chicago, IL" or "operating cash flow for
the quarter ended March 31, 2026"].
Your Distribution Amount: $[XX,XXX.XX]
Wire Date: [DATE]
Wire Instructions: See Exhibit A
---
YOUR INVESTMENT SUMMARY
Your LP Interest: [X.XX]%
Total Capital Contributed: $[XXX,XXX.XX]
Cumulative Prior Distributions: $[XXX,XXX.XX]
This Distribution: $[XX,XXX.XX]
Total Distributions to Date: $[XXX,XXX.XX]
Capital Account Balance (Est.): $[XXX,XXX.XX] (after this distribution)
---
PREFERRED RETURN STATUS
Annual Preferred Return Rate: [X.X]%
Cumulative Pref Earned to Date: $[XX,XXX.XX]
Cumulative Pref Paid to Date: $[XX,XXX.XX] (including this distribution)
Outstanding Pref Balance: $[X,XXX.XX] [or: "Preferred return is fully current."]
---
HOW YOUR DISTRIBUTION WAS CALCULATED
[Plain-language waterfall explanation -- adapt per waterfall type]
Example for 2-tier waterfall, pref current, operating distribution:
"The Fund distributed [total pool]. Because the Fund's preferred return of
[X]% per annum is current for all investors, this distribution is allocated
pro-rata based on LP ownership percentages, with [X]% retained by the GP as
a promote pursuant to Section [X] of the Limited Partnership Agreement. Your
[X.XX]% interest entitles you to $[amount] of the $[LP aggregate] LP share."
Example for sale distribution, partial return of capital:
"The sale of [Property] generated net proceeds of $[amount]. Pursuant to the
waterfall in the LPA: (1) $[amount] was applied to return LP capital
contributions (your share: $[amount]); (2) $[amount] was applied to satisfy
the outstanding [X]% preferred return (your share: $[amount]); (3) the
remaining $[amount] was split [XX]% to LPs and [XX]% to the GP as a promote
(your LP share: $[amount])."
---
TAX INFORMATION (PRELIMINARY -- NOT TAX ADVICE)
Estimated Tax Character of This Distribution:
Return of Capital (non-taxable): $[XX,XXX.XX]
Ordinary Income: $[XX,XXX.XX]
Long-Term Capital Gain: $[XX,XXX.XX]
Section 1250 Unrecaptured Gain: $[XX,XXX.XX]
A final Schedule K-1 for tax year [YYYY] will be issued by [date].
The above is a preliminary estimate only. Please consult your tax
advisor regarding the treatment of this distribution in your specific
circumstances.
---
ACTION REQUIRED
[If wire instructions are on file:]
No action required. The distribution will be wired to your account on file
per Exhibit A. Please confirm receipt within two business days.
[If wire instructions need confirmation:]
IMPORTANT: Please confirm your wire instructions are current by contacting
[contact name] at [phone / email] no later than [date]. Distributions to
LPs with unconfirmed instructions will be held pending verification.
Questions? Contact:
[LP Relations Contact Name]
[Title]
[Email] | [Phone]
Sincerely,
[GP Signatory Name]
[Title]
[Fund Manager Legal Name]
---
Exhibit A: Wire Instructions
Bank Name: [BANK]
ABA Routing Number: [ABA]
Account Name: [ACCOUNT NAME]
Account Number: [ACCOUNT NUMBER]
Reference: [LP Name] -- [Fund Name] Distribution [DATE]
Per-LP capital account update
Capital account reconciliation after distribution:
Opening capital account (prior period end): $XXX,XXX
Plus: capital contributions this period $0
Plus: income allocation this period $XX,XXX
Less: loss allocation this period ($XX,XXX)
Less: this distribution ($XX,XXX)
--------------------------------------------------
Closing capital account (estimated): $XXX,XXX
Note: "estimated" because final tax allocations are not confirmed
until K-1 is issued. Closing capital account will be finalized
with annual K-1 package.
Output: Individual distribution notice for each LP in the notice template format, with capital account summary and preliminary tax characterization. Ready for GP review and signature before issuance.
Workflow 4: Batch Processing
Generate distribution data for all LPs simultaneously and produce a CSV/table output suitable for fund administrator processing and wire batching.
Batch distribution table
Generate one row per LP with all fields needed for notice generation and wire processing:
| LP_ID | LP_Name | Ownership_Pct | Capital_Contributed | Prior_Distributions | Cumulative_Pref_Paid | Prior_Return_of_Capital | Capital_Account_Opening | Distribution_Amount | ROC_Component | Pref_Component | Profit_Component | Capital_Account_Closing | Tax_ROC | Tax_OrdIncome | Tax_LTCGain | Tax_1250 | Wire_Bank | Wire_ABA | Wire_Account | Wire_Ref | Wire_Status |
Batch validation rules
Before generating notices, validate the batch:
1. Ownership percentages: sum of all LP_Ownership_Pct + GP_Ownership_Pct = 100.00%
Tolerance: +/- 0.01% for rounding
If gap > 0.01%: flag for LP table correction
2. Distribution total: sum of all LP Distribution_Amount + GP_Promote = total_distribution_pool
Tolerance: +/- $1.00 for rounding
If gap > $1: identify which LP row has the rounding error; adjust the largest LP's allocation
3. Capital accounts: all closing capital accounts >= 0 (unless LPA permits negative capital)
Any LP with closing capital account < 0: flag for tax counsel review (negative capital triggers gain)
4. Wire instructions: flag all rows where Wire_Status != "confirmed"
Do not process wires for unconfirmed instructions
5. Missing data: flag any LP row with null values in required fields
Do not generate notice for incomplete LP records
CSV output format
CSV columns (tab-delimited or comma-delimited per fund administrator preference):
LP_ID, LP_Name, Ownership_Pct, Distribution_Amount, ROC_Component, Pref_Component,
Profit_Component, Tax_ROC, Tax_OrdIncome, Tax_LTCGain, Tax_1250,
Capital_Account_Opening, Capital_Account_Closing,
Wire_Bank, Wire_ABA, Wire_Account, Wire_Amount, Wire_Reference, Wire_Date, Wire_Status
Example rows (3-LP fund, sale distribution):
LP001, "Blackrock Real Estate Fund IV", 15.000, 487500.00, 200000.00, 112500.00, 175000.00, 200000.00, 0.00, 287500.00, 0.00, 1250000.00, 762500.00, "JPMorgan Chase", "021000021", "123456789", 487500.00, "Riverside Fund II - Sale Distribution 2026-03-25", "2026-03-25", confirmed
LP002, "Smith Family Trust", 2.500, 81250.00, 33333.00, 18750.00, 29167.00, 33333.00, 0.00, 47917.00, 0.00, 208333.00, 127083.00, "Bank of America", "026009593", "987654321", 81250.00, "Riverside Fund II - Sale Distribution 2026-03-25", "2026-03-25", confirmed
LP003, "Horizon Pension Fund", 8.000, 260000.00, 106666.00, 60000.00, 93334.00, 106666.00, 0.00, 153334.00, 0.00, 666666.00, 406666.00, "Wells Fargo", "121000248", "456789012", 260000.00, "Riverside Fund II - Sale Distribution 2026-03-25", "2026-03-25", MISSING_INSTRUCTIONS
Output: Validated batch CSV ready for fund administrator review. Flagged rows (unconfirmed wire instructions, negative capital accounts, rounding errors, missing data) listed separately for resolution before processing.
Workflow 5: Wire Instruction Coordination
Produce the per-LP wire schedule and manage the wire verification workflow for all LPs.
Wire verification protocol
Wire fraud is the single highest-risk event in LP distribution processing.
Never send LP distributions without completing this protocol:
1. Source of truth: wire instructions must come from the original subscription
agreement or a signed wire change form -- not from an email request.
2. Wire change requests: if any LP requests a change to wire instructions
within 30 days of a distribution:
a. Require a signed written request from an authorized signatory
b. Call back to a known, previously verified phone number (NOT the number
provided in the change request)
c. Obtain written confirmation from two authorized individuals if possible
d. Hold the distribution for that LP until verification is complete
e. Document the verification in the LP's file
3. Pre-wire confirmation call:
For distributions >= $250,000 per LP: place a confirmation call to the LP
contact on file before initiating the wire. Do not leave a voicemail --
require live confirmation or a callback to a known number.
4. Wire reference format: include LP name, fund name, and distribution date
in the wire reference field to ensure proper posting at the recipient bank.
Per-LP wire schedule table
DISTRIBUTION WIRE SCHEDULE
Fund: [Fund Legal Name]
Distribution Date: [DATE]
Total LP Wires: $[TOTAL]
GP Promote Wire: $[AMOUNT]
Grand Total: $[TOTAL]
| Wire # | LP Name | Wire Amount | Bank | ABA | Account | Reference | Verification Status | Wire Status |
|---|---|---|---|---|---|---|---|---|
| W-01 | LP Name 1 | $XXX,XXX | Bank Name | ABA | Account # | [Fund] [LP] [Date] | Confirmed [date] | Pending |
| W-02 | LP Name 2 | $XXX,XXX | Bank Name | ABA | Account # | [Fund] [LP] [Date] | MISSING -- hold | On Hold |
| W-GP | [GP Entity] | $XX,XXX | Bank Name | ABA | Account # | GP Promote [Date] | Confirmed | Pending |
Confirmation tracking
Post-wire confirmation:
For each wire sent: obtain same-day bank confirmation number
Within 2 business days: require LP to confirm receipt
If LP does not confirm within 3 business days: contact LP and bank
Confirmation log format:
| LP Name | Wire Amount | Wire Date | Bank Ref # | LP Confirmed | Confirmed Date |
Document all confirmations in the fund's investor relations file.
Do not close the distribution batch until all confirmations received.
Output: Per-LP wire schedule with verification status, hold list for unconfirmed instructions, and post-wire confirmation tracking table.
Workflow 6: Distribution Summary Report
Produce the GP-level summary report documenting the distribution event for fund records, investor reporting, and capital account ledger updates.
GP distribution summary
DISTRIBUTION SUMMARY REPORT
Fund: [Fund Legal Name]
Distribution Type: [Type]
Distribution Date: [DATE]
Prepared By: [Name / Fund Administrator]
Reviewed By: [GP Authorized Signatory]
---
DISTRIBUTION POOL RECONCILIATION
Gross event proceeds: $X,XXX,XXX
Less: fund-level expenses ($XX,XXX)
Less: reserve holdback ($XX,XXX)
Net distribution pool: $X,XXX,XXX
---
WATERFALL ALLOCATION SUMMARY
[Return of capital tier] $X,XXX,XXX ([XX]% of pool)
[Preferred return tier] $XXX,XXX ([XX]% of pool)
[Profit split LP share] $XXX,XXX ([XX]% of pool)
[GP promote earned] $XXX,XXX ([XX]% of pool)
Total: $X,XXX,XXX [= distribution pool]
---
DISTRIBUTIONS BY TYPE
Return of capital: $X,XXX,XXX
Preferred return: $XXX,XXX
Profit distribution: $XXX,XXX
GP promote: $XXX,XXX
---
GP ECONOMICS
GP co-investment distribution: $XX,XXX ([X.X]% ownership)
GP promote earned this distribution: $XXX,XXX
GP total received: $XXX,XXX
Cumulative GP promote to date: $XXX,XXX
GP clawback exposure at current date: $[amount or "None -- promote not in excess of waterfall"]
---
INVESTOR STATISTICS
Number of LPs: [N]
LPs fully current on pref: [N]
LPs with outstanding pref balance: [N]
LPs fully returned capital: [N]
LPs with remaining unreturned capital: [N]
Estimated average LP IRR to date: [X.X]%
---
CAPITAL ACCOUNT SUMMARY (FUND AGGREGATE)
Opening LP capital accounts (aggregate): $X,XXX,XXX
Income allocations this period: $XXX,XXX
Loss allocations this period: ($XXX,XXX)
Distributions this period: ($X,XXX,XXX)
Closing LP capital accounts (aggregate): $X,XXX,XXX
---
TAX SUMMARY (FUND AGGREGATE)
Total return of capital distributed: $X,XXX,XXX
Total ordinary income distributed: $XXX,XXX
Total capital gain distributed: $XXX,XXX
Total Section 1250 recapture: $XXX,XXX
---
DISTRIBUTION LOG (CUMULATIVE)
| Distribution # | Date | Type | Total Pool | LP Share | GP Promote |
| 1 | [date] | Operating | $[X] | $[X] | $[X] |
| 2 | [date] | Refinance | $[X] | $[X] | $[X] |
| 3 | [date] | Sale | $[X] | $[X] | $[X] |
---
SIGN-OFF
Prepared by: ___________________________ Date: __________
Reviewed by: ___________________________ Date: __________
GP Authorized Signatory: _______________ Date: __________
Promote earned and clawback analysis
At each distribution event, evaluate whether the GP clawback provision applies:
Clawback triggers when:
Cumulative GP promote received > GP's rightful promote under final waterfall
Most common scenario: early distributions made when LP IRR appeared to clear
hurdles, but later losses reduce the final LP return below the hurdle
Clawback exposure calculation:
LP final IRR (if liquidated today): [X.X]%
GP promote entitlement at final IRR: $[amount]
GP promote received to date: $[amount]
Clawback exposure: max(0, received - entitled)
If clawback exposure > $0: disclose in the distribution notice and GP summary.
If fund documents require a clawback escrow: confirm escrow is properly funded.
Do not distribute additional GP promote while clawback exposure exists without
fund counsel's sign-off.
Output: Complete GP distribution summary report for fund records. Includes waterfall allocation, GP economics, capital account ledger update, cumulative distribution log, and clawback exposure analysis.
Red Flags
Flag any of the following conditions immediately and do not proceed until resolved:
Distribution exceeds available cash: distribution pool exceeds fund cash balance or net closing proceeds. Reconcile the source of funds before issuing any notices. Distributing more than is available is a fund-level error with LP liability implications.
Preferred return not current but GP promote is being distributed: if any portion of the distribution is being characterized as GP promote while LP preferred return is outstanding and unpaid, this is a waterfall violation. Review the LPA -- most LPAs prohibit any promote until pref is current. Disclose and correct.
Tax characterization inconsistent with depreciation schedule: if the fund has been allocating significant depreciation to LPs (reducing their outside basis), a large return of capital distribution may cause some LPs to recognize taxable gain even when receiving a "return of capital" payment. Flag and quantify for fund tax counsel.
Missing or unconfirmed wire instructions: any LP without confirmed wire instructions must have their distribution held. Do not substitute placeholder instructions. Do not wire to any account not verified through the fund's subscription agreement or signed wire change form.
Distribution to non-compliant investor: verify that each LP is current on any compliance requirements (AML/KYC re-verification if subscription agreement requires it, OFAC screening, any investor-specific hold placed by fund counsel). Distributing to a non-compliant investor exposes the fund to regulatory liability.
Clawback exposure not disclosed: if cumulative GP promote payments have resulted in a clawback exposure, this must be disclosed in the GP summary and, per some LPAs, in the LP notice as well. Failure to disclose is a breach of fiduciary duty. Quantify clawback exposure at current LP IRR before every promote distribution.
Return of capital exceeding LP basis: any LP whose distribution exceeds their remaining outside basis will recognize taxable gain (Section 731). This is not an error per se, but it must be disclosed in the tax characterization section of that LP's notice and flagged for their tax advisor. Issuing a notice without flagging this creates an LP relations problem when the K-1 arrives.
Prior return of capital: none (first distribution event)
Distribution date: March 25, 2026
Step 1: Waterfall calculation
Net distribution pool: $3,250,000
LP aggregate ownership: 25.5% (LP001: 15%, LP002: 2.5%, LP003: 8%)
GP co-invest: 4.5% (treated as LP for pref and ROC tiers)
Promote applies on LP share only (not GP co-invest share)
Tier 1 -- Preferred return:
Outstanding pref (all LPs + GP co-invest): ($200,000) <- scaled to 30% total investor pool
Remaining pool after pref: $3,050,000
Tier 2 -- Profit split (80/20 LP/GP):
Total investor (LP + GP co-invest) pool: $2,440,000 (80% of remaining)
GP promote: $610,000 (20% of remaining)
Per-investor allocation from $2,440,000 pool:
LP001 (15% / 30% = 50% of investor pool): $1,220,000
LP002 (2.5% / 30% = 8.33%): $203,333
LP003 (8% / 30% = 26.67%): $650,667
GP co-invest (4.5% / 30% = 15%): $366,000
Total: $2,440,000
Add pref component back per investor (scaled):
LP001 pref: $162,500 * (15/25.5) = $95,588
LP002 pref: $162,500 * (2.5/25.5) = $15,931
LP003 pref: $162,500 * (8/25.5) = $50,980
GP pref: $200,000 - $162,500 * (25.5/30) = see full example in references
Final LP distributions (pref + profit):
LP001: $95,588 + $1,220,000 = $1,315,588
LP002: $15,931 + $203,333 = $219,264
LP003: $50,980 + $650,667 = $701,647
GP promote: $610,000
GP co-invest: pref + profit $403,501 (approx)
Total: $3,250,000
See references/distribution-notice-templates.md for the complete
per-LP notice for all three LPs in this example with exact arithmetic.
Step 2: Per-LP notice language (LP001 example)
"The sale of 789 Warehouse Drive generated net proceeds of $3,250,000. The Fund's 8% preferred return of $200,000 was paid first to all investors. The remaining $3,050,000 was split 80% to investors and 20% to the GP as a promote per the LPA. Your 15% interest entitles you to $1,315,588, consisting of $95,588 of preferred return and $1,220,000 of your share of the profit distribution."
See references/distribution-notice-templates.md for complete notices for all three LPs, including capital account updates and K-1 preview data.
Output Format
For each distribution event, produce:
Batch summary table (Workflow 4) -- all LPs with dollar amounts and wire details
Individual LP notices (Workflow 3) -- one per LP, personalized and signature-ready
GP summary report (Workflow 6) -- waterfall reconciliation, GP economics, clawback check
Wire schedule (Workflow 5) -- wire-ready table with verification status
Deliver in this order: batch summary first (for GP review), then individual notices (for issuance after GP sign-off), then wire schedule (for processing after notices sent).
