Civic Intelligence

John R Bertsch Charitable Foundation

990PF • Fiscal year 2013 • EIN 38-6517911

Jan 01, 2013 to Dec 31, 2013 • Filed on May 10, 2014

Organization Profile
2326 Elmwood Dr SEGrand Rapids, MI 49506

(616) 450-0206

Siviq Scores

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

Liabilities / Assets

95th percentile

1.00x

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

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

Liabilities / Revenue

95th percentile

1.00x

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

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

Net Margin

99th percentile

100%

Higher net margin than 99% of similar nonprofits.

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

Top Officer Pay

75th percentile

$0

Higher top officer pay than 75% of similar nonprofits.

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

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

Asset Growth

Score unavailable

No value available

A valid growth rate could not be computed from the available filing history.

Annualized from 2012 to 2013

Revenue Growth

48th percentile

0.0%

Faster revenue growth than 48% of similar nonprofits.

2013 filings • <$500k nonprofits • Annualized from 2011 to 2013

Balance Sheet
Liabilities / Assets95th percentile

Assets

Up

$1

Up $1 from 2012

Net Assets

Flat

$0

Flat from 2012

Liabilities

Up

$1

Up $1 from 2012

Revenue And Expenses
Liabilities / Revenue95th percentileNet Margin99th percentile

Revenue

$1

No earlier filing loaded for comparison.

Expenses

Flat

$0

Flat from 2012

Net Income

$1

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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: $1Net Assets 2013: $02013Assets 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: $12023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2013

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

Operations Trend

Revenue Growth48th 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

2013

Revenue$1
Expenses$0
Net Income$1
Open 2013 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
May 10, 2014
Return Version
2013v3.1
Compensation and Service Providers
Top Officer Pay75th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
JOHN BERTSCHOfficer-$0--
Filing and Contact Details

Filer

EIN
38-6517911
Phone
6164500206

Signing Officer

Name
John R Bertsch
Title
Officer
Phone
6164500206
Signed
2014-05-10
Discuss with paid preparer
Yes

Preparer

Preparer
Jennifer Madden
Phone
6164466537
Raw XML Appendix144 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
AllOthProgRltdInvestmentsSch/AllOtherProgramRelatedInvstGrp/Desc0None
IRS990PF/AddressChangeInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
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/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
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/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0JOHN BERTSCH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Officer
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine10644 Cascade Hills
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0Grand Rapids
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0MI
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode049546
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.000000
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.000000
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
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/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/IndividualWithBooksNm0JOHN BERTSCH
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine102326 Elmwood Dr SE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0Grand Rapids
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0MI
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode049506
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum06164500206
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
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/UndistributedIncomeCYAmt00
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0JOHN R BERTSCH
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0OFFICER
ReturnHeader/BusinessOfficerGrp/PhoneNum06164500206
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-05-10
ReturnHeader/Filer/BusinessName/BusinessNameLine10John R Bertsch Charitable Foundation
ReturnHeader/Filer/BusinessNameControlTxt0JOHN
ReturnHeader/Filer/EIN0386517911
ReturnHeader/Filer/PhoneNum06164500206
ReturnHeader/Filer/USAddress/AddressLine102326 Elmwood Dr SE
ReturnHeader/Filer/USAddress/City0Grand Rapids
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode049506
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine10The Family Financials LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine102326 Elmwood Dr SE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/City0Grand Rapids
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/State0MI
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCode049506
ReturnHeader/PreparerPersonGrp/PhoneNum06164466537
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JENNIFER MADDEN
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02014-05-15T13:44:04-07:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2013 • 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
2023XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1$1$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
2013Detailed filing. Detailed filing data is available for this year.$1$1$0$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
Peer Organizations

Similar nonprofits based on the same Siviq industry and scale cohort. 2013 filings • <$500k nonprofits