READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — November 20, 2014 — III.d. Expenditure Transactions — reading text
Part 1 of 11. These parts divide the reading text for browsing; they are not the source document's page numbers.
Machine-extracted text — 21-III.d. 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
October 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 October 2014.
TDC Recommendation to BCC
For informational purposes only.
November 13, 2014 Tourist Development Department, Okaloosa County, FL
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 11/13/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 13:05:45 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’1’ and transact.fund=’104’
ACCOUNTING PERIOD: 2/15
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
1 /15 10/01/14 11 44,600.00 POSTED FROM BUDGET SYSTEM
TOTAL CS−CONSULTING 44,600.00 .00 .00
534018 CS−CHAMBER OF COMMERCE
1 /15 10/01/14 11 40,000.00 POSTED FROM BUDGET SYSTEM
TOTAL CS−CHAMBER OF COMMERCE 40,000.00 .00 .00
540002 TRAVEL OUT−OF−COUNTY
1 /15 10/01/14 11 15,000.00 POSTED FROM BUDGET SYSTEM
1 /15 10/30/14 21 V1500859 21200456 GAIL MORGAN 979.51 .00 BOCA RATON FL
TOTAL TRAVEL OUT−OF−COUNTY 15,000.00 979.51 .00
540005 TRAVEL LODGING EXPENSES
1 /15 10/01/14 11 15,000.00 POSTED FROM BUDGET SYSTEM
1 /15 10/30/14 21 V1500859 21200456 GAIL MORGAN 596.07 .00 BOCA RATON FL
TOTAL TRAVEL LODGING EXPENSES 15,000.00 596.07 .00
542001 POSTAGE/FREIGHT CHARGES
1 /15 10/01/14 11 500.00 POSTED FROM BUDGET SYSTEM
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 75.88 .00 TDD 1/22/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 94.64 .00 TDD 3/19/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 100.66 .00 TDD 1/8/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 105.42 .00 TDD 2/26/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 153.72 .00 TDD 3/10/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 167.72 .00 TDD 4/22/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 203.70 .00 TDD 4/2/14
1 /15 10/09/14 21 V1500285 009109 CASS DATA & MAIL 476.42 .00 TDD 3/25/14
1 /15 10/15/14 19 AJE1C5 −75.88 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −94.64 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −100.66 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −105.42 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −153.72 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −167.72 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −203.70 REVERS ACCRUED V1500285
1 /15 10/15/14 19 AJE1C5 −476.42 REVERS ACCRUED V1500285
TOTAL POSTAGE/FREIGHT CHARGES 500.00 .00 .00
545990 INSURANCE−OTHER
1 /15 10/01/14 11 1,415.00 POSTED FROM BUDGET SYSTEM
1 /15 10/01/14 19 BUDGET−5 118.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER 1,415.00 118.00 .00
546900 RM−TECHINCAL SUPT SERVICE
1 /15 10/01/14 11 900.00 POSTED FROM BUDGET SYSTEM
TOTAL RM−TECHINCAL SUPT SERVICE 900.00 .00 .00
RUN DATE 11/13/2014 TIME 13:05:45 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 11/13/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 13:05:45 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’1’ and transact.fund=’104’
ACCOUNTING PERIOD: 2/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548001 PROMOTIONAL ACTIVITIES
548001 PROMOTIONAL ACTIVITIES
1 /15 10/01/14 11 48,905.00 POSTED FROM BUDGET SYSTEM
1 /15 10/09/14 19 COR1AB 10,000.00 RECLASS 2014 PREPAIDS
1 /15 10/23/14 17 21500097−01 21500081 VULCAN PARK AND 300.00 MEETING SPACE RENTAL FOR
1 /15 10/30/14 21 21500097−01 21500081 VULCAN PARK AND .00 −300.00 MEETING SPACE RENTAL FOR
TOTAL PROMOTIONAL ACTIVITIES 48,905.00 10,000.00 .00
548003 TRADE SHOW FEES
1 /15 10/01/14 11 8,000.00 POSTED FROM BUDGET SYSTEM
1 /15 10/30/14 21 1500906 013788 FLORIDA TOURISM 495.00 .00 DEL REG −E SCHROEDER
1 /15 10/30/14 21 1500906 013788 FLORIDA TOURISM 2,700.00 .00 BOOTH −S DEDICKE
1 /15 10/30/14 21 1500915 21300427 SITE SEARCH INC 3,000.00 .00 BHAM 14 TRDSHOW
1 /15 10/30/14 21 V1500859 21200456 GAIL MORGAN 1,000.00 .00 BOCA RATON FL
TOTAL TRADE SHOW FEES 8,000.00 7,195.00 .00
548010 AGENCY BASE SVCS−MONTHLY
1 /15 10/01/14 11 348,750.00 POSTED FROM BUDGET SYSTEM
TOTAL AGENCY BASE SVCS−MONTHLY 348,750.00 .00 .00
548011 AGENCY SVCS−OTHER
1 /15 10/01/14 11 87,500.00 POSTED FROM BUDGET SYSTEM
TOTAL AGENCY SVCS−OTHER 87,500.00 .00 .00
548020 WEBSITE DEV & MAINTENANCE
1 /15 10/01/14 11 82,500.00 POSTED FROM BUDGET SYSTEM
1 /15 10/24/14 17 21500093−01 21500080 OPULENT WORX 3,240.00 FY15 STRATEGIC MARKETING
TOTAL WEBSITE DEV & MAINTENANCE 82,500.00 .00 3,240.00
548042 FALL CAMPAIGN
1 /15 10/01/14 11 477,685.00 POSTED FROM BUDGET SYSTEM
TOTAL FALL CAMPAIGN 477,685.00 .00 .00
548043 CHRISTMAS CAMPAIGN
1 /15 10/01/14 11 127,878.00 POSTED FROM BUDGET SYSTEM
TOTAL CHRISTMAS CAMPAIGN 127,878.00 .00 .00
548044 SNOWBIRD CAMPAIGN
1 /15 10/01/14 11 174,558.00 POSTED FROM BUDGET SYSTEM
TOTAL SNOWBIRD CAMPAIGN 174,558.00 .00 .00
548046 SUMMER CAMPAIGN
1 /15 10/01/14 11 840,029.00 POSTED FROM BUDGET SYSTEM
TOTAL SUMMER CAMPAIGN 840,029.00 .00 .00
548047 NON−SEASONAL
1 /15 10/01/14 11 84,390.00 POSTED FROM BUDGET SYSTEM
RUN DATE 11/13/2014 TIME 13:05:45 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 11/13/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 13:05:45 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’1’ and transact.fund=’104’
ACCOUNTING PERIOD: 2/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548047 NON−SEASONAL (cont’d)
TOTAL NON−SEASONAL 84,390.00 .00 .00
548051 CAMPAIGN PRODUCTION
1 /15 10/01/14 11 200,000.00 POSTED FROM BUDGET SYSTEM
TOTAL CAMPAIGN PRODUCTION 200,000.00 .00 .00
548060 SPECIAL EVENTS
1 /15 10/01/14 11 225,000.00 POSTED FROM BUDGET SYSTEM
1 /15 10/02/14 17 21500001−01 21201579 DESTIN CHARTER B 19,973.00 SPECIAL EVENT FUNDING PER
1 /15 10/30/14 17 21401250−04 21000426 FLORIDA STATE RA 1,000.00 CHANGE ORDER − 1
1 /15 10/30/14 17 21401250−05 21000426