If UPI has replaced cash for you, ATM withdrawals should fall as UPI payments rise. If withdrawals stay flat while UPI grows, you are probably still paying cash for specific things UPI does not reach, or you are spending more overall. A six-month before and after comparison shows which.
Six made-up months
| Month | Cash withdrawn | UPI spend | Cash plus UPI | Cash share |
|---|---|---|---|---|
| Month 1 | ₹12,000 | ₹8,000 | ₹20,000 | 60% |
| Month 2 | ₹11,000 | ₹11,000 | ₹22,000 | 50% |
| Month 3 | ₹9,500 | ₹14,000 | ₹23,500 | 40% |
| Month 4 | ₹7,000 | ₹17,000 | ₹24,000 | 29% |
| Month 5 | ₹7,000 | ₹18,500 | ₹25,500 | 27% |
| Month 6 | ₹6,800 | ₹20,000 | ₹26,800 | 25% |
Cash falls from ₹12,000 to ₹6,800 while UPI rises from ₹8,000 to ₹20,000. The shares are cash divided by cash plus UPI, for example 12,000 ÷ 20,000 = 60% and 6,800 ÷ 26,800 = about 25%.
What should fall, and by how much?
Compare the first three months and the last three. Average cash in the first three is (12,000 + 11,000 + 9,500) ÷ 3 = about ₹10,833; in the last three it is (7,000 + 7,000 + 6,800) ÷ 3 = about ₹6,933. That is a fall of ₹3,900, or roughly 36%.
UPI averages went from (8,000 + 11,000 + 14,000) ÷ 3 = ₹11,000 to (17,000 + 18,500 + 20,000) ÷ 3 = ₹18,500, a rise of ₹7,500. UPI grew by almost double what cash fell. So the combined total went up by about ₹3,600 a month (from about ₹21,833 to ₹25,433). In this example, UPI replaced some cash and also made extra spending easier.
Why does the withdrawal line go flat?
In months 4 to 6 the line sits near ₹7,000. That floor is usually cash for specific purposes:
- Vendors and helpers who prefer cash, such as a vegetable seller, a domestic worker or a driver.
- Temples, tips, small tolls and parking.
- Places in your area with no UPI or poor connectivity.
- A habit of keeping a reserve of cash "just in case".
A flat line is not a failure. It marks the cash you cannot easily replace, and it is useful to know that number.
How do you build this?
- For each month, total the ATM withdrawals.
- Total the UPI payments from the bank statement, excluding transfers between your own accounts.
- Compute cash share as withdrawals divided by the sum of both.
- Compare the average of the first three months with the last three.
- Write down what you think the remaining cash is for.
In a sheet, =SUMIFS($C$2:$C$500,$D$2:$D$500,"Cash withdrawal",$A$2:$A$500,">="&F2,$A$2:$A$500,"<"&EDATE(F2,1)) gives the monthly cash, and the same with a UPI tag gives UPI.
If you cannot tell, take ten UPI payments from month 6 and ask whether you would have paid cash for each a year ago. Those that you would have paid in cash are the shift; those you would not have made at all are new spending. Two or three such samples are enough to get a rough feel.
Which payments went to UPI?
Some UPI spending replaced cash and some is new. A good test is the payee: UPI payments to shops you used to pay in cash are the shift. UPI payments to online services or new merchants are additions.
Whatever you find, avoid judging yourself by one month. Cash usage swings with festivals, travel and guests, so judge the direction over at least three months.
Using an app
If you import bank statements into SpendixAI, you can group by category in the Report builder and compare cash withdrawals with the categories you pay by UPI. For the cash you still spend, add expenses by hand, singly or in a batch, so that the withdrawal does not become an unexplained line.
What to note down
- The average cash per month before and after.
- What the remaining cash is for, in a sentence.
- Whether the total rose, and why.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
