To analyse your ATM withdrawals, list every cash withdrawal for six months and work out four numbers: how many, the total, the average size and which days of the month they fall on. Those four show whether you take cash out in a few planned lumps or in many small top-ups, and the pattern points to different habits.
Six months of made-up data
| Month | Withdrawals | Total | Average |
|---|---|---|---|
| April | 5 | ₹12,000 | ₹2,400 |
| May | 4 | ₹10,000 | ₹2,500 |
| June | 6 | ₹14,000 | ₹2,333 |
| July | 3 | ₹9,000 | ₹3,000 |
| August | 4 | ₹10,000 | ₹2,500 |
| September | 6 | ₹15,000 | ₹2,500 |
| Six months | 28 | ₹70,000 | ₹2,500 |
Across the six months the count is 28 and the total ₹70,000, so the overall average is 70,000 ÷ 28 = ₹2,500, and the monthly average is about ₹11,667. Notice that the monthly average of the averages is not the same as the overall one; use total over count.
How do you compute it in a sheet?
Mark each row with a category such as Cash withdrawal. With dates in A, amounts in C and category in D, and the first day of each month in F2 downward: count is =COUNTIFS($D$2:$D$500,"Cash withdrawal",$A$2:$A$500,">="&F2,$A$2:$A$500,"<"&EDATE(F2,1)). Total is the same with SUMIFS and $C$2:$C$500 as the first argument. Average is =IFERROR(H2/G2,0), if G is count and H is total. For the day of the month, add =DAY(A2) in a helper column and count withdrawals by day.
What do few big and many small withdrawals mean?
Take two people who both withdraw ₹15,000 in a month. One withdraws three times at ₹5,000; the other 15 times at ₹1,000. The first is planning: a lump for rent to a landlord who takes cash, a domestic worker's pay, a market trip. The second tops up often, perhaps because a small balance in the wallet is easy to spend. Neither is wrong, but the second is more likely to hide where the money went.
- A few big withdrawals: look for fixed cash payments and ask if they could move to UPI.
- Many small withdrawals: look at whether each was needed, and whether there is a bank fee for extra withdrawals; check your own bank's terms.
- Withdrawals clustered after the first few days of the month point to a salary-driven pattern.
- Withdrawals on weekends or before festivals point to planned cash use.
When in the month do you withdraw?
Plot the day of the month for each of the 28 withdrawals. If most land between the 1st and 7th, you are drawing cash after payday for the whole month. If they are spread out, you probably refill the wallet as it empties. A cluster just before a festival is usually shopping or gifts, not routine.
Do fees and limits matter?
Some banks allow a certain number of free withdrawals at other banks' machines and charge for the rest. The rules differ by bank and change, so check your own account terms and your statement rather than assuming. If you see charges on your statement, count them as their own line: ten small withdrawals can cost more in fees than two bigger ones.
Tracking the cash itself
If you want the real picture, log cash spending in a note each day, or in a tracker. SpendixAI lets you add expenses by hand, singly or several at once, which suits a weekly catch-up of cash payments. Keep the withdrawal as the source and the hand-entered items as the spend.
Next steps
- Count, total and average the last six months.
- Note the days of the month.
- Decide which pattern you have: few big or many small.
- Choose one change, for example one planned withdrawal a week, and test it for two months.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


