3.3. HRSR 12-07-200912/09/2009 11:05 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: 11/01/2009 THRU 12/07/2009
BUDGET TO USE: CB-CURRENT BUDGET
VENDOR NAME ITEM #
01-10832 TRI-COUNTY ACTION PROG I-DE9-1
01-20360 GRAY, PLANT,MOOTY,MOOTY I-521091
REGULAR DEPARTMENT PAYMENT REPORT PAGE:
ITEM # 3.3.
BANK: ALL
G/L ACCGUNT NAME DESCRIPTION CHECK # AMOUNT
911 9-6110-4909 Contractual S: OCT ADMINISTRATION C 001653 2,792.99
VENDOR 01-10832 TOTALS 2,792.99
911 9-6110-9309 Legal Fees OCT LEGAL SVCS 001650 570.00
VENDOR O1-20360 TOTALS 570.00
DEPARTMENT 6110 NSP Admin TOTAL: 3,362.99
01-32230 SHERBURNE COUNTY RECOR I-111609. 911 9-6112-4909 Contractual S: UNIT 74 TROUT BROOK 001652 46.00
VENDOR 01-32230 TOTALS 96.00
01-32260 SHERBURNE CO AUDITOR\T I-111309 911 9-6112-4909 Contractual S: MORTGAGE REGISTRY TA 001651 236.18
VENDOR 01-32260 TOTALS 236.18
DEPARTMENT 6112 Acquisition/Rehab TOTAL: 282.18
VENDOR SET 911 NSP TOTAL: 3,699.67
BALANCE SHEET Item #.3.3.
Page: 1
OCTOBER 2009
CITY OF ELK RIVER
As of: ] 0/30/2009 Balances
Fund Type: CU Component Unit
Fund: 910 - HRA
Assets
Acct Class: 1000 Current Assets
1010 Cash 548,836.53
1190 Notes Receivable 400,000.00
1310 Due From Other Funds 369,125.92
Acct Class: 1000 Current Assets 1,317,962.45
Acct Class: 1600 Capital Assets
1620 Buildings & Structures 720,000.00
Acct Class: 1600 Capital Assets 720,000.00
Total Assets 2,037,962.45
Liabilities
Acct Class: 2000 Current Liabilities
Building Purchase (non-current liability)** 320,070.29
Acct Class: 2000 Current Liabilities 320,070.29
Total Liabilities 320,070.29
ReservesBalances
Acct Class: 2400 Fund Equity
2400 Fund Balance 1,694,608.89
2600 Change In Fund Balance 23,283.27
Acct Class: 2400 Fund Equity 1,717,892.16
Total Reserves/Balances 1,717,892.16
Total Liabilities & Balances 2,037,962.45
** _ "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
oi~ 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.
BALANCE SHEET
NOVEMBER 2009
CITY OF ELK RIVER
As of: 11/30/2009
Fund Type: CU Component Unit
Fund: 910 - HRA
Assets
Acct Class: 1000 Current Assets
1010 Cash
1190 Notes Receivable
1310 Due From Other Funds
Acct Class: 1000 Current Assets
Acct Class: 1600 Capital Assets
1620 Buildings & Structures
Acct Class: 1600 Capital Assets
Liabilities
Acct Class: 2000 Current Liabilities
Building Purchase (non-current liability)**
Acct Class: 2000 Current Liabilities
ReservesBa(ances
Acct Class: 2400 Fund Equity
2400 Fund Balance
2600 Change In Fund Balance
.~. 3
Page: 1
Balances
546,695.88
400,000.00
369,125.92
1,3 15,821.80
720,000.00
Total Assets 2,035,821.80
320,070.29
320,070.29
Total Liabilities 320,070.29
Acct Class: 2400 Fund Equity
Total ReservesBalances
Total Liabilities & Balances
1,694,608.89
1,715,751.51
2,035,821.80
** =The City's financial system is on the modified accrual basis of accounting and the current financial resources measuremeni,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.
12-04-2009 12:59 PM D E T A I L L I S T I N G PAGE: 1
FUND 910-HRA PERIOD TO USE: Nov-2009 THRU Nov-2009
DEPT 6100 Housing & Redevelopment SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAM # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE====
4-6100-4322 Postage
B E G I N N I N G B A L A N C E 9.80
11/02/09 10/30 A00057 CHK: 001646 00436 POSTAGE FOR METER 17440 2.07 11.87
CITY OF ELK RIVER INV# 110209. /PO#
_____________ NOVEMBER ACTIVITY DB: 2.07 CR: 0.00 2.07
4-6100-4361 Insurance
B E G I N N I N G B A L A N C E 1,378.50
11/02/09 10/30 A00057 CHK: 001646 00436 OPEN MTG LAW ANNUAL PAY 17440 146.00 1,524.50
CITY OF ELK RIVER INV# 110209 /PO#
------------- NOVEMBER ACTIVITY DB: 146.00 CR: 0.00 146.00
4-6100-4389 Utilities
B E G I N N I N G B A L A N C E 423.15
li/02/09 10/30 A00058 CHK: 001647 00436 WATER/ELEC 720 MAIN 17700 35.61 458.76
ELK RIVER MUNICIPAL UTILI INV# 102509. /PO#
_____________ NOVEMBER ACTIVITY DB: 35.61 CR: 0.00 35.61
4-6100-4401 Bldg Repair/Maint Services
B E G I N N I N G B A L A N C E 2,690.56
11/06/09 11/06 A00059 CHK: 001649 00451 REPAIRS-ARTS ALLIANCE BL 36620 2,164.89 4,855.95
YALE MECHANICAL INV# 105124 /PO#
_____________ NOVEMBER ACTIVITY DB: 2,164.89 CR: 0.00 2,164.89
4-6100-4433 Dues & Subscriptions
B E G I N N I N G B A L A N C E 0.00
li/02/09 10/30 A00056 CHK: 001645 00436 SUBSCRIPTION RENEWAL 16734 236.50 236.50
DOWNTOWN IDEA EXCHANGE INV# 110209 /PO#
_____________ NOVEMBER ACTIVITY DB: 236.50 CR: 0.00 236.50
12-04-2009 12:58 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: NOVEMBER 30TH, 2009
910-HRA
FINANCIAL SUMMARY 91.67°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
HRA 388,300 .00 512. 17 197,484 .78 50 .86 190,815 .22
TOTAL REVENUES 388,300 .00 512. 17 197,484 .78 50 .86 190,815 .22
EXPENDITURE SUMMARY
Economic Development
Housing & Redevelopment 274,850 .00 2,652. 82 176,342. 16 64. 16 98,507. 84
TOTAL Economic Development 274,850 .00 2,652. 82 176,342. 16 64. 16 98,507. 84
TOTAL EXPENDITURES 274,850 .00 2,652. 82 176,342. 16 64. 16 98,507. 84
REVENUES OVER/(UNDER) EXPENDITURES 113,450 .00 ( 2,140. 65) 21,142. 62 92,307. 38
12-04-2009 12:58 PM
910-HRA
Economic Development
Housing & Redevelopment
DEPARTMENTAL EXPENDITURES
PAGE: 3
91.67% 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
510-4-6100-4108 Insurance
910-4-6100-4109 Workers Comp
TOTAL Personal Services
supplies
910-4-6100-4201 Office Supplies
TOTAL Supplies
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
510-4-6100-4361 Insurance
910-4-6100-4389 Utilities
910-9-6100-4401 Bldg Repair/Maim 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
TOTAL Housing & Redevelopment
53,600 .00 0 .00 26,544 .35 49. 52 27,055 .65
3,600 .00 0 .00 1,914 .95 53. 19 1,685 .05
3,350 .00 0 .00 1,744 .35 52. 07 1,605 .65
800. 00 0 .00 407 .97 51. 00 392 .03
7,200. 00 0 .00 3,478 .40 48. 31 3,721 .60
200. 00 67 .75 245 .35 122. 68 ( 45 .35)
68,750. 00 67 .75 34,335 .37 49. 94 34,414 .63
0. 00 0 .00 16 .35 0. 00 ( 16 .35)
0. 00 0 .00 16 .35 0. 00 ( 16 .35)
10,000. 00 0 .00 0 .00 0. 00 10,000 .00
40,000. 00 0 .00 3,645 .00 9. 11 36,355 .00
500. 00 2 .07 11 .87 2. 37 488 .13
16,000. 00 0 .00 0 .00 0. 00 16,000 .00
3,000. 00 146 .00 1,524 .50 50. 82 1,475 .50
3,000. 00 35 .61 458 .76 15. 29 2,541 .24
2,000. 00 2,164 .89 4,855 .45 242. 77 ( 2,855 .45)
400. 00 236 .50 236 .50 59. 13 163 .50
0. 00 0 .00 90 .00 0. 00 ( 90 .00)
74,900. 00 2,585 .07 10,822 .08 14. 45 64,077 .92
97,550. 00 0 .00 97,522 .91 99. 97 27 .09
20,650. 00 0 .00 20,645 .45 99. 98 4 .55
118,200. 00 0. 00 118,168 .36 99. 97 31 .64
9,500. 00 0.00 9,500.00 100. 00 0.00
3,500. 00 0.00 3,500.00 100. 00 0.00
13,000. 00 0.00 13,000.00 100. 00 0.00
274.850.00 2.652.82 176.342.16 64.16 98,507.84
TOTAL Economic Development 274,850 .00 2,652 .82 176,342.16 64.16 98,507. 84
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES 274,850
----------
113,450 .00
--- -
.00 ( 2,652.
----------
2,140. 82
-- -
65) 176,342.16 64.16
------------ ------- -
21,142.62 98,507.
----------
92,307. 84
--
38
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: NOVEMBER 30TH, 2009