Each accounting software listed below imports one or more formats like OFX, QFX, QBO, QIF, CSV files. Scroll down for each format section to see converters converting to this format.
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.
All conversions and formats mentioned below are supported by the ProperConvert app.
See below file format(s) supported by specific accounting software/service
OFX files are Open Financial Exchange files. This format ia the most popular. Apps like Xero, Sage, FreeAgent, MS Money, ZarMoney and others import OFX files. For most software and online services, OFX is the first choice. However, there are few OFX variants, make sure to select correct "OFX file type" targeting your accounting app. When not sure, select option "OFX all apps".
OFX format has the transaction ID (reference ID) when QIF does not. Reference ID (when supplied by your bank) allows you to skip already imported transactions.
OFX files should be created differently for different software (Microsoft Money for Us, non-US, old Microsoft Money 99, 2000, and also other software like Sage).
The ProperConvert app convert PDF statements for bank and credit card transactions. The following transaction details are extracted from PDF files:
These details are matched with required OFX transaction details: date, amount, payee, memo, check number.
To convert XLS, XLSX, Excel, CSV to OFX (Excel file to OFX format), you can use the following method.
Prepare your Excel file
QIF format is supported by Xero. Make sure to use the expected date format (based on your country settings). When you use one of the 2QIF converters listed below, select the QIF target as "MS Money or other" and set the expected output date format:
ZarMoney imports OFX, QFX files.
Sage imports OFX files. Sage exists as desktop software (Sage 50, Sage 300) and an 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 match account settings in Sage software.
Use the ProperConvert app to convert your transaction files to required by FreeAgent file format (OFX, QFX, QBO, QIF are supported, but OFX provides the best results).
You could get a transactions file from your Online Banking and if FreeAgent does not import it right away, you may convert ot a comtablie and correct OFX format, using ProperSoft converter. For example, if your have a PDF file for bank or credit card statement, convert it to the OFX format first.
OFX, QIF, or CSV files must have the Payee names, as with any Online accounting system. It's not necessarily exactly the same, as in your accounting system or even if doesn't have any names, like "Payment". You have to categorize or match that specific transaction to a vendor record, and an expense or income account:
When you start working with your transactions, the system can guess next time, when you import an OFX file, because you already match certain descriptions to certain Vendors or certain Payees. So you can guess next time.
QBO (also called QuickBooks OFX) files are similar to OFX files with additional Quickbooks related details. These additional details do not matter for FreeAgent. If your QBO file is not imported directly by FreeAgent, convert it first to a compatible QBO file (or to the OFX file described earlier). The steps to import QBO files are identical to steps to import OFX files.
QFX files, also known as Quicken OFX files, are similar to OFX files but include additional details specific to Quicken. These extra details are not necessary for FreeAgent. If your QFX file is not directly imported by FreeAgent, you can first convert it to a compatible QFX file or an OFX file. The steps to convert QFX to QBO files are the same as those for importing OFX files.
QIF files (also called Quicken Interchange File) are different from OFX/QFX/QBO files. You need to pay attention to the date format (MM/DD/YYYY vs DD/MM/YYYY) and the decimal separator for amounts (dot vs coma), also the amounts should not the thousand separator to bring less confusion to FreeAgent.
Your QIF file may not be compatible with FreeAgent. Use the ProperConvert to convert your QIF to OFX and the import created OFX file into FreeAgent.
To import transactions from a PDF file into FreeAgent, convert it first to OFX format using the ProperConvert app. The app extract date, amount, description, check number from PDF files for bank and credit card statements. The payee name is extracted from the transaction description by removing common known parts, dates, numbers and other things. You may use included renaming feature to further detect certain payee names and set the payee name to match closely the vendor name in FreeAgent.
LessAccounting supports QIF and QFX import. If you have transactions in these formats, you should be fine and just import those files.
In case you have a CSV or Excel file, you can convert your files to QIF or QFX format and import them into LessAccounting.
If you have a PDF file for your bank or credit card account, you can use the ProperConvert converter.
If you have 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 the ProperConvert app to convert.
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 the ProperConvert app which tolerates many mistakes in files and create a correct QIF file from your file.
Microsoft Money Sunset Edition imports QIF and OFX files. It also imports QBO and QFX files (see below how to import). There are some differences between QIF and OFX/QFX/QBO import (see below), but overall either QIF or OFX are fine to use for import.
Use the ProperConvert app to convert your transaction files to required by your accounting software file format.
QBO and QFX files are extended OFX files. As MS Money follows the OFX specification, it should import QBO and QFX files as OFX files. To import a QFX or QBO file, try the following in MS Money: