How to Track Your Syndication Investments: A Simple Record System
On this page
To track your syndication investments, keep one spreadsheet with a row per deal, a log of every distribution, a folder per deal for documents and K-1s, and a yearly check of actual results against the projections you were shown. Each sponsor's investor portal shows only its own deals, so once you hold two or more, your own record is the one place that shows your whole private real estate portfolio, your cash returned and what your CPA needs.
This post is for investors who hold or plan to hold more than one syndication. It is general information, not tax or investment advice.
Why should a passive investor keep their own records?
Sponsors' portals differ, a sponsor can change software, and a deal can run seven years or more. Your own record lets you see total cash returned across deals, spot a deal that has gone quiet, answer your CPA's questions and help your family if something happens to you. It also makes it easier to judge a sponsor before you invest with them again. See how to read a quarterly report.
What goes in the deal list?
Use one row per deal with these columns:
- Deal name and property address
- Sponsor and sponsor contact
- Investing entity (you, a joint account, an LLC, a trust or an IRA) and the tax ID used
- Amount invested and date funded
- Class of interest and ownership percentage, from the closing documents; see the cap table
- Preferred return and profit split, from the operating agreement
- Planned hold period and planned exit
- Projected cash on cash, IRR and equity multiple, as shown at signing; see equity multiple, IRR and cash on cash
- Status: raising, operating, refinanced, sold
How do you log distributions?
Keep one log for all deals: date, deal, amount, how it arrived, and the label on the distribution notice. Mark which payments the sponsor calls a return of capital (for example, from a refinance) and which are cash flow, because that changes your capital account and what is left of your investment. Totals by deal and by year show which deals are on plan. For returns over time, see XIRR for syndication investors.
Which documents should you keep?
For each deal, keep a folder with the offering summary or PPM, the signed subscription agreement, the countersigned operating agreement, the closing confirmation, every investor update, every distribution notice, every K-1 and any capital account statement. Keep wire confirmations too. Store copies in a second place, since a portal login can lapse. See capital account statements.
What should you track for taxes?
K-1s for each deal, the state returns each K-1 may require, any passive losses carried forward and your basis. Your outside basis starts with what you invested and changes each year with income, losses and distributions. Your CPA tracks it, but your log makes the work faster and catches a missing K-1. See outside basis versus capital account and passive loss carryover.
How do you compare actual results with the plan?
Once a year, put the projections next to what happened: distributions received against the projected cash on cash, occupancy and rent growth against the business plan, and the renovation pace. One weak quarter is normal; a gap that grows each year without a clear explanation is a question to ask. See red flags in a syndication.
How DoorRaise fits in
On DoorRaise, an investor's signed documents, quarterly updates, distribution notices and K-1s for every DoorRaise deal live in one signed-in account, and quarterly distributions and updates are the default. Investors fund by wire into the deal's escrow account at Enterprise Bank & Trust. DoorRaise does not hold investor money or give investment advice.
FAQ
Is a spreadsheet enough?
For most investors, yes: a deal list, a distribution log and a folder per deal cover what you and your CPA need.
Should I track my basis myself?
Your CPA should own the number, but keeping K-1s and the distribution log in one place makes it easy.
What if a sponsor changes portals?
Download every document while you still have access and keep copies in your own folder.
How do I know a payment instruction change is real?
Call the sponsor at a number you already had, not one in the email. See wire fraud in syndications.
Sources
- IRS: About Schedule K-1 (Form 1065)
- IRS: Publication 541, Partnerships
- SEC Investor.gov: Private placements
This article is general information, not legal, tax or investment advice. Every investment can lose money, and distributions are not guaranteed. DoorRaise is not a law firm, broker-dealer, investment adviser or funding portal.