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