| Name | Fee | Due | Payment | Action |
|---|
| Name | Fee | Due | Payment | Action |
|---|
| Name | Package | Fee | Status | Payment |
|---|
| # | Name | Package | Fee | Due Date | Status | Payment | Actions |
|---|
| Name | Package | Fee | Paid On |
|---|
| Name | Package | Fee | Due Date | Action |
|---|
Jo customers PAID mark hain unko koi reminder nahi jayega β sirf Unpaid + Due/Overdue customers ko message milega.
| Name | Fee | Due Date | Status | Payment | Send |
|---|
Sara data ek JSON file mein save karein. Kabhi bhi restore kar saktay hain.
Ye upar wale CSV import se alag hai β ye automatic hai. Jab bhi koi customer save/Paid/Unpaid ho, khud Sheet mein jata hai; aur login karte waqt, Sheet mein seedha add kiye naye customers khud yahan aa jate hain.
Upar wala button dabayein β jo bhi masla ho wo turant message mein dikh jayega. Sabse aam wajah: Apps Script mein code update karne ke baad Deploy β Manage deployments β βοΈ β New version β Deploy karna reh jata hai.
Apna purana customer data Google Sheet ya Excel se yahan import karein. Pehle template download karein, apna data usi format mein Google Sheet ya Excel mein tarteeb dein (arrange karein), phir wahan se CSV file download karke yahan upload kar dein β sab customers automatically add ho jayenge.
Pehli row mein bilkul yeh headings honi chahiyen (isi tarteeb / order mein):
Name | WhatsApp | Address | Package | Fee | DueDate | ConnectionDate | Status | Notes
β’ DueDate aur ConnectionDate ka format: YYYY-MM-DD (e.g. 2026-08-15)
β’ Status: active / pending / suspended
β’ Google Sheets mein: File β Download β Comma Separated Values (.csv) se CSV nikalein, phir wohi file yahan "Import" button se upload kar dein.
β’ Agar kisi customer ka WhatsApp number pehle se system mein maujood hai, to uska data update ho jayega (duplicate nahi banega) β naye number automatically naye customer ki tarah add ho jayenge.
No backups yet.
to pay via JazzCash.
Customer JazzCash app khol ke *786*10# dial kare ya Till ID 9830 9797 6 daal ke seedha aap ke account mein payment kare.
Payment aane ke baad khud customer ko Paid mark karein Customers page se. System automatically payment detect nahi karta.