Alois,
As Derek pointed out your screenshot showed that you have an older non-
Bayesian matching system selected. The Bayesian matching is much better
but it is a learning algorithm.
To enable Bayesian matching, select Edit->Preferences (Bearbeiten-
>Einstellungen)from the menu and select the Import tab in the
dialogue. Check the third checkbox down labelled "Use bayesian
matching" ("Bayesianisches Matching verwenden"). my translations into
German may not match the official translators.
The original non-Bayesian matcher which you are using is a relatively
crude process and I would not recommend using it in preference to the
Bayesian matcher. AFAIK it is the default matching algorithm which is
set when GnuCash is installed.
When you haven't imported any data previously GnuCash has no
information on which to base its decision making so it may frequently
make incorrect assignments. But it builds frequency tables of the
occurrence of words, amounts etc in the data fields of the imported
transactions. Once those tables start to build up and get data in them,
GnuCash will use them to assign an account based on the probability
tables of that data occurring in a transaction being imported and once
it is trained on the imported data it usually has a high rate of
success.
When I import my credit card and savings account data out of a couple
of hundred transactions a month I might have to manually assign 3-4
transactions, quite often because the vendor includes a number which is
meaningful to them in the description field which changes every month
rather than a fixed number.
This is why people have been recommending to initially import small
batches of data. The Bayesian frequency tables are added to in the last
step of the import process. If you don't complete an import then no
data is stored. If you import data with incorrect account assignments,
then yo train the Bayesian matcher to make incorrect assignments. With
small batches of data it is easier to make the corrections in the
import process.
Once you have the matching process working fairly well, then you can
increase the batch size and there will be fewer errors but it is
unlikely there will ever be no matching errors or incorrect decisions
on whether to import or not. There is no automatic import process
which will give you a zero error rate and it is important to manually
correct those errors in the import matching process itself at each
import and not to correct them later manually in the register as doing
that does not construct the frequency tables on which the matching
process relies. This matching process has a number of functions,
detecting duplicates, deciding whether to import all the data or just
the description data if an imported transaction matches an existing
transaction in GnuCash, assigning the account for the second entry
(split) of a transaction when that data does not exist in the import
file.
The import matcher does have the ability to select multiple
transactions using the CTRL key and assign a single transfer account to
the selection. This is mainly of use when importing transactions from a
bank in assigning the expense income accounts and may be less relevant
where you are importing data from another accounting system.
Where both accounts for a transaction are specified in the import file
Gnucash has to match an account name in the import file to an internal
account name the first time it encounters a particular name in the
import file. Once that match has been made it it will use the assigned
internal account each time that name occurs in the account fields of
the data being imported.
I assume you read the documentation on the import process? Chapter 6.16
covers importing transactions in various formats. It should be
available on line in both English and German.
The learning curve with GnuCash can be steep, particularly if you are
used to the foibles of other accounting software but it is worth the
initial effort and consequent frustration longer term.
David Cousens
On Tue, 2025-02-25 at 19:11 +0100, "alois müller" via gnucash-user
wrote:
> ONE last comment before I leave with great disappointment:
> under tools I can find the "Import-Zuordnungen" (see attached
> picture!)
> 90 % of them are based on the description field, dispite ALL my
> transaction are having both debit AND credit accounts!!
>
> This is distusting and will NEVER work...
>
> --- Ursprüngliche Nachricht ---
> Von: "Derek Atkins" <de...@ihtfp.com>
> Datum: 25.02.2025 17:01:22
> An: "alois müller" <m...@eclipso.at>
> Betreff: Re: [GNC] Import troubles
>
> If you don't like it, you're welcome to go use something else.
> We'll even give you double your money back what you paid for it!
>
> -derek
>
> On Tue, February 25, 2025 10:49 am, "alois müller" via gnucash-user
> wrote:
> > NO! Because there are thousands of transactions that Gnu cash
> > doesn't
>
> > import correct - dispite that all transaction have a debit and a
>
> > credit account!!
> > Even worse:
> >
> > You can't even select multiple transactions :-/
> > Gnu Cash sucks!!
> >
> > Von: Gyle McCollam <gmccol...@live.com>
> > Datum: 25.02.2025 14:58:19
> > An: flywire <flywi...@gmail.com>, "alois müller"
> <m...@eclipso.at>
> > Betreff: Re: [GNC] Import troubles
> >
> > When you check them as new, do you also assign the corresponding
>
> > debit/credit account which you need to do?
> >
> >
> >
> >
> >
> > Thank You,
> >
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > [1]gmccol...@live.com email
> >
> >
> >
> > _______________________________________________________________
>
> >
> > From: gnucash-user on behalf of "alois müller" via gnucash-user
>
> > Sent: Tuesday, February 25, 2025 5:49 AM
> > To: flywire
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Import troubles
> >
> > No, it will NOT recognize!
> > all red transaction which I check as "new" are imported
> to the
> > "Ausgleichskonto", which is useless.
> > All transactions look the same in my csv-file. But 10% are
> > not
>
> > recognized by the correct debit account!
> > This import routine is buggy!!
> > I give up - gnu cash sucks!!
> > Von: flywire
> > Datum: 25.02.2025 00:35:53
> > An: alois müller
> > Betreff: Import troubles
> > I have over 30 000 transactions!
> > even IF it were just 2% it would be impossible to do
> > manually..
>
> > One match might cover 100's of transactions. Import your file in
> small
> > batches s
> > o the match will recognise transactions in future batches.
> > Regards
> >
> > __________________________________________________________________
>
> > Your E-Mail. Your Cloud. Your Office. [1]eclipso Mail Europe.
>
> > References
> > 1. [2]https://www.eclipso.at/
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> > __________________________________________________________________
>
> >
> > Your E-Mail. Your Cloud. Your Office. [4]eclipso Mail Europe.
> >
> > References
> >
> > 1. file:///tmp/gmccol...@gyleshomes.com
> > 2. https://www.eclipso.at/
> > 3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > 4. https://www.eclipso.at/
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > 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@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
