Civic Intelligence

American Federation of State County & Municipal Employees

990EZ • Fiscal year 2017 • EIN 14-1865407

Jan 01, 2017 to Dec 31, 2017 • Filed on Nov 08, 2018

Organization ProfileN/A
PO Box 396Oriskany, NY 13424

(315) 736-0141

Siviq Scores

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

Liabilities / Assets

70th percentile

0.01x

Higher debt load relative to assets than 70% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Liabilities / Revenue

60th percentile

0.00x

Higher debt load relative to revenue than 60% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Net Margin

72nd percentile

14%

Higher net margin than 72% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Top Officer Pay

47th percentile

$0

Higher top officer pay than 47% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2017 filings • 501(c)5 • <$500k nonprofits • Source year 2017

Asset Growth

98th percentile

162%

Faster asset growth than 98% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Annualized from 2016 to 2017

Revenue Growth

35th percentile

-2.5%

Faster revenue growth than 35% of similar nonprofits.

2017 filings • 501(c)5 • <$500k nonprofits • Annualized from 2016 to 2017

Balance Sheet
Liabilities / Assets70th percentile

Assets

Up

$16,274

Up $10,069 (+162%) from 2016

Net Assets

Up

$16,072

Up $10,045 (+167%) from 2016

Liabilities

Up

$202

Up $24 (+13%) from 2016

Revenue And Expenses
Liabilities / Revenue60th percentileNet Margin72nd percentile

Revenue

Down

$42,350

Down $1,094 (-2.5%) from 2016

Expenses

Down

$36,460

Down $14,649 (-29%) from 2016

Net Income

Up

$5,890

Up $13,555 (+177%) from 2016

Historical Trend

Balance Sheet Trend

Asset Growth98th percentile

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

$80K$60K$40K$20K$0Assets 2010: $56,749Liabilities 2010: $1,499Net Assets 2010: $55,2502010Assets 2011: $59,020Liabilities 2011: $2,242Net Assets 2011: $56,7782011Assets 2012: $66,245Liabilities 2012: $1,136Net Assets 2012: $65,1092012Assets 2013: $43,450Liabilities 2013: $41Net Assets 2013: $43,4092013Assets 2014: $23,998Liabilities 2014: $173Net Assets 2014: $23,8252014Assets 2015: $15,774Liabilities 2015: $127Net Assets 2015: $15,6472015Assets 2016: $6,205Liabilities 2016: $178Net Assets 2016: $6,0272016Assets 2017: $16,274Liabilities 2017: $202Net Assets 2017: $16,0722017Assets 2018: $16,187Liabilities 2018: $163Net Assets 2018: $16,0242018Assets 2019: $12,286Net Assets 2019: $12,2862019Assets 2020: $21,274Net Assets 2020: $21,2742020Assets 2021: $14,004Liabilities 2021: $1,825Net Assets 2021: $12,1792021Assets 2022: $16,809Liabilities 2022: $2,199Net Assets 2022: $14,6102022

Highlighted filing

2017

Assets$16,274
Liabilities$202
Net Assets$16,072
Open 2017 Filing

Operations Trend

Revenue Growth35th percentile

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

$60K$40K$20K$0-$20KRevenue 2010: $43,065Expenses 2010: $31,721Net Income 2010: $11,3442010Revenue 2011: $41,839Expenses 2011: $40,311Net Income 2011: $1,5282011Revenue 2012: $42,775Expenses 2012: $34,444Net Income 2012: $8,3312012Revenue 2013: $42,069Expenses 2013: $37,015Net Income 2013: $5,0542013Revenue 2014: $42,886Expenses 2014: $41,540Net Income 2014: $1,3462014Revenue 2015: $47,309Expenses 2015: $54,412Net Income 2015: -$7,1032015Revenue 2016: $43,444Expenses 2016: $51,109Net Income 2016: -$7,6652016Revenue 2017: $42,350Expenses 2017: $36,460Net Income 2017: $5,8902017Revenue 2018: $36,475Expenses 2018: $35,443Net Income 2018: $1,0322018Revenue 2019: $35,121Expenses 2019: $39,943Net Income 2019: -$4,8222019Revenue 2020: $33,653Expenses 2020: $24,665Net Income 2020: $8,9882020Revenue 2021: $20,925Expenses 2021: $35,020Net Income 2021: -$14,0952021Revenue 2022: $21,319Expenses 2022: $18,888Net Income 2022: $2,4312022

Highlighted filing

2017

Revenue$42,350
Expenses$36,460
Net Income$5,890
Open 2017 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2017 to Dec 31, 2017
Signed
Nov 8, 2018
Return Version
2017v2.3
Gross Receipts
$42,350
Mission and Program Overview

Mission

The objective of this local shall be to carry out, on a local basis, the objectives stated in the american federation of state, county, and municipal employees constitution; and to safeguard the employment rights of all members who are in good standing of the oneida county sheriff's department employees local 1249.

Program Services

DescriptionGrantsExpenses
MEMBER LIFE AND DBL INSURANCE--
AMOUNTS USED TO HOLD AND ATTEND CONFERENCES AND MEETINGS DURING WHICH MEMBERS RECEIVE PROFESSIONAL DEVELOPMENT TRAINING AND SUPPORT.--
CHARITABLE CONTRIBUTIONS,ADVERTISING, PUBLICATIONS, AND MISCELLANEOUS ALLOCATIONS.--
Compensation and Service Providers
Top Officer Pay47th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
LUIS ROMANPresidentPT$0--
TODD WOODLANDTreasurerPT$0--
CHRISTOPHER HOFFMANSgt At Arms-$0--
JENNIFER PEZDEKRecording SePT$0--
WILLIAM HARTFinance SecrPT$0--
ROY LAUGHINGHOUSEVice PresidePT$0--
DANIEL NOONANChief StewarPT$0--
Filing and Contact Details

Filer

Filer Name
Oneida Co Sheriffs Dept Employees
EIN
14-1865407
Phone
3157360141
Address
PO BOX 396, ORISKANY, NY 13424

Signing Officer

Name
Todd Woodland
Title
Treasurer
Phone
3157360141
Signed
2018-11-08

Preparer

Firm
Gustafson & Wargo Cpas Llp
Address
430 COURT ST - STE 1E, UTICA, NY 13502
Preparer
Nancy a Beadle CPA
Phone
3157350705
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 8

“Income-other 1,020 total 1,020”

Form 990-ez, Part I, Line 16

“Expenses advertising 150 office expense 559 conferences & meetings 5,912 christmas party 1,599 donations 5,787 super bowl party 39 bank charges 70 interest 22 non-investment depreciation 452 total 14,590”

Form 990-ez, Part I, Line 20

“Transfer from ocdsba 5,000 transfer to ocdsba -845”

Form 990-ez, Part II, Line 24

“Accounts receivable 1,984 3,787 due to/from dsba 0 0 6,526 6,526 less accumulated depreciation 5,461 5,913 total 3,049 4,400”

Form 990-ez, Part II, Line 26

“Accounts payable and accrued expenses 178 202”

Form 990-ez, Part III

“The objective of this local shall be to carry out, on a local basis, the objectives stated in the american federation of state, county, and municipal employees constitution; and to safeguard the employment rights of all members who are in good standing of the oneida county sheriff's department employees local 1249.”

Raw XML Appendix133 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BenefitsPaidToOrForMembersAmt020420
IRS990EZ/BooksInCareOfDetail/PersonNm0TODD WOODLAND
IRS990EZ/BooksInCareOfDetail/PhoneNum03157360141
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 396
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0ORISKANY
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0NY
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd013424
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt03156
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt011874
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/ExcessOrDeficitForYearAmt05890
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt01450
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt06205
IRS990EZ/Form990TotalAssetsGrp/EOYAmt016274
IRS990EZ/GrossReceiptsAmt042350
IRS990EZ/GroupExemptionNum01381
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt041330
IRS990EZ/MethodOfAccountingAccrualInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt06027
IRS990EZ/NetAssetsOrFundBalancesEOYAmt016072
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt06027
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt016072
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt020.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt16.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt24.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt38.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt46.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt56.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt620.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0LUIS ROMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1TODD WOODLAND
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CHRISTOPHER HOFFMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JENNIFER PEZDEK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4WILLIAM HART
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5ROY LAUGHINGHOUSE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6DANIEL NOONAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2SGT AT ARMS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3RECORDING SE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4FINANCE SECR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5VICE PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6CHIEF STEWAR
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt03049
IRS990EZ/OtherAssetsTotalDetail/EOYAmt04400
IRS990EZ/OtherChangesInNetAssetsAmt04155
IRS990EZ/OtherExpensesTotalAmt014590
IRS990EZ/OtherRevenueTotalAmt01020
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0THE OBJECTIVE OF THIS LOCAL SHALL BE TO CARRY OUT, ON A LOCAL BASIS, THE OBJECTIVES STATED IN THE AMERICAN FEDERATION OF STATE, COUNTY, AND MUNICIPAL EMPLOYEES CONSTITUTION; AND TO SAFEGUARD THE EMPLOYMENT RIGHTS OF ALL MEMBERS WHO ARE IN GOOD STANDING OF THE ONEIDA COUNTY SHERIFF'S DEPARTMENT EMPLOYEES LOCAL 1249.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0MEMBER LIFE AND DBL INSURANCE
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1AMOUNTS USED TO HOLD AND ATTEND CONFERENCES AND MEETINGS DURING WHICH MEMBERS RECEIVE PROFESSIONAL DEVELOPMENT TRAINING AND SUPPORT.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt2CHARITABLE CONTRIBUTIONS,ADVERTISING, PUBLICATIONS, AND MISCELLANEOUS ALLOCATIONS.
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0NY
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt0178
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt0202
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt036460
IRS990EZ/TotalRevenueAmt042350
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0INCOME-OTHER 1,020 TOTAL 1,020
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES ADVERTISING 150 OFFICE EXPENSE 559 CONFERENCES & MEETINGS 5,912 CHRISTMAS PARTY 1,599 DONATIONS 5,787 SUPER BOWL PARTY 39 BANK CHARGES 70 INTEREST 22 NON-INVESTMENT DEPRECIATION 452 TOTAL 14,590
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TRANSFER FROM OCDSBA 5,000 TRANSFER TO OCDSBA -845
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3ACCOUNTS RECEIVABLE 1,984 3,787 DUE TO/FROM DSBA 0 0 6,526 6,526 LESS ACCUMULATED DEPRECIATION 5,461 5,913 TOTAL 3,049 4,400
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4ACCOUNTS PAYABLE AND ACCRUED EXPENSES 178 202
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5THE OBJECTIVE OF THIS LOCAL SHALL BE TO CARRY OUT, ON A LOCAL BASIS, THE OBJECTIVES STATED IN THE AMERICAN FEDERATION OF STATE, COUNTY, AND MUNICIPAL EMPLOYEES CONSTITUTION; AND TO SAFEGUARD THE EMPLOYMENT RIGHTS OF ALL MEMBERS WHO ARE IN GOOD STANDING OF THE ONEIDA COUNTY SHERIFF'S DEPARTMENT EMPLOYEES LOCAL 1249.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 8
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART I, LINE 20
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART II, LINE 24
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5FORM 990-EZ, PART III
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/PersonNm0TODD WOODLAND
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum03157360141
ReturnHeader/BusinessOfficerGrp/SignatureDt02018-11-08
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ONEIDA CO SHERIFFS DEPT EMPLOYEES
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0LOCAL NUMBER 1249 AFSCME
ReturnHeader/Filer/BusinessNameControlTxt0ONEI
ReturnHeader/Filer/EIN0141865407
ReturnHeader/Filer/PhoneNum03157360141
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 396
ReturnHeader/Filer/USAddress/CityNm0ORISKANY
ReturnHeader/Filer/USAddress/StateAbbreviationCd0NY
ReturnHeader/Filer/USAddress/ZIPCd013424
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId01E81A3E90BE6BB78E40EC1DBE26FB7953DFB717E
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0A32231636ADA5560F652860F3ED595CC7E7CFE91
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0209.217.211.98
ReturnHeader/FilingSecurityInformation/IPDt02018-11-12
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CS
ReturnHeader/FilingSecurityInformation/IPTm010:38:31
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0161263579
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0GUSTAFSON & WARGO CPAS LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0430 COURT ST - STE 1E
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0UTICA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd013502
ReturnHeader/PreparerPersonGrp/PhoneNum03157350705
ReturnHeader/PreparerPersonGrp/PreparationDt02018-11-08
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0NANCY A BEADLE CPA
ReturnHeader/ReturnTs02018-11-12T11:38:31-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-01-01
ReturnHeader/TaxPeriodEndDt02017-12-31
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2017 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$16,274
Liabilities
$202
Net assets
$16,072
Revenue
$42,350
Expenses
$36,460
Net income
$5,890
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Detailed filing. Detailed filing data is available for this year.$16.8$2.20$14.6$21.3$18.9$2.43
2021Detailed filing. Detailed filing data is available for this year.$14.0$1.83$12.2$20.9$35.0$14.1
2020Detailed filing. Detailed filing data is available for this year.$21.3$21.3$33.7$24.7$8.99
2019Detailed filing. Detailed filing data is available for this year.$12.3$12.3$35.1$39.9$4.82
2018Detailed filing. Detailed filing data is available for this year.$16.2$0.16$16.0$36.5$35.4$1.03
2017Detailed filing. Detailed filing data is available for this year.$16.3$0.20$16.1$42.4$36.5$5.89
2016Detailed filing. Detailed filing data is available for this year.$6.21$0.18$6.03$43.4$51.1$7.67
2015Detailed filing. Detailed filing data is available for this year.$15.8$0.13$15.6$47.3$54.4$7.10
2014Detailed filing. Detailed filing data is available for this year.$24.0$0.17$23.8$42.9$41.5$1.35
2013Detailed filing. Detailed filing data is available for this year.$43.5$0.04$43.4$42.1$37.0$5.05
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$66.2$1.14$65.1$42.8$34.4$8.33
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$59.0$2.24$56.8$41.8$40.3$1.53
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$56.7$1.50$55.3$43.1$31.7$11.3