Loading...
AJE 4148 Completed ProjectsHTE info Group type (F4)AJ Adjusting journal Group date 09/30/17 Accounting period 13 Accounting year 2017 Group description Record Completed Projects Create document N (Y=Yes; N=No) Count entered 64 Debit amount entered 5,838,081.42 Credit amount entered 5,838,081.42 Transaction date 09/30/17 Page:1 1 Group number 4148 Funding Fund/Account Name Project #Source Account number Debit Credit GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PM1501 131 900 0000 164 91 00 249,720.24 GFAAG/Capital Expense Reclass PM1501 131 900 0000 169 90 00 249,720.24 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PM1505 320 900 0000 164 91 00 7,386.00 GFAAG/Capital Expense Reclass PM1505 320 900 0000 169 90 00 7,386.00 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PM1701 001 900 0000 164 91 00 5,619.04 GFAAG/Capital Expense Reclass PM1701 001 900 0000 599 69 99 5,619.04 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PM1702 110 900 0000 164 91 00 118,860.02 GFAAG/Capital Expense Reclass PM1702 110 900 0000 599 69 99 118,860.02 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PM1705 131 900 0000 164 91 00 5,394.48 GFAAG/Capital Expense Reclass PM1705 131 900 0000 599 69 99 5,394.48 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PW1404 001 900 0000 164 91 00 28,854.82 GFAAG/Capital Expense Reclass PW1404 001 900 0000 169 90 00 28,854.82 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PW1406 131 900 0000 164 91 00 99,990.29 GFAAG/Capital Expense Reclass PW1406 131 900 0000 169 90 00 99,990.29 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PW1502 110 900 0000 164 91 00 638,096.53 GFAAG/Capital Expense Reclass PW1502 110 900 0000 169 90 00 438,040.45 GFAAG/Capital Expense Reclass PW1502 110 900 0000 599 69 99 200,056.08 GFAAG/Infrastructure-IMPR OTHER BLDG-PURCHASED PS1501 300 900 0000 164 91 00 3,703,713.45 GFAAG/Capital Expense Reclass PS1501 300 900 0000 169 90 00 1,159,231.94 GFAAG/Capital Expense Reclass PS1501 300 900 0000 599 69 99 2,544,481.51 Water Fund/IOTB PU1410 400 400 0000 164 91 00 98,567.00 WaterFund/Capital Expense Reclass PU1410 400 400 0000 169 90 00 98,567.00 Water Fund/IOTB PU1602 400 400 0000 164 91 00 23,263.72 WaterFund/Capital Expense Reclass PU1602 400 400 0000 169 90 00 23,263.72 Water Fund/IOTB PU1603 400 400 0000 164 91 00 25,915.70 WaterFund/Capital Expense Reclass PU1603 400 400 0000 169 90 00 25,915.70 Water Fund/IOTB PU1604 400 400 0000 164 91 00 8,747.45 WaterFund/Capital Expense Reclass PU1604 400 400 0000 169 90 00 172.16 WaterFund/Capital Expense Reclass PU1604 400 400 0000 599 69 99 8,575.29 Water Fund/IOTB PU1605 400 400 0000 164 91 00 97,339.25 WaterFund/Capital Expense Reclass PU1605 400 400 0000 169 90 00 97,339.25 Sewer Fund/IOTB PU1308 410 410 0000 164 91 00 7,850.70 Sewer Fund/Capital Expense Reclass PU1308 410 410 0000 169 90 00 7,850.70 Sewer Fund/IOTB PU1309 410 410 0000 164 91 00 5,019.30 Sewer Fund/Capital Expense Reclass PU1309 410 410 0000 169 90 00 5,019.30 Sewer Fund/IOTB PU1409 410 410 0000 164 91 00 48,417.60 Sewer Fund/Capital Expense Reclass PU1409 410 410 0000 169 90 00 48,417.60 Sewer Fund/IOTB PU1607 410 410 0000 164 91 00 206,671.70 Sewer Fund/Capital Expense Reclass PU1607 410 410 0000 599 69 99 206,671.70 Sewer Fund/IOTB PU1608 410 410 0000 164 91 00 14,049.02 Sewer Fund/Capital Expense Reclass PU1608 410 410 0000 169 90 00 14,049.02 Sewer Fund/IOTB PU1609 410 410 0000 164 91 00 20,091.93 Sewer Fund/Capital Expense Reclass PU1609 410 410 0000 169 90 00 20,091.93 Sewer Fund/IOTB PU1614 410 410 0000 164 91 00 50,518.42 Sewer Fund/Capital Expense Reclass PU1614 410 410 0000 169 90 00 574.92 Sewer Fund/Capital Expense Reclass PU1614 410 410 0000 599 69 99 49,943.50 Sewer Fund/IOTB PU1615 410 410 0000 164 91 00 33,508.77 Sewer Fund/Capital Expense Reclass PU1615 410 410 0000 169 90 00 26,520.57 Sewer Fund/Capital Expense Reclass PU1615 410 410 0000 599 69 99 6,988.20 Sewer Fund/IOTB PU1616 410 410 0000 164 91 00 20,573.21 Sewer Fund/Capital Expense Reclass PU1616 410 410 0000 169 90 00 252.71 Sewer Fund/Capital Expense Reclass PU1616 410 410 0000 599 69 99 20,320.50 Sewer Fund/IOTB PU1709 410 410 0000 164 91 00 6,859.90 Sewer Fund/Capital Expense Reclass PU1709 410 410 0000 599 69 99 6,859.90 Sewer Fund/IOTB PU1710 410 410 0000 164 91 00 9,744.10 Sewer Fund/Capital Expense Reclass PU1710 410 410 0000 599 69 99 9,744.10 Sewer Fund/IOTB PU1713 410 410 0000 164 91 00 6,392.79 Sewer Fund/Capital Expense Reclass PU1713 410 410 0000 599 69 99 6,392.79 Sewer Fund/IOTB PU1714 410 410 0000 164 91 00 31,083.80 Sewer Fund/Capital Expense Reclass PU1714 410 410 0000 599 69 99 31,083.80 Stormwater Fund/IOTB PW1406 470 470 0000 164 91 00 73,538.66 Stormwater Fund/Capital Expense Reclass PW1406 470 470 0000 169 90 00 73,538.66 Stormwater Fund/IOTB PW1411 470 470 0000 164 91 00 192,293.53 Stormwater Fund/Capital Expense Reclass PW1411 470 470 0000 169 90 00 192,293.53 Batch Count:64 Control Total5,838,081.42 5,838,081.42 Explanation:Record FY 2016/2017 completed projects 05/21/18 City of Atlantic Beach CIP - Improvements Other Than Buildings Project Reconciliation Fiscal Year 2017 169.90-00 63-00 164.91-**169.90-00 Project Bal @ 2016 Retainage Completed &Bal @ Fixed Project Description Number 09/30/16 CWIP or Reclass Capitalized 09/30/17 Asset # RUSSELL PK RENOVATION PM1501 249,720.24 - - (249,720.24) - 00002787 BULL PK PLAYGRND EQUIPMT PM1504 16,038.80 11,880.00 - - 27,918.80 DUTTON ISLE RD IMPROVMENT PM1505 7,386.00 - - (7,386.00) - 00002788 NEW POLICE BLDG PS1501 1,159,231.94 2,544,481.51 (3,703,713.45) - 00002791 JORDAN PARK BATHROOMS PM1701 - 5,619.04 - (5,619.04) - 00002760 JORDAN&DONNER ADA PG IMP PM1702 - 118,860.02 - (118,860.02) - 00002762 SHADE STRUCTURE - SS PIER PM1705 - 5,394.48 - (5,394.48) - 00002763 Repair 24" Efflt For Main PU1308 7,850.70 - - (7,850.70) - 00002764 Repair 12" Force Main PU1309 5,019.30 - - (5,019.30) - 00002765 Effluent Pump at WWTP PU1409 48,417.60 - - (48,417.60) - 00002766 Connect A1A @ Mallard Cve PU1410 98,567.00 - - (98,567.00) - 00002767 EFF OUTFALL @ SHERMAN PT PU1504 63.75 528,263.52 - - 528,327.27 SOFT STARTS - WTP1, 2 &3 PU1602 23,263.72 - - (23,263.72) - 00002778 CHLORINE AUTO CONTROL VAL PU1603 25,915.70 - - (25,915.70) - 00002779 CONTROL BUBBLER SYSTEM PU1604 172.16 8,575.29 - (8,747.45) - 00002768 REPLACE SEASPRAY H20 SERV PU1605 97,339.25 - - (97,339.25) - 00002769 SEWER SYSTEM REHAB SEAOAT PU1607 - 206,671.70 - (206,671.70) - 00002770 CONTROL PANEL LIFT STA WW PU1608 14,049.02 - - (14,049.02) - 00002771 SOFTSTARTS LIFT ST. ABC&D PU1609 20,091.93 - - (20,091.93) - 00002780 PHORPHOROUS TREATMENT FAC PU1611 24,832.75 362,110.70 - - 386,943.45 REPLACE EFF PUMP #2 PU1614 574.92 49,943.50 - (50,518.42) - 00002783 REPLACE RAS PUMP & MOTOR PU1615 26,520.57 6,988.20 - (33,508.77) - 00002772 REPLAC INFLUENT PUMP WWTP PU1616 252.71 20,320.50 - (20,573.21) - 00002773 REPLACE H20 SERVICE SEASP PU1703 - 149,105.10 - - 149,105.10 SOFTSTART LIFT STATION E PU1708 - 3,324.63 - - 3,324.63 MARINA L/S PU1709 - 6,859.90 - (6,859.90) - 00002784 REPLACE 4 WETWELL TOPS PU1710 - 9,744.10 - (9,744.10) - 00002774 MASTER LS CONTROL UPGRADE PU1711 - 27,972.44 - - 27,972.44 REPLACE DISK - KRUGER DIS PU1713 - 6,392.79 - (6,392.79) - 00002775 TWO EFFLUENT SCREEN REPLA PU1714 - 31,083.80 - (31,083.80) - 00002776 Robert Street Ditch PW1404 28,854.82 - - (28,854.82) - 00002777 SALTAIR/STURDIVAN SIDEWLK PW1406 173,528.95 - - (173,528.95) - 00002785 SEMINOLE STREET SCAPE PW1407 116,614.70 20,970.99 - - 137,585.69 Marsh Project Ped Path PW1408 105,868.00 2,035.00 - - 107,903.00 SALTAIR DRAINAGE UPGRADE PW1411 192,293.53 - - (192,293.53) - 00002786 FRANCIS AVE DRAINAGE IMPR PW1502 438,040.45 200,056.08 - (638,096.53) - 00002789 MARSH PRESERVE PATH PH 2 PW1603 416,946.70 42,612.67 - - 459,559.37 SIDEWALK AND ST IMP PW1702 - 17,286.73 - - 17,286.73 AQUATIV GARDENS POND IMPR PW1705 - 56,119.32 - - 56,119.32 JASMINE POND BANK RESTORA PW1706 - 15,197.26 - - 15,197.26 SALTAIR DRAINAGE IMP PW1711 - 170,937.98 (13,627.62) - 157,310.36 - - - - - Project Sub-Total 3,297,455.21 4,628,807.25 (13,627.62) (5,838,081.42) 2,074,553.42 G/L Total 3,297,455.21 4,628,807.25 (13,627.62) (5,838,081.42) 2,074,553.42 Difference - - - - - 400 268,569.97 167,758.10 0.00 (253,833.12)182,494.95 410 147,673.25 1,259,675.78 0.00 (460,781.24)946,567.79 470 324,166.56 220,489.53 (13,627.62)(265,832.19)265,196.28 900 2,557,045.43 2,980,883.84 0.00 (4,857,634.87)680,294.40 3,297,455.21 4,628,807.25 (13,627.62)(5,838,081.42)2,074,553.42