Archimage Posted January 2, 2003 Posted January 2, 2003 I am having problems getting Relius to print my safe harbor contributions separately. All the "canned" reports combine the safe harbor contribution (SHNEC) into the EMPLOYER source. Has anyone else had any luck on this issue?
Tom Poje Posted January 2, 2003 Posted January 2, 2003 Unfortunately, there is no independent source for the SHNEC. After the val is run, I've changed the source to QNEC and edited the reports to say Safe Harbor instead of QNEC, and then printed. or some goofy scheme like that. It is a pain. There are a number of other issues involved as well. (e.g. nondiscrim testing you can't impute disparity on the SHNEC) hopefully someday a new source will be added.
Archimage Posted January 2, 2003 Author Posted January 2, 2003 Have you heard anything from Corbel about a possible update on this?
Guest DottleC2 Posted January 2, 2003 Posted January 2, 2003 I've heard rumblings that there may be a revision after ver 7.3; in other words Ver 8. You might try doing away with the hard coded report subtotals; Instead of subtotaling on 'Employer Discretionary' or whatever is hardcoded, hide that band and use the account name next to each line item instead; this can be changed at the plan level so as not to disturb a generic report. Idea is to not subtotal at the header, just print each account on a separate line. The only groups header/footer that _aren't_ suppressed are Group 2 header, group 2 foot, Group 5a Foot, and Report footer a. This way, whatever you've typed in for account name is what will print on each line item; Group Header #1 ...SORTNAM [format/suppress] Group Footer #1 [format/suppress] >> Group Header #2 ..soc sec num ..last name NameText:=NameText+" "+ soc. sec number etc >> Group Footer #2 ...participant total [begbal] ; calc gain amt etc Group Header #3 Typecd [format/suppressed] This band can be used to place account type field in case subtotals are re-introduced; the account type based on source in many instances just doesn't work. Group Footer #3 Typecd [format/suppressed] ...Group 3 and 4 are both suppressed but can stay for sorting or testing etc. Group Header #4a ...SrceID (this for sorting too) [format/suppressed] can keep suppressed just in case; some plans really do need subtotals, but more often than not confusion results if they are generated at the report level; Group Header #4b [format/suppressed] Group Header #5 [format/suppressed] >> Group Footer #5a Account Name ; [beg Bal], calc gain/ loss ETc Etc Group footer #5b [one line supressed with @flag] >> Report Footer a Sum of [beg Bal], calc gain/loss etc etc (Totals) Page foot at a half inch seems to work The end result is something like; Smith, John 999-99-9991 Profit Sharing Loan x Profit Sharing Pool x Money Purchase x Deferral Pooled x Participant Total x Hope that helps rather than confuses; the bottom line is that the sort order is maintained, and only account name prints (and totals). Bill
Guest greggi39 Posted January 3, 2003 Posted January 3, 2003 i have created a 2nd ER source called safe harbor and then added an account to that source. I usually will use the fdp style summary of accounts reports.
Archimage Posted January 3, 2003 Author Posted January 3, 2003 That works fine for a balance forward plan but my problem lies with daily plans. Thanks for the info everyone.
FAPInJax Posted January 3, 2003 Posted January 3, 2003 8.0 does have a modification that should help. The source may now have a checkbox activated which indicates whether it is a ADP or ACP safe harbor. This should enable the differentiation of these monies.
Guest DottleC2 Posted January 3, 2003 Posted January 3, 2003 <> That reminded me of something. Version 7.3 creates source level specifications for this, so I had assumed (perhaps incorrectly) that you (Arch) were utilizing a separate source. The end result being that an additional account is created... I usually give SH account the number 151 just to set it apart. Since we decided to not use subtotals anymore, and just use daily valuation style activity and statements, i.e. source fund amount, there has been no problem with this or merged MP sources in PS plans. One thing that is confusing (I think) is that Relius will squawk with a message box when you try and add an additional source to Employer source; ignore this, and add as many sources as you like under 'Employer'; as long as they are represented by an account, you're fine in my estimation. Handle the contribution at the transaction level according to the plan. Sounds like you may have resolved already, but my two cents plus. Bill
Guest Tbrown Posted January 6, 2003 Posted January 6, 2003 I don't think there is anything in 8.0 that will help you from a reporting standpoint (at least I haven't found it yet). What we have done is change our report groupings based upon ER fully vested vs. ER subject to vesting. If you choose the "Immediate" vesting schedule, the report displays and groups those accounts (and subtotals them) under Safe Harbor. If you have an immediate vesting source that is just profit sharing and not safe harbor, then we choose the schedule "Immediate Non SH". This is a custom schedule we set up that has a vesting schedule that is immediate vesting, but Relius picks it up as "Subject to vesting" and will display, group and subtotal under the description "Employer" or "Profit Sharing" or whatever you want to call it. Maybe this will help some. Tim
Guest DottleC2 Posted February 3, 2003 Posted February 3, 2003 Having rethought this thread - the question in the context of ver 8.0 provides a clearer answer than the previous one I think. Below, a vesting report is created and shows basically account data by source. If for some reason a report needed to be able to break subtotals on source number rather than the 'canned' source group, this might help. The problem leading up to this point was the naming of the source which is resolved in @custfld1 below: REPORT BY SOURCE - VESTING REPORT 'Used Sacctdl8.rpt for a template 'Custom fields are rough draft 'I used fake-friendly-field names below 'Using v8.0 GROUP HEADER 1 - [Name Sort] / Supress GROUP HEADER 2 - [sSN] / KeepTogether @NameAndSs GROUP HEADER 3 - [Type Code] / Suppress GROUP HEADER 4 - [source ID] / Suppress GROUP HEADER 5 - [Account ID] / Suppress --------------------------- Use Sacctdl8.rpt for a template Details / Suppress Fields: [Contribution Amount] etc may come in handy in future to provide subtotal in footers below, if you needed a more specific contribution/transaction analysis for year end. --------------------------- GROUP FOOTER 5A - [Account ID] / Suppress GROUP FOOTER 5B - [Account ID] / Suppress @flag x=1 GROUP FOOTER 4A - [source ID] First Field: @CUSTOMFIELD1 if IsNull ({TYPEDSCRPTXT}) or {TYPEDSCRPTXT} = ' ' then {R_ACCT.ACCNTNAME} //may want to base on @AcctType else {TYPEDSCRPTXT} A second Field: @strVestedPCT ToText({R_EEACCT.VESTING%},0)+" % " GROUP FOOTER 4B - RPTPLANACCT / Suppress @set flag x=0 GROUP FOOTER 3 - [Type Code] / Suppress GROUP FOOTER 2 - [sSN ] / Suppress GROUP FOOTER 1 - [Name Sort] a line_______________________ * * * Regards, Bill
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now