Participant Statement

[FJR]

I am looking for someone to share the following:

A participant statement program that will combine on one statement a 401(k) profit sharing and Money Purchase account information under the same plan.

I would greatly appreciate it if someone has such a statement.

[Tom Poje]

well that depends.

I have modified statements so the wording says Prior Money Purchase rather than Match, and simply coded the money purchase as a match account

but of course that is a plan with no match, the money purchase is no longer in existance, and I wasn't showing investments, just totals by 'source' so to speak.

If I remember correctly, even if money purchase is on going, you could still run it as an employer account and then switch to 'match' before printing.

the typical 'language in the cert by source is something like

If ({RPTPLANACCT.TYPECD} = 'A' or {RPTPLANACCT.TYPECD}='B' or {RPTPLANACCT.TYPECD}='M' or {RPTPLANACCT.TYPECD}='L') Then

BegBal4:={RPTEEACCT.BEGBALAMT}

so if your profit sharing account was #100

and the money purchase was #150 you could simply add that to the expression

If ({RPTPLANACCT.TYPECD} = 'A' or {RPTPLANACCT.TYPECD}='B' or {RPTPLANACCT.TYPECD}='M' or {RPTPLANACCT.TYPECD}='L') AND acct number = 100 (that is not the exact expression, but it would be similar)

then beg bal44:={RPTEEACCT.BEGBALAMT}

[Tom Poje]

solution:

without getting overcomplicated on creating reports

modify summary account to print soc sec number and account data for money purcahse plan, and save as csv when running report writer.

If you are not aware of it, any report run in report writer can be saved as an excel file or csv file or word or rich text file.

import this data into census user fields in the 401k plan

add a line to indicate these user fields on the certificate currently being used, and sum them into grand totals.

............

ok, I am a fool. I needed a break from my other work, so I designed the report for a reasonable fee. (Or at least the parties involved came to an agreement) I really fooled him. I designed it so it fit inside his bordered paper. I think my boss calls it Rent-A-Tom (RAT for short)