Turn Your Square Sales Report Into a 5-Line Daily Summary
Researched
What it does
A short morning note that says how yesterday went, what sold, when it was busy and anything odd, written from the Square report you exported.
Who it is for
Cafe, retail and service owners who take payments on Square and never have time to read the full reports.
Tools
Square Dashboard, Reports, Sales summary (export as CSV, or copy the numbers)
ChatGPT or Claude
Steps
In Square Dashboard, open Reports, then Sales summary, and set the date to yesterday.
Export it, or copy the totals and the item sales into a note.
Paste it into the prompt below.
Read the 5 lines and check one number against Square before you act on it.
Do the same each morning for a week, then ask it to compare the week.
The prompt
Here is yesterday's sales report from Square. Write a 5-line summary for me. Do not change or send anything.
[paste the sales summary, item sales and hourly sales if you have them]
1. Total net sales, number of sales and average sale.
2. Busiest hour and slowest hour.
3. Top 3 items and any item that sold far less than usual.
4. Refunds, discounts or comps, with the amount.
5. One thing worth checking today.
Use only the numbers above. If a number is missing, write "not in the report".
Tips
Keep the same prompt every day so the summaries are easy to compare.
After a week, paste all 7 summaries and ask what changed.