FY21 GRANT REVENUE BUDGET RECONCILIATION.XLSX

Actuals (Jul- Forecast (Mar- FY 2021 Dept Revised
Grant Unit Activity Start Date End Date Program TRUE UP Comment
Feb) Jun) Budget
KRESGE FOUNDATION 2200 HSDX 7/1/2019 11/30/2021 22APPKRESG 11,867 238,129 249,996 -
ACAA SWG URRD RR Prgm Admin 2299 HSDX 7/1/2020 6/30/2021 22CDACAAUR 967 388 1,355 -
CD ACAA SRP ADMIN 2299 HSDX 7/1/2018 6/30/2021 22CDACASRP - - - -
CD ACAA ACAURD ADMIN 2299 HSDX 7/1/2018 6/30/2021 22CDACAURD - - - -
ACAA SWG URRD RR Program 2299 HSDX 7/1/2020 6/30/2021 22CDACAURS 13,091 16,945 13,632 (16,404)
CD ACAA APS ADMIN 2299 HSDX 7/1/2018 6/30/2021 22CDACSAPS 25,013 9,987 - (35,000)
CD ACAA SWG ADMIN 2299 HSDX 7/1/2018 6/30/2021 22CDADOCS - - - -
CS Eviction Prevention 2205 HSDX 2/1/2019 6/30/2020 22CSADOH - - 105,293 105,293
CS Evict Prevent Voucher 2205 HSDX 2/1/2019 6/30/2020 22CSADOHVH - - 360,396 360,396
ACAA APS PRG ADMIN 2205 HSDX 7/1/2020 6/30/2021 22CSAPSAD - 16,260 73,584 57,324
APS-Engery Support 2205 HSDX 8/1/2019 7/31/2020 22CSAPSE3 9,233 - 124,957 115,724
22CSAPSCB 2205 HSDX 12/1/2020 12/31/2021 22CSAPSCB 48,807 140,000 - (188,807)
CS CSBG CARES Admin 2205 HSDX 7/1/2020 6/30/2021 22CSBGCARE 182 75,033 - (75,215)
CS CSBG CARES Sub 2205 HSDX 7/1/2020 6/30/2021 22CSBGCSUB - 261,946 - (261,946)
CS CSBG CARES Voucher 2205 HSDX 7/1/2020 6/30/2021 22CSBGCVH 72,590 100,000 - (172,590)
DOH Covid 19 admin 2205 HSDX 3/27/2020 3/31/2021 22CSDOHCVA 155,901 46,175 - (202,076)
DOH Covid 19 vouchers 2205 HSDX 3/27/2020 3/31/2021 22CSDOHCVV 207,400 33,571 - (240,971)
DOH Covid 19 prg deliv 2205 HSDX 3/27/2020 3/31/2021 22CSDSCCSN 249,758 - - (249,758)
CS LIHEAP CARES Admin 2205 HSDX 7/1/2020 6/30/2021 22CSLICARE 13,584 42,753 - (56,337)
CS LIHEAP CARES Sub 2205 HSDX 7/1/2020 6/30/2021 22CSLICSUB 45,014 259,529 - (304,543)
CS LIHEAP CARES Vouchers 2205 HSDX 7/1/2020 6/30/2021 22CSLICVH 1,733,161 22,146 - (1,755,307)
CS HAMC COFFELT 2205 HSDX 5/1/2019 4/30/2020 22CSHMCFLT - - 25,300 25,300
CS LIHEAP Direct Srvs 2205 HSDX 7/1/2020 6/30/2021 22CSLIHEAP - - 36,782 36,782
CS NEIGHBORS HELPING NEIGHBORS 2205 HSDX 7/1/2020 6/30/2021 22CSNHNVH 6,910 2 6,912 -
ACAA SRP PRG ADMIN 2205 HSDX 7/1/2020 6/30/2021 22CSSRPAD - - 11,184 11,184
CS ACAA SRP ADMIN 2205 HSDX 7/1/2018 6/30/2021 22CSSRPADM - - - -
CS ACAA SRP Covid 19 emergency funds 2205 HSDX 7/1/2020 6/30/2021 22CSSRPCV (120) 120 - -
ACAA SWES PRG ADMIN 2205 HSDX 7/1/2020 6/30/2021 22CSSWESAD - - 3,216 3,216
CS ACAA SWGE-SHR ADMIN 2205 HSDX 7/1/2018 6/30/2021 22CSSWESAM - - - -
ACAA SWG E SHARE 2205 HSDX 7/1/2020 6/30/2021 22CSSWGES 19,736 12,448 32,184 -
ACAA URRD PRG ADMIN 2205 HSDX 7/1/2020 6/30/2021 22CSURRDAD - - 5,484 5,484
CS ACAA URRD ADMIN 2205 HSDX 7/1/2018 6/30/2021 22CSURRDAM - - - -
EHS-SUPPLEMENT COVID 2220 HSDX 7/1/2020 6/30/2021 22EDCOVID 344,460 350,407 - (694,867)
ESG AZCEND 2299 HSDX 7/1/2020 6/30/2021 22ESGAZSUB 3,810 11,190 69,996 54,996
HCD ESG COVID 2299 HSDX 3/1/2020 9/30/2022 22ESGCOVID 184,143 881,207 - (1,065,350)
HCD ESG COVID ADMIN 2299 HSDX 3/1/2020 9/30/2022 22ESGCVADM 40,855 29,400 - (70,255)
ESG A NEW LEAF 2299 HSDX 7/1/2020 6/30/2021 22ESGNLSUB 50,634 39,366 90,000 -
EXP-Supplement COVID 2220 HSDX 9/1/2019 8/31/2020 22EXPCOVID 75,353 - - (75,353)
ADMIN COSTPOOL ROLLOVER 2200 HSDX 7/1/2016 6/30/2020 22HSROLL (757) 757 - -
National Association of Workforce Boards 2200 HSDX 7/1/2017 6/30/2018 22NAWB 699 55,992 55,293 still open in FBR with FY18 Grant Period
SASD AAA SAIL Covid-19 2245 HSDX 7/1/2020 6/30/2021 22SAILCOVD 221,124 244,876 - (466,000)
SSBG SOCIAL SERVICES 2245 HSDX 7/1/2020 6/30/2021 22SAILWTLT 128,753 96,401 225,154 -
SWFIPXMC 2270 HSDX 11/1/2016 6/30/2021 22SWFIPX 47,160 30,810 163,594 85,624
Vitalyst Health Foundation 2299 HSDX 7/1/2018 6/30/2019 22VITALYST - - 50,004 50,004
WDD TCAA 2270 HSDX 10/7/2020 6/30/2021 22WDDTCAA 11,194 7,112 - (18,306)
22WDSCTSDL 2270 HSDX 7/1/2020 6/30/2021 22WDSCTSDL 15,179 8,458 13,518 (10,119)
WD - SURPRISE 2270 HSDX 7/1/2020 6/30/2021 22WDSURP 37,965 9,352 43,785 (3,532)
22WDTEMPE 2270 HSDX 7/1/2020 6/30/2021 22WDTEMPE 28,341 15,012 46,714 3,361
WD - WICKENBURG 2270 HSDX 7/1/2020 6/30/2021 22WDWKBG 32,078 11,535 43,613 -
CD-WTHR ACAA SRP ADM 2299 HSDX 5/1/2020 6/30/2021 CDACAASRP 16,039 - 33,505 17,466
ACAA URRD ADM WX 2299 HSDX 7/1/2020 6/30/2021 CDACAAURAD 17,019 - 31,869 14,850
ACAA URRD WX 2299 HSDX 7/1/2020 6/30/2021 CDACAAURRD 243,062 2,120 318,624 73,442
CD-WTHR ACAA SRP 2299 HSDX 5/1/2020 6/30/2021 CDACASRP 224,533 16,422 226,020 (14,935)
APS WEATHERIZATION ADMIN 2299 HSDX 1/1/2020 12/31/2020 CDACSADM 28,337 - 70,551 42,214
APS WEATHERIZATION 2299 HSDX 1/1/2020 12/31/2020 CDACSAPS 340,851 31,651 416,664 44,162
CDBG ADMIN 2299 HSDX 7/1/2020 6/30/2021 CDBGADM - - 48,255 48,255 Budget is in F222 - s/b in F217?
ESG16 HUD 2299 HSDX 7/1/2020 6/30/2021 CDESGADM 2,093 - 19,348 17,255
COMMUNITY BRIDGES ES26 SUBRECIPIENT 2299 HSDX 7/1/2020 6/30/2021 CDESGSUB 8,879 141,121 72,948 (77,052)
GOEP LIHEAP 2299 HSDX 7/1/2020 6/30/2021 CDLIHEAP - - 10,380 10,380
CD-GOEP DOE ADM 2299 HSDX 7/1/2020 6/30/2021 CDWTHRDOEA 24,099 - 22,878 (1,221)
CD-GOEP DOE WTHR 2299 HSDX 7/1/2020 6/30/2021 CDWTHRDOEP 379,535 30,085 409,620 -
CD-GOEP DOE TRAINING 2299 HSDX 7/1/2020 6/30/2021 CDWTHRDOET 2,000 - 28,764 26,764
GOEP LIHEAP ADM WTHR 2299 HSDX 7/1/2020 6/30/2021 CDWTHRLA 53,103 - 46,978 (6,125)
GOEP LIHEAP WTHR 2299 HSDX 7/1/2020 6/30/2021 CDWTHRLP 838,265 434,582 916,918 (355,929)
GOEP SWG WTHR 2299 HSDX 1/1/2020 12/31/2020 CDWTHRSG 15,487 - 78,384 62,897
GOEP SWG ADM 2299 HSDX 1/1/2021 12/31/2021 CDWTHRSGA 1,209 - 7,842 6,633
HUMAN SERVICE GEN SRV COSTPOOL 2200 POOL 7/1/2019 6/30/2020 COSTPOOL (140,447) 140,447 - - FY20
HUMAN SERVICE GEN SRV COSTPOOL 2200 POOL 7/1/2020 6/30/2021 COSTPOOL 150,978 659,784 810,762 - FY21
CS-ACAA16 APS 2205 HSDX 7/1/2020 6/30/2021 CSACAAAPS 44,331 37,469 367,908 286,108
CA-ACAA16 SRP 2205 HSDX 7/1/2020 6/30/2021 CSACAASRP 90,824 15,821 111,864 5,219
CS-ACAA16 SWG 2205 HSDX 7/1/2020 6/30/2021 CSACAASWG 42,874 6,350 49,224 -
CDS-ACAA16 URRD 2205 HSDX 7/1/2020 6/30/2021 CSACAAURRD 15,998 12,129 54,888 26,761
CSD-DES CSBG ADMIN 2205 HSDX 7/1/2020 6/30/2021 CSBGADM 71,556 28,630 598,838 498,652
CS-DES CSBG SUBRECIPIENT 2205 HSDX 7/1/2020 6/30/2021 CSBGSUB 124,409 146,799 225,000 (46,208)
DES CSBG VOUCHERS 2205 HSDX 7/1/2020 6/30/2021 CSBGVH 31,172 50,000 99,996 18,824
HUD FAMILY SELF SUFFICIENCY 2205 HSDX 1/1/2020 12/31/2020 CSHMCHFSS - - 30,521 30,521
HAMC HOUSING 2205 HSDX 1/1/2020 12/31/2020 CSHMCMADHT - - 27,279 27,279
CSD-DES LIHEAP ADMIN 2205 HSDX 7/1/2020 6/30/2021 CSLIHEAPAM 95,513 24,326 305,843 186,004
CS LIHEAP SUB 2205 HSDX 7/1/2020 6/30/2021 CSLIHEAPSB 77,837 432,050 436,248 (73,639)
CS-LIHEAP VOUCHERS 2205 HSDX 7/1/2020 6/30/2021 CSLIHEAPVH 1,672,258 1,363,261 3,643,116 607,597
CD-DES TANF ADMIN 2205 HSDX 7/1/2020 6/30/2021 CSTANF - - 115,635 115,635
TANF SUN RECIEP 2205 HSDX 7/1/2020 6/30/2021 CSTANFSUB 8,556 57,032 109,776 44,188
CSD-DES TANF VOUCHERS 2205 HSDX 7/1/2020 6/30/2021 CSTANFVH 121,702 120,000 370,056 128,354
CCP EXPANSION BASE 2220 HSDX 9/1/2020 8/31/2021 EDCCPEXP 894,580 545,284 1,783,164 343,300
EARLY CHILDHOOD PRTNR 2220 HSDX 7/1/2020 6/30/2021 EDCCPSHP 1,304,958 1,233,135 2,654,200 116,107
EARLY CHILDHOOD TTA 2220 HSDX 7/1/2020 6/30/2021 EDCCTTA 27,626 34,918 89,472 26,928
EDCPADMN 2220 HSDX 7/1/2020 6/30/2021 EDCPADMN 65,755 36,399 - (102,154)
CCP EXPANSION TTA 2220 HSDX 9/1/2020 8/31/2021 EDCPXTTA 605 16,251 43,116 26,260
HSDED EARLY HEAD START ADMIN 2220 HSDX 7/1/2020 6/30/2021 EDEHADMN 300,919 181,590 - (482,509)
EARLY HEAD START BASE 2220 HSDX 7/1/2020 6/30/2021 EDEHEADST 1,485,188 1,414,462 2,899,650 -
CACFP MEALS REIMBURSEMENTS 2220 HSDX 10/1/2019 9/30/2020 EDEHHCACF - - 98,004 98,004
EARLY HEAD START TTA 2220 HSDX 7/1/2020 6/30/2021 EDEHSTTA 24,530 29,988 83,504 28,986
CACFP MEALS REIMBURSEMENTS 2220 HSDX 10/1/2019 9/30/2020 EDHDHCACF - - 342,000 342,000
HEAD START TTA 2220 HSDX 7/1/2020 6/30/2021 EDHDSTTA 57,013 36,313 112,027 18,701
HSDED HEAD START ADMIN 2220 HSDX 7/1/2020 6/30/2021 EDHEADMN 1,011,115 494,914 - (1,506,029)
HEAD START BASE 2220 HSDX 7/1/2020 6/30/2021 EDHEADST 5,468,341 4,731,596 11,506,817 1,306,880
SASD AAA SAIL 2245 HSDX 7/1/2020 6/30/2021 SASDAAS 966,334 652,693 1,872,911 253,884
CSD DES CASE MGT SSBG 2205 HSDX 7/1/2020 6/30/2021 SSBGCM 179,381 145,888 356,755 31,486
WDD ADULT ADMIN FY 2270 HSDX 10/1/2020 6/30/2021 WDFYADADMN 373,472 660,415 699,864 (334,023) IDC for all Programs
WDD ADULT PROG FY 2270 HSDX 10/1/2020 6/30/2021 WDFYADULT 2,610,859 3,938,730 6,549,589 -
WDD DISWRK PROG FY 2270 HSDX 10/1/2020 6/30/2021 WDFYDISWRK 713,248 358,357 1,200,471 128,866
WDD DW FY TO ADULT 2270 HSDX 10/1/2019 9/30/2020 WDFYDWADLT 2,323,808 - - (2,323,808)
WDD DW ADMIN FY 2270 HSDX 10/1/2020 6/30/2021 WDFYDWADMN 281,964 - 95,099 (186,865)
WDD RR PROG FY 2270 HSDX 10/1/2019 9/30/2020 WDFYRPDRSP 619,151 49,067 1,208,904 540,686
WDD ADULT ADMIN PY 2270 HSDX 7/1/2019 6/30/2021 WDPYADADMN 70,055 - - (70,055)
WDD ADULT PROG PY 2270 HSDX 7/1/2019 6/30/2021 WDPYADULT 618,657 - 387,624 (231,033)
WDD RR PROG PY 2270 HSDX 7/1/2020 6/30/2021 WDPYRPDRSP 31,373 256,063 - (287,436)
WDD YOUTH ADMIN PY 2270 HSDX 4/1/2020 6/30/2021 WDPYYTHADM 251,661 - 546,354 294,693
WDD YOUTH PROG PY 2270 HSDX 4/1/2020 6/30/2021 WDPYYTHPRO 2,653,752 2,226,567 3,451,603 (1,428,716)

Forecast (Mar- FY 2021 Dept Revised
Grant Unit Activity Start Date End Date Program Actuals (Jul-Feb) TRUE UP Comment
Jun) Budget
CDBG A New Leaf 2299 HSDX 7/1/2020 6/30/2021 22CDANLSUB 20,782 18,548 9,000 (30,330)
HCD CDBG COVID 2299 HSDX 3/1/2020 9/30/2022 22CDBGCOVD 222,452 - - (222,452)
HCD CDBG COVID 2299 HSDX 3/1/2020 9/30/2022 22CDBGCVAD 71,510 40,331 - (111,841)
CDBG HOMELESS NAVIGATION SERVICE2299 HSDX 7/1/2020 6/30/2021 22CDCBINAV 45,714 86,286 66,000 (66,000)
CDBG Community Bridges 2299 HSDX 7/1/2020 6/30/2021 22CDCBISUB - - 51,500 51,500
CDBG Lutheran Social Services 2299 HSDX 7/1/2020 6/30/2021 22CDLSSSUB 36,430 28,570 25,000 (40,000)
CDBG NATIVE AMERICAN CONNECTION 2299 HSDX 7/1/2020 6/30/2021 22CDNACSUB 95,196 49,474 22,500 (122,170)
CDBG TOLLESON SUB 2299 HSDX 7/1/2018 6/30/2019 22CDTOLSUB 113,942 78,312 - (192,254)
CDBG NAVIGATION TO WORKFORCE DE2299 HSDX 7/1/2020 6/30/2021 22CDWDDCOR 5,828 26,906 103,475 70,741
CDBG Youngtown SUB 2299 HSDX 7/1/2020 6/30/2021 22CDYOUNG - - 187,000 187,000
HOUSING AUTHORITY OF MARICOPA CO2299 HSDX 7/1/2020 6/30/2021 22HAMCTBRA 46,021 336,299 190,159 (192,161)
LEAD HAZARD CONTROL AND HEALTHY 2299 HSDX 7/1/2019 6/30/2022 22HEALTHYH - - 100,000 100,000 3-year award
HOME ADMIN CITIES 2299 HSDX 7/1/2020 6/30/2021 22HMADMSUB - - 67,104 67,104
HOME MCHIP 2299 HSDX 7/1/2018 6/30/2019 22HMMCHIP 30,200 219,800 621,878 371,878
LEAD HAZARD CONTROL AND HEALTHY 2299 HSDX 7/1/2019 6/30/2022 22LEADSAFE 118,788 136,946 494,700 238,966 3-year award
CDBG ADMIN 2299 HSDX 7/1/2020 6/30/2021 CDBGADM 220,559 75,009 447,683 152,115
CDBG DG1407 MCHSD EMERGENCY REP2299 HSDX 7/1/2019 6/30/2020 CDBGEMRP 100 250,900 90,000 (161,000)
CDBG UNALLOCATED 2299 HSDX 7/1/2020 6/30/2021 CDBGUNALLO - 500,000 281,399 (218,601) Placeholder for unallocated fund
CDBG DG1504 TOWN OF GILA BEND SU 2299 HSDX 7/1/2019 6/30/2020 CDGILASUB 253,556 - 56,296 (197,260)
CDBG DG1209 GUADALUPE SUBRECIPIE2299 HSDX 7/1/2020 6/30/2021 CDGUADSUB 386,311 503,391 219,437 (670,265)
CDBG DG1503 CITY OF EL MIRAGE SUBR2299 HSDX 7/1/2019 6/30/2020 CDMIRAGSUB 63,923 - 212,500 148,577
TRIBAL SALT RIVER PIMA MARICOPA 2299 HSDX 1/1/2020 12/31/2020 CDSRPTRBL 75,000 - 75,000 -
CDBG DG1507 TOWN OF WICKENBURG 2299 HSDX 7/1/2019 6/30/2020 CDWICKSUB 541,927 - 299,457 (242,470)
HOME CM1209 AVONDALE SUBRECIPIE 2299 HSDX 7/1/2019 6/30/2020 HMAVONSUB - 87,032 94,195 7,163
HOME CM1101 CHANDLER SUBRECIPIE 2299 HSDX 7/1/2018 6/30/2019 HMCHANDSUB 11,013 225,703 263,797 27,081
HOME CM1502 TOWN OF GILBERT SUB 2299 HSDX 7/1/2019 6/30/2020 HMGILBTSUB 250,359 - 125,180 (125,179)
HOME CM0903 GLENDALE SUBRECIPIEN2299 HSDX 7/1/2019 6/30/2020 HMGLENSUB 479,350 161,087 929,940 289,503
HOME NEWTOWN CHANDLER SUBRECI 2299 HSDX 7/1/2020 6/30/2021 HMNEWCHSUB - - 96,522 96,522
HOME CHDO NEWTOWN TEMPE SUBRE2299 HSDX 7/1/2020 6/30/2021 HMNEWTMSUB 561,888 - 114,949 (446,939)
HOME CM1406 CITY OF PEORIA SUBREC2299 HSDX 7/1/2020 6/30/2021 HMPEORSUB - 192,853 229,674 36,821
HOME CM1307 SCOTTSDALE SUBRECIP 2299 HSDX 7/1/2020 6/30/2021 HMSCOTTSUB - 84,309 312,772 228,463
HOME CM0910 SURPRISE SUBRECIPIEN 2299 HSDX 7/1/2020 6/30/2021 HMSURPSUB - 187,475 187,764 289
HOME CM1008 TEMPE SUBRECIPIENT 2299 HSDX 7/1/2018 6/30/2019 HMTEMPESUB 10,300 257,613 167,913 (100,000)
HOME ADM 2299 HSDX 7/1/2020 6/30/2021 HOMEADM 157,200 80,364 301,482 63,918
HOME PROGRAM INCOME 2299 HSDX 7/1/2020 6/30/2021 HOMEPI - - 29,995 29,995
HOME UNALLOCATED 2299 HSDX 7/1/2020 6/30/2021 HOMEUNALLO - 380,941 255,000 (125,941) Placeholder for unallocated fund
SAVE THE FAMILY 2299 HSDX 7/1/2020 6/30/2021 SVFAMLYSUB - - 132,500 132,500
HOME MCHIP 2299 HSDX 7/1/2015 6/30/2016 RNTLHSGDEV 35,273 - - (35,273)
-
TOTAL GRANT BUDGET 3,853,622 4,008,149 6,861,771 (1,000,000)

Forecast (Mar- FY 2021 Dept Revised
Grant Unit Activity Start Date End Date Program Actuals (Jul-Feb) TRUE UP Comment
Jun) Budget
Human Services ERA Admin 2200 HSDX 12/27/2020 12/31/2021 22ERAADMIN - 4,620,882 - (4,620,882)
Human Services ERA Rent 2200 HSDX 12/27/2020 12/31/2021 22ERARENT - 31,190,954 - (31,190,954)
Human Services ERA Utilities 2200 HSDX 12/27/2020 12/31/2021 22ERAUTIL - 10,396,985 - (10,396,985)
-
TOTAL GRANT BUDGET - 46,208,821 - (46,208,821)