possible report for pulling data from Relius to FT William

[Tom Poje]

I've decided to post this version of the report for now. Seem to be having real good success with it, and the wonderful Austin took the trouble to look at it and seems to have success as well. He actually modified the report slightly and I actually like his version of the report better, but I ran into one problem with the report if 2010 is the first year the plan is on the system even though it has existed in the past. Which is why I posted this version)

OK, I'm at level 16 and it appears to works fine, he is still at an earlier version, so the D people don't get pulled from the prior year (if the report is printed from 1/1/2009 - 12/31/2010)

another possible issue is the amount that shows - possibly may be different if there is an outstanding loan balance.

In Relius, run the report out of Custom, save as a File/ Excel (data only)

the items in columns A - J can be copied and pasted into the FT William file 8955Sample.csv

(when you open up the 5500 in FT William, you have to first click on form 8955-ssa

and then return - at that point you will now see an option to upload file.)

I've sort of added a counter to the spreadsheet, you can total up the number of D and A people on the excel sheet you create.

I had one person show up as an A that had a residual balance of 45 cents, so they showed as a 0, I guess its ok to delete folks like that.

had another that showed as a D. usually they show blank for the amount, this one showed as a negative amount, because I'm pulling the vested balance total. I think that was caused by the person being paid out and by the time the balance was forfeited there were some losses, so the system thought he was overpaid. (all account data was imported)

so I guess there are one or two items to watch out for.

This report can be run across the all plans as well, but of cousre the results only make sense if the plan has processed for the year.

people who would have been an A in 2009 and a D in 2010 do not show. working under the assumption that you do not have to report these folks.

of course, such report is 'use at your own risk', but as I've said, it looks to me like its doing the job.

I think that's everything

[Tom Poje]

oh, if no one goes on the SSA the report will print blank

if saved as an excel file I believe it will only show the company name

[Tom Poje]

upon further review of my counter, the "A" bodies are correct as for the year

the "D" body total is correct, but as to whether they are 2009 or 2010 will be off when running a date range from 2009-2010. My current counter will lump all "D" people in 2009, even if they should be 2010. not sure if there is an easy way to tell the system what year they were paid out when running a report over two years. (I suppose it might be possible to look at prior distrib, but probbaly just as easy to tun the report from 1/109 - 12/31/09 and see how many D's show up)

of course this results in quite an anomaly.

for items 6 the electronic import expects the body count on page 2 = to the values one puts on page 1 (thus you include 'D' bodies)

however if you put the count down for a 2 year period, then you put 2009 people on line 6a and 2010 bodies on line 6b.

6b is supposedly for those bodies you voluntarily report - which would normally be people who quit the same year the form is filed. but then why would that item include D people, so that will only add to the confusion.