Loading...
HomeMy WebLinkAbouttrialbalance2017 03/21/2018 16:42 |CITY OF SEBASTIAN |P 1 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 001 GEN FUND ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 001 -00-00-00-000-102000- EQUITY IN POOLED CASH 001001 1,221,578.28 001 -00-00-00-000-104000- PETTY CASH 001001 580.00 001 -00-00-00-000-104001- PETTY CASH - PD ADMINISTRATI 001001 100.00 001 -00-00-00-000-104008- PETTY CASH - PD RECORDS 001001 50.00 001 -00-00-00-000-104050- PETTY CASH - TENNIS COURTS 001001 200.00 001 -00-00-00-000-104057- PETTY CASH - SKATE PARK 001001 250.00 001 -00-00-00-000-115001- ACCOUNTS RECEIVABLE - GF 001001 370,888.57 001 -00-00-00-000-115050- TRAVEL ADVANCES-EMPLOYEE 001001 177.60 001 -00-00-00-000-131000- DUE FROM OTHER FUNDS 001001 886,970.01 001 -00-00-00-000-132946- ADVANCE TO AIRPORT 001001 100,000.44 001 -00-00-00-000-133000- DUE FROM OTHER GOVT'L UNITS 001001 281,984.17 001 -00-00-00-000-133100- DUE FROM DOR-FUEL TAX REBATE 001001 2,805.95 001 -00-00-00-000-141000- INVENTORIES-MATERIALS/SUPPLI 001001 471.91 001 -00-00-00-000-141001- INVENTORIES-COMPUTER SUPPLIE 001001 382.30 001 -00-00-00-000-141054- INVENTORY - GARAGE 001001 34,697.70 001 -00-00-00-000-141260- INVENTORY-DIESEL FUEL 001001 3,803.68 001 -00-00-00-000-141265- INVENTORY - UNLEADED FUEL 001001 15,652.20 001 -00-00-00-000-151100- INVESTMENTS-SBA 001001 1,437,552.78 001 -00-00-00-000-151335- INVESTMENTS-AGENCY NOTES 001001 504,241.96 001 -00-00-00-000-155000- PREPAID EXPENSES 001001 186,269.76 001 -00-00-00-000-155115- PREPAID POSTAGE 001001 1,227.41 001 -00-00-00-000-202000- ACCOUNTS PAYABLE 001001 116,164.16 001 -00-00-00-000-208001- SALES TAX PAYABLE 001001 234.85 001 -00-00-00-000-208002- DUE TO IRC - TIF 001001 50,173.39 001 -00-00-00-000-216000- ACCRUED WAGES PAYABLE 001001 257,514.32 001 -00-00-00-000-217000- ACCRUED TAXES PAYABLE 001001 19,510.20 001 -00-00-00-000-218010- ACCRUED COBRASERVE 001001 100.51 001 -00-00-00-000-219010- ACCRUED CH 185 POLICE PENSIO 001001 16,538.87 001 -00-00-00-000-219110- ACCRUED 401A DEF CONTRIBUTIO 001001 3,518.65 001 -00-00-00-000-219150- ACCRUED CWA/ITU PENSION CONT 001001 8,164.03 001 -00-00-00-000-220000- DEPOSITS 001001 1,400.00 001 -00-00-00-000-220010- DEPOSITS - CAR SEATS 001001 851.00 001 -00-00-00-000-220020- DEPOSIT - HRA 001001 17,013.69 001 -00-00-00-000-220030- DEPOSITS-SHOP WITH A COP 001001 13,564.19 001 -00-00-00-000-223000- DEFERRED REVENUE 001001 11,220.57 001 -00-00-00-000-223010- DEFFERED REV - BUSINESS TAX 001001 60,798.40 001 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 001001 4,507,145.27 =================================================================================================================================== FUND TOTALS 5,066,898.41 5,066,898.41=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 2 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 105 CDBG ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 105 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 105000 227,642.88 105 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 105000 227,642.88 =================================================================================================================================== FUND TOTALS 227,642.88 227,642.88=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 3 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 106 CDBG ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 106 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 106000 63,300.43 106 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 106000 63,300.43 =================================================================================================================================== FUND TOTALS 63,300.43 63,300.43=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 4 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 120 LOGT ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 120 -00-00-00-000-102000- EQUITY IN POOLED CASH 120001 221,726.54 120 -00-00-00-000-133000- DUE FROM OTHER GOVT'L UNITS 120001 61,170.76 120 -00-00-00-000-202000- ACCOUNTS PAYABLE 120001 71,893.55 120 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 120001 211,003.75 =================================================================================================================================== FUND TOTALS 282,897.30 282,897.30=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 5 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 130 DST ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 130 -00-00-00-000-102000- EQUITY IN POOLED CASH 130001 983,818.38 130 -00-00-00-000-132946- ADVANCE TO AIRPORT 130001 550,638.46 130 -00-00-00-000-133000- DUE FROM OTHER GOVT'L UNITS 130001 310,264.81 130 -00-00-00-000-151100- INVESTMENTS-SBA 130001 802,905.62 130 -00-00-00-000-202000- ACCOUNTS PAYABLE 130001 3,750.00 130 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 130001 2,643,877.27 =================================================================================================================================== FUND TOTALS 2,647,627.27 2,647,627.27=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 6 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 140 RIVERFRONT ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 140 -00-00-00-000-102000- EQUITY IN POOLED CASH 140001 442,763.86 140 -00-00-00-000-151100- INVESTMENTS-SBA 140001 98,287.83 140 -00-00-00-000-202000- ACCOUNTS PAYABLE 140001 303.60 140 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 140001 540,748.09 =================================================================================================================================== FUND TOTALS 541,051.69 541,051.69=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 7 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 150 PARKING ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 150 -00-00-00-000-151100- INVESTMENTS-SBA 150001 39,893.10 150 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 150001 39,893.10 =================================================================================================================================== FUND TOTALS 39,893.10 39,893.10=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 8 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 160 REC IMPACT ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 160 -00-00-00-000-102000- EQUITY IN POOLED CASH 160001 758,997.99 160 -00-00-00-000-151100- INVESTMENTS-SBA 160001 196,253.33 160 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 160001 50,358.74 160 -00-00-00-000-271001- Fund Bal Unreserved ZONE A 160001 251,850.30 160 -00-00-00-000-271002- Fund Bal Unreserved ZONE B 160001 211,624.15 160 -00-00-00-000-271003- Fund Bal Unreserved ZONE C 160001 55,354.46 160 -00-00-00-000-271004- Fund Bal Unreserved ZONE D 160001 386,063.67 =================================================================================================================================== FUND TOTALS 955,251.32 955,251.32=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 9 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 163 STORM UTIL ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 163 -00-00-00-000-102000- EQUITY IN POOLED CASH 163001 255,319.01 163 -00-00-00-000-133000- DUE FROM OTHER GOVT'L UNITS 163001 11,284.21 163 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 163001 183,396.78 163 -00-00-00-000-271300- FUND BALANCE RESERVE FOR DEB 163001 450,000.00 =================================================================================================================================== FUND TOTALS 450,000.00 450,000.00=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 10 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 190 LEF FUND ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 190 -00-00-00-000-102000- EQUITY IN POOLED CASH 190001 14,571.56 190 -00-00-00-000-151100- INVESTMENTS-SBA 190001 34,653.94 190 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 190001 49,225.50 =================================================================================================================================== FUND TOTALS 49,225.50 49,225.50=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 11 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 263 STORM DEBT ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 263 -00-00-59-590-102000- EQUITY IN POOLED CASH 263001 170,357.22 263 -00-00-59-590-271000- FUND BALANCE-UNRESERVED 263001 170,357.22 =================================================================================================================================== FUND TOTALS 170,357.22 170,357.22=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 12 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 310 CAP PROJ ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 310 -00-00-00-000-102000- EQUITY IN POOLED CASH 310000 436,302.89 310 -00-00-00-000-202000- ACCOUNTS PAYABLE 310000 356,290.41 310 -00-00-00-000-206000- RETAINAGE PAYABLE 310000 100,562.94 310 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 310000 11,431,764.75 310 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 310000 746,211.32 310 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 310000 10,706,103.89 =================================================================================================================================== FUND TOTALS 11,888,618.10 11,888,618.10=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 13 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 320 CAP IMPROV ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 320 -00-00-00-000-102000- EQUITY IN POOLED CASH 320000 73.95 320 -00-00-00-000-133000- DUE FROM OTHER GOVT'L UNITS 320000 35,575.94 320 -00-00-00-000-133705- DUE FROM FIND 320000 14,205.07 320 -00-00-00-000-202000- ACCOUNTS PAYABLE 320000 868.30 320 -00-00-00-000-206000- RETAINAGE PAYABLE 320000 3,507.42 320 -00-00-00-000-207001- DUE TO GENERAL FUND 320000 51,300.00 320 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 320000 34,694,447.44 320 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 320000 1,327,489.32 320 -00-00-00-000-271200- DESGNATED FUND BALANCE 320000 1,029,333.41 320 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 320000 34,402,112.29 =================================================================================================================================== FUND TOTALS 35,779,456.57 35,779,456.57=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 14 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 330 TRANS PROJ ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 330 -00-00-00-000-133000- DUE FROM OTHER GOVT'L UNITS 330000 9,869.91 330 -00-00-00-000-135000- INTEREST/DIVIDENDS RECEIVABL 330000 .01 330 -00-00-00-000-207001- DUE TO GENERAL FUND 330000 9,870.01 330 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 330000 31,875,419.21 330 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 330000 .11 330 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 330000 31,875,419.21 =================================================================================================================================== FUND TOTALS 31,885,289.23 31,885,289.23=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 15 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 335 ROAD PAVNG ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 335 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 335000 445,175.25 335 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 335000 445,175.25 =================================================================================================================================== FUND TOTALS 445,175.25 445,175.25=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 16 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 363 STORM IMPR ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 363 -00-00-00-000-102000- EQUITY IN POOLED CASH 363000 252,924.35 363 -00-00-00-000-202000- ACCOUNTS PAYABLE 363000 3,323.00 363 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 363000 33,876,772.57 363 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 363000 33,642,671.22 363 -00-00-00-000-271500- APPROPRIATED FUND BALANCE 363000 15,500.00 =================================================================================================================================== FUND TOTALS 33,895,595.57 33,895,595.57=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 17 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 390 PUB FAC IM ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 390 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 390000 9,972,843.16 390 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 390000 9,972,843.16 =================================================================================================================================== FUND TOTALS 9,972,843.16 9,972,843.16=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 18 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 410 GOLF COURS ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 410 -00-00-00-000-102000- EQUITY IN POOLED CASH 410001 88,956.99 410 -00-00-00-000-104000- PETTY CASH 410001 1,250.00 410 -00-00-00-000-115000- ACCOUNTS RECEIVABLE 410001 10,823.43 410 -00-00-00-000-141000- INVENTORIES-MATERIALS/SUPPLI 410001 13,088.09 410 -00-00-00-000-155000- PREPAID EXPENSES 410001 6,320.70 410 -00-00-00-000-162900- BUILDINGS 410001 437,153.45 410 -00-00-00-000-163900- ACCUMULATED DEPRECIATION-BLD 410001 289,054.85 410 -00-00-00-000-164900- IMPROVMENTS OTHER THAN BLDGS 410001 1,183,567.94 410 -00-00-00-000-165900- ACCUMULATED DEPRECIATION-IOT 410001 187,140.43 410 -00-00-00-000-166900- EQUIPMENT AND FURNITURE 410001 494,863.74 410 -00-00-00-000-167900- ACCUMULATED DEPRECIATION-EQU 410001 149,839.50 410 -00-00-00-000-168900- INFRASTRUCTURE 410001 1,369,778.75 410 -00-00-00-000-168950- ACCUMULATED DEPRECIATION-INF 410001 966,032.57 410 -00-00-00-000-169900- CONSTRUCTION WORK IN PROCESS 410001 65,211.99 410 -00-00-00-000-202000- ACCOUNTS PAYABLE 410001 63,254.90 410 -00-00-00-000-203000- NOTES PAYABLE-CURRENT PORTIO 410001 48,285.80 410 -00-00-00-000-203900- NOTES PAYABLE-LONG-TERM PORT 410001 206,167.00 410 -00-00-00-000-206000- RETAINAGE PAYABLE 410001 1,923.47 410 -00-00-00-000-207000- DUE TO OTHER FUNDS 410001 1,023,317.98 410 -00-00-00-000-207001- DUE TO GENERAL FUND 410001 535,800.00 410 -00-00-00-000-208001- SALES TAX PAYABLE 410001 4,657.44 410 -00-00-00-000-210910- COMPENSATED ABSENCES-L/T 410001 93,121.14 410 -00-00-00-000-215040- ACCRUED INT PAYABLE-'93 BOND 410001 417.02 410 -00-00-00-000-216000- ACCRUED WAGES PAYABLE 410001 9,926.61 410 -00-00-00-000-217000- ACCRUED TAXES PAYABLE 410001 738.33 410 -00-00-00-000-218004- OPEB Liability 410001 417.48 410 -00-00-00-000-219110- ACCRUED 401A DEF CONTRIBUTIO 410001 325.87 410 -00-00-00-000-219150- ACCRUED CWA/ITU PENSION CONT 410001 192.35 410 -00-00-00-000-220020- DEPOSIT - HRA 410001 493.15 410 -00-00-00-000-223401- DEFERRED GIFT CERTIFICATES 410001 2,906.35 410 -00-00-00-000-223402- DEFERRED CREDIT BOOK 410001 21,495.50 410 -00-00-00-000-223412- DEFERRED CLUB STORAGE FEES 410001 953.19 410 -00-00-00-000-223421- DEFERRED MEMBERSHIP FEES 410001 41,629.88 410 -00-00-00-000-223422- DEFERRED HANDICAP FEES 410001 1,020.00 410 -00-00-00-000-223423- DEFERRED RES CARD FEES 410001 514.03 410 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 410001 .30 410 -00-00-00-000-248000- RETAINED EARNINGS-RESERVED 410001 102,768.00 410 -00-00-00-000-271600- APPROPRIATED RETAINED EARNIN 410001 66,860.58 410 -00-00-00-000-272000- RETAINED EARNINGS-UNRESERVED 410001 147,251.74 =================================================================================================================================== FUND TOTALS 3,818,760.27 3,818,760.27=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 19 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 415 GC PROJECT ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 415 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 415000 114,132.53 415 -00-00-00-000-271600- APPROPRIATED RETAINED EARNIN 415000 114,132.53 =================================================================================================================================== FUND TOTALS 114,132.53 114,132.53=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 20 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 450 AIRPORT ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 450 -00-00-00-000-102000- EQUITY IN POOLED CASH 450001 59,670.44 450 -00-00-00-000-115450- ACCTS REC. - AIRPORT 450001 502.73 450 -00-00-00-000-141450- AVIATION FUEL 450001 5,680.08 450 -00-00-00-000-155000- PREPAID EXPENSES 450001 12,464.92 450 -00-00-00-000-161900- LAND 450001 9,060.00 450 -00-00-00-000-162900- BUILDINGS 450001 6,187,616.46 450 -00-00-00-000-163900- ACCUMULATED DEPRECIATION-BLD 450001 1,115,335.71 450 -00-00-00-000-164900- IMPROVMENTS OTHER THAN BLDGS 450001 1,666,973.46 450 -00-00-00-000-165900- ACCUMULATED DEPRECIATION-IOT 450001 991,952.99 450 -00-00-00-000-166900- EQUIPMENT AND FURNITURE 450001 794,374.89 450 -00-00-00-000-167900- ACCUMULATED DEPRECIATION-EQU 450001 578,741.50 450 -00-00-00-000-168900- INFRASTRUCTURE 450001 6,428,352.43 450 -00-00-00-000-168950- ACCUMULATED DEPRECIATION-INF 450001 3,191,315.10 450 -00-00-00-000-169900- CONSTRUCTION WORK IN PROCESS 450001 67,675.22 450 -00-00-00-000-202000- ACCOUNTS PAYABLE 450001 1,977.63 450 -00-00-00-000-208045- AIRPORT SALES TAX PAYABLE 450001 1,139.32 450 -00-00-00-000-210910- COMPENSATED ABSENCES-L/T 450001 37,357.06 450 -00-00-00-000-216000- ACCRUED WAGES PAYABLE 450001 7,686.98 450 -00-00-00-000-217000- ACCRUED TAXES PAYABLE 450001 574.20 450 -00-00-00-000-218004- OPEB Liability 450001 218.74 450 -00-00-00-000-219110- ACCRUED 401A DEF CONTRIBUTIO 450001 251.30 450 -00-00-00-000-219150- ACCRUED CWA/ITU PENSION CONT 450001 440.52 450 -00-00-00-000-220020- DEPOSIT - HRA 450001 616.44 450 -00-00-00-000-223000- DEFERRED REVENUE 450001 9,094.18 450 -00-00-00-000-236901- ADVANCE FROM GF FUND 001 450001 100,000.44 450 -00-00-00-000-236913- ADVANCE FROM DST FUND 450001 550,638.46 450 -00-00-00-000-250000- CONTRIBUTED CAPITAL 450001 70.00 450 -00-00-00-000-272000- RETAINED EARNINGS-UNRESERVED 450001 8,646,192.94 =================================================================================================================================== FUND TOTALS 15,232,987.07 15,232,987.07=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 21 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 455 AIRPORT PR ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 455 -00-00-00-000-102000- EQUITY IN POOLED CASH 455000 17,130.80 455 -00-00-00-000-133503- DUE FR FDOT-JPA A1451 455000 196,934.25 455 -00-00-00-000-133531- DUE FROM FDOT - JPA 455000 1,811.39 455 -00-00-00-000-133532- DUE FR FDOT-JPA A1656 455000 30,615.25 455 -00-00-00-000-133605- FED DUE FROM FAA 455000 82,915.00 455 -00-00-00-000-162900- BUILDINGS 455000 2,541,355.82 455 -00-00-00-000-163900- ACCUMULATED DEPRECIATION-BLD 455000 507,520.03 455 -00-00-00-000-165900- ACCUMULATED DEPRECIATION-IOT 455000 160,228.38 455 -00-00-00-000-166900- EQUIPMENT AND FURNITURE 455000 109,249.41 455 -00-00-00-000-167900- ACCUMULATED DEPRECIATION-EQU 455000 107,650.92 455 -00-00-00-000-168900- INFRASTRUCTURE 455000 934,530.59 455 -00-00-00-000-168950- ACCUMULATED DEPRECIATION-INF 455000 661,116.02 455 -00-00-00-000-169900- CONSTRUCTION WORK IN PROCESS 455000 187,158.36 455 -00-00-00-000-202000- ACCOUNTS PAYABLE 455000 39,010.13 455 -00-00-00-000-207000- DUE TO OTHER FUNDS 455000 290,000.00 455 -00-00-00-000-245050- BUDGETARY FUND BALANCE - UNR 455000 49,025,132.25 455 -00-00-00-000-250000-C1502 CONTRIBUTED CAPITAL 455000 230,210.78 455 -00-00-00-000-250000-C2502 CONTRIBUTED CAPITAL 455000 1,606.00 455 -00-00-00-000-271600- APPROPRIATED RETAINED EARNIN 455000 48,810,402.38 455 -00-00-00-000-272000- RETAINED EARNINGS-UNRESERVED 455000 1,889,628.74 =================================================================================================================================== FUND TOTALS 52,912,103.25 52,912,103.25=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 22 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 480 BUILDING ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 480 -00-00-00-000-102000- EQUITY IN POOLED CASH 480001 294,392.16 480 -00-00-00-000-131000- DUE FROM OTHER FUNDS 480001 323,317.98 480 -00-00-00-000-151100- INVESTMENTS-SBA 480001 116,946.44 480 -00-00-00-000-155000- PREPAID EXPENSES 480001 7,686.77 480 -00-00-00-000-161900- LAND 480001 10,375.59 480 -00-00-00-000-166900- EQUIPMENT AND FURNITURE 480001 112,738.45 480 -00-00-00-000-167900- ACCUMULATED DEPRECIATION-EQU 480001 54,683.86 480 -00-00-00-000-202000- ACCOUNTS PAYABLE 480001 1,758.37 480 -00-00-00-000-208300- DUE TO STATE - RADON 480001 3,020.10 480 -00-00-00-000-208301- DUE TO STATE - DCA 480001 2,560.49 480 -00-00-00-000-210910- COMPENSATED ABSENCES-L/T 480001 103,287.67 480 -00-00-00-000-216000- ACCRUED WAGES PAYABLE 480001 18,331.48 480 -00-00-00-000-217000- ACCRUED TAXES PAYABLE 480001 1,410.33 480 -00-00-00-000-218004- OPEB Liability 480001 738.00 480 -00-00-00-000-219110- ACCRUED 401A DEF CONTRIBUTIO 480001 368.41 480 -00-00-00-000-219150- ACCRUED CWA/ITU PENSION CONT 480001 1,281.41 480 -00-00-00-000-220020- DEPOSIT - HRA 480001 493.15 480 -00-00-00-000-223000- DEFERRED REVENUE 480001 7,332.00 480 -00-00-00-000-272000- RETAINED EARNINGS-UNRESERVED 480001 1,371,178.42 480 -85-00-52-524-132947- ADVANCE TO GC FUND 480110 700,000.00 =================================================================================================================================== FUND TOTALS 1,565,950.54 1,565,950.54=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 23 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 601 CEMETRY TF ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 601 -00-00-00-000-102000- EQUITY IN POOLED CASH 601001 64,845.04 601 -00-00-00-000-151100- INVESTMENTS-SBA 601001 876,215.87 601 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 601001 941,060.91 =================================================================================================================================== FUND TOTALS 941,060.91 941,060.91=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 24 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 620 PO PENSION ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 620 -00-00-00-000-135000- INTEREST/DIVIDENDS RECEIVABL 620200 34,918.35 620 -00-00-00-000-151620- INVESTMENTS-POLICE PENSION 620200 13,967,600.91 620 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 620200 14,002,519.26 =================================================================================================================================== FUND TOTALS 14,002,519.26 14,002,519.26=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 25 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 680 PERF DEPOS ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 680 -00-00-00-000-102000- EQUITY IN POOLED CASH 680800 6,930.00 680 -00-00-00-000-151100- INVESTMENTS-SBA 680800 73,750.00 680 -00-00-00-000-220900- PERFORMANCE DEPOSITS 680800 5,500.00 680 -00-00-00-000-220902- PERFORMANCE BOND SEB. LANDIN 680800 10,000.00 680 -00-00-00-000-220904- Cash Bond - Mercedes Home 680800 500.00 680 -00-00-00-000-220907- Construction Bond - Maronda 680800 1,000.00 680 -00-00-00-000-220909- Cash Bond - Vickers Grove Sa 680800 63,680.00 =================================================================================================================================== FUND TOTALS 80,680.00 80,680.00=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 26 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 901 GFAAG ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 901 -00-00-00-000-161900- LAND 901001 8,391,050.43 901 -00-00-00-000-162900- BUILDINGS 901001 13,342,048.36 901 -00-00-00-000-163900- ACCUMULATED DEPRECIATION-BLD 901001 5,727,992.61 901 -00-00-00-000-164900- IMPROVMENTS OTHER THAN BLDGS 901001 6,871,237.87 901 -00-00-00-000-165900- ACCUMULATED DEPRECIATION-IOT 901001 4,231,785.71 901 -00-00-00-000-166900- EQUIPMENT AND FURNITURE 901001 9,644,084.95 901 -00-00-00-000-167900- ACCUMULATED DEPRECIATION-EQU 901001 7,104,621.98 901 -00-00-00-000-168900- INFRASTRUCTURE 901001 42,100,214.36 901 -00-00-00-000-168950- ACCUMULATED DEPRECIATION-INF 901001 23,032,101.34 901 -00-00-00-000-169900- CONSTRUCTION WORK IN PROCESS 901001 381,886.45 901 -00-00-00-000-271000- FUND BALANCE-UNRESERVED 901001 35,534,327.20 901 -00-00-00-000-280001- INV IN GFA-COUNTY GRANTS 901001 507,031.16 901 -00-00-00-000-280002- INV IN GFA-STATE GRANTS 901001 2,852,055.04 901 -00-00-00-000-280003- INV IN GFA-DISTRICT GRANTS 901001 2,919,702.23 901 -00-00-00-000-280004- INV IN GFA-FEDERAL GRANTS 901001 1,587,498.45 901 -00-00-00-000-280005- INV IN GFA-GENERAL FD REVENU 901001 8,476,823.02 901 -00-00-00-000-280006- INV IN GFA-CEMETERY TRUST FU 901001 592,753.25 901 -00-00-00-000-280007- INV IN GFA-LAW ENFORCE TRUST 901001 97,814.53 901 -00-00-00-000-280008- INV IN GFA-CONTRIB CAP/ENT F 901001 22,500.82 901 -00-00-00-000-280009- INV IN GFA-CAPITAL LEASES 901001 767,061.62 901 -00-00-00-000-280010- INV IN GFA-LOGT PAVING LOAN 901001 1,225,976.32 901 -00-00-00-000-280011- INV IN GFA-PARKING IN LIEU O 901001 90,620.98 901 -00-00-00-000-280020- INV IN GFA - LOGT 901001 3,150,962.23 901 -00-00-00-000-280030- INV IN GFA - DST 901001 23,648,358.12 901 -00-00-00-000-280031- RIVERFRONT REDEVELOPMENT FUN 901001 2,693,061.35 901 -00-00-00-000-280035- INV IN GFA - REVENUE BONDS 901001 13,816,786.42 901 -00-00-00-000-280050- INV IN GFA-CONTRIB FROM DEVE 901001 76,019.86 901 -00-00-00-000-280060- INV IN GFA-RIF 901001 2,432,715.78 901 -00-00-00-000-280063- INV IN GFA - STORMWATER FEE 901001 2,939,502.58 901 -00-00-00-000-280100- INV IN GFA-GIFTS/DONATIONS 901001 2,862,921.74 901 -00-00-00-000-280363- INV IN GFA - STORMWATER BOND 901001 5,408,182.48 =================================================================================================================================== FUND TOTALS 116,264,849.62 116,264,849.62=================================================================================================================================== 03/21/2018 16:42 |CITY OF SEBASTIAN |P 27 JSmith |2017 FINAL TRIAL BALANCE |gleoytrb FUND 951 GLTDAG ACCOUNT DESCRIPTION ORG DEBIT CREDIT___________________________________________________________________________________________________________________________________ 951 -00-00-00-000-180006- AMOUNT AVAILABLE-DST 2003 BO 951001 160,727.13 951 -00-00-00-000-180007- AMOUNT AVAILABLE-03'STORMWAT 951001 167,382.03 951 -00-00-00-000-181003- AMT TO BE PROV-GAS TAX LOAN 951001 1,478,000.00 951 -00-00-00-000-181006- AMOUNT TO BE PROV-DST 03 BON 951001 192,272.87 951 -00-00-00-000-181008- AMOUNT TO BE PROV-03 SW BOND 951001 2,107,617.97 951 -00-00-00-000-181100- AMT TO BE PROV-COMP ABSENCES 951001 1,395,593.82 951 -00-00-00-000-210910- COMPENSATED ABSENCES-L/T 951001 1,395,593.82 951 -00-00-00-000-232003- DST 03 BONDS PAYABLE-CURRENT 951001 353,000.00 951 -00-00-00-000-232005- SW 03 BONDS PAYABLE-CURRENT 951001 363,000.00 951 -00-00-00-000-232121- GAS TAX N/P - CURRENT 951001 215,000.00 951 -00-00-00-000-232905- SW 03 BONDS PAYABLE - L/T 951001 1,912,000.00 951 -00-00-00-000-252921- GAS TAX NOTE PAYABLE-L/T 951001 1,263,000.00 =================================================================================================================================== FUND TOTALS 5,501,593.82 5,501,593.82=================================================================================================================================== ** END OF REPORT - Generated by Jennifer Smith **