Spreadsheet: 829758d1684425122-need-to-add-cells-j9-j16-for-all-icoy-working-capital-inside-ifna-formula-feb23-trial-balances-lse-test
Sheet: 211NHD GL005 FEB

GL005 - GL Balance
Ledger: LL US Ledger | Period Year: 2023 | Period: FEB-23 | CoA Entity: 390072 - 211 North Harbor Drive Owner LLC | Profit Centre: All | Cost Centre: All | Natural Account: All | Counter Party: All | Spare: All | Currency: USD
GL Period | CoA Entity Number | CoA Entity Name | Profit Centre | Cost Centre | Natural Account Number | Natural Account Name | Counter Party | Spare | Opening Balance | Period Net | Closing Balance
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 4001 | 0050 | 111001 | Rev from the Sale of Goods | 000000 | 000000 | -24641399 | -1715000 | -26356399
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 4001 | 0050 | 200102 | Cost of Sales - GPM (Projects) | 000000 | 000000 | 23901759.94 | 1660983.8 | 25562743.74
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 311102 | Cash at Bank No 1 | 000000 | 000000 | -5516.54 | 0 | -5516.54
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 311127 | Cash at Bank No 1 (Clearing) | 000000 | 000000 | 68749648.5 | 1489529.63 | 70239178.13
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 311152 | Cash at Bank No 1 (Non Control) | 000000 | 000000 | -67739120.08 | -1626999.74 | -69366119.82
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 000000 | 000000 | -10544741.58 | 0 | -10544741.58
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300040 | 000000 | 9816644.63 | 0 | 9816644.63
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300121 | 000000 | -299.55 | 0 | -299.55
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300310 | 000000 | -74.59 | 0 | -74.59
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 320010 | 000000 | 559580.76 | 0 | 559580.76
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 320325 | 000000 | 436514.27 | 0 | 436514.27
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 330710 | 000000 | 185677.06 | 0 | 185677.06
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 390062 | 000000 | -231322.75 | 0 | -231322.75
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 333210 | Property HFS Non Curr at Cost (Projects) | 000000 | 000000 | 286031268.46 | -848256.61 | 285183011.85
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411101 | Trade Creditors - Control Curr | 000000 | 000000 | -241 | -191023.4 | -191264.4
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411251 | Unrealised Profit (BS) | 000000 | 000000 | -200000 | 0 | -200000
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411750 | Accrued Exp (Excl oncost) Curr | 000000 | 000000 | -6626951.03 | 398060.82 | -6228890.21
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411854 | Goods Receipted Not Invoiced (GRNI) | 000000 | 000000 | -125917.12 | -353743.52 | -479660.64
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411855 | Project Allocations Clearing | 000000 | 000000 | 0 | -410.24 | -410.24
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 422131 | Secured Bank Loan Non Curr - Drawdown | 000000 | 000000 | -88489404.93 | 1186859.26 | -87302545.67
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 422132 | Secured Bank Loan Non Curr - Repayment | 000000 | 000000 | -8048252.84 | 0 | -8048252.84
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 511002 | ICOY - Share Issues | 390071 | 000000 | -174350000 | 0 | -174350000
FEB-23 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 513101 | Retained Profits O/Bal ([NAME] ICOY prft) | 000000 | 000000 | -8677852.61 | 0 | -8677852.61
Report No: OPR_GL_005 |  |  |  | 1 |  |  |  | Executed: 01-Mar-23 5:21 PM GMT By Shannon Deery