A monthly retail review in 30 minutes: what to check in your Clover data

Most owners look at their numbers constantly and decide on them rarely. You check yesterday's total, glance at the drawer, notice a shelf is empty, and move on. A month later you could not say whether the store is doing better or worse than in the spring, or which of the things you worried about actually mattered.

A monthly review fixes that without taking over your life. It is a fixed 30-minute slot, the same five checks each time, and one decision written down at the end. If you already follow a weekly routine, the monthly review is the step back that shows what the weekly glances cannot.

Why a monthly rhythm works

A week is too short to separate a trend from noise: one rainy Saturday or one delivery delay can move the numbers. A month contains every weekday several times, a payday or two, and enough sales per product to say something. It is also long enough that a slow product has had time to prove it is slow, and short enough that you can still act before the season changes.

Signs you need a fixed review

• You can quote today's sales but not last month's, or how it compares with the month before.
• You reorder from memory and are surprised by what is left on the shelf.
• Decisions about prices, staffing or ordering are made in reaction to the last bad day.
• Nobody can say what was decided after the last time you looked at the numbers.

The 30-minute routine

1. Total sales and transactions (5 minutes). Compare the closed month with the previous one and, if you have it, the same month last year. Look at transactions and average basket as well as the total, since a flat total can hide fewer customers spending more.
2. Best days and slowest days (5 minutes). Check whether your busiest and quietest days moved. If Friday has crept up, your schedule may be one step behind.
3. Top ten and bottom ten products (10 minutes). Note what entered or left the top ten, and which items sold almost nothing. For the bottom list, ask whether they are new, seasonal or simply stalled.
4. Stock that did not move (5 minutes). From the bottom list, mark items you still hold a lot of. These are your candidates for a markdown, a bundle, a move to another store or a pause on reordering.
5. One decision (5 minutes). Write a single sentence: what you will change, who does it, and by when. Review it at the start of next month's session.

A mini scenario: a clothing boutique owner sits down on the second of the month with a coffee. Sales are up 6 percent, but transactions are down and the average basket is higher. She finds that two large wedding-season purchases lifted the month, and that the regular small purchases are slipping. Her decision: contact her repeat customers about the new arrivals and place a smaller autumn order than planned. Total time, 30 minutes.

Common mistakes

The first is reviewing without deciding. If you close the report without writing a decision, the session was reading, not reviewing. One small, specific change is enough.

The second is comparing months of different length or with different weekends. A month with five Saturdays will beat one with four. Compare per-day averages, or take the same weekdays, before drawing conclusions.

The third is changing too many things at once. If you alter prices, display and ordering in one month, you will not know which one worked. Pick one change, then read the result next month.

Where CornerPilot fits

You can do this review from Clover reports and exports, but it means rebuilding the same comparisons each month. CornerPilot connects to your Clover data and shows sales, transactions, product trends and period comparisons in one dashboard, so the five checks come from the same place every time. Data syncs on a schedule rather than live, which suits a monthly routine. With several locations, you can run the same review store by store.

The takeaway

A monthly review is five checks and one decision: total and basket, best and slowest days, top and bottom products, stock that stalled, and a written next step. This week, put the first slot in your calendar and write down the one question you most want next month's numbers to answer.

To see how a Clover-connected dashboard supports this routine, see the features page or the pricing.