Civic Intelligence

The Graham Foundation

990T • Fiscal year 2023 • EIN 23-6805421

Jan 01, 2023 to Dec 31, 2023 • Filed on Oct 14, 2024

Organization Profile
1420 Sixth AvenueYork, PA 17403

(717) 849-4001

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.

$40M$30M$20M$10M$0Assets 2011: $16,050,382Liabilities 2011: $0Net Assets 2011: $16,050,3822011Assets 2020: $24,421,472Liabilities 2020: $0Net Assets 2020: $24,421,4722020Assets 2022: $29,780,224Liabilities 2022: $0Net Assets 2022: $29,780,2242022Assets 2024: $32,768,412Liabilities 2024: $0Net Assets 2024: $32,768,4122024

Latest loaded filing

2024

Assets$32,768,412
Liabilities$0
Net Assets$32,768,412
Open 2024 Filing

Operations Trend

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

$6.0M$4.0M$2.0M$0Expenses 2011: $1,065,0392011Revenue 2020: $4,812,518Expenses 2020: $3,900,097Net Income 2020: $912,4212020Revenue 2022: $3,715,600Expenses 2022: $3,310,512Net Income 2022: $405,0882022Revenue 2024: $5,234,415Expenses 2024: $3,252,544Net Income 2024: $1,981,8712024

Latest loaded filing

2024

Revenue$5,234,415
Expenses$3,252,544
Net Income$1,981,871
Open 2024 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Oct 14, 2024
Return Version
2023v7.0
Filing and Contact Details

Filer

Filer Name
The Graham Foundation
EIN
23-6805421
Phone
7178494001
Address
1420 SIXTH AVENUE, YORK, PA 17403

Signing Officer

Name
William H Kerlin Jr
Title
Trustee
Phone
7178494001
Signed
2024-10-14
Discuss with paid preparer
Yes

Preparer

Firm
Baker Tilly Advisory Group Lp
Address
1570 FRUITVILLE PIKE SUITE 400, LANCASTER, PA 17601
Preparer
Kerri N Bogda CPA
Phone
7177404863
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
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/NetLongTermGainOrLossGrp/TotalForYearAmt0-3325
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/NetSTCapitalGainOrLossAmt044735
IRS1041ScheduleD/EstateOrTrustCapGainOrLossGrp/TotalNetGainOrLossAmt041410
IRS1041ScheduleD/NetLTCapitalGainOrLossAmt0-3325
IRS1041ScheduleD/NetLTGainOrLossFromSchK1Amt0-3325
IRS1041ScheduleD/NetSTCapitalGainOrLossAmt044735
IRS1041ScheduleD/NetSTGainOrLossFromSchK1Amt0109235
IRS1041ScheduleD/STCapitalLossCarryoverAmt064500
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/NetLongTermGainOrLossGrp/TotalForYearAmt0-3325
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/NetSTCapitalGainOrLossAmt044735
IRS1041ScheduleD/TotalCapitalGainOrLossGrp/TotalNetGainOrLossAmt041410
IRS1041ScheduleI/AdjAlternativeMinTaxableIncAmt045793
IRS1041ScheduleI/AdjustedRegularTaxAmt014718
IRS1041ScheduleI/AdjustedTotalIncomeAmt045793
IRS1041ScheduleI/AlternativeMinimumTaxAmt00
IRS1041ScheduleI/AlternativeMinTaxableIncomeAmt045793
IRS1041ScheduleI/EstateOrTrustShrLessExemptAmt017393
IRS1041ScheduleI/MaximumCapitalGainsOrNetAmt04522
IRS1041ScheduleI/NetExemptionAmt028400
IRS1041ScheduleI/NetShareAltMinTaxbleIncomeAmt00
IRS1041ScheduleI/NetShareAltMinTxblIncmXPctAmt00
IRS1041ScheduleI/PassiveActivityAmt00
IRS1041ScheduleI/TentativeAlternativeMinTaxAmt04522
IRS990T/BooksInCareOfDetail/PersonNm0WILLIAM H KERLIN JR
IRS990T/BooksInCareOfDetail/PhoneNum07178494001
IRS990T/BooksInCareOfDetail/USAddress/AddressLine1Txt01420 SIXTH AVENUE
IRS990T/BooksInCareOfDetail/USAddress/CityNm0YORK
IRS990T/BooksInCareOfDetail/USAddress/StateAbbreviationCd0PA
IRS990T/BooksInCareOfDetail/USAddress/ZIPCd017403
IRS990T/BookValueAssetsEOYAmt030786541
IRS990T/CharitableContributionsDedAmt044794
IRS990T/EstimatedTaxPaymentsAmt05000
IRS990T/ForeignAccountsQuestionInd00
IRS990T/ForeignTrustQuestionInd00
IRS990T/Form2220AttachedInd0X
IRS990T/Form990TScheduleAAttachedCnt01
IRS990T/Organization501cTrustInd0X
IRS990T/Organization501IndicatorGrp/Organization501cTypeTxt0c3
IRS990T/Organization501IndicatorGrp/Organization501Ind0X
IRS990T/OtherTaxesAmt00
IRS990T/OverpaymentSection/AppliedToESTaxAmt02000
IRS990T/OverpaymentSection/OverpaymentAmt02282
IRS990T/OverpaymentSection/RefundAmt0282
IRS990T/PaidTaxLiabilityAmt00
IRS990T/PriorYearOverpaymentCreditAmt012000
IRS990TScheduleA/CapitalGainNetIncomeAmt041410
IRS990TScheduleA/NetOperatingLossDeductionAmt00
IRS990TScheduleA/PrincipalBusinessActivityCd0900099
IRS990TScheduleA/SequenceReferenceNum01
IRS990TScheduleA/SequenceTotalNum01
IRS990TScheduleA/TotalAllocableDeductionsAmt00
IRS990TScheduleA/TotalCtrlOrgDeductionAmt00
IRS990TScheduleA/TotalCtrlOrgPymtGrossIncmAmt00
IRS990TScheduleA/TotalDeductionsAmt00
IRS990TScheduleA/TotalDeductionSetAsidesAmt00
IRS990TScheduleA/TotalDirectAdvertisingCostAmt00
IRS990TScheduleA/TotalDividendsReceivedDedAmt00
IRS990TScheduleA/TotalGrossAdvertisingIncomeAmt00
IRS990TScheduleA/TotalGrossDebtFinancedIncmAmt00
IRS990TScheduleA/TotalInvestmentIncomeAmt00
IRS990TScheduleA/TotalPrtshpSCorpIncomeAmt049177
IRS990TScheduleA/TotalRentDeductionsAmt00
IRS990TScheduleA/TotalRentIncomeAmt00
IRS990TScheduleA/TotalUnrelatedBusinessCompAmt00
IRS990TScheduleA/TotExcessReadershipCostsDedAmt00
IRS990TScheduleA/TotNetUnrltTrdBusIncmAmt090587
IRS990TScheduleA/TotUnrltTrdBusIncmAmt090587
IRS990TScheduleA/TotUnrltTrdBusIncmExpnssAmt00
IRS990TScheduleA/TradeOrBusinessDesc0INVESTMENT ACTIVITIES
IRS990TScheduleA/UBIBeforeNOLDedAmt090587
IRS990TScheduleA/UnrelatedBusinessTaxblIncmAmt090587
IRS990T/SpecificDeductionAmt01000
IRS990T/SubsidiaryCorporationInd00
IRS990T/TaxableTrustAmt014718
IRS990T/TaxLessCreditsAmt014718
IRS990T/TaxRateScheduleInd0X
IRS990T/TotalDeductionAmt01000
IRS990T/TotalPaymentsAmt017000
IRS990T/TotalTaxAmt014718
IRS990T/TotalTaxComputationAmt014718
IRS990T/TotalUBTIAmt044793
IRS990T/TotalUBTIBeforeNOLSpecificAmt045793
IRS990T/TotalUBTIBeforeSection199AAmt045793
IRS990T/TotalUBTIComputedAmt090587
ReturnHeader/BuildTS02024-10-15 13:58:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0WILLIAM H KERLIN JR
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum07178494001
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-10-14
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0THE GRAHAM FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0GRAH
ReturnHeader/Filer/EIN0236805421
ReturnHeader/Filer/PhoneNum07178494001
ReturnHeader/Filer/USAddress/AddressLine1Txt01420 SIXTH AVENUE
ReturnHeader/Filer/USAddress/CityNm0YORK
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd017403
ReturnHeader/IRSResponsiblePrtyInfoCurrInd01
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0390859910
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0BAKER TILLY ADVISORY GROUP LP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01570 FRUITVILLE PIKE SUITE 400
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0LANCASTER
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd017601
ReturnHeader/PreparerPersonGrp/PhoneNum07177404863
ReturnHeader/PreparerPersonGrp/PreparationDt02024-10-14
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0KERRI N BOGDA CPA
ReturnHeader/ReturnTs02024-10-14T16:14:00-05: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.$32.8$0.00$32.8$5.23$3.25$1.98
2023Facts available. Structured filing facts are available, but richer extracted sections are limited.
2022Detailed filing. Detailed filing data is available for this year.$29.8$0.00$29.8$3.72$3.31$0.41
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$24.4$0.00$24.4$4.81$3.90$0.91
2011Detailed filing. Detailed filing data is available for this year.$16.1$0.00$16.1$1.07