Civic Intelligence

Aurora Sunrise Rotary Club

EIN 45-3561931 • 501(c)4 • Aurora, IL

Profile

Promoting social welfare, including the common good and general welfare of the community, related charitable purposes and the history values and philosophy of the rotary movement.

PO Box 5352Aurora, IL 60507

n/A

Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on the latest valid filing.

Source year 2023

Liabilities / Revenue

93rd percentile

0.67x

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

501(c)4 • <$500k nonprofits • Source year 2023

Net Margin

19th percentile

-27%

Higher net margin than 19% of similar nonprofits.

501(c)4 • <$500k nonprofits • Source year 2023

Top Officer Pay

89th percentile

$0

Higher top officer pay than 89% of similar nonprofits.

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

501(c)4 • <$500k nonprofits • Source year 2023

Asset Growth

9th percentile

-100%

Faster asset growth than 9% of similar nonprofits.

501(c)4 • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

48th percentile

-2.3%

Faster revenue growth than 48% of similar nonprofits.

501(c)4 • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $7,381 (-100%) from 2022

Liabilities

Down

$5,615

Down $5,130 (-48%) from 2022

Net Assets

Down

-$5,615

Down $2,251 (-67%) from 2022

Operations
Liabilities / Revenue93rd percentileNet Margin19th percentile

Revenue

Down

$8,395

Down $202 (-2.3%) from 2022

Expenses

Up

$10,646

Up $474 (+4.7%) from 2022

Net Income

Down

-$2,251

Down $676 (-43%) from 2022

Trend Graphs

Balance Sheet Trend

Asset Growth9th percentile

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

$15K$10K$5.0K$0-$5.0K-$10KAssets 2013: $9,437Liabilities 2013: $6,604Net Assets 2013: $2,8332013Assets 2014: $4,895Liabilities 2014: $6,240Net Assets 2014: -$1,3452014Assets 2015: $5,904Liabilities 2015: $7,919Net Assets 2015: -$2,0152015Assets 2016: $6,743Liabilities 2016: $8,709Net Assets 2016: -$1,9662016Assets 2017: $5,960Liabilities 2017: $8,609Net Assets 2017: -$2,6492017Assets 2018: $5,809Liabilities 2018: $7,855Net Assets 2018: -$2,0462018Assets 2019: $9,364Liabilities 2019: $10,890Net Assets 2019: -$1,5262019Assets 2020: $7,257Liabilities 2020: $9,580Net Assets 2020: -$2,3232020Assets 2021: $8,411Liabilities 2021: $10,200Net Assets 2021: -$1,7892021Assets 2022: $7,381Liabilities 2022: $10,745Net Assets 2022: -$3,3642022Assets 2023: $0Liabilities 2023: $5,615Net Assets 2023: -$5,6152023

Highlighted filing

2023

Assets$0
Liabilities$5,615
Net Assets-$5,615
Open 2023 Filing

Operations Trend

Revenue Growth48th percentile

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

$20K$10K$0-$10KRevenue 2013: $13,567Expenses 2013: $13,588Net Income 2013: -$212013Revenue 2014: $11,605Expenses 2014: $15,783Net Income 2014: -$4,1782014Revenue 2015: $12,433Expenses 2015: $13,103Net Income 2015: -$6702015Revenue 2016: $15,572Expenses 2016: $15,523Net Income 2016: $492016Revenue 2017: $16,824Expenses 2017: $17,507Net Income 2017: -$6832017Revenue 2018: $17,826Expenses 2018: $17,223Net Income 2018: $6032018Revenue 2019: $14,920Expenses 2019: $14,400Net Income 2019: $5202019Revenue 2020: $12,194Expenses 2020: $12,991Net Income 2020: -$7972020Revenue 2021: $11,492Expenses 2021: $10,958Net Income 2021: $5342021Revenue 2022: $8,597Expenses 2022: $10,172Net Income 2022: -$1,5752022Revenue 2023: $8,395Expenses 2023: $10,646Net Income 2023: -$2,2512023

Highlighted filing

2023

Revenue$8,395
Expenses$10,646
Net Income-$2,251
Open 2023 Filing

Filings

Most recent year

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

Open filing
Assets
$0
Liabilities
$5,615
Net assets
-$5,615
Revenue
$8,395
Expenses
$10,646
Net income
-$2,251
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$0.00$5.62$5.62$8.40$10.6$2.25
2022Detailed filing. Detailed filing data is available for this year.$7.38$10.7$3.36$8.60$10.2$1.58
2021Detailed filing. Detailed filing data is available for this year.$8.41$10.2$1.79$11.5$11.0$0.53
2020Detailed filing. Detailed filing data is available for this year.$7.26$9.58$2.32$12.2$13.0$0.80
2019Detailed filing. Detailed filing data is available for this year.$9.36$10.9$1.53$14.9$14.4$0.52
2018Detailed filing. Detailed filing data is available for this year.$5.81$7.86$2.05$17.8$17.2$0.60
2017Detailed filing. Detailed filing data is available for this year.$5.96$8.61$2.65$16.8$17.5$0.68
2016Detailed filing. Detailed filing data is available for this year.$6.74$8.71$1.97$15.6$15.5$0.05
2015Detailed filing. Detailed filing data is available for this year.$5.90$7.92$2.02$12.4$13.1$0.67
2014Detailed filing. Detailed filing data is available for this year.$4.90$6.24$1.35$11.6$15.8$4.18
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$9.44$6.60$2.83$13.6$13.6$0.02
Latest Filing Detail
Jump To
Filing Snapshot
Filing Period
Jul 1, 2022 to Jun 30, 2023
Signed
Nov 15, 2023
Return Version
2022v5.0
Gross Receipts
$8,395
Mission and Program Overview

Mission

Promoting social welfare, including the common good and general welfare of the community, related charitable purposes and the history values and philosophy of the rotary movement.

Program Services

DescriptionGrantsExpenses
COLLECTION AND DISTRIBUTION OF DUES AND PAYMENT OF CLUB EXPENSES-$10,361
Compensation and Service Providers
Top Officer Pay89th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
TOM CLARKDirector-$0--
SUE DEBOLTSecretary-$0--
JOEL HUFFMANYouth Exchange-$0--
RYAN IVEMEYERPresident-$0--
DAN HOWARDTreasurer-$0--
CHARLES SCHMALZDirector-$0--
JOE KOSNERPast President-$0--
Filing and Contact Details

Filer

Filer Name
Aurora Sunrise Rotary Club
EIN
45-3561931
Phone
6309064143
Address
PO BOX 5352, AURORA, IL 60507

Signing Officer

Name
Dan Howard
Title
Treasurer
Signed
2023-11-15
Discuss with paid preparer
Yes

Preparer

Firm
Mooney & Thomas PC
Address
2111 W Plum St Suite 201, Aurora, IL 60506
Preparer
Ralph T Mooney CPA
Phone
6308445272
Supplemental Narrative

Additional Explanations

Other Expenses.1001

“Advertising and Promotion $100”

Other Expenses.1

“CONFERENCES $4817”

Other Expenses.2

“DUES $3407”

Other Expenses.3

“SUBSCRIPTIONS $590”

Other Expenses.4

“SUPPLIES $529”

Other Expenses.5

“OPERATING EXPENSES $473”

Other Expenses.6

“BANK CHARGES $356”

Total Liabilities.1

“Current Liabilities - Beginning $10745 Current Liabilities - Ending $5615”

Raw XML Appendix163 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/BooksInCareOfDetail/PersonNm0DAN HOWARD
IRS990EZ/BooksInCareOfDetail/PhoneNum06306990974
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt01219 MARIEMONT RD
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0SUGAR GROVE
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IL
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd060554
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt07381
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt08395
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-2251
IRS990EZ/FeesAndOtherPymtToIndCntrctAmt0285
IRS990EZ/FinalReturnInd0X
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt07381
IRS990EZ/Form990TotalAssetsGrp/EOYAmt00
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrossReceiptsAmt08395
IRS990EZ/GroupExemptionNum00573
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0-3364
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0-5615
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0-3364
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0-5615
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt42.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt52.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt62.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0TOM CLARK
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1SUE DEBOLT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JOEL HUFFMAN
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3RYAN IVEMEYER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4DAN HOWARD
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5CHARLES SCHMALZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6JOE KOSNER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Youth Exchange
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Past President
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0true
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt010272
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROMOTING SOCIAL WELFARE, INCLUDING THE COMMON GOOD AND GENERAL WELFARE OF THE COMMUNITY, RELATED CHARITABLE PURPOSES AND THE HISTORY VALUES AND PHILOSOPHY OF THE ROTARY MOVEMENT.
IRS990EZ/PrintingPublicationsPostageAmt089
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0COLLECTION AND DISTRIBUTION OF DUES AND PAYMENT OF CLUB EXPENSES
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt010361
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt010745
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt05615
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt010646
IRS990EZ/TotalProgramServiceExpensesAmt010361
IRS990EZ/TotalRevenueAmt08395
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleN/AssetsDistributedInd0true
IRS990ScheduleN/AttorneyGeneralNotifiedInd0false
IRS990ScheduleN/BondLiabilitiesDischargedInd0false
IRS990ScheduleN/BondsOutstandingInd0false
IRS990ScheduleN/DirectorOfSuccessorInd0true
IRS990ScheduleN/EmployeeOfSuccessorInd0false
IRS990ScheduleN/LiabilitiesPaidInd0true
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/AssetsDistriOrExpnssPaidDesc0CLOSING OF BANK ACCOUNT
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/DistributionDt02023-06-30
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/EIN0366109792
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/FairMarketValueOfAssetAmt02561
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/IRCSectionTxt0501(c)4
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/MethodOfFMVDeterminationTxt0ACTUAL CASH AMOUNTS
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/AddressLine1Txt0PO BOX 5352
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/CityNm0AURORA
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/StateAbbreviationCd0IL
IRS990ScheduleN/LiquidationOfAssetsTableGrp/LiquidationOfAssetsDetail/USAddress/ZIPCd060507
IRS990ScheduleN/OwnerOfSuccessorInd0false
IRS990ScheduleN/ReceiveCompensationInd0false
IRS990ScheduleN/RequiredToNotifyAGInd0false
IRS990ScheduleN/SupplementalInformationDetail/ExplanationTxt0ALL OFFICERS, DIRECTORS AND TRUSTEES ARE RETAINING THEIR SAME TITLES IN THE NEW ORGANIZATION WITH NO NEW ADDITIONAL MEMBERS TO ADD.
IRS990ScheduleN/SupplementalInformationDetail/FormAndLineReferenceDesc0Sch N, Part III, Additional Information
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Advertising and Promotion $100
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1CONFERENCES $4817
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DUES $3407
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3SUBSCRIPTIONS $590
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4SUPPLIES $529
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5OPERATING EXPENSES $473
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6BANK CHARGES $356
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Current Liabilities - Beginning $10745 Current Liabilities - Ending $5615
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Other Expenses.1001
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Expenses.4
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Expenses.5
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Other Expenses.6
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Total Liabilities.1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/FederatedAssuranceLevelCd0FAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd02
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0DAN HOWARD
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Treasurer
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-11-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0AURORA SUNRISE ROTARY CLUB
ReturnHeader/Filer/BusinessNameControlTxt0AURO
ReturnHeader/Filer/EIN0453561931
ReturnHeader/Filer/PhoneNum06309064143
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 5352
ReturnHeader/Filer/USAddress/CityNm0AURORA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060507
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0363031423
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Mooney & Thomas PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02111 W Plum St Suite 201
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Aurora
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd060506
ReturnHeader/PreparerPersonGrp/PhoneNum06308445272
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Ralph T Mooney CPA
ReturnHeader/ReturnTs02023-11-15T09:21:22-08:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0DAN
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0HOWARD
ReturnHeader/TaxPeriodBeginDt02022-07-01
ReturnHeader/TaxPeriodEndDt02023-06-30
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.