Bank statements

How to import a HSBC India statement into an expense tracker

Import an HSBC India statement into an expense tracker: fetch your own copy, upload PDF, CSV or Excel, choose the account and tie the rows to the closing balance.

Editorial illustration for How to import a HSBC India statement into an expense tracker

Importing an HSBC India statement into an expense tracker takes four moves: get your own statement for a set period, upload the PDF, CSV or Excel file, assign it to the right account, and read the preview before you save. The last step is a balance check, so you know the import matches what the bank recorded.

Where does the statement come from?

After signing in to your own account, look for the statement or e-statement area. Banks reorganise their menus, so use those words as your guide and do not trust a menu path from an old article. The bank may also send periodic statements to your registered e-mail. Either source works, as long as the file is the bank's own.

We have not seen every HSBC India layout, and you should not assume one will read cleanly. The verification steps below are what keep you safe.

Do I need a PDF, CSV or Excel file?

FormatGood forWatch out for
CSVClean rows, fastest to checkDates in an unusual order, amounts with commas
ExcelSame as CSV, with tidier columnsExtra summary rows above the table
PDFA faithful copy of the statementPage breaks, wrapped narrations, locked files

If the bank gives you a choice, try CSV or Excel first and keep the PDF as your reference copy.

How do I get the rows in correctly?

  1. Decide the period. A calendar month is simplest.
  2. Select the account in the tracker first. In SpendixAI you pick the bank, card or wallet before importing, and each transaction stays with that account.
  3. Upload the file. Use a batch upload if you have several months waiting.
  4. In the preview, check the first row, the last row and the three biggest amounts against the statement.
  5. Save only when the preview matches. Then look at the import history to confirm the status.

How do I tie the import to the closing balance?

Take three numbers from the statement: opening balance, total credits, total debits. Say they are ₹96,400, ₹1,10,000 and ₹1,02,350. Then 96,400 + 1,10,000 - 1,02,350 = ₹1,04,050, which should be the closing balance. Now add up the imported rows yourself, or run the report in your tracker for the same dates. The credits and debits should equal the statement's.

What if the file will not import?

  • Try the other formats. A CSV may succeed where a PDF failed.
  • If the PDF is protected, open it with the password the bank described, using your own device, and keep the password private.
  • Check you uploaded a statement and not a different document, such as a credit advice or a tax certificate.
  • Look for an Import failed notification and the status in the import history.

How do I keep the import history tidy?

A short naming habit saves trouble. Rename each downloaded file to the account, the start date and the end date before you upload it. A name such as hsbc-salary-2026-04-01-to-2026-04-30 tells you at a glance what is inside and whether the next file should start on 1 May.

  • Store the original in a folder you can find later.
  • Never edit the original. If you must fix something, work on a copy.
  • Note the opening and closing balance in a text file next to the statement. It takes thirty seconds and makes next month's check easy.

If the tracker shows two imports covering the same dates, look at the second one before saving it. Same amount, same merchant, within two days is the usual sign of a repeat, and a repeat is easier to stop than to unpick.

What do I tidy up afterwards?

Review the uncategorised rows, add rules for repeated merchants, and look at the report for possible duplicate charges if you ever overlapped periods. Then put a reminder in your calendar to repeat the download at the start of each month.

SPENDIXAI JOURNAL

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

Explore your reports