READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — September 24, 2015 — III. q. 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. q. 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: September 24, 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 August 2015.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 09/15/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 08:12:03 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’11’ and transact.fund=’104’
ACCOUNTING PERIOD: 12/15
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
11/15 08/05/15 22 1,703.20 PAYROLL CHARGES
11/15 08/19/15 22 1,703.20 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 3,406.40 .00
521000 FICA TAXES
11/15 08/05/15 22 128.06 PAYROLL CHARGES−FRINGE
11/15 08/19/15 22 128.06 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 256.12 .00
522000 RETIREMENT CONTRIBUTIONS
11/15 08/05/15 22 123.65 PAYROLL CHARGES−FRINGE
11/15 08/19/15 22 123.65 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 247.30 .00
523000 LIFE & HEALTH INSURANCE
11/15 08/05/15 22 369.17 PAYROLL CHARGES−FRINGE
11/15 08/05/15 22 10.42 PAYROLL CHARGES−FRINGE
11/15 08/05/15 22 1.75 PAYROLL CHARGES−FRINGE
11/15 08/05/15 22 1.63 PAYROLL CHARGES−FRINGE
11/15 08/19/15 22 369.17 PAYROLL CHARGES−FRINGE
11/15 08/19/15 22 10.42 PAYROLL CHARGES−FRINGE
11/15 08/19/15 22 1.75 PAYROLL CHARGES−FRINGE
11/15 08/19/15 22 1.63 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 765.94 .00
523012 CONTRA L&H INS (REBATE)
11/15 08/06/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
11/15 08/19/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00
540002 TRAVEL OUT−OF−COUNTY
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 599.15 .00 DELTA AIR 0062316680258
TOTAL TRAVEL OUT−OF−COUNTY .00 599.15 .00
541011 CELLULAR PHONES/PAGERS
11/15 08/06/15 19 MOBILEDV −5.00 08/06/2015 MOBILE DEVICE
11/15 08/19/15 19 MOBILEDV −5.00 08/20/2015 MOBILE DEVICE
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 17.99 .00 BEST BUY 00007997
TOTAL CELLULAR PHONES/PAGERS .00 7.99 .00
545990 INSURANCE−OTHER
11/15 08/10/15 19 BUDGET−5 118.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 118.00 .00
548001 PROMOTIONAL ACTIVITIES
11/15 08/13/15 21 21501166−01 6024012 21500229 AAA FLAG & BANNE .00 .00 10 X 10 ECONO TENT PRINT
RUN DATE 09/15/2015 TIME 08:12:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 09/15/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 08:12:03 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’11’ and transact.fund=’104’
ACCOUNTING PERIOD: 12/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548001 PROMOTIONAL ACTIVITIES (cont’d)
11/15 08/13/15 21 21501166−02 6024012 21500229 AAA FLAG & BANNE .00 .00 HARDWARE * HARDWARE * 10
11/15 08/13/15 21 21501166−03 6024012 21500229 AAA FLAG & BANNE .00 .00 8 X 10 BACKDROP MESH
11/15 08/13/15 21 21501166−04 6024012 21500229 AAA FLAG & BANNE .00 .00 3 X 8 SIDE PANELS MESH
11/15 08/13/15 21 21501166−05 6024012 21500229 AAA FLAG & BANNE .00 .00 HARDWARE * SIDE RAILS HAR
11/15 08/17/15 17 21501296−01 001478 THE TROPHY CENTE 2,360.00 QTY.: 5000
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 294.00 .00 TOTALLY (866) 795−4657
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 516.09 .00 4IMPRINT
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 645.80 .00 SOUTHFLORID
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 1,177.99 .00 4IMPRINT
11/15 08/25/15 21 V2150282 014799 BANK OF AMERICA 2,059.53 .00 SOUTHFLORID
TOTAL PROMOTIONAL ACTIVITIES .00 4,693.41 2,360.00
548003 TRADE SHOW FEES
11/15 08/06/15 21 1507924 21500246 **DO NOT USE/VEN 2,200.00 .00 FILM FESTIVAL FEE
11/15 08/13/15 21 GNORGAN2015 014431 FILM FLORIDA INC 1,000.00 .00 GOV CONF/TOURISM REGI
11/15 08/13/15 21 GNORGAN2015 014431 FILM FLORIDA INC −1,000.00 .00 GOV CONF/TOURISM REGI
11/15 08/13/15 21 1508042 014431 FILM FLORIDA INC 1,000.00 .00 GOV CONF/TOURISM REGI
TOTAL TRADE SHOW FEES .00 3,200.00 .00
548010 AGENCY BASE SVCS−MONTHLY
11/15 08/27/15 21 1508499 21300295 PETER A MAYER AD 27,348.75 .00 JUNE 2015 BASE SVCS
11/15 08/27/15 21 1508499 21300295 PETER A MAYER AD 27,348.75 .00 JULY 2015 BASE SVCS
TOTAL AGENCY BASE SVCS−MONTHLY .00 54,697.50 .00
548011 AGENCY SVCS−OTHER
11/15 08/13/15 21 1508090 21300295 PETER A MAYER AD 4,283.75 .00 TO166 MEDIA PLANNING
11/15 08/27/15 21 1508499 21300295 PETER A MAYER AD 1,006.25 .00 TO166 MEDIA PLANNING
TOTAL AGENCY SVCS−OTHER .00 5,290.00 .00
548020 WEBSITE DEV & MAINTENANCE
11/15 08/13/15 21 1508090 21300295 PETER A MAYER AD 49.05 .00 TO153 WEBSITE IMPROV
11/15 08/13/15 21 1508090 21300295 PETER A MAYER AD 10,091.25 .00 TO162 GRP/MTG WBSITE
11/15 08/20/15 21 1508348 20900370 REVIVE MEDIA SER 1,017.00 .00 5/2015−7/2015
11/15 08/27/15 21 1508499 21300295 PETER A MAYER AD 13,311.25 .00 TO162 GRPS&MTGS WBSTE
TOTAL WEBSITE DEV & MAINTENANCE .00 24,468.55 .00
548042 FALL CAMPAIGN
11/15 08/13/15 21 1508090 21300295 PETER A MAYER AD 7,762.50 .00 TO168 FALL BOUNCEBK
11/15 08/20/15 21 1508343 21300295 PETER A MAYER AD 3,967.67 .00 TO149 LEISURE ONLINE
11/15 08/27/15 21 1508499 21300295 PETER A MAYER AD 178.55 .00 TO149 LEISURE ONLINE
11/15 08/27/15 21 1508499 21300295 PETER A MAYER AD 632.50 .00 TO168 FALL BOUNCEBACK
TOTAL FALL CAMPAIGN .00 12,541.22 .00
548046 SUMMER CAMPAIGN
11/15 08/06/15 21 1507952 21300295 PETER A MAYER AD 839.01 .00 TO#164 DAYS OF EC
11/15 08/13/15 21 1508090 21300295 PETER A MAYER AD 202.53 .00 TO150 COOP MEDIA PASS
RUN DATE 09/15/2015 TIME 08:12:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 09/15/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 08:12:03 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’11’ and transact.fund=’104’
ACCOUNTING PERIOD: 12/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR