Civic Intelligence

Upper Arlington Rotary Charitable Foundation C/O Andrew Livingston

990 • Fiscal year 2018 • EIN 31-1289089

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

Organization ProfileN/A
1704 Sundridge DrColumbus, OH 43221

(614) 459-3182

Siviq Scores

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

Liabilities / Assets

57th percentile

0.00x

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

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

22nd percentile

-12%

Higher net margin than 22% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

41st percentile

-2.2%

Faster asset growth than 41% of similar nonprofits.

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

Revenue Growth

60th percentile

7.5%

Faster revenue growth than 60% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets57th percentile

Assets

Down

$336,025

Down $7,718 (-2.2%) from 2017

Net Assets

Down

$336,025

Down $7,718 (-2.2%) from 2017

Liabilities

Flat

$0

Flat from 2017

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin22nd percentile

Revenue

Up

$147,165

Up $10,228 (+7.5%) from 2017

Expenses

Up

$164,164

Up $16,483 (+11%) from 2017

Net Income

Down

-$16,999

Down $6,255 (-58%) from 2017

Historical Trend

Balance Sheet Trend

Asset Growth41st percentile

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

$400K$300K$200K$100K$0Assets 2011: $251,263Liabilities 2011: $0Net Assets 2011: $251,2632011Assets 2012: $233,933Liabilities 2012: $0Net Assets 2012: $233,9332012Assets 2013: $300,628Liabilities 2013: $0Net Assets 2013: $300,6282013Assets 2014: $322,513Liabilities 2014: $0Net Assets 2014: $322,5132014Assets 2015: $312,109Liabilities 2015: $0Net Assets 2015: $312,1092015Assets 2016: $324,371Liabilities 2016: $0Net Assets 2016: $324,3712016Assets 2017: $343,743Liabilities 2017: $0Net Assets 2017: $343,7432017Assets 2018: $336,025Liabilities 2018: $0Net Assets 2018: $336,0252018Assets 2019: $329,956Liabilities 2019: $0Net Assets 2019: $329,9562019Assets 2020: $263,159Liabilities 2020: $4,300Net Assets 2020: $258,8592020Assets 2021: $341,822Liabilities 2021: $0Net Assets 2021: $341,8222021Assets 2022: $311,519Liabilities 2022: $0Net Assets 2022: $311,5192022Assets 2023: $343,133Liabilities 2023: $0Net Assets 2023: $343,1332023Assets 2024: $297,292Liabilities 2024: $0Net Assets 2024: $297,2922024Assets 2025: $288,941Liabilities 2025: $0Net Assets 2025: $288,9412025

Highlighted filing

2018

Assets$336,025
Liabilities$0
Net Assets$336,025
Open 2018 Filing

Operations Trend

Revenue Growth60th percentile

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

$300K$200K$100K$0-$100KRevenue 2011: $118,882Expenses 2011: $72,707Net Income 2011: $46,1752011Revenue 2012: $126,674Expenses 2012: $144,004Net Income 2012: -$17,3302012Revenue 2013: $170,312Expenses 2013: $103,617Net Income 2013: $66,6952013Revenue 2014: $155,716Expenses 2014: $133,831Net Income 2014: $21,8852014Revenue 2015: $184,073Expenses 2015: $192,376Net Income 2015: -$8,3032015Revenue 2016: $150,942Expenses 2016: $129,768Net Income 2016: $21,1742016Revenue 2017: $136,937Expenses 2017: $147,681Net Income 2017: -$10,7442017Revenue 2018: $147,165Expenses 2018: $164,164Net Income 2018: -$16,9992018Revenue 2019: $157,555Expenses 2019: $166,419Net Income 2019: -$8,8642019Revenue 2020: $115,151Expenses 2020: $179,715Net Income 2020: -$64,5642020Revenue 2021: $200,533Expenses 2021: $164,165Net Income 2021: $36,3682021Revenue 2022: $121,506Expenses 2022: $138,728Net Income 2022: -$17,2222022Revenue 2023: $194,357Expenses 2023: $175,371Net Income 2023: $18,9862023Revenue 2024: $133,872Expenses 2024: $190,075Net Income 2024: -$56,2032024Revenue 2025: $118,605Expenses 2025: $137,444Net Income 2025: -$18,8392025

Highlighted filing

2018

Revenue$147,165
Expenses$164,164
Net Income-$16,999
Open 2018 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2017 to Jun 30, 2018
Signed
Jun 18, 2019
Return Version
2017v2.3
Gross Receipts
$182,310
Mission and Program Overview

Mission

To encourage and foster the service ideal of service above self. The foundation supports the five avenues of service, club service, community service, international service, vocational service and new generations.

Balance Sheet Detail
LineBeginningEndChange
Assets
Investments Other Securities$280,284$240,703▼ $39,581
Pledges and Grants Receivable$58,447$90,694▲ $32,247
Cash and Non-Interest-Bearing Accounts$5,012$4,628▼ $384
Total Assets$343,743$336,025▼ $7,718
Liabilities
Total Liabilities$0$0→ $0
Net Assets / Fund Balance
Unrestricted Net Assets$276,313$265,185▼ $11,128
Temporarily Rstr Net Assets$67,430$70,840▲ $3,410
Total Net Assets Fund Balance$343,743$336,025▼ $7,718
Total Liabilities and Net Assets / Fund Balance$343,743$336,025▼ $7,718

Asset Categories

AssetBook ValueDepreciationBasis
Other Securities$70,840--

Endowment Activity

PeriodBeginningContrib.Gain/LossOther UsesEnd
2017$67,430-▲ $3,766-$70,840
2016$61,524-▲ $6,221-$67,430
2015$59,470-▲ $2,346-$61,524
2014$58,705-▲ $1,057-$59,470
2013$50,764$409▲ $7,532-$58,705
Compensation and Service Providers
Top Officer Pay76th percentile

Board Members and Trustees

NameTitle
Richard SimpsonChairman
Allison RussoTrustee
Bill CloydTrustee
Bill MielkeTrustee
Steve LichtblauTrustee
Yvonne PerottiTrustee
Steve RishSecretary
Andrew LivingstonTreasurer
Revenue and Support

Revenue Composition

Contributions and Grants
$109,689
Program Service Revenue
$0
Investment Income
$4,479
Other Revenue
$32,997
All Other Contributions
$109,689
Change in Net Assets
$-16,999
Expenses and Functional Allocation

Major Expense Lines

Line ItemAmount
Grants and Similar Amounts Paid$160,115
Other Expenses$4,049
Professional Fundraising Fees$0
Salaries, Compensation, and Employee Benefits$0
Total Fundraising Expense$0

Functional Expense Allocation

Line ItemProgramManagementFundraisingTotal
Grants to Domestic Orgs$160,115--$160,115
Fees for Service Investment Mgmnt Fees-$2,219-$2,219
Fees for Services Accounting-$990-$990
Office Expenses-$740-$740
Other Expenses-$100-$100
Total Functional Expenses$160,115$4,049$0$164,164
International Activity

Grant and Assistance Recipients

RecipientLocationCategoryPurposeAmount
Mayan Families FoundationSantee, CA--$71,448
The Upper Arlington Community FoundColumbus, OH--$34,150
Big Brothersbig SistersColumbus, OH--$7,357
Ywca of ColumbusColumbus, OH--$6,440
Windermere Elementary PtoUpper Arlington, OH--$6,400
Upper Arlington Education FoundatioColumbus, OH--$5,020
Fundraising, Events, and Gaming
Fundraising activities
Yes
Gaming activities
No
Professional fundraiser used
No

Fundraising and Gaming Totals

Line ItemAmount
Fundraising Gross Income$68,142
Fundraising Direct Expenses$35,145
Professional Fundraising Fees$0

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Dinner/auction$68,142$68,142$4,752$63,390
Total Events$68,142$68,142$35,145$32,997
Political and Lobbying Activity
Political campaign activity
No
Lobbying activity
No
Subject to proxy tax
No
Governance and Compliance

Governance Checklist

Compiled or reviewed by an accountant
No
Business relationship with family members
No
Business relationship with organization members
No
Material changes to governing documents
No
Compensation from other sources disclosed
No
CEO compensation reviewed
No
Other officer compensation reviewed
No
Conflict-of-interest policy
No
Audited financial statements prepared
No
Key decisions subject to board approval
No
Management duties delegated
No

Governance Explanations

Form 990, Page 6, Part VI, Line 8B

“Committees are not authorized to act on behalf of the board”

Form 990, Page 6, Part VI, Line 11B

“Tax returns are submitted to the board for their review and approval prior to filing”

Form 990, Page 6, Part VI, Line 19

“Governing document are made available upon request”

Filing and Contact Details

Filer

Filer Name
Upper Arlington Rotary Charitable
EIN
31-1289089
Phone
6144593182
Address
1704 SUNDRIDGE DR, COLUMBUS, OH 43221

Signing Officer

Name
Andrew Livingston
Title
Treasurer
Phone
6144803066
Signed
2019-06-18
Discuss with paid preparer
Yes

Organization Details

Principal Officer
Andrew Livingston
Formed
1972
Legal Domicile
Oh
Voting Board Members
8
Independent Board Members
8
Employees
0

Preparer

Firm
Mark P Murphy & Associates CPA
Address
1051 OLD HENDERSON RD STE A, COLUMBUS, OH 43220
Preparer
Mark P Murphy
Phone
6144593182
Supplemental Narrative

Additional Explanations

Form 990, Page 1, Item B

“Filing amended return due to receipt of addition information subsequent to filing date. Reported increase in income from fundraising activities of 32,997 not reported on original return.”

Form 990, Part XII

“Line 1 - the organization uses the modified accrual method of accounting”

Financial Statement Notes

Schedule D, Page 2, Part V, Line 4

“Designated for special needs of the community as determined by the board”

Raw XML AppendixShowing 400 of 419 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/AccountantCompileOrReviewInd0false
IRS990/ActivitiesConductedPrtshpInd0false
IRS990/ActivityOrMissionDesc0TO ENCOURAGE AND FOSTER THE SERVICE IDEAL OF SERVICE ABOVE SELF. THE FOUNDATION SUPPORTS THE FIVE AVENUES OF SERVICE, CLUB SERVICE, COMMUNITY SERVICE, INTERNATIONAL SERVICE, VOCATIONAL SERVICE AND NEW GENERATIONS.
IRS990/AllOtherContributionsAmt0109689
IRS990/AmendedReturnInd0X
IRS990/BooksInCareOfDetail/PersonNm0ANDREW LIVINGSTON
IRS990/BooksInCareOfDetail/PhoneNum06144593182
IRS990/BooksInCareOfDetail/USAddress/AddressLine1Txt01704 SUNDRIDGE DRIVE
IRS990/BooksInCareOfDetail/USAddress/CityNm0COLUMBUS
IRS990/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OH
IRS990/BooksInCareOfDetail/USAddress/ZIPCd043221
IRS990/BusinessRlnWithFamMemInd0false
IRS990/BusinessRlnWithOfficerEntInd0false
IRS990/BusinessRlnWithOrgMemInd0false
IRS990/CashNonInterestBearingGrp/BOYAmt05012
IRS990/CashNonInterestBearingGrp/EOYAmt04628
IRS990/ChangeToOrgDocumentsInd0false
IRS990/CollectionsOfArtInd0false
IRS990/CompensationFromOtherSrcsInd0false
IRS990/CompensationProcessCEOInd0false
IRS990/CompensationProcessOtherInd0false
IRS990/ConflictOfInterestPolicyInd0false
IRS990/ConservationEasementsInd0false
IRS990/ConsolidatedAuditFinclStmtInd0false
IRS990/CreditCounselingInd0false
IRS990/CYBenefitsPaidToMembersAmt00
IRS990/CYContributionsGrantsAmt0109689
IRS990/CYGrantsAndSimilarPaidAmt0160115
IRS990/CYInvestmentIncomeAmt04479
IRS990/CYOtherExpensesAmt04049
IRS990/CYOtherRevenueAmt032997
IRS990/CYProgramServiceRevenueAmt00
IRS990/CYRevenuesLessExpensesAmt0-16999
IRS990/CYSalariesCompEmpBnftPaidAmt00
IRS990/CYTotalExpensesAmt0164164
IRS990/CYTotalFundraisingExpenseAmt00
IRS990/CYTotalProfFndrsngExpnsAmt00
IRS990/CYTotalRevenueAmt0147165
IRS990/DecisionsSubjectToApprovaInd0false
IRS990/DeductibleArtContributionInd0false
IRS990/DeductibleNonCashContriInd0false
IRS990/DelegationOfMgmtDutiesInd0false
IRS990/Desc0THE FOUNDATION PROVIDES FUNDING TO HELP OTHER CHARITABLE ORGANIZATIONS AND COMMUNITY SERVICE GROUPS SUPPORT EDUCATION AND ECONOMIC ASSISTANCE IN THE LOCAL AND GREATER COLUMBUS COMMUNITY.
IRS990/DescribedInSection501c3Ind0true
IRS990/DisregardedEntityInd0false
IRS990/DocumentRetentionPolicyInd0false
IRS990/DonorAdvisedFundInd0false
IRS990/ElectionOfBoardMembersInd0false
IRS990/EmployeeCnt00
IRS990/EngagedInExcessBenefitTransInd0false
IRS990/ExpenseAmt088667
IRS990/FamilyOrBusinessRlnInd0false
IRS990/FederalGrantAuditRequiredInd0false
IRS990/FeesForServicesAccountingGrp/ManagementAndGeneralAmt0990
IRS990/FeesForServicesAccountingGrp/TotalAmt0990
IRS990/FeesForSrvcInvstMgmntFeesGrp/ManagementAndGeneralAmt02219
IRS990/FeesForSrvcInvstMgmntFeesGrp/TotalAmt02219
IRS990/ForeignActivitiesInd0false
IRS990/ForeignFinancialAccountInd0false
IRS990/ForeignOfficeInd0false
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd0X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd1X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd2X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd3X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd4X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd5X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd6X
IRS990/Form990PartVIISectionAGrp/IndividualTrusteeOrDirectorInd7X
IRS990/Form990PartVIISectionAGrp/OfficerInd0X
IRS990/Form990PartVIISectionAGrp/OfficerInd1X
IRS990/Form990PartVIISectionAGrp/OfficerInd2X
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt00
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt10
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt20
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt30
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt40
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt50
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt60
IRS990/Form990PartVIISectionAGrp/OtherCompensationAmt70
IRS990/Form990PartVIISectionAGrp/PersonNm0RICHARD SIMPSON
IRS990/Form990PartVIISectionAGrp/PersonNm1STEVE RISH
IRS990/Form990PartVIISectionAGrp/PersonNm2ANDREW LIVINGSTON
IRS990/Form990PartVIISectionAGrp/PersonNm3STEVE LICHTBLAU
IRS990/Form990PartVIISectionAGrp/PersonNm4BILL MIELKE
IRS990/Form990PartVIISectionAGrp/PersonNm5YVONNE PEROTTI
IRS990/Form990PartVIISectionAGrp/PersonNm6BILL CLOYD
IRS990/Form990PartVIISectionAGrp/PersonNm7ALLISON RUSSO
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromOrgAmt70
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt00
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt10
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt20
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt30
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt40
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt50
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt60
IRS990/Form990PartVIISectionAGrp/ReportableCompFromRltdOrgAmt70
IRS990/Form990PartVIISectionAGrp/TitleTxt0CHAIRMAN
IRS990/Form990PartVIISectionAGrp/TitleTxt1SECRETARY
IRS990/Form990PartVIISectionAGrp/TitleTxt2TREASURER
IRS990/Form990PartVIISectionAGrp/TitleTxt3TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt4TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt5TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt6TRUSTEE
IRS990/Form990PartVIISectionAGrp/TitleTxt7TRUSTEE
IRS990/Form990ProvidedToGvrnBodyInd0true
IRS990/FormationYr01972
IRS990/FormerOfcrEmployeesListedInd0false
IRS990/FSAuditedInd0false
IRS990/FundraisingActivitiesInd0true
IRS990/FundraisingDirectExpensesAmt035145
IRS990/FundraisingGrossIncomeAmt068142
IRS990/GamingActivitiesInd0false
IRS990/GoverningBodyVotingMembersCnt08
IRS990/GrantAmt088667
IRS990/GrantsToDomesticOrgsGrp/ProgramServicesAmt0160115
IRS990/GrantsToDomesticOrgsGrp/TotalAmt0160115
IRS990/GrantsToIndividualsInd0false
IRS990/GrantsToOrganizationsInd0true
IRS990/GrantToRelatedPersonInd0false
IRS990/GrossReceiptsAmt0182310
IRS990/GroupReturnForAffiliatesInd0false
IRS990/IncludeFIN48FootnoteInd0false
IRS990/IndependentAuditFinclStmtInd0false
IRS990/IndependentVotingMemberCnt08
IRS990/IndoorTanningServicesInd0false
IRS990/InfoInScheduleOPartVIInd0X
IRS990/InfoInScheduleOPartXIIInd0X
IRS990/InvestmentIncomeGrp/RelatedOrExemptFuncIncomeAmt04479
IRS990/InvestmentIncomeGrp/TotalRevenueColumnAmt04479
IRS990/InvestmentInJointVentureInd0false
IRS990/InvestmentsOtherSecuritiesGrp/BOYAmt0280284
IRS990/InvestmentsOtherSecuritiesGrp/EOYAmt0240703
IRS990/IRPDocumentCnt00
IRS990/IRPDocumentW2GCnt00
IRS990/LegalDomicileStateCd0OH
IRS990/LoanOutstandingInd0false
IRS990/LobbyingActivitiesInd0false
IRS990/LocalChaptersInd0false
IRS990/MaterialDiversionOrMisuseInd0false
IRS990/MembersOrStockholdersInd0false
IRS990/MethodOfAccountingOtherInd0X
IRS990/MinutesOfCommitteesInd0false
IRS990/MinutesOfGoverningBodyInd0true
IRS990/MissionDesc0TO ENCOURAGE AND FOSTER THE SERVICE IDEAL OF SERVICE ABOVE SELF. THE FOUNDATION SUPPORTS THE FIVE AVENUES OF SERVICE, CLUB SERVICE, COMMUNITY SERVICE, INTERNATIONAL SERVICE, VOCATIONAL SERVICE AND NEW GENERATIONS.
IRS990/MoreThan5000KToIndividualsInd0false
IRS990/MoreThan5000KToOrgInd0false
IRS990/NetAssetsOrFundBalancesBOYAmt0343743
IRS990/NetAssetsOrFundBalancesEOYAmt0336025
IRS990/NetIncmFromFundraisingEvtGrp/ExclusionAmt032997
IRS990/NetIncmFromFundraisingEvtGrp/TotalRevenueColumnAmt032997
IRS990/NetUnrlzdGainsLossesInvstAmt09281
IRS990/NoListedPersonsCompensatedInd0X
IRS990/NondeductibleContributionsInd0false
IRS990/OfficeExpensesGrp/ManagementAndGeneralAmt0740
IRS990/OfficeExpensesGrp/TotalAmt0740
IRS990/OfficerMailingAddressInd0false
IRS990/OperateHospitalInd0false
IRS990/Organization501c3Ind0X
IRS990/OrganizationFollowsSFAS117Ind0X
IRS990/OtherExpensesGrp/Desc0OHIO REGISTRATION FEES
IRS990/OtherExpensesGrp/ManagementAndGeneralAmt0100
IRS990/OtherExpensesGrp/TotalAmt0100
IRS990/PartialLiquidationInd0false
IRS990/PledgesAndGrantsReceivableGrp/BOYAmt058447
IRS990/PledgesAndGrantsReceivableGrp/EOYAmt090694
IRS990/PoliticalCampaignActyInd0false
IRS990/PrincipalOfficerNm0ANDREW LIVINGSTON
IRS990/ProfessionalFundraisingInd0false
IRS990/ProgSrvcAccomActy2Grp/Desc0THE FOUNDATION PROVIDES FUNDING TO UNITED STATES SERVICE ORGANIZATIONS TO PROMOTE EDUCATION AND PROVIDE ECOMOMIC SUPPORT TO INTERNATIONAL COMMUNITIES
IRS990/ProgSrvcAccomActy2Grp/ExpenseAmt071448
IRS990/ProgSrvcAccomActy2Grp/GrantAmt071448
IRS990/ProhibitedTaxShelterTransInd0false
IRS990/PYContributionsGrantsAmt095655
IRS990/PYExcessBenefitTransInd0false
IRS990/PYGrantsAndSimilarPaidAmt0142758
IRS990/PYInvestmentIncomeAmt07086
IRS990/PYOtherExpensesAmt04923
IRS990/PYOtherRevenueAmt034196
IRS990/PYRevenuesLessExpensesAmt0-10744
IRS990/PYTotalExpensesAmt0147681
IRS990/PYTotalRevenueAmt0136937
IRS990/ReconcilationRevenueExpnssAmt0-16999
IRS990/RelatedEntityInd0false
IRS990/RelatedOrganizationCtrlEntInd0false
IRS990/ReportInvestmentsOtherSecInd0true
IRS990/ReportLandBuildingEquipmentInd0false
IRS990/ReportOtherAssetsInd0false
IRS990/ReportOtherLiabilitiesInd0false
IRS990/ReportProgramRelatedInvstInd0false
IRS990ScheduleA/Form990ScheduleAPartVIGrp/ExplanationTxt0FUNDRAISING INCOME - DINNER AUCTION 104,582
IRS990ScheduleA/Form990ScheduleAPartVIGrp/FormAndLineReferenceDesc0PART II, LINE 10
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0109689
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt095655
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt0106388
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt0161062
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt0144999
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0617793
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt04479
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt07086
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt09370
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt07118
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt024405
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt052458
IRS990ScheduleA/GrossReceiptsRltdActivitiesAmt04479
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearAmt032997
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus1YearAmt034196
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus2YearsAmt035184
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus3YearsAmt015893
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus4YearsAmt0-13688
IRS990ScheduleA/OtherIncome170Grp/TotalAmt0104582
IRS990ScheduleA/PublicOrganization170Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.79730
IRS990ScheduleA/PublicSupportPY170Pct00.83930
IRS990ScheduleA/PublicSupportTotal170Amt0617793
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0109689
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt095655
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0106388
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0161062
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0144999
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0617793
IRS990ScheduleA/TotalSupportAmt0774833
IRS990/ScheduleBRequiredInd0true
IRS990ScheduleD/CYEndwmtFundGrp/AdministrativeExpensesAmt0357
IRS990ScheduleD/CYEndwmtFundGrp/BeginningYearBalanceAmt067430
IRS990ScheduleD/CYEndwmtFundGrp/EndYearBalanceAmt070840
IRS990ScheduleD/CYEndwmtFundGrp/InvestmentEarningsOrLossesAmt03766
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/AdministrativeExpensesAmt0315
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/BeginningYearBalanceAmt061524
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/EndYearBalanceAmt067430
IRS990ScheduleD/CYMinus1YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt06221
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/AdministrativeExpensesAmt0292
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/BeginningYearBalanceAmt059470
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/EndYearBalanceAmt061524
IRS990ScheduleD/CYMinus2YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt02346
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/AdministrativeExpensesAmt0292
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/BeginningYearBalanceAmt058705
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/EndYearBalanceAmt059470
IRS990ScheduleD/CYMinus3YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt01057
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/BeginningYearBalanceAmt050764
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/ContributionsAmt0409
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/EndYearBalanceAmt058705
IRS990ScheduleD/CYMinus4YrEndwmtFundGrp/InvestmentEarningsOrLossesAmt07532
IRS990ScheduleD/EndowmentsHeldRelatedOrgInd0false
IRS990ScheduleD/EndowmentsHeldUnrelatedOrgInd0false
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt0169863
IRS990ScheduleD/OtherSecuritiesGrp/BookValueAmt170840
IRS990ScheduleD/OtherSecuritiesGrp/Desc0COLUMBUS FOUNDATION FUND
IRS990ScheduleD/OtherSecuritiesGrp/Desc1COLUMBUS FOUNDATION ENDOWMENT FUND
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd0F
IRS990ScheduleD/OtherSecuritiesGrp/MethodValuationCd1F
IRS990ScheduleD/SupplementalInformationDetail/ExplanationTxt0DESIGNATED FOR SPECIAL NEEDS OF THE COMMUNITY AS DETERMINED BY THE BOARD
IRS990ScheduleD/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE D, PAGE 2, PART V, LINE 4
IRS990ScheduleD/TermEndowmentBalanceEOYPct01.00000
IRS990ScheduleD/TotalBookValueSecuritiesAmt0240703
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt035145
IRS990ScheduleG/FundraisingEventInformationGrp/EntertainmentEvent1Amt04878
IRS990ScheduleG/FundraisingEventInformationGrp/EntertainmentTotalEventsAmt04878
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0DINNER/AUCTION
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent1Amt022795
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageTotalEventsAmt022795
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt068142
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt068142
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt068142
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt068142
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt032997
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt04752
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt04752
IRS990ScheduleG/FundraisingEventInformationGrp/RentFacilityCostsEvent1Amt02720
IRS990ScheduleG/FundraisingEventInformationGrp/RentFcltyCostsTotalEventsAmt02720
IRS990ScheduleI/GrantRecordsMaintainedInd0true
IRS990ScheduleI/RecipientTable/CashGrantAmt034150
IRS990ScheduleI/RecipientTable/CashGrantAmt171448
IRS990ScheduleI/RecipientTable/CashGrantAmt27357
IRS990ScheduleI/RecipientTable/CashGrantAmt35020
IRS990ScheduleI/RecipientTable/CashGrantAmt46440
IRS990ScheduleI/RecipientTable/CashGrantAmt56400
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt0THE UPPER ARLINGTON COMMUNITY FOUND
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt1MAYAN FAMILIES FOUNDATION
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt2BIG BROTHERSBIG SISTERS
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt3UPPER ARLINGTON EDUCATION FOUNDATIO
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt4YWCA OF COLUMBUS
IRS990ScheduleI/RecipientTable/RecipientBusinessName/BusinessNameLine1Txt5WINDERMERE ELEMENTARY PTO
IRS990ScheduleI/RecipientTable/RecipientEIN0205860971
IRS990ScheduleI/RecipientTable/RecipientEIN1208433997
IRS990ScheduleI/RecipientTable/RecipientEIN2314379429
IRS990ScheduleI/RecipientTable/RecipientEIN3311156964
IRS990ScheduleI/RecipientTable/RecipientEIN4314379597
IRS990ScheduleI/RecipientTable/RecipientEIN5316401046
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt03600 TREMONT ROAD
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt1PO BOX 710400
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt21855 E DUBLIN GRANVILLE RD
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt31950 MALLWAY DRIVE
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt465 SOUTH FRONT STREET
IRS990ScheduleI/RecipientTable/USAddress/AddressLine1Txt54101 WINDEMERE ROAD
IRS990ScheduleI/RecipientTable/USAddress/CityNm0COLUMBUS
IRS990ScheduleI/RecipientTable/USAddress/CityNm1SANTEE
IRS990ScheduleI/RecipientTable/USAddress/CityNm2COLUMBUS
IRS990ScheduleI/RecipientTable/USAddress/CityNm3COLUMBUS
IRS990ScheduleI/RecipientTable/USAddress/CityNm4COLUMBUS
IRS990ScheduleI/RecipientTable/USAddress/CityNm5UPPER ARLINGTON
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd0OH
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd1CA
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd2OH
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd3OH
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd4OH
IRS990ScheduleI/RecipientTable/USAddress/StateAbbreviationCd5OH
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd043221
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd192070
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd243229
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd343221
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd443215
IRS990ScheduleI/RecipientTable/USAddress/ZIPCd543220
IRS990ScheduleI/SupplementalInformationDetail/ExplanationTxt0RECOMMENDATIONS OF THE SERVICE GRANTS COMMITTEE AND APPROVAL BY THE BOARD SUBMISSION OF PAPERWORK TO THE COLUMBUS FOUNDATION FOR THEIR PROCESSING
IRS990ScheduleI/SupplementalInformationDetail/FormAndLineReferenceDesc0SCHEDULE I, PAGE 1, PART I, LINE 2
IRS990ScheduleI/Total501c3OrgCnt06
IRS990/ScheduleJRequiredInd0false
IRS990/ScheduleORequiredInd0true
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0FILING AMENDED RETURN DUE TO RECEIPT OF ADDITION INFORMATION SUBSEQUENT TO FILING DATE. REPORTED INCREASE IN INCOME FROM FUNDRAISING ACTIVITIES OF 32,997 NOT REPORTED ON ORIGINAL RETURN.
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1COMMITTEES ARE NOT AUTHORIZED TO ACT ON BEHALF OF THE BOARD
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2TAX RETURNS ARE SUBMITTED TO THE BOARD FOR THEIR REVIEW AND APPROVAL PRIOR TO FILING
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3GOVERNING DOCUMENT ARE MADE AVAILABLE UPON REQUEST
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4LINE 1 - THE ORGANIZATION USES THE MODIFIED ACCRUAL METHOD OF ACCOUNTING
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0FORM 990, PAGE 1, ITEM B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1FORM 990, PAGE 6, PART VI, LINE 8B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2FORM 990, PAGE 6, PART VI, LINE 11B
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3FORM 990, PAGE 6, PART VI, LINE 19
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4FORM 990, PART XII
IRS990/SchoolOperatingInd0false
IRS990/SignificantChangeInd0false
IRS990/SignificantNewProgramSrvcInd0false
IRS990/StatesWhereCopyOfReturnIsFldCd0OH
IRS990/SubjectToProxyTaxInd0false
IRS990/TaxablePartyNotificationInd0false
IRS990/TaxExemptBondsInd0false
IRS990/TemporarilyRstrNetAssetsGrp/BOYAmt067430
IRS990/TemporarilyRstrNetAssetsGrp/EOYAmt070840
IRS990/TempOrPermanentEndowmentsInd0true
IRS990/TerminateOperationsInd0false
IRS990/TotalAssetsBOYAmt0343743
IRS990/TotalAssetsEOYAmt0336025
IRS990/TotalAssetsGrp/BOYAmt0343743
IRS990/TotalAssetsGrp/EOYAmt0336025
IRS990/TotalCompGreaterThan150KInd0false
IRS990/TotalContributionsAmt0109689
IRS990/TotalEmployeeCnt00
IRS990/TotalFunctionalExpensesGrp/FundraisingAmt00
IRS990/TotalFunctionalExpensesGrp/ManagementAndGeneralAmt04049
IRS990/TotalFunctionalExpensesGrp/ProgramServicesAmt0160115
IRS990/TotalFunctionalExpensesGrp/TotalAmt0164164
IRS990/TotalGrossUBIAmt00
IRS990/TotalLiabilitiesEOYAmt00
IRS990/TotalLiabilitiesGrp/BOYAmt00
IRS990/TotalLiabilitiesGrp/EOYAmt00
IRS990/TotalNetAssetsFundBalanceGrp/BOYAmt0343743
IRS990/TotalNetAssetsFundBalanceGrp/EOYAmt0336025
IRS990/TotalProgramServiceExpensesAmt0160115
IRS990/TotalRevenueGrp/ExclusionAmt032997
IRS990/TotalRevenueGrp/RelatedOrExemptFuncIncomeAmt04479
IRS990/TotalRevenueGrp/TotalRevenueColumnAmt0147165
IRS990/TotLiabNetAssetsFundBalanceGrp/BOYAmt0343743
IRS990/TotLiabNetAssetsFundBalanceGrp/EOYAmt0336025
IRS990/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990/TypeOfOrganizationCorpInd0X
IRS990/UnrelatedBusIncmOverLimitInd0false
IRS990/UnrestrictedNetAssetsGrp/BOYAmt0276313
IRS990/UnrestrictedNetAssetsGrp/EOYAmt0265185
IRS990/UponRequestInd0X
IRS990/USAddress/AddressLine1Txt01704 SUNDRIDGE DRIVE
IRS990/USAddress/CityNm0COLUMBUS
IRS990/USAddress/StateAbbreviationCd0OH
IRS990/USAddress/ZIPCd043221
IRS990/VotingMembersGoverningBodyCnt08
IRS990/VotingMembersIndependentCnt08
IRS990/WebsiteAddressTxt0N/A
IRS990/WhistleblowerPolicyInd0false
ReturnHeader/BuildTS02019-02-21 02:37:17Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0ANDREW LIVINGSTON
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASURER
ReturnHeader/BusinessOfficerGrp/PhoneNum06144803066
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-06-18
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0UPPER ARLINGTON ROTARY CHARITABLE
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0FOUNDATION C/O ANDREW LIVINGSTON
ReturnHeader/Filer/BusinessNameControlTxt0UPPE
ReturnHeader/Filer/EIN0311289089
ReturnHeader/Filer/PhoneNum06144593182
ReturnHeader/Filer/USAddress/AddressLine1Txt01704 SUNDRIDGE DR
ReturnHeader/Filer/USAddress/CityNm0COLUMBUS
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OH
ReturnHeader/Filer/USAddress/ZIPCd043221
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId065B6F50B0F712C2B2EB7AECA6B6152BC4EED6A79
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId0B2E1E5A2E7E21CF6CC5F5EFE3DC77ABA76B946DE

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$336,025
Liabilities
$0
Net assets
$336,025
Revenue
$147,165
Expenses
$164,164
Net income
-$16,999
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$2.89$0.00$2.89$1.19$1.37$0.19
2024Detailed filing. Detailed filing data is available for this year.$2.97$0.00$2.97$1.34$1.90$0.56
2023Detailed filing. Detailed filing data is available for this year.$3.43$0.00$3.43$1.94$1.75$0.19
2022Detailed filing. Detailed filing data is available for this year.$3.12$0.00$3.12$1.22$1.39$0.17
2021Detailed filing. Detailed filing data is available for this year.$3.42$0.00$3.42$2.01$1.64$0.36
2020Detailed filing. Detailed filing data is available for this year.$2.63$0.04$2.59$1.15$1.80$0.65
2019Detailed filing. Detailed filing data is available for this year.$3.30$0.00$3.30$1.58$1.66$0.09
2018Detailed filing. Detailed filing data is available for this year.$3.36$0.00$3.36$1.47$1.64$0.17
2017Detailed filing. Detailed filing data is available for this year.$3.44$0.00$3.44$1.37$1.48$0.11
2016Detailed filing. Detailed filing data is available for this year.$3.24$0.00$3.24$1.51$1.30$0.21
2015Detailed filing. Detailed filing data is available for this year.$3.12$0.00$3.12$1.84$1.92$0.08
2014Detailed filing. Detailed filing data is available for this year.$3.23$0.00$3.23$1.56$1.34$0.22
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$3.01$0.00$3.01$1.70$1.04$0.67
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.34$0.00$2.34$1.27$1.44$0.17
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$2.51$0.00$2.51$1.19$0.73$0.46