3.2 LIBSR 10-27-20202-12-2020 11:49 AM CITY OF ELK RIVER
BALANCE SHEET
AS OF: JANUARY 31ST, 2020
-11-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 415,060.42
TOTAL ASSETS
iIABILITIES
211-2200 Deposits Payable 50.00
TOTAL LIABILITIES
EQUITY
2.11-2400 Fund Balance 430,472.66
TOTAL BEGINNING EQUITY 430,472.66
TOTAL EXPENSES 3,490.32
(WILL CLOSE TO FUND BAL.) ( 11,971.92)
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 15,462.24)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
415,060.42
50.00
415,010.42
PAGE: 1
415,060.42
--------------
--------------
415,060.42
--------------
--------------
3.Z
2-12-2020 11:51 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2020
211 -LIBRARY
FINANCIAL SUMMARY
:REVENUE SUMMARY
Library
'DOTAL REVENUES
EXPENDITURE SUMMARY
:vulture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
FEVENUES OVER/(UNDER) EXPENDITURES
CURRENT
BUDGET
08.33% OF YEAR COMP.
CURRENT YEAR TO DATE % OF BUDGET
PERIOD ACTUAL BUDGET BALANCE
101,500.00
0.00
0.00
0.00
101,500.00
101,500.00
0.00
0.00
0.00
101,500.00
116,000.00
3,490.32
3,490.32 3.01
112,509.68
116,000.00
3,490.32
3,490.32 3.01
112,509.68
116,000.00
3,490.32
3,490.32 3.01
112,509.68
( 14,500.00)(
3,490.32)(
3,490.32) (
11,009.68)
^12-2020 11:51 AM
CITY OF ELK RIVER
PAGE: 2
REVENUE
& EXPENSE REPORT
(UNAUDITED)
AS OF: JANUARY
31ST, 2020
1 -LIBRARY
08.33% OF
YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
:VENUES
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
LbYary
ut s
11-•3-0000-3111 Current Ad Valorem Taxes
66,000.00
0.00
0.00
0.00
66,000.00
TOTAL Taxes
66,000.00
0.00
0.00
0.00
66,000.00
Attrgovernmental Rev
harges for Services
ther Revenue
11--3-0000-3621 Interest Income
7,500.00
0.00
0.00
0.00
7,500.00
TOTAL Other Revenue
7,500.00
0.00
0.00
0.00
7,500.00
ransfers In
11--3-0000-3945 Transfer -Utilities
28,000.00
0.00
0.00
0.00
28,000.00
TOTAL Transfers In
26,000.00
0.00
0.00
0.00
28,000.00
TCiTAL Library
101,500.00
0.00
0.00
0.00
101,500.00
,ibrary Project
)ther Financing Sources
-
:.ansfers In
iOiAL REVENUE
101,500.00
0.00
0.00
0.00
101,500.00
2-12-2020 11:51 AM
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2020
Personal Services
Supplies
211-4-5600-4201 Office Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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 Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
PAGE: 3
08.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
100.00
0.00
0.00
0.00
100.00
8,000.00
56.24
56.24
0.70
7,943.76
8,100.00
56.24
56.24
0.69
8,043.76
1,100.00
92.08
92.08
8.37
1,007.92
650.00
0.00
0.00
0.00
650.00
500.00
0.00
0.00
0.00
500.00
2,800.00
692.00
692.00
24.71
2,108.00
28,250.00
0.00
0.00
0.00
28,250.00
16,550.00
0.00
0.00
0.00
16,550.00
250.00
0.00
0.00
0.00
250.00
30,000.00
2,490.00
2,490.00
8.30
27,510.00
13,200.00
160.00
160.00
1.21
13,040.00
100.00
0.00
0.00
0.00
100.00
93,400.00
3,434.08
3,434.08
3.68
89,965.92
14,500.00
0.00
0.00
0.00
14,500.00
14,500.00
0.00
0.00
0.00
14,500.00
116,000.00
3,490.32
3,490.32
3.01 112,509.68
116,000.00
3,490.32
3,490.32
3.01 112,509.68
116,000.00
3,490.32
3,490.32
3.01 112,509.68
( 14,500.00)(
3,490.32)(
3,490.32)
( 11,009.68)
2-12-2020 11:55 AM D E T A I L L I S T I N G PAGE:
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY TRANSACTION DATE: 1/01/2020 THRU 1/31/2020
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
1/21/20 1/16 A93951 CHK: 113245 03351 SUPPLIES 15887
DACOTAH PAPER CO INV# 26882
JANUARY ACTIVITY DB: 56.24 CR:
ACCOUNT TOTAL DB: 56.24 CR:
---------------------------------------------------------------------------------------
4-5600-4321 Telephone
B E G I N N I N G B A L A N C E
1/23/20 1/24 A94216 CHK: 113370 03370 PHONE LINE CHGS 11102
WINDSTREAM INV# 010720
JANUARY ACTIVITY DB: 92.08 CR:
ACCOUNT TOTAL DB: 92.08 CR:
--------------------------------------------------------------------------------------
4-5600-4361 Insurance
B E G I N N I N G B A L A N C E
1/01/20 1/08 B31542 07195 LMC - PROP/LIAB INS - JAN/MAR JE# 046634
JANUARY ACTIVITY DB: 692.00 CR:
ACCOUNT TOTAL DB: 692.00 CR:
-------------------------------------------------------------------------------
4-5600-4405 Cleaning Services
B E G I N N I N G B A L A N C E
1/21/20 1/16 A93904 CHK: 113303 03351 JAN CLEANING SVCS 12651
PERFECTION PLUS, INC. INV# 113009
JANUARY ACTIVITY DB: 2,490.00 CR:
ACCOUNT TOTAL DB: 2,490.00 CR:
-------------------------------------------------------------------------------
4-5600-4409 Contractual Services
B E G I N N I N G B A L A N C E
1/06/20 1/02 A93389 CHK: 113148 03326 PROGRAM 1/10/20 13060
ROBIN DEEANN SCHAIBLE INV# 011020
1/06/20 1/02 A93390 CHK: 113149 03326 PROGRAM 1/13/20 13060
ROBIN DEEANN SCHAIBLE INV# 011320
56.24
/PO#
0.00 56.24
0.00
92.08
/PO#
0.00 92.08
0.00
692.00
0.00 692.00
0.00
2,490.00
/PO#
0.00 2,490.00
0.00
40.00
/PO#
40.00
/PO#
0.00
56.24
0.00
92.08
0.00
692.00
0.00
2,490.00
0.00
40.00
80.00
2-12-2020 11:55 AM
D E T A I L L
I S T I N G
PAGE:
2
FUND
211 -LIBRARY
ACTIVE
ACCOUNTS ONLY
TRANSACTION DATE:
1/01/2020
THRU 1/31/2020
DEPT
5600 Library
SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE
TRAN # REFERENCE
PACKET======DESCRIPTION=====_= VEND INV/PO/JE
# NOTE =====AMOUNT====
====BALANCE ----
/21/20 1/16
A93918 CHK: 113312
03351 PROGRAM 1/27/20
13060
40.00
120.00
ROBIN DEEANN SCHAIBLE
INV# 012720
/PO#
/21/20 1/16
A93919 CHK: 113313
03351 PROGRAM 2/03/20
13060
40.00
160.00
ROBIN DEEANN SCHAIBLE
INV# 020320
/PO#
------------=
JANUARY ACTIVITY DB:
160.00 CR:
0.00
160.00
ACCOUNT TOTAL DB:
160.00 CR:
0.00
.•�,*_+_*_*_+_+_*_*_*_*_*_
000 ERRORS IN THIS REPORT!
** REPORT TOTALS **
--- DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
0.00
0.00
REPORTED ACTIVITY:
3,490.32
0.00
ENDING BALANCES:
3,490.32
0.00
TOTAL FUND ENDING BALANCE:
3,490.32
2-12-2020 11:55 AM
D E T A I L L I S T I N G
SELECTION CRITERIA
---------------------------------------------------------------------------
FISCAL YEAR: Jan -2019 / Dec -2019
FUND: Include: 211
TRANSACTION DATES: 1/01/2020 THRU 1/31/2020
TRANSACTIONS: BOTH
---------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
.ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
.DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-45??????
•--------------------------------------
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: 3
3-17-2020 10:37 AM CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: FEBRUARY 29TH, 2020
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 396,630.80
211-1380 Interest Receivable 1,957.00
398,587.80
TOTAL ASSETS 398,587.80
LIABILITIES
211-2200 Deposits Payable ( 50.00)
TOTAL LIABILITIES ( 50.00)
EQUITY
211-2400 Fund Balance 430,472.66
TOTAL BEGINNING EQUITY 430,472.66
TOTAL EXPENSES 22,054.04
(WILL CLOSE TO FUND BAL.) ( 9,780.82)
TOTAL REVENUE OVER/(UNDER) EXPENSES ( 31,834.86)
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 398,637.80
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 398,587.80
--------------
--------------
3-17-2020 10:44 AM
D E T A I L L I S T
I N G
PAGE: 1
FUND 211
-LIBRARY
PERIOD TO USE:
Feb -2020 THRU
Feb -2020
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
56.24
2/03/20 1/30 A94471
CHK: 113372
03382 SUPPLIES
13973
202.66
258.90
1000 BULBS INV#
W01998616
/PO#
2/18/20 2/13 A95130
CHK: 113600
03402 SUPPLIES
15887
1,422.98
1,681.88
DACOTAH PAPER CO INV#
40611
/PO#
FEBRUARY ACTIVITY DB: 1,625.64
CR:
0.00
1,625.64
-•-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N C E
92.08
2/18/20 2/13 A95015
CHK: 113698
03402 PHONE LINE CHGS
11102
92.40
184.48
WINDSTREAM INV#
020720
/PO#
FEBRUARY ACTIVITY DB:
92.40 CR:
0.00
92.40
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N C E
0.00
2/03/20 1/30 A94514
EFT: 000814
03382 WATER/ELECTRIC
17700
2,854.69
2,854.69
ELK RIVER MUNICIPAL UTILI INV#
011520
/PO#
2/03/20 1/30 A94556
EFT: 000817
03382 JAN RUBBISH SVCS
30851
61.25
2,915.94
RANDY'S ENVIRONMENTAL SER INV#
135818-011720
/PO#
FEBRUARY ACTIVITY DB: 2,915.94
CR:
0.00
2,915.94
------------------------------------------------------------------------------------------------------------------------------------
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
.2/03/20 1/30 A94345
CHK: 113375
03382 REPAIR LIGHTING BALLASTS
10373
519.74
519.74
AID ELECTRIC CORPORATION INV#
61136
/PO#
2/03/20 1/30 A94567
CHK: 113475
03382 ANNUAL FIRE ALARM INSPEC
33444
235.00
754.74
SUMMIT COMPANIES INV#
1471011
/PO#
2/03/20 1/30 A94573
CHK: 113475
03382 ANNUAL FIRE SPRINKLER IN
33444
200.00
954.74
SUMMIT COMPANIES INV#
1472532
/PO#
2/18/20 2/13 A95146
CHK: 113603
03402 EXTERIOR WINDOW CLNG
16448
205.00
1,159.74
DISTINCTIVE WINDOW CLEANI INV#
16827
/PO#
FEBRUARY ACTIVITY DB: 1,159.74
CR:
0.00
1,159.74
-------------------------------------------------------------------------------------------------------------------------------------
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-17-2020 10:44 AM
D E T A I L L I
S T I
N G
PAGE:
2
FUND
211-LIBRARY
PERIOD TO USE: Feb-2020 THRU Feb-2020
DEPT
5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE
TRAN #
REFERENCE
PACKET======DESCRIPTION=====_=
VEND INV/PO/JE
# NOTE ====-AMOUNT==== ====BALANCE====
:/18/20 2/13
A95072
CHK: 113663
03402 FEB CLEANING SVCS
12651
2,490.00
4,980.00
PERFECTION PLUS, INC.
INV#
113043
/PO#
------------=
FEBRUARY 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
160.00
°/03/20 1/30
A94438
CHK: 113466
03382 PROGRAM 2/07/20
13060
40.00
200.00
ROBIN DEEANN SCHAIBLE
INV#
020720
/PO#
?/03/20 1/30
A94439
CHK: 113467
03382 PROGRAM FEE 2/10/20
13060
40.00
240.00
ROBIN DEEANN SCHAIBLE
INV#
021020
/PO#
?/03/20 1/30
A94526
CHK: 113414
03382 ADDL OPEN HOURS
20400
10,200.00
10,440.00
GREAT RIVER REGIONAL LIBR
INV#
11720-1
/PO#
_'/1.8/20 2/13
A95093
CHK: 113671
03402 PROGRAM 02/24/20
13060
40.00
10,480.00
ROBIN DEEANN SCHAIBLE
INV#
022420
/PO#
2/28/20 2/28
A95907
VOID: 113312
03429 REVERSE VOIDED CHECK
13060
40.000R
10,440.00
ROBIN DEEANN SCHAIBLE
INV#
012720
/PO#
_____________
FEBRUARY ACTIVITY DB:
10,320.00 CR:
40.000R
10,280.00
��--*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS **
---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
3,490.32
0.00
REPORTED ACTIVITY:
18,603.72
40.000R
ENDING BALANCES:
22,094.04
40.000R
TOTAL FUND ENDING BALANCE:
22,054.04
3-17-2020 10:44 AM
D E T A I L L I S T I N G
SELECTION CRITERIA
---------------------------------------------------------------------------
FISCAL YEAR: Jan -2019 / Dec -2019
FUND: Include: 211
PERIOD TO USE: Feb -2020 THRU Feb -2020
TRANSACTIONS: BOTH
---------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: YES
.ACTIVE ACCOUNT ONLY: NO
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4-????-45??????
----------------------------------------------------
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: 3
3-17-2020 10:40 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: FEBRUARY 29TH, 2020
211 -LIBRARY
FINANCIAL SUMMARY 16.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Library 105,100.00 0.00 0.00 0.00 105,100.00
TOTAL REVENUES 105,100.00 0.00 0.00 0.00 105,100.00
3EXPENDITURE SUMMARY
Culture & Recreation
Library 115,100.00 18,563.72 22,054.04 19.16 93,045.96
TOTAL Culture & Recreation 115,100.00 18,563.72 22,054.04 19.16 93,045.96
TOTAL EXPENDITURES 115,100.00 18,563.72 22,054.04 19.16 93,045.96
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 18,563.72)( 22,054.04) 12,054.04
--7-2020 10:40 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: FEBRUARY 29TH, 2020
_-LIBRARY
ibrary
axes
11-•3-0000-3111 Current Ad Valorem Taxes
TOTAL Taxes
ntE�rgovernmental Rev
harges for Services
thnr Revenue
11•-3-0000-3621 Interest Income
TOTAL Other Revenue
r?nsfers In
11-3-0000-3945 Transfer -Utilities
'TOTAL Transfers In
TOTAL Library
ibrary Project
)ther Financing Sources
ransfers In
16.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
RnnrF.T PERIOD ACTUAL BUDGET BALANCE
69,000.00 0.00 0.00 0.00 69,000.00
69,000.00 0.00 0.00 0.00 69,000.00
8,100.00
0.00
0.00
0.00
8,100.00
8,100.00
0.00
0.00
0.00
8,100.00
28,000.00
0.00
0.00
0.00
28,000.00
28,000.00
0.00
0.00
0.00
28,000.00
105,100.00
0.00
0.00
0.00
105,100.00
DOTAL REVENUE 105,100.00 0.00 0.00 0.00 105,100.00
3-17-2020 10:40 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: FEBRUARY 29TH, 2020
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
.211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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 Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
CURRENT
BUDGET
16.67% OF YEAR COMP.
CURRENT YEAR TO DATE % OF BUDGET
PERIOD ACTUAL BUDGET BALANCE
8,500.00
1,625.64
1,681.88
19.79
6,818.12
8,500.00
1,625.64
1,681.88
19.79
6,818.12
1,100.00
92.40
184.48
16.77
915.52
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,000.00
0.00
692.00
23.07
2,308.00
30,700.00
2,915.94
2,915.94
9.50
27,784.06
17,150.00
1,159.74
1,159.74
6.76
15,990.26
200.00
0.00
0.00
0.00
200.00
30,000.00
2,490.00
4,980.00
16.60
25,020.00
13,700.00
10,280.00
10,440.00
76.20
3,260.00
100.00
0.00
0.00
0.00
100.00
96,600.00
16,938.08
20,372.16
21.09
76,227.84
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
115,100.00
18,563.72
22,054.04 19.16
93,045.96
TOTAL Culture & Recreation
115,100.00
18,563.72
22,054.04 19.16
93,045.96
TOTAL EXPENDITURES
115,100.00
18,563.72
22,054.04 19.16
93,045.96
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
18,563.72)(
22,054.04)
12,054.04
4-09-2020 04:23 PM
CITY OF ELK RIVER
PAGE: i
BALANCE
SHEET
AS OF: MARCH
31ST, 2020
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
BALANCE
ASSETS
211-1010 Cash - Library
415,454.72
211-1380 Interest Receivable
1,957.00
417,411.72
TOTAL ASSETS
417,411.72
LIABILITIES
--------------
--------------
211-2200 Deposits Payable
(
50.00)
TOTAL LIABILITIES
(
50.00)
EQUITY
211-2400 Fund Balance
420,691.84
TOTAL BEGINNING EQUITY
420,691.84
TOTAL REVENUE
28,000.00
TOTAL EXPENSES
31,230.12
TOTAL REVENUE OVER/(UNDER)
EXPENSES (
3,230.12)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
417,461.72
TOTAL LIABILITIES, EQUITY &
REV.OVER/(UNDER)
EXP.
--------------
--------------
417,411.72
4-09-2020 4:28 PM
D E T A I L L I
S T I N G
PAGE: 1
FUND 211-LIBRARY
PERIOD TO USE:
Mar-2020 THRU
Mar-2020
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
1,681.88
3/16/20 3/12 A96101
CHK: 113994
03431 BULK SALT
13048
176.40
1,858.28
STEP SAVER INC
INV# 135612
/PO#
-------------
MARCH ACTIVITY DB:
176.40
CR:
0.00
176.40
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N
C E
184.48
3/20/20 3/20 A96521
CHK: 114032
03443 PHONE LINE CHGS
11102
92.42
276.90
WINDSTREAM
INV# 030620
/PO#
-------------
MARCH ACTIVITY DB:
92.42
CR:
0.00
92.42
-------------------------------------------------------------------------------------------------------------------------------------
4-5600-4361
Insurance
B
E G I N N I N G B A L A N
C E
692.00
3/16/20 3/12 A96247
CHK: 113943
03431 LIABILITY INS - APR/JUN 23805
692.00
1,384.00
LEAGUE OF MN CITIES INS T
INV# 40002926-030420
/PO#
MARCH ACTIVITY DB:
692.00
CR:
0.00
692.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N
C E
2,915.94
3/02/20 2/27 A95711
EFT: 000832
03417 WATER/ELECTRIC
17700
2,593.73
5,509.67
ELK RIVER MUNICIPAL UTILI
INV# 021220
/PO#
3/02/20 2/27 A95748
EFT: 000834
03417 FEB RUBBISH SVCS
30851
61.25
5,570.92
RANDY'S ENVIRONMENTAL SER
INV# 135818-021920
/PO#
3/27/20 3/27 A96607
EFT: 000850
03447 WATER/ELECTRIC
17700
2,559.28
8,130.20
ELK RIVER MUNICIPAL UTILI
INV# 031120
/PO#
MARCH ACTIVITY DB:
5,214.26
CR:
0.00
5,214.26
------------------------------------------------------------------------------------------------------------------------------------
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
3/02/20 2/27 A95519
CHK: 113735
03417 ELECTRICAL SVCS
10373
231.00
231.00
AID ELECTRIC CORPORATION
INV# 61436
/PO#
MARCH ACTIVITY DB:
231.00
CR:
0.00
231.00
4-09-2020 4:28
PM
D E T A I L L I
S T I
N G
PAGE:
2
FUND
211 -LIBRARY
PERIOD TO USE: Mar -2020 THRU Mar -2020
DEPT
5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST
DATE
TRAN #
REFERENCE
PACKET======DESCRIPTION=====_=
VEND INV/PO/JE
# NOTE =====AMOUNT==== ====BALANCE====
__-•--------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N
C E
4,980.00
X6/20
3/12
A96077
CHK:
113969
03431 CLEANING SVCS - MAR
12651
2,490.00
7,470.00
PERFECTION PLUS, INC.
INV#
113078
/PO#
MARCH 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, 440.00
3106/20
3/06
A95917
CHK:
113847
03430 PROGRAM 03/02/20
13060
40.00
10,480.00
ROBIN DEEANN SCHAIBLE
INV#
030220
/PO#
3106/20
3/06
A95918
CHK:
113848
03430 PROGRAM 03/09/20
13060
40.00
10,520.00
ROBIN DEEANN SCHAIBLE
INV#
030920
/PO#
31[)6/20
3/06
A95919
CHK:
113849
03430 PROGRAM 03/16/20
13060
40.00
10,560.00
ROBIN DEEANN SCHAIBLE
INV#
031620
/PO#
3/16/20
3/12
A96104
CHK:
113983
03431 PROGRAM 03/23/20
13060
40.00
10,600.00
ROBIN DEEANN SCHAIBLE
INV#
032320
/PO#
3!16/20
3/12
A96105
CNK:
113984
03431 PROGRAM 03/30/20
13060
40.00
10,640.00
ROBIN DEEANN SCHAIBLE
INV#
033020
/PO#
:)/16/20
3/12
A96106
CHK:
113985
03431 PROGRAM 04/03/20
13060
40.00
10,680.00
ROBIN DEEANN SCHAIBLE
INV#
040320
/PO#
�i16/20
3/12
A96107
CHK:
113986
03431 PROGRAM 04/06/20
13060
40.00
10,720.00
ROBIN DEEANN SCHAIBLE
INV#
040620
/PO#
MARCH ACTIVITY DB:
280.00 CR:
0.00
280.00
-'-*-*-*-*-*-*-*-*-*-*-*-
000 ERRORS IN THIS REPORT!
** REPORT TOTALS **
---
DEBITS ---
--- CREDITS ---
BEGINNING BALANCES:
22,054.04
0.00
REPORTED ACTIVITY:
9,176.08
0.00
ENDING BALANCES:
31,230.12
0.00
TOTAL FUND ENDING BALANCE:
31,230.12
4-09-2020 4:28 PM
D E T A I L L I S T I N G
SELECTION CRITERIA
-------------------------------------------------
FISCAL YEAR: Jan -2020 / Dec -2020
FUND: Include: 211
PERIOD TO USE: Mar -2020 THRU Mar -2020
TRANSACTIONS: BOTH
----------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: YES
ACTIVE ACCOUNT ONLY: NO
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-95??????
-----------------------------------------------------
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: 3
4-09-2020 04:25 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2020
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
25.00% OF YEAR COMP,
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
105,100.00
0.00
28,000.00
26.64
77,100.00
105,100.00
0.00
28,000.00
26.64
77,100.00
115,100.00
9,176.08
31,230.12 27.13
83,869.88
115,100.00
9,176.08
31,230.12 27.13
83,869.88
115,100.00
9,176.08
31,230.12 27.13
83,869.88
( 10,000.00)(
9,176.08)(
3,230.12) (
6,769.88)
-09-2020 04.25 PM
CITY OF ELK
RIVER
PAGE: 2
REVENUE
& EXPENSE REPORT
(UNAUDITED)
AS OF: MARCH
31ST, 2020
I -LIBRARY
25.00% OF
YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
VENUES
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
brary
txe s
.1-3-0000-3111 Current Ad Valorem Taxes
69,000.00
0.00
0.00
0.00
69,000.00
69,000.00
0.00
0.00
0.00
69,000.00
TOTAL Taxes
:tergovernmental Rev
larges for Services
_her Revenue
11-3-0000-3621 Interest Income
8,100.00
0.00
0.00
0.00
8,100.00
TOTAL Other Revenue
8,100.00
0.00
0.00
0.00
8,100.00
ransfers in
11-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
105,100.00
0.00
28,000.00
26.64
77,100.00
i':,rary Project
--------------
,iher Financing Sources
'ransfers In
:OTAL REVENUE
105,100.00
0.00
26,000.00
26.64
77,100.00
4-09-2020 04:25 PM
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2020
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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
111-4-5600-4409 Contractual Services
211-4-5600-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
PAGE: 3
25.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
8,500.00
176.40
1,858.28
21.86
6,641.72
8,500.00
176.40
1,858.28
21.86
6,641.72
1,100.00
92.42
276.90
25.17
823.10
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,000.00
692.00
1,384.00
46.13
1,616.00
30,700.00
5,214.26
8,130.20
26.48
22,569.80
17,150.00
0.00
1,159.74
6.76
15,990.26
200.00
231.00
231.00
115.50 (
31.00)
30,000.00
2,490.00
7,470.00
24.90
22,530.00
13,700.00
280.00
10,720.00
78.25
2,980.00
100.00
0.00
0.00
0.00
100.00
96,600.00
8,999.68
29,371.84
30.41
67,228.16
10,000.00
0.00
0.00
0.00
10,000.00
10,000.00
0.00
0.00
0.00
10,000.00
115,100.00
9,176.08
31,230.12 27.13
83,869.88
115,100.00
9,176.08
31,230.12 27.13
83,869.88
115,100.00
9,176.08
31,230.12 27.13
83,869.88
( 10,000.00)(
9,176.08)(
3,230.12) (
6,769.88)
10-15-2020 10:42 AM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: APRIL 30TH, 2020
BALANCE
414,320.37
1,957.00
416,277.37
TOTAL ASSETS
LIABILITIES
211-2020 A/P - Library
50.00
.211-2200 Deposits Payable (
50.00)
!EQUITY
:211-2400 Fund Balance
420,691.84
TOTAL BEGINNING EQUITY
420,691.84
TOTAL REVENUE
31,256.02
TOTAL, EXPENSES
35,670.49
TOTAL REVENUE OVER/(UNDER) EXPENSES (
4,414.47)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
416,277.37
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER)
EXP.
416,277.37
--------------
--------------
416,277.37
10-15-2020 11:08 AM D E T A I L L I S T I N G
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
PAGE: 1
Apr -2020 THRU
Apr -2020
DEPT 5600 Library SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE
# NOTE
=====AMOUNT====
====BALANCE====
-------------------------------------------------------------------------
9-5600-9219 Operating Supplies
B E G I N N I N G B ALAN C E
1,858.28
4/06/20 4/02 A96756 CHK: 114072 03448 SUPPLIES 11835
11.88
1,870.16
BATTERIES PLUS BULBS INV# P24893964
/PO#
4/20/20 4/16 A97529 CHK: 114280 03463 SUPPLIES 17890
199.54
2,069.70
ELK RIVER WINLECTRIC INV# 31137301
/PO#
APRIL ACTIVITY DB: 206.42 CR:
0.00
206.42
----------------------------------------------------------------------------------
4-5600-4321 Telephone
B E G I N N I N G B A L A N C E
276.90
4/20/20 4/16 A97409 CHK: 114329 03463 PHONE LINE CHGS 11102
92.70
369.60
WINDSTREAM INV# 040720
/PO#
APRIL ACTIVITY DB: 92.70 CR:
0.00
92.70
--------------------------------------------------------------------
-5600-9389 Utilities
---------------
B E G I N N I N G B ALA N C E
8,130.20
4/06/20 4/02 A97009 EFT: 000867 03448 MAR RUBBISH SVCS 30851
61.25
8,191.95
RANDY'S ENVIRONMENTAL SER INV# 135818-031920
/PO#
APRIL ACTIVITY DB: 61.25 CR:
0.00
61.25
------------------------------------------------------------------------------------
4-5600-4405 Cleaning Services
B E G I N N I N G B A L A N C E
7,470.00
4/20/20 4/16 A97443 CHK: 114311 03463 CLEANING SVCS - APR 12651
2,490.00
9,960.00
PERFECTION PLUS, INC. INV# 113106
/PO#
APRIL 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 ALAN C E
10, 720.00
4/16/20 4/16 A97733 VOID: 113983 03473 REVERSE VOIDED CHECK 13060
90.00CR
10,680.00
ROBIN DEEANN SCHAIBLE INV# 032320
/PO#
4/16/20 4/16 A97734 VOID: 113984 03473 REVERSE VOIDED CHECK 13060
40.00CR
10,640.00
ROBIN DEEANN SCHAIBLE INV# 033020
/P0#
4/16/20 4/16 A97735 VOID: 113985 03473 REVERSE VOIDED CHECK 13060
40.00CR
10,600.00
ROBIN DEEANN SCHAIBLE INV# 040320
/PO#
4/16/20 4/16 A97736 VOID: 113986 03473 REVERSE VOIDED CHECK 13060
40.00CR
10,560.00
ROBIN DEEANN SCHAIBLE INV# 040620
/PO#
APRIL ACTIVITY DB: 0.00 CR:
160.00OR
160.00CR
10-15-2020 11:08 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: Apr -2020 THRU Apr -2020
SUPPRESS ZEROS ACCOUNTS: ALL
DEPT 5600 Library
=====AMOUNT== ====BALANCE====
'OST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE
-------------------------------------------------------- ------------------------------------------------------------------------
4-5600-4560 Equipment
0.00
B E G I N N I N G B A L A N C E
120/20 4/16 A97393 CHK: 114271 03463 REUPHOLSTER LOUNGE CHAIR 10299
1,750.00 1,750.00
COLBATH UPHOLSTERY SERVIC INV# 33981 /PO#
APRIL ACTIVITY DB: 1,750.00 CR: 0.00 1,750.00
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 31,230.12 0.00
REPORTED ACTIVITY: 4,600.37 160.00OR
ENDING BALANCES: 35,830.49 160.00OR
TOTAL FUND ENDING BALANCE: 35,670.49
10-15-22020 11:08 AM D E T A I L L I S T I N G
PAGE: 3
SELECTION CRITERIA
---------------------------------------------------------------------------------------------
FISCAL YEAR: Jan -2020 / Dec -2020
FUND: Include: 211
PERIOD TO USE: Apr -2020 THRU Apr -2020
TRANSACTIONS: BOTH
--------------------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-45??????
------------------------------------------------------------
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-15-2020 10:54 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2020
211 -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
:vulture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
33.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
105,100.00
881.58
31,256.02
29.74
73,843.98
105,100.00
881.58
31,256.02
29.74
73,843.98
115,100.00
4,440.37
35,670.49 30.99
79,429.51
115,100.00
4,440.37
35,670.49 30.99
79,429.51
115,100.00
4,440.37
35,670.49 30.99
79,429.51
( 10,000.00)(
3,558.79)(
4,414.47) (
5,585.53)
-15-2020 10:54 AM
CITY OF ELK
RIVER
PAGE: 2
REVENUE
& EXPENSE REPORT (UNAUDITED)
AS OF: APRIL
30TH, 2020
I -LIBRARY
33.33%
OF YEAR COMP,
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
:VENUES
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
_brary
eyes
1i-•3-0000-3111 Current Ad Valorem Taxes
69,000.00
0.00
0.00
0.00
69,000.00
TOTAL Taxes
69,000.00
0.00
0.00
0.00
69,000.00
-itargovernmental Rev
zarges for Services
Cher Revenue
11••3-0000-3621 Interest Income
8,100.00
881.58
3,256.02
40.20
4,843.98
TOTAL Other Revenue
8,100.00
881.58
3,256.02
40.20
4,843.98
ransfers In
11-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
105,100.00
881.58
31,256.02
29.74
73,843.98
ibrary Project
-rher Financing Sources
'ransfers In
_
'OTAL REVENUE 105,100.00 881.58 31,256.02 29.74 73,843.98
10-15-2020 10:54 AM CITY OF ELK RIVER PAGE• 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2020
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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 Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
33.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
8,500.00
206.42
2,064.70
24.29
6,435.30
8,500.00
206.42
2,064.70
24.29
6,435.30
1,100.00
92.70
369.60
33.60
730.40
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,000.00
0.00
1,384.00
46.13
1,616.00
30,700.00
61.25
8,191.45
26.68
22,508.55
17,150.00
0.00
1,159.74
6.76
15,990.26
200.00
0.00
231.00
115.50 (
31.00)
30,000.00
2,490.00
9,960.00
33.20
20,040.00
13,700.00 (
160.00)
10,560.00
77.08
3,140.00
100.00
0.00
0.00
0.00
100.00
96,600.00
2,483.95
31,855.79
32.98
64,744.21
10,000.00
1,750.00
1,750.00
17.50
8,250.00
10,000.00
1,750.00
1,750.00
17.50
8,250.00
TOTAL Library
115,100.00
4,440.37
35,670.49 30.99
79,429.51
TOTAL Culture & Recreation
115,100.00
4,440.37
35,670.49 30.99
79,429.51
TOTAL EXPENDITURES
115,100.00
4,440.37
35,670.49 30.99
79,429.51
REVENUES OVER/(UNDER) EXPENDITURES
( 10,000.00)(
3,558.79)(
4,414.47) (
5,585.53)
10-15-2020 10:43 AM
CITY OF ELK RIVER
PAGE: 1
BALANCE
SHEET
AS OF: MAY
31ST, 2020
211-LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
BALANCE
ASSETS
211-1010 Cash - Library
408,096.93
211-1380 Interest Receivable
1,957.00
410,053.93
TOTAL ASSETS
410,053.93
LIABILITIES
--------
211-2200 Deposits Payable
(
50.00)
TOTAL LIABILITIES
EQUITY
(
50.00)
211-2400 Fund Balance
420,691.84
TOTAL BEGINNING EQUITY
420,691.84
TOTAL REVENUE
31,587.67
TOTAL EXPENSES
42,175.58
TOTAL REVENUE OVER/(UNDER)
EXPENSES (
10,587.91)
TOTAL EQUITY & REV. OVER/(UNDER)
EXP.
410,103.93
TOTAL LIABILITIES, EQUITY &
REV.OVER/(UNDER)
EXP.
410,053.93
10-15-2020 11:11 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:
May -2020 THRU
May -2020
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
2,064.70
5/18/20 5/14 A98428
CHK: 114465
03500 SUPPLIES - LUTRON REPLAC 17890
1,599.93
3,664.63
ELK RIVER WINLECTRIC INV# 31382300
/PO#
MAY ACTIVITY DB: 1,599.93 CR:
0.00
1,599.93
_.-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N C E
369.60
5/18/20 5/14 A98295
CHK: 114529
03500 PHONE LINE CHGS 11102
95.57
465.17
WINDSTREAM INV# 050620
/PO#
MAY ACTIVITY DB: 95.57 CR:
0.00
95.57
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4389
Utilities
B
E G I N N I N G B A L A N C E
8,191.45
5/04/20 4/30 A97984
EFT: 000920
03484 WATER/ELECTRIC 17700
1,918.94
10,110.39
ELK RIVER MUNICIPAL UTILI INV# 041520
/PO#
5/04/20 4/30 A98041
EFT: 000922
03484 APR RUBBISH SVCS 30851
61.25
10,171.64
RANDY'S ENVIRONMENTAL SER INV# 135818-041720
/PO#
MAY ACTIVITY DB: 1,980.19 CR:
0.00
1,980.19
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N C E
1,159.74
5/04/20 4/30 A97864
EFT: 000908
03484 ELECTRICAL SVCS -REPLACE 10373
110.50
1,270.24
AID ELECTRIC CORPORATION INV# 62042
/PO#
5/04/20 4/30 A97969
CHK: 114371
03484 EXTERIOR WINDOW CLNG 16448
205.00
1,475.24
DISTINCTIVE WINDOW CLEANI INV# 17399
/PO#
5/16/20 5/14 A98323
CHK: 114510
03500 FIRE EXTINGUISHER SVCS 11955
23.90
1,499.14
RICHFIELD FIRE EXTINGUISH INV# 120368
/PO#
MAY ACTIVITY DB: 339.40 CR:
0.00
339.40
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4405
Cleaning Services
B
E G I N N I N G B A L A N C E
91960.00
5/18/20 5/14 A98346
CHK: 114503
03500 CLEANING SVCS - MAY 12651
2,490.00
12,450.00
PERFECTION PLUS, INC. INV# 113143
/PO#
MAY ACTIVITY DB: 2,490.00 CR:
0.00
2,490.00
10-15-2020 11:11 AM D E T A I L L I S T I N G
FUND 211 -LIBRARY ACTIVE ACCOUNTS ONLY PERIOD TO USE:
DEPT 5600 Library SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION======= VEND INV/PO/JE # NOTE
--•*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT!
PAGE: 2
May -2020 THRU May -2020
=====AMOUNT==== ====BALANCE====
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 35,670.49 0.00
REPORTED ACTIVITY: 6,505.09 0.00
ENDING BALANCES: 42,175.58 0.00
TOTAL FUND ENDING BALANCE: 42,175.58
10-15-2020 11:11 AM D E T A I L L I S T I N G PAGE: 3
SELECTION CRITERIA
--------------------------------------------
FISCAL YEAR: Jan -2020 / Dec -2020
FUND: Include: 211
PERIOD TO USE: May -2020 THRU May -2020
TRANSACTIONS: BOTH
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
.ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-45??????
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-15-2020 10:55 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2020
211 -LIBRARY
FINANCIAL SUMMARY
41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Library 105,100.00 331.65 31,587.67 30.05 73,512.33
TOTAL REVENUES 105,100.00 331.65 31,587.67 30.05 73,512.33
EXPENDITURE SUMMARY
Culture & Recreation
Library 115,100.00 6,505.09 42,175.58 36.64 72,924.42
TOTAL Culture & Recreation 115,100.00 6,505.09 42,175.58 36.64 72,924.42
TOTAL EXPENDITURES 115,100.00 6,505.09 42,175.58 36.64 72,924.42
REVENUES OVER/(UNDER) EXPENDITURES ( 10,000.00)( 6,173.44)( 10,587.91) 587.91
-15-2020 10:55 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2020
I -LIBRARY
41.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
VEIVUES BUDGET PERIOD ACTUAL BUDGET BALANCE
brary
Lxa s
.1-3-0000-3111 Current Ad Valorem Taxes
69,000.00
0.00
0.00
0.00
69,000.00
69,000.00
0.00
0.00
0.00
69,000.00
TOTAL Taxes
ite:rgovernmental Rev
Larges for Services
rhea Revenue
11-3-0000-3621 Interest Income
8,100.00
331.65
3,587.67
44.29
4,512.33
TOTAL Other Revenue
8,100.00
331.65
3,587.67
44.29
4,512.33
ransfers In
11•-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
105,100.00
331.65
31,587.67
30.05
73,512.33
,ibrary Project
)rner Financing Sources
'ransfers In
roTAL REVENUE 105,100.00 331.65 31,587.67 30.05 73,512.33
10-15-2020 10:55 AM CITY OF ELK RIVER PAGE• 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MAY 31ST, 2020
211 -LIBRARY
Culture & Recreation
Library 41.67% OF YEAR COMP,
CURRENT CURRENT YEAR TO DATE % OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
8,500.00
1,599.93
3,664.63
43.11
4,835.37
TOTAL Supplies
8,500.00
1,599.93
3,664.63
43.11
4,835.37
Other Services & Charges
211-4-5600-4321 Telephone
1,100.00
95.57
465.17
42.29
634.83
211-4-5600-4331 Travel, Conferences & Schools
150.00
0.00
0.00
0.00
211-4-5600-4359 Publishing
500.00
0.00
150.00
211-4-5600-4361 Insurance
3,000.00
0.00
0.00
0.00
500.00
1,384.00
46.13
1,616.00
211-4-5600-4389 Utilities
30,700.00
1,980.19
10,171.64
33.13
20,528.36
211-4-5600-4401 Bldg Repair/Maint Services
17,150.D0
339.40
1,499.14
8.74
15,650.86
211-4-5600-4404 Equip Repair/Maint Services
200.00
0.00
231.00
115.50
211-4-5600-4405 Cleaning Services
30,000.00
2,490.00
12,450.00
(
41.50
31.00)
17,550.00
211-4-5600-4409 Contractual Services
13,700.00
0.00
10,560.00
77.08
3,140.00
211-4-5600-4433 Dues & Subscriptions
100.00
0.00
0.00
0.00
TOTAL Other Services & Charges
96,600.00
4,905.16
36,760.95
38.05
100.00
59,839.05
Capital Outlay
211-4-5600-4560 Equipment
10,000.00
0.00
1,750.00
17.50
8,250.00
TOTAL Capital Outlay
10,000.00
0.00
1,750.00
17.50
8,250.00
='ransfers Out
TOTAL Library
115,100.00
6,505.09
42,175.58
36.64
72,924.42
TOTAL Culture & Recreation
115,100.00
6,505.09
42,175.58
36.64
72,924.42
TOTAL EXPENDITURES
115,100.00
6,505.09
42,175.58
36.64
72,924.42
REVENUES OVER/(UNDER) EXPENDITURES (
10,000.00)(
6,173.44)(
10,587.91)
587.91
10-15-2020 10:44 AM
:211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
:211-1010 Cash - Library
:211-1380 Interest Receivable
CITY OF ELK RIVER PAGE: 1
BALANCE SHEET
AS OF: JUNE 30TH, 2020
BALANCE
424,360.56
1,957.00
426,317.56
TOTAL ASSETS
:LIABILITIES
211-2200 Deposits Payable ( 50.00)
TOTAL LIABILITIES ( 50.00)
EQUITY
211-2400 Fund Balance 420,691.84
TOTAL BEGINNING EQUITY 420,691.84
TOTAL REVENUE 55,769.01
TOTAL EXPENSES 50,093.29
TOTAL REVENUE OVER/(UNDER) EXPENSES 5,675.72
TOTAL EQUITY & REV. OVER/(UNDER) EXP. 426,367.56
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
426,317.56
--------------
--------------
426,317.56
--------------
--------------
10-15-2020 11:12 AM
D E T A I L L I S T I N G
PAGE: 1
FUND 211 -LIBRARY
DEPT 5600 Library
ACTIVE ACCOUNTS ONLY
SUPPRESS ZEROS
PERIOD TO USE:
ACCOUNTS: ALL
Jun -2020 THRU
Jun -2020
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
3,664.63
6/01/20 5/27 A98880 CHK: 114608
03519 BULK SALT - LIBRARY 13048
170.80
3,835.43
STEP SAVER INC INV# 137243
/PO#
6/01/20 5/27 A98940 CHK: 114569
03519 SUPPLIES 17890
15.96
3,851.39
ELK RIVER WINLECTRIC INV# 31382100
/PO#
6/15/20 6/10 A99432 CHK: 114669
03536 SUPPLIES 17890
77.88
3,929.27
ELK RIVER WINLECTRIC INV# 31504500
/PO#
6/15/20 6/10 A99446 EFT: 001032
03536 SUPPLIES 20300
357.60
4,286.87
GRAINGER INV# 9539885849
/PO#
6/24/20 6/24 A99839 CHK: 114759
03549 DAP ULTRA CLR,VINYL FLRI 21600
22.96
4,309.83
HOME DEPOT CREDIT SERVICE INV# 1025781
/PO#
JUNE ACTIVITY DB: 645.20 CR:
0.00
645.20
4-5600-4321 Telephone
-------------------------------------------------------------------------------------
B E G I N N I N G B A L A N C E
465.17
6/15/20 6/10 A99279 CHK: 114737
03536 PHONE LINE CHGS 11102
93.10
558.27
WINDSTREAM INV# 060820
/PO#
JUNE ACTIVITY DB: 93.10 CR:
0.00
93.10
4-5600-4361 Insurance
-------------------------------------------------------------------------------------
B E
G I N N I N G B A L A N C E
1, 384.00
6/15/20 6/10 A99481 CHK: 114687
03536 INSURANCE ALLOCATION 23805
753.00
2,137.00
LEAGUE OF MN CITIES INS T INV# 40002926-060420
/PO#
JUNE ACTIVITY DB: 753.00 CR:
0.00
753.00
4-5600-4389 Utilities
------------------------------------------------------------------------------------
B E
G I N N I N G B A L A N C E
10, 171.64
6/01/20 5/27 A98938 EFT: 000990
03519 WATER/ELECTRIC 17700
1,546.37
11,718.01
ELK RIVER MUNICIPAL UTILI INV# 051320
/PO#
6/01/20 5/27 A98989 EFT: 000992
03519 MAY RUBBISH SVCS 30851
61.26
11,779.27
RANDY'S ENVIRONMENTAL SER INV# 135818-051920
/PO#
6/24/20 6/24 A99835 EFT: 001057
03549 WATER/ELECTRIC 17700
1,728.92
13,508.19
ELK RIVER MUNICIPAL UTILI INV# 061020
/PO#
JUNE ACTIVITY DB: 3,336.55 CR:
0.00
3,336.55
10-15-2020 11:12 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:
Jun -2020 THRU Jun -2020
DEPT 5600 Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE TRAN # REFERENCE
PACKET======DESCRIPTION===-=_= VEND INV/PO/JE
# NOTE
=====AMOUNT====
====BALANCE===-
===BALANCE===-----------------------------------------------------------------------------------
---------------------------- ------------------------------------------------------------------------------------------------------
4-5600-4401 Bldg Repair/Maint
4-5600-4401
Services
1,499.14
B
E G I N N I N G B A L A N C E
105/20 6/05 A99161 CHK: 114635
03532 MOWING SVCS CONTRACT -LIB 11661
524.86
2,024.00
SPEEDCUTTERS OUTDOOR MAIN INV# 12225
/PO#
/15/20 6/10 A99403 CHK: 114664
03536 PEST CONTROL - LIBRARY 15191
75.00
2,099.00
RICHARD J MORGAN INV# 10002
/PO#
JUNE ACTIVITY DB: 599.86 CR:
0.00
599.86
----------------------------------------------------------------------------------
4-5600-4405 Cleaning Services
12, 450.00
B
E G I N N I N G B A L A N C E
!_.5/20 6/10 A99325 CHK: 114707
03536 CLEANING SVCS - JUN 12651
2,490.00
14,940.00
PERFECTION PLUS, INC. INV# 113179
/PO#
JUNE ACTIVITY DB: 2,490.00 CR:
0.00
2,490.00
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS ---
--- CREDITS ---
BEGINNING BALANCES: 42,175.58
0.00
REPORTED ACTIVITY: 7,917.71
0.00
ENDING BALANCES: 50,093.29
0.00
TOTAL FUND ENDING BALANCE: 50,093.29
10-15-2020 11:12 AM
D E T A I L L I S T I N G
SELECTION CRITERIA
-------------------------------------------------------------
FISCAL YEAR: Jan -2020 / Dec -2020
FUND: Include: 211
PERIOD TO USE: Jun -2020 THRU Jun -2020
TRANSACTIONS: BOTH
---------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-45??????
----------------------------------------------------
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: 3
3.0-15-2020 10:56 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2020
'll -LIBRARY
FINANCIAL SUMMARY
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
ICTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
105,100.00
24,181.34
55,769.01
53.06
49,330.99
105,100.00
--------------------------
--------------------------
24,181.34
-------------
-------------
55,769.01
53.06
--------------------
--------------------
49,330.99
115,100.00
7,917.71
50,093.29 43.52
65,006.71
115,100.00
7,917.71
50,093.29 43.52
65,006.71
115,100.00
--------------------------
--------------------------
7,917.71
-------------
-------------
50,093.29 43.52
--------------------
--------------------
65,006.71
( 10,000.00)
16,263.63
5,675.72 (
15,675.72)
0-15-2020 10:56 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED
AS OF: JUNE 30TH, 2020
11 --LIBRARY
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
MENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
ibrary
axes
IT -3-0000-3111 Current Ad Valorem Taxes
TOTAL Taxes
ntergovernmental Rev
barges for Services
ger Revenue
11-3-0000-3621 Interest Income
TOTAL Other Revenue
ansfers In
I-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
TOTAL Library
i)D:rary Project
69,000.00 24,181.34 24,181.34 35.05 44,818.66
69,000.00 24,181.34 24,181.34 35.05 44,818.66
81100.00 0.00 3,587.67 44.29 4,512.33
8,100.00 0.00 3,587.67 44.29 4,512.33
28,000.00 0.00 28,000.00 100.00 0.00
28,000.00 0.00 28,000.00 100.00 0.00
105,100.00 24,181.34 55,769.01 53.06 49,330.99
t -her Financing Sources
ransfers In
iTAL REVENUE 105,100.00 24,181.34 55,769.01 53.06 49,330.99
------------- ------------- -------------
--- ---- ----------- ==
-----------------------------------------------------------
LO -15-2020 10:56 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2020
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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
?11-4-5600-4401 Bldg Repair/Maint Services
111-4-5600-4404 Equip Repair/Maint Services
111-4-5600-4405 Cleaning Services
211-4-5600-4409 Contractual Services
211-4-5600-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
8,500.00
645.20
4,309.83
50.70
4,190.17
8,500.00
645.20
4,309.83
50.70
4,190.17
1,100.00
93.10
558.27
50.75
541.73
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,000.00
753.00
2,137.00
71.23
863.00
30,700.00
3,336.55
13,508.19
44.00
17,191.81
17,150.00
599.86
2,099.00
12.24
15,051.00
200.00
0.00
231.00
115.50 (
31.00)
30,000.00
2,490.00
14,940.00
49.80
15,060.00
13,700.00
0.00
10,560.00
77.08
3,140.00
100.00
0.00
0.00
0.00
100.00
96,600.00
7,272.51
44,033.46
45.58
52,566.54
10,000.00
0.00
1,750.00
17.50
8,250.00
10,000.00
0.00
1,750.00
17.50
8,250.00
TOTAL Library 115,100.00 7,917.71 50,093.29 43.52 65,006.71
TOTAL Culture & Recreation 115,100.00 7,917.71 50,093.29 43.52 65,006.71
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
115,100.00
7,917.71
50,093.29 43.52
65,006.71
( 10,000.00)
16,263.63
5,675.72 (
15,675.72)
10-15-2020 10:45 AM CITY OF ELK RIVER
PAGE: 1
BALANCE SHEET
AS OF: JULY 31ST, 2020
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION BALANCE
ASSETS
211-1010 Cash - Library 430,180.94
211-1380 Interest Receivable 1,957.00
432,137.94
TOTAL ASSETS
432,137.94
LIABILITIES
211-2200 Deposits Payable
(
50.00)
TOTAL LIABILITIES
(
50.00)
EQUITY
211-2400 Fund Balance
420,691.84
TOTAL BEGINNING EQUITY
420,691.84
TOTAL REVENUE
66,338.83
TOTAL EXPENSES
54,842.73
TOTAL REVENUE OVER/(UNDER) EXPENSES
11,496.10
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
432,187.94
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER)
EXP.
432,137.94
10-15-2020 11:14 AM
D E T A I L L I S T I N G
PAGE:
FUND 211-LIBRARY
ACTIVE ACCOUNTS ONLY
PERIOD TO USE:
Jul-2020 THRU Jul-2020
DEPT 5600
Library
SUPPRESS ZEROS
ACCOUNTS: ALL
POST DATE TRAN #
REFERENCE
PACKET======DESCRIPTION=====_= VEND
INV/PO/JE
# NOTE
=====AMOUNT==== ====BALANCE====
-•-----------------------------------------------------------------------------------------------------------------------------------
4-5600-4321
Telephone
B
E G I N N I N G B A L A N C E
558.27
7/20/20 7/15 A00700
CHK: 115041
03579 PHONE LINE CHGS 11102
101.18
659.45
WINDSTREAM INV# 070720
/PO#
------------=
JULY ACTIVITY DB: 101.18
CR:
0.00
------------------------------------------------------------------------------------------------------------------------------------
4-5600-4401
Bldg Repair/Maint Services
B
E G I N N I N G B A L A N C E
2,099.00
7/06/20 7/01 A00054
EFT: 001069
03554 BALLASTS IN MAIN AREA-LI 10373
1,559.40
3,658.40
AID ELECTRIC CORPORATION INV# 62492
/PO#
7/06/20 7/01 A00056
EFT: 001069
03554 REPLACE FLUOR FIXTURE W/ 10373
114.00
3,772.40
AID ELECTRIC CORPORATION INV# 62494
/PO#
7/06/20 7/01 A00081
CHK: 114885
03554 MOWING SVCS CONTRACT 11661
524.86
4,297.26
SPEEDCUTTERS OUTDOOR MAIN INV# 12344
/PO#
JULY ACTIVITY DB: 2,198.26
CR:
0.00
2,198.26
------------------------------------------------------------------------------------------------------------------------------------
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/20/20 7/15 A00737
CHK: 115009
03579 CLEANING SVCS - JUL 12651
2,490.00
17,430.00
PERFECTION PLUS, INC. INV# 113214
/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, 560.00
7/27/20 7/27 A01309
VOID: 113849
03602 REVERSE VOIDED CHECK 13060
40.00CR
10,520.00
ROBIN DEEANN SCHAIBLE INV# 031620
/PO#
-------------
JULY ACTIVITY DB: 0.00
CR:
40.000R
40.000R
10-15-2020 11:14 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: Jul-2020 THRU Jul-2020
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: 50,093.29 0.00
REPORTED ACTIVITY: 4,789.44 40.00OR
ENDING BALANCES: 54,882.73 40.00OR
TOTAL FUND ENDING BALANCE: 54,842.73
10-15-2020 11:14 AM D E T A I L L I S T I N G PAGE: 3
--------------------------------------------
FISCAL YEAR: Jan -2020 / Dec -2020
FUND: Include: 211
PERIOD TO USE: Jul -2020 THRU Jul -2020
TRANSACTIONS: BOTH
--------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4-????-????????
45?????????????
-------------
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 ***
SELECTION CRITERIA
-----------------------------
10-15-2020 10:57 AM
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED) PAGE: 1
211 -LIBRARY AS OF: JULY 31ST, 2020
FINANCIAL SUMMARY
58.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF
BUDGET
BUDGET PERIOD ACTUAL BUDGET
BALANCE
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
105,100.00
10,569.82
66,338.83
63.12
38,761.17
105,100.00
10,569.82
66,338.83
63.12
38,761.17
115,100.00
4,749.44
54,842.73 47.65
60,257.27
115,100.00
4,749.44
54,842.73 47.65
60,257.27
115,100.00
4,749.44
54 842.73 47.65
60 257.27
( 10,000.00)
5,820.38
11,496.10
(
21,496.10)
PAGE: 2
5-2020 10:57 AM CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2020
-LIBRARY 58.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF
BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
.N CIES
ra:ry
:es
.-3-0000-3111 Current Ad Valorem Taxes
L-3-0000-3112 Delinquent Ad Valorem Taxes
TOTAL Taxes
tergovernmental Rev
arges for Services
her Revenue
1-3-0000-3621 Interest Income
TOTAL Other Revenue
cansfers In
11-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
TOTAL Library
.ibrary Project
Irher Financing Sources
Transfers In
GTAL REVENUE
69,000.00
10,363.54
34,544.88
50.07
34,455.12
0.00
206.26
206.28
0.00 (
206.28)
69,000.00
10,569.82
34,751.16
50.36
34,248.84
8,100.00
0.00
3,587.67
44.29
4,512.33
8,100.00
0.00
3,587.67
44.29
4,512.33
za,000.00
0.00
28,000.00
100.00
0.00
28,000.00
0.00
28,000.00
100.00
o.00
105,100.00
10,569.82
66,338.83
63.12
38,761.17
105,100.00 10,569.82 66,338.83 63.12 38,761.17
10-15-2020 10:57 AM
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2020
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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 Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
PAGE: 3
115,100.00
4,749.44
54,842.73 47.65
58.33%
OF YEAR COMP.
CURRENT
CURRENT
YEAR TO DATE
% OF
BUDGET
BUDGET
PERIOD
ACTUAL
BUDGET
BALANCE
8,500.00
4,309.83
50.70
0.00
4,190.17
8,500.00
0.00
4,309.83
50.70
4,190.17
1,100.00
101.18
659.45
59.95
440.55
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,000.00
0.00
2,137.00
71.23
863.00
30,700.00
0.00
13,508.19
44.00
17,191.81
17,150.00
2,198.26
4,297.26
25.06
12,852.74
200.00
0.00
231.00
115.50 (
31.00)
30,000.00
2,490.00
17,430.00
58.10
12,570.00
13,700.00 (
40.00)
10,520.00
76.79
3,180.00
100.00
0.00
0.00
0.00
100.00
96,600.00
4,749.44
48,782.90
50.50
47,817.10
10,000.00
0.00
1,750.00
17.50
8,250.00
10,000.00
0.00
1,750.00
17.50
8,250.00
115,100.00
4,749.44
54,842.73 47.65
60,257.27
115,100.00
4,749.44
54,842.73 47.65
60,257.27
115,100.00
4,749.44
54,842.73 47.65
60,257.27
10,000.00)
5,820.38
11,496.10 (
21,496.10)
10-15-2020 10:47 AM
CITY OF ELK RIVER
BALANCE SHEET PAGE: 1
211-LIBRARY AS OF: AUGUST 31ST, 2020
ACCOUNT # ACCOUNT DESCRIPTION
BALANCE
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable 422,250.86
1,957.00
424,207.86
TOTAL ASSETS
424,207.86
LIABILITIES
211-2200 Deposits Payable
TOTAL LIABILITIES ( 50.00)
EQUITY ( 50.00)
211-2400 Fund Balance
TOTAL BEGINNING EQUITY 420,691.84
420,691.84
TOTAL REVENUE
TOTAL EXPENSES 66,338.83
TOTAL REVENUE OVER/(UNDER) EXPENSES 62,772.81
3,566.02
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
424,257.86
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP.
424,207.86
10-15-2020 11:15 AM
FUND 211 -LIBRARY D E T A I L L I S T I N G
DEPT ACTIVE ACCOUNTS ONLY
5600 Library
PERIOD
PAGE: 1
SUPPRESS
POST DATE T SUPPRESS ZEROS
RAN # REFERENCE
TO USE:
Aug -2020 THRU
Aug -2020
PACKET======
ACCOUNTS: ALL
VEND INV/pO/JE #
---------------------------------------------
NOTE
=====AMOCtiT====
==�=BALANCE====
4-5600-4219 ---------"'----------
Operatin--------------
4 Supplies
------------------
---------------
B E G I N N I N G B A L A N C E
---------------
8/11/20 8/12 A01986 EFT: 0012174,309.83
03614
SUPPLIES
BATTERIES PLUS BULBS11835
8/17/20 8/12 A02049 CHK: 115258 INV# P29320673
74'70
4,384.53
03614 BULK SALT
/PO#
STEP SAVER INC 13048
INV# 139070
8/17/20 8/12 A02131 CHK: 11519003619
=72.90
4,557.43
SOAP
/PO#
15887
DACOTAH PAPER CO
8/31/20 8/31 A02829 CHK: 115390 INV# 57707
36.25
4,593.68
03642 GLOVES - NORMAL CLEANING 15887
/PO#
DACOTAH PAPER CO INV# 58824
71.56
4,665.24
----= AUGUST ACTIVITY De;
/PO#
355.41 CR:
0.00
355.41
------------------------------------
9-5600-4321
T
Telephone
-----------
B E G I N N I N G B A L A N C E
--------------------
8/17/20 8/12 A01960 CHK: 115270659.45
03614
PHONE LINE CHGS 11102
WINDSTREAM
INV# 080720
AUGUST ACTIVITY
/PO#
92.94
752.39
DB: 92.94 CR:
------------
0.00
92.94
--------------------'__
4-5600-4389 Utilities ---'-'
-----------
B E G I N N I N G B A L A N C E
-------------------
8/03/20 7/29 A01523 EFT: 00119003592
13,508.19
WATER/ELECTRIC
17700
ELK RIVER MUNICIPAL UTILI INV# 071520
8/03/20 7/29 A01601 EFT: 001199
2,123.86
15,632.05
03592 JUL RUBBISH SVCS
/PO#
0851
RANDY'S ENVIRONMENTAL SER INV# 135818-071720
8/25/20 8/25 A02639 EFT: 00127517700
61.25
15,693.30
03627 WATER/ELECTRIC
/PO#
ELK RIVER MUNICIPAL UTILI INV# 0812 20
2,001.76
17,695.06
AUGUST ACTIVITY/PO#
DB:
4,186.87 CR:
0.00_
-------------------
4,186.87
---------------
4-5600-4401 -
________
Bldg Repair/Maint Services
-- -----------------------
B E G I N N I N G B A L A N C E
8,103/20 7/29 A01369 CHK: 1151304,297.26
03592
MOWING SVCS CONTRACT 11661
SPEEDCUTTERS OUTDOOR MAIN INV# 12474
9I17/20 8/12 A02127 CHK: 115187
524.86
4,822.12
03614 PEST CONTROL -LIBRARY
/PO#
15191
RICHARD J MORGAN
8/17/20 8/12 A02154 CHK: 115194 INV# 10009
75.00
4,897 12
03614 EXTERIOR WINDOW CLNG
/PO#
DISTINCTIVE WINDOW CLEANI INV# 17866
205.00
5,102.12
AUGUST ACTIVITY DB:
/PO#
804.86 CR:
0.00
804.86
PAGE: 2
D E T A I L L I S T I N G2020
10-15-2020 11:15 AM ACTIVE ACCOUNTS ONLY PERIOD TO USE: Aug -2020 THRU Aug-
L`UND 211-LIBRARYACCOUNTS: ALL _===BALANCE====
SUPPRESS ZEROS NOTE =====AMOUNT====
DEPT 5600 Library IPTION VEND INV/PO/JE #
DESCR===== _
DATE TRAN # REFERENCE PACKET=—=_ --------
----------
17,430.00
4-•5600-4405 Cleaning Services
B E G I N N I N G B ALAN C E 19, 920.00
2,490.00
11524
/2p 8/12 A02015 CHK: 2 03614 CLEANING SVCS - AUG 12651
/PO#
INV# 113255
PERFECTION PLUS, INC. 0.00 2,490.00
____ _______= AUGUST ACTIVITY
DB: 2,490.00 CR:
000 ERRORS IN THIS REPORT!
** REPORT TOTALS **
BEGINNING BALANCES:
REPORTED ACTIVITY:
ENDING BALANCES:
TOTAL FUND ENDING BALANCE:
--- CREDITS ---
--- DEBITS ---
0.00
54,842.73
0.00
7,930.08
0.00
62,772.81
62,772.81
10-15-2020 11:15 AM
D E T A I L L I S T I N G
PAGE: 3
--- ------ ------------------------ SELECTION CRITERIA
FISCAL YEAR; ---""--------
____
Jan -2020
/ Dec -2020 ------------"
-----------------------
FUND:
Include: 211
PERIOD TO USE:
Aug -2020 THRU Aug -2020
TRANSACTIONS: BOTH
-----------
----
-------------------------
____________________
ACCOUNT SELECTION
ACCOUNT RANGE:
DEPARTMENT RANGE: - THRU -
THRU ZZZZZZZZZZZZZZZ
ACTIVE FUNDS ONLY:
ACTIVE ACCOUNT ONLY: NO
YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-437?????
4 -????-44??????
4 -????_45??????
PRINT OPTIONS
---------------------
- __
----------------
DETAIL ----'-----
OMIT ACCOUNTS WITH NO ACTIVITY: YES
PRINT ENCUMBRANCES:
NO
PRINT VENDOR NAME:
PRINT PROJECTS: YES
NO
PRINT JOURNAL ENTRY NOTES:
PRINT MONTHLY TOTALS: NO
YES
PRINT GRAND TOTALS:
PRINT: INVOICE/PO # NO
PAGE BREAK BY: NONE
--------------------------------------
"** END OF REPORT **1
10-15-2020 10:58 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: AUGUST 31ST, 2020
PAGE: I
66.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF
BUDGET BUDGET
PERIOD ACTUAL BUDGET BALANCE
105,100.00
0.00
66,338.83
63.12
38,761.17
105,100.00
0.00
66,338.83
_-_
63.12
38,761.17
115,100.00
7,930.08
62,772.81 54.59
52,327.19
115,100.00
7,930.08
62,772.81 54.59
52,327.19
115,100.00
7,930.08
62,772.81 54.54
_ 52,327.19
( 10,000.00)(
7,930.08)
3,566.02
(
13,566.02)
PAGE: 2
CITY OF ELK RIVER
5-2020 10:58 AM
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2020
LI13RARY 66.67% OF YEAR COMP.
CURRENT CURRENT
YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
iNUES _——
ralcy
es
-3-0000-3111 Current Ad valorem Taxes
-3-0000-3112 Delinquent Ad Valorem Taxes
TOTAL Taxes
cergovernmental Rev
ar3es for Services
her Revenue
,1-3-0000-3621 Interest Income
^''OTAL Other Revenue
-ansfers In
11-3-0000-3945 Transfer -Utilities
TOTAL Transfers In
TOTAL Library
,ibrary Project
;ther Financing Sources
Transfers In
69,000.00 0.00 34,544.88 50.07 34,455.12
0.00
0.00 206.28 0.00 ( 206.28)
69,000.00 0.00 34,751.16 50.36 34,248.84
8,100.00 0.00 3,587.67 44.29
8,100.00 0.00 3,587.67 44.29
28,000.00
28,000.00
105,100.00
0.00 28,000.00 100.00
0.00 28,000.00 100.00
4,512.33
4,512.33
0.00
0.00
0.00 66,338.83 63.12 38,761.17
105,100.00 0.00 66,338.83 63.12 38,761.17
TOTAL REVENUE
10-15-2020 10:58 AM
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: AUGUST 31ST, 2020
PAGE: 3
66.67% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF
BUDGET
BUDGET
PERIOD ACTUAL BUDGET
BALANCE
Personal Services
Supplies
-
211-4-5600-4219 Operating Supplies
TOTAL Supplies
8,500.00
355.41
4,665.24
54.89
3,834.76
8,500.00
355.41
4,665.24
54.89
3,834.76
Other Services & Charges
211-4-5600-4321 Telephone
211-4-5600-4331 Travel, Conferences & Schools
11100.00
92.94
752.39
68.40
211-4-5600-4359 Publishing
150.00347.61
0.00
0.00
0.00
211-4-5600-4361 Insurance
500.00
0.00
0.00
0.00
150.00
211-4-5600-4389 Utilities
3,000.00
0.00
2,137.00
71.23
500.00
211-4-5600-4401 Bldg Repair/Maint
30,700.00
4,186.87
17,695.06
57.64
863.00
Services
211-4-5600-4404 Equip Repair/Maint Services
17,150.00
804.86
5,102.12
29.75
13,009.94
12,047.88
211-4-5600-4405 Cleaning Services
200.00
0.00
231.00
115.50
211-4-5600-4409 Contractual Services
30,000.00
2,490.00
19,920.00
66.40
31.00)
10,080.00
211-4-5600-4433 Dues & Subscriptions
13,700.00
0.00
10,520.00
76.78
3,180.00
TOTAL Other Services & Charges
100.00
0'00
0.00
0.00
100.00
96,600.00
7,574.67
56,357.57
58.34
Capital Outlay
40,242.43
211-4-5600-4560 Equipment
TOTAL Capital Outlay
10,000.00
0.00
1,750.00
17.50
6,250.00
10,000.00
0.00
1,750.00
17.50
8,250.00
Transfers Out
TOTAL Library
115,100.00
7,930.08
62,772.81
54.59
52,327,19
`!'OTAL Culture & Recreation
------------
115,100.00
7,930.08
62,772.81
54.54
- -
52,327.19
TOTAL EXPENDITURES
115,100.00
7,930.08
62,772.81
54.54
52,327.19
REVENUES OVER/(UNDER) EXPENDITURES
(
10,000.00)(
7,930.08)
3,566.02
(
13,566.02)
10-15-2020 10:51 AM
211 -LIBRARY
ACCOUNT # ACCOUNT DESCRIPTION
ASSETS
211-1010 Cash - Library
211-1380 Interest Receivable
CITY OF ELK RIVER
BALANCE SHEET PAGE: 1
AS OF: SEPTEMBER 30TH, 2020
BALANCE
416,276.97
1,957.00
TOTAL ASSETS
LIABILITIES
211-2200 Deposits Payable
TOTAL LIABILITIES ( 50.00)
EQUITY
211-2400 Fund Balance
TOTAL BEGINNING EQUITY 420,691.84
420,691.84
TOTAL REVENUE
TOTAL EXPENSES 66,338.83
TOTAL REVENUE OVER/(UNDER) EXPENSES 68'796.70
( 2,907,87)
TOTAL EQUITY & REV. OVER/(UNDER) EXP.
TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP
418,233.97
50.00)
418,283.97
418,233.97
418,233.97
10-15-2020 11:17 AM D E T A I L L I S T I N G
FUND 211 -LIBRARY
1
PAGE:ACTIVE
ACCOUNTS ONLY
DEPT 5600 Library
PERIOD TO USE:
Sep -2020 THRU
Sep -2020
SUPPRESS ZEROS
POST DATE IRAN # REFERENCE PACKET======DESCRIPTION=====__
ACCOUNTS: ALL
VEND INV/PO/JE
# NOTE
=====AMOUNT====
====BALANCE====
--------------------------------------------------
-5600-9219 Operating Supplies
------------------------------------------
B E G I N N I N G B A L A N C E
4,665.24
9/21/20 9/17 A03788 CHK: 115565 03651 PAINT
32280
SHERWIN-WILLIAMS INV# 3340-8
/PO#
66.47
9,731.71
SEPTEMBER ACTIVITY DB: 66.47 CR:
0.00
66.47
-----------------------------------------------------------------------------------------
4-5600-4321 Telephone
B E G I N N I N G B A L A N C E
752.39
9/21/20 9/17 A03540 CHK: 115582 03651 PHONE LINE CHGS
11102
WINDSTREAM INV# 090820
/PO#
96.90
849.29
SEPTEMBER ACTIVITY DB: 96.90 CR:
0.00
96.90
----------------------------------------------------------------------
4-5600-4361 Insurance
--------"-'--------
B E G I N N I N G B A L A N C E
2,137.00
9/21/20 9/17 A03739 CHK: 115529 03651 INSURANCE ALLOCATION 23805
LEAGUE OF MN CITIES INS T INV# 40002926-090420
/PO#
753.00
2,890.00
SEPTEMBER ACTIVITY DB: 753.00 CR:
0.00
753.00
------------------------------------------------------------------------------------------
4-5600-4389 Utilities
B E G I N N I N G B A L A N C E
17,695.06
9/08/20 9/02 A03183 EFT: 001320 03637 AUG RUBBISH SVCS 30851
RANDY'S ENVIRONMENTAL SER INV# 135818-081920
/PO#
61.25
17,756.31
9/21/20 9/17 A03689 EFT: 001358 03651 WATER/ELECTRIC 17700
ELK RIVER MUNICIPAL UTILI INV# 090920
/PO#
1,981.41
19,737.72
SEPTEMBER ACTIVITY DB: 2,042.66 CR:
0.00
2,042.66
----------------------------------------------------------------------------------------
4-5600-4401 Bldg Repair/Maint Services
B E G I N N I N G B A L A N C E
5,102.12
9/08/20 9/02 A02912 CHK: 115442 03637 MOWING SVCS CONTRACT 11661
SPEEDCUTTERS OUTDOOR MAIN INV# 12576
/PO#
524.86
5,626.98
SEPTEMBER ACTIVITY DB: 524.86 CR:
0.00
524.86
10-15-2020 11:17 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: Sep -2020 THRU Sep -2020
DEPT 5600 Library
SUPPRESS ZEROS ACCOUNTS: ALL
()SITDATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ==-=BALANCE====
--------------------------------------------------------- -----------------------------------------------------------------------
4-5600-4405 Cleaning Services 19,920.00
B E G I N N I N G B A L A N C E
'25/20 9/25 A04081 CHK: 115597 03670 CLEANING SVCS - SEP 12651
2,490.00 22,910.00
PERFECTION PLUS, INC. INV# 113294 /PO#
SEPTEMBER ACTIVITY DB: 2,490.00 CR:
0.00 2,490.00
000 ERRORS IN THIS REPORT!
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 62,772.81 0.00
REPORTED ACTIVITY: 5,973.89 0.00
ENDING BALANCES: 68,746.70 0.00
TOTAL FUND ENDING BALANCE: 68,746.70
10-15-2020 11:17 AM D E T A I L L I S T I N G
SELECTION CRITERIA
-------------------------------------------------------------------------------
FISCAL YEAR: Jan -2020 / Dec -2020
FUND: Include: 211
PERIOD TO USE: Sep -2020 THRU Sep -2020
TRANSACTIONS: BOTH
---------------------------------------------------------------------------
ACCOUNT SELECTION
ACCOUNT RANGE: THRU ZZZZZZZZZZZZZZZ
DEPARTMENT RANGE: - THRU -
ACTIVE FUNDS ONLY: NO
ACTIVE ACCOUNT ONLY: YES
INCLUDE RESTRICTED ACCOUNTS: NO
DIGIT SELECTION: 4 -????-42??????
4 -????-43??????
4 -????-44??????
4 -????-45??????
--------------------------------------------------------------------------------
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 #
!?AGE BREAK BY: NONE
-----------------------------------------------
*** END OF REPORT ***
PAGE: 3
10-15-2020 10:59 AM CITY OF ELK RIVER
PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
211 -LIBRARY AS OF: SEPTEMBER 30TH, 2020
FINANCIAL SUMMARY
75.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Library
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/;UNDER) EXPENDITURES
105,100.00
0.00
66,338.83
63.12
38,761.17
105,100.00
0.00
66,338.83
63.12
38,761.17
115,100.00
5,973.89
68,746.70 59.73
46,353.30
115,100.00
5,973.89
68,746.70 59.73
46,353.30
115,100.00
5,973.89
68,746.70 59.73
46,353.30
( 10,000.00)(
5,973.89)(
2,407.87) (
7,592.13)
-2020 10:59 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2020
1 -LIBRARY
75.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
'4UES BUDGET PERIOD ACTUAL BUDGET BALANCE
Crary
.xe s
1-3-0000-3111 Current Ad Valorem Taxes
1-3-0000-3112 Delinquent Ad Valorem Taxes
TOTAL Taxes
7te:rgovernmental Rev
jae:ges for Services
ther Revenue
11--3-0000-3621 Interest Income
TOTAL Other Revenue
ransfers In
11-3-0000-3945 Transfer -Utilities
'DOTAL Transfers In
TOTAL Library
A brary Project
)th.er Financing Sources
Cransfers In
69,000.00
0.00
34,544.88
50.07
34,455.12
0.00
0.00
206.28
0.00 (
206.28)
69,000.00
0.00
34,751.16
50.36
34,248.84
0.00
3,587.67
44.29
4,512.33
8,100.00
8,100.00
0.00
3,587.67
44.29
4,512.33
28,000.00
28,000.00
105,100.00
0.00 28,000.00 100.00
0.00 28,000.00 100.00
0.00
0.00
0.00 66,338.83 63.12 38,761.17
TOTAL REVENUE 105,100.00 0.00 66,338.83 63.12 38,761.17
10-15-2020 10:59 AM
211 -LIBRARY
Culture & Recreation
Library
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: SEPTEMBER 30TH, 2020
Personal Services
Supplies
211-4-5600-4219 Operating Supplies
TOTAL Supplies
Other 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 Other Services & Charges
Capital Outlay
211-4-5600-4560 Equipment
TOTAL Capital Outlay
Transfers Out
TOTAL Library
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
PAGE: 3
75.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
8,500.00
66.47
4,731.71
55.67
3,768.29
8,500.00
66.47
4,731.71
55.67
3,768.29
1,100.00
96.90
849.29
77.21
250.71
150.00
0.00
0.00
0.00
150.00
500.00
0.00
0.00
0.00
500.00
3,000.00
753.00
2,890.00
96.33
110.00
30,700.00
2,042.66
19,737.72
64.29
10,962.28
17,150.00
524.86
5,626.98
32.81
11,523.02
200.00
0.00
231.00
115.50 (
31.00)
30,000.00
2,490.00
22,410.00
74.70
7,590.00
13,700.00
0.00
10,520.00
76.79
3,180.00
100.00
0.00
0.00
0.00
100.00
96,600.00
5,907.42
62,264.99
64.46
34,335.01
10,000.00
0.00
1,750.00
17.50
8,250.00
10,000.00
0.00
1,750.00
17.50
8,250.00
115,100.00
5,973.89
68,746.70 59.73
46,353.30
115,100.00
5,973.89
68,746.70 59.73
46,353.30
115,100.00
5,973.89
68,746.70 59.73
46,353.30
( 10,000.00)(
5,973.89)(
2,407.87) (
7,592.13)