Skip to content
BankConv
Get started

Bank statement date fixer

Open a bank CSV, pick the date column and the format your software wants, and download the file with every date rewritten. It reads “03 SEP” and “Sep 3” dates with no year, month names, two-digit years and rows with no date.

Runs in your browser. Your file is never uploaded.

2 · Choose the formats

3 · Check and download

Paste a CSV to begin.

Date shapes it reads

These all come out as 2026-09-03 (or the format you choose):

In the fileNotes
03 SEPNo year: uses the statement year you set
Sep 3Month first, no year
MAR03Month and day run together
03-SEP-26Two-digit year
3 sept. 2026French and Spanish month names
03.09.26Dots instead of slashes
09/03/2026US or day-first: you choose, or it detects
20260903Compact year-month-day

Questions

Why won’t my accounting software accept the dates in my bank CSV?

Importers expect one date format for the whole file, usually the one you pick on the import screen. Bank exports often print “03 SEP” with no year, a month name, or a day-first date that a US importer reads as month-first. Rewriting the column into one format fixes it.

What happens to dates with no year?

They get the statement year you set. If the statement runs from December into January, tick “Statement crosses into a new year” and every date after the year turns over gets the next year.

Some rows have no date at all.

Many statements print the date only on the first transaction of each day. Tick “Fill blank dates from the row above” and those rows get the date of the transaction before them.

How does it tell 03/09 (3 September) from 03/09 (March 9)?

If any date in the column has a first number over 12, it must be day-first; if the second number is over 12, it must be month-first. When every date is ambiguous, it assumes month-first, so check the detected order and change it if your bank is outside the US.

Does it change anything else in the file?

No. Only the date column is rewritten. Every other column is kept as it was, and the file is saved as a comma-separated CSV.

Is my file uploaded?

No. The CSV is read and rewritten by JavaScript in this page.

More free tools