In the early twentieth century an Italian economist named Vilfredo Pareto noticed that about eighty percent of the land in Italy was owned by twenty percent of the people. He then looked at his garden and found that about twenty percent of the pea pods produced eighty percent of the peas. The ratio is not a law of nature, but it shows up in so many places that you should expect it in your own sales records. Most owners have never checked.
That is the strange thing about small business data. The records exist. Every point of sale system, every notebook of orders, every Messenger thread with a customer contains patterns that a consultant would charge good money to find. What is missing is not the data. It is the habit of asking it a few simple questions.
Start with data you can trust
Before any report, spend one afternoon cleaning the records. Give every product one name, so that "Iced Latte", "iced latte" and "Latte (cold)" do not count as three items. Record the date and time of every sale. Mark voids and discounts so they do not pollute the totals. A dirty record can produce a confident wrong answer, and a confident wrong answer is worse than no answer at all.
Question one: what actually pays the bills?
Rank your products by revenue, highest to lowest, and add a running total. A café we will call Kape Kanto did this for the first time last year. The owner believed her pastries were a sideline. The ranking said otherwise.
Three products produced more than two thirds of the revenue. The bottom four, which took up two fifths of the menu, produced seven percent. That does not mean the long tail should be deleted. Some items bring people through the door, and some are there for the regulars. It does mean the owner could finally answer a question she had avoided: which products deserve the best shelf space, the most careful sourcing and the most attention from staff?
What to do with it. Protect the top three. Examine the bottom four, and for each one decide whether it earns its place as a draw, a margin builder or a habit for regulars. If it is none of these, retire it.
Question two: when do customers actually come?
Most owners can tell you their busy hour from memory. Memory is usually wrong by an hour or two, and it forgets the quiet days entirely. Group your sales by day of the week and by hour, and look at the shape.
The useful findings are usually dull and valuable. You may learn that Tuesday afternoons never recover, which suggests a promotion or a shorter shift. You may learn that your Friday peak starts an hour earlier than your staffing, which explains the complaints about slow service. Scheduling by data rather than habit can lower payroll costs without cutting a single hour of opening time.
Question three: who comes back?
Acquiring a customer costs real money, through ads, discounts and time. Keeping one costs less. Yet most small businesses know their sales but not their repeat rate. If you collect even a phone number or a loyalty card ID, you can count how many customers bought twice in the last ninety days.
A repeat rate that is climbing means your product and service are working. A rate that is flat while sales rise means you are filling a leaky bucket. A rate that is falling is an early warning, and it usually shows up in the data months before it shows up in the till.
Sales tell you what happened. Repeat customers tell you whether it deserved to.
Question four: how much does each customer spend?
Divide total sales by the number of transactions and you have your average basket. It is the cheapest lever in the business. If Kape Kanto serves eight hundred customers a month at one hundred and fifty pesos each, raising the average basket by thirty pesos through a simple pastry pairing adds twenty four thousand pesos a month. No new customer is needed, no ad is bought.
The way to raise it is rarely pressure. It is a sensible pairing placed where the customer is already looking, a combo that feels like a favor, a size upgrade offered once and with a smile.
Turning the four questions into a habit
Put the four reports on one page and review them on the first Monday of each month. Compare to the previous month and to the same month last year. Write down one thing you will change and one thing you will leave alone. A single page, read consistently, is worth more than an elaborate dashboard that nobody opens.
When to go further
Spreadsheets will carry you a long way. When you have thousands of transactions across several branches, or you want to forecast weekly demand so you buy the right stock, it is time to move to a proper reporting tool. Even then, the questions stay the same. Better tools only make the answers faster.
The data you need is already in your drawer or in your point of sale. The skill is learning to ask it plain questions and to believe the answers, even when they contradict what you thought you knew about your own business.
Kape Kanto is a composite example and the numbers are illustrative. If you want help setting up your monthly report, get in touch.