0001140361-23-038830.txt : 20230809 0001140361-23-038830.hdr.sgml : 20230809 20230809164748 ACCESSION NUMBER: 0001140361-23-038830 CONFORMED SUBMISSION TYPE: 13F-HR PUBLIC DOCUMENT COUNT: 2 CONFORMED PERIOD OF REPORT: 20230630 FILED AS OF DATE: 20230809 DATE AS OF CHANGE: 20230809 EFFECTIVENESS DATE: 20230809 FILER: COMPANY DATA: COMPANY CONFORMED NAME: ALESCO ADVISORS LLC CENTRAL INDEX KEY: 0001269978 IRS NUMBER: 161579300 STATE OF INCORPORATION: NY FISCAL YEAR END: 1231 FILING VALUES: FORM TYPE: 13F-HR SEC ACT: 1934 Act SEC FILE NUMBER: 028-10620 FILM NUMBER: 231155941 BUSINESS ADDRESS: STREET 1: 120 OFFICE PARK WAY CITY: PITTSFORD STATE: NY ZIP: 14534 BUSINESS PHONE: 8588560970 MAIL ADDRESS: STREET 1: 120 OFFICE PARK WAY CITY: PITTSFORD STATE: NY ZIP: 14534 13F-HR 1 primary_doc.xml X0202 13F-HR LIVE 0001269978 XXXXXXXX 06-30-2023 06-30-2023 false Alesco Advisors LLC
120 Office Park Way Pittsford NY 14534
13F HOLDINGS REPORT 028-10620 N
Benton F. Kircher Chief Compliance Officer (585) 586-0970 /s/ Benton F. Kircher Pittsford NY 08-09-2023 0 164 2784139084
INFORMATION TABLE 2 informationtable.xml ABBOTT LABS COM 002824100 264195 2423 SH OTR 2423 0 0 ALLSTATE CORP COM 020002101 479994 4402 SH OTR 4402 0 0 ALPHABET INC CAP STK CL A 02079K305 465394 3888 SH OTR 3888 0 0 ALPHABET INC CAP STK CL C 02079K107 297102 2456 SH OTR 2456 0 0 AMAZON COM INC COM 023135106 643718 4938 SH OTR 4938 0 0 APPLE INC COM 037833100 4206260 21685 SH OTR 20658 0 1027 AUTOMATIC DATA PROCESSING IN COM 053015103 284628 1295 SH OTR 1295 0 0 BERKSHIRE HATHAWAY INC DEL CL B NEW 084670702 2697992 7912 SH OTR 7912 0 0 BOEING CO COM 097023105 275564 1305 SH OTR 1305 0 0 BROADSTONE NET LEASE INC COM 11135E203 3550490 229954 SH OTR 229954 0 0 CATERPILLAR INC COM 149123101 258353 1050 SH OTR 1050 0 0 CHEMUNG FINL CORP COM 164024101 507550 13214 SH OTR 13214 0 0 CONSTELLATION BRANDS INC CL A 21036P108 397674 1616 SH OTR 1616 0 0 DEERE & CO COM 244199105 289306 714 SH OTR 714 0 0 DIMENSIONAL ETF TRUST INTERNATNAL VAL 25434V807 521001 15860 SH SOLE 15860 0 0 DIMENSIONAL ETF TRUST INTL SMALL CAP E 25434V773 2091932 91671 SH SOLE 87671 0 4000 DIMENSIONAL ETF TRUST EMERGING MKTS VA 25434V740 2817684 115621 SH SOLE 109994 0 5627 DISNEY WALT CO COM 254687106 296671 3323 SH OTR 3323 0 0 EXXON MOBIL CORP COM 30231G102 1538394 14344 SH OTR 14344 0 0 GLOBAL X FDS S&P 500 CATHOLIC 37954Y889 1150753 21138 SH SOLE 21138 0 0 GLOBAL X FDS S&P EX US ETF 37954Y368 351954 12320 SH SOLE 12320 0 0 HOME DEPOT INC COM 437076102 277402 893 SH OTR 893 0 0 INTEL CORP COM 458140100 250803 7500 SH OTR 7500 0 0 INVESCO EXCHANGE TRADED FD T S&P500 PUR VAL 46137V258 596747 7695 SH SOLE 7695 0 0 ISHARES GOLD TR ISHARES NEW 464285204 991336 27242 SH SOLE 27242 0 0 ISHARES INC ESG AWR MSCI EM 46434G863 5288409 167196 SH SOLE 163986 0 3210 ISHARES INC MSCI GBL MIN VOL 464286525 1023792 10441 SH SOLE 10441 0 0 ISHARES INC CORE MSCI EMKT 46434G103 137871625 2797152 SH SOLE 2721608 0 75544 ISHARES TR CORE MSCI EAFE 46432F842 297869343 4412879 SH SOLE 4280558 0 132321 ISHARES TR US TREAS BD ETF 46429B267 58926125 2573193 SH SOLE 2523882 0 49311 ISHARES TR 0-5YR HI YL CP 46434V407 2429177 58605 SH SOLE 58605 0 0 ISHARES TR ESG AW MSCI EAFE 46435G516 9768171 133939 SH SOLE 130924 0 3015 ISHARES TR CORE MSCI INTL 46435G326 495378 8105 SH SOLE 8105 0 0 ISHARES TR ESG AWR MSCI USA 46435G425 35581866 365092 SH SOLE 357922 0 7170 ISHARES TR ESG AWRE 1 5 YR 46435G243 7885518 329800 SH SOLE 329800 0 0 ISHARES TR IBONDS DEC23 ETF 46434VAX8 748837 29610 SH SOLE 29610 0 0 ISHARES TR IBONDS DEC24 ETF 46434VBG4 531546 21590 SH SOLE 21590 0 0 ISHARES TR MSCI INTL MOMENT 46434V449 209990 6325 SH SOLE 6325 0 0 ISHARES TR MSCI INTL QUALTY 46434V456 420080 11800 SH SOLE 11800 0 0 ISHARES TR 0-5 YR TIPS ETF 46429B747 9468777 97016 SH SOLE 95114 0 1902 ISHARES TR FLTG RATE NT ETF 46429B655 1143196 22495 SH SOLE 22495 0 0 ISHARES TR MSCI EAFE MIN VL 46429B689 266625 3950 SH SOLE 3950 0 0 ISHARES TR SHORT TREAS BD 464288679 1293370 11710 SH SOLE 11710 0 0 ISHARES TR USD INV GRDE ETF 464288620 262472 5240 SH SOLE 5240 0 0 ISHARES TR ISHS 1-5YR INVS 464288646 2484168 49515 SH SOLE 49515 0 0 ISHARES TR EAFE VALUE ETF 464288877 70373748 1437960 SH SOLE 1395985 0 41975 ISHARES TR MICRO-CAP ETF 464288869 19301781 176595 SH SOLE 168449 0 8146 ISHARES TR MBS ETF 464288588 713011 7645 SH SOLE 7645 0 0 ISHARES TR 3 7 YR TREAS BD 464288661 650758 5646 SH SOLE 5646 0 0 ISHARES TR NATIONAL MUN ETF 464288414 13120212 122929 SH SOLE 121755 0 1174 ISHARES TR JPMORGAN USD EMG 464288281 673281 7780 SH SOLE 7780 0 0 ISHARES TR EAFE SML CP ETF 464288273 11369809 192774 SH SOLE 180249 0 12525 ISHARES TR NEW YORK MUN ETF 464288323 15656682 293967 SH SOLE 276267 0 17700 ISHARES TR SHRT NAT MUN ETF 464288158 13385473 128657 SH SOLE 127192 0 1465 ISHARES TR CORE US AGGBD ET 464287226 3220830 32882 SH SOLE 30087 0 2796 ISHARES TR TIPS BD ETF 464287176 2700960 25097 SH SOLE 23583 0 1514 ISHARES TR 1 3 YR TREAS BD 464287457 998095 12310 SH SOLE 12310 0 0 ISHARES TR 20 YR TR BD ETF 464287432 2229680 21660 SH SOLE 21660 0 0 ISHARES TR IBOXX INV CP ETF 464287242 573142 5300 SH SOLE 5300 0 0 ISHARES TR MSCI EAFE ETF 464287465 3630075 50070 SH SOLE 49365 0 705 ISHARES TR RUS 2000 GRW ETF 464287648 727980 3000 SH SOLE 3000 0 0 ISHARES TR RUS MID CAP ETF 464287499 457168 6260 SH SOLE 6260 0 0 ISHARES TR RUS MD CP GR ETF 464287481 1381809 14300 SH SOLE 14300 0 0 ISHARES TR RUS MDCP VAL ETF 464287473 553594 5040 SH SOLE 5040 0 0 ISHARES TR GLOBAL 100 ETF 464287572 769347 10115 SH SOLE 10115 0 0 ISHARES TR CORE S&P MCP ETF 464287507 253021529 967652 SH SOLE 936893 0 30758 ISHARES TR S&P MC 400VL ETF 464287705 25027784 233621 SH SOLE 225474 0 8147 ISHARES TR S&P MC 400GR ETF 464287606 1676400 22352 SH SOLE 22352 0 0 ISHARES TR CORE S&P SCP ETF 464287804 246293826 2471589 SH SOLE 2399269 0 72320 ISHARES TR SP SMCP600VL ETF 464287879 1288909 13555 SH SOLE 13555 0 0 ISHARES TR S&P SML 600 GWT 464287887 1265954 11015 SH SOLE 11015 0 0 ISHARES TR S&P 500 VAL ETF 464287408 18453151 114481 SH SOLE 104840 0 9641 ISHARES TR CORE S&P500 ETF 464287200 640514608 1437066 SH SOLE 1395788 0 41278 ISHARES TR S&P 500 GRWT ETF 464287309 1601447 22722 SH SOLE 22722 0 0 ISHARES TR RUS 1000 ETF 464287622 271770 1115 SH SOLE 1115 0 0 ISHARES TR RUS 1000 GRW ETF 464287614 5135960 18664 SH SOLE 18664 0 0 ISHARES TR RUSSELL 2000 ETF 464287655 1532805 8185 SH SOLE 8185 0 0 ISHARES TR RUS 2000 VAL ETF 464287630 471680 3350 SH SOLE 3350 0 0 ISHARES TR RUSSELL 3000 ETF 464287689 2416183 9495 SH SOLE 9495 0 0 ISHARES TR CORE S&P US GWT 464287671 234336 2400 SH SOLE 2400 0 0 ISHARES TR ESG SCRD S&P MID 46436E551 202146 5675 SH SOLE 5675 0 0 ISHARES TR ESG AWARE MSCI 46435U663 6713777 189014 SH SOLE 185504 0 3510 ISHARES TR ESG AWR US AGRGT 46435U549 27896904 591412 SH SOLE 567127 0 24285 ISHARES TR 0-3 MNTH TREASRY 46436E718 1703666 16930 SH SOLE 16930 0 0 ISHARES TR ESG MSCI USA ETF 46436E767 264233 7350 SH SOLE 7350 0 0 J P MORGAN EXCHANGE TRADED F US VALUE FACTR 46641Q753 320585 8985 SH SOLE 8985 0 0 JOHNSON & JOHNSON COM 478160104 905063 5468 SH OTR 5468 0 0 JPMORGAN CHASE & CO COM 46625H100 1135887 7810 SH OTR 7810 0 0 LOWES COS INC COM 548661107 1403854 6220 SH OTR 6220 0 0 MCDONALDS CORP COM 580135101 342873 1149 SH OTR 1149 0 0 MERCK & CO INC COM 58933Y105 203325 1762 SH OTR 1762 0 0 MICROCHIP TECHNOLOGY INC. COM 595017104 433129 4835 SH OTR 4835 0 0 MICROSOFT CORP COM 594918104 3659688 10747 SH OTR 10747 0 0 ORACLE CORP COM 68389X105 664403 5579 SH OTR 5579 0 0 PAYCHEX INC COM 704326107 8645355 77280 SH OTR 77280 0 0 PEPSICO INC COM 713448108 541769 2925 SH OTR 2925 0 0 PFIZER INC COM 717081103 206038 5617 SH OTR 5617 0 0 PIMCO ETF TR 1-5 US TIP IDX 72201R205 827988 16461 SH SOLE 16460 0 1 PROCTER AND GAMBLE CO COM 742718109 407270 2684 SH OTR 2684 0 0 SCHWAB STRATEGIC TR INTL EQTY ETF 808524805 1271457 35665 SH SOLE 35665 0 0 SCHWAB STRATEGIC TR US LRG CAP ETF 808524201 3245485 61972 SH SOLE 56900 0 5072 SCHWAB STRATEGIC TR US SML CAP ETF 808524607 326529 7455 SH SOLE 5757 0 1698 SCHWAB STRATEGIC TR US LCAP VA ETF 808524409 1212968 18080 SH SOLE 17700 0 380 SCHWAB STRATEGIC TR SCHWB FDT INT LG 808524755 4829454 149565 SH SOLE 131235 0 18330 SCHWAB STRATEGIC TR US AGGREGATE B 808524839 1801440 39026 SH SOLE 39026 0 0 SCHWAB STRATEGIC TR US REIT ETF 808524847 1081669 55385 SH SOLE 24485 0 30900 SCHWAB STRATEGIC TR US MID-CAP ETF 808524508 865714 12188 SH SOLE 11688 0 500 SCHWAB STRATEGIC TR INTL SCEQT ETF 808524888 321367 9516 SH SOLE 9516 0 0 SCHWAB STRATEGIC TR EMRG MKTEQ ETF 808524706 454328 18446 SH SOLE 18446 0 0 SCHWAB STRATEGIC TR SHT TM US TRES 808524862 11295358 235026 SH SOLE 234401 0 625 SCHWAB STRATEGIC TR INT-TRM U.S TRES 808524854 708154 14370 SH SOLE 14370 0 0 SCHWAB STRATEGIC TR US TIPS ETF 808524870 122512636 2336690 SH SOLE 2299322 0 37367 SELECT SECTOR SPDR TR TECHNOLOGY 81369Y803 413613 2379 SH SOLE 2379 0 0 SHERWIN WILLIAMS CO COM 824348106 318624 1200 SH OTR 1200 0 0 SPDR DOW JONES INDL AVERAGE UT SER 1 78467X109 307746 895 SH SOLE 895 0 0 SPDR GOLD TR GOLD SHS 78463V107 389520 2185 SH SOLE 2185 0 0 SPDR INDEX SHS FDS S&P EMKTSC ETF 78463X756 1002941 19100 SH SOLE 19100 0 0 SPDR INDEX SHS FDS S&P INTL SMLCP 78463X871 1036028 33957 SH SOLE 33457 0 500 SPDR S&P 500 ETF TR TR UNIT 78462F103 108158762 243996 SH SOLE 242291 0 1705 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 789244 1648 SH SOLE 1648 0 0 SPDR SER TR PRTFLO S&P500 VL 78464A508 120677312 2793456 SH SOLE 2720257 0 73200 SPDR SER TR NUVEEN BLMBRG MU 78468R721 915630 19836 SH SOLE 15515 0 4321 SPDR SER TR S&P 400 MDCP VAL 78464A839 47521260 690917 SH SOLE 672620 0 18297 SPDR SER TR BLOOMBERG 1-3 MO 78468R663 285560 3110 SH SOLE 3110 0 0 SPDR SER TR PORTFOLIO SHORT 78464A474 227866 7740 SH SOLE 7740 0 0 SPDR SER TR PORT MTG BK ETF 78464A383 1874401 85550 SH SOLE 85550 0 0 SPDR SER TR PORTFOLIO S&P500 78464A854 1924422 36930 SH SOLE 24665 0 12265 SPDR SER TR BLOOMBERG 1 10 Y 78468R861 11175254 605377 SH SOLE 552264 0 53113 SPDR SER TR BLOOMBERG INVT 78468R200 7901754 257470 SH SOLE 257470 0 0 SPDR SER TR BLOOMBERG 3-12 M 78468R523 390878 3930 SH SOLE 3930 0 0 SPDR SER TR SPDR S&P 500 ETF 78468R796 990696 27390 SH SOLE 27390 0 0 THE CIGNA GROUP COM 125523100 204557 729 SH OTR 729 0 0 THERMO FISHER SCIENTIFIC INC COM 883556102 243136 466 SH OTR 466 0 0 TOMPKINS FINL CORP COM 890110109 211437 3796 SH OTR 3796 0 0 TRANE TECHNOLOGIES PLC SHS G8994E103 329924 1725 SH OTR 1725 0 0 UNITEDHEALTH GROUP INC COM 91324P102 235514 490 SH OTR 490 0 0 VANECK ETF TRUST INTRMDT MUNI ETF 92189H201 720996 15650 SH SOLE 15650 0 0 VANGUARD BD INDEX FDS SHORT TRM BOND 921937827 3028090 40070 SH SOLE 40070 0 0 VANGUARD BD INDEX FDS INTERMED TERM 921937819 919311 12220 SH SOLE 12220 0 0 VANGUARD BD INDEX FDS TOTAL BND MRKT 921937835 101068765 1390408 SH SOLE 1349102 0 41306 VANGUARD INDEX FDS LARGE CAP ETF 922908637 11221693 55356 SH SOLE 55356 0 0 VANGUARD INDEX FDS MCAP VL IDXVIP 922908512 8667124 62633 SH SOLE 58881 0 3751 VANGUARD INDEX FDS S&P 500 ETF SHS 922908363 770877 1893 SH SOLE 1760 0 133 VANGUARD INDEX FDS TOTAL STK MKT 922908769 605550 2749 SH SOLE 2749 0 0 VANGUARD INDEX FDS VALUE ETF 922908744 794055 5588 SH SOLE 5588 0 0 VANGUARD INDEX FDS MID CAP ETF 922908629 3939608 17894 SH SOLE 17894 0 0 VANGUARD INDEX FDS SM CP VAL ETF 922908611 1069311 6465 SH SOLE 6465 0 0 VANGUARD INDEX FDS REAL ESTATE ETF 922908553 306999 3674 SH SOLE 3674 0 0 VANGUARD INDEX FDS SMALL CP ETF 922908751 2738166 13767 SH SOLE 12367 0 1400 VANGUARD INTL EQUITY INDEX F FTSE EMR MKT ETF 922042858 24984909 614182 SH SOLE 577629 0 36553 VANGUARD INTL EQUITY INDEX F GLB EX US ETF 922042676 380760 9474 SH SOLE 4509 0 4965 VANGUARD INTL EQUITY INDEX F TT WRLD ST ETF 922042742 213356 2200 SH SOLE 2200 0 0 VANGUARD MALVERN FDS STRM INFPROIDX 922020805 82140302 1732187 SH SOLE 1697496 0 34691 VANGUARD MUN BD FDS TAX EXEMPT BD 922907746 4149779 82632 SH SOLE 82632 0 0 VANGUARD SCOTTSDALE FDS VNG RUS1000IDX 92206C730 4102754 20355 SH SOLE 20355 0 0 VANGUARD SCOTTSDALE FDS VNG RUS1000GRW 92206C680 658068 9300 SH SOLE 9300 0 0 VANGUARD SCOTTSDALE FDS SHORT TERM TREAS 92206C102 665050 11520 SH SOLE 11520 0 0 VANGUARD SCOTTSDALE FDS INT-TERM CORP 92206C870 1220223 15440 SH SOLE 15440 0 0 VANGUARD SCOTTSDALE FDS SHRT TRM CORP BD 92206C409 5096239 67357 SH SOLE 63247 0 4110 VANGUARD TAX-MANAGED FDS VAN FTSE DEV MKT 921943858 46401877 1004805 SH SOLE 951435 0 53370 VANGUARD WHITEHALL FDS HIGH DIV YLD 921946406 1027288 9685 SH SOLE 9685 0 0 VISA INC COM CL A 92826C839 478047 2013 SH OTR 2013 0 0 WISDOMTREE TR FLOATNG RAT TREA 97717Y527 646612 12850 SH SOLE 12850 0 0 XYLEM INC COM 98419M100 1027545 9124 SH OTR 9124 0 0