DD/MM or MM/DD? How to read bank statement dates
A date such as 03/04/2026 is ambiguous: it means 3 April in DD/MM/YYYY format or March 4 in MM/DD/YYYY format. Confirm the statement’s convention before exporting transactions.
Which dates are clear, and which are ambiguous?
If the first number is greater than 12, the date must use DD/MM/YYYY. If the second number is greater than 12, it must use MM/DD/YYYY. When both numbers are 12 or lower, the date alone cannot tell you which convention was used.
| Printed date | What it tells you | Example reading |
|---|---|---|
| 18/04/2026 | First number is greater than 12 | DD/MM/YYYY: 18 April 2026 |
| 04/18/2026 | Second number is greater than 12 | MM/DD/YYYY: April 18, 2026 |
| 03/04/2026 | Both numbers could be a month | Ambiguous without more evidence |
How can I confirm the statement’s date convention?
- Look for a printed format label, a date legend, or an explicit statement period.
- Check a transaction date where one part is greater than 12, if the statement includes one.
- Compare the first and last transaction dates with the statement period and any source records you trust.
- If every date could be read both ways, do not guess from one date. Check the bank’s source information or ask the account holder.
A country, language, or currency can provide context, but it is not enough to prove the date format on an individual document.
What should I check in ExtractMint?
- Compare the displayed date convention with the printed statement before relying on the converted rows.
- When the format is ambiguous, choose DD/MM/YYYY or MM/DD/YYYY from the statement review controls.
- Recheck the statement period, first transaction, and last transaction after making the choice.
- Review dates in the downloaded file before importing or sharing it.
ExtractMint keeps an ambiguous-date warning visible and disables QBO export until you choose a convention. Choosing a format resolves the ambiguity for conversion; it does not confirm the dates are correct, so compare the result with the source.
When opening the exported CSV in Excel, use the Excel import guide to apply explicit column types and locale, then recheck that the dates still match the statement.
Example: a short statement period
Suppose an invented statement shows dates from 03/04/2026 to 07/04/2026. Under DD/MM/YYYY, the period is 3–7 April 2026. Under MM/DD/YYYY, it is March 4–July 4, 2026. The printed statement period or another unambiguous date should decide which reading is right.
Continue your statement review
- Check opening and closing balances after choosing the date convention.
- Review descriptions, columns, and page breaks against the source PDF.
- Choose CSV, Excel, or QBO for the next step.
A matching balance is only an arithmetic cross-check. It cannot prove that every date or transaction was extracted correctly.