Bank statements

Yes Bank statement PDF to Excel: convert and tidy it

Yes Bank statement PDF to Excel in Google Sheets: import the file, build a signed amount, drop blank rows with QUERY and total each month with SUMIFS.

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

To bring a Yes Bank statement into Google Sheets from a CSV or converted PDF, upload the file with number and date conversion switched on, build one signed amount column, drop blank rows with QUERY, and total months with SUMIFS. The formulas below are for Google Sheets; most also work in Excel, and where one does not, it says so. Column letters are examples because we have not assumed this bank's layout.

How do I get the file into Sheets?

  1. Download the statement from your own net banking as CSV or Excel if the bank offers it.
  2. In a blank sheet choose File, then Import, then Upload.
  3. Pick Replace current sheet or Insert new sheet.
  4. Keep the option to convert text to numbers and dates ticked, and set the locale to India first, so day comes before month.

A PDF cannot be imported like this. Use a CSV or Excel version, or copy text from a real-text PDF and paste it in.

How do I create one signed amount column?

Say A is Date, B Narration, C Debit, D Credit. In E1 write Amount, and in E2 enter one formula for the whole column:

=ARRAYFORMULA(IF(A2:A="","",IF(D2:D<>"",D2:D,-C2:C)))

This is a Google Sheets formula; Excel would use a normal formula copied down instead. If it returns an error, check that amounts are numbers and not text.

How do I remove blank rows?

Blank lines between pages are common. This QUERY builds a clean copy elsewhere:

=QUERY(A1:E500,"select * where A is not null",1)

The 1 at the end tells Sheets that the first row is a header. Keep the original tab untouched so you can compare.

How do I total a month?

Put the month's first day in H1, for example 01/04/2026, and enter:

=SUMIFS($E$2:$E$500,$A$2:$A$500,">="&H1,$A$2:$A$500,"<"&EDATE(H1,1))

This adds every amount from 1 April up to but not including 1 May. Change H1 to see another month. It works in Excel too, as EDATE exists there.

How do I total by category once rows are labelled?

Add a Category column F and fill it in, by hand or with a lookup. Then, with the month's first day in H1, this total works in Sheets and Excel:

=SUMIFS($E$2:$E$500,$F$2:$F$500,"Groceries",$A$2:$A$500,">="&$H$1,$A$2:$A$500,"<"&EDATE($H$1,1))

To list each category once in Google Sheets or Excel 365, use =UNIQUE($F$2:$F$500) in a free cell, then put the SUMIFS formula beside each name, referring to its cell instead of the typed word. A pivot table does the same thing without formulas if you prefer clicking to typing.

What is a quick accuracy test?

Use the opening and closing balances. Say you start at ₹52,000 and the signed amounts for April add up to ₹6,430. Then 52,000 + 6,430 = ₹58,430 should be the closing balance on the statement. In the sheet: =52000+SUM($E$2:$E$500). If it is off, search for a number equal to the difference.

Do I need all this every month?

The sheet is fine for a one-off clean-up or a small number of statements. Month after month it asks for the same repair work, and an expense tracker like SpendixAI can take the statement file directly, with rows shown for your review before they are saved.

If you stay with Sheets, a few habits pay off. Keep one tab per month named in an obvious way, such as 2026-04. Put your formulas in the header row or on a separate summary tab so they are not overwritten when you paste a new file. And leave the original download untouched in a Raw tab, so that a broken formula never costs you the source data.

Share the sheet with nobody unless you must; it contains a month of your payees and balances.

SPENDIXAI JOURNAL

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

Explore your reports