Past Cashflow Report
Past Cashflow Report in Frappe Lending provides a detailed view of repayments received from borrowers up to a selected date. It helps lenders review historical cash flows by showing loan-wise payment details and the allocation of collected amounts.
The report provides visibility into repayment history, including amounts received toward principal, interest, additional interest, charges, penalties, and excess payments, helping users analyze borrower payment patterns.
Did You Know?
Past Cashflow Report helps lenders understand how much has been collected from borrowers and how repayments have been allocated across different loan components.
Accessing Past Cashflow Report
The Past Cashflow Report can be accessed from the Reports section in Frappe Lending.
Home > Lending > Reports > Past Cashflow ReportPurpose of Past Cashflow Report
The report helps users review historical repayment transactions and analyze borrower cash flows.
Key uses include:
- Reviewing repayment history up to a selected date.
- Tracking total amounts collected from borrowers.
- Understanding repayment allocation across loan components.
- Analyzing borrower payment behavior.
Information Available in the Report
The report provides loan-wise repayment details, including:
| Component | Description |
|---|---|
| Applicant Name | Displays the borrower associated with the loan. |
| Loan Product | Shows the loan product linked with the repayment records. |
| Principal Paid | Displays the amount collected toward the outstanding loan principal. |
| Interest Paid | Shows the interest amount collected from the borrower. |
| Additional Interest | Tracks any additional interest amounts collected as part of repayment. |
| Charges | Displays additional loan-related charges collected from the borrower. |
| Penalties | Shows penalty amounts collected due to overdue payments or other conditions. |
| Excess Payments | Displays amounts received beyond the required repayment amount. |
Cashflow Tracking
The Past Cashflow Report helps lenders understand the movement of collected amounts by separating repayments into different categories.
| Repayment Category | Purpose |
|---|---|
| Principal | Tracks the portion of repayment used to reduce the loan balance. |
| Interest | Tracks income generated from lending activities. |
| Charges and Penalties | Provides visibility into additional amounts collected from borrowers. |
| Excess Payment | Identifies additional amounts received beyond scheduled dues. |
Report Filtering
Users can generate the report based on a selected date to review repayments received up to that point.
This helps in:
- Comparing collections over different periods.
- Reviewing historical repayment performance.
- Analyzing loan-wise cash realization.
Note
The report reflects repayments made on or before the selected date, providing a historical view of borrower cash flows.
Best Practices
- Use the report regularly to review borrower repayment history.
- Analyze repayment allocation across principal, interest, and charges.
- Compare cash collections with loan portfolio performance.
- Review excess payments to ensure proper adjustment handling.
