Bank statements

Track spending across Canara Bank and your other accounts

Track spending across Canara Bank and a credit card without counting twice: a worked April example showing why bill payments and purchases differ.

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

When you track spending across a Canara Bank account and a credit card, the bill payment from the bank is not new spending; it clears purchases made earlier. Count the card's own purchases in the month they happened and treat the payment as a transfer. If you count the payment instead, your totals lag by a month and will not match what you bought. The numbers here are hypothetical.

Why do two views of the same month disagree?

There are two ways to look at April. A cash view counts money leaving the bank in April. A spending view counts what you bought in April. They differ because the card bill paid in April covers March purchases.

What do the numbers look like?

Say these are the facts for April:

  • Direct payments from the Canara Bank account (rent, bills, UPI): ₹31,000.
  • Card purchases made in March: ₹18,200, paid from the bank on 5 April.
  • Card purchases made in April: ₹21,500, which will be paid in May.
ViewWorkingApril total
Cash view (bank outflow)31,000 + 18,200₹49,200
Spending view (what you bought)31,000 + 21,500₹52,500

The two differ by 52,500 − 49,200 = ₹3,300, which is simply 21,500 − 18,200, the change in card purchases from March to April. The spending view is the one to track, because it tells you what April cost.

How do I set this up?

  1. Create two accounts: Canara Bank savings and your card.
  2. Import the bank statement into the first and the card statement into the second.
  3. Label the bank's card bill payment as a transfer, not an expense.
  4. Categorise the card's purchases as usual.

Card statements often run from one date to another, such as the 12th to the 11th, which does not line up with calendar months. Pick a rule and stay with it. The easiest is to treat each purchase by its own transaction date, whatever the card's cycle says.

Will the balances still agree?

Yes, if you check each account separately. The bank's closing balance depends only on bank movements, including the card payment. The card's outstanding amount depends only on purchases less payments. The tracker keeps them apart because every transaction keeps its account, which SpendixAI does after you choose the account before importing.

What if the card cycle ends mid-month?

Import the statement for whatever period it covers and do not worry that the end date is not the month end. Reports filter by transaction date, so the purchases fall into the right month anyway. Only the closing balance check needs the exact statement dates.

How do refunds behave on a card?

A refund shows up as a credit on the card statement, often weeks after the purchase. Say a ₹2,400 online order in March is returned and the refund arrives in April. File the refund under the same category as the order, such as Shopping, rather than as income. Then April's card purchases of ₹21,500 net down to 21,500 − 2,400 = ₹19,100 in that category's total, which is the honest figure.

If the refund lands on the bank account instead of the card, treat it the same way: a negative expense in the original category, not salary and not a transfer.

Next step

After one tidy month, add a rule for the monthly card payment so that it is marked as a transfer without you thinking about it. Then look at the card's purchases by category; that is usually where the surprises are.

Look at the card by category once a month. Cards tend to collect subscriptions, online orders and fuel, which are easy to forget because no cash visibly leaves your hand. If the card total is bigger than you expected, check it for one-off annual charges before deciding that your habits changed.

SPENDIXAI JOURNAL

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

Explore your reports