READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — July 21, 2016 — III. t. Expenditure Transactions — reading text
Part 1 of 7. These parts divide the reading text for browsing; they are not the source document's page numbers.
III. t. 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: July 21, 2016
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 June 2016.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 07/14/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 05:56:52 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’9’ and transact.fund=’104’
ACCOUNTING PERIOD: 10/16
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
9 /16 06/08/16 22 1,774.40 PAYROLL CHARGES
9 /16 06/23/16 22 1,774.40 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 3,548.80 .00
521000 FICA TAXES
9 /16 06/08/16 22 133.46 PAYROLL CHARGES−FRINGE
9 /16 06/23/16 22 133.46 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 266.92 .00
522000 RETIREMENT CONTRIBUTIONS
9 /16 06/08/16 22 128.82 PAYROLL CHARGES−FRINGE
9 /16 06/23/16 22 128.82 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 257.64 .00
523000 LIFE & HEALTH INSURANCE
9 /16 06/08/16 22 380.25 PAYROLL CHARGES−FRINGE
9 /16 06/08/16 22 10.94 PAYROLL CHARGES−FRINGE
9 /16 06/08/16 22 1.75 PAYROLL CHARGES−FRINGE
9 /16 06/08/16 22 1.63 PAYROLL CHARGES−FRINGE
9 /16 06/23/16 22 380.25 PAYROLL CHARGES−FRINGE
9 /16 06/23/16 22 10.94 PAYROLL CHARGES−FRINGE
9 /16 06/23/16 22 1.63 PAYROLL CHARGES−FRINGE
9 /16 06/23/16 22 1.75 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 789.14 .00
523012 CONTRA L&H INS (REBATE)
9 /16 06/30/16 19 REBATE −40.00 INS REB ALLOC PER9
TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00
524000 WORKERS’ COMPENSATION
9 /16 06/01/16 19 BUDGET−3 10.00 JUNE 2016
TOTAL WORKERS’ COMPENSATION .00 10.00 .00
540002 TRAVEL OUT−OF−COUNTY
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA 1.75 .00 LA CITY PARKING METER
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA 60.00 .00 DELTA AIR BAGGAGE F
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA 649.20 .00 DELTA AIR 006234405
TOTAL TRAVEL OUT−OF−COUNTY .00 710.95 .00
541011 CELLULAR PHONES/PAGERS
9 /16 06/16/16 21 1607516 20900128 VERIZON WIRELESS 49.73 .00 4/24−5/23/16 TDD
9 /16 06/30/16 19 MOBILEDV −10.00 JUN16 PR MOBILE DEVICE
TOTAL CELLULAR PHONES/PAGERS .00 39.73 .00
545990 INSURANCE−OTHER
9 /16 06/01/16 19 BUDGET−5 34.00 GENERAL LIABILITY
RUN DATE 07/14/2016 TIME 05:56:52 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 07/14/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 05:56:52 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’9’ and transact.fund=’104’
ACCOUNTING PERIOD: 10/16
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
545990 INSURANCE−OTHER (cont’d)
TOTAL INSURANCE−OTHER .00 34.00 .00
548001 PROMOTIONAL ACTIVITIES
9 /16 06/22/16 13 −2,594.00 BT−CA−16−20
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA −59.98 .00 STAPLS6920606281001
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA 35.98 .00 STAPLES 0011882
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA 59.98 .00 STAPLS6920606281000
9 /16 07/06/16 21 V2160244 014799 BANK OF AMERICA 973.00 .00 PROFESSIONAL MARKETIN
TOTAL PROMOTIONAL ACTIVITIES −2,594.00 1,008.98 .00
548010 AGENCY BASE SVCS−MONTHLY
9 /16 06/09/16 21 1607317 21300295 PETER A MAYER AD 778.65 .00 TRAVEL
9 /16 06/16/16 21 1607474 21300295 PETER A MAYER AD 306.72 .00 TRAVEL
9 /16 06/23/16 21 1607646 21300295 PETER A MAYER AD 27,348.75 .00 MAR2016
9 /16 06/23/16 21 1607646 21300295 PETER A MAYER AD 27,348.75 .00 FEB2016
TOTAL AGENCY BASE SVCS−MONTHLY .00 55,782.87 .00
548044 SNOWBIRD CAMPAIGN
9 /16 06/02/16 21 1607198 21300295 PETER A MAYER AD 1,868.14 .00 TO173 INTERFUSE MEDIA
9 /16 06/09/16 21 1607317 21300295 PETER A MAYER AD 498.51 .00 MEDIA PASS THROUGH
TOTAL SNOWBIRD CAMPAIGN .00 2,366.65 .00
548046 SUMMER CAMPAIGN
9 /16 06/02/16 21 1607198 21300295 PETER A MAYER AD 3,406.59 .00 TO173 INTERFUSE MEDIA
9 /16 06/02/16 21 1607198 21300295 PETER A MAYER AD 4,100.00 .00 TO186 FOOD/TRVL QRTLY
9 /16 06/02/16 21 1607198 21300295 PETER A MAYER AD 24,000.00 .00 TO173 COASTAL LIVING
9 /16 06/09/16 21 1607317 21300295 PETER A MAYER AD 5,610.00 .00 SATELLITE RADIO
9 /16 06/09/16 21 1607317 21300295 PETER A MAYER AD 6,183.12 .00 MEDIA PASS THROUGH
9 /16 06/16/16 21 1607474 21300295 PETER A MAYER AD 10,153.20 .00 PRINT LEISURE
9 /16 06/29/16 21 1607779 21300295 PETER A MAYER AD 10,500.00 .00 LEISURE
9 /16 06/29/16 21 1607779 21300295 PETER A MAYER AD 22,799.53 .00 HOLIDAY LEISURE
9 /16 06/29/16 21 1607779 21300295 PETER A MAYER AD 25,000.00 .00 PRINT LEISURE
TOTAL SUMMER CAMPAIGN .00 111,752.44 .00
548047 NON−SEASONAL
9 /16 06/16/16 21 1607474 21300295 PETER A MAYER AD 17,833.88 .00 GULF TO TABLE
TOTAL NON−SEASONAL .00 17,833.88 .00
548051 CAMPAIGN PRODUCTION
9 /16 06/09/16 21 1607317 21300295 PETER A MAYER AD 258.75 .00 CREATVIVE REFRESH
9 /16 06/09/16 21 1607317 21300295 PETER A MAYER AD 1,638.75 .00 CREATIVE SVCS
TOTAL CAMPAIGN PRODUCTION .00 1,897.50 .00
548060 SPECIAL EVENTS
9 /16 06/08/16 17 21600853−01 21600129 JEFFREY L STRODE 20,000.00 LOCAL EVENT MARKETING FUN
9 /16 06/16/16 17 21600889−01 21001823 FLORIDA POWERBOA 5,230.00 LOCAL EVENT MARKETING FUN
RUN DATE 07/14/2016 TIME 05:56:52 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 07/14/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 05:56:52 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’9’ and transact.fund=’104’
ACCOUNTING PERIOD: 10/16
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548060 SPECIAL EVENTS (cont’d)
9 /16 06/16/16 21 21600006−01 V1607446 000428 HORIZONS OF OKAL 656.88 −3,574.00 LOCAL EVENT MARKETING FUN
TOTAL SPECIAL EVENTS .00