Re: [GNC] Direct Adjustment of Security's Price

[David Carlson]

GnuCash has tools described in Chapter 11 of the Guide as noted by David T
earlier.  It is probably possible to adapt one of the investment over time
reports to produce the information you need if you structure your accounts
well and then periodically download prices from the Internet using the
Finance::Quote module, but the details are beyond my personal knowledge.

On Sun, Jun 19, 2022 at 9:59 PM Gao Bite  wrote:

> Mr. D, Cousens:
>
> I am sorry that I did not state what I expected from the income
> recording well in the previous e-mail. I wish that you could read it
> carefully and give me advice accordingly.
>
> I purchase securities for speculation, which I anticipate their market
> price and the ability to resell these securities for that price. Every
> two weeks, I need to update the market price of my holding securities. I
> need to increase (decrease) the securities' asset value. What's more, I
> need to record changes in market value as an income. I need to be able
> to display the value of income over time so that I can have a better
> decision on investing.
>
> However, I have some issues in recording my investing process in your
> software. First of all, the built-in trading account generates gains and
> losses only on the current exchange rate, so it is hard to display the
> performance of the investment over time. While adjusting securities'
> value affects the total asset's value standalone, recording the
> investment income needs a corresponding asset account. This fact gives
> me two choices: either detach the asset value from the accounting
> equation or detach the securities' book value from their market value
> (as the method in the tutorial displays).
>
> I sincerely hope that there is a method to fix these incorrectnesses. I
> would greatly appreciate it if you help me find these methods.
>
>  Yours,
>
>  Bite Gao
> June 20th, 2022
>
> On 2022-06-20 6:41, davidcousen...@gmail.com wrote:
> > Bite
> >
> > The transaction to record this, if a profit or increase in value of the
> security
> > is to debit the security by the amount of the profit and to credit an
> income
> > account by the same amount. For a loss in value creidt the security
> account and
> > debit the income amount. The profit or loss is the product of the number
> of
> > securites held  and the difference in prices between the date at which
> you are
> > recording the unrealized gain/loss and the price at the time you have
> previously
> > recorded a gain or loss Ultimately this traces back to the initail
> purchase
> > price.
> >
> > You may find it useful to use a sub-account of the security (of the same
> type
> > account) totalling into the security account to record the unrealized
> gains and
> > losses so that you preserve the initial cost basis which you will likely
> need
> > for capital gains taxes in most jurisdiction. Unrealized gains and
> losses are
> > generally not taxable as income in most jurisdictions, so you would need
> an
> > Income account separate from any Income account structure which records
> income
> > for taxation purposes.
> >
> > David Cousens
> >
> > On Sun, 2022-06-19 at 21:56 +0800, Gao Bite wrote:
> >> GnuCash developers & Maintainers:
> >>
> >>   Hello! I would like to record the unrealized profit & loss from
> >> security investment directly into an income account. Could you please
> >> tell me whether I am possible to do as above, and if possible, how I can
> >> achieve this?
> >>
> >>   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.
> ___
> 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.
>


-- 
David Carlson
___

Re: [GNC] Direct Adjustment of Security's Price

[Gao Bite]

Mr. D, Cousens:

I am sorry that I did not state what I expected from the income 
recording well in the previous e-mail. I wish that you could read it 
carefully and give me advice accordingly.


I purchase securities for speculation, which I anticipate their market 
price and the ability to resell these securities for that price. Every 
two weeks, I need to update the market price of my holding securities. I 
need to increase (decrease) the securities' asset value. What's more, I 
need to record changes in market value as an income. I need to be able 
to display the value of income over time so that I can have a better 
decision on investing.


However, I have some issues in recording my investing process in your 
software. First of all, the built-in trading account generates gains and 
losses only on the current exchange rate, so it is hard to display the 
performance of the investment over time. While adjusting securities' 
value affects the total asset's value standalone, recording the 
investment income needs a corresponding asset account. This fact gives 
me two choices: either detach the asset value from the accounting 
equation or detach the securities' book value from their market value 
(as the method in the tutorial displays).


I sincerely hope that there is a method to fix these incorrectnesses. I 
would greatly appreciate it if you help me find these methods.


    Yours,

    Bite Gao
June 20th, 2022

On 2022-06-20 6:41, davidcousen...@gmail.com wrote:

Bite

The transaction to record this, if a profit or increase in value of the security
is to debit the security by the amount of the profit and to credit an income
account by the same amount. For a loss in value creidt the security account and
debit the income amount. The profit or loss is the product of the number of
securites held  and the difference in prices between the date at which you are
recording the unrealized gain/loss and the price at the time you have previously
recorded a gain or loss Ultimately this traces back to the initail purchase
price.

You may find it useful to use a sub-account of the security (of the same type
account) totalling into the security account to record the unrealized gains and
losses so that you preserve the initial cost basis which you will likely need
for capital gains taxes in most jurisdiction. Unrealized gains and losses are
generally not taxable as income in most jurisdictions, so you would need an
Income account separate from any Income account structure which records income
for taxation purposes.

David Cousens

On Sun, 2022-06-19 at 21:56 +0800, Gao Bite wrote:

GnuCash developers & Maintainers:

  Hello! I would like to record the unrealized profit & loss from
security investment directly into an income account. Could you please
tell me whether I am possible to do as above, and if possible, how I can
achieve this?

  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.

___
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] Transaction Imports

[Jon Schewe]

I'm trying to do a similar import and I'm finding that I can't convince
GnuCash to enter the other account. I'm using import transactions from
CSV.I have matched columns to Date, Description, Account, Price,
Deposit, Transfer Account.The "Account" column is the mutual fund
account.The "Transfer Account" column is the currency account.
When I start the import process all of my transactions need an account
to transfer from, despite specifying the Transfer Account. When I try
and select my currency account I'm told that it has the wrong
commodity.
I have another column for the currency amount, but I don't know what to
map that to in the importer.
I tried checkout out 
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
 but it doesn't seem to address this.Suggestions on where I'm going
wrong.
On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote:
> Further to this: you care about how much money something cost (the
> amount you have spent), and how much you got for it (the amount of
> shares you purchased). The first affects how much money you have in
> your bank account, the second affects how many shares show in your
> mutual fund.
> On April 11, 2022 8:16:06 PM EDT, Stu Perlman 
> wrote:
> > Thank for the heads up.
> > On Mon, Apr 11, 2022 at 3:03 PM D  wrote:
> > > Not going to go into great detail here, but you definitely DON'T
> > > want tohave gnucash calculate shares. Have it calculate price.On
> > > Apr 11, 2022, at 11:21, Stu Perlman  wrote:
> > > > Hello Everyone,
> > > > I am looking for some guidance on how to import a few hundred
> > > > transactionsfrom my 401(k) account.Unfortunately, the plan
> > > > administrator does not offer a good option forexporting the
> > > > transaction data but I am able to get what I need with
> > > > somebasic web scraping.
> > > > I have been experimenting with creating a multi-split CSV
> > > > import from thedata that I have captured.What I wanted to do
> > > > was a file layout such as:
> > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/2021
> > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index
> > > > Institutional
> > > > Fund,299.26,0.916289038,326.601/19/2021,Contribution,Cash,-
> > > > 299.26,,Vanguard Institutional Index Institutional
> > > > Fund,299.26,0.892008703,335.49
> > > > 
> > > > My wishful thinking was that I could put the number of shares
> > > > into the memocolumn for reference (but that the system would
> > > > auto-calculate that numberusing the provided Price and
> > > > transaction amount ("Deposit")).I hit a blocker on the second
> > > > to last step of the import wizard with themessage: "*The
> > > > account 'Vanguard Institutional Index Fund' has a
> > > > differentcommodity to the one required, 'US Dollar'. Please
> > > > choose a differentaccount.*"
> > > > So I'm wondering if there are other ways I can go about what
> > > > I'm trying toaccomplish?  I started with the CSV importer
> > > > because I figured it would bethe easiest record layout to
> > > > create but I'm not against using a differentformat if what I
> > > > want to accomplish can be done.
> > > > I have a backup plan which is that I will NOT do the multi-
> > > > split import andwill just select the Cash account for all rows
> > > > in the Import Previewscreen. I could pack the memo field with
> > > > the ticker symbol, price,quantity, and total debit and let it
> > > > all dump into the Imbalance-USDaccount. I would then have to
> > > > either manually fix them one by one orpossibly script it
> > > > out.  I have done this with success in the past butwould rather
> > > > just get it right at the data import step if that's in anyway
> > > > possible.
> > > > My thanks in advance for any advice offered.
> > > > - Stu--
> > > > gnucash-user mailing listgnucash-u...@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 
> listgnucash-u...@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.g

Re: [GNC] Direct Adjustment of Security's Price

[davidcousens49]

Bite

The transaction to record this, if a profit or increase in value of the security
is to debit the security by the amount of the profit and to credit an income
account by the same amount. For a loss in value creidt the security account and
debit the income amount. The profit or loss is the product of the number of
securites held  and the difference in prices between the date at which you are
recording the unrealized gain/loss and the price at the time you have previously
recorded a gain or loss Ultimately this traces back to the initail purchase
price.

You may find it useful to use a sub-account of the security (of the same type 
account) totalling into the security account to record the unrealized gains and
losses so that you preserve the initial cost basis which you will likely need
for capital gains taxes in most jurisdiction. Unrealized gains and losses are
generally not taxable as income in most jurisdictions, so you would need an
Income account separate from any Income account structure which records income
for taxation purposes.

David Cousens

On Sun, 2022-06-19 at 21:56 +0800, Gao Bite wrote:
> GnuCash developers & Maintainers:
> 
>  Hello! I would like to record the unrealized profit & loss from 
> security investment directly into an income account. Could you please 
> tell me whether I am possible to do as above, and if possible, how I can 
> achieve this?
> 
>  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] Bitcoin Lightning payments

[Michael or Penny Novack]

Obviously BTC

In general I think standards are good - especially internationally 
agreed ones. But according to the ISO website


https://www.iso.org/news/ref2466.html

ISO 4217 is never going to cover cryptocurrencies.  ISO are apparently 
looking at crypto.



No, I thought I explained why it COULDN'T be "BTC"

That choice would violate an existing ISO standard. Unless Bhutan 
adopted Bitcoin as a currency << hey, it might be easier/quicker to get 
Bhutan to do that then getting the ISO to agree. >> The first thing the 
ISO would need to do is settle on what first two characters would be "no 
state". There are lots cryptocurrencies so maybe want several character 
pairs for "no state"


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] rookie question Imbalance-USD

[David T. via gnucash-user]

You're welcome. You seem to have sent it with a mysterious subtext that is 
impossible to decipher. 

For the record, improperly-used terminology on this list has resulted in epic 
misunderstandings that confuse newcomers when they attempt to understand the 
complexities of both gnucash AND double entry bookkeeping. The terminology in 
this specific case is a prime example of this. If you were to go back and look 
at the list archives, you'd see involved discussions about the use and meaning 
of the terms "transaction"  "split" and "entry".

I made my comment from that perspective; your snarky comment just underscores 
for me the kind of person YOU are. Go stuff yourself. 

David T. 

On June 19, 2022 9:59:23 AM EDT, Gyle McCollam  wrote:
>Thank you for going back over my post with such a fine-tooth comb.  I don't 
>know how I could have made such an egregious error.  I will attempt to do 
>better in the future, but when I make an error like this again in the future, 
>and I'm sure I will, please bring it to my attention.  My sincerest apologies. 
> I do hope you forgive me.
>
>Thank you.
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>
>gmccol...@live.com   email
>
>
>From: David T. 
>Sent: Saturday, June 18, 2022 6:32 PM
>To: Gyle McCollam ; gnucash-user@gnucash.org 
>; David Carlson ; Kevin 
>T 
>Subject: RE: [GNC] rookie question Imbalance-USD
>
>The confusion arises when you use "entry" for both splits and transactions in 
>the same paragraph, as you did here.
>
>On June 18, 2022 4:57:57 PM EDT, Gyle McCollam  wrote:
>When I say entry, I refer to the entire transaction, but I get your point.
>
>
>
>Sent from Samsung Galaxy smartphone.
>
>
>
> Original message 
>From: "David T." 
>Date: 6/18/22 4:24 PM (GMT-05:00)
>To: gnucash-user@gnucash.org, Gyle McCollam , David 
>Carlson , Kevin T 
>Cc: gnucash-user@gnucash.org
>Subject: Re: [GNC] rookie question Imbalance-USD
>
>Gyle,
>
>Whether you delete the imbalance account or not once it is empty is a user 
>preference. Some dislike seeing the imbalance account in their books, and 
>delete it if it is empty. Others (like myself and you) leave that account in 
>place. I leave it because it just reappears again later anyways when you miss 
>an entry.
>
>Also, I'll note that you made a misleading statement late in the first 
>paragraph when you said that "If he deletes the entry, he will delete it from 
>the other accounts as well." In this instance, I think you meant to say "If he 
>deletes the **transaction,** he will delete it from the other accounts as 
>well." It's a minor, yet significant, difference in terminology. An entry (as 
>I understand) is the single line within a transaction, synonymous with the 
>Gnucash term "split." The Transaction is made up of two or more splits/entries.
>
>Best,
>David T.
>
>On June 18, 2022 2:57:01 PM EDT, Gyle McCollam  wrote:
>
>I agree that the matching step is critical when importing and the proper 
>account should be assigned during import.  I also agree that the OP needs to 
>understand Double Entry accounting better,  However, if he has "empty" 
>transactions in the imbalance account, my bet is that if he clicks on the 
>split icon in the toolbar, he will see his debit and credit accounts, plus the 
>empty imbalance account.  When correcting the imbalance entry, he needs to 
>open the split and click on the imbalance entry and change that to the proper 
>account.  I think he added the proper account, entered the amount, then 
>removed the amount from the imbalance account. Doing it this way you can't 
>delete the imbalance account, unless you "jump" to one of the other accounts 
>and delete it from there.  If he deletes the entry, he will delete it from the 
>other accounts as well, which he doesn't want to do.
>  You state that "Once all funds are re-allocated there should be no entries 
> remaining and you can safely delete that account."  You don't delete the 
> account, once there are no entries the account it is irrelevant and if you 
> have it set to not display unused accounts you won't see it unless in the 
> future there is another entry in there,
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com   email
>
>From: gnucash-user  on 
>behalf of David Carlson 
>Sent: Saturday, June 18, 2022 1:59 PM
>To: Kevin T 
>Cc: gnucash-user@gnucash.org 
>Subject: Re: [GNC] rookie question Imbalance-USD
>
>First, Imbalance-USD is not an expense account but a top level account, and
>it is intended to be used only when an automated function is unable to form
>a fully balanced transaction.  You are correct that you can look under that
>account name to find unbalanced transactions if and when they exist.
>
>You might find it useful to re-read about double entry bookkeeping in the
>various help resources

Re: [GNC] Direct Adjustment of Security's Price

[David T. via gnucash-user]

Chapter 11 of the Guide. 

On June 19, 2022 9:56:31 AM EDT, Gao Bite  wrote:
>GnuCash developers & Maintainers:
>
>    Hello! I would like to record the unrealized profit & loss from security 
>investment directly into an income account. Could you please tell me whether I 
>am possible to do as above, and if possible, how I can achieve this?
>
>    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] Bitcoin Lightning payments

[Dr. David Kirkby]

On Sun, 19 Jun 2022 at 12:08, Peter West  wrote:

> If you wait for 4217, you’ll be waiting a long time.
>
> Or so it seems to me.
>
> —
> Peter West
> p...@pbw.id.au


According to the ISO website, they are looking at crypto, but it will not
be part of ISO 4217.  That was written 2.5 years ago 😂😂😂

https://www.iso.org/news/ref2466.html



Dave


-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
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] rookie question Imbalance-USD

[Gyle McCollam]

Sorry, tht first para was to be cross out.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Gyle McCollam 
Sent: Sunday, June 19, 2022 9:59 AM
To: David T. ; gnucash-user@gnucash.org 

Subject: Re: [GNC] rookie question Imbalance-USD

Thank you for going back over my post with such a fine-tooth comb.  I don't 
know how I could have made such an egregious error.  I will attempt to do 
better in the future, but when I make an error like this again in the future, 
and I'm sure I will, please bring it to my attention.  My sincerest apologies.  
I do hope you forgive me.

Thank you.


Thank You,
Gyle McCollam

Gyle McCollam


gmccol...@live.com   email


From: David T. 
Sent: Saturday, June 18, 2022 6:32 PM
To: Gyle McCollam ; gnucash-user@gnucash.org 
; David Carlson ; Kevin 
T 
Subject: RE: [GNC] rookie question Imbalance-USD

The confusion arises when you use "entry" for both splits and transactions in 
the same paragraph, as you did here.

On June 18, 2022 4:57:57 PM EDT, Gyle McCollam  wrote:
When I say entry, I refer to the entire transaction, but I get your point.



Sent from Samsung Galaxy smartphone.



 Original message 
From: "David T." 
Date: 6/18/22 4:24 PM (GMT-05:00)
To: gnucash-user@gnucash.org, Gyle McCollam , David Carlson 
, Kevin T 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] rookie question Imbalance-USD

Gyle,

Whether you delete the imbalance account or not once it is empty is a user 
preference. Some dislike seeing the imbalance account in their books, and 
delete it if it is empty. Others (like myself and you) leave that account in 
place. I leave it because it just reappears again later anyways when you miss 
an entry.

Also, I'll note that you made a misleading statement late in the first 
paragraph when you said that "If he deletes the entry, he will delete it from 
the other accounts as well." In this instance, I think you meant to say "If he 
deletes the **transaction,** he will delete it from the other accounts as 
well." It's a minor, yet significant, difference in terminology. An entry (as I 
understand) is the single line within a transaction, synonymous with the 
Gnucash term "split." The Transaction is made up of two or more splits/entries.

Best,
David T.

On June 18, 2022 2:57:01 PM EDT, Gyle McCollam  wrote:

I agree that the matching step is critical when importing and the proper 
account should be assigned during import.  I also agree that the OP needs to 
understand Double Entry accounting better,  However, if he has "empty" 
transactions in the imbalance account, my bet is that if he clicks on the split 
icon in the toolbar, he will see his debit and credit accounts, plus the empty 
imbalance account.  When correcting the imbalance entry, he needs to open the 
split and click on the imbalance entry and change that to the proper account.  
I think he added the proper account, entered the amount, then removed the 
amount from the imbalance account. Doing it this way you can't delete the 
imbalance account, unless you "jump" to one of the other accounts and delete it 
from there.  If he deletes the entry, he will delete it from the other accounts 
as well, which he doesn't want to do.
  You state that "Once all funds are re-allocated there should be no entries 
remaining and you can safely delete that account."  You don't delete the 
account, once there are no entries the account it is irrelevant and if you have 
it set to not display unused accounts you won't see it unless in the future 
there is another entry in there,


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email

From: gnucash-user  on 
behalf of David Carlson 
Sent: Saturday, June 18, 2022 1:59 PM
To: Kevin T 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] rookie question Imbalance-USD

First, Imbalance-USD is not an expense account but a top level account, and
it is intended to be used only when an automated function is unable to form
a fully balanced transaction.  You are correct that you can look under that
account name to find unbalanced transactions if and when they exist.

You might find it useful to re-read about double entry bookkeeping in the
various help resources.  The F1 key should work while in GnuCash.

We never use the term "Category" to refer to anything in GnuCash, not even
"Expense" Accounts.

The fact that you are finding "empty" transactions there indicates that you
are not always deleting references to that account after re-allocating
funds to the desired account.  Once all funds are re-allocated there should
be no entries remaining and you can safely delete that account.  It will be
re-created if n

Re: [GNC] rookie question Imbalance-USD

[Gyle McCollam]

Thank you for going back over my post with such a fine-tooth comb.  I don't 
know how I could have made such an egregious error.  I will attempt to do 
better in the future, but when I make an error like this again in the future, 
and I'm sure I will, please bring it to my attention.  My sincerest apologies.  
I do hope you forgive me.

Thank you.


Thank You,
Gyle McCollam

Gyle McCollam


gmccol...@live.com   email


From: David T. 
Sent: Saturday, June 18, 2022 6:32 PM
To: Gyle McCollam ; gnucash-user@gnucash.org 
; David Carlson ; Kevin 
T 
Subject: RE: [GNC] rookie question Imbalance-USD

The confusion arises when you use "entry" for both splits and transactions in 
the same paragraph, as you did here.

On June 18, 2022 4:57:57 PM EDT, Gyle McCollam  wrote:
When I say entry, I refer to the entire transaction, but I get your point.



Sent from Samsung Galaxy smartphone.



 Original message 
From: "David T." 
Date: 6/18/22 4:24 PM (GMT-05:00)
To: gnucash-user@gnucash.org, Gyle McCollam , David Carlson 
, Kevin T 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] rookie question Imbalance-USD

Gyle,

Whether you delete the imbalance account or not once it is empty is a user 
preference. Some dislike seeing the imbalance account in their books, and 
delete it if it is empty. Others (like myself and you) leave that account in 
place. I leave it because it just reappears again later anyways when you miss 
an entry.

Also, I'll note that you made a misleading statement late in the first 
paragraph when you said that "If he deletes the entry, he will delete it from 
the other accounts as well." In this instance, I think you meant to say "If he 
deletes the **transaction,** he will delete it from the other accounts as 
well." It's a minor, yet significant, difference in terminology. An entry (as I 
understand) is the single line within a transaction, synonymous with the 
Gnucash term "split." The Transaction is made up of two or more splits/entries.

Best,
David T.

On June 18, 2022 2:57:01 PM EDT, Gyle McCollam  wrote:

I agree that the matching step is critical when importing and the proper 
account should be assigned during import.  I also agree that the OP needs to 
understand Double Entry accounting better,  However, if he has "empty" 
transactions in the imbalance account, my bet is that if he clicks on the split 
icon in the toolbar, he will see his debit and credit accounts, plus the empty 
imbalance account.  When correcting the imbalance entry, he needs to open the 
split and click on the imbalance entry and change that to the proper account.  
I think he added the proper account, entered the amount, then removed the 
amount from the imbalance account. Doing it this way you can't delete the 
imbalance account, unless you "jump" to one of the other accounts and delete it 
from there.  If he deletes the entry, he will delete it from the other accounts 
as well, which he doesn't want to do.
  You state that "Once all funds are re-allocated there should be no entries 
remaining and you can safely delete that account."  You don't delete the 
account, once there are no entries the account it is irrelevant and if you have 
it set to not display unused accounts you won't see it unless in the future 
there is another entry in there,


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email

From: gnucash-user  on 
behalf of David Carlson 
Sent: Saturday, June 18, 2022 1:59 PM
To: Kevin T 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] rookie question Imbalance-USD

First, Imbalance-USD is not an expense account but a top level account, and
it is intended to be used only when an automated function is unable to form
a fully balanced transaction.  You are correct that you can look under that
account name to find unbalanced transactions if and when they exist.

You might find it useful to re-read about double entry bookkeeping in the
various help resources.  The F1 key should work while in GnuCash.

We never use the term "Category" to refer to anything in GnuCash, not even
"Expense" Accounts.

The fact that you are finding "empty" transactions there indicates that you
are not always deleting references to that account after re-allocating
funds to the desired account.  Once all funds are re-allocated there should
be no entries remaining and you can safely delete that account.  It will be
re-created if new transactions appear.

As you noticed, double-clicking is nearly useless in GnuCash.  It does work
to change the sort order of columns in some windows.

When using an import function, GnuCash is trying to learn what Account
transactions have been applied to in the past so it can try to use the same
account with similar transactions.  That is why it is important to use the
"Matching" step to correct ac

Re: [GNC] Bitcoin Lightning payments

[Dr. David Kirkby]

On Sat, 18 Jun 2022 at 22:32, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
> ogram, just
>

b) NO, not a "lame excuse". Misunderstanding of what the ISO is/does. It
sets STANDARDS. In other words, "for currency X use ABX" (or whatever).
Dr. David, if there is no agreed standard for what the three letter
currency code for "bitcoin" is, what should the developers use? Should
they simply use ANY three characters not already in use for some
currency that has an ISO currency code? There are > 17 thousand three
character codes possible and only the order of a hundred or two in use.

Obviously BTC

In general I think standards are good - especially internationally agreed
ones. But according to the ISO website

https://www.iso.org/news/ref2466.html

ISO 4217 is never going to cover cryptocurrencies.  ISO are apparently
looking at crypto.

Personally I feel while ISO is thinking about it, open source software
should just get on an implement the obvious ones. The most obvious is
bitcoin, and that would be BTC. The top 25 by market cap would probably
satisfy almost all users.

Another solution, which would obviously be more work, is for a use to
create a text file with information about other currencies.

BTW, years ago I had a Nigerian scammer try to scam me. I decided to get my
own back, and got him up quote for various items. He thought he was going
to get about $25,000 out of me, but he actually ended up with a huge phone
bill phoning a very expensive number I had. He reckoned one FAX cost him
$50. Anyway, I was very keen to pay in Jersey Royals, not USD, but he
wanted USD. Had he Googled Jersey Royals, he would have realised that they
were a variety of potato and not a currency. I had several months
of fun winding him up😂😂


> Michael D Novack


Dave .
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
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] Direct Adjustment of Security's Price

[Gao Bite]

GnuCash developers & Maintainers:

    Hello! I would like to record the unrealized profit & loss from 
security investment directly into an income account. Could you please 
tell me whether I am possible to do as above, and if possible, how I can 
achieve this?


    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] Bitcoin Lightning payments

[Peter West]

The existing structure of 4217 codes will not work for crypto. It uses the 
two-letter country code plus one letter for the currency. (Do any of these 
conflict with he three letter country codes? As it happens, yes: BTN, CHE, MKD) 
All these codes are mnemonic. (There may be a few for which that is stretching 
the point, but not for lack of wanting a mnemonic.) One letter will not do for 
crypto; there are too many, and they are proliferating. The upshot is that 
whatever happens to crypto designations through ISO, the structure will be 
different.

One might select an otherwise unused first letter (X is the only contender) and 
provide two letters for designating the currency. That will severely restrict 
the mnemonic value of the code. There may well be competing schemes, but every 
exchange uses one – three or four letters from my observations – and that 
situation will soon enough resolve to a single set. Who knows what ISO will 
eventually come up with to accommodate crypto, except that it will not be the 
same structure?

Does GnuCash make ANY use of the internal structure of 4217 codes? If so, 
there’s a development problem right there. If not, things are easier. As we 
speak, exchanges are providing cross-currency quotations for both ISO 
currencies and crypto. How do they do it? As long as the crypto designators 
(like BTC, BUSD, ETH, DOGE) are distinct from the currency designators, the 
indicated currency is unambiguous.

If you wait for 4217, you’ll be waiting a long time.

Or so it seems to me.

—
Peter West
p...@pbw.id.au
And taking the five loaves and the two fish, he looked up to heaven and said a 
blessing over them. Then he broke the loaves and gave them to the disciples to 
set before the crowd.

> On 19 Jun 2022, at 7:32 am, Michael or Penny Novack 
>  wrote:
> 
…
> I'll reply not a a developer but as somebody whose done LOTS of software 
> design in my day.
> 
> a) If the developers did the job right, the ISO currency codes are not hard 
> coded but in "app data" read in when the program starts << that means they 
> can be changed without changing the code in any program, just data in a file.
> 
> b) NO, not a "lame excuse". Misunderstanding of what the ISO is/does. It sets 
> STANDARDS. In other words, "for currency X use ABX" (or whatever). Dr. David, 
> if there is no agreed standard for what the three letter currency code for 
> "bitcoin" is, what should the developers use? Should they simply use ANY 
> three characters not already in use for some currency that has an ISO 
> currency code? There are > 17 thousand three character codes possible and 
> only the order of a hundred or two in use. Whatever they pick the odds are 
> worse then 10,000:1 it won't agree with the code chosen by any other team of 
> software developers OR with what eventually become the standardized currency 
> code for bitcoin if/when the ISO chooses one.
> 
>Your beef should not be with the gnucash developers but with the ISO. You 
> bitcoin users need to lobby THEM to choose a code for bitcoin. Actually, 
> there are TWO standards you need them to choose. One one is the two character 
> prefix to be used when a currency that is not the currency of a nation state 
> (or union of states, like EU in EUR). Then the third character that means 
> "bitcoin".
> 
>Actually, there ARE several codes (competing codes) in use for 
> Bitcoin. Any of those might end up as the eventual code except BTC (which 
> violates ISO 4217 because BT is the code for an existing nation state). When 
> I was suggesting that a two character code first, note that "CC" (for 
> "cryptocurrency" will not do as "CC" already assigned as a "country code".

___
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.