Operations

Billing spreadsheet templates

Download the columns BillGrid imports, ready to open in Excel.

Runs in your browser. No signup. Updated 5 November 2026.

These are CSV files. Excel, Google Sheets and LibreOffice all open them. Keep the header row unchanged and delete the example rows before you add your own.

Customer and connection register

The register BillGrid imports: every customer, account number, meter and opening balance.

customer_nameaccount_numbercustomer_phonemeter_numberzoneroutecategoryservice_addressopening_balance

Meter reading sheet

One row per meter. Paste the readings, then check the consumption before billing.

meter_numbercurrent_readingprevious_readingread_atnotes

Water and waste tariff sheet

One row per block, with no upper limit on the last block. Charges and levies are read from the first row.

namecategoryservicebasisis_defaultstanding_chargeeffective_fromband_up_torate_per_unitlevy_namelevy_modelevy_value

Payment register

Record payments you have already collected, including cash and bank deposits.

account_numberamountmethodreferencepaid_at

Invoice register

Raise a batch of invoices for customers who are not on a recurring billing run.

customer_nameamountcurrencyissue_datedue_datereferencedescriptioncustomer_phonecustomer_email

M-Pesa statement, cleaned

The six columns the reconciler needs. Keep Safaricom's header names so they are recognised.

Receipt No.Completion TimePaid InOther Party InfoA/C No.Status

Zones and routes

The zones and routes used to group meter readings and disconnection lists.

zoneroute

The account, reading, tariff, payment and invoice templates use the same column names as BillGrid's import screens. Zones are imported on their own; keep that file separate.

Most billing spreadsheets fail in the same place: the columns are laid out to look right on screen, not to be imported later.

These templates use the same column names BillGrid's importer expects. Start here, and moving to BillGrid is a file upload, not a rebuild.

Before you rely on the number. CSV files open in Excel, Google Sheets and LibreOffice. The columns match BillGrid's importer, so the same sheet can be uploaded when you move to BillGrid.

The method

What columns a billing spreadsheet needs

A billing spreadsheet works best with one row per thing: one per customer, one per meter reading, one per payment. Keep totals out of the data rows and put them on a separate sheet, so the file can still be sorted, checked and imported later.

Give every customer a stable account number and every meter its own number. Those two columns are what connect readings and payments to the right account, and they are the first things to fix when a spreadsheet stops adding up.

The columns in each template

Each download starts with these headers and example rows to delete.

Customer and connection registercustomer_name, account_number, customer_phone, meter_number, zone, route, category, service_address, opening_balance
Meter reading sheetmeter_number, current_reading, previous_reading, read_at, notes
Water and waste tariff sheetname, category, service, basis, is_default, standing_charge, effective_from, band_up_to, rate_per_unit, levy_name, levy_mode, levy_value
Payment registeraccount_number, amount, method, reference, paid_at
Invoice registercustomer_name, amount, currency, issue_date, due_date, reference, description, customer_phone, customer_email
M-Pesa statement, cleanedReceipt No., Completion Time, Paid In, Other Party Info, A/C No., Status
Zones and routeszone, route

How it works

How to use the billing spreadsheet templates

Download the sheet you need

Each file has a header row of column names and some example rows. Delete the examples before you type your real data.

Keep one row per thing

One row per customer, one row per meter reading, one row per payment. Do not merge two customers into one row or put totals at the bottom.

Upload the same file later

The account, reading, tariff, payment and invoice templates match BillGrid's import screens. Keep the headers unchanged.

Questions we get

Questions about the billing spreadsheet templates

Are these real Excel files?

No, they are CSV files, which Excel, Google Sheets and LibreOffice open directly. CSV is plain text, so it opens almost anywhere and the column names stay visible.

Can I add my own columns?

Yes, for your own records, but remove them before importing if the importer is strict. The safest sheet keeps exactly the columns in the template.

Should I put totals in the sheet?

No. Keep totals out of the data rows. One row per customer, reading or payment. Totals belong in a separate summary sheet.

Import the sheet you already keep

BillGrid imports the register, readings and opening balances, then raises the next run from the same data.

Or reach us directly

We reply within one business day.