How to correctly calculate my S-corp taxable income with QBI deduction and 401K contributions? My Excel scenarios need verification.
Hey tax folks, I'm trying to make sure I understand how all these different pieces work together for my S-corp taxes. I've put together an Excel spreadsheet with a couple different scenarios for how my taxable income would work out when factoring in the Qualified Business Income (QBI) deduction and my 401K contributions. In Scenario 1, I'm showing my business income at $175,000 with a 401K contribution of $22,500 and trying to calculate the correct QBI deduction. I think I need to apply the QBI to my income AFTER the 401K contribution, but I'm not 100% sure. In Scenario 2, I'm projecting higher business income of $225,000 with the same 401K contribution, but I'm confused about whether the QBI phase-out thresholds apply differently when 401K contributions are involved. Can someone take a look at my general approach and let me know if I'm doing this right? I really don't want to mess this up and leave money on the table or worse, have the IRS come after me. Thanks in advance for any help!
21 comments


Miguel Diaz
Your approach sounds mostly right, but there are some important details to understand about how QBI and 401K contributions interact for S-corp taxation. For an S-corp owner, your QBI deduction is generally 20% of your qualified business income. The key thing to remember is that your 401K contributions as an employee DO reduce your W-2 wages, but they don't directly reduce your QBI calculation. The QBI is based on the business income that passes through to your personal return. For Scenario 1 ($175K business income): Your 401K contribution reduces your personal taxable income, but the QBI calculation would still be based on your share of the business income. So if you're the sole owner, you'd potentially get a QBI deduction of up to 20% of that $175K, subject to limitations. For Scenario 2 ($225K business income): You're getting closer to the QBI phase-out thresholds (which start at $340,100 for married filing jointly or $170,050 for single filers for 2023), but you're still below them. The phase-out is based on your taxable income BEFORE the QBI deduction but AFTER standard/itemized deductions and qualified retirement contributions.
0 coins
Ava Johnson
•Thanks for the detailed response! So to clarify, if I'm the sole owner, my QBI would be calculated on the full $175K in Scenario 1, not on $175K minus my 401K contribution? And for the phase-out thresholds, are those numbers still accurate for 2025 filing or have they been adjusted for inflation? I'm trying to plan ahead.
0 coins
Miguel Diaz
•The QBI would be calculated on your business income that passes through to your personal return, so yes, generally on the full amount before your personal 401K contribution. Your personal 401K contribution reduces your taxable income but doesn't directly reduce the QBI calculation. For the phase-out thresholds, the numbers I quoted were for 2023, and they do adjust annually for inflation. For 2025, they will be higher - likely around $360,000 for married filing jointly and $180,000 for single filers based on inflation trends, though the IRS hasn't published official 2025 numbers yet. Keep an eye on IRS announcements for the exact figures when planning.
0 coins
Zainab Ahmed
I went through a similar headache with my S-corp last year and found this amazing tool at https://taxr.ai that literally saved me hours of frustration. It analyzes your specific S-corp situation and tells you exactly how to optimize your QBI and retirement contributions. I uploaded my spreadsheet and it immediately caught that I was calculating my QBI wrong - turns out I was double-counting some deductions which would have caused issues. Their system also showed me how to properly balance my W-2 wages vs distributions to maximize the QBI benefit, which my accountant hadn't even mentioned. The tool walks you through different scenarios just like you're trying to do.
0 coins
Connor Byrne
•That sounds useful! Does it handle situations where you have multiple income sources? I have my S-corp but also do some 1099 consulting work on the side, and trying to figure out how everything interacts is making my head spin.
0 coins
Yara Abboud
•I'm a bit skeptical of these online tools. How does it compare to just using an accountant? I've been burned before by tax software that gave me wrong calculations, and the IRS doesn't care that "my software told me to do it this way.
0 coins
Zainab Ahmed
•It definitely handles multiple income sources - that's actually one of its strengths. You can input your S-corp income, any 1099 work, W-2 income, rental properties, etc. It shows you how they all interact for QBI calculations and suggests the optimal mix based on your specific situation. As for using it versus an accountant, I actually use both. I run scenarios through taxr.ai first to understand my options, then discuss the recommendations with my accountant. Many accountants don't proactively optimize these things unless you specifically ask. The tool gives me the knowledge to have better conversations with my accountant and make sure nothing is missed. It's not about replacing professional advice - it's about being an informed client.
0 coins
Connor Byrne
Just wanted to follow up - I checked out https://taxr.ai after seeing it mentioned here and it was incredibly helpful for my situation with multiple income sources. The analysis showed me that I should be allocating my home office deduction differently between my S-corp and 1099 work to maximize my QBI benefit. I was also calculating my retirement contribution limits incorrectly since I have both the S-corp 401k and SEP options for my 1099 work. The scenario comparison feature was exactly what I needed - similar to what you were trying to do in Excel but much more sophisticated in how it handles the tax code interactions. Definitely worth checking out if you're running complex scenarios like this.
0 coins
PixelPioneer
I spent THREE DAYS trying to get through to someone at the IRS who could answer my S-corp QBI questions last year. After being on hold for hours and getting disconnected twice, I found https://claimyr.com and you can watch how it works here: https://youtu.be/_kiP6q8DX5c. They got me connected to an IRS agent in about 20 minutes who actually specialized in pass-through entity taxation. The agent walked me through exactly how the QBI calculations work with retirement contributions and confirmed I was doing my Excel models all wrong. Turns out the order of operations for these calculations really matters. Got my questions answered in one call instead of wasting days on hold.
0 coins
Keisha Williams
•Wait, how does this actually work? They somehow get you to the front of the IRS phone queue? That seems impossible given how understaffed the IRS is.
0 coins
Yara Abboud
•Yeah right. Sounds like a scam to me. Nobody can magically get through to the IRS faster. I'll stick to waiting on hold like everyone else rather than paying for some "service" that probably doesn't deliver.
0 coins
PixelPioneer
•It's not about getting to the "front" of the queue. They use technology that continually calls the IRS using their system and only connects you when a human actually answers. So instead of you personally being on hold for hours, their system does the waiting for you and then calls you when they've got an agent on the line. The reason it works is pretty straightforward - most people give up after being on hold for a long time, but their automated system never gives up. I was skeptical too until I tried it. Nothing magical about it - just smart use of technology to solve a frustrating problem.
0 coins
Yara Abboud
I need to eat my words about Claimyr. After posting my skeptical comment, I decided to try it since I had some complicated QBI questions similar to the original poster. Got connected to an IRS agent in about 15 minutes who actually understood S-corp taxation. The agent confirmed that for an S-corp owner, the 401K contributions don't directly reduce QBI but do reduce overall taxable income, which could keep you below phase-out thresholds longer. For anyone else struggling with these calculations, getting direct confirmation from the IRS saved me a ton of worry. And yes, the service actually works exactly as described. Sometimes it's worth admitting when you're wrong!
0 coins
Paolo Rizzo
One thing nobody's mentioned yet is that your reasonable compensation (W-2 wages) from the S-corp also matters for maximizing QBI. If your W-2 wages are too low compared to distributions, you might face QBI limitations. For S-corps with higher income, the QBI deduction is limited to the GREATER of: - 50% of W-2 wages paid by the business, OR - 25% of W-2 wages plus 2.5% of the unadjusted basis of qualified property Make sure your Excel model accounts for this if your income increases beyond the thresholds.
0 coins
Ava Johnson
•That's a great point I hadn't considered. For my Scenario 2 with the higher income, should I be modeling different W-2 wage levels to see how that impacts the overall tax picture? And does increasing my W-2 wages (vs. distributions) affect my 401K contribution limits?
0 coins
Paolo Rizzo
•Yes, definitely model different W-2 wage levels for your higher income scenario. The sweet spot is usually the lowest reasonable compensation that still maximizes your QBI deduction while minimizing employment taxes. Your 401K contribution limits are directly tied to your W-2 wages. For 2025, you can contribute up to $23,000 (plus $7,500 catch-up if you're 50+) from your W-2 wages. So if you increase your wages, you have more room for 401K contributions, which helps offset the higher employment taxes. But you need to balance this against optimizing your QBI deduction.
0 coins
Amina Sy
Has anyone else noticed that most tax software doesn't handle these S-corp QBI and retirement contribution interactions correctly? I tried three different programs last year and got three different results!
0 coins
Oliver Fischer
•I had the same issue! Ended up paying a CPA $450 to fix the mess I made trying to do it myself. She told me the consumer-grade tax software just isn't set up for complex S-corp situations, especially with the QBI deduction calculations.
0 coins
Amina Sy
•Good to know I'm not the only one! Frustrating that we pay for software that's supposed to handle this stuff correctly and it still gets it wrong. Makes me wonder what other things it's calculating incorrectly that I don't even know about.
0 coins
Dylan Hughes
This is exactly why I always recommend double-checking your QBI calculations manually, especially for S-corp owners. The interaction between reasonable compensation, QBI deduction limits, and retirement contributions creates a lot of room for error. One approach that's worked well for me is creating a simple decision matrix in Excel that shows total tax liability (income tax + employment tax) at different W-2 wage levels. For each scenario, calculate: 1. Your QBI deduction based on the wage limitation test 2. Employment taxes on the W-2 wages (15.3% on first $160,200 for 2025) 3. Income tax savings from 401K contributions 4. Overall effective tax rate This helps you find the optimal balance between minimizing employment taxes and maximizing QBI benefits. Don't forget that your 401K contribution room is also constrained by your W-2 wages, so higher wages = more retirement contribution capacity. The key is modeling multiple scenarios like you're already doing, but make sure you're accounting for ALL the moving pieces, not just the QBI calculation in isolation.
0 coins
Freya Nielsen
•This is incredibly helpful! I've been struggling with exactly this kind of optimization analysis. Quick question - when you mention the employment tax rate of 15.3% on the first $160,200 for 2025, is that the updated Social Security wage base? I thought it was still around $147,000 but I might be looking at old numbers. Also, for the decision matrix approach you described, do you typically model this monthly or just annually? I'm wondering if there's benefit to adjusting the W-2 vs distribution mix throughout the year based on how business income is trending.
0 coins