Civic Intelligence

Mcgregor Family Charitable Trust C/O Nbt Financial Group

990PF • Fiscal year 2014 • EIN 20-7341100

Jan 01, 2014 to Dec 31, 2014 • Filed on May 13, 2015

120 Madison St Attn Bshay Vp No1800Syracuse, NY 13202

(315) 475-7595

Siviq Scores

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

Liabilities / Assets

89th percentile

0.00x

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

2014 filings • NTEE T22 • <$500k nonprofits • Source year 2014

Liabilities / Revenue

89th percentile

0.00x

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

2014 filings • NTEE T22 • <$500k nonprofits • Source year 2014

Net Margin

72nd percentile

40%

Higher net margin than 72% of similar nonprofits.

2014 filings • NTEE T22 • <$500k nonprofits • Source year 2014

Top Officer Pay

93rd percentile

$0

Higher top officer pay than 93% of similar nonprofits.

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

2014 filings • NTEE T22 • <$500k nonprofits • Source year 2014

Asset Growth

68th percentile

5.1%

Faster asset growth than 68% of similar nonprofits.

2014 filings • NTEE T22 • <$500k nonprofits • Annualized from 2013 to 2014

Revenue Growth

87th percentile

217%

Faster revenue growth than 87% of similar nonprofits.

2014 filings • NTEE T22 • <$500k nonprofits • Annualized from 2013 to 2014

Assets

Up

$391,687

Up $19,054 (+5.1%) from 2013

Net Assets

Up

$391,687

Up $19,054 (+5.1%) from 2013

Liabilities

Flat

$0

Flat from 2013

Revenue

Up

$43,920

Up $30,074 (+217%) from 2013

Expenses

Up

$26,439

Up $7,546 (+40%) from 2013

Net Income

Up

$17,481

Up $22,528 (+446%) from 2013

Historical Trend

Balance Sheet Trend

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

$600K$400K$200K$0Assets 2010: $377,209Liabilities 2010: $0Net Assets 2010: $377,2092010Assets 2011: $384,115Liabilities 2011: $0Net Assets 2011: $384,1152011Assets 2012: $377,680Liabilities 2012: $12012Assets 2013: $372,633Liabilities 2013: $0Net Assets 2013: $372,6332013Assets 2014: $391,687Liabilities 2014: $0Net Assets 2014: $391,6872014Assets 2015: $386,798Liabilities 2015: $0Net Assets 2015: $386,7982015Assets 2016: $383,881Liabilities 2016: $0Net Assets 2016: $383,8812016Assets 2017: $376,616Liabilities 2017: $0Net Assets 2017: $376,6162017Assets 2018: $373,151Liabilities 2018: $0Net Assets 2018: $373,1512018Assets 2019: $411,436Liabilities 2019: $0Net Assets 2019: $411,4362019Assets 2020: $381,584Liabilities 2020: $0Net Assets 2020: $381,5842020Assets 2021: $366,330Liabilities 2021: $0Net Assets 2021: $366,3302021Assets 2022: $342,281Liabilities 2022: $0Net Assets 2022: $342,2812022Assets 2023: $331,943Liabilities 2023: $0Net Assets 2023: $331,9432023Assets 2024: $325,339Liabilities 2024: $0Net Assets 2024: $325,3392024

Highlighted filing

2014

Assets$391,687
Liabilities$0
Net Assets$391,687

Operations Trend

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

$100K$50K$0-$50KExpenses 2010: $11,0142010Expenses 2011: $20,0582011Revenue 2012: $12,683Expenses 2012: $19,118Net Income 2012: -$6,4352012Revenue 2013: $13,846Expenses 2013: $18,893Net Income 2013: -$5,0472013Revenue 2014: $43,920Expenses 2014: $26,439Net Income 2014: $17,4812014Revenue 2015: $22,534Expenses 2015: $27,509Net Income 2015: -$4,9752015Revenue 2016: $24,607Expenses 2016: $27,630Net Income 2016: -$3,0232016Revenue 2017: $20,441Expenses 2017: $27,706Net Income 2017: -$7,2652017Revenue 2018: $24,151Expenses 2018: $27,616Net Income 2018: -$3,4652018Revenue 2019: $69,554Expenses 2019: $31,269Net Income 2019: $38,2852019Revenue 2020: $14,442Expenses 2020: $44,294Net Income 2020: -$29,8522020Revenue 2021: $28,232Expenses 2021: $43,486Net Income 2021: -$15,2542021Revenue 2022: $9,851Expenses 2022: $33,900Net Income 2022: -$24,0492022Revenue 2023: $12,613Expenses 2023: $22,951Net Income 2023: -$10,3382023Revenue 2024: $21,213Expenses 2024: $27,817Net Income 2024: -$6,6042024

Highlighted filing

2014

Revenue$43,920
Expenses$26,439
Net Income$17,481
Jump To
Filing Snapshot
Filing Period
Jan 1, 2014 to Dec 31, 2014
Signed
May 13, 2015
Return Version
2014v5.0
Compensation and Service Providers

Employees

NameTitleFull / Part TimeBaseOtherTotal
NBT BANK NA - ATTN BARRY SHAY VPTrustee-$0--
JAMES HOYTrustee-$0--
PATRICK J POWERSTrustee-$0--
Filing and Contact Details

Filer

Filer Name
Mcgregor Family Charitable Trust
EIN
20-7341100
Phone
3154757595
Address
120 MADISON ST ATTN BSHAY VP NO, 1800, SYRACUSE, NY 13202

Signing Officer

Name
Barry Shay-vice President
Title
Trustee
Phone
3153369220
Signed
2015-05-13
Discuss with paid preparer
Yes

Preparer

Firm
D'ARCANGELO & CO LLP
Address
200 EAST GARDEN STREET, ROME, NY 13442-4300
Preparer
Patrick J Powers CPA
Phone
3153369220
Raw XML Appendix356 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/Amt01300
AccountingFeesSchedule/AccountingFeesDetail/CategoryTxt0ACCOUNTING SERVICES
AccountingFeesSchedule/AccountingFeesDetail/DisbursementsCharitablePrpsAmt01300
AccountingFeesSchedule/AccountingFeesDetail/NetInvestmentIncomeAmt01300
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0386281
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0425275
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0NBT BANK INVESTMENTS NON-GOVERNMENT SECURITIES
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/RelatedOrExemptFunctionIncmAmt012356
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/RelatedOrExemptFunctionIncmAmt031564
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt043920
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt043920
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesChrtblPrpsAmt01300
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesNetInvstIncmAmt01300
IRS990PF/AnalysisOfRevenueAndExpenses/AccountingFeesRevAndExpnssAmt01300
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt031564
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt022972
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt022972
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt012356
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt012356
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt017481
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0223051
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt031564
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt040453
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt0504
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt0504
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0504
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt01663
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt01663
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt01663
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt026439
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt03467
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt026439
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt043920
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt043920
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt03467
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt03467
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt03467
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt0191487
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt028288
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt13276
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt028288
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt13276
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt0219775
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt13276
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0NBT BANK A/C 15069611 L/T SALES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt031564
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt017481
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt01573
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0391687
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0372633
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0391687
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt019763
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt019763
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt019763
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt020168
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0405
IRS990PF/DistributableAmountGrp/TotalTaxAmt0405
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0405
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0405
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0405
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0405
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt00
IRS990PF/FMVAssetsEOYAmt0430681
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0364922
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0386281
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0425275
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0391687
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt07711
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt05406
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt05406
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0391687
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0430681
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0391687
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0391687
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0409503
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt04508
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0404995
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt06143
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt020168
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0403360
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0409503
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdCntrctOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/CompOfHghstPdEmplOrNONETxt0NONE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/ContractorPaidOver50kCnt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt04.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt12.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/AverageHrsPerWkDevotedToPosRt22.00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/CompensationAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/EmployeeBenefitProgramAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt00
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt10
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/ExpenseAccountOtherAllwncAmt20
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm0NBT BANK NA - ATTN BARRY SHAY VP
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm1JAMES HOY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/PersonNm2PATRICK J POWERS
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt0TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt1TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/TitleTxt2TRUSTEE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt0120 MADISON ST SUITE 1800 ATTN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt1911 MACEWIN DRIVE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine1Txt2PO BOX 4300
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine2Txt0BSHAY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm0SYRACUSE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm1OSPREY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/CityNm2ROME
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd0NY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd1FL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/StateAbbreviationCd2NY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd013202
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd134229
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCd213440
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt015308
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt015713
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt018771
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt019009
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt019827
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt010610
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt05928
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.037951
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.045016
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.048350
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.049397
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.028759
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.018232
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0405
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0403360
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0416983
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0393157
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0401384
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0368924
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0325151
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt026439
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.189754
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt026034
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt026439
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0405
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt026439
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/LineNumberTxt04
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/LineNumberTxt18
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/RelationshipStatementTxt0INVESTMENT INCOME IS DISTRIBUTED TO LOCAL CHARITIES AS REQUIRED.
IRS990PF/RlnOfActyToAccomOfExmptPrpsGrp/RlnOfActyToAccomOfExmptPrpsGrp/RelationshipStatementTxt1INVESTMENT INCOME IS DISTRIBUTED TO LOCAL CHARITIES AS REQUIRED.
IRS990PF/StatementsRegardingActy4720Grp/BrrwOrLendDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/BusinessHoldingsInd00
IRS990PF/StatementsRegardingActy4720Grp/FurnGoodsDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToIndividualsInd00
IRS990PF/StatementsRegardingActy4720Grp/GrantsToOrganizationsInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceElectionInd00
IRS990PF/StatementsRegardingActy4720Grp/InfluenceLegislationInd00
IRS990PF/StatementsRegardingActy4720Grp/JeopardyInvestmentsInd00
IRS990PF/StatementsRegardingActy4720Grp/NoncharitablePurposeInd00
IRS990PF/StatementsRegardingActy4720Grp/PayCompDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/PaymentToGovernmentOfficialInd00
IRS990PF/StatementsRegardingActy4720Grp/PayPremiumsPrsnlBnftCntrctInd00
IRS990PF/StatementsRegardingActy4720Grp/ProhibitedTaxShelterTransInd00
IRS990PF/StatementsRegardingActy4720Grp/RcvFndsToPayPrsnlBnftCntrctInd01
IRS990PF/StatementsRegardingActy4720Grp/SaleOrExchDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/TransferAstDisqualifiedPrsnInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPriorActsInd00
IRS990PF/StatementsRegardingActy4720Grp/UncorrectedPYJeopardyInvstInd00
IRS990PF/StatementsRegardingActy4720Grp/UndistributedIncomePYInd00
IRS990PF/StatementsRegardingActyGrp/ActivitiesNotPreviouslyRptInd00
IRS990PF/StatementsRegardingActyGrp/AtLeast5000InAssetsInd01
IRS990PF/StatementsRegardingActyGrp/ChangesToArticlesOrBylawsInd00
IRS990PF/StatementsRegardingActyGrp/ComplyWithPublicInspRqrInd01
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0NBT FINANCIAL GROUP
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine1Txt0120 MADISON ST SUITE 1800 ATTN B
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine2Txt0SHAY VP
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/CityNm0SYRACUSE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/StateAbbreviationCd0NY
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCd013202
IRS990PF/StatementsRegardingActyGrp/MoreThan100SpentInd00
IRS990PF/StatementsRegardingActyGrp/NewSubstantialContributorsInd00
IRS990PF/StatementsRegardingActyGrp/OrganizationDissolvedEtcInd00
IRS990PF/StatementsRegardingActyGrp/OrgReportOrRegisterStateCd0NY
IRS990PF/StatementsRegardingActyGrp/OwnControlledEntityInd00
IRS990PF/StatementsRegardingActyGrp/PhoneNum03154757595
IRS990PF/StatementsRegardingActyGrp/PrivateOperatingFoundationInd00
IRS990PF/StatementsRegardingActyGrp/Section4955ManagersTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section4955OrganizationTaxAmt00
IRS990PF/StatementsRegardingActyGrp/Section508eRqrSatisfiedInd00
IRS990PF/StatementsRegardingActyGrp/TaxReimbursedAmt00
IRS990PF/StatementsRegardingActyGrp/UnrelatedBusIncmOverLimitInd00
IRS990PF/StatementsRegardingActyGrp/WebsiteAddressTxt0NA
IRS990PF/SumOfProgramRelatedInvstGrp/TotalAmt00
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt05743
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt15743
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt25743
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt32297
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt43446
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt0COMMUNITY MEMORIAL HOSPITAL OF HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt1HAMILTON CENTRAL SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt2POOLVILLE UNITED METHODIST CHURCH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt3SHERBURNE-EARLVILLE CENTRAL SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine1Txt4SOUTHERN MADISON COUNTY VOLUNTEER AMBULANCE CORP
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt0HOSPITAL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt1SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt2CHURCH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt3SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientFoundationStatusTxt4OTHER CHARITY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt0NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt1NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt2NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt3NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientRelationshipTxt4NONE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt0150 BROAD STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt147 WEST KENDRICK STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt2PO BOX 249
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt315 THOMAS STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1Txt4PO BOX 453
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm0HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm1HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm2NORTH NORWICH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm3SHERBURNE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/CityNm4HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd0NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd1NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd2NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd3NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/StateAbbreviationCd4NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd013346
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd113346
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd213346
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd313460
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCd413346
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt022972
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/LoansOrLoanGuaranteesInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PerformanceOfServicesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/PurchaseOfAssetsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/ReimbursementArrangementsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RelationshipsNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/RentalOfFacilitiesOthAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SalesOrExchangesOfAssetsInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/SharingOfFacilitiesEtcInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOfCashToNonchrtblEOInd00
IRS990PF/TrnsfrTransRlnNonchrtblEOGrp/TrnsfrOtherAssetNonchrtblEOInd00
IRS990PF/UndistributedIncomeGrp/AppliedToCurrentYearAmt08179
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt018260
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt019763
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt026439
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt011584
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt018260
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0NYS FILING FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1US TREASURY
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2FOREIGN TAX PAID ON DIVIDENDS
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt0100
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt1122
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt2282
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt0100
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt1122
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt2282
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0100
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1122
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt2282
OtherIncreasesSchedule/OtherIncreasesDetail/Amt01354
OtherIncreasesSchedule/OtherIncreasesDetail/Amt1219
OtherIncreasesSchedule/OtherIncreasesDetail/Desc0FED TAX REFUND - NET
OtherIncreasesSchedule/OtherIncreasesDetail/Desc1NON-DIVIDEND DISTRIBUTION NBT BANK
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt01663
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0TRUSTEE FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt01663
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt01663
ReturnHeader/BuildTS02016-03-07 17:11:31Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0BARRY SHAY-VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum03153369220
ReturnHeader/BusinessOfficerGrp/SignatureDt02015-05-13
ReturnHeader/Filer/BusinessName/BusinessNameLine1Txt0MCGREGOR FAMILY CHARITABLE TRUST
ReturnHeader/Filer/BusinessName/BusinessNameLine2Txt0C/O NBT FINANCIAL GROUP
ReturnHeader/Filer/BusinessNameControlTxt0MCGR
ReturnHeader/Filer/EIN0207341100
ReturnHeader/Filer/PhoneNum03154757595
ReturnHeader/Filer/USAddress/AddressLine1Txt0120 MADISON ST ATTN BSHAY VP NO
ReturnHeader/Filer/USAddress/AddressLine2Txt01800
ReturnHeader/Filer/USAddress/CityNm0SYRACUSE
ReturnHeader/Filer/USAddress/StateAbbreviationCd0NY
ReturnHeader/Filer/USAddress/ZIPCd013202
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0132550103
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine1Txt0D'ARCANGELO & CO LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine1Txt0200 EAST GARDEN STREET
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/CityNm0ROME
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/StateAbbreviationCd0NY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCd0134424300
ReturnHeader/PreparerPersonGrp/PhoneNum03153369220
ReturnHeader/PreparerPersonGrp/PreparationDt02015-05-07
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0PATRICK J POWERS CPA
ReturnHeader/ReturnTs02015-05-14T09:05:56-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02014-01-01
ReturnHeader/TaxPeriodEndDt02014-12-31
ReturnHeader/TaxYr02014

Document Assets

No mirrored PDF or thumbnail assets are attached yet.

Filings

Balance SheetOperations
YearAssetsLiabilitiesNet AssetsRevenueExpensesNet Income
2024Detailed filing. Detailed filing data is available for this year.$3.25$0.00$3.25$0.21$0.28$0.07
2023Detailed filing. Detailed filing data is available for this year.$3.32$0.00$3.32$0.13$0.23$0.10
2022Detailed filing. Detailed filing data is available for this year.$3.42$0.00$3.42$0.10$0.34$0.24
2021Detailed filing. Detailed filing data is available for this year.$3.66$0.00$3.66$0.28$0.43$0.15
2020Detailed filing. Detailed filing data is available for this year.$3.82$0.00$3.82$0.14$0.44$0.30
2019Detailed filing. Detailed filing data is available for this year.$4.11$0.00$4.11$0.70$0.31$0.38
2018Detailed filing. Detailed filing data is available for this year.$3.73$0.00$3.73$0.24$0.28$0.03
2017Detailed filing. Detailed filing data is available for this year.$3.77$0.00$3.77$0.20$0.28$0.07
2016Detailed filing. Detailed filing data is available for this year.$3.84$0.00$3.84$0.25$0.28$0.03
2015Detailed filing. Detailed filing data is available for this year.$3.87$0.00$3.87$0.23$0.28$0.05
2014Detailed filing. Detailed filing data is available for this year.$3.92$0.00$3.92$0.44$0.26$0.17
2013Detailed filing. Detailed filing data is available for this year.$3.73$0.00$3.73$0.14$0.19$0.05
2012Summary only. Only limited summary data is available for this year.$3.78$0.00$0.13$0.19$0.06
2011Detailed filing. Detailed filing data is available for this year.$3.84$0.00$3.84$0.20
2010Detailed filing. Detailed filing data is available for this year.$3.77$0.00$3.77$0.11