Access your Back Office at your fingertips.
Download the app now on Google Play Store.
Scan the QR code
You can also scan QR code with your phone to download the app.
How to onboard customers in bulk with Lendsqr
Updated
On this page
Introduction
Bulk customer onboarding allows lenders to create multiple customer profiles at once by uploading a single structured file. Instead of entering each customer manually, you prepare an .xlsx file containing customer data and upload it to the platform in one action. This reduces onboarding time significantly and ensures that customer data is captured in a consistent format across the entire organization.
For lenders managing large volumes of customers, manual onboarding is inefficient and prone to errors such as missing fields, inconsistent formatting, and duplicate entries. Bulk onboarding addresses this by standardizing the intake process and enabling batch processing of customer records in a controlled and auditable way.
This feature is particularly useful for lenders migrating from offline systems, onboarding customers through agents or partner networks, digitizing cooperative or group lending structures, and preparing customer data ahead of new product launches. It also ensures that customer records are properly structured for downstream processes such as decisioning, scoring, loan disbursement, and repayment tracking.
Common use cases
Bulk onboarding is typically used in scenarios where speed, scale, and consistency are required.
Microfinance institutions often use it to digitize legacy customer records that previously existed in paper or offline systems. Agent banking networks use it to upload customer data collected in the field after onboarding sessions. Cooperatives and thrift organizations use it to onboard members in batches rather than individually. Fintechs launching new loan products use it to pre-load customers into the system before going live. It is also commonly used during system migration when switching from an existing loan management platform to Lendsqr.
In all these cases, the goal is to reduce operational effort while ensuring that customer data is structured correctly and ready for automated processing.
Log in to your Lendsqr admin console and, from the left sidebar, expand Bulk operations, then select Bulk Customer Creation. This page lists every batch you have uploaded, with its date, batch ID, and customer count, and is where you both start a new upload and review past ones.
Step 2: Download the sample template
Click More actions at the top of the page, then select Download Sample. This gives you a pre-formatted Excel template with all required fields already structured in the correct format. The same menu also has Export Excel and Export CSV options for exporting previously uploaded batches.
If this is your first time using the feature or you are unsure about formatting, always start by downloading the sample template to avoid errors.
Step 3: Populate the template
Use the downloaded .xlsx file as the foundation for your upload. This ensures that column names, formatting rules, and system requirements are already correctly defined.
Populate the file with your customer data, ensuring that each row represents a unique customer and each column contains the correct data type.
There are strict system limits that must be observed during preparation. Each upload can contain a maximum of 120 records, and the file size must not exceed 1MB. The file must also remain in .xlsx format, as other formats such as .csv or .xls are not supported.
While filling the template, ensure that all required fields are completed accurately. Missing or incorrectly formatted data can result in validation errors or partial upload failures.
Template format requirements
The upload template must follow a strict structure to ensure successful processing. Each field plays a specific role in customer creation and system integration.
The required fields include email, which is used for customer communication and account identification. Phone number, which must be in international format, is used for verification and communication. Date of birth must follow the yyyy/mm/dd format to ensure consistency across systems.
The BVN field is used for identity verification and must match official banking records. The BVN phone number should correspond to the phone number linked to the BVN to ensure identity consistency. Account number is required for financial transactions and repayment processing.
Bank code refers to the NIP code of the customer’s bank and must be valid to ensure successful payment routing. Branch ID is used internally to assign the customer to the correct operational branch or unit.
Incorrect formatting in any of these fields can lead to rejection of individual records or failure of the entire upload batch, depending on system configuration.
Template format (xlsx only)
Your upload file must be in xlsx format and must include the following fields:
Field name
Description
email
Customer’s email address.
phone_number
Customer’s phone number in international format (e.g., 234…).
date_of_birth
Customer’s date of birth in yyyy/mm/dd format.
bvn
Customer’s Bank Verification Number.
bvn_phone_number
Phone number registered with the customer’s BVN.
account_number
Customer’s bank account number.
bank_code
NIP bank code for the customer’s bank.
branch_id
Internal branch identifier (if applicable).
Step 4: Upload the completed file
Once the template has been fully populated, return to the Bulk Customer Creation page and click Upload Customers. This opens a dialog where you can browse for or drag and drop the completed .xlsx file, then click Upload.
After upload, the system processes the file and creates a new batch, which appears at the top of the history table on the Bulk Customer Creation page. Its status and per-customer results are available from there, covered in Step 6 below.
Step 5: View batch details and processing results
On the Bulk Customer Creation page, find your batch in the history table using its batch ID or upload date, then click the three-dot (more-icon) menu next to it and select View Details.
The batch detail page shows a summary of total customers, successful, pending, and failed counts for that batch, so you can see the overall outcome at a glance.
Below that, an Approval Workflow timeline shows who initiated the batch and when. If your organization has an approval workflow enabled, the batch is routed to an approver before customers are officially created, and each stage of that review appears in this timeline. If no workflow is configured, the upload is processed directly.
For records that fail, the system records the failure against that customer within the batch, allowing you to identify and correct issues and re-upload only the affected entries instead of repeating the entire batch. This level of granularity helps teams resolve data issues without disrupting the rest of the onboarding process.
Tips for a successful upload
Always use the official sample template as your starting point. This ensures that formatting, column structure, and system requirements remain intact.
Do not modify column names, delete required fields, or change the order of columns, as this can cause validation failures during upload.
Ensure all identity fields such as BVN, phone numbers, and bank codes are accurate and verified before uploading. These fields are critical for downstream verification and transaction processing.
Keep each batch within the recommended limits to avoid performance issues or partial processing.
Perform internal validation before uploading to reduce errors during system processing.
Common errors and how to fix them
One common issue is uploading files in unsupported formats, such as .csv or .xls. The system only accepts .xlsx files, so ensure the file is saved correctly before uploading.
Another frequent issue is missing or renamed columns. If headers are modified, the system may not recognize the data structure. Always use the original template without alterations.
Incorrect BVN or bank codes can also cause record failures. These should be validated against official banking records before upload.
Exceeding the maximum number of records per upload can result in partial processing or rejection. In such cases, split the file into smaller batches and re-upload.
Formatting errors in dates or numeric fields can also trigger validation failures, so ensure consistency across all rows.
Best practices for bulk onboarding
Establish a standardized data collection process before onboarding customers. This reduces inconsistencies and improves data quality.
Validate customer data at the source before it is entered into the upload file. This includes identity checks, phone number verification, and confirmation of banking details.
Use batch uploads strategically rather than mixing unrelated customer groups in a single file. This improves traceability and simplifies troubleshooting.
Monitor upload history regularly to identify recurring data issues and improve upstream data quality.
Restrict bulk upload permissions to authorized users only to maintain control and prevent unauthorized customer creation.
Conclusion
Bulk customer onboarding in Lendsqr provides a scalable and efficient way to create large volumes of customer profiles while maintaining data consistency and operational control.
By following the correct process, using validated templates, and adhering to best practices, lenders can significantly reduce manual effort and improve onboarding accuracy.
When implemented properly, bulk onboarding becomes a foundational tool for scaling lending operations, improving data quality, and ensuring readiness for automated credit decisioning and disbursement workflows.
