Import OFX Credit Card from Bank

Alex's Avatar

Alex

19 Oct, 2009 01:13 AM

My VISA is issued through my bank. It only allows for downloading OFX files. When I download the credit card details and attempt to import it only brings up my bank accounts in Moneydance and not my credit cards. Not sure if this is a bug in MoneyDance or how the file is downloaded. I have no qualms having to edit the OFX file, just need to know what to change. Here is the details from the top of the file with sensitive portions 'X'ed out.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX> <SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO</STATUS><DTSERVER>20091018210521.899[-4:EDT]<LANGUAGE>ENG<FI><ORG>XXXXXXXX<FID>XXXXX</FI></SONRS></SIGNONMSGSRSV1><br/> <BANKMSGSRSV1><STMTTRNRS><TRNUID>0<STATUS><CODE>0<SEVERITY>INFO</STATUS><STMTRS><CURDEF>USD<BANKACCTFROM><BANKID>XXXXXXXXX<ACCTID>XXXXXXXXXXX<ACCTTYPE>CREDITLINE</BANKACCTFROM>

Showing page 2 out of 2. View the first page

  1. 31 Posted by Ben Spencer on 01 Sep, 2010 12:27 AM

    Ben Spencer's Avatar

    We have the next stable release MD2010r4 pencilled in for October 1st. There will certainly be a beta release containing the fix before that data.

    Ben Spencer
    Moneydance Support

  2. 32 Posted by henjenliu on 10 Oct, 2010 12:12 PM

    henjenliu's Avatar

    This may be an easy solution to Alex and the above posters. I too recently started having problems importing my credit card transactions, after a year of problem-free use. Either Moneydance changed their code in a recent version or my bank changed the way they sent the info. But when I tried to import to my credit card account, all I would see listed were my bank accounts.

    Now, I use Citibank for my banking and credit cards. I was accessing all of my accounts through the Citibank Online pages. Instead, I went to the Citicards site and registered my credit cards. This site did indeed send the info which was properly recognized by Moneydance as "credit card." So if your credit card has some other way of accessing your statement, I would try that. At least until Build 752 comes out. Hope this helps.

  3. 33 Posted by Alex on 04 Nov, 2010 02:16 AM

    Alex's Avatar

    I second third fourth etc this. When can we expect the update as I'm
    now back logged to February of this year because of a rather annoying
    feature that makes it so I cannot choose my VISA card. Oh what joys
    I'll have when I must download and import all those months of
    transactions. I've been looking great during these troubled times with
    only monthly payments showing for VISA.

    Alex

  4. 34 Posted by Lionel Freeman on 04 Nov, 2010 01:29 PM

    Lionel Freeman's Avatar

    Is the import OFX working now?

    Lionel

    On 4 November 2010 02:18, Alex <
    [email blocked]<tender%[email blocked]>
    > wrote:

  5. 35 Posted by Jessica Little on 07 Nov, 2010 08:02 PM

    Jessica Little's Avatar

    Hi All,

    We've had some technical difficulties that have delayed the release of r4, but we hope to have a test build out shortly, and then the stable r4 release out a week or so after that.

    Jessica Little
    Moneydance Support

  6. 36 Posted by Alex on 30 Dec, 2010 04:34 PM

    Alex's Avatar

    Will we be seeing r4 or Moneydance 2011 soon? My net worth is looking
    great with only payments to my visa card. It will be almost a year now
    since I was able to download and import my ofx file for my visa card.
    I've been waiting for the ability to choose my Visa credit card as my
    credit union does not put in the correct details. Alternatively if I
    knew what Moneydance is looking for to decide what accounts to offer I
    could hand edit the file before importing.

    Alex

  7. 37 Posted by Jessica Little on 05 Jan, 2011 04:10 PM

    Jessica Little's Avatar

    Hi Alex,

    We hope to have a preview build out shortly that should have this fixed. Unfortunately, I can't give you an exact timeline yet, but we're very actively working on it.

    You could edit the file, but I believe it would mess up the signs on your transactions (making them negative when they should be positive, and visa versa). I'm really pushing to get this new release out within the week, so it might be worth waiting a bit longer. I'm very sorry for the delay and inconvenience.

    Jessica Little
    Moneydance Support

  8. 38 Posted by bill on 27 Jan, 2011 03:41 AM

    bill's Avatar

    This seems to be taking an unusually long time to get out. We really need this soon.

    Bill

  9. 39 Posted by Ben Spencer on 29 Jan, 2011 03:26 PM

    Ben Spencer's Avatar

    I realize this is an important issue and I am sorry for the delay. There are a couple of important features that the developers really want to get polished in the next release and I am afraid that this is pushing back the time line.

    Sincerely
    Ben Spencer
    Moneydance Support

  10. 40 Posted by Michael on 06 Feb, 2011 06:53 PM

    Michael's Avatar

    Ben,

    I've long had similar issues, but my bank gave an option to download .qfx files, which gave me a work-around. They no longer do that; and so I now find myself with no way of downloading credit card information other than the .ofx route. If Moneydance will not patch this soon, I will need to shift to another program soon.

    Michael

  11. 41 Posted by bkeyport on 08 Feb, 2011 07:42 AM

    bkeyport's Avatar

    I'm having this problem as well - but only one bank has the issue - I uploaded a OFX file in a private discussion, so the developers have test material.

  12. 42 Posted by Jessica Little on 08 Feb, 2011 02:27 PM

    Jessica Little's Avatar

    Hi All,

    I'm very sorry for the long delay on this. We've resolved some of the issues we were having earlier and hope to have a preview build of Moneydance 2011 out in the next week that should address this issue.

    Jessica Little
    Moneydance Support

  13. 43 Posted by bkeyport on 07 Mar, 2011 08:15 AM

    bkeyport's Avatar

    so, it was a week, a month ago. Hmmm. What happened now?

  14. 44 Posted by Jessica Little on 07 Mar, 2011 06:41 PM

    Jessica Little's Avatar

    So, we're almost ready to release the preview. If you're willing, could you test out one of our daily builds to make sure the problem is fixed? You should be aware that this is kind of a beta of a beta, so there might be bugs that we've not yet fixed in it. Definitely back up your files before installing this. If you'd like to try it out, you can download installers for the daily build from our website at http://moneydance.com/tmp/daily/installers/

    Jessica Little
    Moneydance Support

  15. 45 Posted by bkeyport on 08 Mar, 2011 04:32 AM

    bkeyport's Avatar

    Build 777 is good for me, except for printing issues (mentioned elsewhere). All problems are fixed.

  16. 46 Posted by Peter Linley on 08 Mar, 2011 10:55 PM

    Peter Linley's Avatar

    Thanks Jessica. I downloaded the beta and the OFX option worked fine when
    selecting my credit card so thats a big improvement. By the way I did notice
    a bug in the charting section. When selecting a chart to give me a
    particular category spending for the last 12 months, but shown on a monthly
    basis, all I got was a 12 month cumulative figure which was no help. This
    problem does not exist in the current version. Also it only allowed me to
    edit the chart once. Thereafter all the options were 'greyed' out.

    Pete

    On 7 March 2011 20:41, Jessica Little <
    [email blocked]> wrote:

  17. 47 Posted by Jessica Little on 09 Mar, 2011 03:38 PM

    Jessica Little's Avatar

    Hi Pete,

    Thanks for the bug report. Which chart were you using exactly? Just want to make sure I'm debugging the right one.

    Jessica Little
    Moneydance Support

  18. 48 Posted by Peter Linley on 09 Mar, 2011 05:17 PM

    Peter Linley's Avatar

    Hi Jessica

    Using an Expense or Income Chart and selecting say the last 12 months and
    then selecting 'Group by Month', Moneydance does not show it monthly.
    Instead it just gives a cumulative amount which is obviously not useful if
    you are trying to analyze monthly Expenditure or Income.

    Pete

    On 9 March 2011 17:38, Jessica Little <
    [email blocked]> wrote:

  19. 49 Posted by Peter Linley on 10 Mar, 2011 03:33 AM

    Peter Linley's Avatar

    Hi Jessica

    Just picked up another issue with downloading OFX. I have a mortgage account
    with my bank. When I download an an OFX file from that account, Moneydance
    only provides options to select bank accounts and credit cards now but not
    Liability accounts like Mortgage loans.

    Thanks

    Peter

    On 7 March 2011 20:41, Jessica Little <
    [email blocked]> wrote:

  20. 50 Posted by Jessica Little on 12 Mar, 2011 04:55 PM

    Jessica Little's Avatar

    Hi Peter,

    That report was changed to be cumulative since the last build. However, I think we had meant to put an option on it to be non-cumulative, but that apparently didn't happen. I've added a ticket for this feature to our bug tracking system. Thanks for pointing it out.

    As for the second issue, I believe I've fixed this. The fix should show up in tomorrow's daily, which is usually built around 10 am. Could you try it tomorrow and let me know if you can download to your liability account?

    Jessica Little
    Moneydance Support

  21. 51 Posted by Peter Linley on 15 Mar, 2011 02:29 AM

    Peter Linley's Avatar

    Hi Jessica

    Still nothing. Have downloaded the latest build but still no change on being
    able to download liability accounts in OFX.

    Regards

    Peter

    On 12 March 2011 18:55, Jessica Little <
    [email blocked]> wrote:

  22. 52 Posted by Jessica Little on 16 Mar, 2011 07:23 PM

    Jessica Little's Avatar

    H Peter,

    OK, I've tried another fix for this. It should be in the daily build tomorrow (Thursday) after 10. Please try it out once available and let me know if the problem is fixed.

    Jessica Little
    Moneydance Support

  23. 53 Posted by Peter Linley on 18 Mar, 2011 10:09 PM

    Peter Linley's Avatar

    Tried it now, Friday, still not working.

    Peter

    On 16 March 2011 21:24, Jessica Little <
    [email blocked]> wrote:

  24. 54 Posted by Jessica Little on 19 Mar, 2011 12:22 PM

    Jessica Little's Avatar

    Hi Peter,

    I'm not sure why it's still not working. If you would be willing, could you send me the logs from your download attempt? Here's how to get them:

    1) In Moneydance, click on the Help menu and select the Console Window option. This will open the console messages window.
    2) While the Console Window is open, attempt to connect to your bank. Any error messages should be recorded to the Console.
    3) Select all of the text in the Console and use the Copy to Clipboard button at the bottom to copy the text.
    4) Paste the text from the message window into a text file (preferably saved with a .txt extension) and email that file directly to me at jessica @moneydance.com.

    Do not attach the file to your response here, since this thread is public and the logs will contain your account information. To be safe you should redact any account info in the debug logs. Just replace it with something like ACCOUNT NUMBER HERE and it should be fine.

    Jessica Little
    Moneydance Support

  25. 55 Posted by randolph on 25 Dec, 2011 05:58 PM

    randolph's Avatar

    For what it's worth, it now seems to be working for me with Unitus Community Credit Union--thanks!

  26. System closed this discussion on 31 Mar, 2015 03:31 PM.

Comments are currently closed for this discussion. You can start a new one.

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

Recent Discussions

17 Jun, 2024 10:10 PM
17 Jun, 2024 09:48 PM
17 Jun, 2024 09:37 PM
17 Jun, 2024 07:29 PM
17 Jun, 2024 07:00 PM