Bank statements

How to import a Standard Chartered statement into an expense tracker

Import a Standard Chartered statement into an expense tracker: download your own copy, choose PDF, CSV or Excel, pick the account, review rows and check the balance.

Editorial illustration for How to import a Standard Chartered statement into an expense tracker

To import a Standard Chartered statement into an expense tracker, download your own statement for a clear date range, upload it as PDF, CSV or Excel, choose the matching account, and review every row before saving. Then compare the imported totals with the opening and closing balance printed on the statement. If those figures agree, the import can be trusted.

Where do I find my Standard Chartered statement?

Sign in to your account on your own phone or computer and look for a section called statements, e-statements or account statement. Menus change from time to time, so search by those words rather than following a fixed path you read somewhere. You will normally be asked for the account, a date range and a file format. Download the file to your own device.

We cannot describe every layout the bank uses, and layouts can change. That is why the checks later in this article matter more than any promise that a file will read perfectly the first time.

Which format and date range should I pick?

  • If CSV or Excel is offered, choose it first. Each transaction is already a separate row, so there is less to untangle than with a PDF.
  • Use PDF when it is the only option, or when you want a copy that looks exactly like the bank's own record.
  • Pick whole calendar months, or whole quarters, so the dates are easy to remember.
  • Never overlap ranges. If March ends on the 31st, the next file starts on 1 April.
  • Keep the original file in a folder named by month, so you can go back to it if a row looks odd.

How do I import it, step by step?

  1. Choose the account the statement belongs to before you upload anything. SpendixAI keeps the account with every transaction, so a savings account and a salary account never get mixed together.
  2. Upload the PDF, CSV or Excel file. You can upload more than one file in a batch if you are catching up on several months.
  3. Open the preview and read the rows. Look at the first and last row, a few UPI lines and any large amount.
  4. Fix anything that looks wrong, then save. Rows are only added once you confirm them.
  5. Open the import history and make sure the status shows the file as done, not failed.

How do I check the totals against the closing balance?

A statement is a small piece of arithmetic: opening balance, plus credits, minus debits, gives the closing balance. Say your opening balance is ₹42,000, credits for the month add up to ₹65,000 and debits add up to ₹51,300. Then 42,000 + 65,000 - 51,300 = ₹55,700, and that should be the closing balance on the statement.

Now compare the imported rows with the same three numbers. The table shows what a mismatch usually means.

What you compareIf it does not match
Total of imported credits against the statement creditsA credit row was skipped, or a refund was read as spending
Total of imported debits against the statement debitsA debit row is missing, or one was imported twice
Number of rows against the number of lines on the statementA page of the PDF was not read, or a header line became a row
First and last dates against the date range you asked forThe wrong file, or an overlap with an earlier import

What if I have a year of old statements to bring in?

Do it in order, oldest first, and check each month before moving to the next. Importing twelve files at once feels efficient, but if the third one was wrong, the other nine inherit the confusion. A calm pace is quicker in the end.

  1. Download one financial year in monthly pieces, April to March, so every file has a clean start and end.
  2. Import April and run the balance check. Only then import May.
  3. Keep a small note beside each month: file name, date range, row count, and whether the balance matched.

If a month refuses to tie out, leave it flagged in your note and carry on. You can return to it once the rest is in, and a single hard month rarely spoils the other eleven.

What do I do after the first import?

  • Look for possible duplicates if you ever uploaded an overlapping range. SpendixAI flags likely duplicate imports so you can decide.
  • Set up categories for the merchants you pay most often, so next month sorts itself.
  • Repeat the balance check each month for the first three months, then spot-check.
  • Keep cash spending out of the statement import and add it by hand.

A short routine beats a clever setup: download, import, check the closing balance, categorise what is left. It takes a few minutes once you have done it twice.

SPENDIXAI JOURNAL

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

Explore your reports