Civic Intelligence

Bern Community Support Foundation

990EZ • Fiscal year 2023 • EIN 48-1222524

Jan 01, 2023 to Dec 31, 2023 • Filed on Apr 25, 2024

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 2023

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2023

Net Margin

92nd percentile

56%

Higher net margin than 92% of similar nonprofits.

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

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.

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

Asset Growth

70th percentile

16%

Faster asset growth than 70% of similar nonprofits.

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

Revenue Growth

93rd percentile

152%

Faster revenue growth than 93% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Flat

$147,244

Flat from 2023

Net Assets

$147,244

No earlier filing loaded for comparison.

Liabilities

-

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet Margin92nd percentile

Revenue

Flat

$36,837

Flat from 2023

Expenses

Flat

$16,070

Flat from 2023

Net Income

Flat

$20,767

Flat from 2023

Historical Trend

Balance Sheet Trend

Asset Growth70th 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,244Net Assets 2023: $147,2442023Assets 2023: $147,244Liabilities 2023: $02023Assets 2024: $147,469Net Assets 2024: $147,4692024

Highlighted filing

2023

Assets$147,244
Liabilities-
Net Assets$147,244
Open 2023 Filing

Operations Trend

Revenue Growth93rd 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 2023: $36,837Expenses 2023: $16,070Net Income 2023: $20,7672023Revenue 2024: $40,100Expenses 2024: $39,875Net Income 2024: $2252024

Highlighted filing

2023

Revenue$36,837
Expenses$16,070
Net Income$20,767
Open 2023 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2023 to Dec 31, 2023
Signed
Apr 25, 2024
Return Version
2023v5.1
Gross Receipts
$36,837
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--
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
In Care Of
% Brent Lortscher
Phone
7853366121
Address
PO Box 123, Bern, KS 66408

Signing Officer

Name
Brent Lortscher
Title
President
Phone
7853366121
Signed
2024-04-25
Discuss with paid preparer
No
Supplemental Narrative

Additional Explanations

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

“Activity Scholarships, Grantee Various, Cash Grant 5,093, Relationship”

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

“State Kansas Annual Report Fee 40”

Raw XML Appendix168 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/BOYAmt070045
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt090812
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt022479
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt020767
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form720FiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt0126477
IRS990EZ/Form990TotalAssetsGrp/EOYAmt0147244
IRS990EZ/GrantsAndSimilarAmountsPaidAmt09993
IRS990EZ/GrossReceiptsAmt036837
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/InvestmentIncomeAmt014358
IRS990EZ/LandAndBuildingsGrp/BOYAmt056432
IRS990EZ/LandAndBuildingsGrp/EOYAmt056432
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt0126477
IRS990EZ/NetAssetsOrFundBalancesEOYAmt0147244
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt0126477
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt0147244
IRS990EZ/OccupancyRentUtltsAndMaintAmt06037
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/OtherExpensesTotalAmt040
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0To Enhance the Quality of Life in the Bern Communiity
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0Grants to local organizations to facilitate the quality of life in Bern KS
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/RelatedOrgSect527OrgInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/StatesWhereCopyOfReturnIsFldCd0KS
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TotalExpensesAmt016070
IRS990EZ/TotalRevenueAmt036837
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus2YearsAmt011337
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus3YearsAmt02225
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/CurrentTaxYearMinus4YearsAmt019943
IRS990ScheduleA/GiftsGrantsContriRcvd170Grp/TotalAmt033505
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt022464
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus1YearAmt09342
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus2YearsAmt011337
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus3YearsAmt02225
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearMinus4YearsAmt019943
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt065311
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus2YearsAmt08733
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus3YearsAmt08701
IRS990ScheduleA/GrossInvestmentIncome170Grp/CurrentTaxYearMinus4YearsAmt06692
IRS990ScheduleA/GrossInvestmentIncome170Grp/TotalAmt024126
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus1YearAmt05302
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus2YearsAmt08732
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus3YearsAmt08701
IRS990ScheduleA/GrossInvestmentIncome509Grp/CurrentTaxYearMinus4YearsAmt06692
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt029427
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus1YearAmt05302
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus2YearsAmt08732
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus3YearsAmt08701
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/CurrentTaxYearMinus4YearsAmt06692
IRS990ScheduleA/InvestmentIncomeAndUBTIGrp/TotalAmt029427
IRS990ScheduleA/InvestmentIncomeCYPct00.31060
IRS990ScheduleA/InvestmentIncomePYPct00.38750
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.68940
IRS990ScheduleA/PublicSupportPY509Pct00.61250
IRS990ScheduleA/PublicSupportTotal170Amt033505
IRS990ScheduleA/PublicSupportTotal509Amt065311
IRS990ScheduleA/ThirtyThrPctSuprtTestsCY509Ind0X
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt022464
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus1YearAmt09342
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus2YearsAmt011337
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus3YearsAmt02225
IRS990ScheduleA/Total509Grp/CurrentTaxYearMinus4YearsAmt019943
IRS990ScheduleA/Total509Grp/TotalAmt065311
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus2YearsAmt011337
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus3YearsAmt02225
IRS990ScheduleA/TotalCalendarYear170Grp/CurrentTaxYearMinus4YearsAmt019943
IRS990ScheduleA/TotalCalendarYear170Grp/TotalAmt033505
IRS990ScheduleA/TotalSupportAmt057631
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt022464
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus1YearAmt014644
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus2YearsAmt020069
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus3YearsAmt010926
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearMinus4YearsAmt026635
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt094738
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 5,093, Relationship
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1State Kansas Annual Report Fee 40
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Form 990-EZ, Part I, Line 10, Grants Paid
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Form 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/SignatureDt02024-04-25
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BERN COMMUNITY SUPPORT FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0BERN
ReturnHeader/Filer/EIN0481222524
ReturnHeader/Filer/InCareOfNm0% Brent Lortscher
ReturnHeader/Filer/PhoneNum07853366121
ReturnHeader/Filer/USAddress/AddressLine1Txt0PO Box 123
ReturnHeader/Filer/USAddress/CityNm0Bern
ReturnHeader/Filer/USAddress/StateAbbreviationCd0KS
ReturnHeader/Filer/USAddress/ZIPCd066408
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0true
ReturnHeader/ReturnTs02024-06-20T02:02:02-00:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Brent
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0Lortscher
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 990EZDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$147,244
Liabilities
-
Net assets
$147,244
Revenue
$36,837
Expenses
$16,070
Net income
$20,767
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
2023Detailed filing. Detailed filing data is available for this year.$1.47$1.47$0.37$0.16$0.21
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