austin3515

Well it came from this: https://www.federalregister.gov/documents/2021/09/15/2021-19714/proposed-revision-of-annual-information-returnreports Not sure what that means but it was never part of a Bill, but rather a change in a regulation I think.

Kinda landing in the same place. I told the advisor it can be done and they'r working with their wealth management side who lives in the IRA space. Thanks All!

Excellent thanks! (3) Rollover contribution An amount is described in this paragraph as a rollover contribution if it meets the requirements of subparagraphs (A) and (B). (A) In general Paragraph (1) [Which states ALL distributions from IRAs are taxable] does not apply to any amount paid or distributed out of an individual retirement account or individual retirement annuity to the individual for whose benefit the account or annuity is maintained if— (i) the entire amount received (including money and any other property) is paid into an individual retirement account or individual retirement annuity (other than an endowment contract) for the benefit of such individual not later than the 60th day after the day on which he receives the payment or distribution; or (ii) the entire amount received (including money and any other property) is paid into an eligible retirement plan for the benefit of such individual not later than the 60th day after the date on which the payment or distribution is received, except that the maximum amount which may be paid into such plan may not exceed the portion of the amount received which is includible in gross income (determined without regard to this paragraph).

I just read a really cool suggestion - do a Roth covnersion - roll the basis to a Roth IRA and the gains portion to a pre-tax IRA. I dont follow the mechanics but if someon else does and can it explain it I would be grateful! https://www.lordabbett.com/en-us/financial-advisor/insights/retirement-planning/when-the-reverse-makes-sense--benefits-of-a-reverse-rollover.html#:~:text=A regular rollover is when,your employer or plan administrator. EXAMPLE: Ben has a $100,00 traditional IRA of which $30,000 consists of basis (after-tax funds), and the remaining $70,000 is pre-tax. Since a 401(k) can only accept pre-tax funds, the basis can’t be rolled over and must remain in his IRA. After Ben rolls over the $70,000 to his 401(k), what’s left in his IRA ($30,000) is all after-tax dollars, which can now be converted to a Roth IRA, free of taxes. Why? Because taxes had previously been paid on these funds, there is no tax bill for the Roth conversion.

Is there a rule that says that an IRA including nondeductible contributions cannot be rolled over to a 401(k) plan? Ordinarily I would say forget it but in this case it is the owner who wants to consolidate. If the answer was no, wouldn't that be indicated on this chart? I don't see any mention of any such restriction. https://www.irs.gov/pub/irs-tege/rollover_chart.pdf

What gets me going is that they did not indicate WHERE to get them. That was great. But for ASP we just have to do the global update. Whether or not that works for the standalone / network versions I can't say... Hopefully it does though.

The problem with your approach is that even just the interest rate changes monthly, and the mortality each year. So you need an APR in your formula that is different for each year end. With ASP I just have to do a few keystrokes to download the data I need. You'd have to ask Relius where to get the new interest rate tables/mortality tables and how to update them, but I believe it is somewhree on Relius.net. Your supposed to import it every month again because the rate is different each month. The report you need to copy is somewhere on your C drive with all of the ADP test reports, etc. I don't know exactly where but you can just copy it your custom reports folder with any other custom reports you have. And then again just add it under the Participant Certificate / DOL Lifetime Income folder of Report Writer. But if your good with Crystal you can take the Relius LT Income report and pull out the fields you need or revise their standard report any way you want.

I found what I need by the way. If you are good with Crystal what you can do is: 1) Copy the DOLLifetimeIncome.rpt from the R drive (if you use ASP) to your custom reoprts folder 2) Edit the report to be whatever you need including just an export of the Lifetime Income amounts, and all other figures (interest rates, etc). 3) You have to add the custom report to the same Participant Certificate folder where the Relius standard Lifetime Income report is saved. It will not run under the normal Custom report window. With that you can pretty much do anything you want, including sorting it alphabetically and suppressing those with no balances.

I was on the RVUG website and even created an account but could not find the instructions on how to sort it alphabetically or suppress the no balance people. If you happen to know where that video recording would be I would appreciate it!

Attention Relius Users The name of the mortality table you want is called "20XX Applicable." If you navigate to Data Entry, Tables, Actuarial, Table Entry, pick "Mortality" from drop-down, and then select "2021 Applicable" (for the 2021 table) that table will be displayed. You can then click/drag on the Age and Factor headers which will highlight the rows and you can then copy/paste into Excel!

You can easily convert PDFs to Excel so having in PDF is pretty much just as good. 2021 table if anyone wants it. https://www.irs.gov/pub/irs-drop/n-19-67.pdf 2022 table again just to put them both in the same post. This is already html so more of a copy/paste: https://www.irs.gov/irb/2020-51_IRB#NOT-2020-85

OK Pam Shoup on another thread hooked me up and now I have the tables in Relius! But there are 10 2021 tables to choose from. Which one is CBZ using? These are my choices. Nothing seemed to line up with CBZ...

OMG is it possible to like your post 50 times?

Arond and around we go. My newest one is from 2015 and I presume the issue is that we have not downlaoded the tables. My original quesiton on a different thread was where in Relius support website do I download the tables. Bri, do you know where I do that? I really really appreciate everyone's help at here!

1) Where in Relius? 2) It doesn't seem to match the mortality table that Zeller put in the spreadsheet...

I guess I found the 2022 tables. It was not easy find! https://www.irs.gov/irb/2020-51_IRB#NOT-2020-85

Is this it on page 5? https://www.irs.gov/pub/irs-drop/n-22-22.pdf Or is this only for 2023 valuation dates? And which column? Unisex on far right? Another one for 2021, but no unisex one? https://www.govinfo.gov/content/pkg/FR-2022-04-28/pdf/2022-06330.pdf Man this is complicated....

Where can I download the mortality tables?

A link perhaps?

How often are these updated? And your saying the 417e table is just straight from the notice? And the CMT rate is just the 1 interest rate, right (the 1.20%)? Where would you get that? I wrote an Excel loan program that automatically pulls in the prime rate from a website. I forgot what the feature is called but the functionality is in Excel to download the contents of a webpage, and then you just have to use a little trickery to get things where you want them to be... If you let me know where to find this, I'd try and automate it, because I personally see a lot of value in being ablet o calculate these things in Excel or in my case Access. But being able to calculate these APR's is the hurdle.

So we asked Relius why we could not get our Lifetime income numbers to work and they said: What they don't mention is WHERE we get the rates. Anyone know? Also would anyone know what the math is to caluclate the benefits if say I needed to do it in Excel?

I didn;t pay for any of those, I just use it for the regs really, and all the IRS notices and Q&A'. the official stuff. Can't justify the EOB plus that as well. But it is tempting.. I also use their Q&A service which is super awesome. As far as I am concerned the fact that they don;t mention it to me is confirmation that its not an issue. They did not say "thou shalt not correct missed deferrals for HCE's because then only HCE's are getting Nonelective Contributions" and therefore it's not an issue. Can I venture a guess that's along the lines of what eSource said?

Where in EPCRS does it indicate that contributions made just for HCE's due failures applicable to HCEs are not going to cause nondiscrimination problems. So HCE's deferral election was not implemented. QNEC / Match make up not required. There must be something in EPCRS that says if I correct for an HCE the correction does not create a nondiscrimination issue. Where is that?

Well that is true and all, but I was only trying to write down the rationale for the provision. And I think my rationale is the explanation (well at least it reconciled it in my head).

Ahh, the failure to provide the opportunity to participate would always be to those who were otherwise excludables, wouldn't it? That's what I was missing! Thanks!!