Budgeting

Reconcile salary to spending: opening ₹4,200, closing ₹1,800

Reconcile your bank balance with your expenses: opening ₹4,200 plus salary ₹48,000 minus closing ₹1,800 means ₹50,400 left, but only ₹44,900 is explained.

Editorial illustration for Reconcile salary to spending: opening ₹4,200, closing ₹1,800

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 sourceWhat to look forHypothetical amount
Credit card bill paymentA single large debit to the card issuer₹3,000
Cash withdrawalsATM debits with no matching expenses₹1,500
Transfer to own savingsMoney moved to another account of yours₹800
Bank charges and feesSmall recurring debits₹200
Total foundMatches 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

  1. Write the opening balance, total credits and closing balance for the period.
  2. Compute money out with the formula above.
  3. Total your categorised spending and subtract it.
  4. Place the remainder into card bills, cash, transfers and charges.
  5. Record anything left as unexplained, and look at it again next month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports