Bank statements

State Bank of India statement PDF to Excel: convert and tidy it

Convert a State Bank of India statement to Excel, repair text amounts with NUMBERVALUE, and add month and April to March year columns.

Editorial illustration for State Bank of India statement PDF to Excel: convert and tidy it

To turn a State Bank of India statement into an Excel table, take the CSV or Excel download if your own login offers it. If you only have a PDF, use Data, Get Data, From File, From PDF in Excel for Microsoft 365 or a recent desktop version. After loading, the main job is repairing amounts that arrive as text, then adding month and financial-year columns so the table is ready for totals.

Why will my amounts not add up?

A converted PDF often stores numbers as text, with commas, and sometimes with a Dr or Cr tag attached. Click an amount: if it sits at the left of the cell, or SUM returns zero, it is text. We cannot tell you how your own file is written, so look at ten amounts before choosing a formula. With the text in C2, these work in Excel and in Google Sheets:

  • =NUMBERVALUE(C2,".",",") reads 12,450.75 as the number 12450.75.
  • =NUMBERVALUE(SUBSTITUTE(SUBSTITUTE(C2,"Dr",""),"Cr",""),".",",") strips a trailing Dr or Cr tag first.
  • =IF(RIGHT(C2,2)="Dr",-1,1)*NUMBERVALUE(SUBSTITUTE(SUBSTITUTE(C2,"Dr",""),"Cr",""),".",",") gives debits as negatives and credits as positives.

NUMBERVALUE takes the text, the decimal separator and the group separator, in that order. Trim stray spaces with TRIM if a cell still refuses to convert.

What if the narration spreads over two rows?

Long narrations may wrap in a PDF and arrive as a row with only text under the transaction. Before you convert numbers, find those rows by filtering for a blank date, copy the text up into the narration of the row above, and delete the extra row. If you skip this, your row count will not match the statement, and any total you build will be fragile.

How do I add a month and a financial-year column?

Once dates are real dates in column A, add two helper columns so the data can be summarised:

ColumnFormulaWhat it gives
Month=TEXT(A2,"mmm-yyyy")A label such as Apr-2026
Month start=EOMONTH(A2,-1)+1The first day of that month, a real date
FY start year=IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1)2026 for April 2026 to March 2027

The FY column is the one that saves headaches around March and April. A transaction on 28 March 2027 has an FY start year of 2026, and one on 2 April 2027 has 2027. Filter by it and each financial year stands alone.

How do I total a year without a pivot table?

With the cleaned signed amount in D and the FY start year in F, spending (negative amounts) for the year starting April 2026 is:

  • =SUMIFS($D$2:$D$2000,$F$2:$F$2000,2026,$D$2:$D$2000,"<0")
  • Change "<0" to ">0" to total credits.
  • Use ranges rather than whole columns so that totals stay quick on a large sheet.

How do I prove the sheet is complete?

Take any month and check the arithmetic: opening balance plus credits minus debits equals closing balance. Say the opening balance is ₹31,200, credits ₹58,400 and debits ₹49,975. The closing balance should be ₹31,200 plus ₹58,400 minus ₹49,975, which is ₹39,625. If your sheet lands elsewhere, sort by date and look for a page that was missed or a debit that was read as a credit.

Save the cleaned table with the helper columns visible and the formulas intact on one tab, and a values-only copy on another. The formula tab lets you recheck your logic, while the values tab is safe to sort and filter without breaking anything, and it opens quickly even after several years of data have been added.

When should I stop doing this by hand?

A cleaned sheet suits a single year or a one-off check. If you repeat the clean-up monthly and then want categories as well, a tracker is the logical next step. SpendixAI takes PDF, CSV or Excel statements and shows the rows for review before saving, so the repetitive part moves out of your sheet while you keep the closing-balance check.

SPENDIXAI JOURNAL

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

Explore your reports