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



-- — need to import transactions, but the file format is not supported? Try ProperSoft converters.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

CosmWasmers, Time to Build your Awesome Project at HackAtom V!

How to learn code?

9 my favorite iOS 15 Homescreen Widgets — (October 2021)

Frame Update & Movement in Unity

How can a shipping API help streamline customer experience?

[Anouncement]PlatON PIP-3 proposal passed, network upgraded to version 1.1.0

Why Every Programmer Should Start Their Own Blog

Person typing on laptop

Styling Excel cells with mso-number-format CSS attribute

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sergiy Tytarenko

Sergiy Tytarenko — need to import transactions, but the file format is not supported? Try ProperSoft converters.

More from Medium

Multi-version Odoo installation and configuration in PyCharm (odoo-10 and odoo-15)

Integrating Technologies Using Python Voice Controlled Menu


Two Most Important Browser Extensions