A day-by-day cash plan for a new shop is a calendar with three numbers on each day: the cash you start with, the cash you expect to take in and pay out, and the cash left at closing. The rule is simple: opening cash, plus expected sales, minus payments, equals closing cash. If any day's closing figure is lower than you can live with, you can see it weeks before it happens.
What goes into the calendar?
Draw a table with one row per day. Mark these in advance:
- Supplier payment dates and amounts
- Rent date
- Salary date
- Electricity and other fixed bills
- Expected daily sales, which can start low and rise as people find the shop
- Small daily expenses, such as tea, packing material and local transport
How does the formula work on a single day?
Take a made-up shop with ₹2,00,000 on opening day. Daily sales are guessed at ₹6,000 in week one and small daily expenses at ₹1,000. On the fifth day the first supplier instalment of ₹25,000 is due.
- Days 1 to 4: each day adds 6,000 and takes away 1,000, so the cash rises by 5,000 a day. After four days it is 2,00,000 plus 20,000, which is ₹2,20,000.
- Day 5: add 6,000, subtract 1,000 and subtract the supplier's 25,000. The cash goes from 2,20,000 to ₹2,00,000.
- Days 6 and 7: another 5,000 each, so day 7 closes at ₹2,10,000.
What does the whole month look like?
Here is the same shop by week, with its guesses written out.
| Period | Sales in | Payments out | Closing cash |
|---|---|---|---|
| Week 1 (days 1 to 7) | ₹42,000 | ₹32,000: supplier 25,000, small costs 7,000 | ₹2,10,000 |
| Week 2 (days 8 to 14) | ₹49,000 | ₹19,000: stock top-up 12,000, small costs 7,000 | ₹2,40,000 |
| Week 3 (days 15 to 21) | ₹56,000 | ₹32,000: supplier 25,000, small costs 7,000 | ₹2,64,000 |
| Week 4 (days 22 to 30) | ₹63,000 | ₹67,000: rent 20,000, wages 10,000, electricity 3,000, small costs 9,000, supplier 25,000 | ₹2,60,000 |
Check week by week: 2,00,000 plus 42,000 minus 32,000 is 2,10,000. Then plus 49,000 minus 19,000 is 2,40,000. Then plus 56,000 minus 32,000 is 2,64,000. Then plus 63,000 minus 67,000 is ₹2,60,000. Notice that week four is the only week in which the shop pays out more than it takes in, because rent, wages and bills fall together.
What if sales are lower than you guessed?
Run the calendar a second time with sales cut by a quarter. In week one, sales of ₹42,000 become ₹31,500, which is ₹10,500 less. If every week is that much lower, the total shortfall for the month is a quarter of the month's sales of 2,10,000, which is ₹52,500, leaving about ₹2,07,500 at the end of the month (2,60,000 minus 52,500). The shop survives, but you can see how little room there would be if the opening cash were smaller.
How do you keep it updated?
Every evening, replace the day's guess with the real figures: actual sales, actual payments and the real closing cash from the till and bank. Then recalculate the next few days from the new starting point. After a week you will know how far off your guesses were and can adjust the rest of the month.
A statement-based expense tracker such as SpendixAI can show the real payments for the month by category when you upload your bank statement, which helps you correct the payment side of the plan; the sales guess still has to come from your own daily record.
A simple closing routine
- Count cash and write it in the calendar.
- Check the bank balance and note any pending payments.
- Look at the next seven days of dues.
- Mark any day that falls under your floor, and decide what to move.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


