LET Audit Trail 2017.pdf

Viewer
Transcript

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