READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — August 27, 2015 — III. o. Expenditure Transactions — reading text
Part 1 of 8. These parts divide the reading text for browsing; they are not the source document's page numbers.
III. o. Expenditure Transactions — extracted reading text
Machine-extracted OCR text · Review label: Known limitations
Compare this copy with the preserved source. Review labels describe the recorded status of this file; they do not guarantee that the text is error-free. Spacing and line breaks are retained, with long lines wrapped to fit the screen.
TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM
DATE: August 27, 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 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 July 2015.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 08/19/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 06:54:22 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’10’ and transact.fund=’104’
ACCOUNTING PERIOD: 11/15
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
10/15 07/08/15 22 1,703.20 PAYROLL CHARGES
10/15 07/22/15 22 1,703.20 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 3,406.40 .00
521000 FICA TAXES
10/15 07/08/15 22 128.06 PAYROLL CHARGES−FRINGE
10/15 07/22/15 22 128.06 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 256.12 .00
522000 RETIREMENT CONTRIBUTIONS
10/15 07/08/15 22 123.65 PAYROLL CHARGES−FRINGE
10/15 07/22/15 22 123.65 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 247.30 .00
523000 LIFE & HEALTH INSURANCE
10/15 07/08/15 22 369.17 PAYROLL CHARGES−FRINGE
10/15 07/08/15 22 10.42 PAYROLL CHARGES−FRINGE
10/15 07/08/15 22 1.75 PAYROLL CHARGES−FRINGE
10/15 07/08/15 22 1.63 PAYROLL CHARGES−FRINGE
10/15 07/22/15 22 369.17 PAYROLL CHARGES−FRINGE
10/15 07/22/15 22 10.42 PAYROLL CHARGES−FRINGE
10/15 07/22/15 22 1.75 PAYROLL CHARGES−FRINGE
10/15 07/22/15 22 1.63 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 765.94 .00
523012 CONTRA L&H INS (REBATE)
10/15 07/08/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
10/15 07/23/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00
534018 CS−CHAMBER OF COMMERCE
10/15 07/09/15 21 1507280 002981 FWB CHAMBER OF C 5,000.00 .00 JAN−MAR2015
10/15 07/16/15 21 1507418 002241 DESTIN AREA CHAM 5,000.00 .00 APR 15 − JUN 15
10/15 07/23/15 21 1507627 002981 FWB CHAMBER OF C 5,000.00 .00 APR−JUN 2015
TOTAL CS−CHAMBER OF COMMERCE .00 15,000.00 .00
540002 TRAVEL OUT−OF−COUNTY
10/15 07/09/15 21 1507324 EMP00334 GAIL MORGAN 162.00 .00 ST AUGUSTINE 6/28−7/1
10/15 07/09/15 21 1507324 EMP00334 GAIL MORGAN 386.58 .00 LOS ANGELES 5/26−6/2
10/15 07/24/15 21 V2150256 014799 BANK OF AMERICA 63.00 .00 HILTON ST AUGUSTINE HIS
TOTAL TRAVEL OUT−OF−COUNTY .00 611.58 .00
540005 TRAVEL LODGING EXPENSES
10/15 07/24/15 21 V2150256 014799 BANK OF AMERICA 567.00 .00 HILTON ST AUGUSTINE HIS
TOTAL TRAVEL LODGING EXPENSES .00 567.00 .00
RUN DATE 08/19/2015 TIME 06:54:22 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 08/19/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 06:54:22 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’10’ and transact.fund=’104’
ACCOUNTING PERIOD: 11/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
541011 CELLULAR PHONES/PAGERS
541011 CELLULAR PHONES/PAGERS
10/15 07/08/15 19 MOBILEDV −5.00 07/09/2015 MOBILE DEVICE
10/15 07/23/15 19 MOBILEDV −5.00 07/23/2015 MOBILE DEVICE
TOTAL CELLULAR PHONES/PAGERS .00 −10.00 .00
545990 INSURANCE−OTHER
10/15 07/01/15 19 BUDGET−5 118.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 118.00 .00
548001 PROMOTIONAL ACTIVITIES
10/15 07/10/15 17 21501166−01 21500229 AAA FLAG & BANNE 850.00 10 X 10 ECONO TENT PRINT
10/15 07/10/15 17 21501166−02 21500229 AAA FLAG & BANNE 292.50 HARDWARE * HARDWARE * 10
10/15 07/10/15 17 21501166−03 21500229 AAA FLAG & BANNE 317.50 8 X 10 BACKDROP MESH
10/15 07/10/15 17 21501166−04 21500229 AAA FLAG & BANNE 235.00 3 X 8 SIDE PANELS MESH
10/15 07/10/15 17 21501166−05 21500229 AAA FLAG & BANNE 115.00 HARDWARE * SIDE RAILS HAR
10/15 07/10/15 18 21501166−01 21500229 AAA FLAG & BANNE −850.00 CHANGE ORDER − 1
10/15 07/10/15 18 21501166−02 21500229 AAA FLAG & BANNE −292.50 CHANGE ORDER − 1
10/15 07/10/15 18 21501166−03 21500229 AAA FLAG & BANNE −317.50 CHANGE ORDER − 1
10/15 07/10/15 18 21501166−04 21500229 AAA FLAG & BANNE −235.00 CHANGE ORDER − 1
10/15 07/10/15 18 21501166−05 21500229 AAA FLAG & BANNE −115.00 CHANGE ORDER − 1
10/15 07/24/15 21 V2150256 014799 BANK OF AMERICA 40.43 .00 IMAGE PRINTING & DIGITAL
10/15 07/24/15 21 V2150256 014799 BANK OF AMERICA 172.36 .00 LULUS DESTIN
10/15 07/24/15 21 V2150256 014799 BANK OF AMERICA 320.00 .00 TOTALLY (866) 795−4657
TOTAL PROMOTIONAL ACTIVITIES .00 532.79 .00
548010 AGENCY BASE SVCS−MONTHLY
10/15 07/23/15 21 1507685 21300295 PETER A MAYER AD 641.79 .00 MARCH TRAVEL
10/15 07/23/15 21 1507685 21300295 PETER A MAYER AD 641.79 .00 MAY TRAVEL
10/15 07/23/15 21 1507685 21300295 PETER A MAYER AD 1,269.45 .00 TRAVEL EXPENSES
10/15 07/23/15 21 1507685 21300295 PETER A MAYER AD 27,348.75 .00 MAY BASE SERVICES
TOTAL AGENCY BASE SVCS−MONTHLY .00 29,901.78 .00
548011 AGENCY SVCS−OTHER
10/15 07/16/15 21 1507466 21300295 PETER A MAYER AD 1,897.50 .00 TO142 PURCH&REP
10/15 07/16/15 21 1507466 21300295 PETER A MAYER AD 8,481.25 .00 TO166 MEDIA PLANNING
TOTAL AGENCY SVCS−OTHER .00 10,378.75 .00
548020 WEBSITE DEV & MAINTENANCE
10/15 07/01/15 21 1507174 21300295 PETER A MAYER AD 3,536.25 .00 TO162 GROUP MTGS WEB
10/15 07/16/15 21 1507466 21300295 PETER A MAYER AD 10,436.25 .00 TO162 GRP WEBSITE
TOTAL WEBSITE DEV & MAINTENANCE .00 13,972.50 .00
548046 SUMMER CAMPAIGN
10/15 07/16/15 21 1507466 21300295 PETER A MAYER AD 1,523.75 .00 TO164 DAYS OF EC
10/15 07/23/15 21 1507685 21300295 PETER A MAYER AD 29,425.12 .00 TO148 SIRIUS RADIO
10/15 07/23/15 21 1507685 21300295 PETER A MAYER AD 74,033.63 .00 TO149 OKAT FY15
RUN DATE 08/19/2015 TIME 06:54:22 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 08/19/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 06:54:22 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’10’ and transact.fund=’104’
ACCOUNTING PERIOD: 11/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548046 SUMMER CAMPAIGN (cont’d)
TOTAL SUMMER CAMPAIGN .00 104,982.50 .00
548047 NON−SEASONAL
10/15 07/22/15 13 18,975.00