Civic Intelligence

Trail of Johnson County

EIN 81-3616856 • 501(c)3 • Iowa City, IA

Profile

Community Development

28 South Linn StreetIowa City, IA 52240

www.trailofjohnsoncounty.com

Siviq Scores

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

Liabilities / Assets

59th percentile

0.00x

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

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

Liabilities / Revenue

61st percentile

0.00x

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

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

Net Margin

29th percentile

-12%

Higher net margin than 29% of similar nonprofits.

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

Top Officer Pay

Score unavailable

No value available

No filing with officer rows is available for this organization yet.

Asset Growth

34th percentile

-15%

Faster asset growth than 34% of similar nonprofits.

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

Revenue Growth

53rd percentile

0.8%

Faster revenue growth than 53% of similar nonprofits.

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

Balance Sheet
Liabilities / Assets59th percentile

Assets

Down

$69,836

Down $7,175 (-9.3%) from 2022

Liabilities

Flat

$0

Flat from 2022

Net Assets

Down

$69,836

Down $7,175 (-9.3%) from 2022

Operations
Liabilities / Revenue61st percentileNet Margin29th percentile

Revenue

Up

$140,395

Up $26,499 (+23%) from 2022

Expenses

Up

$147,570

Up $20,069 (+16%) from 2022

Net Income

Up

-$7,175

Up $6,430 (+47%) from 2022

Trend Graphs

Balance Sheet Trend

Asset Growth34th percentile

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

$100K$50K$0Assets 2021: $90,616Liabilities 2021: $0Net Assets 2021: $90,6162021Assets 2022: $77,011Liabilities 2022: $0Net Assets 2022: $77,0112022Assets 2023: $69,836Liabilities 2023: $0Net Assets 2023: $69,8362023

Highlighted filing

2023

Assets$69,836
Liabilities$0
Net Assets$69,836
Open 2023 Filing

Operations Trend

Revenue Growth53rd percentile

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

$150K$100K$50K$0-$50KRevenue 2021: $112,957Expenses 2021: $114,254Net Income 2021: -$1,2972021Revenue 2022: $113,896Expenses 2022: $127,501Net Income 2022: -$13,6052022Revenue 2023: $140,395Expenses 2023: $147,570Net Income 2023: -$7,1752023

Highlighted filing

2023

Revenue$140,395
Expenses$147,570
Net Income-$7,175
Open 2023 Filing

Filings

Most recent year

2023 • Form 990EZXML pending. An XML filing is linked for this year, but detailed extraction is still pending.

Open filing
Assets
$69,836
Liabilities
$0
Net assets
$69,836
Revenue
$140,395
Expenses
$147,570
Net income
-$7,175
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.70$0.00$0.70$1.40$1.48$0.07
2022Detailed filing. Detailed filing data is available for this year.$0.77$0.00$0.77$1.14$1.28$0.14
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0.91$0.00$0.91$1.13$1.14$0.01
Latest Detailed Filing

The latest 2023 filing currently has linked XML that has not been fully parsed yet. Showing the latest detailed filing from 2022 below.

Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
May 15, 2023
Return Version
2022v5.0
Gross Receipts
$113,896
Mission and Program Overview

Mission

Community Development

Program Services

DescriptionGrantsExpenses
Provided Services to MembersNumber of Services Provided: 884Number of Members: 238-$63,750
Provided Cultural and Education Events to Members-$63,750
Compensation and Service Providers
Top Officer PayScore unavailable

Employees

NameTitleFull / Part TimeBaseOtherTotal
Bob UnitedExecutive DirectorFT$0--
Alex TaylorChair Of Board Of Directors-$0--
Alison AndrewsVolunteer Cmte ChairPT$0--
Vincent GaffneyBoard Member-$0--
Lesanne FliehlerCommunications Chair-$0--
Beth LegueBoard Member-$0--
Bob ReynoldsTreasurer ElectPT$0--
Julie GridleyBoard Member-$0--
Ellen HallinBoard Member-$0--
Barb SteinEducational ChairPT$0--
Filing and Contact Details

Filer

Filer Name
Trail of Johnson County
EIN
81-3616856
Address
28 South Linn Street, Iowa City, IA 52240

Signing Officer

Name
Bob Untiedt
Title
Treasurer
Phone
3198009003
Signed
2023-05-15
Discuss with paid preparer
No

Preparer

Firm
Fowler Tax Service PC
Address
1102 Park Avenue, Muscatine, IA 52761
Preparer
Alec R Fowler
Phone
5637705365
Supplemental Narrative

Additional Explanations

Description of other expenses Part I line 16

“Description AmountInsurance 3,250Payroll Service 689Finance Fees 10Staff Development 2,140Telephone 349Prof. Org. Dues 425Postage 348Software Fees 2,434Website Management 353CC Processing 2,253Fall Event 1,858Mkt Printing 438Contract Services 875Office Exp. 2,975Membership Refund 299Member Programs 3,516Volunteer Background Checks 717”

Raw XML Appendix192 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/PersonNm0Beth Legue
IRS990EZ/BooksInCareOfDetail/PhoneNum03193565945
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0102 S Clinton Street
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Iowa City
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd052240
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt090616
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt077011
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt066190
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-13605
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt090616
IRS990EZ/Form990TotalAssetsGrp/EOYAmt077011
IRS990EZ/GrossReceiptsAmt0113896
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt0530
IRS990EZ/LandAndBuildingsGrp/BOYAmt00
IRS990EZ/LandAndBuildingsGrp/EOYAmt00
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MembershipDuesAmt047176
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt090616
IRS990EZ/NetAssetsOrFundBalancesEOYAmt077011
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt090616
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt077011
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt040.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt210.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt32.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt44.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt52.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt610.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt74.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt81.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt95.00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/EmployeeBenefitProgramAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt40
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt50
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt60
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt70
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt80
IRS990EZ/OfficerDirectorTrusteeEmplGrp/ExpenseAccountOtherAllwncAmt90
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Bob United
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Alex Taylor
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Alison Andrews
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Vincent Gaffney
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm4Lesanne Fliehler
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm5Beth Legue
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm6Bob Reynolds
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm7Julie Gridley
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm8Ellen Hallin
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm9Barb Stein
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0Executive Director
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Chair of Board of Directors
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Volunteer CMTE Chair
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Board Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt4Communications Chair
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt5Board Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt6Treasurer Elect
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt7Board Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt8Board Member
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt9Educational Chair
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt00
IRS990EZ/OtherAssetsTotalDetail/EOYAmt00
IRS990EZ/OtherExpensesTotalAmt022929
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0Community Development
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Provided Services to MembersNumber of Services Provided: 884Number of Members: 238
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt1Provided Cultural and Education Events to Members
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt063750
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt163750
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/SalariesOtherCompEmplBnftAmt0104572
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/SumOfTotalLiabilitiesGrp/BOYAmt00
IRS990EZ/SumOfTotalLiabilitiesGrp/EOYAmt00
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TotalExpensesAmt0127501
IRS990EZ/TotalProgramServiceExpensesAmt0127500
IRS990EZ/TotalRevenueAmt0113896
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0www.trailofjohnsoncounty.com
IRS990ScheduleA/CommunityTrustInd0X
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearAmt0113336
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt0112871
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt088962
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt083384
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt078555
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt0477108
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/CurrentTaxYearAmt026265
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/CurrentTaxYearMinus1YearAmt026265
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/CurrentTaxYearMinus2YearsAmt026265
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/CurrentTaxYearMinus3YearsAmt026265
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/CurrentTaxYearMinus4YearsAmt026265
IRS990ScheduleA/GovtFurnSrvcFcltsVl170Grp/TotalAmt0131325
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearAmt0316
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt085
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt096
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt085
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt044
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt0626
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearAmt0200
IRS990ScheduleA/OtherIncome170Grp/CurrentTaxYearMinus4YearsAmt0210
IRS990ScheduleA/OtherIncome170Grp/TotalAmt0410
IRS990ScheduleA/PublicSupportCY170Pct00.99830
IRS990ScheduleA/PublicSupportPY170Pct00.99900
IRS990ScheduleA/PublicSupportTotal170Amt0608433
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearAmt0139601
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt0139136
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt0115227
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt0109649
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt0104820
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt0608433
IRS990ScheduleA/TotalSupportAmt0609469
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Description AmountInsurance 3,250Payroll Service 689Finance Fees 10Staff Development 2,140Telephone 349Prof. Org. Dues 425Postage 348Software Fees 2,434Website Management 353CC Processing 2,253Fall Event 1,858Mkt Printing 438Contract Services 875Office Exp. 2,975Membership Refund 299Member Programs 3,516Volunteer Background Checks 717
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Description of other expenses Part I line 16
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL2
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0Bob Untiedt
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Treasurer
ReturnHeader/BusinessOfficerGrp/PhoneNum03198009003
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-05-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Trail of Johnson County
ReturnHeader/Filer/BusinessNameControlTxt0TRAI
ReturnHeader/Filer/EIN0813616856
ReturnHeader/Filer/USAddress/AddressLine1Txt028 South Linn Street
ReturnHeader/Filer/USAddress/CityNm0Iowa City
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd052240
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0832706856
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Fowler Tax Service PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01102 Park Avenue
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Muscatine
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd052761
ReturnHeader/PreparerPersonGrp/PhoneNum05637705365
ReturnHeader/PreparerPersonGrp/PreparationDt02023-09-19
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Alec R Fowler
ReturnHeader/ReturnTs02023-09-19T15:09:25-04:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Bob
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Untiedt
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.