Management Report TOWN OF SCOTTSVILLE For the period ended July 31, 2024 Prepared on October 15, 2024 For management use only Table of Contents Profit and Loss. Balance Sheet.. 2/8 Profit and Loss July 2024 INCOME General Fund Total Received from County Gov. 10-4300 Flood Controi Contribution Total Received. from County Gov. Received from State 104215Communcations Tax Sales Tax 10-4220 Fluvanna County Total Sales Tax Total Received: from State Received from the Town 10-4408 Business Licenses 10-4409 Fines 10-4416 Traffic Fines-Alb Co. Total 10-4409 Fines 10-4424 Meals Tax 10-4425 Cigarette Tax 10-4429 Rental Income 10-4422 American Tower Monthly 10-4423 Farmers' Market 10-4426 Victory Hall Theatre Total 10-4429 Rental. Income 10-4436 Rolling Stock Tax 10-4440 Transient Occupancy Tax 10-4449 Utility Consumers' Tax 10-4446 Gas Total 10-4449 Utility Consumers' Tax 10-4450 Utility Consumption Tax 10-4452 Electric 10-4454 Gas Total 10-4450 Utility Consumption Tax 10-4459 Miscellaneous 10-4455 Vendor Fees 10-4460 Fourth of July Total 10-4455 Vendor Fees Total 10-4459. Miscellaneous Tetal Received frem the Town Return on Investments TOWN OF SCOTTSVILLE 21,420.00 21,420.00 962.69 173.70 173.70 1,136.39 206.00 142.51 142.51 29,656.41 28,500.00 2,046.08 340.00 745.00 3,131.08 1,861.49 1,423.62 2,810.41 500.41 3,310.82 19.97 199.33 9.12 228.42 485.00 485.00 485.00 68,945.35 3/8 Total -782.30 -1,130.78 -1,913.08 89,588.66 -0.02 89,588.64 89,588.64 48.35 785.54 4.00 144.93 148.93 21.17 1,352.00 1,246.34 129.52 4,753.84 3,315.93 178.24 289.64 3,783.81 2,970.00 656.84 29.58 773.22 46.83 2,938.00 319.84 95.00 20,050.46 269.00 1,237.50 1,237.50 1,237.50 102.13 98.66 200.79 2,944.79 4/8 10-4600 Income Reinvest - LGIP Town 10-4601 Income Reinvest- LGIP Caldwell Total Return on. Investments Total General. Fund Unapplied Cash Payment Income Total Income GROSS PROFIT EXPENSES 10-5035 Administrative Vacation Administrative and Office 10-5005 Computer 10-5006 Bank Service Charges 10-5015 Payroll Direct Deposit Fees Total 10-5006 Bank Service Charges 10-5014 Internet Service 10-5017 Payroll Health Benefits 10-5018 Payroll Pension 10-5019 Payroll Life Insurance 10-5020 Payroll Town Administrator 10-5022 Payroll Town Clerk 10-5026 Administrative Holiday 10-5027 Administrative - Sick Total 10-5022 Payroll - Town Clerk 10-5025 Cigarette Tax Stamps 10-5038 Payroll Matching FICA 10-5040 Telephone 10-5042 Office Supplies 10-5044 Mailings 10-5046 Town Attorney Contract 10-5047 Office Equipment 10-5049 Accounting Services Total Administrative and Office Capital Improvements 10-5169 Police-Purchase Car Int Expense CBS Municipal Building 10-5133 Construc/Renovation (Exterior) Total Municipal Building Streets 10-5152 Signage Improvements 10-5165 Repair and Maintenance Total Streets Total Capital Improvements TOWN OF SCOTTSVILLE Total 26.05 26.05 34.42 412.00 166.36 612.78 412.00 34.42 1,395.09 235.31 2,000.00 2,000.00 77.44 4,154.26 315.64 88.00 128.92 34.38 163.30 1,521.15 462,59 603.03 1,065.62 3,153.71 169.19 169.19 342.76 511.95 14,276.92 2,028.00 990.77 113.90 385.42 5/8 DMV Select (deleted) 10-5904 Office Supplies (deleted) Total DMV Select (deleted) Farmers' Market 10-5202 Payroll Matching FICA 10-5210 Manager's Fees 10-5353 Elec.-Water Fleet St (Fmrs Mkt Tent) Total Farmers'. Market Flood Control 10-5304 Payroll - Flood Superintendent 10-5306 Payroll Matching FICA 10-5308 Pump Maintenance 10-5310 Electricity 10-5312 Levee/Dam Maint. 10-5311 Mowing of Levee & Dam Total 10-53121 Levee/Dam Maint. 10-5315 Telephone Total Flood Contral Municipal Building 10-5350 Elevator Maint & Phone 10-5351 Pest Control 10-5352 Utilities Elec, Gas, Water 10-5357 Electricity Upstairs 10-5360 Water/Sewer Total 10-5352 Utilities- Elec, Gas, Water 10-5354 Repairs and Maint 10-5356 Cleaning Service 10-5362 Supplies - Cleaning Total 10-5356 Clearing Serviice Total Municipal Building Parks and Trails 10-5515 Park Maintenance 10-5517 CBS Electricity Total 10-5515 Park. Maintenance 10-5635 CBS Exhibits - Design & Repair Total Parks and Trails Police Department 10-5406 Payroll Base Salary 10-5408 Payroll Health Benefits 10-5410 Payroll Matching FICA 10-5411 Payroll Life Insurance 10-5412 Payroll Pension TOWN OF SCOTTSVILLE Total 57.05 36.00 167.75 210.00 172.11 67.87 200.64 18,706.43 54.00 1,171.38 323.84 985.38 82.13 3,520.36 534.72 178.24 4,233.32 494.58 21.47 3,678.64 15.98 28.00 11,088.72 5,110.27 5,110.27 5,110.27 66,407.77 23,180.87 $23,180.87 10-5420 Vehicle Gas & Fluid 10-5426 Supplies and Equip 10-5428 Utilities - Elec, Gas, Water 10-5430 Telephone/DSL 10-5432 Office Expenses 10-5496 IT Maintenance 10-5550 Food Total Police Department Street Department 10-5444 2008 Chevrolet Colorado 10-5500 Maintenance 10-5502 Payroll Matching FICA 10-5503 Payroll Health Benefits 10-5505 Payroll Life Insurance 10-5506 Payroll Street Cleaning/Maint 10-5041 Maintenance Sick 10-5043 Maintenance Holiday Total 10-5506. Payrell- - Street CleaningMaint 10-5507 Payroll VRS 10-5510 Trash/Contract Labor 10-5512 Street Lighting 10-5514 Materials & Supplies 10-5529 Truck Repairs & Fuel Total Street Department Tourism and Econ Development 10-5526 Events & Tourism Committee 10-5602 4th of July Total 10-5526. Events & Tourism Committee Total Tourism and Econ Development Total Expenses NET OPERATING INCOME NET INCOME TOWN OF SCOTTSVILLE 6/8 Balance Sheet As ofJuly 31, 2024 ASSETS Current Assets Bank Accounts 10-1000 BB&T Checking Account 10-1001 CARES Fund 10-1003 E Summons 10-1200 Caldwell TOS 10-1202 Town of Scottsville LGIP 10-1203 Cash Clearing ADP Clearing Total Bank Accounts Accounts Receivable 10-1400. Accounts Receivable Total Accounts Receivable Other Current Assets 10-1499 Undeposited Funds Total Other Current Assets Total Current Assets Fixed Assets Total 110,274.29 1,001.00 1,448.42 244,891.26 169,419.59 38,544.88 -1,705.08 563,874.36 32,488.93 32,488.93 -215.50 -215.50 596,147.79 278,515.50 29,794.00 3,744,679.00 940,550.00 1,164,619.00 280,748.42 13,562.00 -4,833,186.82 1,619,281.10 31,690.58 25,883.67 5,806.91 $2,221,235.80 10-1500 Land and Land Improvements 10-1620 Plans and Topographical Maps 10-1630 Buildings and Improvements 10-1640 Levee and Improvements 10-1650 Roads and Sidewalks 10-1660 Police Equipment 10-1670 Office Furniture and Equipment 10-1700 Accumulated Depreciation Total Fixed Assets Other Assets 10-1800 Deferred Outflows 10-3051 Long Term Debt Contra Account Total Other Assets TOTALASSETS LIABILITIES AND EQUITY Liabilities Current Liabilities Credit Cards 10-2004 Town of Scottsville Visa Total Credit Cards 897.40 897.40 7/8 TOWN OF SCOTTSVILLE Total 900.00 702.72 -50,943.00 12,643.00 9,378.89 1,906.11 16,350.91 35,066.33 21,203.52 41,498.72 -11.83 4,789.61 5,687.01 27,756.00 27,756.00 33,443.01 -428.40 545,759.72 1,619,280.60 23,180.87 2,187,792.79 $2,221,235.80 Other Current Llabilities 10-2005 Security Deposit Receipts 10-2111 Aflac Insurance 10-2500 Net Pension Liability 10-2510 OPEB Payroil Liabilities 10-2010 Direct Deposit Liabilities 10-2012 VRS 10-2013 Vacation Liability 10-2014 Health Insurance ICMA-RC Total Payroll. Llabilities VAI Dept of Taxation sales tax Payable Total Other Current Liabilities Total Current. Liabilities Leng-Term. Ltabilities 10-2800 Deferred Inflows Totall Long-Term. Liabilities Total Liabililties Equity 10-3000 Opening Bal Equity 10-3010 Retained Earnings 10-3050 Invested in Capital Assets Net Income Totall Equity TOTAL LIABILITIES. ANDI EQUITY TOWN OF SCOTTSVILLE 8/8 TOWN OF SCOTTSVILLE Budget VS. Actuals: FY_ 2024-2025-FY25PAL July2 2024 JUL2 2024 0.00 0.00 0.00 0.00 0.00 5,833.33 -5,833.33 5,833.33 0.00 1,583.33 -1,583.33 133.33 0.00 1,100.00 -1,100.00 1,400.00 -1,400.00 0.00 962.69 1,050.00 1,250.00 -1,250.00 0.00 0.00 4,916.67 -4,916.67 173.70 0.00 173.70 4,916.67 -4,742.97 1,136.39 11,433.33 -10,296.94 416.67 1,416.67 -1,416.67 0.00 5,416.67 -5,416.67 206.00 7,750.00 -7,544.00 583.33 142.51 0.00 0.00 142.51 583.33 29,656.41 24,333.33 2,383.33 2,046.08 0.00 340.00 583.33 745.00 3,131.08 2,966.66 1,861.49 141.67 1,423.62 1,250.00 2,810.41 2,500.00 500.41 0.00 0.00 3,310.82 2,500.00 19.97 500.00 199.33 0.00 9.12 0.00 228.42 500.00 41.67 83.33 485.00 0.00 TOTAL ACTUAL BUDGET OVERBUDGET %OFE BUDGET ACTUAL BUDGET OVERBUDGET %OFBUDGET Income 10-4603 Relmbursement General Fund 10-4301 Donations 10-4406 Police Dept Donations Total 10-4301 Donations Recelved1 from County Gov. 10-4300 Flood Control Contribution 10-4315 Project Partnership Grants Total Receivedf from County Gov. Received from Federal Gov. 10-4107 VDOT Grant Reimbursement Total Recelved from Federal Gov. Receivedf from State 10-4111 DCJS- Pollce Equipment 10-4201 DEQL Litter Grant 10-4205' VAC Grant 10-4206 Region 10N Mental Health Relmbursement 10-4208 Law Enforce.. Assist 10-4209 DMV Select servicef fees 10-4215 Communications Tax 10-4230 Dept. ofF Firei Programs Grant 10-4234 VAH Housing Development. Auth 10-4235 Rental Dist. Sales Tax 10-4216/ Albemarle County 10-4220F Fluvanna County Total Sales' Tax Total Recelved! trom State Received fromt theT Town 10-4112E-911 Grant 10-4400 Vehicle Licensel Tax 10-4401 Farmers' Market 10-4404E Bank Franchise Tax 10-4408 Business Licenses 10-4409F Fines 10-44167 Traffic Fines- AlbO Co. 10-4420 Parking Tickets S'Ville Total 10-4409 Fines 10-44241 Meals" Tax 10-4425 Cigarette Tax 10-4429 Rental Income 10-4422 American Tower- Monthly 10-4423F Farmers' Market 10-4426V Victory! Hall7 Theatre Total 10-4429 Rentall Income 10-4436 Rolling Stock Tax 10-44407 Transient Occupancy Tax 10-4449 Ullity Consumers" Tax 10-4446 Gas 10-4448 Electric Total 10-4449 Ulilily Consumers" Tax 10-4450 Utility Consumption" Tax 10-4452 Electric 10-4454 Gas Total 10-4450 Utility Consumption" Tax 10-44582 Zoning Permits 10-4459 Miscellaneous 10-4455 Vendor Fees 10-4460 Fourth of July 0.00 0.00 0.00 0.00 0.00 5,833.33 0.00 -133.33 0.00 0.00 -87.31 0.00 0.00 173.70 -416.67 0.00 583.33 142.51 0.00 -440.82 2,383.33 2,046.08 243.33 745.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,833.33 $-5,833.33 $0.00 $5,833.33 $-5,833.33 $0.00 $0.00 $0.00 $1,583.33 $-1,583.33 $0.00 $133.33 $-133.33 $0.00 $0.00 $0.00 $1,100.00 $-1,100.00 $0.00 $1,400.00 $-1,400.00 $0.00 $0.00 91.68% $962.69 $1,050.00 $0.00 $1,250.00 $-1,250.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,916.67 $-4,916.67 $173.70 $0.00 3.53% $173.70 $4,916.67 $-4,742.97 9.94% $1,136.39 $11,433.33 $-10,296.94 $0.00 $0.00 $0.00 $416.67 $-416.67 $0.00 $1,416.67 $-1,416.67 $0.00 $0.00 $0.00 $5,416.67 $-5,416.67 2.66% $206.00 $7,750.00 $-7,544.00 $0.00 $583.33 $-583.33 $142.51 $0.00 $0.00 $0.00 24.43% $142.51 $583.33 $-440.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $-87.31 $0.00 $0.00 $0.00 $173.70 $0.00 $0.00 $142.51 $0.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 91.68% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 3.53% 9.94% 0.00% 0.00% 0.00% 0.00% 0.00% 2.66% 0.00% 0.00% 0.00% 24.43% 0.00% 0.00% 58.29% 0.00% 21,420.00 1,675.00 19,745.00 1,278.81% $21,420.00 $1,675.00 $19,745.00 1,278.81% 21,420.00 1,875.00 19,745.00 1,278.81% $21,420.00 $1,675.00 $19,745.00 1,278.81% 5,323.08 121.88% $29,656.41 $24,333.33 $5,323.08 121.88% 28,500.00 5,700.00 22,800.00 500.00% $28,500.00 $5,700.00 $22,800.00 500.00% $0.00 $2,383.33 $-2,383.33 $2,046.08 $0.00 $2,048.08 58.29% $340.00 $583.33 $-243.33 $745.00 $0.00 $745.00 $164.42 105.54% $173.62 113.89% $310.41 112.42% $500.41 $0.00 $810.82 132.43% $199.33 $9.12 $-41.67 $-83.33 $0.00 $485.00 164.42 105.54% $3,131.08 $2,966.66 173.62 113.89% $1,423.62 $1,250.00 310.41 112.42% $2,810.41 $2,500.00 810.82 132.43% $3,310.82 $2,500.00 1,719.82 1,313.96% $1,861.49 $141.67 $1,719.82 1,313.96% 500.41 0.00 -480.03 199.33 9.12 -271.58 -41.67 -83.33 485.00 $500.41 $0.00 $0.00 $0.00 3.99% $19.97 $500.00 $-480.03 $199.33 $0.00 $9.12 $0.00 45.68% $228.42 $500.00 $-271.58 $0.00 $41.67 $0.00 $83.33 $0.00 $0.00 $485.00 $0.00 0.00% 0.00% 3.99% 0.00% 0.00% 45.88% 0.00% 0.00% 0.00% 0.00% 1/5 Cash Basis Tuesday, October 15,2 20240 05:56 PM GMT-04:00 TOWN OF SCOTTSVILLE Budget VS. Actuals: FV.2022025-PY25PAL July: 2024 JUL 2024 485.00 0.00 485.00 485.00 83.33 1,250.00 -1,250.00 -782.30 0.00 -782.30 -1,130.78 0.00 -1,130.78 -0.02 -0.02 48.35 48.35 583.33 -583.33 2,083.33 -2,083.33 785.54 141.67 4.00 41.67 -37.67 144.93 144.93 148.93 41.67 833.33 833.33 591.67 591.67 21.17 21.17 1,352.00 1,541.67 -189.67 1,246.34 908.33 129.52 216.67 -87.15 4,753.84 5,150.00 -396.16 3,315.93 3,862.50 178.24 178.24 289.64 289.64 3,783.81 3,862.50 -78.69 0.00 0.00 2,970.00 247.50 16.67 -16.67 191.67 -191.67 58.33 -58.33 656.84 766.67 -109.83 29.58 729.17 -699.59 29.17 -29.17 29.17 -29.17 29.58 787.51 -757.93 773.22 125.00 46.83 83.33 -36.50 2,938.00 1,583.33 319.84 283.33 166.67 -166.67 95.00 41.67 20,050.46 20,305.85 416.67 -416.67 0.00 0.00 0.00 0.00 0.00 0.00 269.00 666.67 -397.67 208.33 -208.33 2,000.00 2,000.00 208.33 -208.33 0.00 0.00 1,237.50 416.67 250.00 -250.00 TOTAL $485.00 $401.67 582.02% ACTUAL BUDGET OVER BUDGET % OFE BUDGET ACTUAL BUDGET OVERI BUDGET % OFE BUDGET 68,945.35 53,100.00 15,845.35 129.84% $68,945.35 $53,100.00 $16,845.35 129.84% -1,913.08 1,250.00 -3,163.08 -153.05% $-1,913.08 $1,250.00 $-3,163.08 -153.05% 89,588.66 73,291.86 16,297.00 122.24% $89,588.66 $73,291.68 $16,297.00 122.24% $89,588.64 $73,291.66 $16,296.98 122.24% $89,588.64 $73,291.66 $16,298.98 122.24% $89,588.64 $73,291.66 $16,296.98 122.24% $89,588.64 $73,291.66 $16,296.98 122.24% Total 10-4455 Vendor Fees Total 10-4459N Miscellaneous Totel Receivedf from thel Town Return on Investments 10-4600 Income Reinvest- LGIP Town 10-4601 Income Reinvest- LGIP Caldwell Total Retumo onl Investments Total General Fund Unapplied Cash Payment Income Totall Income GROSS PROFIT Expenses 10-5035 Administrative- Vacation Administrative and Office 10-5000 Advertising 10-5002 Audit 10-5005 Computer 10-5006 Bank Service Charges 10-5015F Payroll- Direct Deposit Fees Total 10-5006 Bank Service Charges 10-5008 Dues, Subs. and Documents 10-5010 Insurance- VML & Wrkrs Comp 10-5014 Internet Service 10-5017 Payroll- Health Benefits 10-5018 Payroll- Pension 10-5019 Payroll- Lifel Insurance 10-5020 Payroll- TownA Adminlstrator 10-5022 Payroll- Town Clerk 10-5026/ Administrative- Holiday 10-5027 Administrative- Slck Total 10-5022 Payroll Town Clerk 10-5023 Payroll- Temp 10-5025 Cigarette Tax Stamps 10-5028" TAI Expenses 10-5030 Professional Development 10-5036 Town Council & Mayor 10-5038 Payroli- Matching FICA 10-50401 Telephone 10-50601 TA Cell Phone 10-5061 Clerk Cell Phone Total 10-50407 Telephone 10-5042 Office Supplies 10-50441 Mailings 10-5046 Town Attorney Contract 10-5047 Office Equipment 10-50481 Legal Litigation, Surveys 10-5049 Accounting Serviçes Total Administrative and Olfice Capitall Improvements 10-5062 E911 Grant Purchases 10-5130 Farmers' Market Restrooms 10-51497 Tree Removal 10-5168 Pollce- Purchase Car/Equipment 10-5169F Police-Purchase Car Int Expense 10-5170 VCNA CIP 10-5176 DGJS Grant- Purchases 10-5805 Farmers' Market Structure 10-5806. James River Waterfront CBS Flood Control $485.00 $0.00 0.00% 0.00% 0.00% 0.00% $-0.02 0.00% $48.35 0.00% $0.00 0.00% 0.00% 0.00% $643.87 554.49% $-37.67 9.60% $144.93 0.00% $107.26 357.40% 0.00% 0.00% $21.17 0.00% 87.70% $338.01 137.21% $-87.15 59.78% 85.85% $178.24 0.00% $289.64 0.00% $-78.69 97.96% $0.00 0.00% $-16.67 0.00% 0.00% $-58.33 0.00% 85.67% 4.06% $-29.17 0.00% $-29.17 0.00% 3.76% $648.22 618.58% $-36.50 56.20% $36.51 112.89% 0.00% $53.33 227.98% 98.74% $0.00 0.00% 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% 40.35% 0.00% 0.00% 0.00% 0.00% 0.00% 2/5 401.67 582.02% $485.00 $83.33 $0.00 $1,250.00 $-1,250.00 $-782,30 $0.00 $-782.30 $-1,130.78 $0.00 $-1,130.78 $-0.02 $0.00 $48.35 $0.00 $0.00 $0.00 $0.00 $583.33 $-583.33 $0.00 $2,083.33 $-2,083.33 9.60% $4.00 $41.67 $144.93 $0.00 $0.00 $833.33 $-833.33 $0.00 $591.67 $-591.67 $21.17 $0.00 87.70% $1,352.00 $1,541.67 $-189.67 338.01 137.21% $1,246.34 $908.33 59.78% $129.52 $216.67 92.31% $4,753.84 $5,150.00 $-396.16 92.31% -546.57 85.85% $3,315.93 $3,862.50 $-546.57 643.87 554.49% $785.54 $141.67 107.26 357.40% $148.93 $41.67 $178.24 $0.00 $289.64 $0.00 97.96% $3,783.81 $3,862.50 $0.00 $0.00 $0.00 $16.67 $0.00 $191.67 $-191.67 $0.00 $58.33 85.67% $656.84 $766.67 $-109.83 4.06% $29.58 $729.17 $-699.59 $0.00 $29.17 $0.00 $29.17 3.76% $29.58 $787.51 $-757.93 648.22 618.58% $773.22 $125.00 56.20% $46.83 $83.33 1,354.67 185.56% $2,938.00 $1,583.33 $1,354.67 185.56% 36.51 112.89% $319.84 $283.33 53.33 227.98% $95.00 $41.67 -255.39 98.74% $20,050.46 $20,305.85 $-255.39 2,722.50 1,200.00% $2,970.00 $247.50 $2,722.50 1,200.00% $0.00 $166.67 $-166.67 $0.00 $0.00 $0.00 $416.67 $-416.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 40.35% $269.00 $666.67 $-397.67 $0.00 $208.33 $-208.33 $0.00 $2,000.00 $-2,000.00 $0.00 $208.33 $-208.33 $0.00 $0.00 $0.00 $250.00 $-250.00 $0.00 $820.83 297.00% 820.83 297.00% $1,237.50 $416.67 Cash Basis Tueeday, October 15, 2024 05:56 PM GMT-04:00 TOWN OF SCOTTSVILLE Budget VS. Actuais: FY_ 2024-2025-FY25PaL July 2024 JUL2 2024 1,250.00 -1,250.00 1,500.00 -1,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,500.00 -2,500.00 250.00 0.00 0.00 2,750.00 -2,750.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 26.05 0.00 250.00 34.42 14.58 412.00 450.00 41.67 0.00 0.00 20.83 166.36 58.33 612.78 835.41 8.33 125.00 250.00 412.00 450.00 34.42 14.58 83.33 1,395.09 416.67 235.31 191.67 125.00 2,000.00 583.33 2,000.00 708.33 77.44 100.00 25.00 4,154,26 2,372.91 125.00 315.64 458.33 TOTAL ACTUAL BUDGET OVERE BUDGET %OFE BUDGET ACTUAL BUDGET OVERBUDGET %OF BUDGET 10-5810P Pump Statlon Total Flood Contro! Municipal Building 10-51200 Construct/PRenoyation: (Interior) 10-5134 Construction/Renv (Interior) Total 10-5120 ConstnuctRenyation (interior) 10-5133 ConstructPenoyation. (Exterior) Total Municipal Bullding Street Furnishings Streets 10-5152 Signage Improvements 10-5165 Repaira and Maintenance Total Streets Total Capitall Improvements Community Development 10-5209 Holiday" Tree & Decorations 10-5213 Dept. ofF Fire Programs Grant Local Agency Support Public Art Public! Heaith Total Communlty Development DMV Select (deleted) 10-5902 Computer (deleted) 10-5904 Office Supplies (deleted) 10-5905 Payroll- Wages (deleted) 10-5906 Payroli- FICA (deleted) 10-5907 Payroll- Lifel Insurance (deleted) 10-5908 Payroll- Health! Insurance (deleted) 10-5909 Payroll- Retirement (deleted) 10-5910 Professional Development (deleted) 10-59127 Telephone &1 Internet (deleted) Total DMV Select (doleted) Farmers' Market 10-5201 Farmers Mkt Structure 10-5202 Payroll- Matching FICA 10-52101 Manager's Fees 10-5211 Telephone/lnternet 10-5212 SNAP/EBT Program 10-52161 Misc. Expenses 10-5217/ Advertising 10-5353 Elec.-Water Fleet St( (Fmrs Mkt7 Tent) Total Farmers' Market Flood Control 10-5300 Equipment Maint. & Supplies 10-5301 Dlesel Fuelf for Pumps 10-53021 Mink Creek Dam Certification 10-5304 Payroll- Flood Superintendent 10-5306 Payroll- Matching FICA 10-5307 Pump House! Maintenance 10-5308 Pump Maintenance 10-5310 Electricity 10-5312Levee/Dam! Maint. 10-5311 Mowing ofLevee8 & Dam Total 10-5312 Levee/Dam Maint. 10-53157 Telephone 10-5316 Alarm Total Flood Control MunicipalE Building 10-5063 AEDA AUTOMATED! EXTERNAL DEFIBRILLATORS 10-5350 Elevator Maint & Phone $0.00 $1,250.00 $-1,250.00 $0.00 $1,500.00 $-1,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,237.50 $0.00 $1,237.50 $1,237.50 $0.00 $1,237.50 $0.00 $0.00 $0.00 $0.00 $102.13 $0.00 $98.66 $0.00 $200.79 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,500.00 $-2,500.00 $0.00 $250.00 $-250.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,750.00 $-2,750.00 $0.00 $0.00 $0.00 $0.00 $26.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26.05 $0.00 $0.00 $0.00 $0.00 $250.00 $-250.00 19.84 236.08% $34.42 $14.58 91.56% $412.00 $450.00 $0.00 $41.67 $0.00 $0.00 $0.00 $0.00 $0.00 $20,83 $0.00 $0.00 $0.00 $8.33 $0.00 $125.00 $-125.00 $0.00 $250.00 $-250.00 $0.00 $83.33 $0.00 $125.00 $-125.00 $0.00 $25.00 $0.00 $0.00 $0.00 $125.00 $-125.00 68.87% $315.64 $458.33 $-142.69 0.00% 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% 0.00% 0.00% $0.00 0.00% $0.00 0.00% $102.13 0.00% $98.66 0.00% $200.79 0.00% $0.00 0.00% $0.00 0.00% 0.00% 0.00% $0.00 0.00% $0.00 0.00% 0.00% $0.00 0.00% $0.00 0.00% $26.05 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% $26.05 0.00% $0.00 0,00% 0.00% $19.84 236.08% $-38.00 91.56% $-41.67 0.00% $0.00 0.00% $0.00 0.00% $-20.83 0.00% $108.03 285.20% 73.35% $0.00 0.00% $-8.33 0.00% 0.00% 0.00% $-38.00 91.56% $19.84 236.08% $-83.33 0.00% $978.42 334.82% $43.64 122.77% 0.00% $-22.56 77.44% $-25.00 0.00% $0.00 0.00% 0.00% 68,87% 3/5 0.00 0.00 1,237.50 1,237.50 0.00 102.13 98.66 200.79 0.00 -250.00 0.00 0.00 0.00 26.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 26.05 -250.00 -38.00 -41.67 0.00 0.00 -20.83 -8.33 -125.00 250.00 -83.33 -125.00 -25.00 -125.00 -142.69 1,237.50 1,237.50 102.13 98.66 200.79 2,944.79 5,416.67 -2,471.88 54.37% $2,944.79 $5,416.67 $-2,471.88 54.37% 26.05 108.03 285.20% $166.36 $58.33 222.63 73.35% $612.78 $835.41 $-222.63 -38.00 91.56% $412.00 $450.00 19.84 236.08% $34.42 $14.58 978.42 334.82% $1,395.09 $416.67 43.64 122.77% $235.31 $191.67 -22.56 77.44% $77.44 $100.00 1,416.67 342.86% $2,000.00 $583.33 $1,416.67 342.86% 1,291.67 282.35% $2,000.00 $708.33 $1,291.67 282.35% 1,781.35 175.07% $4,154.26 $2,372.91 $1,781.35 175.07% Cash Basis Tuesday, October 15, 2024 05:56 PMC GMT-04:00 TOWN OF SCOTTSVILLE Budget VS. Actuals: FY_2024,025-PY25PAL July: 2024 JUL: 2024 88.00 41.67 416.67 128.92 0.00 34.38 0.00 163.30 416.67 1,521.15 375.00 462.59 416.67 603.03 1,065.62 416.67 0.00 3,153.71 1,833.34 416.67 169.19 0.00 0.00 83.33 250.00 0.00 83.33 0.00 169.19 833.33 342.76 0.00 511.95 833.33 1,100.00 -1,100.00 83.33 125.00 20.83 2,028.00 1,541.67 990.77 1,283.33 113.90 133.33 385.42 858.33 333.33 416.67 608.33 57.05 1,083.33 -1,026.28 0.00 0.00 0.00 0.00 57.05 1,083.33 -1,026.28 500.00 0.00 0.00 500.00 36.00 416.67 167.75 58.33 210.00 666.67 172.11 125.00 67.87 500.00 208.33 200.64 16.67 18,706.43 25,486.23 54.00 1,171.38 333.33 41.67 1,171.38 $75.00 41.67 TOTAL ACTUAL BUDGET OVERE BUDGET % OFE BUDGET ACTUAL BUDGET OVERE BUDGET %OFE BUDGET 10-5351 Pest Control 10-5352 Utilities Elec, Gas, Water 10-5357 Electricity- Upstairs 10-5360 Water/Sewer Total 10-5352 Ulliles- Elec, Gas, Water 10-5354 Repairs and Maint 10-5356 Cleaning Service 10-5362 Supplies Cleaning Total 10-5356 Cleaning Service 10-5361 Alarm Total Munioipal Bullding Parks and'T Trails 10-5515F Park Maintenance 10-5517CBS Electricity 10-5518 CBS Water 10-5521 Bruce Park 10-5522 CBS 10-5523 Street7 Tree Maintenance 10-5525 Farmers' Market Pavillon 10-5527 VCNA 10-5530 Old. Jail/Butterfly Garden Total 10-5515 Park Maintenance 10-5635 CBSE Exhibits- Design & Repair Total Parks and7 Tralls Policel Department 10-50641 Region1 100 Contractual 10-5402 Building! Maintenance 10-54041 Part-Time Officers 10-5405 Future Officer Fund 10-5406 Payrall- Base Salary 10-5408 Payroll- Health Benefits 10-5410 Payroll- Matching FICA 10-5411 Payroll- -Litel Insurance 10-5412 Payroll- Pension 10-54131 LODAI Premiums 10-5416F Professional Dev. 10-5418 Vehiclel Insurance 10-5420 Vehicle Gas &F Fluid 10-5552: 2014F FordE Explorer (8341) 10-5553 2013F Ford Explorer (9191) 10-55542 2016F Ford F-150 (6113) 10-5557 2021 Interceptor 1( (4442) Total 10-5420 Vehlcle Gas & Fluid 10-5422 Vehicle Repairs & Maint 10-5546 20141 Interceptor 2( (8341) 10-5547 2016 Ford F-150 (6113) Total 10-5422) Vehlcle Repairs & Maint 10-5426 Supplies and Equip 10-5428 Utilities- Elec, Gas, Water 10-54301 Telephone/DSL 10-5432 Office Expenses 10-54961 ITI Maintenançe 10-5498 Uniforms 10-5550 Food Total Pollce Department Street Department 10-54442 2008 Chevrolet Colorado 10-5500 Maintenance 10-5598 Snow Removal Total 10-55001 Malntenance 10-5501 Streetscape! Plantings 46.33 211.18% $88.00 $41.67 $46.33 211.18% 0.00% $128.92 0.00% $34.38 0.00% 39.19% $45.92 111.02% $603.03 0.00% $848.95 255.75% $0.00 0.00% $0.00 0.00% 0.00% $169.19 0.00% $0.00 0.00% $0.00 0.00% $-83.33 0.00% 0.00% $0.00 0.00% $-83.33 0.00% $0.00 0.00% 20.30% $342.76 0.00% 61.43% $0.00 0.00% 0.00% $-83.33 0.00% 0.00% $-20.83 0.00% 92,66% $486.33 131.55% $-19.43 85.43% 44.90% 0.00% 0.00% 0.00% 5.27% $0.00 0.00% $0.00 0.00% $0.00 0.00% $0.00 0.00% 5.27% 0.00% $0.00 0,00% $0.00 0.00% 0.00% 8.64% $109.42 287.59% 31,50% $47.11 137.69% 13.57% 0.00% $183.97 1,203.60% 73,40% $0.00 0.00% $54.00 0.00% $838.05 351.42% $-41.67 0.00% $796.38 312.37% $-41.67 0.00% 4/5 -416.67 128.92 34.38 -253.37 603.03 0.00 -416.67 169.19 0.00 0.00 -83.33 250.00 0.00 -83.33 0.00 664.14 342.76 -83.33 -125.00 20.83 -292.56 -19.43 -472.91 -333.33 -416.67 -608.33 0.00 0.00 0.00 0.00 500.00 0.00 0.00 -500.00 -380.67 -456.67 -432.13 -208.33 6,779.80 54.00 -41.67 -41.67 $0.00 $416.67 $-416.67 $128.92 $0.00 $34.38 $0.00 39.19% $183.30 $416.67 $-253.37 $603.03 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $416.67 $-416.67 $169.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $83.33 $0.00 $250.00 $-250.00 $0.00 $0.00 $0.00 $83.33 $0.00 $0.00 20.30% $169.19 $833.33 $-664.14 $342.76 $0.00 -321.38 61.43% $511.95 $833.33 $-321.38 $0.00 $0.00 $0.00 $1,100.00 $-1,100.00 $0.00 $83.33 $0.00 $125.00 $-125.00 $0.00 $20.83 1,146.15 405.64% $1,521.15 $375.00 $1,146.15 405.64% 45.92 111.02% $462.59 $416.67 648.95 255.75% $1,065.62 $416.67 1,320.37 172.02% $3,153.71 $1,833.34 $1,320.37 172.02% 14,276.92 15,407.08 -1,130.16 92.68% $14,276.92 $15,407.08 $-1,130.16 486.33 131.55% $2,028.00 $1,541.67 77.20% $990.77 $1,283.33 $-292.56 77.20% 85,43% $113.90 $133.33 44.90% $385.42 $858.33 $-472.91 $0.00 $333.33 $-333.33 $0.00 $416.67 $-416.67 $0.00 $608.33 $-608.33 5.27% $57.05 $1,083.33 $-1,026.28 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5.27% $57.05 $1,083.33 $-1,026.28 $0.00 $500.00 $-500.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500.00 $-500.00 8.64% $36.00 $416.67 $ -380.67 31.50% $210.00 $666.67 $-456.67 13.57% $67.87 $500.00 $-432.13 $0.00 $208.33 $-208.33 73.40% $18,706.43 $25,486.23 $-6,779.80 $0.00 $0.00 $54.00 $0.00 $0.00 $41.67 $0.00 $41.67 109.42 287.59% $167.75 $58.33 47.11 137.69% $172.11 $125.00 183.97 1,203.60% $200.64 $16.67 838.05 351.42% $1,171.38 $333.33 796.38 312.37% $1,171.38 $375.00 Cash Basls Tuesday, October 15, 2024 05:56PM GMT-04:00 TOWN OF SCOTTSVILLE Budget VS. Actuals: FV.2024-2D25-PY25PAL July2 2024 JUL 2024 TOTAL ACTUAL BUDGET OVERE BUDGET % OFE BUDGET ACTUAL BUDGET OVERBUDGET %OFE BUDGET 10-5502 Payroll- -Matching FICA 10-5503F Payroll- Health Benefits 10-5505 Payroll- Lifel Insurance 10-5506 Payroli- Street Cleaning/Maint 10-5041 Maintenance- Sick 10-5043 Maintenance- Holday Total 10-5506 Payroll -Street Cleaning/Malint 10-5507 Payroll- VRS 10-5509 Telephone 10-55101 Trash/Contract! Labor 10-5512 StreetL Lighting 10-55141 Materials & Supplies 10-55291 Truck Repairs & Fuel 10-5532 Unlforms Total Street Department Tourism and! Econ Development 10-5526E Events & Tourism Committee 10-56024 4thc ofJ July 10-5604 Batteau Total 10-5526 Events &T Tourism Committee 10-5600 PortaToilet- Boat! Land, Events 10-5610 Website 10-56171 Misc-Conf,travel exp,publicity 10-5620E Brochures Total Tourism andE Econ! Development Town Planning Planning Commisslon 10-5707 Professional Consultation 10-5710 Miscellaneous Expenses Total Planning Commission Total Town Planning Total Expenses NETG OPERATING INCOME NETI INCOME 323.84 325.00 985.38 750.00 82.13 433.33 3,520.36 3,862.50 534.72 178.24 4,233.32 3,862.50 494.58 0.00 16.67 21.47 133.33 3,678.64 1,125.00 15.98 375.00 28.00 291.67 16.67 11,088.72 7,745.84 625.00 5,110.27 0.00 0.00 5,110.27 625.00 125.00 333.33 66.67 16.67 5,110.27 1,166.67 20.83 0.00 0.00 20.83 20.83 -1.16 99.64% $323.84 $325.00 235.38 131.38% $985.38 $750.00 18.95% $82.13 $433.33 $-351.20 -342.14 91.14% $3,520.36 $3,862.50 $-342.14 $534.72 $0.00 $178.24 $0.00 370.82 109.60% $4,233.32 $3,862.50 $494.58 $0.00 $0.00 $16.67 16.10% $21.47 $133.33 $-111.86 4.26% $15.98 $375.00 $-359.02 9.60% $28.00 $291.67 $-263.67 $0.00 $16.67 $0.00 $0.00 $0.00 $625.00 $-625.00 $5,110.27 $0.00 $5,110.27 $0.00 $0.00 $0.00 $125.00 $-125.00 $0.00 $333.33 $-333.33 $0.00 $66.67 $0.00 $16.67 $0.00 $0.00 $0.00 $20.83 $0.00 $0.00 $0.00 $0.00 $0.00 $20.83 $0.00 $20.83 96.57% $66,407.77 $68,767.08 $-2,359.31 $-1.16 99.64% $235.38 131.38% $534.72 $178.24 $370.82 109.60% $494.58 $-16.67 -351.20 534.72 178.24 494.58 -16.67 -111.86 -359.02 -263.67 -16.67 625.00 5,110.27 0.00 -125.00 333.33 -66.67 -16.67 -20.83 0.00 0.00 -20.83 20.83 18.95% 91.14% 0.00% 0.00% 0.00% 0.00% 16.10% 4.26% 9.60% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 96.57% 2,553.64 326.99% $3,678.64 $1,125.00 $2,553.64 326.99% 3,342.88 143.16% $11,088.72 $7,745.84 $3,342.88 143.16% $-16.67 $0.00 $0.00 $-66.67 $-16.67 $0.00 $-20.83 $0.00 $0.00 $-20.83 $-20.83 4,485.27 817.64% $5,110.27 $625.00 $4,485.27 817.64% 3,943.60 438.02% $5,110.27 $1,166.67 $3,943.60 438.02% $88,407.77 $68,767.08 $-2,359.31 $23,180.87 $4,524.58 $18,656.29 512.33% $23,180.87 $4,524.58 $18,656.29 512.33% $23,180.87 $4,524.58 $18,656.29 512.33% $23,180.87 $4,524.58 $18,656.29 512.33% Cash Basis Tuesday, October 15, 20240 05:56 PM GMT-04:00 5/5 C / L C - :e 6 8 8 8 > 6 8 d8 88 e 3 88 8 48 6