Re: [GNC] Reorganize Trading accounts

2023-04-27 Thread Liz
On Sun, 23 Apr 2023 12:49:29 -0400 King Mak wrote: > Hi, > > I have just acquired a new computer. I moved all my gnucash files to > the new computer by copy-paste. But when I open my accounting files > in the new computer, I notice that some of the transactions are > missing . What do I do?

Re: [GNC] Reorganize Trading accounts

2023-04-24 Thread Michael or Penny Novack
On 4/24/2023 4:24 PM, R Losey wrote: If you have a trust (I assume that it is for someone else), a business, and personal accounts, why not just have three separate books? Not necessarily. From the description, probably only one tax ID. I am guessing the trust might be a revocable trust (we

Re: [GNC] Reorganize Trading accounts

2023-04-24 Thread R Losey
Cash-US > Cash-International > Bonds-US > Bonds-International > Stock-US > Stock-International > RealEstate-US > RealEstate-International > > Sometime later, I learned about Trading accounts, so turned on that > feature. I noticed that the Trading accounts

Re: [GNC] Reorganize Trading accounts

2023-04-23 Thread Adrien Monteleone
It might be easier at this time to keep separate books and then export and manipulate further in a spreadsheet for the combined reports. (while I understand some reports can be either consolidated or separate, the fact that you need separate Balance Sheet Reports tells me the books should be

Re: [GNC] Reorganize Trading accounts

2023-04-23 Thread Alex Aycinena
rs > Cc: > Bcc: > Date: Sun, 23 Apr 2023 09:36:29 +0300 > Subject: [GNC] Reorganize Trading accounts > When I first setup my file, all of the investments / securities were > organized by type: > Cash-US > Cash-International > Bonds-US > Bonds-International > St

Re: [GNC] Reorganize Trading accounts

2023-04-23 Thread King Mak
n I first setup my file, all of the investments / securities were > organized by type: > Cash-US > Cash-International > Bonds-US > Bonds-International > Stock-US > Stock-International > RealEstate-US > RealEstate-International > > Sometime later, I learn

[GNC] Reorganize Trading accounts

2023-04-23 Thread Fred Tydeman
When I first setup my file, all of the investments / securities were organized by type: Cash-US Cash-International Bonds-US Bonds-International Stock-US Stock-International RealEstate-US RealEstate-International Sometime later, I learned about Trading accounts, so turned

Re: [GNC] Trading accounts

2023-04-22 Thread john
Maybe, because it's all we've got for differentiating two securities with the same symbol. Regards, John Ralls > On Apr 22, 2023, at 1:20 AM, Fred Tydeman wrote: > > Is there a relationship between Security Namespaces and Trading accounts? > If I change which Namespac

Re: [GNC] Trading accounts

2023-04-22 Thread Fred Tydeman
Is there a relationship between Security Namespaces and Trading accounts? If I change which Namespace a security is in, should that affect a Trading account? On Fri, Apr 21, 2023 at 11:29 PM john wrote: > No, the naming scheme is hard-coded. Ralf Habacker made a start at > removin

Re: [GNC] Trading accounts

2023-04-21 Thread john
No, the naming scheme is hard-coded. Ralf Habacker made a start at removing name dependencies but got it working only for opening balance accounts. Regards, John Ralls > On Apr 21, 2023, at 9:30 AM, Fred Tydeman wrote: > > Can Trading accounts be moved around? > That is, given

[GNC] Trading accounts

2023-04-21 Thread Fred Tydeman
Can Trading accounts be moved around? That is, given a new parent. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please

Re: [GNC] Trading accounts

2022-07-27 Thread Mike Alexander
to fix things by adding trading account splits where needed you could use the "Check and Repair" commands in the Actions menu. If Trading Accounts are turned on these commands should add the splits where required. I would certainly make a backup copy before trying this. Mike On 2

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
;;--)) > >Geoff >= > >On 27/07/2022 8:36 pm, David Carlson wrote: >> This has confused me. Is the recent thread titled " >> [GNC] Evil Lots Behavior" about lots or trading accounts? >> >> On Wed, Jul 27, 2022 at 12:10 AM David T. wrote: >

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
transactions without notification, something I believe to be a dangerous bug...) You suggested that the OP consult that thread. I'm saying it's not the same problem, and the ELB thread has nothing to do with trading accounts. David T. On July 27, 2022 2:46:34 PM GMT+03:00, Geoff wrote: >Lots. >

Re: [GNC] Trading accounts

2022-07-27 Thread Geoff
Lots. (And they aren't really evil, just wilful). ;--)) Geoff = On 27/07/2022 8:36 pm, David Carlson wrote: This has confused me. Is the recent thread titled " [GNC] Evil Lots Behavior" about lots or trading accounts? On Wed, Jul 27, 2022 at 12:10 AM David T. wrote:

Re: [GNC] Trading accounts

2022-07-27 Thread David Carlson
This has confused me. Is the recent thread titled " [GNC] Evil Lots Behavior" about lots or trading accounts? On Wed, Jul 27, 2022 at 12:10 AM David T. wrote: > David C. > > Trading accounts are not the same as lots. Different concept, different > code. Just a for inst

Re: [GNC] Trading accounts

2022-07-26 Thread David T. via gnucash-user
David C. Trading accounts are not the same as lots. Different concept, different code. Just a for instance: trading accounts are turned on by book; lots can be enabled by account. David T. On July 27, 2022 3:33:37 AM GMT+03:00, David Carlson wrote: >I believe that you are witnessing fi

Re: [GNC] Trading accounts

2022-07-26 Thread David Carlson
ote: > > Over the past several months, I have been importing Quicken data into > > GnuCash. There is about 6 years of data and lots of transactions. > Besides > > normal income and expenses, that data involved many different stocks and > > many different currencies. Recently, I

Re: [GNC] Trading accounts

2022-07-26 Thread David Carlson
I believe that you are witnessing first hand why trading accounts are not enabled by default, i.e. they create a royal mess in your trading history. You might want to re-read the recent thread about evil trading accounts. They may work ok for some users who's documentation goals align

Re: [GNC] Trading accounts

2022-07-26 Thread davidcousens49
t; normal income and expenses, that data involved many different stocks and > many different currencies. Recently, I saw a reference to "Trading" > accounts. I have now enabled that feature. Based on reading > https://www.mathstat.dal.ca/~selinger/accounting/tutorial, I believ

[GNC] Trading accounts

2022-07-26 Thread Fred Tydeman
Over the past several months, I have been importing Quicken data into GnuCash. There is about 6 years of data and lots of transactions. Besides normal income and expenses, that data involved many different stocks and many different currencies. Recently, I saw a reference to "Trading"

Re: [GNC] GNU cash keeps adding trading accounts

2021-06-28 Thread Public Address
to:sunfis...@yahoo.com> Sent: 27 June 2021 12:45 To: David H<mailto:hell...@gmail.com> Cc: Michael via gnucash-user<mailto:gnucash-user@gnucash.org>; Public Address<mailto:public.addr...@hotmail.co.uk> Subject: Re: [GNC] GNU cash keeps adding trading accounts My apologies. I was

Re: [GNC] GNU cash keeps adding trading accounts

2021-06-28 Thread Public Address
tmail.co.uk> Cc: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] GNU cash keeps adding trading accounts I think this is a known bug discussed/reported back in late April which has been fixed and will presumably be released in v4.6 shortly. Check out https://lis

Re: [GNC] GNU cash keeps adding trading accounts

2021-06-27 Thread D. via gnucash-user
ng trading accounts This may or may not be the same problem as in the earlier issue. The earlier issue concerned accounts created in Equity erroneously, not Trading. The (mis-) creation of trading accounts in different tree structures sounds like a different but related problem. Perhaps the fix i

Re: [GNC] GNU cash keeps adding trading accounts

2021-06-27 Thread D. via gnucash-user
This may or may not be the same problem as in the earlier issue. The earlier issue concerned accounts created in Equity erroneously, not Trading. The (mis-) creation of trading accounts in different tree structures sounds like a different but related problem. Perhaps the fix implemented

Re: [GNC] GNU cash keeps adding trading accounts

2021-06-27 Thread David H
I think this is a known bug discussed/reported back in late April which has been fixed and will presumably be released in v4.6 shortly. Check out https://lists.gnucash.org/pipermail/gnucash-user/2021-April/096343.html for more details. Bug report at

[GNC] GNU cash keeps adding trading accounts

2021-06-27 Thread Public Address
Version: 4.5 Build ID: 4.5+(2021-03-27) Finance::Quote: 1.49 Windows 10 I have been entering stock transactions. All stocks are successfully set up in the security editor. However, if (say) I buy AMD shares 1 Buy 10 shares in Brokerage account:AMD 2

Re: [GNC] Trading accounts functionality

2021-04-05 Thread Mike Alexander
On 4 Apr 2021, at 3:29, zuperkoleopt...@gmail.com wrote: Do you think I should file bug reports? Sure, if you can specify detailed step by step instructions for reproducing the errors. The more information you can give the more likely it is to get fixed. Mike

Re: [GNC] Trading accounts functionality

2021-04-04 Thread zuperkoleoptera
On Sat, 2021-04-03 at 03:21 -0400, Mike Alexander wrote: > On 3 Apr 2021, at 1:31, zuperkoleopt...@gmail.com wrote: > > Another issue that I just realized and is related to the > > functionality > > of trading accounts, but maybe not the one that we are discussing > >

Re: [GNC] Trading accounts functionality

2021-04-03 Thread Mike Alexander
On 3 Apr 2021, at 1:31, zuperkoleopt...@gmail.com wrote: Another issue that I just realized and is related to the functionality of trading accounts, but maybe not the one that we are discussing here, is the security/currency of the top level placeholder account Trading. Shouldn't that be set

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
the > > > > system not in eur which is a currency. > > > > Although I have switched to use "commodity value" in the > > > > "smallest > > > > fraction" switch it still uses 1/ instead the 1/. > > > > But

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
ill uses 1/ instead the 1/. >>> But this is somehow minor issue as I assume it does not affect the >>> actual value of the account, it's just visual. >> >> No, it's pretty clearly keeping the transaction from balancing >> because .0012 != .00

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
account, it's just visual.   > > No, it's pretty clearly keeping the transaction from balancing > because .0012 != .00115652. > > As for the trading splits miraculously appearing, did that happen to > all cross-commodity transactions in your book or just ones that you > touche

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
> On Apr 2, 2021, at 9:42 AM, zuperkoleopt...@gmail.com wrote: > > On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: >> >> >>> On Apr 2, 2021, at 8:37 AM, John Ralls wrote: >>> >>> On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: which by the way it does not

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
On Fri, 2021-04-02 at 08:47 -0700, John Ralls wrote: > > > > On Apr 2, 2021, at 8:37 AM, John Ralls wrote: > > > > On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: > > > > > > which by the way it > > > does not use the default security fraction which is 1/ > > > but > > >

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
> On Apr 2, 2021, at 8:37 AM, John Ralls wrote: > > On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: >> >> which by the way it >> does not use the default security fraction which is 1/ but >> 1/. > > The price is in Euro, so it displays as 1/100 of the Euro's

Re: [GNC] Trading accounts functionality

2021-04-02 Thread John Ralls
On Apr 2, 2021, at 4:05 AM, zuperkoleopt...@gmail.com wrote: > > which by the way it > does not use the default security fraction which is 1/ but > 1/. The price is in Euro, so it displays as 1/100 of the Euro's fraction. That's for display only, the actual calculated price is as

Re: [GNC] Trading accounts functionality

2021-04-02 Thread zuperkoleoptera
I have been using lots and scrubing my investment accounts to track realized gains. But since I have turned on trading accounts I have not scrubbed any account. I am attaching an example of 2 splits created after turning on trading accounts. As a side-note some of the account names are in Greek

Re: [GNC] Trading accounts functionality

2021-04-02 Thread Mike Alexander
On 28 Mar 2021, at 11:21, zuperkoleopt...@gmail.com wrote: The problem I am facing is the following, after activating trading accounts the system created the hierarchy for all the trading accounts, but also created a bunch of splits in already recorded transactions. So from the beginning

[GNC] Trading accounts functionality

2021-03-28 Thread zuperkoleoptera
in USD, so I started exploring the trading accounts functionality. I have read both articles from P. Selinger and browsed through the documentation and mailing lists, for related subjects. The problem I am facing is the following, after activating trading accounts the system created the hierarchy

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christoph R
Hi Mike, Lukas, I am using trading accounts since multiple years and can confirm that the UI can be pretty cumbersome. I got used to it. Besides the regular problems in getting the transactions straight it works pretty well Cheers, Christoph > Am 22.01.2021 um 06:13 schrieb Mike Alexan

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christopher Lam
account accounts for these inaccuracies. > > My question was more why the trading accounts (which seem to me the > cleaner, superior and better way) are not enabled by default. > > Also, can you comment a bit more why precicely this would be a major > minefield? (If you know it, o

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christopher Lam
uments previously (but did not read them thoroughly). > > My takeaway is: > * Storing the conversion rate per transaction makes the accounting > equation as a function of time inconsistent (but it is consistent for each > snaphot in time). > * Trading account accounts for these inaccura

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Mike Alexander
When I implemented trading accounts several years ago they were a bit controversial. Some people thought they were more trouble than they were worth and argued that they should be an opt-in choice. One of the initial design goals was that if you didn't turn them on nothing would change

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Christopher Lam
y is a major minefield. > > Start from > https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html > > and finish with > > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the > > background on trading accounts. > > From discussion with ac

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread w...@theprescotts.com
takeaway is: * Storing the conversion rate per transaction makes the accounting equation as a function of time inconsistent (but it is consistent for each snaphot in time). * Trading account accounts for these inaccuracies. My question was more why the trading accounts (which seem to me the cleaner

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Lukas Haase
snaphot in time). * Trading account accounts for these inaccuracies. My question was more why the trading accounts (which seem to me the cleaner, superior and better way) are not enabled by default. Also, can you comment a bit more why precicely this would be a major minefield? (If you know

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Christopher Lam
Multicurrency is a major minefield. Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html and finish with https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the background on trading accounts. >From discussion with accountant, it would seem that the saf

Re: [GNC] Switching to trading accounts in existing database

2021-01-21 Thread Lukas Haase
Hi Mike, On 2021-01-21 02:24, Mike Alexander wrote: On 19 Jan 2021, at 20:08, Lukas Haase wrote: So I got recommended using trading accounts. But suddenly all my previous multi-currency transactions get a small grey box with a cross (hinting the transaction is inconsistent). How do I best

Re: [GNC] Switching to trading accounts in existing database

2021-01-20 Thread Mike Alexander
On 19 Jan 2021, at 20:08, Lukas Haase wrote: So I got recommended using trading accounts. But suddenly all my previous multi-currency transactions get a small grey box with a cross (hinting the transaction is inconsistent). How do I best deal with this? Is it possible to keep my old multi

[GNC] Switching to trading accounts in existing database

2021-01-19 Thread Lukas Haase
ot recommended using trading accounts. But suddenly all my previous multi-currency transactions get a small grey box with a cross (hinting the transaction is inconsistent). How do I best deal with this? Is it possible to keep my old multi currency transactions as-is and use trading accounts only f

Re: [GNC] The type of trading accounts

2020-10-17 Thread Adrien Monteleone
They show up in their own section if I'm not mistaken. While the original question is interesting, I wonder how practical the answer is. Regards, Adrien On 10/17/20 11:58 AM, Stan Brown wrote: And of asset accounts. One way to determine whether its expense account or an asset account is

Re: [GNC] The type of trading accounts

2020-10-17 Thread Stan Brown
On 2020-10-17 04:42, Gal wrote: > But on the other hand, when I open a trading account register, I see that > money coming into the account (debit) is increasing its balance, and money > going out of the account (credit) is decreasing the balance, but this is the > behavior of expense accounts.

[GNC] The type of trading accounts

2020-10-17 Thread Gal
Does a trading account, i.e. an account of type "Trading" that was auto created by the system, acts like an income account or like an expense account? On one hand the concept behind this account type classifies it as an income account: https://www.mscs.dal.ca/~selinger/accounting/tutorial.html

Re: [GNC] Gnucash automatically created trading accounts

2020-02-28 Thread Gio Bacareza
Thank you David. On Sun, Jan 26, 2020 at 5:56 AM David Cousens wrote: > Gio, > > There is one problem that does occur with importing multiple currencies > associated with the price that I am aware of. If the price is expressed as > a > rational number i.e. one integer number divided by another

Re: [GNC] Gnucash automatically created trading accounts

2020-01-25 Thread David Cousens
Gio, There is one problem that does occur with importing multiple currencies associated with the price that I am aware of. If the price is expressed as a rational number i.e. one integer number divided by another integer number or 1+ a rational number, GnuCash sometimes does not appear to parse

[GNC] Gnucash automatically created trading accounts

2020-01-25 Thread Gio Bacareza
So I started a new file. Then I imported csvs containing transactions which have been pre-populated with Gnucash expense accounts. While Gnucash expense accounts are in 1 currency, there are some accounts that have other currencies. After importation, I find that gnucash created a trading

Re: Trading Accounts for Securities

2018-02-22 Thread Keith Bellairs
shows the amount spent or received. So the trading USD account shows dollar amounts for all stock transactions in USD. I did not see a way to set up trading accounts for the currency side of each stock separately, but there may well be a way. When I sell a security I post a debit to the checking

Re: Trading Accounts for Securities

2018-02-22 Thread Keith Bellairs
Thanks, Derek. I get that. I guess trading accounts do not provide for a use case I need. Keith On Wed, Feb 21, 2018 at 12:10 PM, Derek Atkins <de...@ihtfp.com> wrote: > Hi, > > Trading accounts do not show you UNREALIZED gains. They exist to help you > balance out REALI

Re: Trading Accounts for Securities

2018-02-21 Thread Derek Atkins
Hi, Trading accounts do not show you UNREALIZED gains. They exist to help you balance out REALIZED gains once you have a sale transaction. -derek On Wed, February 21, 2018 12:00 pm, Keith Bellairs wrote: > I started looking at using trading accounts but I may be missing > som

Trading Accounts for Securities

2018-02-21 Thread Keith Bellairs
I started looking at using trading accounts but I may be missing something. The trading account created by gnucash for a stock shows as a balance the number of shares in the account. This is also the balance shown in the asset account for that stock. Transactions for all stocks post to the USD

Re: Trading Accounts

2018-02-14 Thread Les
Thanks, that is what my test file indicates.  I am adding Trading Accounts to my production GC file. Les On 02/13/2018 02:59 AM, Wm via gnucash-user wrote: On 12/02/2018 17:12, Les wrote: I use, in addition to USD. AUD, HKD, CAD, CNY and SGD.  I buy in tranches for average cost.  So

Re: Trading Accounts

2018-02-14 Thread Wm
On 13/02/2018 02:27, David Carlson wrote: Be sure to compare what Gnucash generates to what your broker reports to the government. Gnucash has trouble calculating the net gain that the IRS wants to see. Many of us still use spreadsheet s to compare to the brokerage reports that are sent to the

Re: Trading Accounts

2018-02-14 Thread Wm via gnucash-user
, at the bottom of my accounts list, there is a list of currencies and exchanges with totals for each. But, again, there isn't any difference in income and expenses. Trading Accounts may well help you given the mix of currencies. -- Wm ___ gnucash

Re: Trading Accounts

2018-02-14 Thread Wm
On 12/02/2018 12:41, Les wrote: I have a "test" laptop with GC 2.6.17 running the latest Linux Mint.  I opened GC and tried using Trading Accounts, did check and repair, noted the totals of assets, liabilities, income and expense before and after. There was no difference.  I then ra

Re: Trading Accounts

2018-02-13 Thread Les
fference occurs (and I completely missed it initially).  In the GC file without the use of Trading Accounts, I have unrealized gains, whereas in the GC file using Trading Accounts, I have trading gains. I think I need to start using Trading Accounts, if I want to obtain a more ac

Re: Trading Accounts

2018-02-12 Thread David Carlson
, "Les" <lellio...@gmail.com> wrote: > I ran a balance sheet for 2016 and compared the two. Everything looks the > same until I reach the equity account. Here is where the difference occurs > (and I completely missed it initially). In the GC file without the use of &

Re: Trading Accounts

2018-02-12 Thread Les
I ran a balance sheet for 2016 and compared the two.  Everything looks the same until I reach the equity account.  Here is where the difference occurs (and I completely missed it initially).  In the GC file without the use of Trading Accounts, I have unrealized gains, whereas in the GC file

Re: Trading Accounts

2018-02-12 Thread David Carlson
If you read Christopher's links, they go into the theory behind the development of trading accounts. I personally do not need them for my use, so I am not conversant with how they work. I think that you may need them, based on the fact that you are looking into using them, but I cannot help

Re: Trading Accounts

2018-02-12 Thread Christopher Lam
/accounting/tutorial.html https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html C On 12/02/18 20:41, Les wrote: I have a "test" laptop with GC 2.6.17 running the latest Linux Mint.  I opened GC and tried using Trading Accounts, did check and repair, noted the totals

Re: Trading Accounts

2018-02-12 Thread Les
I have a "test" laptop with GC 2.6.17 running the latest Linux Mint.  I opened GC and tried using Trading Accounts, did check and repair, noted the totals of assets, liabilities, income and expense before and after.  There was no difference.  I then ran a Income and Expense report

Re: Trading Accounts

2018-02-12 Thread David Carlson
It would be more fun to make a test copy of an existing file!  David C On Feb 12, 2018 4:13 AM, "Les" <lellio...@gmail.com> wrote: > Thanks, Adrien, David & Christoph for your replies. I think opening a new > GC file and testing Trading Accounts is a good

Re: Trading Accounts

2018-02-11 Thread Christoph R
t is difficult to > turn them off. > > I would set up a test file to try them on until you decide whether you like > them. > > David C > > On Feb 11, 2018 5:39 PM, "Adrien Monteleone" <adrien.montele...@gmail.com> > wrote: > >> Yes, you c

Re: Trading Accounts

2018-02-11 Thread David Carlson
you can add trading accounts (or any other accounts) as needed to your > current file. > > Regards, > Adrien > > On Sun, Feb 11, 2018 at 4:18 PM, Les <lellio...@gmail.com> wrote: > > > I have been using GC for several years, and although I trade stocks, I > >

Trading Accounts

2018-02-11 Thread Les
I have been using GC for several years, and although I trade stocks, I have never used the "Trading Accounts" option.  Can I just start using it, or would I need to start a new GC file? Thanks, Les ___ gnucash-user mailing list gn