READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — January 13, 2016 — III. l. Expenditure Transactions — reading text
Part 1 of 10. These parts divide the reading text for browsing; they are not the source document's page numbers.
III. l. 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: January 13, 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 December 2015.
OPTIONS: N/A
RECOMMENDATION TO BCC: N/A, for informational purposes only.
SUNGARD PENTAMATION, INC. PAGE NUMBER: 1
DATE: 01/04/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 10:26:30 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’3’ and transact.fund=’104’
ACCOUNTING PERIOD: 4/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
3 /16 12/09/15 22 1,722.40 PAYROLL CHARGES
3 /16 12/22/15 22 1,722.40 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 3,444.80 .00
513010 SALARIES/WAGES−RELIEF
3 /16 12/09/15 22 326.03 PAYROLL CHARGES
3 /16 12/22/15 22 181.13 PAYROLL CHARGES
TOTAL SALARIES/WAGES−RELIEF .00 507.16 .00
521000 FICA TAXES
3 /16 12/09/15 22 154.42 PAYROLL CHARGES−FRINGE
3 /16 12/22/15 22 143.34 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 297.76 .00
522000 RETIREMENT CONTRIBUTIONS
3 /16 12/09/15 22 125.05 PAYROLL CHARGES−FRINGE
3 /16 12/22/15 22 125.05 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 250.10 .00
523000 LIFE & HEALTH INSURANCE
3 /16 12/09/15 22 380.25 PAYROLL CHARGES−FRINGE
3 /16 12/09/15 22 10.94 PAYROLL CHARGES−FRINGE
3 /16 12/09/15 22 1.75 PAYROLL CHARGES−FRINGE
3 /16 12/09/15 22 1.63 PAYROLL CHARGES−FRINGE
3 /16 12/22/15 22 380.25 PAYROLL CHARGES−FRINGE
3 /16 12/22/15 22 10.94 PAYROLL CHARGES−FRINGE
3 /16 12/22/15 22 1.63 PAYROLL CHARGES−FRINGE
3 /16 12/22/15 22 1.75 PAYROLL CHARGES−FRINGE
TOTAL LIFE & HEALTH INSURANCE .00 789.14 .00
523012 CONTRA L&H INS (REBATE)
3 /16 12/05/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
3 /16 12/17/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
3 /16 12/29/15 19 REBATE −20.00 INSURANCE REBATE ALLOCATI
TOTAL CONTRA L&H INS (REBATE) .00 −60.00 .00
524000 WORKERS’ COMPENSATION
3 /16 12/02/15 19 BUDGET−3 10.00 DECEMBER 2015
TOTAL WORKERS’ COMPENSATION .00 10.00 .00
540002 TRAVEL OUT−OF−COUNTY
3 /16 12/22/15 21 V1602107 EMP00334 GAIL MORGAN 146.00 .00 ORLANDO 12/9−12/15
TOTAL TRAVEL OUT−OF−COUNTY .00 146.00 .00
541011 CELLULAR PHONES/PAGERS
3 /16 12/05/15 19 MOBILEDV −5.00 11/24/2015 MOBILE DEVICE
RUN DATE 01/04/2016 TIME 10:26:30 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 2
DATE: 01/04/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 10:26:30 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’3’ and transact.fund=’104’
ACCOUNTING PERIOD: 4/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 (cont’d)
3 /16 12/17/15 19 MOBILEDV −5.00 12/10/2015 MOBILE DEVICE
3 /16 12/17/15 21 1602021 20900128 VERIZON WIRELESS 49.40 .00 10/24−11/23/15 TDD
3 /16 12/29/15 19 MOBILEDV −5.00 12/23/2015 MOBILE DEVICE
TOTAL CELLULAR PHONES/PAGERS .00 34.40 .00
545990 INSURANCE−OTHER
3 /16 12/02/15 19 BUDGET−5 34.00 GENERAL LIABILITY
TOTAL INSURANCE−OTHER .00 34.00 .00
547002 PRINTING & BINDING
3 /16 12/29/15 21 V2160075 014799 BANK OF AMERICA 40.83 .00 IMAGE PRINTING & DIGI
TOTAL PRINTING & BINDING .00 40.83 .00
548001 PROMOTIONAL ACTIVITIES
3 /16 12/10/15 21 21501423−01 1601760 21500279 ATLANTA EATS LLC 2,500.00 −2,500.00 AIRING OF EMERALD COAST D
3 /16 12/29/15 21 V2160075 014799 BANK OF AMERICA 68.88 .00 IMAGE PRINTING & DIGI
TOTAL PROMOTIONAL ACTIVITIES .00 2,568.88 −2,500.00
548010 AGENCY BASE SVCS−MONTHLY
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 455.27 .00 TRAVEL
3 /16 12/10/15 21 1601843 21300295 PETER A MAYER AD 27,348.75 .00 OCT2015
TOTAL AGENCY BASE SVCS−MONTHLY .00 27,804.02 .00
548011 AGENCY SVCS−OTHER
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 891.25 .00 MEDIA PURCHASING
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 6,123.75 .00 MEDIA PURCHASING
TOTAL AGENCY SVCS−OTHER .00 7,015.00 .00
548042 FALL CAMPAIGN
3 /16 12/10/15 21 1601843 21300295 PETER A MAYER AD 12,995.00 .00 CO OP PRINT
TOTAL FALL CAMPAIGN .00 12,995.00 .00
548047 NON−SEASONAL
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 5,893.75 .00 CHICAGO TAKEOVER
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 5,000.00 .00 FAMILY TRAVEL
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 5,534.30 .00 100TH ANNIVERSARY
3 /16 12/16/15 13 1,725.00 BT−16−07
TOTAL NON−SEASONAL 1,725.00 16,428.05 .00
548051 CAMPAIGN PRODUCTION
3 /16 12/03/15 21 1601681 21300295 PETER A MAYER AD 855.91 .00 PRINT COLLATERAL
3 /16 12/10/15 21 1601843 21300295 PETER A MAYER AD 7,100.00 .00 WINTER TV
3 /16 12/22/15 21 1602116 21300295 PETER A MAYER AD 1,667.50 .00 CREATIVE BRAND
TOTAL CAMPAIGN PRODUCTION .00 9,623.41 .00
548060 SPECIAL EVENTS
RUN DATE 01/04/2016 TIME 10:26:30 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 01/04/2016 OKALOOSA COUNTY BOCC AUDIT11
TIME: 10:26:30 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’16’ and transact.period=’3’ and transact.fund=’104’
ACCOUNTING PERIOD: 4/16
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
548060 SPECIAL EVENTS
3 /16 12/17/15 21 21600123−01 1601995 21600010 SINFONIA GULF CO 12,409.00 −12,409.00 LOCAL EVENT MARKETING FUN
TOTAL SPECIAL EVENTS .00 12,409.00 −12,409.00
548090 PROMOTIONAL RESERVES
3 /16 12/16/15 13 −3,725.00 BT−16−07
TOTAL PROMOTIONAL RESERVES −3,725.00 .00 .00
549906 BACKGROUND CHECKS
3 /16 12/03/15 21 1601651 006534 FLORIDA DEPT OF 38.75 .00 TDD
3 /16 12/03/15 11 .00