3.4. HRSR 06-01-2009BALANCE SHEET
MARCH 2009 Page: 1
CITY OF ELK RIVER
As of: 3/31/2009 Balances
Fund Type: CU Component Unit
Fund: 910 - HRA
Assets
Acct Class: 1000 Current Assets
1010 Cash 468,660.70
1190 Notes Receivable 400,000.00
13 ] 0 Due From Other Funds 369, 125.92
Acct Class: 1000 Current Assets 1,237,786.62
Acct Class: 1600 Capital Assets
1620 Buildings & Structures 720,000.00
Acct Class: 1600 Capital Assets 720,000.00
Total Assets 1,957,786.62
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 -56,892.56
Acct Class: 2400 Fund Equity 1,637,716.33
Total Reserves/Balances 1,637,716.33
Total Liabilities & Balances i,y~ t, t~o.o~
** _ "I'he 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 tinance will do is manually insert the long-term liability in your balance sheet to more
closely reflect accrual accounting.
4-06-2009 10:12 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2009
91.0-HRA
FINANCIAL SUMMARY
CURRENT CURRENT
BUDGET PERIOD
25.00% OF YEAR COMP.
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
REVENUE SUMMARY
HRA
TOTAL REVENUES
}?XPENDITURE SUMMARY
tJCOnomic Development
Housing & Redevelopment
TOTAL Economic Development
'('O'PAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
388,300 .00 1,416 .19 4,283 .11 1.10 384,016. 89
388,300. 00 1,416 .19 4,283. 11 1.10 384,016. 89
274,850. 00 3,606. 18 61,175. 67 22.26 213,674 .33
274,850. 00 3,606. 18 61,175. 67 22.26 213,674. 33
274,850. 00 3,606. 18 61,175. 67 22.26 213,674. 33
113,450. 00 ( 2,189. 99)( 56,892. 56) 170,342. 56
4-06-2009 10:12 AM
910-HRA
REVENUES
HRA
Pr.o ert Taxes
P. __Y
910-~3-0000-3111 Current Ad Valorem Taxes
TOTAL Property Taxes
Charges _for Services
910-3-0000-3475 Building Rent
TOTAL Charges for Services
Other Revenue
910-3-0000-3621 Interest Income
TOTAL Other Revenue
'Pransfers In
910-3-0000-3947 Transfer - TIF
TOTAL Transfers In
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2009
PAGE: 2
25.OOa OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
317,000 .00 0.00 0 .00 0. 00 317,000. 00
317,000 .00 0.00 0 .00 0. 00 317,000. 00
7,800 .00 650.00 1,950 .00 25. 00 5,850. 00
7,SOD .00 650.00 1,950 .00 25. 00 5,850. 00
5,000 .00 766.19 2,333 .11 46 .66 2,666. 89
5,000 .00 766.19 2,333 .11 46 .66 2,666. 89
58,500. 00 0.00 0 .00 0 .00 58,500. 00
58,500. 00 0.00 0 .00 0 .00 58,500. 00
TOTAL HRA 388,300.00 1,416.19 4,283.11 1.10 384,016.89
'TOTAL REVENUE 388,300.00 1,916.19 4,283.11 1.10 389,016.89
------------- ------------- ------------- ------- -------------
4-~06-2009 10:12 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2009
910-HRA
Economic Development 25 .00% OF YEAR CO MP.
Housing ~ Redevelopment
CURREN T CURRENT YEAR TO DATE % OF BUDGE T
DEPARTMENTAL EXPENDITURES BUDGE T PERIOD ACTUA L BUDGET BALANC E
personal Services
910-4~-6100-4101 Regular Pay 53,600 .00 0 .00 ( 1,590 .24) 2 .97- 55,190 .24
910-4-6100-4104 PERA 3,600 .00 0 .00 0 .00 0 .00 3,600 .00
910-4-6100-4105 FICA 3,350 .00 0 .00 0 .00 0 .00 3,350 .00
910-4-6100-4107 Medicare 800 .00 0 .00 0 .00 0 .00 800 .00
910-4-6100-4108 Insurance 7,200 .00 0 .00 0 .00 0 .00 7,200 .00
910-4-6100-4109 Workers Comp 200 .00 0 .00 59 .20 29 .60 140 .80
TOTAL Personal Services 68,750 .00 0 .00 ( 1,531 .04) 2 .23- 70,281 .04
Pu lies
PL' - - --
910-4-6100-4201 Office Supplies 0 .00 0. 00 16 .35 0 .00 1 1.6 .35)
___
'TOTAL Supplies 0 .00 0. 00 16 .35 0 .00 ( 16 .35)
Other Services & Charges
91.0-4-6100-4304 Legal Fees 10,000 .00 0. 00 0 .00 0. 00 10,000 .00
91.0-4-6100-4319 Other Professional Services 40,000 .00 3,550. 00 3,550 .00 8. 88 36,950 .00
910-9-6100-4322 Postage 500 .00 0. 00 0 .00 0. 00 500 .00
910-4-6100-4359 Publishing 16,000 .00 0. 00 0 .00 0. 00 16,000 .00
910-4-6100-4361 Insurance 3,000 .00 0. 00 0 .00 0. 00 3,000 .00
910-4-6100-4389 Utilities 3,000 .00 56. 18 56 .18 1. 87 2,943 .82
910-4-6100-4401 Bldg Repair/Maint Services 2,000 .00 0. 00 0 .00 0. 00 2,000 .00
91.0-4-6100-4933 Dues & Subscriptions 400 .00 0. 00 0 .00 0. 00 400 .00
TOTAL Other Services & Charges 74,900 .00 3,606. 18 3,606 .18 4. 81 71,293 .82
llebt Service
910-4-6100-4601 Principal 97,550. 00 0. 00 48,040 .89 99. 25 49,509 .16
91.0-4-6100-4611 Interest - 20,650. 00 O. UO 11,043. 34 53. 48 9,606 .66
'TOTAL Debt Service 118,200. 00 0. 00 59,084. 18 49. 99 59,115 .82
eransfers Out
910-4-6100-4721 Transfer-General Fund 9,500. 00 0. 00 0. 00 0. 00 9,500. 00
910-4-6100-4735 Transfer-EDA - 3,500._ 00 0. 00 0. 00 0. 00 3,500. 00
TOTAL Transfers Out 13,000. 00 0. 00 0. 00 0. 00 13,000. 00
'1'01'AL Housing & Redevelopment 274,850. 00 3,606. 18 61,175. 67 22. 26 213,679. 33
TOTAL Economic Development 274,850. 00 3,606. 18 61,175. 67 22. 26 21.3,674. 33
'!'D'I'AL EXPENDITURES 274,850. 00 3,606. 18 61,175. 6'7 22. 26 213,674. 33
REVENUES OVER/(UNDER) EXPENDITURES 113,450. 00 ( 2,189. 99)( 56,892. 56) 170,342. 56
4-06-2009 10:24 AM D E T A I L L I S T I N G PAGE: 1
FUND 910-HRA PERIOD TO USE: Mar-2009 T HRU Mar-2009
DEPT 6100 Housing & Redevelopment SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAM # REFERENCE PACKET======DESCRIPTION=== ==_= VEND INV/PO/JE # NOTE =====AMOUNT==== ====BALANCE ====
f'UND: 910-HRA
4-6100-4 319 Other Professional Services
B E G I N N I N G B A L A N C E 0 .00
3/02/09 2/27 A00028 CHK: 001609 00235 NSP GRANT P ROJECT 31462 3,550 .00 3,550 .00
S E H, INC INV# 214346 /PO#
------------= MARCH ACTIVITY DB: 3,550.00 CR: 0.00 3,550 .00
4-6100-4 389 Utilities
B E G I N N I N G B A L A N C E 0 .00
llEPT: 6100 Housing & Redevelopme nt
3/02/09 2/27 A00027 CHK: 001608 00235 WATER/ELEC 720 MAIN 17440 35 .26 35 .26
CITY OF ELK RIVER INV# 012509 /PO#
3/29/09 3/24 A00029 CHK: 001610 00259 NATURAL GAS 720 MAIN 13845 20 .92 56 .18
CENTERPOINT ENERGY INV# 031009 /PO#
_____________ MARCH ACTIVITY DB: 56.18 CR: 0.00 56 .18
000 ERRORS IN THIS REPORT
** REPORT TOTALS ** --- DEBITS --- --- CREDITS ---
BEGINNING BALANCES: 16.35 0.00
REPORTED ACTIVITY: 3,606.18 0.00
ENDING BALANCES: 3,622.53 0.00
BALANCE SHEET
APRIL 2009 Page: 1
CITY OF ELK RIVER
As of: 4/30/2009 Balances
Fund Type: CU Component Unit
Fund: 910 - HRA
Assets
Acct Class: 1000 Current Assets
1010 Cash 468,279.85
1190 Notes Receivable 400,000.00
1310 Due From Other Funds 369,125.92
Acct Class: 1000 Current Assets 1,237,405.77
Acct Class: 1600 Capital Assets
1620 Buildings & Structures 720,000.00
Acct Class: 1600 Capital Assets 720,000.00
Total Assets 1,957,405.77
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 -57,273.41
Acct Class: 2400 Fund Equity 1,637,335.48
Total Reserves/Balances 1,637,335.48
Total Liabilities & Balances 1,957,405.77
** =The City's financial system is on the modified accrual basis of accountingand 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.
5-06-2009 10:52 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2009
910-HRA
FINANCIAL SUMMARY 33. 33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
HRA 388,300 .00 702. 86 4,985 .97 1. 28 383,319.03
TOTAL REVENUES 388,300 .00 702. 86 4,985. 97 1. 28 383,314.03
EXPENDITURE SUMMARY
Economic Development
Housing & Redevelopment 274,850. 00 1,083. 71 62,259. 38 22. 65 212,590.62
TOTAL Economic Development 274,850. 00 1,083. 71 62,259. 38 22. 65 212,590.62
TOTAL EXPENDITURES 274,850. 00 1,083. 71 62,259. 36 22. 65 212,590.62
REVENUES OVER/(UNDER) EXPENDITURES 113,450. 00 ( 380. 85)( 57,273. 41) 170,723.41
5-06-2009 10:52 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2009
910-HRA
33.331 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
HRA
Property Taxes
910-3-0000-3111 Current Ad Valorem Taxes
TOTAL Property Taxes
Charges for Services
910-3-0000-3475 Building Rent
TOTAL Charges for Services
Other Revenue
910-3-0000-3621 Interest Income
TOTAL Other Revenue
Transfers In
910-3-0000-3947 Transfer - TIF
TOTAL Transfers In
TOTAL HRA
TOTAL REVENUE
317,000 .00 0 .00 0 .00 0 .00 317,000 .00
317,000 .00 0 .00 0 .00 0 .00 317,000 .00
7,800 .00 0. 00 1,950 .00 25 .00 5,850 .00
7,800 .00 0. 00 1,950 .00 25. 00 5,850 .00
5,000. 00 702. 86 3,035. 97 60. 72 1,964 .03
5,000. 00 702. 86 3,035. 97 60. 72 1,964 .03
58,500. 00 0. 00 0. 00 0. 00 58,500. 00
58,500. 00 0. 00 0. 00 O. OD 58,500. 00
388,300. 00 702. 86 4,985. 97 1. 28 383,314. 03
388,300. 00 702. 86 4,985. 97 1. 28 383,314. 03
5-06-2009 10:52 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: APRIL 30TH, 2009
910-HRA
Economic Development
Housing & Redevelopment
DEPARTMENTAL EXPENDITURES
33.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
910-4-6100-4101 Regular Pay
910-9-6100-9104 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
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
910-4-6100-4361 insurance
910-4-6100-4389 Utilities
910-4-6100-4401 Bldg Repair/Maint Services
910-4-6100-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Debt Service
910-4-6100-4601 Principal
910-4-6100-4611 Interest
TOTAL Debt Service
Transfers Out
910-9-6100-4721 Transfer-General Fund
910-4-6100-4735 Transfer-EDA
TOTAL Transfers Out
53,600.00 0 .00 ( 1,590 .24) 2 .97- 55,190 .24
3,600.00 0 .00 0 .00 0 .00 3,600 .00
3,350.00 0 .00 0 .00 0 .00 3,350 .00
800.00 0 .00 0 .00 0 .00 800 .00
7,200.00 0 .00 0 .00 0 .00 7,200 .00
200.00 59. 20 118 .40 59 .20 81 .60
68,750.00 59. 20 ( 1,971 .84) 2 .14- 70,221 .84
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,550. 00 8. 88 36,950. 00
500.00 0. 00 0. 00 0. 00 500. 00
16,000.00 0. 00 0. 00 0. 00 16,000. 00
3,000.00 689. 25 689. 25 22. 98 2,310. 75
3,000.00 35. 26 91. 44 3. 05 2,908. 56
2,000.00 300. 00 300. 00 15. 00 1,700. 00
400.00 0. 00 0. 00 0. 00 400. 00
74,900.00 1,024. 51 4,630. 69 6. 18 70,269. 31
97,550 .00 0.00 48,040.84 49 .25 49,509.16
20,650 .00 0.00 11,043.34 53 .48 9,606.66
118,200 .00 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
274,850.00 1,083.71 62,259.38 22.65 212,590.62
TOTAL Economic Development 274,850.00 1,083.71 62,259.38 22.65 212,590.62
TOTAL EXPENDITURES 274,850.00 1,083 .71 62,259. 38 22.65 212,590 .62
REVENUES OVER/(UNDER) EXPENDITURES 113,450.00 ( 380. 85)( 57,273. 91) 170,723. 41
5-06-2009 10:54 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: Apr-2009 TH RU Apr- 2009
DEPT 6100 Housing & Redevelopment SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE TRAN # REFERENCE PACKET======DESCRIPTION=====_= VEND INV/PO/JE # NOTE =====AMOONT==== ====BALANCE====
FOND: 910-HRA
4-6100-4361 Insurance
B E G I N N I N G B A L A N C E 0 .00
4/06/09 4/02 A00030 CHK: 001611 00257 QTRLY INS ALLOCATION 17440 689 .25 689 .25
CITY OF ELK RIVER INV# 040620 09 /PO#
------------= APRIL ACTIVITY DB: 689.25 CR: 0.00 689 .25
4-6100-4389 Utilities
B E G I N N I N G B A LAN C E 56 .18
DEPT: 6100 Housing & Redevelopment
4/06/09 5/04 B08044 00470 ERMU - WATER/ELEC 720 MAIN JE# 003071 35. 26 91. 49
_____________ APRIL ACTIVITY DB: 35.26 CR: 0.00 35 .26
4-6100-9401 Bldg Repair/Maint Services
B E G I N N I N G B A L A N C E 0. 00
4/06/09 5/04 B08060 00470 REPAIR ROOF - 716 MAIN JE# 003111 300. 00 300. 00
_____________ APRIL ACTIVITY DB: 300.00 CR: 0.00 300. 00
4-6100-4440 Miscellaneous
B E G I N N I N G B A L A N C E 0. 00
4/06/09 4/02 A00031 CHK: 001612 00257 WATER/ELEC 720 MAIN 17700 35. 26 35. 26
ELK RIVER MUNICIPAL UTILI INV# 032520 09 /PO#
4/06/09 4/02 A00032 CHK: 001613 00257 REPAIR ROOF 716 MAIN 10169 300. 00 335. 26
J. SPANJERS COMPANY INC INV# 857 /PO#
9/06/09 5/04 B08094 00470 ERMU - WATER/ELEC 720 MAIN JE# 003071 35. 26CR 300. 00
4/06/09 5/04 B08060 00470 REPAIR ROOF - 716 MAIN JE# 003111 300. 000R 0. 00
_____________ APRIL ACTIVITY DB: 335.26 CR: 335.26CR 0. 00
*-*-*-*-*-*-*-*-*-*-*-*-*- 000 ERRORS IN THIS REPORT! +_*_*_*_*_._*_+_+_*_*_._._*
** REPORT TOTALS ** --- DEBITS ---
BEGINNING BALANCES: 3,622.53
REPORTED ACTIVITY: 1,359.77
ENDING BALANCES: 4,982.30
--- CREDITS ---
0.00
335.26CR
335.26CR