Civic Intelligence

Ann Bethany Bertling and Tristan Gonzalez Foundation

990EZ • Fiscal year 2020 • EIN 81-5093420

Jan 01, 2020 to Dec 31, 2020 • Filed on May 15, 2021

Organization ProfileN/A
105 S River StSeguin, TX 78155

(830) 560-6292

Siviq Scores

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

Liabilities / Assets

55th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Liabilities / Revenue

55th percentile

0.00x

Tied with the lowest-debt nonprofits in its peer group.

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

Net Margin

7th percentile

-121%

Higher net margin than 7% of similar nonprofits.

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

Top Officer Pay

76th percentile

$0

Higher top officer pay than 76% of similar nonprofits.

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

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

Asset Growth

11th percentile

-41%

Faster asset growth than 11% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Revenue Growth

18th percentile

-58%

Faster revenue growth than 18% of similar nonprofits.

2020 filings • 501(c)3 • <$500k nonprofits • Annualized from 2019 to 2020

Balance Sheet
Liabilities / Assets55th percentile

Assets

Down

$51,500

Down $35,132 (-41%) from 2019

Net Assets

Down

$51,500

Down $35,132 (-41%) from 2019

Liabilities

Flat

$0

Flat from 2019

Revenue And Expenses
Liabilities / Revenue55th percentileNet Margin7th percentile

Revenue

Down

$29,135

Down $39,749 (-58%) from 2019

Expenses

Up

$64,267

Up $35,905 (+127%) from 2019

Net Income

Down

-$35,132

Down $75,654 (-187%) from 2019

Historical Trend

Balance Sheet Trend

Asset Growth11th percentile

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

$200K$150K$100K$50K$0Assets 2018: $46,110Liabilities 2018: $0Net Assets 2018: $46,1102018Assets 2019: $86,632Liabilities 2019: $0Net Assets 2019: $86,6322019Assets 2020: $51,500Liabilities 2020: $0Net Assets 2020: $51,5002020Assets 2021: $69,714Liabilities 2021: $0Net Assets 2021: $69,7142021Assets 2022: $93,028Liabilities 2022: $0Net Assets 2022: $93,0282022Assets 2023: $173,939Liabilities 2023: $0Net Assets 2023: $173,9392023Assets 2024: $126,485Net Assets 2024: $126,4852024

Highlighted filing

2020

Assets$51,500
Liabilities$0
Net Assets$51,500
Open 2020 Filing

Operations Trend

Revenue Growth18th percentile

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

$200K$100K$0-$100KRevenue 2018: $46,201Expenses 2018: $3,366Net Income 2018: $42,8352018Revenue 2019: $68,884Expenses 2019: $28,362Net Income 2019: $40,5222019Revenue 2020: $29,135Expenses 2020: $64,267Net Income 2020: -$35,1322020Revenue 2021: $58,513Expenses 2021: $40,299Net Income 2021: $18,2142021Revenue 2022: $86,136Expenses 2022: $62,822Net Income 2022: $23,3142022Revenue 2023: $189,617Expenses 2023: $108,706Net Income 2023: $80,9112023Revenue 2024: $105,657Expenses 2024: $153,111Net Income 2024: -$47,4542024

Highlighted filing

2020

Revenue$29,135
Expenses$64,267
Net Income-$35,132
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
May 15, 2021
Return Version
2020v4.0
Gross Receipts
$29,135
Mission and Program Overview

Mission

Provide scholarships for children and agricultural education for children

Program Services

DescriptionGrantsExpenses
PROVIDE SCHOLARSHIPS AND AGRICULTURAL EDUCATION$62,650$62,650
Compensation and Service Providers
Top Officer Pay76th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
CHRISTOPHER BLAKE BERTLINGPresident-$0--
JENNIFER L BERTLINGVice President-$0--
JESSICA GONZALEZTreasurer-$0--
BRANDON J OEHLKESecretary-$0--
Filing and Contact Details

Filer

Filer Name
Ann & Bethany Bertling and
EIN
81-5093420
Phone
8305606292
Address
105 S RIVER ST, SEGUIN, TX 78155

Signing Officer

Name
Blake Bertling
Title
President
Signed
2021-05-15
Discuss with paid preparer
Yes

Preparer

Firm
Oehlke CPA Pllc
Address
105 S River Street, SEGUIN, TX 78155
Preparer
Brandon J Oehlke CPA
Phone
8303792991
Supplemental Narrative

Additional Explanations

Grants and Similar Amounts Paid In Excess of $5,000.1

“| Donee's Name: GUADALUPE COUNTY YOUTH LIVESTOCK SHOW | Cash Amount Given: $46400”

Grants and Similar Amounts Paid In Excess of $5,000.2

“| Donee's Name: SCHLRSHPS-ELEVEN INDIVIDUALS@$1,000 EACH | Cash Amount Given: $11000”

Grants and Similar Amounts Paid In Excess of $5,000.3

“| Donee's Name: LA VERNIA CHAMBER OF COMMERC E YTH SHOW | Cash Amount Given: $5100”

Other Expenses.1002

“Office Expenses $165”

Other Expenses.1009

“Depreciation $635”

Other Expenses.2

“SUPPLIES $257”

Other Expenses.3

“BANK SERVICE CHARGE $2”

Other Assets.1003

“Machinery and Equipment - Beginning $1586 Machinery and Equipment - Ending $951”

Raw XML Appendix154 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/PersonNm0BLAKE BERTLING
IRS990EZ/BooksInCareOfDetail/PhoneNum08305606292
IRS990EZ/BooksInCareOfDetail/USAddress/AddressLine1Txt0P O BOX 91
IRS990EZ/BooksInCareOfDetail/USAddress/CityNm0KINGSBURY
IRS990EZ/BooksInCareOfDetail/USAddress/StateAbbreviationCd0TX
IRS990EZ/BooksInCareOfDetail/USAddress/ZIPCd078638
IRS990EZ/CashSavingsAndInvestmentsGrp/BOYAmt085046
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt050549
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/ContributionsGiftsGrantsEtcAmt029135
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt0-35132
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt086632
IRS990EZ/Form990TotalAssetsGrp/EOYAmt051500
IRS990EZ/FundraisingGrossIncomeAmt00
IRS990EZ/GrantsAndSimilarAmountsPaidAmt062650
IRS990EZ/GrossReceiptsAmt029135
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt086632
IRS990EZ/NetAssetsOrFundBalancesEOYAmt051500
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt086632
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt051500
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/AverageHrsPerWkDevotedToPosRt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt00
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt10
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt20
IRS990EZ/OfficerDirectorTrusteeEmplGrp/CompensationAmt30
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm0CHRISTOPHER BLAKE BERTLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm1JENNIFER L BERTLING
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm2JESSICA GONZALEZ
IRS990EZ/OfficerDirectorTrusteeEmplGrp/PersonNm3BRANDON J OEHLKE
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt0President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt1Vice President
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt2Treasurer
IRS990EZ/OfficerDirectorTrusteeEmplGrp/TitleTxt3Secretary
IRS990EZ/OperateHospitalInd0false
IRS990EZ/Organization501c3Ind0X
IRS990EZ/OrganizationDissolvedEtcInd0false
IRS990EZ/OrganizationHadUBIInd0false
IRS990EZ/OtherAssetsTotalDetail/BOYAmt01586
IRS990EZ/OtherAssetsTotalDetail/EOYAmt0951
IRS990EZ/OtherExpensesTotalAmt01059
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE SCHOLARSHIPS FOR CHILDREN AND AGRICULTURAL EDUCATION FOR CHILDREN
IRS990EZ/PrintingPublicationsPostageAmt0558
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE SCHOLARSHIPS AND AGRICULTURAL EDUCATION
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt062650
IRS990EZ/ProgramSrvcAccomplishmentGrp/ProgramServiceExpensesAmt062650
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt00
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt064267
IRS990EZ/TotalProgramServiceExpensesAmt062650
IRS990EZ/TotalRevenueAmt029135
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/CurrentTaxYearAmt062650
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt062650
IRS990ScheduleA/GovtFurnSrvcFcltsVl509Grp/TotalAmt00
IRS990ScheduleA/GrossInvestmentIncome509Grp/TotalAmt00
IRS990ScheduleA/GrossReceiptsAdmissionsGrp/TotalAmt00
IRS990ScheduleA/GrossReceiptsNonUnrltBusGrp/TotalAmt00
IRS990ScheduleA/InvestmentIncomeCYPct00.00000
IRS990ScheduleA/NetIncomeFromOtherUBIGrp/TotalAmt00
IRS990ScheduleA/OtherIncome509Grp/TotalAmt00
IRS990ScheduleA/Post1975UBTIGrp/TotalAmt00
IRS990ScheduleA/PubliclySupportedOrg509a2Ind0X
IRS990ScheduleA/PublicSupportCY509Pct00.00000
IRS990ScheduleA/PublicSupportTotal509Amt062650
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt00
IRS990ScheduleA/Total509Grp/CurrentTaxYearAmt062650
IRS990ScheduleA/Total509Grp/TotalAmt062650
IRS990ScheduleA/TotalSupportCalendarYearGrp/CurrentTaxYearAmt062650
IRS990ScheduleA/TotalSupportCalendarYearGrp/TotalAmt062650
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0| Donee's Name: GUADALUPE COUNTY YOUTH LIVESTOCK SHOW | Cash Amount Given: $46400
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1| Donee's Name: SCHLRSHPS-ELEVEN INDIVIDUALS@$1,000 EACH | Cash Amount Given: $11000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2| Donee's Name: LA VERNIA CHAMBER OF COMMERC E YTH SHOW | Cash Amount Given: $5100
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Office Expenses $165
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4Depreciation $635
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5SUPPLIES $257
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt6BANK SERVICE CHARGE $2
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt7Machinery and Equipment - Beginning $1586 Machinery and Equipment - Ending $951
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc0Grants and Similar Amounts Paid In Excess of $5,000.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc1Grants and Similar Amounts Paid In Excess of $5,000.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc2Grants and Similar Amounts Paid In Excess of $5,000.3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.1002
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Expenses.1009
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Expenses.2
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc6Other Expenses.3
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc7Other Assets.1003
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/FederatedAssuranceLevelCd0FAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd02
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0BLAKE BERTLING
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-05-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0ANN & BETHANY BERTLING AND
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0TRISTAN GONZALEZ FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0ANN&
ReturnHeader/Filer/EIN0815093420
ReturnHeader/Filer/PhoneNum08305606292
ReturnHeader/Filer/USAddress/AddressLine1Txt0105 S RIVER ST
ReturnHeader/Filer/USAddress/CityNm0SEGUIN
ReturnHeader/Filer/USAddress/StateAbbreviationCd0TX
ReturnHeader/Filer/USAddress/ZIPCd078155
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0452845893
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0OEHLKE CPA PLLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0105 S River Street
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0SEGUIN
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd078155
ReturnHeader/PreparerPersonGrp/PhoneNum08303792991
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Brandon J Oehlke CPA
ReturnHeader/ReturnTs02021-05-17T11:44:39-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0BLAKE
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0BERTLING
ReturnHeader/TaxPeriodBeginDt02020-01-01
ReturnHeader/TaxPeriodEndDt02020-12-31
ReturnHeader/TaxYr02020

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

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

Open filing
Assets
$51,500
Liabilities
$0
Net assets
$51,500
Revenue
$29,135
Expenses
$64,267
Net income
-$35,132
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$1.26$1.26$1.06$1.53$0.47
2023Detailed filing. Detailed filing data is available for this year.$1.74$0.00$1.74$1.90$1.09$0.81
2022Detailed filing. Detailed filing data is available for this year.$0.93$0.00$0.93$0.86$0.63$0.23
2021Detailed filing. Detailed filing data is available for this year.$0.70$0.00$0.70$0.59$0.40$0.18
2020Detailed filing. Detailed filing data is available for this year.$0.52$0.00$0.52$0.29$0.64$0.35
2019Detailed filing. Detailed filing data is available for this year.$0.87$0.00$0.87$0.69$0.28$0.41
2018Detailed filing. Detailed filing data is available for this year.$0.46$0.00$0.46$0.46$0.03$0.43