If you only have fifteen minutes at month end, look at five numbers: sales, gross margin, fixed costs, cash on hand and dues outstanding. Together they tell you whether the shop earned more than it spent, whether that profit is real money in hand, and whether customers are slowly becoming your lenders. None of them needs special software; a notebook page with five lines is enough.
Where does each of the five numbers come from?
Each number can be pulled from a record you probably already keep. The table shows the source and the sum.
| Number | Where to find it | How to get it |
|---|---|---|
| Sales | Daily sales sheet or bill book | Add up the month, cash and UPI together |
| Gross margin | Sales sheet plus supplier bills | (Sales minus the cost of what you sold) divided by sales |
| Fixed costs | Rent, salaries, electricity, loan EMIs | Add the bills that arrive whether or not you sell much |
| Cash on hand | Drawer count plus bank balance | Count it on the last day, after the day's closing |
| Dues outstanding | Udhaar book and supplier list | Total owed to you, and separately total you owe |
A worked month with made-up figures
Say a grocery shop sold ₹3,20,000 in the month, and the goods that left the shelves cost ₹2,40,000 to buy. Gross profit is ₹80,000, which is 25 percent of sales. Fixed costs were rent ₹30,000, two helpers ₹24,000, electricity ₹6,000 and other bills ₹5,000, a total of ₹65,000. What is left before the owner draws anything is ₹80,000 minus ₹65,000, which is ₹15,000.
Now the other two numbers. The drawer and the bank together hold ₹48,000. Customers owe ₹52,000 on udhaar, and the shop owes suppliers ₹61,000. So the profit looks healthy on paper, but dues owed to the shop are larger than the cash in hand, which is worth a conversation with yourself.
What does a change in each number mean?
- Sales up, margin flat: you are selling more of the same mix. Check that stock and staff can cope.
- Sales flat, margin down: either purchase prices rose and you did not pass them on, or discounts and wastage crept up.
- Fixed costs up: look for the new line, a salary raise, a repair that became regular, or a bill that was missed last month and arrived now.
- Cash on hand down while profit is steady: money has gone into stock, repayments or dues. Look at the next two numbers before panicking.
- Dues outstanding up: you are selling on credit faster than you collect. That is a sales number that has not become cash yet.
Which number should I worry about first?
Worry first about cash on hand, because bills are paid in cash and not in profit. A shop can show a profit and still fail to pay the distributor on Friday if the money is sitting in udhaar. Compare the cash number with what falls due in the next thirty days: rent, salaries, supplier instalments and EMIs. If cash covers them comfortably, the other four numbers are about improvement, not survival.
How do I keep this down to a minute?
Make one row per month on a single page, with the five numbers across and the months down. After three months you can see direction without any arithmetic. Keep the working, such as the cost of goods sold, in the back of the book and carry only the five results forward.
If your shop expenses already flow through a bank account, SpendixAI can import that statement and group rent, salaries and electricity into categories, so the fixed-costs total is a report rather than a manual sum. Sales and udhaar would still live in your own sheet.
Your month-end checklist
- Total the month's sales and write it down.
- Work out gross profit and the margin percentage.
- Add the fixed costs and subtract them from gross profit.
- Count the drawer and read the bank balance.
- Total what customers owe and what you owe, then compare with last month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
