Spending that shows up in months you were not even in college means the dates in your pocket-money sheet are being read the wrong way round. Change the locale or convert the date text with a short formula, then check that every row sits in the right month. It is a ten-minute fix, and you only need to learn it once.
What does the problem look like on a student sheet?
You download your account statement for August, import it into a sheet and the monthly chart shows spending in January and March as well. Or the first week of the month looks empty while the end looks crowded. Both are symptoms of the same thing: dates written day first were read month first, so 04/08/2026 became 8 April.
How do you fix it in Google Sheets?
- Open File, then Settings, and look at the Locale. Set it to India, which writes dates day first.
- If the dates are already text, the locale will not repair them. Use a helper column.
- In a helper column, type =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)) for text like 04/08/2026.
- Fill it down, copy it, and Paste special as values only over the original.
- Format the column as Date and sort.
In Excel the helper formula is the same. For a whole column in one go, use Data, then Text to Columns, pick Date and choose DMY.
A worked example with pocket money
Say your parent sends ₹7,500 on 01/08/2026 and you pay ₹1,800 for a hostel mess advance on 03/08/2026 and ₹650 for a bus pass on 05/08/2026. Read month first, those become 8 January, 8 March and 8 May, so August shows nothing, and your sheet says you spent ₹0 in the month you actually spent ₹2,450 (1,800 plus 650). The money then looks as if it vanished into the wrong months. After conversion, August shows ₹7,500 in and ₹2,450 out, leaving ₹5,050 for the rest of the month.
| Printed date | What it is | Wrong reading |
|---|---|---|
| 01/08/2026 | pocket money ₹7,500 | 8 January |
| 03/08/2026 | mess advance ₹1,800 | 8 March |
| 05/08/2026 | bus pass ₹650 | 8 May |
How do you check you got it right?
- Add a month column with =MONTH(A2). August rows should all say 8.
- Sort by date. The first row should be the statement's first date.
- Look for text still left-aligned in the date column.
- Compare your total with the closing balance difference on the statement.
Can an app skip this?
SpendixAI takes a statement as a PDF, CSV or Excel file and shows the rows with their dates before saving, so you can see that the first date matches the start of the month. The Free plan covers statement import, default categories and the dashboard. Do not assume every layout will parse perfectly; the review step is where you catch a date that looks off.
What if the dates are mixed, some fixed and some not?
After a partial fix you may have a column where half the rows are real dates and half are text. Do not fix the text ones by hand. Add a helper column with =ISNUMBER(A2); TRUE means a real date and FALSE means text. Filter for FALSE, convert only those rows with the DATE formula, and clear the filter.
Then sort the whole column once. If the order looks right from first to last, you are done. If a row sits out of place, look at its day and month; it is usually one that was converted twice.
Next time you download a statement
- Download it as CSV or Excel if the bank offers it.
- Check the first and last dates before you do anything else.
- Fix the dates once, then save the sheet as your template.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


