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

[David Cousens]

Aleksandar,

Have you looked at the account assignments that are stored in the account
mapping. If you open the Map editor (Tools->Import Map Editor) and open the
Online tab you will find the information GnuCash is using to map the accounts.
It is possible that in early import attempts the wrong mapping between the
accounts in the import file and the internal GnuCash files might have occurred.
If you find any incorrect account assignments there they can be deleted. Next
time you do an import you will be asked to assign the account information in the
import record to an internal GnuCash account for any matchings you have deleted.
This can appear a bit confusing since most of us will assign the same names our
bank uses to our accounts in GnuCash but it actually is separate information

David


  On Mon, 2021-06-21 at 18:00 -0400, Aleksandar Kocic wrote:
> Updated to the latest version, same issue:
> Version: 4.5
> Build ID: 4.5+(2021-03-27)
> 
> On Mon, Jun 21, 2021 at 4:55 PM Aleksandar Kocic <akocic11 at gmail.com> wrote:
> 
> > Version: 4.4
> > Build ID: 4.4+(2020-12-28)
> > 
> > Just to clarify that the files do have the account numbers and they are
> > different. Here is an obfuscated example:
> > 
> > <CCSTMTRS><CURDEF>CAD<CCACCTFROM><ACCTID>XXX<ACCTTYPE>CREDITLINE</CCACCTFROM
> > >
> > 
> > <CCSTMTRS><CURDEF>CAD<CCACCTFROM><ACCTID>YYY<ACCTTYPE>CREDITLINE</CCACCTFROM
> > >
> > 
> > 
> > 
> > On Mon, Jun 21, 2021 at 4:50 PM David Carlson <david.carlson.417 at gmail.com>
> > wrote:
> > 
> > > And what version of GnuCash are you running?  Newer releases have an
> > > easier way to fix the problem.
> > > 
> > > On Mon, Jun 21, 2021 at 3:29 PM Aleksandar Kocic <akocic11 at gmail.com>
> > > wrote:
> > > 
> > > > It is QFX.
> > > > 
> > > > On Mon, Jun 21, 2021 at 4:21 PM Derek Atkins <derek at ihtfp.com> wrote:
> > > > 
> > > > > Hi,
> > > > > 
> > > > > Are you downloading QIF?  OFX?  CSV?  Something else?
> > > > > 
> > > > > -derek
> > > > > 
> > > > > On Mon, June 21, 2021 4:17 pm, 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.
> > > > > > 
> > > > > 
> > > > > --
> > > > >        Derek Atkins                 617-623-3745
> > > > >        derek at ihtfp.com             www.ihtfp.com
> > > > >        Computer and Internet Security Consultant
> > > > > 
> > > > > 
> > > > _______________________________________________
> > > > 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.
> > > > 
> > > 
> > > --
> > > David Carlson
> > > 
> _______________________________________________
> 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.
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed