Okaloosa County BOCC — June 23, 2016 — III. o. Expenditure Transactions — reading text

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 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. 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 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 SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 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 540002 TRAVEL OUT−OF−COUNTY (cont’d) TOTAL TRAVEL OUT−OF−COUNTY .00 1,075.27 .00 540005 TRAVEL LODGING EXPENSES 8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 1,614.00 .00 COURTYARD BY MARRIOTT 8 /16 05/26/16 21 V2160216 014799 BANK OF AMERICA 1,823.00 .00 COURTYARD BY MARRIOTT TOTAL TRAVEL LODGING EXPENSES .00 3,437.00 .00 541011 CELLULAR PHONES/PAGERS 8 /16 05/12/16 21 1606796 20900128 VERIZON WIRELESS 49.73 .00 3/24−4/23/16 TDD TOTAL CELLULAR PHONES/PAGERS .00 49.73 .00 545990 INSURANCE−OTHER 8 /16 05/02/16 19 BUDGET−5 34.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 34.00 .00 548003 TRADE SHOW FEES 8 /16 05/19/16 21 1606874 014431 FILM FLORIDA INC 2,000.00 .00 FL NATIVE PRODUCERS TOTAL TRADE SHOW FEES .00 2,000.00 .00 548020 WEBSITE DEV & MAINTENANCE 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 1,035.00 .00 WEBSITE IMPROVEMENTS 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 2,443.75 .00 WEBSITE DEVELOPMENT TOTAL WEBSITE DEV & MAINTENANCE .00 3,478.75 .00 548042 FALL CAMPAIGN 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 1,969.70 .00 SMP CO−OP PKGS FALL 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 3,030.30 .00 SMP CO−OP PKGS FALL 8 /16 05/12/16 21 1606749 21300295 PETER A MAYER AD 4,534.00 .00 LEISURE PRINT TOTAL FALL CAMPAIGN .00 9,534.00 .00 548043 CHRISTMAS CAMPAIGN 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 483.15 .00 CHRISTMAS 2016 8 /16 05/19/16 21 1606927 21300295 PETER A MAYER AD 12.56 .00 HOLIDAY LEISURE 8 /16 05/19/16 21 1606927 21300295 PETER A MAYER AD 63,847.53 .00 HOLIDAY LEISURE TOTAL CHRISTMAS CAMPAIGN .00 64,343.24 .00 548044 SNOWBIRD CAMPAIGN 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 221.05 .00 CHRISTMAS 2016 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 8,311.73 .00 SNOWBIRD 8 /16 05/05/16 21 1606372 21300295 PETER A MAYER AD 1,188.88 .00 SNOWBIRD 8 /16 05/19/16 21 1606927 21300295 PETER A MAYER AD 35.93 .00 HOLIDAY LEISURE 8 /16 05/19/16 21 1606927 21300295 PETER A MAYER AD 24,023.80 .00 HOLIDAY LEISURE 8 /16 06/01/16 21 1607198 21300295 PETER A MAYER AD 1,973.93 .00 TO172 INTERFUSE MEDIA 8 /16 06/01/16 21 1607198 21300295 PETER A MAYER AD 3,156.11 .00 TO171 NAT PUBLIC RADI 8 /16 06/01/16 21 1607198 21300295 PETER A MAYER AD 3,470.00 .00 TO176 PRINT LEISURE TOTAL SNOWBIRD CAMPAIGN .00 42,381.43 .00 RUN DATE 06/15/2016 TIME 11:29:39 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 3 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’