Civic Intelligence

John Ruan Foundation Trust

990T • Fiscal year 2023 • EIN 42-6059463

Jul 01, 2022 to Jun 30, 2023 • Filed on Oct 09, 2023

Organization Profile
11207 NW Aurora AvenueUrbandale, IA 50322

(515) 245-2552

Siviq Scores

Scores are not available for this record yet.

Balance Sheet

Assets

-

No earlier filing loaded for comparison.

Net Assets

-

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses

Revenue

-

No earlier filing loaded for comparison.

Expenses

-

No earlier filing loaded for comparison.

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$150M$100M$50M$0Assets 2012: $3,847,120Liabilities 2012: $78,3242012Assets 2013: $3,892,047Liabilities 2013: $02013Assets 2014: $4,911,995Liabilities 2014: $125,3952014Assets 2015: $8,277,280Liabilities 2015: $231,0732015Assets 2016: $15,102,093Liabilities 2016: $181,0452016Assets 2020: $100,640,820Liabilities 2020: $02020Assets 2021: $103,561,030Liabilities 2021: $2,276,562Net Assets 2021: $101,284,4682021Assets 2022: $110,876,833Liabilities 2022: $7,935,313Net Assets 2022: $102,941,5202022Assets 2023: $98,778,410Liabilities 2023: $0Net Assets 2023: $98,778,4102023Assets 2024: $99,450,504Liabilities 2024: $0Net Assets 2024: $99,450,5042024Assets 2025: $100,195,996Liabilities 2025: $0Net Assets 2025: $100,195,9962025

Latest loaded filing

2025

Assets$100,195,996
Liabilities$0
Net Assets$100,195,996
Open 2025 Filing

Operations Trend

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

$10M$5.0M$0-$5.0MRevenue 2012: $699,501Expenses 2012: $594,378Net Income 2012: $105,1232012Revenue 2013: $805,051Expenses 2013: $681,800Net Income 2013: $123,2512013Revenue 2014: $1,550,852Expenses 2014: $656,299Net Income 2014: $894,5532014Revenue 2015: $4,177,333Expenses 2015: $917,726Net Income 2015: $3,259,6072015Revenue 2016: $7,757,054Expenses 2016: $882,213Net Income 2016: $6,874,8412016Revenue 2020: $7,281,473Expenses 2020: $5,131,654Net Income 2020: $2,149,8192020Revenue 2021: $6,342,431Expenses 2021: $5,698,783Net Income 2021: $643,6482021Revenue 2022: $7,230,015Expenses 2022: $5,572,963Net Income 2022: $1,657,0522022Revenue 2023: $553,935Expenses 2023: $4,717,045Net Income 2023: -$4,163,1102023Revenue 2024: $5,106,530Expenses 2024: $4,434,436Net Income 2024: $672,0942024Revenue 2025: $5,235,570Expenses 2025: $4,490,078Net Income 2025: $745,4922025

Latest loaded filing

2025

Revenue$5,235,570
Expenses$4,490,078
Net Income$745,492
Open 2025 Filing
Jump To
Filing Snapshot
Filing Period
Jul 1, 2022 to Jun 30, 2023
Signed
Oct 9, 2023
Return Version
2022v7.0
Filing and Contact Details

Filer

Filer Name
John Ruan Foundation Trust
EIN
42-6059463
Phone
5152452552
Address
11207 NW Aurora Avenue, Urbandale, IA 50322

Signing Officer

Name
John Ruan IV
Title
Trustee
Phone
5152452552
Signed
2023-10-09
Discuss with paid preparer
Yes

Preparer

Firm
Eide Bailly LLP
Address
800 Nicollet Mall Ste 1300, Minneapolis, MN 55402-7033
Preparer
Deb Nelson CPA
Phone
6122536500
Raw XML Appendix113 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
IRS1041ScheduleI/AdjAlternativeMinTaxableIncAmt038890
IRS1041ScheduleI/AdjustedRegularTaxAmt012282
IRS1041ScheduleI/AdjustedTotalIncomeAmt038890
IRS1041ScheduleI/AlternativeMinimumTaxAmt00
IRS1041ScheduleI/AlternativeMinTaxableIncomeAmt038890
IRS1041ScheduleI/EstateOrTrustShrLessExemptAmt012390
IRS1041ScheduleI/MaximumCapitalGainsOrNetAmt03221
IRS1041ScheduleI/NetExemptionAmt026500
IRS1041ScheduleI/NetShareAltMinTaxbleIncomeAmt00
IRS1041ScheduleI/NetShareAltMinTxblIncmXPctAmt00
IRS1041ScheduleI/TentativeAlternativeMinTaxAmt03221
IRS990T/BalanceDueAmt02352
IRS990T/BooksInCareOfDetail/PersonNm0Tracey Ball
IRS990T/BooksInCareOfDetail/PhoneNum05152452552
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt011207 NW Aurora Avenue
IRS990T/BooksInCareOfDetail/USAddress/CityNm0Urbandale
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0IA
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd050322
IRS990T/BookValueAssetsEOYAmt098778410
IRS990T/ChangeInMethodOfAccountingInd00
IRS990T/CharitableContributionsDedAmt00
IRS990T/ESPenaltyAmt070
IRS990T/EstimatedTaxPaymentsAmt010000
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form2220AttachedInd0X
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/PaidTaxLiabilityAmt00
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/NetUnrelatedDebtFincdIncmAmt038890
IRS990TScheduleA/PrincipalBusinessActivityCd0525990
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalAllocableDeductionsAmt04079
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt042969
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt038890
IRS990TScheduleA/TotUnrltTrdBusIncmAmt042969
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt04079
IRS990TScheduleA/TradeOrBusinessDesc0Unrelated Debt Financed Investment Income
IRS990TScheduleA/UBIBeforeNOLDedAmt038890
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt038890
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AllocableDeductionAmt04079
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionAdjBasisPct00.07757
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAcquisitionDebtAmt08123292
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/AverageAdjustedBasisAmt0104724163
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeAmt0553935
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/GrossIncomeReportableAmt042969
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/OtherDebtFinancedDeductionAmt052584
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/PropertyDesc0Debt-Financed Investm
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/StraightLineDepreciationDedAmt00
IRS990TScheduleA/UnrelatedDebtFinancedPropGrp/TotalDebtFinancedDeductionAmt052584
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableTrustAmt012282
IRS990T/TaxLessCreditsAmt012282
IRS990T/TaxRateScheduleInd0X
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt010000
IRS990T/TotalTaxAmt012282
IRS990T/TotalTaxComputationAmt012282
IRS990T/TotalUBTIAmt037890
IRS990T/TotalUBTIBeforeNOLSpecificAmt038890
IRS990T/TotalUBTIBeforeSection199AAmt038890
IRS990T/TotalUBTIComputedAmt038890
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0John Ruan IV
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/PhoneNum05152452552
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-10-09
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0John Ruan Foundation Trust
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0426059463
ReturnHeader/Filer/PhoneNum05152452552
ReturnHeader/Filer/USAddress/AddressLine1Txt011207 NW Aurora Avenue
ReturnHeader/Filer/USAddress/CityNm0Urbandale
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IA
ReturnHeader/Filer/USAddress/ZIPCd050322
ReturnHeader/IRSResponsiblePrtyInfoCurrInd01
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0450250958
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Eide Bailly LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0800 Nicollet Mall Ste 1300
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Minneapolis
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0554027033
ReturnHeader/PreparerPersonGrp/PhoneNum06122536500
ReturnHeader/PreparerPersonGrp/PreparationDt02023-10-02
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Deb Nelson CPA
ReturnHeader/ReturnTs02023-10-16T09:12:07-05:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0John
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Ruan IV
ReturnHeader/TaxPeriodBeginDt02022-07-01
ReturnHeader/TaxPeriodEndDt02023-06-30
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2023 • Form 990TFacts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
-
Liabilities
-
Net assets
-
Revenue
-
Expenses
-
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2025Detailed filing. Detailed filing data is available for this year.$100$0.00$100$5.24$4.49$0.75
2024Detailed filing. Detailed filing data is available for this year.$99.5$0.00$99.5$5.11$4.43$0.67
2023Detailed filing. Detailed filing data is available for this year.$98.8$0.00$98.8$0.55$4.72$4.16
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.
2022Detailed filing. Detailed filing data is available for this year.$111$7.94$103$7.23$5.57$1.66
2021Detailed filing. Detailed filing data is available for this year.$104$2.28$101$6.34$5.70$0.64
2020Summary only. Only limited summary data is available for this year.$101$0.00$7.28$5.13$2.15
2016Summary only. Only limited summary data is available for this year.$15.1$0.18$7.76$0.88$6.87
2015Summary only. Only limited summary data is available for this year.$8.28$0.23$4.18$0.92$3.26
2014Summary only. Only limited summary data is available for this year.$4.91$0.13$1.55$0.66$0.89
2013Summary only. Only limited summary data is available for this year.$3.89$0.00$0.81$0.68$0.12
2012Summary only. Only limited summary data is available for this year.$3.85$0.08$0.70$0.59$0.11