Okaloosa County BOCC — October 22, 2015 — Agenda Packet — reading text

Fort Walton Beach Single Family Dwelling 4.04% 12.50% Okaloosa Island 31.31% Condo Hotel / Motel 60.36% Destin 24.24% 64.65% Page 7 Packet Pg. 111  3.m.a Total TDT Collections and Percentage Breakdown FY 2015 Attachment: III. m. TDT Reports OCTC (Aug 15) (4894 : Okaloosa Tax Collector Report) 1st Penny 2nd Penny 4th Penny Beach, park Beach, waterway & Debt service for Tax Collector 3rd Penny improvements & tourist destination construction, Convention Center 5th Penny Month Total Collections Commission maintenance, facilities and other facility reconstruction or Tourism Promotion 3% of Collections shoreline protection, improvements; renovation convention operations restoration lifeguard services; center and future improvements administration improvements October $ 886,981.06 $ 26,609.43 $ 172,074.33 $ 172,074.33 $ 172,074.33 $ 172,074.33 $ 172,074.33 November $ 313,442.31 $ 9,403.27 $ 60,807.81 $ 60,807.81 $ 60,807.81 $ 60,807.81 $ 60,807.81 December $ 320,915.76 $ 9,627.48 $ 62,257.66 $ 62,257.66 $ 62,257.66 $ 62,257.66 $ 62,257.66 January $ 410,853.35 $ 12,325.59 $ 79,705.55 $ 79,705.55 $ 79,705.55 $ 79,705.55 $ 79,705.55 February $ 492,951.35 $ 14,788.54 $ 95,632.56 $ 95,632.56 $ 95,632.56 $ 95,632.56 $ 95,632.56 March $ 1,033,763.09 $ 31,012.89 $ 200,550.04 $ 200,550.04 $ 200,550.04 $ 200,550.04 $ 200,550.04 April $ 1,248,990.41 $ 37,469.72 $ 242,304.14 $ 242,304.14 $ 242,304.14 $ 242,304.14 $ 242,304.14 May $ 1,628,068.98 $ 48,842.07 $ 315,845.38 $ 315,845.38 $ 315,845.38 $ 315,845.38 $ 315,845.38 June $ 3,247,331.26 $ 97,419.93 $ 629,982.27 $ 629,982.27 $ 629,982.27 $ 629,982.27 $ 629,982.27 July $ 3,688,644.87 $ 110,659.35 $ 715,597.10 $ 715,597.10 $ 715,597.10 $ 715,597.10 $ 715,597.10 August $ 2,009,054.41 $ 60,271.63 $ 389,756.56 $ 389,756.56 $ 389,756.56 $ 389,756.56 $ 389,756.56 September $ - $ - $ - $ - $ - $ - $ - Total $ 15,280,996.85 $ 458,429.90 $ 2,964,513.39 $ 2,964,513.39 $ 2,964,513.39 $ 2,964,513.39 $ 2,964,513.39 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8 Packet Pg. 112  3.n Tourist Development Council Meeting: 10/22/15 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 4895) DOC ID: 4895 Expenditure Transaction Report Updated: 10/19/2015 2:10 PM by Aida Wilkinson Page 1 Packet Pg. 113  3.n.a TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM DATE: October 22, 2015 TO: Tourist Development Council FROM: Ed Schroeder, Tourist Development Department Director Charlotte Dunworth, Finance, Administration, & Compliance Manager SUBJECT: Monthly Expenditure Transaction Analysis STATEMENT OF ISSUE: Pursuant to Florida Statutes 125.0104(4)(e), “The council shall continuously Attachment: III. n. Expenditure Transactions (4895 : Expenditure Transaction Report) review expenditures… Expenditures which the council believes to be unauthorized shall be reported to the county governing board and the Department of Revenue”. BACKGROUND: One of the most comprehensive reports from the County’s accounting system is the Expenditure Transaction Analysis, which lists the fiscal period, date, transaction type, check number, vendor number, vendor name, dollar amount, and description for each tourist development tax expenditure transaction. This report is being provided to assist the TDC in identifying possibly unauthorized expenditures. The following pages provide transaction detail for the month of September 2015. OPTIONS: N/A RECOMMENDATION TO BCC: N/A, for informational purposes only. Packet Pg. 114  SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 10/14/2015 OKALOOSA COUNTY BOCC AUDIT11 TIME: 07:44:56 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’15’ and transact.period=’12’ and transact.fund=’104’ ACCOUNTING PERIOD: 1/16 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 12/15 09/02/15 22 1,703.20 PAYROLL CHARGES 12/15 09/21/15 22 1,703.20 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 3,406.40 .00 521000 FICA TAXES 12/15 09/02/15 22 128.06 PAYROLL CHARGES−FRINGE 12/15 09/21/15 22 128.06 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 256.12 .00 522000 RETIREMENT CONTRIBUTIONS 12/15 09/02/15 22 123.65 PAYROLL CHARGES−FRINGE 12/15 09/21/15 22 123.65 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 247.30 .00 523000 LIFE & HEALTH INSURANCE