Jump to content

I'm reviewing a non-profit and trying to connect 5500 form data to its 990 form, but I'm noticing some differences in lots of data points. How do I reconcile that?


Recommended Posts

Posted

This impacts things like number of employees, revenue (as represented by TOT INCOME on the 990 and Revenue on 5500), liabilities, cash on hand, etc. Can anyone help me understand why I'm seeing those differences?

Posted

Well I’m confused because I’m not aware of many data points that would be identical on those two forms. 
 

The name, address and EIN ought to match of course. 
 

But can you list a few examples of data points that should match? Please be specific. 

William C. Presson, ERPA, QPA, QKA
bill.presson@gmail.com
C 205.994.4070

 

Posted

Apologies, definitely should’ve been more clear. The biggest thing I’m trying to do is reconcile some of the reported figures from a 990 and 5500 health benefits form. From what I can tell, the 990 reports the non-profit level figures for major metrics like company revenue, liabilities, and a bunch of other metrics like spend towards employee benefits. In theory, it seemed like I could cross-reference those figures with the 5500 form to match up those figures.

For example- employee benefits spend listed in the 990 matching with the premium received amt from the 5500 schedule A. Or, revenue/liabilities from the 990 matched with reported figures from 5500 Schedule H. It may be my misunderstanding, but are those not referring to the same thing?

thanks!

Posted

Are both reports for the same period?

And even if they are, consider that one report's item might be on an accrual basis of accounting while the other report's similar item refers to an amount actually paid or received.

Further, seemingly similar items might not be exactly the same in a particular report's query or instructions.

Peter Gulia PC

Fiduciary Guidance Counsel

Philadelphia, Pennsylvania

215-732-1552

Peter@FiduciaryGuidanceCounsel.com

Posted

So both reports are for the same period. I'm noticing this discrepancy for pretty much all companies that I was trying to validate. For example, here's what I see for this EIN.

Form 990: Total number of individuals employed in calendar year: 303. Total Revenue: 23,674,433. Then for employee benefit spend, it seemingly could come from two sources. Either Part 8 line 2c (Private Insurance Rev): 590,890 or part 9 line 9 (other employee benefits): 3,229,238. In either case, it doesn't really match total benefit spend from the 5500. 

Form 5500 Total number of employees: 217. Total Income: 2,511,761. Total Benefit Spend: 530,428

My goal is to get these to match as closely as possible. Do you know what might be explaining differences between something like total revenue and total income or the differences in reported benefits?

Thanks!

Posted

Pretty sure the 5500 only deals with participants and not employees. 
 

Also a 5500 usually deals with a single plan. It’s possible that plan could have more than one benefit but it may not have all benefits. And not all benefits have enough participants to require reporting on a 5500. 
 

While 5500s and 990s are technically public documents, it’s bad form to identify an employer on the board. 

William C. Presson, ERPA, QPA, QKA
bill.presson@gmail.com
C 205.994.4070

 

Posted

In addition to making sure the dates correspond you'll want to make sure that you're comparing numbers using the same basis of accounting (accrual, cash, modified cash). 

On the Form 990, the realized gain (loss) is usually reported on Part VIII.  Unrealized gain (loss) is usually reported on Part XI, Line 5 (and not necessarily part of revenue).  

Depending on the situation, Part IX, Line 4 may also include those benefits provided to Officers, Directors, Trustees, Key Employees and other Employees and therefore not reflected in Part IX, Line 9.  Part IX, Line 9 could include several other items such as employee events. 

With that said you probably won't reconcile between the two just by looking at the forms.  I'm not saying that it's impossible but you're going to need more information to be able to reconcile.  I hope this helps.  

Posted

I agree with the comments above but have to ask "why" are you trying to reconcile the numbers on these forms?  If I see a discrepancy in a significant number on something that matters to the 403(b) (number of employees listed as 800 on the 990 but we have been told there were 10 when the proposal was issued), I ask the sponsor to explain.

Patricia Neal Jensen, JD

Vice President and Nonprofit Practice Leader

|Future Plan, an Ascensus Company

21031 Ventura Blvd., 12th Floor

Woodland Hills, CA 91364

E patricia.jensen@futureplan.com

P 949-325-6727

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...