[GNC] Newbie Q: match Description to Transfer

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Newbie Q: match Description to Transfer

Bitmancer
Just starting out to use GnuCash. Imports fine from my bank to my Checking
account.
Now I have to make sense of it all!

In the Checking ledger, there are many different creditors. For example,
"Kroger" in the Description field. How can I label all "Kroger" entries with
"Expenses:Groceries" in the Transfer column? If I can make this happen, I
can do all my repetitive transactions and catch up on 8 months of data
faster.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

David Carlson-4
Welcome to GnuCash and to the GnuCash-User Maillist.

GnuCash is set by default to "remember" the transfer account assignment and
to attempt to make the same assignment to similar looking transactions in
future imports.  It uses a process called Bayesian Matching, which is not
perfect, but it usually makes pretty good guesses after a training process.

When you import transactions there is a step where you assign a "transfer"
account to each transaction or, after the first time, you approve GnuCash's
guess or override it with your correct information.  If you do not make
corrections in that step, GnuCash cannot "learn" the correct assignments,
and it may even make more "misteaks" later.

David Carlson

On Tue, Sep 3, 2019 at 5:24 PM Bitmancer <[hidden email]> wrote:

> Just starting out to use GnuCash. Imports fine from my bank to my Checking
> account.
> Now I have to make sense of it all!
>
> In the Checking ledger, there are many different creditors. For example,
> "Kroger" in the Description field. How can I label all "Kroger" entries
> with
> "Expenses:Groceries" in the Transfer column? If I can make this happen, I
> can do all my repetitive transactions and catch up on 8 months of data
> faster.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Greg Feneis
Perhaps, before importing, add a "Groceries" sub account to your expenses
account. Then, instead of importing the entire checking account from your
bank, just import a month's worth of records or so. In the matcher step,
assign transfer accounts accordingly. Then import the remaining records for
that checking account from your bank.  This lets you teach GnuCash how to
assign, at first, then on the second import, GnuCash does most of the work
on the majority of the records.

Kind regards, Greg Feneis
(Pixel 3)


On Tue, Sep 3, 2019, 18:20 David Carlson <[hidden email]>
wrote:

> Welcome to GnuCash and to the GnuCash-User Maillist.
>
> GnuCash is set by default to "remember" the transfer account assignment and
> to attempt to make the same assignment to similar looking transactions in
> future imports.  It uses a process called Bayesian Matching, which is not
> perfect, but it usually makes pretty good guesses after a training process.
>
> When you import transactions there is a step where you assign a "transfer"
> account to each transaction or, after the first time, you approve GnuCash's
> guess or override it with your correct information.  If you do not make
> corrections in that step, GnuCash cannot "learn" the correct assignments,
> and it may even make more "misteaks" later.
>
> David Carlson
>
> On Tue, Sep 3, 2019 at 5:24 PM Bitmancer <[hidden email]>
> wrote:
>
> > Just starting out to use GnuCash. Imports fine from my bank to my
> Checking
> > account.
> > Now I have to make sense of it all!
> >
> > In the Checking ledger, there are many different creditors. For example,
> > "Kroger" in the Description field. How can I label all "Kroger" entries
> > with
> > "Expenses:Groceries" in the Transfer column? If I can make this happen, I
> > can do all my repetitive transactions and catch up on 8 months of data
> > faster.
> >
> >
> >
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > _______________________________________________
> > gnucash-user mailing list
> > [hidden email]
> > 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Bitmancer
I get it. I have to create a training session of sorts. January ought to do
it.
I will try that tomorrow. Thanks to both of you, David Carlson and Greg
Feneis.

On Tue, Sep 3, 2019 at 8:43 PM Greg Feneis <[hidden email]> wrote:

> Perhaps, before importing, add a "Groceries" sub account to your expenses
> account. Then, instead of importing the entire checking account from your
> bank, just import a month's worth of records or so. In the matcher step,
> assign transfer accounts accordingly. Then import the remaining records for
> that checking account from your bank.  This lets you teach GnuCash how to
> assign, at first, then on the second import, GnuCash does most of the work
> on the majority of the records.
>
> Kind regards, Greg Feneis
> (Pixel 3)
>
>
> On Tue, Sep 3, 2019, 18:20 David Carlson <[hidden email]>
> wrote:
>
> > Welcome to GnuCash and to the GnuCash-User Maillist.
> >
> > GnuCash is set by default to "remember" the transfer account assignment
> and
> > to attempt to make the same assignment to similar looking transactions in
> > future imports.  It uses a process called Bayesian Matching, which is not
> > perfect, but it usually makes pretty good guesses after a training
> process.
> >
> > When you import transactions there is a step where you assign a
> "transfer"
> > account to each transaction or, after the first time, you approve
> GnuCash's
> > guess or override it with your correct information.  If you do not make
> > corrections in that step, GnuCash cannot "learn" the correct assignments,
> > and it may even make more "misteaks" later.
> >
> > David Carlson
> >
> > On Tue, Sep 3, 2019 at 5:24 PM Bitmancer <[hidden email]>
> > wrote:
> >
> > > Just starting out to use GnuCash. Imports fine from my bank to my
> > Checking
> > > account.
> > > Now I have to make sense of it all!
> > >
> > > In the Checking ledger, there are many different creditors. For
> example,
> > > "Kroger" in the Description field. How can I label all "Kroger" entries
> > > with
> > > "Expenses:Groceries" in the Transfer column? If I can make this
> happen, I
> > > can do all my repetitive transactions and catch up on 8 months of data
> > > faster.
> > >
> > >
> > >
> > > --
> > > Sent from:
> > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > > _______________________________________________
> > > gnucash-user mailing list
> > > [hidden email]
> > > 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
> > [hidden email]
> > 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
> [hidden email]
> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Bitmancer
That did the trick. I split everything by month!

Then I learned that by DOUBLE CLICKING on an account, I could change it from
UNRECONCILED to the correct Expense.
Nowhere in the online docs that I read does it say to DOUBLE CLICK. I would
recommend that we alter the docs to fix this!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Liz
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Liz
On Sat, 7 Sep 2019 16:53:12 -0500 (CDT)
Bitmancer <[hidden email]> wrote:

> That did the trick. I split everything by month!
>
> Then I learned that by DOUBLE CLICKING on an account, I could change
> it from
> UNRECONCILED
"Imbalanced-XXX" where XXX is a currency
> to the correct Expense.
> Nowhere in the online docs that I read does it say to DOUBLE CLICK. I
> would recommend that we alter the docs to fix this!

Double clicking is not a means I have ever used to alter the expense
account in an import. If it does also work then it would be important
to add it to the docs.

Just to fill in some details can you let us know your OS and version of
Gnucash?

Liz

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

David Cousens
Liz, Bitmancer

There are modifications to the import matcher docs in progress which have
the double clicking to modify a transfer account incorporated in them. The
behavior is the same as in the register for changing the account for a
split.  

AFAIK the behavior hasn't changed since the early v30-3.1.  I recently setup
multiple selection to allow assignment of a single transfer account to
multiple transactions. The double click either opens the transfer account
selection dialogue if a transaction is flagged for import or the match
picker dialog if it has been matched to an existing transaction for a single
transaction selection to allow examination of that match. A right click will
bring up the transfer account selection if multiple transactions are
selected. A single left click selects the transaction but doesn't perform
any specific action. Ctrl-Left click and Shift Left click can be used to
select multiple transactions as describedin the GTK treeview documentation
until the description makes into into the docs

I'm currently reworking a lot of the docs around importing. Slowly because I
have to experiment and explore a lot to make sure I have everything covered.
The changes won't make it into v3.7  and are probably currently being
targeted at v4.0.

David



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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 Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Bitmancer
In reply to this post by Liz
Liz,

I am using Arch Linux 5.2.10 with GnuCash 3.6 Build ID: 3.6+(2019-06-29)

Regards,
Bitmancer



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Bitmancer
In reply to this post by David Cousens
Thanks again, David.

I am using v3.6 from the Arch Linux distro.

I finally figured out *almost everything* that I complained about.

Now I would like to compare my expenses at two grocers.
My Expenses:Groceries ledger combines them financially.
<http://gnucash.1415818.n4.nabble.com/file/t378732/Screenshot_from_2019-09-08_17-17-34.png>
Can I do so from the Reports somehow? I cannot see how.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Newbie Q: match Description to Transfer

Adrien Monteleone-2
Run a transaction report on just that account. In Options > Sorting, set either the primary or secondary key to ‘Description’ and optionally show subtotals.

Regards,
Adrien

> On Sep 8, 2019 w37d251, at 5:19 PM, Bitmancer <[hidden email]> wrote:
>
> Thanks again, David.
>
> I am using v3.6 from the Arch Linux distro.
>
> I finally figured out *almost everything* that I complained about.
>
> Now I would like to compare my expenses at two grocers.
> My Expenses:Groceries ledger combines them financially.
> <http://gnucash.1415818.n4.nabble.com/file/t378732/Screenshot_from_2019-09-08_17-17-34.png>
> Can I do so from the Reports somehow? I cannot see how.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


_______________________________________________
gnucash-user mailing list
[hidden email]
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.