[GNC] gnucash-user Digest, Vol 231, Issue 55
Eric Hammond
eric at jehammond.net
Tue Jun 21 21:21:31 EDT 2022
Thank you David, Derek and Maf,
That works good enough, since I don't expect to need it much.
Maf, I am interested in what other situations this is needed.
There were no intended graphics (or?) attached. It may be my Outlook adding a background
Thanks again,
Eric
-----Original Message-----
From: gnucash-user <gnucash-user-bounces+eric=jehammond.net at gnucash.org> On Behalf Of gnucash-user-request at gnucash.org
Sent: Tuesday, June 21, 2022 5:13 PM
To: gnucash-user at gnucash.org
Subject: gnucash-user Digest, Vol 231, Issue 55
Send gnucash-user mailing list submissions to
gnucash-user at gnucash.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-request at gnucash.org
You can reach the person managing the list at
gnucash-user-owner at gnucash.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..."
Today's Topics:
1. Stock and Stock Prices (Gyle McCollam)
2. Thank you for your courtesy (Jim DeLaHunt)
3. Help (Eric Hammond)
4. Re: Thank you for your courtesy (Chris Graves)
5. Re: Help (Derek Atkins)
6. Re: Help (Maf. King)
7. Re: Help (davidcousens49 at gmail.com)
8. Re: Help (Derek Atkins)
9. Re: Help (davidcousens49 at gmail.com)
----------------------------------------------------------------------
Message: 1
Date: Tue, 21 Jun 2022 19:08:23 +0000
From: Gyle McCollam <gmccollam at live.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] Stock and Stock Prices
Message-ID:
<BLAPR06MB68027DE4D3C125A6FCE41CEECAB39 at BLAPR06MB6802.namprd06.prod.outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
My statements for stocks show shares and prices per share to 5 decimal places. In GnuCash "Tools/Price Database" it shows the per share price to 5 decimal places as well. However, in the register it shows the shares and balance to 5 decimal places as well, but it only shows the price to 4 decimal places. I can't find how to change this anywhere. I would like it to show the price in the register to the same 5 decimal places it has it recorded to in the price database. Any help would be appreciated.
Thank You,
Gyle McCollam
Gyle McCollam
gmccollam at live.com<mailto:gmccollam at gyleshomes.com> email
------------------------------
Message: 2
Date: Tue, 21 Jun 2022 12:35:30 -0700
From: Jim DeLaHunt <list+gnucash at jdlh.com>
To: gnucash-user at gnucash.org
Subject: [GNC] Thank you for your courtesy
Message-ID: <03a1e981-8eb3-caa4-60f0-a5c565564082 at jdlh.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Liz, David T, Gyle, and D:
(but really everyone contributes)
Thank you for your courtesy.? Liz, thank you for your work as list moderator, and specifically for stepping in when some recent language was not acceptable here. The others of you, thank you for apologising, rather than lashing out. The result is a more pleasant and more productive email list and community.
I am subscribed to users' mailing lists for other projects, where this sort of courtesy is often lacking. Nasty comments are more common. Some participants are repeatedly nasty. When someone points out that they are violating the community's code of conduct, they do not apologise, and they lash out with more nastiness. It is awful.
And that is one of the reasons why I spend more effort participating here rather than there. Thank you.
Best regards,
??? ?Jim DeLaHunt
------------------------------
Message: 3
Date: Tue, 21 Jun 2022 19:43:14 +0000
From: Eric Hammond <eric at jehammond.net>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] Help
Message-ID:
<BYAPR19MB25175DF3D5F2B788E2007FF2D5B39 at BYAPR19MB2517.namprd19.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
I was not paid by a client, and have 'written it off', but how do I book it in GnuCash?
Standard business practice is to post it in to an expense account such as 'Bad Debt' or 'Uncollectable'.
I have created the account 'Expenses:Bad Debt' but GnuCash does not allow me to select it, apparently only accepting an asset account.
Thank you for the help,
Eric
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4863 bytes
Desc: image001.jpg
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220621/a6dc5ebf/attachment-0001.jpg>
------------------------------
Message: 4
Date: Tue, 21 Jun 2022 13:15:09 -0700
From: Chris Graves <mohavebaked at gmail.com>
To: Jim DeLaHunt <list+gnucash at jdlh.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Thank you for your courtesy
Message-ID:
<CAM-ahxkKSyTugp4pOnpwTjWTLU+YSr618PO1-D++Z4T4wCvT5w at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
+1
On Tue, Jun 21, 2022 at 12:36 PM Jim DeLaHunt <list+gnucash at jdlh.com> wrote:
> Liz, David T, Gyle, and D:
> (but really everyone contributes)
>
> Thank you for your courtesy. Liz, thank you for your work as list
> moderator, and specifically for stepping in when some recent language
> was not acceptable here. The others of you, thank you for apologising,
> rather than lashing out. The result is a more pleasant and more
> productive email list and community.
>
> I am subscribed to users' mailing lists for other projects, where this
> sort of courtesy is often lacking. Nasty comments are more common.
> Some participants are repeatedly nasty. When someone points out that
> they are violating the community's code of conduct, they do not
> apologise, and they lash out with more nastiness. It is awful.
>
> And that is one of the reasons why I spend more effort participating
> here rather than there. Thank you.
>
> Best regards,
> ?Jim DeLaHunt
>
>
> _______________________________________________
> 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.
>
------------------------------
Message: 5
Date: Tue, 21 Jun 2022 16:35:29 -0400
From: "Derek Atkins" <derek at ihtfp.com>
To: "Eric Hammond" <eric at jehammond.net>
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Help
Message-ID:
<d1cebb54f6e0466304bd5201636dbd2e.squirrel at mail2.ihtfp.org>
Content-Type: text/plain;charset=utf-8
Hi,
On Tue, June 21, 2022 3:43 pm, Eric Hammond wrote:
>
> I was not paid by a client, and have 'written it off', but how do I
> book it in GnuCash?
> Standard business practice is to post it in to an expense account such
> as 'Bad Debt' or 'Uncollectable'.
> I have created the account 'Expenses:Bad Debt' but GnuCash does not
> allow me to select it, apparently only accepting an asset account.
The way I have done it myself (as the original author of the biz features) was to process the payment as if I was paid, but then change the transaction from Asset:Bank to Expense:WriteOff. So long as you don't change the *amount* of the payment (or other numerical values) then this won't break or affect anything in the internal references.
Hope this helps!
> Thank you for the help,
>
> Eric
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
PS: I'm sorry your client didn't pay you.
--
Derek Atkins 617-623-3745
derek at ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
------------------------------
Message: 6
Date: Tue, 21 Jun 2022 22:37:54 +0100
From: "Maf. King" <maf at chilwell.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Help
Message-ID: <4719544.GXAFRqVoOG at janus>
Content-Type: text/plain; charset="us-ascii"
+1 for Derek's method. I've done the same in the past for a variety of
reasons.
Hth,
Maf.
On Tuesday, 21 June 2022 21:35:29 BST Derek Atkins wrote:
> Hi,
>
> On Tue, June 21, 2022 3:43 pm, Eric Hammond wrote:
> > I was not paid by a client, and have 'written it off', but how do I book
> > it in GnuCash?
> > Standard business practice is to post it in to an expense account such as
> > 'Bad Debt' or 'Uncollectable'.
> > I have created the account 'Expenses:Bad Debt' but GnuCash does not allow
> > me to select it, apparently only accepting an asset account.
>
> The way I have done it myself (as the original author of the biz features)
> was to process the payment as if I was paid, but then change the
> transaction from Asset:Bank to Expense:WriteOff. So long as you don't
> change the *amount* of the payment (or other numerical values) then this
> won't break or affect anything in the internal references.
>
> Hope this helps!
>
> > Thank you for the help,
> >
> > Eric
> >
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> PS: I'm sorry your client didn't pay you.
------------------------------
Message: 7
Date: Wed, 22 Jun 2022 09:20:18 +1000
From: davidcousens49 at gmail.com
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Help
Message-ID: <eec7c63b0ea378bb5d614059ab50af67c30b1944.camel at gmail.com>
Content-Type: text/plain; charset="UTF-8"
Eric,
The image you attached did not appear to contain anything. Presumably you raised
an invoice when you billed the client which would have created an entry debiting
Accounts Receivable and crediting the appropriate income account.
To record the bad debt you would create a transaction which credited Accounts
Receivable and debited Expense:Bad Debts. This will cancel out the amount
credited to Income in the original invoice. I had no difficulty creating such an
entry in V4.10 with a test account setup for the business features. There was no
limitation on the account selection when I created the transaction in the
Accounts Receivable register.
The Help manual
https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html has a
description of how to do this using the process payment process which does have
a restriction on processing the payment to an expense account. The key is to
select an asset account (e.g. cheque account) when creating the transaction in
Process payment and then after the transaction is created change the account
from the asset account to the Expense:Bad Debt account. It is only the process
payment procedure which has a restriction on the type of account you can select
for a payment and there is no way that GnuCash could internally differentiate
between a payment to an Bad Debts expense account and any other expense account
as there isn't a specific account type for bad debts.
David Cousens
On Tue, 2022-06-21 at 19:43 +0000, Eric Hammond wrote:
> I was not paid by a client, and have 'written it off', but how do I book it in
> GnuCash?
> Standard business practice is to post it in to an expense account such as 'Bad
> Debt' or 'Uncollectable'.
> I have created the account 'Expenses:Bad Debt' but GnuCash does not allow me
> to select it, apparently only accepting an asset account.
>
> Thank you for the help,
>
> Eric
>
>
> _______________________________________________
> 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.
------------------------------
Message: 8
Date: Tue, 21 Jun 2022 19:41:37 -0400
From: "Derek Atkins" <derek at ihtfp.com>
To: davidcousens49 at gmail.com
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Help
Message-ID:
<74e7596fbd3c20cabf584b0b9bdc494f.squirrel at mail2.ihtfp.org>
Content-Type: text/plain;charset=utf-8
David,
On Tue, June 21, 2022 7:20 pm, davidcousens49 at gmail.com wrote:
> Eric,
>
[snip]
> To record the bad debt you would create a transaction which credited
> Accounts
> Receivable and debited Expense:Bad Debts. This will cancel out the amount
> credited to Income in the original invoice. I had no difficulty creating
> such an
> entry in V4.10 with a test account setup for the business features. There
> was no
> limitation on the account selection when I created the transaction in the
> Accounts Receivable register.
Just creating the transaction directly is not sufficient -- you still have
to map it to the Customer to "pay" the invoice.
> The Help manual
> https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html has
> a
> description of how to do this using the process payment process which does
> have
> a restriction on processing the payment to an expense account. The key is
> to
> select an asset account (e.g. cheque account) when creating the
> transaction in
> Process payment and then after the transaction is created change the
> account
> from the asset account to the Expense:Bad Debt account. It is only the
> process
> payment procedure which has a restriction on the type of account you can
> select
> for a payment and there is no way that GnuCash could internally
> differentiate
> between a payment to an Bad Debts expense account and any other expense
> account
> as there isn't a specific account type for bad debts.
Yes, which is the process I pointed out several hours ago. :)
> David Cousens
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins 617-623-3745
derek at ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
------------------------------
Message: 9
Date: Wed, 22 Jun 2022 10:12:35 +1000
From: davidcousens49 at gmail.com
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Help
Message-ID: <45338939b263a49362e17af243cd9e2f0f2e6ade.camel at gmail.com>
Content-Type: text/plain; charset="UTF-8"
Apologies Derek,
I hadn't seen you post before putting up my own reply. I tend to go through my
emails serially. I'll remember to switch the grouping by threads on in my
client.
David
On Tue, 2022-06-21 at 19:41 -0400, Derek Atkins wrote:
> David,
>
> On Tue, June 21, 2022 7:20 pm, davidcousens49 at gmail.com wrote:
> > Eric,
> >
> [snip]
> > To record the bad debt you would create a transaction which credited
> > Accounts
> > Receivable and debited Expense:Bad Debts. This will cancel out the amount
> > credited to Income in the original invoice. I had no difficulty creating
> > such an
> > entry in V4.10 with a test account setup for the business features. There
> > was no
> > limitation on the account selection when I created the transaction in the
> > Accounts Receivable register.
>
> Just creating the transaction directly is not sufficient -- you still have
> to map it to the Customer to "pay" the invoice.
>
> > The Help manual
> > https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html has
> > a
> > description of how to do this using the process payment process which does
> > have
> > a restriction on processing the payment to an expense account. The key is
> > to
> > select an asset account (e.g. cheque account) when creating the
> > transaction in
> > Process payment and then after the transaction is created change the
> > account
> > from the asset account to the Expense:Bad Debt account. It is only the
> > process
> > payment procedure which has a restriction on the type of account you can
> > select
> > for a payment and there is no way that GnuCash could internally
> > differentiate
> > between a payment to an Bad Debts expense account and any other expense
> > account
> > as there isn't a specific account type for bad debts.
>
> Yes, which is the process I pointed out several hours ago. :)
>
> > David Cousens
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
------------------------------
Subject: Digest Footer
_______________________________________________
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.
------------------------------
End of gnucash-user Digest, Vol 231, Issue 55
*********************************************
More information about the gnucash-user
mailing list