Re: [GNC] Combining Method in Chapter 11 and Standalone Security

[davidcousens49]

Bite,

The overall methodology is the same although the calculation of the unrealized
gain or loss is slightly different from the example - there is no external
valuation just recording a stock price. A new valuation of a painting is
essentially the same as a change in an updated stock price stock price etc. To
calculate the unrealized gain or loss over a period it is the number of
securities held over the period x the difference between prices at the start and
end date of the period over which you evaluate the unrealized gains and losses
gain/loss = N*(price at end - price at start). You can choose any period which
is convenient for your purpose so long as you have obtained a price at the end
date of the period - it need not be at a fixed interval. The intervals do have
to be contiguous, i.e. the end date of one period is the start date of the next.
If you sell at a particular point it becomes a realized gain/loss for the number
of securities involved in the sell and the unrealized gain goes to zero for the
securities you have sold, but not for any you continue to hold and a buy
increases the number of securities in the calculation going forward. 
You will need to maintain your cost base for CGT purposes. To do this you would
use sub-accounts of the main stock account (of type stock) one for the recording
of the initial purchase cost and susequent any buy/sell operation and the second
to record the unrealized gains/losses as in Ch11. You will need a corresponding
income account which is not included in your taxable income against which the
unrealized gains and losses are recorded as in the Ch11 example.  A gain will
debit your security's unrealized gains/Losses account and credit your
Income:Unrelaized Gains and Losses account by the amount of the gain while a
loss will reverse the debit and credit accounts. As David T pointed out the
major problem is keeping the cost base evaluation valid if you are buying and
selling only part (lots) of the holding in any given security but this is
independent of the unrealized gains/losses.

David Cousens

On Fri, 2022-06-24 at 08:48 +0800, Gao Bite wrote:
> GnuCash developers & Maintainers:
> 
> Hello! I have found several issues when I am reading your "Tutorial and 
> Concepts Guide". When I reads methods in the 11th chapter,I have found 
> that its example is based on non-fungible asset like painting. However, 
> what I am expecting is that records capital gains for fungible 
> securities (stock, bonds, ETF, etc.). How can I apply method in this 
> chapter to these type of assets?
> 
> Yours,
> 
> Bite Gao
> June 19th, 2022
> 
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] Combining Method in Chapter 11 and Standalone Security

[Michael or Penny Novack]

On 6/23/2022 8:48 PM, Gao Bite wrote:

GnuCash developers & Maintainers:

Hello! I have found several issues when I am reading your "Tutorial 
and Concepts Guide". When I reads methods in the 11th chapter,I have 
found that its example is based on non-fungible asset like painting. 
However, what I am expecting is that records capital gains for 
fungible securities (stock, bonds, ETF, etc.). How can I apply method 
in this chapter to these type of assets?


Yours,

Bite Gao
June 19th, 2022 


First of all, the gnucash tutorial is just that. Not supposed to be the 
equivalent of an accounting 101 text. It's just simplified basics. If 
you need more, seek out more.


But second, and perhaps more to the point for those wanting/needing BOTH 
an estimate of their true net worth and also books useful for reporting 
according to the rules of their jurisdiction is to recognize that 
gnucash can keep more than one set of books. Within reason, as many as 
you want.


Thus, if you are not taxed on unrealized gains, etc. you want one set of 
books on that basis. That is where you enter all your ordinary 
transactions and from which you extract the data for tax filings, etc. 
But if the reality is that you have investments perhaps specifically 
chosen because their increase in value is NOT currently taxable, you can 
have a second set of books for that purpose. Note I am NOT talking about 
double the effort. That second set of books might just have transactions 
reflecting annual adjustments for net realized gains/losses plus 
unrealized gains/losses plus any transactions involving the acquisition 
or disposition of such investments << or quarterly or whatever you want >>


Michael D Novack

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Combining Method in Chapter 11 and Standalone Security

[David T. via gnucash-user]

The concept of capital gains is the same, whether you're talking about a 
painting or a stock. The difference between your purchase and your sale price 
is the gain or loss. The only trick to consider for stocks is that different 
lots of stock purchases can have different cost bases, which obviously affects 
gain calculations. What are your specific issues? 

On June 23, 2022 8:48:09 PM EDT, Gao Bite  wrote:
>GnuCash developers & Maintainers:
>
>Hello! I have found several issues when I am reading your "Tutorial and 
>Concepts Guide". When I reads methods in the 11th chapter,I have found that 
>its example is based on non-fungible asset like painting. However, what I am 
>expecting is that records capital gains for fungible securities (stock, bonds, 
>ETF, etc.). How can I apply method in this chapter to these type of assets?
>
>Yours,
>
>Bite Gao
>June 19th, 2022
>
>___
>gnucash-user mailing list
>gnucash-user@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@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.

[GNC] Combining Method in Chapter 11 and Standalone Security

[Gao Bite]

GnuCash developers & Maintainers:

Hello! I have found several issues when I am reading your "Tutorial and 
Concepts Guide". When I reads methods in the 11th chapter,I have found 
that its example is based on non-fungible asset like painting. However, 
what I am expecting is that records capital gains for fungible 
securities (stock, bonds, ETF, etc.). How can I apply method in this 
chapter to these type of assets?


Yours,

Bite Gao
June 19th, 2022

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] gnucash-user Digest, Vol 231, Issue 55

[Maf. King]

Off the top of my head, I don't recall exactly.

I _think_, aside from bad debt,  I handled vendor discounts and credit notes 
in this way, before GC became more elegant in that way.

Hth,
Maf.


On Wednesday, 22 June 2022 02:21:31 BST Eric Hammond wrote:
> 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  On
> Behalf Of gnucash-user-requ...@gnucash.org Sent: Tuesday, June 21, 2022
> 5:13 PM
> To: gnucash-user@gnucash.org
> Subject: gnucash-user Digest, Vol 231, Issue 55
> 
> Send gnucash-user mailing list submissions to
>   gnucash-user@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-requ...@gnucash.org
> 
> You can reach the person managing the list at
>   gnucash-user-ow...@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 (davidcousen...@gmail.com)
>8. Re:  Help (Derek Atkins)
>9. Re:  Help (davidcousen...@gmail.com)
> 
> 
> --
> 
> Message: 1
> Date: Tue, 21 Jun 2022 19:08:23 +
> From: Gyle McCollam 
> To: "gnucash-user@gnucash.org" 
> Subject: [GNC] Stock and Stock Prices
> Message-ID:
>   
 .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
> 
> gmccol...@live.com   email
> 
> 
> --
> 
> Message: 2
> Date: Tue, 21 Jun 2022 12:35:30 -0700
> From: Jim DeLaHunt 
> To: gnucash-user@gnucash.org
> Subject: [GNC] Thank you for your courtesy
> Message-ID: <03a1e981-8eb3-caa4-60f0-a5c565564...@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 +
> From: Eric Hammond 
> To: "gnucash-user@gnucash.org" 
> Subject: [GNC] Help
> Message-ID:
>   
 .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:
>  ebf/attachment-0001.jpg>
> 
> --
> 
> Message: 4
> Date: Tue, 21 Jun 2022 13:15:09 -0700
> From: Chris Graves 
> To: Jim DeLaHunt 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Thank you for your courtesy
> Mes

Re: [GNC] Trail Balance Help

[Derek Atkins]

Hi,

On Thu, June 23, 2022 10:37 am, Jack Lockard wrote:
> I've been using GnuCash for over ten years now and just the other day ran
> a Trial Balance report for the first time. As you might imagine, it did
> not balance and was out of balance in excess of $100k. I started running
> reports year by year. 2011 and 2012 were in balance. 2013 was out of
> balance by $4303.1. I ran it with a date of 7/15/2013 and it was in
> balance. Ran it again with a date of 7/16/2013 and it was out of balance
> $4303,10. Next I ran a General Ledger report for 7/16/2013 for all
> accounts and there were only two transactions. One was $40.75 for a gas
> purchase (40.75 credit to checking and 40.75 debit to
> expenses:auto:gas&oil). The other was a rollover from an ESOP account to
> an IRA account in the amount of $6222.88. No match to $4303.10.
> There is an Unrealized Gain amount on the trial balance of $87,645.69. I
> ran an Advanced Portfolio report for the same date and it shows an
> Unrealized Gain of $84,389.45. Don't understand why they are different by
> $3,256.24 and it doesn't match the out of balance amount and would only
> make the out of balance amount larger.
> I have no clue how to find where the imbalance is coming from. Any
> suggestions on how to locate it?

My INITIAL guess is that the "difference" is due to a change in value in
the PriceDB, and the different reports are using a different exchange rate
than the transaction itself.

Generally an out-of-balance Trial Balance implies you did not account for
realized gains/losses.  So the IRA account transaction would be the reason
for that.  Perhaps you're missing $4303.10 of realized gain?

> Jack

> 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
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@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.

[GNC] Trail Balance Help

[Jack Lockard]

I've been using GnuCash for over ten years now and just the other day ran a 
Trial Balance report for the first time. As you might imagine, it did not 
balance and was out of balance in excess of $100k. I started running reports 
year by year. 2011 and 2012 were in balance. 2013 was out of balance by 
$4303.1. I ran it with a date of 7/15/2013 and it was in balance. Ran it again 
with a date of 7/16/2013 and it was out of balance $4303,10. Next I ran a 
General Ledger report for 7/16/2013 for all accounts and there were only two 
transactions. One was $40.75 for a gas purchase (40.75 credit to checking and 
40.75 debit to expenses:auto:gas&oil). The other was a rollover from an ESOP 
account to an IRA account in the amount of $6222.88. No match to $4303.10.
There is an Unrealized Gain amount on the trial balance of $87,645.69. I ran an 
Advanced Portfolio report for the same date and it shows an Unrealized Gain of 
$84,389.45. Don't understand why they are different by $3,256.24 and it doesn't 
match the out of balance amount and would only make the out of balance amount 
larger.
I have no clue how to find where the imbalance is coming from. Any suggestions 
on how to locate it?
Jack
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Questions on invoicing and invoice format

[Charles Vincent]

Adrien,
Thank you VERY much for your replies. I will definitely be less frustrated
not being able to figure something out which cannot be done (at this stage).
Good suggestion for q. no. 1.
Again, thanks.


Charles VINCENT
Membre fondateur et ancien président du Conseil d'Administration

Ecole Française de Battambang

+33 6 7082 0475 (Mobile & WhattsApp)
+855 12 635612 (Telegram)

www.ecolefrancaisedebattambang.org

On Wed, Jun 22, 2022, 20:34 Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> On 6/22/22 4:40 AM, Charles Vincent wrote:
> > 1. Is it possible to delete invoices?  As I was setting up invoices, I
> made
> > some mistakes so I now have invoice 1, invoice 2 and invoice 3 with
> > different print options for the same student but I cannot seem to find a
> > way to delete unnecessary invoices. Any option for that?
>
> No, you can't delete them.
>
> But you can re-assign them to someone else.
>
> When this happens, I usually edit the invoice# to be something like 'Use
> Next' and before starting an invoice, I'll do a Find for the 'Use Next'
> invoice#, then edit from there.
>
> > 2. How do I save a Fancy invoice configuration which will apply to all
> > clients?  Right now, the only way I have been able to do it is to save
> the
> > fancy configuration for client 1 but when I use the same configuration
> for
> > client 2, it comes out with the name of client 1 instead of client 2.
> > What I am asking is the process to save a Print Invoice configuration
> (or a
> > Report /Saved Report configurations) which can be used for many clients
> > without having to format each individual client.
>
> As far as I know, there is no way to specify a different default
> configuration. It would be a very useful enhancement. Unless you really
> need to, I'd avoid putting client info in the configuration. Keep it as
> general as possible.
>
>
> > 3.  What is the process to ensure that When I open and insert amounts in
> a
> > new invoice, what is the process to ensure that it automatically goes to
> > the right print invoice fancy format?  I cannot figure it out.
>
> It doesn't work automatically. You have to choose the stylesheet each
> time if you want to use one other than the default. (note, you *can*
> edit and save changes to the default) There is no way to change *which*
> stylesheet is the default. This too would be quite useful.
>
>
> Regards,
> Adrien
>
> ___
> gnucash-user mailing list
> gnucash-user@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@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.