When the balance is lower than you expected, the money has almost always gone through one of five quiet routes: small UPI payments, autopay mandates, ATM withdrawals, bank charges, or a transfer you forgot. Pull the statement for the period and reconcile it line by line, starting from the last day your balance matched your expectation.
How do you reconcile the balance step by step?
- Note the balance on the last day you felt sure of it, from a passbook entry, an SMS you kept or a statement.
- Download the statement from that date to today, through your bank's usual route, as PDF, CSV or Excel.
- Add up all credits and all debits separately.
- Check: opening balance plus credits minus debits should equal today's balance. In a sheet: =B1+SUM(C2:C200)-SUM(D2:D200), where B1 is the opening balance, C holds credits and D holds debits.
- If it matches, the statement is complete and the gap is inside the rows. If it does not, you have missed a page or a date range.
A worked example with made-up numbers
Say you expected ₹38,000 but the account shows ₹31,481. The gap is 38,000 minus 31,481, which is ₹6,519. Going through the debit rows you find:
| Row found | Amount in rupees |
|---|---|
| Subscription renewed by autopay | 799 |
| Twelve small UPI payments to local shops | 1,240 |
| ATM withdrawal | 2,000 |
| Bank charge row | 1,180 |
| Transfer to a relative, forgotten | 1,300 |
| Total explained | 6,519 |
799 plus 1,240 is 2,039; plus 2,000 is 4,039; plus 1,180 is 5,219; plus 1,300 is 6,519. The gap is fully explained, and none of it was an error. That is the usual outcome: not theft or mistakes, just several smaller items that never reached your mental total.
Where do silent debits usually come from?
- Autopay and standing instructions: OTT plans, insurance, app subscriptions, mutual fund instalments you set up and forgot.
- Small UPI payments to tea stalls and kiranas, which feel like nothing in the moment.
- Cash withdrawals that are spent without being recorded.
- Bank charge rows, such as annual card fees or SMS and service charges. Their amounts depend on your account terms; read your own schedule of charges rather than assuming.
- Pending or held amounts that later settle as a final debit, which can make one purchase appear twice for a while.
What if a debit really is unknown?
If you do not recognise a row, do not wait. Contact your bank through the number printed on your card or the official app, and ask to raise a dispute. Note the date, amount and reference. Never read out an OTP to anyone who calls you about a debit, whoever they say they are, and do not install apps at a stranger's request.
How do you stop it happening again?
- Do this reconciliation once a month, on the same day.
- Keep a list of every autopay and mandate you have and review it quarterly.
- Set a low-balance reminder on your own calendar for the day before big debits such as EMI.
- Record cash withdrawals as a spend when you take them out, then adjust as you use the cash.
Where can SpendixAI help?
You pick the account (bank, card or wallet) when you import, so each transaction keeps its account and you can look at one account at a time. Imports show a status, possible duplicate imports are flagged, and the Possible duplicate charges report lists the same amount to the same merchant within two days. SpendixAI does not connect to your bank, so the balance check above still uses the figures from your statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

