Does anyone have a good spreadsheet template for tracking multiple assets for Form 4562? My professor wants us to show our work and I'm terrible at setting up Excel formulas for depreciation calculations.

Great question about Form 4562! Just to add to what others have said - when you're combining multiple 7-year assets on line 19c, make sure you're also considering whether any of them qualify for bonus depreciation. For 2023, you can still take 80% bonus depreciation on qualifying new property, which would be claimed before regular MACRS depreciation. If you elect bonus depreciation on some assets but not others (even within the same property class), you'll need to separate them on different lines of Part III. So you might have one line for 7-year assets taking bonus depreciation and another line for 7-year assets using only regular MACRS. Also, don't forget about the Section 179 election limit - for 2023 it's $1,160,000 with a phase-out starting at $2,890,000. If your total equipment purchases are under these thresholds, you might want to consider Section 179 instead of or in addition to MACRS depreciation for maximum first-year deduction. Keep detailed records as others mentioned - asset description, cost, date placed in service, business use percentage, and which depreciation method you chose for each asset. This will save you headaches later!

Anyone else notice that the tax software doesn't clearly explain this stuff? I had the same confusion last year. Had to dig deep into the actual forms to see that the software was calculating everything correctly but just displayed it confusingly on the summary screens.

This is exactly the kind of situation where having a clear breakdown is crucial! I went through something similar when I sold my rental last year. One thing that helped me was creating my own simple spreadsheet to track the math: - Total gain: $202k - Depreciation recapture (taxed up to 25%): $45k - Remaining long-term capital gain (taxed at 15% for MFJ): $157k Then I compared this to what showed up on Form 4797 Part III and Schedule D in my software. The key is that even though line 7 shows the full $202k, the tax calculation behind the scenes should be applying different rates to each portion. If you want to double-check your effective tax rate, calculate what you'd expect to pay: ($45k × 25%) + ($157k × 15%) = $11,250 + $23,550 = $34,800 total. Then see if that matches what your software is calculating for tax on this gain. This helped me confirm everything was working correctly even though the summary screens were confusing.

You can also call the IRS at 1-800-829-1040 and ask them to check if your dependent's SSN was used on another return, but they won't tell you who filed it. If it was used, they'll send you Form 14039 (Identity Theft Affidavit) and you'll need to file a paper return with all your custody documentation. The whole process can take 4-6 months to resolve unfortunately.

Another option is to request Form 4506-T (Request for Transcript of Tax Return) from the IRS website or by calling them. This will show you a transcript of what was filed under your child's SSN, including who claimed them as a dependent. It's free and usually faster than waiting for notices. If you see they were claimed by someone else, you can then decide whether to file a paper return disputing it or try to resolve it directly with your ex first.

I've been following this thread and wanted to add some clarity from my experience as someone who's dealt with this exact situation multiple times. The confusion often comes from how partnership taxation works versus how IRA contribution eligibility is determined. Here's the key distinction: guaranteed payments to partners are reported on your K-1 (Box 4) and represent compensation for services you provided to the partnership. Even though these payments get combined with your share of partnership income/loss on Schedule E, they don't lose their character as "earned income" for IRA purposes. Think of it this way - if you work for a corporation and receive a W-2 salary, but the corporation loses money, your salary is still earned income for Roth contributions. Guaranteed payments work similarly - they're compensation for your services, separate from your ownership interest in the partnership's profits or losses. The IRS specifically addresses this in Publication 590-A under the definition of compensation. As long as your guaranteed payments were for services (not for use of capital), they count toward your Roth contribution limit regardless of whether the partnership had a net loss. So with your $26,500 in guaranteed payments, you should be able to contribute up to the annual Roth IRA limit, assuming you meet the income phase-out requirements.

This is such a common misconception that trips up so many partnership taxpayers! I went through this exact same situation a few years ago and initially thought I couldn't contribute to my Roth because my Schedule E showed a net loss. The key insight that finally clicked for me is that guaranteed payments maintain their character as compensation regardless of what happens with the rest of the partnership's operations. It's almost like having two separate tax events - you received compensation for services (the guaranteed payments), and separately, your ownership interest in the partnership experienced a loss. I'd strongly recommend double-checking with a tax professional who understands partnership taxation, because this is an area where many general practitioners get confused. The IRS publications are pretty clear on this, but it's easy to miss if you're just looking at the bottom-line numbers on your tax return. With $26,500 in guaranteed payments, you should definitely be able to make your Roth contribution (assuming you're under the income phase-out limits). Don't let a partnership loss cost you a whole year of retirement savings!

Just wanted to add - make sure you keep copies of EVERYTHING related to your nondeductible contributions forever (or at least until you've withdrawn all the money). I learned this the hard way. I had made nondeductible contributions years ago, filed my 8606 forms properly, but then lost track of the paperwork during a move. When I started taking distributions years later, I couldn't prove my basis to the IRS and ended up paying tax on money that should have been tax-free coming out. The burden of proof is 100% on you to track your nondeductible basis, not on the IRS. They don't keep easily accessible records of your basis year to year.

Great advice from everyone here! I went through this exact situation last year when I discovered I had missed filing Form 8606 for multiple years of nondeductible contributions. One thing I'd add that helped me tremendously - when you mail your Form 8606, use certified mail with return receipt requested. The IRS can be slow to process these forms, and having proof of delivery gives you documentation that you filed it timely (even though it's late for the original tax year). Also, consider keeping a detailed log of all your IRA transactions going forward. I created a simple spreadsheet that tracks: - Date of contribution - Amount contributed - Tax year it applies to - Whether it was deductible or nondeductible - Form 8606 filing status This has made my annual tax prep so much easier and ensures I never miss tracking my basis again. The few hours spent organizing this information upfront saves tons of stress later, especially if you ever need to prove your basis to the IRS during an audit or when taking distributions. Your numbers look correct for the 2022 form, and yes, you should include the full $15,500 basis on your 2023 Form 8606 even if the 2022 form hasn't been processed yet. The key is that you're filing it before or with your 2023 return.