0001567619-20-015188.txt : 20200814 0001567619-20-015188.hdr.sgml : 20200814 20200814091813 ACCESSION NUMBER: 0001567619-20-015188 CONFORMED SUBMISSION TYPE: 13F-HR PUBLIC DOCUMENT COUNT: 2 CONFORMED PERIOD OF REPORT: 20200630 FILED AS OF DATE: 20200814 DATE AS OF CHANGE: 20200814 EFFECTIVENESS DATE: 20200814 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: 201101768 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 13F-HR LIVE false true false 0001269978 XXXXXXXX 06-30-2020 06-30-2020 ALESCO ADVISORS LLC

120 OFFICE PARK WAY PITTSFORD NY 14534

13F HOLDINGS REPORT 028-10620 N Jeffrey D. Bradley (585) 586-0970 /s/ Jeffrey D. Bradley Pittsford NY 08-14-2020 0 121 2061081 false INFORMATION TABLE 2 form13fInfoTable.xml ABBOTT LABS COM 002824100 317 3467 SH OTR 3467 0 0 ALLSTATE CORP COM 020002101 475 4902 SH OTR 4902 0 0 AMAZON COM INC COM 023135106 406 147 SH OTR 147 0 0 APPLE INC COM 037833100 1823 4997 SH OTR 4741 0 257 AUTOMATIC DATA PROCESSING IN COM 053015103 204 1372 SH OTR 1372 0 0 BERKSHIRE HATHAWAY INC DEL CL A 084670108 267 1 SH OTR 1 0 0 BERKSHIRE HATHAWAY INC DEL CL B NEW 084670702 932 5219 SH OTR 5219 0 0 BOEING CO COM 097023105 505 2754 SH OTR 2754 0 0 CONSTELLATION BRANDS INC CL A 21036p108 275 1571 SH OTR 1571 0 0 DISNEY WALT CO COM DISNEY 254687106 237 2124 SH OTR 2124 0 0 EXXON MOBIL CORP COM 30231g102 651 14565 SH OTR 14565 0 0 INTEL CORP COM 458140100 387 6473 SH OTR 6473 0 0 INVESCO ACTIVLY MANGD ETC FD OPTIMUM YIELD 46090F100 386 29817 SH SOLE 27767 0 2050 INVESCO EXCHANGE TRADED FD T S&P500 PUR VAL 46137V258 357 7485 SH SOLE 7485 0 0 ISHARES GOLD TRUST ISHARES 464285105 297 17500 SH SOLE 17500 0 0 ISHARES TR TIPS BD ETF 464287176 17895 145488 SH SOLE 135982 0 9506 ISHARES TR CORE S&P500 ETF 464287200 494594 1597062 SH SOLE 1521817 0 75245 ISHARES TR CORE US AGGBD ET 464287226 23361 197622 SH SOLE 193132 0 4490 ISHARES TR IBOXX INV CP ETF 464287242 790 5875 SH SOLE 5875 0 0 ISHARES TR S&P 500 GRWT ETF 464287309 1358 6547 SH SOLE 6547 0 0 ISHARES TR S&P 500 VAL ETF 464287408 15737 145429 SH SOLE 130458 0 14972 ISHARES TR BARCLAYS 7 10 YR 464287440 463 3800 SH SOLE 3800 0 0 ISHARES TR 1 3 YR TREAS BD 464287457 1108 12790 SH SOLE 12790 0 0 ISHARES TR MSCI EAFE ETF 464287465 4188 68809 SH SOLE 68004 0 805 ISHARES TR RUS MDCP VAL ETF 464287473 386 5040 SH SOLE 5040 0 0 ISHARES TR RUS MD CP GR ETF 464287481 1131 7150 SH SOLE 7150 0 0 ISHARES TR CORE S&P MCP ETF 464287507 212726 1196298 SH SOLE 1147099 0 49199 ISHARES TR S&P MC 400GR ETF 464287606 1547 6905 SH SOLE 6905 0 0 ISHARES TR RUS 1000 GRW ETF 464287614 3445 17948 SH SOLE 17948 0 0 ISHARES TR RUS 1000 ETF 464287622 399 2324 SH SOLE 2324 0 0 ISHARES TR RUS 2000 VAL ETF 464287630 343 3515 SH SOLE 3515 0 0 ISHARES TR RUS 2000 GRW ETF 464287648 631 3050 SH SOLE 3050 0 0 ISHARES TR RUSSELL 2000 ETF 464287655 1018 7110 SH SOLE 7110 0 0 ISHARES TR S&P MC 400VL ETF 464287705 29968 225424 SH SOLE 216344 0 9080 ISHARES TR CORE S&P SCP ETF 464287804 180172 2638341 SH SOLE 2544132 0 94209 ISHARES TR SP SMCP600VL ETF 464287879 1182 9824 SH SOLE 9824 0 0 ISHARES TR S&P SML 600 GWT 464287887 1431 8426 SH SOLE 8426 0 0 ISHARES TR SHRT NAT MUN ETF 464288158 1920 17803 SH SOLE 16823 0 980 ISHARES TR EAFE SML CP ETF 464288273 8835 164772 SH SOLE 161082 0 3690 ISHARES TR JPMORGAN USD EMG 464288281 537 4920 SH SOLE 4920 0 0 ISHARES TR NEW YORK MUN ETF 464288323 3348 58182 SH SOLE 48672 0 9510 ISHARES TR NATIONAL MUN ETF 464288414 2226 19290 SH SOLE 19290 0 0 ISHARES TR MBS ETF 464288588 897 8104 SH SOLE 8104 0 0 ISHARES TR INTRM GOV CR ETF 464288612 1374 11675 SH SOLE 11675 0 0 ISHARES TR SH TR CRPORT ETF 464288646 978 17880 SH SOLE 17880 0 0 ISHARES TR 3 7 YR TREAS BD 464288661 6784 50750 SH SOLE 50750 0 0 ISHARES TR SHORT TREAS BD 464288679 1408 12715 SH SOLE 12715 0 0 ISHARES TR MICRO-CAP ETF 464288869 13046 149485 SH SOLE 137005 0 12480 ISHARES TR EAFE VALUE ETF 464288877 52947 1324676 SH SOLE 1265204 0 59472 ISHARES TR FLTG RATE NT ETF 46429B655 9517 188124 SH SOLE 181647 0 6477 ISHARES TR 0-5 YR TIPS ETF 46429B747 9606 93814 SH SOLE 91771 0 2043 ISHARES TR CORE MSCI EAFE 46432F842 280991 4915866 SH SOLE 4732859 0 183007 ISHARES TR CORE MSCI EMKT 46434G103 88423 1857619 SH SOLE 1796307 0 61312 ISHARES TR ESG MSCI EM ETF 46434G863 636 19810 SH SOLE 19810 0 0 ISHARES TR 0-5YR INVT GR CP 46434V100 223 4280 SH SOLE 4280 0 0 ISHARES TR 0-5YR HI YL CP 46434V407 4705 109700 SH SOLE 109700 0 0 ISHARES TR CORE MSCI INTL 46435G326 452 8843 SH SOLE 8843 0 0 ISHARES TR ESG MSCI USA ETF 46435G425 797 11384 SH SOLE 11384 0 0 ISHARES TR ESG MSCI EAFE 46435G516 944 15585 SH SOLE 15585 0 0 ISHARES TR ESG AWR US AGRGT 46435U549 756 13375 SH SOLE 13375 0 0 JPMORGAN CHASE & CO COM 46625h100 795 8450 SH OTR 8450 0 0 JOHNSON & JOHNSON COM 478160104 811 5768 SH OTR 5768 0 0 LOWES COS INC COM 548661107 884 6540 SH OTR 6540 0 0 MICROSOFT CORP COM 594918104 2357 11580 SH OTR 11580 0 0 MICROCHIP TECHNOLOGY INC. COM 595017104 253 2405 SH OTR 2405 0 0 ORACLE CORP COM 68389X105 307 5548 SH OTR 5548 0 0 PAYCHEX INC COM 704326107 5851 77242 SH OTR 77242 0 0 PEPSICO INC COM 713448108 415 3139 SH OTR 3139 0 0 PIMCO ETF TR 1-5 US TIP IDX 72201R205 3602 67720 SH SOLE 67720 0 0 PROCTER AND GAMBLE CO COM 742718109 204 1706 SH OTR 1706 0 0 SPDR S&P 500 ETF TR TR UNIT 78462F103 85973 278808 SH SOLE 272498 0 6310 SPDR GOLD TR GOLD SHS 78463V107 299 1785 SH SOLE 1785 0 0 SPDR INDEX SHS FDS S&P EMKTSC ETF 78463X756 1338 32776 SH SOLE 32676 0 100 SPDR INDEX SHS FDS S&P INTL SMLCP 78463X871 1124 41093 SH SOLE 40293 0 800 SPDR SER TR PRTFLO S&P500 VL 78464A508 87528 3020299 SH SOLE 2920885 0 99414 SPDR SER TR DJ REIT ETF 78464A607 246 3153 SH SOLE 3153 0 0 SPDR SER TR PORTFOLIO AGRGTE 78464A649 1278 41419 SH SOLE 37054 0 4365 SPDR SER TR PORTFLI TIPS ETF 78464A656 1302 43206 SH SOLE 42426 0 780 SPDR SER TR S&P 400 MDCP VAL 78464A839 21024 493179 SH SOLE 472912 0 20267 SPDR SER TR PORTFOLIO S&P500 78464A854 986 27206 SH SOLE 14791 0 12415 SPDR DOW JONES INDL AVERAGE UT SER 1 78467X109 269 1045 SH SOLE 1045 0 0 SPDR S&P MIDCAP 400 ETF TR UTSER1 S&PDCRP 78467Y107 787 2426 SH SOLE 2426 0 0 SPDR SER TR BLOMBERG BRC INV 78468R200 70935 2327257 SH SOLE 2273729 0 53528 SPDR SER TR NUVEEN BRC MUNIC 78468R721 1011 19572 SH SOLE 19572 0 0 SPDR SER TR NUVEEN BLMBRG SR 78468R739 275 5524 SH SOLE 5524 0 0 SPDR SER TR SPDR S&P 500 ETF 78468R796 822 10770 SH SOLE 1070 0 9700 SCHWAB STRATEGIC TR US LRG CAP ETF 808524201 4789 64624 SH SOLE 59494 0 5130 SCHWAB STRATEGIC TR US LCAP VA ETF 808524409 273 5447 SH SOLE 5447 0 0 SCHWAB STRATEGIC TR US MID-CAP ETF 808524508 1035 19665 SH SOLE 18795 0 870 SCHWAB STRATEGIC TR US SML CAP ETF 808524607 865 13241 SH SOLE 12711 0 530 SCHWAB STRATEGIC TR EMRG MKTEQ ETF 808524706 624 25637 SH SOLE 25237 0 400 SCHWAB STRATEGIC TR INTL EQTY ETF 808524805 2076 69784 SH SOLE 69784 0 0 SCHWAB STRATEGIC TR US AGGREGATE B 808524839 11075 196917 SH SOLE 187787 0 9130 SCHWAB STRATEGIC TR US REIT ETF 808524847 2843 80734 SH SOLE 66904 0 13830 SCHWAB STRATEGIC TR INTRM TRM TRES 808524854 823 14000 SH SOLE 14000 0 0 SCHWAB STRATEGIC TR SHT TM US TRES 808524862 9388 181828 SH SOLE 181828 0 0 SCHWAB STRATEGIC TR US TIPS ETF 808524870 39441 657126 SH SOLE 618034 0 39092 SCHWAB STRATEGIC TR INTL SCEQT ETF 808524888 472 15945 SH SOLE 15945 0 0 SHERWIN WILLIAMS CO COM 824348106 231 400 SH OTR 400 0 0 TOMPKINS FINANCIAL CORPORATI COM 890110109 246 3796 SH OTR 3796 0 0 UNION PAC CORP COM 907818108 206 1220 SH OTR 1220 0 0 VANECK VECTORS ETF TR AMT FREE INT ETF 92189H201 876 17200 SH SOLE 17200 0 0 VANGUARD BD INDEX FDS SHORT TRM BOND 921937827 1533 18440 SH SOLE 18440 0 0 VANGUARD BD INDEX FDS TOTAL BND MRKT 921937835 53831 609360 SH SOLE 592545 0 16815 VANGUARD TAX-MANAGED FDS FTSE DEV MKT ETF 921943858 39003 1005502 SH SOLE 858737 0 146765 VANGUARD MALVERN FDS STRM INFPROIDX 922020805 62242 1240627 SH SOLE 1194822 0 45805 VANGUARD INTL EQUITY INDEX F GLB EX US ETF 922042676 1839 39411 SH SOLE 29971 0 9440 VANGUARD INTL EQUITY INDEX F FTSE EMR MKT ETF 922042858 13446 339471 SH SOLE 283776 0 55695 VANGUARD SCOTTSDALE FDS SHORT TERM TREAS 92206C102 815 13100 SH SOLE 13100 0 0 VANGUARD SCOTTSDALE FDS SHRT TRM CORP BD 92206C409 289 3500 SH SOLE 3500 0 0 VANGUARD SCOTTSDALE FDS MORTG-BACK SEC 92206C771 3552 65335 SH SOLE 65335 0 0 VANGUARD MUN BD FDS TAX EXEMPT BD 922907746 1092 20170 SH SOLE 20170 0 0 VANGUARD INDEX FDS S&P 500 ETF SHS 922908363 434 1533 SH SOLE 1469 0 64 VANGUARD INDEX FDS MCAP VL IDXVIP 922908512 6761 70648 SH SOLE 64685 0 5963 VANGUARD INDEX FDS REAL ESTATE ETF 922908553 678 8640 SH SOLE 6235 0 2405 VANGUARD INDEX FDS VANGUARD INDEX FDS 922908629 3537 21577 SH SOLE 19187 0 2390 VANGUARD LARGE-CAP ETF MID CAP ETF 922908637 9976 69764 SH SOLE 69084 0 680 VANGUARD INDEX FDS LARGE CAP ETF 922908645 484 2385 SH SOLE 2370 0 15 VANGUARD INDEX FDS SMALL CP ETF 922908751 2028 13915 SH SOLE 11770 0 2145 VANGUARD INDEX FDS TOTAL STK MKT 922908769 587 3751 SH SOLE 3751 0 0 VISA INC COM CL A 92826C839 270 1396 SH OTR 1396 0 0