Your Cart
Loading

Customer List & Repeat Sales Tracker for Salons and Small Shops (Excel & Google Sheets)

On Sale
MYR9.90
MYR 9.90
Added to cart

Keep your regulars in one list. See who spends the most, who hasn't come back in a while, and whose birthday is this month.


What you get

- Visits, total spent and last visit for each customer, from your sales log

- At-risk flag when a customer hasn't returned in X days (you choose X)

- Birthday-this-month column for greetings or promos

- Top 10 customers by spending

- Where your customers come from: walk-in, Instagram, Google Maps, referral...


Good to know

- Works in Excel 2016 or newer, Google Sheets and LibreOffice. No macros.

- Green cells are for your input. Formula cells are locked so you can't break them by accident.

- Comes with sample data so you can see how it works. Clear the green cells and start.

- Labels in English and Chinese (简体中文).

- Instant download: one .xlsx file with a guide sheet inside.

- The file holds personal data. Keep it private and only message customers who agreed to hear from you (PDPA).


---


熟客放在一张表,谁花最多、谁很久没来、谁这个月生日,一看就知道。


内容

- 每位客人的来店次数、累计消费、最后来店日期自动算

- 超过几天没来标「流失风险」(天数你定)

- 本月生日一栏,方便发祝福或优惠

- 消费最多的前 10 位

- 客人从哪里来:路过、Instagram、Google 地图、朋友介绍……


说明

- Excel 2016 以上、Google Sheets、LibreOffice 都能开,没有宏。

- 浅绿色格子是你填的,公式格锁住了,不怕改坏。

- 里面有示例资料,先看懂怎么用,清掉浅绿色格子就能开始。

- 中英双语标题。

- 付款后马上下载:一个 .xlsx 档案,里面有说明页。

- 档案里有客人的个人资料,请自己保管好;只联络同意收讯息的客人(PDPA)。

You will get a XLSX (126KB) file