Bank statements

Track spending across Union Bank of India and your other accounts

Track spending across Union Bank of India and other accounts with a month-end reconciliation table that shows exactly which account is out and by how much.

Editorial illustration for Track spending across Union Bank of India and your other accounts

The reliable way to track spending across Union Bank of India and your other accounts is a month-end reconciliation. For each account, take the opening balance, add what came in, subtract what went out, and compare with the statement's closing balance. Whichever account does not match shows you where a row is missing or doubled. All figures below are hypothetical.

What does a reconciliation table look like?

AccountOpeningInOutComputed closingStatement closingDifference
Union Bank of India₹30,000₹72,000₹58,400₹43,600₹43,600₹0
Second bank₹55,000₹8,000₹21,300₹41,700₹42,150₹450
Credit card (owed)₹6,000₹14,200 spent₹6,000 paid₹14,200₹14,200₹0

The first row: 30,000 + 72,000 − 58,400 = ₹43,600, which agrees with the statement. The second: 55,000 + 8,000 − 21,300 = ₹41,700, but the statement says ₹42,150. The card: 6,000 + 14,200 − 6,000 = ₹14,200, which also agrees.

What does a ₹450 difference tell me?

The statement's closing balance is ₹450 higher than the tracker's computed one. So the tracker has ₹450 more going out than the bank did, or ₹450 less coming in. The most common causes are a payment imported twice or a credit that was not imported. Search that account for a debit of exactly ₹450, or for two identical debits of any amount.

Where do I look first?

  1. Search the amount: ₹450 as a debit, and as a credit.
  2. Look for pairs of identical rows on the same day.
  3. Check the first and last day of the statement; edge rows are the easiest to miss.
  4. Check the import history to see whether the same file went in twice.

SpendixAI has a report listing the same amount paid to the same merchant within two days, and it flags possible duplicate imports, both useful here.

What about transfers between the accounts?

A transfer from Union Bank of India to the second bank appears twice: out of one account and into the other. Both rows stay in the tracker so that each account's balance is right, but neither counts as spending. If your totals ignore that, one account will be fine and the other overstated.

What if one statement has not arrived?

Some cards and accounts issue statements later than others. Do not wait for all of them. Reconcile the accounts you have and write down which one is pending, so the month is not silently treated as finished.

Work in an order that helps you: the bank accounts first, because they are complete as soon as the month ends, then the card. Do not guess missing figures. A line marked pending is honest; an estimate dressed up as a statement figure will mislead you in a year's time.

How do I compute spending after reconciling?

Add the categorised spending from each account, leaving out transfers and the card bill payment. Because every balance was proved, you can trust that nothing is missing from the total.

A final checklist

  • Opening balance equals last month's closing.
  • In minus out gives the statement's closing figure.
  • Transfers and bill payments are labelled.
  • Differences, even small, are explained.

Keep the whole thing in perspective. The aim is not a perfect ledger but a month you can explain. If three of four accounts reconcile exactly and the fourth is out by ₹30, note it and move on; chasing every rupee costs more time than it saves.

Larger gaps deserve attention at once. A difference of several thousand rupees means a whole row, or even a whole file, has gone missing or been imported twice. Fix that first, because every report you look at afterwards is built on it.

Over a year this routine takes twelve short sittings and gives you something worth having: a record in which each balance has been proved against the bank's own figure.

SPENDIXAI JOURNAL

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

Explore your reports