Bank statements

Track spending across Punjab National Bank and your other accounts

Track spending across Punjab National Bank and other accounts: one account per source, transfers left out, card bills not counted twice, with a worked month.

Editorial illustration for Track spending across Punjab National Bank and your other accounts

Money you merely moved between your own accounts is not spending, and neither is a card bill payment. For a Punjab National Bank account and your others, treat each source as its own account, count only real purchases, then check each closing balance on its own statement. A worked month below shows the numbers fitting together; all figures are hypothetical.

What does a simple three-account setup look like?

Say you have a Punjab National Bank salary account, a savings account at another bank and one credit card. Create three accounts in your tracker with names you recognise. Import each statement into its own account so that every transaction keeps its source.

How does one month move through the accounts?

AccountOpeningMoney inMoney outClosing
Punjab National Bank salary₹20,000₹55,000₹50,400₹24,600
Other bank savings₹80,000₹10,000₹0₹90,000
Credit card (amount owed)₹0₹14,600 spent₹14,600 paid₹0

The salary account's outflow of ₹50,400 is rent ₹16,000, UPI spending ₹9,800, a transfer to savings ₹10,000 and a card bill payment of ₹14,600. Check: 16,000 + 9,800 + 10,000 + 14,600 = ₹50,400. Closing is 20,000 + 55,000 − 50,400 = ₹24,600.

So what did I actually spend?

Not ₹50,400. Remove the ₹10,000 transfer, because it also appears as money in on the savings account, and remove the ₹14,600 card payment, because the card's own purchases are counted instead. Real spending is rent 16,000 + UPI 9,800 + card purchases 14,600 = ₹40,400.

How do I label transfers so they stay out of spending?

  1. Create a category called Transfer between own accounts.
  2. Add a rule for the regular monthly move and for the card bill payment.
  3. Treat the matching credit on the receiving account in the same way.
  4. Skim for large round-figure debits each month and ask whether they were moves.

What do I check at month end?

Compare each account's closing balance in the tracker with the one on its own statement. For the card, compare the outstanding amount. If one is off, the difference is the number to look for; do not tolerate small gaps, because they tend to be missing rows.

Does importing several accounts create problems?

Only if you mix them. SpendixAI asks you to pick the account before an import, and keeps it with each transaction, so the same payment is never attached to the wrong source. Import history shows what went into which account, and possible duplicate imports are flagged.

What mistakes show up most often?

  • Counting the card bill payment as spending as well as the card purchases. This is the biggest one, and it inflates the month by the whole bill.
  • Forgetting that a transfer has two sides. The ₹10,000 sent to savings leaves the salary account and enters the savings account; if only one side is imported, one balance will be wrong.
  • Importing the card statement for one period and the bank statement for another, so the payment and the purchases it cleared land in different months.
  • Leaving out an account because it feels small. A wallet or a second savings account with a few thousand rupees can hold the very payment that explains a difference.

Next month is not a fresh start either. The salary account should open at ₹24,600, savings at ₹90,000 and the card at ₹0, exactly where this month closed. If a new statement opens anywhere else, something happened between the two files, and it is better to find it now than after six months.

A short routine

  • Download all three statements for the same calendar month.
  • Import each into its own account.
  • Mark transfers and the card bill payment.
  • Match the three closing balances.

Once a quarter, add one more look: list the three biggest spending categories for each month and see whether any jumped. A sudden rise usually has an ordinary cause, such as an annual premium or a festival month, but it is far easier to explain while you remember it.

SPENDIXAI JOURNAL

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

Explore your reports