[GNC] Transactions imported from the file assigned to wrong account

[John Ralls]

Yes, that does sound like a bug. Please file a bug report at https://bugs.gnucash.org. You can easily cite this thread with https://code.gnucash.org/pipermail/gnucash-user/2021-June/096929.html

Regards,
John Ralls


> On Jun 22, 2021, at 8:51 AM, Aleksandar Kocic <akocic11 at gmail.com> wrote:
> 
> While removing the account works, it seems like a bug.
> 
> When I remove an account from Tools -> Import Map editor -> Online tab, I get asked the next time which account I want to use when importing the file. However, the Import Map Editor doesn't know how to process the file and extract the account id (the "Match String"). Hence, the "Match String" is left empty, and the next time I need to import a file, from the same bank but a different account, the Import Map Editor picks up the existing account, no question asked.
> 
> As I pointed out before, it is a QFX file, and the line with the account id looks like this:
> <CCSTMTRS><CURDEF>USD<CCACCTFROM><ACCTID>1234567890<ACCTTYPE>CREDITLINE</CCACCTFROM>
> 
> Regards,
> Aleksandar
> 
> 
> 
> On Mon, Jun 21, 2021 at 8:10 PM Aleksandar Kocic <akocic11 at gmail.com> wrote:
> Thanks John and David,
> 
> The Import Map Editor helped. I removed the account in question, which btw didn't have assigned the id, and it worked. I was asked to assign the account when trying to import the file.  
> 
> On Mon, Jun 21, 2021 at 8:08 PM John Ralls <jralls at ceridwen.us> wrote:
> David Carlson pointed you halfway: Open Tools>Import Map Editor.
> 
> The other half is to select the radio button "online" on the top of the dialog. That should display the online-id to GnuCash account associations and enable you to delete any that are incorrect. If there's only one then perhaps GnuCash isn't picking up the right number; compare the online id with your import file to see wha it's using.
> 
> Regards,
> John Ralls
> 
> 
> > On Jun 21, 2021, at 4:56 PM, Aleksandar Kocic <akocic11 at gmail.com> wrote:
> > 
> > It is QFX.
> > 
> > I understand the process; however, it doesn't work. All the files are
> > assigned to the same account with no questions asked.
> > 
> > Is there a way to remove this association and start fresh?
> > 
> > On Mon., Jun. 21, 2021, 6:06 p.m. Jim DeLaHunt, <list+gnucash at jdlh.com>
> > wrote:
> > 
> >> Aleksandar:
> >> 
> >> Which file format are you importing?  The UI and procedure are slightly
> >> different for each one. I am most familiar with OFX file import, and
> >> secondarily with CSV file import.
> >> 
> >> At the beginning of the import process, there is a step when GnuCash has
> >> you designate which GnuCash account should receive the transactions you
> >> are importing. For OFX format files, GnuCash can then remember a
> >> correspondence between the account number in the OFX file and the
> >> GnuCash account which receives the transaction, and it doesn't need to
> >> ask you the next time that you import.
> >> 
> >> Have you read through the GnuCash Guide documentation about file import?
> >> <
> >> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-ofx
> >>> 
> >> 
> >> Best regards,
> >> 
> >>     —Jim DeLaHunt
> >> 
> >> On 2021-06-21 13:17, Aleksandar Kocic wrote:
> >>> I download the file from the bank's site and manually import it.
> >>> 
> >>> I can see the account number in the file. However, for whatever reason,
> >> the
> >>> application chooses another account and it seems that cannot be changed.
> >>> 
> >>> 
> >>> On Mon., Jun. 21, 2021, 3:55 p.m. John Ralls, <jralls at ceridwen.us>
> >> wrote:
> >>> 
> >>>> 
> >>>>> On Jun 21, 2021, at 12:08 PM, Aleksandar Kocic <akocic11 at gmail.com>
> >>>> wrote:
> >>>>> Hi there,
> >>>>> 
> >>>>> I am trying to import transactions downloaded from the bank. However,
> >>>> since
> >>>>> I have multiple accounts with the same institution, the transactions
> >> are
> >>>>> assigned to an already existing account.
> >>>>> 
> >>>>> How do I select the account I want to use for importing transactions?
> >>>> How are you doing the import and doesn't the bank include the bank
> >> account
> >>>> number?
> >>>> 
> >>>> Regards,
> >>>> John Ralls
> >>>> 
> >>>> 
> >>> _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>> 
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >> 
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>