Loading...
HomeMy WebLinkAbout18 Treasurers Report - Cover Pagep' TRUCKEE DONNER Public Utility District MEETING DATE: October 6, 2021 TO: Board of Directors AGENDA ITEM #18 FROM: Michael Salmon, Chief Financial Officer SUBJECT: Approve the Treasurer's Report: July 31, 2021 & August 31, 2021 Page 1 of 1 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT October 6, 2021 Fund Balances for the Month Ended July 31, 2021 And Disbursements for the Month August 31, 2021 Page 1 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending July 31, 2021 and disbursements for August 2021. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for August 2021 were $3,696,876.44. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during August 2021 total $3,696,876.44. 3) STATEMENT OF GENERAL FUND: As of July 31, 2021 the balance in the General Fund was $16,396,809 (Electric $11,996,449 and Water $4,400,360). 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 July 2021 was $36,935,574 ($26,949,441 Electric and $9,986,134 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 July 2020 0.92% 0.89% 0.74% 0.11 % August 2020 0.78% 0.74% 0.53% 0.12% September 2020 0.69% 0.57% 0.55% 0.12% October 2020 0.62% 0.60% 0.52% 0.13% November 2020 0.58% 0.49% 0.52% 0.11 % December 2020 0.54% 0.32% 0.49% 0.10% January 2021 0.46% 0.29% 0.47% 0.10% February 2021 0.41 % 0.26% 0.45% 0.08% March 2021 0.36% 0.24% 0.43% 0.07% April 2021 0.34% 0.23% 0.42% 0.05% May 2021 0.32% 0.24% 0.40% 0.05% June 2021 0.26% 0.19% 0.37% 0.08% 0.55% July 2021 0.22% 0.21 % 0.36% 0.07% 0.55% Page 2 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of August 2021 totaled $3,696,876.44. A listing of those disbursements is attached. AP DISBURSEMENTS METRICS: 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 1,000,000.00 0.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2018 ■ 2019 ■ 2020 2021 # A/P Payments Issued 400 350 300 250 200 — 150 100 50 0 Jan Feb Mar Apr May Jun Jul Aug Sep ■ 2018 ■ 2019 ■ 2020 - 2021 # A/P Invoices Vouchered 1000 — 800 600 — 400 — 200 Ilk 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2018 ■ 2019 ■ 2020 ■ 2021 Page 3 of 12 Truckee Donner Public Utility District Check Register August 2021 Check/Tran Date Type Vendor Vendor Name Reference Amount 5065 8/5/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 07/30/21 $ 623.93 5064 8/5/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 07/30/2021 18,652.49 5061 8/5/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS PPE 07/30/2021 20,962.80 5066 8/5/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 07/30/2021 22,515.03 5062 8/5/2021 WIRE 11233 CALPERS PENSION 51,063.31 5063 8/5/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 07/30/2021 97,341.43 5060 8/5/2021 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 194,084.38 31789 8/6/2021 DD 1079 O'REI LILY AUTO PARTS MISC PARTS & SUPPLIES - 130593 8/6/2021 CHK 10761 SOUTHWEST GAS CORP. UTILITIES: NATURAL GAS 34.11 130579 8/6/2021 CHK 78 FEDERAL EXPRESS CORPORATION FEDERAL EXPRESS CHARGES 37.24 130576 8/6/2021 CHK 5661 DOORKING, INC CELL PHONE CHARGES 41.95 130591 8/6/2021 CHK 716 SMALLPOND STUDIO PROFESSIONAL SERVICES: MARKETING 54.13 130599 8/6/2021 CHK 99999 TRUCKEE TAHOE HOME IMPROVEMENT LLC CUSTOMER REFUND -CLOSED ACCOUNT 69.94 31797 8/6/2021 DD 7300 TRUCKEE RENTS INC MATERIALS 70.36 130573 8/6/2021 CHK 240 AUDIO ON -HOLD ON -HOLD PHONE SYSTEM 79.00 31796 8/6/2021 DD 7176 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 99.45 130574 8/6/2021 CHK 44444 BRYAN NADEAU APPLIANCE REBATE- ELECTRIC 100.00 130592 8/6/2021 CHK 9985 EARL SMITH RENEWAL- CROSS CONNECTION 100.00 31783 8/6/2021 DD 1305 JW WELDING SUPPLIES & TOOLS MATERIALS 104.42 130575 8/6/2021 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 07/30/2021 115.38 31780 8/6/2021 DD 9334 DAVID C EMERY OT MEALS 143.09 130580 8/6/2021 CHK 2222 FRANK STRATTON'S JUST FIX IT MATERIALS 160.00 130572 8/6/2021 CHK 657 AT&T COMMUNICATIONS 163.76 31776 8/6/2021 DD 10445 ANSELL HEALTHCARE PRODUCTS LLC FIELD SUPPLIES 164.32 130603 8/6/2021 CHK 999 VSS INTERNATIONAL WATER PERMIT REFUND 173.02 31782 8/6/2021 DD 3480 GRAINGER INC. MATERIALS 184.86 130601 8/6/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 198.55 130594 8/6/2021 CHK 6860 TAHOE FOREST HEALTH SYSTEM PERSONNEL EXPENSES - WC CLAIM 205.00 31786 8/6/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 281.74 130587 8/6/2021 CHK 462 POWERPLAN-OIB REPAIRS & MAINTENANCE 343.38 130590 8/6/2021 CHK 900 SIERRA MOUNTAIN PIPE & SUPPLY TOILET EXCHANGE - RYAN RODARTE 385.60 31784 8/6/2021 DD 10008 MOTION & FLOW CONTROL PRODUCTS, INC. 2020 RAM 35004x4 ALTEC SVC BODY RPL 200 395.17 31794 8/6/2021 DD 1787 SILVER STATE INTERNATIONAL TRUCKS REPAIRS & MAINTENANCE 413.96 31791 8/6/2021 DD 9504397 PACE SUPPLY MATERIALS 422.64 130602 8/6/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 424.04 130596 8/6/2021 CHK 44444 TARIK OMAR ELECTRIC VEHICLE CHARGER REBATE 500.00 31775 8/6/2021 DD 228 ALLIED ELECTRONICS INC. MATERIALS 505.00 130577 8/6/2021 CHK 193 EASTERN REGIONAL LANDFILL LANDFILL CHARGES 530.50 130598 8/6/2021 CHK 11041 TRUCKEE PAINT MART INC. MATERIALS 540.53 31781 8/6/2021 DD 3340 GENERAL PACIFIC INC EMPLOYEE UNIFORMS 592.56 130585 8/6/2021 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 683.71 130583 8/6/2021 CHK 3515 GRAYBAR ELECTRIC CO INC MATERIALS 819.95 130571 8/6/2021 CHK 10360 AFLAC EMPLOYEE PAID INSURANCE 981.32 130582 8/6/2021 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS 1,049.31 130597 8/6/2021 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 1,246.21 31799 8/6/2021 DD 10678 WILLDAN FINANCIAL SERVICES OG, GC, DLAD MR ANNUAL ADMIN COSTS 1,343.40 130604 8/6/2021 CHK 7820 WESTERN NEVADA SUPPLY MATERIALS 1,601.34 130586 8/6/2021 CHK 999 MYERS AND SONS CONSTRUCTION REFUND WATER PERMIT 1,800.72 130578 8/6/2021 CHK 348 EDGES ELECTRICAL GROUP 2021 WATER SCADA SYSTEM REPLACEMENT 1,828.43 31778 8/6/2021 DD 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC XEROX COPIER LEASE 2,311.89 130589 8/6/2021 CHK 1398 SCHINDLER ELEVATOR CORP BUILDING MAINTENANCE 2,326.15 130584 8/6/2021 CHK 1116 HUNT&SONS, INC MATERIALS 2,708.09 130595 8/6/2021 CHK 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 3,277.50 31777 8/6/2021 DD 577 COOPERATIVE RESPONSE CENTER INC. ANSWERING SERVICE 3,338.52 130581 8/6/2021 CHK 1484 FUENTES CONSULTING LLC EMPLOYEE DEVELOPMENT 3,470.32 5067 8/6/2021 WIRE 1359 CALPERS PENSION 9,460.00 31792 8/6/2021 DD 1466 ROADSAFE TRAFFIC SYSTEMS MATERIALS 10,760.01 31790 8/6/2021 DD 820 ONESOURCE DISTRIBUTORS INVENTORY 13,307.04 130600 8/6/2021 CHK 1435 TRUCKEE TAHOE WORKFORCE HOUSING AGENCY PROFESSIONAL SERVICES: OTHER 14,688.00 130588 8/6/2021 CHK 10808 RAILROAD MANAGEMENT CO LLC ENVIRONMENTAL COMPLIANCE FEES 18,266.83 31787 8/6/2021 DD 5130 NCPA MEMBERSHIP DUES 29,408.00 31788 8/6/2021 DD 6403 NEVADA POWER COMPANY PURCHASED POWER-NEVADA POWER 31,858.47 31779 8/6/2021 DD 10759 DONNER LAKE ASSESSMENT DISTR NC DLAD 20/21 ASSESSMENT COLLECTION 37,486.65 31800 8/6/2021 DD 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 53,835.34 31793 8/6/2021 DD 6402 SIERRA PACIFIC POWER CO PURCHASED POWERE -SPPC 65,792.01 31795 8/6/2021 DD 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 276,797.99 31785 8/6/2021 DD 1481 MOUNTAIN G ENTERPRISES, INC TRUCKEE SUBSTATION CONTROL 298,311.40 31798 8/6/2021 DD 10584 UAMPS PURCHASED POWER - UAMPS 1,007,729.66 31816 8/12/2021 DD 837 SIERRA OFFICE SOLUTIONS XEROX COPIER LEASE 11.37 130614 8/12/2021 CHK 99999 ANDREWS GROVE CUSTOMER REFUND -CLOSED ACCOUNT 11.93 130624 8/12/2021 CHK 1079 O'REI LILY AUTO PARTS MISC PARTS & SUPPLIES 14.31 130618 8/12/2021 CHK 10932 J & L FOOD MART & CARWASH REPAIRS & MAINTENANCE 22.00 130621 8/12/2021 CHK 115 KIMBALL-MIDWEST MISC PARTS & SUPPLIES 26.43 130628 8/12/2021 CHK 675 SHERWIN-WILLIAMS MATERIALS 36.39 130615 8/12/2021 CHK 905 HEALTHEQUITY INC. HSA ADMINISTRATIVE FEES 64.35 130620 8/12/2021 CHK 99999 CYRUS JOHNSON CUSTOMER REFUND-CLOSEDACCOUNT 66.45 31820 8/12/2021 DD 7300 TRUCKEE RENTS INC MATERIALS 71.45 130609 8/12/2021 CHK 358 CALIFORNIA SURVEYING DRAFTING SUPPLY INC OFFICE SUPPLIES 100.18 130630 8/12/2021 CHK 99999 JAMES SMOOT CUSTOMER REFUND -CLOSED ACCOUNT 101.10 130607 8/12/2021 CHK 99999 JAKE BECKER CUSTOMER REFUND -CLOSED ACCOUNT 111.16 31821 8/12/2021 DD 10380 ULINE FIELD SUPPLIES 144.88 130612 8/12/2021 CHK 348 EDGES ELECTRICAL GROUP 2021 WATER SCADA SYSTEM REPLACEMENT 151.24 130634 8/12/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 190.81 130626 8/12/2021 CHK 99999 THOMAS ROLAND CUSTOMER REFUND -CLOSED ACCOUNT 196.83 31805 8/12/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 200.00 130632 8/12/2021 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY WATER SAMPLE ANALYSIS 200.00 31814 8/12/2021 DD 602 SAFETY ON SITE SAFETY SUPPLIES 200.81 130616 8/12/2021 CHK 1116 HUNT &SONS, INC FUEL FOR VEHICLES 211.78 Page Iof3 Page 4 of 12 Check/Tran Date Type Vendor Vendor Name Reference Amount 31810 8/12/2021 DO 617 MOUNTAIN EAP WELLNESS PROGRAM 225.00 130629 8/12/2021 CHK 99999 STEVEN SHUMATE CUSTOMER REFUND -CLOSED ACCOUNT 233.37 31808 8/12/2021 DO 1305 JW WELDING SUPPLIES & TOOLS MATERIALS 251.28 130635 8/12/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 254.56 31803 8/12/2021 DO 640 EMPLOYER LYNX INC. PERSONNEL EXPENSES 288.00 130631 8/12/2021 CHK 6860 TAHOE FOREST HEALTH SYSTEM PERSONNEL EXPENSES 406.00 130613 8/12/2021 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS 473.66 130611 8/12/2021 CHK 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING, MAINTENANCE & SUPPORT 491.73 31817 8/12/2021 DO 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 504.00 31815 8/12/2021 DO 6155 SAFETY-KLEEN CORPORATION HAZARDOUS MATERIAL COMPLIANCE 630.70 130605 8/12/2021 CHK 999 FRANK ALDRIDGE REFUND WORK ORDER#19-63938 718.63 31809 8/12/2021 DO 9710 EMPLOYEE VISION REIMBURSEMENT 811.99 130610 8/12/2021 CHK 1073 CLEAN MACHINE REPAIRS & MAINTENANCE 880.00 31811 8/12/2021 DO 820 ONESOURCE DISTRIBUTORS MATERIALS 909.09 31802 8/12/2021 DO 1167 EAST RIVER PR PROFESSIONAL SERVICES: MARKETING 1,000.00 31806 8/12/2021 DO 3340 GENERAL PACIFIC INC MATERIALS 1,409.42 130633 8/12/2021 CHK 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 1,500.02 130636 8/12/2021 CHK 7820 WESTERN NEVADA SUPPLY INVENTORY 1,599.72 130619 8/12/2021 CHK 1176 CHRISTINE FJACKSON, O.D. VISION REIMBURSEMENT 1,770.00 130606 8/12/2021 CHK 657 AT&T COMMUNICATIONS 1,879.93 31804 8/12/2021 DO 1036 ESCI SAFETY MEETING 1,925.00 130608 8/12/2021 CHK 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE USE TAX PREPAYMENT#1 1,996.00 31819 8/12/2021 DO 155 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 2,000.00 31801 8/12/2021 DO 515 BRAGG CRANE SERVICE CONTRACT SERVICES: ROW TREE CLEARING 2,642.85 31812 8/12/2021 DO 9504397 PACE SUPPLY INVENTORY 4,710.39 130627 8/12/2021 CHK 734 SHEPHERD'S AUTO BODY REPAIRS & MAINTENANCE 5,075.38 31807 8/12/2021 DO 3820 IBEW LOCAL 1245 UNION DUES 6,284.40 31813 8/12/2021 DO 1466 ROADSAFE TRAFFIC SYSTEMS CONTRACT SERVICES: ROW TREE CLEARING 7,171.25 130617 8/12/2021 CHK 1434 INDUSTRIAL FLOW SOLUTIONS MATERIALS 7,735.09 130625 8/12/2021 CHK 693 QUALITY TRUCK EQUIPMENT AND FABRICATION REPAIRS & MAINTENANCE 12,906.43 130622 8/12/2021 CHK 5151 NRECA INSURANCE 16,903.52 31818 8/12/2021 DO 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 30,632.56 130623 8/12/2021 CHK 5150 NRECA GROUP BENEFITS TRUST INSURANCE 199,636.96 5075 8/19/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 08/13/21 883.93 5076 8/19/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 08/13/2021 18,800.67 5073 8/19/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 08/13/2021 19,403.24 5071 8/19/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS PPE 08/13/2021 21,122.11 5072 8/19/2021 WIRE 11233 CALPERS PENSION 53,596.13 5074 8/19/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 08/13/2021 85,903.32 5070 8/19/2021 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 189,895.26 31899 8/20/2021 DO 736 FACTORY MOTOR PARTS MISC PARTS & SUPPLIES - 130651 8/20/2021 CHK 970 NORTHERN CALIFORNIAJOINT POLE ASSN MEMBERSHIP DUES 6.50 130648 8/20/2021 CHK 468 MAITA CHEVROLET REPAIRS & MAINTENANCE 10.32 31920 8/20/2021 DO 630 WESTERN AREA POWER ADMINISTRATION ENVIRONMENTAL COMPLIANCE FEES 10.44 31903 8/20/2021 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 10.75 130655 8/20/2021 CHK 246 ROCK GARDEN MATERIALS 13.10 130653 8/20/2021 CHK 1079 O'REI LILY AUTO PARTS REPAIRS & MAINTENANCE 41.38 130660 8/20/2021 CHK 7175 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 60.60 130639 8/20/2021 CHK 9215 EMPLOYEE VISION REIMBURSEMENT 71.71 130652 8/20/2021 CHK 99999 ROBERT O'CONNOR CUSTOMER REFUND-CLOSEDACCOUNT 75.87 130643 8/20/2021 CHK 115 KIMBALL-MIDWEST MISC PARTS & SUPPLIES 76.69 31914 8/20/2021 DO 7176 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 106.65 130650 8/20/2021 CHK 99999 JENNY NIELSEN CUSTOMER REFUND -CLOSED ACCOUNT 109.58 130638 8/20/2021 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE O8/13/2021 115.38 31900 8/20/2021 DO 3480 GRAINGER INC. MATERIALS 126.78 130654 8/20/2021 CHK 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 133.73 130649 8/20/2021 CHK 99999 CHRISTOPHER MAUSOLFF CUSTOMER REFUND -CLOSED ACCOUNT 149.59 31895 8/20/2021 DO 10020 ALPHA ANALYTICAL INC. WATER SAMPLE ANALYSIS 155.00 130661 8/20/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 190.75 130641 8/20/2021 CHK 277 HACH COMPANY WATER SAMPLE ANALYSIS 194.95 130662 8/20/2021 CHK 7380 UNITED PARCEL SERVICE UPSCHARGES 199.00 31905 8/20/2021 DO 6403 NEVADA POWER COMPANY PURCHASED POWER -SPPC & NEVADA POWER 239.90 31916 8/20/2021 DO 7300 TRUCKEE RENTS INC MISC PARTS & SUPPLIES 254.27 130642 8/20/2021 CHK 1176 CHRISTINE FJACKSON, O.D. VISION REIMBURSEMENT 265.00 130658 8/20/2021 CHK 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 281.85 5078 8/20/2021 WIRE 11233 CALPERS PENSION 289.57 31913 8/20/2021 DO 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 305.48 31906 8/20/2021 DO 775 ONLINE INFORMATION SERVICES MATERIALS 371.30 31911 8/20/2021 DO 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 392.00 31912 8/20/2021 DO 9947 EMPLOYEE VISION REIMBURSEMENT 400.00 31897 8/20/2021 DO 1054 TERANCE COCHRANE, O.D. VISION REIMBURSEMENT 408.00 130647 8/20/2021 CHK 1149 LOOMIS BANKING CHARGES 514.32 5081 8/20/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS 9960 FINAL 528.84 130645 8/20/2021 CHK 1132 LEAF OFFICE SUPPLIES 549.34 130664 8/20/2021 CHK 999 WHITNEY KUKULKA REFUND FACILITY FEE 649.00 31904 8/20/2021 DO 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS & MAINTENANCE 692.38 130663 8/20/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 726.76 130640 8/20/2021 CHK 78 FEDERAL EXPRESS CORPORATION FEDEX BILL 741.09 31918 8/20/2021 DO 4590 UNDERGROUND FACILITIES SAFE EXCAVATION ENVIRONMENTAL COMPLIANCE FEES 1,034.43 130659 8/20/2021 CHK 1357 THE UNION GENERAL ADVERTISEMENT 1,442.12 130656 8/20/2021 CHK 536 TAHOE-TRUCKEE UNIFIED SCHOOL DISTRICT BOARD MEETING EXPENSES 1,550.00 130637 8/20/2021 CHK 134 ANIXTER INC. INVENTORY 2,059.40 5082 8/20/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9960 FINAL 2,464.02 31907 8/20/2021 DO 9504397 PACE SUPPLY MATERIALS 4,234.08 31910 8/20/2021 DO 1466 ROADSAFE TRAFFIC SYSTEMS CONTRACT SERVICES: ROW TREE CLEARING 4,720.00 31902 8/20/2021 DO 1303 MONROE TITAN, LLC HARDWARE PURCHASES 5,257.20 31898 8/20/2021 DO 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,300.00 130646 8/20/2021 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 6,616.57 5079 8/20/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS 9960 FINAL 6,750.00 130657 8/20/2021 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 6,923.68 5080 8/20/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 9960 FINAL 9,815.92 Page 2of3 Page 5 of 12 Check/Tran Date Type Vendor Vendor Name Reference Amount 31908 8/20/2021 DD 5730 PORTER SIMON LEGAL SERVICES 11,200.00 31901 8/20/2021 DD 778 HDR ENGINEERING INC PROFESSIONAL SERVICES- ENGINEERING 12,967.76 31915 8/20/2021 DD 712 TRUCKEE DONNER PUD PURCHASED POWER -STAMPEDE HYDRO 14,507.40 130665 8/20/2021 PL PL PAYROLL PAYROLL FINAL CHECK 14,792.18 31919 8/20/2021 DD 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 22,304.52 130644 8/20/2021 CHK 1067 LAKESIDE PAVING & SEALING MATERIALS 27,350.00 31917 8/20/2021 DD 1183 TRUCKEE-CARSON IRRIGATION DISTRICT PURCHASED POWER- TCID 32,558.77 31921 8/20/2021 DD 1321 WRIGHTTREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 37,492.16 31896 8/20/2021 DD 5440 ALTEC INDUSTRIES INC 2020 GMC 25004X4 ALTEC BODY RPL 228 91,739.71 31909 8/20/2021 DD 1483 RAPID CONSTRUCTION INC. 2021 PIPELINE REPLACEMENT 308,070.75 130666 8/27/2021 CHK 999 DAVID HANSELL REFUND WORK ORDER#20-631040 33.87 130669 8/27/2021 CHK 99999 TONY PASTORE CUSTOMER REFUND -CLOSED ACCOUNT 52.34 130670 8/27/2021 CHK 99999 JEFFREY RUVALCABA CUSTOMER REFUND -CLOSED ACCOUNT 148.59 130667 8/27/2021 CHK 99999 BARBARA IHDE CUSTOMER REFUND -CLOSED ACCOUNT 204.41 130673 8/27/2021 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 260.16 31926 8/27/2021 DD 320 W&TGRAPHICS EMPLOYEE UNIFORMS 307.92 31923 8/27/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 360.00 130671 8/27/2021 CHK 99999 TROUT UNLIMITED CUSTOMER REFUND -CLOSED ACCOUNT 489.54 31922 8/27/2021 DD 829 CDS GLOBAL REMITTANCE PROCESSING 855.05 31925 8/27/2021 DD 6360 THATCHER COMPANY OF CALIFORNIA, INC WATER QUALITY: TREATMENT 1,612.96 130668 8/27/2021 CHK 1067 LAKESIDE PAVING & SEALING MATERIALS 4,950.00 130672 8/27/2021 CHK 7290 TRUCKEE OVERHEAD DOOR BUILDING MAINTENANCE 9,543.00 31924 8/27/2021 DD 289 NISC JULY 2021 RECURRING INVOICE 19,479.67 202 $ 3,696,876.44 Page 3of3 Page 6 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 7/31/2021 Page 1 of 2 Electric Dept Water Dept Total Balance in General Fund 6/30/2021 $13,287,835 $4,996,703 $18,284,539 Receipts: Revenue received Retired employees medical insurance Record interest earned FF Funding and DL Surcharge Reimbursement for 2006 COP Cash clearing accounts (timing -prior month reversal) Cash clearing accounts (timing -current month) Total Receipts Disbursements: Accounts payable/payroll disbursements Distribute UPTIF interest Restrict facilities fees Restrict Donner Lake surcharge Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 7/31/2021 1,901,045 1,193,715 3,094,759 19,566 - 19,566 13,408 2,824 16,232 - 37,700 37,700 (63,958) - (63,958) 34,660 - 34,660 1,904,721 1,234,238 $3,138,958 $3,149,470 $1,750,434 $4,899,904 1,880 1,152 3,032 21,639 69,747 91,386 - 9,249 9,249 14,693 - 14,693 8,425 - 8,425 $3,196,107 $1,830,581 $5,026,688 $11,996,449 $4,400,360 $16,396,809 9/22/2021 5:11 PM I:\Treasurers Report\Statement of General Fund\2021\2021-07 GF Page 7 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 7/31/2021 Page 2 of 2 Distribution of Non -Restricted Funds At Month -End: Customer Services Operating Funds Operating clearing accounts U.S. Bank -General Fund LAIF, UPTIF, PCIF, & TVI - General Fund Total Market Adjustment Total Non -Restricted Funds Distribution of Designated & Restricted Funds at Month -End: LAIF, UPTIF, PCIF & TVI - Restricted Funds UPTIF - TDPUD Prop 55 Reserve Fund UPTIF - Donner Lake Assessment District POB Deferred Liability Reserve Fund 2015 COP Water Bonds, Interest Payment Fund 2015 COP Water Bonds, Principal Payment Fund U S Bank - Donner Lake Assessment District 00-1 Total Market Adjustment Total Restricted Funds Total Funds Available Total Market Adjustments Electric Dept Water Dept Total $2,400 $0 $2,400 34,660 - 34,660 1,694,889 - 1,694,889 10,264, 501 4,400, 360 14, 664, 860 $11,996,449 $4,400,360 $16,396,809 $57,871 $22,034 $79,905 $12,054,320 $4,422,394 $16,476,714 14,758,365 3,984,990 18,743,354 - 341,657 341,657 - 666,007 666,007 88,695 - 88,695 - 8,661 8,661 - 547,760 547,760 - 445 445 14,847,060 5,549,520 20,396,580 48,060 14,220 62,280 14,895,121 5,563,740 20,458,860 26,949,441 9,986,134 36,935,574 105,931 36,254 142,185 9/22/2021 5:11 PM I:\Treasurers Report\Statement of General Fund\2021\2021-07 GF Page 8 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 7/31/2021 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2020 6/30/2021 Activity 7/31/2021 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.22%(0.26%) General Fund 1..136.1 $ 6,968,896 $ 8,741,093 $ (1,785,504) $ 6,955,589 Consolidate cash 556,719 LAIF transfer (2,350,000) Quarterly Investment Income payment received 7,776.27 Capital Replacement Fund 136.41 1,181,925 1,443,102 1,076 1,444,178 Quarterly Investment Income payment received 1,076 AB 32 Cap & Trade Fund 1..136.58 1,606,959 558,843 1,131 559,973 Quarterly Investment Income payment received 1,131 Deferred Liabilites Reserve 1..136.42 2,085,918 2,091,376 1,898 2,093,274 Quarterly Investment Income payment received 1,898 Total LAIF Electric Investments 11,843,699 12,834,413 (1,781,399) 11,053,014 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.36% (0.37%) General Fund 1..136.12 1,690,317 839,502 (23,231) 816,271 Distribute UPTIF interest (1,880) Restrict facility fees (21,639) Record monthly interest 288 Facilities Fees 1..136.9 748,126 $91,282 21,945 913,227 Restrict facilites fees 21,639 Record monthly interest 306 Electric Rate Reserve Fund 1..136.45 1,604,909 2,098,897 720 2,099,617 Record monthly interest 720 Capital Replacement Fund 136.46 833,092 834,996 286 $35,282 Record monthly interest 286 Electric Vehicle Reserve 1..136.13 626,347 $42,735 289 $43,024 Record monthly interest 289 Total UPTIF Electric Investments 5,502,792 5,507,412 9 5,507,421 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.21%(0.19%) Electric General Fund PC1..136.49 524,852 523,042 (3,406) 519,636 Record monthly interest 94 TVI Interest Receivable (3,500) Electric Rate Reserve Fund 1..136.47 4,333,619 2,341,813 3,922 2,345,735 Record monthly interest 422 TVI Interest Recievable 3,500 Capital Replacement Fund 1..136.48 1,621,632 1,623,762 293 1,624,055 Record monthly interest 293 Total PCIF County Electric Investments 6,480,103 4,488,617 809 4,489,426 TVI INVESTMENTS- 0.55%(0.55%) General Fund TVI 1..136.15 - 1,973,005 - 1,973,005 Record Initial funds transfer for new investment Electric Rate Reserve Fund 1..136.44 2,000,000 2,000,000 Record Initial funds transfer for new investment Total TVI Electric Investments 3,973,005 3,973,005 Total Electric Investments $ 23,826,594 $ 26,803,447 $ (1,780,582) $ 25,022,865 9/22/2021 5:10 PM Investments Status Report I:\Treasurers Report\Investment Status Reports\2021\2021-071n-st—ts Status Report Page 1 of 3 Page 9 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 7/31/2021 Balance Beg.Balance Month End Balance %Current Month(%Last Month) 12/31/2020 6/30/2021 Activity 7/31/2021 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.22%(0.26%) General Fund 2..136.1 1,861,580 1,347,606 (624,241) 723,365 Consolidate cash (556,719) Quarterly Investment Income payment received 2,225 Restrict facility fees (69,747) DSC Operating Reserve Fund 2..136.47 76,677 (0) - (0) Facilities Fees 2..136.90 948,794 1,336,663 70,861 1,407,524 Restrict facility fees 69,747 Quarterly Investment Income payment received 1,114 SRF/DLAD Reserve Fund 2..125.5 826,526 828,827 (828,827) - Investment Income (828,827) SRF Loan Payoff Capital Replacement Fund 2..136.48 - 1,015,747 1,015,747 Total LAIF Water Investments 2,887,052 4,528,844 (1,382,207) 3,146,637 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.36% (0.37%) General Fund 2..136.12 848,478 736,059 27,551 763,610 Transfer to DLAD surcharge (9,249) Distribute UPTIF interest (1,152) DL Surcharge Reimbursement for 2006 COP 8,018 FF Funding portion of 2006 COP 29,682 Record monthly interest 252 Facilities Fees 2..136.25 890,402 714,189 (29,437) 684,752 Record monthly interest 245 Transfer to GF for FF Funding portion of 2006 COP (29,682) West River St. Assessment District 2..136.31 38,065 38,152 13 38,165 Record monthly interest 13 Prepaid Connection Fees 2..136.7 77,788 77,966 27 77,993 Record monthly interest 27 Donner Lake Assessment District Fund 2..136.84 664,261 665,779 228 666,007 Record monthly interest 228 Donner Lake Assessment District Surcharge Fund 2..136.61 147,937 155,532 1,284 156,816 DLAD surcharge collections 9,249 DL Surcharge Reimbursement to GF for 2006 COP (8,018) Record monthly interest 53 TSA SAD II Improvement Fund 2..136.85 18,363 18,405 6 18,411 Record monthly interest 6 Water Vehicle Reserve 2..136.13 197,987 478,912 164 479,076 Record monthly interest 164 Deferred Liabilites Reserve 2..136.42 106,226 106,469 37 106,505 Record monthly interest 37 Prop 55 Reserve Fund 2..125.94 340,762 341,540 117 341,657 Record monthly interest 117 Total UPTIF Water Investments 3,330,269 3,333,002 (9) 3,332,993 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.21%(0.19%) Water General Fund PC 2..136.5 375,541 1,919,829 346 1,920,175 Record monthly interest 346 DSC Operating Reserve Fund 2..136.49 1,541,769 0 - 0 Total PCIF Water Investments 1,917,311 1,919,829 346 1,920,175 9/22/2021 5:10 PM Investments Status Report I:\Treasurers Report\Investment Status Reports\2021\2021-071n-st-ts Status Report Page 2 of 3 Page 10 of 12 TVI INVESTMENTS- 0.55%(0.55%) Water General Fund TVI 2..136.15 Total TVI Water Investments INVESTMENT STATUS REPORT Activity for the Month Ended 7/31/2021 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2020 6/30/2021 Activity 7/31/2021 993,209 993,209 993,209 993,209 Total Water Investments $ 8,134,631 $ 10,774,884 $ (1,381,870) $ 9,393,014 ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Pre - Market Adjustments Total LAIF Investments 41% 14,730,751 17,363,257 (3,163,607) 14,199,651 Total UPTIF Investments 26% 8,833,060 8,840,414 (0) 8,840,414 Total PCIF Investments 19% 8,397,414 6,408,446 1,155 6,409,601 Total TVI Investments 14% 4,966,214 4,966,214 Total Investments 100 % Month End Bal.Mix $ 31,961,225 $ 37,578,331 $ (3,162,452) $ 34,415,879 Market Adjustments Total LAIF Investments 67,341 67,341 (33,882) 33,458 Total UPTIF Investments 33,897 33,897 33,897 Total PCIF Investments 62,280 62,280 - 62,280 Total TVI Investments 11,274 1,275 12,549 Total Investments $ 163,518 $ 174,793 $ (32,607) $ 142,185 Post - Market Adjustments Total LAIF Investments 41 % 14,798,091 17,430,598 (3,197,489) 14,233,109 Total UPTIF Investments 26% 8,866,958 8,874,311 - 8,874,311 Total PCIF Investments 19% 8,459,694 6,470,726 1,155 6,471,881 Total TVI Investments 14% - 4,977,488 1,275 4,978,763 Total Investments 100% Month End Bal.Mix $ 32,124,743 $ 37,753,124 $ (3,195,059) $ 34,558,064 9/22/2021 5:10 PM Investments Status Report 1:\Trea, ,rers Report\tovestmeot stags Reports\2021\2021-07 In-st—ts status Report Page 3 of 3 Page 11 of 12 ELECTRIC FUNDS General Fund Facilities Fees Electric Rate Reserve Capital Replacement Fund Deferred Liabilites Reserve/POB Fund Electric Vehicle Reserve AB 32 Fund Market Adjustments Total Electric Investments WATER FUNDS General Fund Facilities Fees Capital Replacement Fund 2015 COP Funds DSC and Operating Reserve Fund West River St. Assessment District Deferred Liabilites Reserve Prepaid Connection Fees DLAD Fund DLAD Surcharge SRF Reserve and Payment Fund TSA SAD II Improvement Fund Water Vehicle Reserve Prop 55 Reserve Fund DLAD Investment Market Adjustments Total Water Investments Electric and Water, subtotal MELLO ROOS - OLD GREENWOOD Total Mello Roos - Old Greenwood MELLO ROOS - GRAY'S CROSSING Total Mello Roos - Gray's Crossing Total Investments TRUCKEE DONNER PUD INVESTMENT BALANCES as of July 31, 2021 Utah Public TVI Fidelity Mmkt Morgan Stanley Dreyfus Treasury Federated US US Bank Cash/ LAW Placer County Investment Fund Investments Govt 57 Treas Sec Port Security Treas Cash Res Checking Cash clearings Total 131.1 $ 6,955,589 $ 519,636 $ 816,271 $ 1,973,005 $ $ $ $ $ 1,694,889 $ 37,060 $ 11,996,449 - - 913,227 - - - 913,227 - 2,345,735 2,099,617 2,000,000 6,445,351 1,444,178 1,624,055 835,282 - 3,903,515 2,093,274 - - 88,695 2,181,969 - 843,024 - 843,024 559,973 - - - 559,973 26,760 48,060 21,117 9,993 - 105,931 11,079,774 4,537,486 5,528,538 3,982,998 88,695 1,694,889 37,060 26,949,441 $ 723,365 $ 1,920,175 $ 763,610 $ 993,209 $ $ $ - $ $ - $ - 4,400,360 1,407,524 - 684,752 - 2,092,276 1,015,747 - 1,015,747 - 556,421 556,421 (0) 0 0 38,165 38,165 106,505 106,505 77,993 77,993 666,007 445 666,452 156,816 - 156,816 18,411 18,411 479,076 479,076 341,657 341,657 6,698 14,220 12,780 2,556 - - 36,254 3,153,335 1,934,395 3,345,773 995,765 556,421 - 445 - 9,986,134 14,233,109 6,471,881 8,874,311 4,978,763 556,421 88,695 1,695,334 37,060 36,935,574 - - - - - 306,198 604,051 - - 910,249 - 306,198 604,051 - 910,249 1,906,096 - - 2,241,483 4,147,580 1,906,096 2,241,483 4,147,580 $ 16,139,205 $ 6,471,881 $ 8,874,311 $ 4,978,763 $ 556,421 $ 306,198 $ 692,747 $ 2,241,483 $ 1,695,334 $ 37,060 $ 41,993,403 2021 06 Last Month End Balances 19,336,694 6,470,726 8,874,311 4,977,488 466,019 306,198 604,065 2,239,917 1,145,280 3,005,822 47,426,520 Change from last month (3,197,489) 1,155 - 1,275 90,402 0 88,682 1,566 550,054 (2,968,762) (5,433,117) 202007 PY Month End Balances 17,165,113 8,342,642 8,880,359 - 545,361 248,392 743,832 2,215,636 1,186,351 11,284 39,338,971 Change from PY Month (1,025,908) (1,870,761) (6,048) 11,060 57,807 (51,085) 25,847 508,982 25,775 2,654,432 202012 PYE Balances 17,525,627 8,459,694 8,866,958 137,681 306,183 5,716 769,266 2,635,065 440,819 39,147,008 Change from PYE (1,386,422) (1,987,813) 7,353 418,740 15 687,031 1,472,217 (939,731) (403,759) 2,846,394 I:\Treasurers Report\2021\2021-10 Treasurer's Mp-rt All Investments 202107 S55 Page 12 of 12