READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — October 22, 2015 — III. n. Expenditure Transactions — reading text
Part 1 of 10. These parts divide the reading text for browsing; they are not the source document's page numbers.
III. n. 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: October 22, 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 September 2015.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 10/14/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 07:44:56 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’12’ and transact.fund=’104’
ACCOUNTING PERIOD: 1/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
12/15 09/02/15 22 1,703.20 PAYROLL CHARGES
12/15 09/21/15 22 1,703.20 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 3,406.40 .00
521000 FICA TAXES
12/15 09/02/15 22 128.06 PAYROLL CHARGES−FRINGE
12/15 09/21/15 22 128.06 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 256.12 .00
522000 RETIREMENT CONTRIBUTIONS
12/15 09/02/15 22 123.65 PAYROLL CHARGES−FRINGE
12/15 09/21/15 22 123.65 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 247.30 .00
523000 LIFE & HEALTH INSURANCE
12/15 09/02/15 22 369.17 PAYROLL CHARGES−FRINGE
12/15 09/02/15 22 10.42 PAYROLL CHARGES−FRINGE
12/15 09/02/15 22 1.75 PAYROLL CHARGES−FRINGE
12/15 09/02/15 22 1.63 PAYROLL CHARGES−FRINGE
12/15 09/21/15 22 369.17 PAYROLL CHARGES−FRINGE
12/15 09/21/15 22 10.42 PAYROLL CHARGES−FRINGE
12/15 09/21/15 22 1.63 PAYROLL CHARGES−FRINGE
12/15 09/21/15 22 1.75 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 765.94 .00
523012 CONTRA L&H INS (REBATE)
12/15 09/02/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
12/15 09/21/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00
540002 TRAVEL OUT−OF−COUNTY
12/15 09/24/15 21 V1509421 EMP00334 GAIL MORGAN 127.00 .00 TAMPA 8/29−9/2/15
12/15 09/30/15 21 V1509579 EMP00334 GAIL MORGAN 34.00 .00 TAMPA FL 8/29−9/2/15
TOTAL TRAVEL OUT−OF−COUNTY .00 161.00 .00
540005 TRAVEL LODGING EXPENSES
12/15 09/28/15 21 V2150309 014799 BANK OF AMERICA 668.00 .00 MARRIOTT 337UA WATERS
TOTAL TRAVEL LODGING EXPENSES .00 668.00 .00
541011 CELLULAR PHONES/PAGERS
12/15 09/02/15 19 MOBILEDV −5.00 09/03/2015 MOBILE DEVICE
12/15 09/17/15 21 1509278 20900128 VERIZON WIRELESS −150.34 .00 7/24−8/23/15 TDD
12/15 09/21/15 19 MOBILEDV −5.00 09/17/2015 MOBILE DEVICE
12/15 09/24/15 21 1509471 20900128 VERIZON WIRELESS 126.17 .00 6/24−7/23/15 TDD
TOTAL CELLULAR PHONES/PAGERS .00 −34.17 .00
RUN DATE 10/14/2015 TIME 07:44:56 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 10/14/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 07:44:56 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’12’ and transact.fund=’104’
ACCOUNTING PERIOD: 1/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
545990 INSURANCE−OTHER
12/15 09/01/15 19 BUDGET−5 117.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 117.00 .00
548001 PROMOTIONAL ACTIVITIES
12/15 09/16/15 17 21501423−01 21500279 ATLANTA EATS LLC 2,500.00 AIRING OF EMERALD COAST D
12/15 09/28/15 21 V2150309 014799 BANK OF AMERICA 294.00 .00 TOTALLY PROMOTIONAL
TOTAL PROMOTIONAL ACTIVITIES .00 294.00 2,500.00
548010 AGENCY BASE SVCS−MONTHLY
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 1,789.46 .00 TRAVEL
TOTAL AGENCY BASE SVCS−MONTHLY .00 1,789.46 .00
548042 FALL CAMPAIGN
12/15 09/02/15 21 1508767 21300295 PETER A MAYER AD 9,700.43 .00 TO149 LEISURE DIGTAL
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 1,060.06 .00 TO149 LEISURE DIGITAL
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 9,244.38 .00 TO149 LEISURE DIGITAL
TOTAL FALL CAMPAIGN .00 20,004.87 .00
548046 SUMMER CAMPAIGN
12/15 09/02/15 21 1508767 21300295 PETER A MAYER AD 229.55 .00 TO149 LEISURE DIGTAL
12/15 09/02/15 21 1508767 21300295 PETER A MAYER AD 25,000.00 .00 TO147 LEISURE PRINT
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 2,999.80 .00 TO149 LEISURE DIGITAL
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 7,270.82 .00 TO 148 LEISURE BRDCST
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 11,842.00 .00 TO147 LEISURE PRINT
12/15 09/24/15 21 1509433 21300295 PETER A MAYER AD 33,326.40 .00 TO147 EXTERNAL MEDIA
TOTAL SUMMER CAMPAIGN .00 80,668.57 .00
548047 NON−SEASONAL
12/15 09/17/15 21 1509240 21300295 PETER A MAYER AD 10,785.00 .00 TO159 FL GOLF GUIDE
TOTAL NON−SEASONAL .00 10,785.00 .00
548060 SPECIAL EVENTS
12/15 09/23/15 17 21501447−01 21001488 SOUTHERN EVENTS 12,362.00 LOCAL EVENT MARKETING FUN
12/15 09/30/15 21 21500001−01 1509521 21201579 DESTIN CHARTER B 7,749.34 −19,973.00 SPECIAL EVENT FUNDING PER
TOTAL SPECIAL EVENTS .00 7,749.34 −7,611.00
TOTAL 5TH TDT−TOURISM PROMOTION .00 126,838.83 −5,111.00
RUN DATE 10/14/2015 TIME 07:44:56 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 10/14/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 07:44:56 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’12’ and transact.fund=’104’
ACCOUNTING PERIOD: 1/16
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
512010 SALARIES/WAGES−FULL−TIME
12/15 09/02/15 22 14,378.87 PAYROLL CHARGES
12/15 09/21/15 22 14,427.13 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 28,806.00 .00
512020 SALARIES/WAGES−PART−TIME
12/15 09/02/15 22 1,929.72 PAYROLL CHARGES
12/15 09/21/15 22 1,714.47 PAYROLL CHARGES
TOTAL SALARIES/WAGES−PART−TIME .00 3,644.19 .00
514010 OVERTIME
12/15 09/21/15 22 7.47 PAYROLL CHARGES
12/15 09/21/15 11 .00
TOTAL OVERTIME .00 7.47 .00
521000 FICA TAXES