Loading...
HomeMy WebLinkAbout[05a] April Financial ReportsDATE: May 19, 2015 MEMO TO:St. Joseph Economic Development Authority FROM: Cynthia Smith-StrackMunicipal Development Group Administrator Judy Weyrens RE: Accounts Payable April Financial Reports Mayor Rick Schultz A.Accounts Payable: Councilors Following are Accounts Payable for the EDA’s Consideration. Matt Killam Bob Loso Payable To For Fund Amount Renee Symanietz MDG, Inc. Apr. Econ. Dev. Service 150-46500-300 $3,037.62 Dale Wick Total $ 3,037.62 EDA *Plus invoices noted on enclosed check register. Doug Danielson Larry Hosch As of April 30, 2015 a total of 156.75 hours of service have been provided. Gary Osberg Action: Rick Schultz A MOTION is in order to approve the Accounts Payable. Dale Wick B. Financial Report: Aprilfinancial reportsare attachedfor 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 4 of 47 INVOICE MDG,I. UNICIPAL EVELOPMENT ROUPNC 25562 WILLOW LANE NEW PRAGUE, MN 56071 City of St. Joseph 952-758-7399 Attn: Judy Weyrens FAX: 952-758-3711 City Administrator staff@municipaldevelopmentgroup.com PO 668 St. Joseph, MN 56374 Invoice Date 5-10-15Payment TermsCustomer ID #: : 30 days STJ15EDA Project AprEconomicDevelopment Services Amount: $2,500.00 Monthly contract fee $ 537.62 935miles x .575 $3,037.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 April 1,2015EDA Office Hours: C. Strack 8.00 Hours April 8,2015EDA Office Hours: C. Strack8.00Hours April 15,2015EDA Office Hours: C. Strack8.00Hours April22,2015EDA Office Hours: C. Strack8.50Hours April 29,2015EDA Office Hours: C. Strack8.00Hours Total April201540.50Hours Total Contract Hours April30,2015:156.25Hours Thank you! We appreciated the opportunity to work with you! Cynthia Smith-Strack Check No.__________________ Date : ______________________ Cynthia Smith-Strack, PrincipalMDG Page 5 of 47 ** Detail available upon request Page 6 of 47 05/05/15 3:50 PM CITY OF ST. JOSEPH Page 1 EDA Balance Sheet Current Period: April 2015 YTDYTDCurrent FUND DescrAccount DescrBegin YrDebitCreditBalance FUND 150 Economic Development Economic DevelopmentG 150-10100 Cash$109,443.65$57,170.85$80,501.29$86,113.21 Economic DevelopmentG 150-10450 Interest Receivable$215.50$0.00$215.50$0.00 Economic DevelopmentG 150-10700 Taxes Receivable - Delinquen$1,316.15$0.00$1,316.15$0.00 Economic DevelopmentG 150-13113 Due From other Gov t Units$0.00$0.00$0.00$0.00 Economic DevelopmentG 150-15500 Due From Other Fund$500.00$0.00$0.00$500.00 Economic DevelopmentG 150-20200 Accounts Payable-$6,601.63$6,601.63$0.00$0.00 Economic DevelopmentG 150-20201 Salaries Payable-$35.03$35.03$0.00$0.00 Economic DevelopmentG 150-22204 Deferred Inflow of Resources-$1,316.15$1,316.15$0.00$0.00 Economic DevelopmentG 150-24415 Design. Fd Bal - Capital Proj-$53,041.94$0.00$0.00-$53,041.94 Economic DevelopmentG 150-25310 Appropriated Fund Balance-$50,480.55$80,716.79$63,807.51-$33,571.27 FUND 150 Economic Development$0.00$145,840.45$145,840.45$0.00 FUND 152 TIF 3-1 CMCU TIF 3-1 CMCUG 152-10100 Cash$0.00$0.00$0.00$0.00 TIF 3-1 CMCUG 152-10450 Interest Receivable$0.00$0.00$0.00$0.00 TIF 3-1 CMCUG 152-20200 Accounts Payable$0.00$0.00$0.00$0.00 TIF 3-1 CMCUG 152-25310 Appropriated Fund Balance$0.00$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00$0.00 FUND 157 TIF 2-1 Millstream TIF 2-1 MillstreamG 157-10100 Cash$17,951.81$163.31$0.00$18,115.12 TIF 2-1 MillstreamG 157-10450 Interest Receivable$29.72$0.00$29.72$0.00 TIF 2-1 MillstreamG 157-25310 Appropriated Fund Balance-$17,981.53$29.72$163.31-$18,115.12 FUND 157 TIF 2-1 Millstream$0.00$193.03$193.03$0.00 FUND 158 TIF 2-2 Meat Market TIF 2-2 Meat MarketG 158-10100 Cash$116.36$0.70$28.67$88.39 TIF 2-2 Meat MarketG 158-10450 Interest Receivable$0.25$0.00$0.25$0.00 TIF 2-2 Meat MarketG 158-20201 Salaries Payable-$17.52$17.52$0.00$0.00 TIF 2-2 Meat MarketG 158-20500 Due To Other Fund-$500.00$0.00$0.00-$500.00 TIF 2-2 Meat MarketG 158-25310 Appropriated Fund Balance$400.91$28.92$18.22$411.61 FUND 158 TIF 2-2 Meat Market$0.00$47.14$47.14$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat TIF 2-3 Bayou Blues/AllG 159-10100 Cash$0.00$0.00$0.00$0.00 TIF 2-3 Bayou Blues/AllG 159-10450 Interest Receivable$0.00$0.00$0.00$0.00 TIF 2-3 Bayou Blues/AllG 159-20200 Accounts Payable$0.00$0.00$0.00$0.00 TIF 2-3 Bayou Blues/AllG 159-25310 Appropriated Fund Balance$0.00$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00$0.00 FUND 250 Revolving Loan Fund Revolving Loan FundG 250-10100 Cash$39,469.77$3,409.75$343.55$42,535.97 Revolving Loan FundG 250-10450 Interest Receivable$63.29$0.00$63.29$0.00 Revolving Loan FundG 250-11900 Notes Receivable$21,723.72$0.00$21,723.72$0.00 Revolving Loan FundG 250-22204 Deferred Inflow of Resources-$21,723.72$21,723.72$0.00$0.00 Revolving Loan FundG 250-25310 Appropriated Fund Balance-$39,533.06$406.84$3,409.75-$42,535.97 FUND 250 Revolving Loan Fund$0.00$25,540.31$25,540.31$0.00 $0.00$171,620.93$171,620.93$0.00 Page 7 of 47 05/05/15 3:51 PM CITY OF ST. JOSEPH Page 1 EDA Expenditure Report Current Period: April 2015 2015April2015 Account DescrYTD Budget2015 AmtYTD Amt FUND 150 Economic Development E 150-46500-101 Salaries$4,000.00$453.75$1,305.15 E 150-46500-103 Legislative Bodies$1,260.00$0.00$0.00 E 150-46500-121 PERA Contributions$0.00$0.00$0.57 E 150-46500-122 FICA Contributions$0.00$28.13$80.79 E 150-46500-123 Deferred Comp-Employer$0.00$0.00-$0.43 E 150-46500-125 Medicare Contributions$0.00$6.57$18.89 E 150-46500-151 Workers Comp. Insur. Prem.$10.00$0.00$0.00 E 150-46500-200 Office Supplies$500.00$0.00$32.14 E 150-46500-215 Software Support$540.00$0.00$522.33 E 150-46500-300 Professional Services$28,000.00$6,185.26$10,495.13 E 150-46500-303 Engineering Fee$2,000.00$0.00$143.10 E 150-46500-304 Legal Fees$1,000.00$0.00$391.50 E 150-46500-321 Telephone$785.00$72.97$266.46 E 150-46500-322 Postage$350.00$0.00$0.00 E 150-46500-328 Marketing$3,000.00$0.00$157.64 E 150-46500-331 Travel & Conference Expense$150.00$0.00$0.00 E 150-46500-340 Advertising$500.00$0.00$149.58 E 150-46500-433 Dues & Memberships$5,000.00$0.00$5,000.00 E 150-46500-582 Computer Software$0.00$0.00$0.00 E 150-46500-588 EDA Programs$33,500.00-$2,255.16$46,438.53 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$130,595.00$4,491.52$65,001.38 FUND 152 TIF 3-1 CMCU E 152-46500-300 Professional Services$0.00$0.00$0.00 E 152-46500-340 Advertising$0.00$0.00$0.00 E 152-46500-622 TIF/Abatement Payments$0.00$0.00$0.00 E 152-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00 FUND 157 TIF 2-1 Millstream E 157-46500-101 Salaries$420.00$0.00$0.00 E 157-46500-121 PERA Contributions$30.00$0.00$0.00 E 157-46500-122 FICA Contributions$25.00$0.00$0.00 E 157-46500-123 Deferred Comp-Employer$10.00$0.00$0.00 E 157-46500-125 Medicare Contributions$5.00$0.00$0.00 E 157-46500-131 Health Insurance$60.00$0.00$0.00 E 157-46500-132 Dental Insurance$10.00$0.00$0.00 E 157-46500-133 Life Insurance$5.00$0.00$0.00 E 157-46500-134 Disabilty Insurance$5.00$0.00$0.00 E 157-46500-300 Professional Services$0.00$0.00$0.00 E 157-46500-340 Advertising$0.00$0.00$0.00 E 157-46500-622 TIF/Abatement 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$570.00$0.00$0.00 FUND 158 TIF 2-2 Meat Market E 158-46500-101 Salaries$420.00$0.00$3.83 E 158-46500-121 PERA Contributions$30.00$0.00$0.29 E 158-46500-122 FICA Contributions$25.00$0.00$0.17 E 158-46500-123 Deferred Comp-Employer$10.00$0.00$0.05 E 158-46500-125 Medicare Contributions$5.00$0.00$0.04 Page 8 of 47 05/05/15 3:51 PM CITY OF ST. JOSEPH Page 2 EDA Expenditure Report Current Period: April 2015 2015April2015 Account DescrYTD Budget2015 AmtYTD Amt E 158-46500-131 Health Insurance$60.00$0.00$5.37 E 158-46500-132 Dental Insurance$10.00$0.00$0.89 E 158-46500-133 Life Insurance$5.00$0.00$0.07 E 158-46500-134 Disabilty Insurance$5.00$0.00$0.44 E 158-46500-300 Professional Services$0.00$0.00$0.00 E 158-46500-340 Advertising$0.00$0.00$0.00 E 158-46500-622 TIF/Abatement Payments$0.00$0.00$0.00 FUND 158 TIF 2-2 Meat Market$570.00$0.00$11.15 FUND 159 TIF 2-3 Bayou Blues/Alley Flat E 159-46500-300 Professional Services$0.00$0.00$0.00 E 159-46500-340 Advertising$0.00$0.00$0.00 E 159-46500-622 TIF/Abatement Payments$0.00$0.00$0.00 E 159-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$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 $131,735.00$4,491.52$65,012.53 Page 9 of 47 05/05/15 3:51 PM CITY OF ST. JOSEPH Page 1 EDA Revenue Report Current Period: April 2015 2015April2015 FUND DescrSOURCESOURCE DescrYTD Budget2015 AmtYTD Amt FUND 150 Economic Development Economic Development31010Current Ad Valorem Taxes$94,595.00$0.00$0.00 Economic Development33160Federal Grants - Other$0.00$0.00$47,301.00 Economic Development34150TIF/MIF Deposit$0.00$0.00$0.00 Economic Development34200DEED Housing Reimbursem$0.00$0.00$0.00 Economic Development36210Interest Earnings$1,000.00$43.18$791.10 Economic Development39201Transfers from Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$95,595.00$43.18$48,092.10 FUND 152 TIF 3-1 CMCU TIF 3-1 CMCU31050Tax Increment$0.00$0.00$0.00 TIF 3-1 CMCU36210Interest Earnings$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00 FUND 157 TIF 2-1 Millstream TIF 2-1 Millstream31050Tax Increment$0.00$0.00$0.00 TIF 2-1 Millstream36210Interest Earnings$0.00$8.93$133.59 FUND 157 TIF 2-1 Millstream$0.00$8.93$133.59 FUND 158 TIF 2-2 Meat Market TIF 2-2 Meat Market31050Tax Increment$0.00$0.00$0.00 TIF 2-2 Meat Market36210Interest Earnings$0.00$0.04$0.45 TIF 2-2 Meat Market39201Transfers from Other Funds$0.00$0.00$0.00 FUND 158 TIF 2-2 Meat Market$0.00$0.04$0.45 FUND 159 TIF 2-3 Bayou Blues/Alley Flat TIF 2-3 Bayou Blues/Alley Fla31050Tax Increment$0.00$0.00$0.00 TIF 2-3 Bayou Blues/Alley Fla36210Interest Earnings$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00 FUND 250 Revolving Loan Fund Revolving Loan Fund36210Interest Earnings$300.00$20.31$305.71 Revolving Loan Fund39201Transfers from Other Funds$0.00$0.00$0.00 Revolving Loan Fund39320Revolving Loan Principal$7,095.00$626.89$2,489.26 Revolving Loan Fund39321Revolving Loan Interest$985.00$49.66$207.94 Revolving Loan Fund39322Revolving Loan Origination $0.00$0.00$0.00 FUND 250 Revolving Loan Fund$8,380.00$696.86$3,002.91 $103,975.00$749.01$51,229.05 Page 10 of 47 05/05/15 3:51 PM CITY OF ST. JOSEPH Page 1 EDA Check Register CHECK #Search NameCommentsFUNDDEPARTAmount 049101BRIGGS AND MORGANBayou Alley/Flats TIF Plan revi15046500$4,000.00 049123CENTURYLINKT1 line/20 sets 229 #'s15046500$61.97 049124CENTURYLINK BUSINESS SERVICESlong distance telephone15046500$3.43 049160MUNICIPAL DEVELOPMENT CORPallocate March -TIF15046500$74.43 049160MUNICIPAL DEVELOPMENT CORPallocate March -BFA loans15046500$273.09 049160MUNICIPAL DEVELOPMENT CORPallocate March -mtgs w/qualifi15046500$397.32 049160MUNICIPAL DEVELOPMENT CORPallocate March -marketing mat15046500$198.66 049160MUNICIPAL DEVELOPMENT CORPallocate March -business retent15046500$1,191.96 049160MUNICIPAL DEVELOPMENT CORPallocate March -organizational 15046500$794.64 049160MUNICIPAL DEVELOPMENT CORPallocate March services15046500-$2,930.10 049160MUNICIPAL DEVELOPMENT CORPeda contract hours-Mar15046500$2,930.10 049206CENTURYLINK BUSINESS SERVICESlong distance telephone-April15046500$7.57 $7,003.07 Page 11 of 47 Bayou CMCU, (0.00) 1,700.0043,759.0018,405.449,210.8010,276.4281,651.66240,003.00 83,351.6 6 Balance 2015 (6,821.71) (6,014.02)(534.60)(273.09)(6,821.71)(47,301.00) 4/30 ReserveBudgetTransfersSpent Balance201520152015 4/30through 2,568.251,266.56165.194,000.00 4,000.0 0 through ED A 18,500.0012,000.003,000.0033,500.00 33,500.0 0 Plan 2014 Expenditures Improvement Budge t 4, 47 of December (731.96)(165.19) 12 12/31/2014 1,700.0025,259.009,851.219,210.807,549.5150,973.37287,304.00 CIP 52,673.3 Available 7 Page CapitalFinal Capital Adopted 2015 2015 2013 CDBG Grant Development Fund Business Demolition Program CSAH 2/3 Collection Street General Business Development/TIF Parkway Business Center BFA Grant/Loan Program Equipment Rental Conversions Let's Go Downtown Computer Software EDA-1301EDA-1302 CodeNumber EDA-130EDA-130EDA-130EDA-130EDA-130EDA-130EDA-130 Project 7783459 150-46500-582EDA150-46500-588 DepartmentAccount TOTAL EDA CIP Project A ED THIS PAGE INTENTIONALLY LEFT BLANK Page 2 of 47