Loan Statement of Account
Loan Statement of Account in Frappe Lending provides a transaction-wise view of a borrower’s loan activity for a selected period. It combines loan disbursements, demands, and repayments into a single timeline, helping users understand how the loan balance changes over time.
The report displays debit, credit, and running balance details for each transaction, making it useful for borrower-level reconciliation and reviewing complete loan movement history.
Did You Know?
Loan Statement of Account provides a complete financial trail of loan transactions, helping lenders and borrowers track balance changes throughout the loan lifecycle.
Accessing Loan Statement of Account
The Loan Statement of Account report can be accessed from the Reports section in Frappe Lending.
Home > Lending > Reports > Loan Statement of AccountPurpose of Loan Statement of Account
The report helps users review and reconcile loan-related transactions by providing a chronological view of all financial movements.
Key uses include:
- Reviewing complete loan transaction history.
- Tracking how the outstanding loan balance changes over time.
- Reconciling borrower-level loan activity.
- Verifying disbursements, demands, and repayments.
Transactions Covered in the Report
The Loan Statement of Account combines multiple loan activities into a single timeline.
| Transaction Type | Description |
|---|---|
| Loan Disbursement | Shows the amount released to the borrower and added to the loan account. |
| Loan Demand | Displays scheduled dues generated for principal, interest, and other applicable amounts. |
| Loan Repayment | Shows payments received from the borrower and their impact on the outstanding balance. |
Information Available in the Report
The report provides transaction-level details including:
| Field | Description |
|---|---|
| Transaction Date | Displays the date associated with each loan transaction. |
| Transaction Type | Identifies whether the entry is a disbursement, demand, repayment, or other loan activity. |
| Debit Amount | Shows amounts increasing the loan balance. |
| Credit Amount | Shows amounts reducing the loan balance. |
| Running Balance | Displays the updated outstanding balance after each transaction. |
Loan Balance Tracking
The report provides a chronological view of loan movements, allowing users to understand how the outstanding balance evolves.
| Activity | Impact on Loan Balance |
|---|---|
| Disbursement | Increases the outstanding loan amount. |
| Demand Generation | Records scheduled dues against the borrower. |
| Repayment | Reduces outstanding dues based on payment allocation. |
Report Period Selection
Users can generate the Loan Statement of Account for a specific period to review transactions within the selected date range.
This helps in:
- Analyzing historical loan activity.
- Preparing borrower statements.
- Reconciling loan balances.
- Reviewing repayment and outstanding trends.
Note
The running balance is calculated based on the sequence of loan transactions recorded within the selected reporting period.
Best Practices
- Review loan statements regularly for transaction accuracy.
- Use the report for borrower reconciliation and account verification.
- Check transaction timelines when investigating balance differences.
- Maintain accurate loan transaction records for reliable reporting.
