GNOME Bugzilla – Bug 98963
OFX Importer: matching account cannot be changed later
Last modified: 2018-06-29 20:21:08 UTC
Package: GnuCash Severity: normal Version: 1.7.3 Synopsis: RFE: Add clear flag for OFX account transaction matcher Bugzilla-Product: GnuCash Bugzilla-Component: Import Description: When you first import OFX data into GnuCash is asks you which account the import is for. This is saved to the account's kvp. There should be a checkbox or something in the Edit account dialog to clear this in case someone chooses the wrong account when they do an import. ------- Bug moved to this database by unknown@bugzilla.gnome.org 2002-11-18 23:07 ------- Reassigning to the default owner of the component, chris@wilddev.net.
Changed title to state the problem clearer. Raised severity since this is quite a bummer for users.
OFX account mappings are unique and should not change over time, your checking account at bank X will stay your checking account at bank X. If your transit number changes, the ofx module won't find the matching account and will give you the chance to reassign. Puting a global option in the account editor for editing online id's is premature. (That may no longuer be the case once we use the generic import infrastructure for QIF). At most, I would currently see a button "Remove all online_id associations", but I wonder where to plug it in the interface.
Here are the two workaround until this is fixed... > I must have messed up my accounts! > When I import a ofx-file the account from which the transaction comes from > is automaticaly selected, right? The very first time a new account appears > in an ofx-file a window pops up and asks for selecting an existing account. > But how can I change this reference later on? It looks like I've made a > mistake at that time. Now it put the transactions on the wrong account! You can't (currently). The simplest way to fix it involves editing your data file directly: With a text editor, open your data file, and search for the string "online_id". You will find constructs like this one: <slot> <slot:key>online_id</slot:key> <slot:value type="string">7000001000023421 0023421 815-30480-00XXXXX-EOP</slot:value> </slot> One of them is the account you are trying to import. Remove these4 lines once you find it. Next time you import, you will get asked which gnucash account you want to use fot that ofx account. If you don't want to edit your datafile, you can import some other ofx file (like one of the sample files distributed with libofx). Each time you are asked which gnucash account to use for account number whatever, select the account that you mistakenly selected before. Once you see the list of transactions, hit cancel. Then try to reimport your original ofx file, you should be able to select the right account. Off course, backup your file before you proceed...
sorry, but is this bug still open? I'm experiencing the same problem on version 2.2.6... Any different workaround for it?
I also have a similar problem, but it relates to this comment: (https://lists.gnucash.org/pipermail/gnucash-devel/2009-July/025753.html) about importing investment accounts. I have a multicurrency investment account. When importing the OFX with a dividend transaction and I make a mistake and select an income account with the wrong currency, then the transaction values will come up blank in the register. (See also bug https://bugzilla.gnome.org/show_bug.cgi?id=577032) This error is then 'remembered' for future transactions. It would be very practical to be able to edit this account 'association' within the user interface to correct such errors.
The second method worked for me. Thanks! I went to libofx.sourceforge.net and downloaded a sample OFX file (.xml) and it worked perfectly. I never could find the "online_id" in, what I presume was, my data file. It was a binary file. I'm running Windows 7 and GC 2.2.9 (In reply to comment #3) > Here are the two workaround until this is fixed... > > > I must have messed up my accounts! > > When I import a ofx-file the account from which the transaction > comes from > > is automaticaly selected, right? The very first time a new account > appears > > in an ofx-file a window pops up and asks for selecting an existing > account. > > But how can I change this reference later on? It looks like I've made a > > mistake at that time. Now it put the transactions on the wrong account! > > You can't (currently). The simplest way to fix it involves editing > your data file directly: > > With a text editor, open your data file, and search for the string > "online_id". You will find constructs like this one: > <slot> > <slot:key>online_id</slot:key> > <slot:value type="string">7000001000023421 0023421 > 815-30480-00XXXXX-EOP</slot:value> > </slot> > One of them is the account you are trying to import. Remove these4 > lines once you find it. Next time you import, you will get asked > which gnucash account you want to use fot that ofx account. > [THE FOLLOWING WORKED FOR ME] > If you don't want to edit your datafile, you can import some other ofx > file (like one of the sample files distributed with libofx). Each > time you are asked which gnucash account to use for account number > whatever, select the account that you mistakenly selected before. > Once you see the list of transactions, hit cancel. Then try to > reimport your original ofx file, you should be able to select the > right account. > > Off course, backup your file before you proceed...
(In reply to comment #2) > OFX account mappings are unique and should not change over time, your > checking account at bank X will stay your checking account at bank X. > If your transit number changes, the ofx module won't find the > matching account and will give you the chance to reassign. Puting a > global option in the account editor for editing online id's is > premature. (That may no longuer be the case once we use the generic > import infrastructure for QIF). At most, I would currently see a > button "Remove all online_id associations", but I wonder where to plug > it in the interface. HI. My OFX and my bank statement for my credit card brings me transactions on different currencies. How should I deal with it so? As far as I know, I should use different accounts for different currencies. Doing this, how can I import my OFX on both accounts? I already compiled a GIT version on Ubuntu today and I'm willing to work on the code. I think this is related to https://bugzilla.gnome.org/show_bug.cgi?id=385366 as well.
Unless credit card work very differently where you live than in Canada, the transactions on your credit card are all in your local currency (at whatever exchange rate your card applied at the time of the transaction. For my cards the amoun in the foreign currency is in the transaction description, not in the actual data). The ofx file only represents on side of the transaction (one split). In your case, since it's a credit card, it's the side of the passive account representing your credit card. The transaction matcher allows you to create the other side if the transaction doesn't already exist. Having accounts in different currencies make sense only when having splits across them are indeed in different currencies. I'd be very surprised if that's your case. If credit card work like they do in Canada, all acconts involved should be in your local currency. You pay back your credit card in your local currency. For your expense account, you are normally interested in what it really cost you, so the amount AFTER conversion by your credit card. So once again in your local currency.
How can I send my OFX to you ? I don't want to change anything on it in the process ( to cover data ). I can send you 2 example OFX and PDF from credit card. Maybe you would get a better idea about it. I have some reasons to register both values. But I can accept suggestions.
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=98963. Please continue processing the bug there and please update any external references or bookmarks.