Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Finance - Quarterly Reports - FY 20/21 4th Quarter - 09/30/2021
CITY OF EAGLE TREASURER'S REPORT FOR THE QUARTER ENDING SEPTEMBER 30, 2021 BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 09:54AM PAGE: 1 01 GENERAL FUND 491,279.01 3,285,458.19 53.62 2,114,328.12 54.91 1,021,823.48 640,585.60 06 LIBRARY FUND ( 38,809.31) 529,584.48 76.61 485,963.14 68.06 48,291.64 ( 43,479.61) 07 MUSEUM FUND 82,198.09 .00 96.35 37,915.92 77.02 ( 2,617.84)46,900.01 08 PARK IMPACT FEE FUND 161,258.68 118,732.63 52.37 65,696.11 12.04 1,582.03 212,713.17 09 RECREATION - SPECIAL EVENTS 177,654.56 14,139.79 90.96 44,412.12 74.19 ( 4,796.36) 152,178.59 10 EAGLE HISTORICAL COMMISSION 19,510.66 .00 71.96 227.33 29.59 .00 19,283.33 11 EXECUTIVE DEPARTMENT .00 37,232.70 85.45 39,854.12 85.13 ( 2,621.42).00 12 CITY CLERK/TREAS DEPARTMENT .00 111,003.90 83.21 125,788.45 84.04 ( 14,784.55).00 13 BUILDING DEPARTMENT .00 232,982.77 112.80 290,629.90 113.81 ( 57,647.13).00 14 P&Z DEPARTMENT .00 255,601.21 86.68 298,231.15 88.47 ( 42,629.94).00 17 RECREATION - PARKS AND REC 302,509.35 65,874.74 124.48 226,782.51 125.16 ( 27,368.27) 168,969.85 18 IT DEPARTMENT .00 164,800.49 79.00 195,950.04 78.21 ( 31,149.55).00 19 CAPITAL PROJECTS FUND 3,241,563.79 9,116,846.76 205.44 2,101,845.62 51.31 7,218,550.55 3,038,014.38 21 ARTS COMMISSION 54,623.41 1.00 58.56 30,066.37 52.82 .00 24,558.04 23 PUBLIC WORKS .00 20,556.32 81.92 665,967.05 67.71 ( 645,410.73).00 24 RECREATION - EAGLE FUN DAYS 46,197.28 11,008.09 59.10 80,911.95 114.25 .00 ( 23,706.58) 25 PATHWAY IMPACT FEE FUND 68,474.94 35,004.03 28.92 4,074.50 16.91 ( 3,289.97) 102,694.44 26 ECONOMIC DEVELOPMENT .00 44,079.04 68.93 48,597.94 69.59 ( 4,518.90).00 27 LAW ENF DEV IMPACT FEES 9,435.00 12,832.97 37.55 .00 .00 13,653.73 8,614.24 54 CITY HALL BOND FUND 91,530.13 .00 100.00 88,124.91 100.00 .00 3,405.22 60 WATER FUND 609,844.21 550,793.37 75.76 269,013.97 38.83 ( 53,558.97) 945,182.58 TOTAL 5,317,269.80 14,606,532.48 7,214,381.22 7,413,507.80 5,295,913.26 Citizens are invited to inspect the detailed supporting records of the above financial statements. Idaho Code 50-1011 Making the Quarterly Treasurer's Report available for public review on the City's Website shall satisfy publication requirements. Idaho Code 50-208 For additional information please contact Eagle City Hall, 939-6813. City of Eagle Kellie Rekow, CMC City Treasurer Posted to the City of Eagle website, 10-27-21 100 % of the fiscal year has elapsed Unaudited Revenue / Expenditure Report CITY OF EAGLE COMBINED CASH INVESTMENT SEPTEMBER 30, 2021 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 5,142,400.79 99-0106-00-00 RETURNED CHECK CLEARING ACCT ( 102.55) 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 153,615.02 TOTAL COMBINED CASH 5,295,913.26 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 5,295,913.26) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 640,585.60 6 ALLOCATION TO LIBRARY FUND ( 43,479.61) 7 ALLOCATION TO MUSEUM FUND 46,900.01 8 ALLOCATION TO PARK IMPACT FEE FUND 212,713.17 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 152,178.59 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 19,283.33 17 ALLOCATION TO RECREATION - PARKS AND REC 168,969.85 19 ALLOCATION TO CAPITAL PROJECTS FUND 3,038,014.38 21 ALLOCATION TO ARTS COMMISSION 24,558.04 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS ( 23,706.58) 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 102,694.44 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 8,614.24 54 ALLOCATION TO CITY HALL BOND FUND 3,405.22 60 ALLOCATION TO WATER FUND 945,182.58 TOTAL ALLOCATIONS TO OTHER FUNDS 5,295,913.26 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 5,295,913.26) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 2 ASSETS 01-0101-00-00 CASH 640,585.60 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 23,145.52 01-0115-00-00 ACCOUNTS RECEIVABLE 54,229.06 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 839,550.12 01-0151-25-00 FIRST INTERSTATE INVESTMENT 4,173,893.40 01-0151-28-00 ICCU CD 50,933.96 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 5,788,223.58 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE 153,023.89 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES ( 99.00) 01-0203-01-01 BONDS DEPOSITS PAYABLE 1,500,332.44 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 4,939.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 205,624.00 01-0203-01-06 LAND USE DEPOSITS PAYABLE 50,933.96 01-0217-07-00 GEN ADMIN HEALTH INSURANCE ( 10,779.13) 01-0217-07-01 COBRA- HEALTH INSURANCE ( 1,415.27) 01-0217-09-00 WORKERS' COMPENSATION 1,465.85 01-0226-00-00 DEFERRED REVENUE 18,513.60 TOTAL LIABILITIES 1,920,539.34 FUND EQUITY 01-0271-00-00 FUND BALANCE 4,174,598.60 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 306,914.36) BALANCE - CURRENT DATE ( 306,914.36) TOTAL FUND EQUITY 3,867,684.24 TOTAL LIABILITIES AND EQUITY 5,788,223.58 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 3 REVENUE 01-0308-00-00 CARRY OVER .00 .00 7,590,179.00 7,590,179.00 .0 01-0309-01-00 MONEY MARKET ACCOUNT 1ST QTR .00 .00 5,648,849.00 5,648,849.00 .0 01-0309-05-00 OPERATING ACCOUNT .00 .00 1,000,000.00 1,000,000.00 .0 01-0311-00-00 PROPERTY TAX 854,769.04 2,514,246.81 2,481,020.00 ( 33,226.81)101.3 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,624.13 4,248.28 3,000.00 ( 1,248.28)141.6 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 4,231.41 8,462.84 8,463.00 .16 100.0 01-0316-10-00 FRANCHISE FEE/EAGLE WATER CO.827.18 4,564.73 10,430.00 5,865.27 43.8 01-0316-10-02 FRANCHISE FEE/SUEZ 4,596.89 14,686.85 19,000.00 4,313.15 77.3 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 50,763.03 265,962.52 260,000.00 ( 5,962.52)102.3 01-0316-12-00 FRANCHISE FEE/CABLE TV 28,368.76 110,952.07 98,700.00 ( 12,252.07)112.4 01-0316-13-00 FRANCHISE FEE/TRASH 76,772.10 298,362.84 239,680.00 ( 58,682.84)124.5 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 46,437.20 217,410.91 212,000.00 ( 5,410.91)102.6 01-0321-10-00 ALCOHOLIC BEVERAGE LICENSES 3,557.39 40,155.66 30,000.00 ( 10,155.66)133.9 01-0321-30-00 BUSINESS LICENSE FEE 1,125.00 19,125.00 19,000.00 ( 125.00)100.7 01-0322-10-00 BUILDING & INSPECTION PERMITS 419,782.84 1,949,506.83 1,250,000.00 ( 699,506.83)156.0 01-0322-12-00 PLAN REVIEW FEES 161,917.06 709,644.14 437,500.00 ( 272,144.14)162.2 01-0322-13-00 ENERGY STANDARDS (IRES)6,050.00 32,350.00 25,000.00 ( 7,350.00)129.4 01-0322-14-00 ELECTRICAL INSPECT FEE 65,394.17 277,344.28 205,000.00 ( 72,344.28)135.3 01-0322-15-00 PLUMBING INSPECTION FEES 56,484.91 255,204.43 205,000.00 ( 50,204.43)124.5 01-0322-16-00 MECHANICAL INSPECTION FEES 62,342.36 271,301.92 205,000.00 ( 66,301.92)132.3 01-0322-20-00 FIRE IMPACT ADMIN FEES 1,020.00 6,080.00 .00 ( 6,080.00).0 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 43,289.88 305,644.60 161,500.00 ( 144,144.60)189.3 01-0323-02-00 INSPECTION FEES 970.00 7,770.00 5,500.00 ( 2,270.00)141.3 01-0323-03-00 PLAN REVIEW FEES 8,875.00 41,550.00 30,000.00 ( 11,550.00)138.5 01-0323-04-00 STREET LIGHT INSPECTION FEES 130.00 920.00 834.00 ( 86.00)110.3 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,500.00 5,300.00 3,000.00 ( 2,300.00)176.7 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 5,000.00 21,750.00 18,000.00 ( 3,750.00)120.8 01-0324-01-00 TREE FUND 3,850.00 4,900.00 .00 ( 4,900.00).0 01-0331-61-00 MATCHING GRANT .00 .00 100,000.00 100,000.00 .0 01-0331-63-00 GRANTS/MATCHING FUNDS .00 .00 50,000.00 50,000.00 .0 01-0335-10-00 STATE LIQUOR 204,030.00 702,022.00 525,796.00 ( 176,226.00)133.5 01-0335-50-00 STATE SALES TAX 4.75 14.25 573,939.00 573,924.75 .0 01-0335-60-00 STATE REVENUE SHARING 1,009,527.52 3,012,719.96 2,105,889.00 ( 906,830.96)143.1 01-0338-40-00 COURT FEES 9,691.75 30,649.09 44,000.00 13,350.91 69.7 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT .00 15.00 1,000.00 985.00 1.5 01-0338-42-00 WEED ABATEMENT 261.25 565.28 2,000.00 1,434.72 28.3 01-0341-11-00 MISCELLANEOUS PERMITS/LICENSES 760.00 6,553.40 4,000.00 ( 2,553.40)163.8 01-0341-12-00 ANIMAL CONTROL FEES 1,073.00 10,751.00 15,000.00 4,249.00 71.7 01-0341-13-00 ENGINEERING FEES-DEVELOPERS 28,876.75 240,507.50 100,000.00 ( 140,507.50)240.5 01-0341-14-00 ATTORNEY FEES - DEVELOPER .00 14,816.65 10,000.00 ( 4,816.65)148.2 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 4,466.13 7,748.95 5,000.00 ( 2,748.95)155.0 01-0341-20-00 REIMBURSE WATER DEPARTMENT 3,201.00 12,803.00 12,803.00 .00 100.0 01-0341-21-00 PRESSURIZED IRRIGATION REIMB .00 .00 6,700.00 6,700.00 .0 01-0341-26-00 BACKGROUND CHECKS 111.00 1,147.00 200.00 ( 947.00)573.5 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 1,610.59 6,824.33 .00 ( 6,824.33).0 01-0341-28-00 ID POWER SUBSTATION WATER USE .00 .00 120.00 120.00 .0 01-0341-29-00 REVEL EAGLE-EASEMENT-MERRILL P .00 1,000.00 .00 ( 1,000.00).0 01-0350-05-00 FIELD OF HONOR 2,000.00 24,766.25 10,000.00 ( 14,766.25)247.7 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND 511.00 511.00 4,161.00 3,650.00 12.3 01-0371-25-00 BANK INVESTMENT INTEREST 2,148.98 6,978.84 6,000.00 ( 978.84)116.3 01-0379-00-00 MISCELLANEOUS .00 11,099.19 300.00 ( 10,799.19)3699.7 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 4 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG 27.48 369.93 500.00 130.07 74.0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 2,253.31 6,480.73 1,500.00 ( 4,980.73)432.1 01-0383-08-00 ELECTION REVENUE 160.00 160.00 .00 ( 160.00).0 01-0383-09-00 ROOM RESERVATIONS 188.00 238.00 766.00 528.00 31.1 01-0383-15-00 MISCELLANEOUS REVENUE 97.17 8,832.17 .00 ( 8,832.17).0 01-0383-17-00 COVID-19 FACE MASK PROCEEDS .00 205.80 .00 ( 205.80).0 01-0383-18-00 COVID-19 STIMULUS FUNDS .00 894,654.91 .00 ( 894,654.91).0 01-0385-00-00 FIRE DEPT IMPACT FEES 104,780.16 347,156.52 10,000.00 ( 337,156.52)3471.6 TOTAL FUND REVENUE 3,285,458.19 12,737,035.46 23,756,329.00 11,019,293.54 53.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 5 RESERVE 01-0410-01-00 MONEY MARKET ACCOUNT .00 .00 7,966,484.00 7,966,484.00 .0 01-0410-03-00 MONTHLY TRANSFERS TO DEPTS 845,700.11 3,299,379.20 3,683,064.00 383,684.80 89.6 01-0410-10-00 OPERATING ACCOUNT .00 .00 1,000,000.00 1,000,000.00 .0 01-0410-19-00 RESERVE, EMERGENCIES .00 13,526.87 521,430.00 507,903.13 2.6 TOTAL RESERVE 845,700.11 3,312,906.07 13,170,978.00 9,858,071.93 25.2 ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 1,380.00 4,370.00 4,200.00 ( 170.00)104.1 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,720.00 5,720.00 5,000.00 ( 720.00)114.4 01-0413-05-00 OFFICE EXPENSES 5,016.78 20,946.46 15,000.00 ( 5,946.46)139.6 01-0413-06-00 PRINTING & DISTRIBUTION 94.17 201.49 2,500.00 2,298.51 8.1 01-0413-07-00 POSTAGE 1,821.55 9,585.20 5,800.00 ( 3,785.20)165.3 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 2,211.17 5,258.40 2,000.00 ( 3,258.40)262.9 01-0413-10-00 INSURANCE - PROPERTY .00 48,191.00 52,391.00 4,200.00 92.0 01-0413-12-00 PERSONNEL TRAINING .00 395.00 6,000.00 5,605.00 6.6 01-0413-13-00 TRAVEL & PER DIEM .00 .00 4,000.00 4,000.00 .0 01-0413-14-00 PROFESSIONAL DUES 7,007.75 63,325.90 171,587.00 108,261.10 36.9 01-0413-25-00 MISCELLANEOUS 102.22 7,284.60 2,500.00 ( 4,784.60)291.4 01-0413-28-00 RESOURCE MATERIALS 764.74 4,634.63 1,500.00 ( 3,134.63)309.0 01-0413-29-00 REAL PROPERTY TAXES/CITY .00 233.00 225.00 ( 8.00)103.6 01-0413-31-00 ENGINEERING FEE/DEVELOPER CHGS 78,284.02 271,783.52 100,000.00 ( 171,783.52)271.8 01-0413-33-00 ATTORNEY FEE-CHARGE DEVELOPERS 4,223.04 11,071.54 20,000.00 8,928.46 55.4 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 714.35 1,745.10 1,000.00 ( 745.10)174.5 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 75.00 .00 ( 75.00).0 01-0413-46-00 PROPERTY TAX EXP -3%.00 .00 250.00 250.00 .0 01-0413-50-00 JOB POSTINGS 1,047.13 5,177.36 1,500.00 ( 3,677.36)345.2 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT .00 979.25 1,000.00 20.75 97.9 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 320.00 1,737.74 1,000.00 ( 737.74)173.8 01-0413-54-00 COVID-19 FACE MASK PURCHASES ( 30.00)19,970.00 .00 ( 19,970.00).0 01-0413-55-00 COVID-19 EXPENDITURES .00 793,101.71 .00 ( 793,101.71).0 TOTAL ADMINISTRATION 104,676.92 1,275,786.90 397,453.00 ( 878,333.90)321.0 PERSONNEL 01-0415-11-00 SALARIES-COUNCIL 12,720.00 49,820.00 50,880.00 1,060.00 97.9 01-0415-21-00 FICA 973.08 3,811.23 15,717.00 11,905.77 24.3 01-0415-22-00 PERSI 1,518.72 5,948.32 24,531.00 18,582.68 24.3 01-0415-23-00 HRA BUY-DOWN .00 .00 804.00 804.00 .0 01-0415-23-01 HRA/COBRA ADMIN FEES 377.39 822.82 .00 ( 822.82).0 01-0415-24-00 WORKERS' COMPENSATION 17.76 42,643.60 389.00 ( 42,254.60)10962. 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS .00 71.18 100.00 28.82 71.2 01-0415-25-00 INSURANCE .00 .00 24,000.00 24,000.00 .0 TOTAL PERSONNEL 15,606.95 103,117.15 116,421.00 13,303.85 88.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 44,314.21 277,253.37 250,000.00 ( 27,253.37)110.9 01-0416-02-02 LITIGATION ATTORNEYS FEES 5,842.00 7,930.00 50,000.00 42,070.00 15.9 01-0416-05-00 PROSECUTOR 15,999.00 64,000.00 64,000.00 .00 100.0 01-0416-06-00 IDAHO HUMANE SOCIETY 34,421.01 137,684.04 137,684.00 ( .04)100.0 01-0416-07-00 CITY ENGINEERING 395.00 2,161.25 50,000.00 47,838.75 4.3 01-0416-07-04 PARK/REC ENGINEERING FEES .00 .00 20,000.00 20,000.00 .0 01-0416-08-00 CITY AUDITOR SERVICES .00 12,500.00 20,000.00 7,500.00 62.5 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 803,457.00 3,213,833.63 3,213,834.00 .37 100.0 01-0416-23-00 GRANT WRITER .00 .00 15,000.00 15,000.00 .0 01-0416-31-00 MANLEY SERVICES .00 .00 300.00 300.00 .0 01-0416-35-00 ADMINISTRATIVE RESERVE 48,300.50 53,800.50 200,000.00 146,199.50 26.9 01-0416-46-00 ALLUMBAUGH HOUSE 4,437.25 17,749.00 17,749.00 .00 100.0 01-0416-49-00 DRUGFREE IDAHO 431.43 1,427.78 1,093.00 ( 334.78)130.6 01-0416-54-00 IDAHO SUICIDE PREVENTION .00 10,000.00 10,000.00 .00 100.0 01-0416-55-00 EAGLE SENIOR CENTER 25,000.00 100,000.00 100,000.00 .00 100.0 01-0416-56-00 CRIME STOPPERS .00 3,500.00 3,500.00 .00 100.0 TOTAL CONTRACTS & AGREEMENTS 982,597.40 3,901,839.57 4,153,160.00 251,320.43 94.0 CODE ENFORCEMENT 01-0417-00-00 WEED ABATEMENT .00 .00 12,000.00 12,000.00 .0 TOTAL CODE ENFORCEMENT .00 .00 12,000.00 12,000.00 .0 GRANTS 01-0421-01-00 GRANTS/MATCHING FUNDS .00 .00 100,000.00 100,000.00 .0 01-0421-03-00 MATCHING GRANT .00 .00 50,000.00 50,000.00 .0 TOTAL GRANTS .00 .00 150,000.00 150,000.00 .0 RESTRICTED FUNDS 01-0422-06-00 FIELD OF HONOR 17,850.64 18,824.69 10,000.00 ( 8,824.69)188.3 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,161.00 4,161.00 .0 TOTAL RESTRICTED FUNDS 17,850.64 18,824.69 14,161.00 ( 4,663.69)132.9 CONTINUING EDUCATION 01-0461-01-00 CONTINUING EDUCATION .00 .00 3,600.00 3,600.00 .0 TOTAL CONTINUING EDUCATION .00 .00 3,600.00 3,600.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 7 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 1,833.99 5,836.00 5,000.00 ( 836.00)116.7 01-0462-02-00 AWARDS & RECOGNITIONS 19.95 952.92 1,000.00 47.08 95.3 01-0462-03-00 CITY BRANDING/LOGO .00 .00 5,000.00 5,000.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,853.94 6,788.92 11,000.00 4,211.08 61.7 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER .00 151,263.00 151,263.00 .00 100.0 01-0463-02-00 ARTS COMMISSION TRANSFER .00 44,901.00 44,901.00 .00 100.0 01-0463-04-00 HISTORICAL COMMISSION TRANSFER .00 7,016.00 7,016.00 .00 100.0 01-0463-05-00 SPECIAL EVENTS TRANSFER .00 136,613.00 136,613.00 .00 100.0 01-0463-06-00 RECREATION PARKS-REC TRANSFER .00 313,674.00 313,674.00 .00 100.0 01-0463-07-00 CAPITAL PROJECTS TRANSFER .00 1,219,751.00 2,869,751.00 1,650,000.00 42.5 01-0463-08-00 EAGLE FUN DAYS TRANSFER .00 37,277.00 37,277.00 .00 100.0 01-0463-11-00 PUBLIC WORKS TRANSFER .00 2,009,789.00 2,009,789.00 .00 100.0 01-0463-12-00 CITY HALL BOND FUND TRANSFER .00 101,700.00 101,700.00 .00 100.0 TOTAL GENERAL FUND TRANSFERS .00 4,021,984.00 5,671,984.00 1,650,000.00 70.9 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VRT HWY 44 EXPRESS SRV ENHANC .00 45,808.00 45,834.00 26.00 99.9 01-0468-10-01 VRT EAGLE SENIOR CITIZENS .00 9,738.00 9,738.00 .00 100.0 TOTAL COMMUNITY PROJECTS-CAP OUTLA .00 55,546.00 55,572.00 26.00 100.0 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 146,042.16 347,156.52 .00 ( 347,156.52).0 TOTAL FIRE DEPARTMENT IMPACT FEES 146,042.16 347,156.52 .00 ( 347,156.52).0 TOTAL FUND EXPENDITURES 2,114,328.12 13,043,949.82 23,756,329.00 10,712,379.18 54.9 NET REVENUE OVER EXPENDITURES 1,171,130.07 ( 306,914.36).00 306,914.36 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 LIBRARY FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 8 ASSETS 06-0101-00-00 LIBRARY/CASH ( 43,479.61) 06-0103-00-00 LIBRARY/PETTY CASH 300.00 06-0104-00-00 PETTY CASH-CHILDRENS PROGRAMS 300.00 06-0107-00-00 LIBRARY/TAXES RECEIVABLE 14,690.40 06-0151-25-00 FIRST INTERSTATE INVESTMENT 917,915.38 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 891,598.17 LIABILITIES AND EQUITY LIABILITIES 06-0202-00-00 LIBRARY/VOUCHERS PAYABLE 1,527.01 06-0216-00-00 LIBRARY/ACCRUED PAYROLL 19,220.15 06-0217-03-00 LIBRARY/FICA 3,039.93 06-0217-04-00 LIBRARY/PUBLIC RETIREMENT 3,284.67 06-0217-07-00 LIBRARY HEALTH INSURANCE 3,811.76 06-0217-09-00 WORKERS' COMPENSATION 12,382.66 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 11,773.27 TOTAL LIABILITIES 57,493.45 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 659,973.11 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 174,131.61 BALANCE - CURRENT DATE 174,131.61 TOTAL FUND EQUITY 834,104.72 TOTAL LIABILITIES AND EQUITY 891,598.17 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 9 REVENUE 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE 523,890.72 1,541,204.34 1,511,079.00 ( 30,125.34)102.0 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS 995.44 2,668.19 1,000.00 ( 1,668.19)266.8 06-0361-20-00 LIBRARY/FINES/FEES 678.89 3,309.85 .00 ( 3,309.85).0 06-0361-20-01 LOST ITEMS 373.78 2,385.14 2,500.00 114.86 95.4 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 522.39 745.29 3,600.00 2,854.71 20.7 06-0361-21-01 3 D PRINTING 4.40 98.58 400.00 301.42 24.7 06-0371-25-00 BANK INTEREST 412.19 1,386.85 700.00 ( 686.85)198.1 06-0379-00-00 MISCELLANEOUS 2,701.67 4,711.79 750.00 ( 3,961.79)628.2 06-0380-02-00 GRANTS-GIFTS-MEMORIALS 5.00 2,563.00 .00 ( 2,563.00).0 06-0390-00-00 CARRY OVER .00 .00 75,000.00 75,000.00 .0 06-0390-01-00 RESERVE FUND .00 .00 440,000.00 440,000.00 .0 TOTAL FUND REVENUE 529,584.48 1,559,073.03 2,035,029.00 475,955.97 76.6 EXPENDITURES RESERVE 06-0410-01-00 RESERVE .00 .00 450,000.00 450,000.00 .0 TOTAL RESERVE .00 .00 450,000.00 450,000.00 .0 CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 122.50 367.50 10,000.00 9,632.50 3.7 06-0416-02-00 PHOTOCOPIERS 1,423.18 4,898.73 14,570.00 9,671.27 33.6 TOTAL CONTRACTS/AGREEMENTS 1,545.68 5,266.23 24,570.00 19,303.77 21.4 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 8,335.59 30,967.46 7,200.00 ( 23,767.46)430.1 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 3,500.00 32,361.64 42,090.00 9,728.36 76.9 06-0420-04-00 MARKETING 11,633.74 19,998.73 11,300.00 ( 8,698.73)177.0 06-0420-04-01 OUTREACH .00 179.96 3,000.00 2,820.04 6.0 06-0420-05-00 OFFICE SUPPLIES 2,188.17 5,250.61 9,373.00 4,122.39 56.0 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 6,860.99 14,236.21 8,000.00 ( 6,236.21)178.0 06-0420-06-00 UNIFORMS 3,459.20 3,459.20 3,905.00 445.80 88.6 06-0420-07-00 SMALL FURNITURE REPLACEMENT 4,217.26 7,528.65 1,400.00 ( 6,128.65)537.8 06-0420-09-00 MAINTENANCE AGREEMENTS 3,115.00 28,740.30 31,194.00 2,453.70 92.1 06-0420-10-00 POSTAGE 3,163.30 3,689.91 2,500.00 ( 1,189.91)147.6 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS .00 1,061.01 12,626.00 11,564.99 8.4 06-0420-12-00 DEBT COLLECTION .00 .00 2,340.00 2,340.00 .0 06-0420-13-00 PRINTING AND PUBLISHING 455.89 1,263.64 1,500.00 236.36 84.2 TOTAL OPERATIONS & MAINTENANCE 46,929.14 148,737.32 136,428.00 ( 12,309.32)109.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 10 LYNX1 CONSORTIUM 06-0430-00-00 LYNK! SYSTEM 4,206.01 17,175.07 18,300.00 1,124.93 93.9 06-0430-02-00 LYNX! COURIER 2,458.20 9,207.51 10,580.00 1,372.49 87.0 TOTAL LYNX1 CONSORTIUM 6,664.21 26,382.58 28,880.00 2,497.42 91.4 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 1,054.20 3,425.16 2,700.00 ( 725.16)126.9 06-0435-01-00 3D PRINTING .00 687.16 2,600.00 1,912.84 26.4 06-0435-02-00 LOST ITEMS REFUNDS 103.28 207.27 1,700.00 1,492.73 12.2 06-0435-03-00 OPEN ACCESS 374.56 1,028.67 1,200.00 171.33 85.7 TOTAL COST RECOVERY OR PASS THRU 1,532.04 5,348.26 8,200.00 2,851.74 65.2 TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE .00 5,487.43 10,762.00 5,274.57 51.0 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR 275.13 1,132.58 1,250.00 117.42 90.6 06-0440-02-00 COMPUTER EQUIPMENT (SMALL)126.73 5,267.05 3,600.00 ( 1,667.05)146.3 TOTAL TECHNOLOGY 401.86 11,887.06 15,612.00 3,724.94 76.1 GUEST RESOURCES 06-0450-00-00 BOOKS 32,550.82 83,748.01 127,384.00 43,635.99 65.7 06-0450-01-00 PRINT VENDOR PROCESSING 1,474.50 4,553.04 8,400.00 3,846.96 54.2 06-0450-02-00 BOOKS -DIGITAL 1,199.00 13,543.42 60,116.00 46,572.58 22.5 06-0450-03-00 MAGAZINES & NEWSPAPERS 3,957.76 5,036.01 6,344.00 1,307.99 79.4 06-0450-03-01 MAGAZINES - DIGITAL 2,782.00 3,922.00 6,000.00 2,078.00 65.4 06-0450-04-00 MEDIA 112,372.08 184,490.24 51,400.00 ( 133,090.24)358.9 06-0450-05-00 MEDIA - DIGITAL 16,552.00 60,159.20 50,315.00 ( 9,844.20)119.6 06-0450-06-00 DATABASES 5,585.00 14,474.99 10,862.00 ( 3,612.99)133.3 06-0450-07-00 HOTSPOT 1,434.00 4,429.85 5,400.00 970.15 82.0 TOTAL GUEST RESOURCES 177,907.16 374,356.76 326,221.00 ( 48,135.76)114.8 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 3,581.94 11,896.77 25,000.00 13,103.23 47.6 TOTAL GUEST CLASSES & EVENTS 3,581.94 11,896.77 25,000.00 13,103.23 47.6 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 96,229.95 390,824.22 415,153.00 24,328.78 94.1 06-0461-11-00 OVERTIME 209.10 849.57 5,065.00 4,215.43 16.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 11 06-0461-15-00 SALARIES - PART TIME 52,487.73 159,843.77 173,551.00 13,707.23 92.1 06-0461-21-00 FICA 12,796.21 42,947.72 45,036.00 2,088.28 95.4 06-0461-22-00 PERSI 13,386.73 47,721.28 49,569.00 1,847.72 96.3 06-0461-23-00 HRA BUY-DOWN .00 .00 1,850.00 1,850.00 .0 06-0461-23-01 HRA/COBRA ADMIN FEES 289.59 1,015.16 11,000.00 9,984.84 9.2 06-0461-24-00 WORKERS' COMPENSATION 321.76 2,096.09 6,472.00 4,375.91 32.4 06-0461-25-00 INSURANCE 9,600.24 45,139.29 55,469.00 10,329.71 81.4 06-0461-26-00 HSA CONTRIBUTION 940.00 4,700.00 5,280.00 580.00 89.0 06-0461-27-00 PTO CASH OUT .00 .00 52,234.00 52,234.00 .0 06-0461-28-00 UNEMPLOYMENT BENEFITS .00 175.99 18,000.00 17,824.01 1.0 06-0461-29-00 EMPLOYMENT TESTING .00 .00 750.00 750.00 .0 TOTAL PERSONNEL 186,261.31 695,313.09 839,429.00 144,115.91 82.8 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM .00 .00 17,300.00 17,300.00 .0 06-0463-01-00 MILEAGE REIMBURSEMENT 22.62 320.90 1,000.00 679.10 32.1 06-0463-02-00 TRAINING .00 400.00 2,375.00 1,975.00 16.8 06-0463-03-00 CONTINUING EDUCATION 1,194.00 5,373.00 12,500.00 7,127.00 43.0 06-0463-03-05 TUITION REIMBURSEMENT .00 8,658.12 12,500.00 3,841.88 69.3 06-0463-04-00 RECRUITMENT .00 .00 1,000.00 1,000.00 .0 06-0463-05-00 RELOCATION EXPENSE .00 .00 5,000.00 5,000.00 .0 06-0463-06-00 TRUSTEE-TRAVEL/MEETINGS .00 .00 5,600.00 5,600.00 .0 06-0463-08-00 VIRTUAL TRAINING .00 1,856.78 1,500.00 ( 356.78)123.8 TOTAL STAFF DEVELOPMENT 1,216.62 16,608.80 58,775.00 42,166.20 28.3 FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING .00 4,934.91 1,500.00 ( 3,434.91)329.0 06-0464-01-00 BUILDING SUPPLIES .00 .00 1,500.00 1,500.00 .0 06-0464-02-00 UTILITIES 5,867.94 21,315.26 27,000.00 5,684.74 79.0 06-0464-03-00 TELEPHONE 2,391.53 2,391.53 2,465.00 73.47 97.0 06-0464-04-00 SECURITY SYSEM 675.00 1,194.36 3,000.00 1,805.64 39.8 06-0464-05-00 CUSTODIAL 50.61 517.13 46,649.00 46,131.87 1.1 06-0464-06-00 GROUNDS .00 .00 1,000.00 1,000.00 .0 06-0464-07-00 FLOOR MATS 354.27 680.45 1,500.00 819.55 45.4 TOTAL FACILITY (BLDGS & GROUNDS)9,339.35 31,033.64 84,614.00 53,580.36 36.7 CAPITAL IMPROVEMENT 06-0466-00-00 CAPITAL BUILDING 10,488.32 10,488.32 .00 ( 10,488.32).0 06-0466-01-00 CAPITAL FURNISHING 25,690.74 29,024.74 .00 ( 29,024.74).0 06-0466-02-00 CAPITAL EQUIPMENT .00 4,193.08 .00 ( 4,193.08).0 06-0466-03-00 CAPITAL TECHNOLOGY 14,404.77 14,404.77 37,300.00 22,895.23 38.6 TOTAL CAPITAL IMPROVEMENT 50,583.83 58,110.91 37,300.00 ( 20,810.91)155.8 TOTAL FUND EXPENDITURES 485,963.14 1,384,941.42 2,035,029.00 650,087.58 68.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 12 NET REVENUE OVER EXPENDITURES 43,621.34 174,131.61 .00 ( 174,131.61).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 MUSEUM FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 13 ASSETS 07-0101-00-00 MUSEUM/CASH 46,900.01 07-0103-00-00 MUSEUM/PETTY CASH 75.00 TOTAL ASSETS 46,975.01 LIABILITIES AND EQUITY LIABILITIES 07-0202-00-00 VOUCHERS PAYABLE 492.93 07-0217-03-00 FICA 246.54 07-0217-04-00 MUSEUM/PERSI RETIREMENT 240.94 07-0217-07-00 MUSEUM HEALTH INSURANCE 923.56 07-0217-09-00 WORKERS' COMPENSATION 1,325.56 TOTAL LIABILITIES 3,229.53 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 13,325.87 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 30,419.61 BALANCE - CURRENT DATE 30,419.61 TOTAL FUND EQUITY 43,745.48 TOTAL LIABILITIES AND EQUITY 46,975.01 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 14 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND .00 151,263.00 151,263.00 .00 100.0 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATE .00 .00 300.00 300.00 .0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 343.19 153.00 ( 190.19)224.3 07-0380-00-00 GIFT SHOP REVENUE .00 23.30 15.00 ( 8.30)155.3 07-0390-00-00 MUSEUM CARRY OVER .00 .00 5,638.00 5,638.00 .0 TOTAL FUND REVENUE .00 151,629.49 157,369.00 5,739.51 96.4 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES-FULL TIME 14,125.72 52,333.05 51,433.00 ( 900.05)101.8 07-0420-15-00 SALARIES - PART TIME 7,747.66 28,889.60 45,716.00 16,826.40 63.2 07-0420-21-00 FICA 1,931.01 6,459.83 7,432.00 972.17 86.9 07-0420-22-00 PERSI 1,927.52 6,489.40 6,141.00 ( 348.40)105.7 07-0420-24-00 WORKERS' COMPENSATION 47.93 164.96 243.00 78.04 67.9 07-0420-25-00 INSURANCE 1,718.37 6,673.86 628.00 ( 6,045.86)1062.7 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL 27,498.21 101,010.70 113,133.00 12,122.30 89.3 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP .00 324.50 300.00 ( 24.50)108.2 07-0461-03-00 CONFERENCES & SEMINARS 560.32 719.64 2,000.00 1,280.36 36.0 07-0461-04-00 TRAVEL & PER DIEM 1,542.30 1,542.30 4,000.00 2,457.70 38.6 TOTAL EDUCATION 2,102.62 2,586.44 6,300.00 3,713.56 41.1 ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION .00 51.20 3,500.00 3,448.80 1.5 07-0462-31-00 OFFICE SUPPLIES 1,852.12 2,016.07 1,500.00 ( 516.07)134.4 07-0462-32-00 ARCHIVAL SUPPLIES 473.61 1,399.03 2,000.00 600.97 70.0 07-0462-33-00 PUBLICITY-PRINTING .00 1,125.92 2,000.00 874.08 56.3 07-0462-34-00 RESEARCH MATERIAL 208.90 208.90 100.00 ( 108.90)208.9 07-0462-35-00 UNIFORMS 305.76 305.76 300.00 ( 5.76)101.9 07-0462-36-00 MUSEUM SHRED-IT 138.44 1,300.85 736.00 ( 564.85)176.8 07-0462-37-00 SHRED - IT 418.95 418.95 .00 ( 418.95).0 07-0462-68-00 MUSEUM PROGRAMS 135.97 344.87 2,500.00 2,155.13 13.8 07-0462-69-00 MISCELLANEOUS 280.93 280.93 200.00 ( 80.93)140.5 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 291.89 300.00 8.11 97.3 TOTAL ADMINISTRATION 3,814.68 7,744.37 13,136.00 5,391.63 59.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 15 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES 1,108.20 1,211.18 1,000.00 ( 211.18)121.1 07-0463-02-00 EXHIBIT ITEMS 39.95 39.95 500.00 460.05 8.0 07-0463-03-00 EXHIBIT CONSTRUCTION 3,090.28 3,090.28 6,000.00 2,909.72 51.5 07-0463-04-00 ANNUAL EXHIBIT .00 .00 10,000.00 10,000.00 .0 TOTAL EXHIBITS 4,238.43 4,341.41 17,500.00 13,158.59 24.8 PROGRAMS 07-0464-08-00 GIFT SHOP SUPPLIES .00 .00 300.00 300.00 .0 TOTAL PROGRAMS .00 .00 300.00 300.00 .0 CAPITAL EXPENDITURES 07-0466-74-01 CAPITAL EXP FURNITURE 261.98 5,526.96 7,000.00 1,473.04 79.0 TOTAL CAPITAL EXPENDITURES 261.98 5,526.96 7,000.00 1,473.04 79.0 TOTAL FUND EXPENDITURES 37,915.92 121,209.88 157,369.00 36,159.12 77.0 NET REVENUE OVER EXPENDITURES ( 37,915.92)30,419.61 .00 ( 30,419.61).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 16 ASSETS 08-0101-00-00 PARK FUND/CASH 212,713.17 08-0151-25-00 FIRST INTERSTATE INVESTMENT 3,488,029.73 TOTAL ASSETS 3,700,742.90 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 2,419,683.92 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,281,058.98 BALANCE - CURRENT DATE 1,281,058.98 TOTAL FUND EQUITY 3,700,742.90 TOTAL LIABILITIES AND EQUITY 3,700,742.90 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 17 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 117,150.60 641,539.00 675,885.00 34,346.00 94.9 08-0371-25-00 BANK INTEREST 1,582.03 5,065.13 2,500.00 ( 2,565.13)202.6 08-0381-00-00 INTERFUND TRANSFERS, IN .00 1,016,818.00 .00 ( 1,016,818.00).0 08-0390-00-00 PARK FUND / CARRY OVER .00 .00 2,497,671.00 2,497,671.00 .0 TOTAL FUND REVENUE 118,732.63 1,663,422.13 3,176,056.00 1,512,633.87 52.4 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 65,696.11 382,363.15 3,176,056.00 2,793,692.85 12.0 TOTAL CAPITAL IMPROVEMENTS 65,696.11 382,363.15 3,176,056.00 2,793,692.85 12.0 TOTAL FUND EXPENDITURES 65,696.11 382,363.15 3,176,056.00 2,793,692.85 12.0 NET REVENUE OVER EXPENDITURES 53,036.52 1,281,058.98 .00 ( 1,281,058.98).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:26AM PAGE: 18 ASSETS 09-0101-00-00 CASH 152,178.59 TOTAL ASSETS 152,178.59 LIABILITIES AND EQUITY LIABILITIES 09-0202-00-00 VOUCHERS PAYABLE 700.00 09-0217-03-00 FICA 235.22 09-0217-04-00 PUBLIC RETIREMENT 337.51 09-0217-07-00 HEALTH INSURANCE 8,514.68 09-0217-09-00 WORKERS' COMPENSATION 12,192.53 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 25,299.29 FUND EQUITY 09-0271-00-00 FUND BALANCE 95,822.85 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 31,056.45 BALANCE - CURRENT DATE 31,056.45 TOTAL FUND EQUITY 126,879.30 TOTAL LIABILITIES AND EQUITY 152,178.59 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 19 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND .00 136,613.00 136,613.00 .00 100.0 09-0347-06-00 CHRISTMAS MARKET .00 1,505.00 1,400.00 ( 105.00)107.5 09-0347-08-00 SATURDAY MARKET 13,584.79 25,072.36 19,800.00 ( 5,272.36)126.6 09-0347-10-00 GAZEBO CONCERT SERIES 45.00 75.00 225.00 150.00 33.3 09-0347-11-00 HARVEST FEST MARKET 110.00 285.00 2,450.00 2,165.00 11.6 09-0376-12-00 MISCELLANEOUS REVENUE .00 .00 500.00 500.00 .0 09-0376-13-00 SPONSORSHIPS .00 3,500.00 20,000.00 16,500.00 17.5 09-0376-15-00 EVENT APPLICATION FEES 400.00 1,400.00 3,000.00 1,600.00 46.7 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 14,139.79 168,450.36 185,188.00 16,737.64 91.0 EXPENDITURES PERSONNEL 09-0420-10-00 SALARIES-FULL TIME 19,786.62 73,242.31 73,493.00 250.69 99.7 09-0420-11-00 OVERTIME 779.58 1,183.27 1,300.00 116.73 91.0 09-0420-15-00 SALARIES-PART TIME 2,520.08 4,192.52 16,157.00 11,964.48 26.0 09-0420-21-00 FICA 1,981.04 6,171.00 7,130.00 959.00 86.6 09-0420-22-00 PERSI 2,793.15 9,224.07 9,199.00 ( 25.07)100.3 09-0420-24-00 WORKERS' COMPENSATION 837.09 2,537.78 2,265.00 ( 272.78)112.0 09-0420-25-00 INSURANCE 2,138.75 8,368.21 9,364.00 995.79 89.4 09-0420-26-00 HSA CONTRIBUTION 450.00 1,800.00 1,800.00 .00 100.0 09-0420-29-00 PTO CASH OUT .00 .00 2,250.00 2,250.00 .0 TOTAL PERSONNEL 31,286.31 106,719.16 122,958.00 16,238.84 86.8 ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES .00 444.10 800.00 355.90 55.5 09-0463-12-00 PROMOTIONS .00 1,195.88 14,000.00 12,804.12 8.5 09-0463-19-00 TRAINING 595.00 595.00 1,200.00 605.00 49.6 09-0463-20-00 TRAVEL/PER DIEM 2,027.22 2,486.02 1,400.00 ( 1,086.02)177.6 09-0463-21-00 PROFESSIONAL DUES 50.00 1,935.20 2,030.00 94.80 95.3 09-0463-22-00 UNIFORMS 335.34 418.34 500.00 81.66 83.7 09-0463-23-00 GAS/MILEAGE .00 .00 150.00 150.00 .0 09-0463-25-00 SECURITY DEPOSIT REFUND .00 .00 1,200.00 1,200.00 .0 09-0463-26-00 MEMBERSHIPS .00 304.90 700.00 395.10 43.6 09-0463-27-00 EQUIPMENT 108.98 698.96 8,000.00 7,301.04 8.7 TOTAL ADMINISTRATION 3,116.54 8,078.40 29,980.00 21,901.60 27.0 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 3,934.32 6,886.33 8,000.00 1,113.67 86.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 20 09-0467-03-00 CHRISTMAS MARKET .00 1,909.84 4,500.00 2,590.16 42.4 09-0467-04-00 GAZEBO CONCERT SERIES 4,945.00 6,104.99 8,750.00 2,645.01 69.8 09-0467-05-00 GENERAL EVENTS 227.90 1,327.90 7,000.00 5,672.10 19.0 09-0467-06-00 EAGLE HARVEST FEST 797.05 2,648.74 4,000.00 1,351.26 66.2 09-0467-08-00 EVENTS EQUIPMENT RENTAL .00 2,048.55 .00 ( 2,048.55).0 TOTAL ACTIVITIES 9,904.27 20,926.35 32,250.00 11,323.65 64.9 EVENT REFUNDS 09-0468-01-00 EVENT REFUNDS ( 15.00)( 15.00).00 15.00 .0 09-0468-02-00 CHRISTMAS MARKET REFUND .00 1,505.00 .00 ( 1,505.00).0 09-0468-03-00 SATURDAY MARKET REFUND 120.00 180.00 .00 ( 180.00).0 TOTAL EVENT REFUNDS 105.00 1,670.00 .00 ( 1,670.00).0 TOTAL FUND EXPENDITURES 44,412.12 137,393.91 185,188.00 47,794.09 74.2 NET REVENUE OVER EXPENDITURES ( 30,272.33)31,056.45 .00 ( 31,056.45).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 21 ASSETS 10-0101-00-00 CASH 19,283.33 TOTAL ASSETS 19,283.33 LIABILITIES AND EQUITY FUND EQUITY 10-0271-00-00 FUND BALANCE 15,152.16 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 4,131.17 BALANCE - CURRENT DATE 4,131.17 TOTAL FUND EQUITY 19,283.33 TOTAL LIABILITIES AND EQUITY 19,283.33 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 22 REVENUE 10-0316-12-00 FUNDING FROM GENERAL FUND .00 7,016.00 7,016.00 .00 100.0 10-0390-00-00 CARRY OVER .00 .00 2,734.00 2,734.00 .0 TOTAL FUND REVENUE .00 7,016.00 9,750.00 2,734.00 72.0 EXPENDITURES ADMINISTRATION 10-0462-01-00 OFFICE SUPPLIES .00 .00 250.00 250.00 .0 10-0462-02-00 PUBLICITY - PRINTING .00 490.00 1,000.00 510.00 49.0 10-0462-05-00 EDUCATION/TRAINING .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION .00 490.00 1,750.00 1,260.00 28.0 PROGRAMS 10-0464-07-00 PRESERVATION .00 .00 1,000.00 1,000.00 .0 10-0464-08-00 COMM ENGAGEMENT/SPECIAL EVENTS 227.33 227.33 1,000.00 772.67 22.7 TOTAL PROGRAMS 227.33 227.33 2,000.00 1,772.67 11.4 GRANTS 10-0465-02-00 MUNICIPAL GRANT FUNDS .00 2,167.50 6,000.00 3,832.50 36.1 TOTAL GRANTS .00 2,167.50 6,000.00 3,832.50 36.1 TOTAL FUND EXPENDITURES 227.33 2,884.83 9,750.00 6,865.17 29.6 NET REVENUE OVER EXPENDITURES ( 227.33)4,131.17 .00 ( 4,131.17).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 23 LIABILITIES AND EQUITY LIABILITIES 11-0216-00-00 ACCRUED PAYROLL 1,750.00 11-0217-03-00 FICA 452.83 11-0217-04-00 EXEC DEPT/PUBLIC RETIREMENT 675.73 11-0217-07-00 EXEC DEPT HEALTH INSURANCE 1,608.07 11-0217-09-00 WORKERS' COMPENSATION 1,811.11 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 6,073.74 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 6,607.49) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 533.75 BALANCE - CURRENT DATE 533.75 TOTAL FUND EQUITY ( 6,073.74) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 24 REVENUE 11-0301-00-00 MONTHLY TRANSFER TO DEPTS 37,232.70 145,437.59 170,206.00 24,768.41 85.5 TOTAL FUND REVENUE 37,232.70 145,437.59 170,206.00 24,768.41 85.5 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 140.78 200.00 59.22 70.4 11-0413-05-00 OFFICE EXPENSES .00 38.42 200.00 161.58 19.2 11-0413-12-00 PERSONNEL TRAINING .00 355.00 5,000.00 4,645.00 7.1 11-0413-13-00 TRAVEL & PER DIEM 32.00 33.00 1,600.00 1,567.00 2.1 TOTAL ADMINISTRATION 32.00 567.20 7,000.00 6,432.80 8.1 PERSONNEL 11-0415-10-00 SALARIES-FULL TIME 28,955.78 111,782.33 128,370.00 16,587.67 87.1 11-0415-11-00 OVERTIME .00 .00 500.00 500.00 .0 11-0415-21-00 FICA 2,524.16 8,837.34 9,973.00 1,135.66 88.6 11-0415-22-00 PERSI 3,951.20 13,840.62 15,396.00 1,555.38 89.9 11-0415-24-00 WORKERS' COMPENSATION 51.12 184.82 217.00 32.18 85.2 11-0415-25-00 INSURANCE 739.21 3,501.80 .00 ( 3,501.80).0 11-0415-26-00 HSA CONTRIBUTION 180.00 880.00 1,200.00 320.00 73.3 11-0415-27-00 PTO CASH OUT .00 .00 1,500.00 1,500.00 .0 TOTAL PERSONNEL 36,401.47 139,026.91 157,156.00 18,129.09 88.5 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY .00 .00 1,500.00 1,500.00 .0 11-0417-02-00 PROGRAM PRINTING .00 .00 250.00 250.00 .0 11-0417-03-00 SWAG BAGS-TAKEAWAYS 1,176.28 2,279.18 250.00 ( 2,029.18)911.7 11-0417-04-00 DECORATIONS .00 .00 250.00 250.00 .0 TOTAL STATE OF THE CITY 1,176.28 2,279.18 2,250.00 ( 29.18)101.3 COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 1,239.37 1,984.74 3,800.00 1,815.26 52.2 11-0422-02-00 STAFF RELATIONS 1,005.00 1,045.81 .00 ( 1,045.81).0 TOTAL COMMUNITY & STAFF RELATIONS 2,244.37 3,030.55 3,800.00 769.45 79.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 25 TOTAL FUND EXPENDITURES 39,854.12 144,903.84 170,206.00 25,302.16 85.1 NET REVENUE OVER EXPENDITURES ( 2,621.42)533.75 .00 ( 533.75).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 26 LIABILITIES AND EQUITY LIABILITIES 12-0202-00-00 VOUCHERS PAYABLE ( 10.00) 12-0216-00-00 ACCRUED PAYROLL 7,001.54 12-0217-02-00 FEDERAL WITHHOLDING TAX .02 12-0217-03-00 FICA 1,420.86 12-0217-04-00 CLERKS DEPT/PUBLIC RETIREMENT 2,212.17 12-0217-07-00 CLERK DEPT HEALTH INSURANCE 7,882.17 12-0217-09-00 WORKERS' COMPENSATION 6,506.83 TOTAL LIABILITIES 25,013.59 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 20,308.88) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 4,704.71) BALANCE - CURRENT DATE ( 4,704.71) TOTAL FUND EQUITY ( 25,013.59) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 27 REVENUE 12-0301-00-00 MONTHLY TRANSFER TO DEPTS 111,003.90 473,386.43 568,890.00 95,503.57 83.2 TOTAL FUND REVENUE 111,003.90 473,386.43 568,890.00 95,503.57 83.2 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE EXPENSES 111.82 455.36 5,000.00 4,544.64 9.1 12-0413-06-00 DUPLICATION/PUBLISHING/PRINTIG 90.00 90.00 100.00 10.00 90.0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 1,320.34 2,226.34 12,200.00 9,973.66 18.3 12-0413-13-00 TRAVEL & PER DIEM 87.52 215.48 11,200.00 10,984.52 1.9 12-0413-14-00 PROFESSIONAL DUES 180.00 650.00 990.00 340.00 65.7 12-0413-29-00 UNIFORMS ( 10.00)432.70 750.00 317.30 57.7 TOTAL ADMINISTRATION 1,779.68 4,069.88 30,240.00 26,170.12 13.5 PERSONNEL 12-0415-10-00 SALARIES- FULL TIME 89,795.66 346,434.59 377,655.00 31,220.41 91.7 12-0415-11-00 OVERTIME 559.94 980.81 1,000.00 19.19 98.1 12-0415-15-00 SALARIES-PART TIME .00 .00 16,500.00 16,500.00 .0 12-0415-21-00 FICA 7,474.33 26,273.38 30,229.00 3,955.62 86.9 12-0415-22-00 PERSI 12,273.14 42,841.57 45,211.00 2,369.43 94.8 12-0415-23-00 HRA BUY- DOWN .00 2,543.76 .00 ( 2,543.76).0 12-0415-24-00 WORKERS' COMPENSATION 194.98 703.26 988.00 284.74 71.2 12-0415-25-00 INSURANCE 13,710.72 54,243.89 59,567.00 5,323.11 91.1 12-0415-26-00 PTO CASH OUT .00 .00 7,500.00 7,500.00 .0 TOTAL PERSONNEL 124,008.77 474,021.26 538,650.00 64,628.74 88.0 TOTAL FUND EXPENDITURES 125,788.45 478,091.14 568,890.00 90,798.86 84.0 NET REVENUE OVER EXPENDITURES ( 14,784.55)( 4,704.71).00 4,704.71 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 28 ASSETS 13-0103-00-00 PETTY CASH 100.00 TOTAL ASSETS 100.00 LIABILITIES AND EQUITY LIABILITIES 13-0202-00-00 VOUCHERS PAYABLE 40,822.18 13-0216-00-00 ACCRUED PAYROLL 5,067.00 13-0217-03-00 FICA 1,396.51 13-0217-04-00 BLDG DEPT/PUBLIC RETIREMENT 2,022.42 13-0217-07-00 BLDG DEPT HEALTH INSURANCE 7,254.37 13-0217-09-00 WORKERS' COMPENSATION 37,031.03 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 91,693.51 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 82,887.52) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 8,705.99) BALANCE - CURRENT DATE ( 8,705.99) TOTAL FUND EQUITY ( 91,593.51) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 29 REVENUE 13-0301-00-00 MONTHLY TRANSFER TO DEPTS 232,982.77 974,465.90 863,892.00 ( 110,573.90)112.8 TOTAL FUND REVENUE 232,982.77 974,465.90 863,892.00 ( 110,573.90)112.8 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE EXPENSES 348.80 5,555.62 6,000.00 444.38 92.6 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 118.88 300.00 181.12 39.6 13-0413-09-00 COMMERCIAL PLAN REVIEW 1,560.00 5,340.00 6,000.00 660.00 89.0 13-0413-12-00 TRAINING & CERTIFICATION RENEW .00 915.00 4,400.00 3,485.00 20.8 13-0413-13-00 TRAVEL & PER DIEM .00 .00 4,895.00 4,895.00 .0 13-0413-14-00 PROFESSIONAL DUES .00 535.00 505.00 ( 30.00)105.9 13-0413-25-00 MISCELLANEOUS .00 122.75 300.00 177.25 40.9 13-0413-28-00 RESOURCE MATERIALS .00 1,082.40 1,500.00 417.60 72.2 13-0413-29-03 MECHANICAL FEE REFUND 240.00 6,682.78 200.00 ( 6,482.78)3341.4 13-0413-29-04 PLUMBING PERMIT REFUND 1,165.00 5,245.00 200.00 ( 5,045.00)2622.5 13-0413-29-05 ELECTRICAL PERMIT REFUND 1,376.00 3,745.44 200.00 ( 3,545.44)1872.7 13-0413-30-00 UNIFORMS 875.66 875.66 1,000.00 124.34 87.6 TOTAL ADMINISTRATION 5,565.46 30,218.53 25,500.00 ( 4,718.53)118.5 PERSONNEL 13-0415-10-00 SALARIES-FULL TIME 83,170.20 282,486.94 248,800.00 ( 33,686.94)113.5 13-0415-11-00 OVERTIME 156.44 5,879.53 8,000.00 2,120.47 73.5 13-0415-21-00 FICA 7,074.74 22,425.46 20,501.00 ( 1,924.46)109.4 13-0415-22-00 PERSI 11,108.93 35,151.17 31,997.00 ( 3,154.17)109.9 13-0415-24-00 WORKERS' COMPENSATION 2,741.19 8,083.23 3,309.00 ( 4,774.23)244.3 13-0415-25-00 INSURANCE 14,364.25 47,456.46 46,055.00 ( 1,401.46)103.0 13-0415-26-00 HSA CONTRIBUTION 600.00 1,700.00 1,200.00 ( 500.00)141.7 13-0415-28-00 PTO CASH OUT .00 .00 11,180.00 11,180.00 .0 TOTAL PERSONNEL 119,215.75 403,182.79 371,042.00 ( 32,140.79)108.7 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTIONS 43,145.35 150,629.67 129,600.00 ( 21,029.67)116.2 13-0416-11-00 MECHANICAL INSPECTOR 47,590.90 159,389.45 129,600.00 ( 29,789.45)123.0 13-0416-13-00 BLDG INSPECTOR 20,733.00 63,223.00 58,800.00 ( 4,423.00)107.5 13-0416-14-00 PLAN REVIEW - CONTRACT 496.94 11,478.81 15,000.00 3,521.19 76.5 13-0416-25-00 ELECTRICAL INSPECTOR 53,882.50 164,993.74 129,600.00 ( 35,393.74)127.3 TOTAL CONTRACTS & AGREEMENTS 165,848.69 549,714.67 462,600.00 ( 87,114.67)118.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 30 VEHICLE OPERATIONS 13-0417-02-00 FUEL COSTS .00 55.90 750.00 694.10 7.5 13-0417-03-00 VEHICLE REPLACEMENT .00 .00 4,000.00 4,000.00 .0 TOTAL VEHICLE OPERATIONS .00 55.90 4,750.00 4,694.10 1.2 TOTAL FUND EXPENDITURES 290,629.90 983,171.89 863,892.00 ( 119,279.89)113.8 NET REVENUE OVER EXPENDITURES ( 57,647.13)( 8,705.99).00 8,705.99 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 31 ASSETS 14-0103-00-00 PETTY CASH 50.00 TOTAL ASSETS 50.00 LIABILITIES AND EQUITY LIABILITIES 14-0202-00-00 VOUCHERS PAYABLE 3,705.00 14-0216-00-00 ACCRUED PAYROLL 9,808.33 14-0217-03-00 FICA 3,391.86 14-0217-04-00 P&Z DEPT/PUBLIC RETIREMENT 5,215.16 14-0217-07-00 P&Z DEPT HEALTH INSURANCE ( 26,891.47) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 64,161.81 TOTAL LIABILITIES 59,594.03 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 39,825.40) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 19,718.63) BALANCE - CURRENT DATE ( 19,718.63) TOTAL FUND EQUITY ( 59,544.03) TOTAL LIABILITIES AND EQUITY 50.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 32 REVENUE 14-0301-00-00 MONTHLY TRANSFER TO DEPTS 255,601.21 957,160.80 1,104,183.00 147,022.20 86.7 TOTAL FUND REVENUE 255,601.21 957,160.80 1,104,183.00 147,022.20 86.7 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE EXPENSES 486.80 1,232.59 1,200.00 ( 32.59)102.7 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 76.00 1,000.00 924.00 7.6 14-0413-08-00 LEGAL ADS & PUBLICATIONS 1,028.63 4,295.16 8,000.00 3,704.84 53.7 14-0413-12-00 PERSONNEL TRAINING 325.00 1,050.00 4,100.00 3,050.00 25.6 14-0413-13-00 TRAVEL & PER DIEM 1.00 1.00 12,900.00 12,899.00 .0 14-0413-14-00 PROFESSIONAL DUES 924.00 2,413.00 2,000.00 ( 413.00)120.7 14-0413-23-01 SOFTWARE PURCHASE .00 .00 400.00 400.00 .0 14-0413-25-00 MISCELLANEOUS 1,826.92 2,548.76 500.00 ( 2,048.76)509.8 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES .00 1,990.00 2,000.00 10.00 99.5 14-0413-28-00 RESOURCE MATERIALS .00 .00 200.00 200.00 .0 14-0413-30-01 ENVIRONMENTAL REVIEW SERVICES .00 .00 5,000.00 5,000.00 .0 14-0413-37-00 ARBORICULTURE .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION 4,592.35 13,606.51 37,800.00 24,193.49 36.0 PERSONNEL 14-0415-10-00 SALARIES-FULL TIME 205,368.80 690,221.64 688,654.00 ( 1,567.64)100.2 14-0415-11-00 OVERTIME 2,181.14 4,922.85 11,300.00 6,377.15 43.6 14-0415-21-00 FICA 17,878.56 53,623.40 64,650.00 11,026.60 82.9 14-0415-22-00 PERSI 28,977.57 86,602.79 85,297.00 ( 1,305.79)101.5 14-0415-23-00 HRA/COBRA ADMIN FEES .00 33.75 .00 ( 33.75).0 14-0415-24-00 WORKERS' COMPENSATION 4,178.40 14,051.26 11,922.00 ( 2,129.26)117.9 14-0415-25-00 INSURANCE 25,049.33 86,286.73 136,528.00 50,241.27 63.2 14-0415-26-00 HSA CONTRIBUTION 600.00 2,400.00 5,400.00 3,000.00 44.4 14-0415-29-00 PTO CASH OUT .00 .00 14,432.00 14,432.00 .0 14-0415-30-00 HRA BUY- DOWN .00 .00 15,400.00 15,400.00 .0 TOTAL PERSONNEL 284,233.80 938,142.42 1,033,583.00 95,440.58 90.8 CONTRACTS & AGREEMENTS 14-0416-02-00 TRAILS CONSULTANTS-STUDIES .00 .00 20,000.00 20,000.00 .0 14-0416-03-00 PROFESSIONAL SERVICE CONTRACTS 9,405.00 25,130.50 .00 ( 25,130.50).0 TOTAL CONTRACTS & AGREEMENTS 9,405.00 25,130.50 20,000.00 ( 5,130.50)125.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 33 PUBLIC RELATIONS 14-0422-01-00 PUBLIC RELATIONS .00 .00 200.00 200.00 .0 TOTAL PUBLIC RELATIONS .00 .00 200.00 200.00 .0 CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT .00 .00 600.00 600.00 .0 TOTAL CAPITAL OUTLAY .00 .00 600.00 600.00 .0 COMMUNITY PLANNING PROJECTS 14-0468-02-00 COMPREHENSIVE PLAN REWRITE .00 .00 2,000.00 2,000.00 .0 14-0468-11-00 OTHER .00 .00 10,000.00 10,000.00 .0 TOTAL COMMUNITY PLANNING PROJECTS .00 .00 12,000.00 12,000.00 .0 TOTAL FUND EXPENDITURES 298,231.15 976,879.43 1,104,183.00 127,303.57 88.5 NET REVENUE OVER EXPENDITURES ( 42,629.94)( 19,718.63).00 19,718.63 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 34 ASSETS 17-0101-00-00 CASH 168,969.85 TOTAL ASSETS 168,969.85 LIABILITIES AND EQUITY LIABILITIES 17-0202-00-00 VOUCHERS PAYABLE 11,695.23 17-0217-03-00 FICA 1,664.07 17-0217-04-00 PUBLIC RETIREMENT 1,079.92 17-0217-07-00 HEALTH INSURANCE ( 5,678.18) 17-0217-09-00 WORKERS' COMPENSATION 30,742.63 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 35,277.74 FUND EQUITY 17-0271-00-00 FUND BALANCE 136,764.52 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 3,072.41) BALANCE - CURRENT DATE ( 3,072.41) TOTAL FUND EQUITY 133,692.11 TOTAL LIABILITIES AND EQUITY 168,969.85 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 35 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND .00 313,674.00 313,674.00 .00 100.0 17-0302-00-00 REGISTRATION 50,113.66 203,471.91 115,500.00 ( 87,971.91)176.2 17-0302-01-00 SPONSORSHIPS .00 .00 13,000.00 13,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 15,761.08 42,223.76 7,000.00 ( 35,223.76)603.2 17-0303-00-00 SCHOLARSHIP FUNDS .00 1,000.00 1,000.00 .00 100.0 TOTAL FUND REVENUE 65,874.74 560,369.67 450,174.00 ( 110,195.67)124.5 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES 7,363.00 24,238.88 25,000.00 761.12 97.0 17-0416-01-00 CONTRACT-PERMITS TEAM SPORTS 4,707.86 9,022.87 25,000.00 15,977.13 36.1 TOTAL CONTRACTS 12,070.86 33,261.75 50,000.00 16,738.25 66.5 PERSONNEL 17-0420-10-00 SALARIES-FULL TIME 63,642.86 230,847.40 165,651.00 ( 65,196.40)139.4 17-0420-11-00 SALARIES-SEASONAL 48,417.36 54,597.62 41,989.00 ( 12,608.62)130.0 17-0420-15-00 SALARIES-PART TIME 5,411.75 14,979.66 20,275.00 5,295.34 73.9 17-0420-18-00 OVERTIME 2,487.64 4,120.96 2,000.00 ( 2,120.96)206.1 17-0420-21-00 FICA 10,817.34 24,401.62 17,761.00 ( 6,640.62)137.4 17-0420-22-00 PERSI 8,981.86 28,790.62 20,286.00 ( 8,504.62)141.9 17-0420-24-00 WORKERS' COMPENSATION 5,499.75 12,183.59 8,506.00 ( 3,677.59)143.2 17-0420-25-00 INSURANCE 7,690.00 28,370.83 28,006.00 ( 364.83)101.3 17-0420-26-00 HSA CONTRIBUTION 750.00 3,400.00 3,600.00 200.00 94.4 17-0420-27-00 PTO CASH OUT .00 .00 2,250.00 2,250.00 .0 TOTAL PERSONNEL 153,698.56 401,692.30 310,324.00 ( 91,368.30)129.4 RESTRICTED FUNDS 17-0421-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL RESTRICTED FUNDS .00 .00 1,000.00 1,000.00 .0 ADMINISTRATION 17-0422-00-00 TRAINING-PROFESSIONAL DEVELOP 22.80 314.77 1,000.00 685.23 31.5 17-0422-01-00 OFFICE SUPPLIES .00 531.31 1,000.00 468.69 53.1 17-0422-02-00 ADVERTISING/MKTING CAMP/CLASS 1.11 184.10 4,500.00 4,315.90 4.1 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS 77.40 675.32 .00 ( 675.32).0 17-0422-03-00 PRINTING AND PUBLISHING 569.83 599.83 .00 ( 599.83).0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 36 17-0422-04-00 GAS/MILEAGE 43.68 43.68 100.00 56.32 43.7 17-0422-05-00 COMMUNICATION 74.00 74.00 .00 ( 74.00).0 17-0422-06-00 PRINTING AND PUBLISHING 366.90 8,207.32 25,000.00 16,792.68 32.8 17-0422-07-00 PROFESSIONAL DUES 1,015.46 1,065.46 2,000.00 934.54 53.3 17-0422-08-00 TRAINING 598.00 598.00 2,000.00 1,402.00 29.9 17-0422-09-00 TRAVEL/PER DIEM 2,037.22 2,700.96 4,000.00 1,299.04 67.5 17-0422-10-00 BACKGROUND CHECKS 1,405.75 2,153.10 1,500.00 ( 653.10)143.5 17-0422-11-00 REFUNDS-PARK REC PROGRAMS 2,106.00 2,476.00 4,000.00 1,524.00 61.9 TOTAL ADMINISTRATION 8,318.15 19,623.85 45,100.00 25,476.15 43.5 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 2,626.92 7,466.05 5,000.00 ( 2,466.05)149.3 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 5,327.81 15,326.31 5,000.00 ( 10,326.31)306.5 17-0423-01-00 UNIFORMS 10,144.70 25,163.71 1,000.00 ( 24,163.71)2516.4 17-0423-02-00 FIELD TRIPS 11,416.48 12,550.42 3,000.00 ( 9,550.42)418.4 17-0423-03-00 FACILITY RENTAL 4,225.00 20,235.00 3,000.00 ( 17,235.00)674.5 17-0423-04-00 TRANSPORTATION SERVICES 14,456.25 15,281.25 7,000.00 ( 8,281.25)218.3 17-0423-05-00 DADDY DAUGHTER DANCE .00 .00 1,800.00 1,800.00 .0 17-0423-05-01 EAGLE FUN DAYS ( 357.94).00 .00 .00 .0 17-0423-07-00 GLOW IN THE PARK .00 3,388.83 3,700.00 311.17 91.6 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT .00 .00 450.00 450.00 .0 17-0423-09-00 VETERAN'S BREAKFAST .00 556.38 800.00 243.62 69.6 17-0423-10-00 NEW PROGRAMS .00 562.97 2,000.00 1,437.03 28.2 TOTAL RECREATION 47,839.22 100,530.92 32,750.00 ( 67,780.92)307.0 VEHICLES 17-0424-03-00 GAS 495.42 789.41 1,000.00 210.59 78.9 TOTAL VEHICLES 495.42 789.41 1,000.00 210.59 78.9 CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT-TEAM SPORTS 4,360.30 7,543.85 10,000.00 2,456.15 75.4 TOTAL CAPITAL EQUIPMENT 4,360.30 7,543.85 10,000.00 2,456.15 75.4 TOTAL FUND EXPENDITURES 226,782.51 563,442.08 450,174.00 ( 113,268.08)125.2 NET REVENUE OVER EXPENDITURES ( 160,907.77)( 3,072.41).00 3,072.41 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 37 LIABILITIES AND EQUITY LIABILITIES 18-0202-00-00 VOUCHERS PAYABLE 22,822.80 18-0217-03-00 FICA 555.58 18-0217-04-00 PUBLIC RETIRMENT 936.81 18-0217-07-00 HEALTH INSURANCE ( 24,159.15) 18-0217-09-00 WORKERS' COMPENSATION 1,426.32 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES 2,402.36 FUND EQUITY 18-0271-00-00 FUND BALANCE ( 8,379.89) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 5,977.53 BALANCE - CURRENT DATE 5,977.53 TOTAL FUND EQUITY ( 2,402.36) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 38 REVENUE 18-0301-00-00 MONTHLY TRANSFER TO DEPTS 164,800.49 598,062.82 757,014.00 158,951.18 79.0 TOTAL FUND REVENUE 164,800.49 598,062.82 757,014.00 158,951.18 79.0 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES .00 23.31 4,000.00 3,976.69 .6 18-0413-03-00 TRAINING 1,199.00 2,618.00 6,450.00 3,832.00 40.6 18-0413-04-00 TRAVEL AND PER DIEM .00 .00 6,600.00 6,600.00 .0 18-0413-05-00 PROFESSIONAL DUES .00 .00 600.00 600.00 .0 18-0413-06-00 UNIFORMS 570.46 570.46 400.00 ( 170.46)142.6 TOTAL ADMINISTRATION 1,769.46 3,211.77 19,050.00 15,838.23 16.9 PERSONNEL 18-0415-10-00 SALARIES (FULL TIME)54,932.65 186,499.79 215,244.00 28,744.21 86.7 18-0415-11-00 IT DEPT/OVERTIME 138.11 653.20 1,000.00 346.80 65.3 18-0415-21-00 FICA 4,498.35 13,945.87 16,612.00 2,666.13 84.0 18-0415-22-00 PERSI 7,512.25 23,282.81 16,181.00 ( 7,101.81)143.9 18-0415-23-00 HRA BUY- DOWN .00 .00 6,160.00 6,160.00 .0 18-0415-24-00 WORKERS' COMPENSATION 119.49 379.04 515.00 135.96 73.6 18-0415-25-00 INSURANCE 8,905.21 31,474.84 40,637.00 9,162.16 77.5 18-0415-26-00 HSA 180.00 720.00 720.00 .00 100.0 18-0415-27-00 PTO CASH OUT .00 .00 900.00 900.00 .0 TOTAL PERSONNEL 76,286.06 256,955.55 297,969.00 41,013.45 86.2 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 75,615.84 187,874.16 258,870.00 70,995.84 72.6 18-0416-02-00 REPAIR & SERVICES .00 1,417.43 .00 ( 1,417.43).0 TOTAL CONTRACT & AGREEMENTS 75,615.84 189,291.59 258,870.00 69,578.41 73.1 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 18,329.50 65,870.46 70,425.00 4,554.54 93.5 TOTAL INTERNET/PHONE SERVICES 18,329.50 65,870.46 70,425.00 4,554.54 93.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 39 OPERATIONAL RESERVE 18-0418-01-00 OPERATIONAL RESV, EQUIP/SOFTWR 1,445.01 28,887.92 30,000.00 1,112.08 96.3 TOTAL OPERATIONAL RESERVE 1,445.01 28,887.92 30,000.00 1,112.08 96.3 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 143.08 1,300.00 1,156.92 11.0 18-0419-02-00 EQUIPMENT 14,848.17 40,068.92 59,150.00 19,081.08 67.7 18-0419-03-00 SOFTWARE PURCHASES 7,656.00 7,656.00 20,000.00 12,344.00 38.3 18-0419-05-00 TOOLS .00 .00 250.00 250.00 .0 TOTAL CAPITAL OUTLAY 22,504.17 47,868.00 80,700.00 32,832.00 59.3 TOTAL FUND EXPENDITURES 195,950.04 592,085.29 757,014.00 164,928.71 78.2 NET REVENUE OVER EXPENDITURES ( 31,149.55)5,977.53 .00 ( 5,977.53).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 40 ASSETS 19-0101-00-00 CASH 3,038,014.38 19-0151-25-00 FIRST INTERSTATE INVESTMENT 9,345,641.36 19-0151-25-01 FIRST INTERSTATE INV CITY HALL 822,313.84 TOTAL ASSETS 13,205,969.58 LIABILITIES AND EQUITY FUND EQUITY 19-0271-00-00 FUND BALANCE 2,617,313.93 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 10,588,655.65 BALANCE - CURRENT DATE 10,588,655.65 TOTAL FUND EQUITY 13,205,969.58 TOTAL LIABILITIES AND EQUITY 13,205,969.58 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 41 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND .00 1,219,751.00 1,219,751.00 .00 100.0 19-0301-01-00 BANK INTEREST 244.38 372.40 500.00 127.60 74.5 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 16,251.07 247,301.64 370,000.00 122,698.36 66.8 19-0301-07-00 HALF CFI PED/BIKE EDUCATION .00 4,157.74 .00 ( 4,157.74).0 19-0301-11-00 SALE OF REAL PROPERTY 9,100,310.56 9,100,310.56 1,650,000.00 ( 7,450,310.56)551.5 19-0301-12-00 FEMA GENERAL REVENUE .00 337,464.81 1,891,403.00 1,553,938.19 17.8 19-0301-13-00 EURA COST SHARE .00 .00 424,000.00 424,000.00 .0 19-0301-20-00 COMPASS CIM GRANT .00 .00 25,000.00 25,000.00 .0 19-0331-01-00 ARPA, AMERICAN RESCUE PLAN ACT .00 3,204,501.48 .00 ( 3,204,501.48).0 19-0371-25-01 BANK INTEREST, EXPANSION 40.75 164.20 .00 ( 164.20).0 19-0390-00-00 CARRY OVER .00 .00 1,289,462.00 1,289,462.00 .0 TOTAL FUND REVENUE 9,116,846.76 14,114,023.83 6,870,116.00 ( 7,243,907.83)205.4 EXPENDITURES CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE .00 31,000.00 1,225,392.00 1,194,392.00 2.5 19-0462-02-00 GUERBER PARK BALLFIELDS .00 6,000.00 10,000.00 4,000.00 60.0 19-0462-03-00 FEMA TRAIL REPLACEMENT .00 2,402.60 1,423,724.00 1,421,321.40 .2 TOTAL CAPITAL MAINTENANCE .00 39,402.60 2,659,116.00 2,619,713.40 1.5 TRANSFERS 19-0463-00-00 INTERFUND TRANSFERS, OUT .00 1,016,818.00 .00 ( 1,016,818.00).0 TOTAL TRANSFERS .00 1,016,818.00 .00 ( 1,016,818.00).0 CITY CAPITAL PROJECTS 19-0465-05-00 GENERAL CITY PROJECTS ( 15,417.34)4,298.43 100,000.00 95,701.57 4.3 19-0465-06-00 EXPANSION OF CITY HALL 903,939.31 1,002,172.42 1,650,000.00 647,827.58 60.7 19-0465-07-00 LAND PURCHASES 1,104,174.87 1,104,174.87 .00 ( 1,104,174.87).0 TOTAL CITY CAPITAL PROJECTS 1,992,696.84 2,110,645.72 1,750,000.00 ( 360,645.72)120.6 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION .00 .00 561,000.00 561,000.00 .0 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 78,478.28 327,831.36 900,000.00 572,168.64 36.4 19-0466-07-00 TRANSPORTATION/PLANNING GRANT 28,814.25 28,814.25 .00 ( 28,814.25).0 19-0466-09-00 EAGLE-STATE ST INTERSECTION .00 .00 670,000.00 670,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 42 TOTAL PZ CAPITAL PROJECTS 107,292.53 356,645.61 2,131,000.00 1,774,354.39 16.7 TRAILS-PATHWAY - FLOODING 19-0471-00-00 FEMA PA GRANT - FLOODING 1,856.25 1,856.25 .00 ( 1,856.25).0 TOTAL TRAILS-PATHWAY - FLOODING 1,856.25 1,856.25 .00 ( 1,856.25).0 TRAILS & PATHWAYS 19-0473-03-00 GREENBELT MAINTENANCE .00 .00 330,000.00 330,000.00 .0 TOTAL TRAILS & PATHWAYS .00 .00 330,000.00 330,000.00 .0 TOTAL FUND EXPENDITURES 2,101,845.62 3,525,368.18 6,870,116.00 3,344,747.82 51.3 NET REVENUE OVER EXPENDITURES 7,015,001.14 10,588,655.65 .00 ( 10,588,655.65).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 43 ASSETS 21-0101-00-00 CASH 24,558.04 TOTAL ASSETS 24,558.04 LIABILITIES AND EQUITY FUND EQUITY 21-0271-00-00 FUND BALANCE 20,108.92 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 4,449.12 BALANCE - CURRENT DATE 4,449.12 TOTAL FUND EQUITY 24,558.04 TOTAL LIABILITIES AND EQUITY 24,558.04 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 44 REVENUE 21-0301-00-00 FUNDING FROM GENERAL FUND .00 44,901.00 44,901.00 .00 100.0 21-0376-07-00 DONATIONS .00 .00 500.00 500.00 .0 21-0376-09-00 SCHOLARSHIPS .00 .00 500.00 500.00 .0 21-0376-11-00 GALLERY MAINTENANCE .00 430.00 500.00 70.00 86.0 21-0376-12-00 POSTCARD REVENUE 1.00 8.00 300.00 292.00 2.7 21-0390-00-00 CARRY OVER .00 .00 30,719.00 30,719.00 .0 TOTAL FUND REVENUE 1.00 45,339.00 77,420.00 32,081.00 58.6 EXPENDITURES ADMINISTRATION 21-0420-00-00 ADMINISTRATION .00 186.32 10,000.00 9,813.68 1.9 21-0420-01-00 POSTCARD EXPENDITURES .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION .00 186.32 10,300.00 10,113.68 1.8 ART EDUCATION 21-0421-00-00 ART EDUCATION & ADVOCACY 7,000.00 11,000.00 19,000.00 8,000.00 57.9 TOTAL ART EDUCATION 7,000.00 11,000.00 19,000.00 8,000.00 57.9 ART INSTALLATION 21-0422-00-00 ARTS IN PUBLIC SPACES/BEAUTIFY 20,778.57 26,261.46 27,120.00 858.54 96.8 TOTAL ART INSTALLATION 20,778.57 26,261.46 27,120.00 858.54 96.8 ACQUISITION OF ART 21-0423-00-00 ACQUISITION OF ART .00 .00 1,500.00 1,500.00 .0 TOTAL ACQUISITION OF ART .00 .00 1,500.00 1,500.00 .0 COMMUNITY EVENTS 21-0425-00-00 COMMUNITY EVENTS 2,287.80 3,388.22 18,000.00 14,611.78 18.8 TOTAL COMMUNITY EVENTS 2,287.80 3,388.22 18,000.00 14,611.78 18.8 CITY BEAUTIFICATION CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 45 21-0426-00-00 CITY BEAUTIFICATION .00 53.88 .00 ( 53.88).0 TOTAL CITY BEAUTIFICATION .00 53.88 .00 ( 53.88).0 GALLERY MTNC/SUPPLIES 21-0427-00-00 GALLERY MTNC/SLUPPLIES .00 .00 1,500.00 1,500.00 .0 TOTAL GALLERY MTNC/SUPPLIES .00 .00 1,500.00 1,500.00 .0 TOTAL FUND EXPENDITURES 30,066.37 40,889.88 77,420.00 36,530.12 52.8 NET REVENUE OVER EXPENDITURES ( 30,065.37)4,449.12 .00 ( 4,449.12).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 46 ASSETS 23-0151-00-00 INVESTMENTS 780,473.65 TOTAL ASSETS 780,473.65 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE 75,536.96 23-0216-00-00 ACCRUED PAYROLL 9,200.85 23-0217-02-00 FEDERAL WITHHOLDING 25.57 23-0217-03-00 FICA 3,569.98 23-0217-04-00 PUBLIC RETIREMENT 2,814.49 23-0217-05-00 PW DEPT MISC DEDUCTIONS ( 14,386.03) 23-0217-07-00 HEALTH INSURANCE 28,349.11 23-0217-08-00 GARNISHMENT ( 1,162.50) 23-0217-09-00 WORKERS' COMPENSATION 89,958.51 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 192,746.94 FUND EQUITY 23-0271-00-00 FUND BALANCE 222,391.44 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 365,335.27 BALANCE - CURRENT DATE 365,335.27 TOTAL FUND EQUITY 587,726.71 TOTAL LIABILITIES AND EQUITY 780,473.65 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 47 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND .00 2,009,789.00 2,009,789.00 .00 100.0 23-0303-00-00 VENDOR LEASE PAYMENTS, PARKS 4,819.10 9,772.18 1,300.00 ( 8,472.18)751.7 23-0314-00-00 VEHICLE REPLACEMENT .00 .00 63,700.00 63,700.00 .0 23-0315-01-00 SANITATION SERVICES 13,079.50 70,707.82 13,000.00 ( 57,707.82)543.9 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 150,000.00 150,000.00 .0 23-0315-06-00 TREE FUNDS .00 .00 30,795.00 30,795.00 .0 23-0315-08-00 LIBRARY FLOORING, SAVINGS .00 .00 290,000.00 290,000.00 .0 23-0315-09-00 WYCLIFF PUMP STATION .00 8,985.03 6,690.00 ( 2,295.03)134.3 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 300.00 300.00 .00 100.0 23-0316-01-00 MEMORIAL DONATIONS 2,657.72 7,112.43 6,000.00 ( 1,112.43)118.5 TOTAL FUND REVENUE 20,556.32 2,106,666.46 2,571,574.00 464,907.54 81.9 EXPENDITURES ADMINISTRATION 23-0413-01-00 OFFICE SUPPLIES .00 412.78 750.00 337.22 55.0 23-0413-02-00 PRINTING AND PUBLISHING .00 46.35 500.00 453.65 9.3 23-0413-03-00 LEGAL, ADV, PUBLICATION .00 460.66 500.00 39.34 92.1 23-0413-04-00 TRAINING 653.96 2,777.71 15,500.00 12,722.29 17.9 23-0413-05-00 TRAVEL & PER DIEM .00 11.48 6,725.00 6,713.52 .2 23-0413-06-00 PROFESSIONAL DUES .00 .00 1,000.00 1,000.00 .0 23-0413-07-00 TELEPHONE AND COMMUNICATIONS .00 714.12 .00 ( 714.12).0 23-0413-09-00 UNIFORMS 200.00 2,915.71 4,800.00 1,884.29 60.7 23-0413-10-00 PUBLIC RELATIONS 46.48 335.43 1,000.00 664.57 33.5 TOTAL ADMINISTRATION 900.44 7,674.24 30,775.00 23,100.76 24.9 GEN MAINTENANCE & REPAIR 23-0414-02-00 MISC MTNC & REPAIR GROUNDS 20,647.27 32,237.98 40,000.00 7,762.02 80.6 23-0414-03-00 MATERIALS AND SUPPLIES 26,195.45 46,266.33 47,000.00 733.67 98.4 23-0414-04-00 HOLIDAY LIGHTING 5,965.31 10,130.30 3,500.00 ( 6,630.30)289.4 23-0414-05-00 PAPER PRODUCTS 5,443.35 40,644.64 30,000.00 ( 10,644.64)135.5 23-0414-06-00 BACK FLOW PARTS REPLACEMENT .00 96.47 5,000.00 4,903.53 1.9 23-0414-07-01 MTNC/RPR SNOW EQUIPMENT .00 .00 1,500.00 1,500.00 .0 23-0414-08-00 SIGNS & SIGN REPLACEMENT 3,461.62 6,135.51 5,000.00 ( 1,135.51)122.7 23-0414-10-00 ROOF MAINTENANCE .00 .00 3,000.00 3,000.00 .0 23-0414-11-00 HVAC MAINTENANCE .00 917.15 1,500.00 582.85 61.1 23-0414-12-00 EMERGENCY REPAIRS .00 .00 25,000.00 25,000.00 .0 TOTAL GEN MAINTENANCE & REPAIR 61,713.00 136,428.38 161,500.00 25,071.62 84.5 PW RESTRICTED FUNDS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 48 23-0415-02-00 SIDEWALKS, LTS, TREES, STR-REP 2,800.00 2,800.00 150,000.00 147,200.00 1.9 23-0415-08-00 LIBRARY FLOORING 248,112.85 331,853.90 290,000.00 ( 41,853.90)114.4 TOTAL PW RESTRICTED FUNDS 250,912.85 334,653.90 440,000.00 105,346.10 76.1 CONTRACTS & AGREEMENTS 23-0416-00-00 WYCLIFFE PUMP STATION 3,567.15 6,174.57 6,690.00 515.43 92.3 23-0416-01-00 FARMERS UNION .00 1,153.03 960.00 ( 193.03)120.1 23-0416-02-00 EAST ENTRY SIGN .00 342.77 1,000.00 657.23 34.3 23-0416-03-00 SCENIC BYWAY .00 .00 154.00 154.00 .0 23-0416-07-00 CHAUMONT LEASE AGREEMENT .00 1.00 1.00 .00 100.0 23-0416-08-00 BASELINE MANAGER AGREEMENT .00 3,383.00 2,000.00 ( 1,383.00)169.2 23-0416-09-00 NEW DRY CREEK DITCH CO .00 991.00 700.00 ( 291.00)141.6 23-0416-10-00 BALLANTYNE/BOISE VALLEY DITCH .00 1,680.00 1,100.00 ( 580.00)152.7 23-0416-11-00 LEGAL SERVICES .00 .00 2,000.00 2,000.00 .0 TOTAL CONTRACTS & AGREEMENTS 3,567.15 13,725.37 14,605.00 879.63 94.0 VEHICLES 23-0417-01-00 VEHICLE MTNC & REPAIR 6,993.80 13,313.89 15,000.00 1,686.11 88.8 23-0417-02-00 GAS AND OIL 9,939.02 22,002.78 21,500.00 ( 502.78)102.3 23-0417-03-00 VEHICLE REPLACEMENT .00 .00 51,000.00 51,000.00 .0 23-0417-05-00 VEHICLE CAR WASH 40.00 85.00 660.00 575.00 12.9 TOTAL VEHICLES 16,972.82 35,401.67 88,160.00 52,758.33 40.2 PROGRAMS 23-0418-03-00 MEMORIALS, MTNC/REPAIR 3,847.05 3,981.15 6,000.00 2,018.85 66.4 TOTAL PROGRAMS 3,847.05 3,981.15 6,000.00 2,018.85 66.4 FLOWER BASKETS 23-0419-01-00 MATERIALS & SUPPLIES .00 759.00 2,000.00 1,241.00 38.0 23-0419-02-00 FLOWERS .00 15,000.00 15,000.00 .00 100.0 TOTAL FLOWER BASKETS .00 15,759.00 17,000.00 1,241.00 92.7 EQUIPMENT MTNC & REPAIR 23-0420-00-00 MTNC/REPAIR EQUIPMENT 5,096.30 10,663.10 10,000.00 ( 663.10)106.6 TOTAL EQUIPMENT MTNC & REPAIR 5,096.30 10,663.10 10,000.00 ( 663.10)106.6 SUSTAINABILITY-CONSERVATION CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 49 23-0421-01-00 SANITATION SERVICES 4,643.57 20,328.97 54,000.00 33,671.03 37.7 23-0421-02-00 TREE FUNDS .00 .00 29,511.00 29,511.00 .0 23-0421-03-00 TREE VOUCHER PROGRAM 95.39 14,877.18 15,000.00 122.82 99.2 23-0421-04-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0421-05-00 FACILITY AUTOMATION UPGRADE .00 .00 77,000.00 77,000.00 .0 23-0421-06-00 LED FACILITY BULB CONVERSION .00 .00 15,000.00 15,000.00 .0 23-0421-07-00 LEAF RECYCLING PROGRAM .00 853.20 25,000.00 24,146.80 3.4 23-0421-08-00 TREE RECYCLING PROGRAM .00 .00 13,000.00 13,000.00 .0 TOTAL SUSTAINABILITY-CONSERVATION 4,738.96 36,059.35 228,811.00 192,751.65 15.8 FLEET MANAGEMENT 23-0423-00-00 VEHICLE REPLACEMENT 8,569.00 22,649.00 83,700.00 61,051.00 27.1 TOTAL FLEET MANAGEMENT 8,569.00 22,649.00 83,700.00 61,051.00 27.1 PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 125,134.29 487,347.86 477,675.00 ( 9,672.86)102.0 23-0433-11-00 OVERTIME 5,255.80 9,482.39 18,600.00 9,117.61 51.0 23-0433-15-00 SALARIES-PART TIME .00 1,659.16 15,640.00 13,980.84 10.6 23-0433-16-00 SALARIES-SEASONAL 38,236.74 68,467.21 129,500.00 61,032.79 52.9 23-0433-21-00 FICA 14,554.46 44,224.08 50,330.00 6,105.92 87.9 23-0433-22-00 PERSI 17,776.03 61,683.75 61,225.00 ( 458.75)100.8 23-0433-24-00 WORKERS' COMPENSATION 7,703.21 23,377.75 25,015.00 1,637.25 93.5 23-0433-25-00 INSURANCE 15,288.72 65,081.74 89,813.00 24,731.26 72.5 23-0433-26-00 HSA CONTRIBUTION 900.00 4,100.00 16,500.00 12,400.00 24.9 23-0433-27-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 TOTAL PERSONNEL 224,849.25 765,423.94 891,998.00 126,574.06 85.8 SHOP 23-0440-00-00 SHOP LEASE 3,947.08 23,264.91 23,000.00 ( 264.91)101.2 23-0440-01-00 BLDG MAINTENANCE & REPAIR 40.21 40.21 .00 ( 40.21).0 23-0440-02-00 UTILTIES 341.52 2,860.56 3,500.00 639.44 81.7 23-0440-03-00 CUSTODIAL SERVICES .00 116.35 .00 ( 116.35).0 TOTAL SHOP 4,328.81 26,282.03 26,500.00 217.97 99.2 STREET LIGHTS 23-0441-01-00 MAINTENANCE & REPAIR 6,376.50 7,022.87 8,000.00 977.13 87.8 23-0441-02-00 UTILITIES 7,539.80 25,650.13 50,000.00 24,349.87 51.3 TOTAL STREET LIGHTS 13,916.30 32,673.00 58,000.00 25,327.00 56.3 CITY HALL CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 50 23-0442-01-00 BLDG MAINTENANCE & REPAIR 542.24 1,049.24 2,500.00 1,450.76 42.0 23-0442-02-00 MTNC & REPAIR GROUNDS .00 801.00 1,500.00 699.00 53.4 23-0442-03-00 CUSTODIAL SERVICES 95.53 312.85 .00 ( 312.85).0 23-0442-04-00 UTILITIES 8,543.98 26,470.89 36,000.00 9,529.11 73.5 TOTAL CITY HALL 9,181.75 28,633.98 40,000.00 11,366.02 71.6 SENIOR CENTER 23-0443-01-00 BLDG MAINTENANCE & REPAIR 126.80 2,199.52 2,500.00 300.48 88.0 23-0443-02-00 MTNC & REPAIR GROUNDS .00 395.40 1,500.00 1,104.60 26.4 23-0443-03-00 CUSTODIAL SERVICES .00 217.32 .00 ( 217.32).0 TOTAL SENIOR CENTER 126.80 2,812.24 4,000.00 1,187.76 70.3 LIBRARY 23-0444-01-00 BLDG MAINTENANE & REPAIR 431.30 3,383.30 5,000.00 1,616.70 67.7 23-0444-02-00 MTNC & REPAIR GROUNDS .00 .00 2,000.00 2,000.00 .0 TOTAL LIBRARY 431.30 3,383.30 7,000.00 3,616.70 48.3 MUSEUM 23-0445-01-00 BLDG MAINTENANCE & REPAIR .00 96.16 .00 ( 96.16).0 TOTAL MUSEUM .00 96.16 .00 ( 96.16).0 ARBORETUM PARK 23-0446-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0446-02-00 EQUIPMENT MTNC & REPAIRS .00 .00 500.00 500.00 .0 23-0446-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0446-04-00 UTILITIES .00 72.65 500.00 427.35 14.5 TOTAL ARBORETUM PARK .00 72.65 2,000.00 1,927.35 3.6 FLAG PLAZA 23-0447-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-03-00 GROUNDS - MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-04-00 UTILTIES 39.04 75.16 225.00 149.84 33.4 TOTAL FLAG PLAZA 39.04 75.16 1,725.00 1,649.84 4.4 FRIENDSHIP PARK 23-0448-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 51 23-0448-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0448-03-00 GROUNDS MTNC & REPAIR .00 .00 2,500.00 2,500.00 .0 23-0448-04-00 UTILITIES 774.81 2,148.33 2,600.00 451.67 82.6 TOTAL FRIENDSHIP PARK 774.81 2,148.33 6,100.00 3,951.67 35.2 GUERBER PARK 23-0449-01-00 BLDGS/STRUCTURES MTNC & REPAIR 163.94 1,783.94 2,500.00 716.06 71.4 23-0449-02-00 EQUIPMENT MTNC & REPAIR 1,148.58 1,148.58 1,500.00 351.42 76.6 23-0449-03-00 GROUNDS MTNC & REPAIR .00 126.29 5,000.00 4,873.71 2.5 23-0449-04-00 UTILITIES 4,637.71 11,325.67 21,000.00 9,674.33 53.9 TOTAL GUERBER PARK 5,950.23 14,384.48 30,000.00 15,615.52 48.0 HERITAGE PARK 23-0450-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 366.74 2,000.00 1,633.26 18.3 23-0450-02-00 EQUIPMENT MTNC & REPAIR 319.20 319.20 1,500.00 1,180.80 21.3 23-0450-03-00 GROUNDS MTNC & REPAIR 49.90 363.09 500.00 136.91 72.6 23-0450-04-00 UTILTIES 1,337.07 3,003.62 2,600.00 ( 403.62)115.5 TOTAL HERITAGE PARK 1,706.17 4,052.65 6,600.00 2,547.35 61.4 MCDONALDS PARK/PATHWAY 23-0451-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-03-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 TOTAL MCDONALDS PARK/PATHWAY .00 .00 2,000.00 2,000.00 .0 MERRILL PARK 23-0452-01-00 BLDG/STRUCTURES MTNC & REPAIR 98.43 1,718.43 2,500.00 781.57 68.7 23-0452-02-00 EQUIPMENT MTNC & REPAIR 1,365.60 1,500.00 1,500.00 .00 100.0 23-0452-03-00 GROUNDS MTNC & REPAIR .00 246.23 5,000.00 4,753.77 4.9 23-0452-04-00 UTILITIES 3,936.70 10,601.91 8,000.00 ( 2,601.91)132.5 TOTAL MERRILL PARK 5,400.73 14,066.57 17,000.00 2,933.43 82.7 ORVAL KRASEN PARK 23-0453-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 315.00 500.00 185.00 63.0 23-0453-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-03-00 GROUNDS MTNC & REPAIR .00 2.54 500.00 497.46 .5 23-0453-04-00 UTILITIES 455.44 1,518.22 1,600.00 81.78 94.9 TOTAL ORVAL KRASEN PARK 455.44 1,835.76 3,100.00 1,264.24 59.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 52 SPORTS COMPLEX 23-0454-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 3,433.44 2,500.00 ( 933.44)137.3 23-0454-02-00 EQUIPMENT MTNC & REPAIR 610.00 610.00 1,000.00 390.00 61.0 23-0454-03-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 23-0454-04-00 UTILITIES 10,391.66 24,237.59 15,500.00 ( 8,737.59)156.4 TOTAL SPORTS COMPLEX 11,001.66 28,281.03 20,000.00 ( 8,281.03)141.4 TOWN ENTRANCE SIGNS 23-0455-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-04-00 UTILITIES 3,221.90 7,123.16 21,500.00 14,376.84 33.1 TOTAL TOWN ENTRANCE SIGNS 3,221.90 7,123.16 23,000.00 15,876.84 31.0 PLAZA DRIVE 23-0456-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0456-03-00 GROUNDS MTNC & REPAIR .00 103.50 500.00 396.50 20.7 23-0456-04-00 UTILITIES 231.75 655.46 1,000.00 344.54 65.6 TOTAL PLAZA DRIVE 231.75 758.96 2,000.00 1,241.04 38.0 WEST PARK 23-0458-02-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 TOTAL WEST PARK .00 .00 1,000.00 1,000.00 .0 PAMELA BAKER PARK 23-0459-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0459-02-00 GROUNDS MTNC & REPAIR 1,400.00 1,400.00 500.00 ( 900.00)280.0 23-0459-03-00 EQUIPMENT MTNC/REPAIR .00 .00 500.00 500.00 .0 23-0459-04-00 UTILITIES 1,251.80 3,553.30 2,000.00 ( 1,553.30)177.7 TOTAL PAMELA BAKER PARK 2,651.80 4,953.30 3,500.00 ( 1,453.30)141.5 CAPITAL EQUIPMENT 23-0460-00-00 TOOLS 2,154.59 3,249.90 11,000.00 7,750.10 29.5 23-0460-01-00 EQUIPMENT 3,814.05 90,642.00 83,000.00 ( 7,642.00)109.2 TOTAL CAPITAL EQUIPMENT 5,968.64 93,891.90 94,000.00 108.10 99.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 53 CITY LANDSCAPE MAINTENANCE 23-0462-00-00 EQUIPMENT RENTAL 101.74 3,852.26 5,000.00 1,147.74 77.1 23-0462-01-00 SPRAYING/FERTILIZING 10,511.00 25,092.00 48,000.00 22,908.00 52.3 23-0462-02-00 SAFETY EQUIPMENT .00 .00 1,000.00 1,000.00 .0 23-0462-03-00 DUMPING-DISPOSAL 353.65 647.20 5,000.00 4,352.80 12.9 TOTAL CITY LANDSCAPE MAINTENANCE 10,966.39 29,591.46 59,000.00 29,408.54 50.2 LINDER ROAD RESTROOM 23-0463-01-00 BLDG/STRUCTURES MTNC REPAIR .00 700.00 500.00 ( 200.00)140.0 23-0463-02-00 EQUIPMENT MTNC-REPAIR .00 161.31 500.00 338.69 32.3 23-0463-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0463-04-00 UTILITIES 474.22 3,353.06 2,500.00 ( 853.06)134.1 TOTAL LINDER ROAD RESTROOM 474.22 4,214.37 4,000.00 ( 214.37)105.4 TRAILS 23-0464-00-00 GROUNDS MTNC/REPAIR 1,570.12 5,000.00 5,000.00 .00 100.0 23-0464-01-00 EQUIPMENT RENTAL 4,000.00 4,000.00 4,000.00 .00 100.0 TOTAL TRAILS 5,570.12 9,000.00 9,000.00 .00 100.0 FISCAL YEAR CAPITAL PROJECTS 23-0480-06-00 BASELINE FLOW CONTROLS .00 3,219.69 7,500.00 4,280.31 42.9 23-0480-15-00 LANDSCAPE UPGRADES - PARKS .00 2,184.00 25,000.00 22,816.00 8.7 23-0480-21-00 SECURITY CODE SYSTEM CH .00 .00 5,000.00 5,000.00 .0 23-0480-22-00 GUERBER PARK PAINTING .00 14,125.00 30,000.00 15,875.00 47.1 23-0480-23-00 GUERBER PARK LED LIGHTS .00 1,521.87 2,000.00 478.13 76.1 23-0480-24-00 GUERBER PARK, TRAIL FENCING .00 7,367.06 7,500.00 132.94 98.2 23-0480-25-00 TRAILS BENCH INSTALL 2,402.37 9,515.20 7,000.00 ( 2,515.20)135.9 23-0480-26-00 PICNIC TABLE BENCH INSTALL .00 3,351.68 8,000.00 4,648.32 41.9 23-0480-27-00 TRASH CANS, BIKE REP, BENCH .00 2,722.78 2,500.00 ( 222.78)108.9 23-0480-28-00 FLAG POLE INSTALL .00 2,924.32 5,000.00 2,075.68 58.5 23-0480-29-00 FLAG POLE INSTALL .00 3,650.00 5,000.00 1,350.00 73.0 23-0480-30-00 CITY SIGNAGE - UPDATE .00 .00 75,000.00 75,000.00 .0 TOTAL FISCAL YEAR CAPITAL PROJECTS 2,402.37 50,581.60 179,500.00 128,918.40 28.2 TOTAL FUND EXPENDITURES 665,967.05 1,741,331.19 2,571,574.00 830,242.81 67.7 NET REVENUE OVER EXPENDITURES ( 645,410.73)365,335.27 .00 ( 365,335.27).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 54 ASSETS 24-0101-00-00 CASH ( 23,706.58) TOTAL ASSETS ( 23,706.58) LIABILITIES AND EQUITY LIABILITIES 24-0217-00-00 FUND BALANCE 25,313.33 TOTAL LIABILITIES 25,313.33 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 49,019.91) BALANCE - CURRENT DATE ( 49,019.91) TOTAL FUND EQUITY ( 49,019.91) TOTAL LIABILITIES AND EQUITY ( 23,706.58) CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 55 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND .00 37,277.00 37,277.00 .00 100.0 24-0303-00-00 SPONSORSHIPS .00 .00 21,000.00 21,000.00 .0 24-0303-01-00 CAR SHOW 745.29 2,376.00 3,300.00 924.00 72.0 24-0303-02-00 CORNHOLE .00 .00 1,250.00 1,250.00 .0 24-0303-03-00 FUN RUN 109.00 109.00 1,500.00 1,391.00 7.3 24-0303-04-00 VENDORS .00 495.00 4,550.00 4,055.00 10.9 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED 10,153.80 12,268.80 .00 ( 12,268.80).0 24-0390-00-00 CARRY OVER .00 .00 20,000.00 20,000.00 .0 TOTAL FUND REVENUE 11,008.09 52,525.80 88,877.00 36,351.20 59.1 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 PARADE CONTRACTOR 5,000.00 10,000.00 10,000.00 .00 100.0 24-0401-03-00 FIREWORKS 15,776.50 26,684.28 25,000.00 ( 1,684.28)106.7 24-0401-04-00 ADVERTISEMENT 3,604.22 4,354.22 10,100.00 5,745.78 43.1 24-0401-05-00 MUSIC & ENTERTAINMENT 8,925.00 8,925.00 7,000.00 ( 1,925.00)127.5 24-0401-06-00 SUPPLIES 2,332.02 2,332.02 .00 ( 2,332.02).0 TOTAL ADMIN EXPENDITURES 35,637.74 52,295.52 52,100.00 ( 195.52)100.4 LOGISTICS 24-0410-00-00 PORTA POTTIES 4,523.61 4,523.61 1,500.00 ( 3,023.61)301.6 24-0410-01-00 SUPPLIES 1,920.25 5,358.98 2,500.00 ( 2,858.98)214.4 24-0410-02-00 TRAFFIC BARRIERS & CONTROL 9,078.00 9,078.00 8,000.00 ( 1,078.00)113.5 24-0410-03-00 GOLF CART RENTALS .00 .00 500.00 500.00 .0 24-0410-04-00 POLICE OVERTIME .00 .00 5,000.00 5,000.00 .0 24-0410-05-00 STREET CLOSURES 350.00 350.00 4,000.00 3,650.00 8.8 24-0410-06-00 SIGNAGE .00 .00 2,500.00 2,500.00 .0 24-0410-07-00 SECURITY 3,900.50 3,900.50 4,000.00 99.50 97.5 24-0410-09-00 EQUIPMENT 2,346.77 2,346.77 1,500.00 ( 846.77)156.5 TOTAL LOGISTICS 22,119.13 25,557.86 29,500.00 3,942.14 86.6 FUN RUN 24-0420-01-00 PROMOTIONS 103.03 103.03 1,200.00 1,096.97 8.6 24-0420-02-00 BIBS 2,792.50 2,792.50 300.00 ( 2,492.50)930.8 24-0420-03-00 BREAKFAST 89.41 89.41 300.00 210.59 29.8 24-0420-04-00 ADVERTISING .00 .00 200.00 200.00 .0 24-0420-05-00 MISCELLANEOUS 531.52 531.52 400.00 ( 131.52)132.9 TOTAL FUN RUN 3,516.46 3,516.46 2,400.00 ( 1,116.46)146.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 56 CAR SHOW 24-0430-00-00 MARKETING/ADVERTISING 284.29 344.29 60.00 ( 284.29)573.8 24-0430-01-00 DASH PLAQUES 2,492.50 2,492.50 250.00 ( 2,242.50)997.0 24-0430-02-00 TROPHIES .00 .00 2,300.00 2,300.00 .0 24-0430-03-00 SUPPLIES 903.98 903.98 300.00 ( 603.98)301.3 24-0430-04-00 PARKING 511.00 511.00 317.00 ( 194.00)161.2 24-0430-05-00 MISCELLANEOUS ( 13.62)( 13.62)150.00 163.62 ( 9.1) 24-0430-06-00 RAFFLE .00 .00 400.00 400.00 .0 24-0430-08-00 COMMUNITY GROUP .00 .00 400.00 400.00 .0 TOTAL CAR SHOW 4,178.15 4,238.15 4,177.00 ( 61.15)101.5 CORNHOLE 24-0440-00-00 BUILDING/PAINT SUPPLIES 1,357.94 1,357.94 200.00 ( 1,157.94)679.0 24-0440-01-00 ARTIST .00 477.25 300.00 ( 177.25)159.1 24-0440-02-00 BEAN BAGS 383.20 383.20 200.00 ( 183.20)191.6 24-0440-03-00 ADVERTISING 727.00 727.00 .00 ( 727.00).0 TOTAL CORNHOLE 2,468.14 2,945.39 700.00 ( 2,245.39)420.8 ROCKY MOUNTAIN OYSTER FEED 24-0445-01-00 COMMUNITY BENEFICIARY 4,096.00 4,096.00 .00 ( 4,096.00).0 24-0445-03-00 FOOD AND BEVERAGE 8,896.33 8,896.33 .00 ( 8,896.33).0 TOTAL ROCKY MOUNTAIN OYSTER FEED 12,992.33 12,992.33 .00 ( 12,992.33).0 TOTAL FUND EXPENDITURES 80,911.95 101,545.71 88,877.00 ( 12,668.71)114.3 NET REVENUE OVER EXPENDITURES ( 69,903.86)( 49,019.91).00 49,019.91 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 57 ASSETS 25-0101-00-00 CASH 102,694.44 25-0151-25-00 FIRST INTERSTATE INVESTMENT 664,824.15 TOTAL ASSETS 767,518.59 LIABILITIES AND EQUITY LIABILITIES 25-0202-00-00 VOUCHERS PAYABLE 3,591.50 TOTAL LIABILITIES 3,591.50 FUND EQUITY 25-0271-00-00 FUND BALANCE 683,540.13 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 80,386.96 BALANCE - CURRENT DATE 80,386.96 TOTAL FUND EQUITY 763,927.09 TOTAL LIABILITIES AND EQUITY 767,518.59 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 58 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 34,702.50 190,037.50 165,250.00 ( 24,787.50)115.0 25-0325-00-00 IDPR GRANT .00 .00 100,000.00 100,000.00 .0 25-0371-25-00 BANK INTEREST 301.53 1,147.46 800.00 ( 347.46)143.4 25-0379-00-00 MISC REVENUE .00 2,423.00 .00 ( 2,423.00).0 25-0390-00-00 CARRY OVER .00 .00 403,514.00 403,514.00 .0 TOTAL FUND REVENUE 35,004.03 193,607.96 669,564.00 475,956.04 28.9 EXPENDITURES GRANTS 25-0415-00-00 IDPR GRANT .00 .00 65,120.00 65,120.00 .0 TOTAL GRANTS .00 .00 65,120.00 65,120.00 .0 CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS 3,591.50 102,600.50 504,444.00 401,843.50 20.3 25-0438-01-00 EAGLE ISLAND ST PK CONNECTION 483.00 10,620.50 100,000.00 89,379.50 10.6 TOTAL CAPITAL IMPROVEMENTS 4,074.50 113,221.00 604,444.00 491,223.00 18.7 TOTAL FUND EXPENDITURES 4,074.50 113,221.00 669,564.00 556,343.00 16.9 NET REVENUE OVER EXPENDITURES 30,929.53 80,386.96 .00 ( 80,386.96).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 59 LIABILITIES AND EQUITY LIABILITIES 26-0202-00-00 VOUCHERS PAYABLE 277.00 26-0217-03-00 FICA 371.85 26-0217-04-00 PUBLIC RETIREMENT 583.73 26-0217-07-00 HEALTH INSURANCE ( 84.85) 26-0217-09-00 WORKERS' COMPENSATION 599.92 TOTAL LIABILITIES 1,747.65 FUND EQUITY 26-0271-00-00 FUND BALANCE ( 300.28) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,447.37) BALANCE - CURRENT DATE ( 1,447.37) TOTAL FUND EQUITY ( 1,747.65) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 60 REVENUE 26-0301-00-00 MONTHLY TRANSFER TO DEPTS 44,079.04 150,865.66 218,879.00 68,013.34 68.9 TOTAL FUND REVENUE 44,079.04 150,865.66 218,879.00 68,013.34 68.9 EXPENDITURES ADMINISTRATION 26-0413-05-00 OFFICE SUPPLIES .00 249.85 500.00 250.15 50.0 26-0413-06-00 DUPLICATION/PUBLISHING/PRINTIN .10 97.46 1,500.00 1,402.54 6.5 26-0413-12-00 TRAINING 250.00 1,485.00 6,895.00 5,410.00 21.5 26-0413-13-00 TRAVEL & PER DIEM .00 .00 6,400.00 6,400.00 .0 26-0413-14-00 PROFESSIONAL DUES 455.00 2,254.88 2,890.00 635.12 78.0 26-0413-19-00 COMMUNICATIONS 2,561.66 13,691.10 10,400.00 ( 3,291.10)131.7 26-0413-29-00 UNIFORMS .00 .00 200.00 200.00 .0 TOTAL ADMINISTRATION 3,266.76 17,778.29 28,785.00 11,006.71 61.8 PERSONNEL 26-0415-10-00 SALARIES- FULL TIME 34,222.02 102,765.18 134,639.00 31,873.82 76.3 26-0415-21-00 FICA 2,976.95 8,181.75 10,529.00 2,347.25 77.7 26-0415-22-00 PERSI 4,669.84 12,853.86 16,303.00 3,449.14 78.8 26-0415-23-00 HRA BUY-DOWN .00 .00 1,540.00 1,540.00 .0 26-0415-24-00 WORKERS' COMPENSATION 74.32 208.76 2,417.00 2,208.24 8.6 26-0415-25-00 INSURANCE 3,388.05 10,525.19 21,666.00 11,140.81 48.6 26-0415-27-00 PTO CASH OUT .00 .00 3,000.00 3,000.00 .0 TOTAL PERSONNEL 45,331.18 134,534.74 190,094.00 55,559.26 70.8 TOTAL FUND EXPENDITURES 48,597.94 152,313.03 218,879.00 66,565.97 69.6 NET REVENUE OVER EXPENDITURES ( 4,518.90)( 1,447.37).00 1,447.37 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 61 ASSETS 27-0101-00-00 CASH 8,614.24 27-0151-25-00 FIRST INTERSTATE INVESTMENTS 33,915.25 TOTAL ASSETS 42,529.49 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 42,529.49 BALANCE - CURRENT DATE 42,529.49 TOTAL FUND EQUITY 42,529.49 TOTAL LIABILITIES AND EQUITY 42,529.49 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 62 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 12,832.24 42,528.28 55,500.00 12,971.72 76.6 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 57,664.00 57,664.00 .0 27-0371-25-00 BANK INTEREST .73 1.21 100.00 98.79 1.2 TOTAL FUND REVENUE 12,832.97 42,529.49 113,264.00 70,734.51 37.6 EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT .00 .00 56,632.00 56,632.00 .0 27-0438-01-00 CITY FACILITY .00 .00 56,632.00 56,632.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 113,264.00 113,264.00 .0 TOTAL FUND EXPENDITURES .00 .00 113,264.00 113,264.00 .0 NET REVENUE OVER EXPENDITURES 12,832.97 42,529.49 .00 ( 42,529.49).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 CITY HALL BOND FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 63 ASSETS 54-0101-00-00 CASH 3,405.22 TOTAL ASSETS 3,405.22 LIABILITIES AND EQUITY FUND EQUITY 54-0271-00-00 FUND BALANCE 3,404.45 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD .77 BALANCE - CURRENT DATE .77 TOTAL FUND EQUITY 3,405.22 TOTAL LIABILITIES AND EQUITY 3,405.22 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 64 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND .00 101,700.00 101,700.00 .00 100.0 TOTAL FUND REVENUE .00 101,700.00 101,700.00 .00 100.0 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT 75,000.00 75,000.00 75,000.00 .00 100.0 54-0480-82-00 INTEREST BOND PAYMENT 13,124.91 26,249.23 26,250.00 .77 100.0 54-0480-84-00 PAYING AGENT FEE .00 450.00 450.00 .00 100.0 TOTAL BOND PAYMENTS 88,124.91 101,699.23 101,700.00 .77 100.0 TOTAL FUND EXPENDITURES 88,124.91 101,699.23 101,700.00 .77 100.0 NET REVENUE OVER EXPENDITURES ( 88,124.91).77 .00 ( .77).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2021 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 65 ASSETS 60-0101-00-00 CASH 945,182.58 60-0115-00-00 WATER/ACCOUNTS RECEIVABLE 137,419.91 60-0151-01-00 DEQ LOAN INV (COLL/PMTS)674,883.46 60-0151-02-00 DEQ RESERVE FUND INV 182,000.00 60-0151-25-00 FIRST INTERSTATE INVESTMENT 2,634,292.52 60-0161-00-00 WATER/LAND 93,250.00 60-0162-00-00 WATER/BUILDINGS & STRUCTURES 559,285.00 60-0163-00-00 WATER/ACCUMULATED DEP.-BLDGS.&( 161,266.00) 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 10,361,461.00 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS ( 3,104,612.00) 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 1,294,524.00 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP ( 816,504.00) 60-0170-00-00 HRA 10% DEPOSIT 550.08 60-0171-00-00 DEFERRED OUTFLOWS-PENSION 57,594.00 TOTAL ASSETS 12,858,060.55 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE 45,606.62 60-0204-00-00 WATER/LEXINGTON - TVV 1,787.89 60-0215-00-00 INTEREST PAYABLE 19,418.00 60-0216-00-00 ACCRUED PAYROLL 6,081.88 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 21,059.36 60-0217-03-00 FICA 1,542.82 60-0217-04-00 PUBLIC RETIREMENT 2,618.32 60-0217-07-00 WATER DEPT HEALTH INSURANCE 9,534.59 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 53,056.11 60-0217-10-00 HSA CONTRIBUTION ( 100.00) 60-0217-11-00 NET PENSION LIABILITY 227,012.00 60-0217-12-00 DEFERRED INFLOWS-PENSION 7,412.00 60-0220-00-00 WATER/SERVICE DEPOSITS 92,400.00 60-0231-00-00 DEQ LOAN 1,433,947.00 TOTAL LIABILITIES 1,922,539.09 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 9,765,485.67 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,170,035.79 BALANCE - CURRENT DATE 1,170,035.79 TOTAL FUND EQUITY 10,935,521.46 TOTAL LIABILITIES AND EQUITY 12,858,060.55 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:27AM PAGE: 66 REVENUE 60-0346-57-00 RESERVE, REPAIR/ MAINTENANCE .00 .00 125,000.00 125,000.00 .0 60-0346-58-00 RESERVE, EQUIP/BLDG REPLCMNT .00 .00 200,000.00 200,000.00 .0 60-0346-59-00 STL-SUPPLY TRUNK LINE FEE 7,465.50 359,659.67 105,000.00 ( 254,659.67)342.5 60-0346-59-01 STL-CARRY FORWARD, PREVIOUS FY .00 .00 498,000.00 498,000.00 .0 60-0346-60-00 HOOK UP FEES CITY 101,871.70 386,270.50 151,500.00 ( 234,770.50)255.0 60-0346-65-00 RESERVE, EMERGENCY REPL ITEMS .00 .00 125,000.00 125,000.00 .0 60-0346-66-00 RESERVE, VEHICLE REPLACEMENT .00 .00 48,000.00 48,000.00 .0 60-0346-67-00 RESERVE, FOR BUDGET .00 .00 260,000.00 260,000.00 .0 60-0347-01-00 BILLING REVENUE 318,381.87 1,144,594.51 876,078.00 ( 268,516.51)130.7 60-0347-02-00 OTHER REVENUE 2,510.00 8,120.02 6,240.00 ( 1,880.02)130.1 60-0347-03-00 RECONNECT FEES 100.00 275.00 600.00 325.00 45.8 60-0347-04-00 DELINQUENT FEES 2,490.00 9,263.00 11,040.00 1,777.00 83.9 60-0347-05-00 MISCELLANEOUS REVENUE 10,509.05 19,725.57 7,500.00 ( 12,225.57)263.0 60-0347-06-00 SYSTEM ENHANCEMENT FEE 106,528.38 409,088.96 360,000.00 ( 49,088.96)113.6 60-0355-01-00 WCE-WATER CONST EQUIV FEE ( 646.60)57,196.00 20,000.00 ( 37,196.00)286.0 60-0371-25-00 BANK INTEREST 1,583.47 6,122.06 6,000.00 ( 122.06)102.0 60-0390-00-00 WATER FUND CARRY OVER .00 .00 368,478.00 368,478.00 .0 TOTAL FUND REVENUE 550,793.37 2,400,315.29 3,168,436.00 768,120.71 75.8 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 FUEL & LUBRICANTS 3,014.64 8,144.37 15,000.00 6,855.63 54.3 60-0420-03-00 VEHICLE MTNC & REPAIR 1,135.63 3,572.83 9,000.00 5,427.17 39.7 60-0420-04-00 VEHICLE DETAILING .00 .00 1,650.00 1,650.00 .0 TOTAL VEHICLE OPERATIONS - LEASES 4,150.27 11,717.20 25,650.00 13,932.80 45.7 PERSONNEL 60-0433-10-00 SALARIES-FULL TIME 94,230.05 313,844.67 335,391.00 21,546.33 93.6 60-0433-10-02 ON-CALL TIME 1,064.49 4,029.49 7,500.00 3,470.51 53.7 60-0433-11-00 OVERTIME 294.48 1,178.21 4,500.00 3,321.79 26.2 60-0433-21-00 FICA 8,139.93 24,955.21 27,264.00 2,308.79 91.5 60-0433-22-00 PERSI 12,945.87 39,627.37 42,553.00 2,925.63 93.1 60-0433-23-00 HRA BUY-DOWN 1,540.00 1,701.70 7,700.00 5,998.30 22.1 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 800.00 800.00 .0 60-0433-24-00 WORKERS' COMPENSATION 2,807.69 13,790.74 13,419.00 ( 371.74)102.8 60-0433-25-00 INSURANCE 12,636.85 42,204.29 56,400.00 14,195.71 74.8 60-0433-26-00 HSA CONTRIBUTIONS 600.00 1,500.00 .00 ( 1,500.00).0 60-0433-29-00 PTO CASH OUT .00 .00 9,000.00 9,000.00 .0 TOTAL PERSONNEL 134,259.36 442,831.68 504,527.00 61,695.32 87.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:28AM PAGE: 67 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 617.80 946.67 1,500.00 553.33 63.1 60-0434-19-00 TELECOMMUNICATIONS/SCADA 2,429.95 8,766.53 9,836.00 1,069.47 89.1 60-0434-20-00 ADVERTISING - PUBLICATIONS 33.87 33.87 2,000.00 1,966.13 1.7 60-0434-22-00 TRAVEL-MTNGS-EDUCATION .00 1,435.00 8,000.00 6,565.00 17.9 60-0434-23-00 DUES & SUBSCRIPTIONS 711.00 1,364.00 2,900.00 1,536.00 47.0 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 1,500.00 7,800.00 6,300.00 19.2 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPS 1,620.19 5,249.79 8,000.00 2,750.21 65.6 60-0434-27-00 POSTAGE 29.57 29.57 1,300.00 1,270.43 2.3 60-0434-41-00 LIABILITY INSURANCE .00 4,200.00 4,200.00 .00 100.0 60-0434-42-00 ENGINEERING SERVICES 14,176.02 20,428.51 25,000.00 4,571.49 81.7 60-0434-42-01 LEGAL SERVICES 1,575.00 1,785.00 25,000.00 23,215.00 7.1 60-0434-42-02 MISC LEGAL AND ENG SERVICES 3,681.08 10,461.12 145,920.00 135,458.88 7.2 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 25,000.00 25,000.00 .0 60-0434-44-00 DIG LINE 655.20 3,829.28 4,500.00 670.72 85.1 60-0434-45-00 CITY AUDITOR SERVICES .00 2,500.00 2,500.00 .00 100.0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 5,703.23 20,809.36 27,000.00 6,190.64 77.1 60-0434-50-00 SHOP LEASE 1,800.00 10,763.33 12,600.00 1,836.67 85.4 60-0434-50-01 SHOP UTILITIES 112.90 1,143.07 4,500.00 3,356.93 25.4 60-0434-53-01 PUBLIC WATER DRINKING FEES .00 11,220.00 12,000.00 780.00 93.5 60-0434-53-03 PERMITS AND FEES .00 .00 1,500.00 1,500.00 .0 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 342.62 6,076.14 40,000.00 33,923.86 15.2 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 2,281.07 32,893.39 40,000.00 7,106.61 82.2 60-0434-59-00 CHEMICALS 5,349.02 7,522.72 9,000.00 1,477.28 83.6 60-0434-60-00 POWER 11,448.92 41,820.47 55,000.00 13,179.53 76.0 60-0434-68-00 UNIFORMS 300.00 1,342.31 2,000.00 657.69 67.1 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 52,867.44 196,120.13 502,056.00 305,935.87 39.1 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 1,946.00 8,888.00 11,000.00 2,112.00 80.8 TOTAL TESTING-WK-MO-QTR-ANNUAL 1,946.00 8,888.00 11,000.00 2,112.00 80.8 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT .00 360,000.00 360,000.00 .00 100.0 TOTAL DEQ REVOLVING LOAN PAYMENT .00 360,000.00 360,000.00 .00 100.0 RESTRICTED FUNDS 60-0437-01-00 WATER SYS EXPANSION-STL FEES .00 .00 60,000.00 60,000.00 .0 60-0437-03-00 REFUND OF STL FEES .00 .00 108,800.00 108,800.00 .0 TOTAL RESTRICTED FUNDS .00 .00 168,800.00 168,800.00 .0 CAPITAL EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/27/2021 10:28AM PAGE: 68 60-0438-01-00 EQUIPMENT 199.00 6,480.60 14,900.00 8,419.40 43.5 60-0438-02-00 RESERVE, WATER SYSTEM R&M .00 .00 150,000.00 150,000.00 .0 60-0438-03-00 RESERVE--EQUIP, BLDG REPLCMNT .00 .00 225,000.00 225,000.00 .0 60-0438-05-01 CURRENT STL PROJECTS .00 18,763.21 434,200.00 415,436.79 4.3 60-0438-05-02 HORSESHOE BND1-GREENBROOK 4,159.74 4,159.74 .00 ( 4,159.74).0 60-0438-06-00 RESERVE FOR BUDGET .00 .00 310,000.00 310,000.00 .0 60-0438-08-00 CAPITAL METER SETS (NEW CUST)20,593.16 93,598.74 85,000.00 ( 8,598.74)110.1 60-0438-10-00 WATER MASTER PLAN-UPDATE 20,720.00 28,720.00 40,000.00 11,280.00 71.8 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 26,918.00 46,197.20 114,500.00 68,302.80 40.4 60-0438-18-00 RESERVE, EMERGENCY REPL ITEMS .00 .00 150,000.00 150,000.00 .0 60-0438-20-00 RESERVE, VEHICLE REPLACEMENT .00 .00 60,000.00 60,000.00 .0 60-0438-82-00 ROOM AND BOARD AT CITY HALL 3,201.00 12,803.00 12,803.00 .00 100.0 TOTAL CAPITAL EXPENDITURES 75,790.90 210,722.49 1,596,403.00 1,385,680.51 13.2 TOTAL FUND EXPENDITURES 269,013.97 1,230,279.50 3,168,436.00 1,938,156.50 38.8 NET REVENUE OVER EXPENDITURES 281,779.40 1,170,035.79 .00 ( 1,170,035.79).0