To forecast next month's cash from your bank statements, take the last three monthly statements, find the average weekly money coming in, list the payments that repeat on fixed dates, and then project four weeks forward. With made-up figures the steps give a clear view of the tight weeks. The method works from your own records instead of guesses.
What do I need before I start?
- Bank statements for the last three full months of the account the shop uses, downloaded from your own bank in PDF, CSV or Excel. Check your bank's own site or branch for the route, since each differs.
- A rough note of cash sales that never reach the account, such as cash spent straight on tea, labour or a vegetable vendor.
- Your opening balance today.
Remember a statement shows only what went through the bank. If part of your takings is spent in cash before deposit, the statement will understate both sales and spending.
How do I find the average weekly money in?
Add all the credits that are real sales: UPI collections, card settlements and cash deposits. Leave out transfers between your own accounts and any loan credit. Say the three months show ₹1,62,000, ₹1,48,000 and ₹1,70,000. The total is ₹4,80,000, and the average month is ₹1,60,000.
Three months is about 13 weeks, so the average weekly inflow is ₹4,80,000 ÷ 13 = ₹36,923. Round to ₹36,900 for the forecast. Looking at the range also helps: the lowest month was ₹1,48,000, which is about ₹34,000 a week, so keep that in mind as a cautious case.
How do I find the payments that repeat?
Go down the debit side of each statement and mark anything that appears every month. Write the date and the amount. Made-up examples:
| Payment | Usual date | Amount |
|---|---|---|
| Wages to helpers | 1st | ₹12,000 |
| Shop rent | 5th | ₹15,000 |
| Loan EMI | 10th | ₹10,000 |
| Electricity | around the 18th | ₹3,500 |
| Supplier payments, weekly average | every week | ₹28,000 |
For supplier payments, add up the debits to suppliers in the three months and divide by 13. If that comes to ₹3,64,000, the weekly average is ₹28,000.
How do I project four weeks ahead?
Lay out four weeks, put each fixed payment in the week of its date, add the weekly inflow and weekly supplier payments, and carry the balance forward. Start with ₹20,000. Week 1 covers the 1st to 7th, week 2 the 8th to 14th, week 3 the 15th to 21st and week 4 the 22nd to 28th.
| Week | Opening | Inflow | Suppliers | Fixed payments | Closing |
|---|---|---|---|---|---|
| 1 (1st to 7th) | ₹20,000 | ₹36,900 | ₹28,000 | ₹27,000 | ₹1,900 |
| 2 (8th to 14th) | ₹1,900 | ₹36,900 | ₹28,000 | ₹10,000 | ₹800 |
| 3 (15th to 21st) | ₹800 | ₹36,900 | ₹28,000 | ₹3,500 | ₹6,200 |
| 4 (22nd to 28th) | ₹6,200 | ₹36,900 | ₹28,000 | ₹0 | ₹15,100 |
The forecast shows a thin cushion in weeks 1 and 2, when wages, rent and the EMI follow each other. Week 1 fixed payments are ₹12,000 plus ₹15,000, which is ₹27,000. Nothing here is wrong, but a slow first week would push the account below zero.
What should I add or adjust?
- Known one-off payments: insurance, licence renewal, a repair, a festival order.
- Months with unusual deposits, such as one big wholesale customer, so they do not inflate the average.
- Cash taken out from the till and not deposited, if you spend it in the shop.
- Any change in terms: a supplier moving from credit to cash, a wage rise, a new EMI.
Can a tool read the statements for me?
If you upload the three statements to SpendixAI, you choose the account first and review the rows before saving. Then you can group debits by category, such as suppliers, wages and rent, and see monthly totals without adding them by hand. Any statement layout may not parse perfectly, so check the rows against your own statement.
A month-end routine
- Download the new statement when the month closes.
- Update the average weekly inflow with the latest three months.
- Add or move any fixed payment that changed.
- Roll the forecast forward four weeks and look at the lowest closing balance.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

