Re: [GNC] Cash in investment has a "price"?

[Marcus Winston]

OK, following up, maybe one last time on this 

Seems like this is a bug. It worked fine before, now it doesn't. Is 
there a way to submit a bug to the Gnucash team?


-marcus

On 10/28/23 18:50, Ken Farley wrote:
I used to have my cash balance in the Brokerage account, but somewhere 
along the line I found it "cleaner" (?) to use something like the 
following structure for my various investment accounts (Brokerage, 
IRAs, 401(k)s)


*Assets*

*Investments*

*Brokerage Account*

*  = Cash Account =   <-- an account of type "Bank"*

*Security Account A  <-- Stock or Mutual Fund
*

*Security Account B  <-- Stock or Mutual Fund*

*etc.
*

This structure has worked very well for me. I use the "=" characters 
around the Cash Account name to force this account to be sorted to the 
top of the list in the sub-accounts. When I changed the structure, I 
did something like this:


(1) Added the Bank account to hold my cash balance

(2) Moved all the transactions in the top level "Brokerage Account" 
(or whatever it is called) to this new Bank account.


(3) Changed the top level Brokerage Account to be a Placeholder 
account (to keep me from habitually entering transactions into it).


It was kind of a pain to move the transactions, but that's what tea 
and coffee are for, I suppose...

___
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 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cash in investment has a "price"?

[Marcus Winston]

Correction -- adding a price for USD is not a workaround. it worked in 
my debug file, but maybe that's because I had no other prices in there.


Could still really use a fix for this bug, or a suggestion on a viable 
workaround.


-marcus

On 10/28/23 13:48, Marcus Winston wrote:
OK, looks like a workaround is to go into the price db, and add a 
price for USD.


-marcus

On 10/28/23 13:31, Marcus Winston wrote:

Yes, I have the following account structure:

Assets
    Investments|
        Brokerage Account, security/currency = USD
            Security Account, security/currency = 
        Security Account, security/currency = 

The Adv Profile report worked fine in the previous version of Gnucash 
(4.4, I think it was). Cash balances in the Brokerage account worked 
fine. In 5.4, it seems they're broken.


I created a "debug.gnucash file". If I delete ALL price db entries, 
the Adv Profile report works fine. But if I have even one price in 
the price db (manually entered, or downloaded), the USD in the 
brokerage account have a price equal to the one security for which I 
have a price.


Whatever changed since 4.4, it would be nice to get it 'fixed'.

-marcus

On 10/28/23 12:58, john wrote:


On Oct 28, 2023, at 09:50, Marcus Winston 
 wrote:


I've just updated to GC 5.4-1 (flatpak; linux). Something really 
strange is going on. In the Advanced Portfolio report, the cash 
balance is reported in USD (the correct currency), but the price of 
the currency is not $1. Sometimes it's $11.88, sometimes it's 
$92.xx (92 and change). I did not notice this before, so it may 
have happened under the previous version I was running 
4.something). But, something is really wrong. When I click on the 
hyperlink on the price, it takes me to the price editor for a 
mutual fund that is not even part of the account.


I did a fix and repair all, but that doesn't seem to have fixed it. 
Any hints as to where to look would be appreciated.
I guess you mean that you included a currency account in the APR 
accounts as the APR doesn't have anything labelled "cash balance". 
Acting on that guess I tried it and found that the report logic 
apparently has no special-casing for an account in the report 
currency so it goes looking for a price in the pricedb. Of course it 
won't find anything for USD-USD, so it looks for a two-step 
conversion, USD->XXX->USD, comes up with something, and proceeds to 
use that something to generate nonsense for the rest of the line.


While it's not hard to think of same-currency accounts that would 
make sense to be included in the APR--a certificate of deposit comes 
immediately to mind--it's also easy to think of cases where that 
could only produce nonsense, starting with your brokerage cash 
account. Figuring out the "basis" and separating out the sweep or 
money-market income from changes due to trades and inflows from 
other holdings would be inordinately complex.


For the true currency investment like a CD or even a savings account 
you can work around the pricing fail and generate a meaningful line 
in the APR by inventing a security. That's technically correct for 
Money Market funds, where you own units in the fund and the managers 
exert a great deal of effort to keep the price of those units at 
$1.00, which effort is not always successful.


Regards,
John Ralls


___
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 remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cash in investment has a "price"?

[Marcus Winston]

OK, looks like a workaround is to go into the price db, and add a price 
for USD.


-marcus

On 10/28/23 13:31, Marcus Winston wrote:

Yes, I have the following account structure:

Assets
    Investments|
        Brokerage Account, security/currency = USD
            Security Account, security/currency = 
        Security Account, security/currency = 

The Adv Profile report worked fine in the previous version of Gnucash 
(4.4, I think it was). Cash balances in the Brokerage account worked 
fine. In 5.4, it seems they're broken.


I created a "debug.gnucash file". If I delete ALL price db entries, 
the Adv Profile report works fine. But if I have even one price in the 
price db (manually entered, or downloaded), the USD in the brokerage 
account have a price equal to the one security for which I have a price.


Whatever changed since 4.4, it would be nice to get it 'fixed'.

-marcus

On 10/28/23 12:58, john wrote:


On Oct 28, 2023, at 09:50, Marcus Winston 
 wrote:


I've just updated to GC 5.4-1 (flatpak; linux). Something really 
strange is going on. In the Advanced Portfolio report, the cash 
balance is reported in USD (the correct currency), but the price of 
the currency is not $1. Sometimes it's $11.88, sometimes it's $92.xx 
(92 and change). I did not notice this before, so it may have 
happened under the previous version I was running 4.something). But, 
something is really wrong. When I click on the hyperlink on the 
price, it takes me to the price editor for a mutual fund that is not 
even part of the account.


I did a fix and repair all, but that doesn't seem to have fixed it. 
Any hints as to where to look would be appreciated.
I guess you mean that you included a currency account in the APR 
accounts as the APR doesn't have anything labelled "cash balance". 
Acting on that guess I tried it and found that the report logic 
apparently has no special-casing for an account in the report 
currency so it goes looking for a price in the pricedb. Of course it 
won't find anything for USD-USD, so it looks for a two-step 
conversion, USD->XXX->USD, comes up with something, and proceeds to 
use that something to generate nonsense for the rest of the line.


While it's not hard to think of same-currency accounts that would 
make sense to be included in the APR--a certificate of deposit comes 
immediately to mind--it's also easy to think of cases where that 
could only produce nonsense, starting with your brokerage cash 
account. Figuring out the "basis" and separating out the sweep or 
money-market income from changes due to trades and inflows from other 
holdings would be inordinately complex.


For the true currency investment like a CD or even a savings account 
you can work around the pricing fail and generate a meaningful line 
in the APR by inventing a security. That's technically correct for 
Money Market funds, where you own units in the fund and the managers 
exert a great deal of effort to keep the price of those units at 
$1.00, which effort is not always successful.


Regards,
John Ralls


___
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 remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cash in investment has a "price"?

[Marcus Winston]

Yes, I have the following account structure:

Assets
    Investments|
        Brokerage Account, security/currency = USD
            Security Account, security/currency = 
        Security Account, security/currency = 

The Adv Profile report worked fine in the previous version of Gnucash 
(4.4, I think it was). Cash balances in the Brokerage account worked 
fine. In 5.4, it seems they're broken.


I created a "debug.gnucash file". If I delete ALL price db entries, the 
Adv Profile report works fine. But if I have even one price in the price 
db (manually entered, or downloaded), the USD in the brokerage account 
have a price equal to the one security for which I have a price.


Whatever changed since 4.4, it would be nice to get it 'fixed'.

-marcus

On 10/28/23 12:58, john wrote:



On Oct 28, 2023, at 09:50, Marcus Winston  wrote:

I've just updated to GC 5.4-1 (flatpak; linux). Something really strange is 
going on. In the Advanced Portfolio report, the cash balance is reported in USD 
(the correct currency), but the price of the currency is not $1. Sometimes it's 
$11.88, sometimes it's $92.xx (92 and change). I did not notice this before, so 
it may have happened under the previous version I was running 4.something). 
But, something is really wrong. When I click on the hyperlink on the price, it 
takes me to the price editor for a mutual fund that is not even part of the 
account.

I did a fix and repair all, but that doesn't seem to have fixed it. Any hints 
as to where to look would be appreciated.

I guess you mean that you included a currency account in the APR accounts as the APR doesn't 
have anything labelled "cash balance". Acting on that guess I tried it and found that 
the report logic apparently has no special-casing for an account in the report currency so it 
goes looking for a price in the pricedb. Of course it won't find anything for USD-USD, so it 
looks for a two-step conversion, USD->XXX->USD, comes up with something, and proceeds to 
use that something to generate nonsense for the rest of the line.

While it's not hard to think of same-currency accounts that would make sense to be 
included in the APR--a certificate of deposit comes immediately to mind--it's also easy 
to think of cases where that could only produce nonsense, starting with your brokerage 
cash account. Figuring out the "basis" and separating out the sweep or 
money-market income from changes due to trades and inflows from other holdings would be 
inordinately complex.

For the true currency investment like a CD or even a savings account you can 
work around the pricing fail and generate a meaningful line in the APR by 
inventing a security. That's technically correct for Money Market funds, where 
you own units in the fund and the managers exert a great deal of effort to keep 
the price of those units at $1.00, which effort is not always successful.

Regards,
John Ralls


___
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 remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Cash in investment has a "price"?

[Marcus Winston]

I've just updated to GC 5.4-1 (flatpak; linux). Something really strange 
is going on. In the Advanced Portfolio report, the cash balance is 
reported in USD (the correct currency), but the price of the currency is 
not $1. Sometimes it's $11.88, sometimes it's $92.xx (92 and change). I 
did not notice this before, so it may have happened under the previous 
version I was running 4.something). But, something is really wrong. When 
I click on the hyperlink on the price, it takes me to the price editor 
for a mutual fund that is not even part of the account.


I did a fix and repair all, but that doesn't seem to have fixed it. Any 
hints as to where to look would be appreciated.


-marcus

___
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 remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] dark theme on Linux

[Marcus Winston]

I'm in the same boat, running GnuCash 4.5 flatpak on Linux Mint 20.1. I 
have the dark theme running, but want the alternating lines appearance 
that I had in GC 3.x. I had created a gtk 3.0 theme css file for GC 3.x, 
and it had worked. Now, with upgrading the OS and installing Flatpak GC, 
I can't find where to put the old .css file to have it work. Any 
pointers would be appreciated.


-marcus

On 6/24/21 3:38 AM, David Cousens wrote:

Michael,

Under the Edit->Preferences dialog there is an option to use the GnuCash built
in colour scheme. Turning this off allows the dark Theme from the system to be
used in the register display. I am running Linux Mint using Adwaita-dark for the
buttons and the Linux Mint-Y-dark for the Windows borders and Mint-Y-Dark-Teal
for Icons in the System theme settings. These seem to be picked up by GnuCash
without any difficulty. I have made no changes to the defauklt gtk-3.0.css
filein .config/gnucash or the stylesheets in.local/share/gnucash. The window
appearance with the default GnuCash colours is as per the attached screenshot of
a screen fragment. With the Gnucash colors on, the appearance is the same apart
from the background colors for the register entries but the windows borders
icons and buttons remain unchanged. The link you posted did not link to anything
so I am not sure what you have done


David


On Thu, 2021-06-24 at 11:20 +0200, Michael via gnucash-user wrote:

I have the following configuration: MX Linux 19.4 AHS, GnuCash 4.5, I
have Adwaita-dark theme enabled by default in MX, when I start GNC, the
buttons/menu has no dark theme enabled, tried the solution suggested in
this post , still doesn't work,
how can I enable dark theme in GNC? Please see the attached screenshot.

___
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] Import CSV: save settings doesn't save

[Marcus Winston]

Thanks for those details. I do have libgtk-3 installed, version 3.18.9. 
I believe I've had it installed since I built GnuCash; Linux Mint 18.3 
appears to have come with gtklib 3.18. Also, I assume most of GnuCash 
wouldn't work if libgtk runtime wasn't installed from the get-go. I 
built it (GnuCash 3.6) on LInux Mint 18.3 a year and a half ago.


-marcus

On 2/3/21 2:51 PM, David Cousens wrote:

Marcus,

Those errors in the tracefile tends to suggest a problem with the GTK
library at runtime. Have you recently upgraded from a  2.x version of
GnuCash to the  3.6 version? The GTK dependencies changed at that
transition. (https://wiki.gnucash.org/wiki/Dependencies - i need to upgrade
this for V4).  You only need the development headers to build GnuCash but
the runtime libraries will need to be installed as well when you run
GnuCash.

Try "dpkg -l | grep libgtk"   in a terminal. This will list the installed
GTK libraries. You should see at least the following in some version

libgtk-3-0
libgtk-3-bin
libgtk-3-common
libgtk-3-dev   -  required for build

for gtk 3  and the version number should be  > 3.14.0  for GnuCash v3.6 (I
currently have 3.24.20  on LM 20.3)
and you will likely have

libgtk2.0-0
libgtk2.0-bin
libgtk2.0-common

for GTK 2.GnuCash3.x does not use GTK2 (but other installed programs may
and they operate independently).

If this is not the problem we may need help from John Geert or Derek.

David Cousens







-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Import CSV: save settings doesn't save

[Marcus Winston]

Thanks for the reply. I don't get any sort of pop-up when I type in a 
name and click on the Save button.


I finally found something that might help. This might be a question for 
the gnucash-dev list (rather than the user list). When I try to save the 
import profile, I get the following lines in the gnucash.trace file:


* 07:26:33  WARN  invalid cast from 'GtkBox' to 'GtkComboBox'
* 07:26:33  WARN  invalid cast from 'GtkBox' to 'GtkBin'
* 07:26:33 ERROR  gtk_bin_get_child: assertion 'GTK_IS_BIN (bin)' 
failed
* 07:26:33 ERROR  gtk_entry_get_text: assertion 'GTK_IS_ENTRY 
(entry)' failed
* 07:26:33 ERROR  gtk_combo_box_get_active_iter: assertion 
'GTK_IS_COMBO_BOX (combo_box)' failed


This is from LInux Mint 18.3, and I built GnuCash from source (since it 
wasn't available in my package manager). If anyone has an idea on what 
to do with/about these error messages, I'd surely appreciate knowing. 
It's possible that there was some missing dependency when I built 
GnuCash. I'm pretty computer literate, but not quite a software 
engineer, so could have missed some important error message.


Marcus

On 2/2/21 1:04 PM, David Cousens wrote:

Marcus

This works fine in GnuCash 4.4 on LinuxMInt 20.3.

Apologize for not responding earlier but II rarely use the importer with CSV
these days and had left it for someone who was using it regularly.

Tosave the file with changed settings( change at least one first of course)
you first have to type a new name in the text box in stead of the default
"No Settings", e.g "MySettings" and then click on the save button. You
should get a popup to say the settings have been saved That should give two
entries which now appear in the dropdown box. Also if you export a file
using the GnuCash  default settings it will also create an entry for those.
There should be no need to restart the importer to see the saved file in the
dropdown box.  You should then be able to select either the No Settings or
mySettings and see the altered selections change in the dialog.

AFAIK it was also working around 3.3 when I last used it while making a few
changes to the importer documentation.

David Cousens



-
David Cousens
--
Sent from:http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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 
seehttps://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] Import CSV: save settings doesn't save

[Marcus Winston]

Hello everyone,

If there are any suggestions on how to figure out the trouble, I'd
appreciate it.
-m

On Fri, Jan 22, 2021 at 9:26 AM Marcus Winston 
wrote:

> >>> the next time you run the csv import assistant the name you typed in
> should be present...
>
> That's the problem: the name I typed in doesn't show up. That's what I
> mean by "nothing happens".
>
> -marcus
>
> On Fri, Jan 22, 2021 at 8:19 AM John Ralls  wrote:
>
>>
>>
>> > On Jan 22, 2021, at 7:26 AM, Marcus Winston <
>> mar...@thechocolatehouse.net> wrote:
>> >
>> > Hello,
>> >
>> > I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit
>> "faster". I see the "Save Settings" (
>> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save).
>> Unfortunately for me, saving settings doesn't work. I type in a name, click
>> the "Save" button, and nothing happens. I've tried looking at the
>> gnucash.trace file, with both --debug, and --debug --extra as command-line
>> options, but didn't find anything useful. Any suggestions or hints are
>> appreciated.
>>
>> What do you expect to happen?
>>
>> What should happen is that the next time you run the csv import assistant
>> the name you typed in should be present in the list for you to select and
>> if you select it your saved column types and other parameters--encoding,
>> date format, etc.--are reflected in the dialog.
>>
>> Regards,
>> John Ralls
>>
>>
___
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] Multi-column balance sheet report

[Marcus Winston]

Hi all,

I just found this thread on the web:

https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/2149519-reporting-multiple-periods

Given the date on the post from Geert Janssens, I'm guessing this report 
or capability isn't included in my GnuCash version 3.6 (from ~1.5 years 
back). Is there any way I can download this thing and get it working in 
my GnuCash (on Linux)? I didn't find any download links on the above page.


Thanks.

-marcus

___
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] Import CSV: save settings doesn't save

[Marcus Winston]

>>> the next time you run the csv import assistant the name you typed in
should be present...

That's the problem: the name I typed in doesn't show up. That's what I mean
by "nothing happens".

-marcus

On Fri, Jan 22, 2021 at 8:19 AM John Ralls  wrote:

>
>
> > On Jan 22, 2021, at 7:26 AM, Marcus Winston <
> mar...@thechocolatehouse.net> wrote:
> >
> > Hello,
> >
> > I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit
> "faster". I see the "Save Settings" (
> https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save).
> Unfortunately for me, saving settings doesn't work. I type in a name, click
> the "Save" button, and nothing happens. I've tried looking at the
> gnucash.trace file, with both --debug, and --debug --extra as command-line
> options, but didn't find anything useful. Any suggestions or hints are
> appreciated.
>
> What do you expect to happen?
>
> What should happen is that the next time you run the csv import assistant
> the name you typed in should be present in the list for you to select and
> if you select it your saved column types and other parameters--encoding,
> date format, etc.--are reflected in the dialog.
>
> Regards,
> John Ralls
>
>
___
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] Import CSV: save settings doesn't save

[Marcus Winston]

Hello,

I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit 
"faster". I see the "Save Settings" 
(https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save). 
Unfortunately for me, saving settings doesn't work. I type in a name, 
click the "Save" button, and nothing happens. I've tried looking at the 
gnucash.trace file, with both --debug, and --debug --extra as 
command-line options, but didn't find anything useful. Any suggestions 
or hints are appreciated.


Thanks.

-marcus

___
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] Asset accounts: cost, or value?

[Marcus Winston]

Well, yes, it isn't necessarily a gnucash question. But pen and ink are 
a bit cumbersome, and so I use gnucash.


Let me illustrate, perhaps it will help to identify whether I'm 
fundamentally doing it wrong, or just have the wrong accounts.


In the assets:fixed assets:house account, I have (I'm making up numbers 
to make things simple):


purchase price of house: +$100,000, balance $100,000

costs to purchase: +$1000, balance $101,000

costs to sell: +$2000, balance $102,000

capital gains: $20,000, balance $122,000


What I'm attempting to do is see the cost or value of the house (or, 
that's what I thought it would do) in the assets:fixed assets:house 
account.  The purchase price is, of course, fine. The costs to purchase 
add to the basis, which is what I want to do in order to easily 
see/calculate (eventually) capital gains (for tax-related purposes). I 
add the selling costs before capital gains because, when I add the 
capital gains, then I get to the actual selling price of the house, 
which is convenient. It might be wrong from an accounting perspective, 
but I'm just a "regular person", not an accountant. I'm trying to figure 
out how to use GnuCash to track all this stuff.  What I see in the other 
accounts tells me I am probably doing it wrong. The "costs to purchase" 
account is an expense. But that account has a -$1000 balance, and the 
"costs to sell" account (also under Expenses) has a -$2000 balance. The 
capital gains is the only thing that's right, because that's an income 
account.


The fundamental question is, should I be trying to use the assets:fixed 
assets:house account to track this stuff? What I see in there has me 
thinking that account tracks my actual costs, but when I add the capital 
gains, it appears to reflect the value of the house, not the cost. 
Hence, my original question: is the "house" account intended to track 
the value, or the cost, of the house?


MW


On 9/2/20 6:53 AM, Michael or Penny Novack wrote:

On 9/2/2020 8:28 AM, Marcus Winston wrote:
OK, Thanks. So the "balance" in the asset account would reflect the 
cost of the asset, not its value. That's fine, and is what I 
concluded also.


Next question: When I sell the house, I'm adding the costs to sell 
the house (title insurance, reconveyance fees, etc) to the cost of 
the house itself. In other words, this will increase the bottom line 
on the fixed asset "House" account. For two-column accounting, where 
does that money come from (what's the other account)? I tried using 
an equity account, but then I end up with a positive equity value on 
the house after I sell it, and that doesn't make sense (I think I 
should have zero equity in the house once it's sold).


MW


This isn't a gnucash question per se (you would have exactly the same 
question were we back in the days of pen and ink on paper accounting)


When these transactions occurred you may have entered them wrongly << 
BTW, maybe it is being in different jurisdictions, but you are listing 
things like "title insurance" and "conveyance fees" as SELLER costs. 
In my experience, it is the buyer who pays for those particular 
things. >>


But back to the other side of those transactions. What I suspect is 
that you entered them incorrectly with the other side as expenses, not 
changes to the basis.


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.

___
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] Asset accounts: cost, or value?

[Marcus Winston]

OK, Thanks. So the "balance" in the asset account would reflect the cost 
of the asset, not its value. That's fine, and is what I concluded also.


Next question: When I sell the house, I'm adding the costs to sell the 
house (title insurance, reconveyance fees, etc) to the cost of the house 
itself. In other words, this will increase the bottom line on the fixed 
asset "House" account. For two-column accounting, where does that money 
come from (what's the other account)? I tried using an equity account, 
but then I end up with a positive equity value on the house after I sell 
it, and that doesn't make sense (I think I should have zero equity in 
the house once it's sold).


MW

On 9/1/20 10:38 PM, Stan Brown wrote:

On 2020-09-01 19:49, Marcus Winston wrote:

I had thought that the Assets:Fixed assets:House would reflect the value of
the house. But after putting the purchase price of the house, and then
adding the costs to purchase (recording fees, appraisal, etc), I conclude
that the House account actually reflects the total cost of the house, and
not necessarily its value. First question: is that a correct view of the
Assets:Fixed assets:House1 account?

Any tracking of value that you might do would be mere speculation. Even
an appraisal is no indication of how much your house is really worth:
both when I moved earlier this year both houses' appraisals were about
20% different from the selling price.

Valuing assets on a balance sheet at somebody's guess of what they're
worth, known as "writing to market", is part of shady accounting
practices and, if I'm not mistaken, partly responsible for the real
estate crash of 2008-2011. Don't do it!

And of course for tax purposes, as you indicated, you _have_ to work
from actual costs, not from guesses about value. Keeping your books on a
cost basis will make that less difficult when you make out your tax returns.


___
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] Asset accounts: cost, or value?

[Marcus Winston]

I'm working on tracking asset values, costs, capital gains, and such, in
GnuCash. Specifically for my house (primary residence). I've sold one
house, and own a second.  I have created some accounts for this:

Assets:Fixed assets:House1
Assets:Fixed assets:House2
Liabilities:Mortgage
Income:Capital Gains:House
Expenses:Asset Purchase
Expenses:Asset Sell

I had thought that the Assets:Fixed assets:House would reflect the value of
the house. But after putting the purchase price of the house, and then
adding the costs to purchase (recording fees, appraisal, etc), I conclude
that the House account actually reflects the total cost of the house, and
not necessarily its value. First question: is that a correct view of the
Assets:Fixed assets:House1 account?

Since I've sold that house, I can add the costs-to-sell to the basis of
that house, and from there, calculate capital gains. And it's this that
leads me to think that the House1 asset account reflects the cost of the
house, and not the value of the house.

Regards,
MW
___
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] Chase OFX - error 15500

[Marcus Winston]

I'm attempting to set up online banking for the first time. Using GnuCash
2.6.12that goes with my Linux distribution (Mint 18.3). I apparently
successfully connect to the bank (JP Morgan Chase), and try to retrieve an
account list. I get error 15500. searching the list archives, I see it can
help to set the version to 2500 instead of 2300 (since Quicken 2013 is no
longer supported). That, unfortunately, doesn't help me.  I suppose it's
possible that I typed my password wrong. Where in a Linux system can I find
where the password (or hash, more likely ) is stored so I can delete it and
get GnuCash's online banking to ask me for it again?

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

has GnuCash code been reviewed for security?

[Marcus Winston]

I've searched the web and mailing list archives for this one, but didn't
find it. I'm just curious if GnuCash has ever gone through a code review
specifically for security? Perhaps something like what was done for
TrueCrypt...?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.