When your tracked expenses are lower than what left your bank account, the difference is usually not lost money. It is money that moved somewhere you did not label as an expense, such as cash from an ATM, a transfer to another account of your own, a card bill payment, or a payment from an account you never added. Subtract, then hunt the gap in a fixed order.
The reconciliation formula
For one calendar month and one bank account, use this.
- Total debits: add every debit line on the statement for the month.
- Tracked expenses: add every expense you recorded from that account.
- Gap = total debits minus tracked expenses.
- Explained gap: add the amounts you can identify as non-expense money movement or untracked spending.
- Unexplained gap = gap minus explained gap. Aim to bring this to a small figure, not necessarily zero.
Where does the gap usually hide?
Work through these in order, because the first few are the biggest and the easiest to confirm.
- Credit card bill payments. If you track the card's own swipes, the bill payment from the bank is the same money counted again, so it should be excluded or marked as a transfer, not an expense.
- Transfers between your own accounts, to a fixed deposit, a recurring investment, or a family member. These are real money out of the account but not necessarily spending.
- ATM withdrawals. The cash left the bank in one lump, but you spent it in many small pieces and probably tracked few of them.
- UPI payments from an account you did not import, or merchant payments you forgot to log.
- Loan EMIs, insurance premiums and standing instructions that leave quietly on a set date.
- Bank charges and fees on the statement.
A worked example with made-up numbers
Say your bank statement for the month shows total debits of ₹1,12,000, and your tracked expenses from that account add up to ₹71,000. The gap is ₹41,000. Going line by line:
| Cause | Amount | Treatment |
|---|---|---|
| Credit card bill payment | ₹22,000 | Transfer, not an expense |
| ATM withdrawals, three visits | ₹9,000 | Cash spending, partly untracked |
| Transfer to own savings account | ₹8,000 | Savings, not an expense |
| Unexplained | ₹2,000 | Check older UPI and fee lines |
The identified items total ₹39,000, leaving ₹2,000 unexplained. Three causes, one of them cash, account for nearly all of it. Nothing needs to be hunted any further than a small residual.
What do I do about cash from the ATM?
Treat a withdrawal as a pile of cash that you will spend over the next days. You have two honest options. Either record each cash spend as you go, which is accurate but tiring, or record the withdrawal as a single 'cash' expense in a category called Cash and accept that detail is lost. For many households the second option is fine, as long as you notice if the cash category keeps growing. If a month's cash feels vague, jot the three biggest cash spends and leave the rest.
Making the gap smaller every month
Mark transfers and card bill payments as non-expenses at the moment you import them, so they never inflate or confuse your totals. SpendixAI keeps each transaction attached to the account you chose before importing, flags possible duplicate imports, and lets you add the rest of your spending by hand, including cash entries in batches. The aim is that every debit on the statement is either an expense, a transfer you recognise, or a known cash pile.
A short monthly reconciliation routine
- Do it on the same day each month, after the statement is available.
- Reconcile one account at a time, never all at once.
- Write the unexplained figure down each month; if it grows, the pattern is the clue.
- Keep an eye on small, repeated debits you do not recognise and check your own bank's statement notes to identify them.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

