CSV / QBO to IIF converter.


Recommended Posts

Disclaimer: Use at your own risk. I made this app for my needs and it works fantastically. If you use this app BACKUP your company file before importing the iif file. You should be doing that anyway.

Up to Quickbooks 2018 the iff file should import without issue. In Quickbooks 2019 and newer if you import your iif file the new way, it will work, but descriptions on deposit bank transactions seem to be left blank and check numbers are added for each debit.

Quickbooks 2019 and above still give you the option at the bottom of the import screen 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

Tutorial

 

Known Bugs

If you want to sort by date do so AFTER loading a pattern file.

Compiled EXE and source code on Dropbox.
I will now keep a copy of the previous version in the folder too. In case the latest release breaks something

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

NEW Editor UI! Both apps are now in a single application

image.thumb.png.43ca6054bb9fdc436d027749769cd765.png

 

Wasn't sure where to post this, but I thought this might be a good spot from now on.

This is an QBO/CSV to Quickbooks IIF converter I created with the help of Chat GPT. No, it's not written Powershell, yes it probably could have been written in PowerShell, no I don't want to learn PowerShell. (That was for the Powershell guy that always comes in these threads.)

I'm still using Quickbooks Pro 2018. A couple of years ago my bank stopped offering IIF files for transaction downloads and only offers CSV and OBO. I was never a fan of OBO files, so I went looking for a CSV to IIF converter. I only found one and it was $150 was called "Transactions". Looks like they have now changed the name and are charging $150 PER YEAR for it. https://www.propersoft.net/purchase/

I've been using it for a few years and it does work well. I just refuse to upgrade to the new Quickbooks as Intuit has become Greedy, and now it's a yearly cost of $500+ (when I used to buy it for $250, every 4 years)

So the other day I was wondering, if is it possible to with the help of chatGPT have one written in Python. A couple of days later I finished it. I've since converted it to EXE and added it to my created apps collection. I've put it through its paces and fixed all the bugs that I could see.

I thought I would just put this out there for anyone who wanted a free solution instead of paying $150 PER YEAR!

image.thumb.png.eb8497b36ed4e547f4876c7a9f954fc9.png

The blank white lines are lines that I've redacted for this post.

This is a screenshot of an older version. Above is the newer UI, I didn't want to create a new screenshot as it takes a lot of redacting.

image.thumb.png.73a2b99ed9b0c8f3a72de171a422060b.png

It also includes what I call a “Pattern Editor” which is now built right into the main application.
 
image.png.395cc5eebf479c00aa6a225f12932d95.png
 
The editor is pretty cool, it lets you create a Definition file which can be loaded into the main application. This allows you to do the following.
 
  •  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 it 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. I did this because my Verizon gets put on my VISA card every month, but some months 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.
  •  If a transaction has X in the name, rename the transaction and add it to this account. So 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 you can and it works great! You just enter amount 1 for account 1 and amount 2 for account 2. (its in the screenshot)
  • •You can also have it automatically add memos for certain transactions who's name/total or just name matches.

To convert the source code into an exe

First, you would install pyinstaller

First, make sure to run this command from a CMD. This installs the requirement the my python application requires to run.

pip install PyQt5

Then navigate to the following folder depending on your Python version.. Put your Python source code file (.py) in that folder.

C:\Users\(username)\appdata\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\Scripts

Then open a powershell window and cd to the same folder.

Then run the following command

.\pyinstaller --onefile -w --icon=(name of your png if you want to use an icon).png '(Name of your file).py'

Example 

.\pyinstaller --onefile -w --icon=transfer.png 'copythese.py'

You will find the converted EXE inside the dist folder located inside the path given above.

A bug was found in 4.0 and 4.1 were splits were not being recorded to the IIF file. So I fixed it and have released the beta version of 4.2

v4.2 Latest
May 26th, 2024 :

  • 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 the 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. Instead, 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 recorded.
  • New: Made the warning box about splits not matching bigger, just like the final box that appears when you export a CSV.
  • Updated: Removed the warning about the 32-character limit on the account name. That feature was shortening the account names which had previously worked without issue.

v4.1 PULLED
May 19nd, 2024 :

  • New: Added a "Swap debit and credit" button. Some Financial institutions give debits a positive amount and a credit a - amount. When that happens the debit's and credits swapped. This button lets you swap them around back to where they should be
  • New: When the pattern file is imported into the main application, it will ask if you "want to copy the old transaction descriptions to the memo line."
  • New: Added support for csv in tab format, but only if the format is date/amount/description.
  • New: Added a donation button, in case people wanted to donate via Venmo.
  • Update: Added support for the discovery credit card CSV format.
  • New: In the pattern editor it now shows a Length exceeded dialog box if your account name exceeds 31 characters. Quickbooks only allows account names with a maximum of 31 characters.

 

v4.0 PULLED
May 13nd, 2024

  • Fix: When checking for existing transactions in Quickbooks, if it finds more than 2 transactions with the same name and same amount, it will switch to also checking by date.
  • New: You can now export your register using print to a file, and select CSV Deliminated file. Then, in the program, you can load your transactions, load the pattern file, and then select all and load the exported file and it will uncheck any transactions already in QuickBooks
  • Fix: A bug in the code was introduced when working on the QBO section that would put debits in credits and credits in debits.
  • New: The app reloads when you click on load CSV or QBO if a file has already been loaded. This prevents custom account names from staying from one load to another
  • New: A new account selection screen was added. This screen lets you add and delete accounts and select them from a drop-down.
  • New: Drastically improved support for QBO (I had no idea some were formatted differently than others)
  • New: Added support for OFX files.
  • New: You can now modify data directly on the table and save it to an if file without a pattern file loaded. If a pattern file is loaded, what you have manually entered will only save if there is no match in the pattern file. Otherwise, the pattern file wins.
  • Updated: Updated the tutorial link to a new tutorial for version 4.0

image.png.3c3becbe12aa6f57cc5476311674ff7f.png

image.png.0cbb36e886e93f6df0d27b2c81d725b3.png

  • New: Added DPI support for the account menu
  • New: Redesigned the success dialog box on Export

image.png.08108fc3738130dfb508a45b47d34466.png

v3.9
May 2nd, 2024

  • New/Fixed: Disabled Sorting. If you were to sort any column and load a pattern file, it crashed. If you do not sort, load a pattern file, and then sort and export, transfers end up in the wrong transactions. So, I turned off the ability to sort.
  • New: Added a button at the top that says " Show uncategorized transactions". I spoke with a beta tester who said he sorted only to find uncategorized transactions. Now, you can just push a button. It's even easier than sorting
  • New: I never really mentioned this, but many versions ago, I added CTRL+F Functionality, which would bring up a search box on the bottom of the application, letting you search transactions. Now I have made that box visible and added searching accounts and descriptions.
  • New: After a pattern file is loaded, you can no longer load another one unless you reload your CSV or QBO. In some edit cases I've seen the table data get corrupt when loading 1 pattern file after another
  • New: After a pattern file is loaded, you can no longer load another one unless you reload your CSV or QBO**.** In some edit cases, I've seen the table data get corrupt when loading 1 pattern file after another
  • New: Added a button called "Add names to pattern files"
  • New: You can now load an empty patter file into the converter or a file with patterns in it. Then select transactions who's names you want to add to the pattern file to match and then click "Add names to pattern file" in the pattern file will be a list of names of a large number of online reatailers. if it matches any of those names in a transaction, it will truncate the name in the pattern editor.
  • Fixed: A bug was introduced in 3.8.5 that if a pattern file only had 2 entries, it would not open, saying that the pattern file was invalid.

v3.8.7 Stable
April 28th, 2024

  • Fixed: A bug was introduced in 3.8.5 that if a pattern file only had 2 entries, it would not open, saying that the pattern file was invalid.

v3.8.4
April 23th, 2024

  • New: You can now resize the main app.

v3.8.5
April 18th, 2024

  • Update: Redesigned the welcome box
  • New: Added a tutorial link to the bottom of the welcome box.
  • New: Renamed amount1 account1 and amount2 account2 to Split 1 Amount Split 1 Account Split 2 Amount Split 2 Account

image.png.6df546a091910d96abda41e17624fa3c.png

v3.8.5
April 17th, 2024

  • New: Added the color Red for items in the pattern editor list that have the account name "ignore"
  • New: Added a new button that says "What do the colors mean"
  • New: Added a box that now tells you what every color means
  • Updated: Added a box that now tells you what every color means
  • Fixed: It now checks inside every loaded JSON file to see if on the 3rd line of the file it says "Pattern." If it doesn't, it says, "This file is not a valid pattern file". It will no longer let you load random JSON files.

image.png.f3141b6a4e33f541d295a6af5974d7c2.png

 

v3.8.4
April 17th, 2024

  • New: Redesigned the Create, Open, Import, Help, and Cancel menus. I always thought it looked fugly.

image.png.d4b2db1de93da689e08e1f382dd606c3.png

v3.8.3
April 15th, 2024

  • New: Added "Import" to the first dialog of the pattern editor. This lets you import a tab-delimited file that you can print from your bank / credit card register. (Print / file / tab delimited). When imported, every vendor and account you've used between the dates specified on the print will show up in the app. Every vendor entered into the "What to match field" will have a # put in the back of their name, so they can not automatically match a transaction when the pattern file is loaded. When the txt file is imported, the account specified for that vendor is also automatically filled on the pattern editor. Every account ever used during those dates is also added to autocomplete.
  • Fix: Renamed "Save" to "Create"
  • Fix: If there is no defaultaccount.txt and you open the app, leave the "Please set a default account" Blank, click cancel, proceed to change the default import account to something else, and click "set," the program will crash.
  • Update:  Updated the YouTube URL in the "Tutorial" Button. It now points to the newly released tutorial for 3.8.3
Link to comment
Share on other sites

  • 2 weeks later...

OLD POST. I thought I would leave it here so that you can see how fugly the first version of the definition 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.

image.png.bfa90a41cdf88edb4c1df94506c4924b.png

image.png.19c7a61a6247fb251dc78a9b622f5e5b.png

pip install PyQt5
pip install wxPython

Compiled EXE on Dropbox

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

Link to comment
Share on other sites

  • 4 months later...

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 by NexGen.Media
Link to comment
Share on other sites

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

image.png.e442beae24ab505238fa92f773c6c03c.png

Link to comment
Share on other sites

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! :)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • +Warwagon changed the title to CSV / QBO to Quickbooks IIF converter.
  • +Warwagon changed the title to CSV / QBO to IIF converter.

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

Screenshot 2024-03-22 115411.png

Screenshot 2024-03-22 115536.png

Link to comment
Share on other sites

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

Screenshot 2024-03-22 115411.png

Screenshot 2024-03-22 115536.png

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

Link to comment
Share on other sites

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

Screenshot 2024-03-22 115411.png

 

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

Link to comment
Share on other sites

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.image.thumb.png.87d2426aab39f081cfaadcdbb68ba0a7.png

image.thumb.png.a6a675bd27956b01dd587ef8f1068a87.png

Link to comment
Share on other sites

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

image.thumb.png.603c1646b4adf488c8df3a1c0178150e.png

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

image.png.f6b2511599641768b40cd2ddc7031456.png

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


 

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.