Civic Intelligence

Bertha Lam Tuw

990PF • Fiscal year 2022 • EIN 37-6184661

Jan 01, 2022 to Dec 31, 2022 • Filed on Apr 26, 2023

Organization Profile
116 Allegheny Center Mall P8yb3502lPittsburgh, PA 15212

(412) 209-4730

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 2022

Liabilities / Revenue

59th percentile

0.00x

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

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

Net Margin

4th percentile

-523%

Higher net margin than 4% 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

74th percentile

48%

Faster revenue growth than 74% of similar nonprofits.

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

Balance Sheet
Liabilities / AssetsScore unavailable

Assets

Down

$0

Down $17,466 (-100%) from 2021

Net Assets

Down

$0

Down $17,466 (-100%) from 2021

Liabilities

Flat

$0

Flat from 2021

Revenue And Expenses
Liabilities / Revenue59th percentileNet Margin4th percentile

Revenue

Up

$3,338

Up $1,079 (+48%) from 2021

Expenses

Up

$20,796

Up $19,742 (+1873%) from 2021

Net Income

Down

-$17,458

Down $18,663 (-1549%) from 2021

Historical Trend

Balance Sheet Trend

Asset Growth2nd percentile

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

$20K$15K$10K$5.0K$0Assets 2011: $18,802Liabilities 2011: $02011Assets 2012: $17,635Liabilities 2012: $02012Assets 2013: $17,100Liabilities 2013: $1Net Assets 2013: $17,1002013Assets 2014: $16,881Liabilities 2014: $1Net Assets 2014: $16,8812014Assets 2015: $16,858Liabilities 2015: $12015Assets 2016: $16,391Liabilities 2016: $0Net Assets 2016: $16,3912016Assets 2017: $15,888Liabilities 2017: $0Net Assets 2017: $15,8882017Assets 2018: $15,108Liabilities 2018: $0Net Assets 2018: $15,1082018Assets 2019: $17,269Liabilities 2019: $1Net Assets 2019: $17,2692019Assets 2020: $16,272Liabilities 2020: $12020Assets 2021: $17,466Liabilities 2021: $0Net Assets 2021: $17,4662021Assets 2022: $0Liabilities 2022: $0Net Assets 2022: $02022

Highlighted filing

2022

Assets$0
Liabilities$0
Net Assets$0
Open 2022 Filing

Operations Trend

Revenue Growth74th percentile

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

$30K$20K$10K$0-$10K-$20KRevenue 2011: $718Expenses 2011: $1,888Net Income 2011: -$1,1702011Revenue 2012: $798Expenses 2012: $1,965Net Income 2012: -$1,1672012Revenue 2013: $631Expenses 2013: $1,168Net Income 2013: -$5372013Revenue 2014: $687Expenses 2014: $906Net Income 2014: -$2192014Revenue 2015: $911Expenses 2015: $935Net Income 2015: -$242015Revenue 2016: $426Expenses 2016: $892Net Income 2016: -$4662016Revenue 2017: $839Expenses 2017: $1,341Net Income 2017: -$5022017Revenue 2018: $582Expenses 2018: $1,363Net Income 2018: -$7812018Revenue 2019: $3,493Expenses 2019: $1,335Net Income 2019: $2,1582019Revenue 2020: $358Expenses 2020: $1,354Net Income 2020: -$9962020Revenue 2021: $2,259Expenses 2021: $1,054Net Income 2021: $1,2052021Revenue 2022: $3,338Expenses 2022: $20,796Net Income 2022: -$17,4582022

Highlighted filing

2022

Revenue$3,338
Expenses$20,796
Net Income-$17,458
Open 2022 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2022 to Dec 31, 2022
Signed
Apr 26, 2023
Return Version
2022v5.0
Compensation and Service Providers
Top Officer Pay78th percentile

Employees

NameTitleFull / Part TimeBaseOtherTotal
PNC BANK NATrustee-$0--
Grants and Assistance

Foundation Grants and Related Investments

TypeRecipientPurposeStatusLocationAmount
Paid GrantAMERICAN CANCER SOCIETY INC C/O MICHAEL SAENZGENERAL SUPPORTPCOKLAHOMA CITY, OK, US$6,723
Paid GrantUNTD WAY OF CHAMPAIGN CTYGENERAL SUPPORTPCSAVOY, IL, US$6,723
Paid GrantUNIVERSITY OF IL FOUNDATION ATTN EJ CHUNG JDGENERAL SUPPORTPCURBANA, IL, US$6,723
Filing and Contact Details

Filer

Filer Name
Bertha Lam Tuw
EIN
37-6184661
Phone
4122094730
Address
116 ALLEGHENY CENTER MALL P8YB3502L, PITTSBURGH, PA 15212

Signing Officer

Name
Pnc Bank N a
Title
Tax Manager
Phone
4122094730
Signed
2023-04-26
Discuss with paid preparer
Yes

Preparer

Firm
Ernst & Young US Llp
Address
2100 ONE PPG PLACE, PITTSBURGH, PA 15222
Preparer
Jason Belot
Phone
3302555814
Raw XML Appendix342 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
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt0464287200 ISHARES CORE S&P 500
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt1921937835 VANGUARD TOTAL BOND
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt224610C840 DELAWARE VALUE FUND-
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt346432F842 ISHARES CORE MSCI EA
InvestmentsOtherSchedule2/InvestmentsOtherGrp/CategoryOrItemTxt4552746364 MFS EMERGING MKTS DE
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionAmt0131
IRS990PF/AnalysisIncomeProducingActyGrp/DividendsAndInterestFromSecDtl/ExclusionCd014
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionAmt03207
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/ExclusionCd018
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt03338
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt03338
IRS990PF/AnalysisOfRevenueAndExpenses/AdjustedNetIncomeAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt03207
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt020169
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt020169
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DeprecAndDpltnRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt0131
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt0131
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-17458
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt018959
IRS990PF/AnalysisOfRevenueAndExpenses/InterestDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/LegalFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt03207
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt03338
IRS990PF/AnalysisOfRevenueAndExpenses/NetSTCapitalGainAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OthEmplSlrsWgsNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt030
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt030
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PensionEmplBnftNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/PrintingAndPubNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TaxesRevAndExpnssAmt0597
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt020199
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt020796
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt03338
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt03338
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt030
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt0627
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingAdjNetIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/TravConfMeetingNetInvstIncmAmt00
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt02019-06-03
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt12019-06-03
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt22018-08-14
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt32019-06-03
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt42019-06-03
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt52021-06-29
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/AcquiredDt62009-04-01
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0554
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt1119
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt23599
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt34153
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt41075
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt51400
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt64852
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0376
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt129
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt2-52
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt32482
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt4217
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt5-119
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt6274
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0376
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt129
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt2-52
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt32482
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt4217
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt5-119
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt6274
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0930
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt1148
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt23547
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt36635
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt41292
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt51281
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt65126
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc02. ISHARES TR S&P 500 INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc12. ISHARES CORE MSCI EAFE ETF ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2170.716 DELAWARE VALUE FUND-R6
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc315. ISHARES TR S&P 500 INDEX FD
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc418. ISHARES CORE MSCI EAFE ETF ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc593.458 MFS EMERGING MKTS DEBT FD-R6
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc663. VANGUARD TOTAL BOND MARKET ETF
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt02022-01-10
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt12022-01-10
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt22022-02-17
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt32022-02-17
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt42022-02-17
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt52022-02-17
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/SoldDt62022-02-17
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt03207
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-17458
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt020
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt012
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt020
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt017466
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt0672
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt0672
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt0672
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt0718
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt046
IRS990PF/DistributableAmountGrp/TotalTaxAmt046
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/AppliedToESTaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EsPenaltyAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/EstimatedPlusOvpmtIncmTxAmt090
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExemptFrgnOrgTaxWthldAtSrceAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/ExtsnRequestIncomeTaxPaidAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt046
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/OverpaymentAmt044
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/RefundAmt044
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt046
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt046
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt090
IRS990PF/FinalReturnInd0X
IRS990PF/FMVAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AcctRcvblEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt017466
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowFASB117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsBOYAmt015752
IRS990PF/Form990PFBalanceSheetsGrp/OtherInvestmentsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/OtherRcvblAllwncDbtflAcctAmt00
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt01714
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt017466
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt017466
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt017466
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt00
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt014581
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt00
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt014581
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt0219
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt0718
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt014362
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt014581
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt01
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0PNC BANK NA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0PITTSBURGH
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0PA
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd015212
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization4947a1TrtdPFInd0X
IRS990PF/PFQualifyingDistributionsGrp/CharitableAssetsAcquisPaidAmt00
IRS990PF/PFQualifyingDistributionsGrp/ExpensesAndContributionsAmt020199
IRS990PF/PFQualifyingDistributionsGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/PFQualifyingDistributionsGrp/QualifyingDistributionsAmt020199
IRS990PF/PFQualifyingDistributionsGrp/SetAsideCashDistriTestAmt00
IRS990PF/PFQualifyingDistributionsGrp/SetAsideSuitabilityTestAmt00
IRS990PF/PFStatusTermSect507b1AInd0X
IRS990PF/StatementsRegardingActy4720Grp/ActsFailToQlfyAsExceptionsInd0false
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/PayCompDisqualifiedPrsnInd0true
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd0false
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd0false
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd0false
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/SubjToTaxRmnrtnExPrchtPymtInd0false
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd0false
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd0false
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd0false
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd0false
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd0true
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd0false
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd0true
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd0false
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd0false
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd0false
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd0true
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd0false
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0PITTSBURGH
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0PA
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd015212
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd0false
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd0false
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd0true
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0IL
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd0false
IRS990PF/StatementsRegardingActyGrp/PersonsWithBooksName/BusinessNameLine1Txt0PNC BANK NA
IRS990PF/StatementsRegardingActyGrp/PhoneNum04122094730
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd0false
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd0true
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd0false
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt06723
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt16723
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt26723
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2GENERAL SUPPORT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0AMERICAN CANCER SOCIETY INC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1UNTD WAY OF CHAMPAIGN CTY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2UNIVERSITY OF IL FOUNDATION
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine2Txt0C/O MICHAEL SAENZ
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine2Txt1ATTN EJ CHUNG JD
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2PC
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0NTL OFFICE OF PROBATE TR
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt15 DUNLAP COURT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt21305 W GREEN STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0OKLAHOMA CITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1SAVOY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2URBANA
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0OK
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2IL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd0731720366
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd1618749501
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd2618012900
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt020169
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/AppliedToCurrentYearAmt0672
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt0698
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt0672
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr4Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt018829
IRS990PF/UndistributedIncomeGrp/ExcessFromCurrentYearAmt018829
IRS990PF/UndistributedIncomeGrp/ExcessFromYear1Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear2Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear3Amt00
IRS990PF/UndistributedIncomeGrp/ExcessFromYear4Amt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt020199
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt018829
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt018829
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt0698
LiquidationExplanationStmt/ExplanationTxt0THE BERTHA LAM TRUST CLOSED DURING THE 2022 TAX YEAR PER THE SMALL BALANCE TERMINATION STATUTE UNDER ILLINOIS LAW. IT HAS DISTRIBUTED REMAINING FUNDS PER THE GOVERNING DOCUMENT. SEE ATTACHED
OtherDecreasesSchedule/OtherDecreasesDetail/Amt020
OtherDecreasesSchedule/OtherDecreasesDetail/Desc0ROUNDING ADJ FOR SALES AND TRANSACTIONS
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0STATE FILING FEES
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt030
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt00
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt030
OtherIncreasesSchedule/OtherIncreasesDetail/Amt012
OtherIncreasesSchedule/OtherIncreasesDetail/Desc02021 TRANSACTION POSTED IN 2022
TaxesSchedule/TaxesDetail/Amt026
TaxesSchedule/TaxesDetail/Amt127
TaxesSchedule/TaxesDetail/Amt2544
TaxesSchedule/TaxesDetail/CategoryTxt0INCOME TAX WITHHELD
TaxesSchedule/TaxesDetail/CategoryTxt1FEDERAL TAX PAYMENT - PRIOR YE
TaxesSchedule/TaxesDetail/CategoryTxt2FEDERAL ESTIMATES - PRINCIPAL
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt00
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt10
TaxesSchedule/TaxesDetail/DisbursementsCharitablePrpsAmt20
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt00
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt10
TaxesSchedule/TaxesDetail/NetInvestmentIncomeAmt20
ReturnHeader/BuildTS02023-04-26 12:10:37Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd0true
ReturnHeader/BusinessOfficerGrp/PersonNm0PNC BANK N A
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TAX MANAGER
ReturnHeader/BusinessOfficerGrp/PhoneNum04122094730
ReturnHeader/BusinessOfficerGrp/SignatureDt02023-04-26
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0BERTHA LAM TUW
ReturnHeader/Filer/BusinessNameControlTxt0LAM
ReturnHeader/Filer/EIN0376184661
ReturnHeader/Filer/PhoneNum04122094730
ReturnHeader/Filer/USAddress/AddressLine1Txt0116 ALLEGHENY CENTER MALL P8YB3502L
ReturnHeader/Filer/USAddress/CityNm0PITTSBURGH
ReturnHeader/Filer/USAddress/StateAbbreviationCd0PA
ReturnHeader/Filer/USAddress/ZIPCd015212
ReturnHeader/IRSResponsiblePrtyInfoCurrInd0false
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0346565596
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0ERNST & YOUNG US LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt02100 ONE PPG PLACE
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0PITTSBURGH
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0PA
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd015222
ReturnHeader/PreparerPersonGrp/PhoneNum03302555814
ReturnHeader/PreparerPersonGrp/PreparationDt02023-04-26
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0JASON BELOT
ReturnHeader/ReturnTs02023-05-03T18:00:28-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02022-01-01
ReturnHeader/TaxPeriodEndDt02022-12-31
ReturnHeader/TaxYr02022

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2022 • Form 990PFDetailed filing. Detailed filing data is available for this year.

Open filing
Assets
$0
Liabilities
$0
Net assets
$0
Revenue
$3,338
Expenses
$20,796
Net income
-$17,458
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2022Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$3.34$20.8$17.5
2021XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$17.5$0.00$17.5$2.26$1.05$1.21
2020XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$16.3$0.00$0.36$1.35$1.00
2019Detailed filing. Detailed filing data is available for this year.$17.3$0.00$17.3$3.49$1.34$2.16
2018XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$15.1$0.00$15.1$0.58$1.36$0.78
2017Detailed filing. Detailed filing data is available for this year.$15.9$0.00$15.9$0.84$1.34$0.50
2016XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$16.4$0.00$16.4$0.43$0.89$0.47
2015XML pending. An XML filing is linked for this year, but detailed extraction is still pending.$16.9$0.00$0.91$0.94$0.02
2014Detailed filing. Detailed filing data is available for this year.$16.9$0.00$16.9$0.69$0.91$0.22
2013Detailed filing. Detailed filing data is available for this year.$17.1$0.00$17.1$0.63$1.17$0.54
2012Summary only. Only limited summary data is available for this year.$17.6$0.00$0.80$1.97$1.17
2011Summary only. Only limited summary data is available for this year.$18.8$0.00$0.72$1.89$1.17