Civic Intelligence

Upshot Foundation

990PF • Fiscal year 2019 • EIN 84-1730205

Jan 01, 2019 to Dec 31, 2019 • Filed on Oct 20, 2020

417 E Deerpath RoadLake Forest, IL 60045

(214) 350-7900

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 2019

Liabilities / Revenue

21st percentile

0.00x

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

2019 filings • $5M-$10M nonprofits • Source year 2019

Net Margin

98th percentile

97%

Higher net margin than 98% of similar nonprofits.

2019 filings • $5M-$10M nonprofits • Source year 2019

Top Officer Pay

30th percentile

$0

Higher top officer pay than 30% of similar nonprofits.

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

2019 filings • $5M-$10M nonprofits • Source year 2019

Asset Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2019

Revenue Growth

Score unavailable

No value available

No earlier valid filing was available within the previous three public years.

Source year 2019

Assets

$0

No earlier filing loaded for comparison.

Net Assets

$0

No earlier filing loaded for comparison.

Liabilities

$0

No earlier filing loaded for comparison.

Revenue

$8,650,556

No earlier filing loaded for comparison.

Expenses

$293,705

No earlier filing loaded for comparison.

Net Income

$8,356,851

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

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

$6.0M$4.0M$2.0M$0Assets 2019: $0Liabilities 2019: $0Net Assets 2019: $02019Assets 2020: $0Liabilities 2020: $0Net Assets 2020: $02020Assets 2021: $5,834,575Liabilities 2021: $0Net Assets 2021: $5,834,5752021Assets 2022: $5,848,899Liabilities 2022: $0Net Assets 2022: $5,848,8992022Assets 2023: $5,955,262Liabilities 2023: $0Net Assets 2023: $5,955,2622023Assets 2024: $2,199,787Liabilities 2024: $0Net Assets 2024: $2,199,7872024

Highlighted filing

2019

Assets$0
Liabilities$0
Net Assets$0

Operations Trend

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

$10M$5.0M$0-$5.0MRevenue 2019: $8,650,556Expenses 2019: $293,705Net Income 2019: $8,356,8512019Revenue 2020: $3,946,357Expenses 2020: $403,172Net Income 2020: $3,543,1852020Revenue 2021: $264,863Expenses 2021: $4,620Net Income 2021: $260,2432021Revenue 2022: $48,910Expenses 2022: $34,586Net Income 2022: $14,3242022Revenue 2023: $107,813Expenses 2023: $1,450Net Income 2023: $106,3632023Revenue 2024: $57,675Expenses 2024: $3,813,150Net Income 2024: -$3,755,4752024

Highlighted filing

2019

Revenue$8,650,556
Expenses$293,705
Net Income$8,356,851
Jump To
Filing Snapshot
Filing Period
Jan 1, 2019 to Dec 31, 2019
Signed
Oct 20, 2020
Return Version
2019v5.1
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
Stuart BernsenTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Upshot
EIN
84-1730205
Address
417 E DEERPATH ROAD, Lake Forest, IL 60045

Signing Officer

Name
Stuart Bernsen
Title
Trustee
Phone
8479122411
Signed
2020-10-20
Discuss with paid preparer
Yes

Preparer

Firm
DFW Universal Tax Service LLC
Address
2218 S JUPITER RD SUITE 102, Garland, TX 75041
Preparer
Laura Sanchez
Phone
2143507900
Raw XML Appendix191 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
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriRcvdRevAndExpnssAmt08100488
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt08356851
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0293705
IRS990PF/AnalysisOfRevenueAndExpenses/OtherIncomeRevAndExpnssAmt0550068
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt0293705
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt08650556
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0293705
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt08356851
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt08356851
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt08356851
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrganizationFollowsFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblAmt0243690
IRS990PF/Form990PFBalanceSheetsGrp/OtherNtsAndLoansRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
IRS990PF/InitialReturnInd0X
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt00
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt00
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt00
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt00.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Stuart Bernsen
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0417 E Deerpath Road
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Lake Forest
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0IL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd060045
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt00
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0false
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0false
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0Stuart Bernsen
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0417 E Deerpath Road
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Lake Forest
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0IL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd060045
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0false
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PhoneNum08479122411
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SupplementaryInformationGrp/ContributingManagerNm0Stuart Bernsen - Trustee
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt00
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/DistributableAsAdjustedAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorNum12
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0Stuart Bernsen
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm1Scion Charitable
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt0417 E Deerpath Road
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt14 E Ogden Ave Ste 351
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0Lake Forest
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm1Westmont
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0IL
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd1IL
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd060045
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd160559
IRS990ScheduleB/ContributorInformationGrp/NoncashContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt0120000
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt17980488
IRS990ScheduleB/GeneralRuleInd0X
IRS990ScheduleB/NonCashPropertyContributionGrp/ContributorNum02
IRS990ScheduleB/NonCashPropertyContributionGrp/FairMarketValueAmt00
IRS990ScheduleB/NonCashPropertyContributionGrp/NoncashPropertyDesc0Income InterestNon-cash Charitable contribution
IRS990ScheduleB/NonCashPropertyContributionGrp/ReceivedDt02019-03-12
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/AdjustedNetIncomeAmt20
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Bank Service Charges
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1Formation
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2Loan Expense
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt20
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt10
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt20
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt015
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt150000
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt2243690
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt00
OtherIncomeSchedule2/OtherIncomeDetail/AdjustedNetIncomeAmt10
OtherIncomeSchedule2/OtherIncomeDetail/Desc0Chiros LLC
OtherIncomeSchedule2/OtherIncomeDetail/Desc1Interest
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt00
OtherIncomeSchedule2/OtherIncomeDetail/NetInvestmentIncomeAmt10
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt0542078
OtherIncomeSchedule2/OtherIncomeDetail/RevenueAndExpensesPerBooksAmt17990
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/BalanceDueAmt0243690
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/BorrowerNameGrp/PersonNm0Vistria Cap Call
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/ConsiderationFMVAmt00
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/InsiderRelationshipTxt0None
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/InterestRt01
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/LoanMaturityDt02029-12
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/LoanOriginalAmt0243690
OtherNotesLoansRcvblLongSch/OtherNotesLoansRcvblLongGrp/NoteDt02019-12
ReturnHeader/BuildTS02021-04-22 16:20:28Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0STUART BERNSEN
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum08479122411
ReturnHeader/BusinessOfficerGrp/SignatureDt02020-10-20
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0UPSHOT
ReturnHeader/Filer/BusinessNameControlTxt0UPSH
ReturnHeader/Filer/EIN0841730205
ReturnHeader/Filer/USAddress/AddressLine1Txt0417 E DEERPATH ROAD
ReturnHeader/Filer/USAddress/CityNm0Lake Forest
ReturnHeader/Filer/USAddress/StateAbbreviationCd0IL
ReturnHeader/Filer/USAddress/ZIPCd060045
ReturnHeader/FilingSecurityInformation/AtSubmissionCreationDeviceId001C85CC6855D63F2680B50867D6A292D9922D633
ReturnHeader/FilingSecurityInformation/AtSubmissionFilingDeviceId001C85CC6855D63F2680B50867D6A292D9922D633
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionId08068772020295haxwmlb
ReturnHeader/FilingSecurityInformation/FederalOriginalSubmissionIdDt02020-10-21
ReturnHeader/FilingSecurityInformation/FilingLicenseTypeCd0P
ReturnHeader/FilingSecurityInformation/IPAddress/IPv4AddressTxt070.119.213.67
ReturnHeader/FilingSecurityInformation/IPDt02020-10-21
ReturnHeader/FilingSecurityInformation/IPTm016:32:13
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0452405562
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0DFW Universal Tax Service LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02218 S JUPITER RD SUITE 102
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Garland
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd075041
ReturnHeader/PreparerPersonGrp/PhoneNum02143507900
ReturnHeader/PreparerPersonGrp/PreparationDt02020-10-20
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Laura Sanchez
ReturnHeader/ReturnTs02020-10-20T18:11:46-04:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02019-01-01
ReturnHeader/TaxPeriodEndDt02019-12-31
ReturnHeader/TaxYr02019

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings