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

GL005 - GL Balance
Time run: 9/08/2022 4:05:18 AM
GL Period | CoA Entity Number | CoA Entity Name | Profit Centre | Cost Centre | Natural Account Number | Natural Account Name | Counter Party | Spare | Currency Code | Opening Balance | Period Net | Closing Balance | Development Adjustments | Adjusted Closing Balance | Comments
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 4001 | 0050 | 111001 | Rev from the Sale of Goods | 000000 | 000000 | USD | 0 | -5429279 | -5429279 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 4001 | 0050 | 200102 | Cost of Sales - GPM (Projects) | 000000 | 000000 | USD | 0 | 4470458.48 | 4470458.48 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 311102 | Cash at Bank No 1 | 000000 | 000000 | USD | -5516.54 | 0 | -5516.54
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 311127 | Cash at Bank No 1 (Clearing) | 000000 | 000000 | USD | 44992737.7 | 4946674.28 | 49939411.98
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 311152 | Cash at Bank No 1 (Non Control) | 000000 | 000000 | USD | -44391726.22 | -913.84 | -44392640.06
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 000000 | 000000 | USD | -10544741.58 | 0 | -10544741.58 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300040 | 000000 | USD | 9816644.63 | 0 | 9816644.63 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300121 | 000000 | USD | -26.9 | -238.5 | -265.4 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300310 | 000000 | USD | -74.59 | 0 | -74.59 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 320010 | 000000 | USD | 559580.76 | 0 | 559580.76 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 320325 | 000000 | USD | 436514.27 | 0 | 436514.27 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 330710 | 000000 | USD | 185677.06 | 0 | 185677.06 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 390062 | 000000 | USD | -231322.75 | 0 | -231322.75 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 333210 | Property HFS Non Curr at Cost (Projects) | 000000 | 000000 | USD | 295816876.2 | -1081197.37 | 294735678.83 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411101 | Trade Creditors - Control Curr | 000000 | 000000 | USD | -10000 | 10000 | 0 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411750 | Accrued Exp (Excl oncost) Curr | 000000 | 000000 | USD | -8220341.04 | -300865.94 | -8521206.98 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 411854 | Goods Receipted Not Invoiced (GRNI) | 000000 | 000000 | USD | -62756.15 | -49547.27 | -112303.42 | 0
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 422131 | Secured Bank Loan Non Curr - Drawdown | 000000 | 000000 | USD | -100305752.37 | -2173301.68 | -102479054.05 | 1
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 422132 | Secured Bank Loan Non Curr - Repayment | 000000 | 000000 | USD | -5007919.87 | -391789.16 | -5399709.03 | 2
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 511002 | ICOY - Share Issues | 390071 | 000000 | USD | -174350000 | 0 | -174350000 | 3
JUL-22 | 390072 | 211 North Harbor Drive Owner LLC | 0000 | 0000 | 513101 | Retained Profits O/Bal ([NAME] ICOY prft) | 000000 | 000000 | USD | -8677852.61 | 0 | -8677852.61 | 4
Grand Total