READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — September 18, 2014 — III.c. 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.
Machine-extracted text — 13-III.c. Expenditure Transactions.pdf
Machine-extracted OCR text · Review label: Machine produced / unreviewed
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.
Expenditure Transaction Analysis
August 2014
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”. 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 2014.
TDC Recommendation to BCC
For informational purposes only; no action needed.
September 12, 2014 Tourist Development Department, Okaloosa County, FL
**August Transactions**
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 09/12/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 12:27:30 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’14’ and transact.period=’11’ and transact.fund=’104’
ACCOUNTING PERIOD: 12/14
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
534003 CS−CONSULTING
11/14 08/07/14 21 V1407735 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION
TOTAL CS−CONSULTING .00 3,166.67 .00
534500 CS−PERSONNEL
11/14 08/07/14 21 1407726 21101150 LANDRUM STAFFING 664.80 .00 HALSEY 7/26/14
11/14 08/14/14 21 1408215 21101150 LANDRUM STAFFING 531.84 .00 HALSEY 7/19/14
11/14 08/21/14 21 1408373 21101150 LANDRUM STAFFING −74.79 .00 HALSEY 7/12/14
11/14 08/21/14 21 1408373 21101150 LANDRUM STAFFING 64.80 .00 HALSEY 7/12/14
11/14 08/21/14 21 1408373 21101150 LANDRUM STAFFING 74.79 .00 HALSEY 7/12/14
11/14 08/21/14 21 1408373 21101150 LANDRUM STAFFING 265.92 .00 HALSEY 8/2/14
11/14 08/27/14 21 1408523 21101150 LANDRUM STAFFING 132.96 .00 HALSEY 8/9/14
11/14 08/27/14 21 V1408519 009350 KELLY SERVICES,I 415.58 .00 MEGILL 8/3/14
11/14 08/28/14 21 V1408519 009350 KELLY SERVICES,I 283.35 .00 MEGILL 8/10
TOTAL CS−PERSONNEL .00 2,359.25 .00
545990 INSURANCE−OTHER
11/14 08/01/14 19 BUDGET−5 62.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 62.00 .00
548001 PROMOTIONAL ACTIVITIES
11/14 08/21/14 21 1408350 21400298 FIRST COAST PROM 9,047.00 .00 LET’S GO EMERALD COAS
TOTAL PROMOTIONAL ACTIVITIES .00 9,047.00 .00
548003 TRADE SHOW FEES
11/14 08/28/14 21 V1408530 21200456 GAIL MORGAN 2,000.00 .00 PRODUCER GUILD REGIST
TOTAL TRADE SHOW FEES .00 2,000.00 .00
548010 AGENCY BASE SVCS−MONTHLY
11/14 08/14/14 21 1408241 21300295 PETER A MAYER AD 993.38 .00 TRAVEL
TOTAL AGENCY BASE SVCS−MONTHLY .00 993.38 .00
548011 AGENCY SVCS−OTHER
11/14 08/28/14 13 1,495.00 BT−CA−14−36
11/14 08/28/14 13 1,150.00 BT−CA−14−36
TOTAL AGENCY SVCS−OTHER 2,645.00 .00 .00
548020 WEBSITE DEV & MAINTENANCE
11/14 08/14/14 21 1408241 21300295 PETER A MAYER AD 468.00 .00 TO128 TV DISTRIBUTION
11/14 08/22/14 21 V2140264 014799 BANK OF AMERICA 19.00 .00 SERVERSTADIUM.COM
11/14 08/22/14 21 V2140264 014799 BANK OF AMERICA 1,017.00 .00 REVIVE MEDIA SERVICES
TOTAL WEBSITE DEV & MAINTENANCE .00 1,504.00 .00
548040 PUBLIC RELATIONS
11/14 08/07/14 21 248600 21300295 PETER A MAYER AD 3.04 .00 TO128TV DISTRIBUTION
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 7.04 .00 TO128TV DISTRIBUTION
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 2,070.00 .00 TO137PRESS KIT
RUN DATE 09/12/2014 TIME 12:27:30 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
**August Transactions**
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 09/12/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 12:27:30 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’14’ and transact.period=’11’ and transact.fund=’104’
ACCOUNTING PERIOD: 12/14
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548040 PUBLIC RELATIONS (cont’d)
11/14 08/07/14 21 248600 21300295 PETER A MAYER AD −3.04 .00 TO128TV DISTRIBUTION
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 3.04 .00 TO128TV DISTRIBUTION
11/14 08/14/14 21 1408241 21300295 PETER A MAYER AD 9.16 .00 TO128 TV DISTRIBUTION
TOTAL PUBLIC RELATIONS .00 2,089.24 .00
548042 FALL CAMPAIGN
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 4.73 .00 TO115 MEDIA
TOTAL FALL CAMPAIGN .00 4.73 .00
548046 SUMMER CAMPAIGN
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 8.41 .00 TO115 MEDIA
TOTAL SUMMER CAMPAIGN .00 8.41 .00
548047 NON−SEASONAL
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 25.31 .00 TO115 MEDIA
11/14 08/07/14 21 1407751 21300295 PETER A MAYER AD 50.39 .00 TO115 MEDIA
11/14 08/28/14 13 5,000.00 BT−CA−14−36
11/14 08/28/14 13 4,505.00 BT−CA−14−36
TOTAL NON−SEASONAL 9,505.00 75.70 .00
548090 PROMOTIONAL RESERVES
11/14 08/28/14 13 −12,150.00 BT−CA−14−36
TOTAL PROMOTIONAL RESERVES −12,150.00 .00 .00
TOTAL 5TH TDT−TOURISM PROMOTION .00 21,310.38 .00
RUN DATE 09/12/2014 TIME 12:27:30 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
**August Transactions**
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 09/12/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 12:27:30 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’14’ and transact.period=’11’ and transact.fund=’104’
ACCOUNTING PERIOD: 12/14
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
512010 SALARIES/WAGES−FULL−TIME
11/14 08/06/14 22 14,202.40 PAYROLL CHARGES
11/14 08/20/14 22 14,202.40 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 28,404.80 .00
512020 SALARIES/WAGES−PART−TIME
11/14 08/06/14 22 830.20 PAYROLL CHARGES
11/14 08/20/14 22 581.14 PAYROLL CHARGES
TOTAL SALARIES/WAGES−PART−TIME .00 1,411.34 .00
521000 FICA TAXES
11/14 08/06/14 22 1,123.51 PAYROLL CHARGES−FRINGE
11/14 08/20/14 22 1,104.46 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 2,227.97 .00
522000 RETIREMENT CONTRIBUTIONS
11/14 08/06/14 22 1,788.25 PAYROLL CHARGES−FRINGE
11/14 08/20/14 22 1,769.89 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 3,558.14 .00
523000 LIFE & HEALTH INSURANCE
11/14 08/06/14 22 1,450.00 PAYROLL CHARGES−FRINGE
11/14 08/06/14 22 60.60 PAYROLL CHARGES−FRINGE
11/14 08/06/14 22 11.55 PAYROLL CHARGES−FRINGE
11/14 08/06/14 22 11.50 PAYROLL CHARGES−FRINGE
11/14 08/06/14 22 50.00 PAYROLL CHARGES
11/14 08/20/14 22 1,450.00 PAYROLL CHARGES−FRINGE
11/14 08/20/14 22