Civic Intelligence

Franklin Police Sergeants Union

EIN 27-3737291 • 501(c)5 • Franklin, MA

Profile

The franklin police sergeants union works to secure fair compensation and a safe working environment for its members. The organization also works to promote fellowship among its members as well as the preserve the confidence of the citizens of franklin, massachusetts.

911 Panther WayFranklin, MA 02038

n/A

Siviq Scores

Precomputed percentiles relative to similar nonprofits. These scores are descriptive rather than judgmental.

Liabilities / Assets

58th percentile

0.00x

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

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

Liabilities / Revenue

60th percentile

0.00x

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

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

Net Margin

9th percentile

-37%

Higher net margin than 9% of similar nonprofits.

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

Top Officer Pay

48th percentile

$0

Higher top officer pay than 48% of similar nonprofits.

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

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

Asset Growth

22nd percentile

-13%

Faster asset growth than 22% of similar nonprofits.

501(c)5 • <$500k nonprofits • Annualized from 2021 to 2022

Revenue Growth

50th percentile

1.3%

Faster revenue growth than 50% of similar nonprofits.

501(c)5 • <$500k nonprofits • Annualized from 2021 to 2022

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$21,073

Down $3,026 (-13%) from 2021

Liabilities

Flat

$0

Flat from 2021

Net Assets

Down

$21,073

Down $3,026 (-13%) from 2021

Operations
Liabilities / Revenue60th percentileNet Margin9th percentile

Revenue

Up

$8,140

Up $106 (+1.3%) from 2021

Expenses

Up

$11,166

Up $6,816 (+157%) from 2021

Net Income

Down

-$3,026

Down $6,710 (-182%) from 2021

Trend Graphs

Balance Sheet Trend

Asset Growth22nd percentile

Grouped bars show assets, liabilities, and net assets across loaded filings.

$30K$20K$10K$0Assets 2016: $7,582Liabilities 2016: $0Net Assets 2016: $7,5822016Assets 2017: $15,380Liabilities 2017: $0Net Assets 2017: $15,3802017Assets 2018: $19,389Liabilities 2018: $0Net Assets 2018: $19,3892018Assets 2019: $23,152Liabilities 2019: $0Net Assets 2019: $23,1522019Assets 2020: $20,415Liabilities 2020: $0Net Assets 2020: $20,4152020Assets 2021: $24,099Liabilities 2021: $0Net Assets 2021: $24,0992021Assets 2022: $21,073Liabilities 2022: $0Net Assets 2022: $21,0732022

Highlighted filing

2022

Assets$21,073
Liabilities$0
Net Assets$21,073
Open 2022 Filing

Operations Trend

Revenue Growth50th percentile

Revenue, expenses, and net income by year, with the latest filing highlighted.

$30K$20K$10K$0-$10KRevenue 2016: $5,280Expenses 2016: $13,327Net Income 2016: -$8,0472016Revenue 2017: $12,321Expenses 2017: $4,523Net Income 2017: $7,7982017Revenue 2018: $11,849Expenses 2018: $7,840Net Income 2018: $4,0092018Revenue 2019: $21,345Expenses 2019: $17,582Net Income 2019: $3,7632019Revenue 2020: $8,981Expenses 2020: $11,718Net Income 2020: -$2,7372020Revenue 2021: $8,034Expenses 2021: $4,350Net Income 2021: $3,6842021Revenue 2022: $8,140Expenses 2022: $11,166Net Income 2022: -$3,0262022

Highlighted filing

2022

Revenue$8,140
Expenses$11,166
Net Income-$3,026
Open 2022 Filing

Filings

Most recent year

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

Open filing
Assets
$21,073
Liabilities
$0
Net assets
$21,073
Revenue
$8,140
Expenses
$11,166
Net income
-$3,026
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Detailed filing. Detailed filing data is available for this year.$21.1$0.00$21.1$8.14$11.2$3.03
2021Detailed filing. Detailed filing data is available for this year.$24.1$0.00$24.1$8.03$4.35$3.68
2020Detailed filing. Detailed filing data is available for this year.$20.4$0.00$20.4$8.98$11.7$2.74
2019Detailed filing. Detailed filing data is available for this year.$23.2$0.00$23.2$21.3$17.6$3.76
2018Detailed filing. Detailed filing data is available for this year.$19.4$0.00$19.4$11.8$7.84$4.01
2017Detailed filing. Detailed filing data is available for this year.$15.4$0.00$15.4$12.3$4.52$7.80
2016Detailed filing. Detailed filing data is available for this year.$7.58$0.00$7.58$5.28$13.3$8.05
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jul 1, 2021 to Jun 30, 2022
Signed
Nov 15, 2022
Return Version
2021v4.2
Gross Receipts
$8,140
Mission and Program Overview

Mission

The franklin police sergeants union works to secure fair compensation and a safe working environment for its members. The organization also works to promote fellowship among its members as well as the preserve the confidence of the citizens of franklin, massachusetts.

Program Services

DescriptionGrantsExpenses
TO SECURE FAIR COMPENSATION AND A SAFE WORKING ENVIRONMENT FOR ITS MEMBERS AS WELL AS TO PROMOTE CONFIDENCE AND COMMUNITY AWARENESS WITH THE CITIZENS OF FRANKLIN, MASSACHUSETTS.$0$0
Compensation and Service Providers
Top Officer Pay48th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
DANIEL SMITHPresident-$0--
ROBERT MACQUARRIETreasurer/Secretary-$0--
Filing and Contact Details

Filer

Filer Name
Franklin Police Sergeants Union
EIN
27-3737291
Phone
6173595258
Address
911 PANTHER WAY, FRANKLIN, MA 02038

Signing Officer

Name
Robert Macquarrie
Title
Treasurer
Phone
6173595258
Signed
2022-11-15
Discuss with paid preparer
Yes

Preparer

Firm
Auerr Zajac & Associates Llp
Address
29 DEAN AVENUE, FRANKLIN, MA 02038
Preparer
Kevin a Auerr CPA
Phone
5085281305
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 16 - Other Expenses

“Description: donations. Amount: 3,975. Description: office expense. Amount: 109. Description: flowers for funerals. Amount: 100. Description: training. Amount: 1,082. Total to form 990-ez, line 16: 5,266.”

Raw XML Appendix101 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/ActivitiesNotPreviouslyRptInd00
IRS990EZ/BooksInCareOfDetail/PersonNm0ROBERT MACQUARRIE
IRS990EZ/BooksInCareOfDetail/PhoneNum06173595258
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0911 PANTHER WAY
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0FRANKLIN
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0MA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd002038
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt024099
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt021073
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd00
IRS990EZ/ContributionsGiftsGrantsEtcAmt02230
IRS990EZ/DirectIndirectPltclExpendAmt00
IRS990EZ/DonorAdvisedFndsInd00
IRS990EZ/ExcessOrDeficitForYearAmt0-3026
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt05900
IRS990EZ/ForeignFinancialAccountInd00
IRS990EZ/ForeignOfficeInd00
IRS990EZ/Form990TotalAssetsGrp/BOYAmt024099
IRS990EZ/Form990TotalAssetsGrp/EOYAmt021073
IRS990EZ/GrossReceiptsAmt08140
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InfoInScheduleOPartVInd0X
IRS990EZ/MadeLoansToFromOfficersInd00
IRS990EZ/MembershipDuesAmt05910
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt024099
IRS990EZ/NetAssetsOrFundBalancesEOYAmt021073
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt024099
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt021073
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt01.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0DANIEL SMITH
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1ROBERT MACQUARRIE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1TREASURER/SECRETARY
IRS990EZ/OperateHospitalInd00
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd00
IRS990EZ/OrganizationHadUBIInd00
IRS990EZ/OtherChangesInNetAssetsAmt00
IRS990EZ/OtherExpensesTotalAmt05266
IRS990EZ/PoliticalCampaignActyInd00
IRS990EZ/PrimaryExemptPurposeTxt0THE FRANKLIN POLICE SERGEANTS UNION WORKS TO SECURE FAIR COMPENSATION AND A SAFE WORKING ENVIRONMENT FOR ITS MEMBERS. THE ORGANIZATION ALSO WORKS TO PROMOTE FELLOWSHIP AMONG ITS MEMBERS AS WELL AS THE PRESERVE THE CONFIDENCE OF THE CITIZENS OF FRANKLIN, MASSACHUSETTS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0TO SECURE FAIR COMPENSATION AND A SAFE WORKING ENVIRONMENT FOR ITS MEMBERS AS WELL AS TO PROMOTE CONFIDENCE AND COMMUNITY AWARENESS WITH THE CITIZENS OF FRANKLIN, MASSACHUSETTS.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt00
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt00
IRS990EZ/ProhibitedTaxShelterTransInd00
IRS990EZ/RelatedOrganizationCtrlEntInd00
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0MA
IRS990EZ/SubjectToProxyTaxInd00
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd00
IRS990EZ/TotalExpensesAmt011166
IRS990EZ/TotalRevenueAmt08140
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0DESCRIPTION: DONATIONS. AMOUNT: 3,975. DESCRIPTION: OFFICE EXPENSE. AMOUNT: 109. DESCRIPTION: FLOWERS FOR FUNERALS. AMOUNT: 100. DESCRIPTION: TRAINING. AMOUNT: 1,082. TOTAL TO FORM 990-EZ, LINE 16: 5,266.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 16 - OTHER EXPENSES
TransferPrsnlBnftContractsDecl/DeclarationDesc0THE ORGANIZATION DID NOT, DURING THE YEAR, RECEIVE ANY FUNDS, DIRECTLY,OR INDIRECTLY, TO PAY PREMIUMS ON A PERSONAL BENEFIT CONTRACT.THE ORGANIZATION, DID NOT, DURING THE YEAR, PAY ANY PREMIUMS, DIRECTLY,OR INDIRECTLY, ON A PERSONAL BENEFIT CONTRACT.
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd03
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0ROBERT MACQUARRIE
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06173595258
ReturnHeader/BusinessOfficerGrp/SignatureDt02022-11-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0FRANKLIN POLICE SERGEANTS UNION
ReturnHeader/Filer/BusinessNameControlTxt0FRAN
ReturnHeader/Filer/EIN0273737291
ReturnHeader/Filer/PhoneNum06173595258
ReturnHeader/Filer/USAddress/AddressLine1Txt0911 PANTHER WAY
ReturnHeader/Filer/USAddress/CityNm0FRANKLIN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MA
ReturnHeader/Filer/USAddress/ZIPCd002038
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0043125991
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0AUERR ZAJAC & ASSOCIATES LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt029 DEAN AVENUE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0FRANKLIN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd002038
ReturnHeader/PreparerPersonGrp/PhoneNum05085281305
ReturnHeader/PreparerPersonGrp/PreparationDt02022-11-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KEVIN A AUERR CPA
ReturnHeader/ReturnTs02022-11-15T10:47:47-06:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0ROBERT
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0MACQUARRIE
ReturnHeader/TaxPeriodBeginDt02021-07-01
ReturnHeader/TaxPeriodEndDt02022-06-30
ReturnHeader/TaxYr02021

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 501(c)5 • <$500k nonprofits