Loading...
HomeMy WebLinkAbout[05] Accounts Payable & Financial ReportCITY OF ST. JOSEPH VVV. cityofstjoscph.com DATE: April 20, 2011 MEMO TO: St. Joseph Economic Development Authority The reports consist of 1. Monthly Report. 2. Balance Sheet. 3. EDA revenue to date. 4. EDA expenditures to date. 5. CIP Summary A MOTION is in order to approve the Financial Reports. Page 8 of 27 FROM: Cynthia Smith- Strack, Municipal Development Group Administrator Judy Weyrens RE: Accounts Payable — April March 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. Mar. Econ. Dev. Service 150 -46500 -300 $ 2,676.85 Dale Wick Total $ 2,676.85 EDA Carolyn Yaggie- Action: Heinen A MOTION is in order to approve the Accounts Payable. Chad Davey Al Rassier Tom Skahen B. Financial Report: Dale Wick March 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. CIP Summary A MOTION is in order to approve the Financial Reports. Page 8 of 27 ae% MUNICIPAL DEVELOPMENT GROUP, INC. 25562 WILLOW LANE NEW PRAGUE, MN 56071 952 - 758 -7399 FAX: 952 - 758 -3711 staff @municipaidevelopmentgroup.com INVOICE City of St. Joseph Attn: Judy Weyrens City Administrator PO 668 St. Joseph, MN 56374 Invoice Date 4 -10 -11 Payment Terms: 30 days Customer ID #: ISTJ10EDA Project March Economic Development Services See attached detail Amount: $2,200.00 Monthly contract fee 476.85 935 miles x .51 $2,676.85 Code to: 150 -46500 -300 for general EDA Remit To: Municipal Development Group, Inc. 25562 Willow Lane New Prague, MN 56071 Dates -EDA Hours March 2, 2011 EDA Office Hours: C. Strack 8.00 Hour March 9, 2011 EDA Office Hours: C. Strack 8.00 Hour March 16, 2011 EDA Office Hours: C. Strack 8.00 Hour March 23, 2011 EDA Office Hours: C. Strack 7.00 Hour March 30, 2011 EDA Office Hours: C. Strack 9.00 Hour March 31, 2011 Attend workshop with Council 2.50 Hour Total March 2011 42.50 Hour Total Contract Hours Thru March 31, 2011: 117.50 Hours Check No. Date: Thank youl We appreciated the opportunity to work with youl Page 9 of 27 Principal St. Joseph Economic Development Authority Summary Treasurer's Report - Fund 150 March 2011 Fund 150, EDA Balance as of December 31, 2010 (unaudited) Year to Date Revenue: Interest Earnings Transfers from the City's General Fund Total Revenue Y_ ear 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 Advertising Recording Fee Rentals (Postage Machine) St. Cloud EDA Membership Dues EDA Programs Total Expenses Fund Summaries as of December 31, 2010: 1.42 438.26 ** 3,714.19 981.27 ** 211.45 5,345.17 EDA Fund Balance - Fund 150 - unaudited Designated for Capital Programs Undesignated TIF 1-4 St. Joseph Development Fund Balance - Fund 156 TIF 2 -1 Millstream Shops and Lofts Fund Balance - Fund 157 Revolving Loan Fund Balance - Fund 250 ** Detail available upon request Page 11 of 27 0.52 (21.32) (529.52) (2,997.67) (96.00) (189.79) (2,251.50) 5,162.57 1.42 (6,085.28) (921.29) 5,162.57 (6,083.86) 41,790.14 4,037.04 35,721.27 r' Ir"dI ..' CITY OF ST JOSEPH EDA Balance Sheet Current Period: March 2011 04/15/119:07 AM Page 1 FUND 156 TIF 1-4 St. Joe Development TIF 1-4 St. Joe Develop G 156 -10100 Cash $41,593.09 YTD YTD Current FUND Descr Account Descr Begin Yr Debit Credit Balance FUND 150 Economic Development G 156 -25310 Appropriated Fund Balance - $41,698.76 $115.50 $206.88 Economic Development G 150 -10100 Cash $8,841.22 $35.93 $9,798.44 - $921.29 Economic Development G 150 -10450 Interest Receivable on Invest. $31.27 $0.00 $31.27 $0.00 Economic Development G 150 -20200 Accounts Payable - $3,709.92 $3,709.92 $0.00 $0.00 Economic Development G 150 -24415 Design. Fd Bal - Capital Proj - $5,162.57 $0.00 $0.00 - $5,162.57 Economic Development G 150 -25310 Appropriated Fund Balance $0.00 $9,829.71 $3,745.85 $6,083.86 FUND 150 Economic Development $0.00 $13,575.56 $13,575.56 $0.00 FUND 156 TIF 1-4 St. Joe Development TIF 1-4 St. Joe Develop G 156 -10100 Cash $41,593.09 $206.88 $9.83 $41,790.14 TIF 1-4 St. Joe Develop G 156 -10450 Interest Receivable on Invest. $105.67 $0.00 $105.67 $0.00 TIF 1-4 St. Joe Develop G 156 -25310 Appropriated Fund Balance - $41,698.76 $115.50 $206.88 - $41,790.14 FUND 156 TIF 1-4 St. Joe Development $0.00 $322.38 $322.38 $0.00 FUND 157 TIF 24 Millstream TIF 2 -1 Millstream G 157 -10100 Cash $4,020.96 $16.80 $0.72 $4,037.04 TIF 2 -1 Millstream G 157 -10450 Interest Receivable on Invest. $4.82 $0.00 $4.82 $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 - $4,025.78 $5.54 $16.80 - $4,037.04 FUND 157 TIF 2 -1 Millstream $0.00 $22.34 $22.34 $0.00 FUND 158 TIF 2 -2 Meat Market TIF 2 -2 Meat Market G 158 -10100 Cash $0.00 $0.00 $0.00 $0.00 TIF 2 -2 Meat Market G 158 -25310 Appropriated Fund Balance $0.00 ry $0.00 _.. $0.00 _._. y5$0.00 _...._., $0.00 FUND 158 TIF 2 -2 Meat Market $0.00., $0.00 $0.00 FUND 250 Revolving Loan Fund Revolving Loan Fund G 250 -10100 Cash Revolving Loan Fund G 250 -10450 Interest Receivable on Invest. 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 $34,565.78 $1,163.86 $8.37 $89.51 $0.00 $89.51 $20,715.08 $0.00 $20,715.08 $0.00 $0.00 $0.00 - $20,715.08 $20,715.08 $0.00 - $34,655.29 $97.88 $1,163.86 $0.00 $21,976.82 $21,976.82 $0.00 $35,897.10 $35,897.10 Page 12 of 27 $35,721.27 $0.00 $0.00 $0.00 $0.00 - $35,721.27 $0.00 $0.00 I � ! I" l._. CITY OF ST JOSEPH EDA Expenditure Report Current Period: March 2011 FUND 150 Economic Development $83,990.00 FUND 156 TIF 1-4 St. Joe Development March 2011 2011 Amt YTD Amt $0.00 2011 Account Descr YTD Budget FUND 150 Economic Development $21.32 E 150 -46500 -103 Legislative Bodies $1,390.00 E 150 -46500 -151 Workers Comp. Insur. Prem. $150.00 E 150 -46500 -200 Office Supplies $500.00 E 150 - 46500 -215 software support $450.00 E 150 -46500 -300 Professional Services $28,000.00 E 150 -46500 -303 Engineering Fee $2,000.00 E 150 -46500 -304 Legal Fees $1,000.00 E 150 -46500 -321 Telephone $1,200.00 E 150 -46500 -322 Postage $350.00 E 150 -46500 -331 Travel & Conference Expense $150.00 E 150 -46500 -340 Advertising $500.00 E 150 - 46500 -410 Rentals $0.00 E 150 - 46500 -433 Dues & Memberships $8,000.00 E 150 - 46500 -434 Certification Fee $0.00 E 150 - 46500 -582 Computer Software $300.00 E 150 - 46500 -588 EDA Programs $40,000.00 FUND 150 Economic Development $83,990.00 FUND 156 TIF 1-4 St. Joe Development March 2011 2011 Amt YTD Amt $0.00 $0.00 $0.00 -$0.52 $0.00 $21.32 $0.00 $529.52 $1,054.30 $2,997.67 $0.00 $96.00 $0.00 $0.00 $65.29 $189.79 $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 $1,574.87 $2,251.50 $2,694.46 $6,085.28 E 156 -46500 -101 Salaries $0.00 $0.00 $0.00 E 156 - 46500 -121 PERA Contributions $0.00 $0.00 $0.00 E 156 -46500 -122 FICA Contributions $0.00 $0.00 $0.00 E 156 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.00 E 156 -46500 -125 Medicare Contributions $0.00 $0.00 $0.00 E 156 -46500 -130 Health Ins - Deductible $0.00 $0.00 $0.00 E 156 - 46500 -131 Health Insurance $0.00 $0.00 $0.00 E 156 -46500 -133 Life Insurance $0.00 $0.00 $0.00 E 156 -46500 -134 Disabilty Insurance $0.00 $0.00 $0.00 E 156 -46500 -136 Fringe Benefits- Employee $0.00 $0.00 $0.00 E 156 -46500 -300 Professional Services $0.00 $0.00 $0.00 E 156 -46500 -340 Advertising $0.00 $0.00 $0.00 E 156 - 46500 -622 Tax Increment Payments $0.00 $0.00 $0.00 FUND 156 TIF 1-4 St. Joe Development $0.00 $0.00 $0.00 FUND 157 TIF 2 -1 Millstream E 157 -46500 -101 Salaries $0.00 $0.00 $0.00 E 157 -46500 -121 PERA Contributions $0.00 $0.00 $0.00 E 157 -46500 -122 FICA Contributions $0.00 $0.00 $0.00 E 157 -46500 -123 Deferred Comp - Employer $0.00 $0.00 $0.00 E 157 -46500 -125 Medicare Contributions $0.00 $0.00 $0.00 E 157 -46500 -130 Health Ins - Deductible $0.00 $0.00 $0.00 E 157 -46500 -131 Health Insurance $0.00 $0.00 $0.00 E 157 -46500 -133 Life Insurance $0.00 $0.00 $0.00 E 157 -46500 -134 Disabilty Insurance $0.00 $0.00 $0.00 E 157 -46500 -136 Fringe Benefits - Employee $0.00 $0.00 $0.00 E 157 -46500 -300 Professional Services $0.00 $0.00 $0.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 $0.00 E 157 -46500 -622 Tax Increment Payments $0.00 $0.00 $0.00 E 157 -49300 -720 Transfers to Other Funds $0.00 $0.00 $0.00 FUND 157 TIF 2 -1 Millstream $0.00 $0.00 $0.00 FUND 158 TIF 2 -2 Meat Market E 158-46500 -300 Professional Services $0.00 $0.00 $0.00 E 158-46500 -340 Advertising $0.90 $0.00 $0.00 Pagel of 27 04/14/11 11:24 AM Page 1 r' CITY OF ST JOSEPH 04/14/11 11:24 AM Page 2 EDA Expenditure Report Current Period: March 2011 2011 March 2011 Account Descr YTD Budget 2011 Amt YTD Amt E 158 -46500 -622 Tax Increment Payments $0.00 $0.00 $0.00 FUND 158 TIF 2 -2 Meat Market $0.00 $0.00 $0.00 FUND 250 Revolving Loan Fund E 250 -46500 -300 Professional Services $0.00 $0.00 $0.00 E 250 -46500 -304 Legal Fees $0.00 $0.00 $0.00 E 250 -46500 -317 Other fees $0.00 $0.00 $0.00 E 250 - 46500 -434 Certification Fee $0.00 $0.00 $0.00 E 250 - 46500 -455 Revolving Loan Proceeds $0.00 $0.00 $0.00 FUND 250 Revolving Loan Fund $0.00 $0.00 $0.00 $83,990.00 $2,694.46 $6,085.28 Page 14 of 27 r' CITY OF ST JOSEPH 04/14/11 11:24 AM 4-1J � Page 1 EDA Revenue Report Current Period: March 2011 FUND Descr SOURCE SOURCE Descr FUND 150 Economic Development 2011 Amt YTD Amt Economic Development 34150 TIF /MIF Deposit Economic Development 36210 Interest Earnings Economic Development 39201 Transfers from Other Funds FUND 150 Economic Development $0.00 FUND 156 TIF 1 -4 St. Joe Development $12.70 TIF 1 -4 St. Joe Development 31050 Tax Increment TIF 1 -4 St. Joe Development 36210 Interest Earnings FUND 156 TIF 1-4 St. Joe Development $104.67 FUND 157 TIF 2 -1 Millstream $0.00 TIF 2 -1 Millstream 31050 Tax Increment TIF 2 -1 Millstream 33404 Market Value Credit TIF 2 -1 Millstream 34150 TIF /MIF Deposit TIF 2 -1 Millstream 36210 Interest Earnings FUND 157 TIF 2 -1 Millstream $0.00 FUND 250 Revolving Loan Fund $8.70 $11.26 Revolving Loan Fund 36210 Interest Earnings Revolving Loan Fund 39320 Revolving Loan Principal Revolving Loan Fund 39321 Revolving Loan Interest Revolving Loan Fund 39322 Revolving Loan Origination FUND 250 Revolving Loan Fund $0.00 $49.70 2011 March 2011 YTD Budget 2011 Amt YTD Amt $0.00 $0.00 $0.00 $150.00 $12.70 $1.42 $83,840.00 $0.00 $0.00 $83,990.00 $12.70 $1.42 $0.00 $0.00 $0.00 $0.00 $104.67 $91.38 $0.00 $104.67 $91.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.70 $11.26 $0.00 $8.70 $11.26 $0.00 $87.82 $75.98 $0.00 $280.30 $837.42 $0.00 $49.70 $152.58 $0.00 $0.00 $0.00 $0.00 $417.82 $1,065.98 $83,990.00 $543.89 $1,170.04 Page 15 of 27 ti M C C 3 V) N O L O O O O O z N 0 W 0 p a N a - 0 O a a` fn C en o C> O Gl O -O a--I O m m x a ai l7 W E U O y '6 m r1 4! m c d U c d �o c •O O •- n ' Z m N a o -_ N 3 CO a 3 N U d m U n V G1 H o I- m C(1 n LD O V1 Dl W N o Ln N N Dl v It Ln a v CC) a In 3 m V ON Ln N N O �••� C C� N rl Ln w .--I L/1 W � lD W N N N f0 O O N In LO ti M C C 3 V) N O L O O O O O O 0 W 0 p a N O O O O O O a a` fn C en o C> O Gl O -O a--I O m m x a ai l7 W E U O y '6 m r1 4! m d d m 0 �o c •O O •- n ' Z m N a C 7 O N 3 CO a 3 N N V G1 H c c c C11 C> y O W N ti M C C 3 V) N O L a� Z N L O U C 3 O V a a o„ a a a 0 ii O M Ol n V O V1 00 O I� N C1 LIl lD V �n lD O .1 N N .--I lD v v tD m o Ln v N v � O On O O I. Ln v Ln o a O II Ln O O O O O I Ln C) c 0 c 0 l l o N v N C c 00 � O0 V r C E 0 W 0 p a N it V) 0 C N 10 p a a` fn C en o C> N Gl O -O a--I O m m x a ai l7 W E U O y '6 m r1 4! m d d m 0 �o c U W -4 l.7 '" G V a •- n ' Z m N a C 7 O N 3 CO LL C1 m U o G1 H c c c C C> y O W N N w E CC) a In 3 Q W a� Z N L O U C 3 O V a a o„ a a a 0 ii O M Ol n V O V1 00 O I� N C1 LIl lD V �n lD O .1 N N .--I lD v v tD m o Ln v N v � O On O O I. Ln v Ln o a O II Ln O O O O O I Ln C) c 0 c 0 l l o N v N C c Q a w w N a) 03 p U C a C: o C ,o U p N O > U C O co @ _U N (7 to 2 U- m CO c X U M V In O O O c o o w W W a U a 0 w F O F N O CD N m (6 a N - E o m 3 n N p C 3 O U o 0 a O O O U U CL E cn c LL O p U O c 1- CL r N O O 3 3 3 o C c c c W W N co CC) CC) In L9 O O O O LO LO (D (D V V O O In In Q a w w N a) 03 p U C a C: o C ,o U p N O > U C O co @ _U N (7 to 2 U- m CO c X U M V In O O O c o o w W W a U a 0 w F O F N O CD N m (6 a