FREE QBO / CSV to IIF converter for Windows.
Disclaimer: Use at your own risk. I made this app for my needs and it works fantastically. If you use this app back up your company file before importing the iif file.
This program lets you import a CSV, QBO or OFX file and convert it to an IIF file to import into Quickbooks.
This program is for people who import Bank, Credit card and Transfers. it does not support accounts receivable Quickbooks Accounts.
It also includes a pattern file editor, which lets you match up, rename, split, and put them in the correct account before you create the iif file. This does A LOT of the heavy lifting for you so you won't even have to handle them once they get imported into Quickbooks.
I'm giving this app away for free because, due to Intuit's greed, I'm sure people will be death-gripping older versions of Quickbooks for years to come. They will need some way to import their transactions into Quickbooks. Before this program, the only other app out there I could find with the same functionality is $120 per year.
Inside the app (4.1 or newer) there is a donation button if you want to donate.
This is a program I created in conjunction with Chatgpt. It's in Python, but I do have some EXEs available. You can also take the source code, which is also available there, and compile it on your own. The dropbox links are towards the bottom
There only a few other program available that does this that I am aware of and it's $120 per year.
Up to Quickbooks 2018, the iff file should be imported without issue. In Quickbooks 2019 and newer if you import your iif file the new way, it will work, but descriptions on deposit for bank transactions seem to be left blank and check numbers are added for each debit.
2019 and newer still give you the option to.
**"Import it for me. I'll fix it later"**This is the old method used up until Quickbooks 2018
People on the internet say using that method IIF's import without issue
Starting with version 4.1, if the program tells you that your CSV is incompatible, you do have the ability to map the fields yourself by clicking on the "Let me try mapping it by hand" in the bottom right of the box. Even though that should let you open the CSV just fine, I would still like to be contacted about your CSV so I can add native support for the CSV file into the app for everyone else.
There is a tutorial video at the bottom, give it a watch! Come back here for updates on the latest versions. They are posted at the bottom of this page.
This is what the program looks like.
Included in the app is a "Pattern editor"
This app allows you to create, modify, and edit a JSON pattern file that you can import into the first program. The pattern file allows you to tell the program
- If a transaction has X in the name, rename the transaction to X for (Example, if a transaction has WM SUPERCENTER in the name such as 648105 PURCHASE WM SUPERCENTER #1625 712-546-4900 IA 10277255 4041 .. rename to "WAL-MART"
- If a transaction is named X and has X amount name it this. If it does not have X amount, still give it a name but just put it over in Premier Offset so I can tell it where to go.
- If a transaction has X in the name, rename it and add it to this account. For example, if a transaction had " HY-VEE F&F" in the name, such as "995471 PURCHASE HY-VEE F&F LE MARS 5382 LE MARS IA 4445043046110 4," rename it to "HY-VEE FUEL" and add it to the account "Business:Automobile Expense:Fuel."
- Split a transaction to the tune of 2 splits. I wasn't aware that you could split a transaction in an IIF file, but it works great! You just enter amount 1 for account 1 and amount 2 for account 2. (it's in the screenshot)
- If a transaction has X in the name and transaction amount is X $ rename the transaction and put it in this account. I did this because my Verizon gets put on my VISA card every month, but other things get put on there too. So in months when the VISA matches $36.38 it automatically puts VISA in Business:Direct Expenses - Business:Telephone:Cellphone.
- You can also have it automatically add memo's for certain transactions who's name/total or just name matches.
- You can mark a vendor as "Transfer," so all of their transactions are always marked as "Transfer and are automatically checked
I created this app for myself, but I thought others may find it useful. I'm sure, like me, other people are death-gripping their older version of QuickBooks.
When importing CSV, if it doesn't like the format your CSV is in, it will tell you it's unable to import it and give you a way to contact me so I can add your CSV to the app and make it compatible with your financial institution.
This is why I also added support for QBO files, which are standardized. So, if your bank removed support for IIF like mine has but still gives you QBO and CSV, and CSV isn't working for you, just use QBO.
Here is a tutorial on how it works
https://www.youtube.com/watch?v=nTii7Vg-p0k
Compiled EXE and source code on Dropbox
If you find a bug in the "Latest" release, please report the bug to me. In the mean time try the release ending in "Previous" on drop box.
Files ending in Beta or Alpha are test versions, so there may be bugs.
Download Link https://www.dropbox.com/scl/fo/t088czui5pzgsm998w2hi/AMJrjSJMw2nRzca6jgIIO6k?rlkey=w6vtqby1kzrfy7l7xroh13p5w&st=3y7sdpmp&dl=0
Neowin.net link
https://www.neowin.net/forum/topic/1434103-csv-qbo-to-iif-converter/
Both the Stable and Beta are available in Dropbox.
v4.3 June 9rd, 2024 Beta 8
- Fix : In the process of fixing the splits I broke the matching feature of unchecking transactions already in Quickbooks. It should work again now. The only thing it won't uncheck are split transactions.
- New: Added another CSV bank format.
- New: Added autocomplete to the transaction edit box. When you rename a transactions name and account it creates an autocomplete.json file in the same directly as the exe. It uses that file to store all the names and accounts you use to autocomplete them.
- New: When a pattern file is loaded into the app the names and accounts of that pattern are automatically added to the autocomplete.json file. This way you could load numerous pattern files into the app and have all the accounts you've ever used available to you.
- New: Added a "Autocomplete options" button to the top right of the application.
- New: Added the option to import an account list and vendor list from Quickbooks
- New: Added a help button that says "How do I create an account or vendor CSV file?" it gives you instructions how to create the file.
- New: Added a "Clear Autocomplete data" button to the autocomplete options box. When that is pressed you are asked if you want to clear the autocomplete data. If you choose yes it will erase the contents of the autocomplete.json file.
- Update: Changed the version number from 4.2.1 to 4.3
- New: Autocomplete added to the "Replace with" field of the pattern editor.
- New: Unified Autocomplete. The pattern editor and the main app now share the same autocomplete data via autocomplete.json. The pattern file data no longer gets added to the autocomplete when you load the file into the main app but instead when it gets loaded into the pattern editor and when items are being added or updated.
- Fixed: a bug that would crash the program when a CSV would be opened with the headers not at the top of the file. When clicking on Let me try mapping it, the program would crash.
- New: Added a button to the mapping app that says, “Why is my data not showing up”. When clicked brings up a box telling people how to open their CSV file and remove the data from the top of the file, to make sure that the headers are at the top.
v4.2 May 26th, 2024 Stable
- Fix : Splits are now getting recorded to the IIF file again. The issue was introduced when I added the ability to type directly onto the description and account line without having pattern file loaded. I brought back a feature that I had in the app but removed. You can no longer type in on the description and have it be recorded. In stead click on the account box and you will see a box appear which lets you enter a description and an account. I removed the memo from that box as I could not get it to show up on the memo line after pressing ok. You can still type directly on the memo line and have it be recorded.
- New: Made the warning box about splits not matching bigger, just like the final box that appear when you export a csv.
- Updated: Removed the warning about the 32 character limited on the account name. That feature was shortening the account names which had previous worked without issue.
- Fix: If a Debit or Credit column has a negative amount it removes the - and records it as a positive in the correct column.
Posted Jun 11, 2024, 12:48 PM UTC