SUNGARD PENTAMATION DATE: 07/20/2017 TIME: 12:33:35
PAGE NUMBER: AUDIT21
ESCAMBIA COUNTY BOCC EXPENDITURE AUDIT TRAIL
1
SELECTION CRITERIA: orgn.fund=’121’ ACCOUNTING PERIODS: 1/17 THRU 13/17 SORTED BY: FUND,TOTAL COST CNTR,1ST SUBTOTAL,ACCOUNT TOTALED ON: FUND,TOTAL COST CNTR,1ST SUBTOTAL PAGE BREAKS ON: FUND,TOTAL COST CNTR FUND − 121 − LAW ENFORCEMENT TRUST FD COST CENTER − 540103 − LAW ENFORCEMENT TRUST ACCOUNT DATE
T/C
ENCUMBRANC
REFERENCE
VENDOR
ENCUMBRANCES DESCRIPTION
CUMULATIVE BALANCE
BUDGET
EXPENDITURES
53101 PROFESSIONAL SERVICES 09/30/16 11−1 01/25/17 13−4 07/05/17 25−10 BA141 TOTAL PROFESSIONAL SERVICES
.00 .00 10,000.00 −5,000.00 5,000.00
.00
53501 INVESTIGATIONS 09/30/16 11−1 01/25/17 13−4 TOTAL INVESTIGATIONS
.00 .00 10,000.00 10,000.00
.00
54101 COMMUNICATIONS 09/30/16 11−1 TOTAL COMMUNICATIONS
.00 .00 .00
.00
54201 POSTAGE & FREIGHT 09/30/16 11−1 01/25/17 13−4 TOTAL POSTAGE & FREIGHT
.00 .00 2,000.00 2,000.00
.00
54601 REPAIR & MAINTENANCE 09/30/16 11−1 01/25/17 13−4 TOTAL REPAIR & MAINTENANCE
.00 .00 2,000.00 2,000.00
.00
54701 PRINTING & BINDING 09/30/16 11−1 TOTAL PRINTING & BINDING
.00 .00 .00
.00 .00
.00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM .00 .00
54801
.00
.00
.00 BEGINNING BALANCE
121−52000−52100−54−5401−540103−540103 − LAW ENFORCEMENT TRUST
PROMOTIONAL ACTIVITIES
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
.00
.00
.00
.00
.00
.00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD BA141−L.E.T TRNF AID TO .00 5,000.00 .00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD .00 10,000.00 .00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM .00 .00 .00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD .00 2,000.00 .00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD .00 2,000.00
SUNGARD PENTAMATION DATE: 07/20/2017 TIME: 12:33:35
PAGE NUMBER: AUDIT21
ESCAMBIA COUNTY BOCC EXPENDITURE AUDIT TRAIL
2
SELECTION CRITERIA: orgn.fund=’121’ ACCOUNTING PERIODS: 1/17 THRU 13/17 SORTED BY: FUND,TOTAL COST CNTR,1ST SUBTOTAL,ACCOUNT TOTALED ON: FUND,TOTAL COST CNTR,1ST SUBTOTAL PAGE BREAKS ON: FUND,TOTAL COST CNTR FUND − 121 − LAW ENFORCEMENT TRUST FD COST CENTER − 540103 − LAW ENFORCEMENT TRUST ACCOUNT DATE
T/C
ENCUMBRANC
REFERENCE
VENDOR
54801 PROMOTIONAL ACTIVITIES (cont’d) 09/30/16 11−1 01/25/17 13−4 07/05/17 25−10 BA141 TOTAL PROMOTIONAL ACTIVITIES
BUDGET
54901 OTHER CURRENT CHGS & OBL. 09/30/16 11−1 01/25/17 13−4 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 04/17/17 21−7 V21962 04/17/17 21−7 V21962 04/17/17 21−7 V21962 04/17/17 21−7 V21962 04/17/17 21−7 V21962 04/17/17 21−7 V21962 07/05/17 21−10 V22788 07/05/17 21−10 V22788 07/05/17 21−10 V22788 TOTAL OTHER CURRENT CHGS & OBL.
.00 35,000.00 −35,000.00 .00
401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748
HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE
.00 .00 5,000.00 DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID 5,000.00
EXPENDITURES
.00 .00 1,011.00 1,200.00 341.00 2,022.00 55.00 1,011.00 94.50 100.00 1,011.00 2,022.00 100.00 500.00 200.00 1,011.00 2,042.00 1,021.00 100.00 13,841.50
55201 OPERATING SUPPLIES 09/30/16 11−1 01/25/17 13−4 TOTAL OPERATING SUPPLIES
.00 .00 10,000.00 10,000.00
.00
TOTAL 1ST SUBTOTAL − OPERATING EXPENSES
34,000.00
13,841.50
.00 .00
.00
56401 MACHINERY & EQUIPMENT 09/30/16 11−1
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
.00
ENCUMBRANCES DESCRIPTION
CUMULATIVE BALANCE
POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD BA141−L.E.T TRNF AID TO .00 .00 .00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD .00 PAM CHILDERS−CLERK .00 PAM CHILDERS−CLERK .00 ESC SUN PRESS .00 PAM CHILDERS/FILING F .00 M&M INVESTIGATIONS .00 PAM CHILDERS/FILING F .00 ANCHOR COURT REPORTIN .00 FL SHERIFF’S INSURANC .00 PAM CHILDERS/FILE FEE .00 PAM CHILDERS/FILE FEE .00 FL SHERIFFS INSURANCE .00 BALLINGER PUB/PUB NOT .00 BALLINGER PUB/LEGAL A .00 PAM CHILDER/FILE FEE .00 PAM CHILDERS/FILING F .00 PAM CHILDERS/FILING F .00 BALLINGER PUB/NOTICE .00 −8,841.50 .00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD .00 10,000.00 .00
20,158.50
.00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM
SUNGARD PENTAMATION DATE: 07/20/2017 TIME: 12:33:35
PAGE NUMBER: AUDIT21
ESCAMBIA COUNTY BOCC EXPENDITURE AUDIT TRAIL
3
SELECTION CRITERIA: orgn.fund=’121’ ACCOUNTING PERIODS: 1/17 THRU 13/17 SORTED BY: FUND,TOTAL COST CNTR,1ST SUBTOTAL,ACCOUNT TOTALED ON: FUND,TOTAL COST CNTR,1ST SUBTOTAL PAGE BREAKS ON: FUND,TOTAL COST CNTR FUND − 121 − LAW ENFORCEMENT TRUST FD COST CENTER − 540103 − LAW ENFORCEMENT TRUST ACCOUNT DATE
T/C
ENCUMBRANC
REFERENCE
VENDOR
56401 MACHINERY & EQUIPMENT (cont’d) 01/25/17 13−4 07/05/17 25−10 BA141 TOTAL MACHINERY & EQUIPMENT
BUDGET
ENCUMBRANCES DESCRIPTION
CUMULATIVE BALANCE
42,056.00 −42,056.00 .00
.00
.00
.00
.00
.00
.00
.00
.00 .00 310,758.00 HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID
.00
.00 BEGINNING BALANCE POSTED FROM BUDGET SYSTEM BA036−FB CARRY FORWARD .00 ESC CTY EXPLORERS/DON .00 GRTR P’COLA GOLF/DONA .00 INDEPEND FOR BLIND/DO .00 FL ASSOC HOSTAGE/DONA .00 FREEDOM FNDTN/DONATE .00 PENS SUB ROTARY/DONAT .00 BELMONT YTH BAND/DONA .00 UNITED WAY/DONATE .00 WFHS BASEBALL/DONATE .00 TATE H.S. SOCCER/DONA .00 PSC COLLEGE FNDTN/DON .00 GULF CST CRIMSTOP/DON .00 GULF CST KIS HSE/DONA .00 TATE BOOSTER/DONATE .00 ESC CTY EXPLORERS/DON .00 EPPS CHRIST CNTR/DONA .00 SOUTHERN YTH/DONATE .00 PSC FOUNDATION/DONATE .00 P.H.S GIRLS SOCCER/DO .00 MOVEMENT FOR CHG/DONA .00 PYRAMID/DONATE .00 BEULAH ACAD SCIENCE/D .00 PENS. SPORT ASSOC/DON .00 PENS. COMM ARTS/DONAT .00 PENS LITTLE THEATRE/D .00 AMERICAN LEGION/DONAT .00 ARC GATEWAY/DONATE .00 BIG BRO/BIG SIS/DONAT .00 PACE CNTR 4 GIRLS/DON
TOTAL 1ST SUBTOTAL − CAPITAL OUTLAY 58201 AIDS TO PRIVATE ORGANIZ. 09/30/16 11−1 01/25/17 13−4 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 01/30/17 21−4 V21174 04/17/17 21−7 V21962
EXPENDITURES
401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748 401748
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
BA036−FB CARRY FORWARD BA141−L.E.T TRNF AID TO
1,300.00 5,000.00 2,500.00 10,000.00 1,500.00 2,500.00 5,000.00 5,000.00 500.00 500.00 10,000.00 7,500.00 10,000.00 100.00 2,900.00 2,500.00 2,500.00 5,000.00 500.00 1,500.00 750.00 1,000.00 7,500.00 500.00 2,500.00 500.00 20,000.00 10,000.00 20,000.00
SUNGARD PENTAMATION DATE: 07/20/2017 TIME: 12:33:35
PAGE NUMBER: AUDIT21
ESCAMBIA COUNTY BOCC EXPENDITURE AUDIT TRAIL
4
SELECTION CRITERIA: orgn.fund=’121’ ACCOUNTING PERIODS: 1/17 THRU 13/17 SORTED BY: FUND,TOTAL COST CNTR,1ST SUBTOTAL,ACCOUNT TOTALED ON: FUND,TOTAL COST CNTR,1ST SUBTOTAL PAGE BREAKS ON: FUND,TOTAL COST CNTR FUND − 121 − LAW ENFORCEMENT TRUST FD COST CENTER − 540103 − LAW ENFORCEMENT TRUST ACCOUNT DATE
T/C
ENCUMBRANC
REFERENCE
VENDOR
EXPENDITURES
DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID DAVID 82,056.00 HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID
5,000.00 10,000.00 25,000.00 1,000.00 1,000.00 20,000.00 10,000.00 5,000.00 5,000.00 1,500.00 500.00 400.00 5,000.00 5,000.00 1,000.00 5,000.00 10,000.00 1,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 2,500.00 1,000.00 5,000.00 5,000.00
.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
15,000.00 5,000.00 5,000.00 2,000.00 10,000.00 2,500.00 500.00 2,000.00 3,000.00 4,000.00 5,000.00
.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00
58201 AIDS TO PRIVATE ORGANIZ. (cont’d) 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 04/17/17 21−7 V21962 401748 07/05/17 25−10 BA141 07/05/17 21−10 V22788 401748 07/05/17 21−10 V22788 401748 07/05/17 21−10 V22788 401748 07/05/17 21−10 V22788 401748 07/05/17 21−10 V22788 401748 07/05/17 21−10 V22788 401748 07/05/17 21−10 V22788 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748
BUDGET
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE HONORABLE
ENCUMBRANCES DESCRIPTION
CUMULATIVE BALANCE
ESC CNTY CNSL PTAS/DO PENS MESS HALL/DONATE AFCEA BLUE ANGELS/DON YTH ASSOC NE PENS/DON KING RICHARD/DONATE PANHANDLE CHAR/DONATE GULF CST KID HSE/DONA ESC CNTY SCHOOLS/DONA HADJI TMPL/DONATE WHS BASEBALL/DONATE WHS BASEBALL/DONATE WHS SOFTBALL/DONATE VET MEM PRK FNDTN/DON GIRL SCOUTS/DONATE PHS LACROSSE/DONATE MY BRO MY SIS/DONATE FL INST HUMAN COG/DON TATE BOOSTER/DONATE PENS OPERA/DONATE AUTISM PENS/DONATE AMER HEART ASSOC/DONA NWF LEGAL SVC/DONATE PERF BLESS & JAZZ/DON EPILEPSY FNDTN/DONATE IND FOR BLIND/DONATE COMM DRUG & ALCOH/DON CHILD HOME SOC/DONAT BA141−L.E.T TRNF AID TO FAVOR HOUSE/DONATE NEW WOLD BELIVERS/DON MILITRY OFF ASSOC/DON TEEN CHALLENG/DONATE PATHWAY 4 CHG/DONATE ST VINCENT DEPAUL/DON PERDIDO YTH SPRT/DONA ALPHA CNTR/SPONSOR MENS BARN MTG/DONATE CIVITAN/SPONSOR JR ACHIEV/SPONSOR
SUNGARD PENTAMATION DATE: 07/20/2017 TIME: 12:33:35
PAGE NUMBER: AUDIT21
ESCAMBIA COUNTY BOCC EXPENDITURE AUDIT TRAIL
5
SELECTION CRITERIA: orgn.fund=’121’ ACCOUNTING PERIODS: 1/17 THRU 13/17 SORTED BY: FUND,TOTAL COST CNTR,1ST SUBTOTAL,ACCOUNT TOTALED ON: FUND,TOTAL COST CNTR,1ST SUBTOTAL PAGE BREAKS ON: FUND,TOTAL COST CNTR FUND − 121 − LAW ENFORCEMENT TRUST FD COST CENTER − 540103 − LAW ENFORCEMENT TRUST ACCOUNT DATE
T/C
ENCUMBRANC
REFERENCE
BUDGET
EXPENDITURES
58201 AIDS TO PRIVATE ORGANIZ. (cont’d) 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 07/18/17 21−10 V22919 401748 TOTAL AIDS TO PRIVATE ORGANIZ.
HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID HONORABLE DAVID 392,814.00
15,000.00 5,000.00 1,000.00 2,500.00 10,000.00 1,000.00 377,450.00
.00 .00 .00 .00 .00 .00 .00
NAVAL AVIAT MUS/SPONS STUDER INST/SPONSOR UNITY IN FAMILY/SPONS WSRE FNDTN/SPONSOR TATE HS FNDTN/SPONSOR FL SHERIFF YTH/DONATE 15,364.00
TOTAL 1ST SUBTOTAL − GRANTS AND AIDS
392,814.00
377,450.00
.00
15,364.00
TOTAL TOTAL COST CNTR − LAW ENFORCEMENT TRU
426,814.00
391,291.50
.00
35,522.50
TOTAL FUND − LAW ENFORCEMENT TRUST FD
426,814.00
391,291.50
.00
35,522.50
TOTAL REPORT
426,814.00
391,291.50
.00
35,522.50
* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION
ENCUMBRANCES DESCRIPTION
CUMULATIVE BALANCE
VENDOR