Okaloosa County BOCC — January 13, 2016 — Agenda Packet — reading text

- $ - $ - $ - August $ - $ - $ - $ - $ - $ - $ - September $ - $ - $ - $ - $ - $ - $ - Total $ 1,425,642.53 $ 42,769.28 $ 276,574.65 $ 276,574.65 $ 276,574.65 $ 276,574.65 $ 276,574.65 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8 Packet Pg. 148  3.l Tourist Development Council Meeting: 01/13/16 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Information Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 5171) DOC ID: 5171 Expenditure Transaction Report Updated: 1/11/2016 5:10 PM by Aida Wilkinson Page 1 Packet Pg. 149  3.l.a 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 Attachment: III. l. Expenditure Transactions (5171 : 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 for the month of December 2015. OPTIONS: N/A RECOMMENDATION TO BCC: N/A, for informational purposes only. Packet Pg. 150  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 Packet Pg. 151 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 3.l.a Attachment: III. l. Expenditure Transactions (5171 : Expenditure Transaction Report)  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