Loading...
HomeMy WebLinkAbout18 2020-09 Treasurers Report Final - Cover pageTRUCKEE DONNER Public Utility District MEETING DATE: September 2, 2020 TO: Board of Directors AGENDA ITEM #18 FROM: Michael Salmon, Chief Financial Officer SUBJECT: Approval of the Treasurer's Report: September 2020 Page 1 of 1 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT September 16, 2020 Fund Balances for the Month Ended July 31, 2020 And Disbursements for the Month Ended August 31, 2020 Page 1 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending July 31, 2020 and disbursements for August 2020. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for August 2020 were $2,898,599.86. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during August 2020 total $2,898,599.86. 3) STATEMENT OF GENERAL FUND: As of July 31, 2020 the balance in the General Fund was $12,268,461 (Electric $9,719,966 and Water $2,548,494). 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 the Federal Farm Credit Investment as of July 31, 2020 was $36,031,131 ($24,396,919 electric and $11,634,212 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: 1 YR T LAIF PCIF UPTIF BILL July 2019 2.38% 2.08% 2.87% 1.94% August 2019 2.34% 1.96% 2.73% 1.72% September 2019 2.28% 1.96% 2.60% 1.71 % October 2019 2.19% 1.84% 2.54% 1.49% November 2019 2.10% 1.93% 2.40% 1.56% December 2019 2.04% 1.70% 2.28% 1.55% January 2020 1.97% 1.78% 2.20% 1.41 % February 2020 1.91 % 1.80% 2.10% 0.95% March 2020 1.79% 1.54% 1.66% 0.17% April 2020 1.65% 1.23% 1.44% 0.16% May 2020 1.36% 1.19% 1.19% 0.17% June 2020 1.22% 1.19% 0.95% 0.16% July 2020 0.92% 0.98% 0.74% 0.11 % 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 2020 totaled $2,898,599.86. A listing of those disbursements is attached. Page 3 of 12 Truckee Donner Public Utility District Check Register August2020 ChecklTran Date Type Vendor 128949 8/5/2020 CHK 99999 128953 8/5/2020 CHK 99999 128950 8/5/2020 CHK 99999 128951 8/5/2020 CHK 99999 128952 8/5/2020 CHK 99999 128948 8/5/2020 CHK 99999 28791 8/5/2020 DD 6403 28790 8/5/2020 DD 1397 28792 8/5/2020 DD 26 28793 8/5/2020 DD 10584 4760 8/6/2020 WIRE 905 4756 8/6/2020 WIRE 3824 4759 8/6/2020 WIRE 540 4761 8/6/2020 WIRE 3094 4757 8/6/2020 WIRE 11233 4758 8/6/2020 WIRE 7310 4751 8/6/2020 PL PL 28832 8/14/2020 DD 7300 128987 8/14/2020 CHK 1079 128979 8/14/2020 CHK 10932 28803 8/14/2020 DD 39 28837 8/14/2020 DD 630 129009 8/14/2020 CHK 7320 128983 8/14/2020 CHK 99999 128972 8/14/2020 CHK 44444 128975 8/14/2020 CHK 44444 128980 8/14/2020 CHK 44444 129001 8/14/2020 CHK 719 28827 8/14/2020 DD 10414 128999 8/14/2020 CHK 669 128959 8/14/2020 CHK 240 128960 8/14/2020 CHK 99999 28829 8/14/2020 DD 6880 128964 8/14/2020 CHK 44444 128965 8/14/2020 CHK 44444 129005 8/14/2020 CHK 1357 128992 8/14/2020 CHK 99999 128963 8/14/2020 CHK 6731 129002 8/14/2020 CHK 6860 28835 8/14/2020 DD 10380 128977 8/14/2020 CHK 1120 128988 8/14/2020 CHK 5222 129010 8/14/2020 CHK 1308 128998 8/14/2020 CHK 9985 128984 8/14/2020 CHK 617 28800 8/14/2020 DD 9205 128991 8/14/2020 CHK 10004 129012 8/14/2020 CHK 7380 28794 8/14/2020 DD 228 129006 8/14/2020 CHK 9979 128997 8/14/2020 CHK 716 28828 8/14/2020 DD 3826 128973 8/14/2020 CHK 35 129011 8/14/2020 CHK 2236 28816 8/14/2020 DD 4720 128995 8/14/2020 CHK 1082 28814 8/14/2020 DD 9637 129013 8/14/2020 CHK 643 129007 8/14/2020 CHK 608 128996 8/14/2020 CHK 837 128982 8/14/2020 CHK 1149 128967 8/14/2020 CHK 10489 28826 8/14/2020 DD 1427 128955 8/14/2020 CHK 10816 128968 8/14/2020 CHK 44444 28813 8/14/2020 DD 1305 128958 8/14/2020 CHK 657 128978 8/14/2020 CHK 186 128954 8/14/2020 CHK 1441 28810 8/14/2020 DD 3480 128969 8/14/2020 CHK 348 28825 8/14/2020 DD 181 28833 8/14/2020 DD 973 128971 8/14/2020 CHK 44444 28798 8/14/2020 DD 829 128966 8/14/2020 CHK 1073 28808 8/14/2020 DD 3340 28795 8/14/2020 DD 5440 28830 8/14/2020 DD 6360 28805 8/14/2020 DD 1167 28807 8/14/2020 DD 848 28804 8/14/2020 DD 524 128989 8/14/2020 CHK 1285 Vendor Name LETA FRITZ ERIC WORMOOD KFSM LLC ARTHUR LOPEZ OTIS R WALTON GERALD ALDERSON NEVADA POWER COMPANY CONCORD UTILITY SERVICES THE BANK OF NEW YORK MELLON LAMPS HEALTHEQUITY INC. ICMA RETIREMENT TRUST 457 CALPERS 457 DEFERRED COMP PRGM EMPLOYMENT DEV DEPT CALPERS INTERNAL REVENUE SERVICE Payroll TRUCKEE RENTS INC O'REI LLY AUTO PARTS J & L FOOD MART & CARWASH CROSSROADS CARWASH WESTERN AREA POWER ADMINISTRATION TRUCKEE TAHOE LUMBER CO JOHN MORTON EUGENE GINI GARTH GARTRELL KEN PANZIERA T-MOBILE SNAP -ON INDUSTRIAL STATE WATER RESOURCES CONTROL BOARD AUDIO ON -HOLD AVERY BROWN TAHOE INSTANT PRESS CARYSTEVENS CARY STEVENS THE UNION LINDA SANFORD CALIFORNIA DEPARTMENT OF TAX AND FEE TAHOE FOREST HEALTH SYSTEM ULINE GEOSPATIAL EXPERTS OFFICE DEPOT INC. TRUCKEE TIRE EMPLOYEE MOUNTAIN EAP EMPLOYEE RENO FORKLIFT UNITED PARCEL SERVICE ALLIED ELECTRONICS INC. EMPLOYEE SMALLPOND STUDIO STONE'S COUNTRYTIRE FLEETPROS UNIFIRST MOUNTAIN HARDWARE AND SPORTS SIERRA NEVADA AD PARTNERS EMPLOYEE UNITED SITE SERVICES OF NEVADA TOKAYSOFTWARE SIERRA OFFICE SOLUTIONS LOOMIS CORELOGIC INFORMATION SOLUTIONS INC SMARTSHEET INC. ALL SEASONS CARPET & UPHOLSTERY CLEANING DAVID ARNOLD JW WELDING SUPPLIES & TOOLS AT&T GRANITE CONSTRUCTION COMPANY AIS SPECIALTY PRODUCTS INC GRAINGER INC. EDGES ELECTRICAL GROUP SILVER STATE ANALYTICAL LABORATORIES, IN TRUCKEE TAHOE HOME IMPROVEMENT LLC ERIKJOHNSON CDS GLOBAL CLEAN MACHINE GENERAL PACIFIC INC ALTEC INDUSTRIES INC THATCHER COMPANY OF CALIFORNIA, INC EAST RIVER PR FASTENAL DE LAGE LANDEN OPERATIONAL SERVICES LLC ORANGE COAST TITLE COMPANY Reference CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT PURCHASED POWER - NV ENERGY ACLARA MTU REPLACEMENT PROJECT WARRANTY DEBT PAYMENTS PURCHASED POWER - UAMPS EMPLOYEE HSA CONTRIBUTIONS PPE 07/31/20 ICMA CONTRIBUTIONS PPE 07/31/2020 CALIPERS 457 CONTRIBUTIONS PPE 07/31/2020 SDI/STATE WITHHOLDING PPE 07/31/2020 PENSION FEDERAL/FICA WITHHOLDING PPE 07/31/2020 Payroll Direct Deposit MATERIALS REPAIRS & MAINTENANCE FUEL FOR VEHICLES REPAIRS & MAINTENANCE ENVIRONMENTAL COMPLIANCE FEES BUILDING MAINTENANCE CUSTOMER REFUND - CLOSED ACCOUNT REFRIGERATOR RECYCLE REFRIGERATOR RECYCLE REFRIGERATOR RECYCLE SANDEL-AVERY ALARM MATERIALS GRADE T1 RENEWAL ON -HOLD PHONE SYSTEM CUSTOMER REFUND - CLOSED ACCOUNT OFFICE SUPPLIES APPLIANCE REBATE - ELECTRIC TOILET REBATE GENERAL ADVERTISEMENT CUSTOMER REFUND - CLOSED ACCOUNT SALES TAX PAYABLE PERSONNEL EXPENSES FIELD SUPPLIES LICENSING, MAINTENANCE & SUPPORT OFFICE SUPPLIES REPAIRS & MAINTENANCE VISION REIMBURSEMENT WELLNESS PROGRAM VISION REIMBURSEMENT REPAIRS & MAINTENANCE UPS CHARGES SAFETY SUPPLIES VISION REIMBURSEMENT MARKETING REPAIRS & MAINTENANCE MEMBERSHIP DUES EMPLOYEE UNIFORM CLEANING SERVICES MATERIALS OFFICE SUPPLIES VISION REIMBURSEMENT MATERIALS LICENSING, MAINTENANCE & SUPPORT XEROX COPIER LEASE BANKING CHARGES LICENSING, MAINTENANCE & SUPPORT LICENSING, MAINTENANCE & SUPPORT BUILDING MAINTENANCE EV REBATE MATERIALS COMMUNICATIONS MATERIALS FACILITY SUPPLIES ACLARA MTU REPLACEMENT PROJECT WARRANTY MATERIALS WATER SAMPLE ANALYSIS REFRIGERATOR RECYCLE WATER HEATER REBATE REMITTANCE PROCESSING REPAIRS & MAINTENANCE MATERIALS REPAIRS & MAINTENANCE WATER QUALITY: TREATMENT PROFESSIONAL SERVICES: MARKETING MATERIALS XEROX COPIER LEASE GC MR ANNUAL ADMIN COSTS Amount 3.89 53.17 69.71 87.87 107.19 1,294.58 15,363.80 20,611.20 176,897.85 670,734.87 417.01 17,851.33 19,435.25 19,851.37 59,857.91 90,318.04 183,493.79 8.97 10.34 10.82 13.20 19.35 24.46 32.37 35.00 35.00 35.00 38.39 54.75 55.00 79.00 80.22 86.22 100.00 100.00 107.35 131.85 134.00 134.50 173.16 199.00 204.11 216.50 216.53 225.00 230.00 299.86 306.44 319.34 330.10 343.75 345.56 360.00 364.06 390.31 395.00 400.00 411.87 430.00 452.38 459.07 477.41 478.45 500.00 500.00 500.63 541.85 605.07 718.66 795.30 811.02 823.00 1,000.00 1,000.00 1,024.24 1,200.00 1,257.03 1,397.14 1,459.76 1,475.00 1,487.57 1,499.41 1,500.00 Page 4 of 12 Checkrrran Date Type Vendor 128961 8/14/2020 CHK 381 28838 8/14/2020 DO 10678 28823 8/14/2020 DO 1013 28834 8/14/2020 DO 448 129000 8/14/2020 CHK 349 28806 8/14/2020 DO 1036 129003 8/14/2020 CHK 6920 28821 8/14/2020 DO 5730 129008 8/14/2020 CHK 10050 129014 8/14/2020 CHK 7820 128974 8/14/2020 CHK 1790 129004 8/14/2020 CHK 548 28811 8/14/2020 DO 778 128970 8/14/2020 CHK 3096 28802 8/14/2020 DO 577 128994 8/14/2020 CHK 4447 128976 8/14/2020 CHK 10645 128993 8/14/2020 CHK 1034 128981 8/14/2020 CHK 6401 28812 8/14/2020 DO 3820 28796 8/14/2020 DO 1243 28797 8/14/2020 DO 1359 128956 8/14/2020 CHK 1181 128962 8/14/2020 CHK 920 28831 8/14/2020 DO 1328 28836 8/14/2020 DO 10737 28817 8/14/2020 DO 5130 28799 8/14/2020 DO 9503810 128985 8/14/2020 CHK 5151 28822 8/14/2020 DO 1380 128990 8/14/2020 CHK 10808 28809 8/14/2020 DO 3322 28819 8/14/2020 DO 289 28801 8/14/2020 DO 1397 28820 8/14/2020 DO 820 128957 8/14/2020 CHK 134 28839 8/14/2020 DO 1321 28818 8/14/2020 DO 923 28824 8/14/2020 DO 6402 28815 8/14/2020 DO 257 128986 8/14/2020 CHK 5150 4766 8/20/2020 WIRE 905 4762 8/20/2020 WIRE 3824 4767 8/20/2020 WIRE 3094 4765 8/20/2020 WIRE 540 4763 8/20/2020 WIRE 11233 4764 8/20/2020 WIRE 7310 4754 8/20/2020 PL PL 129032 8/21/2020 CHK 1079 129027 8/21/2020 CHK 115 28919 8/21/2020 DO 4720 28915 8/21/2020 DO 10650 129036 8/21/2020 CHK 900 129021 8/21/2020 CHK 348 129038 8/21/2020 CHK 669 129025 8/21/2020 CHK 905 129020 8/21/2020 CHK 99999 129018 8/21/2020 CHK 5860 28931 8/21/2020 DO 10380 129030 8/21/2020 CHK 99999 129024 8/21/2020 CHK 99999 129022 8/21/2020 CHK 99999 129033 8/21/2020 CHK 5222 129028 8/21/2020 CHK 99999 28917 8/21/2020 DO 9467 28911 8/21/2020 DO 228 28922 8/21/2020 DO 5070 28927 8/21/2020 DO 6847 28924 8/21/2020 DO 9945 28925 8/21/2020 DO 181 28926 8/21/2020 DO 7313 129047 8/21/2020 CHK 99999 28918 8/21/2020 DO 965 129044 8/21/2020 CHK 2236 28916 8/21/2020 DO 3340 129026 8/21/2020 CHK 1176 129029 8/21/2020 CHK 10008 129043 8/21/2020 CHK 10233 129034 8/21/2020 CHK 10331 28921 8/21/2020 DO 775 129040 8/21/2020 CHK 1357 129046 8/21/2020 CHK 7820 129019 8/21/2020 CHK 657 129042 8/21/2020 CHK 10206 129031 8/21/2020 CHK 494 28913 8/21/2020 DO 10367 Vendor Name CAL-NEVADA TOWING WILLDAN FINANCIAL SERVICES SIERRA ENERGY PROFESSIONALS TRUCKEE TAHOE RADIO LLC STRADLING YOCCA CARLSON & RAUTH P.C. ESCI TAHOE TRUCKEE SIERRA DISPOSAL PORTER SIMON TOWN OF TRUCKEE WESTERN NEVADA SUPPLY FLYERS ENERGY LLC THE AUTO &TIRE DOCTOR INC. HDR ENGINEERING INC EMPLOYMENT DEVELOMENT DEPT. COOPERATIVE RESPONSE CENTER INC. SO MYERS INC. GEI CONSULTANTS INC SCHNEIDER ELECTRIC SYSTEMS USA, INC LIBERTY UTILITIES IBEW LOCAL 1245 CALIFORNIA SPECIAL DISTRICTS ASSOCIATION CALPERS AMAZON/SYNCB CALIFORNIA AIR RESOURCES BOARD TRAFFIC MANAGEMENT, INC. US BANK GOVERNMENT SERVICES NCPA CDW GOVERNMENT INC. NRECA SHAFER EQUIPMENT COMPANY INC RAILROAD MANAGEMENT CO LLC GEXPRO NISC CONCORD UTILITY SERVICES ONESOURCE DISTRIBUTORS ANIXTER INC. WRIGHT TREE SERVICE, INC. NETXPERTSINC SIERRA PACIFIC POWER CO LONGO INCORPORATED NRECA GROUP BENEFITS TRUST HEALTHEQUITY INC. ICMA RETIREMENT TRUST 457 EMPLOYMENT DEV DEPT CALPERS 457 DEFERRED COMP PRGM CALPERS INTERNAL REVENUE SERVICE Payroll O'REI LILY AUTO PARTS KIM BALL-M I DW EST MOUNTAIN HARDWARE AND SPORTS EUROFINS EATON ANALYTICAL INC. SIERRA MOUNTAIN PIPE & SUPPLY EDGES ELECTRICAL GROUP STATE WATER RESOURCES CONTROL BOARD HEALTHEQUITY INC. CHERYLE CUSTER ARAMARK UNIFORM SERVICES INC ULINE NAVOPACHE ELECTRIC COOPERATIVE NANCYS HAWTREY JOHN GASPARI OFFICE DEPOT INC. MOLLY KNICKERBOCKER EMPLOYEE ALLIED ELECTRONICS INC. PLATT TDPUD EMPLOYEES FLOWER FUND EMPLOYEE SILVER STATE ANALYTICAL LABORATORIES, IN TAHOE SUPPLY COMPANY VIRGINIA WILSON MOSS ADAMS UNIFIRST GENERAL PACIFIC INC CHRISTINE FJACKSON, O.D. MOTION & FLOW CONTROL PRODUCTS, INC. TRUCKEE-NORTH TAHOE MATERIAL RENO BUSINESS INTERIORS ONLINE INFORMATION SERVICES THE UNION WESTERN NEVADA SUPPLY AT&T TRUCKEE CHAMBER OF COMMERCE NVS, INC. CCMEDIA Reference REPAIRS & MAINTENANCE GC, OG, DLAD MR ANNUAL ADMIN COSTS RESIDENTIAL ENERGY SURVEY PROGRAM MARKETING GC MR ANNUAL ADMIN COSTS SAFETY MEETING LANDFILL CHARGES LEGAL SERVICES PEV STATION EXPENSES HYDRANT MAINTENANCE MATERIALS FUEL FOR VEHICLES REPAIRS & MAINTENANCE PROFESSIONAL SERVICES: OTHER UNEMPLOYEMENT INSURANCE ANSWERING SERVICE MATERIALS ENVIRONMENTAL COMPLIANCE FEES LICENSING, MAINTENANCE & SUPPORT ELECTRIC FOR PUMP STATION UNION DUES MEMBERSHIP DUES PENSION MATERIALS ENVIRONMENTAL COMPLIANCE FEES NORTHWOODS REBUILD CHAMONIX-MUHLEBACH CREDIT CARD CHARGES MEMBERSHIP DUES LICENSING, MAINTENANCE & SUPPORT INSURANCE 2020 FELLING DECK/DUMP TRAILER ENVIRONMENTAL COMPLIANCE FEES PURCHASE TRANSFORMERS JULY 2020 AMS ACLARA MTU REPLACEMENT PROJECT WARRANTY INVENTORY INVENTORY CONTRACT SERVICES: ROW TREE CLEARING FIBER REDUNDANCY SWITCH EXTENSION PURCHASED POWER - SPPC FACILITIES METERING IMPROVEMENTS INSURANCE EMPLOYEE HSA CONTRIBUTIONS PPE 08/14/20 ICMA CONTRIBUTIONS PPE 08/14/2020 SDI/STATE WITHHOLDING PPE O8/14/2020 CALIPERS 457 CONTRIBUTIONS PPE 08/14/2020 PENSION FEDERAL/FICA WITHHOLDING PPE 08/14/2020 Payroll Direct Deposit REPAIRS & MAINTENANCE MISC PARTS & SUPPLIES 2020 WATER SCADA SYSTEM REPLACEMENT WATER SAMPLE ANALYSIS MATERIALS MATERIALS T2 RENEWAL -C WALKER HEALTH 125 ADMINISTRATIVE FEES CUSTOMER REFUND - CLOSED ACCOUNT EMPLOYEE UNIFORM CLEANING SERVICES MATERIALS PAYMENT PROCESSED IN ERROR CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT FACILITY SUPPLIES CUSTOMER REFUND - CLOSED ACCOUNT VISION REIMBURSEMENT SCADA MATERIALS MATERIALS FLOWER FUND VISION REIMBURSEMENT WATER SAMPLE ANALYSIS FACILITY SUPPLIES CUSTOMER REFUND - CLOSED ACCOUNT PROFESSIONAL SERVICES - AUDIT EMPLOYEE UNIFORM CLEANING SERVICES INVENTORY VISION REIMBURSEMENT MATERIALS MATERIALS MATERIALS CREDIT CHECK SERIVCES GENERAL ADVERTISEMENT MATERIALS COMMUNICATIONS PROFESSIONAL SERVICES: OTHER FACILITIES METERING IMPROVEMENTS MARKETING Amount 1,645.00 1,777.25 2,000.00 2,000.00 2,399.59 2,406.25 3,997.70 4,000.00 4,000.00 4,025.40 4,152.58 5,002.79 5,198.75 5,481.00 5,496.09 5,601.00 5,658.24 5,964.00 6,352.99 6,742.40 7,615.00 9,243.00 9,444.78 9,654.00 10,311.00 11,269.20 11,575.00 12,000.00 16,767.39 17,698.72 17,734.79 18,203.86 19,852.80 20,718.55 30,002.68 33,082.59 39,227.20 44,015.72 62,497.93 62,683.38 191,819.17 417.01 18,913.74 22,943.66 26,424.43 57,929.87 103,883.34 206,393.12 9.19 29.76 42.85 50.00 54.13 58.11 60.00 66.30 74.68 78.18 100.34 103.28 108.23 108.60 127.92 136.24 155.55 167.80 211.00 212.00 238.34 240.00 258.37 265.38 300.00 352.87 392.43 400.00 417.05 422.89 463.31 478.85 551.00 627.68 783.37 800.00 825.80 866.00 Page 5 of 12 ChecklTran Date Type Vendor 129039 8/21/2020 CHK 6940 28914 8/21/2020 DD 1054 28932 8/21/2020 DD 4590 28923 8/21/2020 DD 1270 129015 8/21/2020 CHK 10360 28933 8/21/2020 DD 698 129035 8/21/2020 CHK 11302 129037 8/21/2020 CHK 10720 28928 8/21/2020 DD 1303 28912 8/21/2020 DD 5440 129017 8/21/2020 CHK 1443 129016 8/21/2020 CHK 1261 28920 8/21/2020 DD 820 129023 8/21/2020 CHK 3349 129041 8/21/2020 CHK 242 129045 8/21/2020 CHK 1188 28934 8/21/2020 DO 1321 28929 8/21/2020 DD 1328 28930 8/21/2020 DO 1183 28948 8/25/2020 DD 7300 129061 8/25/2020 CHK 10008 129063 8/25/2020 CHK 1079 28943 8/25/2020 DD 6880 129072 8/25/2020 CHK 1308 129067 8/25/2020 CHK 77 129055 8/25/2020 CHK 736 129073 8/25/2020 CHK 2236 28944 8/25/2020 DD 7313 129058 8/25/2020 CHK 115 28942 8/25/2020 DD 4720 28941 8/25/2020 DD 3480 129065 8/25/2020 CHK 1273 129064 8/25/2020 CHK 5222 129053 8/25/2020 CHK 193 129060 8/25/2020 CHK 2237 129077 8/25/2020 CHK 7821 129059 8/25/2020 CHK 1132 129051 8/25/2020 CHK 1073 129062 8/25/2020 CHK 5151 129056 8/25/2020 CHK 186 129069 8/25/2020 CHK 548 129076 8/25/2020 CHK 7820 129074 8/25/2020 CHK 643 129054 8/25/2020 CHK 348 129066 8/25/2020 CHK 31 28945 8/25/2020 DD 6360 28936 8/25/2020 DO 1251 129057 8/25/2020 CHK 3515 28946 8/25/2020 DD 1328 28949 8/25/2020 DD 4590 129068 8/25/2020 CHK 1436 129048 8/25/2020 CHK 1441 129050 8/25/2020 CHK 2235 28940 8/25/2020 DD 3340 28937 8/25/2020 DD 893 129070 8/25/2020 CHK 10434 129052 8/25/2020 CHK 1415 129075 8/25/2020 CHK 682 129071 8/25/2020 CHK 11041 129049 8/25/2020 CHK 134 28950 8/25/2020 DD 10737 28938 8/25/2020 DD 992 28935 8/25/2020 DD 1397 28939 8/25/2020 DD 949 28947 8/25/2020 DD 712 28951 8/25/2020 DD 1321 235 Vendor Name TAHOE TRUCKEE SANITATION AGENCY TERANCE COCHRANE, O.D. UNDERGROUND SERVICE ALERT OF NORTHERN RADIAN RESEARCH INC. AFLAC WILEY PRICE & RADULOVICH LLP SAGE LAND SURVEYING INC. SNOQUIP TITAN WIRE AND CABLE ALTEC INDUSTRIES INC AQUA SHIELD ENCLOSURES, LLC ANALYTICAL ENVIRONMENTAL SERVICES ONESOURCE DISTRIBUTORS GLOBALRENTALCOINC THOLL FENCE INC. UNIVERSITY OF NEVADA, RENO WRIGHT TREE SERVICE, INC. TRAFFIC MANAGEMENT, INC. TRUCKEE-CARSON IRRIGATION DISTRICT TRUCKEE RENTS INC MOTION & FLOW CONTROL PRODUCTS, INC. O'REI LLY AUTO PARTS TAHOE INSTANT PRESS TRUCKEE TIRE RENO BUICK GMC CADILLAC FACTORY MOTOR PARTS UNIFIRST TAHOE SUPPLY COMPANY KIM BALL-M I DW EST MOUNTAIN HARDWARE AND SPORTS GRAINGER INC. PFM INDUSTRIAL FINISHING OFFICE DEPOT INC. EASTERN REGIONAL LANDFILL MINASIAN, MEITH, SOARES, SEXTON & COOPER WESTERN NEVADA SUPPLY LEAF CLEAN MACHINE NRECA GRANITE CONSTRUCTION COMPANY THEAUTO &TIRE DOCTOR INC. WESTERN NEVADA SUPPLY UNITED SITE SERVICES OF NEVADA EDGES ELECTRICAL GROUP POULIN STEEL FAB INC. THATCHER COMPANY OF CALIFORNIA, INC CONSTRUCTION MATERIALS ENGINEERS, INC. GRAYBAR ELECTRIC CO INC TRAFFIC MANAGEMENT, INC. UNDERGROUND SERVICE ALERT OF NORTHERN SACTOWN CONTRACTORS CORP AIS SPECIALTY PRODUCTS INC CARSON INDUSTRIES INC. GENERAL PACIFIC INC DEBBIE MADERA CLEANING SERVICE TOP DOG TIMBER CRISIS INTERVENTION SERVICES VERIZON WIRELESS TRUCKEE PAINT MART INC. ANIXTER INC. US BANK GOVERNMENT SERVICES E & M ELECTRIC & MACHINERY INC CONCORD UTILITY SERVICES FERGUSON ENTERPRISES INC 1423 TRUCKEE DONNER PUD WRIGHT TREE SERVICE, INC. Reference WATER SAMPLE ANALYSIS VISION REIMBURSEMENT ENVIRONMENTAL COMPLIANCE FEES MATERIALS EMPLOYEE PAID INSURANCE PROFESSIONAL SERVICES: GENERAL COUNSEL MATERIALS REPAIRS & MAINTENANCE INVENTORY MATERIALS MATERIALS ENVIRONMENTAL COMPLIANCE FEES INVENTORY MATERIALS BUILDING MAINTENANCE EMPLOYEE DEVELOPMENT CONTRACT SERVICES: ROW TREE CLEARING NORTHWOODS REBUILD CHAMONIX- MUHLEBACH PURCHASED POWER -TCID MATERIALS MATERIALS REPAIRS & MAINTENANCE OFFICE SUPPLIES REPAIRS & MAINTENANCE REPAIRS & MAINTENANCE MISC PARTS & SUPPLIES EMPLOYEE UNIFORM CLEANING SERVICES FACILITY SUPPLIES MATERIALS MATERIALS MATERIALS REPAIRS & MAINTENANCE OFFICE SUPPLIES LANDFILL CHARGES PROFESSIONAL SERVICES: GENERAL COUNSEL TOILET EXCHANGE - DEAN SCHAECHER XEROX COPIER LEASE REPAIRS & MAINTENANCE HEALTH 125 ADMINISTRATIVE FEES MATERIALS REPAIRS & MAINTENANCE HYDRANT MAINTENANCE MATERIALS MATERIALS MATERIALS MATERIALS WATER QUALITY: TREATMENT HIGH ALTITIUDE FITNESS CLIMBING GYM INVENTORY MATERIALS MATERIALS WAREHOUSE LIGHTING UPGRADE PROJECT FACILITY SUPPLIES INVENTORY EMPLOYEE UNIFORMS BUILDING CLEANING MATERIALS INCOME QUALIFIED (ESP) CELL PHONE CHARGES MATERIALS INVENTORY CREDIT CARD CHARGES LICENSING, MAINTENANCE & SUPPORT ACLARA MTU REPLACEMENT PROJECT WARRANTY METERS PURCHASE PURCHASED POWER - STAMPEDE HYDRO GEN CONTRACT SERVICES: ROW TREE CLEARING Amount 875.00 932.00 993.48 1,100.00 1,113.96 1,518.00 1,750.00 1,769.12 2,057.81 2,986.16 4,966.00 5,600.00 6,979.85 8,711.23 9,250.98 11,094.86 21,092.64 38,791.50 43,183.91 47.60 60.84 73.03 86.22 88.00 104.07 130.85 168.14 185.39 186.86 205.23 208.46 250.00 260.77 272.00 320.00 341.97 549.34 570.00 570.00 607.92 664.85 796.40 909.53 1,101.75 1,350.00 1,459.76 1,755.00 1,844.15 2,121.00 2,188.40 2,317.34 2,873.08 3,473.42 3,912.48 6,100.00 7,153.00 7,860.00 7,959.56 8,016.89 8,300.33 10,591.75 21,227.00 22,543.50 34,505.68 35,569.67 39,193.47 $ 2,898,599.86 Page 6 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 7/31/2020 Page 1 of 2 Balance in General Fund 6/30/2020 Receipts: Revenue received Retired employees medical insurance Record interest earned Cash clearing accounts (timing) Total Receipts Disbursements: Accounts payable disbursements Voided checks Distribute UPTIF interest Vehicle asset sales, transfer funds GF to Vehicle Fund Restrict Donner Lake surcharge Restrict facilities fees Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 7/31/2020 Electric Dept Water Dept Total $9,962,920 $2,877,879 $12,840,799 2,683,933 $1,198,820 $3,882,753 22,107 - 22,107 22,718 7,041 29,759 8,884 8,884 $2,737,642 $1,205,860 $3,943,503 $2,935,544 $1,408,713.27 $4,344,257 (1,388) (1,388) 5,638 3,412 9,050 - 9,196 9,196 24,704 115,312 140,016 7,363 - 7,363 7,347 7,347 $2,980,596 $1,535,245 $4,515,841 $9,719,966 $2,548,494 $12,268,461 9/21/2020 5:07 PM I:\Treasurers Repo rt\Statement of General Fund\2020\2020-07 GF Page 7 of 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 7/31/2020 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 - General Fund Total Non -Restricted Funds Distribution of Designated & Restricted Funds at Month -End: LAIF, UPTIF & PCIF - Restricted Funds UPTIF - TDPUD Prop 55 Reserve Fund UPTIF - Donner Lake Assessment District POB Deferred Liability Reserve Fund SRF DLAD Bond Reserve Fund 2015 COP Water Bonds, Interest Payment Fund 2015 COP Water Bonds, Principal Payment Fund Donner Lake Federal Farm Credit Account U S Bank - Donner Lake Assessment District 00-1 Total Restricted Funds Market Adjustments Total Funds Available Electric Dept Water Dept Total $2,400 8,884 367,616 9,341,066 $0 - - 2,548,494 $2,400 8,884 367,616 11,889,560 $9,719,966 $2,548,494 $12,268,461 14,572,533 4,131,469 18,704,002 - 339,950 339,950 - 681,689 681,689 87,380 - 87,380 - 824,467 824,467 - 8,528 8,528 - 536,833 536,833 - 1,698,880 1,698,880 - 818,735 818,735 14,659,913 9,040,552 23,700,464 17,041 45,166 62,207 $24,396,919 $11,634,212 $36,031,131 9/21/2020 5:07 PM I:\Treasurers Repo rt\Statement of General Fund\2020\2020-07 GF Page 8 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 7/31/2020 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2019 6/30/2020 Activity 7/31/2020 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.92% (1.22%) General Fund 1..136.1 $ 7,155,195 $ 6,414,391 $ 1,029,691 $ 7,444,082 Consolidate cash 208,506 Reimburse for Horse Butte Power LAIF transfer 800,000 Quarterly Investment Income payment received 21,185 Capital Replacement Fund 136.41 - 1,001,592 3,319 1,004,911 Quarterly Investment Income payment received 3,319 AB 32 Cap & Trade Fund 1..136.58 1,538,617 1,407,379 4,662 1,412,040 Reimburse for Horse Butte Power Quarterly Investment Income payment received 4,662 Deferred Liabilites Reserve 1..136.42 2,053,044 2,074,131 6,874 2,081,005 Quarterly Investment Income payment received 6,874 Total LAIF Electric Investments 10,746,856 10,897,493 1,044,546 11,942,039 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.74% (0.95%) General Fund 1..136.12 1,764,421 1,402,822 (29,244) 1,373,578 Distribute UPTIF interest (5,638) Restrict facility fees (24,704) Record monthly interest 1,098 Vehicle asset sale proceeds, transfer Out to Vehicle Reserve Fund - Facilities Fees 1..136.9 918,914 1,053,169 25,528 1,078,698 Restrict facilites fees 24,704 Record monthly interest 824 Electric Rate Reserve Fund 1..136.45 1,585,287 1,599,832 1,252 1,601,085 Record monthly interest 1,252 Capital Replacement Fund 136.46 822,907 830,457 650 831,107 Record monthly interest 650 Electric Vehicle Reserve 1..136.13 402,741 624,366 489 624,855 Record monthly interest 489 Vehicle asset sale proceeds, transfer In - Total UPTIF Electric Investments 5,494,271 5,510,647 (1,324) 5,509,323 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.98% (1.19%) Electric General Fund PC1..136.49 518,955 522,970 435 523,405 Record monthly interest 435 Electric Rate Reserve Fund 1..136.47 4,284,920 4,318,079 3,591 4,321,670 Record monthly interest 3,591 Capital Replacement Fund 1..136.48 1,603,411 1,615,818 1,344 1,617,161 Record monthly interest 1,344 Total PCIF County Electric Investments 6,407,287 6,456,867 5,370 6,462,237 Total Electric Investments $ 22,648,413 $ 22,865,007 $ 1,048,591 $ 23,913,598 9/23/2020 11:19AM Investments Status Report I:\Treasurers Report\Investment Status Reports\2020\2020-07 Investments Status Report Page 1 of 3 Page 9 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 7/31/2020 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2019 6/30/2020 Activity 7/31/2020 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.92% (1.22%) General Fund 2..136.1 1,501,700 2,082,556 (317,418) 1,765,138 Consolidate cash (208,506) Quarterly Investment Income payment received 6,400 Restrict facility fees (115,312) DSC Operating Reserve Fund 2..136.47 75,464 76,241 255 76,495 Quarterly Investment Income payment received 255 Facilities Fees 2..136.90 197,794 497,090 116,514 613,604 Restrict facility fees 115,312 Quarterly Investment Income payment received 1,203 SRF/DLAD Reserve Fund 2..125.5 821,579 821,580 2,887 824,467 Investment Income 2,887 Total LAIF Water Investments 2,596,538 3,477,467 (197,761) 3,279,705 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.74% (0.95%) General Fund 2..136.12 709,878 421,128 (12,278) 408,850 Transfer to DLAD surcharge (9,196) Distribute UPTIF interest (3,412) Record monthly interest 330 Facilities Fees 2..136.25 1,232,912 1,244,223 974 1,245,197 Record monthly interest 974 West River St. Assessment District 2..136.31 37,599 37,944 30 37,974 Record monthly interest 30 Prepaid Connection Fees 2..136.7 76,837 77,542 61 77,603 Record monthly interest 61 Donner Lake Assessment District Fund 2..136.84 674,963 681,155 533 681,689 Record monthly interest 533 Donner Lake Assessment District Surcharge Fund 2..136.61 133,379 190,031 9,345 199,375 DLAD surcharge collections 9,196 Record monthly interest 149 TSA SAD II Improvement Fund 2..136.85 18,139 18,305 14 18,319 Record monthly interest 14 Water Vehicle Reserve 2..136.13 219,238 172 219,409 Record monthly interest 172 Deferred Liabilites Reserve 2..136.42 104,927 105,890 83 105,973 Record monthly interest 83 Prop 55 Reserve Fund 2..125.94 336,596 339,684 266 339,950 Record monthly interest 266 Total UPTIF Water Investments 3,325,229 3,335,141 (802) 3,334,339 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.98% (1.19%) Water General Fund PC 2..136.5 371,323 374,195 311 374,506 Record monthly interest 311 DSC Operating Reserve Fund 2..136.49 1,524,445 1,536,241 1,278 1,537,519 Record monthly interest 1,278 Total PCIF Water Investments 1,895,768 1,910,436 1,589 1,912,025 Total Water Investments $ 7,817,536 $ 8,723,043 $ (196,974) $ 8,526,069 9/23/2020 11:19AM Investments Status Report I:\Treasurers Report\Investment Status Reports\2020\2020-07 Investments Status Report Page 2 of 3 Page 10 of 12 INVESTMENT STATUS REPORT Activity for the Month Ended 7/31/2020 %Current Month (%Last Month) ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Pre - Market Adjustments Total LAIF Investments Total UPTIF Investments Total PCIF Investments Total Investments Balance Beg.Balance Month End Balance 12/31/2019 6/30/2020 Activity 7/31/2020 47% 13,343,394 14,374,960 846,785 15,221,744 27% 8,819,500 8,845,788 (2,126) 8,843,662 26% 8,303,055 8,367,303 6,958 8,374,262 100% Month End Bal.Mix $ 30,465,949 $ 31,588,051 $ 851,617 $ 32,439,668 9/23/2020 11:19AM Investments Status Report I:\Treasurers Report\Investment Status Reports\2020\2020-07 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 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 2020 06 Last Month End Balances Change from last month Pctg Change TRUCKEE DONNER PUD INVESTMENT BALANCES as of July 31, 2020 Utah Public Fidelity Mmkt Morgan Stanley Dreyfus Treasury Federated US Federal US Bank Cash/ LAIF Placer County Investment Fund Govt 57 Treas Sec Port Security Treas Cash Res Farm Credit Checking Cash clearings Total 131.1 $ 7,444,082 $ 523,405 $ 1,373,578 $ $ $ $ $ $ 367,616 $ 11,284 $ 9,719,966 - - 1,078,698 - - 1,078,698 - 4,321,670 1,601,085 5,922,755 1,004,911 1,617,161 831,107 3,453,180 2,081,005 - - 87,380 2,168,385 - 624,855 - 624,855 1,412,040 - 1,412,040 18,580 (24,400) 22,861 17,041 11.960.619 6.437.837 5.532.184 87.380 367.616 11.284 24.396.919 $ 1,765,138 $ 374,506 $ 408,850 $ $ $ $ $ $ $ 2,548,494 613,604 - 1,245,197 1,858,802 - - - 545,361 545,361 76,495 1,537,519 - - 1,614,014 - - 37,974 37,974 105,973 105,973 77,603 77,603 681,689 818,735 1,500,424 - 199,375 - 199,375 824,467 - 824,467 - 18,319 18,319 219,409 219,409 339,950 339,950 - - 1,698,880 1,698,880 28,327 (7,219) 13,836 10,223 45,166 3,308,032 1,904,805 3,348,175 545,361 1,709,103 818,735 11,634,212 Non -Current Current 9,925,109 15,268,651 8,342,642 8,880,359 545,361 87,380 1,709,103 1,186,351 11,284 36,031,131 - - - - 248,392 656,452 - - - 904,843 248,392 656,452 904,843 1,896,463 2,215,636 4,112,099 1,896,463 2,215,636 4,112,099 $ 17,165,113 $ 8,342,642 $ 8,880,359 $ 545,361 $ 248,392 $ 743,832 $ 2,215,636 $ 1,709,103 $ 1,186,351 $ 11,284 $ 41,048,074 16,351,748 8,335,684 8,882,485 454,191 248,379 636,543 2,215,609 1,716,838 2,401,464 402,826 40,881,937 813,366 6,958 (2,126) 91,170 13 107,289 28 (7,736) (1,215,113) (391,542) 166,137 5% 0% 0% 20% 0% 17% 0% 0% -51% -97% 0% I:\Treasurers Report\2020\2020-09 Treasurers Repp Wl Investments 202007 S5 Page 12 of 12