Loading...
HomeMy WebLinkAbout[05] Accounts Payable and Financial ReportCITY OF ST. JOSEPH vvww.cityof stiosepli.ccm DATE: October 16, 2013 The reports consist of: 1. Monthly Report. 2. Balance Sheet. 3. EDA revenue to date. 4. EDA expenditures to date. 5. Check Register 6. CIP Summary A MOTION is in order to approve the Financial Reports. Page 6 of 40 MEMO TO: St. Joseph Economic Development Authority FROM: Cynthia Smith - Strack Municipal Development Group Administrator Judy Weyrens RE: Accounts Payable September Financial Reports Mayor Richard Schultz A. Accounts Payable: Councilors Following are Accounts Payable for the EDA's Consideration. Steve Frank Bob Loso Payable To For Fund Amount Renee Symanietz MDG, Inc. Sept. Econ. Dev. Service 150 - 46500 -300 $ 2,622.62 Dale Wick $2,200 services, $422.62 mileage Total $ 2,622.62 EDA Doug Danielson 'Plus invoices noted on enclosed check register. Steve Frank Larry Hosch Through September 30th a total of 324.50 contract hours have been provided; 95.50 hours Gary Osberg remain on the contract. Dale Wick Action: A MOTION is in order to approve the Accounts Payable. B. Financial Report: September financial reports are attached for your consideration. The reports consist of: 1. Monthly Report. 2. Balance Sheet. 3. EDA revenue to date. 4. EDA expenditures to date. 5. Check Register 6. CIP Summary A MOTION is in order to approve the Financial Reports. Page 6 of 40 4% MUNICIPAL DEVELOPMlNT GROUP, INC. 25562 WILLOW LANE NEW PRAGUE, MN 56071 952 - 758 -7399 FAX: 952 - 758 -3711 staff @municipaldevelopmentgroup.com INVOICE City of St. Joseph Attn: Judy Weyrens City Administrator PO 668 St. Joseph, MN 56374 Invoice Date 10 -10 -13 Payment Terms: 30 days Customer ID #: STJ 13EDA Project Aug Economic Development Services Amount: $2,200.00 Monthly contract fee 422.62 748 miles x.565 $2,622.62 Code to: 150 - 46500 -300 for general EDA Remit To: Municipal Development Group, Inc. 25562 Willow Lane New Prague, MN 56071 Dates -EDA Hours September 4, 2013 EDA Office Hours: C. Strack 8.00 Hours September 6, 2013 EDA Office Hours: C. Strack in MDG Office 4.50 Hours September 11, 2013 EDA Office Hours: C. Strack 7.50 Hours September 11, 2013 EDA Office Hours: J. Anderson in MDG Office 0.50 Hours September 18, 2013 EDA Office Hours: C. Strack 7.50 Hours September 25, 2013 EDA Office Hours: C. Strack 9.00 Hours Total September 2013 37.00 Hours Total Contract Hours September 30, 2013: 324.50 Hours Check No. Date: Thank you! We appreciated the opportunity to work with you! Page 7 of 40 Principal St. Joseph Economic Development Authority Summary Treasurer's Report - Fund 150 September 2013 Fund 150, EDA Balance as of December 31, 2012 (audited) Year to Date Revenue: Interest Earnings DEED Housing Fees Ad Valorem Taxes Total Revenue Year to Date Expenditure Total by Project: Market Development Business Development Organizational Development Infrastructure Development Workforce Development Year to Date Exoenditures by Object: Board Stipends Staff Salaries Workers Comp Premium Office Supplies Software Support Municipal Development Group Legal /Engineering Fees Telephone Postage Business Luncheon Marketing Advertising Rentals (Postage Machine) EDA Programs Total Expenses Fund Summaries as of September 30,2013: 8,672.79 13,165.41 " 4,015.83 25,854.03 EDA Fund Balance - Fund 150 - unaudited Designated for Capital Programs Designated for DEED Housing Projects Undesignated TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 TIF 2 -2 St. Joseph Meat Market Fund Balance - Fund 158 Revolving Loan Fund Balance - Fund 250 "" Detail available upon request Page 8 of 40 38.63 11,250.00 65.505.67 (107.14) (2.57) (622.93) (17,556.51) (578.87) (2,736.07) (30.62) (6.093.69) 77,651.57 76,794.30 (27.728.40) 126.717.47 39,086.44 15,368.57 72,262.46 12,516.10 (558.28) 28,787.28 CITY OF ST. JOSEPH EDA Balance Sheet Current Period: September 2013 YTD YTD Current FUND Descr Account Descr Begin Yr Debit Credit Balance FUND 150 Economic Development Economic Development G 150 -10100 Cash Economic Development G 150 -10450 Interest Receivable Economic Development G 150 -10700 Taxes Receivable - Delinquen Economic Development G 150 -13113 Due From other Gov t Units Economic Development G 150 -15500 Due From Other Fund Economic Development G 150 -20200 Accounts Payable Economic Development G 150 -22204 Deferred Revenue Economic Development G 150 -24415 Design. Fd Bal - Capital Proj Economic Development G 150 -25310 Appropriated Fund Balance FUND 150 Economic Development FUND 157 TIF 2 -1 Mills TIF 2 -1 Millstream TIF 2 -1 Millstream TIF 2 -1 Millstream TIF 2 -1 Millstream TIF 2 -1 Millstream tream G 157 -10100 Cash G 157 -10450 Interest Receivable G 157 -13113 Due From other Gov t Units G 157 -20200 Accounts Payable G 157 -25310 Appropriated Fund Balance FUND 157 TIF 2 -1 Millstream FUND 158 TIF 2 -2 Meat Market TIF 2 -2 Meat Market G 158 -10100 Cash TIF 2 -2 Meat Market G 158 -20500 Due To Other Fund TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance FUND 158 TIF 2 -2 Meat Market FUND 250 Revolving Loan Fund Revolving Loan Fund Revolving Loan Fund Revolving Loan Fund Revolving Loan Fund Revolving Loan Fund Revolving Loan Fund FUND 250 Revolving Loa G 250 -10100 Cash G 250 -10450 Interest Receivable G 250 -11900 Notes Receivable G 250 -20200 Accounts Payable G 250 -22204 Deferred Revenue G 250 -25310 Appropriated Fund Balance n Fund $79,525.68 $102,750.26 $56,058.47 $126,217.47 $75.73 $0.00 $75.73 $0.00 $893.10 $0.00 $893.10 $0.00 $351.51 $0.00 $351.51 $0.00 $500.00 $0.00 $0.00 $500.00 - $2,801.35 $2,801.35 $0.00 $0.00 - $893.10 $893.10 $0.00 $0.00 - $13,296.71 $0.00 $0.00 - $13,296.71 - $64,354.86 $56,485.71 $105,551.61 - $113,420.76 $0.00 $162,930.42 $162,930.42 $0.00 $10,832.25 $41,946.34 $40,262.49 $12,516.10 $12.43 $0.00 $12.43 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 - $10,844.68 $40,274.92 $41,946.34 - $12,516.10 $0.00 $82,221.26 $82,221.26 $0.00 $30.02 $2,425.11 $2,513.41 - $58.28 - $500.00 $0.00 $0.00 - $500.00 $469.98 $2,513.41 $2,425.11 $558.28 $0.00 $4,938.52 $4,938.52 $0.00 $22,746.98 $6,336.18 $295.88 $28,787.28 $24.25 $0.00 $24.25 $0.00 $36,130.90 $0.00 $36,130.90 $0.00 $0.00 $0.00 $0.00 $0.00 - $36,130.90 $36,130.90 $0.00 $0.00 - $22,771.23 $320.13 $6,336.18 - $28,787.28 $0.00 $42,787.21 $42,787.21 $0.00 $0.00 $292,877.41 $292,877.41 $0.00 Page 9 of 40 10/16/13 9:22 AM Page 1 CITY OF ST. JOSEPH EDA Revenue Report Current Period: September 2013 10/16/13 9:31 AM Page 1 FUND 157 TIF 2 -1 Millstream TIF 2 -1 Millstream 31050 Tax Increment 2013 September 2013 FUND Descr SOURCE SOURCE Descr YTD Budget 2013 Amt YTD Amt FUND 150 Economic Development 34150 TIF /MIF Deposit $0.00 $0.00 $0.00 Economic Development 31010 Current Ad Valorem Taxes $126,095.00 $0.00 $65,505.67 Economic Development 33160 Federal Grants - Other $0.00 $0.00 $0.00 Economic Development 34150 TIF /MIF Deposit $0.00 $0.00 $0.00 Economic Development 34200 DEED Housing Reimbursem $0.00 $11,250.00 $11,250.00 Economic Development 36210 Interest Earnings $500.00 $373.67 $38.63 Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00 FUND 150 Economic Development 39201 Transfers from Other Funds $126,595.00 $11,623.67 $76,794.30 FUND 157 TIF 2 -1 Millstream TIF 2 -1 Millstream 31050 Tax Increment $0.00 $0.00 $19,002.78 TIF 2 -1 Millstream 33404 Market Value Credit $0.00 $0.00 $0.00 TIF 2 -1 Millstream 34150 TIF /MIF Deposit $0.00 $0.00 $0.00 TIF 2 -1 Millstream 36210 Interest Earnings $0.00 $52.28 -$8.60 FUND 157 TIF 2 -1 Millstream $0.00 $52.28 $18,994.18 FUND 158 TIF 2-2 Meat Market TIF 2 -2 Meat Market 31050 Tax Increment $0.00 $0.00 $1,864.26 TIF 2 -2 Meat Market 34150 TIF /MIF Deposit $0.00 $0.00 $0.00 TIF 2 -2 Meat Market 36210 Interest Earnings $0.00 $1.11 $0.61 TIF 2 -2 Meat Market 39201 Transfers from Other Funds $0.00 $0.00 $0.00 FUND 158 TIF 2 -2 Meat Market $0.00 $1.11 $1,864.87 FUND 250 Revolving Loan Fund Revolving Loan Fund 36210 Interest Earnings $300.00 $88.00 - $45.90 Revolving Loan Fund 39320 Revolving Loan Principal $7,095.00 $594.98 $5,301.75 Revolving Loan Fund 39321 Revolving Loan Interest $985.00 $78.57 $760.20 Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00 FUND 250 Revolving Loan Fund $8,380.00 $761.55 $6,016.05 $134,975.00 $12,438.61 $103,669.40 Page 10 of 40 CITY OF ST. JOSEPH EDA Expenditure Report Current Period: September 2013 10/16/13 9:24 AM Page 1 FUND 157 TIF 2 -1 Millstream E 157 - 46500 -101 Salaries 2013 September 2013 Account Descr YTD Budget 2013 Amt YTD Amt FUND 150 Economic Development $0.00 $0.00 $5.66 E 150 - 46500 -101 Salaries $0.00 $0.00 $91.92 E 150 -46500 -103 Legislative Bodies $1,260.00 $0.00 $0.00 E 150 -46500 -121 PERA Contributions $0.00 $0.00 $6.67 E 150 - 46500 -122 FICA Contributions $0.00 $0.00 $5.66 E 150 - 46500 -123 Deferred Comp- Employer $0.00 $0.00 $1.57 E 150 -46500 -125 Medicare Contributions $0.00 $0.00 $1.32 E 150 -46500 -151 Workers Comp. Insur. Prem. $10.00 $0.00 $2.57 E 150 -46500 -200 Office Supplies $500.00 $0.00 $0.00 E 150 - 46500 -215 Software Support $540.00 $0.00 $622.93 E 150 -46500 -300 Professional Services $28,000.00 $2,371.11 $17,556.51 E 150 -46500 -303 Engineering Fee $2,000.00 $0.00 $0.00 E 150 -46500 -304 Legal Fees $1,000.00 $0.00 $0.00 E 150 -46500 -321 Telephone $785.00 $61.63 $578.87 E 150 -46500 -322 Postage $350.00 $0.00 $0.00 E 150 -46500 -328 Marketing $8,000.00 $2,500.00 $2,736.07 E 150 -46500 -331 Travel & Conference Expense $150.00 $0.00 $0.00 E 150 -46500 -340 Advertising $500.00 $0.00 $30.62 E 150 -46500 -410 Rentals $0.00 $0.00 $0.00 E 150 - 46500 -433 Dues & Memberships $0.00 $0.00 $0.00 E 150 - 46500 -434 Certification Fee $0.00 $0.00 $0.00 E 150 -46500 -582 Computer Software $0.00 $0.00 $0.00 E 150 -46500 -588 EDA Programs $33,500.00 $454.30 $6,093.69 E 150 - 46500 -622 TIF /Abatement Payments $50,000.00 $0.00 $0.00 E 150 -49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00 FUND 150 Economic Development $126,595.00 $5,387.04 $27,728.40 FUND 157 TIF 2 -1 Millstream E 157 - 46500 -101 Salaries $0.00 $0.00 $91.92 E 157 -46500 -121 PERA Contributions $0.00 $0.00 $6.67 E 157 - 46500 -122 FICA Contributions $0.00 $0.00 $5.66 E 157 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $1.57 E 157 -46500 -125 Medicare Contributions $0.00 $0.00 $1.32 E 157 -46500 -131 Health Insurance $0.00 $0.00 $0.00 E 157 - 46500 -132 Dental Insurance $0.00 $0.00 $0.90 E 157 -46500 -133 Life Insurance $0.00 $0.00 $0.08 E 157 -46500 -134 Disabilty Insurance $0.00 $0.00 $0.51 E 157 -46500 -300 Professional Services $0.00 $0.00 $81.00 E 157 - 46500 -317 Other fees $0.00 $0.00 $0.00 E 157 -46500 -331 Travel & Conference Expense $0.00 $0.00 $0.00 E 157 -46500 -340 Advertising $0.00 $0.00 $30.63 E 157 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $17,102.50 E 157 -49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00 FUND 157 TIF 2 -1 Millstream $0.00 $0.00 $17,322.76 FUND 158 TIF 2-2 Meat Market E 158 - 46500 -101 Salaries $0.00 $0.00 $128.70 E 158 -46500 -121 PERA Contributions $0.00 $0.00 $9.31 E 158- 46500 -122 FICA Contributions $0.00 $0.00 $7.94 E 158 - 46500 -123 Deferred Comp- Employer $0.00 $0.00 $2.18 E 158 -46500 -125 Medicare Contributions $0.00 $0.00 $1.86 Page 11 of 40 CITY OF ST. JOSEPH EDA Expenditure Report Current Period: September 2013 Account Descr E 158 -46500 -131 Health Insurance E 158 - 46500 -132 Dental Insurance E 158 -46500 -133 Life Insurance E 158 -46500 -134 Disabilty Insurance E 158 -46500 -300 Professional Services E 158 -46500 -340 Advertising E 158- 46500 -622 TIF /Abatement Payments FUND 158 TIF 2 -2 Meat Market FUND 250 Revolving Loan Fund E 250 -46500 -300 Professional Services E 250 -46500 -304 Legal Fees E 250 -46500 -317 Other fees E 250 - 46500 -434 Certification Fee E 250 - 46500 -455 Revolving Loan Proceeds FUND 250 Revolving Loan Fund 2013 September 2013 YTD Budget 2013 Amt YTD Amt $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.91 $0.00 $0.07 $0.00 $0.52 $0.00 $0.00 $0.00 $30.63 $0.00 $1,771.05 $0.00 $1,953.17 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $126,595.00 $5,387.04 $47,004.33 Page 12 of 40 10/16/13 9:24 AM Page 2 CITY OF ST. JOSEPH EDA Check Register 10/16/13 9:23 AM Page 1 CHECK # Search Name Comments FUND DEPART Amount 046971 CENTRYLINK Sep Tl /long distance/PD /WTP 150 46500 $61.63 046977 GREATER ST. CLOUD DEVELOP CORP 2013 investment - 3rd & 4th q 150 46500 $2,500.00 047010 MUNICIPAL DEVELOPMENT CORP Aug website 150 46500 $71.87 047010 MUNICIPAL DEVELOPMENT CORP Aug marketing material 150 46500 $341.20 047010 MUNICIPAL DEVELOPMENT CORP Aug mtgs /research /Qualified p 150 46500 $1,616.58 047010 MUNICIPAL DEVELOPMENT CORP Aug business retention 150 46500 $251.51 047010 MUNICIPAL DEVELOPMENT CORP Organizational development -A 150 46500 $341.46 047010 MUNICIPAL DEVELOPMENT CORP allocate Aug EDA services 150 46500 - $2,622.62 047010 MUNICIPAL DEVELOPMENT CORP August EDA services 150 46500 $2,622.62 047057 RETAIL THERAPY, LLC BFA grant 150 46500 $202.79 $5,387.04 Page 13 of 40 N `w -4 C � a LL W N W > O CL E CL v v m m L m~ Cl m' u u m g E m c - O N 0 O U) C N p d 7 0J u O Qom O w Co y Ur E 01 N 0 C °o (3) O O O M CL m w W CL N E 'a O n m U E Q Lem M !� M °� CL a a � o. o = ,� N o U to M u 7 0 r N a U Q 0 m U. m M ° .-1 m o P. of N o L W rM1 � N L ~ ~ N N N Q 0 cc �0 7 a, 0 u c 0 0 u u a c d w � CL` a a, 0 �8 O t0 o IR CD O M N m 1 m' 1l `w -4 to a LL O W > O CL E CL v v N c L m~ Cl m' u u m g ry A c - O N 0 O U) N p d .O+ Qom O w Co y Ur U N C °o (3) W m w U a m U 00 rn Ln rn rn tu °N rn L m ° .-1 m o P. of o o00o r-: m .4 m n ~ Il O Ln N O 0) m N O tto N m - ^ n �8 O t0 o IR CD O M N m 1 m' 1l 00 -4 to a LL «• C N O CL E CL @ G7 m 3 CL Cl m' V1 N o m E c - O N 0 O U) m m a U Q O w J F- 0 F- O d CA 07 IL E LL «• C N O CL E CL @ G7 3 CL C O > O y c a o 0 o ° c> o m E c - O N 0 O U) p c � �U .O+ Qom O w Co y Ur U N C C � O7 = W m w U -i m m U m U tu R m m a U Q O w J F- 0 F- O d CA 07 IL This page intentionally left blank