Q: How can we create a report which identifies all of the unpaid payments?
A: I would create and run a Transaction report.
1. Create a New report template. On the top right, pick up at least the Unpaid Pmt Line status (there could be other Unpaid Pmt Line statuses).
2. On the left from the “Transaction Data” theme, pick up at least Line Status, Pmt Date and Expected Pmt. I also included the Outstanding amount balance that will appear on each transaction.
3. Then add the loan identifiers such as loan ID, Borrower data, etc. (I moved them up for the report with the arrows on the right). You could also add an email, phone number, etc. so collectors can easily reach these clients. You could also email these clients directly in Margill (or automate the process, but I will not cover this here).
I called my report “Unpaid Pmts”. Run it for the desired loans and period. I ran mine for January 2024:
I have 4 unpaid payments. Notice the Outstanding amount on loans 10104 and 10392. This shows that these are bad payers since the Outstanding (balance) is higher than the current unpaid payment. You can show totals and export to Excel or other.