Turn a messy sales sheet into a daily summary
Top sellers, slow movers and the day’s total, from the sheet you already keep.
- ForShop owners who note every sale in Excel but never get time to read it.
- HelperAsk Your Business
- ModeBerri Strawberry 1
- AttachExcel sheet
Copy the prompt
Here is my sales sheet for [date]. Give me a short summary: total sales, the five best selling items, anything that sold less than usual, and one thing I should do tomorrow.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Ask Your Business helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Keep one sheet per day with the same columns, and Berri reads it the same way every time.
- Ask "remember that Sunday is my slow day" once, and Berri will keep it in mind when comparing days.
Turn a messy sales sheet into a daily summaryAsk Your Business
XLSsales-18-nov.xlsx
Here is my sales sheet for 18 Nov. Give me a short summary: total sales, the five best selling items, anything that sold less than usual, and one thing I should do tomorrow.
Reading sales-18-nov.xlsx
Total sales were Rs 42,860 across 186 bills. Your five best sellers:
| Item | Units | Sales |
|---|---|---|
| Toned milk 1 L | 142 | Rs 9,230 |
| Atta 5 kg | 38 | Rs 8,740 |
| Cooking oil 1 L | 41 | Rs 6,560 |
| Basmati rice 1 kg | 29 | Rs 3,770 |
| Detergent 1 kg | 24 | Rs 2,880 |
Biscuits sold 30% less than last week. Tomorrow: move them to the counter shelf.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.