


Ask the community...
I created a custom Excel spreadsheet that helps with ERTC/PPP optimization that I'm happy to share. It's not as fancy as dedicated software, but it has formulas that calculate different scenarios based on which wages you allocate where. Key features: 1. Separates employees by quarter/PPP period 2. Calculates ERTC for different qualified wage caps 3. Optimizes PPP forgiveness with non-payroll expenses 4. Shows total benefit comparison between different allocation methods Message me your email if you want a copy. It comes with no guarantees but has worked well for my 30-employee manufacturing business.
This sounds great! Would your spreadsheet work for a restaurant business with about 45 employees? And does it account for the different ERTC rates between 2020 (50% of qualified wages) and 2021 (70% of qualified wages)?
It should definitely work for a restaurant with 45 employees. You'll just need to add more rows for the additional staff, but all the formulas will adjust automatically. And yes, it has separate sections for 2020 and 2021 with the different credit percentages (50% vs 70%) and different qualified wage caps ($10,000 per year in 2020 vs $10,000 per quarter in 2021). I actually designed it when helping a friend with his restaurant, so it already has some restaurant-specific features like allocating tipped employees appropriately. Just make sure you customize the state unemployment rate section since that impacts some calculations.
Has anyone actually had their ERTC claim accepted and received a check yet? We submitted amended 941s for Q2-Q4 2020 and Q1-Q3 2021 almost a year ago and haven't heard anything. Our CPA says the IRS is backlogged by 18-24 months on these claims. Just wondering if there's any light at the end of this tunnel...
We just got our ERTC refund last month after waiting 14 months. Filed in March 2022 and check arrived April 2023. About $168k total. No explanation for the delay and no interest payment included even though they're supposed to pay interest after 45 days. Just be patient, it'll come eventually.
I had a similar experience but the opposite way - TurboTax showed $280 more than TaxSlayer. Turns out TurboTax was correctly applying a savers credit that TaxSlayer missed. One trick I learned: you can view the actual forms before filing with either service. If you look at the completed 1040 forms from both and compare them line by line, you'll usually spot where the difference is coming from. It's usually on one specific line or schedule, and once you find it, you can research whether that specific calculation is correct.
This is great advice! Finding the specific line where the difference occurs is key. Then you can google that specific tax form line to check which calculation is correct.
Just to add another perspective - sometimes the difference isn't because one software is "right" and the other is "wrong." Tax law has gray areas where reasonable people can interpret things differently. If you're self-employed or have investment income, check how each platform is handling your qualified business income deduction or investment expense allocations. These areas have some subjective elements where different software might make different but equally legitimate calculations. I personally would go through the comparison process others have suggested, but if both approaches seem reasonable, I'd probably go with the higher refund. Just make sure you can justify the positions taken on your return if asked!
For anyone still looking, I found a workaround in FreeTaxUSA. If you can't find the specific ESPP entry form, you can actually report it as "Other Income" and just put a description like "ESPP Discount - Form 3922" and enter the discount amount. It's not the most accurate way to do it, but it ensures the income gets reported. Just make sure you keep good records of your cost basis for when you sell the shares later. The main thing is that the discount gets reported as ordinary income.
Is that really correct though? Won't that cause issues when you sell the shares later? I thought there was a specific way you had to report ESPPs to make sure the basis gets tracked correctly.
You're right that it's not ideal. The proper way is definitely through the Stock Options section I mentioned. The "Other Income" approach is really just a last resort if you absolutely cannot find the proper entry point. When you later sell the shares, you'll need to manually calculate and enter the correct adjusted basis. It's much better to use the proper ESPP entry screens which will help track your basis automatically and ensure everything is reported correctly on your tax forms.
Am I the only one who thinks it's ridiculous that tax software makes it so hard to find where to enter common tax forms? Companies are increasingly offering ESPPs and I get this form every year, but I spend hours trying to figure out where to enter it correctly.
You're definitely not alone. I switched from FreeTaxUSA to TaxSlayer last year because of this exact issue. The problem is that most tax software is designed for "typical" W-2 employees without stock compensation. As soon as you have slightly more complex situations, it becomes a treasure hunt.
Don't overlook state R&D credits too! Many states have their own research credit programs with different documentation requirements. In California, for example, the documentation requirements are similar to federal but they specifically want more details on how the research benefits California operations. Always check your state tax authority websites for their specific requirements. Some states are stricter than the IRS, while others are more lenient. Could be leaving money on the table if you only focus on federal credits.
Do you know if you need to file the state R&D credits at the same time as the federal ones? Or can you do federal first and then state later after you've seen if the federal ones are accepted?
You generally can file them separately with different timelines. Most states don't require that you've been approved for the federal credit before claiming the state credit, though some states do require you to at least have claimed the federal credit. The advantage of filing them together is that your documentation will be fresh and consistent. If you wait too long between filings, you might find discrepancies in your documentation which could raise red flags in an audit. But there's no technical requirement to file simultaneously in most states.
Has anyone successfully claimed R&D credits for software development projects? We have a fintech app that required significant experimental development to integrate with banking APIs. Would this qualify? And what kind of documentation should we be keeping?
I've successfully claimed R&D credits for software development for 3 years now. The key is documenting the technical uncertainty you faced. Keep all technical specifications, design documents, meeting notes discussing technical challenges, repository commit messages, and testing documentation. The IRS wants to see that you were developing something truly innovative - not just implementing known techniques. Track time specifically spent on experimental development vs. routine coding. For your fintech integration, focus on documenting the technical uncertainties you faced when developing the integration and how you systematically evaluated alternatives.
Savanna Franklin
I'm in a similar boat but with rental property sales. Just a note on capital gains - don't forget state taxes too! Depending on where you live, states can take a significant bite on top of federal capital gains taxes. I'm in California and was shocked at how much extra I owed to the state when I sold some investment property last year.
0 coins
Juan Moreno
ā¢Do you know if there's any way to offset or reduce state capital gains taxes? Do strategies like 401k contributions work for state taxes too?
0 coins
Savanna Franklin
ā¢Generally, 401k contributions will reduce your state taxable income as well as federal, so that strategy works for both. In most states, their tax system is linked to the federal system, so deductions that work federally often work at the state level too. Some states have unique quirks though. A few states offer special capital gains exclusions for in-state investments or specific industries. And nine states (Alaska, Florida, Nevada, New Hampshire, South Dakota, Tennessee, Texas, Washington, and Wyoming) don't have income tax at all, so capital gains are only taxed federally if you live there.
0 coins
Amy Fleming
Has anyone used tax-loss harvesting to offset capital gains? I'm thinking about selling some underperforming stocks to balance out my gains but not sure if it's worth it or how exactly it works.
0 coins
Justin Trejo
ā¢Tax-loss harvesting can be a great strategy. Basically, you can use investment losses to offset your capital gains dollar-for-dollar. If your losses exceed your gains, you can even use up to $3,000 of those losses to offset ordinary income, with any remaining losses carrying forward to future years. Just be careful about the wash-sale rule - if you sell an investment at a loss and buy the same or a "substantially identical" investment within 30 days before or after the sale, you can't claim the loss for tax purposes.
0 coins