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

GL005 - GL Balance
Time run: 8/02/2023 3:29:12 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
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 311127 | Cash at Bank No 1 (Clearing) | 000000 | 000000 | USD | 1682670.83 | -1417157.41 | 265513.42
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 311152 | Cash at Bank No 1 (Non Control) | 000000 | 000000 | USD | -76463.88 | 0 | -76463.88
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 000000 | 000000 | USD | -5871193.72 | 0 | -5871193.72
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300040 | 000000 | USD | 5308196.28 | 0 | 5308196.28
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300121 | 000000 | USD | -60.45 | 0 | -60.45
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 300330 | 000000 | USD | -252.99 | 0 | -252.99
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 320010 | 000000 | USD | -189.55 | 0 | -189.55
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 320325 | 000000 | USD | 393047.89 | 0 | 393047.89
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 330710 | 000000 | USD | 122668.77 | 0 | 122668.77
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 312215 | ICOY Working Capital | 390072 | 000000 | USD | 231322.75 | 0 | 231322.75
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 333210 | Property HFS Non Curr at Cost (Projects) | 000000 | 000000 | USD | 200495097.89 | 1421700.3 | 201916798.19
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 411101 | Trade Creditors - Control Curr | 000000 | 000000 | USD | -96.49 | 96.49 | 0
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 411750 | Accrued Exp (Excl oncost) Curr | 000000 | 000000 | USD | -96.49 | 96.49 | 0
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 411854 | Goods Receipted Not Invoiced (GRNI) | 000000 | 000000 | USD | -10222.49 | -4269.4 | -14491.89
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 422131 | Secured Bank Loan Non Curr - Drawdown | 000000 | 000000 | USD | 0 | -273.49 | -273.49
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 422132 | Secured Bank Loan Non Curr - Repayment | 000000 | 000000 | USD | -90954826.41 | -96.49 | -90954922.9
JAN-23 | 390062 | 445 East Waterside Drive Owner LLC | 0000 | 0000 | 511002 | ICOY - Share Issues | 390061 | 000000 | USD | -2769698.43 | 0 | -2769698.43
Grand Total |  |  |  |  |  |  |  |  |  | -108550000 | 0 | -108550000