Loading...
HomeMy WebLinkAboutCOPS FUNDS 2022-2023**Click "Shift+Control+j" to run file clean up, then save as CSV** Note: JL Key (10) and JL Obj (8) are for project numbers. JOURNAL VOUCHER Batch ID (16) J0606923 J0606923 Entered By: Approved By: Explanation: Journal Number: JEID (16) J0606923 J0606923 HCELAYA ACCRUE CAL COPS DEFERRED REVENUE FY 22/23 J0606923 Description (30) RECRD CAL COPS DEFERRED REVENUE FY 22/23 RECRD CAL COPS DEFERRED REVENUE FY 22/23 Sec. Ref (16) PEID (12) PEDB (1) CKID (2) CK Num (8) Date: Date: JE Date (8) 6/30/2023 6/30/2023 1/8/2026 GL Key (10) 2290000 2290000 GL Obj (8) 2220000 3423001 JL Key (10) JL Obj (8) Offset (2) N N N N N N N N N N N N N N N N Misc (4) GL Ledger (2) GM GM GM GM GM GM GM GM GM GM GM GM GM GM GM GM JL Ledger (2) Tr. Type (2) ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST Units (18) Msur (4) DR Total 76180.13 DR Amt (18) 76180.13 CR Total 76180.13 CR Amt (18) 76180.13 Hit Other? (1) N N N N N N N N N N N N N N N N EN Type (2) Budg. Ovr. (1) Work Order (12) Prep ID (8) Contract No (16) Post Date (8) JEID ACG (4) TRNS ACG (4) VIEWS (4) UPDATED GRANT NAME LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT UNALLOCATED REVENUE 1/8/2026 GRANT NUMBER COPS - AB 1913 2007/2008 COPS - AB 1913 2008/2009 COPS - AB 1913 2009/2010 COPS - AB 1913 2010/2011 COPS - AB 1913 2011/2012 COPS - AB 1913 2012/2013 COPS - AB 1913 2013/2014 COPS - AB 1913 2014/2015 COPS - AB 1913 2015/2016 COPS - AB 1913 2016/2017 COPS - AB 1913 2017/2018 COPS - AB 1913 2018/2019 COPS - AB 1913 2019/2020 COPS - AB 1913 2020/2021 COPS - AB 1913 2021/2022 COPS - AB 1913 2022/2023 Status Closed Closed Closed Closed Closed Closed Closed Closed Closed Active Active Active Active Active Active Active Active Active Active & Closed FEDERAL CFDA NUMBER n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a Total Totals AWARD AMOUNT 100000 100000 100772.67 100228.43 100000 100000 106230 114618.25 129323.78 139416.41 148746.54 155947.61 156726.58 100000 0 0 0 700837.14 CAL-COPS JAG OTS OTHER EAST-PAC MISC REIMB REVENUE ACCOUNT # 229-0000-342-3001 229-0000-342-3001 229-0000-342-3001 229-0000-342-3001 229-0000-342-3001 229-0000-342-3001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3377400 2290000-3423001 2290000-3331201 2290000-3345000 2290000-3333200 2290000-3347204 2290000-3499400 CITY OF PALM DESERT COPS FUNDS RECONCILIATION FOR FISCAL YEAR ENDING JUNE 30, 2023 PRIOR YEARS AMOUNT 103253 100306.34 100772.67 100228.43 99972.57 100000 106230 114618.25 129323.78 139416.41 148746.54 92901.23 56726.58 100000 0 0 11178.86 548969.62 887962.79 0 0 0 0 11178.86 Fiscal Year 2022/2023 2290000-3423001 GL Account Information Approved Budget 22/23 Total Budget Revenue Received 22/23 Total Revenue 22/23 Budget Balance FY 22/23 AMOUNT 0 0 0 0 0 0 0 0 0 0 0 161284.85 165271.25 0 326556.1 326556.1 0 0 0 0 0 200000 0 0 200000 458491.33 458491.33 -258491.33 MATCHING FUNDS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PRIOR YEARS INTEREST 1981.83 812.87 0 0 27.43 0 0 0 0 0 0 0 0 0 0 0 6953.74 6953.74 0 0 0 0 0 6953.74 FY 21/22 INTEREST 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL AMOUNT 105234.83 101119.21 100772.67 100228.43 100000 100000 106230 114618.25 129323.78 139416.41 148746.54 92901.23 56726.58 100000 161284.85 165271.25 18132.6 882479.46 CAL-COPS JAG OTS OTHER EAST-PAC MISC REIMB EXPENDITURE ACCOUNT # 229-4210-422-3914 229-4210-422-3914 229-4210-422-3914 229-4210-422-3914 229-4210-422-3914 229-4210-422-3914 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391600 2294210-4391800 2294210-4391900 2294210-4392000 PRIOR YEARS EXPENDITURE PER G/L 105234.83 101119.21 100772.67 100228.43 100000 100000 106230 114618.25 129323.78 139416.41 148746.54 105060.25 181083.4 134814.04 0 0 4833.44 713954.08 1059292.67 0 0 0 0 4833.44 Fiscal Year 2022/2023 2294210-4391400 GL Account Information Approved Budget 21/22 Total Budget Expenditures Encumbrances 21/22 Total Costs 20/21 Budget Balance Unencumbered Award Balance FY 22/23 EXPENDITURE PER G/L 0 0 0 0 0 0 0 0 0 0 0 0 0 53023.69 382311.2 0 435334.89 435334.89 0 0 0 0 0 200000 0 200000 435334.89 164667.2 600002.09 -400002.09 -172950.7 FY 17/18 TRANSFER UNALLOCATED 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Years EXPENDITURE PER G/L 105234.83 101119.21 100772.67 100228.43 100000 100000 106230 114618.25 129323.78 139416.41 148746.54 105060.25 181083.4 134814.04 53023.69 382311.2 4833.44 1149288.97 Encumbrance / Advance Amounts 0 0 0 0 0 0 0 0 0 32452.58 132214.62 0 0 0 0 164667.2 Expenditure to Revenue Variance 0 0 0 0 0 0 0 0 0 0 0 -44611.6 -256571.44 -34814.04 108261.16 -217039.95 13299.16 -431476.71 Award Balance 0 0 0 0 0 0 0 0 0 18434.78 -156571.44 -34814.04 -53023.69 -382311.2 No Award Amnt -608285.59 CITY OF PALM DESERT COPS FUNDS FUND BALANCES FOR FISCAL YEAR ENDING JUNE 30, 2023 1/8/2026 Beginning Fund Balances 7/01/22 Revenues Prior Year Deferred Revenues Deferred Revenues Interest Transfers of Funds Transfers In from General Fund Expenditures GASB 31 GASB 31 Prior Year Reversal Ending Fund Balances 6/30/23 Prior Year To Be Carried Forward Balance 1010000 1040000 1150000 1150100 1160000 1260000 1430100 Total Assets 2020000 2070200 2080000 2220000 Total Liabilities 2410100 2410200 2460000 2531000 2532000 2550000 Fund Balance Total Net Assets 2022 0 0 0 0 0 0 0 0 2023 202027.12 202027.12 -109800.34 0 -109800.34 -16046.65 76180.13 92226.78 COPS AB 3229 293220.08 165271.25 0 0 0 0 0 -382311.2 0 0 76180.13 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Federal Grants 0 0 0 0 0 0 0 0 0 0 0 Showing $0 in GL for FY22-23 J0201423 reversed $$ *CALCops_SLESA OTS Grants 0 0 0 0 0 0 0 0 0 0 0 Other Grants 0 0 0 0 0 0 0 0 0 0 0 P.A.C.T. Grant 0 0 0 0 0 0 0 0 0 0 0 Unallocated Revenues 16046.65 0 0 0 0 0 0 0 0 0 16046.65 Deferred Revenue -293220.08 0 293220.08 0 0 0 0 0 0 0 0 Total Fund Equity Totals 16046.65 165271.25 293220.08 0 0 0 0 -382311.2 0 0 92226.78 92226.78 0 DEPT 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 DATE 8/5/2022 8/19/2022 9/2/2022 9/2/2022 9/16/2022 9/16/2022 9/30/2022 9/30/2022 10/14/2022 10/21/2022 10/21/2022 11/4/2022 12/16/2022 12/22/2022 12/22/2022 1/13/2023 2/23/2023 3/2/2023 4/6/2023 4/27/2023 5/11/2023 6/16/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 VENDOR V0013988-FRONTIER COMMUNICATIONS INC V0011989-VERIZON WIRELESS V0012638-BMW MOTORCYCLE OF RIVERSIDE V0013988-FRONTIER COMMUNICATIONS INC V0012707-ENTERPRISE HOLDINGS INC V0006659-RIVERSIDE COUNTY SHERIFF-PSEC V0006659-RIVERSIDE COUNTY SHERIFF-PSEC V0011989-VERIZON WIRELESS V0013988-FRONTIER COMMUNICATIONS INC V0012707-ENTERPRISE HOLDINGS INC V0012707-ENTERPRISE HOLDINGS INC V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0013076-SAN GORGONIO PASS POSSE V0012638-BMW MOTORCYCLE OF RIVERSIDE V0012638-BMW MOTORCYCLE OF RIVERSIDE V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY DESCRIPTION FRONTIER COMMUN Valley Crimest VERIZON WIRELES PD Sheriff Cel BMW New Motorcycle-Patrol Unit FRONTIER COMMUN Valley Crimest Car Rentals for Sheriff Dept Police Radio operations Police Radio operations VERIZON WIRELES PD Sheriff Cel FRONTIER COMMUN Valley Crimest Car Rentals for Sheriff Dept Car Rentals for Sheriff Dept FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FLOCK SAFETY-AutomatedLicensePlateReaders FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest Phase #2 for ALPR- 1st year FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest Mounted Horse Patrol BMW New Motorcycle-Patrol Unit BMW New Motorcycle-Patrol Unit Phase #2 for ALPR-balance due-1st year FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest Pole Replacement 5/26 AveofStates-FLOCK SAFETY-AutomatedLicensePlateReaders AMOUNT 164.74 205.67 30394.43 164.74 3922.18 1398.06 466.02 166.86 167.4 2618.5 5104.07 164.31 170.75 84907.01 30625 175.91 179.32 179.32 179.32 24517.99 169.29 84800 169.97 1500 38000.67 38000.67 33125 174 500 382311.2 764622.4 Begin 7/1/2022 8/1/2022 9/1/2022 10/1/2022 11/1/2022 12/1/2022 1/1/2023 2/1/2023 3/1/2023 4/1/2023 5/1/2023 6/1/2023 7/1/2022 8/1/2022 End 7/31/2022 8/31/2022 9/30/2022 10/31/2022 11/30/2022 12/31/2022 1/31/2023 2/28/2023 3/31/2023 4/30/2023 5/31/2023 6/30/2023 Total 7/31/2022 8/30/2022 Accrual 39-14 0 370.41 36512.29 7889.97 164.31 115702.76 175.91 179.32 179.32 24697.31 169.29 196270.31 382311.2 0 0 0 39-16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39-18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39-19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39-20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 UNALLOCATED 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 370.41 36512.29 7889.97 164.31 115702.76 175.91 179.32 179.32 24697.31 169.29 196270.31 382311.2 0 0 0 DATE 8/5/2022 8/19/2022 9/2/2022 9/2/2022 9/16/2022 9/16/2022 9/30/2022 9/30/2022 10/14/2022 10/21/2022 10/21/2022 11/4/2022 12/16/2022 12/22/2022 12/22/2022 1/13/2023 2/23/2023 3/2/2023 4/6/2023 4/27/2023 5/11/2023 6/16/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 6/30/2023 VENDOR V0013988-FRONTIER COMMUNICATIONS INC V0011989-VERIZON WIRELESS V0012638-BMW MOTORCYCLE OF RIVERSIDE V0013988-FRONTIER COMMUNICATIONS INC V0012707-ENTERPRISE HOLDINGS INC V0006659-RIVERSIDE COUNTY SHERIFF-PSEC V0006659-RIVERSIDE COUNTY SHERIFF-PSEC V0011989-VERIZON WIRELESS V0013988-FRONTIER COMMUNICATIONS INC V0012707-ENTERPRISE HOLDINGS INC V0012707-ENTERPRISE HOLDINGS INC V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0013076-SAN GORGONIO PASS POSSE V0012638-BMW MOTORCYCLE OF RIVERSIDE V0012638-BMW MOTORCYCLE OF RIVERSIDE V0015830-FLOCK SAFETY V0013988-FRONTIER COMMUNICATIONS INC V0015830-FLOCK SAFETY Fiscal Year 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 0.956521739130435 DESCRIPTION FRONTIER COMMUN Valley Crimest VERIZON WIRELES PD Sheriff Cel BMW New Motorcycle-Patrol Unit FRONTIER COMMUN Valley Crimest Car Rentals for Sheriff Dept Police Radio operations Police Radio operations VERIZON WIRELES PD Sheriff Cel FRONTIER COMMUN Valley Crimest Car Rentals for Sheriff Dept Car Rentals for Sheriff Dept FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FLOCK SAFETY-AutomatedLicensePlateReaders FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FRONTIER COMMUN Valley Crimest FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest Phase #2 for ALPR- 1st year FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest Mounted Horse Patrol BMW New Motorcycle-Patrol Unit BMW New Motorcycle-Patrol Unit Phase #2 for ALPR-balance due-1st year FLOCK SAFETY-AutomatedLicensePlateReaders FRONTIER COMMUN Valley Crimest Pole Replacement 5/26 AveofStates-FLOCK SAFETY-AutomatedLicensePlateReaders 2294210 4391400 balance Current Year Expenditure by Grant Award Year 0.956521739130435 2294210 4391400 balance Beginning Balance payment for 09/2022 FY22 COPS Growth payment for 10/2022 payment for 11/2022 payment for 12/2022 payment for 1/2023 payment for 2/2023 payment for 3/2023 payment for 4/2022 Final 22/23 2290000 3423001 balance Combined Beginning Balance and Current Year Salaries Srvc/Spply Equip Admin Overhead Encumbrances Excess (deficiency) CY Revenue Over (under) CY Expenditures Grant Balance AMOUNT 164.74 205.67 30394.43 164.74 3922.18 1398.06 466.02 166.86 167.4 2618.5 5104.07 164.31 170.75 84907.01 30625 175.91 179.32 179.32 179.32 24517.99 169.29 84800 169.97 1500 38000.67 38000.67 33125 174 500 382311.2 Amount 0 0 FY 22/23 SLESF Summary Report (Current) 293220.08 8333.33 65271.25 8333.33 8333.33 8333.33 8333.33 8333.33 8333.33 8333.33 33333.36 165271.25 458491.33 0 102240.43 280070.77 0 0 382311.2 -217039.95 76180.1300000001 GRANT YEAR 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 22/23 Total 0 Total Rcpt # 12483 12550 12652 12832 12957 13161 SLESF0303 13420 13669 13886 Revenue Total Grant Expenditure TYPE Srvc/Spply Srvc/Spply Equip Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Equip Equip Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Equip Srvc/Spply Srvc/Spply Srvc/Spply Srvc/Spply Equip Equip Equip Srvc/Spply Equip Expenditure 0 Date 10/6/2022 10/20/2022 11/4/2022 12/5/2022 1/3/2023 2/6/2023 3/3/2023 3/31/2023 5/9/2023 6/9/2023 Revenue Note Journaled J1200822 12/30/22 Column1 acct 3423001 3423001 3423001 3423001 3423001 3423001 3423001 3423001 3423001 3423001 3423001 DEPT 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 39-14 DATE 7/31/2022 10/6/2022 10/20/2022 11/4/2022 12/5/2022 1/3/2023 2/6/2023 3/3/2023 3/31/2023 5/9/2023 6/9/2023 VENDOR RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER RIVERSIDE COUNTY TREASURER DESCRIPTION SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS SLESF / CALCOPS AMOUNT 293220.08 8333.33 65271.25 8333.33 8333.33 8333.33 8333.33 8333.33 8333.33 8333.33 33333.36 458491.33 21/22Accrual Begin 7/1/2022 8/1/2022 End Total 7/31/2022 8/31/2022 Accrual 39-14 0 0 0 165271.25 0 0 0 0 0 0 0 0 165271.25 293220.08 0 293220.08 39-16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39-18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39-19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39-20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 UNALLOCATED 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 DEFERRED 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total 0 0 0 165271.25 0 0 0 0 0 0 0 0 165271.25 293220.08 0 293220.08 UPDATED CITY OF PALM DESERT COPS FUNDS RECONCILIATION FOR FISCAL YEAR ENDING JUNE 30, 2023 GRANT NAME LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT LOCAL LAW ENFORCEMENT * Award Amount does not reflect the revenue that has been received. ** Remaining Unencumbered Balance reflects the Grant balance based on total awarded amount. 1/8/2026 GRANT NUMBER COPS - AB 1913 2018/2019 COPS - AB 1913 2019/2020 COPS - AB 1913 2020/2021 COPS - AB 1913 2021/2022 REVENUE ACCOUNT # 2290000-3423001 2290000-3423001 2290000-3423001 2290000-3423001 Fiscal Year 2021/2022 2290000-3423001 GL Account Information Action Approved Budget 0 0 0 22/23 Total Budget 0 Revenue Received 0 22/23 Total Revenue 0 22/23 Budget Balance 0 AWARD AMOUNT * 155947.61 156726.58 100000 0 412674.19 Amount 200000 0 0 0 200000 0 458491.33 0 458491.33 0 -258491.33 0 EXPENDITURE ACCOUNT # 2294210-4391400 2294210-4391400 2294210-4391400 2294210-4391400 TOTAL EXPENDITURE PER G/L 105060.25 0 134814.04 0 239874.29 Riverside County Information Services Riverside County Sheriffs Enterprise Holdings BMW Motorcycle of Riverside BMW Motorcycle of Riverside Fiscal Year 2021/2022 2294210-4391400 GL Account Information Action Approved Budget 0 0 21/22 Total Budget Expenditures Encumbrances 21/22 Total Costs 21/22 Budget Balance Unencumbered Award Balance Encumbrance / Advance Amounts 32452.58 132214.62 0 0 164667.2 Encumbrance / Advance - Open POs 16156.12 45000 18000 87214.62 76001.34 242372.08 Amount 200000 0 0 0 200000 435334.89 164667.2 600002.09 -400002.09 -172950.7 Remaining Unencumbered Balance ** 18434.78 24511.96 -34814.04 0 8132.7 P115111 P115126 P115224 P115241 P116071&P116067 19/20 20/21 19/20 20/21 22/23