Civic Intelligence

Bern Community Support Foundation

990EZ • Fiscal year 2022 • EIN 48-1222524

Jan 01, 2022 to Dec 31, 2022 • Filed on May 10, 2023

Organization ProfileN/A
PO Box 123Bern, KS 66408

(785) 336-6121

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 2022

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2022

Net Margin

6th percentile

-115%

Higher net margin than 6% of similar nonprofits.

2022 filings • 501(c)3 • <$500k nonprofits • Source year 2022

Top Officer Pay

78th percentile

$0

Higher top officer pay than 78% of similar nonprofits.

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

2022 filings • 501(c)3 • <$500k nonprofits • Source year 2022

Asset Growth

29th percentile

-12%

Faster asset growth than 29% of similar nonprofits.

2022 filings • 501(c)3 • <$500k nonprofits • Annualized from 2021 to 2022

Revenue Growth

20th percentile

-27%

Faster revenue growth than 20% of similar nonprofits.

2022 filings • 501(c)3 • <$500k nonprofits • Annualized from 2021 to 2022

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$126,477

Down $16,815 (-12%) from 2021

Net Assets

Down

$126,477

Down $16,815 (-12%) from 2021

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin6th percentile

Revenue

Down

$14,644

Down $5,457 (-27%) from 2021

Expenses

Up

$31,459

Up $19,954 (+173%) from 2021

Net Income

Down

-$16,815

Down $25,411 (-296%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth29th percentile

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

$150K$100K$50K$0Assets 2011: $55,666Liabilities 2011: $02011Assets 2012: $54,920Liabilities 2012: $02012Assets 2013: $55,626Liabilities 2013: $02013Assets 2014: $57,932Liabilities 2014: $02014Assets 2015: $124,486Liabilities 2015: $02015Assets 2016: $123,247Liabilities 2016: $02016Assets 2017: $130,284Liabilities 2017: $02017Assets 2018: $128,241Liabilities 2018: $02018Assets 2019: $133,721Liabilities 2019: $02019Assets 2020: $134,696Liabilities 2020: $02020Assets 2021: $143,292Net Assets 2021: $143,2922021Assets 2022: $126,477Net Assets 2022: $126,4772022Assets 2023: $147,244Liabilities 2023: $02023Assets 2024: $147,469Net Assets 2024: $147,4692024

Highlighted filing

2022

Assets$126,477
Liabilities-
Net Assets$126,477
Open 2022 Filing

Operations Trend

Revenue Growth20th percentile

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

$100K$50K$0-$50KRevenue 2011: $26,253Expenses 2011: $14,500Net Income 2011: $11,7532011Revenue 2012: $8,116Expenses 2012: $8,862Net Income 2012: -$7462012Revenue 2013: $16,766Expenses 2013: $16,060Net Income 2013: $7062013Revenue 2014: $20,793Expenses 2014: $18,487Net Income 2014: $2,3062014Revenue 2015: $84,420Expenses 2015: $17,866Net Income 2015: $66,5542015Revenue 2016: $15,886Expenses 2016: $17,125Net Income 2016: -$1,2392016Revenue 2017: $21,776Expenses 2017: $14,739Net Income 2017: $7,0372017Revenue 2018: $19,426Expenses 2018: $21,469Net Income 2018: -$2,0432018Revenue 2019: $33,613Expenses 2019: $28,133Net Income 2019: $5,4802019Revenue 2020: $10,996Expenses 2020: $10,021Net Income 2020: $9752020Revenue 2021: $20,101Expenses 2021: $11,505Net Income 2021: $8,5962021Revenue 2022: $14,644Expenses 2022: $31,459Net Income 2022: -$16,8152022Revenue 2023: $36,837Expenses 2023: $16,070Net Income 2023: $20,7672023Revenue 2024: $40,100Expenses 2024: $39,875Net Income 2024: $2252024

Highlighted filing

2022

Revenue$14,644
Expenses$31,459
Net Income-$16,815
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
May 10, 2023
Return Version
2022v5.0
Gross Receipts
$14,644
Mission and Program Overview

Mission

To Enhance the Quality of Life in the Bern Communiity

Program Services

DescriptionGrantsExpenses
Grants to local organizations to facilitate the quality of life in Bern KS$11,000-
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Brent LortscherPresident-$0--
Renee MeyerTreasurer-$0--
Tiffany KorberSecretary-$0--
Caleb MeyerVice Presdient-$0--
Filing and Contact Details

Filer

Filer Name
Bern Community Support Foundation
EIN
48-1222524
Phone
7853366121
Address
PO Box 123, Bern, KS 66408

Signing Officer

Name
Brent Lortscher
Title
President
Phone
7853366121
Signed
2023-05-10
Discuss with paid preparer
No
Supplemental Narrative

Additional Explanations

Form 990-EZ, Part I, Line 10, Grants Paid

“Activity Scholarships, Grantee Various, Cash Grant 7,000, Relationship”

Form 990-EZ, Part I, Line 10, Grants Paid

“Activity FIreworks Contribution, Grantee Bern FIre Dept, Cash Grant 6,000, Relationship”

Form 990-EZ, Part I, Line 16, Other Expenses

“State Kansas Annual Report Fee 40”

Form 990-EZ, Part I, Line 16, Other Expenses

“Investment Losses 9,270”

Raw XML Appendix179 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
IRS990EZ/ActivitiesNotPreviouslyRptInd0false
IRS990EZ/BooksInCareOfDetail/PersonNm0Renee Meyer
IRS990EZ/BooksInCareOfDetail/PhoneNum07853363906
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0PO Box 123
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0Bern
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0KS
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd066408
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt086860
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt070045
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt09342
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-16815
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0143292
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0126477
IRS990EZ/GrantsAndSimilarAmountsPaidAmt014000
IRS990EZ/GrossReceiptsAmt014644
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt05302
IRS990EZ/LandAndBuildingsGrp/BOYAmt056432
IRS990EZ/LandAndBuildingsGrp/EOYAmt056432
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0143292
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0126477
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0143292
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0126477
IRS990EZ/OccupancyRentUtltsAndMaintAmt07230
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt0001.11
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt1001.11
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt2001.11
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt3001.11
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0Brent Lortscher
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1Renee Meyer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2Tiffany Korber
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3Caleb Meyer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Secretary
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Vice Presdient
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherExpensesTotalAmt09310
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0To Enhance the Quality of Life in the Bern Communiity
IRS990EZ/PrintingPublicationsPostageAmt0919
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Grants to local organizations to facilitate the quality of life in Bern KS
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt011000
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0KS
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt031459
IRS990EZ/TotalRevenueAmt014644
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus1YearAmt011337
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt02225
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt019943
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt013320
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt046825
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt09342
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt011337
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt02225
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt019943
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt013320
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt056167
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus1YearAmt08733
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt08701
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt06692
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt06106
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt030232
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearAmt05302
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt08732
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt08701
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt06692
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt06106
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt035533
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearAmt05302
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt08732
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt08701
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt06692
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt06106
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt035533
IRS990ScheduleA/InvestmentIncomeCYPct00.38750
IRS990ScheduleA/InvestmentIncomePYPct00.42550
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY170Pct00.60770
IRS990ScheduleA/PublicSupportCY509Pct00.61250
IRS990ScheduleA/PublicSupportPY170Pct00.57450
IRS990ScheduleA/PublicSupportPY509Pct00.57450
IRS990ScheduleA/PublicSupportTotal170Amt046825
IRS990ScheduleA/PublicSupportTotal509Amt056167
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY170Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt09342
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt011337
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt02225
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt019943
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt013320
IRS990ScheduleA/Total509Grp/TotalAmt056167
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus1YearAmt011337
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt02225
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt019943
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt013320
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt046825
IRS990ScheduleA/TotalSupportAmt077057
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt014644
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt020069
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt010926
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt026635
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt019426
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt091700
IRS990ScheduleB/ContributorInformationGrp/ContributorBusinessName/BusinessNameLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorNum0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine10RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine20RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/City0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/State0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCode0RESTRICTED
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0RESTRICTED
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0Activity Scholarships, Grantee Various, Cash Grant 7,000, Relationship
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1Activity FIreworks Contribution, Grantee Bern FIre Dept, Cash Grant 6,000, Relationship
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2State Kansas Annual Report Fee 40
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Investment Losses 9,270
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 10, Grants Paid
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 990-EZ, Part I, Line 10, Grants Paid
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Form 990-EZ, Part I, Line 16, Other Expenses
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Form 990-EZ, Part I, Line 16, Other Expenses
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd03
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0Brent Lortscher
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/PhoneNum07853366121
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-05-10
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BERN COMMUNITY SUPPORT FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0BERN
ReturnHeader/Filer/EIN0481222524
ReturnHeader/Filer/PhoneNum07853366121
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO Box 123
ReturnHeader/Filer/USAddress/CityNm0Bern
ReturnHeader/Filer/USAddress/StateAbbreviationCd0KS
ReturnHeader/Filer/USAddress/ZIPCd066408
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/ReturnTs02023-05-12T10:52:11-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Brent
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Lortscher
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$126,477
Liabilities
-
Net assets
$126,477
Revenue
$14,644
Expenses
$31,459
Net income
-$16,815
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$1.47$1.47$0.40$0.40$0.00
2023Summary only. Only limited summary data is available for this year.$1.47$0.00$0.37$0.16$0.21
2022Detailed filing. Detailed filing data is available for this year.$1.26$1.26$0.15$0.31$0.17
2021Detailed filing. Detailed filing data is available for this year.$1.43$1.43$0.20$0.12$0.09
2020Summary only. Only limited summary data is available for this year.$1.35$0.00$0.11$0.10$0.01
2019Summary only. Only limited summary data is available for this year.$1.34$0.00$0.34$0.28$0.05
2018Summary only. Only limited summary data is available for this year.$1.28$0.00$0.19$0.21$0.02
2017Summary only. Only limited summary data is available for this year.$1.30$0.00$0.22$0.15$0.07
2016Summary only. Only limited summary data is available for this year.$1.23$0.00$0.16$0.17$0.01
2015Summary only. Only limited summary data is available for this year.$1.24$0.00$0.84$0.18$0.67
2014Summary only. Only limited summary data is available for this year.$0.58$0.00$0.21$0.18$0.02
2013Summary only. Only limited summary data is available for this year.$0.56$0.00$0.17$0.16$0.01
2012Summary only. Only limited summary data is available for this year.$0.55$0.00$0.08$0.09$0.01
2011Summary only. Only limited summary data is available for this year.$0.56$0.00$0.26$0.15$0.12