Civic Intelligence

Rachel Wetherill

990 • Fiscal year 2012 • EIN 23-6206108

Jan 01, 2012 to Dec 31, 2012 • Filed on Mar 01, 2013

Organization Profile
Pnc Bank Na 620 Liberty Avenue No10 FL15222-2705
Siviq Scores

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

Liabilities / Assets

58th percentile

0.00x

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

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

Liabilities / Revenue

Score unavailable

No value available

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

Source year 2012

Net Margin

Score unavailable

No value available

Net margin requires both revenue and expenses on this filing.

Source year 2012

Top Officer Pay

Score unavailable

No value available

This filing does not contain officer compensation rows.

Source year 2012

Asset Growth

Score unavailable

No value available

A valid growth rate could not be computed from the available filing history.

Annualized from 2011 to 2012

Revenue Growth

Score unavailable

No value available

No valid filing value is available for this score.

Balance Sheet
Liabilities / Assets58th percentile

Assets

Down

$65,552

Down $2,290 (-3.4%) from 2011

Net Assets

Down

$65,552

Down $2,290 (-3.4%) from 2011

Liabilities

Flat

$0

Flat from 2011

Revenue And Expenses
Liabilities / RevenueScore unavailableNet MarginScore unavailable

Revenue

-

No earlier filing loaded for comparison.

Expenses

Up

$4,989

Up $390 (+8.5%) from 2011

Net Income

-

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.

$80K$60K$40K$20K$0Assets 2010: $69,480Liabilities 2010: $0Net Assets 2010: $69,4802010Assets 2011: $67,842Liabilities 2011: $0Net Assets 2011: $67,8422011Assets 2012: $65,552Liabilities 2012: $0Net Assets 2012: $65,5522012Assets 2013: $0Liabilities 2013: $0Net Assets 2013: $02013

Highlighted filing

2012

Assets$65,552
Liabilities$0
Net Assets$65,552
Open 2012 Filing

Operations Trend

Revenue GrowthScore unavailable

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

$100K$50K$0-$50K-$100KExpenses 2010: $4,6532010Expenses 2011: $4,5992011Expenses 2012: $4,9892012Revenue 2013: $18,982Expenses 2013: $84,534Net Income 2013: -$65,5522013

Highlighted filing

2012

Revenue-
Expenses$4,989
Net Income-
Open 2012 Filing
Jump To
Filing Snapshot
Filing Period
Jan 1, 2012 to Dec 31, 2012
Signed
Mar 1, 2013
Return Version
2012v2.1
Gross Receipts
$6,613
Filing and Contact Details

Filer

EIN
23-6206108
Raw XML Appendix294 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
IRS990/AccountantCompileOrReview00
IRS990/ActivitiesConductedPartnership00
IRS990/ActivityOrMissionDescription0FINANCIAL SUPPORT OF OLD UNION CHURCH, ST. PAULS MEMORIAL EPISCOPAL CHURCH
IRS990/AddressPrincipalOfficerUS/AddressLine10PNC BANK 620 LIBERTY AVE
IRS990/AddressPrincipalOfficerUS/City0PITTSBURGH
IRS990/AddressPrincipalOfficerUS/State0PA
IRS990/AddressPrincipalOfficerUS/ZIPCode0152222705
IRS990/AmountOfTaxExemptInterest00
IRS990/AnnualDisclosureCoveredPersons01
IRS990/BenefitsPaidToMembersCY00
IRS990/BenefitsPaidToMembersPriorYear00
IRS990/BsnssRltnshpThruFamilyMember00
IRS990/BsnssRltnshpWithOrganization00
IRS990/CapStckTrstPrinCurrentFunds/BOY067476
IRS990/CapStckTrstPrinCurrentFunds/EOY065227
IRS990/ChangesToOrganizingDocs00
IRS990/CollectionsOfArt00
IRS990/CompCurrentOfficersDirectors/ManagementAndGeneral0931
IRS990/CompCurrentOfficersDirectors/Total0931
IRS990/CompensationFromOtherSources00
IRS990/CompensationProcessCEO00
IRS990/CompensationProcessOther00
IRS990/ConflictOfInterestPolicy01
IRS990/ConservationEasements00
IRS990/ConsolidatedAuditFinancialStmt00
IRS990/ContributionsGrantsCurrentYear00
IRS990/ContributionsGrantsPriorYear00
IRS990/CreditCounseling00
IRS990/DecisionsSubjectToApproval00
IRS990/DeductibleContributionsOfArt00
IRS990/DeductibleNonCashContributions00
IRS990/DelegationOfManagementDuties00
IRS990/DescribedIn501C301
IRS990/Description0PROVIDED FINANCIAL SUPPORT TO OLD UNION CHURCH, ST PAULS MEMORIAL EPISCOPAL CHURCH
IRS990/DisregardedEntity00
IRS990/DocumentRetentionPolicy01
IRS990/DonorAdvisedFunds00
IRS990/DoNotFollowSFAS1170X
IRS990/ElectionOfBoardMembers00
IRS990/ExcessBenefitTransaction00
IRS990/Expense03558
IRS990/FamilyOrBusinessRelationship00
IRS990/FederalGrantAuditRequired00
IRS990/FeesForServicesAccounting/ManagementAndGeneral0500
IRS990/FeesForServicesAccounting/Total0500
IRS990/FiledLieu104101
IRS990/ForeignActivities00
IRS990/ForeignFinancialAccount00
IRS990/ForeignOffice00
IRS990/Form8282PropertyDisposedOf00
IRS990/Form990PartVIISectionA/AverageHoursPerWeek01.00
IRS990/Form990PartVIISectionA/InstitutionalTrustee0X
IRS990/Form990PartVIISectionA/NamePerson0PNC BANK NA
IRS990/Form990PartVIISectionA/OtherCompensation00
IRS990/Form990PartVIISectionA/ReportableCompFromOrganization0931
IRS990/Form990PartVIISectionA/ReportableCompFromRelatedOrgs00
IRS990/Form990PartVIISectionA/Title0TRUSTEE
IRS990/Form990ProvidedToGoverningBody01
IRS990/FormersListed00
IRS990/FSAudited00
IRS990/FundraisingActivities00
IRS990/GainOrLoss/Other0279
IRS990/GainOrLoss/Securities0689
IRS990/Gaming00
IRS990/Grants03558
IRS990/GrantsAndSimilarAmntsCY03558
IRS990/GrantsAndSimilarAmntsPriorYear03413
IRS990/GrantsToDomesticOrgs/ProgramServices03558
IRS990/GrantsToDomesticOrgs/Total03558
IRS990/GrantsToIndividuals00
IRS990/GrantsToOrganizations00
IRS990/GrantToRelatedPerson00
IRS990/GrossAmountSalesAssets/Other0279
IRS990/GrossAmountSalesAssets/Securities04603
IRS990/GrossReceipts06613
IRS990/GroupReturnForAffiliates00
IRS990/Hospital00
IRS990/IndependentAuditFinancialStmt00
IRS990/IndoorTanningServices00
IRS990/InfoInScheduleOPartVI0X
IRS990/InvestmentIncomeCurrentYear02699
IRS990/InvestmentIncome/ExclusionAmount01731
IRS990/InvestmentIncomePriorYear02961
IRS990/InvestmentIncome/TotalRevenueColumn01731
IRS990/InvestmentInJointVenture00
IRS990/InvestmentsPubTradedSecurities/BOY067330
IRS990/InvestmentsPubTradedSecurities/EOY063748
IRS990/LessCostOthBasisSalesExpenses/Other00
IRS990/LessCostOthBasisSalesExpenses/Securities03914
IRS990/LoanToOfficerOrDQP00
IRS990/LobbyingActivities00
IRS990/LocalChapters00
IRS990/MaterialDiversionOrMisuse00
IRS990/MembersOrStockholders00
IRS990/MethodOfAccountingCash0X
IRS990/MinutesOfCommittees00
IRS990/MinutesOfGoverningBody00
IRS990/MissionDescription0FINANCIAL SUPPORT OF OLD UNION CHURCH, ST. PAULS MEMORIAL EPISCOPAL CHURCH
IRS990/MoreThan5000KToIndividuals00
IRS990/MoreThan5000KToOrganizations00
IRS990/NameOfPrincipalOfficerPerson0AMY REES
IRS990/NbrIndependentVotingMembers01
IRS990/NbrVotingGoverningBodyMembers01
IRS990/NbrVotingMembersGoverningBody01
IRS990/NetAssetsOrFundBalancesBOY067842
IRS990/NetAssetsOrFundBalancesEOY065552
IRS990/NetGainOrLossInvestments/ExclusionAmount0968
IRS990/NetGainOrLossInvestments/TotalRevenueColumn0968
IRS990/NetUnrelatedBusinessTxblIncome00
IRS990/NonDeductibleContributions00
IRS990/NumberFormsTransmittedWith109600
IRS990/NumberIndependentVotingMembers01
IRS990/NumberIndividualsGT100K00
IRS990/NumberOfContractorsGT100K00
IRS990/NumberOfEmployees00
IRS990/NumberW2GIncluded00
IRS990/OfficerEntityWithBsnssRltnshp00
IRS990/OfficerMailingAddress00
IRS990/Organization4947a10X
IRS990/OtherExpensePriorYear0250
IRS990/OtherExpensesCurrentYear0500
IRS990/OtherRevenueCurrentYear00
IRS990/OtherRevenuePriorYear00
IRS990/OtherWebsite0X
IRS990/PaidInCapSrplsLandBldgEqpFund/BOY00
IRS990/PaidInCapSrplsLandBldgEqpFund/EOY00
IRS990/PartialLiquidation00
IRS990/PoliticalActivities00
IRS990/PriorExcessBenefitTransaction00
IRS990/ProfessionalFundraising00
IRS990/ProgramServiceRevenueCY00
IRS990/ProgramServiceRevenuePriorYear00
IRS990/ProhibitedTaxShelterTrans00
IRS990/QuidProQuoContributions00
IRS990/ReconcilationOtherChanges00
IRS990/ReconcilationRevenueExpenses0-2290
IRS990/RegularMonitoringEnforcement01
IRS990/RelatedEntity01
IRS990/RelatedOrgControlledEntity00
IRS990/ReportFin48Footnote00
IRS990/ReportInvestOthSecurities00
IRS990/ReportLandBldgEquip01
IRS990/ReportOtherAssets00
IRS990/ReportOtherLiabilities00
IRS990/ReportProgRelInvest00
IRS990/RetainedEarningsEndowmentEtc/BOY0366
IRS990/RetainedEarningsEndowmentEtc/EOY0325
IRS990/RevenuesLessExpensesCY0-2290
IRS990/RevenuesLessExpensesPriorYear0-1638
IRS990/SalariesEtcCurrentYear0931
IRS990/SalariesEtcPriorYear0936
IRS990/SavingsAndTempCashInvestments/BOY0512
IRS990/SavingsAndTempCashInvestments/EOY01804
IRS990ScheduleA/CertificationCheckbox0X
IRS990ScheduleA/ContribBy35ControlledEntity00
IRS990ScheduleA/ContribByControllingIndividual00
IRS990ScheduleA/ContributionByRelatedParty00
IRS990ScheduleA/SumOfAmounts03558
IRS990ScheduleA/SupportedOrgInformation/Amount03558
IRS990ScheduleA/SupportedOrgInformation/EIN0232012758
IRS990ScheduleA/SupportedOrgInformation/ListedInGoverningDoc01
IRS990ScheduleA/SupportedOrgInformation/Name/BusinessNameLine10ST PAULS MEMORIAL EPISCOPAL CHURCH
IRS990ScheduleA/SupportedOrgInformation/OrganizedInUS01
IRS990ScheduleA/SupportedOrgInformation/SupportedOrganizationNotified01
IRS990ScheduleA/SupportedOrgInformation/TypeOfOrganization01
IRS990ScheduleA/SupportingOrg509a3Type3NonFunc0X
IRS990ScheduleA/SupportingOrganization509a30X
IRS990ScheduleA/TotalNumberOfSupportedOrgs01
IRS990/ScheduleBRequired00
IRS990ScheduleD/TotalOfBookValueLandBuildings00
IRS990ScheduleI/Form990ScheduleIPartIV/Explanation0SCHEDULE I, PART I, LINE 2: THE RACHEL WETHERILL TRUST IS A TRUST FUND THAT DISBURSES FUNDS ONLY TO QUALIFYING ORGANIZATIONS AS DIRECTED BY THE TRUST'S GOVERNING INSTRUMENT TO BE USED ONLY IN ACCORDANCE WITH THE GOVERNING INSTRUMENT.
IRS990ScheduleI/Form990ScheduleIPartIV/Identifier0PROCEDURE FOR MONITORING GRANTS IN THE U.S.:
IRS990ScheduleI/Form990ScheduleIPartIV/ReturnReference0PART I, LINE 2:
IRS990ScheduleI/RecordsMaintained01
IRS990/ScheduleJRequired00
IRS990ScheduleO/GeneralExplanation/Explanation0THE RACHEL WETHERILL TRUST IS A TRUST FUND AND HAS NO WRITTEN POLICY REGARDING DOCUMENTATION OF MEETINGS AND WRITTEN ACTIONS OF ITS GOVERNING BODY AND COMMITTEES WITH AUTHORITY TO ACT ON ITS BEHALF
IRS990ScheduleO/GeneralExplanation/Explanation1THE RACHEL WETHERILL TRUST IS A TRUST FUND AND HAS NO WRITTEN POLICY REGARDING DOCUMENTATION OF MEETINGS AND WRITTEN ACTIONS OF ITS GOVERNING BODY AND COMMITTEES WITH AUTHORITY TO ACT ON ITS BEHALF
IRS990ScheduleO/GeneralExplanation/Explanation2PNC BANK AS SOLE TRUSTEE OF THE TRUST PREPARES THE TAX RETURNS FOR THIS TRUST THUS FORM 990 IS PREPARED BY THE GOVERNING BODY
IRS990ScheduleO/GeneralExplanation/Explanation3THE CONFLICT OF INTEREST POLICY OF PNC CHARITABLE TRUST REQUIRES AN ANNUAL AFFIRMATION THAT IT HAS BEEN RECEIVED, READ, UNDERSTOOD AND AGREED TO BE COMPLIED WITH. IN ADDITION, THE POLICY REQUIRES AN ANNUAL DISCLOSURE OF THE EXISTENCE AND NATURE OF ANY AFFILIATION IN WHICH A PARTY WOULD BE CONSIDERED AN INTERESTED PERSON UNDER THE POLICY.
IRS990ScheduleO/GeneralExplanation/Explanation4FORM 990 AND RELATED FINANCIAL STATEMENTS ARE MADE AVAILABLE THROUGH REQUEST AND FROM GUIDESTAR.ORG.
IRS990ScheduleO/GeneralExplanation/Explanation5FORM 990 AND RELATED FINANCIAL STATEMENTS ARE MADE AVAILABLE THROUGH REQUEST AND FROM GUIDESTAR.ORG. THE GOVERNING DOCUMENTS AND CONFLICT OF INTEREST POLICY ARE MADE AVAILABLE TO THE PUBLIC UPON REQUEST.
IRS990ScheduleO/GeneralExplanation/ReturnReference0FORM 990, PART VI, SECTION A, LINE 8A
IRS990ScheduleO/GeneralExplanation/ReturnReference1FORM 990, PART VI, SECTION A, LINE 8B
IRS990ScheduleO/GeneralExplanation/ReturnReference2FORM 990, PART VI, SECTION B, LINE 11
IRS990ScheduleO/GeneralExplanation/ReturnReference3FORM 990, PART VI, SECTION B, LINE 12C
IRS990ScheduleO/GeneralExplanation/ReturnReference4FORM 990, PART VI, SECTION C, LINE 18
IRS990ScheduleO/GeneralExplanation/ReturnReference5FORM 990, PART VI, SECTION C, LINE 19
IRS990/ScheduleORequired01
IRS990ScheduleR/DividendsRelatedOrganization00
IRS990ScheduleR/ExchangeOfAssets00
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/AddressLine10126 BLACK ROCK RD
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/City0OALS
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/State0PA
IRS990ScheduleR/Form990ScheduleRPartII/AddressUS/ZIPCode019456
IRS990ScheduleR/Form990ScheduleRPartII/ControlledOrg00
IRS990ScheduleR/Form990ScheduleRPartII/EIN0232012758
IRS990ScheduleR/Form990ScheduleRPartII/ExemptCodeSection0501(C)(3)
IRS990ScheduleR/Form990ScheduleRPartII/LegalDomicileState0PA
IRS990ScheduleR/Form990ScheduleRPartII/NameOfDisregardedEntity/BusinessNameLine10OLD UNION CHURCH ST PAUL'S MEMORIAL EPISCOPAL CHURCH
IRS990ScheduleR/Form990ScheduleRPartII/PrimaryActivities0CHURCH
IRS990ScheduleR/Form990ScheduleRPartII/PublicCharityStatus0LINE 1
IRS990ScheduleR/GiftGrantOrCapContrFrOtherOrg00
IRS990ScheduleR/GiftGrantOrCapContrToOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesFromOtherOrg00
IRS990ScheduleR/LoansOrGuaranteesToOtherOrg00
IRS990ScheduleR/OtherTransferFromOtherOrg00
IRS990ScheduleR/OtherTransferToOtherOrg00
IRS990ScheduleR/PerformOfServicesByOtherOrgs00
IRS990ScheduleR/PerformOfServicesForOtherOrgs00
IRS990ScheduleR/PurchaseOfAssetsFromOtherOrg00
IRS990ScheduleR/ReceiptOfIntAnnRentsRoyalties00
IRS990ScheduleR/ReimbursementPaidByOtherOrg00
IRS990ScheduleR/ReimbursementPaidToOtherOrg00
IRS990ScheduleR/RentalOfFacilitiesFrOtherOrgs00
IRS990ScheduleR/RentalOfFacilitiesToOtherOrgs00
IRS990ScheduleR/SaleOfAssetsToOtherOrg00
IRS990ScheduleR/SharingOfFacilities00
IRS990ScheduleR/SharingOfPaidEmployees00
IRS990/School00
IRS990/SignificantChange00
IRS990/SignificantNewProgramServices00
IRS990/StateLegalDomicile0PA
IRS990/SubjectToProxyTax00
IRS990/TaxablePartyNotification00
IRS990/TaxExemptBonds00
IRS990/Terminated00
IRS990/TermOrPermanentEndowments00
IRS990/TheBooksAreInCareOf/AddressUS/AddressLine10620 LIBERTY AVENUE 10TH FLOOR
IRS990/TheBooksAreInCareOf/AddressUS/City0PITTSBURGH
IRS990/TheBooksAreInCareOf/AddressUS/State0PA
IRS990/TheBooksAreInCareOf/AddressUS/ZIPCode0152222705
IRS990/TheBooksAreInCareOf/NameBusiness/BusinessNameLine10PNC BANK NA
IRS990/TheBooksAreInCareOf/TelephoneNumber04127685898
IRS990/TotalAssets/BOY067842
IRS990/TotalAssetsBOY067842
IRS990/TotalAssets/EOY065552
IRS990/TotalAssetsEOY065552
IRS990/TotalCompGT150K00
IRS990/TotalExpensesCurrentYear04989
IRS990/TotalExpensesPriorYear04599
IRS990/TotalFunctionalExpenses/Fundraising00
IRS990/TotalFunctionalExpenses/ManagementAndGeneral01431
IRS990/TotalFunctionalExpenses/ProgramServices03558
IRS990/TotalFunctionalExpenses/Total04989
IRS990/TotalFundrsngExpCurrentYear00
IRS990/TotalGrossUBI00
IRS990/TotalLiabilities/BOY00
IRS990/TotalLiabilitiesBOY00
IRS990/TotalLiabilities/EOY00
IRS990/TotalLiabilitiesEOY00
IRS990/TotalLiabNetAssetsFundBalances/BOY067842
IRS990/TotalLiabNetAssetsFundBalances/EOY065552
IRS990/TotalNbrEmployees00
IRS990/TotalNbrVolunteers00
IRS990/TotalNetAssetsFundBalances/BOY067842
IRS990/TotalNetAssetsFundBalances/EOY065552
IRS990/TotalOtherCompensation00
IRS990/TotalProfFundrsngExpCY00
IRS990/TotalProfFundrsngExpPriorYear00
IRS990/TotalProgramServiceExpense03558
IRS990/TotalReportableCompFrmRltdOrgs00
IRS990/TotalReportableCompFromOrg0931
IRS990/TotalRevenueCurrentYear02699
IRS990/TotalRevenue/ExclusionAmount02699
IRS990/TotalRevenuePriorYear02961
IRS990/TotalRevenue/RelatedOrExemptFunctionIncome00
IRS990/TotalRevenue/TotalRevenueColumn02699
IRS990/TotalRevenue/UnrelatedBusinessRevenue00
IRS990/TransfersToExemptNonChrtblOrg00
IRS990/TypeOfOrganizationTrust0X
IRS990/UnrelatedBusinessIncome00
IRS990/UponRequest0X
IRS990/WebSite0N/A
IRS990/WhistleblowerPolicy00
IRS990/YearFormation01844
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/Filer/EIN0236206108
ReturnHeader/Filer/Name/BusinessNameLine10RACHEL WETHERILL
ReturnHeader/Filer/NameControl0WETH
ReturnHeader/Filer/Phone04127685898
ReturnHeader/Filer/USAddress/AddressLine10PNC BANK NA 620 LIBERTY AVENUE NO
ReturnHeader/Filer/USAddress/AddressLine2010 FL
ReturnHeader/Filer/USAddress/City0PITTSBURGH
ReturnHeader/Filer/USAddress/State0PA
ReturnHeader/Filer/USAddress/ZIPCode0152222705
ReturnHeader/Officer/DateSigned02013-03-01
ReturnHeader/Officer/Name0JOHN W ALRUTZ
ReturnHeader/Officer/Phone04127688192
ReturnHeader/Officer/Title0ASSISTANT VICE PRESIDENT
ReturnHeader/ReturnType0990
ReturnHeader/TaxPeriodBeginDate02012-01-01
ReturnHeader/TaxPeriodEndDate02012-12-31
ReturnHeader/TaxYear02012
ReturnHeader/Timestamp02013-03-01T07:38:50-06:00

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Displayed year

2012 • Form 990Facts available. Structured filing facts are available, but richer extracted sections are limited.

Open filing
Assets
$65,552
Liabilities
$0
Net assets
$65,552
Revenue
-
Expenses
$4,989
Net income
-
Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2013Detailed filing. Detailed filing data is available for this year.$0.00$0.00$0.00$19.0$84.5$65.6
2012Facts available. Structured filing facts are available, but richer extracted sections are limited.$65.6$0.00$65.6$4.99
2011Facts available. Structured filing facts are available, but richer extracted sections are limited.$67.8$0.00$67.8$4.60
2010Facts available. Structured filing facts are available, but richer extracted sections are limited.$69.5$0.00$69.5$4.65