Civic Intelligence

John R Bertsch Charitable Foundation

990PF • Fiscal year 2012 • EIN 38-6517911

Jan 01, 2012 to Dec 31, 2012 • Filed on Mar 25, 2013

Organization Profile
644 Cascade Hills Hollow49546
Siviq Scores

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

Liabilities / Assets

Score unavailable

No value available

Liabilities-to-assets requires both liabilities and assets on this filing.

Source year 2012

Liabilities / Revenue

Score unavailable

No value available

Liabilities-to-revenue requires both liabilities and revenue on this filing.

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

82nd percentile

$0

Higher top officer pay than 82% of similar nonprofits.

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

Asset Growth

1st percentile

-100%

Faster asset growth than 1% of similar nonprofits.

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

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $1 (-100%) from 2011

Net Assets

$0

No earlier filing loaded for comparison.

Liabilities

Down

$0

Down $1 (-100%) from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Flat

$0

Flat from 2011

Net Income

-

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset Growth1st 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: $12023Assets 2024: $0Liabilities 2024: $0Net Assets 2024: $02024

Highlighted filing

2012

Assets$0
Liabilities$0
Net Assets$0
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

2012

Revenue-
Expenses$0
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Mar 25, 2013
Return Version
2012v2.0
Compensation and Service Providers
Top Officer Pay82nd percentile

Employees

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

Filer

EIN
38-6517911
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
AllOthProgRltdInvestmentsSch/AllOthProgRltdInvestments/Description0None
IRS990PF/AddressChange0X
IRS990PF/AnalysisOfRevenueAndExpenses/CapitalGainNetIncmNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriGiftsPaidRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessOfRevenueOverExpenses00
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/NotRequiredToAttachScheduleB0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnss00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvestmentIncome00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevenueAndExpenses00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblPrps00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncm00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnss00
IRS990PF/BalanceSheets/OrgThatDoNotFollowSFAS1170X
IRS990PF/BalanceSheets/TotalAssetsEOY00
IRS990PF/BalanceSheets/TotalAssetsEOYFMV00
IRS990PF/BalanceSheets/TotalLiabilitiesEOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsBOY00
IRS990PF/BalanceSheets/TotalLiabilitiesNetAssetsEOY00
IRS990PF/BalanceSheets/TotalNetAssetsEOY00
IRS990PF/DistributableAmount/DistributableAmountAsAdjusted00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/AmountCreditedToNextYear00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/DomesticOrgMeetingSect4940e0X
IRS990PF/ExciseTaxBasedOnInvestmentIncm/InvestmentIncomeExciseTax00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxBasedOnInvestmentIncome00
IRS990PF/ExciseTaxBasedOnInvestmentIncm/TaxUnderSection51100
IRS990PF/ExemptPF0X
IRS990PF/FMVAssetsEOY00
IRS990PF/MethodOfAccountingCash0X
IRS990PF/MinimumInvestmentReturn/AdjTotalFMVOfUnusedAssets00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyCashBalances00
IRS990PF/MinimumInvestmentReturn/AvgMonthlyFMVOfSecurities00
IRS990PF/MinimumInvestmentReturn/CashDeemedCharitable00
IRS990PF/MinimumInvestmentReturn/FMVAllOtherNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/MinimumInvestmentReturn00
IRS990PF/MinimumInvestmentReturn/NetNoncharitableAssets00
IRS990PF/MinimumInvestmentReturn/TotalFMVOfUnusedAssets00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHghstPaidCntrctNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/CompOfHighestPaidEmplNONE0NONE
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/AvgHoursPerWkDevotedToPosition00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Compensation00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ContriToEmplBenefitPlansEtc00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/ExpenseAccountOtherAllowances00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/PersonName0JOHN RBERTSCH
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/Title0Officer
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/AddressLine10644 CASCADE HILLS HOLLOW
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/City0GRAND RAPIDS
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/State0MI
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/OfcrDirTrusteesOrKeyEmployee/USAddress/ZIPCode049546
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfCntrctPaidOver50k00
IRS990PF/OfcrDirTrusteesKeyEmployeeInfo/TotNumberOfOthEmplPaidOver50k00
IRS990PF/QlfyUndSect4940eForReducedTax/AdjNonchrtblAssetsAndOnePct00
IRS990PF/QlfyUndSect4940eForReducedTax/AverageDistributionRatio00.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear100.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear200.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear300.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear400.000000
IRS990PF/QlfyUndSect4940eForReducedTax/DistributionRatioYear500.000000
IRS990PF/QlfyUndSect4940eForReducedTax/QualifyingDistributions00
IRS990PF/QlfyUndSect4940eForReducedTax/TotalDistributionRatio00.000000
IRS990PF/QualifyingDistributions/ExpensesAndContributions00
IRS990PF/StatementsRegardingActivities/ActivitiesNotPrevReported0false
IRS990PF/StatementsRegardingActivities/ApplicableInsuranceContract0false
IRS990PF/StatementsRegardingActivities/AtLeast5000InAssets0false
IRS990PF/StatementsRegardingActivities/BooksInCareOfPersonName0JOHN BERTSCH
IRS990PF/StatementsRegardingActivities/BooksInCareOfPhoneNumber06164500206
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/AddressLine10644 CASVADE HILLS HOLLOW
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/City0GRAND RAPIDS
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/State0MI
IRS990PF/StatementsRegardingActivities/BooksInCareOfUSAddress/ZIPCode049546
IRS990PF/StatementsRegardingActivities/ChangesToArticlesOrBylaws0false
IRS990PF/StatementsRegardingActivities/ComplyWithPublicInspectionRqr0true
IRS990PF/StatementsRegardingActivities/ForeignBank0false
IRS990PF/StatementsRegardingActivities/Form1120POLFiled0false
IRS990PF/StatementsRegardingActivities/InterestInControlledEntity0false
IRS990PF/StatementsRegardingActivities/LegislativePoliticalActivities0false
IRS990PF/StatementsRegardingActivities/MoreThan100Spent0false
IRS990PF/StatementsRegardingActivities/NewSubstantialContributors0false
IRS990PF/StatementsRegardingActivities/PrivateOperatingFoundation0false
IRS990PF/StatementsRegardingActivities/RequirementsOfSect508e0true
IRS990PF/StatementsRegardingActivities/TerminationEtc0false
IRS990PF/StatementsRegardingActivities/UnrelatedBusIncomeOver10000false
IRS990PF/StatementsRegardingActivities/WebsiteAddress0N/A
IRS990PF/StatementsRegardingActy4720/BorrowOrLendWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/BusinessHoldings0false
IRS990PF/StatementsRegardingActy4720/FurnishedGoodsWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/GrantsToIndividuals0false
IRS990PF/StatementsRegardingActy4720/GrantsToOrganizations0false
IRS990PF/StatementsRegardingActy4720/InfluenceElection0false
IRS990PF/StatementsRegardingActy4720/InfluenceLegislation0false
IRS990PF/StatementsRegardingActy4720/JeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/MaintExpendResponsibility0false
IRS990PF/StatementsRegardingActy4720/NoncharitablePurpose0false
IRS990PF/StatementsRegardingActy4720/PayCompensationToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/PaymentToGovernmentOffical0false
IRS990PF/StatementsRegardingActy4720/PayPremiumsPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/ProceedsOrNetIncome0false
IRS990PF/StatementsRegardingActy4720/ProhibitedTaxShelterTransactn0false
IRS990PF/StatementsRegardingActy4720/RcvFundsToPayPrsnlBnftContract0false
IRS990PF/StatementsRegardingActy4720/SaleOrExchangeWithDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/TransferAssetsToDsqflyPerson0false
IRS990PF/StatementsRegardingActy4720/UncorrectedJeopardyInvestments0false
IRS990PF/StatementsRegardingActy4720/UncorrectedPriorActs0false
IRS990PF/StatementsRegardingActy4720/UndistributedIncomePriorYears0false
IRS990PF/StatementsRegardingActy4720/UndistrIncome4942a2NotApplied0false
IRS990PF/SupplementaryInformation/ContributingManager0NONE
IRS990PF/SupplementaryInformation/OnlyContributesToPreselected0X
IRS990PF/SupplementaryInformation/ShareholderManager0NONE
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/LoansOrLoanGuarantees0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PerformanceOfServicesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/PurchaseAssetsNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/ReimbursementArrangements0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RelationshipsNoncharitableEOs0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/RentalOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SalesOrExchangesOfAssets0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/SharingOfFacilitiesEtc0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOfCashToNoncharitableEO0false
IRS990PF/TrnsfrTrRlnWithNoncharitableEO/TrnsfrOthAssetsNoncharitableEO0false
IRS990PF/UndistributedIncome/DistributableAmountAsAdjusted00
IRS990PF/UndistributedIncome/UndistributedIncomeCY00
ReturnHeader/BuildTS02016-02-24 21:20:13Z
ReturnHeader/Filer/EIN0386517911
ReturnHeader/Filer/Name/BusinessNameLine10JOHN R BERTSCH CHARITABLE FOUNDATION
ReturnHeader/Filer/NameControl0JOHN
ReturnHeader/Filer/Phone06164500206
ReturnHeader/Filer/USAddress/AddressLine10644 CASCADE HILLS HOLLOW
ReturnHeader/Filer/USAddress/City0GRAND RAPIDS
ReturnHeader/Filer/USAddress/State0MI
ReturnHeader/Filer/USAddress/ZIPCode049546
ReturnHeader/Officer/DateSigned02013-03-25
ReturnHeader/Officer/Name0JOHN R BERTSCH
ReturnHeader/Officer/Phone06164500206
ReturnHeader/Officer/Title0OFFICER
ReturnHeader/PreparerFirm/PreparerFirmBusinessName/BusinessNameLine10THE FAMILY FINANCIALS LLC
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/AddressLine102326 ELMWOOD DR SE
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/City0GRAND RAPIDS
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/State0MI
ReturnHeader/PreparerFirm/PreparerFirmUSAddress/ZIPCode049506
ReturnHeader/Preparer/Name0JENNIFER MADDEN
ReturnHeader/Preparer/Phone06164466537
ReturnHeader/Preparer/SelfEmployed0X
ReturnHeader/ReturnType0990PF
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-04-05T14:09:42-07:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$0
Liabilities
$0
Net assets
$0
Revenue
-
Expenses
$0
Net income
-
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
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