Make transaction files work with Wave, Sage, FreeAgent, LessAccounting and others
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.
For Xero, convert to OFX or QFX or QBO or QIF or CSV formats.
Import into Sage One, Sage 50, Sage 300 converting to the OFX format.
wave Accounting imports QFX, OFX.
FreeAgent imports CSV, QIF, QFX.
LessAccounting imports QIF, QFX.
ZarMoney imports OFX, QFX.
YNAB imports CSV, QIF, QFX, OFX.
MS Money imports QIF and OFX (and QFX and QBO).
Convert PDF to OFX
The ProperConvert app convert PDF statements for bank and credit card transactions. The following transaction details are extracted from PDF files:
payee is extracted from the description
These details are matched with required OFX transaction details: date, amount, payee, memo, check number.
Convert transactions to a format importable by Xero
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 to 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 a layout compatible with the Xero accounting system.
Convert transactions to a format importable by Sage 50, Sage 300, Sage One
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.
Convert transactions to a format importable by Wave Accounting
Convert transactions to a format ready for LessAccounting
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.
Convert transactions to OFX or QIF format importable by Microsoft Money]
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.
Convert to the QIF format
QIF format supported by Xero. Make sure to use the expected date format (based on your country settings). When you use 2QIF converter, select QIF target as "MS Money or other" and set the expected output date format:
Convert CSV/Excel/TXT, PDF, OFX, QIF, QFX, QBO, MT940 files to the QIF format: Bank2QIF
Convert CSV/Excel/TXT files to the QIF format: CSV2QIF
Convert PDF files to the QIF format: PDF2QIF
QIF import somewhat better when using “Recover accounts” instead of “Downloaded statements”.
How to Import QBO and QFX files
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:
start MS Money and select File-Import-Downloaded Statement
select All files on the file dialog
select a QBO or QFX file
Common file formats supported by accounting software
See above file format(s) supported by specific accounting software/service
Convert to the OFX format
OFX files are Open Financial Exchange files.
Convert CSV/Excel/TXT files to the OFX format
Convert PDF files (text-based) to the OFX format
Convert QIF files to the OFX format - this is a great option to avoid the date format confusion as QIF files may have dates as DD/MM/YYYY and MM/DD/YYYY
Convert non-importable OFX/QBO/QFX files to a correct OFX file
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.
The ProperSoft converter support reference ID and if not supplied, generate it to be unique to guarantee the import for all 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).
Convert XLS/Excel/CSV to OFX
To convert XLS, XLSX, Excel, CSV to OFX (Excel file to OFX format), you can use the following method.
Prepare your Excel file
Open your XLS file in Excel and examine it. If transaction columns do not have the header, simply add them (if possible)
Use the following sample CSV file (Excel opens it) as a guideline how your Excel spreadsheet should look like for easy parsing
Select all transactions including the header (or just press CTRL+A) and copy to the clipboard (CTRL+C)
Download and install the ProperConvert app, make sure the file is digitally signed by ProperSoft on PC, and on Mac, you should be prompted to allow running the app from an identified developer (use the download menu above)
Start the app and click the Paste from clipboard button
Adjust the mapping if required
Examine the transactions on the Transactions tab for dates, amounts, memos, and other columns correctly assigned
Set account details: make sure to set account details like account number, bank id, the currency is set to match the account settings in your accounting software. Some software like Sage, XERO do check them on the OFX file and if there is no match, refuse to import an OFX file.
Convert to an OFX file: click the Save button on the Transactions tab to create the OFX file. The converter offers to save an OFX into the same directory as a CSV/Excel file. If you are using the copy/paste method, you may need to change the directory to save the OFX file
Import into MS Money: Start your software (MS Money) and select File, then Import, Statement file under the main menu and import the OFX file
Import into Sage (Sage 50, Sage One): Start your software Sage and import the OFX file
Convert to the QIF format
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:
Convert CSV/Excel/TXT files to the QIF format
Convert PDF files (text-based) to QIF
Convert QFX files to the QIF format
Convert QBO files to the QIF format
Convert QIF files to the importable QIF variant
Convert QFX/QBO/OFX files to the QIF format or make your QIF file importable