Loading...
3.2 LIBSR 10-26-20219-16-2021 11:14 AM 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS 211-1010 Cash - Library 211-1380 Interest Receivable CITY OF ELK RIVER BALANCE SHEET AS OF: JULY 31ST, 2021 BALANCE 291,529.22 1,614.00 293,143.22.22 PAGE: 1 TOTAL ASSETS 293,143.22 -------------- -------------- LIABILITIES 211-2200 Deposits Payable 100.00 TOTAL LIABILITIES 100.00 EQUITY 211-2400 Fund Balance 384.665_Rn TOTAL BEGINNING EQUITY 384,665.80 TOTAL REVENUE 68,173.98 TOTAL EXPENSES 159,796.56 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 91,622.58) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 293,043.22 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 293,143.22 -------------- -------------- 3.2 9-16-2021 11:21 AM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY PERIOD TO USE: Jul-2021 THRU Jul-2021 DEPT : N/A SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ---=BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 1010 Cash - Library B E G I N N I N G B A L A N C E 293, 788.60 7/06/21 7/07 B37106 Deposit 000000 08173 SHERBURNE CO - JUL TAX SETTLE JE# 051929 11,460.52 305,249.12 7/06/21 7/01 A16605 TRANSFER 04056 211-999 A/P REIMBURSEMEN 684.71CR 304,564.41 7/07/21 7/01 A16660 TRANSFER 04057 211-999 A/P REIMBURSEMEN 61.26CR 304,503.15 7/14/21 7/15 B37214 Deposit 000000 08192 REC CC 7/14 JE# 052041 100.00 304,603.15 7/19/21 7/15 A17389 TRANSFER 04070 211-999 A/P REIMBURSEMEN 10,516.27CR 294,086.88 7/20/21 7/22 B37246 Deposit 000000 08203 REC CC 7/20 JE# 052102 50.00CR 294,036.88 7/23/21 7/23 A17535 TRANSFER 04086 211-999 A/P REIMBURSEMEN 2,507.66CR 291,529.22 JULY ACTIVITY DB: 11,560.52 CR: 13,819.90CR 2,259.38CR ------------------------------------------------------------------------------------------------------------------------------------ 2020 A/P - Library B E G I N N I N G B A L A N C E 0.00 7/06/21 6/30 A16246 CHK: 118087 04046 MOWING SVCS CONTRACT 11661 604.71CR 604.71CR SPEEDCUTTERS OUTDOOR MAIN INV# 13453 /PO# 7/06/21 6/30 A16306 CHK: 118076 04046 PROGRAM 07/12/21 13060 40.00OR 644.71CR ROBIN D SCHAIBLE INV# 071221 /PO# 7/06/21 6/30 A16307 CHK: 118077 04046 PROGRAM 07/19/21 13060 40.00CR 684.71CR ROBIN D SCHAIBLE INV# 071921 /PO# 7/06/21 6/30 A16473 EFT: 002398 04046 JUN RUBBISH SVCS 30851 61.26CR 745.97CR RANDY'S ENVIRONMENTAL SER INV# 135818-061921 /PO# 7/06/21 7/01 A16605 TRANSFER 04056 211-999 A/P REIMBURSEMEN 684.71 61.26CR 7/07/21 7/01 A16660 TRANSFER 04057 211-999 A/P REIMBURSEMEN 61.26 0.00 7/19/21 7/14 A16823 CHK: 118285 04060 PHONE LINE CHGS 11102 93.47CR 93.47CR WINDSTREAM INV# 070721 /PO# 7/19/21 7/14 A16837 CHK: 118123 04060 INSTALL CABLE 11832 410.80CR 504.27CR ALL STATE COMMUNICATIONS INV# 316959 /PO# 7/19/21 7/14 A16888 CHK: 118233 04060 PROGRAM 07/26/21 13060 40.00OR 544.27CR ROBIN D SCHAIBLE INV# 072621 /PO# 7/19/21 7/14 A16889 CHK: 118234 04060 PROGRAM O8/02/21 13060 40.00CR 584.27CR ROBIN D SCHAIBLE INV# 080221 /PO# 7/19/21 7/14 A17123 CHK: 118271 04060 FIRE ALARM SYSTEM-LIBRAR 33444 9,932.000R 10,516.27CR SUMMIT COMPANIES INV# 2183669 /PO# 7/19/21 7/15 A17389 TRANSFER 04070 211-999 A/P REIMBURSEMEN 10,516.27 0.00 7/23/21 7/22 A17482 CHK: 118298 04079 CLEANING SVCS - JUL 12651 2,490.00OR 2,490.00OR PERFECTION PLUS, INC. INV# 113763 /PO# 7/23/21 7/22 A17484 CHK: 118291 04079 NATURAL GAS 13845 17.66CR 2,507.66CR CENTERPOINT ENERGY INV# 6781052-3 JUN 21 /PO# 7/23/21 7/23 A17535 TRANSFER 04086 211-999 A/P REIMBURSEMEN 2,507.66 0.00 JULY ACTIVITY DB: 13,769.90 CR: 13,769.90CR 0.00 9-16-2021 11:21 AM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY PERIOD TO USE: Jul-2021 THRU Jul-2021 DEPT N/A SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 2200 Deposits Payable B E G I N N I N G B A L A N C E 50.000R 7/14/21 7/15 B37214 Deposit 000000 08192 REC CC 7/14 JE# 052041 100.00CR 150.000R 7/20/21 7/22 B37246 Deposit 000000 08203 REC CC 7/20 JE# 052102 50.00 100.000R JULY ACTIVITY DB: 50.00 CR: 100.000R 50.000R ------------------------------------------------------------------------------------------------------------------------------------ 3-0000-3111 Current Ad Valorem Taxes B E G I N N I N G B A L A N C E 26,264.40CR DEPT: 0000 Library 7/06/21 7/07 B37106 Deposit 000000 08173 SHERBURNE CO - JUL TAX SETTLE JE# 051929 JULY ACTIVITY DB: 0.00 CR: 11,265.34CR ------------------------------------------------------------------------------------------------- 3-0000-3112 Delinquent Ad Valorem Taxes B E G I N N I N G B A L A N C E 7/06/21 7/07 B37106 Deposit 000000 D8173 SHERBURNE CO - JUL TAX SETTLE JE# 051929 JULY ACTIVITY DB: 0.00 CR: 195.18CR ------------------------------------------------------------------------------------------------- 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 7/19/21 7/14 A16823 CHK: 118285 04060 PHONE LINE CHGS 11102 WINDSTREAM INV# 070721 /PO# JULY ACTIVITY DB: 93.47 CR: 0.00 ------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 7/06/21 6/30 A16473 EFT: 002398 04046 JUN RUBBISH SVCS 30851 RANDY'S ENVIRONMENTAL SER INV# 135818-061921 /PO# 7/23/21 7/22 A17484 CHK: 118291 04079 NATURAL GAS 13845 CENTERPOINT ENERGY INV# 6781052-3 JUN 21 /PO# JULY ACTIVITY DB: 78.92 CR: 0.00 11,265.34CR 37,529.74CR 11,265.34CR 195.18CR 195.18CR 93.47 93.47 61.26 17.66 78.92 0.00 195.18CR 561.95 655.42 10,456.01 10,517.27 10,534.93 9-16-2021 11:21 AM D E T A I L L I S T I N G PAGE: 3 FUND 211-LIBRARY PERIOD TO USE: Jul-2021 THRU Jul-2021 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 2,660.79 7/06/21 6/30 A16246 CHK: 118087 04046 MOWING SVCS CONTRACT 11661 604.71 3,265.50 SPEEDCUTTERS OUTDOOR MAIN INV# 13453 /PO# 7/19/21 7/14 A16837 CHK: 118123 04060 INSTALL CABLE 11832 410.80 3,676.30 ALL STATE COMMUNICATIONS INV# 316959 /PO# 7/19/21 7/14 A17123 CHK: 118271 04060 FIRE ALARM SYSTEM-LIBRAR 33444 9,932.00 13,608.30 SUMMIT COMPANIES INV# 2183669 /PO# ------------= JULY ACTIVITY DB: 10,947.51 CR: 0.00 10,947.51 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4405 Cleaning Services B E G I N N I N G B A L A N C E 14, 940.00 7/23/21 7/22 A17482 CHK: 118298 04079 CLEANING SVCS - JUL 12651 2,490.00 17,430.00 PERFECTION PLUS, INC. INV# 113763 /PO# JULY ACTIVITY DB: 2,490.00 CR: 0.00 2,490.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services B E G I N N I N G B A L A N C E 10, 680. 00 7/06/21 6/30 A16306 CHK: 118076 04046 PROGRAM 07/12/21 13060 40.00 10,720.00 ROBIN D SCHAIBLE INV# 071221 /PO# 7/06/21 6/30 A16307 CHK: 118077 04046 PROGRAM 07/19/21 13060 40.00 10,760.00 ROBIN D SCHAIBLE INV# 071921 /PO# 7/19/21 7/14 A16888 CHK: 118233 04060 PROGRAM 07/26/21 13060 40.00 10,800.00 ROBIN D SCHAIBLE INV# 072621 /PO# 7/19/21 7/14 A16889 CHK: 118234 04060 PROGRAM O8/02/21 13060 40.00 10,840.00 ROBIN D SCHAIBLE INV# 080221 /PO# JULY ACTIVITY DB: 160.00 CR: 0.00 160.00 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 441,429.26 441,429.26CR REPORTED ACTIVITY: 39,150.32 39,150.32CR ENDING BALANCES: 480,579.58 480,579.58CR TOTAL FUND ENDING BALANCE: 0.00 9-16-2021 11:21 AM -------------------------------------------- FISCAL YEAR: Jan-2021 / Dec-2021 FUND: Include: 211 PERIOD TO USE: Jul-2021 THRU Jul-2021 TRANSACTIONS: BOTH ACCOUNT SELECTION D E T A I L L I S T I N G SELECTION CRITERIA ----------------------------- ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ DEPARTMENT RANGE: - THRU - ACTIVE FUNDS ONLY: YES ACTIVE ACCOUNT ONLY: NO INCLUDE RESTRICTED ACCOUNTS: NO DIGIT SELECTION: --------------------------------------------------- PRINT OPTIONS DETAIL OMIT ACCOUNTS WITH NO ACTIVITY: YES PRINT ENCUMBRANCES: NO PRINT VENDOR NAME: YES PRINT PROJECTS: NO PRINT JOURNAL ENTRY NOTES: NO PRINT MONTHLY TOTALS: YES PRINT GRAND TOTALS: NO PRINT: INVOICE/PO # PAGE BREAK BY: NONE --------------------------------------------------- *** END OF REPORT *** PAGE: 4 9-16-2021 11:18 P.M CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES CURRENT CURRENT BUDGET PERIOD 58.33% OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 106,500.00 11,460.52 68,173.98 64.01 38,326.02 106,500.00 11,460.52 68,173.98 64.01 38,326.02 116,500.00 13.769.90 159,796.56 137.16 ( 43.2,96,56) 116,500.00 13,769.90 159,796.56 137.16 ( 43,296,56) 116,500.00 13,769.90 159,796.56 137.16 ( 43,296.56) ----------------------------------------------------------- REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 2,309.38)( 91,622.58) 81,622.58 9-16-2021 11:18 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 211-LIBRARY REVENUES Library 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 211-3-0000-3111 Current Ad Valorem Taxes 71,500.00 11,265.34 37,529.74 52.49 33,970.26 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 195.18 195.1E 0.00 ( 195,18) TOTAL Taxes 71,500.00 11,460.52 37,724.92 52.76 33,775.08 Other Revenue 211-3-0000-3621 Interest Income 7,000.00 0.00 2,449.06 34.99 4,550.94 TOTAL Other Revenue 7,000.00 0.00 2,449.06 34.99 4,550.94 Transfers In 211-3-0000-3945 Transfer -Utilities 78,000.00 0.00 78,000.00 100.00 0.00 TOTAL Transfers In 28,000.00 0.00 28,000.00 100.00 0.00 TOTAL Library 106,500.00 11,460.52 68,173.98 64.01 38,326.02 Library Project --------------- Other Financing Sources TOTAL REVENUE 106,500.00 11,460.52 68,173.98 64.01 38,326.02 ----------------------------------------------------------- ----------------------------------------------------------- 9-16-2021 11:18 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2021 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES 3 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4331 Travel, Conferences & Schools 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-44D9 Contractual Services 211-4-5600-4433 Dues & Subscriptions TOTAL Services & Charges Capital Outlay 211-4-5600-4520 Buildings & Structures 211-4-5600-4560 Equipment TOTAL Capital Outlay TOTAL Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CURRENT CURRENT BUDGET PERIOD 58.33% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 10,000.00 0.00 2,115.66 21.16 7,884.32 10,000.00 0.00 2,115.68 21.16 7,884.32 1,100.00 93.47 655.42 59.58 444.58 150.00 0.00 0.00 0.00 150.00 500.00 0.00 0.00 0.00 500.00 3,200.00 0.00 2,366.00 73.94 834.00 30,000.00 78.92 10,534.93 35.12 19,465.07 17,550.00 10,947.51 13,608.30 77.54 3,941.70 200.00 0.00 0.00 0.00 200.00 30,000.00 2,490.00 17,430.00 58.10 12,570.00 13,700.00 100.00 160.00 0.00 10,640.00 0.00 79.12 0.00 2,860.00 100.00 96,500.00 13,769.90 55,434.65 57.45 41,065.35 0.00 0.00 102,246.23 0.00 ( 102,246.23) 10,000.00 10,000.00 0.00 0.00 0.00 102,246.23 0.00 1,022.46 ( 10,000.00 92,246.23) 116,500.00 13,769.90 159,796.56 137.16 ( 43,296.56) 116,500.00 13,769.90 159,796.56 137.16 ( 43,296.56) 116,500.00 13,769.90 159,796.56 137.16 ( 43,296.56) ( 10,000.00)( 2,309.38)( 91,622.56) 81,622.58 9-16-2021 11:15 AM 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION ASSETS 211-1010 Cash - Library 211-1380 Interest Receivable TOTAL ASSETS LIABILITIES 211-2200 Deposits Payable TOTAL LIABILITIES EQUITY 211-2400 Fund Balance TOTAL BEGINNING EQUITY CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: AUGUST 31ST, 2021 BALANCE 258,717.25 1,614.00 62 0.331.25 384,665.80 384,665.80 260,331.25 -------------- -------------- TOTAL REVENUE 68,173.98 TOTAL EXPENSES 192.708.53 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 124,534.55) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 260,131-25 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 260,331.25 -------------- -------------- 9-16-2021 11:25 AM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Aug-2021 THRU Aug-2021 DEPT N/A SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 1010 Cash - Library B E G I N N I N G B A L A N C E 291,529.22 8/02/21 7/29 A17961 TRANSFER 04088 211-999 A/P REIMBURSEMEN 190.92CR 291,338.30 8/03/21 8/04 B37403 Deposit 000000 08227 REC CC 8/3 JE# 052254 50.00 291,388.30 8/03/21 7/29 A18009 TRANSFER 04089 211-999 A/P REIMBURSEMEN 1,739.54CR 289,648.76 8/16/21 8/12 A18726 TRANSFER 04108 211-999 A/P REIMBURSEMEN 24,337.49CR 265,3ll.27 8/23/21 8/25 B37609 Deposit 000000 08260 REC CC 8/23 JE# 052433 50.00CR 265,261.27 8/24/21 8/24 A19068 TRANSFER 04125 211-999 A/P REIMBURSEMEN 4,957.50CR 260,303.77 8/25/21 8/26 B37626 Deposit 000000 08264 REC CC 8/25 JE# 052478 50.00 260,353.77 8/25/21 8/24 A19006 TRANSFER 04126 211-999 A/P REIMBURSEMEN 1,686.52CR 258,667.25 8/27/21 6/30 B37637 Deposit 000000 08269 REC CC 8/27 JE# 052505 50.00 258,717.25 ------------= AUGUST ACTIVITY DB: 150.00 CR: 32,961.97CR 32,811.97CR ------------------------------------------------------------------------------------------------------------------------------------ 2020 A/P - Library B E G I N N I N G B A L A N C E 0.00 8/02/21 7/28 A17661 CHK: 118384 04084 PROGRAM 08/09/21 13060 40.000R 40.00CR ROBIN D SCHAIBLE INV# 080921 /PO# 8/02/21 7/28 A17747 CHK: 118331 04084 SUPPLIES 15887 61.30CR 121.30CR DACOTAH PAPER CO INV# 13335 /PO# 8/02/21 7/28 A17765 EFT: 002488 04084 WATER/ELECTRIC/SWR/STRMW 17700 1,678.29CR 1,799.59CR ELK RIVER MUNICIPAL UTILI INV# 071421 /PO# 8/02/21 7/28 A17811 CHK: 118366 04084 SUPPLIES 27420 6.99CR 1,806.58CR N A P A OF ELK RIVER, I INV# 121773 /PO# 8/02/21 7/28 A17834 EFT: 002495 04084 JUL RUBBISH SVCS 30851 61.25CR 1,867.83CR RANDY'S ENVIRONMENTAL SER INV# 135818-071921 /PO# 8/02/21 7/28 A17842 CHK: 118387 04084 SUPPLIES 32280 62.63CR 1,930.46CR SHERWIN-WILLIAMS INV# 6679-6 /PO# 8/02/21 7/29 A17961 TRANSFER 04088 211-999 A/P REIMBURSEMEN 190.92 1,739.54CR 8/03/21 7/29 A18009 TRANSFER 04089 211-999 A/P REIMBURSEMEN 1,739.54 0.00 8/16/21 8/11 A18206 CHK: 118575 04092 PHONE LINE CHGS 11102 93.65CR 93.65CR WINDSTREAM INV# 080621 /PO# 8/16/21 8/11 A18219 CHK: 118560 04092 MOWING SVCS CONTRACT 11661 604.71CR 698.36CR SPEEDCUTTERS OUTDOOR MAIN INV# 13599 /PO# 8/16/21 8/11 A18383 CHK: 118455 04092 HVAC UPGRADES 14338 23,434.13CR 24,132.49CR APEX FACILITY SOLUTIONS, INV# 8 /PO# 8/16/21 8/11 A18428 CHK: 118483 04092 EXTERIOR WINDOW CLNG 16448 205.00OR 24,337.49CR DISTINCTIVE WINDOW CLEANI INV# 19984 /PO# 8/16/21 8/12 A18726 TRANSFER 04108 211-999 A/P REIMBURSEMEN 24,337.49 0.00 8/24/21 8/24 A18908 CHK: 118628 04116 BULK SALT 13048 16.80CR 16.80CR STEP SAVER INC INV# 147527 /PO# 6/24/21 8/24 A18919 CHK: 118591 04116 NATURAL GAS 13845 20.51CR 37.31CR CENTERPOINT ENERGY INV# 6781052-3 JUL 21 /PO# 8/24/21 8/24 A18929 CHK: 118584 04116 HVAC UPGRADES 14338 4,920.19CR 4,957.50CR APEX FACILITY SOLUTIONS, INV# 7 /PO# 9-16-2021 11:25 AM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Aug-2021 THRU Aug-2021 DEPT N/A SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET ------DESCRIPTION======= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 8/24/21 8/24 A18947 EFT: 002580 04116 WATER/ELECTRIC/SWR/STMWT 17700 1,585.69CR 6,543.19CR ELK RIVER MUNICIPAL UTILI INV# 081121 /PO# 8/24/21 8/24 A18971 EFT: 002583 04116 SUPPLIES 25145 100.83CR 6,644.02CR MENARDS - ELK RIVER INV# 073121 /PO# 8/24/21 8/24 A19068 TRANSFER 04125 211-999 A/P REIMBURSEMEN 4,957.50 1,686.52CR 8/25/21 8/24 A19006 TRANSFER 04126 211-999 A/P REIMBURSEMEN 1,686.52 0.00 AUGUST ACTIVITY DB: 32,911.97 CR: 32,911.97CR 0.00 ----------------------------------------------------------------------------------------------------------------------------------- 2200 Deposits Payable B E G I N N I N G B A L A N C E 100.000R 8/03/21 8/04 B37403 Deposit 000000 08227 REC CC 8/3 JE# 052254 50.000R 150.000R 8/23/21 8/25 B37609 Deposit 000000 08260 REC CC 8/23 JE# 052433 50.00 100.000R 8/25/21 8/26 B37626 Deposit 000000 08264 REC CC 8/25 JE# 052478 50.000R 150.000R 8/27/21 8/30 B37637 Deposit 000000 08269 REC CC 8/27 JE# 052505 50.000R 200.00CR AUGUST ACTIVITY DB: 50.00 CR: 150.000R 100.000R ------------------------------------------------------------------------------- 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 8/02/21 7/28 A17747 CHK: 118331 04084 SUPPLIES 15887 DACOTAH PAPER CO INV# 13335 8/02/21 7/28 A17811 CHK: 118366 04084 SUPPLIES 27420 N A P A OF ELK RIVER, I INV# 121773 8/02/21 7/28 A17842 CHK: 118387 04084 PAINT 32280 SHERWIN-WILLIAMS INV# 6679-6 8/24/21 8/24 A18908 CHK: 118628 04116 BULK SALT 13048 STEP SAVER INC INV# 147527 8/24/21 8/24 A18971 EFT: 002583 04116 SUPPLIES 25145 MENARDS - ELK RIVER INV# 073121 8/24/21 8/24 A18971 EFT: 002563 04116 SUPPLIES 25145 MENARDS - ELK RIVER INV# 073121 AUGUST ACTIVITY DB: 268.55 CR ------------------------------------------------------------------------------ 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 8/16/21 8/11 A18206 CHK: 118575 04092 PHONE LINE CHGS 11102 WINDSTREAM INV# 080621 AUGUST ACTIVITY DB: 93.65 CR /PO# /PO# /PO# /PO# /PO# /PO# 0.00 /PO# 0.00 81.30 6.99 62.63 16.80 65.77 35.06 268.55 93.65 93.65 2,115.68 2,196.98 2,203.97 2,266.60 2,283.40 2,349.17 2,384.23 655.42 749.07 9-16-2021 11:25 AM D E T A I L L I S T I N G PAGE: 3 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Aug-2021 THRU Aug-2021 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 10, 534. 93 8/02/21 7/28 A17765 EFT: 002488 04084 WATER/SEWER/ELECTRIC 17700 1,678.29 12,213.22 ELK RIVER MUNICIPAL UTILI INV# 071421 /PO# 8/02/21 7/28 A17834 EFT: 002495 04084 JUL RUBBISH SVCS 30851 61.25 12,274.47 RANDY'S ENVIRONMENTAL SER INV# 135818-071921 /PO# 8/24/21 8/24 A16919 CHK: 118591 04116 NATURAL GAS 13845 20.51 12,294.98 CENTERPOINT ENERGY INV# 6781052-3 JUL 21 /PO# 8/24/21 8/24 A18947 EFT: 002580 04116 WATER/SEWER/ELECTRIC 17700 1,585.69 13,880.67 ELK RIVER MUNICIPAL UTILI INV# 081121 /PO# AUGUST ACTIVITY DB: 3,345.74 CR: 0.00 3,345.74 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services B E G I N N I N G B A L A N C E 13, 608. 30 8/16/21 8/11 A18219 CHK: 118560 04092 MOWING SVCS CONTRACT 11661 604.71 14,213.01 SPEEDCUTTERS OUTDOOR MAIN INV# 13599 /PO# 8/16/21 8/11 A18428 CHK: 118483 04092 EXTERIOR WINDOW CLNG 16448 205.00 14,418.01 DISTINCTIVE WINDOW CLEANI INV# 19984 /PO# AUGUST ACTIVITY DB: 809.71 CR: 0.00 809.71 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4409 Contractual Services B E G I N N I N G B A L A N C E 10, 840.00 8/02/21 7/28 A17661 CHK: 118384 04084 PROGRAM O8/09/21 13060 40.00 10,880.00 ROBIN D SCHAIBLE INV# 080921 /PO# AUGUST ACTIVITY DB: 40.00 CR: 0.00 40.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4520 Buildings & Structures B E G I N N I N G B A L A N C E 102,246.23 8/16/21 8/11 A18383 CHK: 118455 04092 HVAC UPGRADES 14338 23,434.13 125,680.36 APEX FACILITY SOLUTIONS, INV# 8 /PO# 8/24/21 8/24 A18929 CHK: 118584 04116 HVAC UPGRADES 14338 4,920.19 130,600.55 APEX FACILITY SOLUTIONS, INV# 7 /PO# ------------= AUGUST ACTIVITY DB: 28,354.32 CR: 0.00 28,354.32 9-16-2021 11:25 AM D E T A I L L I S T I N G PAGE: 4 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Aug-2021 THRU Aug-2021 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: 452,939.78 452,939.78CR REPORTED ACTIVITY: 66,023.94 66,023.94CR ENDING BALANCES: 518,963.72 518,963.72CR TOTAL FUND ENDING BALANCE: 0.00 9-16-2021 11:25 AM D E T A I L L I S T I N G PAGE: 5 SELECTION CRITERIA -------------------------------------------------------------------------------------------------------- FISCAL YEAR: Jan-2021 / Dec-2021 FUND: Include: 211 PERIOD TO USE: Aug-2021 THRU Aug-2021 TRANSACTIONS: BOTH ------------------------------------------------------------------------------------------------------------------------------------ ACCOUNT SELECTION ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ DEPARTMENT RANGE: - THRU - ACTIVE FUNDS ONLY: YES ACTIVE ACCOUNT ONLY: YES INCLUDE RESTRICTED ACCOUNTS: NO DIGIT SELECTION: ------------------------------------------------------------------------------------------------------------------------------------ PRINT OPTIONS DETAIL OMIT ACCOUNTS WITH NO ACTIVITY: YES PRINT ENCUMBRANCES: NO PRINT VENDOR NAME: YES PRINT PROJECTS: NO PRINT JOURNAL ENTRY NOTES: NO PRINT MONTHLY TOTALS: YES PRINT GRAND TOTALS: NO PRINT: INVOICE/PO # PAGE BREAK BY: NONE ------------------------------------------------------------------------------------------------------------------------------------ *** END OF REPORT *** 9-16-2021 11:19 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2021 211-LIBRARY FINANCIAL SUMMARY REVENUE SUMMARY Library TOTAL REVENUES EXPENDITURESUMMARY Culture & Recreation Library TOTAL Culture & Recreation TOTAL EXPENDITURES REVENUES OVER/(UNDER) EXPENDITURES CURRENT CURRENT YEAR TO DATE BUDGET PERIOD ACTUAL 66.67% OF YEAR COMP. OF BUDGET BUDGET BALANCE 106,500.00 0.00 68,173.98 64.01 38,326.02 106,500.00 0.00 68,173.98 64.01 38,326.02 116,500.00 32,911.97 19 .708 165.42 ( 76,208,53) 116,500.00 32,911.97 192,708.53 165.42 ( 76,208.53) 116,500.00 32,911.97 192,708.53 165.42 ( 76,208.53) ( 10,000.00)( 32,911.97)( 124,534.55) 114,534.55 9-16-2021 11:19 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2021 211-LIBRARY 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Library 211-3-0000-3111 Current Ad Valorem Taxes 71,500.00 0.00 37,529.74 52.49 33,970.26 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 195.18 0.00 ( 195,18) TOTAL Taxes 71,500.00 0.00 37,724.92 52.76 33,775.08 Other Revenue 211-3-0000-3621 Interest Income 7,000.00 0.00 2,449.06 34.99 4,550.94 TOTAL Other Revenue 7,000.00 0.00 2,449.06 34.99 4,550.94 Transfers 211-3-0000-3945 Transfer -Utilities 28,000.00 0.00 28,000.00 100.00 0.00 TOTAL Transfers In 26,000.00 0.00 28,000.00 100.00 0.00 TOTAL Library 106,500.00 0.00 68,173.98 64.01 38,326.02 Library Project Other Financing Sources TOTAL REVENUE 106,500.00 0.00 68,173.98 64.01 38,326.02 9-16-2021 11:19 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31ST, 2021 211-LIBRARY Culture & Recreation Library DEPARTMENTAL EXPENDITURES Personal v s Supplies 211-4-5600-4219 Operating Supplies TOTAL Supplies Services & Charges 211-4-5600-4321 Telephone 211-4-5600-4331 Travel, Conferences & Schools 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 211-4-5600-4433 Dues & Subscriptions TOTAL Services & Charges Capital OLtlav 211-4-5600-4520 Buildings & Structures 211-4-5600-4560 Equipment TOTAL Capital Outlay 66.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 10,000.00 268.55 2,384.23 23.84 7A-15.77 10,000.00 268.55 2,384.23 23.84 7,615.77 1,100.00 93.65 749.07 68.10 350.93 150.00 0.00 0.00 0.00 150.00 500.00 0.00 0.00 0.00 500.00 3,200.00 0.00 2,366.00 73.94 834.00 30,000.00 3,345.74 13,880.67 46.27 16,119.33 17,550.00 809.71 14,418.01 82.15 3,131.99 200.00 0.00 0.00 0.00 200.00 30,000.00 0.00 17,430.00 58.10 12,570.00 13,700.00 100.00 40.00 0.00 10,880.00 0.00 79.42 0.00 2,820.00 100.00 96,500.00 4,289.10 59,723.75 61.89 36,776.25 0.00 10,000.00 28,354.32 0.00 130,600.55 0.00 0.00 ( 0.00 130,600.55) 10,000.00 28,354.32 130,600.55 1,306.01 ( 10.000.00 120,600.55) TOTAL Library 116,500.00 32,9ll.97 192,708.53 165.42 ( 76,208.53) TOTAL Culture & Recreation 116,500.00 32,911.97 192,708.53 165.42 ( 76,208.53) TOTAL EXPENDITURES 116,500.00 -------------------------- 32,911.97 ------------- 192,708.53 165.42 ( ------- 76,208.53) ------------- REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 32,9ll.97)( 124,534.55) 114,534.55 10-13-2021 03:36 PM CITY OF ELK RIVER PAGE: 1 BALANCE SHEET AS OF: SEPTEMBER 30TH, 2021 211-LIBRARY ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 211-1010 Cash - Library 226,132.49 211-1380 Interest Receivable 1,614.00 227,746.49 TOTAL ASSETS 227,746.49 LIABILITIES 211-2200 Deposits Payable 200.00 TOTAL LIABILITIES 200.00 EQUITY 211-2400 Fund Balance 384,665.80 TOTAL BEGINNING EQUITY 384,665.80 TOTAL REVENUE 68,947.27 TOTAL EXPENSES 226,066.58 TOTAL REVENUE OVER/(UNDER) EXPENSES ( 157,119.31) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 227,546.49 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 227,746.49 10-13-2021 3:40 PM D E T A I L L I S T I N G PAGE: 1 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep-2021 THRU Sep-2021 DEPT N/A SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== ------------------------------------------------------------------------------------------------------------------------------------ 1010 Cash - Library BE G I NN I NG BALANCE 259,490.54 9/07/21 9/02 A19704 TRANSFER 04131 211-999 A/P REIMBURSEMEN 1,109.71CR 258,380.83 9/08/21 9/02 A19563 TRANSFER 04133 211-999 A/P REIMBURSEMEN 61.25CR 258,319.58 9/20/21 9/17 A20421 TRANSFER 04143 211-999 A/P REIMBURSEMEN 30,213.84CR 228,105.74 9/24/21 9/27 B37946 Deposit 000000 08316 ERMU LIGHTING RETROFIT JE# 052780 3,006.75 231,112.49 9/24/21 9/24 A20499 TRANSFER 04153 211-999 A/P REIMBURSEMEN 4,980.000R 226,132.49 ------------= SEPTEMBER ACTIVITY DB: 3,006.75 CR: 36,364.80CR 33,358.05CR ------------------------------------------------------------------------------------------------------------------------------------ 2020 A/P - Library B E G I N N I N G B A L A N C E 0.00 9/07/21 9/01 A19184 CHK: 118741 04123 MOWING SVCS CONTRACT 11661 604.71CR 604.71CR SPEEDCUTTERS OUTDOOR MAIN INV# 13707 /PO# 9/07/21 9/01 A19213 CHK: 118645 04123 LOCK REPAIRS 12256 505.00CR 1,109.71CR BLAINE LOCK & SAFE, INC INV# 25873 /PO# 9/07/21 9/01 A19463 EFT: 002632 04123 AUG RUBBISH SVCS 30851 61.25CR 1,170.96CR RANDY'S ENVIRONMENTAL SER INV# 135818-081921 /PO# 9/07/21 9/02 A19704 TRANSFER 04131 211-999 A/P REIMBURSEMEN 1,109.71 61.25CR 9/08/21 9/02 A19563 TRANSFER 04133 211-999 A/P REIMBURSEMEN 61.25 0.00 9/20/21 9/16 A19878 CHK: 118910 04138 PHONE LINE CHGS 11102 93.77CR 93.77CR WINDSTREAM INV# 090821 /PO# 9/20/21 9/16 A19985 CHK: 118805 04138 NATURAL GAS 13845 20.51CR 114.28CR CENTERPOINT ENERGY INV# 6781052-3 AUG 21 /PO# 9/20/21 9/16 A20007 CHK: 118792 04138 HVAC UPGRADES 14338 28,834.87CR 28,949.15CR APEX FACILITY SOLUTIONS, INV# 9 /PO# 9/20/21 9/16 A20043 CHK: 118814 04138 SUPPLIES 15887 404.69CR 29,353.84CR DACOTAH PAPER CO INV# 42721 /PO# 9/20/21 9/16 A20111 CHK: 118850 04138 INSURANCE ALLOCATION 23805 860.000R 30,213.84CR LEAGUE OF MN CITIES INS T INV# 40002926 090721 /PO# 9/20/21 9/17 A20421 TRANSFER 04143 211-999 A/P REIMBURSEMEN 30,213.84 0.00 9/24/21 9/24 A20458 CHK: 118922 04151 CLEANING SVCS - AUG 12651 2,490.000R 2,490.00OR PERFECTION PLUS, INC. INV# 113811 /PO# 9/24/21 9/24 A20459 CHK: 118922 04151 CLEANING SVCS - SEP 12651 2,490.000R 4,980.00OR PERFECTION PLUS, INC. INV# 113855 /PO# 9/24/21 9/24 A20499 TRANSFER 04153 211-999 A/P REIMBURSEMEN 4,980.00 0.00 ------------= SEPTEMBER ACTIVITY DB: 36,364.80 CR: 36,364.80CR 0.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4219 Operating Supplies B E G I N N I N G B A L A N C E 2,384.23 9/20/21 9/16 A20043 CHK: 118814 04138 SUPPLIES 15687 404.69 2,788.92 DACOTAH PAPER CO INV# 42721 /PO# ------------- SEPTEMBER ACTIVITY DB: 404.69 CR: 0.00 404.69 10-13-2021 3:40 PM D E T A I L L I S T I N G PAGE: 2 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep-2021 THRU Sep-2021 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION------= VEND INV/PO/JE # NOTE ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4321 Telephone B E G I N N I N G B A L A N C E 749.07 9/20/21 9/16 A19878 CHK: 118910 04138 PHONE LINE CHGS 11102 93.77 842.84 WINDSTREAM INV# 090821 /PO# ------------= SEPTEMBER ACTIVITY DB: 93.77 CR: 0.00 93.77 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4361 Insurance B E G I N N I N G B A L A N C E 2,366.00 9/20/21 9/16 A20111 CHK: 118850 04138 INSURANCE ALLOCATION 23805 860.00 3,226.00 LEAGUE OF MN CITIES INS T INV# 40002926 090721 /PO# SEPTEMBER ACTIVITY DB: 860.00 CR: 0.00 860.00 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4389 Utilities B E G I N N I N G B A L A N C E 13, 880. 67 9/07/21 9/01 A19463 EFT: 002632 04123 AUG RUBBISH SVCS 30851 61.25 13,941.92 RANDY'S ENVIRONMENTAL SER INV# 135818-081921 /PO# 9/20/21 9/16 A19985 CHK: 118805 04138 NATURAL GAS 13845 20.51 13,962.43 CENTERPOINT ENERGY INV# 6781052-3 AUG 21 /PO# 9/24/21 9/27 B37946 MISC # 092421 08316 LIGHTING RETROFIT - LIBRARY JE# 052780 3,006.75CR 10,955.68 ------------- SEPTEMBER ACTIVITY DB: 81.76 CR: 3,006.75CR 2,924.99CR ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4401 Bldg Repair/Maint Services BEG 1 N N I N G BALANCE 14,418.01 9/07/21 9/01 A19184 CHK: 118741 04123 MOWING SVCS CONTRACT 11661 604.71 15,022.72 SPEEDCUTTERS OUTDOOR MAIN INV# 13707 /PO# 9/07/21 9/01 A19213 CHK: 118645 04123 LOCK REPAIRS 12256 505.00 15,527.72 BLAINE LOCK & SAFE, INC INV# 25873 /PO# 9/24/21 9/24 A20458 CHK: 118922 04151 CLEANING SVCS - AUG 12651 2,490.00 18,017.72 PERFECTION PLUS, INC. INV# 113811 /PO# 9/24/21 9/24 A20459 CHK: 118922 04151 CLEANING SVCS - SEP 12651 2,490.00 20,507.72 PERFECTION PLUS, INC. INV# 113855 /PO# SEPTEMBER ACTIVITY DB: 6,089.71 CR: 0.00 6,089.71 ------------------------------------------------------------------------------------------------------------------------------------ 4-5600-4520 Buildings & Structures B E G I N N I N G B A L A N C E 130, 600.55 10-13-2021 3:40 PM D E T A I L L I S T I N G PAGE: 3 FUND 211-LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE: Sep-2021 THRU Sep-2021 DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE==== 9/20/21 9/16 A20007 CHK: 118792 04138 HVAC UPGRADES 14338 28,834.87 159,435.42 APEX FACILITY SOLUTIONS, INV# 9 /PO# SEPTEMBER ACTIVITY DB: 28,834.87 CR: 0.00 28,834.87 *-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! ** REPORT TOTALS ** --- DEBITS --- --- CREDITS --- BEGINNING BALANCES: 453,813.07 453,813.07CR REPORTED ACTIVITY: 75,736.35 75,736.35CR ENDING BALANCES: 529,549.42 529,549.42CR TOTAL FUND ENDING BALANCE: 0.00 10-13-2021 3:40 PM D E T A I L L I S T I N G PAGE: 4 SELECTION CRITERIA FISCAL YEAR: Jan-2021 / Dec-2021 FUND: include: 211 PERIOD TO USE: Sep-2021 THRU Sep-2021 TRANSACTIONS: BOTH --------------------------------------------------------------------------------------------------------------- ACCOUNT SELECTION ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ DEPARTMENT RANGE: - THRU - ACTIVE FUNDS ONLY: YES ACTIVE ACCOUNT ONLY: YES INCLUDE RESTRICTED ACCOUNTS: NO DIGIT SELECTION: PRINT OPTIONS DETAIL OMIT ACCOUNTS WITH NO ACTIVITY: YES PRINT ENCUMBRANCES: NO PRINT VENDOR NAME: YES PRINT PROJECTS: NO PRINT JOURNAL ENTRY NOTES: NO PRINT MONTHLY TOTALS: YES PRINT GRAND TOTALS: NO PRINT: INVOICE/PO # PAGE BREAK BY: NONE *** END OF REPORT *** 10-13-2021 03:38 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2021 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 YEAR TO DATE BUDGET PERIOD ACTUAL 75.00% OF YEAR COMP. % OF BUDGET BUDGET BALANCE 106,500.00 0.00 68,947.27 64.74 37.552.7,z 106,500.00 0.00 68,947.27 64.74 37,552.73 116,500.00 33,358.05 226,066.58 194.05 ( 109,566,58) 116,500.00 33,358.05 226,066,58 194.05 ( 109,566,58) 116,500.00 33,358.05 226,066.58 194.05 ( 109,566.58) ( 10,000.00)( 33,358.05)( 157,119.31) 147,119.31 10-13-2021 03:38 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEM13ER 30TH, 2021 211-LIBRARY REVENUES Library CURRENT CURRENT BUDGET PERIOD 75.00% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 211-3-0000-3111 Current Ad Valorem Taxes 71,500.00 0.00 37,529.74 52.49 33,970.26 211-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 195.18 0.00 ( 195.18) TOTAL Taxes 71,500.00 0.00 37,724.92 52.76 33,775.08 Other R cr n•e 211-3-0000-3621 Interest Income 7,000.00 0.00 3,222.35 46.03 3,777.65 TOTAL Other Revenue 7,000.00 0.00 3,222.35 46.03 3,777.65 Transfers In 211-3-0000-3945 Transfer -Utilities 280 0.00 Q.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 Library Project other inan ing Sources TOTAL REVENUE 106,500.00 0.00 68,947.27 64.74 37,552.73 106,500.00 0.00 68,947.27 64.74 37,552.73 10-13-2021 03:38 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2021 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-4331 Travel, Conferences & Schools 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 211-4-5600-4433 Dues & Subscriptions TOTAL Services & Charges Capital Outlay 211-4-5600-4520 Buildings & Structures 211-4-5600-4560 Equipment TOTAL Capital Outlay CURRENT CURRENT BUDGET PERIOD 75.00% OF YEAR COMP. YEAR TO DATE % OF BUDGET ACTUAL BUDGET BALANCE 10.000.00 404.69 2,788,92 27.89 7,211.08 10,000.00 404.69 2,788.92 27.89 7,211.08 1,100.00 93.77 842.84 76.62 257.16 150.00 0.00 0.00 0.00 150.00 500.00 0.00 0.00 0.00 500.00 3,200.00 860.00 3,226.00 100.81 ( 26.00) 30,000.00 ( 2,924.99) 10,955.68 36.52 19,044.32 17,550.00 6,089.71 20,507.72 116.85 ( 2,957.72) 200.00 0.00 0.00 0.00 200.00 30,000.00 0.00 17,430.00 58.10 12,570.00 13,700.00 0.00 10,880.00 79.42 2,820.00 100.00 _ 0 00 9.O0 0.00 l00-00 96,500.00 4,118.49 63,842.24 66.16 32,657.76 0.00 28,834.87 159,435.42 0.00 ( 159,435.42) 10,000.00 0.00 0.00 0.00 10,000.00 10,000.00 28,834.87 159,435.42 1,594.35 ( 149,435.42) TOTAL Library 116,500.00 33,358.05 226,066.58 194.05 ( 109,566.58) TOTAL Culture & Recreation 116,500.00 33,358.05 226,066.58 194.05 ( 109,566.58) TOTAL EXPENDITURES 116,500.00 33,358.05 226,066.58 194.05 ( 109,566.58) REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 33,358.05)( 157,119.31) 147,119.31