Fix the wrong date order in a Xero bank CSV
An accepted CSV can still contain the wrong dates. Values such as 03/04/2026 are valid in two date orders, so a successful upload does not prove that the interpretation is correct.
Work through these checks
- Compare an ambiguous date with the original bank statement. Do not infer the order from your computer locale alone.
- Use a value with a day greater than 12 to establish the expected order. Check that the rest of the export follows that same order.
- In CSVReady, confirm Day first or Month first. Xero output uses DD/MM/YYYY. Download the five-row sample and choose the corresponding format in the import screen.
- Review both the date range and net movement. If you already imported incorrect rows, review Xero’s statement correction guidance before reimporting so you do not create duplicates.
Test a sample before the full import
Choose the correct account and currency, check a known payment and receipt, and compare your date range and totals. A successful format check is not a completed reconciliation.
Check ambiguous dates locally · How uploaded data is handled
Reference: Xero statement import troubleshooting. Reviewed 13 September 2026. Menu labels can vary by region and software version.