Civic Intelligence

Columbia County Rotary

990EZ • Fiscal year 2019 • EIN 93-0764414

Jul 01, 2018 to Jun 30, 2019 • Filed on Nov 12, 2019

Organization ProfileN/A
PO Box 721Saint Helens, OR 97051

(503) 543-7195

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.

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

Liabilities / Revenue

56th percentile

0.00x

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

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

Net Margin

92nd percentile

42%

Higher net margin than 92% of similar nonprofits.

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

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.

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

Asset Growth

92nd percentile

59%

Faster asset growth than 92% of similar nonprofits.

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

Revenue Growth

26th percentile

-14%

Faster revenue growth than 26% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets57th percentile

Assets

Up

$31,702

Up $11,823 (+59%) from 2018

Net Assets

$31,702

No earlier filing loaded for comparison.

Liabilities

Flat

$0

Flat from 2018

Revenue And Expenses
Liabilities / Revenue56th percentileNet Margin92nd percentile

Revenue

Down

$27,838

Down $4,495 (-14%) from 2018

Expenses

Down

$16,015

Down $26,428 (-62%) from 2018

Net Income

Up

$11,823

Up $21,933 (+217%) from 2018

Historical Trend

Balance Sheet Trend

Asset Growth92nd percentile

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

$40K$30K$20K$10K$0Assets 2011: $16,845Liabilities 2011: $02011Assets 2012: $23,032Liabilities 2012: $02012Assets 2013: $18,891Net Assets 2013: $18,8912013Assets 2014: $16,029Liabilities 2014: $650Net Assets 2014: $15,3792014Assets 2015: $17,785Liabilities 2015: $150Net Assets 2015: $17,6352015Assets 2016: $7,907Liabilities 2016: $0Net Assets 2016: $7,9072016Assets 2017: $29,989Liabilities 2017: $0Net Assets 2017: $29,9892017Assets 2018: $19,879Liabilities 2018: $02018Assets 2019: $31,702Liabilities 2019: $0Net Assets 2019: $31,7022019

Highlighted filing

2019

Assets$31,702
Liabilities$0
Net Assets$31,702
Open 2019 Filing

Operations Trend

Revenue Growth26th percentile

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

$100K$50K$0-$50KRevenue 2011: $49,058Expenses 2011: $50,065Net Income 2011: -$1,0072011Revenue 2012: $49,174Expenses 2012: $42,987Net Income 2012: $6,1872012Revenue 2013: $46,794Expenses 2013: $50,935Net Income 2013: -$4,1412013Revenue 2014: $51,103Expenses 2014: $54,615Net Income 2014: -$3,5122014Revenue 2015: $47,198Expenses 2015: $44,942Net Income 2015: $2,2562015Revenue 2016: $50,850Expenses 2016: $60,578Net Income 2016: -$9,7282016Revenue 2017: $95,111Expenses 2017: $73,029Net Income 2017: $22,0822017Revenue 2018: $32,333Expenses 2018: $42,443Net Income 2018: -$10,1102018Revenue 2019: $27,838Expenses 2019: $16,015Net Income 2019: $11,8232019

Highlighted filing

2019

Revenue$27,838
Expenses$16,015
Net Income$11,823
Open 2019 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2018 to Jun 30, 2019
Signed
Nov 12, 2019
Return Version
2018v3.1
Gross Receipts
$27,838
Mission and Program Overview

Mission

Fund raising for local non profit organi

Program Services

DescriptionGrantsExpenses
PROVIDE FELLOWSHIP AMONG INTL ORGANIZATION OF ROTARY FOR ITS MEMBERS LOCAL FUNDRAISING FOR VARIOUS LOCAL NON PROFIT ORGANIZATIONS PROVIDE LOCAL VOCATIONAL SCHOLARSHIPS TO HIGH SC-$16,015
Compensation and Service Providers
Top Officer Pay86th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
TED OLSONFoundation Chair-$0--
HOLLY HOUSTONPast President-$0--
HEATHER ARNISPresident-$0--
JESSICA LEADERTreasurer-$0--
Filing and Contact Details

Filer

Filer Name
Columbia County Rotary
EIN
93-0764414
Address
PO BOX 721, Saint Helens, OR 97051

Signing Officer

Name
Palmer T Olson
Title
Foundation Chai
Phone
5035437195
Signed
2019-11-12
Discuss with paid preparer
Yes

Preparer

Firm
Scappoose Business & Tax Service
Address
51671 COLUMBIA RIVER HWY, Scappoose, OR 97056
Preparer
Palmer T Olson
Phone
5035437195
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description AmountADMINISTRATIVE/OFFICE 5,226PAYMENTS TO AFFILIATES 1,237FUNDRAISING 3,042COMMUNITY SERVICES 301VOCATIONAL SERVICE 1,314CLUB SERVICE 211INTERNATIONAL SERVICE 3,400POP CORN EXPENSE 556OTHER ADJUSTMENT PRIOR YR 728”

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/PersonNm0TED OLSON
IRS990EZ/BooksInCareOfDetail/PhoneNum05035437195
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO BOX 721
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Saint Helens
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0OR
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd097051
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt019879
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt031702
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt020069
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt011823
IRS990EZ/FiledScheduleAInd0false
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt019879
IRS990EZ/Form990TotalAssetsGrp/EOYAmt031702
IRS990EZ/GrossReceiptsAmt027838
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt07769
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt019879
IRS990EZ/NetAssetsOrFundBalancesEOYAmt031702
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt019879
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt031702
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00.50
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/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0TED OLSON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1HOLLY HOUSTON
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2HEATHER ARNIS
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3JESSICA LEADER
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0FOUNDATION CHAIR
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1PAST PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2PRESIDENT
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3TREASURER
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501cInd0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt016015
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0FUND RAISING FOR LOCAL NON PROFIT ORGANI
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE FELLOWSHIP AMONG INTL ORGANIZATION OF ROTARY FOR ITS MEMBERS LOCAL FUNDRAISING FOR VARIOUS LOCAL NON PROFIT ORGANIZATIONS PROVIDE LOCAL VOCATIONAL SCHOLARSHIPS TO HIGH SC
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt016015
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt016015
IRS990EZ/TotalProgramServiceExpensesAmt016015
IRS990EZ/TotalRevenueAmt027838
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TypeOfOrganizationAssocInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountADMINISTRATIVE/OFFICE 5,226PAYMENTS TO AFFILIATES 1,237FUNDRAISING 3,042COMMUNITY SERVICES 301VOCATIONAL SERVICE 1,314CLUB SERVICE 211INTERNATIONAL SERVICE 3,400POP CORN EXPENSE 556OTHER ADJUSTMENT PRIOR YR 728
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
ReturnHeader/BuildTS02020-04-17 16:48:07Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0PALMER T OLSON
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0FOUNDATION CHAI
ReturnHeader/BusinessOfficerGrp/PhoneNum05035437195
ReturnHeader/BusinessOfficerGrp/SignatureDt02019-11-12
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0COLUMBIA COUNTY ROTARY
ReturnHeader/Filer/BusinessNameControlTxt0COLU
ReturnHeader/Filer/EIN0930764414
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO BOX 721
ReturnHeader/Filer/USAddress/CityNm0Saint Helens
ReturnHeader/Filer/USAddress/StateAbbreviationCd0OR
ReturnHeader/Filer/USAddress/ZIPCd097051
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId01037D576C2330CE9EE7C713F52FB068F8E050E72
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId01037D576C2330CE9EE7C713F52FB068F8E050E72
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId09357272019344aabctcw
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02019-12-10
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt076.105.215.216
ReturnHeader/FilingSecurityInformation/IPDt02019-12-10
ReturnHeader/FilingSecurityInformation/IPTm017:08:21
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0611902200
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0SCAPPOOSE BUSINESS & TAX SERVICE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt051671 COLUMBIA RIVER HWY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Scappoose
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0OR
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd097056
ReturnHeader/PreparerPersonGrp/PhoneNum05035437195
ReturnHeader/PreparerPersonGrp/PreparationDt02019-12-10
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0PALMER T OLSON
ReturnHeader/ReturnTs02019-12-10T13:10:23-05:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02018-07-01
ReturnHeader/TaxPeriodEndDt02019-06-30
ReturnHeader/TaxYr02018

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$31,702
Liabilities
$0
Net assets
$31,702
Revenue
$27,838
Expenses
$16,015
Net income
$11,823
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2019Detailed filing. Detailed filing data is available for this year.$31.7$0.00$31.7$27.8$16.0$11.8
2018Summary only. Only limited summary data is available for this year.$19.9$0.00$32.3$42.4$10.1
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$30.0$0.00$30.0$95.1$73.0$22.1
2016Detailed filing. Detailed filing data is available for this year.$7.91$0.00$7.91$50.9$60.6$9.73
2015Detailed filing. Detailed filing data is available for this year.$17.8$0.15$17.6$47.2$44.9$2.26
2014Detailed filing. Detailed filing data is available for this year.$16.0$0.65$15.4$51.1$54.6$3.51
2013Facts available. Structured filing facts are available, but richer extracted sections are limited.$18.9$18.9$46.8$50.9$4.14
2012Summary only. Only limited summary data is available for this year.$23.0$0.00$49.2$43.0$6.19
2011Summary only. Only limited summary data is available for this year.$16.8$0.00$49.1$50.1$1.01