Loading...
HomeMy WebLinkAbout16 Treasurers Report AGENDA ITEM # 16 Page 1 of 1 MEETING DATE: December 2, 2020 TO: Board of Directors FROM: Michael Salmon, Chief Financial Officer SUBJECT: Approval of the Treasurer’s Report: December 2020 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER’S REPORT December 2, 2020 Fund Balances for the Month Ended October 31, 2020 And Disbursements for the Month Ended November 30, 2020 Page 1 of 13 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending October 31, 2020 and disbursements for November 2020. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for November 2020 were $2,842,525.01. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during November 2020 total $2,842,525.01 3) STATEMENT OF GENERAL FUND: As of October 31, 2020 the balance in the General Fund was $11,879,759 (Electric $9,179,918 and Water $2,699,841). 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 October 31, 2020 was $37,463,340 ($25,184,781 electric and $12,278,558 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 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.70% 2.01% 1.41% February 2020 1.91% 1.78% 2.10% 0.95% March 2020 1.79% 1.80% 1.66% 0.17% April 2020 1.65% 1.54% 1.44% 0.16% May 2020 1.36% 1.23% 1.19% 0.17% June 2020 1.22% 1.19% 0.95% 0.16% 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.73% 0.52% 0.13% 6) AP DISBURSEMENTS METRICS: See last page. Page 2 of 13 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of November 2020 totaled $2,842,525.01. A listing of those disbursements is attached. Page 3 of 13 Truckee Donner Public Utility District Check Register November 2020 Check/Tran Date Type Vendor Vendor Name Reference Amount 129391 11/6/2020 CHK 99999 GUILLERMO AVILA MENDEZ CUSTOMER REFUND - CLOSED ACCOUNT 5.01 129409 11/6/2020 CHK 99999 KRISTINA SHREVE CUSTOMER REFUND - CLOSED ACCOUNT 9.62 129400 11/6/2020 CHK 78 FEDERAL EXPRESS CORPORATION FEDERAL EXPRESS CHARGES 23.20 129404 11/6/2020 CHK 999 MATTHEW LEDNA REFUND WORK ORDER 20-631000 39.82 129402 11/6/2020 CHK 1449 JACKSON LEWIS PROFESSIONAL SERVICES: GENERAL COUNSEL 75.00 129401 11/6/2020 CHK 44444 HOLLY WILLIAMSON TOILET REBATE 100.00 129396 11/6/2020 CHK 99999 CAROL COCKCROFT CUSTOMER REFUND - CLOSED ACCOUNT 118.81 129393 11/6/2020 CHK 99999 ALFRED BUTTITTA CUSTOMER REFUND - CLOSED ACCOUNT 123.43 129403 11/6/2020 CHK 99999 JESSICA KOEGEL CUSTOMER REFUND - CLOSED ACCOUNT 137.00 129415 11/6/2020 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 168.14 129397 11/6/2020 CHK 99999 COUPE SIXTY-ONE CUSTOMER REFUND - CLOSED ACCOUNT 176.39 129395 11/6/2020 CHK 99999 ELVA CHRISTIAN CUSTOMER REFUND - CLOSED ACCOUNT 188.00 129406 11/6/2020 CHK 99999 JOHN MCNALLY CUSTOMER REFUND - CLOSED ACCOUNT 235.00 129405 11/6/2020 CHK 99999 BARRETT LYON CUSTOMER REFUND - CLOSED ACCOUNT 570.89 129398 11/6/2020 CHK 1415 CRISIS INTERVENTION SERVICES COVID-19 PAYMENT ASSISTANCE 630.00 129413 11/6/2020 CHK 1357 THE UNION GENERAL ADVERTISEMENTS 880.00 129399 11/6/2020 CHK 348 EDGES ELECTRICAL GROUP 2020 WATER SCADA SYSTEM REPLACEMENT 1,341.41 129411 11/6/2020 CHK 716 SMALLPOND STUDIO PROFESSIONAL SERVICES: MARKETING 1,343.75 29509 11/6/2020 DD 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC XEROX COPIER LEASE 1,499.41 129390 11/6/2020 CHK 10360 AFLAC EMPLOYEE PAID INSURANCE 1,670.94 129414 11/6/2020 CHK 999 TOWN OF TRUCKEE REFUND WORK ORDER #19-744411 1,860.57 29510 11/6/2020 DD 1036 ESCI SAFETY MEETING 1,925.00 29515 11/6/2020 DD 1013 SIERRA ENERGY PROFESSIONALS RESIDENTIAL ENERGY SURVEY PROGRAM 2,000.00 129410 11/6/2020 CHK 1082 SIERRA NEVADA AD PARTNERS PROFESSIONAL SERVICES: MARKETING 2,523.63 29512 11/6/2020 DD 1430 JENNIFER STOLL ARCHITECT TDPUD FACILITY MODERNIZATION PROJECT 3,000.00 129392 11/6/2020 CHK 44444 BLAKE DURTSCHE ELECTRIC WATER HEATER REBATE 3,000.00 129407 11/6/2020 CHK 44444 MICHAEL PAPARIAN ELECTRIC WATER HEATER REBATE 3,000.00 129408 11/6/2020 CHK 44444 S BENTLEY ELECTRIC WATER HEATER REBATE 3,000.00 29508 11/6/2020 DD 577 COOPERATIVE RESPONSE CENTER INC.ANSWERING SERVICE 3,692.33 29517 11/6/2020 DD 590 TRUCKEE FENCE COMPANY BUILDING MAINTENANCE 5,800.00 129412 11/6/2020 CHK 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 5,877.84 29507 11/6/2020 DD 1359 CALPERS PENSION 9,243.00 29511 11/6/2020 DD 778 HDR ENGINEERING INC WATER RATE STUDY 10,593.75 29513 11/6/2020 DD 5130 NCPA MEMBERSHIP DUES 14,264.00 29519 11/6/2020 DD 1321 WRIGHT TREE SERVICE, INC.CONTRACT SERVICES: ROW TREE CLEARING 29,420.40 29514 11/6/2020 DD 6403 NEVADA POWER COMPANY PURCHASED POWER - NV ENERGY 52,741.61 29516 11/6/2020 DD 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 150,557.89 129394 11/6/2020 CHK 1294 CHASE LOAN: 2016 COP WATER 341,328.48 29518 11/6/2020 DD 10584 UAMPS PURCHASED POWER - UAMPS 789,870.02 4824 11/12/2020 WIRE 905 HEALTHEQUITY INC.EMPLOYEE HSA CONTRIBUTIONS PPE 11/06/20 1,851.39 4825 11/12/2020 WIRE 3094 EMPLOYMENT DEV DEPT STATE DISABILITY TAX 18,653.59 4820 11/12/2020 WIRE 3824 ICMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS PPE 11/06/2020 19,137.89 4823 11/12/2020 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 11/06/2020 19,178.46 4821 11/12/2020 WIRE 11233 CALPERS PENSION 58,229.20 4822 11/12/2020 WIRE 7310 INTERNAL REVENUE SERVICE FICA/FEDERAL WITHHOLDING PPE 11/06/2020 80,070.39 4816 11/12/2020 PL PL Payroll Payroll Direct Deposit 189,673.59 129425 11/13/2020 CHK 99999 STEVE GIAMBALVO CUSTOMER REFUND - CLOSED ACCOUNT 1.00 29600 11/13/2020 DD 630 WESTERN AREA POWER ADMINISTRATION ENVIRONMENTAL COMPLIANCE FEES 23.84 129439 11/13/2020 CHK 7175 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 36.36 129437 11/13/2020 CHK 719 T-MOBILE SANDEL-AVERY ALARM 38.43 129423 11/13/2020 CHK 78 FEDERAL EXPRESS CORPORATION FEDERAL EXPRESS CHARGES 51.04 129426 11/13/2020 CHK 905 HEALTHEQUITY INC.HSA ADMINISTRATIVE FEES 66.30 29589 11/13/2020 DD 640 EMPLOYER LYNX INC.PERSONNEL EXPENSES 76.00 129418 11/13/2020 CHK 240 AUDIO ON-HOLD ON-HOLD PHONE SYSTEM 79.00 129424 11/13/2020 CHK 99999 DAVID FLORES CUSTOMER REFUND - CLOSED ACCOUNT 84.58 29590 11/13/2020 DD 10650 EUROFINS EATON ANALYTICAL INC.WATER SAMPLE ANALYSIS 90.00 129440 11/13/2020 CHK 999 VERIZON WIRELESS REFUND WORK ORDER #18-644385 105.62 129434 11/13/2020 CHK 99999 DENISE PERKINS CUSTOMER REFUND - CLOSED ACCOUNT 106.18 29597 11/13/2020 DD 7176 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 122.32 129419 11/13/2020 CHK 99999 CURT BROHARD CUSTOMER REFUND - CLOSED ACCOUNT 146.86 129427 11/13/2020 CHK 99999 JAN HOLAN CUSTOMER REFUND - CLOSED ACCOUNT 150.99 129421 11/13/2020 CHK 193 EASTERN REGIONAL LANDFILL LANDFILL CHARGES 187.00 129431 11/13/2020 CHK 617 MOUNTAIN EAP WELLNESS PROGRAM 225.00 129430 11/13/2020 CHK 1149 LOOMIS BANKING CHARGES 457.17 29598 11/13/2020 DD 973 TRUCKEE TAHOE HOME IMPROVEMENT LLC REFRIGERATOR RECYCLE 500.00 129429 11/13/2020 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 522.80 29596 11/13/2020 DD 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 525.00 129417 11/13/2020 CHK 657 AT&T COMMUNICATIONS 551.54 129428 11/13/2020 CHK 1176 CHRISTINE F JACKSON, O.D.VISION REIMBURSEMENT 849.00 129436 11/13/2020 CHK 11302 SAGE LAND SURVEYING INC.MARTIS WOODS PUMP STATION REPLACEMENT 940.00 129420 11/13/2020 CHK 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE ELECTRICAL ENERGY SURCHARGE 1,405.49 129416 11/13/2020 CHK 1459 A.G. BJORSON CONTRACT SERVICES: ROW TREE CLEARING 1,420.00 29588 11/13/2020 DD 1167 EAST RIVER PR PROFESSIONAL SERVICES: MARKETING 1,475.00 29587 11/13/2020 DD 10759 DONNER LAKE ASSESSMENT DISTR SPECIAL ASSESSMENT 1,695.75 129422 11/13/2020 CHK 3096 EMPLOYMENT DEVELOMENT DEPT.UNEMPLOYMENT BENEFITS 3,380.50 129438 11/13/2020 CHK 6860 TAHOE FOREST HEALTH SYSTEM WELLNESS PROGRAM 4,545.50 29595 11/13/2020 DD 5730 PORTER SIMON LEGAL SERVICES 5,130.75 29591 11/13/2020 DD 676 GDS ASSOCIATES INC.PROFESSIONAL SERVICES - ENGINEERING 5,827.50 29593 11/13/2020 DD 3820 IBEW LOCAL 1245 UNION DUES 6,615.87 29592 11/13/2020 DD 778 HDR ENGINEERING INC PROFESSIONAL SERVICES - ENGINEERING 8,268.00 29599 11/13/2020 DD 1183 TRUCKEE-CARSON IRRIGATION DISTRICT PURCHASED POWER - TCID 10,432.83 129435 11/13/2020 CHK 1458 PURE TECHNOLOGIES MATERIALS 10,500.00 129432 11/13/2020 CHK 5151 NRECA INSURANCE 17,468.73 29594 11/13/2020 DD 758 PAMELA HURT ASSOCIATES EMPLOYEE DEVELOPMENT 21,962.50 29601 11/13/2020 DD 1321 WRIGHT TREE SERVICE, INC.CONTRACT SERVICES: ROW TREE CLEARING 28,451.62 129433 11/13/2020 CHK 5150 NRECA GROUP BENEFITS TRUST INSURANCE 199,851.81 Page 1 of 3 Page 4 of 13 Check/Tran Date Type Vendor Vendor Name Reference Amount 129452 11/23/2020 CHK 10419 DEPARTMENT OF MOTOR VEHICLES REPAIRS & MAINTENANCE 27.00 29614 11/23/2020 DD 10008 MOTION & FLOW CONTROL PRODUCTS, INC.MISC PARTS & SUPPLIES 28.08 129460 11/23/2020 CHK 115 KIMBALL-MIDWEST MISC PARTS & SUPPLIES 34.10 129472 11/23/2020 CHK 246 ROCK GARDEN MATERIALS 38.19 129471 11/23/2020 CHK 999 VLADIMIR RIVKIN REFUND WORK ORDER #20-63995 39.82 129459 11/23/2020 CHK 1116 HUNT & SONS, INC FUEL FOR VEHICLES 42.96 129448 11/23/2020 CHK 10223 CALIFORNIA INDUSTRIAL RUBBER MATERIALS 46.84 29629 11/23/2020 DD 2025 THE OFFICE BOSS OFFICE SUPPLIES 75.49 129487 11/23/2020 CHK 1308 TRUCKEE TIRE REPAIRS & MAINTENANCE 80.00 129476 11/23/2020 CHK 99999 ANTHONY STEINER CUSTOMER REFUND - CLOSED ACCOUNT 92.47 129462 11/23/2020 CHK 4250 LAWSON PRODUCTS INC MATERIALS 125.83 129456 11/23/2020 CHK 2222 FRANK STRATTON'S JUST FIX IT MATERIALS 142.00 129442 11/23/2020 CHK 163 APEX SAW WORKS MATERIALS 172.76 129444 11/23/2020 CHK 999 BROOK BUSWELL REFUND WORK ORDER #20-63987 180.55 129454 11/23/2020 CHK 78 FEDERAL EXPRESS CORPORATION WELLNESS PROGRAM 200.91 29632 11/23/2020 DD 10380 ULINE FIELD SUPPLIES 205.60 29623 11/23/2020 DD 10414 SNAP-ON INDUSTRIAL PERSONAL CHARGE - F. HESTON 214.73 29627 11/23/2020 DD 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 231.47 29612 11/23/2020 DD 1305 JW WELDING SUPPLIES & TOOLS MATERIALS 247.73 129473 11/23/2020 CHK 11302 SAGE LAND SURVEYING INC.MATERIALS 250.00 29628 11/23/2020 DD 1297 TANTALUS SYSTEMS MATERIALS 253.00 129490 11/23/2020 CHK 7380 UNITED PARCEL SERVICE UPS CHARGES 253.11 29619 11/23/2020 DD 5070 PLATT MATERIALS 255.40 129449 11/23/2020 CHK 99999 DENNIS CHEZ CUSTOMER REFUND - CLOSED ACCOUNT 281.51 29602 11/23/2020 DD 228 ALLIED ELECTRONICS INC.SAFETY SUPPLIES 319.34 29609 11/23/2020 DD 3480 GRAINGER INC.FIELD SUPPLIES 365.01 129489 11/23/2020 CHK 99999 UNION PACIFIC RR #5001 CUSTOMER REFUND - CLOSED ACCOUNT 384.62 129468 11/23/2020 CHK 5222 OFFICE DEPOT INC.OFFICE SUPPLIES 386.81 129478 11/23/2020 CHK 99999 TAHOE CANDLE DBA: RESCUED WINE CUSTOMER REFUND - CLOSED ACCOUNT 387.51 129470 11/23/2020 CHK 462 POWERPLAN-OIB REPAIRS & MAINTENANCE 464.28 129450 11/23/2020 CHK 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING, MAINTENANCE & SUPPORT 477.41 129467 11/23/2020 CHK 1079 O'REILLY AUTO PARTS REPAIRS & MAINTENANCE 485.47 129480 11/23/2020 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY WATER SAMPLE ANALYSIS 500.00 29626 11/23/2020 DD 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 500.81 129465 11/23/2020 CHK 468 MAITA CHEVROLET REPAIRS & MAINTENANCE 501.74 129488 11/23/2020 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 506.94 129463 11/23/2020 CHK 1132 LEAF XEROX COPIER LEASE 549.34 29615 11/23/2020 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 604.94 129475 11/23/2020 CHK 11001 SPARKS ELECTRIC MOTOR REPAIR MATERIALS 641.95 129483 11/23/2020 CHK 1062 TESSCO INCORPORATED 2020 WATER SCADA SYSTEM REPLACEMENT 752.49 29611 11/23/2020 DD 967 INLAND SUPPLY CO FACILITY SUPPLIES 764.11 29608 11/23/2020 DD 848 FASTENAL MATERIALS 805.95 129461 11/23/2020 CHK 10936 LAKESIDE SPECIALIZED TRANSPORTATION MATERIALS 891.25 29603 11/23/2020 DD 829 CDS GLOBAL REMITTANCE PROCESSING 901.60 129469 11/23/2020 CHK 31 POULIN STEEL FAB INC.MATERIALS 904.56 129491 11/23/2020 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 909.53 29621 11/23/2020 DD 837 SIERRA OFFICE SOLUTIONS XEROX COPIER LEASE 920.01 129458 11/23/2020 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS 932.52 129451 11/23/2020 CHK 2471 CPS HR CONSULTING PROFESSIONAL SERVICES: OTHER 1,005.00 29622 11/23/2020 DD 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 1,103.00 129447 11/23/2020 CHK 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE USE TAX PAYABLE 1,154.00 29624 11/23/2020 DD 3826 STONE'S COUNTRY TIRE REPAIRS & MAINTENANCE 1,163.36 129485 11/23/2020 CHK 999 TRICO ELECTRIC COOPERATIVE PAYMENT PROCESSED IN ERROR 1,189.10 129445 11/23/2020 CHK 381 CAL-NEVADA TOWING REPAIRS & MAINTENANCE 1,218.75 29613 11/23/2020 DD 965 MOSS ADAMS PROFESSIONAL SERVICES: AUDIT 1,375.00 129446 11/23/2020 CHK 6730 CALIFORNIA DEPARTMENT OF TAX AND FEE ENVIRONMENTAL COMPLIANCE FEES 1,830.78 29616 11/23/2020 DD 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS & MAINTENANCE 1,881.75 129486 11/23/2020 CHK 10246 TRUCKEE FIRE PROTECTION DIST SPECIAL ASSESSMENT 1,922.50 129443 11/23/2020 CHK 657 AT&T COMMUNICATIONS 1,998.91 129492 11/23/2020 CHK 7820 WESTERN NEVADA SUPPLY INVENTORY 2,080.89 129453 11/23/2020 CHK 348 EDGES ELECTRICAL GROUP 2020 WATER SCADA SYSTEM REPLACEMENT 2,159.70 29620 11/23/2020 DD 552 RK CONTRACTORS INC.ENVIRONMENTAL COMPLIANCE FEES 2,245.54 129457 11/23/2020 CHK 3349 GLOBAL RENTAL CO INC MATERIALS 2,312.49 29630 11/23/2020 DD 1328 TRAFFIC MANAGEMENT, INC.MATERIALS 2,637.00 129466 11/23/2020 CHK 2237 MINASIAN, MEITH, SOARES, SEXTON & COOPER PROFESSIONAL SERVICES: GENERAL COUNSEL 2,816.00 129441 11/23/2020 CHK 134 ANIXTER INC.INVENTORY 3,083.07 29634 11/23/2020 DD 1450 UTILITY SERVICE CO, INC.MATERIALS 3,200.00 29605 11/23/2020 DD 145 CODALE ELECTRIC SUPPLY, INC METER PURCHASE 3,802.17 129455 11/23/2020 CHK 1790 FLYERS ENERGY LLC FUEL FOR VEHICLES 4,138.34 129481 11/23/2020 CHK 999 TANYA BARRON DAMAGE CLAIM PAYMENT 4,294.22 129484 11/23/2020 CHK 548 THE AUTO & TIRE DOCTOR INC.REPAIRS & MAINTENANCE 4,729.28 129479 11/23/2020 CHK 1249 TAHOE INSTITUTE FOR NATURAL SCIENCE MARKETING 5,000.00 129477 11/23/2020 CHK 349 STRADLING YOCCA CARLSON & RAUTH P.C.GC MR ANNUAL ADMIN COSTS 5,221.00 29607 11/23/2020 DD 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,100.00 129464 11/23/2020 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 6,355.76 29631 11/23/2020 DD 712 TRUCKEE DONNER PUD PURCHASED POWER - STAMPEDE HYDRO GEN 6,532.65 29610 11/23/2020 DD 778 HDR ENGINEERING INC WATER RATE STUDY 6,996.25 29606 11/23/2020 DD 1251 CONSTRUCTION MATERIALS ENGINEERS, INC.2020 CONSTRUCTION INSPECTION SERVICE 7,190.00 29625 11/23/2020 DD 11199 TADPOLE CARTESIA INC.LICENSING, MAINTENANCE & SUPPORT 9,082.18 129482 11/23/2020 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 10,380.01 29633 11/23/2020 DD 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 10,639.84 29618 11/23/2020 DD 820 ONESOURCE DISTRIBUTORS INVENTORY 11,961.92 129474 11/23/2020 CHK 1082 SIERRA NEVADA AD PARTNERS PROFESSIONAL SERVICES: OTHER 12,278.28 29617 11/23/2020 DD 289 NISC OCOTBER 2020 RECURRING INVOICE 28,441.32 29604 11/23/2020 DD 9503810 CDW GOVERNMENT INC.LICENSING, MAINTENANCE & SUPPORT 31,100.57 29635 11/23/2020 DD 1321 WRIGHT TREE SERVICE, INC.CONTRACT SERVICES: ROW TREE CLEARING 31,433.54 4831 11/25/2020 WIRE 905 HEALTHEQUITY INC.EMPLOYER HSA CONTRIBUTIONS 1,136.65 4829 11/25/2020 WIRE 905 HEALTHEQUITY INC.EMPLOYEE HSA CONTRIBUTIONS PPE 11/20/20 1,851.39 4826 11/25/2020 WIRE 3824 ICMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS PPE 11/20/2020 17,909.31 4828 11/25/2020 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 11/20/2020 18,942.34 Page 2 of 3 Page 5 of 13 Check/Tran Date Type Vendor Vendor Name Reference Amount 4830 11/25/2020 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 11/20/2020 20,267.52 4832 11/25/2020 WIRE 11233 CALPERS PENSION 57,554.93 4827 11/25/2020 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 11/20/2020 85,091.21 4819 11/25/2020 PL PL Payroll Payroll Direct Deposit 215,143.02 2,842,525.01$ Page 3 of 3 Page 6 of 13 Electric Dept Water Dept Total Balance in General Fund 9/30/2020 $9,923,127 $2,807,969 $12,731,096 Receipts: Revenue received 2,228,926 $1,116,443 $3,345,369 - - Retired employees medical insurance 20,460 - 20,460 Record interest earned 15,052 4,343 19,395 LAIF Interest quarterly received - Cash clearing accounts (timing-prior month reversal) (35,460) (35,460) Cash clearing accounts (timing-current month) (73,457) (73,457) Total Receipts $2,155,521 $1,120,786 $3,276,306 Disbursements: Accounts payable disbursements $2,852,359 $1,234,952.24 $4,087,312 Voided checks (10,618) (10,618) Distribute UPTIF interest 2,476 1,518 3,994 Vehicle asset sales, transfer funds GF to Vehicle Fund - Transfer to Capital Reserve - Restrict Donner Lake surcharge - (88,742) (88,742) Restrict facilities fees 29,354 91,804 121,158 - - Section 125 benefit disbursement 7,270 - 7,270 Bank charges 7,269 - 7,269 Total Disbursements $2,898,729 $1,228,914 $4,127,643 Balance in General Fund 10/31/2020 $9,179,918 $2,699,841 $11,879,759 Page 1 of 2 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 10/31/2020 11/24/2020 10:33 AM I:\Treasurers Report\Statement of General Fund\2020\2020-10 GF Page 7 of 13 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 (73,457) - (73,457) U.S. Bank-General Fund 977,444 - 977,444 LAIF, UPTIF & PCIF - General Fund 8,273,531 2,699,841 10,973,372 Total $9,179,918 $2,699,841 $11,879,759 Market Adjustment $6,302 $9,759 $15,825 Total Non-Restricted Funds $9,186,220 $2,709,600 $11,895,584 Distribution of Designated & Restricted Funds at Month-End: LAIF, UPTIF & PCIF - Restricted Funds 15,643,170 4,321,391 19,964,561 UPTIF - TDPUD Prop 55 Reserve Fund - 340,466 340,466 UPTIF - Donner Lake Assessment District - 682,724 682,724 POB Deferred Liability Reserve Fund 344,653 - 344,653 SRF DLAD Bond Reserve Fund - 826,526 826,526 2015 COP Water Bonds, Interest Payment Fund - 8,528 8,528 2015 COP Water Bonds, Principal Payment Fund - 810,304 810,304 Donner Lake Federal Farm Credit Account - 1,698,880 1,698,880 U S Bank - Donner Lake Assessment District 00-1 - 864,519 864,519 Total 15,987,823 9,553,339 25,541,162 Market Adjustment 10,739 15,620 26,595 Total Restricted Funds 15,998,562 9,568,959 25,567,756 Total Funds Available 25,184,781 12,278,558 37,463,340 Total Market Adjustments 17,041 25,379 42,419 Page 2 of 2 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 10/31/2020 11/24/2020 10:33 AM I:\Treasurers Report\Statement of General Fund\2020\2020-10 GF Page 8 of 13 INVESTMENT STATUS REPORT Activity for the Month Ended 10/31/2020 Balance Beg.Balance Month End Balance %Current Month (%Last Month)12/31/2019 9/30/2020 Activity 10/31/2020 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.62% (0.69%) General Fund 1..136.1 7,155,195$ 6,340,152$ 122,121$ 6,462,273$ Consolidate cash 107,892 Reimburse for Horse Butte Power - Capital Reserve Transfer - LAIF transfer - Quarterly Investment Income payment received 14,230 Capital Replacement Fund 136.41 - 1,557,314 2,488 1,559,802 Quarterly Investment Income payment received 2,488 Capital Reserve Transfer - AB 32 Cap & Trade Fund 1..136.58 1,538,617 1,823,815 3,241 1,827,057 Reimburse for Horse Butte Power - Quarterly Investment Income payment received 3,241 Deferred Liabilites Reserve 1..136.42 2,053,044 2,081,565 4,353 2,085,918 Quarterly Investment Income payment received 4,353 Total LAIF Electric Investments 10,746,856 11,802,846 132,204 11,935,050 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.52% (0.55%) General Fund 1..136.12 1,764,421 1,318,138 (31,256) 1,286,883 Distribute UPTIF interest (2,476) Restrict facility fees (29,354) Record monthly interest 575 Vehicle asset sale proceeds, transfer Out to Vehicle Reserve Fund - Facilities Fees 1..136.9 918,914 1,129,021 29,847 1,158,867 Restrict facilites fees 29,354 Record monthly interest 492 Electric Rate Reserve Fund 1..136.45 1,585,287 1,602,817 699 1,603,516 Record monthly interest 699 Capital Replacement Fund 136.46 822,907 832,007 363 832,370 Record monthly interest 363 Electric Vehicle Reserve 1..136.13 402,741 625,531 273 625,804 Record monthly interest 273 Vehicle asset sale proceeds, transfer In - Total UPTIF Electric Investments 5,494,271 5,507,514 (74) 5,507,440 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.73% (0.57%) Electric General Fund PC1..136.49 518,955 524,128 247 524,375 Record monthly interest 247 Electric Rate Reserve Fund 1..136.47 4,284,920 4,327,636 2,042 4,329,678 Record monthly interest 2,042 Capital Replacement Fund 1..136.48 1,603,411 1,619,394 764 1,620,158 Record monthly interest 764 Total PCIF County Electric Investments 6,407,287 6,471,157 3,053 6,474,211 Total Electric Investments 22,648,413$ 23,781,518$ 135,183$ 23,916,701$ 11/24/2020 10:31 AM I:\Treasurers Report\Investment Status Reports\2020\2020-10 Investments Status Report Investments Status Report Page 1 of 3 Page 9 of 13 INVESTMENT STATUS REPORT Activity for the Month Ended 10/31/2020 Balance Beg.Balance Month End Balance %Current Month (%Last Month)12/31/2019 9/30/2020 Activity 10/31/2020 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.62% (0.69%) General Fund 2..136.1 1,501,700 2,046,834 (195,698) 1,851,136 Consolidate cash (107,892) Quarterly Investment Income payment received 3,998 Restrict facility fees (91,804) DSC Operating Reserve Fund 2..136.47 75,464 76,516 161 76,677 Quarterly Investment Income payment received 161 Facilities Fees 2..136.90 197,794 774,655 93,233 867,887 Restrict facility fees 91,804 Quarterly Investment Income payment received 1,429 SRF/DLAD Reserve Fund 2..125.5 821,579 824,702 1,823 826,526 Investment Income 1,823 Total LAIF Water Investments 2,596,538 3,722,707 (100,480) 3,622,226 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.52% (0.55%) General Fund 2..136.12 709,878 386,113 87,392 473,505 Transfer to DLAD surcharge (9,231) Distribute UPTIF interest (1,518) Pipeline COP debt payment reimbursement from DLAD 97,973 Record monthly interest 168 Facilities Fees 2..136.25 1,232,912 1,246,545 544 1,247,089 Record monthly interest 544 West River St. Assessment District 2..136.31 37,599 38,015 17 38,032 Record monthly interest 17 Prepaid Connection Fees 2..136.7 76,837 77,687 34 77,721 Record monthly interest 34 Donner Lake Assessment District Fund 2..136.84 674,963 682,426 298 682,724 Record monthly interest 298 Donner Lake Assessment District Surcharge Fund 2..136.61 133,379 218,041 (88,647) 129,394 DLAD surcharge collections 9,231 Pipeline COP debt payment reimbursement from DLAD (97,973) Record monthly interest 95 TSA SAD II Improvement Fund 2..136.85 18,139 18,339 8 18,347 Record monthly interest 8 Water Vehicle Reserve 2..136.13 - 219,647 96 219,743 Record monthly interest 96 Deferred Liabilites Reserve 2..136.42 104,927 106,087 46 106,134 Record monthly interest 46 Prop 55 Reserve Fund 2..125.94 336,596 340,318 148 340,466 Record monthly interest 148 Total UPTIF Water Investments 3,325,229 3,333,218 (64) 3,333,154 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.73% (0.57%) Water General Fund PC 2..136.5 371,323 375,023 177 375,200 Record monthly interest 177 DSC Operating Reserve Fund 2..136.49 1,524,445 1,539,641 726 1,540,367 Record monthly interest 726 Total PCIF Water Investments 1,895,768 1,914,664 903 1,915,567 Total Water Investments 7,817,536$ 8,970,589$ (99,641)$ 8,870,948$ 11/24/2020 10:31 AM I:\Treasurers Report\Investment Status Reports\2020\2020-10 Investments Status Report Investments Status Report Page 2 of 3 Page 10 of 13 INVESTMENT STATUS REPORT Activity for the Month Ended 10/31/2020 Balance Beg.Balance Month End Balance %Current Month (%Last Month)12/31/2019 9/30/2020 Activity 10/31/2020 ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Pre - Market Adjustments Total LAIF Investments 47% 13,343,394 15,525,553 31,723 15,557,276 Total UPTIF Investments 27% 8,819,500 8,840,732 (138) 8,840,594 Total PCIF Investments 26% 8,303,055 8,385,821 3,957 8,389,778 Total Investments 100% Month End Bal.Mix 30,465,949$ 32,752,107$ 35,542$ 32,787,648$ Market Adjustments Total LAIF Investments 46,906 46,906 - 46,906 Total UPTIF Investments 36,697 36,697 - 36,697 Total PCIF Investments (31,620) (31,620) - (31,620) Total Investments 51,984$ 51,984$ -$ 51,984$ Post - Market Adjustments Total LAIF Investments 48% 13,390,301 15,572,459 31,723 15,604,183 Total UPTIF Investments 27% 8,856,197 8,877,429 (138) 8,877,291 Total PCIF Investments 25% 8,271,436 8,354,202 3,957 8,358,158 Total Investments 100% Month End Bal.Mix 30,517,933$ 32,804,090$ 35,542$ 32,839,632$ 11/24/2020 10:31 AM I:\Treasurers Report\Investment Status Reports\2020\2020-10 Investments Status Report Investments Status Report Page 3 of 3 Page 11 of 13 TRUCKEE DONNER PUD INVESTMENT BALANCES as of October 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 ELECTRIC FUNDS General Fund 6,462,273$ 524,375$ 1,286,883$ -$ -$ -$ -$ -$ 977,444$ (71,057)$ 9,179,918$ Facilities Fees - - 1,158,867 - - - - - - - 1,158,867 Electric Rate Reserve - 4,329,678 1,603,516 - - - - - - - 5,933,194 Capital Replacement Fund 1,559,802 1,620,158 832,370 - - - - - - - 4,012,329 Deferred Liabilites Reserve/POB Fund 2,085,918 - - - - 344,653 - - - - 2,430,571 Electric Vehicle Reserve - - 625,804 - - - - - - - 625,804 AB 32 Fund 1,827,057 - - - - - - - - - 1,827,057 Market Adjustments 18,580 (24,400) 22,861 - - - - - - - 17,041 Total Electric Investments 11,953,630 6,449,810 5,530,301 - - 344,653 - - 977,444 (71,057) 25,184,781 WATER FUNDS General Fund 1,851,136$ 375,200$ 473,505$ -$ -$ -$ -$ -$ -$ -$ 2,699,841 Facilities Fees 867,887 - 1,247,089 - - - - - - - 2,114,976 2015 COP Funds - - - 818,833 - - - - - - 818,833 DSC and Operating Reserve Fund 76,677 1,540,367 - - - - - - - - 1,617,045 West River St. Assessment District - - 38,032 - - - - - - - 38,032 Deferred Liabilites Reserve - - 106,134 - - - - - - - 106,134 Prepaid Connection Fees - - 77,721 - - - - - - - 77,721 DLAD Fund - - 682,724 - - - - - 864,519 - 1,547,243 DLAD Surcharge - - 129,394 - - - - - - - 129,394 SRF Reserve and Payment Fund 826,526 - - - - - - - - - 826,526 TSA SAD II Improvement Fund - - 18,347 - - - - - - - 18,347 Water Vehicle Reserve - - 219,743 - - - - - - - 219,743 Prop 55 Reserve Fund - - 340,466 - - - - - - - 340,466 DLAD Investment - - - - - - - 1,698,880 - - 1,698,880 Market Adjustments 28,327 (7,219) 13,836 - - - - (9,564) - - 25,379 Total Water Investments 3,650,553 1,908,348 3,346,990 818,833 - - - 1,689,316 864,519 - 12,278,558 Non-Current Current 10,589,243 Electric and Water, subtotal 15,604,183 8,358,158 8,877,291 818,833 - 344,653 - 1,689,316 1,841,963 (71,057) 37,463,340 MELLO ROOS - OLD GREENWOOD - - - - 312,603 5,712 - - - - 318,315 Total Mello Roos - Old Greenwood - - - - 312,603 5,712 - - - - 318,315 MELLO ROOS - GRAY'S CROSSING 1,901,010 - - - - - 739,370 - - - 2,640,380 Total Mello Roos - Gray's Crossing 1,901,010 - - - - - 739,370 - - - 2,640,380 Total Investments 17,505,193$ 8,358,158$ 8,877,291$ 818,833$ 312,603$ 350,365$ 739,370$ 1,689,316$ 1,841,963$ (71,057)$ 40,422,035$ 2020 09 Last Month End Balances 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 Change from last month 1,153,445 22,475 (5,194) 364,641 64,224 (286,178) (1,476,239) (27,523) (559,501) (473,883) (459,902) Pctg Change 7% 0% 0% 80% 26% -45% -67% -2% -23% -118% -1% I:\Treasurers Report\2020\2020-12 Treasurers Report\All Investments 202010 SSS Page 12 of 13 Accounts Payable (A/P) Metrics 0.00 1,000,000.00 2,000,000.00 3,000,000.00 4,000,000.00 5,000,000.00 6,000,000.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec $ A/P Disbursements 2018 2019 2020 0 50 100 150 200 250 300 350 400 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec # A/P Payments Issued 2018 2019 2020 0 100 200 300 400 500 600 700 800 900 1000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec # A/P Invoices Vouchered 2018 2019 2020 Page 13 of 13