How to Onboard 100 ISP Subscribers in One Day Using Xenfi Billing's Bulk Import Tools

Introduction

One of the biggest operational bottlenecks for growing ISPs in Uganda, Kenya, Ghana, Rwanda, and South Africa is subscriber onboarding. Adding new customers one by one — creating their profile, setting up PPPoE credentials, generating a first invoice, and sending a welcome message — can take 10 to 15 minutes per subscriber. At 100 new subscribers, that is an entire day of manual data entry before a single connection is live.

Xenfi Billing solves this with bulk import tools that allow ISPs to onboard hundreds of subscribers simultaneously using a CSV file. In this guide, we walk through the complete bulk onboarding process — from preparing your subscriber data to creating PPPoE accounts on MikroTik and sending welcome messages to your entire new subscriber base at once. For background on how PPPoE subscriber management works with MikroTik and Xenfi, see our guide on PPPoE Subscriber Management on MikroTik with Xenfi Billing. For a broader overview of the Xenfi platform, visit our Xenfi ISP Billing for East Africa guide.

When Bulk Onboarding Is the Right Approach

Bulk subscriber import is the right approach in several common ISP scenarios:

• Migrating from another billing system — Moving from Radius Manager, a spreadsheet, or another billing platform to Xenfi Billing and needing to import your existing subscriber base
• Launching a new coverage zone — Activating a large group of subscribers who signed up during a pre-registration campaign for a new area
• Onboarding an estate or building — Setting up all units in an apartment block, gated estate, or student hostel at once
• Acquiring another ISP's subscriber base — Migrating customers from an acquired or merged ISP operation
• Seasonal bulk activations — Activating a large batch of subscribers at the start of a semester, financial year, or promotional period

In all these cases, Xenfi's bulk import functionality compresses hours or days of manual work into a single file upload.

Step 1: Prepare Your Subscriber CSV File

The foundation of a successful bulk import is a clean, well-structured CSV file. Xenfi Billing provides a downloadable CSV template from the Subscribers section of your dashboard. The template includes all required and optional fields. For a standard PPPoE subscriber import, the key fields to populate are:

• Full name — Subscriber's first and last name
• Phone number — Used for SMS notifications and mobile money payment links (MTN MoMo, Airtel Money, or M-Pesa)
• Email address — Optional but recommended for invoice email delivery
• Plan name — Must match exactly the plan name configured in your Xenfi plan builder (e.g., “Home-10Mbps” or “Biz-20Mbps”)
• PPPoE username — Unique identifier for each subscriber's router authentication
• PPPoE password — Can be auto-generated by Xenfi or pre-assigned
• Billing start date — The date from which the first billing cycle begins
• Installation address — Physical location of the subscriber connection
• Zone or location — The coverage zone or reseller area the subscriber belongs to (optional)

Data quality tip: Before importing, deduplicate your subscriber list, standardise phone number formats (include country code: +256 for Uganda, +254 for Kenya, +233 for Ghana, +250 for Rwanda, +27 for South Africa), and ensure every plan name in the CSV matches exactly what is configured in Xenfi.

Step 2: Validate Your CSV Before Uploading

A failed import caused by formatting errors wastes time and creates confusion. Before uploading your CSV to Xenfi Billing, run through this pre-upload checklist:

• ✅ All required fields are populated for every row — no blank name, phone, or plan fields
• ✅ Phone numbers include the country code and contain no spaces or special characters
• ✅ Plan names in the CSV exactly match plan names in your Xenfi plan builder
• ✅ PPPoE usernames are unique — no duplicates within the file or against existing subscribers
• ✅ Billing start dates are in the correct format (typically YYYY-MM-DD)
• ✅ The file is saved as a .csv file, not .xlsx or .xls

Xenfi's import tool will flag validation errors row by row if any are detected, allowing you to correct them before the import proceeds.

Step 3: Upload the CSV and Run the Import

Once your file is clean and validated, navigate to Subscribers > Bulk Import in your Xenfi Billing dashboard and upload your CSV. The import tool will:

1. Parse and validate each row in your file
2. Display a preview of the subscribers to be created, with any flagged errors highlighted
3. Allow you to correct errors inline or download a corrected CSV before proceeding
4. On confirmation, create all subscriber profiles simultaneously in your Xenfi account
5. Generate first invoices for all new subscribers based on their billing start dates

For a well-prepared file of 100 subscribers, the import and invoice generation process typically completes in under five minutes.

Step 4: Bulk PPPoE Account Creation on MikroTik

With subscriber profiles created in Xenfi, the next step is pushing PPPoE credentials to your MikroTik router. If your MikroTik router is already connected to Xenfi via the API, this happens automatically — Xenfi creates the PPPoE secrets for all newly imported subscribers on the router simultaneously, with the correct speed profile assigned based on each subscriber's plan. For a detailed walkthrough of the MikroTik-Xenfi API integration and PPPoE configuration, see our guide on PPPoE Subscriber Management on MikroTik with Xenfi Billing.

To verify the bulk PPPoE creation was successful:

• Log into your MikroTik router via Winbox or web interface
• Navigate to PPP > Secrets and confirm the new subscriber usernames appear with the correct profiles
• Test one or two subscriber logins to confirm authentication and speed enforcement are working correctly

If any PPPoE accounts were not created due to a connectivity issue, Xenfi Billing logs the failed API calls so you can identify and retry them individually.

Step 5: Send Bulk Welcome Messages to New Subscribers

Once subscribers are in the system and their PPPoE accounts are live on the router, the final step is notifying them. Xenfi Billing allows you to send a bulk SMS to all newly imported subscribers simultaneously. A well-crafted welcome message includes:

• A welcome greeting and confirmation that their connection is now active
• Their PPPoE username and password (for subscribers who need to configure their router)
• Their first invoice amount and due date with a mobile money payment link
• The URL of the Xenfi subscriber self-service portal and how to log in
• A support contact for any connection issues

Example welcome SMS template:

“Welcome to [ISP Name]! Your internet is now active. Username: [PPPoE username]. Your first invoice of [amount] is due on [date]. Pay here: [payment link]. Manage your account at: [portal link]. Support: [phone number].”

Sending this message to 100 subscribers takes seconds in Xenfi — no individual messages required.

Timeline: Onboarding 100 Subscribers in One Day

Here is a realistic timeline for a bulk onboarding of 100 subscribers using Xenfi Billing:

• Morning (2–3 hours): Collect and clean subscriber data, populate the CSV template, validate all fields
• Mid-morning (30 minutes): Upload CSV to Xenfi, review import preview, confirm and run the import
• Mid-morning (15 minutes): Verify bulk PPPoE account creation on MikroTik, test 2–3 subscriber logins
• Late morning (15 minutes): Send bulk welcome SMS to all 100 new subscribers via Xenfi
• Afternoon: Handle any subscriber calls about connection setup or invoice queries — most are resolved via the self-service portal

Total active staff time: approximately 3–4 hours. Without Xenfi's bulk tools, the same task would take 2–3 full working days of manual data entry.

Best Practices for Bulk Subscriber Onboarding

• Always use the Xenfi CSV template — Do not create your own column structure; use the official template to ensure field mapping is correct.
• Import in batches of 100–200 — For very large imports (500+), break the file into batches to make error identification and correction easier.
• Set billing start dates strategically — If onboarding on the 15th of the month, consider setting billing start dates to the 1st of the following month to avoid complex proration for your first billing cycle.
• Test with 5 subscribers first — Before importing 100, run a test import of 5 subscribers to confirm your CSV format, plan names, and MikroTik integration are all working correctly.
• Keep a backup of your import CSV — Save a copy of every bulk import file with a date stamp for audit and troubleshooting purposes.

Conclusion

Bulk subscriber onboarding is one of the highest-leverage operational capabilities an ISP can have. The ability to activate 100 new subscribers in a single morning — with invoices generated, PPPoE accounts live on MikroTik, and welcome messages sent — is what separates ISPs that scale from those that stay small. Once your subscribers are onboarded, keeping them is equally important — read our guide on How to Reduce ISP Churn in Uganda for retention strategies that work alongside your billing automation. Xenfi Billing's bulk import tools make this a routine capability for ISPs across Uganda, Kenya, Ghana, Rwanda, and South Africa, regardless of technical team size.

Ready to onboard your next batch of subscribers in hours, not days? Visit Xenfi Billing to get started.

Frequently Asked Questions (FAQ)