Loading...
HomeMy WebLinkAbout[04b] August Finance Reports EDA Agenda Item 4b MEETING DATE: September 19, 2017 AGENDA ITEM: August Finance Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE/COUNCIL RECOMMENDATION: N/A PREVIOUS EDA ACTION: None BACKGROUND INFORMATION: Enclosed you will find the reconciled financial reports through August 31, 2017. The ending undesignated balance shows a deficit of $599.48. The designated project balance is $140,736.36. The 2017 budget includes $49,100 for EDA project funding. The designated balance includes this amount; however, only the first half tax settlement has been received. Without showing the 2017 capital expenditures, the undesignated balance would be a surplus of $52,359. The other funds reported include the TIF funds, Lodging Tax, DEED CDAP Grant reimbursement and the Revolving Loan fund. The TIF funds with deficit balances will be covered by the EDA until TIF revenue is received to cover the deficits. The EDA has two outstanding revolving loans at the end of August. The st current revolving loan fund balance is $48,501 at August 31. BUDGET/FISCAL IMPACT: For Information Only ATTACHMENTS: Request for EDA Action – Finance Reports EDA Financial Summary EDA Check Register EDA Revenue Report EDA Expenditure Report EDA Summary CIP Expense Report REQUESTED BOARD ACTION: Consider accepted of the August financial reports. Also, please rd complete the attached expense report for your 3 quarter EDA meeting stipend. ** Detail available upon request CHECK #Search NameCommentsFUNDDEPARTAmount 052386ST. JOSEPH NEWSLEADER, INCPublish TIF report summary15946500$33.81 052386ST. JOSEPH NEWSLEADER, INCPublish TIF report summary15046500$33.81 052386ST. JOSEPH NEWSLEADER, INCPublish TIF report summary15846500$33.81 052386ST. JOSEPH NEWSLEADER, INCPublish TIF report summary15746500$33.81 052386ST. JOSEPH NEWSLEADER, INCPublish TIF report summary15246500$33.81 052393CENTURYLINK BUSINESS SERVICESlong distance telephone15046500$3.85 052411RENGEL PRINTING, INCblank stock paper/#10 envelop15046500$37.85 052422CENTURYLINKT1 line/20 sets 229 #'s15046500$51.22 052464SEH, INCParkway Industrial Park15046500$1,176.00 052478CENTURYLINK BUSINESS SERVICESlong distance telephone15046500$6.29 $1,444.26 2017August2017 Account DescrSOURCYTD Budget2017 AmtYTD Amt FUND 150 Economic Development R 150-46500-31010 Current Ad Valorem Taxes31010$93,920.00$0.00$42,045.94 R 150-46500-33160 Federal Grants - Other33160$0.00$0.00$0.00 R 150-46500-34150 TIF/MIF Deposit34150$0.00$0.00$0.00 R 150-46500-36210 Interest Earnings36210$1,400.00$135.91$750.43 R 150-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 150 Economic Development$95,320.00$135.91$42,796.37 FUND 152 TIF 3-1 CMCU R 152-46500-31050 Tax Increment31050$0.00$0.00$21,294.79 R 152-46500-36210 Interest Earnings36210$0.00$5.82$19.45 R 152-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$5.82$21,314.24 FUND 153 TIF 4-1 Fortitude Senior Apts R 153-46500-31050 Tax Increment31050$0.00$0.00$0.00 R 153-46500-34150 TIF/MIF Deposit34150$0.00$0.00$0.00 R 153-46500-36210 Interest Earnings36210$0.00$0.85$0.85 R 153-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$0.85$0.85 FUND 157 TIF 2-1 Millstream R 157-46500-31050 Tax Increment31050$0.00$0.00$18,143.48 R 157-46500-36210 Interest Earnings36210$275.00$28.45$152.65 FUND 157 TIF 2-1 Millstream$275.00$28.45$18,296.13 FUND 158 TIF 2-2 Meat Market R 158-46500-31050 Tax Increment31050$0.00$0.00$4,181.72 R 158-46500-36210 Interest Earnings36210$5.00$1.43$5.26 R 158-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 158 TIF 2-2 Meat Market$5.00$1.43$4,186.98 FUND 159 TIF 2-3 Bayou Blues/Alley Flat R 159-46500-31050 Tax Increment31050$0.00$0.00$44.36 R 159-46500-36210 Interest Earnings36210$0.00$0.00$0.00 R 159-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$44.36 FUND 220 Lodging Tax R 220-46500-31600 Lodging Tax31600$0.00$2,034.48$4,222.48 R 220-46500-36210 Interest Earnings36210$0.00$11.42$63.60 FUND 220 Lodging Tax$0.00$2,045.90$4,286.08 FUND 225 DEED CDAP Grant R 225-46500-34200 DEED Housing Reimbursement34200$0.00$0.00$11,077.71 R 225-46500-36210 Interest Earnings36210$0.00$12.51$56.24 FUND 225 DEED CDAP Grant$0.00$12.51$11,133.95 FUND 250 Revolving Loan Fund R 250-46500-36210 Interest Earnings36210$250.00$41.02$239.19 R 250-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 R 250-46500-39320 Revolving Loan Principal39320$8,955.00$551.04$3,067.57 R 250-46500-39321 Revolving Loan Interest39321$1,295.00$87.51$757.32 2017August2017 Account DescrSOURCYTD Budget2017 AmtYTD Amt R 250-46500-39322 Revolving Loan Origination Fee39322$0.00$0.00$0.00 FUND 250 Revolving Loan Fund$10,500.00$679.57$4,064.08 $106,100.00$2,910.44$106,123.04 2017August2017 Account DescrYTD Budget2017 AmtYTD Amt FUND 150 Economic Development E 150-46500-101 Salaries$24,200.00$3,224.13$18,000.36 E 150-46500-103 Legislative Bodies$1,260.00$0.00$210.00 E 150-46500-121 PERA Contributions$1,815.00$241.83$1,350.08 E 150-46500-122 FICA Contributions$1,395.00$195.87$1,085.27 E 150-46500-123 Deferred Comp-Employer$0.00$0.00$0.47 E 150-46500-125 Medicare Contributions$325.00$45.80$253.80 E 150-46500-130 H S A- Employer Contribution$790.00$0.00$900.00 E 150-46500-131 Health Insurance$4,190.00$398.84$3,190.72 E 150-46500-132 Dental Insurance$460.00$39.34$355.48 E 150-46500-133 Life Insurance$25.00$2.53$20.30 E 150-46500-134 Disabilty Insurance$175.00$21.19$163.51 E 150-46500-151 Workers Comp. Insur. Prem.$165.00$0.00$0.00 E 150-46500-171 Clothing Allowance$60.00$0.00$0.00 E 150-46500-200 Office Supplies$500.00$37.85$248.46 E 150-46500-215 Software Support$575.00$0.00$1,006.51 E 150-46500-300 Professional Services$3,000.00$0.00$0.00 E 150-46500-303 Engineering Fee$2,000.00$1,176.00$3,273.75 E 150-46500-304 Legal Fees$1,000.00$0.00$288.75 E 150-46500-321 Telephone$675.00$61.36$489.88 E 150-46500-322 Postage$350.00$0.00$0.00 E 150-46500-328 Marketing$2,000.00$0.00$165.00 E 150-46500-331 Travel & Conference Expense$1,000.00$0.00$4.00 E 150-46500-340 Advertising$500.00$33.81$33.81 E 150-46500-433 Dues & Memberships$5,260.00$0.00$5,000.00 E 150-46500-582 Computer Software$0.00$0.00$0.00 E 150-46500-588 EDA Programs$43,600.00$0.00$0.00 E 150-46500-622 TIF/Abatement Payments$0.00$0.00$0.00 E 150-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$95,320.00$5,478.55$36,040.15 FUND 152 TIF 3-1 CMCU E 152-46500-101 Salaries$0.00$0.00$0.00 E 152-46500-121 PERA Contributions$0.00$0.00$0.00 E 152-46500-122 FICA Contributions$0.00$0.00$0.00 E 152-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 152-46500-125 Medicare Contributions$0.00$0.00$0.00 E 152-46500-132 Dental Insurance$0.00$0.00$0.00 E 152-46500-133 Life Insurance$0.00$0.00$0.00 E 152-46500-134 Disabilty Insurance$0.00$0.00$0.00 E 152-46500-300 Professional Services$0.00$0.00$1,630.00 E 152-46500-301 Audit & Accounting Services$750.00$0.00$0.00 E 152-46500-340 Advertising$45.00$33.81$33.81 E 152-46500-622 TIF/Abatement Payments$0.00$0.00$19,165.33 E 152-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$795.00$33.81$20,829.14 FUND 153 TIF 4-1 Fortitude Senior Apts E 153-46500-101 Salaries$0.00$0.00$0.00 E 153-46500-121 PERA Contributions$0.00$0.00$0.00 E 153-46500-122 FICA Contributions$0.00$0.00$0.00 2017August2017 Account DescrYTD Budget2017 AmtYTD Amt E 153-46500-125 Medicare Contributions$0.00$0.00$0.00 E 153-46500-300 Professional Services$0.00$0.00$0.00 E 153-46500-340 Advertising$0.00$0.00$0.00 E 153-46500-588 EDA Programs$0.00$0.00$0.00 FUND 153 TIF 4-1 Fortitude Senior Apts$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-132 Dental 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-300 Professional Services$0.00$0.00$1,426.00 E 157-46500-301 Audit & Accounting Services$500.00$0.00$0.00 E 157-46500-340 Advertising$45.00$33.81$33.81 E 157-46500-622 TIF/Abatement Payments$34,000.00$0.00$16,329.13 E 157-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 157 TIF 2-1 Millstream$34,545.00$33.81$17,788.94 FUND 158 TIF 2-2 Meat Market E 158-46500-101 Salaries$0.00$0.00$103.48 E 158-46500-121 PERA Contributions$0.00$0.00$7.76 E 158-46500-122 FICA Contributions$0.00$0.00$6.33 E 158-46500-123 Deferred Comp-Employer$0.00$0.00$1.56 E 158-46500-125 Medicare Contributions$0.00$0.00$1.48 E 158-46500-131 Health Insurance$0.00$0.00$0.00 E 158-46500-132 Dental Insurance$0.00$0.00$1.66 E 158-46500-133 Life Insurance$0.00$0.00$0.12 E 158-46500-134 Disabilty Insurance$0.00$0.00$1.19 E 158-46500-300 Professional Services$0.00$0.00$0.00 E 158-46500-301 Audit & Accounting Services$500.00$0.00$0.00 E 158-46500-340 Advertising$45.00$33.81$33.81 E 158-46500-622 TIF/Abatement Payments$4,000.00$0.00$3,972.62 FUND 158 TIF 2-2 Meat Market$4,545.00$33.81$4,130.01 FUND 159 TIF 2-3 Bayou Blues/Alley Flat E 159-46500-101 Salaries$0.00$0.00$0.00 E 159-46500-121 PERA Contributions$0.00$0.00$0.00 E 159-46500-122 FICA Contributions$0.00$0.00$0.00 E 159-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 159-46500-125 Medicare Contributions$0.00$0.00$0.00 E 159-46500-132 Dental Insurance$0.00$0.00$0.00 E 159-46500-133 Life Insurance$0.00$0.00$0.00 E 159-46500-134 Disabilty Insurance$0.00$0.00$0.00 E 159-46500-300 Professional Services$0.00$0.00$1,426.00 E 159-46500-301 Audit & Accounting Services$750.00$0.00$0.00 E 159-46500-340 Advertising$45.00$33.81$33.81 E 159-46500-622 TIF/Abatement Payments$0.00$0.00$39.91 E 159-49300-720 Transfers to Other Funds$0.00$0.00$0.00 2017August2017 Account DescrYTD Budget2017 AmtYTD Amt FUND 159 TIF 2-3 Bayou Blues/Alley Flat$795.00$33.81$1,499.72 FUND 220 Lodging Tax E 220-46500-309 Visitors Bureau$0.00$0.00$0.00 FUND 220 Lodging Tax$0.00$0.00$0.00 FUND 225 DEED CDAP Grant E 225-46500-300 Professional Services$0.00$0.00$0.00 FUND 225 DEED CDAP Grant$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 $136,000.00$5,613.79$80,287.96 A 1,898.586,437.506,710.80 ED 53,339.5059,722.3112,627.67 140,736.36 138,837.78 Plan s 2016 2016 20, 8/31 4, 445.00 4,007.50 July 3,562.504,007.50 Expenditure Improvement December Capital 8/31through Capital Recommended: (5,000.00) (5,000.00)(5,000.00) 2017 Adopted Fund EDA General 500.00 5,000.00 49,100.00 10,000.0023,600.0010,000.0048,600.00 1,398.586,710.80 43,339.5036,567.3112,627.6799,245.28 100,643.86 Availablethrough 12/31/2016 2017 - moved $5,000 budget to Great St. Cloud Partnership dues CodeNumberEquipmentBalance201720172017Balance ProjectProjectReserveBudgetGrants/AidsSpent2017 DepartmentAccount St Joseph Economic Development Authority Expense Report NamePay Period: DateEventLocationMtg # Reimbursement Total CERTIFICATION:IDECLARETHATTHISTIMESHEETISATRUEANDCORRECTSTATEMENT OFMEETINGSWORKEDANDTHATNOPARTOFITHASBEENPAID. SignedDate