Customer Register Format — Free Excel and App
A customer register stores each customer's contact details, purchases and follow-ups in one list.
Small businesses use it to remember customers, follow up on orders and see who buys most.
Customer Register format preview
| Date added | Customer name | Phone | Address / area | Last purchase | Total purchases | Follow-up date | Notes |
|---|---|---|---|---|---|---|---|
| 12-Nov-2026 | Anita Sharma | 98XXXXXX10 | Indiranagar | 10-Nov-2026 | ₹8,400 | 25-Nov-2026 | Prefers WhatsApp |
The second row is a filled sample.
What each column means
Date added
Example: 12-Nov-2026
Customer name
Example: Anita Sharma
Phone
Example: 98XXXXXX10
Address / area
Example: Indiranagar
Last purchase
Example: 10-Nov-2026
Total purchases
Example: ₹8,400
Follow-up date
Example: 25-Nov-2026
Notes
Example: Prefers WhatsApp
Customer Register FAQs
What is a customer register?
A list of customers with contact details, purchase history and follow-up dates.
Is it a CRM?
It is a simple customer record. A table app like Recordbook can grow into a light CRM with follow-up dates and status.
What should I record?
Name, phone, area, last purchase, total and the next follow-up date.
Is customer data safe?
Use role-based permissions so only chosen staff can view phone numbers.
Related registers
Udhaar Khata Register
Format and sample
Daily Sales Register
Format and sample
Visitor Register
Format and sample
Running a retail & inventory business? See Recordbook for retail & inventory · Recordbook vs Excel