Civic Intelligence

Jacqueline Mcgill Foundation

990PF • Fiscal year 2020 • EIN 84-6829366

Jan 01, 2020 to Dec 31, 2020 • Filed on Oct 07, 2021

Organization Profile
1654 Dexter LnCharleston, SC 29412

(843) 822-1934

Siviq Scores

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

Liabilities / Assets

83rd percentile

0.21x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2020

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2020

Top Officer Pay

77th percentile

$0

Higher top officer pay than 77% of similar nonprofits.

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

Asset Growth

Score unavailable

No value available

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

Source year 2020

Revenue Growth

Score unavailable

No value available

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

Source year 2020

Balance Sheet
Liabilities / Assets83rd percentile

Assets

$121,676

No earlier filing loaded for comparison.

Net Assets

$96,376

No earlier filing loaded for comparison.

Liabilities

$25,300

No earlier filing loaded for comparison.

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

$0

No earlier filing loaded for comparison.

Expenses

$10,774

No earlier filing loaded for comparison.

Net Income

-$10,774

No earlier filing loaded for comparison.

Historical Trend

Balance Sheet Trend

Asset GrowthScore unavailable

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

$150K$100K$50K$0Assets 2020: $121,676Liabilities 2020: $25,300Net Assets 2020: $96,3762020Assets 2021: $122,606Liabilities 2021: $25,300Net Assets 2021: $97,3062021Assets 2022: $123,076Liabilities 2022: $25,300Net Assets 2022: $97,7762022Assets 2023: $96,208Liabilities 2023: $0Net Assets 2023: $96,2082023Assets 2024: $93,074Liabilities 2024: $0Net Assets 2024: $93,0742024

Highlighted filing

2020

Assets$121,676
Liabilities$25,300
Net Assets$96,376
Open 2020 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$60K$40K$20K$0-$20KRevenue 2020: $0Expenses 2020: $10,774Net Income 2020: -$10,7742020Revenue 2021: $19,700Expenses 2021: $18,770Net Income 2021: $9302021Revenue 2022: $44,800Expenses 2022: $50,670Net Income 2022: -$5,8702022Revenue 2023: $19,962Expenses 2023: $21,530Net Income 2023: -$1,5682023Revenue 2024: $31,500Expenses 2024: $31,480Net Income 2024: $202024

Highlighted filing

2020

Revenue$0
Expenses$10,774
Net Income-$10,774
Open 2020 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2020 to Dec 31, 2020
Signed
Oct 7, 2021
Return Version
2020v4.1
Compensation and Service Providers
Top Officer Pay77th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
Leonard James McGillTrusteePT$0--
Filing and Contact Details

Filer

Filer Name
Jacqueline McGill Foundation
EIN
84-6829366
Phone
8438221934
Address
1654 Dexter Ln, Charleston, SC 29412

Signing Officer

Name
Jacqueline McGill
Title
Trustee
Signed
2021-10-07
Discuss with paid preparer
No

Preparer

Firm
Tax Planning Consultants LLC
Address
1425 Pioneer Dr Suite 127, Irving, TX 75061
Preparer
Glenn T Gillen
Phone
4695864993
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
AccountingFeesSchedule/AccountingFeesDetail/Amt05000
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0Professional Fees
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt05000
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt05650
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt05650
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-10774
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0124
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt05650
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt010774
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt05124
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-10774
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt096376
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0107150
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt096376
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt00
IRS990PF/FMVAssetsEOYAmt0121676
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt0107150
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYAmt01059
IRS990PF/Form990PFBalanceSheetsGrp/CashEOYFMVAmt01059
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherLiabilitiesEOYAmt025300
IRS990PF/Form990PFBalanceSheetsGrp/RcvblFromOfficersEOYAmt0120617
IRS990PF/Form990PFBalanceSheetsGrp/RcvblFromOfficersEOYFMVAmt0120617
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0107150
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt096376
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0107150
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0121676
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0121676
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt025300
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0107150
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0121676
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0107150
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt096376
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt0005.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0Leonard James McGill
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0Trustee
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt01654 Dexter Ln
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0Charleston
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0SC
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd029412
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt05650
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt05650
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt05650
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd0false
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd0false
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd0false
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd0false
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd0false
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProceedsOrNetIncomeInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0Leonard James McGill
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt01654 Dexter Ln
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0Charleston
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0SC
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd029412
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0true
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0SC
IRS990PF/StatementsRegardingActyGrp/PhoneNum08438221934
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0N/A
IRS990PF/SummaryOfDirectChrtblActyGrp/Description1Txt0None
IRS990PF/SummaryOfDirectChrtblActyGrp/Expenses1Amt00
IRS990PF/SumOfProgramRelatedInvstGrp/Description1Txt0None
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt04650
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt11000
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0Cash Donation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1Cash Donation
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0American Red Cross
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1Habit for Humanity
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0431 18th Street NW
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt1731 Meeting St
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0Washington
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1Charleston
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0DC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1SC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd020006
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd129403
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt05650
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/ExcessDistributionCyovYr1Amt019998
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt025648
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt05650
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt019998
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt05650
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt05650
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt025648
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt019998
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990ScheduleB/ContributorInformationGrp/ContributorNum01
IRS990ScheduleB/ContributorInformationGrp/ContributorPersonNm0Jacqueline R McGill
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/AddressLine1Txt01705 Basset Court
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/CityNm0Charleston
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/StateAbbreviationCd0SC
IRS990ScheduleB/ContributorInformationGrp/ContributorUSAddress/ZIPCd029412
IRS990ScheduleB/ContributorInformationGrp/PersonContributionInd0X
IRS990ScheduleB/ContributorInformationGrp/TotalContributionsAmt05250
IRS990ScheduleB/Organization501c3ExemptPFInd0X
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0Bank Charges
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0124
OtherLiabilitiesSchedule/OtherLiabilitiesDetail/Desc0Payable J. McGill reimburesments
OtherLiabilitiesSchedule/OtherLiabilitiesDetail/EOYBookValueAmt025300
OtherReceivablesOfficersSch/OfficerOtherRcvblGrp/BalanceDueAmt071467
OtherReceivablesOfficersSch/OfficerOtherRcvblGrp/BalanceDueAmt149150
OtherReceivablesOfficersSch/OfficerOtherRcvblGrp/BorrowerPersonNm0Dr Leonard McGill
OtherReceivablesOfficersSch/OfficerOtherRcvblGrp/BorrowerPersonNm1Jacqueline McGill
OtherReceivablesOfficersSch/OfficerOtherRcvblGrp/BorrowerTitleTxt0Director
OtherReceivablesOfficersSch/OfficerOtherRcvblGrp/BorrowerTitleTxt1Director
SubstantialContributorsSch/SubstantialContributorDetail/PersonNm0Jacquiline R McGill
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/AddressLine1Txt01705 Basset Court
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/CityNm0Charleston
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/StateAbbreviationCd0SC
SubstantialContributorsSch/SubstantialContributorDetail/USAddress/ZIPCd029412
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/AuthenticationAssuranceLevelCd0AAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/IdentityAssuranceLevelCd0IAL1
ReturnHeader/AdditionalFilerInformation/TrustedCustomerGrp/TrustedCustomerCd03
ReturnHeader/BuildTS02022-09-23 18:48:47Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0false
ReturnHeader/BusinessOfficerGrp/PersonNm0Jacqueline McGill
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0Trustee
ReturnHeader/BusinessOfficerGrp/SignatureDt02021-10-07
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0Jacqueline McGill Foundation
ReturnHeader/Filer/BusinessNameControlTxt0JACQ
ReturnHeader/Filer/EIN0846829366
ReturnHeader/Filer/PhoneNum08438221934
ReturnHeader/Filer/USAddress/AddressLine1Txt01654 Dexter Ln
ReturnHeader/Filer/USAddress/CityNm0Charleston
ReturnHeader/Filer/USAddress/StateAbbreviationCd0SC
ReturnHeader/Filer/USAddress/ZIPCd029412
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0Tax Planning Consultants LLC
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt01425 Pioneer Dr Suite 127
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0Irving
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0TX
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd075061
ReturnHeader/PreparerPersonGrp/PhoneNum04695864993
ReturnHeader/PreparerPersonGrp/PreparationDt02021-10-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0Glenn T Gillen
ReturnHeader/PreparerPersonGrp/SelfEmployedInd0X
ReturnHeader/ReturnTs02021-10-07T01:07:53-00:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonFirstNm0Jacqueline
ReturnHeader/SigningOfficerGrp/PersonFullName/PersonLastNm0McGill
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 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$121,676
Liabilities
$25,300
Net assets
$96,376
Revenue
$0
Expenses
$10,774
Net income
-$10,774
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$0.93$0.00$0.93$0.32$0.31$0.00
2023Detailed filing. Detailed filing data is available for this year.$0.96$0.00$0.96$0.20$0.22$0.02
2022Detailed filing. Detailed filing data is available for this year.$1.23$0.25$0.98$0.45$0.51$0.06
2021Detailed filing. Detailed filing data is available for this year.$1.23$0.25$0.97$0.20$0.19$0.01
2020Detailed filing. Detailed filing data is available for this year.$1.22$0.25$0.96$0.00$0.11$0.11