How to Track Your Expenses Using Your Bank Statement

Most personal finance apps ask you to manually enter transactions. Your bank statement has all of that data already. Using it saves hours of data entry.

Download and import

Download your statement as Excel or CSV. Open it in Google Sheets or Excel. Your transactions are already in rows with dates and amounts. Add a column called "Category" and start tagging each row: Food, Transport, Bills, Shopping, and so on.

Create a pivot table

Once categories are assigned, create a pivot table with categories as rows and the sum of debit amounts as values. This gives you a clean breakdown of spending by category for the month. Update it monthly to see trends.

Finding subscriptions you forgot about

Sort your statement by the narration column. Subscription charges appear as recurring debits with the same narration every month. Count them up. Many people find 5-10 active subscriptions they barely use. Canceling two or three can save Rs 500-2,000 per month.

Setting a monthly target

Once you have two or three months of categorized data, you can see your actual spending patterns. Set realistic limits for each category based on what you spent, not what you think you should spend. Gradual cuts work better than sudden ones.