Okaloosa County BOCC — September 24, 2015 — Agenda Packet — reading text

2nd Penny 4th Penny Beach, park Beach, waterway & Debt service for 3rd Penny improvements & tourist destination construction, Convention Center 5th Penny Month Total Collections maintenance, facilities and other facility reconstruction or Tourism Promotion shoreline protection, improvements; renovation convention operations restoration lifeguard services; center and future improvements administration improvements October $ 886,981.06 $ 177,396.21 $ 177,396.21 $ 177,396.21 $ 177,396.21 $ 177,396.21 November $ 313,442.31 $ 62,688.46 $ 62,688.46 $ 62,688.46 $ 62,688.46 $ 62,688.46 December $ 320,915.76 $ 64,183.15 $ 64,183.15 $ 64,183.15 $ 64,183.15 $ 64,183.15 January $ 410,853.35 $ 82,170.67 $ 82,170.67 $ 82,170.67 $ 82,170.67 $ 82,170.67 February $ 492,951.35 $ 98,590.27 $ 98,590.27 $ 98,590.27 $ 98,590.27 $ 98,590.27 March $ 1,033,763.09 $ 206,752.62 $ 206,752.62 $ 206,752.62 $ 206,752.62 $ 206,752.62 April $ 1,248,990.41 $ 249,798.08 $ 249,798.08 $ 249,798.08 $ 249,798.08 $ 249,798.08 May $ 1,628,068.98 $ 325,613.80 $ 325,613.80 $ 325,613.80 $ 325,613.80 $ 325,613.80 June $ 3,247,331.26 $ 649,466.25 $ 649,466.25 $ 649,466.25 $ 649,466.25 $ 649,466.25 July $ 3,688,644.87 $ 737,728.97 $ 737,728.97 $ 737,728.97 $ 737,728.97 $ 737,728.97 August $ - $ - $ - $ - $ - $ - September $ - $ - $ - $ - $ - $ - Total $ 13,271,942.44 $ 2,654,388.49 $ 2,654,388.49 $ 2,654,388.49 $ 2,654,388.49 $ 2,654,388.49 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8 Packet Pg. 185  3.q Tourist Development Council Meeting: 09/24/15 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Information Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 4786) DOC ID: 4786 Expenditure Transaction Report Updated: 9/21/2015 10:58 AM by Aida Wilkinson Page 1 Packet Pg. 186  3.q.a TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM DATE: September 24, 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. q. Expenditure Transactions (4786 : 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 August 2015. OPTIONS: N/A RECOMMENDATION TO BCC: N/A, for informational purposes only. Packet Pg. 187  SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 09/15/2015 OKALOOSA COUNTY BOCC AUDIT11 TIME: 08:12:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’15’ and transact.period=’11’ and transact.fund=’104’ ACCOUNTING PERIOD: 12/15 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 11/15 08/05/15 22 1,703.20 PAYROLL CHARGES 11/15 08/19/15 22 1,703.20 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 3,406.40 .00 521000 FICA TAXES 11/15 08/05/15 22 128.06 PAYROLL CHARGES−FRINGE 11/15 08/19/15 22 128.06 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 256.12 .00 522000 RETIREMENT CONTRIBUTIONS 11/15 08/05/15 22 123.65 PAYROLL CHARGES−FRINGE 11/15 08/19/15 22 123.65 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 247.30 .00 523000 LIFE & HEALTH INSURANCE 11/15 08/05/15 22 369.17 PAYROLL CHARGES−FRINGE 11/15 08/05/15 22 10.42 PAYROLL CHARGES−FRINGE 11/15 08/05/15 22 1.75 PAYROLL CHARGES−FRINGE 11/15 08/05/15 22 1.63 PAYROLL CHARGES−FRINGE 11/15 08/19/15 22 369.17 PAYROLL CHARGES−FRINGE 11/15 08/19/15 22 10.42 PAYROLL CHARGES−FRINGE 11/15 08/19/15 22 1.75 PAYROLL CHARGES−FRINGE 11/15 08/19/15 22 1.63 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 765.94 .00 523012 CONTRA L&H INS (REBATE) 11/15 08/06/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI 11/15 08/19/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00 540002 TRAVEL OUT−OF−COUNTY 11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 599.15 .00 DELTA AIR 0062316680258 TOTAL TRAVEL OUT−OF−COUNTY .00 599.15 .00 541011 CELLULAR PHONES/PAGERS 11/15 08/06/15 19 MOBILEDV −5.00 08/06/2015 MOBILE DEVICE 11/15 08/19/15 19 MOBILEDV −5.00 08/20/2015 MOBILE DEVICE 11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 17.99 .00 BEST BUY 00007997 TOTAL CELLULAR PHONES/PAGERS .00 7.99 .00 545990 INSURANCE−OTHER 11/15 08/10/15 19 BUDGET−5 118.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 118.00 .00 Packet Pg. 188 548001 PROMOTIONAL ACTIVITIES