Loading...
HomeMy WebLinkAbout18 Treasurer's Report September AGENDA ITEM #18 Public Utility District m MEETING DATE: September 6, 2023 TO: Board of Directors FROM: Melanie Rives, Finance & Accounting Manager Michael Salmon, Chief Financial Officer SUBJECT: Approve the Treasurer's Report September 2023 ATTACHMENTS: 1. 2023-09 Treasurer's Report Page 1 of 1 Page 64 of 85 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT September 6, 2023 Fund Balances for the Month June 30, 2023 And Disbursements for the Month July 31, 2023 (includes Government Code section 53065.5 items) And Delinquent Accounts Write-offs Page 1 of 13 Page 65 of 85 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending June 30, 2023 and disbursements for July 2023. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS and Check Summary The attached listing of checks and ACH payments issued during July 2023 total $6,633,431.65 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 June 30, 2023 the balance in the General Fund was $17,444,016 (Electric $7,952,925 and Water $9,491,091). 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 and TVI Investments as of June 30, 2023 was $58,994,040 ($34,670,261 Electric and $24,323,779 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 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% April 2023 2.87% 2.65% 5.01% 4.57% 0.55% May 2023 2.99% 2.71% 5.06% 4.94% 0.55% June 2023 3.17% 2.71% 5.18% 5.14% 0.55% 6) DELINQUENT ACCOUNTS RECEIVABLE WRITE-OFF: In accordance with District Code section 3.12.020, the Treasurer has reviewed and approved the write-off of delinquent accounts receivables in the amount of$15,511.49. Refer to the last page of this report for details. Page 2 of 13 Page 66 of 85 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of July 2023 totaled $6,633,431.65. A listing of those disbursements is attached. AP DISBURSEMENTS METRICS (excludes Payroll): Accounts Payable (A/P) Metrics $ A/P Disbursements 7,000,000.00 — — 6,000,000.00 — 5,000,000.00 4,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 All, 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 13 Page 67 of 85 Truckee Donner Public Utility District Check Register CA July 2023 Gov.Code 53605.5 ChecklTren Date Tvice Vendor Vendor Name Item Reference Amount 5682 7/1/2023 WIRE 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE USE TAX PAYABLE $ 5,980.00 5681 7/3/2023 WIRE 905 HEALTHEQUITY INC. EMPLOYER HSA DEPOSIT 71,878.50 5672 7/5/2023 WIRE 10360 AFLAC EMPLOYEE PAID INSURANCE 928.16 5671 7/6/2023 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 240,285.36 5674 7/6/2023 WIRE 11233 CALPERS PENSION 65,283.80 5675 7/6/2023 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 06/30/2023 22,000.93 5676 7/6/2023 WIRE 3824 MISSIONSQUARE MISSIONSQUARE CONTRIBUTIONS PPE 06/30/23 34,303.93 5677 7/6/2023 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 06/30/2023 20,773.89 5678 7/6/2023 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 06/30/2023 112,310.07 5679 7/6/2023 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 06/30/23 1,246.22 38825 7/7/2023 DD 1537 AMAZON CAPITAL SERVICES,INC HARDWARE PURCHASES 476.29 38826 7/7/2023 DD 1516 C&D CONTRACTORS INC PIONEER TRAIL PIPELINE PROJECT 640,190.70 38827 7/7/2023 DD 9220 REGINA COOLEY 53605.5 EMPLOYEE DEVELOPMENT-TUITION REIMBURSEMENT 1,565.00 38828 7/7/2023 DD 577 COOPERATIVE RESPONSE CENTER INC. ANSWERING SERVICE 3,254.47 38829 7/7/2023 DD 1469 ECS IMAGING INC LICENSING,MAINTENANCE&SUPPORT 12,800.00 38830 7/7/2023 DD 5840 FERGUSON ENTERPRISES INC MATERIALS&SERVICES 203.25 38831 7/7/2023 DD 3340 GENERAL PACIFIC INC EMPLOYEE UNIFORMS 698.84 38832 7/7/2023 DD 3480 GRAINGER INC. MATERIALS&SERVICES 231.82 38833 7/7/2023 DD 3515 GRAYBAR ELECTRIC CO INC MATERIALS&SERVICES 123.41 38834 7/7/2023 DD 1116 HUNT&SONS,INC FUEL/OIL FOR VEHICLES 139.85 38835 7/7/2023 DD 38201BEW LOCAL 1245 UNION DUES-JULY 2023 7,146.74 38836 7/7/2023 DD 9510 EMPLOYEE VISION REIMBURSEMENT 84.00 38837 7/7/2023 DD 1305 JW WELDING SUPPLIES&TOOLS MATERIALS&SERVICES 414.28 38838 7/7/2023 DD 115 KIMBALL-MIDWEST REPAIRS&MAINTENANCE 1,886.73 38839 7/7/2023 DD 11025 MOONSHINE INK MARKETING 428.00 38840 7/7/2023 DD 617 MOUNTAIN EAP EMPLOYEE RELATIONS&WELLNESS PROGRAM 225.00 38841 7/7/2023 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 279.78 38842 7/7/2023 DD 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS&MAINTENANCE 389.40 38843 7/7/2023 DD 6403 NEVADA POWER COMPANY PURCHASED POWER-SPPC&NEVADA POWER 18,952.61 38844 7/7/2023 DD 10790'REI LILY AUTO PARTS REPAIRS&MAINTENANCE 481.69 38845 7/7/2023 DD 419 QCS LLC BUILDING MAINTENANCE 4,861.00 38846 7/7/2023 DD 9962 GRANT)SACKS* CELL PHONE CHARGES 180.00 38847 7/7/2023 DD 6402 SIERRA PACIFIC POWER CO PURCHASED POWER-SPPC&NEVADA POWER 49,428.55 38848 7/7/2023 DD 1357 SWIFT COMMUNICATIONS OF CALIFORNIA GENERAL ADVERTISEMENT 617.40 38849 7/7/2023 DD 26 THE BANK OF NEW Y0RK MELL0N DEBT PAYMENTS 207,320.37 38850 7/7/2023 DD 10584 LAMPS PURCHASED POWER-LAMPS 613,336.54 38851 7/7/2023 DD 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 318.74 38852 7/7/2023 DD 1546 WATERS CHIROPRACTIC DMV PHYSICAL-J.LEONARD 140.00 38853 7/7/2023 DD 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 496.00 133370 7/7/2023 CHK 134 ANIXTER INC. INVENTORY 15,831.29 133371 7/7/2023 CHK 657 AT&T COMMUNICATIONS 583.60 133372 7/7/2023 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 06/30/2023 115.38 133373 7/7/2023 CHK 1309 CMCTIRE,INC REPAIRS&MAINTENANCE 2,226.02 133374 7/7/2023 CHK 5661 DOORKING,INC BUILDING MAINTENANCE 43.95 133375 7/7/2023 CHK 348 EDGES ELECTRICAL GROUP MATERIALS&SERVICES 103.62 133376 7/7/2023 CHK 428 EDWARD R.BACON CO. REPAIRS&MAINTENANCE 824.00 133377 7/7/2023 CHK 78 FEDERAL EXPRESS CORPORATION FEDERAL EXPRESS CHARGES 36.34 133378 7/7/2023 CHK 1530 FORTRA,LLC LICENSING,MAINTENANCE&SUPPORT 13,941.94 133379 7/7/2023 CHK 341 HANSEN BROS.ENTERPRISES 2023 DISTRICT PIPELINE REPLACEMENT 530,446.86 133381 7/7/2023 CHK 11288 H0LT OF CALIFORNIA PORTABLE EMERGENCY BACKUP GENERATOR 155,033.39 133382 7/7/2023 CHK 9600 NEIL KAUFMAN* MEETING EXPENSES 719.74 133383 7/7/2023 CHK 1549 KS TELECOM,INC HARDWARE PURCHASES 9,998.00 133384 7/7/2023 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 484.34 133385 7/7/2023 CHK 1205 MICR0 MOTION INC PIONEER TRAIL PUMPSTATION PROJECT 4,120.95 133386 7/7/2023 CHK 2249 MOUNTAIN MAGIC CATERING MEETING EXPENSES 500.00 133387 7/7/2023 CHK 5151 NRECA INSURANCE 15,891.49 133388 7/7/2023 CHK 5150 NRECA GROUP BENEFITSTRUST INSURANCE 222,566.90 133389 7/7/2023 CHK 1534 RENTALGUYS MATERIALS&SERVICES 525.11 133390 7/7/2023 CHK 246 ROCK GARDEN MATERIALS&SERVICES 53.45 133391 7/7/2023 CHK 11302 SAGE LAND SURVEYING INC. 2024 PIPELINE REPLACEMENT DESIGN 447.50 133392 7/7/2023 CHK 10761 SOUTHWEST GAS CORP. UTILITIES:NATURAL GAS 446.52 133393 7/7/2023 CHK 173 STATE OF CALIFORNIA WITHHOLDING ORDER PPE 06/30/2023 100.00 133394 7/7/2023 CHK 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 2,864.43 133395 7/7/2023 CHK 7040 TEICHERT&SON INC CREDIT DE MATERIALS&SERVICES 2,219.17 133396 7/7/2023 CHK 11041 TRUCKEE PAINT MART INC. MATERIALS&SERVICES 5,469.66 133397 7/7/2023 CHK 1308 TRUCKEE TIRE REPAIRS&MAINTENANCE 160.82 5673 7/10/2023 WIRE 1359 CALPERS PENSION 10,000.00 38854 7/13/2023 DD 1393 ACWAJPIA PROPERTY INSURANCE JUL23-JUN24 178,218.79 38855 7/13/2023 DD 5440 ALTEC INDUSTRIES INC REPAIRS&MAINTENANCE 38.57 38856 7/13/2023 DD 1537 AMAZON CAPITAL SERVICES,INC HARDWARE PURCHASES 3,613.90 38857 7/13/2023 DD 9085 EMPLOYEE VISION REIMBURSEMENT 378.40 38858 7/13/2023 DD 11443 AUTOGLASS/MOTORSPORTS EXPRESS-TRUCKEE REPAIRS&MAINTENANCE 435.27 38859 7/13/2023 DD 515 BRAGG CRANE SERVICE CONTRACT SERVICES:ROW TREE CLEARING 3,405.35 38860 7/13/2023 DD 2263 CASHMAN EQUIPMENT COMPANY REPAIRS&MAINTENANCE 7,543.24 38861 7/13/2023 DD 10367 CCMEDIA MARKETING 1,375.00 38862 7/13/2023 DD 829 CDS GLOBAL REMITTANCE PROCESSING 823.14 38863 7/13/2023 DD 1251 CONSTRUCTION MATERIALS ENGINEERS,INC. 2023 CONSTRUCTION INSPECTION SERVICES 77,166.50 38864 7/13/2023 DD 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC XEROX COPIER LEASE 2,412.12 38865 7/13/2023 DD 1469 ECS IMAGING INC LICENSING,MAINTENANCE&SUPPORT 2,012.50 38866 7/13/2023 DD 640 EMPLOYER LYNX INC. PERSONNEL EXPENSES 125.00 38867 7/13/2023 DD 1167 ERPR,LLC PROFESSIONAL SERVICES:MARKETING 1,000.00 38868 7/13/2023 DD 9381 CHARLES GAZSO* 01/2023TO06/2023 CELL PHONE REIMBURSE 270.00 38869 7/13/2023 DD 3349 GLOBAL RENTAL CO INC RENTAL VEHICLE REPAIRS 1,443.01 38870 7/13/2023 DD 3515 GRAYBAR ELECTRIC CO INC MATERIALS&SERVICES 3,275.95 38871 7/13/2023 DD 778 HDR ENGINEERING INC ELECTRIC RATE STUDY 5,482.50 38872 7/13/2023 DD 1116 HUNT&SONS,INC FUEL/OIL FOR VEHICLES 6,460.51 38873 7/13/2023 DD 1149 LOOMIS BANKING CHARGES 715.23 38874 7/13/2023 DD 1099 MOANA NURSERY PROFESSIONAL SERVICES:OTHER 219.00 38875 7/13/2023 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 178.84 38876 7/13/2023 DD 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS&MAINTENANCE 1,990.68 38877 7/13/2023 DD 289 NISC JUNE 2023 RECURRING INVOICE 17,478.52 38878 7/13/2023 DD 10790'REI LILY AUTO PARTS REPAIRS&MAINTENANCE 607.87 Page 1of3 Page 4 of 13 Page 68 of 85 Truckee Donner Public Utility District Check Register CA July 2023 Gov.Code 53605.5 ChecklTren Date Tvoe Vendor Vendor Name Item Reference Amount 38879 7/13/2023 DD 775 ONLINE INFORMATION SERVICES CREDIT CHECK SERVICES 235.10 38880 7/13/2023 DD 758 PAMELA HURT ASSOCIATES EMPLOYEE DEVELOPMENT 12,162.50 38881 7/13/2023 DD 1512 PONDER ENVIRONMENTAL SERVICES INC ENVIRONMENTAL COMPLIANCE FEES 3,715.38 38882 7/13/2023 DD 5730 PORTER SIMON LEGAL SERVICES 5,300.00 38883 7/13/2023 DD 1372 POWER PARTNERS,LLC. PURCHASE TRANSFORMERS 6,824.08 38884 7/13/2023 DD 9962 EMPLOYEE VISION REIMBURSEMENT 325.50 38885 7/13/2023 DD 9950 ANABEL SANCHEZ EMPLOYEE DEVELOPMENT 75.22 38886 7/13/2023 DD 9944 JENNIFER SAWYER 53605.5 PARADE SUPPLIES 314.86 38887 7/13/2023 DD 837 SIERRA OFFICE SOLUTIONS XEROX COPIER LEASE 11.37 38888 7/13/2023 DD 1532 SLATE ROCK FR EMPLOYEE UNIFORMS 509.55 38889 7/13/2023 DD 716 SMALLP0ND STUDIO PROFESSIONAL SERVICES:MARKETING 3,878.75 38890 7/13/2023 DD 11304 STELLA-JONES CORPORATION INVENTORY 22,720.72 38891 7/13/2023 DD 5634 SURVEYMONKEY PERSONNEL EXPENSES 468.00 38892 7/13/2023 DD 6360 THATCHER COMPANY OF CALIFORNIA,INC WATER QUALITY:TREATMENT 8,654.82 38893 7/13/2023 DD 7176 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 76.60 38894 7/13/2023 DD 1176 TRUCKEE FAMILY EYECARE OPTOMETRY,INC VISION REIMBURSEMENT 1,295.00 38895 7/13/2023 DD 7300 TRUCKEE RENTS INC MATERIALS&SERVICES 17.31 38896 7/13/2023 DD 1183 TRUCKEE-CARSON IRRIGATION DISTRICT PURCHASED POWER-TCID 53,648.17 38897 7/13/2023 DD 1286 TYNDALE COMPANY INC EMPLOYEE UNIFORMS 605.04 38898 7/13/2023 DD 10380 ULINE FIELD SUPPLIES 398.90 38899 7/13/2023 DD 320 W&T GRAPHICS EMPLOYEE UNIFORMS 102.84 38900 7/13/2023 DD 1552 WBCP,INC JOB ADVERTISEMENT-EUD 20,228.61 38901 7/13/2023 DD 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 974.00 133398 7/13/2023 CHK 1162 ADM ASSOCIATES,INC. EMV:PROFESSIONAL SERVICE 23,031.25 133399 7/13/2023 CHK 6 ALPINE L0CK AND KEY BUILDING MAINTENANCE 110.00 133400 7/13/2023 CHK 134 ANIXTER INC. INVENTORY 5,386.52 133401 7/13/2023 CHK 657 AT&T COMMUNICATIONS 1,396.13 133402 7/13/2023 CHK 1527 AT&T MOBILITY CELL PHONE CHARGES 1,942.47 133403 7/13/2023 CHK 240 AUDIO ON-HOLD ON-HOLD PHONE SYSTEM 79.00 133404 7/13/2023 CHK 1073 CLEAN MACHINE REPAIRS&MAINTENANCE 700.00 133405 7/13/2023 CHK 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING,MAINTENANCE&SUPPORT 521.67 133406 7/13/2023 CHK 1553 CRANMER ENGINEERING INC WATER SAMPLE ANALYSIS 600.00 133407 7/13/2023 CHK 193 EASTERN REGIONAL LANDFILL LANDFILL CHARGES 196.95 133408 7/13/2023 CHK 9335 EMPLOYEE VISION REIMBURSEMENT 1,477.12 133409 7/13/2023 CHK 10645 GEI CONSULTANTS INC PROFESSIONAL SERVICES:OTHER 7,624.33 133410 7/13/2023 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS&SERVICES 678.98 133411 7/13/2023 CHK 1161 MADER SUPPLY,LLC PURCHASE TRANSFORMERS 66,496.64 133412 7/13/2023 CHK 468 MAITA CHEVROLET REPAIRS&MAINTENANCE 558.93 133413 7/13/2023 CHK 1205 MICRO MOTION INC MATERIALS&SERVICES 3,939.61 133414 7/13/2023 CHK 970 NORTHERN CALIFORNIA JOINT POLE ASSN MEMBERSHIP DUES 10.03 133415 7/13/2023 CHK 5151 NRECA HEALTH 125 ADMINISTRATIVE FEES 472.50 133416 7/13/2023 CHK 52220DP BUSINESS SOLUTIONS LLC OFFICE SUPPLIES 2,194.93 133417 7/13/2023 CHK 1540 P31 ENTERPRISES CONTRACT SERVICES:ROW TREE CLEARING 156,507.24 133418 7/13/2023 CHK 9980 EMPLOYEE VISION REIMBURSEMENT 265.00 133419 7/13/2023 CHK 999 RYANBUILT,INC REFUND FACILITY FEES 1,260.00 133420 7/13/2023 CHK 6273 SAUERS ENGINEERING INC 6170 TANK IN EW) 3,125.00 133421 7/13/2023 CHK 675 SHERWIN-WILLIAMS MATERIALS&SERVICES 49.41 133422 7/13/2023 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY WATER SAMPLE ANALYSIS 25.00 133423 7/13/2023 CHK 7040 TEICHERT&SON INC CREDIT DE MATERIALS&SERVICES 2,825.83 133424 7/13/2023 CHK 548 THE AUTO&TIRE DOCTOR INC. REPAIRS&MAINTENANCE 1,721.22 133425 7/13/2023 CHK 10050 T0WN OF TRUCKEE PROFESSIONAL SERVICES:STRATEGIC PLAN 30,000.00 133426 7/13/2023 CHK 7175 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 12.37 133427 7/13/2023 CHK 11041 TRUCKEE PAINT MART INC. MATERIALS&SERVICES 78.28 133428 7/13/2023 CHK 7315 TRUCKEE SANITARY DISTRICT UTILITIES:SEWER 1,542.24 133429 7/13/2023 CHK 1435 TRUCKEE TAHOE WORKFORCE HOUSING AGENCY PROFESSIONAL SERVICES:OTHER 25,651.00 133430 7/13/2023 CHK 7380 UNITED PARCEL SERVICE UPS CHARGES 135.00 133431 7/13/2023 CHK 10175 WHITECAP,L.P. MATERIALS&SERVICES 3,510.56 5684 7/20/2023 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 241,660.99 5686 7/20/2023 WIRE 3824 MISSIONSQUARE MISSIONSQUARE CONTRIBUTIONS PPE 07/14/23 31,549.16 5687 7/20/2023 WIRE 11233 CALPERS PENSION 69,747.56 5688 7/20/2023 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 07/14/2023 109,706.28 5689 7/20/2023 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 07/14/2023 20,797.88 5690 7/20/2023 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 07/14/23 1,246.22 5691 7/20/2023 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 07/14/2023 21,616.81 38984 7/20/2023 DD 1393 ACWAJPIA CYBER LIABILITY INS.JUL23-JUN24 14,024.00 38985 7/20/2023 DD 5440 ALTEC INDUSTRIES INC REPAIRS&MAINTENANCE 17,836.50 38986 7/20/2023 DD 1537 AMAZON CAPITAL SERVICES,INC OFFICE SUPPLIES 326.50 38987 7/20/2023 DD 9086 EMPLOYEE VISION REIMBURSEMENT 249.96 38988 7/20/2023 DD 9503810 CDW GOVERNMENT INC. HARDWARE PURCHASES 3,438.46 38989 7/20/2023 DD 1496 DIRECT TECHNOLOGY PROFESSIONAL SERVICES:PROGRAM DELIVERY 3,600.00 38990 7/20/2023 DD 10650 EUR0FINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 110.00 38991 7/20/2023 DD 3480 GRAINGER INC. MATERIALS&SERVICES 513.65 38992 7/20/2023 DD 1116 HUNT&SONS,INC FUEL/OIL FOR VEHICLES 5,668.79 38993 7/20/2023 DD 11025 MOONSHINE INK MARKETING 428.00 38994 7/20/2023 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 179.72 38995 7/20/2023 DD 6403 NEVADA POWER COMPANY REFUND CREDIT PAID BY NVE IN ERROR 19,507.09 38996 7/20/2023 DD 494 NVS,INC. GEOTECH TESTING SERVICES 15,342.26 38997 7/20/2023 DD 10790'REI LILY AUTO PARTS REPAIRS&MAINTENANCE 68.36 38998 7/20/2023 DD 820 ONESOURCE DISTRIBUTORS INVENTORY 759.06 38999 7/20/2023 DD 9920 EMPLOYEE VISION REIMBURSEMENT 335.00 39000 7/20/2023 DD 419 QCS LLC MATERIALS&SERVICES 979.47 39001 7/20/2023 DD 9962 EMPLOYEE VISION REIMBURSEMENT 585.00 39002 7/20/2023 DD 10414 SNAP-ON INDUSTRIAL RC TOOL ALLOWANCE 34.61 39003 7/20/2023 DD 349 STRADLING YOCCA CARLSON&RAUTH P.C. GC MR AN N UAL ADMIN COSTS 1,577.90 39004 7/20/2023 DD 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 142.89 39005 7/20/2023 DD 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 230.05 39006 7/20/2023 DD 1328 TRAFFIC MANAGEMENT,INC. TRAFFIC CONTROL SERVICES 2,848.00 39007 7/20/2023 DD 712 TRUCKEE DONNER PUD PURCHASED POWER-STAMPEDE HYDRO GENERAT 53,682.91 39008 7/20/2023 DD 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 318.74 39009 7/20/2023 DD 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 38,396.44 39010 7/20/2023 DD 1538 USA FLEET SOLUTIONS MISC PARTS&SUPPLIES 2,765.40 39011 7/20/2023 DD 320 W&T GRAPHICS EMPLOYEE UNIFORMS 878.73 Page 2of3 Page 5 of 13 Page 69 of 85 Truckee Donner Public Utility District Check Register CA July 2023 Gov.Code 53605.5 ChecklTren Date Tvoe Vendor Vendor Name Item Reference Amount 39012 7/20/2023 DO 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 1,064.00 39013 7/20/2023 DO 7820 WESTERN NEVADA SUPPLY CO INVENTORY 3,409.60 39014 7/20/2023 DO 9948 EMPLOYEE VISION REIMBURSEMENT 335.00 133432 7/20/2023 CHK 99999 ALTON BROWN HOLDINGS,LLC CUSTOMER REFUND-CLOSEDACCOUNT 232.10 133433 7/20/2023 CHK 134 ANIXTER INC. INVENTORY 27,088.76 133434 7/20/2023 CHK 99999 PATRIC ASHBY CUSTOMER REFUND-CLOSEDACCOUNT 394.56 133435 7/20/2023 CHK 99999 MISS ELISE C BLENDHEIM CUSTOMER REFUND-CLOSEDACCOUNT 273.43 133436 7/20/2023 CHK 747 CALFIRE MATERIALS&SERVICES 794.78 133437 7/20/2023 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 07/14/2023 115.38 133438 7/20/2023 CHK 99999 MIKE CIRIC CUSTOMER REFUND-CLOSED ACCOUNT 49.04 133439 7/20/2023 CHK 492 CROSNO CONSTRUCTION INC. 6170 TANK(NEW) 500,839.26 133440 7/20/2023 CHK 348 EDGES ELECTRICAL GROUP MATERIALS&SERVICES 67.98 133441 7/20/2023 CHK 99999 LAWRENCE R HORN CUSTOMER REFUND-CLOSED ACCOUNT 60.54 133442 7/20/2023 CHK 1210 IMPACT EQUIPMENT COMPANY REPAIRS&MAINTENANCE 185.60 133443 7/20/2023 CHK 109321&LFOOD MART&CARWASH FUEL/OIL FOR VEHICLES 417.50 133444 7/20/2023 CHK 10936 LAKESIDE SPECIALIZED TRANSPORTATION MATERIALS&SERVICES 754.11 133445 7/20/2023 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 3,524.74 133446 7/20/2023 CHK 468 MAITA CHEVROLET REPAIRS&MAINTENANCE 221.46 133447 7/20/2023 CHK 99999 RILEY J MUSCAT CUSTOMER REFUND-CLOSED ACCOUNT 100.80 133448 7/20/2023 CHK 1349 NEVADA COUNTY AUDITOR PROFESSIONAL SERVICES:OTHER 42,501.00 133449 7/20/2023 CHK 99999 TANIA PILKINTON CUSTOMER REFUND-CLOSED ACCOUNT 115.44 133450 7/20/2023 CHK 462 POWERPLAN-OIB REPAIRS&MAINTENANCE 186.88 133451 7/20/2023 CHK 99999 S+B JAMES CONSTRUCTION CALIFORNIA CUSTOMER REFUND-CLOSED ACCOUNT 231.48 133452 7/20/2023 CHK 11302 SAGE LAND SURVEYING INC. WATER STORAGE TANK ENGINEERING 2021 3,305.00 133453 7/20/2023 CHK 10720 SNOQUIP REPAIRS&MAINTENANCE 751.90 133454 7/20/2023 CHK 173 STATE OF CALIFORNIA WITHHOLDING ORDER PPE 07/14/2023 100.00 133455 7/20/2023 CHK 99999 TAHOE SIGNATURE PROPERTIES CUSTOMER REFUND-CLOSED ACCOUNT 253.61 133456 7/20/2023 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY UTILITIES:SEWER 3,904.56 133457 7/20/2023 CHK 7040 TEICHERT&SON INC CREDIT DE MATERIALS&SERVICES 3,399.73 133458 7/20/2023 CHK 7290 TRUCKEE OVERHEAD DOOR BUILDING MAINTENANCE 1,281.50 133459 7/20/2023 CHK 11041 TRUCKEE PAINT MART INC. MATERIALS&SERVICES 712.77 5693 7/25/2023 WIRE 10360 AFLAC EMPLOYEE PAID INSURANCE 928.16 5685 7/26/2023 WIRE 11233 CALIPERS PENSION 1,141,017.00 5694 7/26/2023 WIRE 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE ELECTRICAL ENERGYSURCHARGE RETURN 13,466.00 5695 7/28/2023 WIRE 11233 CALIPERS PENSION 1,117.05 5696 7/28/2023 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9921 FINAL 979.21 5697 7/28/2023 WIRE 3824 MISSIONSQUARE MISSIONSQUARE CONTRIBUTIONS 9921 FINAL 1,982.24 5698 7/28/2023 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDINGS 9921 FINAL 3,958.60 39015 7/28/2023 DO 856 ACLARA TECHNOLOGIES LLC LICENSING,MAINTENANCE&SUPPORT 6,196.00 39016 7/28/2023 DO 1393 ACWAJPIA WORKER'S COMP Q42023 68,646.17 39017 7/28/2023 DO 1537 AMAZON CAPITAL SERVICES,INC MATERIALS&SERVICES 1,404.96 39018 7/28/2023 DO 9503810 COW GOVERNMENT INC. HARDWARE PURCHASES 256.68 39019 7/28/2023 DO 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,800.00 39020 7/28/2023 DID 361 FIRST CHOICE SERVICES FACILITY SUPPLIES 228.65 39021 7/28/2023 DO 10257 GIVES LLC MATERIALS&SERVICES - 39022 7/28/2023 DO 3480 GRAINGER INC. MATERIALS&SERVICES 491.21 39023 7/28/2023 DO 3515 GRAYBAR ELECTRIC CO INC MATERIALS&SERVICES 1,679.47 39024 7/28/2023 DO 277 HACH COMPANY MATERIALS&SERVICES 726.01 39025 7/28/2023 DO 115 KIMBALL-MIDWEST FACILITY SUPPLIES 152.23 39026 7/28/2023 DO 9738 ZACKARY MEYERS* EMPLOYEE DEVELOPMENT 708.00 39027 7/28/2023 DO 965 MOSS ADAMS LLP PROFESSIONAL SERVICES:AU DIT 7,000.00 39028 7/28/2023 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS&SERVICES 134.49 39029 7/28/2023 DO 5130 NCPA MEMBERSHIP DUES 16,259.00 39030 7/28/2023 DO 6403 NEVADA POWER COMPANY PURCHASED POWER-SPPC&NEVADA POWER 44,163.97 39031 7/28/2023 DO 1079 O'REI LILY AUTO PARTS MISC PARTS&SUPPLIES 496.71 39032 7/28/2023 DO 1541 PAVEMENT COATINGS,CO CONTRACT SVCS:PAVING/SLURRY 51,917.50 39033 7/28/2023 DO 1512 PONDER ENVIRONMENTAL SERVICES INC ENVIRONMENTAL COMPLIANCE FEES 663.00 39034 7/28/2023 DO 1550 REXEL ENERGY SOLUTIONS EV CHARGING STATION 4,710.05 39035 7/28/2023 DO 9942 BENJAMIN SILVA* EMPLOYEE DEVELOPMENT 708.00 39036 7/28/2023 DO 1787 SILVER STATE INTERNATIONAL TRUCKS REPAIRS&MAINTENANCE - 39037 7/28/2023 DO 6604 SPIEGEL&MC DIARMID PROFESSIONAL SERVICES:FERC ISSUES 2,527.50 39038 7/28/2023 DO 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 83.35 39039 7/28/2023 DO 1062 TESSCO INCORPORATED MATERIALS&SERVICES 11.03 39040 7/28/2023 DO 1328 TRAFFIC MANAGEMENT,INC. TRAFFIC CONTROL SERVICES 2,574.00 39041 7/28/2023 DO 4590 UNDERGROUND SERVICE ALERT OF NORTHERN CA MEMBERSHIP DUES 2,750.37 39042 7/28/2023 DO 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 318.74 39043 7/28/2023 DO 7820 WESTERN NEVADA SUPPLY CO INVENTORY 2,770.06 133460 7/28/2023 CHK PL PAYROLL PAYROLL FINAL CHECK 5,887.56 133461 7/28/2023 CHK 134 ANIXTER INC. INVENTORY 3,815.27 133462 7/28/2023 CHK 657 AT&T COMMUNICATIONS 90.68 133463 7/28/2023 CHK 99999 GARYW BOYD CUSTOMER REFUND-CLOSEDACCOUNT 83.17 133464 7/28/2023 CHK 381 CAL-NEVADA TOWING REPAIRS&MAINTENANCE 525.00 133465 7/28/2023 CHK 99999 MIKE CIRIC CUSTOMER REFUND-CLOSED ACCOUNT 66.51 133466 7/28/2023 CHK 1073 CLEAN MACHINE REPAIRS&MAINTENANCE 840.00 133467 7/28/2023 CHK 99999 MR JAMES H CLIFFORD III CUSTOMER REFUND-CLOSED ACCOUNT 129.92 133468 7/28/2023 CHK 348 EDGES ELECTRICAL GROUP 6170 TAN K(N EW) 635.04 133469 7/28/2023 CHK 78 FEDERAL EXPRESS CORPORATION FEDERAL EXPRESS CHARGES 142.49 133470 7/28/2023 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS&SERVICES 658.03 133471 7/28/2023 CHK 1067 LAKESIDE PAVING&SEALING CONTRACT SVCS:PAVING/SLURRY 3,213.50 133472 7/28/2023 CHK 99999 MARJORIE MATTHEWS CUSTOMER REFUND-CLOSED ACCOUNT 14.86 133473 7/28/2023 CHK 675 SHERWIN-WILLIAMS MATERIALS&SERVICES 39.66 133474 7/28/2023 CHK 99999 NICK STEENSON CUSTOMER REFUND-CLOSED ACCOUNT 227.04 133475 7/28/2023 CHK 242 THOLL FENCE INC. BUILDING MAINTENANCE 3,655.00 133476 7/28/2023 CHK 7320 TRUCKEE TAHOE LUMBER CO MATERIALS&SERVICES 179.65 133477 7/28/2023 CHK 10284 UNITED RENTALS MATERIALS&SERVICES 2,184.49 133478 7/28/2023 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 4,640.26 270 $ 6,633,431.65 *Denotes employee reimbursement containing multiple items with no individual item charge of$100 or greater. Page 3 of Page 6 of 13 Page 70 of 85 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 06/30/2023 Page 1 of 2 Electric Dept Water Dept Total Balance in General Fund 05/31/2023 $8,242,090 $9,071,761 $17,313,851 Receipts: Revenue received $2,538,934 $1,239,303 $3,778,237 Retired employees medical insurance 23,179 - 23,179 Record interest earned 15,176 2,652 17,827 Transfer from Vehicle Reserve 10,130 - 10,130 Reimbursement for COP funded projects - 1,702,095 1,702,095 FF Funding&DL Surcharge Reimbursement for 2006 COP&6170 Tank - 121,376 121,376 Cash clearing accounts(timing-prior month reversal) (192,666) - (192,666) Cash clearing accounts(timing-current month) 77,266 - 77,266 Total Receipts $2,472,019 $3,065,426 $5,537,446 Disbursements: Accounts payable/payroll disbursements $2,682,950 $2,566,477 $5,249,427 Distribute UPTIF interest 23,136 14,181 37,317 Restrict facilities fees 20,682 56,140 76,822 Restrict Donner Lake surcharge - 9,298 9,298 Section 125 benefit disbursement 24,464 - 24,464 Bank charges 9,953 9,953 Total Disbursements $2,761,184 $2,646,096 $5,407,281 Balance in General Fund 06/30/2023 $7,952,925 $9,491,091 $17,444,016 7/28/2023 2:06 PM I:\Treasurers Repo rt\Statement of General Fund\2023\2023-06 GF Page 7 of 13 Page 71 of 85 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 06/30/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 77,266 - 77,266 U.S. Bank-General Fund 3,590,549 - 3,590,549 LAIF, UPTIF, PCIF, &TVI -General Fund 4,282,710 9,491,091 13,773,802 Total $7,952,925 $9,491,091 $17,444,016 Market Adjustment (826,008) (648,853) (1,474,861) Total Non-Restricted Funds $7,126,917 $8,842,238 $15,969,156 Distribution of Designated&Restricted Funds at Month-End: LAIF, UPTIF, PCIF&TVI-Restricted Funds $27,572,608 $14,602,157 $42,174,765 UPTIF-Donner Lake Assessment District - 80,306 80,306 2015 COP Water Bonds, Principal Payment Fund - 491,012 491,012 2022 COP Issuance/Payment Fund 143,871 264,894 408,764 U S Bank-Donner Lake Assessment District 00-1 - 43,171 43,171 Total $27,716,478 $15,481,541 $43,198,019 Market Adjustment (173,135) - (173,135) Total Restricted Funds $27,543,344 $15,481,541 $43,024,884 Total Funds Available $34,670,261 $24,323,779 $58,994,040 Total Market Adjustments (999,143) (648,853) (1,647,996) 7/28/2023 2:06 PM I:\Treasurers Repo rt\Statement of General Fund\2023\2023-06 GF Page 8 of 13 Page 72 of 85 INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/2023 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2022 5/31/2023 Activity 6/30/2023 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND(LAIF)-3.17%(2.99%) General Fund 1..136.1 $ 1,710,862 $ 472,514 $ 1,234,910 $ 1,707,424 Consolidate cash 1,327,174 Reimburse for Horse Butte Power (92,264) Capital Replacement Fund 1..136.41 2,489,566 2,519,553 - 2,519,553 AB 32 Cap&Trade Fund 1..136.58 579,554 670,998 92,264 763,262 Reimbursement from GF for Horse Butte Power 92,264 Deferred Liabilities Reserve 1..136.42 2,107,871 2,133,262 2,133,262 LCFS Credits 1..136.59 68,049 74,246 74,246 2022 COP Project Fund 1..132.95 6,544,562 6,623,283 6,623,283 Total LAIF Electric Investments 13,500,465 12,493,856 1,327,174 13,821,029 UTAH PUBLIC TREASURERS'INVESTMENT FUND(UPTIF)- 5.18%(5.06%) General Fund 1..136.12 1,291,337 2,603,165 (27,879) 2,575,286 Distribute UPTIF interest (23,136) Restrict facility fees (20,682) Record monthly interest 11,429 TVI Interest Receivable (5,620) Reimbursement from VR for rental vehicle costs 10,130 Facilities Fees 1..136.9 185,084 219,052 21,643 240,695 Restrict facilites fees 20,682 Record monthly interest 962 Electric Rate Reserve Fund 1..136.45 2,478,957 374,187 3,516 377,703 Record monthly interest 1,643 TVI Interest Receivable 1,873 Capital Replacement Fund 1..136.46 767,865 792,508 7,226 799,734 Record monthly interest 3,479 TVI Interest Received 3,747 Electric Vehicle Reserve 1..136.13 770,416 1,547,222 (3,337) 1,543,885 Record monthly interest 6,793 Transfer to GF for rental vehicle costs (10,130) Total UPTIF Electric Investments 5,493,659 5,536,134 1,169 5,537,304 PLACER COUNTY INVESTMENT FUND(PCIF)- 2.71%(2.71%) Electric Rate Reserve Fund 1..136.47 2,366,422 2,389,302 5,499 2,394,801 Record monthly interest 5,499 Capital Replacement Fund 1..136.48 4,086,623 4,126,136 9,497 4,135,634 Record monthly interest 9,497 Total PCIF County Electric Investments 6,453,045 6,515,438 14,996 6,530,435 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,511,979 $ 1,343,339 $ 31,855,318 8/11/20234:07 PM Investments Status Report Page 9 of 13 I:\Tr....rers Report\In vestment Status Reports\2023\2023-06 In...- tus-Sta Report Page 1 of 3 Page 73 of 85 INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/2023 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2022 5/31/2023 Activity 6/30/2023 WATER FUNDS LOCAL AGENCY INVESTMENT FUND(LAIF)-3.17%(2.99%) General Fund 2..136.1 3,363,862 4,471,565 318,781 4,790,346 Consolidate cash (1,327,174) Restrict facility fees (56,140) Reimburse GF for 2022 COP funded projects 1,702,095 Facilities Fees 2..136.90 1,542,637 1,748,756 56,140 1,804,896 Restrict facility fees 56,140 Capital Replacement Fund 2..136.41 3,375 3,412 3,412 2022 COP Project Fund 2..132.95 11,879,665 11,942,429 (1,702,095) 10,240,334 Transer to GF for COP funded projects (1,702,095) Total LAIF Water Investments 16,789,539 18,166,163 (1,327,174) 16,838,989 UTAH PUBLIC TREASURERS'INVESTMENT FUND(UPTIF)- 5.18%(5.06%) General Fund 2..136.12 322,338 604,025 100,549 704,574 Transfer to DLAD surcharge (9,298) Distribute UPTIF interest (14,181) DL Surcharge Reimbursement for 2006 COP 8,153 FF Funding portion of 2006 COP 29,889 FF Funding portion of 6170 Tank 83,333 Record monthly interest 2,652 Facilities Fees 2..136.25 1,089,150 539,152 (110,855) 428,297 Record monthly interest 2,367 Transfer to GF for FF Funding portion of 2006 COP (29,889) Transfer to GF for FF Funding portion of 6170 Tank (83,333) West River St.Assessment District 2..136.31 38,801 39,535 174 39,709 Record monthly interest 174 Prepaid Connection Fees 2..136.7 79,292 80,793 355 81,148 Record monthly interest 355 Donner Lake Assessment District Fund 2..136.84 78,470 79,955 351 80,306 Record monthly interest 351 Donner Lake Assessment District Surcharge Fund 2..136.61 177,548 186,540 1,964 188,503 DLAD surcharge collections 9,298 DL Surcharge Reimbursement to GF for 2006 COP (8,153) Record monthly interest 819 TSA SAD II Improvement Fund 2..136.85 18,718 19,072 84 19,156 Record monthly interest 84 Water Vehicle Reserve 2..136.13 382,735 640,795 2,813 643,609 Record monthly interest 2,813 Deferred Liabilites Reserve 2..136.42 108,280 110,329 484 110,814 Record monthly interest 484 Capital Replacement Fund 2..136.46 1,018,446 1,037,723 4,556 1,042,279 Record monthly interest 4,556 Total UPTIF Water Investments 3,313,777 3,337,921 474 3,338,395 PLACER COUNTY INVESTMENT FUND(PCIF)- 2.71%(2.71%) 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,500,255 $ (1,326,700) $ 24,173,555 8/11/20234:07 PM Investments Status Report Page 10 of 13 I:\Treasurers Report\Investment Status Reports\2023\2023-06 I nvestm-Status Report Page 2 of 3 Page 74 of 85 INVESTMENT STATUS REPORT Activity for the Month Ended 6/3 012 0 2 3 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2022 5/31/2023 Activity 6/30/2023 ELECTRIC&WATER INVESTMENTS,COMBINED TOTALS Pre-Market Adjustments Total LAIF Investments 55% 30,290,004 30,660,019 - 30,660,019 Total UPTIF Investments 16% 8,807,436 8,874,055 1,644 8,875,698 Total PCIF Investments 12% 6,453,045 6,515,438 14,996 6,530,435 Total TVI Investments 18% 9,962,722 9,962,722 9,962,722 Total Investments 100% Month End Bal.Mix $ 45,550,484 $ 56,012,235 $ 16,639 $ 56,028,873 Market Adjustments Total t.AIF 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) (900,299) (1,117) (901,417) Total Investments $ (1,641,291) $ (1,646,878) $ (1,117) $ (1,647,996) Post-Market Adjustments Total t.AIF Investments 54% 29,726,284 30,096,299 - 30,096,299 Total UPTIF Investments 16% 8,797,711 8,864,330 1,643 8,865,973 Total PCIF Investments 12% 6,279,910 6,342,304 14,996 6,357,300 Total TVI Investments 18% 9,068,010 9,062,422 (1,117) 9,061,305 Total Investments 100% Month End Bal.Mix $ 53,871,915 $ 54,365,355 $ 15,522 $ 54,380,877 8/11/20234:07 PM Investments Status Report Page 11 of 13 I:\Treasurers Report\Investment Status Repons\2023\2023-06 Investments Status Report Page 3 of 3 Page 75 of 85 TRUCKEE DONNER PUD INVESTMENT BALANCES as of June 30,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 $ 1,707,424 $ - $ 2,575,286 $ - $ - $ - $ - $ - $ 3,590,549 $ 79,666 $ 7,952,925 Facilities Fees - 240,695 - - 240,695 Electric Rate Reserve - 2,394,801 377,703 2,000,000 - - - - - - 4,772,504 Capital Replacement Fund 2,519,553 4,135,634 799,734 3,966,550 - - - - - - 11,421,471 Deferred Liabilites Reserve/POB Fund 2,133,262 - - - - - - - - - 2,133,262 Electric Vehicle Reserve - 1,543,885 1,543,885 AB 32 Fund 763,262 - - - - - - - - - 763,262 LCFS Credits 74,246 - - - - - - - - - 74,246 COP Project Fund 6,623,283 6,623,283 COP Issuance/Payment Fund - - - - - - - 143,871 - - 143,871 Market Adjustments 239,310 173,135 6,066 580,632 999,143 Total Electric Investments 13,581,719 6,357,300 5,531,238 5,385,918 143,871 3,590,549 79,666 34,670,261 WATER FUNDS General Fund $ 4,790,346 $ - $ 704,574 $ 3,996,171 $ $ $ $ $ $ 9,491,091 Facilities Fees 1,804,896 - 428,297 - - - - - - - 2,233,193 Capital Replacement Fund 3,412 - 1,042,279 - - - - - - - 1,045,692 2015 COP Funds - - - - 491,012 - - - - - 491,012 DSC and Operating Reserve Fund - - - - - - - - - - - West River St.Assessment District 39,709 39,709 Deferred Liabilites Reserve - - 110,814 - - - - - - - 110,814 Prepaid Connection Fees - - 81,148 - - - - - - - 81,148 DLAD Fund - - 80,306 - - - - - 43,171 - 123,477 DLAD Surcharge 188,503 - 188,503 SRF Reserve and Payment Fund - - - - - - - - - - - TSA SAD II Improvement Fund - - 19,156 - - - - - - - 19,156 Water Vehicle Reserve 643,609 643,609 Restricted Grant Funds - - - - - - - - - - - COP Project Funds 10,240,334 - - - - - - - - - 10,240,334 COP Issuance/Payment Fund - - - - - - - 264,894 - - 264,894 Market Adjustments 324,409 3,659 320,785 648,853 Total Water Investments 16,514,580 3,334,735 3,675,387 491,012 264,894 43,171 24,323,779 Electric and Water,subtotal 30,096,299 6,357,300 8,865,973 9,061,305 491,012 408,764 3,633,720 79,666 58,994,040 MELLO ROOS-OLD GREENWOOD - - - - - 299,378 651,887 - - - 951,266 Total Mello Roos-Old Greenwood 299,378 651,887 951,266 MELLO ROOS-GRAY'S CROSSING 1,944,569 - - 1,818,123 3,762,692 Total Mello Roos-Gray's Crossing 1,944,569 1,818,123 3,762,692 Total Investments $ 32,040,868 $ 6,357,300 $ 8,865,973 $ 9,061,305 $ 491,012 $ 299,378 $ 651,887 $ 2,226,888 $ 3,633,720 $ 79,666 $ 63,707,998 202305 Last Month End Balances 32,040,868 6,342,304 8,864,330 9,062,422 398,969 298,246 650,302 2,105,327 5,014,516 195,066 64,972,350 Change from last month - 14,996 1,643 (1,117) 92,043 1,133 1,585 121,561 (1,380,797) (115,399) (1,264,352) 202206 PY Month End Balances 1,911,418 - - - - - - 2,090,037 - - 4,001,455 Change from PY Month 30,129,450 6,357,300 8,865,973 9,061,305 491,012 299,378 651,887 136,851 3,633,720 79,666 59,706,543 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 393,071 77,390 68,262 (6,704) 358,725 7,073 649,631 1,774,817 200,844 (50,128) 3,336,296 I:\Treasurers Re n\2023\202-9Treazurer'z Rep-Wl Inre--202306 SS6 Page 12 of 13 Page 76 of 85 TRUCKEE DONNER PUBLIC UTILITY DISTRICT WRITE OFF OF DELINQUENT ACCOUNTS CLOSED PRIOR TO January 1, 2023 July 20, 2023 CUSTOMER NAME AMOUNT GLEN SILLEMAN $ 180.78 SIERRA VILLAGE APARTMENT HOMI $ 10.16 HELEN D SMITH $ 164.42 WILLIAM MARTIN $ 185.91 RENEE PATERRA $ 260.94 ROBERT SUNDEEN $ 248.12 ROBERT COHORST $ 141.20 SARAH LUPYAK $ 303.35 RETHA JOHNSON $ 224.16 STANLEY CHARLES $ 675.36 JACK FABER $ 160.46 LUIS INIGUEZ $ 26.43 PATRICK LITTEK $ 338.05 MASON HULEN $ 6,052.41 CHRIS WHITE $ 411.35 VEEDER VIEW LLC $ 294.93 MAX WITTENBERG $ 304.68 ENRIQUE PRECIADO $ 867.04 ANA MARIA REA LOPEZ $ 73.95 RYAN NGUYEN $ 379.26 DAVID KANT $ 74.76 SONJA WENZEL $ 23.99 HENRY PORSCHE $ 1,802.03 CINDI CONWAY $ 167.62 ANITA SCHU $ 165.29 DUSTIN BURKETT $ 1,462.44 MARIO ESTRADA $ 110.28 KRISTEN COSTA $ 50.77 KRISTIN JOHNSON $ 23.32 DEE AMOS $ 149.87 REYNA VANDAMME $ 0.94 JUSTIN JONES $ 69.24 JOSHUA MARQUEZ $ 107.98 MELANIE Y KOMB $ 121.62 WILLIAM LANG $ 120.33 TOTAL WRITE-OFF $ 15,511.49 Page 13 of 13 Page 77 of 85