READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — June 23, 2016 — Agenda Packet — reading text
Part 28 of 39. These parts divide the reading text for browsing; they are not the source document's page numbers.
Agenda Packet — 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.
improvements
October $ 1,068,987.38 $ 32,069.62 $ 207,383.55 $ 207,383.55 $ 207,383.55 $ 207,383.55 $ 207,383.55
November $ 356,655.15 $ 10,699.66 $ 69,191.10 $ 69,191.10 $ 69,191.10 $ 69,191.10 $ 69,191.10
December $ 390,077.62 $ 11,702.33 $ 75,675.06 $ 75,675.06 $ 75,675.06 $ 75,675.06 $ 75,675.06
January $ 436,046.61 $ 13,081.39 $ 84,593.04 $ 84,593.04 $ 84,593.04 $ 84,593.04 $ 84,593.04
February $ 554,344.14 $ 16,630.33 $ 107,542.76 $ 107,542.76 $ 107,542.76 $ 107,542.76 $ 107,542.76
March $ 1,276,174.37 $ 38,285.23 $ 247,577.83 $ 247,577.83 $ 247,577.83 $ 247,577.83 $ 247,577.83
April $ 1,313,570.62 $ 39,407.12 $ 254,832.70 $ 254,832.70 $ 254,832.70 $ 254,832.70 $ 254,832.70
May $ - $ - $ - $ - $ - $ - $ -
June $ - $ - $ - $ - $ - $ - $ -
July $ - $ - $ - $ - $ - $ - $ -
August $ - $ - $ - $ - $ - $ - $ -
September $ - $ - $ - $ - $ - $ - $ -
Total $ 5,395,855.89 $ 161,875.68 $ 1,046,796.04 $ 1,046,796.04 $ 1,046,796.04 $ 1,046,796.04 $ 1,046,796.04
*Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d)
Page 8
Packet Pg. 155
3.o
Tourist Development Council Meeting: 06/23/16 02:00 PM
1540 Miracle Strip Parkway Department: Tourist Development Council
Fort Walton Beach, FL 32548 Category: Report
Prepared By: Aida Wilkinson
SCHEDULED Initiator: Aida Wilkinson
Sponsors:
TDC ITEM (ID # 5781) DOC ID: 5781
Expenditure Transaction Report
Updated: 6/20/2016 3:36 PM by Aida Wilkinson Page 1
Packet Pg. 156
3.o.a
TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM
DATE: June 23, 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
Attachment: III. o. Expenditure Transactions (5781 : Expenditure Transaction Report)
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 to date for the month of May 2016.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
Packet Pg. 157
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 06/15/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 11:29:39 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’8’ and transact.fund=’104’
ACCOUNTING PERIOD: 9/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
8 /16 05/03/16 22 1,774.40 PAYROLL CHARGES
8 /16 05/12/16 22 1,774.40 PAYROLL CHARGES
8 /16 05/25/16 22 1,774.40 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 5,323.20 .00
521000 FICA TAXES
8 /16 05/03/16 22 133.46 PAYROLL CHARGES−FRINGE
8 /16 05/12/16 22 133.46 PAYROLL CHARGES−FRINGE
8 /16 05/25/16 22 133.46 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 400.38 .00
522000 RETIREMENT CONTRIBUTIONS
8 /16 05/03/16 22 128.82 PAYROLL CHARGES−FRINGE
8 /16 05/12/16 22 128.82 PAYROLL CHARGES−FRINGE
8 /16 05/25/16 22 128.82 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 386.46 .00
523000 LIFE & HEALTH INSURANCE
8 /16 05/03/16 22 380.25 PAYROLL CHARGES−FRINGE
8 /16 05/03/16 22 10.94 PAYROLL CHARGES−FRINGE
8 /16 05/03/16 22 1.63 PAYROLL CHARGES−FRINGE
8 /16 05/03/16 22 1.75 PAYROLL CHARGES−FRINGE
8 /16 05/12/16 22 380.25 PAYROLL CHARGES−FRINGE
8 /16 05/12/16 22 10.94 PAYROLL CHARGES−FRINGE
8 /16 05/12/16 22 1.63 PAYROLL CHARGES−FRINGE
8 /16 05/12/16 22 1.75 PAYROLL CHARGES−FRINGE
8 /16 05/25/16 22 380.25 PAYROLL CHARGES−FRINGE
8 /16 05/25/16 22 10.94 PAYROLL CHARGES−FRINGE
8 /16 05/25/16 22 1.75 PAYROLL CHARGES−FRINGE
8 /16 05/25/16 22 1.63 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 1,183.71 .00
524000 WORKERS’ COMPENSATION
8 /16 05/02/16 19 BUDGET−3 10.00 MAY 2016
TOTAL WORKERS’ COMPENSATION .00 10.00 .00
540002 TRAVEL OUT−OF−COUNTY
8 /16 05/12/16 21 V1606732 EMP00334 GAIL MORGAN 632.11 .00 NEWYORK NY 4/12−25/16
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 8.39 .00 NYC TAXI 1B71 1B97
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 32.00 .00 MTA MVM R134−28 ST
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 32.00 .00 MTA MVM N506−34 ST−HE
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 60.00 .00 DELTA AIR BAGGAGE F
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 60.00 .00 DELTA AIR BAGGAGE F
Packet Pg. 158
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 66.55 .00 SQ U.S CAR SERVICE G
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 80.62 .00 MY NY LIMO
8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 103.60 .00 RPS DESTIN FT WALTON
RUN DATE 06/15/2016 TIME 11:29:39 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.o.a
Attachment: III. o. Expenditure