How to Send Monthly Staff Airtime and Data Allowances Automatically in Nigeria
A staff airtime allowance is one of the cheapest benefits an employer can offer and one of the most tedious to administer. The usual approaches all cost more in admin than the airtime costs in naira:
- Handing out printed recharge cards, and losing a few.
- Reimbursing people who top up themselves, against WhatsApp screenshots.
- One person sending transfers all morning on the 28th of every month.
None of these produce a record your finance team can reconcile, and all of them depend on somebody remembering.
Here is how to do it as one upload, and then stop doing it at all.
Part one: send it once to everyone
1. Open the account in the company's name
The wallet balance and the full transaction history are a company financial record. Open the account on a company email address, with the person who will actually run it holding the credentials. A transaction PIN separate from the password means signing in and spending are two different permissions, which is useful when more than one person needs visibility but only one should be able to send.
2. Build the file
Three columns, exactly as in the downloadable template:
| Phone Number | Network | Amount |
|---|---|---|
| 08031234567 | MTN | 2000 |
| 07051234567 | AIRTEL | 2000 |
| 08151234567 | GLO | 5000 |
| 09087654321 | 9MOBILE | 2000 |
Header matching is forgiving: case, spaces and underscores are ignored, and Phone, Number, Mobile or Recipient work for the first column, Telco, Carrier or Provider for the second.
Each row carries its own network and its own amount, so one file covers every network in the company and can give managers a different allowance from everyone else.
Templates, already shaped correctly:
Format the phone column as Text first. Nigerian numbers start with a zero, and spreadsheets strip leading zeros from anything they treat as a number, so 08031234567 becomes 8031234567 silently. If the list is exported from an HR system, check the exported file rather than assuming, because that is where it usually happens.
Collect the network from each employee, don't guess it. Number portability means the prefix is no longer a reliable guide; a number that looks like MTN may have been ported to Airtel years ago. One field in the onboarding form prevents a predictable batch of failures every month.
3. Fund the wallet, upload, review, confirm
Every row is checked before payment: an unusable number, a missing network or an out-of-range amount is flagged for you to fix, and a number whose prefix disagrees with the network you entered is highlighted in case it has been ported. You review the flagged list and the total, then confirm with the transaction PIN.
One thing the platform leaves to you: repeated rows are not removed. The same number twice gets recharged twice. Sort your file by phone number before uploading. On an HR export this is the likeliest error after the leading-zero problem.
Up to 1,000 recipients in a single upload, and as many uploads as you need, so 500 employees is one batch and 2,400 is three.
Send bulk airtime → · Send bulk data →
4. Read the delivery report
The batch takes one debit for the total, then delivers one recipient at a time, so a 500-row batch completes over several minutes rather than instantly. Each employee gets their own line with their own outcome and reference.
Failures are refunded individually and automatically. A barred line, a wrong digit, a number out of service: that one amount returns to the wallet with its own refund reference, and everyone else stays paid. You can then retry only the failed recipients as a smaller batch once the numbers are corrected, without paying twice for the ones that worked.
Part two: stop doing it every month
This is the part that changes the job, and it is the thing most VTU platforms in Nigeria do not offer at all.
Instead of running the batch once, set it to repeat monthly:
- Create the batch exactly as above, then choose monthly instead of a single run.
- It fires on the day and time you set, paying from the wallet at that moment.
- You are notified before a recurring run is due, so a short balance is not a surprise.
- Every run is recorded separately in the history, so the year is already itemised by month.
- A schedule that fails repeatedly pauses itself rather than retrying silently into an empty wallet.
- Pause, edit or cancel it whenever you like, whether someone joins, leaves, or the allowance changes.
Scheduling works for single purchases and bulk batches alike, and for data as well as airtime. Set up a recurring schedule →
What to check before the first automated run
| Check | Why it matters |
|---|---|
| Wallet funded ahead of the run date | A run is paid at the moment it fires. If the balance is short, that run does not complete. |
| The list reflects current headcount | A leaver keeps receiving the allowance until you edit the schedule. |
| The day is not a cut-off day | Pick a date that is not competing with payroll for the same cash. |
| One test run first | Run it once manually before switching on the repeat, with five numbers including a bad one. |
Keeping it reconcilable
What finance gets, without asking for anything extra:
- One debit per batch for the total, not 500 individual debits. This is the single most useful property for reconciliation, and it is worth knowing before you try to match a bank statement.
- One line per employee underneath it, accounting for every naira of that total.
- Refunds back into the same wallet, each referencing the row that failed.
- A separate record per month once it is recurring, so a quarterly report is three numbers rather than a query.
Rates improve with volume and account tier and are shown before you confirm. We deliberately do not publish a percentage in an article: it varies by network and moves, and a figure in prose goes stale and becomes a false claim about money.
Airtime, data, or both?
- Airtime suits roles that make calls: field sales, drivers, security, anyone whose job is a phone call.
- Data suits roles that submit work online: field officers filing reports, remote staff, anyone on a company app.
- Both is two schedules on the same wallet, not a compromise. Run the airtime batch and the data batch separately so each report is clean.
One warning on data: some high-value bundles are sold by the networks for routers rather than phones, such as MTN's HyNetFlex and MiFi plans. Ordered onto a plain SIM in a handset they fail the large majority of the time. The money is refunded, but your staff are still offline. Use standard monthly bundles for phones, and keep any router SIMs in a separate batch.
Frequently asked questions
Can I really send airtime to 500 employees at once? Yes. The cap is 1,000 recipients per upload, so 500 is a single batch. You can run as many batches as you need beyond that.
Can I upload an Excel file of phone numbers? Yes. Excel or CSV, with Phone Number, Network and Amount columns. Case, spaces and underscores in the headers are ignored. Format the phone column as Text so the leading zero survives.
Can one batch mix networks? Yes. The network is per row, so MTN, Airtel, Glo and T2 (9mobile) can all appear in the same file.
What platform can automatically send monthly staff airtime allowances in Nigeria? VTUBOX supports scheduled and recurring purchases for single numbers and for whole bulk batches, on a daily, weekly or monthly cycle, for airtime and for data. Set it once and it runs until you pause it.
Do employees need an account? No. They need a working SIM on the network you listed. The account and wallet are the company's.
What if an employee leaves mid-cycle? Edit the schedule to remove their row. A recurring schedule keeps sending to whatever list it holds, so the edit is the control.
Is there an approval step before a batch sends? The transaction PIN is the control: whoever holds it confirms the batch. Larger organisations typically keep the PIN with one person and sign-in access with several, so spending and visibility are separated.
Test the failure path before you trust it with a payroll run. Create a free account, fund a small amount, and send five recharges including one number you know is dead. Watching that one refund arrive by itself, while the other four stay delivered, tells you more than any uptime figure.
Related reading: Staff airtime allowances · Staff data · How to send bulk airtime · Scheduled vs recurring vs bulk: which to use
Ready to buy airtime, data, pay TV & electricity bills?
Create a free wallet, send airtime and data to one number or a thousand, and get an automatic refund on anything that fails.
Continue reading
Bulk Data for Schools in Nigeria: How It Works for Students and Staff
How a school, college or training centre in Nigeria buys data for students and staff from one wallet: the file format, who should own the account, and how to make it repeat each term.
Bulk & BusinessHow an NGO in Nigeria Can Distribute Data Bundles to Hundreds of Beneficiaries
A practical guide to sending data bundles to 300 beneficiaries from one spreadsheet: the file format, what a donor report needs, and the four mistakes that cost NGOs money on their first batch.
Bulk & BusinessHow to Send Bulk Airtime in Nigeria: Recharge Multiple Numbers at Once
A step-by-step guide to sending bulk airtime in Nigeria: recharge many MTN, Airtel, Glo and T2 (9mobile) numbers in one transaction with VTUBOX.
