Civic Intelligence

Guptas Charitable Foundation

990PF • Fiscal year 2022 • EIN 84-4065011

Jan 01, 2022 to Dec 31, 2022 • Filed on Sep 15, 2023

612 Silver Chase drKeller, TX 76248

(309) 452-3200

Siviq Scores

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

Liabilities / Assets

96th percentile

1.00x

Higher debt load relative to assets than 96% of similar nonprofits.

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

Liabilities / Revenue

60th percentile

0.00x

Higher debt load relative to revenue than 60% of similar nonprofits.

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

Net Margin

17th percentile

-30%

Higher net margin than 17% of similar nonprofits.

2022 filings • <$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 • <$500k nonprofits • Source year 2022

Asset Growth

2nd percentile

-100%

Faster asset growth than 2% of similar nonprofits.

2022 filings • <$500k nonprofits • Annualized from 2021 to 2022

Revenue Growth

12th percentile

-54%

Faster revenue growth than 12% of similar nonprofits.

2022 filings • <$500k nonprofits • Annualized from 2021 to 2022

Assets

Down

$1

Down $1,362,084 (-100%) from 2021

Net Assets

Down

$0

Down $1,362,085 (-100%) from 2021

Liabilities

Flat

$1

Flat from 2021

Revenue

Down

$27,477

Down $32,864 (-54%) from 2021

Expenses

Down

$35,835

Down $16,987 (-32%) from 2021

Net Income

Down

-$8,358

Down $15,877 (-211%) from 2021

Historical Trend

Balance Sheet Trend

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

$1.5M$1.0M$500K$0Assets 2019: $1,000,000Liabilities 2019: $02019Assets 2020: $1,038,910Liabilities 2020: $1Net Assets 2020: $1,038,9102020Assets 2021: $1,362,085Liabilities 2021: $1Net Assets 2021: $1,362,0852021Assets 2022: $1Liabilities 2022: $1Net Assets 2022: $02022Assets 2023: $1,269,154Liabilities 2023: $1Net Assets 2023: $1,269,1542023Assets 2024: $1,099,261Liabilities 2024: $0Net Assets 2024: $1,099,2612024

Highlighted filing

2022

Assets$1
Liabilities$1
Net Assets$0

Operations Trend

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

$1.0M$500K$0-$500KRevenue 2019: $1,000,000Expenses 2019: $0Net Income 2019: $1,000,0002019Revenue 2020: $49,335Expenses 2020: $10,425Net Income 2020: $38,9102020Revenue 2021: $60,341Expenses 2021: $52,822Net Income 2021: $7,5192021Revenue 2022: $27,477Expenses 2022: $35,835Net Income 2022: -$8,3582022Revenue 2023: $15,627Expenses 2023: $27,209Net Income 2023: -$11,5822023Revenue 2024: $76,763Expenses 2024: $355,372Net Income 2024: -$278,6092024

Highlighted filing

2022

Revenue$27,477
Expenses$35,835
Net Income-$8,358
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Sep 15, 2023
Return Version
2022v5.0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
NEHA AGGARWALTreasuer-$0--
Filing and Contact Details

Filer

Filer Name
Guptas Charitable Foundation
EIN
84-4065011
Address
612 Silver Chase dr, Keller, TX 76248

Signing Officer

Name
Neha Aggarwal
Title
Treasuer
Phone
7062475126
Signed
2023-09-15
Discuss with paid preparer
Yes

Preparer

Firm
Peter Kostopoulos CPA Pc
Address
326 SUSAN DRIVE UNIT C, Normal, IL 61761
Preparer
Peter Kostopoulos
Phone
3094523200
Raw XML Appendix186 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
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AccumulatedDepreciationAmt00
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AccumulatedDepreciationAmt10
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AcquiredDt02022-06
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AcquiredDt12019-12
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AssetDesc0PER ASCENT US BANK STATEMENT
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/AssetDesc1PER ASCENT US BANK STATEMENT
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/BasisAmt00
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/BasisAmt10
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/GrossSalesPriceAmt01101
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/GrossSalesPriceAmt12054
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/HowAcquiredTxt0PURCHASE
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/HowAcquiredTxt1PURCHASE
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/PurchaserNameGrp/PersonNm0MARKET
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/PurchaserNameGrp/PersonNm1MARKET
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/SalesExpenseAmt00
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/SalesExpenseAmt10
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/SoldDt02022-12
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/SoldDt12022-12
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/TotalNetAmt01101
GainLossSaleOtherAssetsSch/GainLossSaleOtherAssetGrp/TotalNetAmt12054
IRS990PF/AnalysisIncomeProducingActyGrp/NetRntlIncmReDebtFincdPropGrp/ExclusionCd001
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt031119
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-8358
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt03155
IRS990PF/AnalysisOfRevenueAndExpenses/InterestOnSavRevAndExpnssAmt024322
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt03155
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0330
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt03973
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0413
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt035835
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt027477
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt04716
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-8358
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt0267337
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt01353727
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt01362085
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt01086390
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt055000
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt055000
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt055000
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt055000
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt01086390
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt01362085
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt01086390
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt01362085
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt01362085
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt01086390
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt01362085
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt01362085
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt01100000
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt01100000
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt055000
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt01100000
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt01100000
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt02.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0NEHA AGGARWAL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TREASUER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0612 SILVER CHASE DRIVE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Keller
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0TX
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd076248
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0NEHA AGGARWAL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0612 SILVER CHASE DRIVE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Keller
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0TX
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd076248
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum07092475126
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt031119
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0CHARITABLE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0NC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientPersonNm0VARIOUS CONTRIBUTIONS
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0CHARITABLE PURPOSE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt01408 E EMPIRE STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Bloomington
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd061701
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt031119
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd0false
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd0false
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt055000
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt055000
OtherDecreasesSchedule/OtherDecreasesDetail/Amt0267337
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0UNREALIZED LOSS
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0OFFICE SUPPLIES AND SOFTWARE
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0330
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/AdjustedNetIncomeAmt10
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt0100
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt13873
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0LEGAL AND PROFESSIONAL
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt1INVESTMENT FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt10
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt00
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt10
TaxesSchedule/TaxesDetail/AdjustedNetIncomeAmt00
TaxesSchedule/TaxesDetail/Amt0413
TaxesSchedule/TaxesDetail/CategoryTxt0TAXES AND LICENSES
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/OOBSecurityVerificationCd000
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd00
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0NEHA AGGARWAL
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TREASUER
ReturnHeader/BusinessOfficerGrp/PhoneNum07062475126
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-09-15
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0GUPTAS CHARITABLE FOUNDATION
ReturnHeader/Filer/BusinessNameControlTxt0GUPT
ReturnHeader/Filer/EIN0844065011
ReturnHeader/Filer/USAddress/AddressLine1Txt0612 Silver Chase dr
ReturnHeader/Filer/USAddress/CityNm0Keller
ReturnHeader/Filer/USAddress/StateAbbreviationCd0TX
ReturnHeader/Filer/USAddress/ZIPCd076248
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0363726957
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0PETER KOSTOPOULOS CPA PC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0326 SUSAN DRIVE UNIT C
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Normal
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0IL
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd061761
ReturnHeader/PreparerPersonGrp/PhoneNum03094523200
ReturnHeader/PreparerPersonGrp/PreparationDt02023-09-15
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0PETER KOSTOPOULOS
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02023-09-15T16:19:03-04:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0NEHA
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0AGGARWAL
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings