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.
Meter reading sheet
One row per meter. Paste the readings, then check the consumption before billing.
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.
Payment register
Record payments you have already collected, including cash and bank deposits.
Invoice register
Raise a batch of invoices for customers who are not on a recurring billing run.
M-Pesa statement, cleaned
The six columns the reconciler needs. Keep Safaricom's header names so they are recognised.
Zones and routes
The zones and routes used to group meter readings and disconnection lists.
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.
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 register | customer_name, account_number, customer_phone, meter_number, zone, route, category, service_address, opening_balance |
| Meter reading sheet | meter_number, current_reading, previous_reading, read_at, notes |
| Water and waste tariff sheet | name, category, service, basis, is_default, standing_charge, effective_from, band_up_to, rate_per_unit, levy_name, levy_mode, levy_value |
| Payment register | account_number, amount, method, reference, paid_at |
| Invoice register | customer_name, amount, currency, issue_date, due_date, reference, description, customer_phone, customer_email |
| M-Pesa statement, cleaned | Receipt No., Completion Time, Paid In, Other Party Info, A/C No., Status |
| Zones and routes | zone, 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.
Keep going
Related free tools and guides
Import the sheet you already keep
BillGrid imports the register, readings and opening balances, then raises the next run from the same data.