Loading...
AJE 4147 CIP AdditionsHTE info Group type (F4)AJ Adjusting journal Group date 09/30/17 Accounting period 13 Accounting year 2017 Group description Record FY 2014 CIP Additons Create document N (Y=Yes; N=No) Count entered 32 Debit amount entered 1,394,188.72 Credit amount entered 1,394,188.72 Transaction date 09/30/17 Page:1 1 Group number 4147 Fund/Account Name Project #Account number Debit Credit Water Fund/CIP PU1703 400 0000 169 90 00 149,105.10 Water Fund/Capital Expense Reclass PU1703 400 0000 599 69 99 149,105.10 Water Fund/CIP PW1407 400 0000 169 90 00 10,077.71 Water Fund/Capital Expense Reclass PW1407 400 0000 599 69 99 10,077.71 Sewer Fund/CIP PU1504 410 0000 169 90 00 528,263.52 Sewer Fund/Capital Expense Reclass PU1504 410 0000 599 69 99 528,263.52 Sewer Fund/CIP PU1611 410 0000 169 90 00 362,110.70 Sewer Fund/Capital Expense Reclass PU1611 410 0000 599 69 99 362,110.70 Sewer Fund/CIP PU1708 410 0000 169 90 00 3,324.63 Sewer Fund/Capital Expense Reclass PU1708 410 0000 599 69 99 3,324.63 Sewer Fund/CIP PU1711 410 0000 169 90 00 27,972.44 Sewer Fund/Capital Expense Reclass PU1711 410 0000 599 69 99 27,972.44 Storm Fund/CIP PW1407 470 0000 169 90 00 679.65 Storm Fund/Capital Expense Reclass PW1407 470 0000 599 69 99 679.65 Storm Fund/CIP PW1705 470 0000 169 90 00 56,119.32 Storm Fund/Capital Expense Reclass PW1705 470 0000 599 69 99 56,119.32 Storm Fund/CIP PW1706 470 0000 169 90 00 15,197.26 Storm Fund/Capital Expense Reclass PW1706 470 0000 599 69 99 15,197.26 Storm Fund/CIP PW1711 470 0000 169 90 00 134,865.68 Storm Fund/Capital Expense Reclass PW1711 470 0000 599 69 99 134,865.68 GFA/CIP PM1504 900 0000 169 90 00 11,880.00 GFA/Capital Expense Reclass PM1504 900 0000 599 69 99 11,880.00 GFA/CIP PW1407 900 0000 169 90 00 10,213.63 GFA/Capital Expense Reclass PW1407 900 0000 599 69 99 10,213.63 GFA/CIP PW1408 900 0000 169 90 00 2,035.00 GFA/Capital Expense Reclass PW1408 900 0000 599 69 99 2,035.00 GFA/CIP PW1603 900 0000 169 90 00 42,612.67 GFA/Capital Expense Reclass PW1603 900 0000 599 69 99 42,612.67 GFA/CIP PW1702 900 0000 169 90 00 17,286.73 GFA/Capital Expense Reclass PW1702 900 0000 599 69 99 17,286.73 GFA/CIP PW1711 900 0000 169 90 00 22,444.68 GFA/Capital Expense Reclass PW1711 900 0000 599 69 99 22,444.68 Batch Count:32 Control Total 1,394,188.72 1,394,188.72 Explanation:Record FY 2016/2017 CIP Additions Prepared by: 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