Bank statements

Fixing messy ICICI and SBI card statement rows as a student

A student-friendly way to move a card statement into a sheet, fix split description lines, and see where pocket money went, using a small ₹ example.

Editorial illustration for Fixing messy ICICI and SBI card statement rows as a student

If you have a card on a small limit and want to see where your pocket money goes, the statement PDF is a poor starting point because long descriptions wrap onto extra lines and break copy and paste. You can fix that with one helper column, then add a single column for the type of spend, and in about fifteen minutes you will see your month in four or five totals.

First, a word on where you upload things

Statements contain your name, your card's last digits and every place you shop. Avoid dropping them into random free converter sites, and never use a shared lab or library computer for this. Work on your own device, and if the card is in a parent's name, ask them before you handle the statement.

How do I get the table into a sheet?

  1. Open the PDF on your laptop. Select the table with your cursor and copy it.
  2. Paste into a new Google Sheet or Excel file. If everything lands in one column, try Data then Split text to columns in Sheets, or Text to Columns in Excel.
  3. If your Excel has a Get Data from PDF option, that can pull whole tables; it varies by version, so check what yours offers.
  4. Keep this raw tab untouched. Do your work on a second tab.

Fix wrapped lines with one formula

Say dates are in column A, descriptions in B and amounts in C. In D2 type =IF(A2="","",B2&IF(AND(A3="",B3<>"")," "&B3,"")) and fill down. Rows with a date now carry the full description. Filter column D to hide blanks and you have one row per purchase.

A small example

DateWhat it wasAmount in ₹
03/09SAMPLE FOOD APP BENGALURU289.00
06/09SAMPLE BOOK SHOP DELHI540.00
09/09SAMPLE FOOD APP BENGALURU312.00
15/09SAMPLE OTT SUBSCRIPTION149.00

Add a column E called Type and write Food, Books, Food, Subscription. Then =SUMIFS($C$2:$C$100,$E$2:$E$100,"Food") gives 289 + 312 = ₹601. Books is ₹540 and the subscription is ₹149. Total spent: 601 + 540 + 149 = ₹1,290.

What can I learn from it?

Suppose your monthly pocket money is ₹5,000 and the card was the only place you spent. Food at ₹601 is 601 / 5,000 = about 12 percent of it. Nothing alarming, but if food were ₹2,400 you would see at once that it is nearly half. The point is not to feel guilty; it is to see the pattern before the next month starts.

What about cash and UPI?

A card statement covers only the card. If you also pay friends on UPI and spend cash, you only see part of your month. Keep a second tab for those, or note them at the end of each day.

If you later want this done automatically, SpendixAI is free to start with statement import and default categories, and you choose which account a statement belongs to before importing. It does not read SMS or connect to your bank, so you upload files yourself.

Can I do this with a phone only?

You can, but it is fiddly. Mobile spreadsheet apps handle a pasted table, and the join formula works the same way. The painful part is checking totals on a small screen, so if you can, open the file on a laptop for the first set-up and then use the phone for adding a tag or two. Whatever device you use, keep the statement itself in a folder only you can open.

Keep it simple checklist

  • Work only on your own device
  • Raw tab untouched, work on a copy
  • One row per purchase after the helper
  • Total matches the statement
  • Four or five types, not twenty
SPENDIXAI JOURNAL

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

Explore your reports