Okaloosa County BOCC — March 26, 2015 — Agenda Packet — reading text

62.63% 29.62% Page 7 Packet Pg. 59  3.i.a Total TDT Collections and Percentage Breakdown FY 2015 Attachment: III.j. TDT Reports OCTC (Jan 15) (4015 : Okaloosa Tax Collector Report) TOTAL MONTH FIRST % SECOND % THIRD % FOURTH % FIFTH % COLLECTIONS 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 $ - $ - $ - $ - $ - $ - March $ - $ - $ - $ - $ - $ - April $ - $ - $ - $ - $ - $ - May $ - $ - $ - $ - $ - $ - June $ - $ - $ - $ - $ - $ - July $ - $ - $ - $ - $ - $ - August $ - $ - $ - $ - $ - $ - September $ - $ - $ - $ - $ - $ - Total $ 1,932,192.48 $ 386,438.50 $ 386,438.50 $ 386,438.50 $ 386,438.50 $ 386,438.50 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8 Packet Pg. 60  3.j Tourist Development Council Meeting: 03/26/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 # 4016) DOC ID: 4016 Expenditure Transaction Report Updated: 3/23/2015 1:17 PM by Aida Wilkinson Page 1 Packet Pg. 61  3.j.a TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM DATE: March 26, 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 Attachment: III.k. Expenditure Transactions (4016 : Expenditure Transaction Report) continuously 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 February 2015. OPTIONS: N/A RECOMMENDATION TO BCC: N/A, for informational purposes only. Packet Pg. 62  SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 03/19/2015 OKALOOSA COUNTY BOCC AUDIT11 TIME: 15:26:56 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’15’ and transact.period=’5’ and transact.fund=’104’ ACCOUNTING PERIOD: 6/15 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534003 CS−CONSULTING 5 /15 02/05/15 21 V1503162 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION SVCS TOTAL CS−CONSULTING .00 3,166.67 .00 534018 CS−CHAMBER OF COMMERCE 5 /15 02/05/15 21 1503127 002981 FWB CHAMBER OF C 5,000.00 .00 1ST QTR 10/1−12/31/14 TOTAL CS−CHAMBER OF COMMERCE .00 5,000.00 .00 540002 TRAVEL OUT−OF−COUNTY 5 /15 02/26/15 21 1503814 EMP00284 ED SCHROEDER 41.00 .00 F/LAUD’DALE1/14−17/15 TOTAL TRAVEL OUT−OF−COUNTY .00 41.00 .00 541010 COMMUNICATIONS SERVICE 5 /15 02/06/15 11 .00 ESTABLISH PER CD 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 83.40 .00 HOSTGATOR.COM TOTAL COMMUNICATIONS SERVICE .00 83.40 .00 545990 INSURANCE−OTHER 5 /15 02/02/15 19 BUDGET−5 118.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 118.00 .00 548001 PROMOTIONAL ACTIVITIES 5 /15 02/26/15 21 1503703 20302163 ARAMARK SPORTS & 3,528.00 .00 TOURISM SUMMIT LUNCH 5 /15 02/26/15 21 21500484−01 V1503780 20501697 KOST ENTERPRISES 2,498.00 −2,498.00 DOUBLE WALL POLY BAGS WIT 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 7.35 .00 WAL−MART #0944 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 35.66 .00 WM SUPERCENTER #944 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 60.00 .00 THE GREATER FWB COC 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 69.98 .00 OFFICE MAX 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 80.39 .00 STAPLES 00118828 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 140.27 .00 PARTY CITY #295 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 169.58 .00 OFFICE DEPOT #206 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 487.30 .00 TOOMEYS MARDI GRAS 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 611.15 .00 IMAGE PRINTING & DIGITAL TOTAL PROMOTIONAL ACTIVITIES .00 7,687.68 −2,498.00 548003 TRADE SHOW FEES 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 35.00 .00 VISIT FLORIDA SERVICE CEN 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 35.00 .00 VISIT FLORIDA SERVICE CEN 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 143.10 .00 IN GOBEN CONVENTION SERV 5 /15 02/26/15 21 V2150127 014799 BANK OF AMERICA 1,600.00 .00 IN GOBEN CONVENTION SERV TOTAL TRADE SHOW FEES .00 1,813.10 .00 548010 AGENCY BASE SVCS−MONTHLY 5 /15 02/05/15 21 1503174 21300295 PETER A MAYER AD 314.80 .00 10/15−16/14 DESTIN 5 /15 02/05/15 21 1503174 21300295 PETER A MAYER AD 27,348.75 .00 NOV2014 Packet Pg. 63 5 /15 02/26/15 21 1503802 21300295 PETER A MAYER AD 27,348.75 .00 DECEMBER 2014 TOTAL AGENCY BASE SVCS−MONTHLY .00 55,012.30 .00 RUN DATE 03/19/2015 TIME 15:26:57 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.j.a Attachment: III.k. Expenditure Transactions (4016 : Expenditure Transaction Report)  SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 DATE: 03/19/2015