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 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:
- The item
- The quantity
- The price it actually sold for
- Cash or credit, and the customer's name if credit
- Who made the sale
- 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:
- Add up the day's cash sales from your record.
- Add any debts collected today, since that money is also in the box.
- Count the actual cash in the box.
- Compare. If the box is short and you cannot explain it, write down how much and on what day.
- 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.
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.