READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — July 30, 2015 — III. n. 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. 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: July 30, 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 June 2015.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 07/21/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 07:53:39 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’9’ and transact.fund=’104’
ACCOUNTING PERIOD: 10/15
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
512010 SALARIES/WAGES−FULL−TIME
9 /15 06/10/15 22 1,703.20 PAYROLL CHARGES
9 /15 06/12/15 13 19,109.00 BT−CA−15−27
9 /15 06/24/15 22 1,703.20 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME 19,109.00 3,406.40 .00
521000 FICA TAXES
9 /15 06/10/15 22 130.30 PAYROLL CHARGES−FRINGE
9 /15 06/12/15 13 1,485.00 BT−CA−15−27
9 /15 06/24/15 22 130.30 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES 1,485.00 260.60 .00
522000 RETIREMENT CONTRIBUTIONS
9 /15 06/10/15 22 125.53 PAYROLL CHARGES−FRINGE
9 /15 06/12/15 13 1,430.00 BT−CA−15−27
9 /15 06/24/15 22 125.53 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS 1,430.00 251.06 .00
534003 CS−CONSULTING
9 /15 06/10/15 21 V1506545 21200456 GAIL MORGAN 408.60 .00 FINAL PAYMENT
9 /15 06/12/15 13 −22,024.00 BT−CA−15−27
TOTAL CS−CONSULTING −22,024.00 408.60 .00
540002 TRAVEL OUT−OF−COUNTY
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 35.88 .00 EXXONMOBIL 97617500
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 56.00 .00 RPS DESTIN FT WALTON BEAC
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 60.00 .00 DELTA AIR 0068269460726
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 60.00 .00 DELTA AIR 0068268746615
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 309.88 .00 HERTZ RENT−A−CAR
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 784.20 .00 DELTA AIR 0062309332289
TOTAL TRAVEL OUT−OF−COUNTY .00 1,305.96 .00
540005 TRAVEL LODGING EXPENSES
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 1,446.40 .00 RENAISSANCE HOTELS 9671T
TOTAL TRAVEL LODGING EXPENSES .00 1,446.40 .00
541011 CELLULAR PHONES/PAGERS
9 /15 06/10/15 19 MOBILEDV −5.00 06/10/2015 MOBILE DEVICE
9 /15 06/24/15 19 MOBILEDV −5.00 06/25/2015 MOBILE DEVICE
TOTAL CELLULAR PHONES/PAGERS .00 −10.00 .00
545990 INSURANCE−OTHER
9 /15 06/01/15 19 BUDGET−5 118.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 118.00 .00
548001 PROMOTIONAL ACTIVITIES
9 /15 06/18/15 21 1506639 20302163 ARAMARK SPORTS & 476.00 .00 MAY 8 2015 FOOD/BEVER
RUN DATE 07/21/2015 TIME 07:53:39 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 07/21/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 07:53:39 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’9’ and transact.fund=’104’
ACCOUNTING PERIOD: 10/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 (cont’d)
9 /15 06/23/15 21 V2150231 014799 BANK OF AMERICA 165.00 .00 THE TROPHY CENTER INC.
TOTAL PROMOTIONAL ACTIVITIES .00 641.00 .00
548010 AGENCY BASE SVCS−MONTHLY
9 /15 06/18/15 21 1506731 21300295 PETER A MAYER AD 27,348.75 .00 APRIL 2015
9 /15 06/25/15 21 1506878 21300295 PETER A MAYER AD 27,348.75 .00 MARCH 2015
TOTAL AGENCY BASE SVCS−MONTHLY .00 54,697.50 .00
548011 AGENCY SVCS−OTHER
9 /15 06/25/15 21 1506878 21300295 PETER A MAYER AD 2,357.50 .00 TO142 MEDIA PURCHASIN
9 /15 06/25/15 21 1506878 21300295 PETER A MAYER AD 3,220.00 .00 TO142 MEDIA PURCHASIN
TOTAL AGENCY SVCS−OTHER .00 5,577.50 .00
548044 SNOWBIRD CAMPAIGN
9 /15 06/11/15 21 1506561 21300295 PETER A MAYER AD 4,246.00 .00 TO150 CO−OP PRINT
TOTAL SNOWBIRD CAMPAIGN .00 4,246.00 .00
548046 SUMMER CAMPAIGN
9 /15 06/11/15 21 1506561 21300295 PETER A MAYER AD 776.25 .00 TO164 100 DAYS OF EC
9 /15 06/18/15 21 1506731 21300295 PETER A MAYER AD 64,451.25 .00 TO151 NAT CABLE DATA
TOTAL SUMMER CAMPAIGN .00 65,227.50 .00
548060 SPECIAL EVENTS
9 /15 06/11/15 21 21500629−01 1506487 21301431 EMERALD COAST SP 10,420.00 −10,420.00 SPECIAL EVENT AND SPONSOR
TOTAL SPECIAL EVENTS .00 10,420.00 −10,420.00
549906 BACKGROUND CHECKS
9 /15 06/25/15 21 1506824 006534 FLORIDA DEPT OF 38.75 .00 TDD
TOTAL BACKGROUND CHECKS .00 38.75 .00
TOTAL 5TH TDT−TOURISM PROMOTION .00 148,035.27 −10,420.00
RUN DATE 07/21/2015 TIME 07:53:39 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 07/21/2015 OKALOOSA COUNTY BOCC AUDIT11
TIME: 07:53:39 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’15’ and transact.period=’9’ and transact.fund=’104’
ACCOUNTING PERIOD: 10/15
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
9 /15 06/10/15 22 14,377.55 PAYROLL CHARGES
9 /15 06/24/15 22 14,379.30 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 28,756.85 .00
512020 SALARIES/WAGES−PART−TIME
9 /15 06/10/15 22 1,650.21 PAYROLL CHARGES
9 /15 06/24/15 22 1,303.70 PAYROLL CHARGES
TOTAL SALARIES/WAGES−PART−TIME .00 2,953.91 .00
521000 FICA TAXES
9 /15 06/10/15 22 1,211.81 PAYROLL CHARGES−FRINGE
9 /15 06/24/15 22 1,185.44 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 2,397.25 .00
522000 RETIREMENT CONTRIBUTIONS
9 /15 06/10/15 22 1,865.17 PAYROLL CHARGES−FRINGE
9 /15 06/24/15 22 1,839.77 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 3,704.94 .00
523000 LIFE & HEALTH INSURANCE
9 /15 06/10/15 22 1,845.85 PAYROLL CHARGES−FRINGE
9 /15 06/10/15 22 72.94 PAYROLL CHARGES−FRINGE
9 /15 06/10/15 22 12.25 PAYROLL CHARGES−FRINGE
9 /15 06/10/15 22 11.41 PAYROLL CHARGES−FRINGE
9 /15 06/10/15 22 100.00 PAYROLL CHARGES
9 /15 06/24/15 22