CSV / QBO to IIF converter.

[+Warwagon MVC]

On 19/05/2024 at 15:32, Jason Doster said:

One additional thing I'm seeing. The account field cannot be more than I think 25 characters it look like. The IIF generator will chop off the account name if it is too long, and when it's imported, another account is created to the chopped. That's happening with only a handful of accounts who's name's are too long. If no fix is possible, I'll just shorten up about 5 of my account names. Thx!

I add the character limit back in for 4.5 beta. The issue with the last implementation was that it checked for 31 characters regardless of subcategories. It can be 31 characters PER account. 

it did not take into consideration subcategories, so it thought Business:Subscription Serv - Business:Software Subscriptions was one big account, thus chopping it off at 31 characters. It now calculates 31 Character account names per : (colon)

[King_Poop_Scoop]

I downloaded CSVtoIIF451Latest.exe.

I imported my bank's .csv file no problem. (Transactions from January 1 2024 through today.)

Then I exported (printed) a tab delimited file using an earlier month from the same account. (QBD Premier manufacturing and Wholesale Edition 2021)

I used "Create/Edit Rules" and imported the tab delimited file and I created the .json file no problem.

Then I did some manual editing of transactions within the main app.

Exported the .iif

Imported to QB and only 9 transactions succeeded with over 100 failed.

So I thought, OK, let's skip the manual editing part and start over. Maybe I am doing something wrong.

This time I exported a tab delimited file using all of 2023. I then went through and cleaned that up only keeping stuff that had value, removing the # on each rule, etc.

This all seemed to work, so I exported the .iif file.

Imported the .iif to QB and BAM, QB was gone. It just crashed and went a way.

Tried it again and same thing. Needless to say, nothing was imported. I am at a stand still. 

I should mention, I firewalled QB so that it cannot communicate with the Internet. I am trying to freeze at 2021 -- obviously they have already sun-set my banking feeds.

Thanks -C

[+Warwagon MVC]

On 14/09/2024 at 19:30, King_Poop_Scoop said:

I downloaded CSVtoIIF451Latest.exe.

I imported my bank's .csv file no problem. (Transactions from January 1 2024 through today.)

Then I exported (printed) a tab delimited file using an earlier month from the same account. (QBD Premier manufacturing and Wholesale Edition 2021)

I used "Create/Edit Rules" and imported the tab delimited file and I created the .json file no problem.

Then I did some manual editing of transactions within the main app.

Exported the .iif

Imported to QB and only 9 transactions succeeded with over 100 failed.

So I thought, OK, let's skip the manual editing part and start over. Maybe I am doing something wrong.

This time I exported a tab delimited file using all of 2023. I then went through and cleaned that up only keeping stuff that had value, removing the # on each rule, etc.

This all seemed to work, so I exported the .iif file.

Imported the .iif to QB and BAM, QB was gone. It just crashed and went a way.

Tried it again and same thing. Needless to say, nothing was imported. I am at a stand still. 

I should mention, I firewalled QB so that it cannot communicate with the Internet. I am trying to freeze at 2021 -- obviously they have already sun-set my banking feeds.

Thanks -C

Sent you a message

[+Warwagon MVC]

Version 4.5.3.5 Released

The main new feature is the Bank Account Balance Tool 2.0 (Full change log on the first post)

 

 

[Dangit]

I do a lot of buying using my credit card from new vendors each month.  Would it be possible to create an export of the new vendors so I can upload them to QuickBooks.

[+Warwagon MVC]

On 24/10/2024 at 15:07, Dangit said:

I do a lot of buying using my credit card from new vendors each month.  Would it be possible to create an export of the new vendors so I can upload them to QuickBooks.

Actually when importing the iif into quickbooks, you can select this "I'll do it later option"

This is the pre 2019 option which will automatically add the venders in.

Just make sure you backup your company file first.

[MX1]

Hi there,

I last used this tool in early September. Today when I went in to do things the way I did last time, I get a message that my rules file is incompatible. I haven't done anything to it, it just says it's not compatible. I downloaded the newest version of the software and same problem. I had invested quite a lot of time adding things to my rules file so I am not sure what happened. It looks like I'm going to have to download the newest version and just start from scratch. I already did this as a test, and it does look like the way the rules are laid out in the text file is completely different than before. If you have any tips, I'd love to hear them.

Thanks!

[MX1]

Hi,

I think I misspoke - the .json file that is coming up as incompatible is apparently an automatch file. When I use the new beta version for testing, I see that a rules file is created as well as an automatch file. From what I can vaguely remember, I only had one json file in that directory before, hence my confusion as to why it is no longer compatible.

[+Warwagon MVC]

yes, it also creates an autocomplete file.

It has been creating an autocomplete.json file in that directory for quite a while, but maybe you were using a version before that didn't have autocomplete.

[+Warwagon MVC]

Version 4.5.5 has been released.

[wonderrx]

First off thank you for your work on this. I am still trying to figure out if this is a solution to my needs, but I will definitely be sending support if I get it all figured out.

So my two issues on my test imports so far (I am importing from a checking account and credit card account FYI).

1. Display rendering. I am on a 4k resolution Win 10 PC and the windows are rendering terribly with tiny text in all of your buttons and menus. The text on the imports are all fine/normal sized.

2. How to import transaction numbers. I would like to bring in the check numbers that are included on my CSV's.

Thanks again for your continued efforts, it's great to find a developer who is passionate about something like this!

[+Warwagon MVC]

On 08/01/2025 at 16:13, wonderrx said:

First off thank you for your work on this. I am still trying to figure out if this is a solution to my needs, but I will definitely be sending support if I get it all figured out.

So my two issues on my test imports so far (I am importing from a checking account and credit card account FYI).

1. Display rendering. I am on a 4k resolution Win 10 PC and the windows are rendering terribly with tiny text in all of your buttons and menus. The text on the imports are all fine/normal sized.

2. How to import transaction numbers. I would like to bring in the check numbers that are included on my CSV's.

Thanks again for your continued efforts, it's great to find a developer who is passionate about something like this!

First off my DPI support is lacking. I've tried my best to get it to look good, but on some 4k displays it might not look the best. Part of the issue is I don't have a 4k display. I think I hooked it up to a 4k tv once and I remember it not looking that bad.

Unfortunately, check numbers do not get imported. I might tackle it at some point, but it might require a significant overhaul.

[wonderrx]

On 08/01/2025 at 17:34, Warwagon said:

First off my DPI support is lacking. I've tried my best to get it to look good, but on some 4k displays it might not look the best. Part of the issue is I don't have a 4k display. I think I hooked it up to a 4k tv once and I remember it looking that bad.

Unfortunately, check numbers do not get imported. I might tackle it at some point, but it might require a significant overhaul.

You are awesome for such a fast response. Thanks for logging my request for the ability to put transaction numbers in somehow or to import them. I see when looking at the IIF there is a spot for it in that form.

So the issue I have had in my testing is I am not getting deposit transactions to come in with the Vendor/Payee name attached to the transaction. I've got them all filled in through rules/JSON in your converter, but in QuickBooks they are not there in the transactions for the checking out, only the deposits, the regular charges are working fine with having the vendor name.

Any guesses on what might not be working? It's very close to working great for me

[+Warwagon MVC]

On 08/01/2025 at 18:45, wonderrx said:

You are awesome for such a fast response. Thanks for logging my request for the ability to put transaction numbers in somehow or to import them. I see when looking at the IIF there is a spot for it in that form.

So the issue I have had in my testing is I am not getting deposit transactions to come in with the Vendor/Payee name attached to the transaction. I've got them all filled in through rules/JSON in your converter, but in QuickBooks they are not there in the transactions for the checking out, only the deposits, the regular charges are working fine with having the vendor name.

Any guesses on what might not be working? It's very close to working great for me

Ah yes. That would be the new Shi* way Quickbooks 2019 and newer way of importing.

The deposit names are empty. I did some testing with it. It's them not you or me. When importing, use the option "import it for me. I'll fix it later" ... should work then.

[wonderrx]

On 09/01/2025 at 09:02, Warwagon said:

Ah yes. That would be the new Shi* way Quickbooks 2019 and newer way of importing.

The deposit names are empty. I did some testing with it. It's them not you or me. When importing, use the option "import it for me. I'll fix it later" ... should work then.

Want to make sure I understand before I move forward.  I am successfully importing the IIF and I don't get any message. 

Where would I see the "import it for me. I'll fix it later" message?

Are you saying there basically isn't a way for the Vendor for deposits to pull in? I can live/roll with it, but definitely not as time saving.

Edited January 9, 2025 by wonderrx

[+Warwagon MVC]

On 09/01/2025 at 08:34, wonderrx said:

Want to make sure I understand before I move forward.  I am successfully importing the IIF and I don't get any message. 

Where would I see the "import it for me. I'll fix it later" message?

Are you saying there basically isn't a way for the Vendor for deposits to pull in? I can live/roll with it, but definitely not as time saving.

 

Also created a reddit 9 months ago about the subject on the blank vendor names on import

 

[wonderrx]

On 09/01/2025 at 10:39, Warwagon said:

 

Also created a reddit 9 months ago about the subject on the blank vendor names on import

 

Great news, the transactions did import correctly for the income transactions when I clicked that import it for me I'll fix it later link. Interstingly/helpfully it did not auto increment check numbers (most of EFT transactions) doing it that way. Doing it the normal QuickBooks button option did do that.

Thank you for the wonderful help! I'll get you a donation sometime soon.

[salo225]

Thank you so much for all your hard work on this. This program has been so incredibly helpful! 

One issue I've noticed with the new version (or at least that I'm experiencing) is that the memo-mapping does not reconcile to the payee when converted. ie - When my vendor names (as listed on my statements) get moved to the memo column, the memo column names do not sync to the Vendor/Payee column. the memo line shows a name from a completely different transaction

[+Warwagon MVC]

On 10/01/2025 at 16:21, salo225 said:

Thank you so much for all your hard work on this. This program has been so incredibly helpful! 

One issue I've noticed with the new version (or at least that I'm experiencing) is that the memo-mapping does not reconcile to the payee when converted. ie - When my vendor names (as listed on my statements) get moved to the memo column, the memo column names do not sync to the Vendor/Payee column. the memo line shows a name from a completely different transaction

I'll take a look it.

[+Warwagon MVC]

On 10/01/2025 at 16:21, salo225 said:

Thank you so much for all your hard work on this. This program has been so incredibly helpful! 

One issue I've noticed with the new version (or at least that I'm experiencing) is that the memo-mapping does not reconcile to the payee when converted. ie - When my vendor names (as listed on my statements) get moved to the memo column, the memo column names do not sync to the Vendor/Payee column. the memo line shows a name from a completely different transaction

I just opened up the latest version, opened up a QBO file, told it to use memo line if available, and the payee showed up on the memo line. I then selected all and exported to IIF. Then I opened the IIF file and took a look. What was on the memo line did match the payee / vender. Message me on Telegram, and I'll work with you one-on-one.

[salo225]

On 10/01/2025 at 18:31, Warwagon said:

I just opened up the latest version, opened up a QBO file, told it to use memo line if available, and the payee showed up on the memo line. I then selected all and exported to IIF. Then I opened the IIF file and took a look. What was on the memo line did match the payee / vender.

Thats strange.  I keep getting the same mismatch memo and payee info.  Even tried downloading it again. Same result. The prior version I downloaded (version F4544) seems to work ok for me though. 🤷‍♂️

[+Warwagon MVC]

On 10/01/2025 at 18:59, salo225 said:

Thats strange.  I keep getting the same mismatch memo and payee info.  Even tried downloading it again. Same result. The prior version I downloaded (version F4544) seems to work ok for me though. 🤷‍♂️

The rules file wins.  When it comes to descriptions on the memo line. So make sure your rules file doesn't contain wrong transaction memos.

[+Warwagon MVC]

On 08/01/2025 at 16:13, wonderrx said:

First off thank you for your work on this. I am still trying to figure out if this is a solution to my needs, but I will definitely be sending support if I get it all figured out.

So my two issues on my test imports so far (I am importing from a checking account and credit card account FYI).

1. Display rendering. I am on a 4k resolution Win 10 PC and the windows are rendering terribly with tiny text in all of your buttons and menus. The text on the imports are all fine/normal sized.

2. How to import transaction numbers. I would like to bring in the check numbers that are included on my CSV's.

Thanks again for your continued efforts, it's great to find a developer who is passionate about something like this!

So i'm working on better DPI support

Download LInk

Give the csvtoiif465dpi.exe version a try.

It's just a test version i'm working on for DPI support

[+Warwagon MVC]

On 10/01/2025 at 18:59, salo225 said:

Thats strange.  I keep getting the same mismatch memo and payee info.  Even tried downloading it again. Same result. The prior version I downloaded (version F4544) seems to work ok for me though. 🤷‍♂️

After reading the comments. I forgot the re-respond to you. This was fixed in the newest release.

"Resolved: 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)."

[+Warwagon MVC]

v4.6.8.3
March 18th, 2025

• Fixed: Removed "Load Accounts List" and "Load Vendor List" from Autocomplete Options. Now, only the "Load Data from IIF File" option is used.
• Fixed: When importing accounts and vendors using an IIF file under Autocomplete Options, the system now ignores special characters and provides a list of ignored entries.
• Fixed: The wizard now properly ignores special characters when importing accounts and vendors from an IIF file.
• New: During the setup wizard it now confirms when vendors have been successfully imported and notifies the user if the IIF file contains no accounts or vendors to import.
• New: Added support for XML formatted QBO files.