Civic Intelligence

Glenn W Bailey Charitable Trust

990T • Fiscal year 2023 • EIN 88-6220262

Jan 01, 2023 to Dec 31, 2023 • Filed on Nov 15, 2024

Organization Profile
515 N Flagler Dr 500West Palm Beach, FL 33401

(561) 508-3858

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.

$300M$200M$100M$0Assets 2022: $231,230,737Liabilities 2022: $2,275Net Assets 2022: $231,228,4622022Assets 2023: $221,073,027Liabilities 2023: $2,3332023Assets 2024: $220,994,799Liabilities 2024: $3,097Net Assets 2024: $220,991,7022024

Latest loaded filing

2024

Assets$220,994,799
Liabilities$3,097
Net Assets$220,991,702
Open 2024 Filing

Operations Trend

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

$300M$200M$100M$0-$100MRevenue 2022: $236,439,801Expenses 2022: $6,718,817Net Income 2022: $229,720,9842022Revenue 2023: $1,367,556Expenses 2023: $11,525,324Net Income 2023: -$10,157,7682023Revenue 2024: $10,868,477Expenses 2024: $10,947,469Net Income 2024: -$78,9922024

Latest loaded filing

2024

Revenue$10,868,477
Expenses$10,947,469
Net Income-$78,992
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Nov 15, 2024
Return Version
2023v7.0
Filing and Contact Details

Filer

Filer Name
Glenn W Bailey Charitable Trust
EIN
88-6220262
Phone
5615083858
Address
515 N FLAGLER DR 500, WEST PALM BEACH, FL 33401

Signing Officer

Name
Stephen G Vogelsang Esq
Title
Trustee
Phone
5615083858
Signed
2024-11-15
Discuss with paid preparer
Yes

Preparer

Firm
Rsm US Llp
Address
201 FIRST ST SE STE 800, CEDAR RAPIDS, IA 52401-1425
Preparer
Shawna Huls
Phone
3192985333
Raw XML Appendix149 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
IRS1041ScheduleD/DiffOfSmallerAmt00
IRS1041ScheduleD/DiffOfSmllrPlusSmllrOfCalcAmt02116
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/NetLongTermGainOrLossGrp/TotalForYearAmt052779
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/TotalNetGainOrLossAmt052779
IRS1041ScheduleD/Form4797GainOrLossAmt052779
IRS1041ScheduleD/GainLessIncludedAmt052779
IRS1041ScheduleD/GainPlusDividendsAmt052779
IRS1041ScheduleD/InvestmentIncomeElectionAmt00
IRS1041ScheduleD/NetGainsTaxAmt02820
IRS1041ScheduleD/NetIncomeMinusSmallerAmt052779
IRS1041ScheduleD/NetLTCapitalGainOrLossAmt052779
IRS1041ScheduleD/NetSmallerAmt050663
IRS1041ScheduleD/NetTimesPercentAmt010133
IRS1041ScheduleD/SmallerGainAmt052779
IRS1041ScheduleD/SmallerOfCalcAmt02116
IRS1041ScheduleD/SmallerTaxableIncmOrAllowedAmt03000
IRS1041ScheduleD/SmallerTaxableIncomeOrNetAmt052779
IRS1041ScheduleD/SmallerTimesPercentAmt0317
IRS1041ScheduleD/SmllrTxblIncmOrOthAllowedAmt014650
IRS1041ScheduleD/SmllrTxiLessGainOrTxiOrAllwAmt03000
IRS1041ScheduleD/SmllrTxiOrAllwLessSmllrAmt02116
IRS1041ScheduleD/TaxableIncomeAmt065313
IRS1041ScheduleD/TaxableIncomeLessGainAmt012534
IRS1041ScheduleD/TaxAmt013270
IRS1041ScheduleD/TaxOnTaxableIncomeAmt022310
IRS1041ScheduleD/TaxPlusTimePercentAmt013270
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/NetLongTermGainOrLossGrp/TotalForYearAmt052779
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/TotalNetGainOrLossAmt052779
IRS1041ScheduleD/TxiLessGainPlusDiffOfSmllAmt012534
IRS1041ScheduleI/AdjAlternativeMinTaxableIncAmt066313
IRS1041ScheduleI/AdjustedRegularTaxAmt013270
IRS1041ScheduleI/AdjustedTotalIncomeAmt066313
IRS1041ScheduleI/AlternativeMinimumTaxAmt00
IRS1041ScheduleI/AlternativeMinTaxableIncomeAmt066313
IRS1041ScheduleI/ApplcblCapGainsOrSchDWrkshtAmt012534
IRS1041ScheduleI/CapitalGainsWorksheetAmt052779
IRS1041ScheduleI/EstateOrTrustShrLessExemptAmt037913
IRS1041ScheduleI/ExcessOfSumAmt035797
IRS1041ScheduleI/ExcessOfSumTimesPctAmt07159
IRS1041ScheduleI/FlngThrshldLessThesholdSumAmt02116
IRS1041ScheduleI/FSAmtLessIncAboveThresholdAmt00
IRS1041ScheduleI/IncomeAboveThresholdWorkshtAmt012534
IRS1041ScheduleI/MaximumCapitalGainsOrNetAmt07476
IRS1041ScheduleI/NetAltMinTaxableIncTimesPctAmt0317
IRS1041ScheduleI/NetAltMinTxblIncTimesFSPctAmt09857
IRS1041ScheduleI/NetExemptionAmt028400
IRS1041ScheduleI/NetShareAltMinTaxbleIncomeAmt00
IRS1041ScheduleI/NetShareAltMinTxblIncmXPctAmt00
IRS1041ScheduleI/PassiveActivityAmt00
IRS1041ScheduleI/SmallerOfAltMinTxblIncOrSumAmt037913
IRS1041ScheduleI/SmllrAdjNetGainOrTxblIncAmt02116
IRS1041ScheduleI/SmllrNetAdjAltMinOrNetGainAmt037913
IRS1041ScheduleI/SmllrOfAdjustedAltMinOrSchDAmt037913
IRS1041ScheduleI/SumOfAltMinTaxPercentagesAmt07476
IRS1041ScheduleI/SumOfSmllrAmt02116
IRS1041ScheduleI/SumPlusUnrecapturedSect1250Amt052779
IRS1041ScheduleI/SumThresholdApplcblWrkshtAmt012534
IRS1041ScheduleI/TaxOnAlternativeMinimumGainAmt07476
IRS1041ScheduleI/TentativeAlternativeMinTaxAmt07476
IRS990T/BooksInCareOfDetail/PersonNm0HAYLEY LITTLE
IRS990T/BooksInCareOfDetail/PhoneNum05615083858
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt0515 NORTH FLAGLER DRIVE SUITE 500
IRS990T/BooksInCareOfDetail/USAddress/CityNm0WEST PALM BEACH
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0FL
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd033401
IRS990T/BookValueAssetsEOYAmt0221073027
IRS990T/CharitableContributionsDedAmt065313
IRS990T/EstimatedTaxPaymentsAmt055000
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form1041ScheduleDInd0X
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OtherTaxesAmt00
IRS990T/OverpaymentSection/AppliedToESTaxAmt068219
IRS990T/OverpaymentSection/OverpaymentAmt068219
IRS990T/OverpaymentSection/RefundAmt00
IRS990T/PaidTaxLiabilityAmt00
IRS990T/PriorYearOverpaymentCreditAmt026489
IRS990TScheduleA/CapitalGainNetIncomeAmt052779
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0901101
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TaxesAndLicensesAmt01739
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt01739
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt080586
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt0133365
IRS990TScheduleA/TotUnrltTrdBusIncmAmt0133365
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENTS IN PARTNERSHIPS
IRS990TScheduleA/UBIBeforeNOLDedAmt0131626
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt0131626
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableTrustAmt013270
IRS990T/TaxLessCreditsAmt013270
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt081489
IRS990T/TotalTaxAmt013270
IRS990T/TotalTaxComputationAmt013270
IRS990T/TotalUBTIAmt065313
IRS990T/TotalUBTIBeforeNOLSpecificAmt066313
IRS990T/TotalUBTIBeforeSection199AAmt066313
IRS990T/TotalUBTIComputedAmt0131626
ReturnHeader/BuildTS02024-10-15 13:58:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0STEPHEN G VOGELSANG ESQ
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum05615083858
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-11-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GLENN W BAILEY CHARITABLE TRUST
ReturnHeader/Filer/BusinessNameControlTxt0GLEN
ReturnHeader/Filer/EIN0886220262
ReturnHeader/Filer/PhoneNum05615083858
ReturnHeader/Filer/USAddress/AddressLine1Txt0515 N FLAGLER DR 500
ReturnHeader/Filer/USAddress/CityNm0WEST PALM BEACH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0FL
ReturnHeader/Filer/USAddress/ZIPCd033401
ReturnHeader/IRSResponsiblePrtyInfoCurrInd00
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0420714325
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0RSM US LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0201 FIRST ST SE STE 800
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0CEDAR RAPIDS
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0524011425
ReturnHeader/PreparerPersonGrp/PhoneNum03192985333
ReturnHeader/PreparerPersonGrp/PreparationDt02024-11-08
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0SHAWNA HULS
ReturnHeader/ReturnTs02024-11-13T15:09:54-06:00
ReturnHeader/ReturnTypeCd0990T
ReturnHeader/TaxPeriodBeginDt02023-01-01
ReturnHeader/TaxPeriodEndDt02023-12-31
ReturnHeader/TaxYr02023

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
2024Detailed filing. Detailed filing data is available for this year.$221$0.00$221$10.9$10.9$0.08
2023Summary only. Only limited summary data is available for this year.$221$0.00$1.37$11.5$10.2
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.
2022Detailed filing. Detailed filing data is available for this year.$231$0.00$231$236$6.72$230