Bank statements

Excel statement import showing wrong dates: how to fix it

Dates wrong after importing a bank statement from Excel? Learn why day and month swap, how to repair them with formulas, and how to check the result.

Editorial illustration for Excel statement import showing wrong dates: how to fix it

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 saysRead asShould be
03/04/20264 March 20263 April 2026
07/04/20264 July 20267 April 2026
15/04/2026Left as text15 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.

  1. Copy the original file first.
  2. Add a new column with the DATE formula and fill down.
  3. Copy the new column, paste as values, and delete the old one.
  4. Format as dd-mmm-yyyy so the month shows as a word and cannot be misread.

How do you check the repaired column?

  1. Sort by the new date and check that the first and last dates match the statement period.
  2. Check that the number of rows for each month looks right.
  3. Compare a running total for the month with the bank's closing balance change.
  4. 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.

SPENDIXAI JOURNAL

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

Explore your reports