Bank statements

How to import a SBI Card statement into an expense tracker

Import an SBI Card statement into an expense tracker: get the statement file, choose the card account, check the preview and match it to the total amount due.

Editorial illustration for How to import a SBI Card statement into an expense tracker

Importing an SBI Card statement into an expense tracker means getting the statement file from your own account, uploading it in the format you have, selecting the right card account, and reading the preview before saving. The test of success is simple: the imported purchases, payments and charges should agree with the total amount due on the statement.

How do I get the statement?

Sign in to your own card account on your own device and look for statements or e-statements, or open the one that was e-mailed to you. Wording varies, so use those two words as your guide. If a choice of formats appears, take CSV or Excel before PDF. We cannot tell you how an SBI Card file is laid out, and layouts can change, so check what you get.

Is the billing cycle a calendar month?

Often it is not. The statement has a period from one date to another, and a due date after it. Write the period on the file name, such as the start date, an underscore and the end date. Then the next file can start the day after, and you never overlap or leave a gap. This one habit prevents most duplicate rows.

What does the import look like?

  1. Add the card as an account in the tracker, named so you will recognise it.
  2. Select that account before you upload. In SpendixAI the account is chosen first and each transaction keeps it.
  3. Upload the PDF, CSV or Excel file.
  4. In the preview, check that purchases look like purchases, payments look like payments and refunds are not shown as spending.
  5. Save, then check the status in the import history. If it says failed, you will also get a notification.

How do I check it against the total amount due?

Say the statement shows a previous balance of ₹12,400, payments of ₹12,400, purchases of ₹18,900, a refund of ₹650 and no fees or interest. The total amount due is then 12,400 - 12,400 + 18,900 - 650 = ₹18,250. Check your imported rows: purchases ₹18,900, refund ₹650, payment ₹12,400. If a fee or finance charge exists, it must be on the statement too, so include it.

Imported figureStatement figureIf they differ
Sum of purchasesPurchases or new chargesA row is missing or doubled
Sum of paymentsPayments receivedA payment was read as spending
Sum of refundsCredits or reversalsA refund was read as a purchase
Net amountTotal amount due, less previous balanceA fee or interest line was skipped

What do I do if the import goes wrong?

  • Download the same period as another format and try that.
  • Check the file is the card statement and not a letter or an offer document.
  • If a PDF is locked, open it yourself using the password method the issuer described, and keep that password private.
  • Do not edit amounts to force a match. Find the missing row instead.

What should I do about annual or one-off charges?

A card may charge an annual fee, a renewal or a one-time item that appears once a year. These are easy to mistake for an error on first sight. Look at the narration, compare it with your past statements, and put it in a card-charges category so it is not hidden inside shopping.

If you are unsure what a line is, do not delete it. Leave it categorised as Needs review, and ask the issuer through its official channels. Whatever the answer, the row stays in the record because it was part of the amount you owed.

What should I do each cycle?

Download, import, compare with the total due, categorise what is left and mark your bank-side payment as a transfer. The first time takes a few minutes longer. After that, rules for your regular merchants do most of the work.

SPENDIXAI JOURNAL

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

Explore your reports