Loading...
3.2 LIBSR 04-23-20244-19-2024 10:47 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: OCTOBER 31ST, 2023 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 216,123.01 211-1380 Interest Receivable 1,126.00 217,249.01 TOTAL ASSETS 217,249.01 LIABILITIES EQUITY 211-2400 Fund Balance 241,203.19 TOTAL BEGINNING EQUITY 241,203.19 TOTAL REVENUE 71,399.20 TOTAL EXPENSES 95,353.38 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 23,954.18) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 217,249.01 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 217,249.01 4-19-2024 10:53 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2023 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 83.33% OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 108,000.00 306.69 71,399.20 66.11 36,600.80 108,000.00 306.69 71,399.20 66.11 36,600.80 118,000.00 8,363.48 95,353.38 80.81 22,646.62 118,000.00 8,363.48 95,353.38 80.81 22,646.62 118,000.00 6,363.4E 95,353.38 80.81 22,646.62 ( 101000.00)( 81056.79)( 23,954.18) 13,954.18 4-19-2024 10:53 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2023 211-LIBRARY REVENUES Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 211-3-0000-3112 Delinquent Ad Valorem Taxes TOTAL Taxes Other Revenue 211-3-0000-3621 Interest Income TOTAL Other Revenue Transfers In 211-3-0000-3945 Transfer -Utilities TOTAL Transfers In TOTAL Library Library Project --------------- Other Financing Sources TOTAL REVENUE 83.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 75,000.00 0.00 38,830.92 51.77 36,169.08 0.00 0.00 165.69 0.00 ( 165.69) 75,000.00 0.00 38,996.61 52.00 36,003.39 5,000.00 306.69 4,402.59 88.05 597.41 5,000.00 306.69 4,402.59 88.05 597.41 28,000.00 0.00 28,000.00 100.00 0.00 28,000.00 0.00 28,000.00 100.00 0.00 108,000.00 306.69 71,399.20 66.11 36,600.80 108,000.00 306.69 71,399.20 66.11 36,600.80 4-19-2024 10:53 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31ST, 2023 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-4-5600-4404 Equip Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services TOTAL Services & Charges Capital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay TOTAL Library TOTAL Culture & Recreation TOTAL EXPENDITURES CURRENT BUDGET 83.33% OF YEAR COMP. CURRENT YEAR TO DATE % OF BUDGET PERIOD ACTUAL BUDGET BALANCE 6,000.00 281.04 11,043.64 184.06 ( 5,043.64) 6,000.00 281.04 11,043.64 184.06 ( 5,043.64) 1,200.00 102.71 1,011.62 84.30 188.38 500.00 0.00 0.00 0.00 500.00 7,000.00 0.00 5,771.90 82.46 1,226.10 31,100.00 4,636.36 28,627.35 92.05 2,472.65 19,800.00 6,092.16 21,704.87 109.62 ( 1,904.87) 200.00 0.00 0.00 0.00 200.00 35,000.00 0.00 22,410.00 64.03 12,590.00 7,200.00 (_ 2,748.79) 4,784.00 66.44 2,416.00 102,000.00 8,082.44 84,309.74 82.66 17,690.26 10,000.00 0.00 0.00 0.00 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 118,000.00 8,363.48 95,353.38 80.81 22,646.62 118,000.00 8,363.48 95,353.38 80.81 22,646.62 118,000.00 8,363.48 95,353.38 80.81 22,646.62 REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 8,056.79)( 23,954.18) 13,954.18 4-19-2024 10:59 AM HISTORY DETAIL LISTING PAGE: 1 YEAR : Jan-2023 / Dec-2023 FUND 211-LIBRARY PERIOD TO USE: October THRU October DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== -----------------------------------------------------------------------------------------------------------------------------------' 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 10, 762. 60 10/16/23 10/12 A54048 CHK: 125741 SUPPLIES 15887 201.15 10,963.75 DACOTAH PAPER CO INV# 57533 /PO# 10/16/23 10/12 A54084 CHK: 125746 SUPPLIES 17890 79.89 11,043.64 ELK RIVER WINLECTRIC INV# 38193400 /PO# ------------- OCTOBER ACTIVITY DB: 281.04 CR: 0.00 281.04 -----------------------------------------------------------------------------------------------------------------------------------. 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 908.91 10/19/23 10/20 A54395 CHK: 125835 PHONE LINE CHGS 11102 102.71 1,011.62 WINDSTREAM INV# 100423 /PO# OCTOBER ACTIVITY DB: 102.71 CR: 0.00 102.71 -----------------------------------------------------------------------------------------------------------------------------------' 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 23, 990. 99 10/02/23 9/28 A53508 EFT: 005348 WATER/ELECTRIC/SEWER 17700 2,349.36 26,340.35 ELK RIVER MUNICIPAL UTILI INV# 091323 /PO# 10/16/23 10/12 A53638 CHK: 125787 SEP COMM GARBAGE SVC 10407 61.26 26,401.61 REPUBLIC SERVICES #899 INV# 899-004309994 /PO# 10/19/23 10/20 A54405 CHK: 125817 NATURAL GAS 13845 53.29 26,454.90 CENTERPOINT ENERGY INV# 6781052-3 SEP 23 /PO# 10/26/23 10/27 A54579 EFT: 005427 WATER/ELECTRIC/SEWER 17700 2,172.45 28,627.35 ELK RIVER MUNICIPAL UTILI INV# 101123 /PO# OCTOBER ACTIVITY DB: 4,636.36 CR: 0.00 4,636.36 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 15, 612.71 10/02/23 9/28 A53472 CHK: 125663 REPLACE CONTROL BOARD 15068 1,124.00 16,736.71 ELLIS GEOTHERMAL INC. INV# 13609 /PO# 10/09/23 10/09 A53799 CHK: 125718 SEC & FIRE PANEL MONITOR 36602 586.80 17,323.51 WRIGHT-HENNEPIN COOP ELEC INV# 092923 /PO# 10/16/23 10/12 A53889 EFT: 005369 IRRIGATION WINTERIZED 11661 376.00 17,701.51 SPEEDCUTTERS OUTDOOR MAIN INV# 25693 /PO# 10/27/23 11/02 B45964 IRRIGATIOON/MOWING RECLASS JE# 060629 4,003.36 21,704.87 OCTOBER ACTIVITY DB: 6,092.16 CR: 0.00 6,092.16 4-19-2024 10:59 AM HISTORY DETAIL LISTING PAGE: 2 YEAR Jan-2023 / Dec-2023 FUND 211-LIBRARY PERIOD TO USE: October THRU October DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------- 4-5600-4409 Contractual Services B E G I N N I N G B A L A N C E 10/02/23 9/28 A53341 EFT: 005324 MOWING & FERTILIZER 11661 SPEEDCUTTERS OUTDOOR MAIN INV# 25579 /PO# 10/26/23 10/27 A54567 CHK: 125843 STORYTIME WITH CRAFT-OCT 14941 MARILYN L DIRKSWAGER INV# 102323 /PO# 10/26/23 10/27 A54568 CHK: 125844 ALCOHOL INK PAINTING 15009 DEBRA EDWARDS INV# 101423 /PO# 10/27/23 11/02 B45964 IRRIGATIOON/MOWING RECLASS JE# 060629 ------------= OCTOBER ACTIVITY DB: 1,254.57 CR: 4,003.36CR *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 86,989.90 0.00 REPORTED ACTIVITY: 12,366.84 4,003.36CR ENDING BALANCES: 99,356.74 4,003.36CR TOTAL FUND ENDING BALANCE: 95,353.38 7,532.79 654.57 8,187.36 75.00 8,262.36 525.00 8,787.36 4,003.36CR 4,764.00 2,748.79CR 4-19-2024 10:50 AM 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS 211-1010 Cash - Library 211-1380 Interest Receivable TOTAL ASSETS LIABILITIES EQUITY 211-2400 Fund Balance TOTAL BEGINNING EQUITY CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: NOVEMBER 30TH, 2023 BALANCE 241,039.74 1,126.00 242,165.74 241,203.19 241,203.19 TOTAL REVENUE 105,811.12 TOTAL EXPENSES 104,848.57 TOTAL REVENUE OVER/(UNDER) EXPENSES 962.55 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 242,165.74 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 242,165.74 242,165.74 4-19-2024 10:53 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2023 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ACTUAL 91.67% OF YEAR COMP. % OF BUDGET BUDGET BALANCE 108,000.00 34,411.92 105,811.12 97.97 2,188.88 108,000.00 34,411.92 105,811.12 97.97 2,188.88 118,000.00 9,495.19 104,848.57 88.85 13,151.43 118,000.00 9,495.19 104,848.57 88.85 13,151.43 118,000.00 9,495.19 104,848.57 88.85 13,151.43 ( 10,000.00) 24,916.73 962.55 ( 10,962.55) 4-19-2024 10:53 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2023 211-LIBRARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 75,000.00 34,167.03 72,997.95 97.33 2,002.05 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 ( 259.96)( 94.27) 0.00 94.27 TOTAL Taxes 75,000.00 33,907.07 72,903.68 97.20 2,096.32 Other Revenue 211-3-0000-3621 Interest Income 5,000.00 504.85 4,907.44 98.15 92.56 TOTAL Other Revenue 5,000.00 504.85 4,907.44 98.15 92.56 Transfers In 211-3-0000-3945 Transfer -Utilities 28,000.00 0.00 28,000.00 100.00 0.00 TOTAL Transfers In 28,000.00 0.00 28,000.00 100.00 0.00 TOTAL Library 108,000.00 34,411.92 105,811.12 97.97 2,188.88 Library Project --------------- Other Financing Sources TOTAL REVENUE 108,000.00 34,411.92 105,811.12 97.97 2,188.88 4-19-2024 10:53 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2023 211-LIBRARY Culture & Recreation 91.67% OF YEAR COMP, Library CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 211-4-56OD-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-4-5600-4404 Equip Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services TOTAL Services & Charges Capital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay 6,000.00 395.52 11,439.16 190.65 ( 5,439.16) 6,000.00 395.52 11,439.16 190.65 ( 5,439.16) 1,200.00 102.71 1,114.33 92.86 85.67 500.00 0.00 0.00 0.00 500.00 7,000.00 0.00 5,771.90 82.46 1,228.10 31,100.00 2,263.39 30,890.74 99.33 209.26 19,800.00 0.00 21,704.87 109.62 ( 1,904.87) 200.00 299.00 299.00 149.50 ( 99.00) 35,000.00 4,980.00 27,390.00 78.26 7,610.00 7,200.00 1,454.57 6,238.57 86.65 961.43 102,000.00 9,099.67 93,409.41 91.58 8,590.59 10,000.00 0.00 0.00 0.00 10,000.00 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Library 118,000.00 9,495.19 104,848.57 88.85 13,151.43 TOTAL Culture & Recreation 118,000.00 9,495.19 104,848.57 88.85 13,151.43 TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 118,000.00 9,495.19 104,848.57 88.85 13,151.43 ( 10,000.00) 24,916.73 962.55 ( 10,962.55) 4-19-2024 10:59 AM HISTORY DETAIL LISTING PAGE: 1 YEAR Jan-2023 / Dec-2023 FUND 211-LIBRARY PERIOD TO USE: November THRU November DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ----------------------------------------------------------------------------------------------------------------------------------- 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 11, 043. 64 11/20/23 11/16 A55543 CHK: 126092 BULK SALT 13048 166.50 11,210.14 STEP SAVER INC INV# 168454 /PO# 11/20/23 11/16 A55637 CHK: 126038 SUPPLIES 15887 182.98 11,393.12 DACOTAH PAPER CO INV# 74838 /PO# 11/22/23 11/22 A56005 EFT: 005571 PARTS/SUPPLIES 25145 46.04 11,439.16 MENARDS - ELK RIVER INV# 103123 /PO# ------------= NOVEMBER ACTIVITY DB: 395.52 CR: 0.00 395.52 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 1,011.62 11/09/23 11/09 A55284 CHK: 126015 PHONE LINE CHGS 11102 102.71 1,114.33 WINDSTREAM INV# 110323 /PO# ------------- NOVEMBER ACTIVITY DB: 102.71 CR: 0.00 102.71 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 28, 627.35 11/09/23 11/09 A55322 CHK: 125992 NATURAL GAS 13845 24.28 28,651.63 CENTERPOINT ENERGY INV# 6781052-3 OCT 23 /PO# 11/20/23 11/16 A55460 CHK: 126086 OCT COMM GARBAGE SVC 10407 61.25 28,712.88 REPUBLIC SERVICES #899 INV# 899-004325844 /PO# 11/22/23 11/22 A56003 EFT: 005570 WATER/ELECTRIC/SEWER 17700 2,177.86 30,890.74 ELK RIVER MUNICIPAL UTILI INV# 111523 /PO# NOVEMBER ACTIVITY DB: 2,263.39 CR: 0.00 2,263.39 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4404 Equip Repair/Maint Services B E G I N N I N G B A L A N C E 0.00 11/08/23 11/13 A55446 CHK: 010200 WEATHERMATIC - IRRIG. CO 35099 299.00 299.00 US BANK INV# 10-25-2023 /PO# NOVEMBER ACTIVITY -DB: 299.00 CR: 0.00 299.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 22, 410.00 11/06/23 11/02 A54791 CHK: 125947 CLEANING SVCS - OCT 12651 2,490.00 24,900.00 PERFECTION PLUS, INC. INV# 314912 /PO# 4-19-2024 10:59 AM HISTORY DETAIL LISTING PAGE: 2 YEAR : Jan-2023 / Dec-2023 FUND : 211-LIBRARY PERIOD TO USE: November THRU November DEPT : 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 11/20/23 11/16 A55328 CHK: 126076 CLEANING SVCS - NOV 12651 2,490.00 27,390.00 PERFECTION PLUS, INC. INV# 314979 /PO# ------------- NOVEMBER ACTIVITY DB: 4,980.00 CR: 0.00 4,980.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services B E G I N N I N G B A L A N C E 4,784.00 11/20/23 11/16 A55497 EFT: 005509 MOWING & FERTILIZER 11661 654.57 5,438.57 SPEEDCUTTERS OUTDOOR MAIN INV# 25796 /PO# 11/20/23 11/16 A55623 CHK: 126040 STORYTIME WITH CRAFT-NOV 14941 300.00 5,738.57 MARILYN L DIRKSWAGER INV# 112723 /PO# 11/22/23 11/22 A55998 CHK: 126110 PROG-THE MISTLETONES 121 15134 500.00 6,238.57 CHRISTINA M CASE INV# 120223 /PO# NOVEMBER ACTIVITY DB: 1,454.57 CR: 0.00 1,454.57 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 95,353.38 0.00 REPORTED ACTIVITY: 9,495.19 0.00 ENDING BALANCES: 104,848.57 0.00 TOTAL FUND ENDING BALANCE: 104,848.57 4-19-2024 10:51 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2023 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS 211-1010 Cash - Library 211-1070 Taxes Receivable 211-1380 Interest Receivable BALANCE 235,776.03 2,029.68 1,242.00 239,047.71 TOTAL ASSETS LIABILITIES 211-2020 A/P - Library 12,226.10 211-2310 Unavailable Revenue - Taxes 636.20 TOTAL LIABILITIES EQUITY 211-2400 Fund Balance 241,203.19 TOTAL BEGINNING EQUITY 241,203.19 TOTAL REVENUE 107,859.86 TOTAL EXPENSES 122,877.66 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 15,017.78) TOTAL EQUITY & REV. OVER/(UNDER) EXP. TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 12,862.30 226,185.41 239,047.71 239,047.71 4-19-2024 10:54 AM 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2023 PAGE: 1 100.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 108,000.00 2,048.76 107,859.88 99.87 108,000.00 2,048.76 107,859.88 99.87 140.12 140.12 118,000.00 18,029.09 122,877.66 104.13 ( 4,877.66) 118,000.00 18,029.09 122,877.66 104.13 ( 4,877.66) 118,000.00 18,029.09 122,877.66 104.13 ( 4,877.66) ( 10,000.00)( 15,980.33)( 15,017.78) 5,017.78 4-19-2024 10:54 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2023 211-LIBRARY CURRENT REVENUES BUDGET Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 75,000.00 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 TOTAL Taxes 75,000.00 Other Revenue 211-3-0000-3621 Interest Income 5,000.00 TOTAL Other Revenue 5,000.00 Transfers In 100.00% OF YEAR COMP. CURRENT YEAR TO DATE % OF BUDGET PERIOD ACTUAL BUDGET BALANCE 1,393.48 74,391.43 99.19 608.57 0.00 ( 94.27) 0.00 94.27 1,393.48 74,297.16 99.06 702.84 655.28 5,562.72 121.25 ( 562.72) 655.28 5,562.72 111.25 ( 562.72) 211-3-0000-3945 Transfer -Utilities 28,000.00 0.00 26,000.00 100.00 TOTAL Transfers In 28,000.00 0.00 28,000.00 100.00 0.00 0.00 TOTAL Library 108,000.00 2,048.76 107,859.88 99.87 140.12 Library Project Other Financing Sources TOTAL REVENUE 108,000.00 2,048.76 107,859.88 99.87 140.12 4-19-2024 10:54 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2023 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-4-5600-4404 Equip Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services TOTAL Services & Charges Capital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay TOTAL Library 100.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 6,000.00 913.68 12,352.84 205.88 ( 6,352,84) 6,000.00 913.68 12,352.84 205.68 ( 6,352.84) 1,200.00 102.71 1,217.04 101.42 ( 17.04) 500.00 0.00 0.00 0.00 500.00 7,000.00 0.00 5,771.90 82.46 1,228.10 31,100.00 4,845.85 35,736.59 114.91 ( 4,636.59) 19,800.00 240.95 21,945.82 110.84 ( 2,145.82) 200.00 0.00 299.00 149.50 ( 99.00) 35,000.00 2,490.00 29,880.00 85.37 5,120.00 7,200.00 225.00 6,463.57 89.77 736.43 102,000.00 7,904.51 101,313.92 99.33 686.08 10,000.00 9,210.90 9,210.90 92.11 789.10 10,000.00 9,210.90 9,210.90 92.11 789.10 118,000.00 18,029.09 122,877.66 104.13 ( 4,877.66) TOTAL Culture & Recreation 118,000.00 18,029.09 122,877.66 104.13 ( 4,877.66) TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 118,000.00 ( 10,000.00)( 18,029.09 15,980.33)( 122,877.66 104.13 ( 15,017.78) 4,877.66) 5,017.78 4-19-2024 11:00 AM HISTORY DETAIL LISTING PAGE: 1 YEAR Jan-2023 / Dec-2023 FUND 211-LIBRARY PERIOD TO USE: December THRU December DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT---- ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 11, 439. 16 12/04/23 11/30 A56230 CHK: 126133 SUPPLIES 15887 82.92 11,522.08 DACOTAH PAPER CO INV# 81860 /PO# 12/18/23 12/14 A56886 CHK: 126251 REFRAME PRINTS 15151 659.96 12,182.04 FRAMING PLUS OF ANOKA INC INV# 11290 /PO# 12/18/23 12/14 A56982 EFT: 005671 SUPPLIES 25145 34.12 12,216.16 MENARDS - ELK RIVER INV# 113023 /PO# 12/31/23 1/08 A58018 CHK: 126472 SUPPLIES 15151 127.40 12,343.56 FRAMING PLUS OF ANOKA INC INV# 11315 /PO# 12/31/23 1/24 A58617 EFT: 005824 SUPPLIES 25145 9.28 12,352.84 MENARDS - ELK RIVER INV# 123123 /PO# DECEMBER ACTIVITY DB: 913.68 CR: 0.00 913.68 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 1,114.33 12/28/23 12/14 A56684 CHK: 126331 PHONE LINE CHGS 11102 102.71 1,217.04 WINDSTREAM INV# 120523 /PO# DECEMBER ACTIVITY DB: 102.71 CR: 0.00 102.71 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 30, 890.74 12/08/23 12/08 A56542 CHK: 126188 NATURAL GAS 13845 20.51 30,911.25 CENTERPOINT ENERGY INV# 6781052-3 NOV 23 /PO# 12/18/23 12/14 A56651 CHK: 126300 NOV COMM GARBAGE SVC 10407 203.53 31,114.78 REPUBLIC SERVICES #899 INV# 899-004354532 /PO# 12/21/23 12/22 A57306 EFT: 005690 WATER/ELECTRIC/SWR 17700 2,216.29 33,331.07 ELK RIVER MUNICIPAL UTILI INV# 121323 /PO# 12/31/23 1/11 A58090 CHK: 126544 DEC COMM GARBAGE SVC 10407 61.25 33,392.32 REPUBLIC SERVICES #899 INV# 899-004375095 /PO# 12/31/23 1/11 A58149 CHK: 126502 NATURAL GAS 13845 23.89 33,416.21 CENTERPOINT ENERGY INV# 6781052-3 DEC 23 /PO# 12/31/23 1/24 A58611 EFT: 005819 WATER/ELECTRIC/SWR 17700 2,320.38 35,736.59 ELK RIVER MUNICIPAL UTILI INV# 011024 /PO# DECEMBER ACTIVITY DB: 4,845.85 CR: 0.00 4,845.85 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 21,704.87 12/04/23 11/30 A56252 CHK: 126134 EXTERIOR WINDOW CLNG 16448 228.00 21,932.87 DISTINCTIVE WINDOW CLEANI INV# 23913 /PO# 4-19-2024 11:00 AM HISTORY DETAIL LISTING PAGE: 2 YEAR Jan-2023 / Dec-2023 PERIOD TO USE: December THRU December FUND 211-LIBRARY DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL DATE TRAN # REFERENCE PACKET======DESCRIPTION====== VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== POST 12/12/23 12/13 B46446 MISC # 021452 WH SECURITY REFUND JE# 061170 460.05CR 21,472.82 12/31/23 1/08 A58011 EFT: 005752 BI-MONTHLY SERVICE-LIBRA 14717 82.50 21,555.32 BLACKHAWK PEST CONTROL, L INV# 48343 /PO# 12/31/23 1/08 A58016 EFT: 005752 BI-MONTHLY SERVICE-LIBRA 14717 82.50 21,637.82 BLACKHAWK PEST CONTROL, L INV# 48559 /PO# 12/31/23 1/11 A58198 CHK: 126517 LIBRARY REPAIRS 21200 308.00 21,945.82 MATTHEW HEMMELGARN INV# 12192024 /PO# DECEMBER ACTIVITY DB: 701.00 CR: 460.05CR 240.95 ---------------------------- --------------- -------------------------------- 4-5600-4405 Cleaning Services 27, 390.00 B E G I N N I N G B A L A N C E 12/21/23 12/22 A57277 CHK: 126361 CLEANING SVCS - DEC 12651 2,490.00 29,880.00 PERFECTION PLUS, INC. INV# 315031 /PO# DECEMBER ACTIVITY DB: 2,490.00 CR: 0.00 2,490.00 ------------------------------------------- 4-5600-4409 Contractual ---------------------------------------------------------------------------------------- Services 6,236.57 B E G I N N I N G B A L A N C E 12/18/23 12/14 A56873 CHK: 126243 STORYTIME WITH CRAFT -DEC 14941 225.00 6,463.57 MARILYN L DIRKSWAGER INV# 121823 /PO# DECEMBER ACTIVITY DB: 225.00 CR: 0.00 225.00 --------------------------- --------------- 4-5600-4560 Equipment ---------------------------------- 0.00 B E G I N N I N G B A L A N C E 12/31/23 2/01 A59006 CHK: 126641 ACRYLIC DISPLAY BOXES, B 16275 4,013.00 4,013.00 DEMCO INC INV# 7419452 /PO# 13636 12/31/23 2/29 A60252 CHK: 126875 TABLES -LIBRARY 12900 3,302.50 7,315.50 BRODART CO INV# 635703 /PO# 13537 12/31/23 2/29 A60253 CHK: 126875 CHAIRS -LIBRARY 12900 1,895.40 9,210.90 BRODART CO INV# 635796 /PO# 13537 DECEMBER ACTIVITY DB: 9,210.90 CR: 0.00 9,210.90 4-19-2024 11:00 AM YEAR Jan-2023 / Dec-2023 FUND 211-LIBRARY DEPT 5600 Library POST DATE TRAN # REFERENCE HISTORY DETAIL LISTING PAGE: 3 PERIOD TO USE: December THRU December SUPPRESS ZEROS ACCOUNTS: ALL PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 104,848.57 0.00 REPORTED ACTIVITY: 18,489.14 460.05CR ENDING BALANCES: 123,337.71 460.05CR TOTAL FUND ENDING BALANCE: 122,877.66 4-19-2024 10:51 AM 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS 211-1010 Cash - Library 211-1380 Interest Receivable TOTAL ASSETS LIABILITIES 211-2020 A/P - Library TOTAL LIABILITIES EQUITY 211-2400 Fund Balance TOTAL BEGINNING EQUITY CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: JANUARY 31ST, 2024 BALANCE 230,991.97 1,242.00 232,233.97 9,210.90 9,210.90 226,165.41 226,185.41 TOTAL REVENUE 885.66 TOTAL EXPENSES _ 4,048.00 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 3,162.34) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 223,023.07 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 232,233.97 232,233.97 ------------- 4-19-2024 10:55 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2024 211-LIBRARY FINANCIAL SUMMARY 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 112,000.00 885.66 885.66 0.79 111,114.34 TOTAL REVENUES 112,000.00 885.66 885.66 0.79 111,114.34 EXPENDITURE SUMMARY Culture & Recreation Library 125,000.00 4,048.00 4,048.00 3.24 120,952.00 TOTAL Culture & Recreation 125,000.00 4,048.00 4,048.00 3.24 120,952.00 TOTAL EXPENDITURES 125,000.00 4,048.00 4,048.00 3.24 120,952.00 REVENUES OVER/(UNDER) EXPENDITURES ( 13,000.00)( 3,162.34)( 3,162.34) 1 9,837.66) 4-19-2024 10:55 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2024 211-LIBRARY REVENUES Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 211-3-0000-3112 Delinquent Ad Valorem Taxes TOTAL Taxes Other Revenue 211-3-0000-3621 Interest Income TOTAL Other Revenue Transfers In 211-3-0000-3945 Transfer -Utilities TOTAL Transfers In TOTAL Library Library Project Other Financing Sources TOTAL REVENUE 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 79,000.00 ( 14.70)( 14.70) 0.02- 79,014.70 0.00 14.70 14.70 0.00 ( 14.70) 79,000.00 0.00 0.00 0.00 79,000.00 5,000.00 885.66 885.66 17.71 4,114.34 5,000.00 885.66 885.66 17.71 4,114.34 28,000.00 0.00 0.00 0.00 26,000.00 28,000.00 0.00 0.00 0.00 28,000.00 112,000.00 885.66 885.66 0.79 111,114.34 112,000.00 885.66 885.66 0.79 111,114.34 4-19-2024 10:55 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2024 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services TOTAL Services & Charges Coital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BU➢GET BUDGET PERIOD ACTUAL BUDGET BALANCE 8,000.00 0.00 0.00 0.00 8,000.00 8,000.00 0.00 0.00 0.00 8,000.00 1,200.00 0.00 0.00 0.00 1,200.00 500.00 0.00 0.00 0.00 500.00 7,000.00 1,558.00 1,558.00 22.26 5,442.00 33,300.00 0.00 0.00 0.00 33,300.00 19,800.00 0.00 0.00 0.00 19,800.00 35,000.00 2,490.00 2,490.00 7.11 32,510.00 7,200.00 0.00 0.00 0.00 7,200.00 104,000.00 4,048.00 4,048.00 3.89 99,952.00 13,000.00 0.00 0.00 0.00 13,000.00 13,000.00 0.00 0.00 0.00 13,000.00 TOTAL Library 125,000.00 4,048.00 4,048.00 3.24 120,952.00 TOTAL Culture & Recreation 125,000.00 4,048.00 4,048.00 3.24 120,952.00 TOTAL EXPENDITURES 125,000.00 4,04B.00 4,048.00 3.24 120,952.00 REVENUES OVER/(UNDER) EXPENDITURES ( 13,000.00)( 3,162.34)( 3,162.34) ( 9,837.66) 4-19-2024 11:01 AM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY PERIOD TO USE: Jan-2024 THRU Jan-2024 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # - NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4361 Insurance B E G I N N I N G B A L A N C E 0.00 1/01/24 2/13 B47167 09781 LMC - PROP/CASUALTY INS JAN/MA JE# 061742 1,558.00 1,558.00 JANUARY ACTIVITY DB: 1,558.00 CR: 0.00 1,558.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 0.00 1/16/24 1/11 A58283 CHK: 126538 05198 CLEANING SVCS - JAN 12651 2,490.00 2,490.00 PERFECTION PLUS, INC. INV# 315086 /PO# JANUARY ACTIVITY DB: 2,490.00 CR: 0.00 2,490.00 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 0.00 0.00 REPORTED ACTIVITY: 4,048.00 0.00 ENDING BALANCES: 4,048.00 0.00 TOTAL FUND ENDING BALANCE: 4,048.00 4-19-2024 10:52 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: FEBRUARY 29TH, 2024 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 225,660.16 211-1380 Interest Receivable 1,242.00 226,902.16 TOTAL ASSETS 226,902.16 -------------- LIABILITIES -------------- 211-2020 A/P - Library 5,197.90 TOTAL LIABILITIES 5,197.90 EQUITY 211-2400 Fund Balance 226,185.41 TOTAL BEGINNING EQUITY 226,185.41 TOTAL REVENUE 1,446.49 TOTAL EXPENSES 5,927.64 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 4,481.15) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 221,704.26 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 226,902.16 -------------- -------------- 4-19-2024 10:55 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2024 211-LIBRARY FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Library 112,000.00 560.83 1,446.49 1.29 110,553.51 TOTAL REVENUES 112,000.00 560.83 1,446.49 1.29 110,553.51 EXPENDITURE SUMMARY Culture & Recreation Library 125,000.00 1,879.64 5,927.64 4.74 119,072.36 TOTAL Culture & Recreation 125,000.00 1,879.64 5,927.64 4.74 119,072.36 TOTAL EXPENDITURES 125,000.00 1,879.64 5,927.64 4.74 119,072.36 REVENUES OVER/(UNDER) EXPENDITURES ( 13,000.00)( 1,318.81)( 4,481.15) ( 8,518.85) 4-19-2024 10:55 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2024 211-LIBRARY REVENUES Library 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Taxes 211-3-0000-3111 Current Ad Valorem Taxes 79,000.00 0.00 ( 14.70) 0.02- 79,014.70 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 14.70 0.00 ( 14.70) TOTAL Taxes 79,000.00 0.00 0.00 0.00 79,000.00 Other Revenue 211-3-0000-3621 Interest Income 5,000.00 560.83 1,446.49 28.93 3,553.51 TOTAL Other Revenue 5,000.00 560.83 1,446.49 28.93 3,553.51 Transfers In 211-3-0000-3945 Transfer -Utilities 28,000.00 0.00 0.00 0.00 28,000.00 TOTAL Transfers In 28,000.00 0.00 0.00 0.00 28,000.00 TOTAL Library 112,000.00 560.83 1,446.49 1.29 110,553.51 Library Project Other Financinv Sources TOTAL REVENUE 112,000.00 560.83 1,446.49 1.29 110,553.51 4-19-2024 10:55 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29TH, 2024 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services TOTAL Services & Charges Capital Outlay 211-4-5600-4560 Equipment TOTAL Capital Outlay TOTAL Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 16.67% OF YEAR COMP, CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 8,000.00 1,406.00 1,406.00 17.58 6,594.00 8,000.00 1,406.00 1,406.00 17.58 6,594.00 1,200.00 ( 72.50)( 72.50) 6.04- 1,272.50 500.00 0.00 0.00 0.00 500.00 7,000.00 0.00 1,538.00 22.26 5,442.00 33,300.00 96.14 96.14 0.29 33,203.86 19,800.00 0.00 0.00 0.00 19,800.00 35,000.00 0.00 2,490.00 7.11 32,510.00 7,200.00 450.00 450.00 6.25 6,750.00 104,000.00 473.64 4,521.64 4.35 99,478.36 13,000.00 0.00 0.00 0.00 13,000.00 13,000.00 0.00 0.00 0.00 13,000.00 125,000.00 1,879.64 5,927.64 4.74 119,072.36 125,000.00 1,879.64 5,927.64 4.74 119,072.36 125,000.00 1,879.64 5,927.64 4.74 119,072.36 ( 13,000.00)( 1,318.81)( 4,481.15) ( 8,518.85) 4-19-2024 11:02 AM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY PERIOD TO USE: Feb-2024 THRU Feb-2024 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 0.00 2/05/24 2/01 A58925 CHK: 126639 05221 SUPPLIES 15887 1,155.53 1,155.53 DACOTAH PAPER CO INV# 31412 /PO# 2/05/24 2/01 A59152 CHK: 126697 05231 BULK SALT 13048 173.25 1,328.78 STEP SAVER INC INV# 170323 /PO# 2/12/24 2/12 A59469 CHK: 126724 05246 SUPPLIES 15887 36.69 1,365.47 DACOTAH PAPER CO INV# 34336 /PO# 2/20/24 2/15 A59878 EFT: 005944 05243 SUPPLIES 25145 40.53 1,406.00 MENARDS - ELK RIVER INV# 013124 /PO# ------------= FEBRUARY ACTIVITY DB: 1,406.00 CR: 0.00 1,406.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 0.00 2/26/24 2/29 B47303 MISC # 153224 09830 WINDSTREAM REFUND JE# 062043 72.50CR 72.50CR ------------= FEBRUARY ACTIVITY DB: 0.00 CR: 72.50CR 72.50CR ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 0.00 2/12/24 2/12 A59456 CHK: 126736 05246 JAN COMM GARBAGE SVC 10407 64.46 64.46 REPUBLIC SERVICES #899 INV# 899-004397452 /PO# 2/20/24 2/15 A59758 CHK: 126756 05243 NATURAL GAS 13845 31.68 96.14 CENTERPOINT ENERGY INV# 6781052-3 JAN 24 /PO# FEBRUARY ACTIVITY DB: 96.14 CR: 0.00 96.14 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services B E G I N N I N G B A L A N C E 0.00 2/23/24 2/23 A60161 CHK: 126842 05269 STORYTIME WITH CRAFT-JAN 14941 225.00 225.00 MARILYN L DIRKSWAGER INV# 022024 /PO# 2/23/24 2/23 A60162 CHK: 126842 05269 STORYTIME WITH CRAFT-FEB 14941 225.00 450.00 MARILYN L DIRKSWAGER INV# 022124 /PO# FEBRUARY ACTIVITY DB: 450.00 CR: 0.00 450.00 4-19-2024 11:02 AM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY PERIOD TO USE: Feb-2024 THRU Feb-2024 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 4,048.00 0.00 REPORTED ACTIVITY: 1,952.14 72.50CR ENDING BALANCES: 6,000.14 72.50CR TOTAL FUND ENDING BALANCE: 5,927.64 4-19-2024 10:52 AM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: MARCH 31ST, 2024 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS 211-1010 Cash - Library 211-1380 Interest Receivable TOTAL ASSETS LIABILITIES EQUITY 211-2400 Fund Balance TOTAL BEGINNING EQUITY BALANCE 209,891.21 1,242.00 211,133.21 226,185.41 226,185.41 211,133.21 TOTAL REVENUE 1,446.49 TOTAL EXPENSES 16,498.69 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 15,052.20) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 211,133.21 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 211,133.21 -------------- -------------- 4-19-2024 10:56 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2024 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURE SUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 112,000.00 0.00 1,446.49 1.29 110,553.51 112,000.00 0.00 1,446.49 1.29 110,553.51 125,000.00 10,571.05 16,498.69 13.20 108,501.31 125,000.00 10,571.05 16,498.69 13.20 108,501.31 125,000.00 10,571.05 16,498.69 13.20 108,501.31 ( 13,000.00)( 10,571.05)( 15,052.20) 2,052.20 4-19-2024 10:56 AM CITY OF ELK RIVER PAGE: 2 REVENUE 6 EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2024 211-LIBRARY REVENUES Library Taxes 211-3-0000-3111 Current Ad Valorem Taxes 211-3-0000-3112 Delinquent Ad Valorem Taxes TOTAL Taxes Other Revenue 211-3-0000-3621 Interest Income TOTAL Other Revenue Transfers In 211-3-0000-3945 Transfer -Utilities TOTAL Transfers In TOTAL Library Library Project Other Financinq Sources 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 79,000.00 0.00 ( 14.70) 0.02- 79,014.70 0.00 0.00 14.70 0.00 ( 14.70) 79,000.00 0.00 0.00 0.00 79,000.00 5,000.00 0.00 1,446.49 28.93 3,553.51 5,000.00 0.00 1,446.49 28.93 3,553.51 28,000.00 0.00 0.00 0.00 28,000.00 28,000.00 0.00 0.00 0.00 28,000.00 112,000.00 0.00 1,446.49 1.29 110,553.51 TOTAL REVENUE 112,000.00 0.00 1,446.49 1.29 110,553.51 4-19-2024 10:56 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2024 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal Services Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4359 Publishing 211-4-5600-4361 Insurance 211-4-5600-4389 Utilities 211-4-5600-4401 Bldg Repair/Maint Services 211-4-5600-4405 Cleaning Services 211-4-5600-4409 Contractual Services TOTAL Services & Charges Capital Outer 211-4-5600-4560 Equipment TOTAL Capital Outlay 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 8,000.00 613.50 2,019.50 25.24 5,980.50 8,000.00 613.50 2,019.50 25.24 5,980.50 1,200.00 500.00 7,000.00 33,300.00 19,800.00 35,000.00 7,200.00 104,000.00 13,000.00 13,000.00 0.00 ( 72.50) 6.04- 1,272.50 0.00 0.00 0.00 500.00 1,558.00 3,116.00 44.51 3,884.00 3,257.03 3,353.17 10.07 29,946.83 2,652.52 2,652.52 13.40 17,147.48 2,490.00 4,980.00 14.23 30,020.00 0.00 450.00 6.25 6,750.00 9,957.55 14,479.19 13.92 89,520.81 0.00 0.00 0.00 0.00 13,000.00 0.00 0.00 13,000.00 TOTAL Library 125,000.00 10,571.05 16,498.69 13.20 108,501.31 TOTAL Culture & Recreation 125,000.00 10,571.05 16,498.69 13.20 108,501.31 TOTAL EXPENDITURES 125,000.00 10,571.05 16,498.69 13.20 108,501.31 REVENUES OVER/(UNDER) EXPENDITURES ( 13,000.00)( 10,571.05)( 15,052.20) 2,052.20 4-19-2024 11:02 AM ➢ E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY PERIOD TO USE: Mar-2024 THRU Mar-2024 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 1,406.00 3/04/24 2/29 A60376 EFT: 006003 05274 SUPPLIES 20300 291.36 1,697.36 GRAINGER INV# 9015298681 /PO# 3/04/24 2/29 A60527 CHK: 126878 05275 SUPPLIES 15887 152.10 1,849.46 DACOTAH PAPER CO INV# 47636 /PO# 3/18/24 3/14 A61056 CHK: 126975 05292 SUPPLIES 15887 119.48 1,968.94 DACOTAH PAPER CO INV# 55224 /PO# 3/18/24 3/14 A61133 EFT: 006069 05291 PARTS/SUPPLIES 25145 50.56 2,019.50 MENARDS - ELK RIVER INV# 022924 /PO# ------------- MARCH ACTIVITY DB: 613.50 CR: 0.00 613.50 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4361 Insurance B E G I N N I N G B A L A N C E 1,558.00 3/18/24 3/14 A61123 CHK: 126998 05291 INSURANCE ALLOCATION 23805 1,558.00 3,116.00 LEAGUE OF MN CITIES INS T INV# 40➢02926 030424 /PO# ------------= MARCH ACTIVITY DB: 1,558.00 CR: 0.00 1,558.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 96.14 3/04/24 2/29 A60372 EFT: 006002 05274 WATER/ELECTRIC/SWR 17700 3,169.80 3,265.94 ELK RIVER MUNICIPAL UTILI INV# 021424 /PO# 3/08/24 3/08 A60788 CHK: 126950 05289 FEB COMM GARBAGE SVC 10407 64.46 3,330.40 REPUBLIC SERVICES #899 INV# 899-004422131 /PO# 3/18/24 3/14 A61003 CHK: 126972 05291 NATURAL GAS 13845 22.77 3,353.17 CENTERPOINT ENERGY INV# 6781052-3 FEB 24 /PO# MARCH ACTIVITY DB: 3,257.03 CR: 0.00 3,257.03 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 0.00 3/04/24 2/29 A60340 EFT: 005993 05274 PEST CONTROL -LIBRARY 14717 82.50 82.50 BLACKHAWK PEST CONTROL, L INV# 48744 /PO# 3/04/24 2/29 A60370 CHK: 126879 05274 EXTERIOR WINDOW CLNG 16448 238.00 320.50 DISTINCTIVE WINDOW CLEANI INV# 11302629 /PO# 3/04/24 2/29 A60410 EFT: 006010 05274 ANNUAL FIRE ALARM INSP-L 33444 460.00 780.50 SUMMIT COMPANIES INV# 130099635 /PO# 3/04/24 2/29 A60420 EFT: 006010 05274 ANNUAL SPRINKLER INSP-LI 33444 263.00 1,043.50 SUMMIT COMPANIES INV# 150040939 /PO# 4-19-2024 11:02 AM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY PERIOD TO USE: Mar-2024 THRU Mar-2024 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE IRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 3/18/24 3/14 A60915 CHK: 126987 05291 REPAIR UNIT 2 AIR DAMPER 11926 1,609.02 2,652.52 HUMERATECH INV# 240242 /PO# MARCH ACTIVITY DB: 2,652.52 CR: 0.00 2,652.52 ----------------------------------------------------------------------------------------------------------------------------------- 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 2,490.00 3/04/24 2/29 A60295 CHK: 126911 05274 CLEANING SVCS - FEB 12651 2,490.00 4,980.00 PERFECTION PLUS, INC. INV# 315149 /PO# ------------= MARCH ACTIVITY DB: 2,490.00 CR: 0.00 2,490.00 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 6,000.14 72.50CR REPORTED ACTIVITY: 10,571.05 0.00 ENDING BALANCES: 16,571.19 72.50CR TOTAL FUND ENDING BALANCE: 16,498.69