Wrong dates after an Excel statement import are almost always a day and month mix-up: the file says 03/04/2026 meaning 3 April, but the importer reads it as 4 March. Check a date whose day is above 12, see how it was read, and convert the column to real dates with an explicit day-month-year formula.
Why does the same date read two ways?
Indian statements write day first, so 03/04/2026 means 3 April. Software set to a US style reads month first, so the same text means 4 March. When the day is 13 or more, such as 15/04/2026, a month-first reader cannot make sense of it and leaves it as text. That is why you often find a column where some dates look fine and others are left-aligned.
How do you spot the problem quickly?
- Dates left-aligned in the cell are probably text
- Dates that jump out of order, with March and April mixed
- A date showing as a five-digit number such as 46115, which is a serial number that needs a date format
- Transactions that show up in the wrong month when you total them
A worked example with made-up dates
| Statement says | Read as | Should be |
|---|---|---|
| 03/04/2026 | 4 March 2026 | 3 April 2026 |
| 07/04/2026 | 4 July 2026 | 7 April 2026 |
| 15/04/2026 | Left as text | 15 April 2026 |
If the first two are saved with the wrong month, a ₹12,000 rent paid on 3 April lands in March totals, and March looks ₹12,000 heavier than it was. A column like this can quietly move whole payments across months.
How do you repair the dates?
If the dates are text in the form 03/04/2026 in A2, this builds a true date: =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)). Format the result as a date. It works in Excel and Google Sheets. If your text has dashes or a different length, adjust the positions. For a serial number such as 46115 in a cell, just apply a date format to the cell.
- Copy the original file first.
- Add a new column with the DATE formula and fill down.
- Copy the new column, paste as values, and delete the old one.
- Format as dd-mmm-yyyy so the month shows as a word and cannot be misread.
How do you check the repaired column?
- Sort by the new date and check that the first and last dates match the statement period.
- Check that the number of rows for each month looks right.
- Compare a running total for the month with the bank's closing balance change.
- Spot check five transactions against the original statement.
How do you stop it happening again?
- Download the statement in the same format each time, and note which date style it uses
- Use a dd-mmm-yyyy format in your sheet
- Check the first import of every new account for swapped days and months before importing the rest
- Keep a text copy of the original file, so you can always compare
Banks sometimes change the layout of exported files after an app update, so a file that imported correctly last month can fail this month. A thirty-second glance at the date column catches this.
What about the import tool?
If an importer shows a date preview, read it before saving. SpendixAI shows rows for review before saving, so look at the dates, especially the ones where the day is 12 or below, and fix the file if they look swapped. It also keeps an import history, so a mistaken import can be traced. Any statement layout may not parse perfectly, so the preview is your safety net.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


