Example · Report automation
A sales recap that arrives before you reach the office
Each branch's sales are already in a spreadsheet. Every morning the system totals them, compares them with the previous day, and flags unusual numbers. At 07:00 the report lands in your WhatsApp.
All examplesSteps
- 01Branch dataYesterday's sales from five branches sit in one spreadsheet.
- 02TotalledThe total for all branches is calculated automatically.
- 03ComparedEach branch is compared with the previous day.
- 04Odd numbers flaggedBranches with a big change get a flag and a note.
- 0507:00 reportThe summary is sent to the owner's WhatsApp.
Sample data
Sales per branch
| Branch | Tuesday | Wednesday | Change |
|---|---|---|---|
| Dago | Rp18.4m | Rp19.1m | +4% |
| Buah Batu | Rp15.2m | Rp14.8m | -3% |
| Cimahi | Rp12.6m | Rp4.8m | -62% |
| Antapani | Rp9.9m | Rp10.6m | +7% |
| Kopo | Rp11.3m | Rp11.9m | +5% |
| Total | Rp67.4m | Rp61.2m | -9% |
Needs checking
Cimahi: no transactions after 14:10. Other branches look normal.
Daily ReportWhatsApp
Recap for Wednesday, 14 October
- Total sales Rp61.2 million, down 9% on Tuesday.
- The other four branches moved slightly, from down 3% to up 7%.
- Cimahi Rp4.8 million. No transactions after 14:10, please check with the branch head.
- Highest: Dago at Rp19.1 million.
Branch details are in the spreadsheet.
07:00
The numbers come from your own data
The report only reads data you already have. No figures are changed, and an odd number is only flagged for checking, not explained away.
Still compiling branch reports one by one?
Tell us about the work your team still does by hand. We reply within 1-2 working days.