Civic Intelligence

Rotary International

990EZ • Fiscal year 2018 • EIN 31-0943018

Jul 01, 2017 to Jun 30, 2018 • Filed on May 13, 2019

Organization ProfileWWW.GAHANNAROTARY.ORG
Pobox 30786Gahanna, OH 43230-0786

(614) 864-2222

Siviq Scores

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

Liabilities / Assets

83rd percentile

0.21x

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

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

Liabilities / Revenue

76th percentile

0.08x

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

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

Net Margin

18th percentile

-17%

Higher net margin than 18% of similar nonprofits.

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

Top Officer Pay

86th percentile

$0

Higher top officer pay than 86% of similar nonprofits.

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

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

Asset Growth

11th percentile

-30%

Faster asset growth than 11% of similar nonprofits.

2018 filings • 501(c)4 • <$500k nonprofits • Annualized from 2017 to 2018

Revenue Growth

32nd percentile

-9.3%

Faster revenue growth than 32% of similar nonprofits.

2018 filings • 501(c)4 • <$500k nonprofits • Annualized from 2017 to 2018

Balance Sheet
Liabilities / Assets83rd percentile

Assets

Down

$11,980

Down $5,199 (-30%) from 2017

Net Assets

Down

$9,458

Down $5,199 (-35%) from 2017

Liabilities

Flat

$2,522

Flat from 2017

Revenue And Expenses
Liabilities / Revenue76th percentileNet Margin18th percentile

Revenue

Down

$30,000

Down $3,078 (-9.3%) from 2017

Expenses

Down

$35,196

Down $8,987 (-20%) from 2017

Net Income

Up

-$5,196

Up $5,909 (+53%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth11th percentile

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

$80K$60K$40K$20K$0Assets 2010: $34,294Net Assets 2010: $34,2942010Assets 2011: $34,068Net Assets 2011: $34,0682011Assets 2012: $31,076Net Assets 2012: $31,0762012Assets 2013: $72,384Liabilities 2013: $40,639Net Assets 2013: $31,7452013Assets 2014: $28,742Liabilities 2014: $1,182Net Assets 2014: $27,5602014Assets 2015: $36,861Liabilities 2015: $2,332Net Assets 2015: $34,5292015Assets 2016: $28,094Liabilities 2016: $2,332Net Assets 2016: $25,7622016Assets 2017: $17,179Liabilities 2017: $2,522Net Assets 2017: $14,6572017Assets 2018: $11,980Liabilities 2018: $2,522Net Assets 2018: $9,4582018Assets 2019: $3,999Liabilities 2019: $2,522Net Assets 2019: $1,4772019Assets 2020: $13,692Net Assets 2020: $13,6922020Assets 2021: $17,918Net Assets 2021: $17,9182021Assets 2022: $20,094Net Assets 2022: $20,0942022Assets 2023: $18,202Net Assets 2023: $18,2022023

Highlighted filing

2018

Assets$11,980
Liabilities$2,522
Net Assets$9,458
Open 2018 Filing

Operations Trend

Revenue Growth32nd percentile

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

$60K$40K$20K$0-$20KRevenue 2010: $44,524Expenses 2010: $34,719Net Income 2010: $9,8052010Revenue 2011: $52,750Expenses 2011: $52,976Net Income 2011: -$2262011Revenue 2012: $35,535Expenses 2012: $39,897Net Income 2012: -$4,3622012Revenue 2013: $33,127Expenses 2013: $32,459Net Income 2013: $6682013Revenue 2014: $29,524Expenses 2014: $33,708Net Income 2014: -$4,1842014Revenue 2015: $33,033Expenses 2015: $26,064Net Income 2015: $6,9692015Revenue 2016: $28,027Expenses 2016: $36,749Net Income 2016: -$8,7222016Revenue 2017: $33,078Expenses 2017: $44,183Net Income 2017: -$11,1052017Revenue 2018: $30,000Expenses 2018: $35,196Net Income 2018: -$5,1962018Revenue 2019: $30,572Expenses 2019: $38,553Net Income 2019: -$7,9812019Revenue 2020: $34,691Expenses 2020: $22,476Net Income 2020: $12,2152020Revenue 2021: $19,698Expenses 2021: $15,473Net Income 2021: $4,2252021Revenue 2022: $25,432Expenses 2022: $23,256Net Income 2022: $2,1762022Revenue 2023: $20,431Expenses 2023: $22,325Net Income 2023: -$1,8942023

Highlighted filing

2018

Revenue$30,000
Expenses$35,196
Net Income-$5,196
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
May 13, 2019
Return Version
2017v2.3
Gross Receipts
$37,272
Mission and Program Overview

Mission

To provide humanitarian service, encourage high ethical standards in all vocations, and help build goodwill and peace in the world.

Program Services

DescriptionGrantsExpenses
HOSTED WEEKLY LOCAL MEETINGS FOR APPROX 55 MEMBERS AND GUESTS AND SENT REPRESENTATIVES TO DISTRICT AND INTERNATIONAL EVENTS TO FOSTER AND CO-ORDINATE COMMUNITY SERVICE AS DESCRIBED AS THE PRIMARY EXEMPT PURPOSE.$4,685$34,974
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
RICK TREJOSecretary-$0--
MICHAEL FISHERPast Preside-$0--
CRAIG TRUAXPresident-$0--
PAUL WESTENHEFFERPresident El-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Rose Sale$16,200$16,200$7,272$8,928
Total Events$16,200$16,200$7,272$8,928
Filing and Contact Details

Filer

Filer Name
Rotary International
EIN
31-0943018
Phone
6148642222
Address
POBOX 30786, GAHANNA, OH 43230-0786

Signing Officer

Name
Rick Trejo
Title
Secretary
Signed
2019-05-13
Supplemental Narrative

Additional Explanations

Form 990-ez, Part I, Line 10

“Rotary district 6690 program support 1,500 po box 30786 gahanna oh 43230 rotary international program support 4,125 po box 30786 gahanna oh 43230”

Form 990-ez, Part I, Line 16

“Expenses promotional expenses 176 membership supplies 26 bank fees 99 misc 98 web fees 25 convention & bd meetings 1,447 international convention 2,074 lunch & group meeting events 20,765 total 24,710”

Form 990-ez, Part II, Line 26

“Due to related foundation 2,522 2,522”

Form 990-ez, Part III

“To provide humanitarian service, encourage high ethical standards in all vocations, and help build goodwill and peace in the world.”

Raw XML Appendix116 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/PersonNm0RICK TREJO
IRS990EZ/BooksInCareOfDetail/PhoneNum06148642222
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 30786
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0GAHANNA
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd043230
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt017176
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt011980
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-5196
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt017176
IRS990EZ/Form990TotalAssetsGrp/EOYAmt011980
IRS990EZ/FundraisingGrossIncomeAmt016200
IRS990EZ/GrantsAndSimilarAmountsPaidAmt010310
IRS990EZ/GrossReceiptsAmt037272
IRS990EZ/InfoInScheduleOPartIIIInd0X
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt09800
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt014654
IRS990EZ/NetAssetsOrFundBalancesEOYAmt09458
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt014654
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt09458
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0RICK TREJO
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1MICHAEL FISHER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2CRAIG TRUAX
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3PAUL WESTENHEFFER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0SECRETARY
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PAST PRESIDE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3PRESIDENT EL
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt024710
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0TO PROVIDE HUMANITARIAN SERVICE, ENCOURAGE HIGH ETHICAL STANDARDS IN ALL VOCATIONS, AND HELP BUILD GOODWILL AND PEACE IN THE WORLD.
IRS990EZ/PrintingPublicationsPostageAmt0176
IRS990EZ/ProgramServiceRevenueAmt011272
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0HOSTED WEEKLY LOCAL MEETINGS FOR APPROX 55 MEMBERS AND GUESTS AND SENT REPRESENTATIVES TO DISTRICT AND INTERNATIONAL EVENTS TO FOSTER AND CO-ORDINATE COMMUNITY SERVICE AS DESCRIBED AS THE PRIMARY EXEMPT PURPOSE.
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt04685
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt034974
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SpecialEventsDirectExpensesAmt07272
IRS990EZ/SpecialEventsNetIncomeLossAmt08928
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt02522
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt02522
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt035196
IRS990EZ/TotalProgramServiceExpensesAmt034974
IRS990EZ/TotalRevenueAmt030000
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0WWW.GAHANNAROTARY.ORG
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt07272
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0ROSE SALE
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt016200
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt016200
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt016200
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt016200
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt08928
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt07272
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt07272
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0ROTARY DISTRICT 6690 PROGRAM SUPPORT 1,500 PO BOX 30786 GAHANNA OH 43230 ROTARY INTERNATIONAL PROGRAM SUPPORT 4,125 PO BOX 30786 GAHANNA OH 43230
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1EXPENSES PROMOTIONAL EXPENSES 176 MEMBERSHIP SUPPLIES 26 BANK FEES 99 MISC 98 WEB FEES 25 CONVENTION & BD MEETINGS 1,447 INTERNATIONAL CONVENTION 2,074 LUNCH & GROUP MEETING EVENTS 20,765 TOTAL 24,710
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2DUE TO RELATED FOUNDATION 2,522 2,522
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3TO PROVIDE HUMANITARIAN SERVICE, ENCOURAGE HIGH ETHICAL STANDARDS IN ALL VOCATIONS, AND HELP BUILD GOODWILL AND PEACE IN THE WORLD.
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990-EZ, PART I, LINE 10
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990-EZ, PART I, LINE 16
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990-EZ, PART II, LINE 26
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990-EZ, PART III
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/PersonNm0RICK TREJO
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0SECRETARY
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-05-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ROTARY INTERNATIONAL
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0GAHANNA ROTARY CLUB
ReturnHeader/Filer/BusinessNameControlTxt0ROTA
ReturnHeader/Filer/EIN0310943018
ReturnHeader/Filer/PhoneNum06148642222
ReturnHeader/Filer/USAddress/AddressLine1Txt0POBOX 30786
ReturnHeader/Filer/USAddress/CityNm0GAHANNA
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd0432300786
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId0091321D71D431E33C649433EEFEC1B02C3D25610
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0091321D71D431E33C649433EEFEC1B02C3D25610
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt0209.59.239.156
ReturnHeader/FilingSecurityInformation/IPDt02019-05-15
ReturnHeader/FilingSecurityInformation/IPTimezoneCd0CD
ReturnHeader/FilingSecurityInformation/IPTm009:54:41
ReturnHeader/ReturnTs02019-05-15T09:54:41-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02017-07-01
ReturnHeader/TaxPeriodEndDt02018-06-30
ReturnHeader/TaxYr02017

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$11,980
Liabilities
$2,522
Net assets
$9,458
Revenue
$30,000
Expenses
$35,196
Net income
-$5,196
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023Detailed filing. Detailed filing data is available for this year.$18.2$18.2$20.4$22.3$1.89
2022Detailed filing. Detailed filing data is available for this year.$20.1$20.1$25.4$23.3$2.18
2021Detailed filing. Detailed filing data is available for this year.$17.9$17.9$19.7$15.5$4.23
2020Detailed filing. Detailed filing data is available for this year.$13.7$13.7$34.7$22.5$12.2
2019Detailed filing. Detailed filing data is available for this year.$4.00$2.52$1.48$30.6$38.6$7.98
2018Detailed filing. Detailed filing data is available for this year.$12.0$2.52$9.46$30.0$35.2$5.20
2017Detailed filing. Detailed filing data is available for this year.$17.2$2.52$14.7$33.1$44.2$11.1
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$28.1$2.33$25.8$28.0$36.7$8.72
2015Detailed filing. Detailed filing data is available for this year.$36.9$2.33$34.5$33.0$26.1$6.97
2014Detailed filing. Detailed filing data is available for this year.$28.7$1.18$27.6$29.5$33.7$4.18
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$72.4$40.6$31.7$33.1$32.5$0.67
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$31.1$31.1$35.5$39.9$4.36
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$34.1$34.1$52.8$53.0$0.23
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$34.3$34.3$44.5$34.7$9.81