ISP Billing System with WhatsApp Reminders – Apps Script

A billing and recovery system for internet service providers, running entirely on Google Sheets so there is no hosting cost. It handles the part ISPs actually struggle with — not raising the invoice, but collecting it. Overdue customers surface on a recovery board where you can call them or send a WhatsApp reminder in one click, and record the payment without leaving the screen.

What it does

Customers are registered against an area and a package, both of which you define yourself. Run Billing once a month and it generates invoices for every active customer in one action. Payments record against the invoice with the method, who collected it and a reference, flipping the status from unpaid to paid immediately. Each customer carries a 360 view — profile, timeline, invoices, payments, complaints, assigned equipment, documents and call logs — so the person on the phone has the whole history in front of them.

Highlights

• Collection runs with opening balance, cash and online collected, expenses paid and bank deposit — then reconciled and locked
• Equipment register for routers, ONUs, switches and cables, with serial number, MAC and the customer it is assigned to
• Complaint tickets lodged against a customer and worked through in-progress to resolved
• Call logs recording who called whom and the outcome — paid, promised, no answer
• Leads with package interest, area and source, converted with a mark-won action
• Suspend or disconnect a connection directly from the customer row
• Four roles — super admin, admin, accountant, collector — behind a permission matrix you edit live
• Theme colour palettes, dark mode, and login with signup and email OTP password reset

Who it is for

Small and mid-size internet service providers and cable operators running a few hundred to a few thousand subscribers with their own field collection staff, who want the billing, the recovery and the equipment record in one place.