Bank statements

IDFC FIRST Bank statement PDF to Excel: convert and tidy it

Convert an IDFC FIRST Bank PDF or CSV statement into a clean Excel or Sheets table: fix dates, text amounts and stray rows, then check the balance.

Editorial illustration for IDFC FIRST Bank statement PDF to Excel: convert and tidy it

To turn an IDFC FIRST Bank statement into a clean Excel or Sheets table, start with the CSV or Excel download if the bank offers one, because PDF conversion is the messiest route. If you only have the PDF, convert it, fix the dates, turn text amounts into numbers, delete the stray rows, and prove the result by checking it against the closing balance.

Should you copy from the PDF or convert it?

Copy and paste is the quickest test. Select the table in the PDF, paste it into a sheet, and see whether each value lands in its own cell. If everything arrives in one column, use Text to Columns in Excel, or Split text to columns in Google Sheets, to separate it. If the pasted data is badly scrambled, Excel 365 can read tables straight from a PDF through Data, Get Data, From File, From PDF, which often does better than pasting. Be careful with free online converters, since you would be uploading your bank statement to a stranger's server.

We cannot say how the columns in an IDFC FIRST Bank statement are ordered, so check yours before applying any formula below, and adjust the column letters to match.

How do you fix the dates?

Indian statements write dates day first. A sheet set to a US locale may read 05/04/2025 as the fourth of May. If your dates are stored as text such as 05/04/2025 in cell A2, this formula builds a true date:

  • =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))
  • Fill it down, copy the results, and use Paste Special, Values only, over the original.
  • Format the column as a date and sort it. If the order is jumbled, the dates were misread.

If the date already shows as a date but is wrong, change the file's locale rather than fixing each cell. In Google Sheets this is under File, Settings.

How do you turn text amounts into numbers?

Amounts like 1,25,000.50 often arrive as text, so SUM returns zero. Say the debit sits in D2. This formula strips the commas and converts:

  • =VALUE(SUBSTITUTE(D2, ",", ""))
  • Wrap it as =IF(D2="", 0, VALUE(SUBSTITUTE(D2, ",", ""))) to turn blank cells into zero.

Do the same for the credit column. Then every amount is a number and sums behave.

Which rows should you delete?

Remove everything that is not a single transaction: the account summary at the top, repeated column headings on each page, page-number lines and any closing or total row. A quick way to find the repeats is to filter the date column for blanks and for the word Date, then delete those rows. Keep one header row.

How do you check the sheet against the statement?

Say the statement shows an opening balance of ₹20,000 and a closing balance of ₹23,250, with debits in column D and credits in column E. Put these checks in empty cells:

CheckFormulaYou should see
Total debits=SUM($D$2:$D$500)The debit total printed on the statement, if it has one
Total credits=SUM($E$2:$E$500)The credit total printed on the statement, if it has one
Closing balance=20000+SUM($E$2:$E$500)-SUM($D$2:$D$500)₹23,250, the closing balance on the statement

If the check misses by a round figure, a row is missing or was deleted by mistake. If it misses by a small odd number, one amount was misread.

What should you save at the end?

  • The original statement file, untouched.
  • The cleaned sheet, named with the bank and the period.
  • A note of the closing balance you verified against.
SPENDIXAI JOURNAL

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

Explore your reports