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.
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.