Bank statements

Track spending across HDFC Bank and your other accounts

A worked setup for tracking an HDFC Bank account with another account and a credit card without double counting transfers or card bill payments.

Editorial illustration for Track spending across HDFC Bank and your other accounts

Give every source its own account in your tracker when you follow spending across an HDFC Bank account and the rest. Import each statement into the right one, mark transfers between your own accounts as movement, and count card purchases once, not again when you pay the bill. At month end, tally each account against its closing balance.

What does a typical three-source setup look like?

Say you have an HDFC Bank salary account, a second savings account for emergencies, and one credit card. Name them so you can spot them in a list:

  • HDFC Bank Salary, where income lands and UPI payments leave
  • Emergency Savings, which rarely has spending
  • Main Credit Card, where most online purchases happen

Pick the account before you import, because each transaction keeps the account it came in with. Reports can then be filtered by account or combined.

Why does card spending get counted twice?

It happens when the grocery purchase of ₹3,200 appears on the card statement and the card bill payment of the whole month appears in the bank statement. Both are real lines, but they are the same money. The purchases are the spending; the bill payment only settles them.

ItemWhere it appearsSpending?
Grocery purchase ₹3,200Card statementYes
Fuel purchase ₹2,800Card statementYes
Card bill payment ₹6,000HDFC Bank accountNo, it settles the two above
Rent ₹15,000 by UPIHDFC Bank accountYes

Here the true spending is ₹3,200 plus ₹2,800 plus ₹15,000, which is ₹21,000. Counting the bill payment too would give ₹27,000, an overstatement of ₹6,000.

How should I treat transfers between my own accounts?

Moving ₹10,000 from the salary account to the emergency savings account shows as a debit in one and a credit in the other. Neither is spending or income. Give both lines a transfer category and leave them out when you look at spending. If you forget, your income and spending both look inflated by ₹10,000.

How do I stay on top of it every month?

  1. Download each account's statement for the same month.
  2. Import them one at a time, each into its own account, reviewing rows before saving.
  3. Mark transfers and the card bill payment.
  4. Check each account's total against the closing balance on its statement.
  5. Add cash spending by hand, in a single batch if you have several.

What does the month look like when you add it up?

Say the HDFC Bank salary account received ₹60,000 and shows ₹21,000 of direct spending, the ₹6,000 card bill payment and a ₹10,000 transfer to savings. The card shows ₹6,000 of purchases. Spending is ₹21,000 plus ₹6,000, which is ₹27,000 against ₹60,000 of income. Saved: ₹10,000. Left in the salary account: ₹60,000 minus ₹21,000 minus ₹6,000 minus ₹10,000, which is ₹23,000 before counting the opening balance. These are invented figures, but any month should reconcile like this.

What if a second account is not an HDFC Bank account?

The method does not change. We cannot say how any particular bank formats its statements, so check that dates and amounts look right in the preview. SpendixAI shows rows before saving, and it flags possible duplicate imports if you upload an overlapping period by accident.

One more habit helps: do the check on the same day each month, for example the second, once all the previous month's statements are available. A fixed day turns it into a routine, and the work stays small because each account only has a month of lines to review. Skipping two months makes the mismatch hunt much harder than doing it monthly.

A checklist to keep

  • One account per bank account, card or wallet.
  • Transfers and card bill payments labelled, never counted as spending.
  • Closing balance tallied for every account, every month.
  • Cash entered by hand before you read the month's report.
SPENDIXAI JOURNAL

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

Explore your reports