READ ALONGSIDE THE SOURCE
Okaloosa County BOCC — June 26, 2014 — III.b. Financial Update — reading text
Part 2 of 10. These parts divide the reading text for browsing; they are not the source document's page numbers.
Machine-extracted text — 17-III.b. Financial Update.pdf
Machine-extracted OCR text · Review label: Machine produced / unreviewed
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.
PAGE NUMBER: 2
DATE: 06/19/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 17:07:25 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’14’ and transact.period=’8’ and transact.fund=’104’
ACCOUNTING PERIOD: 9/14
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
545990 INSURANCE−OTHER (cont’d)
548001 PROMOTIONAL ACTIVITIES
8 /14 05/15/14 21 1405686 21300295 PETER A MAYER AD 13,943.75 .00 TO97 MEDIA
8 /14 05/20/14 21 V2140187 014799 BANK OF AMERICA 2,473.80 .00 FIRST COAST PROMOTION
8 /14 05/21/14 18 21401020−01 21400180 PARKSBYNATURE NE −10,000.00 CHANGE ORDER − 1
8 /14 05/22/14 21 21401020−01 1405822 21400180 PARKSBYNATURE NE 5,000.00 −5,000.00 12 MONTH AGREEMENT FOR PA
8 /14 05/28/14 13 15,000.00 BT−CA−14−25
TOTAL PROMOTIONAL ACTIVITIES 15,000.00 21,417.55 −15,000.00
548020 WEBSITE DEV & MAINTENANCE
8 /14 05/02/14 21 V2140165 014799 BANK OF AMERICA 19.00 .00 DIGITAL FORTRESS, INC.
8 /14 05/02/14 21 V2140165 014799 BANK OF AMERICA 57.00 .00 DIGITAL FORTRESS, INC.
8 /14 05/20/14 21 V2140187 014799 BANK OF AMERICA 19.00 .00 DIGITAL FORTRESS, INC.
8 /14 05/20/14 21 V2140187 014799 BANK OF AMERICA 1,017.00 .00 REVIVE MEDIA SERVICES
TOTAL WEBSITE DEV & MAINTENANCE .00 1,112.00 .00
548046 SUMMER CAMPAIGN
8 /14 05/28/14 13 12,363.00 BT−CA−14−25
TOTAL SUMMER CAMPAIGN 12,363.00 .00 .00
548047 NON−SEASONAL
8 /14 05/08/14 21 1405518 21300295 PETER A MAYER AD 15,000.00 .00 TO82 MILES MEDIA
TOTAL NON−SEASONAL .00 15,000.00 .00
548090 PROMOTIONAL RESERVES
8 /14 05/28/14 13 −27,363.00 BT−CA−14−25
TOTAL PROMOTIONAL RESERVES −27,363.00 .00 .00
549906 BACKGROUND CHECKS
8 /14 05/22/14 21 V1405801 009350 KELLY SERVICES,I −7.45 .00 WARDLOW 3/23/14
8 /14 05/22/14 21 V1405801 009350 KELLY SERVICES,I 39.56 .00 WARDLOW 3/23/14
TOTAL BACKGROUND CHECKS .00 32.11 .00
551001 OFFICE SUPPLIES
8 /14 05/02/14 21 V2140165 014799 BANK OF AMERICA 318.72 .00 STAPLES DIRECT
TOTAL OFFICE SUPPLIES .00 318.72 .00
TOTAL 5TH TDT−TOURISM PROMOTION .00 72,578.60 −15,000.00
RUN DATE 06/19/2014 TIME 17:07:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 3
DATE: 06/19/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 17:07:25 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’14’ and transact.period=’8’ and transact.fund=’104’
ACCOUNTING PERIOD: 9/14
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
8 /14 05/01/14 22 11,346.63 PAYROLL CHARGES
8 /14 05/15/14 22 11,194.46 PAYROLL CHARGES
8 /14 05/28/14 22 10,748.20 PAYROLL CHARGES
TOTAL SALARIES/WAGES−FULL−TIME .00 33,289.29 .00
512020 SALARIES/WAGES−PART−TIME
8 /14 05/01/14 22 963.43 PAYROLL CHARGES
8 /14 05/15/14 22 1,007.21 PAYROLL CHARGES
8 /14 05/28/14 22 1,067.33 PAYROLL CHARGES
TOTAL SALARIES/WAGES−PART−TIME .00 3,037.97 .00
521000 FICA TAXES
8 /14 05/01/14 22 918.11 PAYROLL CHARGES−FRINGE
8 /14 05/15/14 22 905.99 PAYROLL CHARGES−FRINGE
8 /14 05/28/14 22 876.76 PAYROLL CHARGES−FRINGE
TOTAL FICA TAXES .00 2,700.86 .00
522000 RETIREMENT CONTRIBUTIONS
8 /14 05/01/14 22 1,454.89 PAYROLL CHARGES−FRINGE
8 /14 05/15/14 22 1,435.84 PAYROLL CHARGES−FRINGE
8 /14 05/28/14 22 1,363.12 PAYROLL CHARGES−FRINGE
TOTAL RETIREMENT CONTRIBUTIONS .00 4,253.85 .00
523000 LIFE & HEALTH INSURANCE
8 /14 05/01/14 22 1,450.00 PAYROLL CHARGES−FRINGE
8 /14 05/01/14 22 60.60 PAYROLL CHARGES−FRINGE
8 /14 05/01/14 22 11.50 PAYROLL CHARGES−FRINGE
8 /14 05/01/14 22 11.55 PAYROLL CHARGES−FRINGE
8 /14 05/01/14 22 100.00 PAYROLL CHARGES
8 /14 05/15/14 22 1,450.00 PAYROLL CHARGES−FRINGE
8 /14 05/15/14 22 60.60 PAYROLL CHARGES−FRINGE
8 /14 05/15/14 22 11.55 PAYROLL CHARGES−FRINGE
8 /14 05/15/14 22 11.50 PAYROLL CHARGES−FRINGE
8 /14 05/15/14 22 50.00 PAYROLL CHARGES
TOTAL LIFE & HEALTH INSURANCE .00 3,217.30 .00
523012 CONTRA L&H INS (REBATE)
8 /14 05/01/14 19 REBATE −80.00 INSURANCE REBATE ALLOCATI
8 /14 05/19/14 19 REBATE −80.00 INSURANCE REBATE ALLOCATI
TOTAL CONTRA L&H INS (REBATE) .00 −160.00 .00
524000 WORKERS’ COMPENSATION
8 /14 05/01/14 19 BUDGET−3 151.00 MAY 2014
8 /14 05/01/14 19 BUDGET−3 151.00 MAY 2014
8 /14 05/02/14 19 COR8AD −151.00 REVERSE DUPL MAY POSTING
TOTAL WORKERS’ COMPENSATION .00 151.00 .00
RUN DATE 06/19/2014 TIME 17:07:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING
SUNGARD PENTAMATION, INC. PAGE NUMBER: 4
DATE: 06/19/2014 OKALOOSA COUNTY BOCC AUDIT11
TIME: 17:07:25 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr=’14’ and transact.period=’8’ and transact.fund=’104’
ACCOUNTING PERIOD: 9/14
FUND − 104 − TOURIST DEVELOPMENT FUND
DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION
ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION
524000 WORKERS’ COMPENSATION (cont’d)
534001 CS−GENERAL FUND ADMIN
8 /14 05/01/14 19 BUDGET−1 33,248.00 GEN FUND ADMINISTRATION
TOTAL CS−GENERAL FUND ADMIN .00 33,248.00 .00
540005 TRAVEL LODGING EXPENSES
8 /14 05/20/14 21 V2140187 014799 BANK OF AMERICA 161.40 .00 SHORES AT DAYTONA
TOTAL TRAVEL LODGING EXPENSES .00 161.40 .00
541010 COMMUNICATIONS SERVICE
8 /14 05/01/14 21 1405041 001337 AT&T CORP 101.32 .00 TDD
8 /14 05/08/14 21 1405456 002790 COX COMMUNICATIO 8.50 .00 TDD
TOTAL COMMUNICATIONS SERVICE .00 109.82 .00
541011 CELLULAR PHONES/PAGERS
8 /14 05/01/14 19 MOBILEDV −10.00 5/1/14 MOBILE DEVICE
8 /14 05/15/14 21 1405732 20900128 VERIZON WIRELESS 238.40 .00 3/24−4/23/14 TDD
8 /14 05/19/14 19 MOBILEDV −10.00 5/15/14 MOBILE DEVICE
TOTAL CELLULAR PHONES/PAGERS .00 218.40 .00
542001 POSTAGE/FREIGHT CHARGES
8 /14 05/01/14 21 1405083 000362 FEDERAL EXPRESS 328.26 .00 148498911 TDD
TOTAL POSTAGE/FREIGHT CHARGES .00 328.26 .00
544620 R/L−BUILDINGS
8 /14 05/02/14 21 V2140165 014799 BANK OF AMERICA 690.00 .00 A STORAGE SOLUTIONS OF DE
8 /14 05/20/14 21 V2140187 014799 BANK OF AMERICA 690.00 .00 A STORAGE SOLUTIONS OF DE
TOTAL R/L−BUILDINGS .00 1,380.00 .00
544640 R/L−EQUIPMENT
8 /14 05/01/14 21 1405120 014376 MUZAK LLC 138.69 .00 JAN−MAR2014
8 /14 05/08/14 21 1405507 014376 MUZAK LLC 138.69 .00 TDD APR−JUN14
TOTAL R/L−EQUIPMENT .00 277.38 .00