How to Track Real Estate Syndication Distributions

How to track real estate syndication distributions is an ACH ledger, not a sponsor-portal screenshot. Each wire is a row: preferred return that accrued, cash that was return of capital versus income, leftover equity still in the deal. Commercial Real Estate Law Group (published January 30, 2025): a preferred return pays investors a specific return before profits go to the Manager. IRS Publication 541 (December 2025): a partnership distribution is not taken into account in determining your distributive share of partnership income or loss. Raziel’s understanding private real estate investing page is the vehicle. Raziel’s real estate investment tracker is one row per deal. This page is every ACH on one syndication.

This is not legal, tax, or investment advice. Raziel Holdings, Inc. does not provide it. Copy the signed operating agreement, not a market default.

Each ACH is a row, not a portal balance

Sponsor portals show year-to-date, then reset, or they vanish after a refinance. Your book should not. Skip capital-call mechanics. Those are cash out. This table is cash in. On every wire, write:

• Settlement date. The day the bank posted it, not the PDF date.

• Net amount. What landed, currency, and any withholding the notice shows.

• Sponsor label. Preferred return, return of capital, refinance, sale, or promote, copied from the notice.

• Unreturned capital after the post. Contributed equity minus cumulative waterfall return of capital.

• Unpaid preferred return after the post. Accrued under the operating agreement, whether this ACH paid it or not.

Do not overwrite last quarter’s row because the portal now shows a new year-to-date. The portal is a view. The rows are the book.

Accrue the preferred return the operating agreement wrote

Commercial Real Estate Law Group (Shams Merchant, published January 30, 2025, page modified August 9, 2026): Class A members receive a specific return before profits are distributed to the Manager. Store the type as a field. Cumulative: unpaid amounts accrue and are made up later, after Class A capital is repaid and before sharing with Class B. Noncumulative: shortfalls do not accumulate.

Investopedia (Akhilesh Ganti, updated July 18, 2026) describes a typical waterfall as sequential tiers: return of capital, preferred return (Investopedia’s usual range for this tier is approximately 7 percent to 9 percent), a catch-up tranche, then carried interest, a stated percentage of further distributions the sponsor receives. Syndications often call that extra sponsor share the promote. The 7 to 9 percent figure is Investopedia’s usual range, not your deal. Copy the rate, compounding, and whether pref is current-pay or accrued from the operating agreement you signed.

If the pref is cumulative, unpaid pref is a running balance in a quarter with no ACH. If it is noncumulative, a missed quarter is gone. The portal’s “preferred paid this year” is not that running balance. Commercial Real Estate Law Group’s 70/30 example is a straight split, a different structure with no preferred-return hurdle. Do not back into a promote from that example.

Split return of capital from income (twice)

The waterfall split and the tax split are not the same line. Investopedia’s first tier sends 100 percent of distributions to investors until they recover initial capital contributions, then preferred return. That is contractual. Keep it on the ACH row as the sponsor’s waterfall label.

The tax split is the K-1. The IRS 2025 Partner’s Instructions for Schedule K-1 (Form 1065): the partnership uses Schedule K-1 to report your share of income, deductions, credits, etc. You may be liable for tax on your share whether or not cash was distributed. Publication 541: a partner generally recognizes gain on a partnership distribution only to the extent money exceeds the adjusted basis of the partnership interest. Any such gain is generally capital gain from the sale of the partnership interest on the date of the distribution. Adjusted basis is decreased (but not below zero) by the money distributed.

The ACH is cash. Box 2 (net rental real estate income) and the other income boxes are allocations. They can arrive months later and in a different amount. The K-1 instructions are explicit that item L cannot be used to figure the partner’s adjusted basis, and that the partner has to track that basis. Do not treat the sponsor’s “income distribution” memo as the tax character. Attach the K-1 to the vehicle when it lands. Reconcile box 19 to the ACH rows. Leave the cash dates alone.

Leftover equity multiple after the wire

After return of capital, leftover equity is unreturned capital still sitting in the property. Equity multiple to date is cumulative distributions divided by capital you contributed. A refinance can make that multiple look finished while the GP still quotes a mark. Leftover is unreturned capital, remaining mark, and dated cash still to come. Which percentage to trust is a different page. This row is the leftover dollars. Raziel’s IRR calculator is dated cash-flow math. Feed it this vehicle, one syndication at a time.

Do not count return of capital as yield. Do not zero the position because a refinance returned contributed equity. Unreturned capital can be zero while you still have a residual profits interest the operating agreement has not paid. Store unreturned capital and remaining ownership separately so the leftover multiple has a denominator.

A workbook holds this if the links hold: each ACH dated, preferred return accrued whether paid or not, return of capital versus income labeled twice (waterfall and tax), leftover unreturned capital after the post. It fails when the portal year-to-date is the only record, when return of capital is booked as income yield, or when the K-1 is treated as the cash date.

Raziel’s real estate dashboard is the book those syndications already sit on: cash dates, documents, IRR and unrealized gains. Raziel does not issue the K-1s and does not give tax advice. When the next ACH lands, open a row. Leave last year’s portal screenshot alone.