I would like to generate a loan balance summary report where I can see the opening balance of the various loans, loan disburse for the period, interest accrued for the period, repayments made during the period and the closing balance at the end of the period, for all the loans.
I would like to group this report by loan applicant. I would also like to be able to filter by date, applicant and loan type. Essentially, I am looking for a report similar to the accounts receivable summary but for loans and not trade.