HomeMy WebLinkAbout[04b] Financial Report
EDA Agenda Item 4b
MEETING DATE: April 19, 2017
AGENDA ITEM: March 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
March 31, 2017. The ending undesignated balance shows a deficit of $26,823.85. The designated
project balance is $147,845.28. The 2017 budget includes $49,100 for EDA project funding. The
designated balance includes this amount; however, the property taxes have not been received yet.
Without showing the 2017 capital expenditures, the undesignated balance would be a surplus of
$22,276.15. In addition, balances may reflect 2016 activity that will be reversed out after the 2016 audit
is completed.
The other funds reported include the TIF funds 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
three outstanding revolving loans at the end of March. The current revolving loan fund balance is
st
$43,436.63 at March 31.
st
I am attaching the 1 quarter expense sheet for your meetings in January-March. Please complete
and submit to Judy at the meeting.
BUDGET/FISCAL IMPACT: For Information Only
ATTACHMENTS: Request for EDA Action – Finance Reports
EDA Financial Summary
EDA Balance Sheet
EDA Check Register
EDA Revenue Report
EDA Expenditure Report
EDA Summary CIP
Expense Sheet
REQUESTED BOARD ACTION: Consider accepted of the March financial reports.
THIS PAGE INTENTIONALLY LEFT BLANK
CHECK
#Search NameCommentsFUNDDEPARTAmount
051763CENTURYLINKfinal fiber through 2/7/1715046500$9.77
051827CENTURYLINK BUSINESS SERVICESlong distance telephone15046500$5.16
051837CENTURYLINKMar 229#'s, WP2, fire suppres15046500$25.86
051842SENTRY BANK-CREDIT CARDFeb/Mar hanging folders, DYM15046500$108.70
051844SLICED ON COLLEGE AVE, INC.reimburse Feb RLF pmt25046500$215.62
051854DANIELSON, DOUG1st quarter EDA mtgs15046500$70.00
051862JOVANOVICH, KADLEC & ATHMANNFeb RLF loan25046500$262.50
051867OSBERG, GARY1st quarter Eda mtgs15046500$70.00
051881CENTURYLINKT1 Feb 7-Mar 3115046500$63.48
051886SLICED ON COLLEGE AVE, INC.refund March RLF pmt25046500$215.62
051911CENTURYLINK BUSINESS SERVICESMar long distance telephone15046500$5.26
051914CIVICPLUSannual fee-hosting,media stora15046500$484.18
$1,536.15
2017March2017
FUND DescrSOURCESOURCE DescrYTD Budget2017 AmtYTD Amt
FUND 150 Economic Development
Economic Development31010Current Ad Valorem Taxes$93,920.00$0.00$632.76
Economic Development33160Federal Grants - Other$0.00$0.00$0.00
Economic Development34150TIF/MIF Deposit$0.00$0.00-$7,500.00
Economic Development34200DEED Housing Reimbursem$0.00$0.00$0.00
Economic Development36210Interest Earnings$1,400.00-$47.34$209.17
Economic Development39201Transfers from Other Funds$0.00$0.00$0.00
FUND 150 Economic Development$95,320.00-$47.34-$6,658.07
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
TIF 3-1 CMCU39201Transfers from Other Funds$0.00$0.00$0.00
FUND 152 TIF 3-1 CMCU$0.00$0.00$0.00
FUND 153 TIF 4-1 Fortitude Senior Apts
TIF 4-1 Fortitude Senior Apts31050Tax Increment$0.00$0.00$0.00
TIF 4-1 Fortitude Senior Apts34150TIF/MIF Deposit$0.00$0.00-$15,000.00
TIF 4-1 Fortitude Senior Apts36210Interest Earnings$0.00$0.00$0.00
TIF 4-1 Fortitude Senior Apts39201Transfers from Other Funds$0.00$0.00$0.00
FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$0.00-$15,000.00
FUND 157 TIF 2-1 Millstream
TIF 2-1 Millstream31050Tax Increment$0.00$0.00$688.00
TIF 2-1 Millstream36210Interest Earnings$275.00-$8.36$37.63
FUND 157 TIF 2-1 Millstream$275.00-$8.36$725.63
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$5.00-$0.14$0.60
TIF 2-2 Meat Market39201Transfers from Other Funds$0.00$0.00$0.00
FUND 158 TIF 2-2 Meat Market$5.00-$0.14$0.60
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
TIF 2-3 Bayou Blues/Alley Fla39201Transfers from Other Funds$0.00$0.00$0.00
FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.00$0.00
FUND 220 Lodging Tax
Lodging Tax31600Lodging Tax$0.00$0.00$377.35
Lodging Tax36210Interest Earnings$0.00-$3.30$4.15
FUND 220 Lodging Tax$0.00-$3.30$381.50
FUND 250 Revolving Loan Fund
Revolving Loan Fund36210Interest Earnings$250.00-$13.08$45.18
Revolving Loan Fund39201Transfers from Other Funds$0.00$0.00$0.00
Revolving Loan Fund39320Revolving Loan Principal$8,955.00$2.58$9,267.04
Revolving Loan Fund39321Revolving Loan Interest$1,295.00$76.80$262.78
Revolving Loan Fund39322Revolving Loan Origination $0.00$0.00$0.00
FUND 250 Revolving Loan Fund$10,500.00$66.30$9,575.00
2017March2017
FUND DescrSOURCESOURCE DescrYTD Budget2017 AmtYTD Amt
$106,100.00$7.16-$10,975.34
2017March2017
Account DescrYTD Budget2017 AmtYTD Amt
FUND 150 Economic Development
E 150-46500-101 Salaries$24,200.00$3,085.32$7,171.55
E 150-46500-103 Legislative Bodies$1,260.00$140.00$175.00
E 150-46500-121 PERA Contributions$1,815.00$231.39$537.85
E 150-46500-122 FICA Contributions$1,395.00$187.14$432.20
E 150-46500-123 Deferred Comp-Employer$0.00$0.00$0.00
E 150-46500-125 Medicare Contributions$325.00$43.77$101.09
E 150-46500-130 H S A- Employer Contribution$790.00$0.00$450.00
E 150-46500-131 Health Insurance$4,190.00$398.84$1,196.52
E 150-46500-132 Dental Insurance$460.00$47.40$142.20
E 150-46500-133 Life Insurance$25.00$2.53$7.59
E 150-46500-134 Disabilty Insurance$175.00$20.28$56.96
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$108.70$190.62
E 150-46500-215 Software Support$575.00$484.18$1,006.51
E 150-46500-300 Professional Services$3,000.00$0.00-$5,993.12
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$675.00$109.53$218.50
E 150-46500-322 Postage$350.00$0.00$0.00
E 150-46500-328 Marketing$2,000.00$0.00$0.00
E 150-46500-331 Travel & Conference Expense$1,000.00$0.00$8.00
E 150-46500-340 Advertising$500.00$0.00$0.00
E 150-46500-433 Dues & Memberships$260.00$0.00$0.00
E 150-46500-582 Computer Software$0.00$0.00$0.00
E 150-46500-588 EDA Programs$48,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$4,859.08$5,701.47
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$0.00
E 152-46500-301 Audit & Accounting Services$750.00$0.00$0.00
E 152-46500-340 Advertising$45.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$795.00$0.00$0.00
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
2017March2017
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-$17,278.12
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-$17,278.12
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$0.00
E 157-46500-301 Audit & Accounting Services$500.00$0.00$0.00
E 157-46500-340 Advertising$45.00$0.00$0.00
E 157-46500-622 TIF/Abatement Payments$34,000.00$0.00$619.20
E 157-49300-720 Transfers to Other Funds$0.00$0.00$0.00
FUND 157 TIF 2-1 Millstream$34,545.00$0.00$619.20
FUND 158 TIF 2-2 Meat Market
E 158-46500-101 Salaries$0.00$0.00$0.00
E 158-46500-121 PERA Contributions$0.00$0.00$0.00
E 158-46500-122 FICA Contributions$0.00$0.00$0.00
E 158-46500-123 Deferred Comp-Employer$0.00$0.00$0.00
E 158-46500-125 Medicare Contributions$0.00$0.00$0.00
E 158-46500-131 Health Insurance$0.00$0.00$0.00
E 158-46500-132 Dental Insurance$0.00$0.00$0.00
E 158-46500-133 Life Insurance$0.00$0.00$0.00
E 158-46500-134 Disabilty Insurance$0.00$0.00$0.00
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$0.00$0.00
E 158-46500-622 TIF/Abatement Payments$4,000.00$0.00$0.00
FUND 158 TIF 2-2 Meat Market$4,545.00$0.00$0.00
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$700.00
E 159-46500-301 Audit & Accounting Services$750.00$0.00$0.00
E 159-46500-340 Advertising$45.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
2017March2017
Account DescrYTD Budget2017 AmtYTD Amt
FUND 159 TIF 2-3 Bayou Blues/Alley Flat$795.00$0.00$700.00
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 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$4,859.08-$10,257.45
A
1,898.586,710.80
ED
53,339.5060,167.3110,000.0017,627.67
149,743.86
147,845.28
Plan
s
2016
2016
20,
3/31
4,
July
Expenditure
Improvement
December
Capital
3/31through
Capital
Recommended:
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
CodeNumberEquipmentBalance201720172017Balance
ProjectProjectReserveBudgetGrants/AidsSpent2017
DepartmentAccount