Loan Import
Loan Import allows organizations to migrate existing or closed loan records from another system into Frappe Lending. A dedicated import template helps structure historical loan data correctly, including loan details, disbursements, outstanding balances, and repayment information.
In Frappe Lending, Loan Import works through the standard Data Import feature, allowing users to migrate historical loan records while maintaining accurate loan history and accounting information.
Available From Version 16 Onwards
Loan Import functionality is available from Frappe Lending version 16 onwards for migrating existing and closed loan records.
Prerequisites
Before importing loans, ensure the following records are already available in the system:
- Loan Product with complete configuration, including accounting accounts such as Loan, Payment, Interest Income, and other required accounts.
- Company
- Applicant (Customer or Employee)
Note
All required master records must exist before importing loans to ensure successful mapping during the migration process.
Preparing Data for Import
To migrate historical loans, download and complete the Loan Import template before uploading it through Data Import.
Downloading the Template
- Open Data Import.
- Select Loan as the Document Type.
- Download the Loan Import template.
- Fill in the required loan details and migration-specific fields.
The template includes standard Loan fields along with additional migration fields prefixed with “Loan Import Details”.
Key Fields for Loan Import
| Field | Description |
|---|---|
| Migration Date | Mandatory field for migrated loans. It defines the cut-off date from which historical loan data is considered. |
| Loan Import Details | Contains historical loan information such as disbursement details and opening outstanding amounts. |
| Opening Outstanding Amounts | Includes outstanding principal, interest, penalties, charges, and other amounts as of the migration date. |
Uploading and Importing Loan Data
Once the import file is prepared:
- Upload the completed CSV file through Data Import.
- Enable the Submit After Import option.
- Start the import process.
Note
Enabling Submit After Import automatically submits the created Loan documents after successful migration.
How the System Processes Imported Loans
After importing loan records, Frappe Lending processes them based on their current loan status.
| Loan Status | System Behaviour |
|---|---|
| Closed | Creates a Loan record with the provided Migration Date. No repayment schedules, demands, or interest accrual entries are generated. |
| Disbursed or Active | Creates complete loan history when Loan Import Details are provided, including opening balances, disbursements, repayment schedules, demands, and interest accruals. |
Records Created During Loan Migration
For active or disbursed loans with import details, the system automatically creates:
- Opening Loan Balance – Records the outstanding loan balance as of the migration date.
- Loan Disbursement – Creates historical disbursement records.
- Loan Repayment Schedule – Generates future repayment schedules based on loan terms.
- Loan Demands – Creates outstanding principal, interest, penalty, and charge demands.
- Loan Interest Accruals – Generates accrual entries for outstanding interest amounts.
Importing Repayments for Migrated Loans
After successfully migrating loans, historical repayment transactions can also be imported using the standard Data Import feature for the Loan Repayment document type.
This allows organizations to migrate complete repayment history and maintain accurate loan transaction records in Frappe Lending.
Benefits of Loan Import
| Benefit | Description |
|---|---|
| Historical Data Migration | Move existing loan records from legacy systems into Frappe Lending. |
| Accurate Loan Balances | Maintain opening outstanding amounts and migration-specific details. |
| Complete Loan History | Recreate loan transactions including disbursements, schedules, and accruals. |
| Faster System Adoption | Reduce manual entry while transitioning from an existing lending system. |
Best Practices
- Verify all master records before starting the import process.
- Ensure migration dates accurately represent the historical cut-off point.
- Validate opening outstanding balances before importing loan records.
- Test the import process with sample data before migrating complete loan portfolios.
