0001567619-20-010262.txt : 20200515
0001567619-20-010262.hdr.sgml : 20200515
20200515092914
ACCESSION NUMBER: 0001567619-20-010262
CONFORMED SUBMISSION TYPE: 13F-HR
PUBLIC DOCUMENT COUNT: 2
CONFORMED PERIOD OF REPORT: 20200331
FILED AS OF DATE: 20200515
DATE AS OF CHANGE: 20200515
EFFECTIVENESS DATE: 20200515
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: 20881223
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
03-31-2020
03-31-2020
ALESCO ADVISORS LLC
120 OFFICE PARK WAY
PITTSFORD
NY
14534
13F HOLDINGS REPORT
028-10620
N
Jeffrey D. Bradley
Chief Compliance Officer
(585) 586-0970
/s/ Jeffrey D. Bradley
Pittsford
NY
05-15-2020
0
116
1638188
false
INFORMATION TABLE
2
form13fInfoTable.xml
ABBOTT LABS
COM
002824100
274
3467
SH
OTR
3467
0
0
ALLSTATE CORP
COM
020002101
450
4902
SH
OTR
4902
0
0
AMAZON COM INC
COM
023135106
355
182
SH
OTR
182
0
0
APPLE INC
COM
037833100
1406
5527
SH
OTR
5270
0
257
AUTOMATIC DATA PROCESSING IN
COM
053015103
217
1585
SH
OTR
1585
0
0
BARCLAYS BANK PLC
DJUBS CMDT ETN36
06738C778
385
23292
SH
OTR
23292
0
0
BERKSHIRE HATHAWAY INC DEL
CL A
084670108
272
1
SH
OTR
1
0
0
BERKSHIRE HATHAWAY INC DEL
CL B NEW
084670702
954
5219
SH
OTR
5219
0
0
BOEING CO
COM
097023105
330
2214
SH
OTR
2214
0
0
DISNEY WALT CO
COM DISNEY
254687106
205
2124
SH
OTR
2124
0
0
EXXON MOBIL CORP
COM
30231g102
553
14565
SH
OTR
14565
0
0
INTEL CORP
COM
458140100
350
6473
SH
OTR
6473
0
0
INVESCO ACTIVELY MANAGD ETF
OPTIMUM YIELD
46090F100
8454
715210
SH
SOLE
694495
0
20715
INVESCO EXCHANGE TRADED FD T
S&P500 PUR VAL
46137V258
303
7597
SH
SOLE
7597
0
0
INVESCO DB COMMDY INDX TRCK
UNIT
46138B103
299
26585
SH
SOLE
26585
0
0
ISHARES GOLD TRUST
ISHARES
464285105
1709
113400
SH
SOLE
113400
0
0
ISHARES TR
TIPS BD ETF
464287176
18399
156030
SH
SOLE
144689
0
11341
ISHARES TR
CORE S&P500 ETF
464287200
395478
1530487
SH
SOLE
1457211
0
73276
ISHARES TR
CORE US AGGBD ET
464287226
21930
190081
SH
SOLE
190081
0
0
ISHARES TR
IBOXX INV CP ETF
464287242
726
5875
SH
SOLE
1385
0
4490
ISHARES TR
S&P 500 GRWT ETF
464287309
1081
6547
SH
SOLE
6547
0
0
ISHARES TR
S&P 500 VAL ETF
464287408
13933
144758
SH
SOLE
133477
0
11281
ISHARES TR
BARCLAYS 7 10 YR
464287440
462
3800
SH
SOLE
3800
0
0
ISHARES TR
1 3 YR TREAS BD
464287457
2014
23234
SH
SOLE
23234
0
0
ISHARES TR
MSCI EAFE ETF
464287465
3849
72001
SH
SOLE
71196
0
805
ISHARES TR
RUS MDCP VAL ETF
464287473
417
6501
SH
SOLE
6364
0
137
ISHARES TR
RUS MD CP GR ETF
464287481
869
7150
SH
SOLE
7150
0
0
ISHARES TR
CORE S&P MCP ETF
464287507
171572
1192629
SH
SOLE
1142085
0
50544
ISHARES TR
S&P MC 400GR ETF
464287606
1232
6905
SH
SOLE
6905
0
0
ISHARES TR
RUS 1000 GRW ETF
464287614
2704
17948
SH
SOLE
17948
0
0
ISHARES TR
RUS 1000 ETF
464287622
320
2264
SH
SOLE
2264
0
0
ISHARES TR
RUS 2000 VAL ETF
464287630
288
3515
SH
SOLE
3515
0
0
ISHARES TR
RUS 2000 GRW ETF
464287648
482
3050
SH
SOLE
3050
0
0
ISHARES TR
RUSSELL 2000 ETF
464287655
798
6972
SH
SOLE
6972
0
0
ISHARES TR
S&P MC 400VL ETF
464287705
33414
304458
SH
SOLE
293523
0
10935
ISHARES TR
CORE S&P SCP ETF
464287804
145762
2597794
SH
SOLE
2500915
0
96879
ISHARES TR
SP SMCP600VL ETF
464287879
982
9822
SH
SOLE
9822
0
0
ISHARES TR
S&P SML 600 GWT
464287887
1186
8600
SH
SOLE
8600
0
0
ISHARES TR
SHRT NAT MUN ETF
464288158
1558
14658
SH
SOLE
13678
0
980
ISHARES TR
AGENCY BOND ETF
464288166
603
5000
SH
SOLE
5000
0
0
ISHARES TR
EAFE SML CP ETF
464288273
5980
133398
SH
SOLE
126573
0
6825
ISHARES TR
JPMORGAN USD EMG
464288281
476
4920
SH
SOLE
4920
0
0
ISHARES TR
NEW YORK MUN ETF
464288323
2969
52542
SH
SOLE
43832
0
8710
ISHARES TR
NATIONAL MUN ETF
464288414
1456
12885
SH
SOLE
12885
0
0
ISHARES TR
MBS ETF
464288588
876
7934
SH
SOLE
7934
0
0
ISHARES TR
INTRM GOV CR ETF
464288612
1041
9075
SH
SOLE
9075
0
0
ISHARES TR
SH TR CRPORT ETF
464288646
1083
20690
SH
SOLE
20690
0
0
ISHARES TR
3 7 YR TREAS BD
464288661
6522
48915
SH
SOLE
48915
0
0
ISHARES TR
SHORT TREAS BD
464288679
1343
12100
SH
SOLE
12100
0
0
ISHARES TR
MICRO-CAP ETF
464288869
10004
149241
SH
SOLE
136871
0
12370
ISHARES TR
EAFE VALUE ETF
464288877
7082
198421
SH
SOLE
181674
0
16747
ISHARES TR
FLTG RATE NT ETF
46429B655
8305
170404
SH
SOLE
166007
0
4397
ISHARES TR
0-5 YR TIPS ETF
46429B747
9563
95722
SH
SOLE
93674
0
2048
ISHARES TR
CORE MSCI EAFE
46432F842
243472
4880168
SH
SOLE
4679879
0
200289
ISHARES INC
CORE MSCI EMKT
46434G103
72302
1786553
SH
SOLE
1710941
0
75612
ISHARES INC
ESG MSCI EM ETF
46434G863
396
14470
SH
SOLE
14470
0
0
ISHARES TR
0-5YR HI YL CP
46434V407
4465
109250
SH
SOLE
109250
0
0
ISHARES TR
ESG MSCI EAFE
46435G516
657
12350
SH
SOLE
12350
0
0
ISHARES TR
ESG US AGR BD
46435U549
424
7650
SH
SOLE
7650
0
0
JPMORGAN CHASE & CO
COM
46625h100
761
8450
SH
OTR
8450
0
0
JOHNSON & JOHNSON
COM
478160104
791
6033
SH
OTR
6033
0
0
LOWES COS INC
COM
548661107
563
6540
SH
OTR
6540
0
0
MICROSOFT CORP
COM
594918104
1964
12455
SH
OTR
12455
0
0
ORACLE CORP
COM
68389X105
268
5548
SH
OTR
5548
0
0
PAYCHEX INC
COM
704326107
4860
77242
SH
OTR
77242
0
0
PEPSICO INC
COM
713448108
399
3322
SH
OTR
3322
0
0
PIMCO ETF TR
1-5 US TIP IDX
72201R205
4229
81781
SH
SOLE
81781
0
0
SPDR S&P 500 ETF TR
TR UNIT
78462F103
72931
282954
SH
SOLE
276644
0
6310
SPDR GOLD TRUST
GOLD SHS
78463V107
266
1799
SH
SOLE
1799
0
0
SPDR INDEX SHS FDS
S&P EMKTSC ETF
78463X756
1562
47177
SH
SOLE
46418
0
759
SPDR INDEX SHS FDS
DJ INTL RL ETF
78463X863
390
14558
SH
SOLE
14423
0
135
SPDR INDEX SHS FDS
S&P INTL SMLCP
78463X871
1069
46959
SH
SOLE
46159
0
800
SPDR SER TR
DJ REIT ETF
78464A607
3210
44459
SH
SOLE
43084
0
1375
SPDR SER TR
PORTFOLIO AGRGTE
78464A649
1545
51115
SH
SOLE
43350
0
7765
SPDR SER TR
PORTFLI TIPS ETF
78464A656
1439
49546
SH
SOLE
48766
0
780
SPDR SER TR
S&P 400 MDCP VAL
78464A839
1651
46813
SH
SOLE
44696
0
2117
SPDR SER TR
PORTFOLIO S&P500
78464A854
819
27090
SH
SOLE
14675
0
12415
SPDR DOW JONES INDL AVRG ETF
UT SER 1
78467X109
229
1045
SH
SOLE
1045
0
0
SPDR S&P MIDCAP 400 ETF TR
UTSER1 S&PDCRP
78467Y107
638
2426
SH
SOLE
2426
0
0
SPDR SER TR
PORTFOLIO SH TSR
78468R101
5160
167979
SH
SOLE
147650
0
20329
SPDR SER TR
BLOMBERG BRC INV
78468R200
43614
1483464
SH
SOLE
1449959
0
33505
SPDR SER TR
NUVEEN BRC MUNIC
78468R721
979
19572
SH
SOLE
19572
0
0
SPDR SER TR
NUVEEN BLMBRG SR
78468R739
285
5824
SH
SOLE
5824
0
0
SPDR SER TR
SPDR S&P 500 ETF
78468R796
688
10770
SH
SOLE
1070
0
9700
SCHWAB STRATEGIC TR
US LRG CAP ETF
808524201
4281
69890
SH
SOLE
64760
0
5130
SCHWAB STRATEGIC TR
US LCAP VA ETF
808524409
556
12569
SH
SOLE
12569
0
0
SCHWAB STRATEGIC TR
US MID-CAP ETF
808524508
1071
25399
SH
SOLE
23404
0
1995
SCHWAB STRATEGIC TR
US SML CAP ETF
808524607
894
17343
SH
SOLE
16168
0
1175
SCHWAB STRATEGIC TR
EMRG MKTEQ ETF
808524706
860
41561
SH
SOLE
40391
0
1170
SCHWAB STRATEGIC TR
INTL EQTY ETF
808524805
2615
101194
SH
SOLE
101194
0
0
SCHWAB STRATEGIC TR
US AGGREGATE B
808524839
10424
192079
SH
SOLE
184019
0
8060
SCHWAB STRATEGIC TR
US REIT ETF
808524847
26462
808233
SH
SOLE
780156
0
28077
SCHWAB STRATEGIC TR
INTRM TRM TRES
808524854
823
14000
SH
SOLE
14000
0
0
SCHWAB STRATEGIC TR
SHT TM US TRES
808524862
26649
515151
SH
SOLE
512826
0
2325
SCHWAB STRATEGIC TR
US TIPS ETF
808524870
16758
291391
SH
SOLE
266409
0
24982
SCHWAB STRATEGIC TR
INTL SCEQT ETF
808524888
1004
41134
SH
SOLE
41134
0
0
TOMPKINS FINANCIAL CORPORATI
COM
890110109
273
3796
SH
OTR
3796
0
0
VANECK VECTORS ETF TR
AMT FREE INT ETF
92189H201
845
17200
SH
OTR
17200
0
0
VANGUARD BD INDEX FDS
SHORT TRM BOND
921937827
1644
20005
SH
SOLE
20005
0
0
VANGUARD BD INDEX FDS
TOTAL BND MRKT
921937835
45612
534408
SH
SOLE
523423
0
10985
VANGUARD TAX-MANAGED INTL FD
FTSE DEV MKT ETF
921943858
29569
886885
SH
SOLE
770153
0
116732
VANGUARD MALVERN FDS
STRM INFPROIDX
922020805
50754
1041757
SH
SOLE
1012642
0
29115
VANGUARD INTL EQUITY INDEX F
GLB EX US ETF
922042676
18662
434908
SH
SOLE
416823
0
18085
VANGUARD INTL EQUITY INDEX F
FTSE EMR MKT ETF
922042858
10052
299598
SH
SOLE
265461
0
34137
VANGUARD SCOTTSDALE FDS
SHORT TERM TREAS
92206C102
605
9700
SH
SOLE
9700
0
0
VANGUARD SCOTTSDALE FDS
SHRT TRM CORP BD
92206C409
720
9100
SH
SOLE
9100
0
0
VANGUARD SCOTTSDALE FDS
MORTG-BACK SEC
92206C771
864
15845
SH
SOLE
15845
0
0
VANGUARD MUN BD FD INC
TAX EXEMPT BD
922907746
879
16620
SH
SOLE
16620
0
0
VANGUARD INDEX FDS
S&P 500 ETF SHS
922908363
348
1469
SH
SOLE
1469
0
0
VANGUARD INDEX FDS
MCAP VL IDXVIP
922908512
3753
46168
SH
SOLE
40603
0
5565
VANGUARD INDEX FDS
REAL ESTATE ETF
922908553
3052
43695
SH
SOLE
40936
0
2759
VANGUARD INDEX FDS
MID CAP ETF
922908629
2538
19277
SH
SOLE
19277
0
0
VANGUARD INDEX FDS
LARGE CAP ETF
922908637
8270
69829
SH
SOLE
69829
0
0
VANGUARD INDEX FDS
SMALL CP ETF
922908751
1292
11188
SH
SOLE
11188
0
0
VANGUARD INDEX FDS
TOTAL STK MKT
922908769
522
4050
SH
SOLE
4050
0
0
VISA INC
COM CL A
92826C839
243
1511
SH
OTR
1511
0
0