How to Buy Prepaid Electricity for Multiple Meters Using CSV

Use SIMcloud’s Bulk Electricity CSV when you need to purchase for several checked prepaid meters. Download the official template, keep the header meter_number,amount,reference,recipient, add one order per row, upload the CSV, review the calculated totals and confirm the batch only when every row is correct.

When to use the bulk electricity CSV

The CSV workflow is designed for landlords, managing agents, accommodation operators, branch networks and businesses responsible for multiple prepaid meters. It replaces repeated entry into the single-purchase form but does not remove the need to validate the source data.

Use the CSV when:

• You have more than one meter to purchase for in the same operational run.
• Each meter, amount and recipient has been confirmed.
• You need a named batch and per-row results.
• The wallet can cover the expected total.
• You want a review step before submission.

Do not use it as a way to test unknown meters with real money. Check uncertain meters first using the public meter validation form.

Download and protect the official template

1. Sign in and open Electricity → Bulk Electricity CSV.
2. Select Download Template.
3. Save a clean master copy before entering customer or property data.
4. Keep the column names and order exactly as supplied.

meter_number,amount,reference,recipient
01234567890,250.00,Unit 4 July electricity,0821234567
09876543210,500.00,Warehouse main meter,0831234567

The example values above illustrate the shape only. Replace them with confirmed information. Do not upload example rows.

Complete every column correctly

SIMcloud limits an electricity CSV file to 2,000 data rows. Split a larger portfolio into clearly named batches and finish one batch before uploading the next.

Keep spreadsheet formatting under control

• Set meter and recipient columns to Text before pasting values.
• Do not use formulas in the final export.
• Remove blank rows below the data.
• Do not merge cells or add title rows above the header.
• If a reference contains a comma, allow the spreadsheet program to quote that field during CSV export.

Upload, review and confirm the batch

1. Give the batch a recognisable name such as July rental meters.
2. Choose the exported .csv file.
3. Confirm that you checked it and understand that successful rows cannot be reversed.
4. Select Upload Electricity CSV.
5. On Confirm Electricity CSV Batch, compare the batch name, filename, row count and total billed amount.
6. Review every displayed row, including the calculated electricity value and fee.
7. Compare the required total with the last known wallet balance.
8. Select Confirm Batch only when the data and funding are correct. Otherwise select Cancel Batch.

You can have only one unconfirmed electricity CSV batch waiting at a time. If SIMcloud says a pending batch exists, open and confirm or cancel it before starting another upload.

Check the batch and individual results

After confirmation, SIMcloud sends you to Electricity CSV Uploads. The accepted rows are processed and also appear in ordinary Electricity History as they complete.

Use both views:

• Batch History for the named upload and row-level submission progress.
• Electricity History for the final voucher, meter details, billing split and purchase status.
• My Electricity Meters for successful meters you want to name, buy again, analyse or schedule.

Investigate failed rows individually. Do not re-upload the entire batch if only a few meters failed, because successful rows may be duplicated. Build a small correction batch containing only verified failures that genuinely need another submission.

Frequently asked questions