Bank statements

How to import a South Indian Bank statement into an expense tracker

Import a South Indian Bank statement into an expense tracker: save your own file, choose the account, review rows, avoid overlaps and match balances.

Editorial illustration for How to import a South Indian Bank statement into an expense tracker

To import a South Indian Bank statement into an expense tracker, save the statement yourself from your banking login as a PDF, CSV or Excel file, upload it against the right account, review the rows before they are saved, and match the totals with the closing balance. If you also use a card from the same bank, import its statement as a separate account.

Which statement should you start with?

Start with the most recent complete month, because it is fresh in your memory and any odd entry will be easy to recognise. Once that month works, go back one month at a time. Each statement should cover the whole month, from the first date to the last, so the closing balance of one month can be compared with the opening of the next.

To fetch it, sign in to your own net banking or mobile banking and look for a statement or e-statement option. Menu names move around, so use the search or help feature in the app if you cannot spot it. A branch can guide you if the option is not visible.

What if you hold a savings account and a card?

Treat them separately. A savings account statement and a card statement look different and carry different meanings: one shows money in and out of your account, the other shows purchases and what you owe. Create two accounts in the tracker and import each file into its own account. If you mix them, card payments will be counted as spending twice.

StatementAccount to pickRemember
Savings accountSouth Indian Bank savingsCredits are money in, debits are money out
Credit cardSouth Indian Bank cardPurchases are spending; the payment is not
CashCashAdd by hand, several at a time

How does the import go?

  1. Pick the account first; the tracker keeps it with each row.
  2. Upload the file.
  3. Read the preview from the top, checking date, narration, amount and direction.
  4. Delete duplicates or stray lines and save.
  5. Open the import history and look for a successful status.

In SpendixAI the account is picked before the import, and rows are reviewed before they are saved. If a file fails, an Import failed notification appears, and possible duplicate imports are flagged. Because we have not seen every South Indian Bank layout, treat the first import as a test and read it slowly.

Why does the card statement not follow the calendar month?

A card statement usually covers a billing cycle, which may run from, say, the 12th of one month to the 11th of the next. Do not force it into calendar months. Import it as it comes, and write the cycle dates in your small log. Purchases keep their own dates, so a report by calendar month will still place each purchase in the month it happened.

How do you avoid overlaps?

Overlaps appear when you download 1 to 20 May and later 15 to 31 May. The days from 15 to 20 would be imported twice. The simplest cure is to keep a tiny log with the account name and the last date imported. Then each new file starts on the next date.

Does it add up?

Take invented figures. Opening balance ₹52,000, credits ₹90,000, debits ₹81,750. Then 52,000 + 90,000 - 81,750 = ₹60,250. If your statement closes at ₹60,250, the import is complete. If the card statement has a different structure, compare purchases and payments with its own summary instead.

A last tip for the first import: keep the original file after uploading. If a row later looks strange, you can open the source and compare it line by line.

  • Same date range for every account.
  • Read the first and last rows.
  • Check the closing balance.
  • Keep your small log up to date.
SPENDIXAI JOURNAL

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

Explore your reports