Each accounting software listed below imports one or more formats like
If your accounting software is not listed below, please let us know to add it to the list below. Check with your accounting software for supported import formats like OFX, QIF, CSV and see the converters below supporting conversion from your original file like PDF format.
Xero provides the CSV import option, but make sure to set the output date format to match your country settings in Xero. The CSV format is the most featured as it accepts more transaction details, and OFX choice is great as well as you do not have worry about the date format with OFX.
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.
Sage imports OFX files. Sage exists as desktop software (Sage 50, Sage 300) and online accounting service (Sage One). It is important for both Sage products that the bank ID, the branch ID, the account number on OFX files to match account settings in Sage software.
In case you have a CSV or Excel file, you can use Bank2QIF, CSV2QIF or Bank2QFX, CSV2QFX to convert your files and import them into LessAccounting. You can choose either converter - they work similar and parse your CSV/Excel in similar way.
If you have a PDF file for your bank or credit card account (the PDF file is text-based and downloaded from online banking), you can use Bank2QIF or PDF2QIF or Bank2QFX or PDF2QFX converter (choose either one).
If you have a QBO or OFX files, you can try to import them into LessAccounting as these are extended OFX files. If LessAccounting does not import them, use Bank2OFX or Bank2QIF to convert. There are also QBO2QIF or OFX2QIF converters you can use. All these converters would be suitable to create importable files to LessAccounting.
If LessAccounting is not importing your QIF/QFX file (not created by a ProperSoft converter), it could be that whoever created the file for you, may not follow the file specifications, so the file is called QIF or QFX, but it is not such inside. In this case, you can try Bank2QIF which tolerates many mistakes in files and create a correct QIF file from your file.
See above file format(s) supported by specific accounting software/service
OFX files are Open Financial Exchange files.
Convert non-importable OFX/QBO/QFX files to a correct 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