Civic Intelligence

John R Bertsch Charitable Foundation

990PF • Fiscal year 2023 • EIN 38-6517911

Jan 01, 2023 to Dec 31, 2023 • Filed on Dec 04, 2024

Organization Profile
2739 Elmwood Dr SEGrand Rapids, MI 49506

(616) 446-6537

Siviq Scores

Precomputed percentiles for this filing year versus similar nonprofits in the same peer cohort.

Liabilities / Assets

96th percentile

1.00x

Higher debt load relative to assets than 96% of similar nonprofits.

2023 filings • <$500k nonprofits • Source year 2023

Liabilities / Revenue

96th percentile

1.00x

Higher debt load relative to revenue than 96% of similar nonprofits.

2023 filings • <$500k nonprofits • Source year 2023

Net Margin

99th percentile

100%

Higher net margin than 99% of similar nonprofits.

2023 filings • <$500k nonprofits • Source year 2023

Top Officer Pay

79th percentile

$0

Higher top officer pay than 79% of similar nonprofits.

Top officer pay equals 0.0% of source-year revenue.

2023 filings • <$500k nonprofits • Source year 2023

Asset Growth

51st percentile

0.0%

Faster asset growth than 51% of similar nonprofits.

2023 filings • <$500k nonprofits • Annualized from 2022 to 2023

Revenue Growth

45th percentile

0.0%

Faster revenue growth than 45% of similar nonprofits.

2023 filings • <$500k nonprofits • Annualized from 2022 to 2023

Balance Sheet
Liabilities / Assets96th percentile

Assets

Up

$1

Up $1 from 2022

Net Assets

Flat

$0

Flat from 2022

Liabilities

Up

$1

Up $1 from 2022

Revenue And Expenses
Liabilities / Revenue96th percentileNet Margin99th percentile

Revenue

Up

$1

Up $1 from 2022

Expenses

Flat

$0

Flat from 2022

Net Income

Up

$1

Up $1 from 2022

Historical Trend

Balance Sheet Trend

Asset Growth51st percentile

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

$1$0Assets 2010: $0Liabilities 2010: $0Net Assets 2010: $02010Assets 2011: $1Liabilities 2011: $12011Assets 2012: $0Liabilities 2012: $0Net Assets 2012: $02012Assets 2013: $1Liabilities 2013: $12013Assets 2014: $0Liabilities 2014: $0Net Assets 2014: $02014Assets 2015: $1Liabilities 2015: $1Net Assets 2015: $02015Assets 2016: $0Liabilities 2016: $0Net Assets 2016: $02016Assets 2017: $0Liabilities 2017: $0Net Assets 2017: $02017Assets 2018: $0Liabilities 2018: $0Net Assets 2018: $02018Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020Assets 2021: $0Liabilities 2021: $0Net Assets 2021: $02021Assets 2022: $0Liabilities 2022: $0Net Assets 2022: $02022Assets 2023: $1Liabilities 2023: $1Net Assets 2023: $02023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2023

Assets$1
Liabilities$1
Net Assets$0
Open 2023 Filing

Operations Trend

Revenue Growth45th percentile

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

$1$0Expenses 2010: $02010Revenue 2011: $1Expenses 2011: $0Net Income 2011: $12011Expenses 2012: $02012Revenue 2013: $1Expenses 2013: $0Net Income 2013: $12013Revenue 2014: $0Expenses 2014: $0Net Income 2014: $02014Revenue 2015: $1Expenses 2015: $0Net Income 2015: $12015Revenue 2016: $0Expenses 2016: $0Net Income 2016: $02016Revenue 2017: $0Expenses 2017: $0Net Income 2017: $02017Revenue 2018: $0Expenses 2018: $0Net Income 2018: $02018Revenue 2020: $0Expenses 2020: $0Net Income 2020: $02020Revenue 2021: $0Expenses 2021: $0Net Income 2021: $02021Revenue 2022: $0Expenses 2022: $0Net Income 2022: $02022Revenue 2023: $1Expenses 2023: $0Net Income 2023: $12023Revenue 2024: $0Expenses 2024: $0Net Income 2024: $02024

Highlighted filing

2023

Revenue$1
Expenses$0
Net Income$1
Open 2023 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Dec 4, 2024
Return Version
2023v5.1
Compensation and Service Providers
Top Officer Pay79th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
John BertschPresident-$0--
Filing and Contact Details

Filer

Filer Name
The John R Bertsch Charitable Foundation
EIN
38-6517911
Phone
6164466537
Address
2739 Elmwood Dr SE, Grand Rapids, MI 49506

Signing Officer

Name
John Bertsch
Title
President
Signed
2024-12-04
Discuss with paid preparer
Yes

Preparer

Firm
The Family Financials LLC
Address
2739 Elmwood Dr SE, Grand Rapids, MI 49506-4260
Preparer
Jennifer Madden
Phone
6164466537
Raw XML Appendix130 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
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt00
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0John Bertsch
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0President
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt02739 Elmwood Dr SE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Grand Rapids
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd049506
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0false
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt02739 Elmwood Dr SE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Grand Rapids
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd049506
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0Jennifer Madden
IRS990PF/StatementsRegardingActyGrp/PhoneNum06164466537
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
ReturnHeader/BuildTS02024-10-15 13:58:12Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0John Bertsch
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02024-12-04
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0The John R Bertsch Charitable Foundation
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0386517911
ReturnHeader/Filer/PhoneNum06164466537
ReturnHeader/Filer/USAddress/AddressLine1Txt02739 Elmwood Dr SE
ReturnHeader/Filer/USAddress/CityNm0Grand Rapids
ReturnHeader/Filer/USAddress/StateAbbreviationCd0MI
ReturnHeader/Filer/USAddress/ZIPCd049506
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0264362596
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0The Family Financials LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02739 Elmwood Dr SE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Grand Rapids
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0495064260
ReturnHeader/PreparerPersonGrp/PhoneNum06164466537
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Jennifer Madden
ReturnHeader/ReturnTs02024-12-04T11:06:56-08:00
ReturnHeader/ReturnTypeCd0990PF
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 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$1
Liabilities
$1
Net assets
$0
Revenue
$1
Expenses
$0
Net income
$1
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0$0$0$0$0$0
2023Detailed filing. Detailed filing data is available for this year.$1$1$0$1$0$1
2022XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0$0$0$0$0$0
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0$0$0$0$0$0
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0$0$0$0$0$0
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0$0$0$0$0$0
2017XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0$0$0$0$0$0
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$0$0$0$0$0$0
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1$1$0$1$0$1
2014Import issue. A filing source exists for this year, but detailed import did not complete cleanly.$0$0$0$0$0$0
2013XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1$1$1$0$1
2012Detailed filing. Detailed filing data is available for this year.$0$0$0$0
2011Summary only. Only limited summary data is available for this year.$1$1$1$0$1
2010Detailed filing. Detailed filing data is available for this year.$0$0$0$0