Civic Intelligence

Ann Bethany Bertling and Tristan Gonzalez Foundation

990EZ • Fiscal year 2019 • EIN 81-5093420

Jan 01, 2019 to Dec 31, 2019 • Filed on Jul 02, 2020

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

57th percentile

0.00x

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

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

Liabilities / Revenue

57th percentile

0.00x

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

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

Net Margin

93rd percentile

59%

Higher net margin than 93% of similar nonprofits.

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

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

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

Asset Growth

90th percentile

88%

Faster asset growth than 90% of similar nonprofits.

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

Revenue Growth

85th percentile

49%

Faster revenue growth than 85% of similar nonprofits.

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

Assets

Up

$86,632

Up $40,522 (+88%) from 2018

Net Assets

Up

$86,632

Up $40,522 (+88%) from 2018

Liabilities

Flat

$0

Flat from 2018

Revenue

Up

$68,884

Up $22,683 (+49%) from 2018

Expenses

Up

$28,362

Up $24,996 (+743%) from 2018

Net Income

Down

$40,522

Down $2,313 (-5.4%) from 2018

Historical Trend

Balance Sheet Trend

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

2019

Assets$86,632
Liabilities$0
Net Assets$86,632

Operations Trend

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

2019

Revenue$68,884
Expenses$28,362
Net Income$40,522
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
Jul 2, 2020
Return Version
2019v5.0
Gross Receipts
$86,628
Mission and Program Overview

Mission

Provide scholarships for children and agricultural education for children

Program Services

DescriptionGrantsExpenses
PROVIDE SCHOLARSHIPS AND AGRICULTURAL EDUCATION$27,750-
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
CHRISTOPHER BLAKE BERTLINGPresident-$0--
JENNIFER L BERTLINGVice President-$0--
JESSICA GONZALEZTreasurer-$0--
BRANDON J OEHLKESecretary-$0--
Fundraising, Events, and Gaming

Fundraising Events

EventGross ReceiptsGross RevenueDirect ExpensesNet Income
Casino Night$86,628$86,628$4,191$82,437
Total Events$86,628$86,628$17,744$68,884
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
2020-07-02
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: $18750

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

| Donee's Name: SCHOLARSHIP-NINE INDIVIDUALS@$1,000 EACH | Cash Amount Given: $9000

Other Expenses.1002

Office Expenses $141

Other Expenses.1009

Depreciation $397

Other Expenses.1

BANK SERVICE CHARGE $74

Other Assets.1003

Machinery and Equipment - Beginning $0 Machinery and Equipment - Ending $1586

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
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/BOYAmt046110
IRS990EZ/CashSavingsAndInvestmentsGrp/EOYAmt085046
IRS990EZ/ChgMadeToOrgnzngDocNotRptInd0false
IRS990EZ/CostOfGoodsSoldAmt00
IRS990EZ/CostOrOtherBasisExpenseSaleAmt00
IRS990EZ/DonorAdvisedFndsInd0false
IRS990EZ/EngagedInExcessBenefitTransInd0false
IRS990EZ/ExcessOrDeficitForYearAmt040522
IRS990EZ/FiledScheduleAInd0true
IRS990EZ/ForeignFinancialAccountInd0false
IRS990EZ/ForeignOfficeInd0false
IRS990EZ/Form1120PolFiledInd0false
IRS990EZ/Form990TotalAssetsGrp/BOYAmt046110
IRS990EZ/Form990TotalAssetsGrp/EOYAmt086632
IRS990EZ/FundraisingGrossIncomeAmt086628
IRS990EZ/GrantsAndSimilarAmountsPaidAmt027750
IRS990EZ/GrossReceiptsAmt086628
IRS990EZ/InfoInScheduleOPartIIInd0X
IRS990EZ/InfoInScheduleOPartIInd0X
IRS990EZ/LobbyingActivitiesInd0false
IRS990EZ/MadeLoansToFromOfficersInd0false
IRS990EZ/MethodOfAccountingCashInd0X
IRS990EZ/NetAssetsOrFundBalancesBOYAmt046110
IRS990EZ/NetAssetsOrFundBalancesEOYAmt086632
IRS990EZ/NetAssetsOrFundBalancesGrp/BOYAmt046110
IRS990EZ/NetAssetsOrFundBalancesGrp/EOYAmt086632
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/EOYAmt01586
IRS990EZ/OtherExpensesTotalAmt0612
IRS990EZ/PartVIHghstPdCntrctProfSrvcTxt0NONE
IRS990EZ/PartVIOfCompOfHghstPdEmplTxt0NONE
IRS990EZ/PoliticalCampaignActyInd0false
IRS990EZ/PrimaryExemptPurposeTxt0PROVIDE SCHOLARSHIPS FOR CHILDREN AND AGRICULTURAL EDUCATION FOR CHILDREN
IRS990EZ/ProgramSrvcAccomplishmentGrp/DescriptionProgramSrvcAccomTxt0PROVIDE SCHOLARSHIPS AND AGRICULTURAL EDUCATION
IRS990EZ/ProgramSrvcAccomplishmentGrp/GrantsAndAllocationsAmt027750
IRS990EZ/ProhibitedTaxShelterTransInd0false
IRS990EZ/RelatedOrganizationCtrlEntInd0false
IRS990EZ/ScheduleBNotRequiredInd0X
IRS990EZ/SchoolOperatingInd0false
IRS990EZ/SpecialEventsDirectExpensesAmt017744
IRS990EZ/SpecialEventsNetIncomeLossAmt068884
IRS990EZ/SubjectToProxyTaxInd0false
IRS990EZ/TanningServicesProvidedInd0false
IRS990EZ/TaxImposedOnOrganizationMgrAmt00
IRS990EZ/TaxImposedUnderIRC4911Amt00
IRS990EZ/TaxImposedUnderIRC4912Amt00
IRS990EZ/TaxImposedUnderIRC4955Amt00
IRS990EZ/TaxReimbursedByOrganizationAmt00
IRS990EZ/TotalExpensesAmt028362
IRS990EZ/TotalProgramServiceExpensesAmt027750
IRS990EZ/TotalRevenueAmt068884
IRS990EZ/TransactionWithControlEntInd0false
IRS990EZ/TrnsfrExmptNonChrtblRltdOrgInd0false
IRS990EZ/TypeOfOrganizationCorpInd0X
IRS990EZ/WebsiteAddressTxt0N/A
IRS990ScheduleA/AmountsRcvdDsqlfyPersonGrp/TotalAmt00
IRS990ScheduleA/First5Years509Ind0X
IRS990ScheduleA/GiftsGrantsContrisRcvd509Grp/TotalAmt00
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/PublicSupportTotal509Amt00
IRS990ScheduleA/SubstantialContributorsAmtGrp/TotalAmt00
IRS990ScheduleA/TaxRevLeviedOrgnztnlBnft509Grp/TotalAmt00
IRS990ScheduleG/FundraisingEventInformationGrp/DirectExpenseSummaryEventsAmt017744
IRS990ScheduleG/FundraisingEventInformationGrp/EntertainmentEvent1Amt07242
IRS990ScheduleG/FundraisingEventInformationGrp/EntertainmentTotalEventsAmt07242
IRS990ScheduleG/FundraisingEventInformationGrp/Event1Nm0CASINO NIGHT
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageEvent1Amt06311
IRS990ScheduleG/FundraisingEventInformationGrp/FoodAndBeverageTotalEventsAmt06311
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsEvent1Amt086628
IRS990ScheduleG/FundraisingEventInformationGrp/GrossReceiptsTotalAmt086628
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueEvent1Amt086628
IRS990ScheduleG/FundraisingEventInformationGrp/GrossRevenueTotalEventsAmt086628
IRS990ScheduleG/FundraisingEventInformationGrp/NetIncomeSummaryAmt068884
IRS990ScheduleG/FundraisingEventInformationGrp/OthDirectExpnssTotalEventsAmt04191
IRS990ScheduleG/FundraisingEventInformationGrp/OtherDirectExpensesEvent1Amt04191
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt0| Donee's Name: GUADALUPE COUNTY YOUTH LIVESTOCK SHOW | Cash Amount Given: $18750
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt1| Donee's Name: SCHOLARSHIP-NINE INDIVIDUALS@$1,000 EACH | Cash Amount Given: $9000
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt2Office Expenses $141
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt3Depreciation $397
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt4BANK SERVICE CHARGE $74
IRS990ScheduleO/SupplementalInformationDetail/ExplanationTxt5Machinery and Equipment - Beginning $0 Machinery and Equipment - Ending $1586
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/FormAndLineReferenceDesc2Other Expenses.1002
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc3Other Expenses.1009
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc4Other Expenses.1
IRS990ScheduleO/SupplementalInformationDetail/FormAndLineReferenceDesc5Other Assets.1003
ReturnHeader/BuildTS02020-09-23 17:36:50Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0BLAKE BERTLING
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0President
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-07-02
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/ReturnTs02020-07-10T09:54:28-07:00
ReturnHeader/ReturnTypeCd0990EZ
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings