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

Hadoop 101: Fundamentals but essentials — MapReduce explained

The 9 biggest errors in the valuation of an IT project — How to avoid them?

The NEW design of website and improved LOGO has arrived.

Configure Xdebug for VSCode using Docker

PHP Debug extension image

How to Map a Network Drive in Windows 10? — Get Answers Now

How to perform CRUD operations using Blazor Server App Part-II

Zenity Linux Command

Variable and Types in C++

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

Geographic Spatial Indexing — A Personal Journey

Everything Is a Program — Chapter 1 — Machines

Wrestling with Data Collection

Effect of a pandemic on the Canadian study permit application- Part 1