3.2. HR CHECK REGISTER 03-01-20102/.25/2010 5;D5 PM
VENDOR SET. 01 CITY OP ELK RIVER
FUND ; 911 NSP
DEPARTMENT; 611 NSP Admin
INVOICE DATE RANGE; 1/01/199$ THRU 99/99/9999
FAY DATE RANGE; 2/01/2010 THRU 3/01/201.0
BUDGET TO USE. CB-CURRENT BUDGET
REGULAR DEPARTMENT PAYMENT REPORT
PAGE; 1
YT ~.2®
BANK; NSF
VENDOR NAME ITEM ## G/L ACCOUNT NAME DESCRIPTION CHECK ## AMOUNT
01M1q$32 TRI-COUNTY ACTION FROG I-DE9~2 91.1, 4-6110-44D9 Contractual S; ADMINISTRATION COSTS 001663 1,545,49
VENDOR 01.-10$32 TOTALS 1,595,49
DEPARTMENT 6110 NSF Admin TOTAL; 1,545.49
01-10832 TR:C-COUNTY ACTxON FROG I-DN1-01 911 461.12-4409 Contractual S; DOME ACQ 10$27 181ST D01667 8,21.2,22
VENDOR 01-10832 TOTALS 8,212,22
DEPARTMENT 6112 Acquisition/ReY~ab TOTAL; $,212.22
VENDOR SET 911 NSP TOTAL; 9,757,71
REPORT GRAND TOTAL; 9,757,71
2/25/2010 5.02 PM
VENDOR SET ; 01 CITY OF ELIC RTVIaR
FUND ; 91a HRA
DEPARTMENT; b10 Housing & Redevelopment
INVOICE DATE RANGE; 1/01/199$ THRU 99/99/9999
PAY DATE RANGE. 2/01/2010 THRU 3/01/2010
BUDGET TC} USE; CB-CURRENT BUDGET
REGULAR DEPARTMENT PAYMENT REPORT
PAGE; 1
BANKc HRA
VENDOR NAME ITEM # G/L ACCOUNT NAME DESCRIPTION CHECK # AMOUNT
01 13845 CENTERPOTNT ENERGY I-01072010 910 ~-b100-4389 Utilities NATURAT, GAS 720 MAIN 001661 10,50
07.13845 CENTERPOINT ENERGY T-020510, 910 4-6100-4389 Utilities NATURAL GAS 720 MAIN 001664 10,50
VENDOR 0113845 TOTALS 21,00
01-17440 CITY OIL' ETaK RIVER I-012x10 910 4-6140-9389 Utilities ET,EC/WATER 720 MAxN 001665 35.61
01-17440 CITY OF ET,K RIVER I-02D110 910 4~6100~4101 Regular Pay RETMB SATa/INS DEC 09 001662 8,189,92
01-17940 CITY OF ELK RIVER T-020110 910 4-6100-4104 PERA ; RETMB SAT,/INS DEC 09 001662 563,46
D1~17440 CITY OF ELK RIVER T-020110 910 4w6100-4105 FICA ; RETMB SAL/INS DEC 09 001662 507,78
01-17490 CITY OF ELK RIVER T-020110 910 4-6100rv4107 Medicare ; RETMB SAL/INS DEC 09 001662 118,76
01 17940 CITY OF ELIC RIVER T-020110 910 4M6100~4108 Insurance RETMB SATa/INS DEC 09 001662 717,60
01 17490 CITY OF ELK RIVER T-020110 910 4-6100W4109 Workers Comp ; RETMB SAT,/INS DEC 09 001662 67,75
01-17490 CITY OF ELK RIVER T-020110 910 4 6100-4361 Insurance REIMS SAT,/INS DEC 09 001662 702.85
01-17440 CITY OF IaLK RIVER I-123109 910 4-6100-4322 Postage ; POSTAGE FOR METER 001662 30,80
VENT)OR 01-1'7440 TOTALS 10, 934.13
01-17700 RLK RIVER MUNICTPATa UT T-030110 910 4-6100-4389 Utilities WATER/ELEC "120 MAIN 001666 35,b1
VENDOR D1-17700 TOTAT,S 35,b1
DEPARTMENT 6100 Housing & Redevelopment TOTAL; 10,99D,74
VENDOR SET 910 HRA TOTAL; 10,990,79
REPORT GRAND TOTAL; 10,990,74
~A~ANC~ ~~ET ~'~' .3
Page: 1
JANUARY 2a 1 a
CITY OF GLK RIVER
As of; 011311za1 a Balances
Fund Type: CU Component Unit
Fund, 9l0 w HRA
Assets
Acct Class; 1 aaa Current Assets
I a 1 a Cash 693,971,08
119a Notes Receivable 9aa,aaa,aa
131 a Due From Other Funds 349,718,11
Acct Class; 1440 Current Assets 1,353,689,19
Acct Class; 1644 Capital Assets
16~a Buildings & Structures 7~a,a00,04
Acct Class; 1644 Capital Assets 724,444,44
Total Assets 2,473,689,19
Liabilities
Acct Class: 2Qa4 Current Liabilities
Accounts Payable 91.30
Building PuI•chase ~non~current liability}~~ 219,621,69
Acct Class: 244() Current Liabilities 219,G62,99
Total liabilities 219,662,99
RcserveslBalances
Acct C1a55; 294~~ Fund Egl~ity
2944 Fund Balance 1,795,057,99
2644 Change ~Il Fund Balance 58,968,71
Acct Class; 2440 Fund Equity 1,859,426,24
Total ReserveslBalances 1,859,426,20
TDtal Llabl lltles ~G BalaI1ce5 2 473 689,19
~~ = Tl~e City's financial system is on the t~za~i~ed accrual basis of accaunling and the cur~enf frnanc~al r°e~oacrces jneasarre~~aen~, focus.
"Government fl~nds, with their focus on current financial resources, do not report liabilities far the following. Unmatured principal and interest
of long-teI•m debt" (GAAFR, page 179}, The City records long-term debt related liabilities as part ofthe GASB 39 conversion entries and will
slaw up on your year-end accr~~al statements, V~hat finance will do is manually insert the long~tern~ liability in your balance sheet to more
closely reflect accrual accounti~~g,
2-11-2x10 ae;4~ AM
910-}BRA
FINANCIAL SUMMARY
CITY OF ELK RIMER
REVENUE & EXPENSE REPORT UNAUDITED)
AS OF: UANUARY 31ST, 2010
PAGE ; ~~ m ~
08.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF SUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
HRA 350,400,00 646.96 646.96 0.1$ 349,753.04
TOTAL REVENUES 350x400.00 646,96 646.96 0.18 349x753,04
EXPENDITURE SUMMARY
Economic Development
1-dousing & Redevelopment.
TOTAL Economic Development
TOTAL EXPENDITURES
REVENUES AVER/(UNDER) EXPENDITURES
267x550,00 67,241,44 67,241.49 25.13 200x30$,56
257x550,00 67x241.44 67x241,44 25,13 200x30$.56
267,550.00 67,241,49 67,241.44 25,13 200,308.56
$2x650.00 ~ 66x594,4$}( 66x594,48) 199x444.9$
2-11-2010 08:45 AM CITY OF ELK RIVER PAGE; 2
REVENUE & EXPENSE REPORT ~UNAUDTTED~
AS OF; JANUARY 31ST, 2010
910-HRA
REVENUES
08,330 OE YEAR COMP.
CURRENT CURRRNT YEAR TO DATE ~ OF BUDGET
BUDGRT PERTOD ACTUAL BUDGET BALANCE
HRA
Taxes
910-3~OOg0-3111 Current A~ Valorem Taxes
TOTAL Taxes
Intergavarnmental Rev
Charges far Services
Other Revenue
910-3-0000-3621 Tnterest xncame
TOTAL Other Revenue
Transfers Tn
910-3-0000-3947 Transfer - TTP
TOTAL Transfers Tn
304,700,00 1,04 1,04 0,00 309,598,96
304,700,00 1,04 1,04 O,Oq 309!698,96
6,000,00 645,92
5,000,00
39,700.00 545,92
a.oa
39,700,00 0,00
645.92 10,77 5,354,08
645,92 10,77 5,354,08
o,oo 0.00 39,700,00
O,oq o,a0 39,700.00
TOTAL HRA 350,400.00 646.95 646,96 0,18 349,753,04
TOTAL REVENUE 350,400.00 646.96 646.96 0,18 349,753,09
2-11-2010 Da;45 AM CITY OF EL~C RIVER PAGE; 3
REVENUE & EXPENSE REPORT ~UNAUDITED~
AS OF; ~7ANUARY 31ST, 2010
91a-HRA
Econanic Develapment
dousing & Rede~elapment
DEPARTMENTAL EXPENDITURES
08,33% OF YRAR CAMP,
CURRENT CURRENT REAR TQ DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
910-4-6100-4101 Regular Pay
91x-4-6100-41D9 PERA
910-4-61x0-41D5 FICA
910-4-61xD--4107 Medicare
91x-4-6104-4108 Insurance
91x-4-61xD-4109 Workers Comp
TOTAL Personal Services
STupplies
Other Services & Cha~'ges
910-4-61Dx-43D4 Legal Fees
910-4-61D0-4319 Other Professional Services
910-9-6100-4322 Postage
91D-4-614D-4359 Publ~.shing
910-4-6100-4361 Insurance
910 4-61x0-93$9 Utilities
914-4-6100-4401 Bldg Repair/Taint Services
9109-G10D-4433 Dues & Subscriptions
910-4-6100-4440 Miscellaneous
TOTAL Other Services & Charges
Debt Service
910-4-6100-4601 Principal
91D-4-6100-9611 Interest
TOTAL Debt Service
Transfers Out
910-4-6100-4721 Transfer-General. Fund
910-4-610D-4'735 Transfer-EDA
TOTAL Transfers out
53,25x,00 i 1,892.74)[ 1,842.74) 3,96- 55,092,74
3,75D,D0 O.DO x.x0 0.00 3,75x.00
3,300,00 O.Oa 0.00 D,DO 3,30D.00
$aa.ao a.aD o.oa D,aa aDD.aa
6,550.00 D.DD 0.00 D,aa 6,55x.00
25a.ao D.DD a,oa o,ox z5a.oa
67,900,Ox ~ 1,842.741( 1,842,74} 2,71 69,742.74
lD,aao.oa a,ox o,aa o,oD 1D,aax.ao
3z,5aa,oD D,ox a,ao D,oo 32,5oa.ao
5a0.oa a,oa a.ao o,aa 5aa,ox
16,ODO.DO x.00 0,x0 D,aO 16,000.00
3,zoa.aD a.oo D.oa a.oa 3,2ao.aD
3,OOD.00 D,DO D.00 a.DO 3,x00,00
3,aaa,DD O,aO a.Ox 0,00 3,OOO.DD
25a,ao a,oD a.aa o,aD 250,00
x.00 10,ODO.OD 10,aa0.Da D,00 ( 10,Oxo.Oa)
68,45x.00 10,a0a.DD 10,ODD.oO 14,61 5$,45x,00
1D3,500,a0 50,966.53 50,966,53 49,24 52,533.47
14,700,00 8,117,65 $,117.65 55,22 5,582,35
118,200.DD 59,0$4,18 59,0$4.18 49,99 59,7.15.82
9,50x,xD 0,00 O.Oa 0.00 9,5DO.Do
3,500,00 0,00 O,Oa 0.00 3,500.00
13,Oa0.a0 0.00 D,DD D.00 13,000.00
TOTAL Housing & Redevelopment 267,550.06 67,241,44 67,241.44 25.13 20x,30$,56
TOTAL Economic Development 267,550.x0 67,241,44 67,241,44 25.13 200,308.56
TOTA1, EXPENDITURES 267,550.D0 67,241.44 67,241,44 25.73 20D,3D$.56
REVENUES OVER/[UNDER) EXPENDITURES 82,850.00 ( 66,594.48}( 66,594.48) 149,444.48
2-11-2010 10;26 AM D E T A I L L I S T I N G PAGE: 1
FUN17 ; 910-HRA ACTIVE ACCOUNTS ONLY PERIOD TO USE; Jan-2010 THRU Jan--201D
DEPT ; 6100 Housing & Redevelopment SUPPRESS ZEROS ACCOUNTS: ALL
POST DATE IRAN # REFE~tENCE PACKET-=====DESCRIPTION==~=w~M VEND TNV/PO/+7E # NOTE =-===AMOUNTw~~- ~~~=BALANCE=-==
46100-4361 Insurance
B EGTNNxNG BALANCE 0,00
1/11/10 1/12 R41017 ITEM POSTING 00362 insurance Premium - January 201D01111221 109,08CR 109,08CR
AR CUSTOMER SET D1 CUSTOMER NUMBER ERART
1/11/14 2/03 816830 Deposit 404004 D0928 ARTS ALLIANCE INS, PREMIUM JE# 006048 109.08 0.00
w...._______~_~ JANUARY ACTIVITY DB; 109,08 CR; 149,48CR 4.00
~-61004440 Miscellaneous
' B EGI NNI NG BALANCE O~OD
1/'27/14 2/09 H16873 M ao0044 00959 Prism Title - NSP funds JE# 006107 0060 10,004.00 10,000,00
~_____.~..~.~~.mW JANUARY ACTTVTTY D~3: 10, 000 , 00 CR; 0 , 04 14, 000 , 00
4-6100-4601 Principal
BEGTNN I NG BALANCE 0,00
1/04f14 12/30 A12770 CHK; 001659 00997 716/720 MAIN ST CD 21633 50,956,53 50,966.53
HOULTON INVESTMENT COMPAN TNV# 010410 /PO#
__w~~..__..___= JANUARY ACTTVTTY DB; 50,966,53 CR; 0,00 50,966,53
4-6100-9611 Interest
B EGINNI NG BALANCE 0,00
1/04/10 12/30 A12770 CHK; 001659 00497 716/720 MAIN ST CD 21633 8,117,65 8,117.65
HOULTON INVESTMENT COMPAN TNV# 010410 /PO#
____~M____-_~ JANUARY ACTTVTTY DB; 8,117,55 CR; 0,00 8,117,65
*-~_*..*-~_*_~_*_*-~-~_~_~- 000 ERRORS TN THIS REPORT; ,r_~-,r_*~~_*_*_~-,r_~_~_,r_~_*
~* REPORT TOTALS ~~ -_- DEBITS ~-- ~-- CREDITS ---
BEGTNNING BALANCES: 0,00 0,00
REPORTED ACTTVTTY; 69,193,25 109,OSCR
ENDING BALANCES; 69,193,26 109,QSCR