Capspace
Loan Register
Upload the monthly Capspace Loans statement. Outputs a per-entity sheet with Entity, Borrower, Balance, Interest, and Reserve extracted into a single workbook.
How it works
Inputs
The monthly Capspace Loans statement workbook.
.xlsx
→
Process
Extracts Entity, Borrower, Balance, Interest, Reserve columns. Groups rows by entity into per-entity sheets.
→
Output
A workbook with one sheet per entity.
Loan_Register_Extracted.xlsx
Run it