To flag ATM cash withdrawals, add a column with =IF(ISNUMBER(SEARCH("ATM",A2)),"Cash",""), where A2 holds the narration. Then total the flagged rows by month with SUMIFS. The flag is the easy part. The useful part is noticing how much cash you took out and how little of it you can later account for.
What is the basic flag formula?
SEARCH returns the position of a word inside text, or an error when it is missing. ISNUMBER turns that into TRUE or FALSE, and IF turns it into a label:
- =IF(ISNUMBER(SEARCH("ATM",A2)),"Cash","")
- SEARCH ignores upper and lower case, so atm and ATM both match.
- Fill the formula down, then filter the new column for Cash.
The weak spot is that SEARCH finds the letters anywhere. A merchant whose name contains ATM inside a longer word would be flagged by mistake. Searching for "ATM " with a trailing space, or "ATM/", cuts down such false matches. Check how withdrawals appear on your own statement first, since different banks use different words.
How do you search for several keywords at once?
Put your keywords in a small list, say H2:H6, for example ATM and CASH WDL. These are examples, so replace them with the wording you actually see. Then use SUMPRODUCT to ask whether any of them appears:
- =IF(SUMPRODUCT(--ISNUMBER(SEARCH($H$2:$H$6,A2)))>0,"Cash","")
- Leave no blank cells inside the range, since an empty keyword matches every narration.
How do you total cash withdrawn each month?
Put the first day of the month in a cell such as H1, the narration flag in column F, the date in column B and the debit amount in column D:
- =SUMIFS($D$2:$D$500,$F$2:$F$500,"Cash",$B$2:$B$500,">="&$H$1,$B$2:$B$500,"<"&EDATE($H$1,1))
EDATE moves the date forward one month, so the formula adds up every Cash row from the first of the month up to, but not including, the first of the next. Change H1 to look at another month.
Why give cash its own category?
An ATM withdrawal is not spending. It is money moved from your account into your pocket, and the real spending happens later, at a chai stall, a vegetable cart or a tip. If you give it a category called Cash, you can see how much left the account in that form. If you do not, it can look like a mysterious chunk of one big expense.
A worked example with invented numbers. Say you withdrew ₹5,000, ₹3,000 and ₹2,000 in October. The Cash total is 5,000 + 3,000 + 2,000 = ₹10,000. You then write down cash spending of ₹4,200 on groceries and local travel. That leaves 10,000 - 4,200 = ₹5,800 of cash you cannot account for. It may still be in your wallet or it may have gone on small things nobody noted.
| Item | Amount |
|---|---|
| Cash withdrawn in October (3 withdrawals) | ₹10,000 |
| Cash spending you noted | ₹4,200 |
| Cash not accounted for | ₹5,800 |
How do you track cash after it leaves the ATM?
- Note cash spends in a separate small list, or a notes app, as you go. Doing it at the end of the day works better than at the end of the month.
- Batch them weekly into the same sheet with a Cash account or payment mode.
- Look at the gap each month. A gap that is large and unexplained is a sign to withdraw smaller amounts, or to pay by UPI where it suits you.
SpendixAI lets you add several expenses at once by hand, which is handy for cash, and keeps each transaction against an account that you choose, so a Cash account can sit beside your bank and card accounts. A sheet does the same job if you are disciplined about updating it.
A short checklist
- Find the exact words your bank uses for withdrawals, and write them in the keyword list.
- Add the Cash flag and filter for false matches.
- Total by month with SUMIFS.
- Log cash spending, then compare it with the withdrawals.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

