Bank statements

Standard Chartered statement PDF to Excel: convert and tidy it

Convert a Standard Chartered statement PDF to Excel and tidy it: handle protected files, fix dates, split debit and credit, drop balance rows and check the total.

Editorial illustration for Standard Chartered statement PDF to Excel: convert and tidy it

The cleanest route from a Standard Chartered statement PDF to Excel is to download the CSV or Excel version if the bank offers one, and convert the PDF only when it does not. Whichever way you go, the job is the same: one header row, one transaction per row, real dates, separate debit and credit columns, and a total that matches the statement's closing balance.

Should I copy the PDF text or convert it?

Copying and pasting from a PDF often puts each line in a single cell, or joins the narration with the amount. Excel's own import from PDF (in the Data tab of recent versions) reads tables better and lets you choose which table to bring in. Online converters exist, but a bank statement is private, so think before uploading it to a website you do not know. Converting on your own computer is the safer habit.

We do not know the exact column order Standard Chartered uses, so open your own file and write down the columns you see before you start cleaning.

What if the PDF is password protected?

Many bank PDFs open only with a password the bank has told you how to form. Check the e-mail or message that came with the statement for the instruction. Open the file yourself, on your own device. If your converter cannot read a protected file, use your PDF viewer to save an unprotected copy for your own use, then delete that copy when you are finished.

How do I tidy the table once it is in Excel?

  1. Delete everything above the header row: the account summary, address block and page titles.
  2. Delete the repeated header that appears at the top of each page of a multi-page PDF. Sort the sheet on a helper column, or use a filter on the date column and remove rows that are not dates.
  3. Fix the date column. If dates are left-aligned they are text. Select the column, use Data, Text to Columns, choose Date and the order day, month, year.
  4. Turn amount text into numbers: remove commas and spaces, and check that nothing says Dr or Cr inside the cell.
  5. Delete the running-balance column from your analysis, but keep a copy of the sheet before you do, because you will need it for the check.

How do I split debit and credit?

Some statements give one amount column with a Dr or Cr marker, others give two columns. You want one signed amount, or two clean columns. Suppose the marker sits in column D and the amount in column C. A signed amount in column E can be built with this formula.

  • =IF(D2="Cr",C2,-C2)
  • Copy it down every row. Credits stay positive and debits become negative.
  • If you have separate Debit and Credit columns instead, use =N(F2)-N(E2) with credit in F and debit in E, so blanks count as zero.

How do I verify the result?

Say the opening balance is ₹18,500, the sheet's credits total ₹72,000 and its debits total ₹66,250. Then 18,500 + 72,000 - 66,250 = ₹24,250, which must equal the closing balance on the statement. If it does not, compare the row count with the transaction count you can see in the PDF, look for a page whose rows were dropped, and look for a row that was pasted twice.

What if the statement runs to many pages?

Long statements are where conversions go wrong, usually at page boundaries. A row can be cut in two, or the last row of one page can arrive without its amount. Scroll to the bottom of each page in the sheet and read the last two rows and the first two rows of the next page against the PDF.

  • Count the transactions per page in the PDF, and count the rows per page in the sheet.
  • Look for rows whose date is blank but whose amount is filled in. They are often orphaned pieces of a split row.
  • Look for two amounts in one cell, a sign that two lines were merged.

Ten minutes spent on page boundaries is cheaper than hunting a ₹499 difference across two hundred rows afterwards.

When is a sheet no longer worth it?

Cleaning one statement by hand is fine. Cleaning twelve, every year, for several accounts, is tedious. SpendixAI accepts statements as PDF, CSV or Excel, shows the rows for review before saving and keeps the account with each one, so the clean-up work happens once instead of in every file.

SPENDIXAI JOURNAL

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

Explore your reports