Loading...
HomeMy WebLinkAbout[05] Accounts Payable & Financial ReportsCITY OF ST. JOSEPH VVV. cityo f stjoseph. com DATE: December 11, 2013 MEMO TO: St. Joseph Economic Development Authority Administrator FROM: Cynthia Smith - Strack Municipal Development Group Judy Weyrens RE: Accounts Payable Mayor November Financial Reports Richard Schultz A. Accounts Payable: Councilors Steve Frank Following are Accounts Payable for the EDA's Consideration. Bob Loso Payable To For Fund Renee Symanietz MDG, Inc. Nov. Econ. Dev. Service 150 -46500 -300 Dale Wick $2,200 services, $422.62 mileage Total EDA Doug Danielson Steve Frank Larry Hosch Gary Osberg Dale Wick Amount $ 2,622.62 $ 2,622.62 'Plus invoices noted on enclosed check register. Through November 30th a total of 396.50 contract hours have been provided; 23.50 hours remain on the contract. Action: A MOTION is in order to approve the Accounts Payable. B. Financial Report: November 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. I a6VA MUNICIPAL DEVELOPMENT GROUP, INC. 25562 WILLOW LANE NEW PRAGUE, MN 56071 952 - 758 -7399 FAX: 952 - 758 -3711 staff @municipaideveiopmentgroup.com INVOICE City of St. Joseph Attn: Judy Weyrens City Administrator PO 668 St. Joseph, MN 56374 Invoice Date 12 -10 -13 Payment Terms: 30 days Customer ID #: STJ13EDA Project Nov. 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 Hour November 6, 2013 EDA Office Hours: C. Strack 7.50 Hour November 13, 2013 EDA Office Hours: C. Strack 7.50 Hour November 20, 2013 EDA Office Hours: C. Strack 7.50 Hour November 27, 2013 EDA Office Hours: C. Strack 9.00 Hour Total November 2013 31.50 Hours Total Contract Hours November 30, 2013: 396.50 Hours Check No. Date: Thank you! We appreciated the opportunity to work with you! 04 Principal St. Joseph Economic Development Authority Summary Treasurer's Report - Fund 150 November 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 Expenditures 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 November 30, 2013: 9,524.21 ** 14,759.26 ** 4,318.96 ** 165.19 ** ** 28,767.62 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 y 295.82 13,475.00 125,503.22 (107.14) (16.57) (622.93) (21,043.59) (91.80) (709.82) (3,810.83) (30.62) (20,473.55) 77,651.57 139,274.04 (46,906.85) 170,018.76 38,089.78 15,368.57 116,560.41 28,451.24 1,302.11 30,194.51 CITY OF ST. JOSEPH EDA Balance Sheet Current Period: November 2013 YTD YTD Current FUND Descr Account Descr Beqin Yr Debit Credit Balance FUND 150 Economic Development Economic Development Economic Development Economic Development Economic Development Economic Development Economic Development Economic Development Economic Development G 150 -10100 Cash G 150 -10450 Interest Receivable G 150 -10700 Taxes Receivable - Delinquen G 150 -13113 Due From other Gov t Units G 150 -15500 Due From Other Fund G 150 -20200 Accounts Payable G 150 -22204 Deferred Revenue 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 Millstream $79,525.68 $198,980.00 $108,986.92 $169,518.76 $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 $109,414.16 $201,781.35 - $156,722.05 $0.00 $312,088.61 $312,088.61 $0.00 TIF 2 -1 Millstream G 157 -10100 Cash $10,832.25 $57,881.48 $40,262.49 $28,451.24 TIF 2 -1 Millstream G 157 -10450 Interest Receivable $12.43 $0.00 $12.43 $0.00 TIF 2 -1 Millstream G 157 -13113 Due From other Gov t Units $0.00 $0.00 $0.00 $0.00 TIF 2 -1 Millstream G 157 -20200 Accounts Payable $0.00 $0.00 $0.00 $0.00 TIF 2 -1 Millstream G 157 -25310 Appropriated Fund Balance - $10,844.68 $40,274.92 $57,881.48 - $28,451.24 FUND 157 TIF 2 -1 Millstream $0.00 $98,156.40 $98,156.40 $0.00 FUND 158 TIF 2 -2 Meat Market TIF 2 -2 Meat Market G 158 -10100 Cash $30.02 $4,285.63 $2,513.54 $1,802.11 TIF 2 -2 Meat Market G 158 -20500 Due To Other Fund - $500.00 $0.00 $0.00 - $500.00 TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance $469.98 $2,513.54 $4,285.63 - $1,302.11 FUND 158 TIF 2 -2 Meat Market $0.00 $6,799.17 $6,799.17 $0.00 FUND 250 Revolving Loan Fund Revolving Loan Fund G 250 -10100 Cash Revolving Loan Fund G 250 -10450 Interest Receivable Revolving Loan Fund G 250 -11900 Notes Receivable Revolving Loan Fund G 250 -20200 Accounts Payable Revolving Loan Fund G 250 -22204 Deferred Revenue Revolving Loan Fund G 250 -25310 Appropriated Fund Balance FUND 250 Revolving Loan Fund $22,746.98 $7,743.41 $295.88 $30,194.51 $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 $7,743.41 - $30,194.51 $0.00 $44,194.44 $44,194.44 $0.00 /v $0.00 $461,238.62 $461,238.62 $0.00 12/03/13 3:04 PM Page 1 CITY OF ST. JOSEPH EDA Revenue Report Current Period: November 2013 2013 November 2013 FUND Descr SOURCE SOURCE Descr YTD Budget 2013 Amt YTD Amt FUND 150 Economic Development Economic Development 31010 Current Ad Valorem Taxes $126,095.00 $59,997.55 $125,503.22 Economic Development 33160 Federal Grants - Other $0.00 $2,225.00 $13,475.00 Economic Development 34150 TIF /MIF Deposit $0.00 $0.00 $0.00 Economic Development 34200 DEED Housing Reimbursem $0.00 $0.00 $0.00 Economic Development 36210 Interest Earnings $500.00 $113.75 $295.82 Economic Development 39201 Transfers from Other Funds $0.00 $0.00 $0.00 FUND 150 Economic Development $126,595.00 $62,336.30 $139,274.04 FUND 157 TIF 2 -1 Millstream TIF 2 -1 Millstream 31050 Tax Increment $0.00 $15,908.68 $34,911.46 TIF 2 -1 Millstream 33404 Market Value Credit $0.00 $0.00 $0.00 TIF 2 -1 Millstream 36210 Interest Earnings $0.00 $11.90 $17.86 FUND 157 TIF 2 -1 Millstream $0.00 $15,920.58 $34,929.32 FUND 158 TIF 2 -2 Meat Market TIF 2 -2 Meat Market 31050 Tax Increment $0.00 $1,860.52 $3,724.78 TIF 2 -2 Meat Market 36210 Interest Earnings $0.00 -$0.06 $0.48 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,860.46 $3,725.26 FUND 250 Revolving Loan Fund Revolving Loan Fund 36210 Interest Earnings $300.00 $27.48 $14.23 Revolving Loan Fund 39320 Revolving Loan Principal $7,095.00 $302.95 $6,496.18 Revolving Loan Fund 39321 Revolving Loan Interest $985.00 $27.05 $912.87 Revolving Loan Fund 39322 Revolving Loan Origination $0.00 $0.00 $0.00 FUND 250 Revolving Loan Fund $8,380.00 $357.48 $7,423.28 $134,975.00 $80,474.82 $185,351.90 12/03/13 3:05 PM Page 1 CITY OF ST. JOSEPH EDA Expenditure Report Current Period: November 2013 12/03/13 3:05 PM Page 1 / Z- 2013 November 2013 Account Descr YTD Budget 2013 Amt YTD Amt FUND 150 Economic Development 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 $14.00 $16.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 $1,768.21 $21,043.59 E 150 -46500 -303 Engineering Fee $2,000.00 $91.80 $91.80 E 150 -46500 -304 Legal Fees $1,000.00 $0.00 $0.00 E 150 -46500 -321 Telephone $785.00 $65.85 $709.82 E 150 -46500 -322 Postage $350.00 $0.00 $0.00 E 150 -46500 -328 Marketing $8,000.00 $755.85 $3,810.83 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 $2,545.02 $20,473.55 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,240.73 $46,906.85 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 Disability 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 / Z- CITY OF ST. JOSEPH EDA Expenditure Report Current Period: November 2013 12103/13 3:05 PM Page 2 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 $0.00 2013 November 2013 Account Descr YTD Budget 2013 Amt YTD Amt E 158 -46500 -131 Health Insurance $0.00 $0.00 $0.00 E 158 -46500 -132 Dental Insurance $0.00 $0.00 $0.91 E 158 -46500 -133 Life Insurance $0.00 $0.00 $0.07 E 158 -46500 -134 Disabilty Insurance $0.00 $0.00 $0.52 E 158 -46500 -300 Professional Services $0.00 $0.00 $0.00 E 158 -46500 -340 Advertising $0.00 $0.00 $30.63 E 158 - 46500 -622 TIF /Abatement Payments $0.00 $0.00 $1,771.05 FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $1,953.17 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 $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 13 $5,240.73 $66,182.78 CITY OF ST. JOSEPH 12/03/13 3:05 PM EDA Check Register Page 1 CHECK # Search Name Comments FUND DEPART Amount 047197 CENTRYLINK 20 sets 229 #'s 150 46500 $11.12 047198 CENTURYLINK BUSINESS SERVICES Oct long distance telephone 150 46500 $4.37 047209 THE LOCAL BLEND cater EDA business breakfast 150 46500 $115.80 047211 TRI- COUNTY ACTION PROGRAM INC DEED housing grant -admin ser 150 46500 $2,225.00 047215 CENTRYLINK Nov T1 line 150 46500 $50.36 047234 LEAGUE OF MN CITIES INS TRUST final workers comp due 12 -13 150 46500 $14.00 047237 MUNICIPAL DEVELOPMENT CORP Oct EDA -CR2 infrastructure de 150 46500 $50.47 047237 MUNICIPAL DEVELOPMENT CORP Oct EDA -mtgs qualified project 150 46500 $269.55 047237 MUNICIPAL DEVELOPMENT CORP Oct EDA - website 150 46500 $117.86 047237 MUNICIPAL DEVELOPMENT CORP Oct EDA- marketing 150 46500 $640.05 047237 MUNICIPAL DEVELOPMENT CORP Oct EDA - business retention 150 46500 $1,347.22 047237 MUNICIPAL DEVELOPMENT CORP Oct EDA - organizational develo 150 46500 $303.13 047288 SEH, INC review home site near Gatewa 150 46500 $91.80 $5,240.73 144 2013 Capital Expenditures General Fund Capital Improvement Plan - EDA 2013 final CIP Budget Adopted December 6, 2012 As of November 30, 2013 through 11/30 through 11/30 Transfers Spent 2013 2013 2013 Balance 1,200.00 12/31/2012 Available (2,869.06) Project Project Reserve Budget Department Account Code Number Equipment Balance 2013 EDA 150 -46500 -582 EDA -1301 Computer Software 1,200.00 9,341.57 EDA 150 -46500 -588 EDA -1302 Let's Go Downtown 3,338.66 10,000.00 EDA -1307 Business Development/TIF - 11,500.00 9,896.32 EDA -1308 Business Demolition Program 3,341.57 6,000.00 EDA -1309 CDBG Grant Development - - EDA -1303 BFA Grant/Loan Program 5,416.48 6,000.00 (8,706.93) EDA -1304 Rental Conversions - EDA -1305 CSAH 2/3 Collection Street 12,096.71 33,500.00 TOTAL EDA CIP 13.296.71 1 33.500.00 2013 Capital Expenditures General Fund Capital Improvement Plan - EDA 2013 final CIP Budget Adopted December 6, 2012 As of November 30, 2013 through 11/30 through 11/30 Transfers Spent 2013 2013 2013 Balance 1,200.00 includes flower (2,869.06) 10,469.60 brackets (4,152.52) 7,347.48 2013 student housing unit 9,341.57 $2500 2012 Scenic Specialties/ (1,520.16) 9,896.32 Retail Therapy (165.19) (165.19) (8,706.93) 36,889.78 38,089.78 (8,706.93)