Loading...
HomeMy WebLinkAbout21 Treasure Report June 2023 AGENDA ITEM #21 Public Utility District m MEETING DATE: June 7, 2023 TO: Board of Directors FROM: Melanie Rives, Finance & Accounting Manager SUBJECT: Approve the Treasurer's Report June 2023 ATTACHMENTS: 1. 2023-06 Treasurers Report Page 1 of 1 Page 298 of 315 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT June 7, 2023 Fund Balances for the Month March 31, 2023 And Disbursements for the Month April 30, 2023 (includes Government Code section 53065.5 items) Page 1 of 12 Page 299 of 315 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending March 31, 2023 and disbursements for April 2023. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS and Check Summary The attached listing of checks and ACH payments issued during April 2023 total $3,921,686.24 in disbursements. 2) EMPLOYEE REIMBURSEMENT FOR INDIVIDUAL CHARGES Per Government Code 53065.5: Each special district, as defined by subdivision (a) of Section 56036, shall, at least annually, disclose any reimbursement paid by the district within the immediately preceding fiscal year of at least one hundred dollars ($100)for each individual charge for services or product received. "Individual charge" includes, but is not limited to, one meal, lodging for one day, transportation, or a registration fee paid to any employee or member of the governing body of the district. The disclosure requirement shall be fulfilled by including the reimbursement information in a document published or printed at least annually by a date determined by that district and shall be made available for public inspection. The Disbursements listing referenced in 1) includes above subject reimbursements information, as applicable. 3) STATEMENT OF GENERAL FUND: As of March 31, 2023 the balance in the General Fund was $12,781,041 (Electric $4,301,635 and Water $8,479,406). 4) FUNDS STATUS REPORT: The total of all funds held in cash and on deposit with US Bank, the Local Agency Investment Fund, Placer County Investment Fund, Utah Public Treasurers' Investment Fund, BNY and TVI Investments as of March 31, 2023 was $58,228,058 ($33,131,666 Electric and $25,096,392 Water). 5) INVESTMENT STATUS REPORT: The majority of the District's investments are in California's Local Agency Investment Fund (LAIF), Utah Public Treasurers' Investment Fund (UPTIF) and the Placer County Investment Fund (PCIF). The earnings rates for the last 13 months were: LAIF PCIF UPTIF 1 YR T-BILL TVI March 2022 0.37% 0.33% 0.53% 1.57% 0.55% April 2022 0.52% 0.41% 0.62% 1.96% 0.55% May 2022 0.68% 0.51% 0.80% 2.00% 0.55% June 2022 0.86% 0.53% 1.12% 2.70% 0.55% July 2022 1.09% 0.65% 1.64% 2.88% 0.55% August 2022 1.28% 0.73% 2.21% 2.88% 0.55% September 2022 1.51% 0.85% 2.48% 3.87% 0.55% October 2022 1.77% 0.98% 2.86% 4.46% 0.55% November 2022 2.01% 1.54% 3.37% 4.52% 0.55% December 2022 2.17% 2.07% 3.85% 4.51% 0.55% January 2023 2.43% 2.27% 4.28% 4.49% 0.55% February 2023 2.62% 2.23% 4.66% 4.78% 0.55% March 2023 2.83% 2.42% 4.80% 4.43% 0.55% Page 2 of 12 Page 300 of 315 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of April 2023 totaled $3,921,686.24. A listing of those disbursements is attached. AP DISBURSEMENTS METRICS (excludes Payroll): Accounts Payable (A/P) Metrics $ A/P Disbursements 6,000,000.00 5,000,000.00 — 4,000,000.00 3,000,000.00 2,000,000.00 lit 1,000,000.00 wil III - ,oil 0.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 0 2019 0 2020 0 2021 0 2022 2023 # A/P Payments Issued 400 — 350 300 — 250 200 150 100 50 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 0 2019 0 2020 0 2021 0 2022 2023 # A/P Invoices Vouchered 1,200 — 1,000 — 800 — 600 400 200 II Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■2019 ■2020 ■2021 ■2022 —2023 Page 3 of 12 Page 301 of 315 Truckee Donner Public Utility District Check Register CA April 2023 Gov.Code 53605.5 ChecklTran Date TVDe Vendor Vendor Name Item Reference Amount 5616 4/1/2023 WIRE 6731 CALIFORNIA DEPARTMENTOF TAXAND FEE USE TAX PAYABLE $ 953.00 5613 4/1/2023 WIRE 10360 AFLAC EMPLOYEE PAID INSURANCE 1,392.24 5611 4/1/2023 WIRE 1359 CALPERS PENSION 10,000.00 133036 4/6/2023 CHK 246 ROCK GARDEN MATERIALS&SERVICES 40.59 133020 4/6/2023 CHK 240 AUDIO ON-HOLD ON-HOLD PHONE SYSTEM 79.00 133046 4/6/2023 CHK 5643 ZORO.COM OFFICE SUPPLIES 94.61 37872 4/6/2023 DO 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 94.91 133044 4/6/2023 CHK 1308 TRUCKEE TIRE REPAIRS&MAINTENANCE 100.00 133023 4/6/2023 CHK 348 EDGES ELECTRICAL GROUP MATERIALS&SERVICES 122.66 133022 4/6/2023 CHK 358 CALIFORNIA SURVEYING DRAFTING SUPPLY INC OFFICE SUPPLIES 146.94 37853 4/6/2023 DO 9347 CHARLES W FILLMAN IV 53605.5 DMV PHYSICAL-C.FILLMAN 165.00 37863 4/6/2023 DO 1079 O'REI LILY AUTO PARTS MISC PARTS&SUPPLIES 186.14 37866 4/6/2023 DO 9923 STEVEN PONCELET' MEETING EXPENSES 193.47 133034 4/6/2023 CHK 462 POWERPLAN-OIB REPAIRS&MAINTENANCE 206.23 133037 4/6/2023 CHK 10720 SNOQUIP REPAIRS&MAINTENANCE 214.90 37874 4/6/2023 DO 1176 TRUCKEE FAMILY EYECARE OPTOMETRY,INC VISION REIMUBRSEMENT 225.00 37860 4/6/2023 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 275.31 37867 4/6/2023 DO 837 SIERRA OFFICE SOLUTIONS XEROX COPIER LEASE 276.97 133040 4/6/2023 CHK 1515 SWPPP SOLUTION HIRSCHDALE PIPELINE 300.00 37876 4/6/2023 DO 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 317.90 133028 4/6/2023 CHK 468 MAITA CHEVROLET REPAIRS&MAINTENANCE 332.65 37870 4/6/2023 DO 716 SMALLPOND STUDIO PROFESSIONAL SERVICES:MARKETING 398.75 133043 4/6/2023 CHK 10189 TRUCKEE DOWNTOWN MERCH ASSN. PRGM DLVRY:DIRECT NON-INCNT 400.00 37865 4/6/2023 DO 820 ONESOURCE DISTRIBUTORS INVENTORY 426.37 37859 4/6/2023 DO 11025 MOONSHINE INK MARKETING 428.00 37877 4/6/2023 DO 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 478.00 37857 4/6/2023 DO 115 KIMBALL-MIDWEST MISC PARTS&SUPPLIES 521.47 133019 4/6/2023 CHK 657 AT&T COMMUNICATIONS 534.18 133021 4/6/2023 CHK 44444 ANDREW BUCKLEY INCENTIVES-EV CHARGERS 600.00 133026 4/6/2023 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 640.51 37869 4/6/2023 DO 1532 SLATE ROCK FIR EMPLOYEE UNIFORM 667.91 37858 4/6/2023 DO 1149 LOOMIS BANKING CHARGES 716.96 37864 4/6/2023 DO 1545 OHIO POWER TOOL,INC CONCRETE SAW 884.34 37856 4/6/2023 DO 3520 JOHNSON CONTROLS FIRE PROTECTION LP BUILDING MAINTENANCE 942.00 133027 4/6/2023 CHK 44444 PATRICK LONERGAN INCENTIVES-EV CHARGERS 950.00 133035 4/6/2023 CHK 1290 RESCUE TRAINING INSTITUTE,INC. BUILDING MAINTENANCE 962.19 133030 4/6/2023 CHK 44444 DEREK MINETTI INCENTIVES-HEAT PUMP WATER HEATER 1,000.00 133025 4/6/2023 CHK 1240 JUST IMAGINE MARKETING&DESIGN MARKETING 1,060.00 133042 4/6/2023 CHK 242 THOLL FENCE INC. BUILDING MAINTENANCE 1,200.00 37871 4/6/2023 DO 6604 SPIEGEL&MC DIARMID PROFESSIONAL SERVICES:FERC ISSUES 1,382.50 133024 4/6/2023 CHK 1352 INSTRUMENT TECHNOLOGY CORPORATION EMPLOYEE DEVELOPMENT 1,600.00 133029 4/6/2023 CHK 44444 STEPHANIE MCINTOSH INCENTIVES-EV CHARGERS&PANEL UPGRADES 1,649.00 37878 4/6/2023 DO 7820 WESTERN NEVADA SUPPLY CO INVENTORY 2,285.46 37852 4/6/2023 DO 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC XEROX COPIER LEASE 2,525.39 133041 4/6/2023 CHK 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 2,864.43 133045 4/6/2023 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 3,016.65 37879 4/6/2023 DO 10678 WILLDAN FINANCIAL SERVICES GC MR ADMIN COSTS 3,708.31 37850 4/6/2023 DO 1537 AMAZON CAPITAL SERVICES,INC REPAIRS&MAINTENANCE 4,008.94 37851 4/6/2023 DO 577 COOPERATIVE RESPONSE CENTER INC. ANSWERING SERVICE 4,236.85 37854 4/6/2023 DO 3349 GLOBAL RENTAL CO INC RENTALVEHICLE 4,979.50 133039 4/6/2023 CHK 10761 SOUTHWEST GAS CORP. UTILITIES:NATURAL GAS 6,754.51 133018 4/6/2023 CHK 134 ANIXTER INC. INVENTORY 7,233.33 37855 4/6/2023 DO 1116 HUNT&SONS,INC FUEL/OIL FOR VEHICLES 7,264.26 133038 4/6/2023 CHK 1495 SOSU TV BOARD MEETING EXPENSES 9,999.00 37861 4/6/2023 DO 5130 NCPA MEMBERSHIP DUES 11,901.00 133033 4/6/2023 CHK 1540 P31 ENTERPRISES CONTRACT SERVICES:ROW TREE CLEARING 14,448.30 37862 4/6/2023 DO 6403 NEVADA POWER COMPANY PURCHASED POWER-SPPC&NEVADA POWER 15,127.27 133031 4/6/2023 CHK 5151 NRECA INSURANCE 16,037.01 37868 4/6/2023 DO 6402 SIERRA PACIFIC POWER CO PURCHASED POWER-SPPC&NEVADA POWER 86,065.47 37873 4/6/2023 DO 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 207,320.37 133032 4/6/2023 CHK 5150 NRECA GROUP BENEFITS TRUST INSURANCE 224,672.01 37875 4/6/2023 DO 10584 UAMPS PURCHASED POWER-LAMPS 1,189,990.08 5610 4/12/2023 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9953 FINAL 142.82 5608 4/12/2023 WIRE 11233 CALPERS PENSION 815.66 5607 4/12/2023 WIRE 3824 MISSIONSQUARE MISSIONSQUARE CONTRIBUTIONS 9953 FINAL 1,746.07 5609 4/12/2023 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 9953 FINAL 2,427.96 133047 4/12/2023 CHK PL PAYROLL PAYROLL FINAL CHECK 12,688.77 5605 4/13/2023 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE O4/07/23 1,246.22 5606 4/13/2023 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 04/07/2023 20,746.75 5604 4/13/2023 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 04/07/2023 22,301.63 5601 4/13/2023 WIRE 3824 MISSIONSQUARE MISSIONSQUARE CONTRIBUTIONS PPE 04/07/23 36,411.29 5602 4/13/2023 WIRE 11233 CALPERS PENSION 65,644.42 5603 4/13/2023 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 04/07/2023 111,344.43 5600 4/13/2023 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 238,952.04 133083 4/14/2023 CHK 99999 BARBARA SMOAK CUSTOMER REFUND-CLOSED ACCOUNT 2.00 133073 4/14/2023 CHK 99999 ETHAN PARKER CUSTOMER REFUND-CLOSED ACCOUNT 10.00 133069 4/14/2023 CHK 970 NORTHERN CALIFORNIAJOINT POLE ASSN MEMBERSHIP DUES 13.84 133081 4/14/2023 CHK 99999 JAIMEE SALIBA CUSTOMER REFUND-CLOSED ACCOUNT 18.43 133052 4/14/2023 CHK 99999 MR CASEY BARTEVIAN CUSTOMER REFUND-CLOSED ACCOUNT 21.18 37974 4/14/2023 DO 1079 O'REI LILY AUTO PARTS REPAIRS&MAINTENANCE 21.44 133063 4/14/2023 CHK 10932 J&L FOOD MART&CARWASH REPAIRS&MAINTENANCE 30.00 133070 4/14/2023 CHK 99999 MISS JILL OATES CUSTOMER REFUND-CLOSED ACCOUNT 41.66 133075 4/14/2023 CHK 99999 MS NATALIE PEREZ CUSTOMER REFUND-CLOSED ACCOUNT 60.42 37969 4/14/2023 DO 115 KIMBALL-MIDWEST MISC PARTS&SUPPLIES 76.44 133077 4/14/2023 CHK 9921 DANIEL PRICE MEETING EXPENSES 79.00 133060 4/14/2023 CHK 99999 WILLIAM HULBERT CUSTOMER REFUND-CLOSED ACCOUNT 96.45 133053 4/14/2023 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 04/07/2023 115.38 37972 4/14/2023 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 117.02 Page 1of3 Page 4 of 12 Page 302 of 315 Truckee Donner Public Utility District Check Register CA April 2023 Gov.Code 53605.5 ChecklTran Date TVDe Vendor Vendor Name Item Reference Amount 133067 4/14/2023 CHK 99999 MS AMY W MORRIS CUSTOMER REFUND-CLOSED ACCOUNT 138.22 133071 4/14/2023 CHK 5222 ODP BUSINESS SOLUTIONS LLC OFFICE SUPPLIES 148.09 133057 4/14/2023 CHK 99999 MRJARRED DURANTE CUSTOMER REFUND-CLOSED ACCOUNT 148.74 133076 4/14/2023 CHK 31 POULIN STEEL FAB INC. MATERIALS&SERVICES 150.00 133084 4/14/2023 CHK 2240 SPRINGHILL SUITES BY MARRIOTT STORM DAMAGE 152.95 37981 4/14/2023 DO 2025 THE OFFICE BOSS WATER SAMPLE ANALYSIS 163.55 37975 4/14/2023 DO 775 ONLINE INFORMATION SERVICES CREDIT CHECK SERVICES 176.60 133078 4/14/2023 CHK 99999 KIMBERLY REILLY CUSTOMER REFUND-CLOSED ACCOUNT 179.64 37955 4/14/2023 DO 1537 AMAZON CAPITAL SERVICES,INC COMPUTER EXPENSES 203.58 133048 4/14/2023 CHK 99999 STEVE ALLINGTON CUSTOMER REFUND-CLOSED ACCOUNT 217.25 37971 4/14/2023 DO 617 MOUNTAIN EAP EMPLOYEE RELATIONS&WELLNESS PROGRAM 225.00 37984 4/14/2023 DO 10380 ULINE FIELD SUPPLIES 238.60 133061 4/14/2023 CHK 99999 HUMBLE BEGINNINGS CUSTOM HOMES CUSTOMER REFUND-CLOSED ACCOUNT 254.55 37976 4/14/2023 DO 9944 EMPLOYEE VISION REIMBURSEMENT 259.96 37962 4/14/2023 DO 9360 JAMES M FLOWERS* EMPLOYEE DEVELOPMENT 261.00 37961 4/14/2023 DO 736 FACTORY MOTOR PARTS MISC PARTS&SUPPLIES 269.15 37964 4/14/2023 DO 3480 GRAINGER INC. FACILITY SUPPLIES 278.69 133054 4/14/2023 CHK 1518 COLUMN SOFTWARE PBC HIRSCHDALE CONN PIPELINE&PRV STATION 294.23 37983 4/14/2023 DO 1286 TYNDALE COMPANY INC EMPLOYEE UNIFORMS 324.75 133059 4/14/2023 CHK 99999 MONICA HOWARTH CUSTOMER REFUND-CLOSED ACCOUNT 335.32 133058 4/14/2023 CHK 9449 EMPLOYEE VISION REIMBURSEMENT 400.00 133062 4/14/2023 CHK 1352 INSTRUMENT TECHNOLOGY CORPORATION EMPLOYEE DEVELOPMENT 400.00 133080 4/14/2023 CHK 9980 EMPLOYEE VISION REIMBURSEMENT 400.00 37977 4/14/2023 DO 1787 SILVER STATE INTERNATIONAL TRUCKS MISC PARTS&SUPPLIES 411.33 133082 4/14/2023 CHK 99999 MS CAMERON SELLERS CUSTOMER REFUND-CLOSED ACCOUNT 424.65 37978 4/14/2023 DO 9953 EMPLOYEE VISION REIMBURSEMENT 435.00 133079 4/14/2023 CHK 99999 RENAISSANCE HOLDING COMPANY,LLC CUSTOMER REFUND-CLOSED ACCOUNT 462.42 37968 4/14/2023 DO 9510 EMPLOYEE VISION REIMBURSEMENT 465.00 37965 4/14/2023 DO 3515 GRAYBAR ELECTRIC CO INC 6170 TANK(NEW) 479.23 133074 4/14/2023 CHK 99999 JOHN PATRICK PAYMENT MADE IN ERROR 481.33 133066 4/14/2023 CHK 99999 MR TREVER J MEIER CUSTOMER REFUND-CLOSED ACCOUNT 493.25 133056 4/14/2023 CHK 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING,MAINTENANCE&SUPPORT 506.48 133065 4/14/2023 CHK 9665 EMPLOYEE VISION REIMBURSEMENT 564.16 37988 4/14/2023 DO 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 566.00 37960 4/14/2023 DO 640 EMPLOYER LYNX INC. PERSONNEL EXPENSES 575.00 37987 4/14/2023 DO 320 W&TGRAPHICS EMPLOYEE UNIFORMS 840.84 37957 4/14/2023 DO 829 CDS GLOBAL REMITTANCE PROCESSING 857.11 37982 4/14/2023 DO 1176 TRUCKEE FAMILY EYECARE OPTOMETRY,INC VISION REIMUBRSEMENT 880.00 37985 4/14/2023 DO 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 959.88 37979 4/14/2023 DO 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 1,036.30 133085 4/14/2023 CHK 99999 THE HOPPY DUCK CUSTOMER REFUND-CLOSED ACCOUNT 1,042.83 37966 4/14/2023 DO 1116 HUNT&SONS,INC FUEL/OIL FOR VEHICLES 1,044.56 133049 4/14/2023 CHK 810 ALMETEK INDUSTRIES INC MATERIALS&SERVICES 1,108.73 37986 4/14/2023 DO 1538 USA FLEET SOLUTIONS MISC PARTS&SUPPLIES 1,382.70 133050 4/14/2023 CHK 657 AT&T COMMUNICATIONS 1,408.71 37958 4/14/2023 DO 9220 REGINA COOLEY 53605.5 TUITION REIMBURSEMENT 1,565.00 37980 4/14/2023 DO 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 1,575.26 37973 4/14/2023 DO 9820 EMPLOYEE VISION REIMBURSEMENT 1,579.70 37963 4/14/2023 DO 10257 GIVES LLC TOOLS 1,953.29 133068 4/14/2023 CHK 10508 NEVADA COUNTY CLERK-RECORDER HIRSCHDALE CONN PIPELINE&PRV STATION 2,814.00 37959 4/14/2023 DO 1496 DIRECT TECHNOLOGY PROFESSIONAL SERVICES:PROGRAM DELIVERY 3,600.00 133086 4/14/2023 CHK 1308 TRUCKEE TIRE REPAIRS&MAINTENANCE 5,800.84 133064 4/14/2023 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 6,274.65 37967 4/14/2023 DO 3820 IBEW LOCAL 1245 UNION DUES PPE 04/07/2023 7,246.86 37956 4/14/2023 DO 2263 CASHMAN EQUIPMENT COMPANY RENTALVEHICLE 7,537.64 133072 4/14/2023 CHK 1540 P31 ENTERPRISES CONTRACT SERVICES:ROW TREE CLEARING 35,912.16 37989 4/14/2023 DO 7820 WESTERN NEVADA SUPPLY CO MATERIALS&SERVICES 48,893.08 37970 4/14/2023 DO 1523 M-3 CONSTRUCTION INC PIONEER TRAIL PUMPSTATION PROJECT 200,423.88 133090 4/21/2023 CHK 193 EASTERN REGIONAL LANDFILL LANDFILL CHARGES 11.25 38016 4/21/2023 DO 7300 TRUCKEE RENTS INC MATERIALS&SERVICES 54.10 133094 4/21/2023 CHK 99999 JORG HEINEMANN CUSTOMER REFUND-CLOSED ACCOUNT 54.74 133095 4/21/2023 CHK 99999 JOHNNY JIMENEZ CUSTOMER REFUND-CLOSED ACCOUNT 70.00 133091 4/21/2023 CHK 348 EDGES ELECTRICAL GROUP BUILDING MAINTENANCE 72.00 38003 4/21/2023 DO 1079 O'REI LILY AUTO PARTS MISC PARTS&SUPPLIES 101.69 133108 4/21/2023 CHK 5643 ZORO TOOLS,INC MATERIALS&SERVICES 114.03 38000 4/21/2023 DO 10008 MOTION&FLOW CONTROL PRODUCTS,INC. REPAIRS&MAINTENANCE 135.40 38014 4/21/2023 DO 7176 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 143.49 133105 4/21/2023 CHK 7175 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 173.18 133098 4/21/2023 CHK 5222 ODP BUSINESS SOLUTIONS LLC FACILITY SUPPLIES 178.72 38008 4/21/2023 DO 9962 GRANT)SACKS* CELL PHONE REIMBURSEMENT 01/23 TO 03/23 180.00 38012 4/21/2023 DO 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 180.36 133107 4/21/2023 CHK 99999 CHASE WOOLARD CUSTOMER REFUND-CLOSED ACCOUNT 208.43 37998 4/21/2023 DO 1099 MOANA NURSERY PROFESSIONAL SERVICES:OTHER 219.00 38011 4/21/2023 DO 1357 SWIFT COMMUNICATIONS OF CALIFORNIA GENERAL ADVERTISEMENT 220.50 133104 4/21/2023 CHK 242 THOLL FENCE INC. BUILDING MAINTENANCE 236.25 133089 4/21/2023 CHK 99999 DANIEL DESMOND CUSTOMER REFUND-CLOSED ACCOUNT 257.40 133102 4/21/2023 CHK 99999 STATE OF CALIFORNIA CSD-HEAP PROGRAM CUSTOMER REFUND-CLOSED ACCOUNT 257.86 38001 4/21/2023 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 294.54 38018 4/21/2023 DO 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 317.90 38009 4/21/2023 DO 1787 SILVER STATE INTERNATIONAL TRUCKS REPAIRS&MAINTENANCE 328.41 133096 4/21/2023 CHK 99999 KERTTU MCCRAY CUSTOMER REFUND-CLOSED ACCOUNT 341.82 133099 4/21/2023 CHK 99999 AMYJ OLSON CUSTOMER REFUND-CLOSED ACCOUNT 351.74 38019 4/21/2023 DO 643 UNITED SITE SERVICES OF NEVADA MATERIALS&SERVICES 358.61 37997 4/21/2023 DO 1305 JW WELDING SUPPLIES&TOOLS MATERIALS&SERVICES 362.47 37993 4/21/2023 DO 10809 BATTERIES PLUS MATERIALS&SERVICES 378.17 133103 4/21/2023 CHK 99999 STATE OF CALIFORNIA CSD-HEAP PROGRAM CUSTOMER REFUND-CLOSED ACCOUNT 400.73 133097 4/21/2023 CHK 5151 NRECA HEALTH 125 ADMINISTRATIVE FEES 480.00 38004 4/21/2023 DO 820 ONESOURCE DISTRIBUTORS MATERIALS&SERVICES 484.94 Page 2of3 Page 5 of 12 Page 303 of 315 Truckee Donner Public Utility District Check Register CA April 2023 Gov.Code 53605.5 ChecklTran Date Tvoe Vendor Vendor Name Item Reference Amount 38020 4/21/2023 DO 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 546.00 133101 4/21/2023 CHK 99999 STATE OF CALIFORNIA CSD-HEAP PROGRAM CUSTOMER REFUND-CLOSED ACCOUNT 668.55 38010 4/21/2023 DO 11214 SINNETT CONSULTING SERVICES,LLC EMPLOYEE DEVELOPMENT 795.85 133106 4/21/2023 CHK 11041 TRUCKEE PAINT MART INC. MATERIALS&SERVICES 924.71 37992 4/21/2023 DO 11443 AUTOGLASS/MOTORSPORTS EXPRESS-TRUCKEE REPAIRS&MAINTENANCE 959.60 37995 4/21/2023 DO 5840 FERGUSON ENTERPRISES INC MATERIALS&SERVICES 1,047.12 37996 4/21/2023 DO 10257 GIVES LLC TOOLS 1,506.35 37999 4/21/2023 DO 965 MOSS ADAMS LLP PROFESSIONAL SERVICES:AUDIT 1,575.00 37991 4/21/2023 DO 1537 AMAZON CAPITAL SERVICES,INC HARDWARE PURCHASES 1,769.74 38013 4/21/2023 DO 1328 TRAFFIC MANAGEMENT,INC. MATERIALS&SERVICES 2,184.00 38005 4/21/2023 DO 9504397 PACE SUPPLY TOOLS 2,245.63 133088 4/21/2023 CHK 99999 CIRCLE PIZZA LLC CUSTOMER REFUND-CLOSED ACCOUNT 2,534.88 37994 4/21/2023 DO 1465 DOCUSIGN,INC LOCKBOX LICENSING,MAINTENANCE&SUPPORT 3,105.00 38021 4/21/2023 DO 7820 WESTERN NEVADA SUPPLY CO INVENTORY 3,218.70 133100 4/21/2023 CHK 6273 SAILERS ENGINEERING INC PIONEER TRAIL PUMPSTATION PROJECT 3,349.20 133087 4/21/2023 CHK 134 ANIXTER INC. INVENTORY 3,457.45 37990 4/21/2023 DO 5440 ALTEC INDUSTRIES INC TOOLS 5,356.95 38006 4/21/2023 DO 5730 PORTER SIMON LEGALSERVICES 5,772.27 38015 4/21/2023 DO 712 TRUCKEE DONNER PUD PURCHASED POWER-STAMPEDE HYDRO GEN 5,978.99 38007 4/21/2023 DO 1372 POWER PARTNERS,LLC. PURCHASE TRANSFORMERS 12,240.91 38002 4/21/2023 DO 289 NISC MARCH 2O23 MISC 17,483.66 38017 4/21/2023 DO 1183 TRUCKEE-CARSON IRRIGATION DISTRICT PURCHASED POWER-TCID 41,788.50 133092 4/21/2023 CHK 1535 EPLUS TECHNOLOGY INC VIRTUAL INFRASTRUCTURE REPLACEMENT 323,142.41 5622 4/27/2023 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE O4/21/23 1,246.22 5618 4/27/2023 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHOLDING PPE 04/21/2023 21,563.28 5620 4/27/2023 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 04/21/2023 22,712.88 5619 4/27/2023 WIRE 3824 MISSIONSQUARE MISSIONSQUARE CONTRIBUTIONS PPE 04/21/23 35,564.49 5617 4/27/2023 WIRE 11233 CALPERS PENSION 65,933.74 5621 4/27/2023 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 04/21/2023 109,282.50 5615 4/27/2023 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 235,465.66 38115 4/28/2023 DO 6403 NEVADA POWER COMPANY PURCHASED POWER-SPPC&NEVADA POWER 29.87 133124 4/28/2023 CHK 99999 CONNIE SULLIVAN CUSTOMER REFUND-CLOSED ACCOUNT 44.89 38104 4/28/2023 DO 5440 ALTEC INDUSTRIES INC TOOLS 78.18 133116 4/28/2023 CHK 905 HEALTHEQUITY INC. HSA ADMINISTRATIVE FEES 79.95 133123 4/28/2023 CHK 11226 SHRED-IT USA LLC OFFICE SUPPLIES 85.00 133111 4/28/2023 CHK 348 EDGES ELECTRICAL GROUP MATERIALS&SERVICES 86.07 133128 4/28/2023 CHK 5643 ZORO TOOLS,INC MATERIALS&SERVICES 86.53 38116 4/28/2023 DO 9950 ANABEL SANCHEZ PERSONNEL EXPENSES 89.94 133110 4/28/2023 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 04/21/2023 115.38 38114 4/28/2023 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 132.82 133122 4/28/2023 CHK 1479 SCHNEIDER ELECTRIC SYSTEMS USA,INC. MATERIALS&SERVICES 146.14 38108 4/28/2023 DO 9224 THOMAS CROW* MEETING EXPENSES 149.00 38106 4/28/2023 DO 9205 SHANE CHRISTIAN` MEETING EXPENSES 174.00 133117 4/28/2023 CHK 99999 MATTHEW JENNINGS CUSTOMER REFUND-CLOSED ACCOUNT 206.02 38110 4/28/2023 DO 3480 GRAINGER INC. PERSONAL CHARGE:R.PURSEL 254.25 38117 4/28/2023 DO 1532 SLATE ROCK FR EMPLOYEE UNIFORMS 264.45 38113 4/28/2023 DO 1099 MOANA NURSERY OFFICE SUPPLIES 272.00 133114 4/28/2023 CHK 99999 FELICIA FORNEY-RAMIREZ CUSTOMER REFUND-CLOSED ACCOUNT 302.99 133119 4/28/2023 CHK 468 MAITA CHEVROLET REPAIRS&MAINTENANCE 319.85 38123 4/28/2023 DO 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 346.00 133113 4/28/2023 CHK 369 FIRST AMERICAN TITLE CO GC MR ANNUAL ADMIN COSTS 420.00 38121 4/28/2023 DO 1286 TYNDALE COMPANY INC EMPLOYEE UNIFORMS 421.04 38107 4/28/2023 DO 9220 EMPLOYEE VISION REIMBURSEMENT 441.95 133115 4/28/2023 CHK 99999 FUDDHISM CUSTOMER REFUND-CLOSED ACCOUNT 1,004.88 133125 4/28/2023 CHK 99999 THE GENESIS GROUP CUSTOMER REFUND-CLOSED ACCOUNT 1,032.86 38111 4/28/2023 DO 3515 GRAYBAR ELECTRIC CO INC MATERIALS&SERVICES 1,222.90 133109 4/28/2023 CHK 134 ANIXTER INC. MATERIALS&SERVICES 1,650.82 133120 4/28/2023 CHK 5200 NORTHWEST PUBLIC POWER ASSOCIATION EMPLOYEE DEVELOPMENT 1,775.00 38105 4/28/2023 DO 1537 AMAZON CAPITAL SERVICES,INC FACILITY SUPPLIES 1,813.56 38120 4/28/2023 DO 1176 TRUCKEE FAMILY EYECARE OPTOMETRY,INC VISION REIMUBRSEMENT 1,885.00 133118 4/28/2023 CHK 999 LIBERTY BELL ALARM CO.INC. WOf12 3 6 3118 2,REFUND COMM.PANEL UPGRADE 1,897.65 133127 4/28/2023 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 2,037.61 38118 4/28/2023 DO 6604 SPIEGEL&MC DIARMID PROFESSIONAL SERVICES:FERC ISSUES 2,257.50 133126 4/28/2023 CHK 1308 TRUCKEE TIRE REPAIRS&MAINTENANCE 2,912.22 38112 4/28/2023 DO 1116 HUNT&SONS,INC FUEL/OIL FOR VEHICLES 4,727.35 133112 4/28/2023 CHK 1535 EPLUS TECHNOLOGY INC NETWORK EQUIPMENT-HARDWARE REFRESH 5,533.63 38109 4/28/2023 DO 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,800.00 38119 4/28/2023 DO 1328 TRAFFIC MANAGEMENT,INC. GRAY WIRE REPLACEMENT/UPGRADE 14,190.00 38124 4/28/2023 DO 7820 WESTERN NEVADA SUPPLY CO MATERIALS&SERVICES 22,804.35 38122 4/28/2023 DO 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 39,782.70 133121 4/28/2023 CHK 1540 P31 ENTERPRISES CONTRACT SERVICES:ROW TREE CLEARING 61,876.54 38103 4/28/2023 DO 1393 ACWA JPIA WORKER'S COMP Q3 2023 81,556.48 248 $ 3,921,686.24 *Denotes employee reimbursement containing multiple items with no individual item charge of$100 or greater. Page 3of3 Page 6 of 12 Page 304 of 315 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 03/31/2023 Page 1 of 2 Electric Dept Water Dept Total Balance in General Fund 02/28/2023 $4,979,788 $8,587,965 $13,567,753 Receipts: Revenue received 3,709,562 1,429,392 5,138,954 Retired employees medical insurance 23,179 - 23,179 Record interest earned 6,156 952 7,107 Transfer from Vehicle Reserve 4,262 - 4,262 Reimbursement for COP funded projects - 87,925 87,925 FF Funding and DL Surcharge Reimbursement for 2006 COP - 121,376 121,376 Cash clearing accounts(timing-prior month reversal) (295,741) - (295,741) Cash clearing accounts(timing-current month) 47,723 - 47,723 Total Receipts 3,495,141 1,639,644 $5,134,785 Disbursements: Accounts payable/payroll disbursements $4,118,130 $1,701,477 $5,819,608 Restrict facilities fees 1,472 37,454 38,926 Restrict Donner Lake surcharge - 9,272 9,272 Section 125 benefit disbursement 44,197 - 44,197 Bank charges 9,495 - 9,495 Total Disbursements $4,173,294 $1,748,203 $5,921,497 Balance in General Fund 03/31/2023 $4,301,635 $8,479,406 $12,781,041 5/2/2023 4:16 PM I:\Treasurers Report\Statement of General Fund\2023\2023-03 GF Page 7 of 12 Page 305 of 315 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 03/31/2023 Page 2 of 2 Electric Dept Water Dept Total Distribution of Non-Restricted Funds At Month-End: Customer Services Operating Funds $2,400 $0 $2,400 Operating clearing accounts 47,723 - 47,723 U.S. Bank-General Fund 3,039,221 - 3,039,221 LAIF, UPTIF, PCIF, &TVI-General Fund 1,212,291 8,479,406 9,691,698 Total $4,301,635 $8,479,406 $12,781,041 Market Adjustment ($823,997) ($647,512) ($1,471,509) Total Non-Restricted Funds $3,477,638 $7,831,894 $11,309,532 Distribution of Designated&Restricted Funds at Month-End: LAIF, UPTIF, PCIF&TVI-Restricted Funds 29,643,991 16,356,388 46,000,379 UPTIF-Donner Lake Assessment District - 79,291 79,291 2015 COP Water Bonds, Principal Payment Fund - 404,806 404,806 2022 COP Issuance/Payment Fund 183,171 381,533 564,704 U S Bank-Donner Lake Assessment District 00-1 - 42,480 42,480 Total 29,827,163 17,264,498 47,091,660 Market Adjustment (173,135) - (173,135) Total Restricted Funds 29,654,028 17,264,498 46,918,526 Total Funds Available 33,131,666 25,096,392 58,228,058 Total Market Adjustments (997,131) (647,512) (1,644,643) 5/2/2023 4:16 PM I:\Treasurers Report\Statement of General Fund\2023\2023-03 GF Page 8 of 12 Page 306 of 315 INVESTMENT STATUS REPORT Activity for the Month Ended 3/31/2023 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2022 2/28/2023 Activity 3/31/2023 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND(LAIF)-2.83%(2.62%) General Fund 1..136.1 $ 1,710,862 $ 754,026 $ 187,366 $ 941,392 Consolidate cash 272,085 Reimburse for Horse Butte Power (84,720) Capital Replacement Fund 1..136.41 2,489,566 2,502,681 - 2,502,681 AB 32 Cap 8r Trade Fund 1..136.58 579,554 582,173 84,720 666,893 Reimbursement for Horse Butte Power 84,720 Deferred Liabilites Reserve 1..136.42 2,107,871 2,118,976 - 2,118,976 LCFS Credits 1..136.59 68,049 62,079 - 62,079 2022 COP Project Fund 1..132.95 6,544,562 6,578,948 - 6,578,948 Total LAIF Electric Investments 13,500,465 12,598,883 272,085 12,870,969 UTAH PUBLIC TREASURERS'INVESTMENT FUND(UPTIF)- 4.80%(4.66%) General Fund 1..136.12 1,291,337 275,071 (4,171) 270,899 Restrict facility fees (1,472) Record monthly interest 909 TVI Interest Receivable (7,870) Reimbursement from VR for rental vehicle costs 4,262 Facilities Fees 1..136.9 185,084 193,606 2,112 195,717 Restrict facilites fees 1,472 Record monthly interest 640 Electric Rate Reserve Fund 1..136.45 2,478,957 2,709,695 11,576 2,721,270 Record monthly interest 8,952 TVI Interest Receivable 2,623 Capital Replacement Fund 1..136.46 767,865 778,016 7,817 785,833 Record monthly interest 2,570 TVI Interest Received 5,247 Electric Vehicle Reserve 1..136.13 770,416 1,556,214 879 1,557,094 Record monthly interest 5,141 Transfer to GF for rental vehicle costs (4,262) Total UPTIF Electric Investments 5,493,659 5,512,602 18,212 5,530,814 PLACER COUNTY INVESTMENT FUND(PCIF)- 2.42%(2.23%) Electric Rate Reserve Fund 1..136.47 2,366,422 2,375,016 4,206 2,379,222 Record monthly interest 4,206 Capital Replacement Fund 1..136.48 4,086,623 4,101,464 7,264 4,108,728 Record monthly interest 7,264 Total PCIF County Electric Investments 6,453,045 6,476,480 11,470 6,487,950 TVI INVESTMENTS- 0.55%(0.55%) Capital Replacement Fund 1..136.43 3,966,550 3,966,550 - 3,966,550 Electric Rate Reserve Fund 1..136.44 2,000,000 2,000,000 - 2,000,000 Total TVI Electric Investments 5,966,550 5,966,550 - 5,966,550 Total Electric Investments $ 31,413,719 $ 30,554,515 $ 301,768 $ 30,856,283 :\T-..3.R,PM Investments Status Report Page 9 of 12 I:\Treasurers Report\Investment S[a[us Reports\2023\2023-03 Investments Status Report Page 1 of 3 Page 307 of 315 INVESTMENT STATUS REPORT Activity for the Month Ended 3/31/2023 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2022 2/28/2023 Activity 3/31/2023 WATER FUNDS LOCAL AGENCY INVESTMENT FUND(LAIF)-2.83%(2.62%) General Fund 2..136.1 3,363,862 4,303,725 (221,615) 4,082,110 Consolidate cash (272,085) Restrict facility fees (37,454) Reimburse GF for 2022 COP funded projects 87,925 Facilities Fees 2..136.90 1,542,637 1,598,746 37,454 1,636,200 Restrict facility fees 37,454 Capital Replacement Fund 2..136.41 3,375 3,392 3,392 2022 COP Project Fund 2..132.95 11,879,665 11,950,018 (87,925) 11,862,093 Transer to GF for COP funded projects (87,925) Total LAIF Water Investments 16,789,539 17,855,881 (272,085) 17,583,795 UTAH PUBLIC TREASURERS'INVESTMENT FUND(UPTIF)- 4.80%(4.66%) General Fund 2..136.12 322,338 288,069 113,056 401,125 Transfer to DLAD surcharge (9,272) DL Surcharge Reimbursement for 2006 COP 8,153 FF Funding portion of 2006 COP 29,890 FF Funding portion of 6170 Tank 83,333 Record monthly interest 952 Facilities Fees 2..136.25 1,089,150 870,058 (110,348) 759,710 Record monthly interest 2,874 Transfer to GF for FF Funding portion of 2006 COP (29,890) Transfer to GF for FF Funding portion of 6170 Tank (83,333) West River St.Assessment District 2..136.31 38,801 39,078 129 39,207 Record monthly interest 129 Prepaid Connection Fees 2..136.7 79,292 79,858 264 80,122 Record monthly interest 264 Donner Lake Assessment District Fund 2..136.84 78,470 79,030 261 79,291 Record monthly interest 261 Donner Lake Assessment District Surcharge Fund 2..136.61 177,548 181,046 1,717 182,762 DLAD surcharge collections 9,272 DL Surcharge Reimbursement to GF for 2006 COP (8,153) Record monthly interest 598 TSA SAD II Improvement Fund 2..136.85 18,718 18,852 62 18,914 Record monthly interest 62 Water Vehicle Reserve 2..136.13 382,735 633,380 2,093 635,472 Record monthly interest 2,093 Deferred Liabilites Reserve 2..136.42 108,280 109,052 360 109,413 Record monthly interest 360 Capital Replacement Fund 2..136.46 1,018,446 1,025,714 3,389 1,029,103 Record monthly interest 3,389 Total UPTIF Water Investments 3,313,777 3,324,137 10,982 3,335,119 PLACER COUNTY INVESTMENT FUND(PCIF)- 2.42%(2.23%) Total PCIF Water Investments - - - - TVI INVESTMENTS- 0.55%(0.55%) Water General Fund TVI 2..136.15 3,996,171 3,996,171 - 3,996,171 Total TVI Water Investments 3,996,171 3,996,171 - 3,996,171 Total Water Investments $ 24,099,487 $ 25,176,189 $ (261,103) $ 24,915,085 :\T-..3.R,PM Investments Status Report Page 10 of 12 I:\Treasurers Report\Investment S[a[us Reports\2023\2023-03 Investments Status Report Page 2 of 3 Page 308 of 315 INVESTMENT STATUS REPORT Activity for the Month Ended 3/31/2023 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2022 2/28/2023 Activity 3/31/2023 ELECTRIC&WATER INVESTMENTS,COMBINED TOTALS Pre-Market Adjustments Total LAIF Investments 54% 30,290,004 30,454,764 - 30,454,764 Total UPTIF Investments 16% 8,807,436 8,836,738 29,194 8,865,933 Total PCIF Investments 12% 6,453,045 6,476,480 11,470 6,487,950 Total TVI Investments 18% 9,962,722 9,962,722 9,962,722 Total Investments 100% Month End Bal.Mix $ 45,550,484 $ 55,730,705 $ 40,663 $ 55,771,368 Market Adjustments Total LAIF Investments (563,719) (563,719) - (563,719) Total UPTIF Investments (9,725) (9,725) (9,725) Total PCIF Investments (173,135) (173,135) (173,135) Total TVI Investments (894,712) (896,947) (1,117) (898,064) Total Investments $ (1,641,291) $ (1,643,526) $ (1,117) $ (1,644,643) Post-Market Adjustments Total LAIF Investments 54% 29,726,284 29,891,045 - 29,891,045 Total UPTIF Investments 16% 8,797,711 8,827,013 29,194 8,856,208 Total PCIF Investments 12% 6,279,910 6,303,345 11,470 6,314,815 Total TVI Investments 18% 9,068,010 9,065,775 (1,117) 9,064,657 Total Investments 100% Month End Bal.Mix $ 53,871,915 $ 54,087,178 $ 39,547 $ 54,126,725 5/10/2023 4:50 PM Investments Status Report Page 11 of 12 I:\Treasurers Report\Investment Status Reports\2023\2023-03 Investments Status Report Page 3 of 3 Page 309 of 315 TRUCKEE DONNER PUD INVESTMENT BALANCES as of March 31,2023 Utah Public TVI Fidelity Mmkt Morgan Stanley Dreyfus Treasury BNY US Bank Cash/ LAIF Placer County Investment Fund Investments Govt 57 Treas Sec Port Security Treas Cash Res Checking Cash Clearings Total 131.1 ELECTRIC FUNDS General Fund $ 941,392 $ - $ 270,899 $ - $ - $ - $ - $ - $ 3,039,221 $ 50,123 $ 4,301,635 Facilities Fees - - 195,717 - - - - - - - 195,717 Electric Rate Reserve - 2,379,222 2,721,270 2,000,000 - - - - - - 7,100,492 Capital Replacement Fund 2,502,681 4,108,728 785,833 3,966,550 11,363,793 Deferred Liabilites Reserve/POB Fund 2,118,976 - - - - - - - - - 2,118,976 Electric Vehicle Reserve - - 1,557,094 - - - - - - - 1,557,094 AB 32 Fund 666,893 - - - - - - - - - 666,893 LCFS Credits 62,079 62,079 COP Project Fund 6,578,948 - - - - - - - - - 6,578,948 COP Issuance/Payment Fund - - - - - - - 183,171 - - 183,171 Market Adjustments 239,310 173,135 6,066 578,621 997,131 Total Electric Investments 12,631,659 6,314,815 5,524,748 5,387,930 183,171 3,039,221 50,123 33,131,666 WATER FUNDS General Fund $ 4,082,110 $ - $ 401,125 $ 3,996,171 $ - $ - $ - $ - $ - $ - 8,479,406 Facilities Fees 1,636,200 759,710 - 2,395,910 Capital Replacement Fund 3,392 - 1,029,103 - - - - - - - 1,032,495 2015 COP Funds - - - - 404,806 - - - - - 404,806 DSC and Operating Reserve Fund - - - - - - - - - - - West River St.Assessment District - - 39,207 - - - - - - - 39,207 Deferred Liabilites Reserve - - 109,413 - - - - - - - 109,413 Prepaid Connection Fees - - 80,122 - - - - - - - 80,122 DLAD Fund - - 79,291 - - - - - 42,480 - 121,771 DLAD Surcharge - - 182,762 - - - - - - - 182,762 SRF Reserve and Payment Fund - - - - - - - - - - - TSA SAD II Improvement Fund - - 18,914 - - - - - - - 18,914 Water Vehicle Reserve - - 635,472 - - - - - - - 635,472 Restricted Grant Funds - - - - - - - - - - - COP Project Funds 11,862,093 - - - - - - - - - 11,862,093 COP Issuance/Payment Fund - - - - - - - 381,533 - - 381,533 Market Adjustments 324,409 - 3,659 319,444 647,512 Total Water Investments 17,259,386 3,331,460 3,676,728 404,806 381,533 42,480 25,096,392 Electric and Water,subtotal 29,891,045 6,314,815 8,856,208 9,064,657 404,806 564,704 3,081,700 50,123 58,228,058 MELLO ROOS-OLD GREENWOOD - - - - - 296,055 294,808 - - - 590,863 Total Mello Roos-Old Greenwood 296,055 294,808 590,863 MELLO ROOS-GRAY'S CROSSING 1,931,551 - - - - - - 904,648 - - 2,836,198 Total Mello Roos-Gray's Crossing 1,931,551 904,648 2,836,198 Total Investments $ 31,822,595 $ 6,314,815 $ 8,856,208 $ 9,064,657 $ 404,806 $ 296,055 $ 294,808 $ 1,469,352 $ 3,081,700 $ 50,123 $ 61,655,119 2023 02 Last Month End Balances 31,812,557 6,303,345 8,827,013 9,065,775 313,643 295,076 449,129 2,075,412 3,695,030 298,141 63,135,121 Change from last month 10,038 11,470 29,194 (1,117) 91,164 978 (154,321) (606,060) (613,329) (248,018) (1,480,002) 2022 03 PY Month End Balances 11,099,221 6,401,270 8,840,166 9,819,593 406,735 288,364 560,964 1,193,422 4,097,407 104,692 42,811,835 Change from PY Month 20,723,374 (86,455) 16,042 (754,936) (1,929) 7,690 (266,156) 275,930 (1,015,707) (54,570) 18,843,285 2022 12 PYE Balances 31,647,797 6,279,910 8,797,711 9,068,010 132,287 292,305 2,256 452,071 3,432,876 129,794 60,371,702 Change from PYE 174,799 34,905 58,497 (3,352) 272,520 3,750 292,552 1,017,281 (351,175) (79,671) 1,283,417 IATreasuren Report\2023\2023-06 Treasurer's Report\AIl ImesMen6 202303 555 Page 12 of 12 Page 310 of 315