FREE CSV/QBO to IIF converter.

[Warwagon]

Quickbooks QBO / CSV to IIF converter​

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 Transfer accounts. It does not support accounts receivable in Quickbooks.​

This program is for people who import Bank, Credit card, and Transfer accounts. It does not support accounts receivable in Quickbooks.

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 due to Intuit's greed. I'm sure people will be death-gripping older versions of QuickBooks for years. 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 was $120 per year.

Unlike other free converters, you do not have to create an account or provide any personal information to use it.

The app (4.1 or newer) has 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 available here and compile it on your own. The Dropbox links are toward the bottom

I am aware of only a few other programs that do this, and they cost $120 per year.

The iff file should be imported without issue up to Quickbooks 2018. 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.

The iff file should be imported without issue up to Quickbooks 2018. 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

There is a tutorial video at the bottom; give it a watch! Come back here for updates on the latest versions, posted at the bottom of this page.

This is what the program looks like.​

Included in the app is a pattern editor​

The Pattern Editor allows you to create, modify, and edit transaction rules to 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 Businessirect 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

IIF Import Troubleshooter​

The app includes an import troubleshooter. This tool allows you to take the message Quickbooks gives you after a failed import (2019 and newer), paste it in, and convert it to plain English.

Balance Tool​

This app also includes something called "Balance Tool". If you import your IIF into Quickbooks your account doesn't balance, you can use this tool to help figure out why.

It lets you

• Enter the balance at the end of the previous month and the balance at the end of the current month after importing the iif file and it will tell you how much you are off by. It will also tell you if any transactions match that exact amount.
• Check off transactions as you go down your transaction list in QuickBooks.
• Import a comma-delimited file exported from Quickbooks and it will compare your running balances in Quickbooks against the Balance tool and let you know which days you balanced. Each date where you balanced will be highlighted in green. You can then quickly figure out when your account stopped balancing.
• It tells you in plain English if you have to much or too little money in QuickBooks.
• You can check for the possibility of transposed numbers
• It tells you if you are missing any despots on QuickBooks or on the bank side

Here is a tutorial on how the app works.​

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/t088...ey=w6vtqby1kzrfy7l7xroh13p5w&st=3y7sdpmp&dl=0​

Neowin Link
https://www.neowin.net/forum/topic/1434103-csv-qbo-to-iif-converter/

Reddit Link

https://www.reddit.com/r/QuickBooks/comments/1dddabe/free_qbo_csv_to_iif_converter_for_windows

Both the latest and beta versions are available on Dropbox.

v4.5 Latest​

September 12th, 2024​

• New: Added the ability to send out two separate change logs, 1 for stable and 1 for beta.
• New: When importing a tab file a user now has the option not to use a # at the beginning of "What to match".
• Fixed: A bug that would crash the rules editor if a user would empty the autocomplete file and create a new rules file, and start typing in an autocomplete filled.
• Fixed: In version 4.5 beta 7, sorting was broken, which caused the program to start sorting the transactions from newest to oldest. That's fixed now. It now sorts correctly from oldest to newest again.
• Fixed: In the rules editor, when clicking update on an entry that has not yet been added to the rules editor, you would receive an autocomplete error. Now, you are told to add the entry first.
• Updated: Renamed the cancel button in the convert IIF and the rules menu box to close.
• Updated: Removed and added some text to the welcome box which appears when you first start the app

 

[Steve]

I still recall how much the world changed when Microsoft introduced Visual Basic.

I was writing the weekly "TechTalk" column for InfoWorld at the time, so the product manager for VB (Nevet Basker) journeyed down to GRC from Redmond to demo their new "thing" for me. It was immediately clear that VB changed the face of programming and I gave it three sequential weekly columns in a row because it was clearly so important. And I recall that one of the techies working for GRC (Millard Ellingsworth, III) saw what Microsoft had done and quite seriously commented: "This is not good. It's going to make it way too easy for people to write programs."

It seems quite clear that while I'm sure we're not there, yet... the idea of having a conversational AI write working code is not far off.

 

[Warwagon]

It seems quite clear that while I'm sure we're not there, yet... the idea of having a conversational AI write working code is not far off.

I would say for very small projects we are already there. I programmed none of this app other than finding and fixing stupidly obvious bugs.

 

[Ralph]

I've used ChatGPT to optimize an already working program in Python I wrote. Since the code was going to run on a battery powered Raspberry Pi, I uploaded the code and asked for it to optimize it for reduced power consumption. What it came back with worked, and I had to ask it about a few changes it made and how they worked.

The modified program didn't change power consumption much, but I did learn a few things from the changes it made.

 

[Steve]

Incredible.

 

[Fuzzball]

Flon's Law: There is not now, nor will there ever be, any programming
language in which it is the least bit difficult to write bad code.

 

[Warwagon]

Here is a video of it in action

 

[Warwagon]

Oh my gosh, my program has come a long way since creating this thread. It feels like it just was a baby. I work on it almost every day.

When I first created this thread, I think it was on a very early version of 3.0 (3.0.3) . It's now on version 4.3

I updated the first post with new screenshots, a Reddit post were you can find more info, and a current Dropbox link

This is what has changed since this thread was created.

New: MUCH improved CSV support
New: MUCH Improved QBO support
New: Support of OFX files
New: Unified Autocomplete. The main app and the pattern editor share the same autocomplete.json file in real-time.
New: Redesigned pattern create / load pattern file box
New: Load a tab-delimited file into the pattern editor to import accounts and names.
New: Edit transactions right in the main app
New: A Swap debit and credits button
New: Map by hand a CSV that it says is incompatible.
New: The app now has buttons at the top: YouTube tutorial, Donate, Select all credits except ignore, Select all debits except ignore, Deselet ALL, Set New default account, Show Uncategorized Transactions, Add Names to Pattern File, Swap Debit and Credit, and Autocomplete Options.
New: When opening the app, you can set a default account without using PremierEcorp Debit offset.
New: Import a Vendor and account list into the autocomplete file
New: Added support for transfers
New: A button on the bottom of the app allows you to load a CSV from Quickbooks to uncheck transactions already in Quickbooks.
New: Color-coded pattern file entries based on whether they are Split, matching by mount, Ignored, or if they have transfer checked.
New: Create accounts you wish to use, which you can select from a drop-down box.
New: Load a pattern file into the main app and add transactions directly into the pattern editor.
New: Click a button and show transactions that are still uncategorized.
New: Search transactions listed in the main app.

AND MORE!