Most independent retailers and cafe owners know how the week went by feel. Busy Saturday, dead Tuesday, ran out of the thing everybody wanted on Sunday. The feel is usually right, and it is also useless a month later, when you cannot remember whether the quiet Tuesday was the rain or the roadworks.
A weekly report fixes that, and almost nobody keeps one up, because sitting down on a Sunday night to export four things and add them up is exactly the job that loses to being tired.
This guide sets up a report that assembles itself and arrives in your inbox on Monday morning. Setup takes about three hours. Reading it takes two minutes.
What you are building
A scheduled automation that collects the figures for last week from the systems you already use, puts them in a sheet next to the two weeks before, and asks an AI assistant to write four short paragraphs about what changed. It arrives as an email you read with a coffee, and it ends with three decisions the week is asking you to make.
Tools: your till or point of sale system, your bookkeeping software, a Google Sheet, an automation tool (Zapier, Make or n8n) and an AI assistant (ChatGPT or Claude). Add your rota and your supplier orders if they live somewhere digital.
Step 1: choose six numbers and no more
The failure mode of owner reporting is a dashboard with forty tiles that nobody opens twice. Pick six lines you would genuinely change a decision over.
- Total sales for the week, against last week and against the same week a month ago.
- Transaction count and average spend per transaction. Neither means much without the other.
- Your top five products by revenue, and anything that dropped out of the top five since last week.
- Staff hours scheduled against sales, expressed however you already think about it.
- Waste, spoilage or shrinkage if your business has it. A rough weekly figure you write down beats a precise monthly figure you never produce.
- One number from outside the till: bookings, covers, footfall or online orders, whichever exists for you.
Write the list down before you touch any software. Anything you add later has to earn its place by displacing one of these.
Step 2: get the numbers out of your systems automatically
Nearly every till system and bookkeeping package can either connect to an automation tool directly or send a scheduled export by email. Either is fine. The rule is that no step in the chain should need you to log in and click.
- Set your point of sale to email a weekly sales export every Sunday night, or connect it to your automation tool if a connector exists.
- In the automation tool, catch that export and append the figures to a Google Sheet with one row per week.
- Do the same for the rest of your six: bookkeeping, rota hours, online orders.
- In the sheet, use ordinary formulas for the comparisons: this week against last week, and this week against the same week four weeks ago.
- Keep the raw exports on a separate tab. One week a number will look wrong, and you will want the source rather than an argument.
If your till cannot export anything useful, do not abandon the report. Type the six numbers into the sheet yourself on a Sunday night for a month. It takes four minutes, the comparisons and the commentary still run on their own, and by the end of the month you will know whether this report is worth changing your till over.
Step 3: ask for commentary, not a summary
A summary repeats the numbers you can already see. Commentary tells you what is different and what might be worth doing about it. Ask for the second one explicitly.
You are writing a short internal report for the owner of a [cafe or shop, one line]. Here are the figures for this week with the two previous weeks alongside for comparison: [paste the sheet]. Write four short paragraphs. One: what changed against last week, naming only movements bigger than ten percent. Two: what changed against the same week a month ago. Three: anything in the product list that moved in or out of the top five, and what that might mean for ordering. Four: three decisions I should make this week, each one specific and doable before Saturday. Do not calculate anything, use the figures exactly as given. Do not congratulate me and do not speculate about causes you cannot see in the data. Under three hundred words.
Two instructions there do most of the work. Telling it not to calculate keeps the model in its lane. Telling it not to speculate about causes is what stops a report that confidently blames the weather for a week you spent short-staffed.
Step 4: send it to yourself on Monday morning
Schedule the automation early on Monday: read the sheet, call the assistant with the commentary prompt, paste the four paragraphs above a plain table of the six numbers, and email it to yourself. No dashboard to log into and no app to remember.
Send it to one other person if you have a manager, and say plainly that it is a shared read of the week rather than a scorecard. A number that arrives without ceremony gets discussed. The same number introduced in a meeting gets defended.
Step 5: make the report ask you something
A report you only read is a report you stop reading. The last section of the email should be three questions rather than three observations, and next week it should show you what you said the week before.
Here are the three decisions the report suggested last week, and here are the figures for this week. For each decision, say whether the underlying number moved, stayed flat, or cannot be measured from what I have given you. One line each, no judgement, no encouragement. Then list which of the three are still worth doing this week and which should be dropped, with a five word reason each.
Add a column to the sheet where you type one line about what you actually did. Six weeks of that column turns a pile of figures into a record of what you decided and what happened next, and it costs one sentence a week.
What changes
You stop running the shop entirely on memory. The quiet Tuesday goes into the record with a note beside it, the supplier conversation happens in the week it matters rather than at the quarter end, and the January review becomes a matter of scrolling rather than reconstructing.
The weekly report is the backbone of Workflow 07: Run a Leaner Business, the AutomateFirst module about the operating rhythm that keeps the other six workflows alive. This guide is that build in full, free. The playbook is $297 once, with a 30 day refund.
Workflow 07: Run a Leaner Business
Six more workflows, written exactly like this one
The AutomateFirst playbook covers seven repetitive jobs end to end, with the prompt library, PDF checklists and lifetime access. One payment of $297, no subscription.
Other guides