READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — April 28, 2016 — III. n. Expenditure Transactions — reading text
Part 1 of 9. 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: April 28, 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 March 2016.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’
ACCOUNTING PERIOD: 7/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
6 /16 03/03/16 22 1,722.40 PAYROLL CHARGES
6 /16 03/17/16 22 2,242.40 PAYROLL CHARGES
6 /16 03/30/16 22 1,774.40 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 5,739.20 .00
521000 FICA TAXES
6 /16 03/03/16 22 129.48 PAYROLL CHARGES−FRINGE
6 /16 03/17/16 22 169.26 PAYROLL CHARGES−FRINGE
6 /16 03/30/16 22 135.74 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 434.48 .00
522000 RETIREMENT CONTRIBUTIONS
6 /16 03/03/16 22 125.05 PAYROLL CHARGES−FRINGE
6 /16 03/17/16 22 162.80 PAYROLL CHARGES−FRINGE
6 /16 03/30/16 22 128.82 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 416.67 .00
523000 LIFE & HEALTH INSURANCE
6 /16 03/03/16 22 380.25 PAYROLL CHARGES−FRINGE
6 /16 03/03/16 22 10.94 PAYROLL CHARGES−FRINGE
6 /16 03/03/16 22 1.63 PAYROLL CHARGES−FRINGE
6 /16 03/03/16 22 1.75 PAYROLL CHARGES−FRINGE
6 /16 03/17/16 22 380.25 PAYROLL CHARGES−FRINGE
6 /16 03/17/16 22 10.94 PAYROLL CHARGES−FRINGE
6 /16 03/17/16 22 1.63 PAYROLL CHARGES−FRINGE
6 /16 03/17/16 22 1.75 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 789.14 .00
524000 WORKERS’ COMPENSATION
6 /16 03/01/16 19 BUDGET−3 10.00 MARCH 2016
TOTAL WORKERS’ COMPENSATION .00 10.00 .00
534003 CS−CONSULTING
6 /16 03/15/16 11 .00 ESTABLISH PER DE
6 /16 03/17/16 21 1605146 015636 THE MERCER GROUP 300.00 .00 CONSULTING
TOTAL CS−CONSULTING .00 300.00 .00
540002 TRAVEL OUT−OF−COUNTY
6 /16 03/10/16 21 V1603985 EMP00334 GAIL MORGAN 120.00 .00 TALLA 1/19−22/16
TOTAL TRAVEL OUT−OF−COUNTY .00 120.00 .00
541010 COMMUNICATIONS SERVICE
6 /16 03/29/16 21 V2160158 014799 BANK OF AMERICA −10.95 .00 HOSTGATOR.COM
TOTAL COMMUNICATIONS SERVICE .00 −10.95 .00
541011 CELLULAR PHONES/PAGERS
RUN DATE 04/19/2016 TIME 11:46:09 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’
ACCOUNTING PERIOD: 7/16
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
541011 CELLULAR PHONES/PAGERS
6 /16 03/17/16 21 1605159 20900128 VERIZON WIRELESS 49.53 .00 1/24−2/23/16 TDD
6 /16 04/15/16 19 MOBILEDV −10.00 MAR16 PR MOBILE DEVICE
TOTAL CELLULAR PHONES/PAGERS .00 39.53 .00
545990 INSURANCE−OTHER
6 /16 03/01/16 19 BUDGET−5 34.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 34.00 .00
548001 PROMOTIONAL ACTIVITIES
6 /16 03/07/16 17 21600553−01 20900370 REVIVE MEDIA SER 500.00 CHANGE ORDER − 1
6 /16 03/16/16 17 21600589−01 21600100 JAMES R VAIL 50.00 USE OF JIM VAIL’S BEACH P
6 /16 03/17/16 17 21600596−01 21100394 THE LOCATION GUI 5,693.00 FULL PAGE BENDAY/LOGO/COM
6 /16 03/29/16 21 V2160158 014799 BANK OF AMERICA 76.65 .00 COBALT THE RESTAURANT
6 /16 03/29/16 21 V2160158 014799 BANK OF AMERICA 310.55 .00 IMAGE PRINTING & DIGI
6 /16 03/29/16 21 V2160158 014799 BANK OF AMERICA 554.38 .00 IMAGE PRINTING & DIGI
6 /16 03/31/16 21 21600589−01 1605389 21600100 JAMES R VAIL 50.00 −50.00 USE OF JIM VAIL’S BEACH P
TOTAL PROMOTIONAL ACTIVITIES .00 991.58 6,193.00
548003 TRADE SHOW FEES
6 /16 03/24/16 21 1605210 014431 FILM FLORIDA INC 1,700.00 .00 G MORGAN REG FEE
TOTAL TRADE SHOW FEES .00 1,700.00 .00
548011 AGENCY SVCS−OTHER
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 1,322.50 .00 MEDIA PURCHASING
TOTAL AGENCY SVCS−OTHER .00 1,322.50 .00
548020 WEBSITE DEV & MAINTENANCE
6 /16 03/07/16 18 21600553−01 20900370 REVIVE MEDIA SER −500.00 CHANGE ORDER − 1
6 /16 03/07/16 17 21600553−01 20900370 REVIVE MEDIA SER 500.00 APPROACH: AD DEVELOPMENT.
TOTAL WEBSITE DEV & MAINTENANCE .00 .00 .00
548042 FALL CAMPAIGN
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 7,327.00 .00 LIESURE BOARDCAST
TOTAL FALL CAMPAIGN .00 7,327.00 .00
548043 CHRISTMAS CAMPAIGN
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 3,263.00 .00 LIESURE BROADCAST
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 6,868.00 .00 LIESURE BOARDCAST
TOTAL CHRISTMAS CAMPAIGN .00 10,131.00 .00
548044 SNOWBIRD CAMPAIGN
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 892.00 .00 LIESURE BROADCAST
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 8,131.86 .00 CO OP PACKAGES
TOTAL SNOWBIRD CAMPAIGN .00 9,023.86 .00
548046 SUMMER CAMPAIGN
RUN DATE 04/19/2016 TIME 11:46:09 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’
ACCOUNTING PERIOD: 7/16
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548046 SUMMER CAMPAIGN
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 6,111.00 .00 LIESURE BROADCAST
TOTAL SUMMER CAMPAIGN .00 6,111.00 .00
548047 NON−SEASONAL
6 /16 03/17/16 21 1605126 21300295 PETER A MAYER AD 70,162.87 .00 CHICAGO TAKEOVER
TOTAL NON−SEASONAL .00 70,162.87 .00
548051 CAMPAIGN PRODUCTION
6 /16 03/10/16 21 1604001 21300295 PETER A MAYER AD 683.10 .00 EMERAL COAST PHOTOSHO
6 /16 03/31/16 21 1605417 21300295 PETER A MAYER AD