How to Track Daily Sales in a Nigerian Shop

Notebook, spreadsheet or app? Here is what a daily sales record must capture, a five-minute closing routine, and how to keep recording when the network is down.

By the MyShopGuard team · 18 Aug · 5 min read

Ask a shop owner what they sold yesterday and most can give a rough total. Ask what they sold last Tuesday, item by item, and the answer is gone. Without that detail you cannot tell whether stock is missing, which items actually make money, or whether a quiet week was quiet for everyone or only for you.

A daily sales record fixes all three, and it does not need to take long.

A day's sales written down line by line
Line by line as it happens beats one total at closing.

A day's total is not enough

Writing "₦42,000" in a book at closing feels like record keeping, but that single number cannot be checked against anything. It leaves out which items left the shelf, how much was cash against credit, and who served the customer. Those three details are what turn a record into something you can act on.

A record you can act on has six pieces per sale:

  1. The item
  2. The quantity
  3. The price it actually sold for
  4. Cash or credit, and the customer's name if credit
  5. Who made the sale
  6. Roughly when

That looks like a lot until you record it as it happens, when all six are in front of you. Reconstructing it at closing takes longer and gets it wrong.

Record it at the counter, not at closing

Memory is the weakest part of any system. A sale written down hours later loses the price it went for, whether the customer paid, and who served them.

Make it a rule that nothing leaves the counter unrecorded, including small sales, sales to friends and family, and the ones you make yourself. The exceptions are exactly where the record breaks down, and a broken record cannot be checked against anything.

Notebook, spreadsheet or app

All three work. They fail differently.

A notebook costs almost nothing, never runs out of battery, and everyone can use it. You do the adding up yourself every day, a page can be torn out, and it cannot tell you that yesterday's count does not match.

A spreadsheet adds up for you and sorts easily. It also needs a laptop or patience with a phone keyboard, and it usually gets updated at closing from memory, which puts you back where you started.

An app records at the counter, adds up by itself, and can compare sales against stock and cash. It needs a phone everyone can use, and it needs to work when the network does not.

The right answer is whichever one you will still be doing in three weeks. A faithfully kept notebook beats an app nobody opens.

The network problem is the real test

In a market, network comes and goes. If your tool stops working when the signal drops, your busiest hours become your unrecorded hours, and those gaps are exactly where losses hide.

Whatever you choose has to keep working offline. In an app, that means sales save on the phone and send themselves later. In a notebook, that is free.

Five minutes at closing

The recording happens during the day. At closing, spend five minutes turning it into something you can trust:

  1. Add up the day's cash sales from your record.
  2. Add any debts collected today, since that money is also in the box.
  3. Count the actual cash in the box.
  4. Compare. If the box is short and you cannot explain it, write down how much and on what day.
  5. Note anything unusual: a breakage, a return, a big discount you approved.

Doing this daily means a difference is always fresh. Doing it monthly means arguing about a Tuesday nobody remembers. If the cash regularly comes up short, these are the signs worth checking.

A cash box being counted against recorded sales
The box against the record, every single day.

Give staff their own login

If everyone writes in the same book with no name attached, you learn that something went wrong but never where to look. When each sale carries the name of whoever made it, patterns appear on their own, and honest staff are protected because a gap can be traced to a shift rather than to a rumour.

Staff need to record sales. They do not need to see your profit, your stock levels or your reports.

What to do with the record each week

A record you never read is just writing practice. Once a week, ask it four questions:

  • What sold most, and what has not moved at all?
  • What did I take in cash, and what is still owed to me?
  • Did any item sell below my normal price, and did I approve it?
  • Does my stock count agree with what the record says I sold?

The last question is the one that catches theft, and it only works if both halves exist: count your stock the short way and compare it with the sales you recorded.

Doing it with an app

MyShopGuard is built for this exact routine. Staff tap the item and the price as they serve, which takes seconds, and every sale is stamped with their name. It works with no network and syncs when signal returns. At closing you count the cash and the app tells you what it should be. When a count or a cash check does not agree, it says so in plain words with the money attached, and shows the total it has caught for you this month.

Start here

Tonight, write down the six pieces for every sale you can still remember from today, then do it live tomorrow from the first customer. At closing, count your cash against the record. That single comparison, done daily, is the habit everything else is built on. Next, work out whether those sales are actually leaving you a profit: how to know if your shop is making profit.

Questions people also ask

What is the best way to record daily sales in a small shop?+

Record each sale as it happens with the item, quantity, price and whether it was cash or credit. A notebook works if you fill it faithfully. An app is easier to add up and cannot be quietly rewritten later.

Is a notebook or an app better for sales records?+

A notebook is cheap and always works, but nothing adds itself up and pages can be torn out. An app does the arithmetic, keeps a record that is harder to alter, and can compare your sales against your stock and cash.

How do I record sales when there is no network?+

Choose a tool that works offline. Sales should save on the phone and send themselves when the network returns, otherwise your busiest hours in the market will be the hours that never get recorded.

Should my staff record the sales?+

Yes, as they serve, because a sale written down hours later is usually wrong. Give staff their own login so each sale carries their name, and keep reports and stock control to yourself.

How long should recording sales take each day?+

A few seconds per sale as it happens, then about five minutes at closing to count your cash against what the records say. If it takes much longer than that, the method is too complicated to survive a busy day.

Read next