CSV / QBO to IIF converter.

[+Warwagon MVC]

Quickbooks QBO / CSV to IIF converter

Join my new Telegram Channel for
https://t.me/+XRqUEpR5e_g4Y2Yx <----Telegram Channel link.

New versions announcements

Preview of new and upcoming features.
Betas for just the group to test
Vote on new features
And more

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.

It also includes a rules 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. 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. Every vendor and account you use already has to exist in QuickBooks.

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. This will automatically import your vendors and accounts for you.

Starting with version 4.1, if the program tells you that your CSV file is incompatible, you can map the fields yourself by clicking the "Let me try mapping it by hand" button at 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, posted at the bottom of this page.

 This is what the program looks like. 

Included in the app is a rules 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 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

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.

Bank Account Balance Tool 2.0

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

• See your Quickbooks Transactions AND your bank transactions side by side.
• As your correct it in Quickbooks your correct it in here and it will continue balancing down page.
• Enter the balance at the end of the previous month and 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.
• 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

Checking off the transactions as you go down the list

In the example above this account did not balance and per the balance tool, shows it 
stopped balancing only on July 1st.

Once the issue was fixed and the account balanced, the CSV was imported again and 
this time you can see it looks much better.

Download Link

If you find a bug in the "Latest" release, please report the bug to me. In the meantime, try the release ending in "Previous" on the drop box.

The Latest, Previous, Old (3 versions ago) and Beta are available in Dropbox.

Files ending in Beta or Alpha are test versions, so there may be bugs.

https://www.dropbox.com/scl/fo/t088czui5pzgsm998w2hi/AMJrjSJMw2nRzca6jgIIO6k?rlkey=w6vtqby1kzrfy7l7xroh13p5w&st=3y7sdpmp&dl=

Tutorial

Change logs

v4.6.6.1 Latest
February 11th, 2025

• New: I redesigned the What's new box. It now allows me to show you what's new depending on which version you have. If you have version 4.6, you will see what's new in every version since. If you are coming from one version back, you will only see what's new since that last version.I can also single out versions that had an issue. So, if you were never using a certain version, that change log entry would not be shown to you.
• New: You can now bring up the Add to Pattern box by pressing CTRL+Shift + A
• Fixed: Fixed a bug that when exporting to iif it would set the account for a deposits as the default account and not the account specified in the rules file.

v4.6.6
February 10th, 2025

• New: When adding single transactions via the "Add to rules" button, it now highlights the transaction you added in green as well as other transactions which match the "What to match".
• New: It now alerts you when you have more than one transaction selected when the clicking "Add to rules" button.
• New: Added a new button under "Autocomplete options" called "Add an Account to Autocomplete" this allows you to add a new single account to the autocomplete, or an account that is part of a sub account.
• Fixed: Fixed a crash that would occur when loading a CSV and selecting YES to load memo if available.

v4.6.5.1
February 7th, 2025

• New: Improved DPI support on 4k displays
• Fixed: You can now split a credit. Before, when importing into Quickbooks, it incorrectly treated it as a debit.
• Fixed: Addressed an issue where memos were loaded whenever opening a QBO file, regardless of whether the user selected "Yes" or "No."
• Fixed: When loading a rules file for a QBO, the application would apply the original name to the memo line even if the user selected "No."

v4.6.4.3
January 31st: Previous

• New: You can now import a QIF file into a rules file by clicking on Create Edit Rules / Import QIF
• New: You can now export to QIF format by clicking on Other options / Export to QIF
• Fixed: Fixed a bug that would throw an autocomplete error during Tab-Deliminited import if you would click clear autocomplete data and then proceed to import a Tab-Deliminited files or a QIF file into the rules Editor.
• Fixed: When importing a Tab-Deliminited and now a QIF file it no longer fills your autocomplete file up with entries that starts with #. It now takes the vendor name from Replace with instead of what to match when importing those file types
• Fixed: Fixed a miss spelling of the word select on the Tab-Deliminited import box.
• Fixed: Addressed an issue in QBO files where memos would not correctly align with transactions when dates were listed in reverse chronological order (newest to oldest).
• Fixed: Enhanced the "Add/Replace Vendor/Payee with Memo" functionality to ignore blank memos, ensuring that vendor lines are not replaced with empty entries.

v4.6.1
January 19th:

• New: You can now clear all vendor lines! Go to Other Options and select Clear the Vendor line. This will leave the vendor field in QuickBooks empty upon import.
• New: The What's New box will display different change logs for people who had the latest release and those behind a few.

v4.6.0.1
January 12th:

• Fixed: When clicking "Add to rules," it would say, "Please load a rules file," even though one was already loaded.
• Fixed: When clicking back during the setup wizard, you would be taken screens out of order of progression

v4.6
January 11th:

• New: When you select a single transaction and click "Add to rules," you now get a box that lets you specify what to match, what to replace with, and the account.
• New: Added a "What's new Box" which is displayed only once when you open a new version.
• New: When you open the app for the first time, you are greeted by a wizard that will walk you through importing your vendors, accounts, bank and credit card accounts, and the default account. If you wish to try it out, you can find it under "Help" in the top right corner under "Run Setup Wizard."
• New: If it's unable to check for updates, it will indicate in red at the top right corner with the words "unable to check for updates."
• Fixed: When loading an incompatible JSON file via "Load Rules File," the app will no longer display the "Map names to memo line" prompt before showing the "Incompatible file" message. Additionally, loading an incompatible file will no longer count as successfully loading a rules file, allowing you to immediately select a different file without needing to reload the CSV or QBO file.
• Fixed: Updated vague or cryptic error messages that sometimes appeared when trying to load incompatible rules files. These messages now consistently read: "This is not a compatible rules file."
• Fixed: Enhanced the text displayed during character limit warnings. The message now provides clear instructions: "Press Backspace and try again." The same warning message now also appears in the Rules Editor.
• Fixed: A bug where users running version 4.5.6 would not be notified about the availability of version 4.6. To resolve this, I will use version 4.5.7 to notify users, but note that it will actually be version 4.6 as indicated in the change log.
• Fixed: If you are running a beta version (e.g., 4.6-beta.3) and the stable channel reports a new version (4.8), while the beta channel reports a newer beta (4.8-beta.1), you will now be notified about the new beta (4.8-beta.1). This ensures that beta users are informed of new beta updates when available, or stable releases only if no new beta exists.
• Fixed: Fixed a bug that prevented the wizard from opening if no defaultaccount.txt was present.
• Fixed: It now writes the imported bank and credit card accounts as Bank and Credit Card instead of BANK and CREDIT CARD. Writing them in capital letters prevented the user from clicking "Convert."

v4.5.5
January 2nd: Previous

• New: You can now import your Accounts and Vendors using the IIF export option in Quickbooks. Navigate to File > Utilities > Export > Lists to IIF files, and simply check the boxes for "Chart of Accounts" and "Vendor List." Once exported, load the IIF file into the autocomplete options box by clicking "Load data from IIF file." If this is not your first import, it will only load the new accounts and vendors, skipping over existing ones.
• New: If you accidentally select your autocomplete.json file when loading your rules file into the main app, you'll now receive a clear message indicating you loaded the autocomplete file. Previously, the app would only notify you of an incompatible file without specifying the issue.
• New: Under Other options there there is now one called "Overlay Quickbooks data". It opens up a box which is always on top and hovers over the converter. It let's you load your data from inside QuickBooks and compare what's already there.
• New: Added Canadian Bank support. A new drop-down option when adding an account for export. This is for users with the Canadian version of QuickBooks, which generates an IIF file using "CHEQUE" instead of "CHECK."
• New: An option under "Other options" that lets users empty the memo line before conversion.
• New: The program now checks wether it has write permissions in the directory it's currently being executed from. Instead of just crashing when attempting to write data to the defaultaccount.txt it will give you an error letting you know you do not have permission in that directory.
• Fix Fixed a crash were the program would crash when loading a CSV if the dates were in the format of YYYYMMDD.
• Fix When exporting CSV's with a date format of YYYYMMDD it will write them in the iif as YYYY-MM-DD

v4.5.4.4 
Oct 3rd:

• Updated: Added more descriptive text to the default account box, visible upon opening the app for the first time or when changing the default account, to make it clearer what the default account refers to.
• New: Added a drop-down list called "Balance Tool." Inside this drop-down are two balance tools: one for Bank accounts and one for Credit Cards, allowing users to manage and reconcile balances for both account types.

v4.5.4.2
Sept 19th

• Fixed: When typing in the rules editor search box the app would crash
• Fixed: When selecting transactions and clicking "Add to rules" the entires added to the rules file would be 2 different transaction names.

v4.5.4
Sept 18th: Previous

• Fixed: Normalized incorrectly formatted dates when importing them into the Bank Account Balance Tool from the converter.
• Fixed: The app was unable to see new updates formatted in a version format of 4.5.3.5. Old versions can see version numbers in that format, but the new version cannot. That has been fixed
• Fixed: Somehow, the Bank Account Balance tool got added to the bottom right, next to "Load rules file." It's been removed.

v4.5.3.5 
September 17th, 2024:

• Fixed: Updated the version matching on the update checker so it doesn't say there is a newer version if you have a beta and the server says there is one that's older than the one you have.
• New: When importing a tab file a user now has the option not to use a # at the beginning of "What to match".
• New: Added Text to the import tab box that tells people to turn off show account numbers before creating a tab file. those are incompatible on iif import
• New: Released a new version of the Balance tool called Bank Account Balance tool 2.0. it now lets you use a split view, Bank account on the left and Quickbooks on the right. It will show you were you and QuickBooks stopped balancing. As you fix it in Quickbooks you can now fix it in the balance tool and it will continue to balance your books.
• New: Added a tutorial button to the balance tool showing you how to use it.

v4.5.1 
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

v4.5 
September 10th, 2024:

• New: The rules editor will prevent you from entering a vendor name longer than 41 characters.
• New: The rules editor will prevent you from entering an account name longer than 31 characters. If you have sub-accounts, it's 31 per example life:personal.
• New: When adding a new account to export to iif it also checks for accounts longer than 31 characters.
• New: It now checks for a new version of the app on startup. If a new version is found it says "Update Available" in green on the right side of the toolbar.
• New: If you click on "Update Available" it brings up the check for update box, it tells you which version you have and which version is currently available as well as a change log.
• New: You can now fill out a transaction in the main app, load a rules file, put a checkmark next to your filled out transaction, and click "Add to Rules". This will take the original transaction name and add it to "What to match", the new name will go to "Replace with" and the account you gave it will be added to "accounts".
• New: You can now search in the rules editor by account name
• New: Entries in the rules editor that start with # will be displayed with white text on a black background
• New: When you click the "add to rules' button on the toolbar, after selecting 1 or more transactions, if it finds a match of a transaction that is already in your rules file, it will list them and give you the option to select that 1 transaction and replace it with the new info, or add a new entry.
• New: It will now inform you if you are trying to import a CSV file with an improperly formatted date. it will also tell you what row it's on. An example of such a date would be 023-04-1.
• Updated: Added "White on black" to the "What do the colors mean.
• Fixed: The edit box in the converter also checks for the Character limit for vendors and accounts.
• Fixed: If a CSV contained only debits or only credits it would say the file was incompatible, regardless if it had the correct headers.
• Fixed: Fixed a utf-8 codec decode byte error that would crash the program when importing a CSV under some circumstances. Now it will give you a dialog box and tell you how you could fix it
• Fixed: In the change log, when a new update Is available, the first bullet point is no longer "change log"
• Fixed: The Account fields were incorrectly giving a 41 Character vender limit warning
•  

Shortcut Key Cheat Sheet

Select All: Ctrl + A
Select All Except Ignore: Ctrl + I
Select None: Ctrl + N
Swap Debit/Credit: Ctrl + S
Load Patterns from File: Ctrl + L
Show Uncategorized Transactions: Ctrl + U
Convert to IIF: Ctrl + E
Set New Default Account: Ctrl + Shift + N
Select All Credits Except Ignore: Ctrl + Shift + C
Select All Debits Except Ignore: Ctrl + D
Autocomplete Options: Ctrl + O

 

[+Warwagon MVC]

OLD POST. I thought I would leave it here so that you can see how fugly the first version of the pattern file was was 😄

Here is a definition editor. It's super sweet. I used to add everything to my definitions file. It allows you to create a definition file using the file name of your choosing. Once you save it it opens it up and you can start adding stuff to it. You can also load it or a different one later

On the left shows your code in the definition file as you add new items. The right shows you every company you've added to the file. It automatically saves as you add stuff.

pip install PyQt5
pip install wxPython

Compiled EXE on Dropbox

https://www.dropbox.com/scl/fi/zxw2214v2yphiptyv5r9z/Definition-Editor.exe?rlkey=77k7s6e9i8vcjyc3odg52o9al&dl=0

[NexGen.Media]

Hello!

I was super excited to come across your solution, as I am also looking at the ProperConvert app and thinking that it's priced a little too high for my use case (which would essentially be a once-a-year affair). However, I tried your app and it doesn't work for me. The app loads, however, when I load my CSV (40KB) which I downloaded directly from my bank, the app just closes. I tried the .exe on Windows 11 both natively on an Intel machine and also in a Win 11 VM on Arm via VMware Fusion (running on a M3 mac w/ Somoma) with the same result. The ProperConvert app I am trialing opens the file without issue.

Any ideas?

Cheers,
Dan
NexGen.Media

Edited February 22, 2024 by NexGen.Media

[+Warwagon MVC]

It's also possible that all CSV's are not created equal. I created that app, around the CSV I was given to by my bank.

If you wanted to get an error message you would have to install Python from the Microsoft store, then open a command prompt and type in these 2 commands.

pip install PyQt5
pip install wxPython

Then you would have to take the code I posted above, paste it into a notepad document and save it as a py file. Then in the command prompt type python filename.py and load the app that way. then when it crashes, it should give you some error inside the back box. I suspect your CSV file is formatted differently than mine.

I'm super bummed the app crashed on you. I was excited for you to use the app.

If you open your CSV file with notepad do your column headers look like this

[NexGen.Media]

Hello,

I really appreciate the quick response and you trying to assist. I actually run a web/software dev firm so familiar with code/Python. Before I came across your post I was thinking about writing something myself. I did try to load the app via Python 3.12 using the .py file and couldn't get the app to run or even log an error (just opened and closed). Again this is all on Win 11 and never tried on Win 10.  Nevertheless, with the time already spent in researching a solution and then trying your solution I am already past 1-hour of billable time, so decided to purchase the ProperSoft app and move on.

Thanks again though!

[+Warwagon MVC]

Version 2.0 Released

I noticed I never released the code for the JSON editor. Well, now I uploaded it.

It's too bad the one person who tried it, couldn't get it to work. Hopefully, more banks share my banks CSV format. I just used it today to balance my account, to test it out before posting the code here.

[+Warwagon MVC]

On 22/02/2024 at 13:19, NexGen.Media said:

Hello,

I really appreciate the quick response and you trying to assist. I actually run a web/software dev firm so familiar with code/Python. Before I came across your post I was thinking about writing something myself. I did try to load the app via Python 3.12 using the .py file and couldn't get the app to run or even log an error (just opened and closed). Again this is all on Win 11 and never tried on Win 10.  Nevertheless, with the time already spent in researching a solution and then trying your solution I am already past 1-hour of billable time, so decided to purchase the ProperSoft app and move on.

Thanks again though!

I know you already purchased the other solution, but I wanted to let you know that I have added support for QBO files, which should be standard across all banks.  So if The financial institution got rid of iif files but still gives you CSV as well as QBO, you can also import QBO.

[+Warwagon MVC]

Version 3.0 released!

[+Warwagon MVC]

Versions

3.01
3.02
3.03
3.04
3.05
3.06

Released

[robertwe4774]

I installed your program today. In the account section imported I entered my categories. When I try to import into QBOOKS as an IIF I get an error that states failed. These are a small few credit card transactions. I review and Failed. The error file shows. 

;
;*** YOUR IIF FILE COULDN'T BE IMPORTED ***   
;
;Some of your records have errors.
;
;1. Search for the errors by typing "[ERROR]" to see only the failed records.
;
;2. Fix the errors and try to import the file again
;
;-----------------------------------------------------------------------------
;
;
!TRNS    DATE    TRNSTYPE    ACCNT    DOCNUM    NAME    CLASS    AMOUNT    TOPRINT    MEMO
!SPL    DATE    TRNSTYPE    ACCNT    DOCNUM    NAME    CLASS    AMOUNT    MEMO
!ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/17/2024        American Express Bonvoy        Brilliant Dining Credit        22.47
SPL    03/17/2024        PremierEcorp Debit Offset                -22.47
ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/15/2024        American Express Bonvoy        AUTOPAY PAYMENT THANK YOU        51.88
SPL    03/15/2024        PremierEcorp Debit Offset                -51.88
ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/12/2024        American Express Bonvoy        TST AUNT LULUS NY SBOCA RATON FL        -22.47
SPL    03/12/2024        PremierEcorp Debit Offset                22.47
ENDTRNS

In the transactions are any new vendors.credit card added into Quickbooks on the fly, or do I need to add them first? 
My edits of those transactions showing the proper account numbers did not save into the IIF file. I did this a few times. 
I must be missing something. I attached a screenshot of what I had before I clicked convert to IIF.

Any ideas?
Thanks

[+Warwagon MVC]

On 22/03/2024 at 10:56, robertwe4774 said:

I installed your program today. In the account section imported I entered my categories. When I try to import into QBOOKS as an IIF I get an error that states failed. These are a small few credit card transactions. I review and Failed. The error file shows. 

;
;*** YOUR IIF FILE COULDN'T BE IMPORTED ***   
;
;Some of your records have errors.
;
;1. Search for the errors by typing "[ERROR]" to see only the failed records.
;
;2. Fix the errors and try to import the file again
;
;-----------------------------------------------------------------------------
;
;
!TRNS    DATE    TRNSTYPE    ACCNT    DOCNUM    NAME    CLASS    AMOUNT    TOPRINT    MEMO
!SPL    DATE    TRNSTYPE    ACCNT    DOCNUM    NAME    CLASS    AMOUNT    MEMO
!ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/17/2024        American Express Bonvoy        Brilliant Dining Credit        22.47
SPL    03/17/2024        PremierEcorp Debit Offset                -22.47
ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/15/2024        American Express Bonvoy        AUTOPAY PAYMENT THANK YOU        51.88
SPL    03/15/2024        PremierEcorp Debit Offset                -51.88
ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/12/2024        American Express Bonvoy        TST AUNT LULUS NY SBOCA RATON FL        -22.47
SPL    03/12/2024        PremierEcorp Debit Offset                22.47
ENDTRNS

In the transactions are any new vendors.credit card added into Quickbooks on the fly, or do I need to add them first? 
My edits of those transactions showing the proper account numbers did not save into the IIF file. I did this a few times. 
I must be missing something. I attached a screenshot of what I had before I clicked convert to IIF.

Any ideas?
Thanks

Thanks for the error reports. I'm not sure if they are added on the fly or not. Add those new accounts to quickbooks and try it again

[+Warwagon MVC]

On 22/03/2024 at 10:56, robertwe4774 said:

I installed your program today. In the account section imported I entered my categories. When I try to import into QBOOKS as an IIF I get an error that states failed. These are a small few credit card transactions. I review and Failed. The error file shows. 

;
;*** YOUR IIF FILE COULDN'T BE IMPORTED ***   
;
;Some of your records have errors.
;
;1. Search for the errors by typing "[ERROR]" to see only the failed records.
;
;2. Fix the errors and try to import the file again
;
;-----------------------------------------------------------------------------
;
;
!TRNS    DATE    TRNSTYPE    ACCNT    DOCNUM    NAME    CLASS    AMOUNT    TOPRINT    MEMO
!SPL    DATE    TRNSTYPE    ACCNT    DOCNUM    NAME    CLASS    AMOUNT    MEMO
!ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/17/2024        American Express Bonvoy        Brilliant Dining Credit        22.47
SPL    03/17/2024        PremierEcorp Debit Offset                -22.47
ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/15/2024        American Express Bonvoy        AUTOPAY PAYMENT THANK YOU        51.88
SPL    03/15/2024        PremierEcorp Debit Offset                -51.88
ENDTRNS
; [ERROR]  is an invalid value for field TRNSTYPE. [15106] 
TRNS    03/12/2024        American Express Bonvoy        TST AUNT LULUS NY SBOCA RATON FL        -22.47
SPL    03/12/2024        PremierEcorp Debit Offset                22.47
ENDTRNS

In the transactions are any new vendors.credit card added into Quickbooks on the fly, or do I need to add them first? 
My edits of those transactions showing the proper account numbers did not save into the IIF file. I did this a few times. 
I must be missing something. I attached a screenshot of what I had before I clicked convert to IIF.

Any ideas?
Thanks

 

Also when entering an account that is a sub of another account it has to be in this format "Business:Indirect Expense:Utilities:Water" each sub-account separated by a colon.

So in your screenshot if meals was a subcategory of 6640 it should be entered as 6640:Meals

*Update*

I tried to recreate the issue without much luck. Those account names did not throw an error, at least for me.  I also sent you a personal message

[+Warwagon MVC]

On 22/03/2024 at 10:56, robertwe4774 said:

 

So I recreated everything as best I could and it imported into QuickBooks without issue. In the future, I'll make a note of this in the app but If you want to add an account for a transaction in the account column, it has to be added from the definition file. If you type in the account field, it's ignored on export.

[+Warwagon MVC]

Created and added a tutorial to the first post.

[+Warwagon MVC]

Version 3.6 released

[+Warwagon MVC]

Version 3.8 released

[Jason Doster]

Thank you so much for delving into this. I am trying out your Python code to convert QBO to IIF and import to QB Desktop 2021. I know you are using 2018 and perhaps 2019. Just for SA, I am getting errors when I try and import into 2021 currently.

I tell ya, with QB Desktop 2021 about to stop allowing transaction QBO imports at end of May, your code here may become the genesis of something very much needed by many. 2021 is the LAST Quickbooks that is an indefinite time license. Many folks will be using 2021 for years to come, including myself, who refuses to go online with my company's data, so I'll fight tooth and nail to continue to do transaction imports from banks and credit cards, as that's the functionality that will be needed to keep QB Desktop 2021 truly functional an efficient.

I know how to Python code and do UIs myself. I'll take a look at your code. My issue is I don't know Quickbook formats things and it's basic construct nearly as well as you. Would like to collaborate.

Thx,

Jason Doster

[Jason Doster]

Belay that, reading through your puts I ignored the errors and imported anyway. It worked in QB 2021. OK, now looking at your patterns editor, what would be awesome is if we could export the current QB accounts, and have them available to choose from automatically in a list. Right now it would be copy and paste, but perhaps that is the way it goes initially until the pattern file is done.

Love what you've done here man. Outstanding.

[+Warwagon MVC]

On 14/04/2024 at 23:46, Jason Doster said:

Belay that, reading through your puts I ignored the errors and imported anyway. It worked in QB 2021. OK, now looking at your patterns editor, what would be awesome is if we could export the current QB accounts, and have them available to choose from automatically in a list. Right now it would be copy and paste, but perhaps that is the way it goes initially until the pattern file is done.

Love what you've done here man. Outstanding.

 

Actually, take a look in the download folder on Dropbox for "Pattern Maker." You can go to your bank account on Quickbooks, select print, then choose "File" and select " "Tab delimited file". Then, import it into the program and convert it into a JSON file

This will create a compatible JSON file for the pattern editor with every vendor you've used in that account through the dates you've specified on export and all the categories already filled in. Of course, you can go through and edit them. Plus, now every account is available for auto-complete.

Once they are all imported, you'll have to tell each one what to match with.

I'm thinking of incorporating this program into the dialog when opening the pattern editor. You would have a choice of

save (which should be renamed to create)
Open
Create from Account export (Or something)
Cancel

 

 

[+Warwagon MVC]

In version 3.8.3 beta 6

Added it right into the app

[Jason Doster]

Trying to get to the Dropbox to download the new version. Came up with an error. Is it still there? Thx! Jason

[+Warwagon MVC]

On 12/05/2024 at 18:50, Jason Doster said:

Trying to get to the Dropbox to download the new version. Came up with an error. Is it still there? Thx! Jason

Yes. I just clicked the link and it worked 

[+Warwagon MVC]

Version 4.0 has been released.

[Jason Doster]

Awesome. I've been working with 3.9 today. I'll download 4.0 next. Don't know why I couldn't get to the Dropbox the other day. Working fine now!

I do think this will allow everyone to work their Credit Card and Bank imports for Quickbooks. I've been comparing the IIF output files to intended required format, and it's really good. Thank you so much for doing this!

I used your "print file method" for my QB credit cards and bank accounts to create initial PATTERN files, imported the vendors and their associated accounts. Currently I have separate PATTERN jsons for each credit card and bank statement. I might combine later, but for now that works just fine. I only have 8 CC/Bank imports I have to do each month. Some notes:

- A transaction item given name had a "#" in front upon json creation that needs to be removed, and then of course given the appropriate syntax to line up with a record you want from the transaction list. That was easy, but took a bit as I was going through 250 patterns imported.

- When I have an import that needs to be split, I actually don't typically know the $ split-out until later. Currently the split needs to be defined with both an account and a $ value. It would be awesome if one could just define the account split out WITHOUT a $ value split until later, perhaps default the first split to all of the $ value, and the second to zero initially, and then only a simple change after import to QB. I dunno. No big deal, just an observation.

- In execution, after I import a QBO file and verify a PATTERN json file will suffice to sort, there are some generic bank-isms like "DEPOSIT" and "CHECK" and a few others that I actually know what they are, so I tried manually changing the name of the transaction to that name which is in the PATTERN json I know it is, all before loading the PATTERN. Then when I loaded the PATTERN, I expected it to pickup the changed transaction name, but instead it picks up the original name to sort. I expect this is because when you do the pattern sort, you are accomplishing on the original QBO, vice any change to the name of the transaction after QBO import. If you could somehow apply the PATTERN to the CHANGED transaction names after QBO import and modification, that would be VERY powerful. I could change the generic DEPOSIT or CHECK name to what I know it actually is, THEN apply the pattern and BAM, ready for IFF write without having to make those changes once in QB. 

Dude, once again, spectacular. If any of these are easy fixes, awesome. If not, thank you so much.

Thx! Jason

[Jason Doster]

Downloaded version 4.0 this morning and found you had already implemented the behavior of the 3rd bullet above, perfect. The first two above are still observations. A way to split items without specifying amounts initially, but breaking it out as sub-accounts would be helpful. Also, question:

- In the PATTERN load, would it be possible to place the OLD matched transaction name into the MEMO line for reference after the transaction has been matched and has a new transaction name

Thx! Jason