Xero.com imports OFX, QFX, QBO, QIF, CSV files.
OFX files are Open Financial Exchange files. This is a preferred format for Xero as transactions are presented only in one way.
Convert CSV/Excel/TXT files to the OFX format: CSV2OFX
Convert PDF files (text based) to the OFX format: PDF2OFX
Convert PDF files (text based) to CSV/Excel: PDF2CSV
Convert QIF files to the OFX format: QIF2OFX - this is great option to avoid the date format confusion as QIF file may have dates as DD/MM/YYYY and MM/DD/YYYY
Convert QIF/QBO/QFX files to the OFX format or fix a non-importable OFX file: Bank2OFX
QIF format ші supported by Xero. Make sure to use expected date format (based on your country settings). When you use one of 2QIF converters listed below, select the QIF target as "MS Money or other" and set expected output date format
Convert CSV/Excel/TXT files to the QIF format: CSV2QIF
Convert PDF files (text based) to QIF: PDF2QIF
Convert QFX files to the QIF format: QFX2QIF
Convert QBO files to the QIF format: QBO2QIF
Convert QIF files to the importable QIF variant: FixMyQIF
Convert QFX/QBO/OFX files to the QIF format or make your QIF file importable: Bank2QIF
Xero provides the CSV import option, but make sure to set the output date format to match your country settings in Xero.
Convert CSV/Excel files to a compatible with Xero CSV layout: CSV2CSV - Use QBO Online or Xero CSV target
This video shows how to convert a PDF file downloaded from your bank or created card account, saved as a CSV file with layout compatible with Xero accounting system using PDF2CSV Converter.