Loading...
HomeMy WebLinkAbout18 Attachement 1 2022-01 Treasurers ReportTRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT January 5, 2022 Fund Balances for the Month Ended October 31, 2021 And Disbursements for the Month November 30, 2021 Page 1 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending October 31, 2021 and disbursements for November 2021. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for November 2021 were $3,139,690.90. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during November 2021 total $3,139,690.90. 3) STATEMENT OF GENERAL FUND: As of October 31, 2021 the balance in the General Fund was $17,349,069 (Electric $12,116,652 and Water $5,232,417). 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 October 2021 was $37,982,691 ($27,004,937 Electric and $10,977,753 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 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% August 2021 0.22% 0.18% 0.33% 0.07% 0.55% September 2021 0.21 % 0.22% 0.32% 0.08% 0.55% October 2021 0.20% 0.12% 0.33% 0.27% 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 November 2021 totaled $3,139,690.90. 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 JII 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 Oct Nov Dec ■ 2018 ■ 2019 ■ 2020 ■ 2021 # A/P Invoices Vouchered 1000 800 600 400 200 I 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 November 2021 Check[Tran Date Tvoe Vendor Vendor Name Reference Amount 5155 11/1/2021 WIRE 11233 CALPERS PENSION $ 483.22 5161 11/1/2021 WIRE 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE USE TAX PAYABLE 805.00 5153 11/1/2021 WIRE 1359 CALPERS PENSION 9,460.00 32599 11/5/2021 DD 3515 GRAYBAR ELECTRIC CO INC MATERIALS - 130967 11/5/2021 CHK 970 NORTHERN CALIFORNIA JOINT POLE ASSN MEMBERSHIP DUES 10.66 130966 11/5/2021 CHK 5555 NORMAN S. WRIGHT MECH. EQUIP. CORP. MATERIALS 14.45 130978 11/5/2021 CHK 10761 SOUTHWEST GAS CORP. UTILITIES: NATURAL GAS 31.99 130956 11/5/2021 CHK 5661 DOORKING, INC CELL PHONE CHARGES 41.95 130959 11/5/2021 CHK 78 FEDERAL EXPRESS CORPORATION FEDERALEXPRESS 103.50 32612 11/5/2021 DD 7300 TRUCKEE RENTS INC MARTIS VALLEY GENERATOR PURCHASE 103.92 32601 11/5/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 106.15 130955 11/5/2021 CHK 99999 DONALD E COLCLOUGH CUSTOMER REFUND -CLOSED ACCOUNT 118.10 32608 11/5/2021 DD 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 119.08 130957 11/5/2021 CHK 348 EDGES ELECTRICAL GROUP W SCADA REPLACEMENT PROJECT 157.42 32595 11/5/2021 DD 5840 FERGUSON ENTERPRISES INC MATERIALS 158.55 130972 11/5/2021 CHK 1431 PACIFIC COAST FLAG FACILITY SUPPLIES 187.93 130974 11/5/2021 CHK 246 ROCK GARDEN MATERIALS 252.33 32594 11/5/2021 DD 848 FASTENAL RCTOOLALLOWANCE 253.28 130982 11/5/2021 CHK 643 UNITEDSITE SERVICESOF NEVADA MATERIALS 285.10 32605 11/5/2021 DD 9962 GRANT SACKS MEETING EXPENSES 291.22 130954 11/5/2021 CHK 9215 EMPLOYEE VISION REIMBURSEMENT 301.83 32614 11/5/2021 DD 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 359.00 130961 11/5/2021 CHK 1187 GLADWELL GOVERNMENTAL SERVICES, INC PROFESSIONAL SERVICES: OTHER 420.00 130962 11/5/2021 CHK 44444 KG PROPERTY MGMT HOLDINGS ELECTRIC VEHICLE CHARGER REBATE 500.00 130973 11/5/2021 CHK 1290 RESCUE TRAINING INSTITUTE, INC. SAFETY SUPPLIES 525.00 130965 11/5/2021 CHK 99999 NAVOPACHE ELECTRIC COOPERATIVE CDS PAYMENT MADE IN ERROR 600.24 130971 11/5/2021 CHK 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 610.46 130960 11/5/2021 CHK 999 GERARDAND CYNTHIA DENICORE INSURANCE DEDUCTIONS & LOSSES 628.43 130953 11/5/2021 CHK 657 AT&T COMMUNICATIONS 637.40 130964 11/5/2021 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 646.26 130968 11/5/2021 CHK 5200 NORTHWEST PUBLIC POWER ASSOCIATION PERSONNEL EXPENSES 700.00 130952 11/5/2021 CHK 10360 AFLAC EMPLOYEE PAID INSURANCE 981.32 130976 11/5/2021 CHK 900 SIERRA MOUNTAIN PIPE &SUPPLY TOILET EXCHANGE- RUSSELL SCHLESKE 1,012.75 130975 11/5/2021 CHK 999 SERGEY MANCHIK REFUND ELECTRIC FEES 1,260.00 32593 11/5/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 1,345.00 32596 11/5/2021 DD 949 FERGUSON ENTERPRISES INC 1423 METERS PURCHASE 1,601.56 32611 11/5/2021 DD 155 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 2,000.00 130963 11/5/2021 CHK 543 KOFF & ASSOCIATES PROFESSIONAL SERVICES: OTHER 2,040.00 32609 11/5/2021 DD 6360 THATCHER COMPANY OF CALIFORNIA, INC WATER QUALITY: TREATMENT 2,109.10 32590 11/5/2021 DD 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC XEROX COPIER LEASE 2,206.48 32592 11/5/2021 DD 1036 ESCI SAFETY MEETING 2,232.50 130981 11/5/2021 CHK 7320 TRUCKEE TAHOE LUMBER CO MARTIS VALLEY GENERATOR PURCHASE 2,350.47 32604 11/5/2021 DD 9504397 PACE SUPPLY INVENTORY 2,594.39 130979 11/5/2021 CHK 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 3,277.50 32607 11/5/2021 DD 6604 SPIEGEL & MC DIARMID PROFESSIONAL SERVICES: FERC ISSUES 4,582.62 130977 11/5/2021 CHK 1082 SIERRA NEVADA AD PARTNERS COMMUNITY EVENTS 4,600.51 130980 11/5/2021 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 5,071.40 32598 11/5/2021 DD 3322 GEXPRO PURCHASE AND INSTALL TRANSFORMERS 6,333.99 32589 11/5/2021 DD 515 BRAGG CRANE SERVICE CONTRACT SERVICES: ROW TREE CLEARING 7,221.55 32597 11/5/2021 DD 3340 GENERAL PACIFIC INC MATERIALS 7,471.59 130958 11/5/2021 CHK 1432 FARR WEST ENGINEERING MARTIS WOODS PUMP STATION REPLACEMENT 7,884.43 32602 11/5/2021 DD 5130 NCPA MEMBERSHIP DUES 10,261.00 32591 11/5/2021 DD 1486 DIVERSIFIED SYSTEMS INTERNATIONAL HARDWARE PURCHASES 11,680.00 130994 11/5/2021 CHK 7820 WESTERN NEVADA SUPPLY MATERIALS 14,848.74 32603 11/5/2021 DD 6403 NEVADA POWER COMPANY PURCHASED POWER - SPPC&NEVADA POWER 17,141.42 130969 11/5/2021 CHK 5151 NRECA INSURANCE 17,730.56 32600 11/5/2021 DD 1406 MEYERS NAVE PROFESSIONAL SERVICES: GENERAL COUNSEL 19,230.75 130983 11/5/2021 CHK 1464 WATERWORKS ENGINEERS PIONEER TRAIL PIPELINE PROJECT 22,637.95 32615 11/5/2021 DD 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 35,475.45 32606 11/5/2021 DD 6402 SIERRA PACIFIC POWER CO PURCHASED POWER - SPPC&NEVADA POWER 63,558.73 32610 11/5/2021 DD 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 153,347.73 130970 11/5/2021 CHK 5150 NRECA GROUP BENEFITS TRUST INSURANCE 217,114.21 32613 11/5/2021 DD 10584 LAMPS PURCHASED POWER-UAMPS 1,026,990.24 32710 11/10/2021 DD 9944 JENNIFER SAWYER OFFICE SUPPLIES 12.99 32703 11/10/2021 DD 10008 MOTION & FLOW CONTROL PRODUCTS, INC. MISC PARTS & SUPPLIES 15.61 32705 11/10/2021 DD 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS & MAINTENANCE 26.47 130994 11/10/2021 CHK 115 KIMBALL-MIDWEST MISC PARTS & SUPPLIES 34.53 32709 11/10/2021 DD 9924 RYAN PURSEL DMV PHYSICAL 100.00 130998 11/10/2021 CHK 1079 O'REILLY AUTO PARTS REPAIRS & MAINTENANCE 108.53 32699 11/10/2021 DD 9467 JOSEPH HORVATH MEETING EXPENSES 115.00 130987 11/10/2021 CHK 1006 CALIFORNIASTATE DISBURSEMENT UNIT CHILD SUPPORT PPE 11/05/2021 115.38 32711 11/10/2021 DD 9955 EMPLOYEE VISION REIMBURSEMENT 116.69 130986 11/10/2021 CHK 99999 GARY BORRELLI CUSTOMER REFUND -CLOSED ACCOUNT 120.63 32704 11/10/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 160.25 130991 11/10/2021 CHK 736 FACTORY MOTOR PARTS MISC PARTS & SUPPLIES 195.87 131003 11/10/2021 CHK 1308 TRUCKEE TIRE REPAIRS & MAINTENANCE 216.50 131004 11/10/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 244.46 32702 11/10/2021 DD 13051W WELDING SUPPLIES & TOOLS MATERIALS 251.28 130992 11/10/2021 CHK 1432 FARR WEST ENGINEERING MARTIS WOODS PUMP STATION REPLACEMENT 260.00 32712 11/10/2021 DD 1787 SILVER STATE INTERNATIONAL TRUCKS MISC PARTS & SUPPLIES 266.27 32713 11/10/2021 DD 10414 SNAP -ON INDUSTRIAL CGTOOLALLOWANCE 273.81 32708 11/10/2021 DD 5450 PDM STEEL SERVICE CENTERS REPAIRS & MAINTENANCE 300.45 130990 11/10/2021 CHK 348 EDGES ELECTRICAL GROUP MATERIALS 311.54 32692 11/10/2021 DD 640 EMPLOYER LYNX INC. PERSONNEL EXPENSES 318.00 131001 11/10/2021 CHK 675 SHERWIN-WILLIAMS WATER QUALITY: TREATMENT 350.81 32695 11/10/2021 DD 3340 GENERAL PACIFIC INC EMPLOYEE UNIFORM 374.33 5154 11/10/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYER HSA DEPOSIT 382.50 130999 11/10/2021 CHK 2235 OLDCASTLE INFRASTRUCTURE, INC. INVENTORY 397.39 Page 1of3 Page 4 of 12 ChecklTran Date Tvoe Vendor Vendor Name Reference Amount 130997 11/10/2021 CHK 7220 NAPA SIERRA MISC PARTS & SUPPLIES 430.64 130996 11/10/2021 CHK 1149 LOOMIS BANKING CHARGES 520.49 32697 11/10/2021 DO 3480 GRAINGER INC. FIELD SUPPLIES 543.83 32690 11/10/2021 DO 9230 EMPLOYEE VISION REIMBURSEMENT 621.29 130989 11/10/2021 CHK 609 CUMMINS ROCKY MOUNTAIN LLC MATERIALS 643.62 5151 11/10/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 11/05/21 685.37 32689 11/10/2021 DO 1054 TERANCE COCHRANE, O.D. VISION REIMBURSEMENT 800.00 32694 11/10/2021 DO 949 FERGUSON ENTERPRISES INC 1423 MATERIALS 883.39 32691 11/10/2021 DO 1167 EAST RIVER PR PROFESSIONAL SERVICES: MARKETING 1,000.00 32693 11/10/2021 DO 848 FASTENAL MATERIALS 1,372.03 130985 11/10/2021 CHK 657 AT&T COMMUNICATIONS 1,389.67 32696 11/10/2021 DO 1296 GOVINVEST PROFESSIONAL SERVICES: GASB 68 VALUATION 1,400.00 32698 11/10/2021 DO 10449 HI -LINE UTILITY SUPPLY CO. MATERIALS 1,754.97 32706 11/10/2021 DO 820 ONESOURCE DISTRIBUTORS INVENTORY 2,696.07 131002 11/10/2021 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 2,821.67 131006 11/10/2021 CHK 10175 WHITE CAP, L.P. MATERIALS 3,392.33 32714 11/10/2021 DO 3826 STONE'S COUNTRY TIRE REPAIRS & MAINTENANCE 3,418.95 131005 11/10/2021 CHK 7820 WESTERN NEVADA SUPPLY MATERIALS 3,811.86 32707 11/10/2021 DO 9504397 PACE SUPPLY INVENTORY 3,975.27 130995 11/10/2021 CHK 543 KOFF & ASSOCIATES PROFESSIONAL SERVICES: OTHER 5,000.00 32700 11/10/2021 DO 3820 IBEW LOCAL 1245 UNION DUES PPE 11/05/2021 6,048.18 130993 11/10/2021 CHK 1011 GEORGE T. HALL COMPANY, INC. MATERIALS 7,829.04 131000 11/10/2021 CHK 31 POULIN STEEL FAB INC. MATERIALS 8,844.98 32688 11/10/2021 DO 9503810 CDW GOVERNMENT INC. LICENSING, MAINTENANCE & SUPPORT 14,708.99 5150 11/10/2021 WIRE 540 CALIPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 11/05/2021 20,767.97 5152 11/10/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 11/05/2021 20,944.81 5147 11/10/2021 WIRE 38241CMA RETIREMENTTRUST 457 ICMA CONTRIBUTIONS PPE 11/O5/2021 24,089.03 32701 11/10/2021 DO 1430 JENNIFER STOLL ARCHITECT TDPUD FACILITY MODERNIZATION 29,866.42 5148 11/10/2021 WIRE 11233 CALIPERS PENSION 50,611.16 5149 11/10/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 11/05/2021 87,796.27 5146 11/10/2021 PL PL Payroll Payroll Direct Deposit 211,282.67 130988 11/10/2021 CHK 1294 CHASE LOAN: 2016 COP 334,187.15 5160 11/18/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9632 FINAL 105.15 5159 11/18/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 9632 FINAL 513.40 131007 11/18/2021 PL PL Payroll Payroll Final Check 1,641.55 32723 11/19/2021 DO 3515 GRAYBAR ELECTRIC CO INC MATERIALS - 131024 11/19/2021 CHK 99999 DAVID OH CUSTOMER REFUND -CLOSED ACCOUNT 1.00 131013 11/19/2021 CHK 99999 ELI FRASER CUSTOMER REFUND -CLOSED ACCOUNT 2.52 131021 11/19/2021 CHK 970 NORTHERN CALIFORNIA JOINT POLE ASSN MEMBERSHIP DUES 6.83 32740 11/19/2021 DO 630 WESTERN AREA POWER ADMINISTRATION ENVIRONMENTAL COMPLIANCE FEES 13.83 131016 11/19/2021 CHK 99999 JEANPIERRE HURTADO BACANEGRA CUSTOMER REFUND -CLOSED ACCOUNT 35.58 32722 11/19/2021 DO 3480 GRAINGER INC. OFFICE SUPPLIES 57.39 131026 11/19/2021 CHK 675 SHERWIN-WILLIAMS MATERIALS 69.52 32728 11/19/2021 DO 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 70.58 131009 11/19/2021 CHK 240 AUDIO ON -HOLD ON -HOLD PHONE SYSTEM 79.00 32719 11/19/2021 DO 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 80.00 131017 11/19/2021 CHK 9600 NEIL KAUFMAN MEMBERSHIP DUES 90.00 32729 11/19/2021 DO 161 NEW PIG CORPORATION MISC PARTS & SUPPLIES 93.83 32715 11/19/2021 DO 228 ALLIED ELECTRONICS INC. MATERIALS 119.08 131030 11/19/2021 CHK 1062 TESSCO INCORPORATED MATERIALS 134.34 131028 11/19/2021 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY WATER SAMPLE ANALYSIS 150.00 131034 11/19/2021 CHK 7380 UNITED PARCEL SERVICE UPS 188.36 32725 11/19/2021 DO 1099 MOANA NURSERY PROFESSIONAL SERVICES: OTHER 190.00 32720 11/19/2021 DO 3340 GENERAL PACIFIC INC EMPLOYEE UNIFORM 193.45 32727 11/19/2021 DO 617 MOUNTAIN EAP WELLNESS PROGRAM 225.00 131027 11/19/2021 CHK 99999 KYLE STEWART CUSTOMER REFUND -CLOSED ACCOUNT 285.97 131012 11/19/2021 CHK 2222 FRANK STRATTON'S JUST FIX IT MATERIALS 290.00 32733 11/19/2021 DO 9923 STEVEN PONCELET MEETING EXPENSES 302.96 131022 11/19/2021 CHK 5151 NRECA HEALTH 125 ADMINISTRATIVE FEES 307.50 32736 11/19/2021 DO 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 331.74 32726 11/19/2021 DO 10008 MOTION & FLOW CONTROL PRODUCTS, INC. FIELD SUPPLIES 337.39 131033 11/19/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 345.77 32737 11/19/2021 DO 1446 TRUELOOK, INC. MATERIALS 349.00 131031 11/19/2021 CHK 242 THOLL FENCE INC. MATERIALS 350.00 131023 11/19/2021 CHK 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 356.40 131015 11/19/2021 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS 396.34 32742 11/19/2021 DO 9575 EMPLOYEE VISION REIMBURSEMENT 400.00 131010 11/19/2021 CHK 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING, MAINTENANCE & SUPPORT 491.73 32731 11/19/2021 DO 820 ONESOURCE DISTRIBUTORS MATERIALS 532.53 131019 11/19/2021 CHK 1132 LEAF OFFICE SUPPLIES 549.34 131014 11/19/2021 CHK 999 GLA MORRIS CONSTRUCTION, INC. REFUND ELECTRIC FEES 719.00 131011 11/19/2021 CHK 348 EDGES ELECTRICAL GROUP MATERIALS 841.39 32717 11/19/2021 DO 829 CDS GLOBAL REMITTANCE PROCESSING 848.58 32716 11/19/2021 DO 10367 CCMEDIA MARKETING 866.00 131035 11/19/2021 CHK 643 UNITEDSITE SERVICESOF NEVADA MATERIALS 990.21 131025 11/19/2021 CHK 31 POULIN STEEL FAB INC. MATERIALS 1,324.95 32741 11/19/2021 DO 816 WESTERN ENVIRONMENTAL TESTING WATER SAMPLE ANALYSIS 1,338.00 131008 11/19/2021 CHK 134 ANIXTER INC. W SCADA REPLACEMENT PROJECT 1,515.50 32718 11/19/2021 DO 981 CRMORBIT INC LICENSING, MAINTENANCE & SUPPORT 2,475.00 32735 11/19/2021 DO 1466 ROADSAFE TRAFFIC SYSTEMS MATERIALS 2,480.00 32732 11/19/2021 DO 9504397 PACE SUPPLY MATERIALS 2,806.18 131029 11/19/2021 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 2,896.67 32724 11/19/2021 DO 778 HDR ENGINEERING INC PROFESSIONAL SERVICES: ENGINEERING 4,512.36 131032 11/19/2021 CHK 10233 TRUCKEE-NORTH TAHOE MATERIAL MARTIS VALLEY GENERATOR PURCHASE 5,026.69 32734 11/19/2021 DO 5730 PORTERSIMON LEGAL SERVICES 6,050.00 32721 11/19/2021 DO 1440 GLOBAL SOFTWARE LLC LICENSING, MAINTENANCE & SUPPORT 6,361.92 131020 11/19/2021 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 6,523.05 32739 11/19/2021 DO 1448 WATTS REGULATOR CO MATERIALS 7,032.65 32730 11/19/2021 DO 289 NISC OCTOBER 2021 RECURRRING INVOICE 12,062.82 131018 11/19/2021 CHK 1067 LAKESIDE PAVING & SEALING MATERIALS 18,800.00 32738 11/19/2021 DO 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 26,449.26 Page 2of3 Page 5 of 12 ChecklTran Date TDB Vendor Vendor Name Reference Amount 32743 11/19/2021 DD 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 59,558.48 131039 11/23/2021 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY 2022 PIPELINE REPLACEMENT PROJECT 100.00 131037 11/23/2021 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 11/19/2021 115.38 131038 11/23/2021 CHK 1491 JUDGE JANET BERRY(RET.) PROFESSIONAL SERVICES: GENERAL COUNSEL 3,000.00 32821 11/23/2021 DD 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,300.00 131036 11/23/2021 CHK 10541 BAR OF AMERICA EMPLOYEE RECOGNITION BANQUET 6,750.00 5166 11/24/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 11/19/21 629.37 5167 11/24/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 11/19/2021 17,386.25 5164 11/24/2021 WIRE 540 CALIPERS 457 DEFERRED COMP PRGM CALIPERS 457 CONTRIBUTIONS PPE 11/19/2021 18,647.47 5162 11/24/2021 WIRE 38241CMA RETIREMENTTRUST 457 ICMA CONTRIBUTIONS PPE 11/19/2021 23,066.51 5163 11/24/2021 WIRE 11233 CALIPERS PENSION 50,105.91 5165 11/24/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 11/19/2021 77,054.06 5158 11/24/2021 PL PL Payroll Payroll Direct Deposit 199,056.34 192 a 3,139,690.90 Page 3of3 Page 6 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 10/31/2021 Page 1 of 2 Electric Dept Water Dept Total Balance in General Fund 9/30/2021 $12,538,406 $5,264,786 $17,803,192 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 Voided checks Distribute UPTIF interest Restrict facilities fees Restrict Donner Lake surcharge Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 10/31/2021 2,000,278 1,191,018 3,191,295 18,613 - 18,613 3,876 836 4,711 - 29,682 29,682 (23,818) - (23,818) 20,803 - 20,803 2,019,751 1,221,535 $3,241,286 $2,394,926 $1,162,099 $3,557,025 (521) - (521) 1,445 885 2,330 25,501 89,700 115,201 - 1,219 1,219 12,282 - 12,282 7,873 - 7,873 $2,441,505 $1,253,904 $3,695,409 $12,116,652 $5,232,417 $17,349,069 12/17/2021 2:19 PM I:\Treasurers Report\Statement of General Fund\2021\2021-10 GF Page 7 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 10/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 20,803 - 20,803 2,168,276 - 2,168,276 9,925,173 5,232,417 15,157,590 $12,116,652 $5,232,417 $17,349,069 $60,925 $22,805 $83,730 $12,177,577 $5,255,222 $17,432,798 14,424,568 4,173,634 18,598,201 - 0 0 - 666,486 666,486 354,732 - 354,732 - 8,661 8,661 - 818,971 818,971 - 40,560 40,560 14,779,300 5,708,312 20,487,612 48,060 14,220 62,280 14,827,360 5,722,532 20,549,892 27,004,937 10,977,753 37,982,691 108,985 37,025 146,010 12/17/2021 2:19 PM I:\Treasurers Report\Statement of General Fund\2021\2021-10 GF Page 8 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 10/31/2021 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2020 9/30/2021 Activity 10/31/2021 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.20% (0.21%) General Fund 1..136.1 Consolidate cash Quarterly Investment Income payment received $ 6,968,896 $ 2,167,800 $ (25,926) $ 2,141,874 (28,918) 2,992.88 Capital Replacement Fund 136.41 1,181,925 1,444,178 1,629 1,445,806 Quarterly Investment Income payment received 1,629 AB 32 Cap & Trade Fund 1..136.58 1,606,959 781,323 493 781,816 Reimburse for Horse Butte Power 493 Deferred Liabilites Reserve 1..136.42 2,085,918 2,093,274 1,124 2,094,398 Quarterly Investment Income payment received 1,124 Total LAIF Electric Investments 11,843,699 6,486,575 (22,680) 6,463,894 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.33% (0.32%) General Fund 1..136.12 1,690,317 1,403,387 (26,578) 1,376,809 Distribute UPTIF interest (1,445) Restrict facility fees (25,501) Record monthly interest 368 Facilities Fees 1..136.9 748,126 967,707 25,755 993,462 Restrict facilites fees 25,501 Record monthly interest 254 Electric Rate Reserve Fund 1..136.45 1,604,909 2,100,575 551 2,101,125 Record monthly interest 551 Capital Replacement Fund 136.46 833,092 835,664 219 835,883 Record monthly interest 219 Electric Vehicle Reserve 1..136.13 626,347 199,266 52 199,318 Record monthly interest 52 Total UPTIF Electric Investments 5,502,792 5,506,599 (1) 5,506,597 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.12% (0.22%) Electric General Fund PC1..136.49 524,852 2,439,537 402 2,439,939 Record monthly interest 447 TVI Interest Receivable (45) Electric Rate Reserve Fund 1..136.47 4,333,619 2,347,358 476 2,347,834 Record monthly interest 430 TVI Interest Recievable 45 Capital Replacement Fund 1..136.48 1,621,632 1,624,627 298 1,624,925 Record monthly interest 298 Total PCIF County Electric Investments 6,480,103 6,411,523 1,176 6,412,699 TVI INVESTMENTS- 0.55%(0.55%) General Fund TVI 1..136.15 3,966,550 3,966,550 Electric Rate Reserve Fund 1..136.44 2,000,000 2,000,000 Total TVI Electric Investments 5,966,550 5,966,550 Total Electric Investments $ 23,826,594 $ 24,371,247 $ (21,506) $ 24,349,741 12/17/2021 2:34 PM Investments Status Report I:\Treasurers Report\Investment Status Repons\2021\2021-10 Investments Status Report Page 1of3 Page 9 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 10/31/2021 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2020 9/30/2021 Activity 10/31/2021 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.20% (0.21%) General Fund 2..136.1 1,861,580 112,463 (60,249) 52,214 Consolidate cash 28,918 Quarterly Investment Income payment received 533 Restrict facility fees (89,700) DSC Operating Reserve Fund 2..136.47 76,677 (0) (0) Facilities Fees 2..136.90 948,794 1,584,866 90,866 1,675,732 Restrict facility fees 89,700 Quarterly Investment Income payment received 1,166 SRF/DLAD Reserve Fund 2..125.5 826,526 Capital Replacement Fund 2..136.41 1,015,747 1,015,747 DLAD Invested 2..136.82 Total LAIF Water Investments 2,887,052 2,713,076 30,617 2,743,693 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.33% (0.32%) General Fund 2..136.12 848,478 1,155,937 27,880 1,183,817 Transfer to DLAD surcharge (1,219) Distribute UPTIF interest (885) DL Surcharge Reimbursement for 2006 COP 29,682 Record monthly interest 303 Facilities Fees 2..136.25 890,402 625,688 (29,518) 596,170 Record monthly interest 164 Transfer to GF for FF Funding portion of 2006 COP (29,682) West River St. Assessment District 2..136.31 38,065 38,182 10 38,192 Record monthly interest 10 Prepaid Connection Fees 2..136.7 77,788 78,029 20 78,049 Record monthly interest 20 Donner Lake Assessment District Fund 2..136.84 664,261 666,311 175 666,486 Record monthly interest 175 Donner Lake Assessment District Surcharge Fund 2..136.61 147,937 159,302 1,261 160,563 DLAD surcharge collections 9,237 DL Surcharge Reimbursement to GF for 2006 COP (8,018) Record monthly interest 42 TSA SAD II Improvement Fund 2..136.85 18,363 18,420 5 18,425 Record monthly interest 5 Water Vehicle Reserve 2..136.13 197,987 484,047 127 484,174 Record monthly interest 127 Deferred Liabilites Reserve 2..136.42 106,226 106,554 28 106,582 Record monthly interest 28 Prop 55 Reserve Fund 2..125.94 340,762 0 0 Total UPTIF Water Investments 3,330,269 3,332,470 (12) 3,332,458 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.12% (0.22%) Water General Fund PC 2..136.5 375,541 215 215 DSC Operating Reserve Fund 2..136.49 1,541,769 0 0 Total PCIF Water Investments 1,917,311 215 215 12/17/2021 2:34 PM Investments Status Report I:\Treasurers Report\Investment Status Repons\2021\2021-10 Investments Status Report Page 2of3 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 10/31/2021 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2020 9/30/2021 Activity 10/31/2021 3,996,171 0 3,996,171 3,996,171 0 3,996,171 Total Water Investments $ 8,134,631 $ 10,041,932 $ 30,605 $ 10,072,537 ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Pre - Market Adjustments Total LAIF Investments 27% 14,730,751 9,199,651 7,937 9,207,587 Total UPTIF Investments 26% 8,833,060 8,839,068 (13) 8,839,055 Total PCIF Investments 19% 8,397,414 6,411,738 1,176 6,412,913 Total TVI Investments 29% - 9,962,722 0 9,962,722 Total Investments 100% Month End Bal.Mix $ 31,961,225 $ 34,413,178 $ 9,099 $ 34,422,277 Market Adjustments Total LAIF Investments 67,341 33,458 - 33,458 Total UPTIF Investments 33,897 33,897 33,897 Total PCIF Investments 62,280 62,280 - 62,280 Total TVI Investments - 15,099 1,275 16,374 Total Investments $ 163,518 $ 144,735 $ 1,275 $ 146,010 Post - Market Adjustments Total LAIF Investments 27% 14,798,091 9,233,109 7,937 9,241,045 Total UPTIF Investments 26 % 8,866,958 8,872,966 (13) 8,872,952 Total PCIF Investments 19% 8,459,694 6,474,018 1,176 6,475,194 Total TVI Investments 29 % 9,977,821 1,275 9,979,096 Total Investments 100% Month End Bal.Mix $ 32,124,743 $ 34,557,913 $ 10,374 $ 34,568,287 12/17/2021 2:34 PM Investments Status Report I:\Treasurers Report\Investment Status Reports\2021\2021-10 Investments 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 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 October 31, 2021 Utah Public TVI Fidelity Mmkt Morgan Stanley Dreyfus Treasury Federated US US Bank Cash/ LAIF Placer County Investment Fund Investments Govt 57 Treas Sec Port Security Treas Cash Res Checking cash clearings Total 131.1 $ 2,141,874 $ 2,439,939 $ 1,376,809 $ 3,966,550 $ $ $ $ $ 2,168,276 $ 23,203 $ 12,116,652 - - 993,462 - - - 993,462 - 2,347,834 2,101,125 2,000,000 6,448,959 1,445,806 1,624,925 835,883 - 3,906,614 2,094,398 - - 354,732 2,449,130 - 199,318 - 199,318 781,816 - - - 781,816 26,760 48,060 21,117 13,048 - 108,985 6,490,654 6,460,759 5,527,715 5,979,598 354,732 2,168,276 23,203 27,004,937 $ 52,214 $ 215 $ 1,183,817 $ 3,996,171 $ $ $ - $ $ - $ - 5,232,417 1,675,732 - 596,170 - 2,271,902 1,015,747 - 1,015,747 - 827,632 827,632 (0) 0 0 38,192 38,192 106,582 106,582 78,049 78,049 666,486 40,560 707,046 160,563 - 160,563 18,425 18,425 - - 484,174 - 484,174 6,698 14,220 12,780 3,326 - - 37,025 2,750,391 14,435 3,345,238 3,999,498 827,632 - 40,560 - 10,977,753 9,241,045 6,475,194 8,872,952 9,979,096 827,632 354,732 2,208,836 23,203 37,982,691 - - - - - 341,675 39 - - 341,713 - 341,675 39 - 341,713 1,908,814 - - 595,133 2,503,947 1,908,814 595,133 2,503,947 $ 11,149,859 $ 6,475,194 $ 8,872,952 $ 9,979,096 $ 827,632 $ 341,675 $ 354,771 $ 595,133 $ 2,208,836 $ 23,203 $ 40,828,351 2021 09 Last Month End Balances 11,141,923 6,474,018 8,872,966 9,977,821 737,227 270,738 337,025 590,402 2,575,474 26,218 41,003,812 Change from last month 7,937 1,176 (13) 1,275 90,404 70,936 17,746 4,731 (366,638) (3,015) (175,461) 202010 PY Month End Balances 17,505,193 8,358,158 8,877,291 - 818,833 312,603 350,365 739,370 1,841,963 1,841,963 40,645,740 Change from PY Month (6,355,334) (1,882,965) (4,339) 9,979,096 8,799 29,072 4,406 (144,237) 366,873 (1,818,760) 182,611 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 (6,375,768) (1,984,500) 5,995 9,979,096 689,951 35,492 349,056 (174,133) (426,229) (417,616) 1,681,343 I:\Treasurers Report\2022\2G22- Treasurer's Mp-rt All Investments 20211G S55 Page 12 of 12