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?
- Open the PDF on your laptop. Select the table with your cursor and copy it.
- 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.
- If your Excel has a Get Data from PDF option, that can pull whole tables; it varies by version, so check what yours offers.
- 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
| Date | What it was | Amount in ₹ |
|---|---|---|
| 03/09 | SAMPLE FOOD APP BENGALURU | 289.00 |
| 06/09 | SAMPLE BOOK SHOP DELHI | 540.00 |
| 09/09 | SAMPLE FOOD APP BENGALURU | 312.00 |
| 15/09 | SAMPLE OTT SUBSCRIPTION | 149.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
Useful ideas start with a clearer picture of your own spending.
Explore your reports
