How do you track K-1 income across multiple sources? (beyond handing to CPA)

Question

Curious how other LPs here manage their K-1s.

I'm invested in a handful of real estate syndications. I'm mostly just adding them into my tax prep software and moving on. I imagine a lot of others are doing the same or just passing them on to their CPA. Now that tax season is over, I've started wondering whether I'm leaving insight on the table. I'm wondering if I should be tracking things like cumulative taxable income across deals and by year, understanding how my distributions compare to what's actually flowing through on the K-1, how my money is actually performing and comparing it to other opportunities, those kinds of things.

For those of you who are more active about it: what does your process look like? How are you using the information in your K-1? Do you pull the numbers into a spreadsheet yourself? Use any software? Or is "give it to the CPA and trust the return" basically the move? If that's the move, is your CPA providing insights?

Jose Ortiz · Answer

John ...

A lot of people do exactly what you described -  plug the K-1 into software (or send it to their CPA) and move on. That works for filing, but yeah… you are definetely leaving some insight on the table.

I don't suggest getting too complicated, but having a simple tracker for each deal makes a big difference over time. Something as basic as a spreadsheet where you track the following items, by year:

1. K-1 income/loss

2. Distributions you actually received

3. Ending capital account

4. Any suspended losses

Once you have that in one place, a few things should start to click:

1. You can clearly see the gap between taxable income vs. actual cash flow (this confuses a lot of people in syndications)

2. You start noticing which deals are actually performing vs. just generating paper losses

3. You build a running total of suspended losses, which can become valuable later when deals sell or if you have passive income to offset

Over a couple years, it turns into a pretty solid dashboard for your portfolio without needing any fancy software.

As for the CPA side...most are going to handle the reporting correctly, but they’re usually not aggregating across all your deals or analyzing performance unless that’s specifically part of the engagement.

So yes, “give it to the CPA” works for compliance. But if you want to understand how your investments are really doing and make better decisions going forward, a simple tracker is probably the easiest upgrade you can make.

I hope this helps.

Ashish Acharya · Answer

Most investors start the way you described, just handing K-1s to the CPA, but you’re right that there’s a lot of insight you can miss if you don’t track them over time.

What I typically see work well is keeping a simple tracker by deal and by year that captures ordinary income or loss, distributions, suspended losses, and your capital account. That helps you see the difference between “taxable income” and actual cash flow, which is where a lot of confusion comes from in syndications. Over time, you’ll also start to see which sponsors are generating real returns versus just paper losses.

The other piece is tying it back to your overall tax picture. K-1 losses may be passive and limited depending on your situation, so tracking suspended losses is important since those can free up later on a sale or when you have passive income to offset.

Also, as Andrew mentioned, it’s hard to see the full picture of the business and the deals being done when, as the CPA, we only receive a K-1 from a return we didn’t prepare.

Happy to connect!

Jose Ortiz · Answer

Just chiming in to add a bit of value here....

With multiple K-1s, it’s important to understand a few core concepts:

- passive vs. non-passive income (determines if losses are usable)

- basis (limits whether you can take losses/distributions)

- suspended losses (losses carried forward)

- multi-state exposure

You can track high-level numbers yourself, but the complexity builds quickly across years and investments.

This is where structured tracking schedules come in - basis, suspended losses, etc. That’s something we build and maintain for clients so nothing slips through the cracks over time.

The real value is tying it all together and knowing whether those losses are actually usable or just sitting on paper.

Hope this provides some additional value.

Doug Smith · Answer

It's a good problem to be getting a lot of K-1s and 1099s...so many that you struggle to track them. I personally only receive a handful, but we have to send out several for investors/capital partners. I gather the K-1s and 1099s that I get and put a package together for the CPA and his team to review. Usually, it's a tax law change that I might be unaware of that they catch. For our funds, I try to have the accounting done as far as I get get it during December so I know how we need to finish out the year and then I'll watch bowl games and take it through 12/31 ASAP. That's gives us time to get our K-1s and 1099s out to capital partners. We're not Vanguard or Fidelity, so it's not like we have hundreds of them to send out. We'll usually have them out before the 4th week of January. As for receiving them, I only have 4 K-1s coming and a handful of 1099s. It's pretty easy to just note what you expect to get and check them off as they come in.

Doug Smith · Answer

My undergrad was in accounting and I was an accountant before I went into banking/lending. For years I did my own, but as time went on I realized the laws were changing too quickly. When I got a top-notch CPA, he found things I had missed and saved me a lot more than I was paying him. Fast forward to the last crash when we started managing private lending and nonperforming loan portfolios for others, we had to use solid licensed accounting pros. I've always agreed with the axiom "if you think it's expensive to hire a professional, try hiring an amateur." Even with my background, I still pay for the pro. I've been a pro in this industry for 35 years and I'm a former accountant...and I still pay the CPA. That's my 2 cents. Good luck to you.

John Prorok · Answer

Thanks Doug,

I'm trying to figure out what I should be tracking on my own and whether or not it makes sense for me to just hand it off to a CPA or build a tool to track things across a bunch of K-1's.

If your comfortable doing so, I'd love to hear what metrics or insights your CPA helped unearth. If you had known to track those things at the time, would you have felt like it was reasonable to track them yourself and then share them with your CPA or would it really have required passing off to do that?

John Prorok · Answer

Thanks Jose, that's really helpful!

Jason Malabute · Answer

Big year-one losses on real estate syndication K-1s are super common, and they're usually a cost seg study at work behind the scenes. The challenge on the CPA side is that when we only see the K-1 and didn't prepare the underlying return, that one document doesn't really give us the full picture of what's actually happening at the deal level.

Aaron Zimmerman · Answer

@John Prorok the cpa could track amount invested and distributions. I'd be looking to the sponsor of the deal for fmv and future projections of irr after the investment has closed.

for the investor, I'd have them keep track of monthly or quarterly updates. To me, biggest things to look at for an lp on the deal would physical and economic occupancy, rent growth, and noi at the fund level (that gets reported by the sponsor)

Aaron Zimmerman · Answer

As a cpa, if my clients are giving me k-1's, it's hard to know to the full picture if I simply receive a k-1 for a return I didn't prepare. For instance, there's a lot of real estate syndications that have large year 1 losses. Is that a cost segregation study accelerating large losses? Probably. However, it certainly Does not provide the full picture.

How do you track K-1 income across multiple sources? (beyond handing to CPA)

Most Popular Reply