Okaloosa County BOCC — April 28, 2016 — Agenda Packet — reading text

5548 Expenditure Transaction Report Updated: 4/25/2016 2:16 PM by Aida Wilkinson Page 1 Packet Pg. 118  3.n.a 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 Attachment: III. n. Expenditure Transactions (5548 : 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 March 2016. OPTIONS: N/A RECOMMENDATION TO BCC: N/A, for informational purposes only. Packet Pg. 119  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 Packet Pg. 120 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 3.n.a Attachment: III. n. Expenditure Transactions (5548 : Expenditure Transaction Report)  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