Import OFX Credit Card from Bank
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
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
31 Posted by Ben Spencer on 01 Sep, 2010 12:27 AM
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
32 Posted by henjenliu on 10 Oct, 2010 12:12 PM
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.
33 Posted by Alex on 04 Nov, 2010 02:16 AM
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
34 Posted by Lionel Freeman on 04 Nov, 2010 01:29 PM
Is the import OFX working now?
Lionel
On 4 November 2010 02:18, Alex <
[email blocked]<tender%[email blocked]>
> wrote:
35 Posted by Jessica Little on 07 Nov, 2010 08:02 PM
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
36 Posted by Alex on 30 Dec, 2010 04:34 PM
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
37 Posted by Jessica Little on 05 Jan, 2011 04:10 PM
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
38 Posted by bill on 27 Jan, 2011 03:41 AM
This seems to be taking an unusually long time to get out. We really need this soon.
Bill
39 Posted by Ben Spencer on 29 Jan, 2011 03:26 PM
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
40 Posted by Michael on 06 Feb, 2011 06:53 PM
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
41 Posted by bkeyport on 08 Feb, 2011 07:42 AM
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.
42 Posted by Jessica Little on 08 Feb, 2011 02:27 PM
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
43 Posted by bkeyport on 07 Mar, 2011 08:15 AM
so, it was a week, a month ago. Hmmm. What happened now?
44 Posted by Jessica Little on 07 Mar, 2011 06:41 PM
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
45 Posted by bkeyport on 08 Mar, 2011 04:32 AM
Build 777 is good for me, except for printing issues (mentioned elsewhere). All problems are fixed.
46 Posted by Peter Linley on 08 Mar, 2011 10:55 PM
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:
47 Posted by Jessica Little on 09 Mar, 2011 03:38 PM
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
48 Posted by Peter Linley on 09 Mar, 2011 05:17 PM
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:
49 Posted by Peter Linley on 10 Mar, 2011 03:33 AM
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:
50 Posted by Jessica Little on 12 Mar, 2011 04:55 PM
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
51 Posted by Peter Linley on 15 Mar, 2011 02:29 AM
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:
52 Posted by Jessica Little on 16 Mar, 2011 07:23 PM
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
53 Posted by Peter Linley on 18 Mar, 2011 10:09 PM
Tried it now, Friday, still not working.
Peter
On 16 March 2011 21:24, Jessica Little <
[email blocked]> wrote:
54 Posted by Jessica Little on 19 Mar, 2011 12:22 PM
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
55 Posted by randolph on 25 Dec, 2011 05:58 PM
For what it's worth, it now seems to be working for me with Unitus Community Credit Union--thanks!
System closed this discussion on 31 Mar, 2015 03:31 PM.