Okaloosa County BOCC — March 27, 2014 — III.c. 5th 1151

SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/02/13 22 11,899.05 PAYROLL CHARGES 1 /14 10/11/13 19 PR1BA −11,899.05 REVERSE 10−3−13 ACCRUAL TOTAL SALARIES/WAGES−FULL−TIME .00 .00 .00 512020 SALARIES/WAGES−PART−TIME 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/02/13 22 988.31 PAYROLL CHARGES 1 /14 10/11/13 19 PR1BA −988.31 REVERSE 10−3−13 ACCRUAL TOTAL SALARIES/WAGES−PART−TIME .00 .00 .00 514010 OVERTIME 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL OVERTIME .00 .00 .00 521000 FICA TAXES 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/02/13 22 960.96 PAYROLL CHARGES−FRINGE 1 /14 10/11/13 19 PR1BC −960.96 REVERSE 10−3−13 ACCRUAL TOTAL FICA TAXES .00 .00 .00 522000 RETIREMENT CONTRIBUTIONS 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/02/13 22 1,467.58 PAYROLL CHARGES−FRINGE 1 /14 10/11/13 19 PR1BD −1,467.58 REVERSE 10−3−13 ACCRUAL TOTAL RETIREMENT CONTRIBUTIONS .00 .00 .00 523000 LIFE & HEALTH INSURANCE 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/02/13 22 50.00 PAYROLL CHARGES 1 /14 10/02/13 22 2,175.00 PAYROLL CHARGES−FRINGE 1 /14 10/02/13 22 84.84 PAYROLL CHARGES−FRINGE 1 /14 10/02/13 22 16.17 PAYROLL CHARGES−FRINGE 1 /14 10/02/13 22 16.10 PAYROLL CHARGES−FRINGE 1 /14 10/18/13 19 COR1CC −2,342.11 CHARGE CORRECT DEPARTMENT TOTAL LIFE & HEALTH INSURANCE .00 .00 .00 523012 CONTRA L&H INS (REBATE) 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/07/13 19 REBATE −120.00 INSURANCE REBATE ALLOCATI 1 /14 10/18/13 19 COR1CC 120.00 CHARGE CORRECT DEPARTMENT TOTAL CONTRA L&H INS (REBATE) .00 .00 .00 524000 WORKERS’ COMPENSATION 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL WORKERS’ COMPENSATION .00 .00 .00 RUN DATE 03/18/2014 TIME 12:52:54 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 524000 WORKERS’ COMPENSATION (cont’d) 534002 CS−ADVERTISING 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 2 /14 11/07/13 11 .00 ESTABLISH 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 285.71 .00 TO59VISIT FLORIDA 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 603.75 .00 TO26 SUMMER CAMPG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 1,222.24 .00 TO33 SUMMER CAMPG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 5,982.82 .00 TO59VISIT FLORIDA 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 7,500.00 .00 TO64FALL CAMPG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 15,932.00 .00 TO63FALL FACEBOOK 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 17,036.00 .00 TO59VISIT FLORIDA 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 453.72 .00 TO33SUMMER MEDIA 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 1,021.32 .00 TO8 SHOULDER SEASON 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 26,529.85 .00 TO33INTERACTIVE MEDIA 1 /14 11/15/13 19 AJE1GC −28,004.89 REVERSE ACCRUE 2013 AP 2 /14 11/15/13 19 AJE1GB −48,562.52 REVERSE ACCRUE AJE13G3 TOTAL CS−ADVERTISING .00 .00 .00 534003 CS−CONSULTING 1 /14 09/30/13 11 66,500.00 POSTED FROM BUDGET SYSTEM 2 /14 11/07/13 21 V1400919 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION 3 /14 12/05/13 21 V1401457 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION 4 /14 01/09/14 21 V1402105 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION 5 /14 02/13/14 21 V1403112 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION 6 /14 03/06/14 21 V1403706 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION SVCS TOTAL CS−CONSULTING 66,500.00 15,833.35 .00 534009 CS−PUBLIC RELATIONS 1 /14 09/30/13 11 1,000.00 POSTED FROM BUDGET SYSTEM TOTAL CS−PUBLIC RELATIONS 1,000.00 .00 .00 534018 CS−CHAMBER OF COMMERCE 1 /14 09/30/13 11 40,000.00 POSTED FROM BUDGET SYSTEM 6 /14 03/06/14 21 1403658 002241 DESTIN AREA CHAM 5,000.00 .00 OCT−DEC2013 6 /14 03/06/14 21 3817 002981 FWB CHAMBER OF C 5,000.00 .00 OCT−DEC2013 6 /14 03/06/14 21 3817 002981 FWB CHAMBER OF C −5,000.00 .00 OCT−DEC2013 6 /14 03/06/14 21 E1403670 002981 FWB CHAMBER OF C 5,000.00 .00 OCT−DEC2013 TOTAL CS−CHAMBER OF COMMERCE 40,000.00 10,000.00 .00 534500 CS−PERSONNEL 1 /14 09/30/13 11 65,000.00 POSTED FROM BUDGET SYSTEM 1 /14 10/24/13 21 V1400490 009350 KELLY SERVICES,I 273.91 .00 WOLFENDEN 9/29/13 1 /14 10/24/13 21 1400493 21101150 LANDRUM STAFFING 1,048.56 .00 NIXON 10/5/13 1 /14 10/31/13 21 1400782 21101150 LANDRUM STAFFING 921.36 .00 NIXON 10/12/13 2 /14 11/07/13 21 1400912 21101150 LANDRUM STAFFING 93.28 .00 NIXON 10/19/13 2 /14 11/07/13 21 V1400910 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 10/13/13 RUN DATE 03/18/2014 TIME 12:52:54 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 3 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534500 CS−PERSONNEL (cont’d) 2 /14 11/07/13 21 V1400910 009350 KELLY SERVICES,I 289.76 .00 DUKES 10/13/13 2 /14 11/07/13 21 V1400910 009350 KELLY SERVICES,I 289.76 .00 DUKES 10/20/13 2 /14 11/07/13 21 1400912 21101150 LANDRUM STAFFING 904.40 .00 NIXON 10/19/13 2 /14 11/07/13 21 1400912 21101150 LANDRUM STAFFING 1,006.16 .00 NIXON 10/26/13 2 /14 11/14/13 21 V1401046 009350 KELLY SERVICES,I 23.00 .00 THATCHER 10/6/13 2 /14 11/14/13 21 V1401046 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 10/27/13 2 /14 11/14/13 21 V1401046 009350 KELLY SERVICES,I 283.35 .00 WOLFENDEN 10/20/13 2 /14 11/14/13 21 V1401046 009350 KELLY SERVICES,I 289.76 .00 DUKES 10/27/13 2 /14 11/14/13 21 V1401046 009350 KELLY SERVICES,I 508.50 .00 THATCHER 10/06/13 2 /14 11/14/13 21 1401050 21101150 LANDRUM STAFFING 921.36 .00 NIXON 11/02/13 2 /14 11/15/13 19 AJE1GB −273.91 REVERSE ACCRUE AJE13G3 4 /14 01/09/14 21 V1402090 009350 KELLY SERVICES,I 474.48 .00 DUKES 8/11/13 5 /14 03/05/14 19 COR5E2 12,935.80 RECLASS NIXON 6 /14 03/06/14 21 1403694 21101150 LANDRUM STAFFING 904.40 .00 NIXON 2/15/14 6 /14 03/06/14 21 1403694 21101150 LANDRUM STAFFING 904.40 .00 NIXON 2/22/14 TOTAL CS−PERSONNEL 65,000.00 22,081.69 .00 534600 CS−JANITORIAL 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL CS−JANITORIAL .00 .00 .00 534900 CS−OTHER 1 /14 09/30/13 11 1,100.00 POSTED FROM BUDGET SYSTEM TOTAL CS−OTHER 1,100.00 .00 .00 540001 TRAVEL IN−COUNTY 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL TRAVEL IN−COUNTY .00 .00 .00 540002 TRAVEL OUT−OF−COUNTY 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL TRAVEL OUT−OF−COUNTY .00 .00 .00 540005 TRAVEL LODGING EXPENSES 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL TRAVEL LODGING EXPENSES .00 .00 .00 541010 COMMUNICATIONS SERVICE 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 1 /14 10/29/13 11 .00 1 /14 10/31/13 21 1400718 001337 AT&T CORP 258.93 .00 TDD 3 /14 01/03/14 19 COR3EB −258.93 RECLASS TOTAL COMMUNICATIONS SERVICE .00 .00 .00 542001 POSTAGE/FREIGHT CHARGES 1 /14 09/30/13 11 59,500.00 POSTED FROM BUDGET SYSTEM RUN DATE 03/18/2014 TIME 12:52:55 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 4 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 542001 POSTAGE/FREIGHT CHARGES (cont’d) 4 /14 01/31/14 21 1402603 012490 UNITED STATES PO 2,000.00 .00 TDD POSTAGE TOTAL POSTAGE/FREIGHT CHARGES 59,500.00 2,000.00 .00 544620 R/L−BUILDINGS 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL R/L−BUILDINGS .00 .00 .00 544640 R/L−EQUIPMENT 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL R/L−EQUIPMENT .00 .00 .00 545990 INSURANCE−OTHER 1 /14 09/30/13 11 1,264.00 POSTED FROM BUDGET SYSTEM 1 /14 10/11/13 19 BUDGET−5 581.00 GENERAL LIABILITY 2 /14 11/01/13 19 BUDGET−5 62.00 GENERAL LIABILITY 3 /14 12/02/13 19 BUDGET−5 62.00 GENERAL LIABILITY 4 /14 01/02/14 19 BUDGET−5 62.00 GENERAL LIABILITY 5 /14 02/03/14 19 BUDGET−5 62.00 GENERAL LIABILITY 6 /14 03/03/14 19 BUDGET−5 62.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER 1,264.00 891.00 .00 547002 PRINTING & BINDING 1 /14 09/30/13 11 110,000.00 POSTED FROM BUDGET SYSTEM TOTAL PRINTING & BINDING 110,000.00 .00 .00 548001 PROMOTIONAL ACTIVITIES 1 /14 09/30/13 11 50,000.00 POSTED FROM BUDGET SYSTEM 1 /14 10/24/13 17 21301090−01 20600602 KIDZ ON THE COAS 1,825.00 ENCUMB CARRIED FORWARD 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 230.00 .00 TO66EMERALD CHRISTMAS 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 373.75 .00 TO73EMERALD CHRISTMAS 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 891.25 .00 TO45CHRISTMAS M/PLNNG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 2,386.25 .00 TO56BRAND TV MEDIA 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 3,162.61 .00 TO78EMERALD CHRISTMAS 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 3,450.00 .00 TO80 SMERF 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 4,140.00 .00 TO66EMERALD CHRISTMAS 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 4,690.00 .00 TO27 VIVA 500 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 7,417.50 .00 TO39FALL CAMPG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 7,768.25 .00 TO78EMERALD CHRISTMAS 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 8,855.00 .00 TO40 FALL CAMPG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 11,298.75 .00 TO39FALL CAMPG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 12,046.25 .00 TO37EMERALD CHRISTMAS 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 12,305.00 .00 TO76 2014 MEDIA PLNNG 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 12,678.75 .00 TO37EMERALD CHRISTMAS 2 /14 11/15/13 19 AJE1GB −91,693.36 REVERSE ACCRUE AJE13G3 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 468.16 .00 TO 71 ADDITIONAL FALL 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 8,280.00 .00 TO 45 CHRISTMAS MEDIA RUN DATE 03/18/2014 TIME 12:52:55 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 5 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548001 PROMOTIONAL ACTIVITIES (cont’d) 3 /14 01/03/14 19 COR3EB 1,766.58 RECLASS 4 /14 01/03/14 21 21301090−01 20600602 KIDZ ON THE COAS .00 −1,825.00 FULL PAGE ADVERTISEMENT − 4 /14 01/09/14 21 1402122 21300295 PETER A MAYER AD 57.50 .00 TO23 CHRISTMAS 4 /14 01/09/14 21 1402122 21300295 PETER A MAYER AD 57.50 .00 TO 23 CHRISTMAS 4 /14 01/09/14 21 1402122 21300295 PETER A MAYER AD 1,150.00 .00 TO23 CHRISTMAS 4 /14 01/16/14 17 21400580−01 21400076 FSE / IS MEDIA 1,000.00 SUNDANCE 2014 INSERTION O 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA 1,200.00 .00 HOLIDAY LIGHTING FL LLC 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA 2,440.00 .00 HOLIDAY LIGHTING FL LLC 4 /14 01/31/14 21 21400580−01 1402505 21400076 FSE / IS MEDIA 1,000.00 −1,000.00 SUNDANCE 2014 INSERTION O 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 38.72 .00 TOOMEYS MARDI GRAS 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 63.60 .00 GULF COAST OFFICE PRODUCT 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 83.99 .00 STAPLES 00118828 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 90.00 .00 THE GREATER FWB COC 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 708.84 .00 TOOMEYS MARDI GRAS 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 5,175.00 .00 TO97 MEDIATIME 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 8,941.25 .00 TO76 MEDIA PLANNING 5 /14 03/05/14 19 COR5E1 −468.16 RECATEGORIZE CAMPAING 5 /14 03/05/14 19 COR5E1 −9,545.00 RECATEGORIZE CAMPAING TOTAL PROMOTIONAL ACTIVITIES 50,000.00 21,507.98 .00 548010 AGENCY BASE SVCS−MONTHLY 1 /14 09/30/13 11 232,500.00 POSTED FROM BUDGET SYSTEM 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 855.00 .00 TO3 AUG2013 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 18,232.50 .00 TO47 JUNE 2013 BASE 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 18,232.50 .00 TO50 MONTHLY BASE 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 18,232.50 .00 TO49 MONTHLY BASE 1 /14 11/15/13 19 AJE1GC −36,465.00 REVERSE ACCRUE 2013 AP 2 /14 11/15/13 19 AJE1GB −19,087.50 REVERSE ACCRUE AJE13G3 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 18,232.50 .00 OCT 2013 4 /14 01/09/14 21 1402122 21300295 PETER A MAYER AD 1,418.50 .00 TO65 TRAVEL 4 /14 01/31/14 21 1402566 21300295 PETER A MAYER AD 18,232.50 .00 NOVEMBER 2013 4 /14 01/31/14 21 1402566 21300295 PETER A MAYER AD 1,382.19 .00 9/30−10/25 MISC TRAVE 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 18,232.50 .00 TO48BASE SVCS JUL13 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 202.08 .00 DEC13 TRAVEL 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 837.70 .00 NOV13 TRAVEL TOTAL AGENCY BASE SVCS−MONTHLY 232,500.00 76,770.47 .00 548020 WEBSITE DEV & MAINTENANCE 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 10,120.00 .00 TO54 WEBSITE 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 16,560.00 .00 TO74EMERALD CHRISTMAS 2 /14 11/07/13 11 .00 ESTABLISH 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 35,880.00 .00 TO54WEBSITE 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 43,700.00 .00 TO53WEBSITE 2 /14 11/14/13 21 1401076 21300295 PETER A MAYER AD 49,450.00 .00 TO55WEBSITE FRONT END 1 /14 11/15/13 19 AJE1GC −129,030.00 REVERSE ACCRUE 2013 AP RUN DATE 03/18/2014 TIME 12:52:55 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 6 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548020 WEBSITE DEV & MAINTENANCE (cont’d) 2 /14 11/15/13 19 AJE1GB −26,680.00 REVERSE ACCRUE AJE13G3 4 /14 01/23/14 13 4,068.00 BT−CA−14−10 5 /14 02/19/14 21 61713 21300295 PETER A MAYER AD 5,060.00 .00 TO1 WEBSITE DISCOVERY 5 /14 02/20/14 21 61713 21300295 PETER A MAYER AD −5,060.00 .00 TO1 WEBSITE DISCOVERY 5 /14 02/20/14 21 1403276 21300295 PETER A MAYER AD 5,060.00 .00 TO1 WEBSITE DISCOVERY 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 19.00 .00 DIGITAL FORTRESS, INC. 5 /14 02/25/14 21 V2140112 014799 BANK OF AMERICA 1,017.00 .00 REVIVE MEDIA SERVICES 6 /14 03/07/14 17 21400909−01 20900370 REVIVE MEDIA SER 3,051.00 WEBSITE/DATABASE SEO & MA TOTAL WEBSITE DEV & MAINTENANCE 4,068.00 6,096.00 3,051.00 548040 PUBLIC RELATIONS 1 /14 09/30/13 11 50,000.00 POSTED FROM BUDGET SYSTEM 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 2,012.50 .00 TO27 VIVA 500 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 2,530.00 .00 TO36FALL PR 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 3,507.50 .00 TO35 SUMMER PR 2 /14 11/07/13 21 1400932 21300295 PETER A MAYER AD 4,858.75 .00 TO44EMERALD CHRISTMAS 2 /14 11/15/13 19 AJE1GB −12,908.75 REVERSE ACCRUE AJE13G3 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 3,047.50 .00 TO 36 FALL PR CAMPAIG 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 230.00 .00 TO 32 SUMMER CAMPAIGN 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 287.50 .00 TO 41 CRISIS COMMUN 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 977.50 .00 TO 35 SUMMER PR 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 1,063.75 .00 TO 41 CRISIS COMMUNIC 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 2,271.25 .00 TO 35 SUMMER PR 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 3,248.75 .00 TO 35 SUMMER PR 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 8,998.75 .00 TO 32 SUMMER CAMPAIGN 2 /14 11/27/13 21 1401334 21300295 PETER A MAYER AD 230.00 .00 TO 36 FALL PR CAMPAIG 4 /14 01/09/14 21 1402122 21300295 PETER A MAYER AD 15,509.02 .00 TO36 FALL PR CAMPAIGN 4 /14 01/10/14 19 COR4BA 92.12 RECLASS 5 /14 02/06/14 21 1402700 21300295 PETER A MAYER AD 258.75 .00 TO41HURRICANE PLANNIN 5 /14 03/05/14 19 COR5E1 −18,786.52 RECATEGORIZE CAMPAING 5 /14 03/05/14 19 COR5E1 −15,726.25 RECATEGORIZE CAMPAING TOTAL PUBLIC RELATIONS 50,000.00 1,702.12 .00 548041 RESEARCH 1 /14 09/30/13 11 55,000.00 POSTED FROM BUDGET SYSTEM 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 34,450.00 .00 TO5CONSUMER RESEARCH TOTAL RESEARCH 55,000.00 34,450.00 .00 548042 FALL CAMPAIGN 1 /14 09/30/13 11 200,000.00 POSTED FROM BUDGET SYSTEM 3 /14 12/05/13 21 1401468 21300295 PETER A MAYER AD 6,393.44 .00 TO59INTERACTIVE MEDIA 3 /14 12/05/13 21 1401468 21300295 PETER A MAYER AD 3,921.57 .00 TO62INTERACTIVE MEDIA 5 /14 02/06/14 21 1402700 21300295 PETER A MAYER AD 1,200.00 .00 TO103 SOCIAL MEDIA 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 977.90 .00 TO59 FALL CHAMPAIGN 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 4,370.00 .00 TO40FALL MEDIA 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 28,894.13 .00 TO71INTERACTIVE MEDIA RUN DATE 03/18/2014 TIME 12:52:55 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 7 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548042 FALL CAMPAIGN (cont’d) 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 63,831.70 .00 TO59 MAGAZINE 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 3,010.00 .00 TO113MAGAZINE 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 16,500.00 .00 TO64FALL CAMPAIGN 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 23,175.00 .00 TO68MAGAZINE 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 1,035.00 .00 TO36FALL PUB RELATION 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 10,522.50 .00 TO39FALL CAMPAIGN 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 62,000.00 .00 TO59MAGAZINE 5 /14 03/05/14 19 COR5E1 468.16 RECATEGORIZE CAMPAING 5 /14 03/05/14 19 COR5E1 18,786.52 RECATEGORIZE CAMPAING 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 431.25 .00 TO40MEDIA TOTAL FALL CAMPAIGN 200,000.00 245,517.17 .00 548043 CHRISTMAS CAMPAIGN 1 /14 09/30/13 11 525,000.00 POSTED FROM BUDGET SYSTEM 3 /14 12/30/13 21 V2140067 014799 BANK OF AMERICA 39.00 .00 DESTIN HISTORY,FISHING MU 3 /14 12/30/13 21 V2140067 014799 BANK OF AMERICA 92.12 .00 HI WINECNTRYGIFTBSKT 4 /14 01/10/14 19 COR4BA −92.12 RECLASS 5 /14 02/06/14 21 1402700 21300295 PETER A MAYER AD 1,200.00 .00 TO103 SOCIAL MEDIA 5 /14 02/06/14 21 1402700 21300295 PETER A MAYER AD 5,530.00 .00 TO86 CHRISTMAS RADIO 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 862.50 .00 TO66CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 5,216.31 .00 TO85 CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 7,963.75 .00 TO91 CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 9,217.49 .00 TO75 MAGAZINE 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 14,173.75 .00 TO46CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 14,432.00 .00 TO87 CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 15,036.25 .00 TO73CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 16,272.50 .00 TO45CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 17,796.25 .00 TO66CHRISTMAS 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 20,000.00 .00 TO94 CHRISTMAS 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 935.00 .00 TO102CHRISTMAS 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 13,255.75 .00 TO93 RADIO 5 /14 03/05/14 19 COR5E1 9,545.00 RECATEGORIZE CAMPAING 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 251.20 .00 TO75 MAGAZINE 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 76,478.86 .00 TO75 MAGAZINE 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 86.25 .00 TO45CHRISTMAS 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 376.05 .00 TO108 CHRISTMAS 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 402.50 .00 TO44CHRISTMAS 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 1,063.75 .00 TO45CHRISTMAS 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 1,178.75 .00 TO46 CHRISTMAS 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 1,495.00 .00 TO46CHRISTMAS 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 4,542.50 .00 TO44CHRISTMAS TOTAL CHRISTMAS CAMPAIGN 525,000.00 237,350.41 .00 548044 SNOWBIRD CAMPAIGN 1 /14 09/30/13 11 130,000.00 POSTED FROM BUDGET SYSTEM TOTAL SNOWBIRD CAMPAIGN 130,000.00 .00 .00 RUN DATE 03/18/2014 TIME 12:52:56 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 8 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548044 SNOWBIRD CAMPAIGN (cont’d) 548045 SPRING CAMPAIGN 1 /14 09/30/13 11 200,000.00 POSTED FROM BUDGET SYSTEM TOTAL SPRING CAMPAIGN 200,000.00 .00 .00 548046 SUMMER CAMPAIGN 1 /14 09/30/13 11 100,000.00 POSTED FROM BUDGET SYSTEM 3 /14 12/05/13 21 1401468 21300295 PETER A MAYER AD 488.75 .00 TO26SUMMER CAMPAIGN 3 /14 12/05/13 21 1401468 21300295 PETER A MAYER AD 10,148.75 .00 TO26SUMMER CAMPAIGN 5 /14 03/05/14 19 COR5E1 15,726.25 RECATEGORIZE CAMPAING 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 18,663.26 .00 TO33INTERACTIVE MEDIA TOTAL SUMMER CAMPAIGN 100,000.00 45,027.01 .00 548047 NON−SEASONAL 1 /14 09/30/13 11 25,000.00 POSTED FROM BUDGET SYSTEM TOTAL NON−SEASONAL 25,000.00 .00 .00 548049 BRANDING 1 /14 09/30/13 11 200,000.00 POSTED FROM BUDGET SYSTEM 5 /14 02/13/14 21 1403121 21300295 PETER A MAYER AD 13,656.25 .00 TO56BRAND TV MEDIA 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 3,795.00 .00 TO56TV MEDIA 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 948.75 .00 TO56BRAND TV MEDIA TOTAL BRANDING 200,000.00 18,400.00 .00 548051 CAMPAIGN PRODUCTION 1 /14 09/30/13 11 250,000.00 POSTED FROM BUDGET SYSTEM 5 /14 02/19/14 21 1403276 21300295 PETER A MAYER AD 1,019.32 .00 TO100CAMPAIGN PRODUCT 5 /14 02/27/14 21 1403423 21300295 PETER A MAYER AD 9,631.25 .00 TO97 MEDIA TIME TOTAL CAMPAIGN PRODUCTION 250,000.00 10,650.57 .00 549520 ADMINISTRATIVE CHARGES 1 /14 09/30/13 11 72,000.00 POSTED FROM BUDGET SYSTEM 2 /14 11/12/13 19 PAYSIMPL .06 OCT 2013 3 /14 12/11/13 24 000004 BENJAMIN F ANDER 4,081.98 10/13 TDD CASH 1 /14 01/09/14 19 TDCSPLIT 4,081.98 REALLOCATE 3&4 CENT TDT 2 /14 01/09/14 19 TDCSPLIT 1,638.23 REALLOCATE 3&4 CENT TDT 3 /14 01/10/14 19 COR3FA −4,081.98 RECLASS 3 /14 02/27/14 19 TDCSPLIT 1,750.03 REALLOCATE 3&4 CENT TDT 4 /14 03/12/14 19 TDCSPLIT 1,992.21 REALLOCATE JAN 2014 TAX TOTAL ADMINISTRATIVE CHARGES 72,000.00 9,462.51 .00 549900 MISCELLANEOUS CHARGES 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 6 /14 03/13/14 11 .00 6 /14 03/13/14 21 V1403872 002498 OKALOOSA COUNTY 105.75 .00 2012BOBW VIN..A393021 6 /14 03/13/14 21 V1403872 002498 OKALOOSA COUNTY 105.75 .00 2012BOBW VIN..A393020 RUN DATE 03/18/2014 TIME 12:52:56 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 9 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549900 MISCELLANEOUS CHARGES (cont’d) TOTAL MISCELLANEOUS CHARGES .00 211.50 .00 549904 JOB LISTING EXPENSES 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL JOB LISTING EXPENSES .00 .00 .00 549905 MOTOR VEHICLE REPORTS 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM TOTAL MOTOR VEHICLE REPORTS .00 .00 .00 549906 BACKGROUND CHECKS 1 /14 09/30/13 11 .00 POSTED FROM BUDGET SYSTEM 4 /14 01/09/14 11 .00 ESTABLISH 4 /14 01/09/14 21 V1402090 009350 KELLY SERVICES,I −1.45 .00 DUKES 8/11/13 4 /14 01/09/14 21 V1402090 009350 KELLY SERVICES,I 10.56 .00 DUKES 8/11/13 TOTAL BACKGROUND CHECKS .00 9.11 .00 551001 OFFICE SUPPLIES 1 /14 09/30/13 11 7,000.00 POSTED FROM BUDGET SYSTEM 2 /14 11/21/13 21 V2140046 014799 BANK OF AMERICA 7.74 .00 GULF COAST OFFICE PRODUCT 2 /14 11/21/13 21 V2140046 014799 BANK OF AMERICA 25.99 .00 STAPLES DIRECT 2 /14 11/21/13 21 V2140046 014799 BANK OF AMERICA 301.57 .00 STAPLS3145014817000 2 /14 11/21/13 21 V2140046 014799 BANK OF AMERICA 1,456.54 .00 STAPLES DIRECT 3 /14 12/30/13 21 V2140067 014799 BANK OF AMERICA 10.98 .00 STAPLES DIRECT 3 /14 12/30/13 21 V2140067 014799 BANK OF AMERICA 67.16 .00 STAPLES DIRECT 3 /14 12/30/13 21 V2140067 014799 BANK OF AMERICA 83.89 .00 STAPLES DIRECT 3 /14 12/30/13 21 V2140067 014799 BANK OF AMERICA 95.38 .00 STAPLES DIRECT 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA −15.79 .00 STAPLES DIRECT 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA 73.75 .00 STAPLES DIRECT 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA 75.95 .00 STAPLES DIRECT 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA 94.43 .00 STAPLES DIRECT 4 /14 01/28/14 21 V2140088 014799 BANK OF AMERICA 101.39 .00 STAPLES DIRECT TOTAL OFFICE SUPPLIES 7,000.00 2,378.98 .00 552800 COMPUTER SUPPLIES 1 /14 09/30/13 11 1,200.00 POSTED FROM BUDGET SYSTEM 2 /14 11/21/13 21 V2140046 014799 BANK OF AMERICA 99.00 .00 REGISTER.COM 1236FDF8J TOTAL COMPUTER SUPPLIES 1,200.00 99.00 .00 552801 COMPUTER SOFTWARE 1 /14 09/30/13 11 1,500.00 POSTED FROM BUDGET SYSTEM TOTAL COMPUTER SOFTWARE 1,500.00 .00 .00 552990 OTHER SUPPLIES 1 /14 09/30/13 11 1,000.00 POSTED FROM BUDGET SYSTEM 2 /14 11/21/13 21 V2140046 014799 BANK OF AMERICA 1,766.58 .00 THE TROPHY CENTER INC. RUN DATE 03/18/2014 TIME 12:52:56 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 10 DATE: 03/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 12:52:54 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.key_orgn=’1151’ ACCOUNTING PERIOD: 6/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 552990 OTHER SUPPLIES (cont’d) 3 /14 01/03/14 19 COR3EB −1,766.58 RECLASS TOTAL OTHER SUPPLIES 1,000.00 .00 .00 554001 BOOK/PUB/SUB/MEMBERSHIPS 1 /14 09/30/13 11 8,000.00 POSTED FROM BUDGET SYSTEM 1 /14 11/08/13 19 AJE1FC 7,798.24 CLEAR PREPAID TOTAL BOOK/PUB/SUB/MEMBERSHIPS 8,000.00 7,798.24 .00 555001 TRAINING/EDUCATION EXPENS 1 /14 09/30/13 11 2,000.00 POSTED FROM BUDGET SYSTEM TOTAL TRAINING/EDUCATION EXPENS 2,000.00 .00 .00 599090 RESERVE FOR CONTINGENCIES 1 /14 09/30/13 11 3,505,436.00 POSTED FROM BUDGET SYSTEM 3 /14 12/26/13 13 −504,653.00 BA−#27 4 /14 01/23/14 13 −4,068.00 BT−CA−14−10 TOTAL RESERVE FOR CONTINGENCIES 2,996,715.00 .00 .00 TOTAL 5TH TDT−TOURISM PROMOTION 5,455,347.00 768,237.11 3,051.00 TOTAL TOURIST DEVELOPMENT FUND 5,455,347.00 768,237.11 3,051.00 TOTAL REPORT 5,455,347.00 768,237.11 3,051.00 RUN DATE 03/18/2014 TIME 12:52:56 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING