When the cash in your wallet is lower than your log says it should be, the gap is simply spending you did not record. To measure it, add your opening cash, any withdrawals and any cash received, subtract the spending you logged, and compare the result with what you actually count. The difference is your untracked cash, and it is worth recording as its own entry.
What is the reconciliation formula?
Think of your wallet as a tiny bank account. Money goes in, money goes out, and the balance should be predictable.
- Opening cash: what you counted at the start of the period
- Plus withdrawals: cash you took out at an ATM or counter
- Plus cash received: for example a friend repaying you in notes
- Minus logged cash spending: everything you wrote down
- Equals expected cash: what should be in your hand right now
Then count what is really there. Actual cash minus expected cash is the difference. A negative number means you spent more than you logged. A positive number means you logged something that did not actually leave your wallet, or forgot a cash receipt.
A worked example with made-up numbers
Suppose you start the month with ₹3,500 in cash. You take ₹5,000 out of an ATM, and a friend hands you ₹1,000 to settle an old dinner. Your log shows ₹6,120 of cash spending. At month end you count ₹2,650.
| Step | Amount |
|---|---|
| Opening cash | ₹3,500 |
| Plus ATM withdrawal | ₹5,000 |
| Plus cash from friend | ₹1,000 |
| Minus logged cash spending | ₹6,120 |
| Expected cash | ₹3,380 |
| Actual cash counted | ₹2,650 |
| Difference | minus ₹730 |
The sum is 3,500 plus 5,000 plus 1,000 minus 6,120, which is 3,380. You counted 2,650, so ₹730 left your wallet without being logged. In a spreadsheet the expected figure is simply =B2+B3+B4-B5 and the difference is =B7-B6, with your cells laid out in that order.
Should you hunt for the missing ₹730?
Usually not. Spend five minutes thinking about the big items, such as a cash payment at a function or a one-off repair, because those are easy to forget. If nothing comes to mind, stop looking.
Record the gap as an entry called Untracked cash, dated at the end of the period. Your monthly total now matches reality. Without that entry, your reports would show a month that is ₹730 cheaper than it truly was.
Is the difference telling you something?
Yes, and this is the useful part. The size of the untracked entry compared with your logged cash spending is a score for your logging habit. In the example, ₹730 against ₹6,850 of total cash use (6,120 plus 730) is about 11 percent. That is the share of cash you could not account for.
Track that number each month. If it falls from one month to the next, your habit is improving. If it jumps, something changed: a trip, a festival, a lost note, or a week when you simply stopped logging.
What if the difference is positive?
Check three things before assuming you gained money.
- A withdrawal you counted twice, once from the statement and once from a note
- A cash receipt, such as a refund or repayment, that you did not add to the formula
- An expense you logged as cash that you actually paid by UPI or card
The third one is very common. If the same purchase appears in both your cash log and your bank statement, you have double counted it, and your wallet will always look fuller than the log expects.
Where an app helps
If you add your cash expenses by hand into SpendixAI and import statements for the ATM withdrawals, the cash side of the formula is already in one place. You still count the wallet yourself. The app cannot see the cash in your hand, so the actual figure always comes from you.
A reconciliation checklist
- Write down your opening cash on the first day
- Keep every ATM withdrawal and cash receipt in the same list
- Count your wallet on a fixed day each month
- Add an Untracked cash entry for the gap
- Note the gap as a share of total cash use and compare month to month
Useful ideas start with a clearer picture of your own spending.
Explore your reports


