Civic Intelligence

Mcgregor Family Charitable Trust C/O Nbt Financial Group

990PF • Fiscal year 2013 • EIN 20-7341100

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

120 Madison St Attn Bshay Vp No180013202

(315) 475-7595

Siviq Scores

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

Liabilities / Assets

88th percentile

0.00x

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

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

Liabilities / Revenue

88th percentile

0.00x

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

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

Net Margin

33rd percentile

-36%

Higher net margin than 33% of similar nonprofits.

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

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.

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

Asset Growth

47th percentile

-1.3%

Faster asset growth than 47% of similar nonprofits.

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

Revenue Growth

58th percentile

9.2%

Faster revenue growth than 58% of similar nonprofits.

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

Assets

Down

$372,633

Down $5,047 (-1.3%) from 2012

Net Assets

$372,633

No earlier filing loaded for comparison.

Liabilities

Down

$0

Down $1 (-100%) from 2012

Revenue

Up

$13,846

Up $1,163 (+9.2%) from 2012

Expenses

Down

$18,893

Down $225 (-1.2%) from 2012

Net Income

Up

-$5,047

Up $1,388 (+22%) from 2012

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

2013

Assets$372,633
Liabilities$0
Net Assets$372,633

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

2013

Revenue$13,846
Expenses$18,893
Net Income-$5,047
Jump To
Filing Snapshot
Filing Period
Jan 1, 2013 to Dec 31, 2013
Signed
May 13, 2014
Return Version
2013v3.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

EIN
20-7341100
Phone
3154757595

Signing Officer

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

Preparer

Preparer
Patrick J Powers CPA
Phone
3153369220
Raw XML Appendix353 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
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYBookValueAmt0364922
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/EOYFMVAmt0435437
InvestmentsCorpStockSchedule/InvestmentsCorporateStockGrp/StockNm0NBT BANK INVESTMENTS NON-GOVERNMENT SECURITIES
IRS990PF/AddressChangeInd0X
IRS990PF/AnalysisIncomeProducingActyGrp/DivAndIntFromSecPartVIIGrp/RelatedOrExemptFunctionIncmAmt09840
IRS990PF/AnalysisIncomeProducingActyGrp/GainSalesAstOthThanInvntryGrp/RelatedOrExemptFunctionIncmAmt04006
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/ExclusionAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/RelatedOrExemptFunctionIncmAmt013846
IRS990PF/AnalysisIncomeProducingActyGrp/SubtotalsIncmProducingActyGrp/UnrelatedBusinessTaxblIncmAmt00
IRS990PF/AnalysisIncomeProducingActyGrp/TotalIncomeProducingActyAmt013846
IRS990PF/AnalysisOfRevenueAndExpenses/CapGainNetIncmNetInvstIncmAmt04006
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstDsbrsChrtblAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstNetInvstIncmAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/CompOfcrDirTrstRevAndExpnssAmt00
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidDsbrsChrtblAmt017293
IRS990PF/AnalysisOfRevenueAndExpenses/ContriPaidRevAndExpnssAmt017293
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsNetInvstIncmAmt09840
IRS990PF/AnalysisOfRevenueAndExpenses/DividendsRevAndExpnssAmt09840
IRS990PF/AnalysisOfRevenueAndExpenses/ExcessRevenueOverExpensesAmt0-5047
IRS990PF/AnalysisOfRevenueAndExpenses/GrossSalesPriceAmt0109367
IRS990PF/AnalysisOfRevenueAndExpenses/NetGainSaleAstRevAndExpnssAmt04006
IRS990PF/AnalysisOfRevenueAndExpenses/NetInvestmentIncomeAmt012246
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesDsbrsChrtblAmt0376
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesNetInvstIncmAmt0376
IRS990PF/AnalysisOfRevenueAndExpenses/OtherExpensesRevAndExpnssAmt0376
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesDsbrsChrtblAmt01224
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesNetInvstIncmAmt01224
IRS990PF/AnalysisOfRevenueAndExpenses/OtherProfFeesRevAndExpnssAmt01224
IRS990PF/AnalysisOfRevenueAndExpenses/ScheduleBNotRequiredInd0X
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesDsbrsChrtblAmt018893
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesNetInvstIncmAmt01600
IRS990PF/AnalysisOfRevenueAndExpenses/TotalExpensesRevAndExpnssAmt018893
IRS990PF/AnalysisOfRevenueAndExpenses/TotalNetInvstIncmAmt013846
IRS990PF/AnalysisOfRevenueAndExpenses/TotalRevAndExpnssAmt013846
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesDsbrsChrtblAmt01600
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesNetInvstIncmAmt01600
IRS990PF/AnalysisOfRevenueAndExpenses/TotOprExpensesRevAndExpnssAmt01600
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt029871
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/CostOrOtherBasisAmt175490
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt0320
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt157
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainOrLossAmt23629
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt0320
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt157
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GainsMinusExcessOrLossesAmt23629
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt030191
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt175547
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/GrossSalesPriceAmt23629
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd0P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd1P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/HowAcquiredCd2P
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc0NBT BANK A/C 15069611 S/T SALES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc1NBT BANK A/C 15069611 L/T SALES
IRS990PF/CapGainsLossTxInvstIncmDetail/CapGainsLossTxInvstIncmGrp/PropertyDesc2CAPITAL GAINS DIVIDENDS
IRS990PF/CapGainsLossTxInvstIncmDetail/CapitalGainNetIncomeAmt04006
IRS990PF/ChgInNetAssetsFundBalancesGrp/ExcessRevenueOverExpensesAmt0-5047
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherDecreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/OtherIncreasesAmt00
IRS990PF/ChgInNetAssetsFundBalancesGrp/SubtotalAmt0372633
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesBOYAmt0377680
IRS990PF/ChgInNetAssetsFundBalancesGrp/TotNetAstOrFundBalancesEOYAmt0372633
IRS990PF/DistributableAmountGrp/DeductionFromDistributableAmt00
IRS990PF/DistributableAmountGrp/DistributableAsAdjustedAmt020727
IRS990PF/DistributableAmountGrp/DistributableBeforeAdjAmt020727
IRS990PF/DistributableAmountGrp/DistributableBeforeDedAmt020727
IRS990PF/DistributableAmountGrp/MinimumInvestmentReturnAmt020849
IRS990PF/DistributableAmountGrp/RecoveriesQualfiedDistriAmt00
IRS990PF/DistributableAmountGrp/TaxBasedOnInvestmentIncomeAmt0122
IRS990PF/DistributableAmountGrp/TotalTaxAmt0122
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/DomesticOrgMeetingSect4940eInd0X
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/InvestmentIncomeExciseTaxAmt0122
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtitleATaxAmt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/SubtotalAmt0122
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxBasedOnInvestmentIncomeAmt0122
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxDueAmt0122
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TaxUnderSection511Amt00
IRS990PF/ExciseTaxBasedOnInvstIncmGrp/TotalPaymentsAndCreditsAmt00
IRS990PF/FMVAssetsEOYAmt0443148
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/AdditionalPaidInCapitalEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CapitalStockEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/CashBOYAmt05
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockBOYAmt0375466
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYAmt0364922
IRS990PF/Form990PFBalanceSheetsGrp/CorporateStockEOYFMVAmt0435437
IRS990PF/Form990PFBalanceSheetsGrp/OrgDoesNotFollowSFAS117Ind0X
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningBOYAmt0377680
IRS990PF/Form990PFBalanceSheetsGrp/RetainedEarningEOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstBOYAmt02209
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYAmt07711
IRS990PF/Form990PFBalanceSheetsGrp/SavAndTempCashInvstEOYFMVAmt07711
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsBOYAmt0377680
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/TotalAssetsEOYFMVAmt0443148
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesBOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesEOYAmt00
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstBOYAmt0377680
IRS990PF/Form990PFBalanceSheetsGrp/TotalLiabilitiesNetAstEOYAmt0372633
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesBOYAmt0377680
IRS990PF/Form990PFBalanceSheetsGrp/TotNetAstOrFundBalancesEOYAmt0372633
IRS990PF/MethodOfAccountingCashInd0X
IRS990PF/MinimumInvestmentReturnGrp/AcquisitionIndebtednessAmt00
IRS990PF/MinimumInvestmentReturnGrp/AdjustedTotalFMVOfUnusedAstAmt0423333
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyCashBalancesAmt05108
IRS990PF/MinimumInvestmentReturnGrp/AverageMonthlyFMVOfSecAmt0418225
IRS990PF/MinimumInvestmentReturnGrp/CashDeemedCharitableAmt06350
IRS990PF/MinimumInvestmentReturnGrp/FMVAllOtherNoncharitableAstAmt00
IRS990PF/MinimumInvestmentReturnGrp/MinimumInvestmentReturnAmt020849
IRS990PF/MinimumInvestmentReturnGrp/NetVlNoncharitableAssetsAmt0416983
IRS990PF/MinimumInvestmentReturnGrp/ReductionClaimedAmt00
IRS990PF/MinimumInvestmentReturnGrp/TotalFMVOfUnusedAssetsAmt0423333
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/AddressLine10120 MADISON ST SUITE 1800 ATTN
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine11911 MACEWIN DRIVE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine12PO BOX 4300
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/AddressLine20BSHAY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City0SYRACUSE
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City1OSPREY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/City2ROME
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State0NY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State1FL
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/State2NY
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode013202
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode134229
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OfficerDirTrstKeyEmplGrp/USAddress/ZIPCode213440
IRS990PF/OfficerDirTrstKeyEmplInfoGrp/OtherEmployeePaidOver50kCnt00
IRS990PF/Organization501c3ExemptPFInd0X
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNetVlNoncharitableAssetsAmt016378
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjNonchrtblNetInvstIncmPctAmt016500
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr1Amt019009
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr2Amt019827
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr3Amt010610
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr4Amt05928
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AdjustedQlfyDistriYr5Amt019752
IRS990PF/QlfyUndSect4940eReducedTaxGrp/AverageDistributionRt00.039277
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr1Rt00.048350
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr2Rt00.049397
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr3Rt00.028759
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr4Rt00.018232
IRS990PF/QlfyUndSect4940eReducedTaxGrp/DistributionYr5Rt00.051647
IRS990PF/QlfyUndSect4940eReducedTaxGrp/LiableSection4942TaxInd00
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetInvestmentIncomePctAmt0122
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsAmt0416983
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr1Amt0393157
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr2Amt0401384
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr3Amt0368924
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr4Amt0325151
IRS990PF/QlfyUndSect4940eReducedTaxGrp/NetVlNoncharitableAssetsYr5Amt0382440
IRS990PF/QlfyUndSect4940eReducedTaxGrp/QualifyingDistributionsAmt018893
IRS990PF/QlfyUndSect4940eReducedTaxGrp/TotalDistributionRt00.196385
IRS990PF/QualifyingDistriPartXIIGrp/AdjustedQualifyingDistriAmt018771
IRS990PF/QualifyingDistriPartXIIGrp/ExpensesAndContributionsAmt018893
IRS990PF/QualifyingDistriPartXIIGrp/PctSect4940eOrgNetInvstIncmAmt0122
IRS990PF/QualifyingDistriPartXIIGrp/ProgramRelatedInvstTotalAmt00
IRS990PF/QualifyingDistriPartXIIGrp/QualifyingDistributionsAmt018893
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/RcvFndsToPayPrsnlBnftCntrctInd00
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/ComplyWithPublicInspRqrInd00
IRS990PF/StatementsRegardingActyGrp/DonorAdvisedFundInd00
IRS990PF/StatementsRegardingActyGrp/ForeignAccountsQuestionInd00
IRS990PF/StatementsRegardingActyGrp/Form1120POLFiledInd00
IRS990PF/StatementsRegardingActyGrp/Form990PFFiledWithAttyGenInd01
IRS990PF/StatementsRegardingActyGrp/IndividualWithBooksNm0NBT FINANCIAL GROUP
IRS990PF/StatementsRegardingActyGrp/LegislativePoliticalActyInd00
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine10120 MADISON ST SUITE 1800 ATTN B
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/AddressLine20SHAY VP
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/City0SYRACUSE
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/State0NY
IRS990PF/StatementsRegardingActyGrp/LocationOfBooksUSAddress/ZIPCode013202
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/Amt04324
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt14323
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt21729
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt34323
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/Amt42594
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt0GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt1GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt2GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt3GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/GrantOrContributionPurposeTxt4GRANT
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine10COMMUNITY MEMORIAL HOSPITAL OF HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine11HAMILTON CENTRAL SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine12POOLVILLE UNITED METHODIST CHURCH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine13SHERBURNE-EARLVILLE CENTRAL SCHOOL
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientBusinessName/BusinessNameLine14SOUTHERN 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/AddressLine10150 BROAD STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1147 WEST KENDRICK STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine12PO BOX 249
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine1315 THOMAS STREET
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/AddressLine14PO BOX 453
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City0HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City1HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City2NORTH NORWICH
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City3SHERBURNE
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/City4HAMILTON
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State0NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State1NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State2NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State3NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/State4NY
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode013346
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode113346
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode213346
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode313460
IRS990PF/SupplementaryInformationGrp/GrantOrContributionPdDurYrGrp/RecipientUSAddress/ZIPCode413346
IRS990PF/SupplementaryInformationGrp/OnlyContriToPreselectedInd0X
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriApprvFutAmt00
IRS990PF/SupplementaryInformationGrp/TotalGrantOrContriPdDurYrAmt017293
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/AppliedToCurrentYearAmt02467
IRS990PF/UndistributedIncomeGrp/AppliedToPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/AppliedToYear1Amt016426
IRS990PF/UndistributedIncomeGrp/CorpusDistri170b1EOr4942g3Amt00
IRS990PF/UndistributedIncomeGrp/DistributableAsAdjustedAmt020727
IRS990PF/UndistributedIncomeGrp/ExcessDistributionCyovAppCYAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovAppCYCorpusAmt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovFromYr5Amt00
IRS990PF/UndistributedIncomeGrp/ExcessDistriCyovToNextYrAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearDeficiencyOrTaxAmt00
IRS990PF/UndistributedIncomeGrp/PriorYearUndistributedIncmAmt00
IRS990PF/UndistributedIncomeGrp/QualifyingDistributionsAmt018893
IRS990PF/UndistributedIncomeGrp/RemainingDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/Taxable1Amt00
IRS990PF/UndistributedIncomeGrp/Taxable2Amt00
IRS990PF/UndistributedIncomeGrp/TotalCorpusAmt00
IRS990PF/UndistributedIncomeGrp/TotalExcessDistributionCyovAmt00
IRS990PF/UndistributedIncomeGrp/TotalForPriorYearsAmt00
IRS990PF/UndistributedIncomeGrp/TreatedAsDistriFromCorpusAmt00
IRS990PF/UndistributedIncomeGrp/UndistributedIncomeCYAmt018260
IRS990PF/UndistributedIncomeGrp/UndistributedIncomePYAmt016426
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc0NYS FILING FEE
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc1US TREASURY
OtherExpensesSchedule/OtherExpensesScheduleGrp/Desc2FOREIGN TAX PAID ON DIVIDENDS
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt0100
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt1111
OtherExpensesSchedule/OtherExpensesScheduleGrp/DisbursementsCharitablePrpsAmt2165
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt0100
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt1111
OtherExpensesSchedule/OtherExpensesScheduleGrp/NetInvestmentIncomeAmt2165
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt0100
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt1111
OtherExpensesSchedule/OtherExpensesScheduleGrp/RevenueAndExpensesPerBooksAmt2165
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/Amt01224
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/CategoryTxt0TRUSTEE FEES
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/DisbursementsCharitablePrpsAmt01224
OtherProfessionalFeesSchedule/OtherProfessionalFeesDetail/NetInvestmentIncomeAmt01224
ReturnHeader/BuildTS02015-12-30 17:16:21Z
ReturnHeader/BusinessOfficerGrp/DiscussWithPaidPreparerInd01
ReturnHeader/BusinessOfficerGrp/PersonNm0BARRY SHAY-VICE PRESIDENT
ReturnHeader/BusinessOfficerGrp/PersonTitleTxt0TRUSTEE
ReturnHeader/BusinessOfficerGrp/PhoneNum03153369220
ReturnHeader/BusinessOfficerGrp/SignatureDt02014-05-13
ReturnHeader/Filer/BusinessName/BusinessNameLine10MCGREGOR FAMILY CHARITABLE TRUST
ReturnHeader/Filer/BusinessName/BusinessNameLine20C/O NBT FINANCIAL GROUP
ReturnHeader/Filer/BusinessNameControlTxt0MCGR
ReturnHeader/Filer/EIN0207341100
ReturnHeader/Filer/PhoneNum03154757595
ReturnHeader/Filer/USAddress/AddressLine10120 MADISON ST ATTN BSHAY VP NO
ReturnHeader/Filer/USAddress/AddressLine201800
ReturnHeader/Filer/USAddress/City0SYRACUE
ReturnHeader/Filer/USAddress/State0NY
ReturnHeader/Filer/USAddress/ZIPCode013202
ReturnHeader/PreparerFirmGrp/PreparerFirmEIN0132550103
ReturnHeader/PreparerFirmGrp/PreparerFirmName/BusinessNameLine10D'ARCANGELO & CO LLP
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/AddressLine10200 EAST GARDEN STREET
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/City0ROME
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/State0NY
ReturnHeader/PreparerFirmGrp/PreparerUSAddress/ZIPCode0134424300
ReturnHeader/PreparerPersonGrp/PhoneNum03153369220
ReturnHeader/PreparerPersonGrp/PreparationDt02014-05-13
ReturnHeader/PreparerPersonGrp/PreparerPersonNm0PATRICK J POWERS CPA
ReturnHeader/ReturnTs02014-05-13T15:21:41-05:00
ReturnHeader/ReturnTypeCd0990PF
ReturnHeader/TaxPeriodBeginDt02013-01-01
ReturnHeader/TaxPeriodEndDt02013-12-31
ReturnHeader/TaxYr02013

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