# Sales report basics for store owners

Source: https://fihrist.world/en/blog/sales-report-basics-for-store-owners
Published: 2026-11-15 | Reading time: 8 min | Publisher: FIHRIST

> A report is not a goal, it is a tool for a decision. These simple questions turn numbers into something you do this week, and protect you from a quick conclusion that costs you a month.

## A report answers only three questions

What tires a store owner most is opening a report with twenty numbers and not knowing where to start. Simplify: what sold? What did not sell? And are the numbers better or worse than a similar period? Everything after that is detail serving these three questions, and whatever does not serve them can be ignored this week.

The common mistake is reading the biggest number on the page as a verdict. Total sales can rise while profit falls, and can fall while the shop is in better shape. That is why you need two or three numbers together, not one, before judging.

## The metrics a small store actually needs, and how each is calculated

You do not need twenty indicators. This set is enough for a weekly decision, and each one can be calculated from a simple export or by hand at the end of the day:

- Order count: count confirmed orders only, not conversations. A chat is not an order until a product, a price, and a delivery method are agreed.
- Total sales: the sum of order values after discount. If you separate shipping, keep it outside the figure or show it separately, so revenue does not look bigger than it is.
- Average order value = total sales divided by number of orders. It tells you whether a customer is buying more or less per visit.
- Units per order = units sold divided by number of orders. Useful if you sell small pieces, because it reveals multi item buying that an average price hides.
- Conversion rate = orders divided by new conversations, multiplied by 100. It measures how well a conversation reaches a decision, not message volume.
- Gross margin per item = (selling price minus purchase cost) divided by selling price, multiplied by 100. Calculate it per item, then look at each item weight in sales, because the best seller may not be the most profitable.
- Return rate = returned orders divided by delivered orders, multiplied by 100. Divide by delivered, not confirmed, because an order that has not arrived cannot be returned.
- Item turnover = units sold in the period divided by the average units held in stock during the period. A higher figure means stock is moving, a lower one means capital sitting on the shelf.
- Average daily sales = period sales divided by actual selling days, not the number of days in the week. This single figure saves you from unfair comparisons.

## A weekly review routine in half an hour

A review that happens every day gets read and not acted on. Set a fixed appointment, once a week, ideally the same day and hour, and follow the same order each time so you do not skip a step:

1. Write the nine figures above into one sheet or file, in the same order every week.
2. Compare with last week, then with the same week last month if you have it.
3. List the top five and bottom five items by movement, and add a reason if you know one.
4. Review items that ran out or hit their minimum, they explain part of any drop.
5. Review returns with their reasons, and conversations that went unanswered.
6. Choose one decision for next week and write it in measurable terms: what you will do, and on which item.
7. Write one line about circumstances: a promotion, a holiday, a supplier pause, a fault. A month later this line is the difference between an explanation and a guess.

## A worked example: reading two consecutive weeks

The figures below are entirely hypothetical, for illustration only, and the currency unit is unspecified because what matters is the relation between the numbers, not their size. We also assume every order was delivered in both weeks, so the return rate is calculated on one basis.

- Week one: 200 new conversations, 40 orders, sales of 12,000, 56 units sold, 4 returns.
- Week two: 260 new conversations, 44 orders, sales of 12,100, 66 units sold, 3 returns.

On a quick look, sales are almost flat: from 12,000 to 12,100. But the arithmetic says something else. Average order value fell from 300 (12,000 divided by 40) to 275 (12,100 divided by 44). Units per order rose from 1.4 (56 divided by 40) to 1.5 (66 divided by 44). Conversion fell from 20 percent (40 divided by 200) to about 17 percent (44 divided by 260). The return rate improved from 10 percent to about 7 percent.

The honest reading: the shop did not grow, it changed shape. Customers bought more pieces but cheaper ones, and the proof is that average unit price fell from about 214 (12,000 divided by 56) to about 183 (12,100 divided by 66). At the same time you needed more conversations to get each order. That leaves two possibilities until you check: either a cheap item drove the volume this week, or discounts increased. The difference matters: the first is a product mix shift, the second is less profit on the same revenue.

How do you settle it? Open item movement for week two and see which item added the extra ten units. If the whole addition came from one cheap item, mix is the cause. If the increase is spread out with a higher discount share, discounting is the cause. In both cases write what you found next to the number, because next week will be compared with this one.

## Comparison traps: when two numbers cannot be compared

Most wrong conclusions do not come from bad intent, they come from comparing two numbers that do not measure the same thing. These are the most common traps in a small shop:

- Number of days: a week with a holiday or a closed day cannot be compared with a full week. Use average daily sales instead of the total.
- Season: the last week before a holiday or during Ramadan is not a normal week. Compare with the same month last year if you have it, or accept that the comparison is weak and write that down.
- Stockouts: if a fast mover was out for three days, its lower figure is not weaker demand but absent supply. Exclude the days it was missing.
- A price or discount change: higher sales after a big discount may mean lower profit. Compare revenue and margin together, not revenue alone.
- One large order: a customer buying a batch once distorts the average. Note unusual orders in the margin of the report instead of letting them create a rule.
- A change in how you measure: if you only started recording conversations this week, conversion cannot be compared with any earlier week. Start measuring and treat the first week as a baseline.
- A channel shift: conversations moving from WhatsApp to Instagram does not mean WhatsApp declined, it means people changed place. Look at the total before judging a channel.

## When a higher number is bad news

Not every rise is a success. Four cases deserve a review before celebrating: sales up with returns up, because you are selling what comes back; sales up with margin down, because you are buying volume at the cost of profit; order count up with average value falling sharply, because you get more effort for the same revenue; and conversations up with orders flat, because you pay in reply time with no result.

## From observation to decision: if this, then that

- If sales rose and average order value fell: check the discount share and the item mix before calling the month a success.
- If conversations rose and conversion fell: check reply speed and the most repeated question, one question may be blocking the decision.
- If sales fell and returns fell with them: the drop may come from a narrower assortment rather than weaker demand.
- If one item fell while a substitute rose: that is a shift inside the shop, not a loss.
- If one item keeps appearing in returns: check the description, sizes, and photos before you stop buying it.
- If a fast mover hits its minimum twice in a month: raise the minimum level or shorten the supply lead time.
- If an item sells slowly but has a high margin: do not drop it immediately, try offering it to whoever bought something close to it.
- If an item sells fast with a thin margin: revisit the purchase cost or raise the price slightly and measure the effect for a week.
- If the gap between drawer cash and the report repeats: review the closing routine and permissions before suspecting a person.

## Common mistakes in reading reports

- Changing several things in one week then trying to find out which one worked. Change one thing and read its effect.
- Judging from a single day. One day may be a holiday, a fault, or a mood, and a week is the smallest unit worth reading.
- Comparing this month with last month without looking at day count or holidays.
- Reading revenue only and ignoring margin, so you believe you profited while standing still.
- Not writing down what happened. Three weeks later you will not remember the supplier delay or the stockout, and you will explain the number wrongly.
- Using the report to judge the team instead of improving the work. Numbers point at a step that needs adjusting, not a person to blame.

## What to write each week so comparison becomes possible

The most important thing about a report is not what it shows today but what you keep for comparison tomorrow. Keep one page per week with the nine figures, the top items and the bottom items, one reason for each unusual movement, and one decision you made. After two months these pages become a series, and they are worth more than any ready made report because they carry your own explanation.

If you do not have time for all of this, keep only three numbers each week: total sales, order count, and the fastest moving item. Three numbers written regularly beat twenty numbers forgotten.

## Where FIHRIST helps

All of the above can be done with a spreadsheet, paper, and a pen. What FIHRIST offers here is specific: an analysis assistant that compares periods, product movement, and channel results, and explains only what the data supports, and you can always check the numbers themselves. Comparing item movement across periods helps you see what moved and what stalled, permissions are set per member, and the interface works in Arabic and English. The decisions remain yours.

## Frequently asked questions

### How often should I review the sales report?

Once a week is enough for most small stores, on a fixed day and hour, because a week is the smallest period that gives a meaningful figure. A long daily review gets read and not acted on, but a short daily close is necessary for the numbers to be sound. The monthly review is for direction, assortment, and margin, not for tracking every order.

### What is the most important number in a sales report?

No single number is more important than the rest, but if you must pick one it is gross profit rather than total sales. Revenue tells you the volume of activity, margin tells you what stays with you. A shop selling a lot at a thin margin works harder and earns less. So read revenue, margin, and order count together, those three reveal whether growth is real or just movement.

### How do I know whether a sales drop is seasonal?

Compare with the same month last year if you have those figures, and see whether the drop happened at the same time. If you have no old figures, look for other signals: did the pattern repeat before or after a holiday, and did all items fall or only one. If one item fell while the rest held, the cause is probably that item rather than the season. When you are unsure, write cause unclear and watch for two weeks.

### Do I need accounting software to read a sales report?

No, a sales report answers questions about selling and movement, while accounting belongs to tax, financial statements, and your statutory obligations. A small store can start with a spreadsheet holding sales, orders, items, and cost, and calculate the metrics in this guide from it. What matters is that the same data stays consistent, not that the software is complex. As the business grows, accounting becomes an organisational necessity rather than a condition for reading sales.

### Why does the sales figure in the report differ from the cash in the drawer?

Because they measure two different things. The report measures the value of what was sold, the drawer holds what was actually collected. The gap usually comes from credit or online sales, collected shipping, a return paid in cash, and a change error or an unrecorded discount. Separate cash from non cash at closing, record every movement outside a sale, and the gap shrinks to something you can explain.
