To check your spending against your bank balance, add the opening balance and everything that came in, then subtract the closing balance. The result is what left the account. With an opening balance of ₹4,200, salary of ₹48,000 and a closing balance of ₹1,800, ₹50,400 left. If categorised spending is ₹44,900, ₹5,500 is unexplained.
What is the formula?
Money out equals opening balance plus money in minus closing balance. Here: 4,200 plus 48,000 is 52,200, and 52,200 minus 1,800 is ₹50,400. This works for any period, and any account, as long as you include every credit. If a refund or a friend's repayment also came in, add it to money in.
How do you find the unexplained ₹5,500?
Subtract what you have already categorised: 50,400 minus 44,900 is ₹5,500. That is money that left the account and is not yet matched to a spending line. It usually hides in a few places.
| Possible source | What to look for | Hypothetical amount |
|---|---|---|
| Credit card bill payment | A single large debit to the card issuer | ₹3,000 |
| Cash withdrawals | ATM debits with no matching expenses | ₹1,500 |
| Transfer to own savings | Money moved to another account of yours | ₹800 |
| Bank charges and fees | Small recurring debits | ₹200 |
| Total found | Matches the gap | ₹5,500 |
Check the sum: 3,000 plus 1,500 is 4,500; plus 800 is 5,300; plus 200 is 5,500. Your own split will differ, but this is the order in which to look: largest first.
Which of these is spending and which is not?
- A card bill payment is not new spending if you have already recorded the card purchases. Counting both double counts it.
- A transfer to your own savings is not spending at all. It is the savings part of your savings rate.
- Cash withdrawals are spending you have not yet itemised. Treat them as a placeholder until you can name what they bought.
- Charges and fees are real spending, small but regular.
- A transfer to another person is spending or lending, and should be noted.
Be careful with the card. If you track card purchases and also count the bill payment, your total will be too high. If you do not track the card at all, the bill payment is your only record of that spending, and you should split it into categories using the card statement.
What if the numbers still do not match?
Check the basics before chasing small items. Is the date range the same on both sides? Did a credit arrive on the last day, which belongs to the next month? Did you include an amount twice, such as a UPI payment that appears both as a bank debit and a card debit? Fix those first. Then work through the largest unmatched debit, then the next.
It helps to express the gap as a share so you can compare months. ₹5,500 against a ₹48,000 salary is about 11.5 percent. Next month, if the unexplained amount is ₹2,000 on ₹48,000, that is about 4.2 percent, and you can see your tracking improving even though the rupee amounts will never match exactly.
Can you speed this up with a tool?
If you import the statement into SpendixAI, you choose the account first, so every transaction keeps its account, and you review rows before saving. That makes it easier to see which debits are card bills or cash, and to compare category totals with the statement's own opening and closing balances. The checking is still yours, and statement layouts differ, so confirm that the totals agree.
A reconciliation routine
- Write the opening balance, total credits and closing balance for the period.
- Compute money out with the formula above.
- Total your categorised spending and subtract it.
- Place the remainder into card bills, cash, transfers and charges.
- Record anything left as unexplained, and look at it again next month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

