SUNGARD PENTAMATION PAGE NUMBER: 1 DATE:

Transcription

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAILPAGE NUMBER:AUDIT211SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0002 - BOARD OF COUNTY COMMISSIOACCOUNTDATET/CPURCHASE OREFERENCEVENDORENCUMBRANCES 0SALARIES, FIXED BY LAW12/03/20 22-312/16/20 22-3TOTALSALARIES, FIXED BY 00 BEGINNING BALANCEPAYROLL CHARGESPAYROLL CHARGES.00316,214.0251200REGULAR SALARIES & WAGES12/03/20 22-312/16/20 22-3TOTALREGULAR SALARIES & 00 BEGINNING BALANCEPAYROLL CHARGESPAYROLL CHARGES.00140,914.330001-510-511-0002-0002 - BOARD OF COUNTY COMMISSIO51400OVERTIME EMPLOYEES12/03/20 22-312/16/20 22-3TOTALOVERTIME EMPLOYEES52100FICA/MEDICARE TAXES12/03/20 22-312/16/20 22-3TOTALFICA/MEDICARE TAXES52200RETIREMENT CONTRIBUTIONS12/03/20 22-312/16/20 22-3TOTALRETIREMENT CONTRIBUTIONS52202TOTALOPEB CONTRIBUTIONSOPEB CONTRIBUTIONS52300LIFE & HEALTH INSURANCE12/03/20 22-3* THERE IS A NOTE ASSOCIATED WITH THIS 1393.101,414.79.00 BEGINNING BALANCEPAYROLL CHARGESPAYROLL CHARGES.005,367.641,711.771,697.398,776.80.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL .768,045.1841,847.44.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL 21.00 BEGINNING BALANCE.00.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGE.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL2SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0002 - BOARD OF COUNTY COMMISSIOACCOUNTDATET/CPURCHASE OREFERENCEVENDOR52300LIFE & HEALTH INSURANCE(cont'd)12/03/20 22-312/03/20 22-312/16/20 22-312/16/20 22-312/16/20 22-3TOTALLIFE & HEALTH INSURANCE52400WORKERS COMP12/03/20 22-312/16/20 22-3TOTALWORKERS 06.00190,236.6929,250.0012997 LAW OFFICES OF J12997 LAW OFFICES OF J29,250.00122.951,680.00440.002,242.95TOTAL 1ST SUBTOTAL - PERSONNEL SERVICES53120CONTRACTUAL SERVICES12/10/20 21-358653912/30/20 21-3587213TOTALCONTRACTUAL SERVICESBUDGETCUMULATIVEBALANCEENCUMBRANCES RINGECHARGES-FRINGE50,953.92.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGE.00510.07.00715,069.31.00 BEGINNING BALANCE.00 10/20 4297.000 SVCS.00 11/6-23 ATTY SVCES.0027,007.0553140TOTALLEGAL FEESLEGAL FEES.00.00.00.00.00 BEGINNING BALANCE.00.0053150TOTALCONSULTING SERVICESCONSULTING SERVICES.00.00.00.00.00 BEGINNING BALANCE.00.0029,250.002,242.95TOTAL 1ST SUBTOTAL - CONTRACTUAL SERVICES.0027,007.0554000TOTALTRAVEL AND PER DIEMTRAVEL AND PER DIEM250.00250.00.00.00.00 BEGINNING BALANCE.0054003TOTALTRAVEL - DISTRICT 4TRAVEL - DISTRICT 43,000.003,000.00.00.00.00 BEGINNING BALANCE.003,000.00* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION250.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL3SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0002 - BOARD OF COUNTY COMMISSIOACCOUNTDATET/CPURCHASE OREFERENCEVENDORBUDGETEXPENDITURESENCUMBRANCES DESCRIPTION.00.00.00.00.00 BEGINNING BALANCE.00CUMULATIVEBALANCE5400454004TOTALTRAVEL - DISTRICT 2TRAVEL - DISTRICT 2TRAVEL - DISTRICT 2(cont'd)54006TOTALTRAVEL - DISTRICT 3TRAVEL - DISTRICT 33,000.003,000.00.00.00.00 BEGINNING BALANCE.003,000.0054007TOTALTRAVEL - DISTRICT 5TRAVEL - DISTRICT 53,000.003,000.00.00.00.00 BEGINNING BALANCE.003,000.0054008TOTALTRAVEL - DISTRICT 1TRAVEL - DISTRICT 13,000.003,000.00.00.00.00 BEGINNING BALANCE.003,000.007,626.00AT&T MOBILITYSMARSH INCSMARSH INCSMARSH INC7,626.0019.3354100COMMUNICATIONS12/21/20 17-3 20211180-0112/22/20 21-3V5450512/22/20 21-3V5450512/22/20 21-3V54505TOTALCOMMUNICATIONS54110POSTAGE01/05/21 BEGINNING BALANCETELEPHONE CELLULAR11/1-8/28/21 USAGE11/1-8/28/21 USAGE11/1-8/28/21 USAGE2,456.3237.005.4042.40.00 BEGINNING BALANCEMAIL ACCRL DEC20.00101,917.602,400.00114515 RICOH USA INC2,400.00.00.00.00 BEGINNING BALANCE2,389.20 COPIER MACHINE LEASE RENT2,389.2010.80.00 BEGINNING BALANCE.005,158.002100227854400LEASE/RENTAL OF EQUIPMENT12/21/20 17-3 20211182-01TOTALLEASE/RENTAL OF .78* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION.00 BEGINNING BALANCE

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL4SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0002 - BOARD OF COUNTY COMMISSIOACCOUNTDATET/CPURCHASE 58366.58506.00506.00.00.0055103COMPUTER SUPPLIES01/15/21 21-3587966TOTALCOMPUTER SUPPLIES2,690.0014787 CDW GOVERNMENT I2,690.00.00617.00617.00.00 BEGINNING BALANCE.00 CREATED AT PCARD IMPORT.002,073.0055200OPERATING SUPPLIES12/30/20 21-3V54548TOTALOPERATING SUPPLIES1,802.007759 CFX OFFICE TECHN1,802.00405.8016.79422.59.00 BEGINNING BALANCE.00 JK1911 11/26 OVERAGE.001,379.4155100TOTALOFFICE SUPPLIESOFFICE BALANCEBUDGET54900ADVERTISING12/17/20 25-3TOTALADVERTISINGREFERENCEENCUMBRANCES DESCRIPTION(cont'd)246.0011/20/20 BCC TRANSFER889.22.00 BEGINNING BALANCE.001,551.42.00 BEGINNING BALANCE.00506.0055201TOTALGAS, OIL, AND LUBRICANTSGAS, OIL, AND LUBRICANTS.00.00.00.00.00 BEGINNING BALANCE.00.0055400TOTALBOOKS AND SUBSCRIPTIONSBOOKS AND SUBSCRIPTIONS.00.00.00.00.00 BEGINNING BALANCE.00.0022,175.0012281 SECRETARY OF STA30.0022,205.0022,175.0030.00.00 BEGINNING BALANCE.00 WALDRON,DEAN,WHITEHUR11/20/20 BCC DUES AND MEMBERSHIPS12/10/20 21-358658112/17/20 25-3246TOTALDUES AND MEMBERSHIPSTOTAL 1ST SUBTOTAL - OPERATING EXPENDITURES56100TOTALLANDLAND* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION22,205.007,421.19128,191.77.00 BEGINNING BALANCE.00.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL5SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0002 - BOARD OF COUNTY COMMISSIOACCOUNTDATET/CPURCHASE STOTAL 1ST SUBTOTAL - CAPITAL OUTLAY.00.00.00.0058100TOTAL.00.00.00.00.00 BEGINNING BALANCE.00.00TOTAL 1ST SUBTOTAL - GRANTS AND AIDS.00.00.00.0059301TOTALREFUND P/Y REVENUESREFUND P/Y REVENUES.00.00.00.00.00 BEGINNING BALANCE.00.00TOTAL 1ST SUBTOTAL - OTHER USES.00.00.00.0059101TRANSFER TO OFFICERS12/01/20 19-321001572TOTALTRANSFER TO 67486,950.01.00 BEGINNING BALANCE12/1/20 CLERK DEC.001,460,849.99TOTAL 1ST SUBTOTAL - OTHER ,739.9928,739.99150,661.58.00 BEGINNING BALANCEPAYROLL CHARGESPAYROLL 0 BEGINNING BALANCEPAYROLL CHARGES.006,860.00.00.00.00.00AID TO GOVT AGENCIESAID TO GOVT AGENCIESENCUMBRANCES DESCRIPTION0001-580-581-0003-0003 - CLERK FINANCE SUBSIDY1,460,849.990001-510-512-0004-0004 - COUNTY ADMINISTRATON51200REGULAR SALARIES & WAGES12/03/20 22-312/16/20 22-3TOTALREGULAR SALARIES & WAGES51204SR TRAVEL ALLOWANCE12/03/20 22-3TOTALSR TRAVEL ALLOWANCE51400TOTALOVERTIME EMPLOYEESOVERTIME EMPLOYEES* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION793,904.008,400.00.00 BEGINNING BALANCE.00.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL6SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0004 - COUNTY ADMINISTRATONACCOUNTDATET/CPURCHASE .511,299.437,020.26.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL .434,863.4325,383.68.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL 5.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGEPAYROLL 226.19.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL 55.00110600 THE FIORENTINO G115971 SWAGIT PRODUCTIO11,500.004,500.0052100FICA/MEDICARE TAXES12/03/20 22-312/16/20 22-3TOTALFICA/MEDICARE TAXES55,022.0052200RETIREMENT CONTRIBUTIONS12/03/20 22-312/16/20 22-3TOTALRETIREMENT CONTRIBUTIONS52202TOTAL141,108.00OPEB CONTRIBUTIONSOPEB CONTRIBUTIONS52300LIFE & HEALTH INSURANCE12/03/20 22-312/03/20 22-312/03/20 22-312/16/20 22-312/16/20 22-312/16/20 22-3TOTALLIFE & HEALTH INSURANCE106,165.0052400WORKERS COMP12/03/20 22-312/16/20 22-3TOTALWORKERS COMP1,134.00TOTAL 1ST SUBTOTAL - PERSONNEL SERVICES53120CONTRACTUAL SERVICES12/07/20 21-3 20210492-01 V5416012/16/20 17-3 20211170-01CUMULATIVEBALANCEBUDGET* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTIONENCUMBRANCES DESCRIPTION.00 BEGINNING BALANCE.00.00.00900,221.2488,000.00 BEGINNING BALANCE-4,500.00 SVCS 11/2048,300.00 CONTRACT SERVICE

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL7SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0004 - COUNTY ADMINISTRATONACCOUNTDATET/CPURCHASE OREFERENCEEXPENDITURES53120CONTRACTUAL SERVICES(cont'd)12/17/20 21-3 20210078-01 V54425118689 THE GABOTON GROU12/30/20 21-3 20210492-01 V54561110600 THE FIORENTINO GTOTALCONTRACTUAL 00 RETAINER 12/20-4,500.00 CONSULTANT 12/31123,800.00455.00TOTAL 1ST SUBTOTAL - CONTRACTUAL 00.00.00 BEGINNING BALANCE.002,000.002,000.00.00.00.00 BEGINNING BALANCE.002,000.004,462.00107545 VERIZON WIRELESS120330 SMARSH INC4,462.00126.42294.407.68428.503,450.00 BEGINNING BALANCE-294.40 221304376-00001 11/4.00 11/1-8/28/21 USAGE3,155.60877.90230.00230.005.0080.2085.20.00 BEGINNING BALANCEMAIL ACCRL DEC20.00144.804,050.00114515 RICOH USA INC114515 RICOH USA INC4,050.00337.50337.50337.501,012.503,712.50 BEGINNING BALANCE-337.50 11/20 3156341-337.50 3156341 483 WIX.COM117958 DRAKE'S DELI741.21138.00160.02PRE-EMPLOYMENT EXPENSESPRE-EMPLOYMENT EXPENSES54000TOTALTRAVEL AND PER DIEMTRAVEL AND PER DIEM54100COMMUNICATIONS12/17/20 21-3 20210375-01 58692212/22/20 21-3V54505TOTALCOMMUNICATIONS54110POSTAGE01/05/21 19-3TOTALPOSTAGE2100227854400LEASE/RENTAL OF EQUIPMENT12/01/20 21-3 20210886-01 V5413212/15/20 21-3 20210886-01 V54468TOTALLEASE/RENTAL OF EQUIPMENT54500TOTALINSURANCEINSURANCE54801SPECIAL EVENTS01/15/21 21-301/15/21 21-3587966587966* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTIONENCUMBRANCES .00.00 BEGINNING BALANCE.006,787.00.00 BEGINNING BALANCE.00 CREATED AT PCARD IMPORT.00 CREATED AT PCARD IMPORT

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL8SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0004 - COUNTY ADMINISTRATONACCOUNTDATET/CPURCHASE O54801SPECIAL EVENTS01/15/21 21-301/15/21 21-3TOTALSPECIAL )5879661343 SPORTS CORNER587966124125 OFFICE 78.00THE PRINT SHOP OSTAPLES ADVANTAGAMAZON.COMSTAPLES 1.00252.13252.13.00 BEGINNING BALANCE.002,680.002,680.00238.85238.85.00 BEGINNING BALANCE.002,441.152,652.00THE PRINT SHOP OSTAPLES 332.00.00.00.00 BEGINNING BALANCE.001,275.00.00.00 BEGINNING BALANCEADVERTISINGADVERTISING55100OFFICE SUPPLIES12/31/20 17-3 20211222-0101/15/21 21-301/15/21 21-301/15/21 21-301/15/21 21-301/15/21 21-3TOTALOFFICE ER SUPPLIESCOMPUTER NG SUPPLIES12/31/20 17-3 20211222-0101/15/21 21-358796601/15/21 21-358796601/15/21 21-3587966TOTALOPERATING SUPPLIES55201TOTALGAS, OIL, AND LUBRICANTSGAS, OIL, AND LUBRICANTS55400BOOKS AND 19369120912103328103328* THERE IS A NOTE ASSOCIATED WITH THIS 9818.421,709.43ENCUMBRANCES DESCRIPTIONCUMULATIVEBALANCEBUDGET.00 CREATED AT PCARD IMPORT.00 CREATED AT PCARD IMPORT.0018,697.78.00 BEGINNING 00.00.00186.34250.00BEGINNING BALANCEBUSINESS CARD ORDER DEC20CREATED AT PCARD IMPORTCREATED AT PCARD IMPORTCREATED AT PCARD IMPORTCREATED AT PCARD IMPORTCREATED AT PCARD IMPORT3,388.74678.87BEGINNING BALANCEBUSINESS CARD ORDER DEC20CREATED AT PCARD IMPORTCREATED AT PCARD IMPORTCREATED AT PCARD IMPORT756.23332.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL9SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0004 - COUNTY ADMINISTRATONACCOUNTDATET/CPURCHASE 60.005,265.00105680 ROTARY CLUB OF S105680 ROTARY CLUB OF S5,265.00776.58126.83126.831,030.24TOTAL 1ST SUBTOTAL - OPERATING EXPENDITURES55,342.006,478.3354600TOTALBUILDING MAINTENANCEBUILDING MAINTENANCE62,000.0062,000.00.00.00.00 BEGINNING BALANCE.0062,000.0054601TOTALEQUIPMENT MAINTENANCEEQUIPMENT MAINTENANCE5,180.005,180.00394.00394.00.00 BEGINNING BALANCE.004,786.0054602TOTALVEHICLE MAINTENANCEVEHICLE MAINTENANCE750.00750.00708.96708.96.00 BEGINNING BALANCE.0067,930.001,102.96BOOKS AND SUBSCRIPTIONS(cont'd)BOOKS AND SUBSCRIPTIONS55401TOTALTRAININGTRAINING55405DUES AND MEMBERSHIPS12/14/20 21-358686812/30/20 21-3587266TOTALDUES AND MEMBERSHIPSTOTAL 1ST SUBTOTAL - MAINTENANCEENCUMBRANCES .00.00 BEGINNING BALANCE.001,275.00590.00.00 BEGINNING BALANCE.00 MMSHP DUES J ANDREWS.00 MMSHP DUES J 0456400TOTALEQUIPMENTEQUIPMENT.00.00.00.00.00 BEGINNING BALANCE.00.0056401TOTALOFFICE EQUIPMENTOFFICE EQUIPMENT.00.00.00.00.00 BEGINNING BALANCE.00.0056403TOTALCOMPUTER EQUIPMENTCOMPUTER EQUIPMENT3,000.003,000.001,800.001,800.00* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION.00 BEGINNING BALANCE.001,200.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL10SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0004 - COUNTY ADMINISTRATONACCOUNTDATEPURCHASE .9462,024.21.00.00.00.0052100FICA/MEDICARE TAXES12/03/20 22-312/16/20 22-3TOTALFICA/MEDICARE TAXES23,005.002,804.08877.67878.734,560.48.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGE.0018,444.5252200RETIREMENT CONTRIBUTIONS12/03/20 22-312/16/20 22-3TOTALRETIREMENT 93.906,202.45.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL 11.444.004.001,795.52CAPITAL VEHICLESCAPITAL VEHICLESTOTAL 1ST SUBTOTAL - CAPITAL OUTLAYENCUMBRANCES DESCRIPTIONCUMULATIVEBALANCEBUDGET56415TOTALT/C.00 BEGINNING BALANCE.00.00.001,200.000001-510-512-0005-0005 - CONSTRUCTION ADMIN.51200REGULAR SALARIES & WAGES12/03/20 22-312/16/20 22-3TOTALREGULAR SALARIES & WAGES51400TOTAL52202TOTALOVERTIME EMPLOYEESOVERTIME EMPLOYEESOPEB CONTRIBUTIONSOPEB CONTRIBUTIONS52300LIFE & HEALTH INSURANCE12/03/20 22-312/03/20 22-312/03/20 22-3* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION23,005.00.00 BEGINNING BALANCEPAYROLL CHARGESPAYROLL CHARGES.00238,698.79.00 BEGINNING BALANCE.00.00 BEGINNING BALANCE.00.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGE.00.00

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08PAGE NUMBER:AUDIT21ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAIL11SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0005 - CONSTRUCTION ADMIN.ACCOUNTDATET/CPURCHASE .529,318.48PAYROLL CHARGES-FRINGEPAYROLL CHARGES-FRINGEPAYROLL 24699.16.00 BEGINNING BALANCEPAYROLL CHARGES-FRINGEPAYROLL 002,205.00.00.00.00 BEGINNING BALANCE.002,205.00.00.00.00.00.00 BEGINNING BALANCE.002,205.00.00.00.00.00.00.00.00 BEGINNING BALANCE.002,925.00107545 VERIZON WIRELESS120330 SMARSH INC116675 STATE OF 45.503.9552300LIFE & HEALTH INSURANCE(cont'd)12/16/20 22-312/16/20 22-312/16/20 22-3TOTALLIFE & HEALTH INSURANCE52400WORKERS COMP12/03/20 22-312/16/20 22-3TOTALWORKERS COMP3,206.00TOTAL 1ST SUBTOTAL - PERSONNEL SERVICES53120TOTALCONTRACTUAL SERVICESCONTRACTUAL SERVICES53150TOTALCONSULTING SERVICESCONSULTING SERVICESTOTAL 1ST SUBTOTAL - CONTRACTUAL SERVICES54000TOTALTRAVEL AND PER DIEMTRAVEL AND PER DIEM54100COMMUNICATIONS12/14/20 21-3 20210665-01 58692212/22/20 21-3V5450512/22/20 21-3587017TOTALCOMMUNICATIONS54110POSTAGE01/05/21 19-3TOTALPOSTAGECUMULATIVEBALANCEBUDGET21002278* THERE IS A NOTE ASSOCIATED WITH THIS TRANSACTION250.00ENCUMBRANCES .22.002,205.00.00BEGINNING BALANCE323770829-00004 11/2311/1-8/28/21 USAGEA97-1355 10/20226.14.00 BEGINNING BALANCEMAIL ACCRL DEC20.00246.05

SUNGARD PENTAMATIONDATE: 02/01/2021TIME: 07:26:08ST. JOHNS BOARD OF COUNTY COMMISSIONERSEXPENDITURE AUDIT TRAILPAGE NUMBER:AUDIT2112SELECTION CRITERIA: ALLACCOUNTING PERIOD: 3/21SORTED BY: DEPARTMENT,1ST SUBTOTAL,FUND,ACCOUNTTOTALED ON: 1ST SUBTOTALPAGE BREAKS ON:FUND - 0001 - GENERAL FUNDDEPARTMENT - 0005 - CONSTRUCTION ADMIN.ACCOUNTDATET/CPURCHASE OREFERENCE5440054400TOTALLEASE/RENTAL OF EQUIPMENT (cont'd)LEASE/RENTAL OF EQUIPMENTLEASE/RENTAL OF EQUIPMENT54500TOTALINSURANCEINSURANCE55100OFFICE SUPPLIES01/15/21 21-3TOTALOFFICE SUPPLIES58796655102SOFTWARE12/29/20 21-3 20210752-01 .00.00.00.00 BEGINNING BALANCE.002,388.002,388.00.00.00.00 BEGINNING BALANCE.002,388.00500.00120912 STAPLES ADVANTAG500.0067.727.9475.66.00 BEGINNING BALANCE.00 CREATED AT

sungard pentamation page number: 1 . accounting period: 3/21 sorted by: department,1st subtotal,fund,account totaled on: 1st subtotal . 55102