MetaProp Labs
Explore SkillsHow They WorkCustom AI Solutions
›Fund & Portfolio›Investor Relations›Distribution Notice Generator

Distribution Notice Generator

distribution-notice-generator

Generates individual LP distribution notices with per-investor share calculations, tax characterization, waterfall tier explanation, and batch processing for 50-200+ investors..

SKILL.md
Trigger
Trigger Info for the Agent
name: distribution-notice-generator
slug: distribution-notice-generator
version: 0.1.0
status: deployed
category: reit-cre
subcategory: investor-relations
description: >
  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.

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.

When to Activate

Explicit triggers: "distribution notice", "LP distribution", "investor notice", "distribution letter", "waterfall distribution", "preferred return distribution", "promote distribution", "return of capital distribution", "refi proceeds distribution", "sale proceeds distribution", "batch distribution", "distribution waterfall calculation", "pref accrual", "GP promote", "carried interest distribution", "K-1 preview", "capital account update"

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)
  • Ongoing quarterly financial reporting (use quarterly-reporting-package)
  • 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:

  1. 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."

  2. 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."

  3. 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."

  4. 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."

  5. 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."

  6. 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)
tax_characterization object yes {return_of_capital_pct, ordinary_income_pct, capital_gain_pct, section_1250_recapture_pct}
wire_date date yes Target date for LP wires
fund_name string yes Fund legal name for notice header
fund_manager string yes GP / manager name
contact_name string recommended LP relations contact for notice footer

Branching Logic

By Fund Structure

Single-asset syndication

  • 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)
  • Tier 2: preferred return (e.g., 8% cumulative)
  • Tier 3a: first promote tier (e.g., 15% IRR hurdle -> 70/30 LP/GP)
  • Tier 3b: second promote tier (e.g., 20% IRR hurdle -> 60/40 LP/GP)
  • Pref accrual calculation is complex; IRR hurdle requires time-weighted cash flow analysis
  • 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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.


Worked Example: 3-LP Fund, Sale Distribution

Transaction facts:

  • Fund: Riverside Industrial Fund II LP
  • Event: sale of 789 Warehouse Drive, Columbus, OH
  • Net sale proceeds: $3,250,000
  • LP table: 3 LPs (LP001: 15%, LP002: 2.5%, LP003: 8%), GP: 74.5% (co-invest 4.5% + promote tier)
  • Waterfall: 2-tier (8% pref, then 80/20 LP/GP promote)
  • Preferred return: 8% cumulative non-compounding
  • Total LP capital contributed: $1,625,000 (LP001: $375,000, LP002: $62,500, LP003: $200,000)
  • Outstanding pref balance (all LPs combined): $162,500
  • 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:

  1. Batch summary table (Workflow 4) -- all LPs with dollar amounts and wire details
  2. Individual LP notices (Workflow 3) -- one per LP, personalized and signature-ready
  3. GP summary report (Workflow 6) -- waterfall reconciliation, GP economics, clawback check
  4. Wire schedule (Workflow 5) -- wire-ready table with verification status
  5. Tax characterization table (Workflow 2) -- per-LP, flagged for counsel review

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).

Skill Files

SKILL.md
references
distribution-notice-templates.md
tax-characterization-guide.md
Download Skill

Category

Fund & Portfolio / Investor Relations

License

Apache-2.0

Source

mariourquia/cre-skills-plugin

Need Help?

Learn how to use this skill with your AI assistant.

Getting started guide →
© 2026 MetaProp Labs