How to convert a QIF file
This video shows how to convert a QIF file.
A QIF file you would get from your online banking or you would export from Quicken, or some other accounting software. And you need to convert those QIF files to another format like OFX or QBO, or CSV, so the Transactions app should work with a QIF file and understands many different formats.
There is a format called QMTF, which is on Quicken for macOS and this format is also supported and similar to QIF format and you can convert this as well. Once the file is loaded, as you can see the date format for each transaction could be with a two-digit year, so that could be confusing for some dates. So some dates could be interpreted as month/day/year or day/month/year.
The converter will try to figure out, so if there is at least one date in a file, that would tell the date format for the whole file then the converter would apply that to all transactions or all dates in the file. But you may also tell the converter ‘okay’ you need to use the dates this way. So, for dates that could be interpreted in different ways, then it would use your preference.
And there is also a thing called Quicken Dates. The special date Quicken date format for dates like before 2000. So dates if you have those files with all their dates you may need to click this check box to have your dates processed correctly, like 1930, 1940, or things like that. So, those dates would be correctly parsed with this check box.
And now the transactions are loaded. You can convert them to any format, like to OFX format, to QBO, you can convert them to another QIF format to make it compatible with certain software.
Or you can convert them to CSV format.
Or convert them to IIF to have them ready for Quickbooks.
Originally published at www.propersoft.net.