How to Fix Date Formats in a Bank CSV
Most broken bank imports come down to dates. 03/04/2026 is March 4 in one country and April 3 in another, and a program that guesses wrong either swaps them or leaves them as text.
Steps
- Find a row with a day above 12, such as the 25th. If it shows as text or an error, the file's date order doesn't match your app or locale.
- Note the file's actual order (day-first or month-first) from that row.
- In Google Sheets, set File > Settings > Locale to a region that uses that order, then import again.
- In Excel, import with Data > From Text/CSV, choose Transform Data and set the column type to Date using a locale with that order.
- Or write the dates as YYYY-MM-DD in a new column, which most tools read without ambiguity, then re-export the CSV.
Good to know
- For a formula fix in Excel or Sheets on a day-first text date in A2: =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)). Check it on a few rows first.
- Xero asks you to confirm the format when dates are ambiguous. QuickBooks asks for one consistent format, and YNAB matches the date column when you import.
- RowSmith's Standard columns layout already writes YYYY-MM-DD, and its QuickBooks, Xero and YNAB layouts use one consistent date format.
Starting from a PDF statement?
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it. Scanned PDFs aren't supported. Convert a statement PDF
Questions
Why did only some dates convert?
Days 1 to 12 parse in either order, so they look fine but may be swapped. Days 13 to 31 fail, which is how you spot the problem.
Does saving as CSV change my dates?
It can. When a spreadsheet saves a CSV it writes dates in its own display format. Check the file in a text editor before importing.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.