MD2019 - QIF import erroneously creates empty 'Imported Bank Account'

al.byrne's Avatar

al.byrne

01 Feb, 2019 06:48 AM

While I'm having some difficulties with MD2019's new lack of support for keyboard navigation in the 'Import' dialog box (see discussion http://help.infinitekind.com/discussions/problems/50445-2019-1847-import-qif-restricted-keyboard-navigation) MD2019 is still happily allowing me to periodically (I do it every few weeks) import QIF files to each account.

Unfortunately, every import mysteriously creates an extraneous 'Imported Bank Account'. Transactions from the QIF are correctly loaded to the target account, but an extra (empty) account is created (see screenshot below). If I import a series of QIFs to multiple accounts during the same session, only one 'Imported Bank Account' is created. Thus, following any QIF data import, I need to dive in to Tools->Accounts and delete the extraneous account. I have confirmed that this behaviour can be reliably replicated - I've just tested, using four different accounts from three different banks.

I presume this behaviour is NOT as intended! (and it certainly wasn't evident in MD versions prior to MD2019).

Any thoughts?

Showing page 2 out of 2. View the first page

  1. 31 Posted by al.byrne on 14 Feb, 2019 09:19 PM

    al.byrne's Avatar

    And, I can no longer navigate the import dialog box using just keyboard navigation.

    We've gone backwards in terms of both functionality and usability, when it wasn't, as far as I could see, actually broken!

    I'm currently testing an opposition product - the one that does facilitate (for an annual subscription) fully automated downloads from the major Australian banks. The UI is certainly different, but I'm encouraged. I shifted from Quicken to Moneydance after 11 years, and now, after 8 years with Moneydance, perhaps the time might be right to move on...

  2. 32 Posted by michael on 15 Feb, 2019 09:32 AM

    michael's Avatar

    Yep they worked perfectly.

    Vie rolled back to 2017 and left it until someone decided to get this important bit working correctly again

    Michael
    ________________________________
    Tel: +44 (0) 208 866 3460
    Mob: +44 (0) 7850 855555
    Fax: +44 (0) 870 486 0633
    Email: [email blocked]<blocked::mailto:[email blocked]>

  3. 33 Posted by dwg on 15 Feb, 2019 10:16 AM

    dwg's Avatar

    I'm a fellow user.

    I can only suggest if you are not getting support and the product is not working as it should you do what people should do whenever they are dissatisfied and that is complain to the management.

    In the case of Moneydance that means Sean Reilly and his email is

    sreilly (at) infinitekind (dot) com

  4. 34 Posted by Peter Barlow on 17 Feb, 2019 10:54 AM

    Peter Barlow's Avatar

    I use PC and Mac versions of MD and only Mac version creates Imported Bank Account

  5. 35 Posted by TonyRI on 17 Feb, 2019 01:47 PM

    TonyRI's Avatar

    I have the option of importing qif, or qfx files from Synchrony bank. I used to always choose "Microsoft Money" format (qif). I now choose "Quicken" format for the qfx file. to avoid the extraneous imported account creation. I use a Windows 10 PC and the problem described by the OP still exists

  6. 36 Posted by Peter Barlow on 20 Feb, 2019 09:25 AM

    Peter Barlow's Avatar

    From: TonyRI <[email blocked]>
    Sent: 17 February 2019 13:47
    To: [email blocked]
    Subject: Re: MD2019 - QIF import erroneously creates empty 'Imported Bank Account' [Problems #51029]

     

    Just discovered MD for Mac only does this if I use the auto open option for .qif files. Manually importing does not create the Imported Bank Account. Have been manually importing .qif files on PC so perhaps that’s why I never saw it.

     

    Regards

     

    Peter

  7. 37 Posted by dwg on 20 Feb, 2019 11:01 AM

    dwg's Avatar

    All the tests I have done I have manually imported QIF files (on Windows 10), all except one imported without problems one however created the Imported Bank Account and I was able to get it to do it twice in two different data sets. I can see nothing in the QIF file that explains why.

  8. 38 Posted by al.byrne on 20 Feb, 2019 11:24 AM

    al.byrne's Avatar

    I continue to see the issue, absolutely repeatably, if I use ‘File->Import’, or if I double-click a downloaded QIF file in the Finder. In all cases, the erroneous empty ‘Imported bank account’ is spontaneously created during the data import.

    I’m getting depressed...

  9. 39 Posted by michael on 20 Feb, 2019 11:28 AM

    michael's Avatar

    Yes it’s a total pain and a rubbish response.

    I have gone back to 2017 and its fine pro tem

    Michael
    ________________________________
    Tel: +44 (0) 208 866 3460
    Mob: +44 (0) 7850 855555
    Fax: +44 (0) 870 486 0633
    Email: [email blocked]<blocked::mailto:[email blocked]>

  10. 40 Posted by dwg on 20 Feb, 2019 11:36 AM

    dwg's Avatar

    I cannot say I blame you, QIF imports worked perfectly in previous versions the only issues were people choosing the wrong import parameters, but that is pretty easy to spot and fix.

    I have posted pointers to this thread on the developers web site but have seen no acknowledgement at all.

    I can only suggest complaining directly to the owner

    In the case of Moneydance that means Sean Reilly and his email is

    sreilly (at) infinitekind (dot) com

  11. 41 Posted by michael on 20 Feb, 2019 11:50 AM

    michael's Avatar

    I've tried the owner. No response

    --- Original message ---

  12. 42 Posted by tony on 23 Feb, 2019 06:58 PM

    tony's Avatar

    I’ve had a similar problem but importing qif now causes the program to freeze needing a task kill using W7 2017.10 works. I don’t know if I’ve corrupted the data on this account or how to repair it

  13. 43 Posted by dwg on 27 Feb, 2019 10:59 PM

    dwg's Avatar

    I would suggest you try the latest preview and see if it corrects the problem of creating the extra account:

    http://infinitekind.com/preview

  14. 44 Posted by al.byrne on 27 Feb, 2019 11:27 PM

    al.byrne's Avatar

    No, sadly, no joy.

    Just downloaded and tested build 1859. While the 'import to' dialog drop-down menu has been reverted to a style that allows keyboard navigation, importing a freshly downloaded QIF of transactions still spontaneously creates an erroneous, empty, 'Imported Bank Account'.

  15. 45 Posted by dwg on 27 Feb, 2019 11:35 PM

    dwg's Avatar

    At least there is some progress.

  16. 46 Posted by dwg on 28 Feb, 2019 05:22 AM

    dwg's Avatar

    I've been able to reproduce the problem on a new data set using a specific QIF file. I have provided a pointer to the developer on the file that I can get this problem with.

  17. 47 Posted by dwg on 05 Mar, 2019 07:44 AM

    dwg's Avatar

    The latest preview has a note about correcting the erroneous account being created..

    http://infinitekind.com/preview

    I however am still getting the extra account created with the test QIF I am using but of course you may get different results.

  18. 48 Posted by TonyRI on 05 Mar, 2019 11:44 AM

    TonyRI's Avatar

    build 1860 no longer created the extra account, the mapping popup defaults to 'Imported Credit Card Account'. After selecting the appropriate account, the file imports correctly and no extra account was created.

    The only difficulty that I experienced, was that the mapping wasn't saved (as in the past). Even after closing and reopening app and re-importing, it will default to the mapping screen that begins with 'Imported Credit Card Account' I then have to re-select the appropriate account each time. Not a big deal but still not performing as previous versions.

  19. 49 Posted by tony on 05 Mar, 2019 12:03 PM

    tony's Avatar

    In my case the above is true, but its a bank account not credit card. The default is "Imported Liability Account" and you cant save the choice.

    More concerning is an import freezes my PC W7. It did this on the previous version, unless I deleted the rogue account.

    My feeling is there is still this phantom account somewhere in my data, as the chooser box seems to list all the accounts on my file ?

  20. Support Staff 50 Posted by Sean Reilly on 05 Mar, 2019 03:43 PM

    Sean Reilly's Avatar

    Hi TonyRI,

    When you have to re-select the account in the import window, is the credit card account that you'd like to import to selected and showing its register?

    Thanks,
    Sean

    From: TonyRI <[email blocked]>(mailto:[email blocked])
    Reply: [email blocked] <[email blocked]>(mailto:[email blocked])

  21. 51 Posted by tony on 05 Mar, 2019 03:52 PM

    tony's Avatar

    I think this is for me. No it’s not selected and not showing it’s registra. It may be because the way I have always imported is

    Download file from bank
    Moneydance opens as it’s associated with qif
    Import box shows list of accounts with imported liability at top.

    I scroll down chose the correct account

    Tranactions show in register but 2 line spacing ( normally I have single)

    Money dance freezes.

    That’s how I’ve always done it, but in 2017.10 the correct account is already selected and it imports in a single spacing line

    Tony

  22. 52 Posted by tony on 05 Mar, 2019 04:07 PM

    tony's Avatar

    Sorry if this isn’t for me but info may be useful. My post is listed but private as files attached

  23. 53 Posted by TonyRI on 05 Mar, 2019 04:27 PM

    TonyRI's Avatar

    Hi Sean,

    Yes.

    The way that I perform the import is to open the credit card register first (In this case Amazon Prime (Synchrony Bank). I then use MS Edge to go to the site. I select the appropriate parameters for exporting data. After I click on 'export', a dialogue box opens, asking whether to open or save. I click on 'open". The MD import window opens to the default 'imported credit card account'. I select the Amazon Prime Account. The import works as expected. I can merge and reconcile without issue.

    When I go back to the site again (As I just did to outline this submission), the process is exactly the same. The import box defaults to 'Imported Credit Card Account' until I manually select the correct account again.

    I hope that this additional information is helpful to you.

    In my case, I do have the ability to select a qfx file instead, so it is not causing a major issue for me (although the qif file provides better transaction description fields).

    Thanks for your prompt attention and continued efforts for resolution.

    Best Regards,

    Tony :)

  24. 54 Posted by al.byrne on 05 Mar, 2019 09:06 PM

    al.byrne's Avatar

    Hi all (Sean, thank you for joining us!).

    While build 1860 has cured the spontaneous creation of an empty 'Imported bank account' on QIF import, I can see the import dialog box is offering to import to what is, at that point in the process, a non-existent new account called, unsurprisingly, 'Imported bank account'. If I scroll and click to select the correct account, the data import to the targeted account proceeds normally and no extraneous account is created. I have not been brave enough to attempt importing into the proposed new account!

    I see the same indications if the QIF originates from a bank savings account, a credit card account, or a loan/liability account, and the account register (if any) open as I commence the import does not vary the result.

    Summary: in all cases, the import dialog proposes import to a non-existent account called 'Imported bank account'.

    MacBook Pro, MacOS Mojave 10.14.3.

  25. 55 Posted by michael on 16 Apr, 2019 01:13 PM

    michael's Avatar

    Where can I download build 1866. The main page only gives you 1855

  26. 56 Posted by TonyRI on 16 Apr, 2019 01:15 PM

    TonyRI's Avatar

    Preview version is available here:

    https://infinitekind.com/preview

  27. 57 Posted by TonyRI on 16 Apr, 2019 01:16 PM

    TonyRI's Avatar

    build 1866
    - QIF import fix: Correct sign of transfer amounts in BuyXfr transactions - QIF import fix: Handle some additional starting balance transactions - Added border to pie graphs - Summary page border and font tweaks - Minor register font tweaks - Fix buy/sell markers on securities graph to properly account for stock splits - Deleting an account in the account or category list window now automatically selects the next account or category - Allow selection of investment accounts in QIF import dialog - Attempt to improve scrolling in QIF import window currency/account-type selector

  28. Support Staff 58 Posted by Sean Reilly on 16 Apr, 2019 02:13 PM

    Sean Reilly's Avatar

    Hi Al,

    Yes, QIF files for single accounts usually do not specify the type of account that they are associated with, so Moneydance shows the "Imported Bank Account" option to give you the opportunity to put the transactions from the import into a new account with the default type (bank) but the ability to change the account type for the new account, or to simply select a different existing account.

    In recent builds you can also change the type or currency for any accounts, provided that they don't already have existing transactions in them.

    I'd love to hear any suggestions or reports of problems with this new setup.

    Thanks!
    Sean

  29. 59 Posted by al.byrne on 16 Apr, 2019 09:02 PM

    al.byrne's Avatar

    Good morning Sean, I’ve just downloaded and tested build 1867b, and tested import of a freshly downloaded QIF.

    - import dialog box - can’t navigate from the default ‘imported bank account’ by keyboard. User must manually click on target account. From that point onward, can navigate the account list by arrow keys

    - import appears to proceed normally, however, when the target account register opens it has changed from single-line view to two-line view

    - and, most importantly, the app then freezes. Must force quit.

    - on subsequent relaunch, imported data is OK, and single-line view is restored.

    All too late for me, after eight years of using Moneydance, I’ve switched. It’s been great, but these QIF import difficulties over the last few months have been too much for me.

    Thanks for all your efforts,

    A.

    MacBook Pro 2017, MacOS Mojave 10.14.4

  30. 60 Posted by tony on 17 Apr, 2019 10:25 PM

    tony's Avatar

    Interesting. I had, and still have an issue with it crashing on W10 if I import ( by download and file association) without Moneydance running. I think that’s likely a different issue to the Mac.

    However here is the interesting bit. When it crashes my W10 I get the double line view. After a force restart it’s back to single line.

    There must be something common here.

    Tony

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screen_Shot_2019-01-27_at_14.09.15.jpg 24.7 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac