3.3-3.5 HRSR 08-02-20107/30/2010 11:05 AM REGULAR DEPARTMENT PAYMENT REPORT - PAGE: 1
~~ ~~' ~' ~~' ~'
VENDOR SET : Ol CITY OF ELK RIVER BANK: HRA
FUND : 910 HRA
DEPARTMENT: 610 Housing & Redevelopment
INVOICE DATE RANGE: 1/01/1998 TH RU 99/99/9999
PAY DATE RANGE: 7/09/2010 TH RU 8/02/2010
BUDGET TO USE: CB-CURRENT BU DGET
VENDOR NAME ITEM # G/L ACCOUNT NAME DESCRIPTION CHECK # AMOUNT
01-17202 ECONOMIC DEVELOPMENT A I-070910 910 4-6100-9735 Transfer-EDA TRANSFER - EDA 001680 3,500.00
VENDOR 01-17202 TOTALS 3,500.00
01-17287 EHLERS & ASSOCIATES, I I-391596 910 9-6100-9319 Other Profess: PROCTOR REDEVELOPMEN 001685 855.00
VENDOR 01-17287 TOTALS 855.00
O1-17990 CITY OF ELK RIVER I-070910 910 4-6100-9721 Transfer-Gene: TRANSFER - GENERAL F 001681 9,500.00
01-17490 CITY OF ELK RIVER I-070910. 910 4-6100-9389 Utilities NATURAL GAS 720 MAIN 001681 10.50
O1-17490 CITY OF ELK RIVER I-080210 910 9-6100-4322 Postage POSTAGE FOR METER 001686 7.17
VENDOR 01-17490 TOTALS 9,517.67
01-17700 ELK RIVER MUNICIPAL UT I-062510 910 9-6100-4389 Utilities WATER/ELEC 720 MAIN 001682 35.61
01-17700 ELK RIVER MUNICIPAL UT I-080210 910 9-6100-9389 Utilities WATER/ELEC 720 MAIN 001687 49.67
VENDOR O1-17700 TOTALS 85.28
01-21633 HOULTON INVESTMENT COM I-070910 910 9-6100-9601 Principal 716/720 MAIN ST CD 001683 52,995.52
O1-21633 HOULTON INVESTMENT COM I-070910 910 9-6100-9611 Interest 716/720 MAIN ST CD 001683 6,588.66
VENDOR 01-21633 TOTALS 59,084.18
----------
----------------------
----------------
--------- D
------------ EPARTMENT 6100 Hou
------------------- sing & Redevelopment TOTAL:
------------------------------ 73,092.13
--------------
V ENDOR SET 910 HRA TOTAL: 73,092.13
REPORT GRAND TOTAL: 73,092.13
7/30/2010 11:13 AM
VENDOR SET: O1 CITY OF ELK RIVER
FUND 911 NSP
DEPARTMENT: 611 NSP Admin
INVOICE DATE RANGE: 1/01/1998 THRU 99/99/9999
PAY DATE RANGE: 6/09/2010 THRU 7/09/2010
BUDGET TO USE: CB-CURRENT BUDGET
VENDOR NAME ITEM #
----------------------------------------
01-10832 TRZ-COUNTY ACTION PROG I-DE9-4
REGULAR DEPARTMENT PAYMENT REPORT
PAGE: 1
BANK: NSP
G/L ACCOUNT NAME DESCRIPTION CHECK # AMOUNT
911 4-6110-4909 Contractual S: ADMINISTRATION COSTS 001689 2,171.47
VENDOR 01-10832 TOTALS 2,171.97
DEPARTMENT 6110 NSP Admin TOTAL: 2,171.97
------------------------------------------------------------------------------------------------------------------------------------
01-11020 ANCHOR BANK I-062210 911 4-6111-9909 Contractual S: DPA 17213 MONROE 000809 10,000.00
BENEFICIARY: REGIS TITLE LLC
VENDOR 01-11020 TOTALS 10,000.00
01-35101 U S BANK NA I-060910 911 4-6111-9409 Contractual S: DPA 17926 VANCE CIRC 000808 10,000.00
BENEFICIARY: NORTHWEST TITLE AGENCY
VENDOR 01-35101 TOTALS
DEPARTMENT 6111 Down Payment Assistance TOTAL: 20,000.00
------------------------------------------------------------------------------------------------------------------------------------
VENDOR SET 911 NSP TOTAL: 22,171.47
REPORT GRAND TOTAL: 22,171.47
7-30-2010 11:44 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2010
I 910-HRA
FINANCIAL SUMMARY
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I REVENUE SUMMARY
I HRA
TOTAL REVENUES
' EXPENDITURE SUMMARY
Economic Development
Housing & Redevelopment
TOTAL Economic Development
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
350,400. 00 422 .69 3,645.75 1.04 346,754. 25
350,900. 00 422 .69 3,645.75 1.04 346,754. 25
267,550. 00 12,323.20 83,567. 85 31.23 183,982.15
267,550. 00 12,323.20 83,567. 85 31.23 183,982.15
267,550. 00 12,323.20 83,567. 85 31.23 183,982.15
82,850. 00 ( 11,900.51)( 79,922. 10) 162,772.10
7-30-2010 11:44 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2010
910-HRA
Economic Development
Housing & Redevelopment
DEPARTMENTAL EXPENDITURES
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
910-4-6100-4101 Regular Pay
910-4-6100-4104 PERA
910-4-6100-4105 FICA
910-4-6100-4107 Medicare
910-4-6100-4108 Insurance
910-4-6100-4109 Workers Comp
TOTAL Personal Services
Other Services & Charges
910-4-6100-4304 Legal Fees
910-4-6100-4319 Other Professional Services
910-4-6100-4322 Postage
910-4-6100-4359 Publishing
910-4-6100-4361 Insurance
910-4-6100-4389 Utilities
910-4-6100-4401 Bldg Repair/Maint Services
910-4-6100-4433 Dues & Subscriptions
910-4-6100-4437 Taxes & Licenses
TOTAL Other Services & Charges
Debt Service
910-4-6100-4601 Principal
910-4-6100-4611 Interest
TOTAL Debt Service
Transfers Out
910-4-6100-4721 Transfer-General Fund
910-4-6100-4735 Transfer-EDA
TOTAL Transfers Out
53,250.00
3,750.00
3,300.00
800.00
6,550.00
250.00
67,900.00
10,237. 40 18,548.73 34. 83 34,701.27
678. 60 1,389.38 37. 05 2,360.62
595. 00 1,224.57 37. 11 - 2,075.43
140. 76 287.99 36. 00 512.01
734. 41 1,836.02 28. 03 4,713.98
0. 00 135.50 54.20 114.50
12,386. 17 23,422.19 34. 50 44,477.81
10,000.00
32,500.00
500.00
16,000.00
3,200.00
3,000..00
3,000.00
250.00
0.00
68,450.00
103,500.00
14,700.00
118,200.00
0.00 0. 00 0.00 10,000.00
0.00 0. 00 0.00 32,500 .00
0.00 0. 41 0.08 499 .59
0.00 0. 00 0.00 16,000 .00
109.08) 751. 02 23.47 2,448 .98
46.11 220. 05 7.34 2,779 .95
0.00 0. 00 0.00 3,000 .00
0.00 0. 00 0.00 250 .00
0.00 90. 00 0.00 ( 90 .00)
62.97) 1,061. 48 1.55 67,388 .52
0.00 50,966. 53 49.24 52,533 .47
0.00 8,117. 65 55.22 6,582 .35
0.00 59,084. 18 49.99 59,115 .82
9,500.00 0.00 0.00 0 .00 9,500. 00
3,500.00 0.00 0.00 0 .00 3,500. 00
13,000.00 0.00 0.00 0 .00 13,000. 00
TOTAL Housing & Redevelopment
267,550.00 12,323.20 83,567.85 31.23 183,982.15
TOTAL Economic Development
267,550.00 12,323.20 83,567.85 31.23 183,982.15
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
267,550 .00 12,323.20 83,567 .85 31.23 183,982 .15
82,850 .00 ( 11,900.51)( 79,922 .10) 162,772 .10
7-30-2010 11:45 AM D E T A I L L I S T I N G PAGE: 1
FUND 910- HRA ACTIVE ACCOUNTS ONLY PERIOD TO USE: Jun-2010 THRU Jun-2010
DEPT 6100 Housing & Redevelopment SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOU NT==== ====BALANCE====
4-6100-4361 Insurance
B E G I N N I N G B ALAN C E 860.10
6/09/10 6/09 R01562 M-ITEM POSTING 00466 June Insurance premium 201006091547 109.08CR 751.02
AR CUSTOMER SET O1 CUSTOMER NUMBER ERART
_____________ JUNE ACTIVITY DB: 0.00 CR: 109.08CR 109.OSCR
4-6100-4389 Utilities
B E G I N N I N G B ALAN C E 173.94
.6/07/10 6/03 A00076 CHK: 001677 00658 NATURAL GAS 720 MAIN APR 17440 10.50 184.44
CITY OF ELK RIVER INV# 060710. /PO#
6/07/10 6/03 A00077 CHK: 001678 00658 WATER/ELEC 720 MAIN 17700 35.61 220.05
ELK RIVER MUNICIPAL UTILI INV# 52510 /PO#
_____________ JUNE ACTIVITY DB: 46.11 CR: 0.00 46.11
*-*-*-*-*-*-*-*-*-*-*- *-*- 000 ERRORS IN THIS REPORT! *_*_*_+_*_*_*_*_*_*_*_*_*_*
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 60,208.63 0.00
REPORTED ACTIVITY: 46.11 109.08CR
ENDING BALANCES: 60,254.74 109.OSCR
BALANCE SHEET
JUNE 2010 Page: 1
CITY OF ELK RIVER
As of: 06/30/2010 Balances
Fund Type: CU Component Unit
Fund: 910 - HRA
Assets
Acct Class: ] 000 Current Assets
1010 Cash 628,571.96
1 ] 50 Accounts Receivable 0.00
1190 Notes Receivable 400,000.00
1310 Due From Other Funds 309,718.11
Acct Class: 1000 Current Assets 1,338,290.07
Acct Class: 1600 Capital Assets
1620 Buildings & Structures 720,000.00
Acct Class: 1600 Capital Assets 720,000.00
Total Assets 2,058,290.07
Liabilities
Acct Class: 2000 Cun•ent Liabilities
Building Purchase (non-current liability)** 219,621.69
Acct Class: 2000 Current Liabilities 219,62].69
Total Liabilities 219,621.69
ReservesBalances
Acct Class: 2400 Fund Equity
2400 Fund Balance 1,918,590.48
2600 Change In Fund Balance -79,922.10.
Acct Class: 2400 Fund Equity 1,838,668.38
Total ReservesBalances 1,838,668.38
Total Liabilities & Balances 2,058,290.07
* * =The City's financial system is on the modified accrual basis of accounting and the current financial resources measurement focus.
"Government funds, with their focus on current financial resources, do not report liabilities for the following. Unmatured principal and interest
of long-term debt" (GAAFR, page 174). The City records long-term debt related liabilities as part of the GASB 34 conversion entries and will
show up on your year-end accrual statements. What finance will do is manually insert the long-term liability in your balance sheet to more
closely reflect accrual accounting.