Okaloosa County BOCC — September 16, 2014 — reading text

Packet Pg. 677 Financial Update – August 2014 EXPENDITURE TRANSACTION ANALYSIS Pursuant to Florida Statutes 125.0104(4)(e), “The council shall continuously review expenditures… Expenditures which the council believes to be unauthorized shall be reported to the county governing board and the Department of Revenue”. 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 months of June & July 2014. TDC Recommendation to BCC Approve the financial update as presented. August 21, 2014 Tourist Development Department, Okaloosa County, FL 6 of 6 Packet Pg. 678  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 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 10/14 07/02/14 21 V1406819 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION SVCS TOTAL CS−CONSULTING .00 3,166.67 .00 534018 CS−CHAMBER OF COMMERCE 10/14 07/10/14 21 1406947 002241 DESTIN AREA CHAM 5,000.00 .00 APR−JUN2014 TDD TOTAL CS−CHAMBER OF COMMERCE .00 5,000.00 .00 534500 CS−PERSONNEL 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 121.24 .00 LATIMER 6/15/14 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 237.30 .00 THATCHER 6/8/14 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 549.91 .00 WARDLOW 6/15/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 69.28 .00 LISHEFSKI 6/22/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 692.80 .00 WARDLOW 6/22/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 6/21/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 108.00 .00 HALSEY 6/21/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 252.70 .00 NIXON 6/28/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 138.56 .00 WARDLOW 6/29/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 207.84 .00 LISHEFSKI 6/29/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 237.30 .00 THATCHER 6/22/14 TOTAL CS−PERSONNEL .00 3,678.93 .00 540002 TRAVEL OUT−OF−COUNTY 10/14 07/17/14 21 V1407147 21200456 GAIL MORGAN 1,664.36 .00 LOS ANGELES CA TOTAL TRAVEL OUT−OF−COUNTY .00 1,664.36 .00 540005 TRAVEL LODGING EXPENSES 10/14 07/17/14 21 V1407147 21200456 GAIL MORGAN 1,494.43 .00 LOS ANGELES CA TOTAL TRAVEL LODGING EXPENSES .00 1,494.43 .00 545990 INSURANCE−OTHER 10/14 07/01/14 19 BUDGET−5 62.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 62.00 .00 547002 PRINTING & BINDING 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 740.00 .00 OFFICE DEPOT #1099 TOTAL PRINTING & BINDING .00 740.00 .00 548003 TRADE SHOW FEES 10/14 07/31/14 21 V1407429 21200456 GAIL MORGAN 2,000.00 .00 REGISTRATION Packet Pg. 679 TOTAL TRADE SHOW FEES .00 2,000.00 .00 548010 AGENCY BASE SVCS−MONTHLY 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 1,522.47 .00 TRAVEL HARD COST 10/14 07/10/14 21 1407009 21300295 PETER A MAYER AD 2,350.25 .00 TRAVEL HARD COST 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS RUN DATE 08/20/2014 TIME 09:51:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548010 AGENCY BASE SVCS−MONTHLY (cont’d) 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS TOTAL AGENCY BASE SVCS−MONTHLY .00 95,035.22 .00 548011 AGENCY SVCS−OTHER 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 21,965.00 .00 TO98 MEDIA PLANNING TOTAL AGENCY SVCS−OTHER .00 21,965.00 .00 548020 WEBSITE DEV & MAINTENANCE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 19.00 .00 SERVERSTADIUM.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 19.00 .00 SERVERSTADIUM.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 339.00 .00 GETTY IMAGES TOTAL WEBSITE DEV & MAINTENANCE .00 377.00 .00 548042 FALL CAMPAIGN 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 6,078.43 .00 TO62 SOUTHERN LIVING 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 71,102.50 .00 TO113 JAN−SEP PRINT TOTAL FALL CAMPAIGN .00 77,180.93 .00 548043 CHRISTMAS CAMPAIGN 10/14 07/14/14 19 CORJBB 20,000.00 CORRECT #1403121 10/14 07/14/14 19 CORJBB −20,000.00 CORRECT #1403121 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD −6,078.44 .00 TO75INTERACTIVE MEDIA 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 6,078.43 .00 TO75 S LIVING CO−OP 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 10,664.28 .00 TO75 DEC13 S LIVING TOTAL CHRISTMAS CAMPAIGN .00 10,664.27 .00 548046 SUMMER CAMPAIGN 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 3,010.00 .00 TO113 JAN−SEP PRINT TOTAL SUMMER CAMPAIGN .00 3,010.00 .00 548047 NON−SEASONAL 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 5,000.00 .00 TO139JAN−SEP PRINT 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 25,134.20 .00 TO113 JAN−SEP PRINT TOTAL NON−SEASONAL .00 30,134.20 .00 548051 CAMPAIGN PRODUCTION 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 3,153.00 .00 TO133 BRAND CAMPAIGN Packet Pg. 680 TOTAL CAMPAIGN PRODUCTION .00 3,153.00 .00 549906 BACKGROUND CHECKS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 24.00 .00 FDLE CCHINET TOTAL BACKGROUND CHECKS .00