Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • 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.
What Berri sends back
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:

ItemUnitsSales
Toned milk 1 L142Rs 9,230
Atta 5 kg38Rs 8,740
Cooking oil 1 L41Rs 6,560
Basmati rice 1 kg29Rs 3,770
Detergent 1 kg24Rs 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.

Your own job, in your own words.

Try Berri