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

GL Period | User Source Name | User Category Name | CoA Entity Number | Profit Centre | Cost Centre | Natural Account | Counter Party | Spare | Journal [NAME] | Journal [NAME] | Journal Line Number | Journal Line Amount | Project Name | Project Number | Task Number | Expenditure Type | Event Type | Supplier Or [NAME] | Transaction Number | Transaction Description | SLA Amount | Accounted Amount | GST Amount
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14336206 49374275 | JUL-22 Payments USD | 83 | -445.75 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14011 | Finance Other |  | 445 East Waterside Drive Owner LLC | 220718_kxxs162_P01_Bank Fees Invoice_01 | Service Chgs/ July 2022/445 East Waterside Drive | -445.75 | -445.75 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14326656 49306444 | JUL-22 Payments USD | 43 | 519.87 |  |  |  |  |  | 445 East Waterside Drive Owner LLC | 220607_kxxs162_P12_Bank Fees Invoice_02 | Service Chgs/ June 2022/445 East Waterside Drive | 519.87 | 519.87 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14335693 49376994 | JUL-22 Payments USD | 37 | -113902.26 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18500 | Other Recovered |  | 445 East Waterside Drive Owner LLC | 06225513 | Reimburse Cascade Operations for Utilities | -73693.26 | -73693.26 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14335693 49376994 | JUL-22 Payments USD | 37 | -113902.26 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14021 | Finance Line Fees |  | CIBC Bank USA | [PHONE] | 3 Months of Loan Admin Fees - Cascade | -10000 | -10000 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14335693 49376994 | JUL-22 Payments USD | 37 | -113902.26 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18096 | Consultants Gen Allowable |  | Knightsbridge Strategies Ltd | 11312 | Knightsbridge CO1 - Bldg KL | -12520 | -12520 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14335693 49376994 | JUL-22 Payments USD | 37 | -113902.26 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18101 | Consultants Gen Allowable |  | [NAME] | 30379 | KL Public Relations - Original Contract | -3400 | -3400 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14335693 49376994 | JUL-22 Payments USD | 37 | -113902.26 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18083 | Consultants Gen Allowable |  | Span Studio LLC | 989 | CO #06 | -14289 | -14289 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14340409 49428523 | JUL-22 Payments USD | 90 | -282602.55 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18104 | Consultants Gen Allowable |  | Lendlease Development Inc. | 440172 | Cascade Marketing CC Reimbursables | -2052.64 | -2052.64 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14340409 49428523 | JUL-22 Payments USD | 90 | -282602.55 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14043 | Fees Development Management |  | Lendlease Platform Development LLC | 060122A | LL Portion of KL DM Fee - Apr-Jun 2022 | -205915.29 | -205915.29 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14340409 49428523 | JUL-22 Payments USD | 90 | -282602.55 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14043 | Fees Development Management |  | Magellan Project Services II LLC | 060122 | MDG's Portion DM Fees - Bldg KL - Apr-Jun 2022 | -68638.43 | -68638.43 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14340409 49428523 | JUL-22 Payments USD | 90 | -282602.55 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18085 | Consultants Gen Allowable |  | H.M. Witt & Co. Signs | 83041 | CO #002 - Cascade - HM Witt | -5996.19 | -5336.19 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14340409 49428523 | JUL-22 Payments USD | 90 | -282602.55 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18085 | Consultants Gen Allowable |  | H.M. Witt & Co. Signs | 83041 | True up KL's contract | -5996.19 | -660 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14340592 49443444 | JUL-22 Payments USD | 20 | 268811.94 |  |  |  |  |  | 445 East Waterside Drive Owner LLC | 220722_Halp143_LSE_Loan_Interest_02 | 445EWD - JUL 2022 Interest | 268811.94 | 268811.94 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14307644 49187542 | JUL-22 Payments USD | 32 | -13545 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18101 | Consultants Gen Allowable |  | [NAME] | 30305 | CO #002 - Cascade | -3545 | -3545 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14307644 49187542 | JUL-22 Payments USD | 32 | -13545 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14021 | Finance Line Fees |  | CIBC Bank USA | [PHONE] | 3 Months of Loan Admin Fees - Cascade | -10000 | -10000 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14335388 49347842 | JUL-22 Payments USD | 94 | -519.87 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14011 | Finance Other |  | 445 East Waterside Drive Owner LLC | 220607_kxxs162_P12_Bank Fees Invoice_01 | Service Chgs/ June 2022/445 East Waterside Drive | -519.87 | -519.87 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14340575 49442132 | JUL-22 Payments USD | 53 | 14132.15 |  |  |  |  |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-1 | Project Allocations Clearing 411855 - Building KL Loan Funding 19 - Cap Call 45 | 14132.15 | 14132.15 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14335540 49360716 | JUL-22 Payments USD | 29 | 445.75 |  |  |  |  |  | 445 East Waterside Drive Owner LLC | 220718_kxxs162_P01_Bank Fees Invoice_02 | Service Chgs/ July 2022/445 East Waterside Drive | 445.75 | 445.75 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14307853 49219491 | JUL-22 Payments USD | 96 | -20558.17 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC18094 | Media - All |  | Lendlease Development Inc. | 070722 | Reimburse LLD for Credit Card Charges - Bldg KL - Draw 43 | -12228.17 | -12228.17 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Payables A 14307853 49219491 | JUL-22 Payments USD | 96 | -20558.17 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC31604 | Consultants Gen Allowable |  | Everywhere Wireless LLC | 6261 | Everywhere Wireless - Bldg KL | -8330 | -8330 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC14012 | Finance Line Fees |  | 445 East Waterside Drive Owner LLC | 220722_Halp143_LSE_Loan_Interest_01 | 445EWD - JUL 2022 Interest | -268811.94 | -268811.94 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC15051 | Consultants Gen Allowable |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-2 | Akerman LLP - Legal Services Re: PD Issues - Draw #45 | -14132.15 | -545 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC15051 | Consultants Gen Allowable |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-2 | Akerman LLP - Legal Services Re: PD Issues - Draw #45 | -14132.15 | -1611.5 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC15051 | Consultants Gen Allowable |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-2 | Akerman LLP - Legal Services Re: PD Issues - Draw #45 | -14132.15 | -2213.75 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC15051 | Consultants Gen Allowable |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-2 | Levenfeld Pearlstein LLC - REA & Related Legal Matters - Draw #45 | -14132.15 | -6031 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC15051 | Consultants Gen Allowable |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-2 | Levenfeld Pearlstein LLC - REA & Related Legal Matters - Draw #45 | -14132.15 | -3245.4 | 0
JUL-22 | Payables | Payments | 390062 | 0000 | 0000 | 312215 | 320010 | 000000 | Payables A 14341924 49471736 | JUL-22 Payments USD | 101 | -282944.09 | PRJ LCHI LSE Bldg KL GSC | 260765 | GSC15051 | Consultants Gen Allowable |  | 445 East Waterside Drive Owner LLC | 220721_HALP143_eInvoice LSE Draw 45 Loan_19-2 | Levenfeld Pearlstein LLC - REA & Related Legal Matters - Draw #45 | -14132.15 | -485.5 | 0
JUL-22 | Payables | Purchase Invoices | 390062 | 0000 | 0000 | 311152 | 000000 | 000000 | Payables A 14327782 49346363 | JUL-22 Purchase Invoices USD | 48 | -445.75 |  |  |  |  |  | 445 East Waterside Drive Owner LLC | 220718_kxxs162_P01_Bank Fees Invoice_02 | Service Chgs/ July 2022/445 East Waterside Drive | -445.75 | -445.75
JUL-22 | Payables | Purchase Invoices | 390062 | 0000 | 0000 | 311152 | 000000 | 000000 | Payables A 14307916 49229406 | JUL-22 Purchase Invoices USD | 50 | -519.87 |  |  |  |  |  | 445 East Waterside Drive Owner LLC | 220607_kxxs162_P12_Bank Fees Invoice_02 | Service Chgs/ June 2022/445 East Waterside Drive | -519.87 | -519.87
JUL-22 | Receivables | Receipts | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Receivables A 14327935 49361206 | JUL-22 Receipts USD | 8 | 389999.17 |  |  |  |  |  |  | 370538966-Near North National |  | 389999.17 | 389999.17
JUL-22 | Receivables | Receipts | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Receivables A 14335682 49374953 | JUL-22 Receipts USD | 8 | -389999.17 |  |  |  |  |  |  | 370538966-Near North National |  | -389999.17 | -389999.17
JUL-22 | Receivables | [NAME] | 390062 | 0000 | 0000 | 311127 | 000000 | 000000 | Receivables A 14335682 49374953 | JUL-22 [NAME] | 1 | 389999.17 |  |  |  | Multiple |  |  | 370538966 | Per [NAME] email on 7/21/22 | 389999.17 | 389999.17