All import guides

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

  1. Compare an ambiguous date with the original bank statement. Do not infer the order from your computer locale alone.
  2. 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.
  3. 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.
  4. 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.

Open the matching converter →

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.