possible useful report for filling out 5500

[Tom Poje]

this one seems to be working fairly well, I haven't had any major problems with it over the years and found it useful.

this is another of my 'screwball' reports, that I have finally been able to update to look like something

basically, its a Summary of Accounts Totals only, but in a format designed to look like the 5500 SF.

Needed something so others here could fill in the account data portion on the 5500 without my help.

There are a few user defined fields I use to track the suspense account, but I think this should work even if you run a 'dummy employee' instead (unless you are using the user defined fields for another purpose)

ok, maybe you have to adjust distributions if you have corrective distributions, but at least it looks something like the actual 5500, and no one has a gun to your head forcing you to use it.

[Tom Poje]

since most of the data we use involves imports, we haven't been using the loan system. thus when I show loans I usually use distribution from one account source and show as positive distribution into the loan source. ({RPTEEACCT.DISTRAMT})

modified this report to use the following as well ({RPTEEACCT.LNDISTRAMT})

[Jim Chad]

Nice report, Tom.

Thanks for sharing it.

[Tom Poje]

well, its not perfect, I haven't found the transacation to run for ADP / ACP failure distributions, so you always have to separate those on your own (and I'm sure there are other scenarios that might crop up), but at least the first attempt did come back and tell me I was out of balance and I could figure out I wasn't pulling 'loan distribution' amounts correctly. (And I probably handle my suspense account differently, but if the report helps, then great)