Civic Intelligence

Automatic Data Processing Inc and Subsidiaries Empl Welfare Bnft Tr

990 • Fiscal year 2012 • EIN 22-2541018

Jul 01, 2011 to Jun 30, 2012 • Filed on May 02, 2013

Organization ProfileN/A
One Adp Boulevard MS 43307068
Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

21st percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

2012 filings • 501(c)9 • $250M-$1B nonprofits • Source year 2012

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

20th percentile

-0.1%

Faster asset growth than 20% of similar nonprofits.

2012 filings • 501(c)9 • $250M-$1B nonprofits • Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets21st percentile

Assets

Down

$48,661,689

Down $47,451 (-0.1%) from 2011

Net Assets

Down

$48,661,689

Down $47,451 (-0.1%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$313,400,428

Up $35,772,606 (+13%) from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth20th percentile

The highlighted filing sits inside the broader history for assets, liabilities, and net assets.

$150M$100M$50M$0Assets 2011: $48,709,140Liabilities 2011: $0Net Assets 2011: $48,709,1402011Assets 2012: $48,661,689Liabilities 2012: $0Net Assets 2012: $48,661,6892012Assets 2013: $46,961,353Liabilities 2013: $0Net Assets 2013: $46,961,3532013Assets 2014: $50,071,576Liabilities 2014: $0Net Assets 2014: $50,071,5762014Assets 2015: $46,990,899Liabilities 2015: $0Net Assets 2015: $46,990,8992015Assets 2016: $46,998,983Liabilities 2016: $0Net Assets 2016: $46,998,9832016Assets 2017: $53,237,344Liabilities 2017: $0Net Assets 2017: $53,237,3442017Assets 2018: $57,733,849Liabilities 2018: $0Net Assets 2018: $57,733,8492018Assets 2019: $60,799,288Liabilities 2019: $0Net Assets 2019: $60,799,2882019Assets 2020: $71,056,908Liabilities 2020: $0Net Assets 2020: $71,056,9082020Assets 2021: $109,947,654Liabilities 2021: $0Net Assets 2021: $109,947,6542021Assets 2022: $128,259,744Liabilities 2022: $0Net Assets 2022: $128,259,7442022Assets 2023: $131,328,758Liabilities 2023: $0Net Assets 2023: $131,328,7582023Assets 2024: $136,275,223Liabilities 2024: $0Net Assets 2024: $136,275,2232024

Highlighted filing

2012

Assets$48,661,689
Liabilities$0
Net Assets$48,661,689
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

Revenue, expenses, and net income across loaded years, with this filing highlighted.

$600M$400M$200M$0-$200MRevenue 2011: $283,687,337Expenses 2011: $277,627,822Net Income 2011: $6,059,5152011Expenses 2012: $313,400,4282012Expenses 2013: $339,530,3532013Revenue 2014: $371,548,847Expenses 2014: $368,438,624Net Income 2014: $3,110,2232014Revenue 2015: $343,000,231Expenses 2015: $346,080,908Net Income 2015: -$3,080,6772015Revenue 2016: $337,051,228Expenses 2016: $337,043,144Net Income 2016: $8,0842016Revenue 2017: $367,130,177Expenses 2017: $360,891,816Net Income 2017: $6,238,3612017Revenue 2018: $384,662,027Expenses 2018: $380,165,523Net Income 2018: $4,496,5042018Revenue 2019: $366,569,024Expenses 2019: $363,503,585Net Income 2019: $3,065,4392019Revenue 2020: $376,092,346Expenses 2020: $365,834,726Net Income 2020: $10,257,6202020Revenue 2021: $402,369,249Expenses 2021: $363,478,503Net Income 2021: $38,890,7462021Revenue 2022: $420,855,808Expenses 2022: $402,543,718Net Income 2022: $18,312,0902022Revenue 2023: $429,547,335Expenses 2023: $426,478,321Net Income 2023: $3,069,0142023Revenue 2024: $451,861,851Expenses 2024: $446,915,386Net Income 2024: $4,946,4652024

Highlighted filing

2012

Revenue-
Expenses$313,400,428
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2011 to Jun 30, 2012
Signed
May 2, 2013
Return Version
2011v1.5
Gross Receipts
$313,352,977
Mission and Program Overview

Mission

To provide benefits to eligible participants of the automatic data processing, inc. Employee welfare benefit trust.

Major Activities

Activity 2
Payment of vision benefits for eligible employees covered under the automatic data processing, inc. Employee welfare benefit trust.
Activity 3
Payment of long term disability benefits for eligible employees covered under the automatic data processing, inc employee welfare benefit trust.
Filing and Contact Details

Filer

EIN
22-2541018
Raw XML Appendix259 raw XML fields

This appendix keeps the raw XML leaves available for debugging and edge-case review. The human report above is the primary experience.

Path#Value
IRS990/AccountantCompileOrReview00
IRS990/ActivitiesConductedPartnership00
IRS990/Activity2/Description0PAYMENT OF VISION BENEFITS FOR ELIGIBLE EMPLOYEES COVERED UNDER THE AUTOMATIC DATA PROCESSING, INC. EMPLOYEE WELFARE BENEFIT TRUST.
IRS990/Activity2/Expense03819565
IRS990/Activity3/Description0PAYMENT OF LONG TERM DISABILITY BENEFITS FOR ELIGIBLE EMPLOYEES COVERED UNDER THE AUTOMATIC DATA PROCESSING, INC EMPLOYEE WELFARE BENEFIT TRUST.
IRS990/Activity3/Expense06003420
IRS990/ActivityOrMissionDescription0TO PROVIDE BENEFITS TO ELIGIBLE PARTICIPANTS OF THE AUTOMATIC DATA PROCESSING, INC. EMPLOYEE WELFARE BENEFIT TRUST.
IRS990/ActivityOther/Description0PAYMENT OF LIFE AND AD&D INSURANCE PREMIUMS FOR ELIGIBLE EMPLOYEES COVERED UNDER THE AUTOMATIC DATA PROCESSING, INC. EMPLOYEE WELFARE BENEIT TRUST.
IRS990/ActivityOther/Description1PAYMENT OF HEALTH SAVINGS ACCOUNT CONTRIBUTIONS FOR ELIGIBLE EMPLOYEES COVERED UNDER THE AUTOMATIC DATA PROCESSING, INC. EMPLOYEE WELFARE BENEIT TRUST.
IRS990/ActivityOther/Expense03856937
IRS990/ActivityOther/Expense110290195
IRS990/AddressPrincipalOfficerUS/AddressLine10ONE ADP BOULEVARD MS 433
IRS990/AddressPrincipalOfficerUS/City0ROSELAND
IRS990/AddressPrincipalOfficerUS/State0NJ
IRS990/AddressPrincipalOfficerUS/ZIPCode007068
IRS990/BenefitsPaidToMembersCY0297316043
IRS990/BenefitsPaidToMembersPriorYear0263236904
IRS990/BenefitsToMembers/ProgramServices0297316043
IRS990/BenefitsToMembers/Total0297316043
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CapStckTrstPrinCurrentFunds/BOY048709140
IRS990/CapStckTrstPrinCurrentFunds/EOY048661689
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO00
IRS990/CompensationProcessOther00
IRS990/ConflictOfInterestPolicy00
IRS990/ConservationEasements00
IRS990/ConsolidatedAuditFinancialStmt00
IRS990/ContributionsGrantsCurrentYear00
IRS990/ContributionsGrantsPriorYear00
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DelegationOfManagementDuties00
IRS990/DescribedIn501C300
IRS990/Description0PAYMENT OF MEDICAL, DENTAL & HOSPITALIZATION BENEFITS FOR ELIGIBLE EMPLOYEES COVERED UNDER THE ADP, INC. EMPLOYEE WELFARE BENEFIT TRUST.
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy00
IRS990/DonorAdvisedFunds00
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers00
IRS990/Expense0273345926
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek02.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek12.00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek22.00
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector0X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector1X
IRS990/Form990PartVIISectionA/IndividualTrusteeOrDirector2X
IRS990/Form990PartVIISectionA/NamePerson0MICHAEL BONARTI
IRS990/Form990PartVIISectionA/NamePerson1MIKE EBERHARDT
IRS990/Form990PartVIISectionA/NamePerson2DERMOT O'BRIEN
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/OtherCompensation10
IRS990/Form990PartVIISectionA/OtherCompensation20
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization10
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization20
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs10
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs20
IRS990/Form990PartVIISectionA/Title0TRUSTEE
IRS990/Form990PartVIISectionA/Title1TRUSTEE
IRS990/Form990PartVIISectionA/Title2TRUSTEE
IRS990/Form990ProvidedToGoverningBody01
IRS990/FormersListed00
IRS990/FSAudited00
IRS990/FundraisingActivities00
IRS990/Gaming00
IRS990/GrantsAndSimilarAmntsCY00
IRS990/GrantsAndSimilarAmntsPriorYear00
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossReceipts0313352977
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt00
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartIII0X
IRS990/InfoInScheduleOPartVI0X
IRS990/InvestmentIncomeCurrentYear040243
IRS990/InvestmentIncome/ExclusionAmount040243
IRS990/InvestmentIncomePriorYear064159
IRS990/InvestmentIncome/TotalRevenueColumn040243
IRS990/InvestmentInJointVenture00
IRS990/LoanToOfficerOrDQP00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingCash0X
IRS990/MinutesOfCommittees00
IRS990/MinutesOfGoverningBody01
IRS990/MissionDescription0TO PROVIDE BENEFITS TO ELIGIBLE PARTICIPANTS OF THE AUTOMATIC DATA PROCESSING, INC. EMPLOYEE WELFARE BENEFIT TRUST.
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/NameOfPrincipalOfficerPerson0CHARLES GIBBONS
IRS990/NbrIndependentVotingMembers00
IRS990/NbrVotingGoverningBodyMembers03
IRS990/NbrVotingMembersGoverningBody03
IRS990/NetAssetsOrFundBalancesBOY048709140
IRS990/NetAssetsOrFundBalancesEOY048661689
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NoListedPersonsCompensated0X
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers00
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress00
IRS990/Organization501c0X
IRS990/OtherExpensePriorYear014390918
IRS990/OtherExpensesCurrentYear016084385
IRS990/OtherExpenses/Description0ADMINISTRATIVE EXPENSES
IRS990/OtherExpenses/ManagementAndGeneral016084385
IRS990/OtherExpenses/Total016084385
IRS990/OtherRevenueCurrentYear00
IRS990/OtherRevenuePriorYear00
IRS990/PaidInCapSrplsLandBldgEqpFund/BOY00
IRS990/PaidInCapSrplsLandBldgEqpFund/EOY00
IRS990/PartialLiquidation00
IRS990/PoliticalActivities00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenue/BusinessCode0525100
IRS990/ProgramServiceRevenue/BusinessCode1525100
IRS990/ProgramServiceRevenueCY0313312734
IRS990/ProgramServiceRevenue/Description0EMPLOYER AND ASSOCIATE
IRS990/ProgramServiceRevenue/Description1CONTRIBUTIONS FROM FOR
IRS990/ProgramServiceRevenuePriorYear0283623178
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome0311005684
IRS990/ProgramServiceRevenue/RelatedOrExemptFunctionIncome12307050
IRS990/ProgramServiceRevenue/TotalRevenueColumn0311005684
IRS990/ProgramServiceRevenue/TotalRevenueColumn12307050
IRS990/ProhibitedTaxShelterTrans00
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses0-47451
IRS990/RelatedEntity00
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip00
IRS990/ReportOtherAssets00
IRS990/ReportOtherLiabilities00
IRS990/ReportProgRelInvest00
IRS990/RetainedEarningsEndowmentEtc/BOY00
IRS990/RetainedEarningsEndowmentEtc/EOY00
IRS990/RevenuesLessExpensesCY0-47451
IRS990/RevenuesLessExpensesPriorYear06059515
IRS990/SalariesEtcCurrentYear00
IRS990/SalariesEtcPriorYear00
IRS990/SavingsAndTempCashInvestments/BOY048709140
IRS990/SavingsAndTempCashInvestments/EOY048661689
IRS990/ScheduleBRequired00
IRS990/ScheduleJRequired00
IRS990ScheduleO/GeneralExplanation/Explanation0THE ORGANIZATION HAS NO OTHER COMMITTEE THAT HAS AUTHORITY TO ACT ON BEHALF OF THE GOVERNING BODY.
IRS990ScheduleO/GeneralExplanation/Explanation1A COPY OF FORM 990 WAS PROVIDED TO THE TRUSTEES OF THE ORGANIZATION PRIOR TO FILING FORM 990.
IRS990ScheduleO/GeneralExplanation/Explanation2THE ORGANIZATION MAKES IT FINANCIAL STATEMENTS AND POLICIES AVAIALABLE TO THE PUBLIC UPON REQUEST.
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990, PART VI, SECTION A, LINE 8B
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PART VI, SECTION B, LINE 11
IRS990ScheduleO/GeneralExplanation/ReturnReference2FORM 990, PART VI, SECTION C, LINE 19
IRS990/ScheduleORequired01
IRS990/School00
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0NJ
IRS990/SubjectToProxyTax00
IRS990/TaxablePartyNotification00
IRS990/TaxExemptBonds00
IRS990/Terminated00
IRS990/TermOrPermanentEndowments00
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10ONE ADP BOULEVARD
IRS990/TheBooksAreInCareOf/AddressUS/City0ROSELAND
IRS990/TheBooksAreInCareOf/AddressUS/State0NJ
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode007068
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10CHARLES GIBBONS
IRS990/TheBooksAreInCareOf/TelephoneNumber09739745834
IRS990/TotalAssets/BOY048709140
IRS990/TotalAssetsBOY048709140
IRS990/TotalAssets/EOY048661689
IRS990/TotalAssetsEOY048661689
IRS990/TotalCompGT150K00
IRS990/TotalExpensesCurrentYear0313400428
IRS990/TotalExpensesPriorYear0277627822
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral016084385
IRS990/TotalFunctionalExpenses/ProgramServices0297316043
IRS990/TotalFunctionalExpenses/Total0313400428
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY00
IRS990/TotalLiabilitiesBOY00
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY048709140
IRS990/TotalLiabNetAssetsFundBalances/EOY048661689
IRS990/TotalNbrEmployees00
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY048709140
IRS990/TotalNetAssetsFundBalances/EOY048661689
IRS990/TotalOfOtherProgramServiceExp014147132
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProfFundrsngExpPriorYear00
IRS990/TotalProgramServiceExpense0297316043
IRS990/TotalProgramServiceRevenue0313312734
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg00
IRS990/TotalRevenueCurrentYear0313352977
IRS990/TotalRevenue/ExclusionAmount040243
IRS990/TotalRevenuePriorYear0283687337
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome0313312734
IRS990/TotalRevenue/TotalRevenueColumn0313352977
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/TransactionRelatedEntity00
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome00
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy00
IRS990/YearFormation01988
ReturnHeader/BuildTS02016-02-25 16:41:14Z
ReturnHeader/Filer/EIN0222541018
ReturnHeader/Filer/Name/BusinessNameLine10AUTOMATIC DATA PROCESSING INC AND
ReturnHeader/Filer/Name/BusinessNameLine20SUSIDIARIES EMPL WELFARE BNFT TR
ReturnHeader/Filer/NameControl0AUTO
ReturnHeader/Filer/Phone09739745834
ReturnHeader/Filer/USAddress/AddressLine10ONE ADP BOULEVARD MS 433
ReturnHeader/Filer/USAddress/City0ROSELAND
ReturnHeader/Filer/USAddress/State0NJ
ReturnHeader/Filer/USAddress/ZIPCode007068
ReturnHeader/Officer/AuthorizeThirdParty01
ReturnHeader/Officer/DateSigned02013-05-02
ReturnHeader/Officer/Name0CHARLES GIBBONS
ReturnHeader/Officer/Phone09739745834
ReturnHeader/Officer/Title0AUTHORIZED REPRESENTATIVE
ReturnHeader/PreparerFirm/EIN0221478099
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10COHNREZNICK LLP
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine104 BECKER FARM ROAD
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0ROSELAND
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0NJ
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode0070681739
ReturnHeader/Preparer/Name0THOMAS LANNING
ReturnHeader/Preparer/Phone09732283500
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02011-07-01
ReturnHeader/TaxPeriodEndDate02012-06-30
ReturnHeader/TaxYear02011
ReturnHeader/Timestamp02013-05-02T15:28:23-05:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990Facts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$48,661,689
Liabilities
$0
Net assets
$48,661,689
Revenue
-
Expenses
$313,400,428
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$136$0.00$136$452$447$4.95
2023Summary only. Only limited summary data is available for this year.$131$0.00$131$430$426$3.07
2022Facts available. Structured filing facts are available, but richer extracted sections are limited.$128$0.00$128$421$403$18.3
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$110$0.00$110$402$363$38.9
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$71.1$0.00$71.1$376$366$10.3
2019Summary only. Only limited summary data is available for this year.$60.8$0.00$60.8$367$364$3.07
2018Facts available. Structured filing facts are available, but richer extracted sections are limited.$57.7$0.00$57.7$385$380$4.50
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$53.2$0.00$53.2$367$361$6.24
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$47.0$0.00$47.0$337$337$0.01
2015Detailed filing. Detailed filing data is available for this year.$47.0$0.00$47.0$343$346$3.08
2014Summary only. Only limited summary data is available for this year.$50.1$0.00$50.1$372$368$3.11
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$47.0$0.00$47.0$340
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$48.7$0.00$48.7$313
2011Summary only. Only limited summary data is available for this year.$48.7$0.00$48.7$284$278$6.06