Bank statements

SBI Card statement PDF to Excel: convert and tidy it

Convert an SBI Card statement PDF to Excel: decide between copying and converting, unlock the file, fix dates, sign purchases and payments, and verify the balance.

Editorial illustration for SBI Card statement PDF to Excel: convert and tidy it

The best way to convert an SBI Card statement PDF to Excel is to avoid the conversion if a CSV or Excel file is available, and otherwise to treat the converted table as raw material: strip the extra rows, repair dates and amounts, add a signed amount column, and test the sheet against the statement's total amount due.

Is a PDF conversion ever perfect?

Rarely. PDFs are drawn for printing, not for spreadsheets, so columns, wrapped narrations and page breaks tend to need hand repair. We have not examined every SBI Card layout and make no claim about column order. Open your own file and write down what each column contains before you begin.

How do I get from the PDF to cells?

  • In recent Excel versions, use Data, Get Data, From File, From PDF and pick the table the preview shows.
  • Or copy from a PDF viewer and paste into a blank sheet, then use Data, Text to Columns if everything lands in one column.
  • Or use a converter you trust. Statements hold personal spending, so avoid sites you cannot vouch for.

If the PDF is locked, use the password method described by the issuer, enter it yourself, and do not pass it on. If your tool still refuses, make an unlocked copy for your own use and delete it once you are done.

What should I delete first?

  1. Everything above the transaction headings, such as the summary and reward information.
  2. Page numbers and repeated headers that became rows.
  3. The summary block at the bottom, if any.
  4. Any row where the date column is not a date. A quick way: add =ISNUMBER(A2) in a helper column, filter for FALSE, and look at each row before deleting.

How do I get dates and amounts right?

If dates are text, sort order and monthly sums will be wrong. Use Text to Columns, choose Date, and select the order day, month, year that matches your file. For amounts stored as text, the formula =VALUE(SUBSTITUTE(D2,",","")) turns 1,250.00 into the number 1250. If the amount has a trailing marker such as Cr, strip it first with =SUBSTITUTE(D2,"Cr","") inside the same formula, then record the sign in a separate column.

How do I show purchases and payments properly?

Create a signed amount: purchases positive, payments and refunds negative. If your file marks credits with Cr in column E and holds the amount in D, use =IF(E2="Cr",-D2,D2). Total this column and you have the net change in what you owe for the period.

CheckFormulaExpect
Number of transactions=COUNT(A2:A300)Same as lines on the PDF
Total purchases=SUMIF(F2:F300,">0")Matches new charges
Total credits=-SUMIF(F2:F300,"<0")Matches payments plus refunds
Net movement=SUM(F2:F300)Total due minus previous balance

How do I keep one clean workbook across months?

Use one sheet called Raw for pasted data and one called Clean for the tidy version. Each cycle, paste the new converted rows below the old ones in Raw, apply your formulas, and let Clean feed your totals. Keep a Month column so you can filter any cycle on its own.

  • Never overwrite Raw rows. Add to the bottom only.
  • Mark each batch with the statement period in a Batch column.
  • Run the four checks in the table above for every new batch before you filter or chart anything.

Does it reconcile?

Say the previous balance was ₹7,200, payments came to ₹7,200, purchases to ₹26,300 and refunds to ₹900. The net movement is 26,300 - 900 - 7,200 = ₹18,200, and the total due is 7,200 + 18,200 = ₹25,400. Compare each of these with the statement and fix any difference by finding the row, not by adjusting a total.

SPENDIXAI JOURNAL

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

Explore your reports