Why are the dates wrong after converting my bank statement? Day and month swapped

By Kayabyte · Last updated 11 November 2026

Short answer: a date such as 03/04/2026 means 3 April in most of the world and March 4 in the United States, and a converter has to guess when every date on the statement is that ambiguous. If your dates came out with day and month swapped, check the first rows of the converted file against the PDF, switch the date order, and convert again. Dates written with a month name (3 Apr, 3 April) are not ambiguous and don’t have this problem. A second cause is the spreadsheet, not the converter: Excel can read and show dates according to your computer’s regional settings.

1. Which kind of problem is it?

Look at three or four rows and compare with the PDF.

Every date has day and month swapped (a 5 March transaction shows as 3 May): the converter read the whole statement in the wrong order, or your spreadsheet did.
Some dates are right and some are not: the file may be fine and the spreadsheet may be reading some cells as dates and others as text, because a date like 25/04 can only be day first while 03/04 can be either. Check the file in a text editor (step 2).
Dates are in the wrong year or far outside the statement period: a misread digit on a scan, or a two-digit year. Compare those rows with the original.

A quick test is to look for any date with a first number above 12 (25/04, 31/05). It can only be a day, so it tells you which order the statement uses.

2. Check the file before the spreadsheet

Open the converted CSV in a plain text editor, not in Excel. The text editor shows what is actually in the file. If the dates there are right, the converter is fine and the problem is how your spreadsheet opens them. If they are wrong there, fix the conversion.

3. Why Excel can show different dates

Microsoft’s page on formatting dates, checked 11 November 2026, says that when you type something like “2/2” Excel treats it as a date and formats it with the default date setting of the computer, and that if you change that setting, the default date format in Excel changes with it. It also says date formats that start with an asterisk follow regional settings while formats without one stay fixed. Its page does not cover importing dates from other files.

In practice, a CSV with 03/04/2026 can be read as 3 April on one computer and 4 March on another. If you share a file between countries, that is a real risk. To avoid it, keep a copy of the PDF, and check a few dates after opening the file anywhere new.

If your dates look wrong only in the spreadsheet, one safe way is to import the date column as text first and convert it yourself, then compare a few rows with the statement.

4. Fix it in Balanced

Balanced is a Mac app we make. It reads a statement (text PDF, scanned PDF, image or CSV) on your Mac, shows a preview table and checks that the transactions add up to the closing balance.

Open the statement in Balanced and look at the first rows of the preview.
Balanced picks the most likely date order from the whole statement, and a date like 25/04 settles it. When every date is ambiguous, check the first rows and switch the date order if needed.
After you switch, the table and the checks update. Compare a few rows with the PDF.
Export. The free version exports the first 5 transactions per file, so you can test your own statement before paying.

One honest limit: the date order does not change whether the totals add up, because the amounts are the same either way. A swapped order will not show up as a failed check, so you need to look at the dates yourself. Balanced’s totals check will catch a missing row, a flipped sign or a misread digit, not a swapped day and month.

Results depend on the layout of each bank’s statement, and a scanned statement can have misread digits, which the totals check usually catches. A password-protected PDF has to be unlocked first with the password from your bank.

Download Balanced and try it free: it reads and checks everything and exports the first 5 transactions per statement file. Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. macOS 15 or later. See pricing and the help page.

Questions

Can I tell the date order from the statement itself? Often yes. Look for a date whose first number is above 12, or a period printed with month names, such as “3 Apr to 2 May”.

Does Balanced guess the date order? It picks the most likely order from the whole statement. If every date is ambiguous, check the first rows yourself, as in step 2.

Why do my dates look right in the preview and wrong in Excel? Excel reads dates using the computer’s regional settings, according to Microsoft’s page checked 11 November 2026. Compare the file in a text editor, and use the text-column import if needed.

My dates are right but the totals fail. Is that the same problem? No. Date order alone does not cause a mismatch. See why converted statements don’t add up.