Re: [GNC] Mutual Fund Dividend After Sale

2022-09-09 Thread Jack Frillman via gnucash-user
I tried entering it like this for half an hour and  could not get to 
enter the values let alone finish the transaction.


But I did stumble on a way of doing it and it works for my needs anyway.

At least your example pointed me in the right direction to find a solution.

So not all wasted.

Thanks,
Jack

On 9/7/22 10:35 AM, John Layman wrote:

See attached clip.

-Original Message-


I tried something like that but couldn't get it work right.
Could you send a example screen shot?


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Dividend After Sale

2022-09-07 Thread Jack Frillman via gnucash-user



I will give that a try when I get a chance and will let you know.
Thanks,

On 9/7/22 10:35 AM, John Layman wrote:

See attached clip.

-Original Message-


I tried something like that but couldn't get it work right.
Could you send a example screen shot?


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Dividend After Sale

2022-09-07 Thread Jack Frillman via gnucash-user

I tried something like that but couldn't get it work right.
Could you send a example screen shot?

On 9/6/22 11:12 AM, John Layman wrote:

I've had the same situation, but did add a zero-share split to the closed
account.  One side was a deposit to the brokerage core account, the other to
Income:Dividends:Tax-Advantaged.

-Original Message-
From: gnucash-user 
On Behalf Of Jack Frillman via gnucash-user
Sent: Monday, September 5, 2022 1:13 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Mutual Fund Dividend After Sale

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?

The account is hidden because it's balance is 0.

Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after the sale it's
balance became 0. No matter how I record that late dividend the balance
becomes non 0 and the account reappears in the account tree or list.

I don't under stand the last part.

On 9/5/22 12:59 PM, Adrien Monteleone wrote:

You deleted the account holding the fund after selling it?

Otherwise, and unless you marked it 'hidden' it will always be there.
Having activity in it doesn't change that. But you wouldn't have
activity in it anyway from a dividend.

What *exactly* do you mean by 'reappearing in my account list' and by
'screwing everything else up'?

A Dividend receipt would normally be between some asset account
('bank' or a brokerage cash account if direct deposit, 'undeposited
funds' if by paper check) according to how you received the money, and
an Income/Revenue account, say 'Dividends Received'. The FundXYZ
account shouldn't be touched at all.

Regards,
Adrien

On 9/5/22 11:41 AM, Jack Frillman via gnucash-user wrote:

Last month I sold a mutual fund say XYZ.
Several weeks after the sale closed and the calendar date went into
the next quarter I received a dividend from XYZ.
How do I enter that dividend transaction for XYZ without having it
reappearing in my account list and screwing everything else up?


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

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Dividend After Sale

2022-09-07 Thread Jack Frillman via gnucash-user
You’re the one lashing out. Take a chill pill

——
I smell carrots a-cooking and where there’s carrots, there’s a rabbit.
— Yosemite Sam

> On Sep 7, 2022, at 12:51 AM, David T.  wrote:
> 
> Jack: 
> 
> DRIP="Dividend Re-Investment Plan"
> 
> It seems to me that you've decided, in your frustration, to lash out at the 
> people who are trying to understand your problem and offer you help. That's 
> not a good look. You've testily confirmed that you haven't received shares 
> from this dividend, and dismissed the writers asking this reasonable 
> question. Your lack of discussion regarding the technical reporting 
> requirements for ROI ("Return On Investment") scenarios implies that this is 
> not your concern.
> 
> It seems to me that you have yet really to explain your original problem 
> clearly-- specifically, what exactly is showing up now that you've received 
> additional money from the disposed asset? Is it a balance in the Chart of 
> Accounts? Is it a balance in some report? *Where* is this transaction going 
> to screw things up? 
> 
> Others have explained that receipt of cash (in a transaction from income into 
> some brokerage cash account) would not affect any display of the commodity 
> account. It's like some random relative sending you $50: you enter the income 
> as coming from Income and going into your checking account. How would this 
> dividend be different? 
> 
> David T.
> 
>> On September 7, 2022 5:43:16 AM GMT+03:00, David Carlson 
>>  wrote:
>> You need to use nouns instead of pronouns
>> 
>>> On Tue, Sep 6, 2022, 8:44 PM Jack Frillman  wrote:
>>> 
>>> What ever what that is.
>>> 
>>> On 9/6/22 7:38 PM, David Carlson wrote:
>>> 
>>> Some DRIPS work that way
>>> 
>>>> On Tue, Sep 6, 2022, 6:17 PM Jack Frillman  wrote:
>>>> 
>>>> Cash of course.
>>>> How can you reinvest in something you no longer have?
>>>> 
>>>> ——
>>>> I smell carrots a-cooking and where there’s carrots, there’s a rabbit.
>>>> — Yosemite Sam
>>>> 
>>>> On Sep 6, 2022, at 7:04 PM, David Carlson 
>>>> wrote:
>>>> 
>>>> 
>>>> Jack,
>>>> John Ralls asked whether you received shares or cash.  It makes a
>>>> difference.
>>>> 
>>>> On Tue, Sep 6, 2022 at 4:30 PM John Layman <
>>>> john.lay...@laymanandlayman.com> wrote:
>>>> 
>>>>> I've had the same situation, but did add a zero-share split to the closed
>>>>> account.  One side was a deposit to the brokerage core account, the
>>>>> other to
>>>>> Income:Dividends:Tax-Advantaged.
>>>>> 
>>>>> -Original Message-
>>>>> From: gnucash-user >>>> ieee@gnucash.org>
>>>>> On Behalf Of Jack Frillman via gnucash-user
>>>>> Sent: Monday, September 5, 2022 1:13 PM
>>>>> To: gnucash-user@gnucash.org
>>>>> Subject: Re: [GNC] Mutual Fund Dividend After Sale
>>>>> 
>>>>> No I didn't delete the account?
>>>>> Why would I do silly thing like that and lose all that history?
>>>>> 
>>>>> The account is hidden because it's balance is 0.
>>>>> 
>>>>> Reappearing means exactly what it says.
>>>>> I was no longer in the account tree, i.e. list, because after the sale
>>>>> it's
>>>>> balance became 0. No matter how I record that late dividend the balance
>>>>> becomes non 0 and the account reappears in the account tree or list.
>>>>> 
>>>>> I don't under stand the last part.
>>>>> 
>>>>>> On 9/5/22 12:59 PM, Adrien Monteleone wrote:
>>>>>> You deleted the account holding the fund after selling it?
>>>>>> 
>>>>>> Otherwise, and unless you marked it 'hidden' it will always be there.
>>>>>> Having activity in it doesn't change that. But you wouldn't have
>>>>>> activity in it anyway from a dividend.
>>>>>> 
>>>>>> What *exactly* do you mean by 'reappearing in my account list' and by
>>>>>> 'screwing everything else up'?
>>>>>> 
>>>>>> A Dividend receipt would normally be between some asset account
>>>>>> ('bank' or a brokerage cash account if direct deposit, 'undeposited
>>>>>> funds' if by paper check) according to how you receiv

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-06 Thread Jack Frillman via gnucash-user

What ever what that is.

On 9/6/22 7:38 PM, David Carlson wrote:

Some DRIPS work that way

On Tue, Sep 6, 2022, 6:17 PM Jack Frillman  wrote:

Cash of course.
How can you reinvest in something you no longer have?

——
I smell carrots a-cooking and where there’s carrots, there’s a
rabbit.
— Yosemite Sam


On Sep 6, 2022, at 7:04 PM, David Carlson
 wrote:


Jack,
John Ralls asked whether you received shares or cash.  It makes a
difference.

On Tue, Sep 6, 2022 at 4:30 PM John Layman
 wrote:

I've had the same situation, but did add a zero-share split
to the closed
account.  One side was a deposit to the brokerage core
account, the other to
Income:Dividends:Tax-Advantaged.

-Original Message-
From: gnucash-user

On Behalf Of Jack Frillman via gnucash-user
Sent: Monday, September 5, 2022 1:13 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Mutual Fund Dividend After Sale

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?

The account is hidden because it's balance is 0.

Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after
the sale it's
balance became 0. No matter how I record that late dividend
the balance
becomes non 0 and the account reappears in the account tree
or list.

I don't under stand the last part.

On 9/5/22 12:59 PM, Adrien Monteleone wrote:
> You deleted the account holding the fund after selling it?
>
> Otherwise, and unless you marked it 'hidden' it will always
be there.
> Having activity in it doesn't change that. But you wouldn't
have
> activity in it anyway from a dividend.
>
> What *exactly* do you mean by 'reappearing in my account
list' and by
> 'screwing everything else up'?
>
> A Dividend receipt would normally be between some asset
account
> ('bank' or a brokerage cash account if direct deposit,
'undeposited
> funds' if by paper check) according to how you received the
money, and
> an Income/Revenue account, say 'Dividends Received'. The
FundXYZ
> account shouldn't be touched at all.
>
> Regards,
> Adrien
        >
    > On 9/5/22 11:41 AM, Jack Frillman via gnucash-user wrote:
>> Last month I sold a mutual fund say XYZ.
>> Several weeks after the sale closed and the calendar date
went into
>> the next quarter I received a dividend from XYZ.
>> How do I enter that dividend transaction for XYZ without
having it
>> reappearing in my account list and screwing everything
else up?
>
>
> ___
> 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.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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



-- 
David Carlson




--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Mutual Fund Dividend After Sale

2022-09-06 Thread Jack Frillman via gnucash-user
Cash of course. 
How can you reinvest in something you no longer have?

——
I smell carrots a-cooking and where there’s carrots, there’s a rabbit.
— Yosemite Sam

> On Sep 6, 2022, at 7:04 PM, David Carlson  wrote:
> 
> 
> Jack,
> John Ralls asked whether you received shares or cash.  It makes a difference.
> 
>> On Tue, Sep 6, 2022 at 4:30 PM John Layman  
>> wrote:
>> I've had the same situation, but did add a zero-share split to the closed
>> account.  One side was a deposit to the brokerage core account, the other to
>> Income:Dividends:Tax-Advantaged.
>> 
>> -Original Message-----
>> From: gnucash-user 
>> On Behalf Of Jack Frillman via gnucash-user
>> Sent: Monday, September 5, 2022 1:13 PM
>> To: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Mutual Fund Dividend After Sale
>> 
>> No I didn't delete the account?
>> Why would I do silly thing like that and lose all that history?
>> 
>> The account is hidden because it's balance is 0.
>> 
>> Reappearing means exactly what it says.
>> I was no longer in the account tree, i.e. list, because after the sale it's
>> balance became 0. No matter how I record that late dividend the balance
>> becomes non 0 and the account reappears in the account tree or list.
>> 
>> I don't under stand the last part.
>> 
>> On 9/5/22 12:59 PM, Adrien Monteleone wrote:
>> > You deleted the account holding the fund after selling it?
>> >
>> > Otherwise, and unless you marked it 'hidden' it will always be there. 
>> > Having activity in it doesn't change that. But you wouldn't have 
>> > activity in it anyway from a dividend.
>> >
>> > What *exactly* do you mean by 'reappearing in my account list' and by 
>> > 'screwing everything else up'?
>> >
>> > A Dividend receipt would normally be between some asset account 
>> > ('bank' or a brokerage cash account if direct deposit, 'undeposited 
>> > funds' if by paper check) according to how you received the money, and 
>> > an Income/Revenue account, say 'Dividends Received'. The FundXYZ 
>> > account shouldn't be touched at all.
>> >
>> > Regards,
>> > Adrien
>> >
>> > On 9/5/22 11:41 AM, Jack Frillman via gnucash-user wrote:
>> >> Last month I sold a mutual fund say XYZ.
>> >> Several weeks after the sale closed and the calendar date went into 
>> >> the next quarter I received a dividend from XYZ.
>> >> How do I enter that dividend transaction for XYZ without having it 
>> >> reappearing in my account list and screwing everything else up?
>> >
>> >
>> > ___
>> > 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.
>> 
>> --
>> Old Unix programmers never die, they just mv to /dev/null
>> - Anonymous
>> 
>> ___
>> 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.
> 
> 
> -- 
> David Carlson
___
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] Mutual Fund Dividend After Sale

2022-09-06 Thread Jack Frillman via gnucash-user



On 9/6/22 1:58 PM, john wrote:




On Sep 6, 2022, at 5:56 AM, Jack Frillman  wrote:



On 9/5/22 11:53 PM, john wrote:



On Sep 5, 2022, at 4:05 PM, Jack Frillman via gnucash-user 
 wrote:




On 9/5/22 3:09 PM, John Ralls wrote:
On Sep 5, 2022, at 10:32 AM, Adrien Monteleone 
 wrote:


On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote:

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?
The account is hidden because it's balance is 0.
Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after 
the sale it's balance became 0. No matter how I record that late 
dividend the balance becomes non 0 and the account reappears in 
the account tree or list.

I didn't think you deleted it, but wasn't sure what was going on.

I can set an account with a non-zero balance to 'hidden' and it 
stays that way, even with subsequent activity. I can set it to 
hidden with a zero balance, add another transaction to make it 
non-zero, and it stays hidden. I'm not sure why your account is 
showing up.


Did you by chance set a View filter on your Accounts tab that 
would affect this?

I don't under stand the last part.

A Dividend receipt would normally be between some asset account 
('bank' or a brokerage cash account if direct deposit, 
'undeposited funds' if by paper check) according to how you 
received the money, and an Income/Revenue account, say 
'Dividends Received'. The FundXYZ account shouldn't be touched 
at all.
As it states, 'normally' a dividend transaction doesn't involve 
the fund/stock at all. It is a separate transaction between asset 
& income accounts. Though David just informed me that there may 
be times you might record it there, which I had not thought of.
In both cases you record an empty split to the stock account. That 
doesn't change the account's balance and therefore won't unhide it 
from the Accounts page.



And how do I do that?


See 
https://www.gnucash.org/docs/v4/C/gnucash-guide/invest-dividends1.html#invest-dividendcash.


Did you have dividend reinvestments turned on? Were you posting 
dividends the way that the next section, Dividends Reinvested, 
recommends? Was that last post-sale dividend reinvested so that you 
had to do a second sale?
Not sure what you mean by "turned on" but the previous dividends were 
reinvested and were entered manually.


Dividend reinvestment is optional with most open-ended mutual funds, 
so "turned on" means that you have accepted the option.


You didn't answer the last, most important, question: Was the last 
dividend, the one that's the subject of your original question, 
reinvested so that you had shares in the fund again and had to sell 
them to re-close the position?


It's an earlier post.
The stock issues it's dividends at the end of each quarter. The stock 
was sold before the end of the quarter and the dividend was issued once 
the new quarter was entered.


Regards,
John Ralls




--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Mutual Fund Dividend After Sale

2022-09-06 Thread Jack Frillman via gnucash-user




On 9/5/22 11:53 PM, john wrote:



On Sep 5, 2022, at 4:05 PM, Jack Frillman via gnucash-user 
 wrote:




On 9/5/22 3:09 PM, John Ralls wrote:
On Sep 5, 2022, at 10:32 AM, Adrien Monteleone 
 wrote:


On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote:

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?
The account is hidden because it's balance is 0.
Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after the 
sale it's balance became 0. No matter how I record that late 
dividend the balance becomes non 0 and the account reappears in 
the account tree or list.

I didn't think you deleted it, but wasn't sure what was going on.

I can set an account with a non-zero balance to 'hidden' and it 
stays that way, even with subsequent activity. I can set it to 
hidden with a zero balance, add another transaction to make it 
non-zero, and it stays hidden. I'm not sure why your account is 
showing up.


Did you by chance set a View filter on your Accounts tab that would 
affect this?

I don't under stand the last part.

A Dividend receipt would normally be between some asset account 
('bank' or a brokerage cash account if direct deposit, 
'undeposited funds' if by paper check) according to how you 
received the money, and an Income/Revenue account, say 'Dividends 
Received'. The FundXYZ account shouldn't be touched at all.
As it states, 'normally' a dividend transaction doesn't involve the 
fund/stock at all. It is a separate transaction between asset & 
income accounts. Though David just informed me that there may be 
times you might record it there, which I had not thought of.
In both cases you record an empty split to the stock account. That 
doesn't change the account's balance and therefore won't unhide it 
from the Accounts page.



And how do I do that?


See 
https://www.gnucash.org/docs/v4/C/gnucash-guide/invest-dividends1.html#invest-dividendcash.


Did you have dividend reinvestments turned on? Were you posting 
dividends the way that the next section, Dividends Reinvested, 
recommends? Was that last post-sale dividend reinvested so that you 
had to do a second sale?
Not sure what you mean by "turned on" but the previous dividends were 
reinvested and were entered manually.


Regards,
John Ralls



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Mutual Fund Dividend After Sale

2022-09-05 Thread Jack Frillman via gnucash-user




On 9/5/22 3:09 PM, John Ralls wrote:

On Sep 5, 2022, at 10:32 AM, Adrien Monteleone  
wrote:

On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote:

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?
The account is hidden because it's balance is 0.
Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after the sale it's 
balance became 0. No matter how I record that late dividend the balance becomes 
non 0 and the account reappears in the account tree or list.

I didn't think you deleted it, but wasn't sure what was going on.

I can set an account with a non-zero balance to 'hidden' and it stays that way, 
even with subsequent activity. I can set it to hidden with a zero balance, add 
another transaction to make it non-zero, and it stays hidden. I'm not sure why 
your account is showing up.

Did you by chance set a View filter on your Accounts tab that would affect this?

I don't under stand the last part.


A Dividend receipt would normally be between some asset account ('bank' or a 
brokerage cash account if direct deposit, 'undeposited funds' if by paper 
check) according to how you received the money, and an Income/Revenue account, 
say 'Dividends Received'. The FundXYZ account shouldn't be touched at all.

As it states, 'normally' a dividend transaction doesn't involve the fund/stock at 
all. It is a separate transaction between asset & income accounts. Though David 
just informed me that there may be times you might record it there, which I had not 
thought of.

In both cases you record an empty split to the stock account. That doesn't 
change the account's balance and therefore won't unhide it from the Accounts 
page.


And how do I do that?


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.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Dividend After Sale

2022-09-05 Thread Jack Frillman via gnucash-user




On 9/5/22 1:32 PM, Adrien Monteleone wrote:

On 9/5/22 12:13 PM, Jack Frillman via gnucash-user wrote:

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?

The account is hidden because it's balance is 0.

Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after the 
sale it's balance became 0. No matter how I record that late dividend 
the balance becomes non 0 and the account reappears in the account 
tree or list.


I didn't think you deleted it, but wasn't sure what was going on.

I can set an account with a non-zero balance to 'hidden' and it stays 
that way, even with subsequent activity. I can set it to hidden with a 
zero balance, add another transaction to make it non-zero, and it 
stays hidden. I'm not sure why your account is showing up.


Did you by chance set a View filter on your Accounts tab that would 
affect this?

No.



I don't under stand the last part.

A Dividend receipt would normally be between some asset account 
('bank' or a brokerage cash account if direct deposit, 'undeposited 
funds' if by paper check) according to how you received the money, 
and an Income/Revenue account, say 'Dividends Received'. The FundXYZ 
account shouldn't be touched at all.


As it states, 'normally' a dividend transaction doesn't involve the 
fund/stock at all. It is a separate transaction between asset & income 
accounts. Though David just informed me that there may be times you 
might record it there, which I had not thought of.


Regards,
Adrien


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Dividend After Sale

2022-09-05 Thread Jack Frillman via gnucash-user

No I didn't delete the account?
Why would I do silly thing like that and lose all that history?

The account is hidden because it's balance is 0.

Reappearing means exactly what it says.
I was no longer in the account tree, i.e. list, because after the sale 
it's balance became 0. No matter how I record that late dividend the 
balance becomes non 0 and the account reappears in the account tree or list.


I don't under stand the last part.

On 9/5/22 12:59 PM, Adrien Monteleone wrote:

You deleted the account holding the fund after selling it?

Otherwise, and unless you marked it 'hidden' it will always be there. 
Having activity in it doesn't change that. But you wouldn't have 
activity in it anyway from a dividend.


What *exactly* do you mean by 'reappearing in my account list' and by 
'screwing everything else up'?


A Dividend receipt would normally be between some asset account 
('bank' or a brokerage cash account if direct deposit, 'undeposited 
funds' if by paper check) according to how you received the money, and 
an Income/Revenue account, say 'Dividends Received'. The FundXYZ 
account shouldn't be touched at all.


Regards,
Adrien

On 9/5/22 11:41 AM, Jack Frillman via gnucash-user wrote:

Last month I sold a mutual fund say XYZ.
Several weeks after the sale closed and the calendar date went into 
the next quarter I received a dividend from XYZ.
How do I enter that dividend transaction for XYZ without having it 
reappearing in my account list and screwing everything else up?



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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Dividend After Sale

2022-09-05 Thread Jack Frillman via gnucash-user



Last month I sold a mutual fund say XYZ.
Several weeks after the sale closed and the calendar date went into the 
next quarter I received a dividend from XYZ.
How do I enter that dividend transaction for XYZ without having it 
reappearing in my account list and screwing everything else up?



Thanks,
 Jack

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Example of importing Stock transactions from CSV

2022-08-21 Thread Jack Frillman via gnucash-user
I’m importing prices

——
I smell carrots a-cooking and where there’s carrots, there’s a rabbit.
— Yosemite Sam

> On Aug 21, 2022, at 9:34 AM, Jon Schewe  wrote:
> 
> 
> Jack,
> 
> I have tried using this configuration multiple times to get the import to 
> work. I have a list of column assignments, none of which have worked 
> correctly. Thus the python script that does in fact work. In your screenshot 
> I see column options that don't exist for me. Are you importing transactions 
> or prices? I'm trying to import transactions.
> 
> Jon
> 
> 
>> On Sat, 2022-08-20 at 11:54 -0400, Jack Frillman via gnucash-user wrote:
>> I use CSV import almost every day and it works just fine.
>> You do have to setup a configuration file that tells the importer how to 
>> interpret your CSV data. I suspect you did not do that.
>> Here is an example of my CSV data:
>> 
>> ARSIX,14.82,Ray Jay,2022/08/20,USD
>> BAFGX,26.47,Ray Jay,2022/08/20,USD
>> BAGIX,10.07,Ray Jay,2022/08/20,USD
>> CISMX,16.75,Ray Jay,2022/08/20,USD
>> GSFTX,29.98,Ray Jay,2022/08/20,USD
>> 
>> Each column of the separated values above are defined when you set the 
>> importer up.
>> I saved this in a file called "ira quotes" and it's selected in the 
>> attached screen shot.  The bottom window is the result of mapping of the 
>> "irs quotes" file to the CSV data above.
>> 
>> As for your Python script I have no idea what it's supposed to do.
>> I have a much smaller Python script that scrapes the closing day prices 
>> off a web page and creates the CSV file I import.
>> 
>> Jack
>> 
>>> On 8/19/22 10:33 PM, Jon Schewe wrote:
>>> So I didn't get the CSV import tool to work. However I was able to
>>> write a python script to do the import. I would think that this would
>>> be possible with the CSV import, but I can't seem to figure out how to
>>> do the right column assignments to make it work. I have attached the
>>> python script and a sample input CSV file.
>>> 
>>> If someone that knows how the CSV import code works and can compare
>>> with my script and tell me how to use the CSV import tool for this,
>>> that would be great.
>>> 
>>> Thanks,
>>> 
>>> Jon
>>> 
>>> 
>>>> On Tue, 2022-07-12 at 08:45 -0500, Jon Schewe wrote:
>>>> That looks similar to what I'm doing, except all of my data is on a
>>>> single line in the CSV file. The biggest problem seems to be how to
>>>> convince GnuCash to use 2 different commodities for the transaction
>>>> when importing from CSV.
>>>> 
>>>> 
>>>>> On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote:
>>>>> Hi Jon
>>>>> 
>>>>> This isn't exactly what you are asking for, but it may give you
>>>>> some
>>>>> clues.  Importing Dividends from CSV:-
>>>>> 
>>>>> https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html
>>>>> 
>>>>> 
>>>>> Good luck!
>>>>> 
>>>>> Geoff
>>>>> =
>>>>> 
>>>>>> On 12/07/2022 12:35 pm, Jon Schewe wrote:
>>>>>> Does anyone have an example of importing stock 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.
>>>>>&g

Re: [GNC] Stock Split - am I doing this right?

2022-07-31 Thread Jack Frillman via gnucash-user
I used the stock split tool under the tool menu and all I entered was the 
number of shares that should be added. There’s an option to enter the price too 
but I didn’t enter anything for it.
I did this for the Amazon & Google splits and it worked fine. I didn’t have to 
calculate anything 

——
I smell carrots a-cooking and where there’s carrots, there’s a rabbit.
— Yosemite Sam

> On Jul 30, 2022, at 7:11 PM, replicon  wrote:
> 
> I'm trying to capture the AMZN stock split that took place a while back.
> 
> I was surprised by the UI, since instead of "enter split ratio" or
> something like that, it wants me to manually calculate additional stock.
> 
> Is the correct way to do it:
> 
>   - Multiply stock holdings by 19, and add that as additional stock (since
>   it's 20-to-1)
>   - Set the "new price" to the value it had when the split occurred
> 
> My concern is, since stock purchases we track in GNUCash include the basis,
> doesn't the stock split tool cause it to lose track of cost basis?
> 
> I imagine the correct way to track things like capital gains is that any
> transaction where stock was received at a certain price should be
> supplanted with a new transaction for 20x that much stock, at 1/20 of the
> value at time of receipt. Is that not correct? Or is that actually
> happening under the hood without my noticing?
> 
> Thanks!
> ___
> 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] Single Account Expenses For Current Year Only

2022-07-27 Thread Jack Frillman via gnucash-user

To All:

The transaction report gave me what I was looking for.

Thanks,
Jack

On 7/27/22 5:30 PM, David H wrote:

Jack,

I use the same setup, including health fund/medicare rebates.  The 
transaction report gives me subtotals by account/sub-account and a 
grand total at the bottom - sounds like what you're looking for.


Cheers David H.

On Thu, 28 Jul 2022 at 07:18, Jack Frillman via gnucash-user 
 wrote:


I have numerous sub accounts under a parent account.
I am working with one of the sub accounts.

On 7/27/22 4:21 PM, Gyle McCollam wrote:
> Stephen,
> He could have one account, but he could also have accounts for
Hospital, Doctors, Dentists, Prescription, Medical Travel, etc. 
These could all be under a parent account, Medical, but everyone
is different and they may not be.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>          email
>
> 
> From: gnucash-user
 on behalf of
Stephen M. Butler 
> Sent: Wednesday, July 27, 2022 4:10 PM
> To: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Single Account Expenses For Current Year Only
    >
> On 7/27/22 12:15, Jack Frillman via gnucash-user wrote:
>> I want add up all my medical expenses from Jan. 1, 2022 up to
today.
>> How do I do that?
>> I tried several different reports and all they gave me was the
account
>> balance as of today. I just want what was spent so far for this
year.
>> And before you ask I set the date range from 1/1/2022 to "today" in
>> the drop down boxes.
>>
>> Thanks!
>>
> I presume you have an expense account just for the medical
expenses?  If
> not, why not?
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385
81D8
>
> ___
> 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.

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

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



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Single Account Expenses For Current Year Only

2022-07-27 Thread Jack Frillman via gnucash-user

I have numerous sub accounts under a parent account.
I am working with one of the sub accounts.

On 7/27/22 4:21 PM, Gyle McCollam wrote:

Stephen,
He could have one account, but he could also have accounts for Hospital, 
Doctors, Dentists, Prescription, Medical Travel, etc.  These could all be under 
a parent account, Medical, but everyone is different and they may not be.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on behalf of 
Stephen M. Butler 
Sent: Wednesday, July 27, 2022 4:10 PM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Single Account Expenses For Current Year Only

On 7/27/22 12:15, Jack Frillman via gnucash-user wrote:

I want add up all my medical expenses from Jan. 1, 2022 up to today.
How do I do that?
I tried several different reports and all they gave me was the account
balance as of today. I just want what was spent so far for this year.
And before you ask I set the date range from 1/1/2022 to "today" in
the drop down boxes.

Thanks!


I presume you have an expense account just for the medical expenses?  If
not, why not?

--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Single Account Expenses For Current Year Only

2022-07-27 Thread Jack Frillman via gnucash-user

Yes.
I have a parent account with various sub accounts to separate vision 
from dental etc.


On 7/27/22 4:10 PM, Stephen M. Butler wrote:

On 7/27/22 12:15, Jack Frillman via gnucash-user wrote:


I want add up all my medical expenses from Jan. 1, 2022 up to today.
How do I do that?
I tried several different reports and all they gave me was the 
account balance as of today. I just want what was spent so far for 
this year.
And before you ask I set the date range from 1/1/2022 to "today" in 
the drop down boxes.


Thanks!



I presume you have an expense account just for the medical expenses?  
If not, why not?




--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Single Account Expenses For Current Year Only

2022-07-27 Thread Jack Frillman via gnucash-user

Can I do that every time my records disagrees with someone elses?
Some how I think not.

On 7/27/22 3:58 PM, Gyle McCollam wrote:

Jack,
That is the advantage of "Tools/Close Book".  If you do that each 
year, the account balances are the YTD totals.  If you have grouped 
all your medical expenses under a parent account that will be the 
grand total as well.  This way you don't even need a report.  It's 
probably to late now, because if you did close your books each year, I 
guess you wouldn't even be asking this question.


Hopefully, someone that uses reports will be able to help you with the 
current situation.  Or you could close your books "as of" 12/31/2021 
and you will then have the totals you are looking for.


Thank You,

*Gyle McCollam*

Gyle McCollam

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of Jack 
Frillman via gnucash-user 

*Sent:* Wednesday, July 27, 2022 3:15 PM
*To:* gnucash-user@gnucash.org 
*Subject:* [GNC] Single Account Expenses For Current Year Only

I want add up all my medical expenses from Jan. 1, 2022 up to today.
How do I do that?
I tried several different reports and all they gave me was the account
balance as of today. I just want what was spent so far for this year.
And before you ask I set the date range from 1/1/2022 to "today" in the
drop down boxes.

Thanks!

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Single Account Expenses For Current Year Only

2022-07-27 Thread Jack Frillman via gnucash-user



I want add up all my medical expenses from Jan. 1, 2022 up to today.
How do I do that?
I tried several different reports and all they gave me was the account 
balance as of today. I just want what was spent so far for this year.
And before you ask I set the date range from 1/1/2022 to "today" in the 
drop down boxes.


Thanks!

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Selling & Buying Mutual Funds

2022-05-20 Thread Jack Frillman via gnucash-user

The error wasn't apparent which prompted my question.
I did notice one thing odd. In the parent account where the cash from 
the sale is deposited the Transfer field was pointing to something other 
than the mutual fund account that sold shares.

I have no idea what I did wrong.

On 5/20/22 1:30 AM, David Carlson wrote:

The actions that you described are conceptually correct.

If you open the security account for each of the funds you will see 
the number of shares bought or sold in each transaction. Whatever 
error exists should be apparent in that view.


On Thu, May 19, 2022, 7:31 PM Jack Frillman via gnucash-user 
 wrote:



My question involves three Mutual funds and their parent account.
Two of the mutual funds are selling some of their shares and the
parent
fund is buying shares.

Details below:

TROSX - Sell x shares but not all.
MYSIX - Sell y shares but not all.
GSFTX - Buy z shares and add to it's existing account.
IRA-Mutual Funds   -   This is the parent account where the cash
balance
is held.

I tried selling x & y number of shares from TROSX & MYSIX and
adding the
resulting cash into the parent account IRA-Mutual Funds.
Then I purchase z shares from the available cash in the parent
account
IRA-Mutual Funds. Afterwards the results, specifically the number of
shares in each account, were not correct.

I have no idea what I did wrong.

What's the proper way of doing this set of transactions?

Thanks,
Jack

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

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



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Selling & Buying Mutual Funds

2022-05-19 Thread Jack Frillman via gnucash-user


My question involves three Mutual funds and their parent account.
Two of the mutual funds are selling some of their shares and the parent 
fund is buying shares.


Details below:

TROSX - Sell x shares but not all.
MYSIX - Sell y shares but not all.
GSFTX - Buy z shares and add to it's existing account.
IRA-Mutual Funds   -   This is the parent account where the cash balance 
is held.


I tried selling x & y number of shares from TROSX & MYSIX and adding the 
resulting cash into the parent account IRA-Mutual Funds.
Then I purchase z shares from the available cash in the parent account 
IRA-Mutual Funds. Afterwards the results, specifically the number of 
shares in each account, were not correct.


I have no idea what I did wrong.

What's the proper way of doing this set of transactions?

Thanks,
Jack

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] importing prices from csv

2022-03-16 Thread Jack Frillman via gnucash-user




I track the prices of Mutual Funds, Stocks and Precious Metals and 
import them all with a single CSV file.
In all three cases I do not use any of the pre-defined GNUCash Namespace 
names. I use all user defined name space.



On 3/16/22 8:08 PM, Art Chimes wrote:

I well remember agonizing over this when I first set up price imports.
There's a bit of a learning curve here.

"Namespace" can be FUND (if it's a mutual fund), NYSE or NASDAQ or
AMEX if it's a stock on the New York Stock Exchange, NASDAQ, or the
American Stock Exchange, respectively.

Most exchange-traded funds, or EFTs, are traded on AMEX, but there are
exceptions. For example, there's an EFT (QQQM) that tracks the NASDAQ
100, and Gnucash wants the FUND namespace on that one.
Good luck, and please post any further questions.


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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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

2022-03-02 Thread Jack Frillman via gnucash-user

Got it.
That's what I was hoping but wasn't sure.
Thanks,

Jack

On 3/2/22 6:55 PM, Geoff wrote:

Hi Jack

Yes, this can be handled the same way as your previous DFMGX -> DFMLX 
conversion.


You need to create a new Security and Account for SPGI.  Then work out 
the cost basis of your INFO securities and use that as the value of 
the transaction so that it becomes the cost basis of your SPGI 
securities and hence there is no capital gain/loss event.


Regards

Geoff
=

On 3/03/2022 4:11 am, Jack Frillman via gnucash-user wrote:


I had a stock (INFO) in a company that was purchased by another 
company (SPGI).  INFO no longer exists but I now have x shares of SPGI.

What's the recommended way of recording this in GNUCash?

This looks very similar to a Mutual Find conversion I asked about a 
few weeks ago. Can this stock transaction be handled the same way?


Thanks.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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

2022-03-02 Thread Jack Frillman via gnucash-user


I had a stock (INFO) in a company that was purchased by another company 
(SPGI).  INFO no longer exists but I now have x shares of SPGI.

What's the recommended way of recording this in GNUCash?

This looks very similar to a Mutual Find conversion I asked about a few 
weeks ago. Can this stock transaction be handled the same way?


Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Class Conversion

2022-02-16 Thread Jack Frillman via gnucash-user

I got it figured out. Not sure how it works but things look fine so I happy.

Thanks for the help.
Jack

On 2/15/22 11:35 PM, Geoff wrote:

Fear not Jack, you are nearly there!

The magic number we are looking for (your Cost Base) is:
(a) what you paid for the Initial Purchase
(b) the cash equivalent value of your two Reinvests

I think you know these numbers because you have shown them as "$", 
and we don't need to know them here.


"DRP" = Dividend Reinvestment Plan.

Ignore the discrepancy in the column headings - for DFMGX I used the 
menu option View / Transaction Journal; for DFMLX I used (the default) 
View / Auto-Split Ledger.


Sorry again for the confusion.

Good night.

Geoff
=


On 16/02/2022 2:48 pm, Jack Frillman wrote:

Now I'm really confused.
No brokerage fees. I pay mine on a quarterly basis and it's an IRA 
account so no taxes yet.

I don't know what a DRP is so the answer is no to that one.

First thing is I don't have split transactions and the columns in my 
register do not match what you have.
My columns are: Date  Num  Description  Transfer  R  Shares Price Buy 
Sell  Balance
I have no idea where your "Tot Debt"  and  "Tot Credit" columns came 
from and I don't have them.


I have only 3 transactions:

Description    Transfer       Shares 
Buy Balance

Initial Purchase      Invest:IRA                  398.75 $ 398.75
Reinvest IRA:Dividends       6.148 
$  404.989
Reinvest IRA:Dividends   5.311 $    
410.209



I will take a closer look at your example in the morning.



On 2/15/22 9:59 PM, Geoff wrote:
Sorry Jack, that is just the total acquisition cost of your 410.209 
units in DFMGX:

 - How much did you pay for them?
 - Were there any brokerage fees or taxes?
 - Did you receive any units in lieu of income (DRP)?

Add that all up and enter it as the Credit when you reduce DFMGX, 
and again as the Debit when you increase DFMLX.


See attached screenshot for an imaginary example where you purchased 
two lots (300 and 100) and received a further 10.209 via DRP. (Dates 
are in DD/MM/ format).


Hope this helps.

Geoff
=

On 16/02/2022 1:20 pm, Jack Frillman wrote:
That make sense except for the "The value you attribute to this 
transaction should be the total cost base of DFMGX, so that DFMLX 
inherits the same cost base."

How do I do that?
When I reduce DFMGX by 410.20900 shares to 0 transfer them to the 
new DFMLX with the transaction drop-down selection thingy?

   OR
Do I just reduce DFMGX by 410.20900 shares to 0 by dumping them 
into a trash account then enter a new balance of 410.08500 in the 
DFMLX account?




On 2/15/22 8:14 PM, Geoff wrote:

Hi Jack

***Assuming there is no cash component, and this is not a capital 
gains taxable event, I think that you need to:


(a) Create a new Security and a new Account for DFMLX.
(b) In a single transaction, reduce the balance of DFMGX to zero, 
and increase the balance of DFMLX to 410.085. The value you 
attribute to this transaction should be the total cost base of 
DFMGX, so that DFMLX inherits the same cost base.


***I am not an accountant.


Regards

Geoff
=

On 16/02/2022 11:18 am, Jack Frillman via gnucash-user wrote:


How should I handle a "Mutual Fund Share Class Conversion".

In my case I had the following transaction, see summary below, 
show up in my broker account:


(410.20900)  shares of DF DENT MID CAP GROWTH FUND INSTL CL N/L 
(DFMGX)

  converting to
410.08500  shares of  DF DENT MID CAP GROWTH FUND INSTL PLUS CL 
N/L (DFMLX)


No price or $ amount is associated with this transaction.
The only things that changed are 1) ticker symbol, 2) name of 
Mutual Fund, 3) number of shares.


Not sure what to do.

Any suggestion will be greatly appreciated.
Thanks.
Jack







--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Class Conversion

2022-02-15 Thread Jack Frillman via gnucash-user

Now I'm really confused.
No brokerage fees. I pay mine on a quarterly basis and it's an IRA 
account so no taxes yet.

I don't know what a DRP is so the answer is no to that one.

First thing is I don't have split transactions and the columns in my 
register do not match what you have.
My columns are: Date  Num  Description  Transfer  R  Shares  Price Buy  
Sell  Balance
I have no idea where your "Tot Debt"  and  "Tot Credit" columns came 
from and I don't have them.


I have only 3 transactions:

Description    Transfer       Shares 
Buy Balance
Initial Purchase      Invest:IRA                  398.75 $          
398.75
Reinvest IRA:Dividends       6.148 
$  404.989
Reinvest IRA:Dividends   5.311 $   
   410.209



I will take a closer look at your example in the morning.



On 2/15/22 9:59 PM, Geoff wrote:
Sorry Jack, that is just the total acquisition cost of your 410.209 
units in DFMGX:

 - How much did you pay for them?
 - Were there any brokerage fees or taxes?
 - Did you receive any units in lieu of income (DRP)?

Add that all up and enter it as the Credit when you reduce DFMGX, and 
again as the Debit when you increase DFMLX.


See attached screenshot for an imaginary example where you purchased 
two lots (300 and 100) and received a further 10.209 via DRP. (Dates 
are in DD/MM/ format).


Hope this helps.

Geoff
=

On 16/02/2022 1:20 pm, Jack Frillman wrote:
That make sense except for the "The value you attribute to this 
transaction should be the total cost base of DFMGX, so that DFMLX 
inherits the same cost base."

How do I do that?
When I reduce DFMGX by 410.20900 shares to 0 transfer them to the new 
DFMLX with the transaction drop-down selection thingy?

   OR
Do I just reduce DFMGX by 410.20900 shares to 0 by dumping them into 
a trash account then enter a new balance of 410.08500 in the DFMLX 
account?




On 2/15/22 8:14 PM, Geoff wrote:

Hi Jack

***Assuming there is no cash component, and this is not a capital 
gains taxable event, I think that you need to:


(a) Create a new Security and a new Account for DFMLX.
(b) In a single transaction, reduce the balance of DFMGX to zero, 
and increase the balance of DFMLX to 410.085.  The value you 
attribute to this transaction should be the total cost base of 
DFMGX, so that DFMLX inherits the same cost base.


***I am not an accountant.


Regards

Geoff
=

On 16/02/2022 11:18 am, Jack Frillman via gnucash-user wrote:


How should I handle a "Mutual Fund Share Class Conversion".

In my case I had the following transaction, see summary below, show 
up in my broker account:


(410.20900)  shares of DF DENT MID CAP GROWTH FUND INSTL CL N/L 
(DFMGX)

  converting to
410.08500  shares of  DF DENT MID CAP GROWTH FUND INSTL PLUS CL N/L 
(DFMLX)


No price or $ amount is associated with this transaction.
The only things that changed are 1) ticker symbol, 2) name of 
Mutual Fund, 3) number of shares.


Not sure what to do.

Any suggestion will be greatly appreciated.
Thanks.
Jack





--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Class Conversion

2022-02-15 Thread Jack Frillman via gnucash-user
That make sense except for the "The value you attribute to this 
transaction should be the total cost base of DFMGX, so that DFMLX 
inherits the same cost base."

How do I do that?
When I reduce DFMGX by 410.20900 shares to 0 transfer them to the new 
DFMLX with the transaction drop-down selection thingy?

  OR
Do I just reduce DFMGX by 410.20900 shares to 0 by dumping them into a 
trash account then enter a new balance of 410.08500 in the DFMLX account?




On 2/15/22 8:14 PM, Geoff wrote:

Hi Jack

***Assuming there is no cash component, and this is not a capital 
gains taxable event, I think that you need to:


(a) Create a new Security and a new Account for DFMLX.
(b) In a single transaction, reduce the balance of DFMGX to zero, and 
increase the balance of DFMLX to 410.085.  The value you attribute to 
this transaction should be the total cost base of DFMGX, so that DFMLX 
inherits the same cost base.


***I am not an accountant.


Regards

Geoff
=

On 16/02/2022 11:18 am, Jack Frillman via gnucash-user wrote:


How should I handle a "Mutual Fund Share Class Conversion".

In my case I had the following transaction, see summary below, show 
up in my broker account:


(410.20900)  shares of DF DENT MID CAP GROWTH FUND INSTL CL N/L (DFMGX)
  converting to
410.08500  shares of  DF DENT MID CAP GROWTH FUND INSTL PLUS CL N/L 
(DFMLX)


No price or $ amount is associated with this transaction.
The only things that changed are 1) ticker symbol, 2) name of Mutual 
Fund, 3) number of shares.


Not sure what to do.

Any suggestion will be greatly appreciated.
Thanks.
Jack



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual Fund Class Conversion

2022-02-15 Thread Jack Frillman via gnucash-user


How should I handle a "Mutual Fund Share Class Conversion".

In my case I had the following transaction, see summary below, show up 
in my broker account:


(410.20900)  shares of DF DENT MID CAP GROWTH FUND INSTL CL N/L (DFMGX)
 converting to
410.08500  shares of  DF DENT MID CAP GROWTH FUND INSTL PLUS CL N/L (DFMLX)

No price or $ amount is associated with this transaction.
The only things that changed are 1) ticker symbol, 2) name of Mutual 
Fund, 3) number of shares.


Not sure what to do.

Any suggestion will be greatly appreciated.
Thanks.
Jack

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Version 4.6 Upgrade Oddities

2021-12-11 Thread Jack Frillman via gnucash-user

I did both actually.

On 12/11/21 1:53 PM, Gyle McCollam wrote:
Better yet, instead of writing it down, create a folder in your email 
account.  Call it GNUCash Tips and move the email there. That way 
there is no paper to lose or misplace, only a crashed computer to 
worry about (LOL).


Thank You,
*Gyle McCollam*

Gyle McCollam

609.680.2326Mobile

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of Jack 
Frillman via gnucash-user 

*Sent:* Saturday, December 11, 2021 1:48 PM
*To:* gnucash-user@gnucash.org 
*Subject:* Re: [GNC] Version 4.6 Upgrade Oddities
That was it.
I guess I better write this down so don't have to ask again in nine 
months.


Thanks.

On 12/11/21 1:24 PM, AC wrote:
> For decimal prices:
> Edit Menu -> Preferences -> Numbers, Date & Time:
> Checkbox: "Force prices to display as decimals"
>
> For account colors:
>
> Edit Menu -> Preferences -> Accounts:
> Two checkboxes:
> Show the Account Color as background
> Show the Account Color on tabs

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
___
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] Version 4.6 Upgrade Oddities

2021-12-11 Thread Jack Frillman via gnucash-user

That was it.
I guess I better write this down so don't have to ask again in nine months.

Thanks.

On 12/11/21 1:24 PM, AC wrote:

For decimal prices:
Edit Menu -> Preferences -> Numbers, Date & Time:
Checkbox: "Force prices to display as decimals"

For account colors:

Edit Menu -> Preferences -> Accounts:
Two checkboxes:
Show the Account Color as background
Show the Account Color on tabs 


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Version 4.6 Upgrade Oddities

2021-12-11 Thread Jack Frillman via gnucash-user
I just upgraded my Linux system to Fedora 34 and it in the process it 
upgraded GNC to 4.6 where previously it was 4.4.

Two of my settings/preferences were undone:

1 - The prices in an investment account is now in fractions, which BTW 
is unreadable, where before (in version 4.4)  I had it as a 5 place 
decimal number. I can't find were to set this.
2 - I have colors assigned to each account. In version 4.4 the color set 
both the tab color and background color of account names in the account 
tab. There is now no option to set the background color of account names 
in the account tab. So, how do I do this?


Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Credit Card Rewards Refund

2021-10-14 Thread Jack Frillman via gnucash-user

I also put it into a miscellaneous income.

On 10/14/21 9:07 AM, Steve Welch via gnucash-user wrote:

Because the rewards aren’t necessarily attributable to any one expense (or to 
split them out proportionately would be a whole lot of work), I always book 
them to miscellaneous income.  I also include that income when I budget.

Hope that helps,

Steve

Sent from my iPhone


On Oct 14, 2021, at 8:34 AM, rsbrux via gnucash-user  
wrote:

I have a credit card which, like a few others, accrues a small percentage (1-2%) of the 
amounts spent as a rebate.  The rebate isn't subtracted from each charge, but accumulates 
in the card account as "Reward Points" until I cash them in.  The amount is 
then credited to the card account as a payment.  Should such payments be recorded as 
income or as a negative expense?

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Split Transaction Confusion Again

2021-10-09 Thread Jack Frillman via gnucash-user



I just bought the stock and I got a dividend and I don't know how often 
I will get them. So setting up a scheduled transaction for it is not 
practical.


The response Gyle sent was the solution what I was trying to do.

Thanks.

On 10/9/21 8:59 PM, Liz Dodd wrote:

On Sat, 9 Oct 2021 11:46:14 -0400
Jack Frillman via gnucash-user  wrote:


Yes it was a big help.
Thanks.

On 10/9/21 10:23 AM, Gyle McCollam wrote:

This would be your entry:

Parent Brokerage Account                $8.61
Tax Account                                      $1.52
Dividend Income Account                                   $10.63

Hope this helps you and is clear.

Thank You,
*Gyle McCollam*


To avoid having to work this out every year, try making a shceduled
transaction.
Edit out the numbers and put the the instructions in place.

Attached is how I get my electricity account recorded faster.
Liz

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Split Transaction Confusion Again

2021-10-09 Thread Jack Frillman via gnucash-user

Yes it was a big help.
Thanks.

On 10/9/21 10:23 AM, Gyle McCollam wrote:

This would be your entry:

Parent Brokerage Account                $8.61
Tax Account                                      $1.52
Dividend Income Account                                   $10.63

Hope this helps you and is clear.

Thank You,
*Gyle McCollam*

Gyle McCollam

609.680.2326Mobile

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of Jack 
Frillman via gnucash-user 

*Sent:* Saturday, October 9, 2021 9:51 AM
*To:* gnucash-user@gnucash.org 
*Subject:* [GNC] Split Transaction Confusion Again

I'm having trouble entering a split transaction for a stock dividend &
the tax that was withheld.

The stock has a dividend of   $10.13
Tax withheld is   $1.52
This leaves a cash deposit of $8.61 in the parent brokerage account.

How do I enter a split transaction that shows the dividend of $10.13,
puts the tax of $1.52 into a tax tracking account and adds $8.61 to the
cash balance in the parent brokerage account?

As with a straight dividend I'm entering the main transaction in the
parent brokerage account.

No matter which way I try making these entry's I always have an amount
added to the imbalance account or the $10.13 added to the cash balance.
I have read GNU Cash Documentation on split transactions several times
and I still can't figure this out.

Thanks.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists 
<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.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Split Transaction Confusion Again

2021-10-09 Thread Jack Frillman via gnucash-user


I'm having trouble entering a split transaction for a stock dividend & 
the tax that was withheld.


The stock has a dividend of   $10.13
Tax withheld is   $1.52
This leaves a cash deposit of $8.61 in the parent brokerage account.

How do I enter a split transaction that shows the dividend of $10.13, 
puts the tax of $1.52 into a tax tracking account and adds $8.61 to the 
cash balance in the parent brokerage account?


As with a straight dividend I'm entering the main transaction in the 
parent brokerage account.


No matter which way I try making these entry's I always have an amount 
added to the imbalance account or the $10.13 added to the cash balance.
I have read GNU Cash Documentation on split transactions several times 
and I still can't figure this out.


Thanks.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] email seems so crude 30 years after MULTICS forums.

2021-10-07 Thread Jack Frillman via gnucash-user




Of course there's Usenet, which doesn't require everyone to connect to


Usenet is still active?
I though it died years ago.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Newbie question

2021-09-26 Thread Jack Frillman via gnucash-user

Steve,

I switched from Moneydance as you did about six months ago. The 
conversion went fine for me except the account balances were off. To 
correct for that I just went to each account that was off and entered an 
opening balance, at the very beginning of the ledger, for the amount 
that was it off by and then everything was fine and has been fine since 
then.


Hope that helps.

If you have any question regarding switchin form Moneydace to GNUCash 
you ask me directly if you wish since I have doe the same conversion.


Jack

On 9/25/21 9:59 PM, Steve Welch via gnucash-user wrote:

Hi!

I’m just getting started with GnuCash and have imported my QIF file from 
Moneydance.  Excited to take it for a spin!
My question is regarding beginning (opening) account balances.  Moneydance has 
an opening balance field in the account setup window, but evidently that field 
isn’t accessible in GnuCash unless setting up a new account.
The problem I seem to be having is that the beginning balances that had been in 
Moneydance did not import into Gnu, so my accounts are off.
I am figuring I can manually enter an opening balance transaction for each 
account but wanted to make sure I wasn’t missing a more elegant (or obvious) 
solution.

Thanks,

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Report Question

2021-09-22 Thread Jack Frillman via gnucash-user

Understand.
I only use a single currency so I should be fine then

Thanks.

On 9/22/21 8:31 PM, Christopher Lam wrote:

Yes it will use 2022 year if the report is launched in 2022.

This report is stable and will not be removed from gnucash. The only 
known blocker against it moving out of experimental is that the 
valuation into target currency is known to be slightly* flawed when 
multiple columns are involved. To fix it would cause the report to be 
much slower. If the book is single currency only then there are no 
known bugs on this report.


* Consider a book with multiple foreign or stock transactions at 
various dates; the weighted average / average cost pricing will 
attempt to value the conversion at a "reasonable" average price into 
the report currency. The mechanism to obtain price at multiple dates 
in this report will slightly differ from the single-date balance sheet 
or income statement report.


On Thu, 23 Sep 2021, 5:25 am Jack Frillman via gnucash-user, 
mailto:gnucash-user@gnucash.org>> wrote:



Using GNUC 4.4

I setup a Income Statement report from the Reports-->Experimental
report
options.
I have the Start Date set to "Start of this Year" and the End Date to
"End of this Year".

Will the date range of the report automatically switch to Jan 1
2022 to
Dec 31 2022 when the new year actually arrives?


Are these Experimental reports stable?

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Report Question

2021-09-22 Thread Jack Frillman via gnucash-user



Using GNUC 4.4

I setup a Income Statement report from the Reports-->Experimental report 
options.
I have the Start Date set to "Start of this Year" and the End Date to 
"End of this Year".


Will the date range of the report automatically switch to Jan 1 2022 to 
Dec 31 2022 when the new year actually arrives?



Are these Experimental reports stable?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Securities Pie Chart.

2021-09-09 Thread Jack Frillman via gnucash-user



It looks like in version 4.4 there is a hard limit of 24 slices 
(securities) for the pie chart. I'm assuming it's limited so the slices 
won't get so thin you can't see them.

So what do you do when you have more than 24 securities?
The only thing I can think of is making more than one chart.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Deleting Scheduled Transactions

2021-09-03 Thread Jack Frillman via gnucash-user

Your last suggestion got me what I wanted.
Thanks.

BTW: I'm not able to uncheck the Enabled check box for some reason. 
Running Version 4.4 on a Mac. I thought I did that before but I can't 
now for some odd reason.




On 9/3/21 9:03 AM, Derek Atkins wrote:

HI,

On Fri, September 3, 2021 8:54 am, Jack Frillman via gnucash-user wrote:

How do you delete/remove a scheduled transaction from the list of
scheduled transactions under the scheduled transaction tab?

So just to be clear, you are trying to remove the full schedule (not
existing, fired-off transactions from your CoA), right?  You just want it
to stop firing off in the future...


I tried unchecking the Enabled check box but that didn't do anything. I
tried the Delete button in the transaction editor and that didn't do
anything. I tried doing it from the calendar and had no luck. I checked
the GNUC documentation and didn't find anything on how to remove/delete
a scheduled transaction.

Unchecking the Enabled box will cause the SX never to fire again, so it
won't create new transactions in the future.


So how can I remove/delete a scheduled transaction?

If you go to Actions -> Scheduled Transactions -> Scheduled Transaction
Editor it brings up the SX page.  From there you can click on the SX you
want to delete and then click on the "Delete" toolbar item to delete the
SX.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Deleting Scheduled Transactions

2021-09-03 Thread Jack Frillman via gnucash-user



How do you delete/remove a scheduled transaction from the list of 
scheduled transactions under the scheduled transaction tab?


I tried unchecking the Enabled check box but that didn't do anything. I 
tried the Delete button in the transaction editor and that didn't do 
anything. I tried doing it from the calendar and had no luck. I checked 
the GNUC documentation and didn't find anything on how to remove/delete 
a scheduled transaction.


So how can I remove/delete a scheduled transaction?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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 Entry Confirmation

2021-08-31 Thread Jack Frillman via gnucash-user
It's not a big deal I was just looking for one and wasn't able to find 
an option like that.


If you want to know how my brain is working.
If I mash ENTER in an open split transaction it moves down to the next 
split transaction. What does that mean? Does that mean the whole 
transaction was entered or just the split was entered? I'm never sure so 
I was looking for an audio confirmation when the entire transaction was 
committed like in the program I used before switching to  GNU Cash.  Now 
to be absolutely sure I close the split and mash ENTER again.


On 8/31/21 3:41 PM, Derek Atkins wrote:

Jack,

On Tue, August 31, 2021 3:30 pm, Jack Frillman via gnucash-user wrote:

What's yhere to understand. I was looking for an audio confirmation like
a little tiny beep.

I think Will's point was questioning why you specifically want an audio
confirmation when there is clearly a visual confirmation (by the cursor
moving to the next line or new transaction).

-derek


On 8/31/21 11:30 AM, William Prescott wrote:

I don't understand.

When I type the Enter key, it moves from one line of a transaction to
the next line. After the last line, it enters the transaction and moves
to the first line of the next transaction.

This is with GnuCash 4.6-1 running on MacOS 11.5.2.

Will

On 2021 Aug 31, at 08-31 10:06:10, Jack Frillman via gnucash-user
 wrote:


Is there any way to have GNU Cash make an audio confirmation when a
manual transaction has been entered?

When I manually enter a transaction by mashing ENTER there is no
feedback that the transaction was entered and I keep hitting ENTER to be
sure I didn't fat finger it.
Just a little beep would suffice.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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





--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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 Entry Confirmation

2021-08-31 Thread Jack Frillman via gnucash-user

An audio confirmation is easier for me notice.

On 8/31/21 3:41 PM, Derek Atkins wrote:

Jack,

On Tue, August 31, 2021 3:30 pm, Jack Frillman via gnucash-user wrote:

What's yhere to understand. I was looking for an audio confirmation like
a little tiny beep.

I think Will's point was questioning why you specifically want an audio
confirmation when there is clearly a visual confirmation (by the cursor
moving to the next line or new transaction).

-derek


On 8/31/21 11:30 AM, William Prescott wrote:

I don't understand.

When I type the Enter key, it moves from one line of a transaction to
the next line. After the last line, it enters the transaction and moves
to the first line of the next transaction.

This is with GnuCash 4.6-1 running on MacOS 11.5.2.

Will

On 2021 Aug 31, at 08-31 10:06:10, Jack Frillman via gnucash-user
 wrote:


Is there any way to have GNU Cash make an audio confirmation when a
manual transaction has been entered?

When I manually enter a transaction by mashing ENTER there is no
feedback that the transaction was entered and I keep hitting ENTER to be
sure I didn't fat finger it.
Just a little beep would suffice.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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





--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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 Entry Confirmation

2021-08-31 Thread Jack Frillman via gnucash-user
What's yhere to understand. I was looking for an audio confirmation like 
a little tiny beep.


On 8/31/21 11:30 AM, William Prescott wrote:

I don't understand.

When I type the Enter key, it moves from one line of a transaction to the next 
line. After the last line, it enters the transaction and moves to the first 
line of the next transaction.

This is with GnuCash 4.6-1 running on MacOS 11.5.2.

Will

On 2021 Aug 31, at 08-31 10:06:10, Jack Frillman via gnucash-user 
 wrote:


Is there any way to have GNU Cash make an audio confirmation when a manual 
transaction has been entered?

When I manually enter a transaction by mashing ENTER there is no feedback that 
the transaction was entered and I keep hitting ENTER to be sure I didn't fat 
finger it.
Just a little beep would suffice.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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 Entry Confirmation

2021-08-31 Thread Jack Frillman via gnucash-user

Okay.
I now know it's not me unable to find it somewhere.

Thanks.

On 8/31/21 11:46 AM, John Ralls wrote:



On Aug 31, 2021, at 8:06 AM, Jack Frillman via gnucash-user 
 wrote:


Is there any way to have GNU Cash make an audio confirmation when a manual 
transaction has been entered?

When I manually enter a transaction by mashing ENTER there is no feedback that 
the transaction was entered and I keep hitting ENTER to be sure I didn't fat 
finger it.
Just a little beep would suffice.

No, sorry.

Regards,
John Ralls



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Transaction Entry Confirmation

2021-08-31 Thread Jack Frillman via gnucash-user



Is there any way to have GNU Cash make an audio confirmation when a 
manual transaction has been entered?


When I manually enter a transaction by mashing ENTER there is no 
feedback that the transaction was entered and I keep hitting ENTER to be 
sure I didn't fat finger it.

Just a little beep would suffice.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Help Selling & Buying Securities

2021-08-10 Thread Jack Frillman via gnucash-user

Got that covered.
Mine is reported at the end of the year and the tax program slurps in 
all the data at tax time.


On 8/10/21 4:52 PM, David Carlson wrote:
Be sure to check your next broker's statement for any capital gain 
that you may need to pay tax on next year.


On Tue, Aug 10, 2021, 2:10 PM Jack Frillman > wrote:


I finally got it figured out. My transactions in GNUC are correct
after
all.
The cash on my brokers website has not been updated yet because the
transactions have not been closed out. Once that happens the cash
amounts will agree. So says my financial advisor.

Thanks for the advice.

On 8/10/21 2:01 PM, Fred Bone wrote:
> On 10 August 2021 at 13:48, Jack Frillman said:
>
>> I have been trough all that and don't see how any of it applies
to what
>> I'm trying to do because: 1 - I have no commissions to deal
with. 2 - I
>> have no capital gains to deal with. Very confusing.. It
appears I have
>> the sell side correct the the buy may have something wrong.
> Well, either
> (a) the value of both sell and buy txns was the same, and you have
> entered one of them wrong, or
> (b) the values were different, so you shouldn't be expecting the net
> result to be nil.
>
> Only you can tell which applies.
>

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Help Selling & Buying Securities

2021-08-10 Thread Jack Frillman via gnucash-user
I finally got it figured out. My transactions in GNUC are correct after 
all.
The cash on my brokers website has not been updated yet because the 
transactions have not been closed out. Once that happens the cash 
amounts will agree. So says my financial advisor.


Thanks for the advice.

On 8/10/21 2:01 PM, Fred Bone wrote:

On 10 August 2021 at 13:48, Jack Frillman said:


I have been trough all that and don't see how any of it applies to what
I'm trying to do because: 1 - I have no commissions to deal with. 2 - I
have no capital gains to deal with. Very confusing.. It appears I have
the sell side correct the the buy may have something wrong.

Well, either
(a) the value of both sell and buy txns was the same, and you have
entered one of them wrong, or
(b) the values were different, so you shouldn't be expecting the net
result to be nil.

Only you can tell which applies.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Help Selling & Buying Securities

2021-08-10 Thread Jack Frillman via gnucash-user
I have been trough all that and don't see how any of it applies to what 
I'm trying to do because:

1 - I have no commissions to deal with.
2 - I have no capital gains to deal with.
Very confusing..
It appears I have the sell side correct the the buy may have something 
wrong.



On 8/10/21 11:49 AM, David Carlson wrote:

Jack,

If you follow the help manual reference given by Eric earlier 
(https://code.gnucash.org/docs/C/gnucash-guide/invest-buy-stock1.html 
) 
and continue forward to the section on stock sales there is a lot of 
information there which should help you.  The issue of capturing 
realized gains is a complex one with more than one solution, but you 
can defer that decision until after you are comfortable with the basic 
transactions.


On Tue, Aug 10, 2021 at 9:28 AM Fred Bone > wrote:


On 10 August 2021 at 10:01, Jack Frillman said:

> I sort of got it to work but my cash balance is all messed up.
> See attached for the example of my transactions.
>
> In the parent account the cash Balance should be $1,115.05 not
$4,676.09
> and I can't figure out why.
>
> Where did I mess up?

Hard to say without knowing what the txns actually were. What you
have
told Gnucash is:

- you had 1115.05 on 7/21
- you sold some Midcap Fund for 5213.04 on 8/10
- you bought some Mid Cap Value for 1652.00 on 8/10

which leaves a balance of 4676.09, as shown.

Presumably you have entered the wrong value for either the sale or
the
purchase txns, but only you can tell which.


___
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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Help Selling & Buying Securities

2021-08-10 Thread Jack Frillman via gnucash-user

I sort of got it to work but my cash balance is all messed up.
See attached for the example of my transactions.

In the parent account the cash Balance should be $1,115.05 not $4,676.09 
and I can't figure out why.


Where did I mess up?


On 8/10/21 8:29 AM, Eric Coates via gnucash-user wrote:

Jack

I'm assuming that your "Invest Account - ABC" is set up as a stock 
(check using the Edit Account button) and you have set an opening 
balance of 100 shares of ABC in that account. If that is correct you 
sell them by an entry similar to the one shown in the attached Sell 
Shares png but you would show that the cash is paid into your Parent 
Invest Account (which should be set up as type Asset but with Security 
/currency set as your base currency.)


After setting up an account "Invest Account - XYZ" buying the XYZ 
shares can be recorded using an entry similar to that shown in the Buy 
Shares png again using the Parent Invest Account as the source of 
funds. (I'm pretty sure that people cleverer than I would do the sale 
and purchase as one transaction but I prefer to keep things simple. 
Like what I am!)


However, it seems that a more common hierarchy of accounts would be 
something like that shown in the Accounts png. Under Assets set up an 
account (commonly) called after the broker you use - marking it as a 
place holder. Then under that set up separate accounts for cash  and 
each of the shares you have (See the notes above as to Type etc). If, 
at some future point, you want to buy shares using "new money" do a 
Transfer from (typically) your bank account to the Cash sub account; 
similarly, selling shares and withdrawing the money is done by a 
transfer from Cash to the bank account.


There's a good write up of the procedure available at
https://code.gnucash.org/docs/C/gnucash-guide/invest-buy-stock1.html
which also deals with commission and taxes. It must be good, it set me 
right!


Best wishes
Eric

=======
On 10/08/2021 01:34, Jack Frillman via gnucash-user wrote:
I'm clueless on how to sell a security and use that money to buy 
another security. All I have done to date is reinvest interest & 
dividends.


I have an account structure that looks like this.

Parent Invest Account - This is for holding a cash balance.
   ABC - Invest account for ABC security.
   XYZ - Invest account for XYZ security.
   xxx - Many more investment accounts for xxx securities.

I'm selling all 100 shares of the security ABC.
I'm going to buy 50 shares of the security XYZ.
How should I do this?

I tried to transfer the cash from the selling of ABC to the Parent 
Investment Account then transfer the required amount of cash from the 
Parent Investment Account to XYZ account then buy those XYZ shares.  
But I got so confused I didn't know what was going on and deleted 
everything and started over trying it with a split transaction and 
OMG that was even worse.


Please advise.
Thanks.




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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Help Selling & Buying Securities

2021-08-09 Thread Jack Frillman via gnucash-user
I'm clueless on how to sell a security and use that money to buy another 
security. All I have done to date is reinvest interest & dividends.


I have an account structure that looks like this.

Parent Invest Account - This is for holding a cash balance.
   ABC - Invest account for ABC security.
   XYZ - Invest account for XYZ security.
   xxx - Many more investment accounts for xxx securities.

I'm selling all 100 shares of the security ABC.
I'm going to buy 50 shares of the security XYZ.
How should I do this?

I tried to transfer the cash from the selling of ABC to the Parent 
Investment Account then transfer the required amount of cash from the 
Parent Investment Account to XYZ account then buy those XYZ shares.  But 
I got so confused I didn't know what was going on and deleted everything 
and started over trying it with a split transaction and OMG that was 
even worse.


Please advise.
Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] No Suitable Backend Found

2021-07-28 Thread Jack Frillman via gnucash-user
I would not use MSWord or LibreOffice to look at it because those are 
word processors and not straight text editors.
One poorly placed fat finger could write formatting to the data file 
really messing it up.

Notepad is safer not sure about Wordpad.


On 7/28/21 12:30 PM, David Carlson wrote:

Adam,
the data files with the .gnucash suffix are a special form of text file
that can be read with your regular text editors such as wordpad, notepad or
an office editor like MSWord or LibreOffice.  GnuCash normally compresses
these files by default, so you may need to uncompress the files with your
favorite file compression program.

As Derek mentioned, recovered files must be on a different physical medium
than your unrecovered files.  You are running your OS and GnuCash from a
fresh copy on a different physical drive as well, I hope.

If any of those editor programs can display clear text and it looks like
transaction data rather than other information like window dimensions or
report settings  then you probably have  recovered your data.

On Wed, Jul 28, 2021 at 11:04 AM Derek Atkins  wrote:


Hi,

On Wed, July 28, 2021 11:57 am, Adam Hodnett wrote:

Maybe it is a metadata file... I do have many of the
.MMDDHHMMSS.gnucash files in the same directory as the
.gnucash file. They all give the same error. There are also

.txt

files with the same names.

I recovered the data with EaseUS Data Recovery. I am attempting to

recover

the same data with a different program at the moment, in case that's the
issue.

It is sounding like the recovery did not succeed.  If the backup failed to
recover even a single block of data it will cause the decompression to
fail.  Windows doesn't really have all the best tools to debug these kinds
of issues.


.gnucash files are all between 70kb and about 140kb.

Assuming you mean KB (KiloBytes) and not kb (kilobits), those files are
probably about the correct size if you don't have a ton of transactions.
My 15-year-old data file is 2.8 MB.

Note:  Backups only work if you copy the data to another storage system
off your main system.


Adam Hodnett
Videographer | Project Coordinator

-derek

--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Linux still at 4.5

2021-07-25 Thread Jack Frillman via gnucash-user




On 7/25/21 7:22 AM, Jean-David Beyer via gnucash-user wrote:

On 7/25/21 5:46 AM, Stephen C. Camidge wrote:

I am running Linux Manjaro and see that the aux distribution only gives version 
4.5 of Gnucash. There is a flatpack version of 4.6, but if I install it, I do 
not have my saved reports and only the default preference.

Where are the preferences stored? I would like to make them match what I have 
when using the aux version?

I am a newbie on Linux so need clear instructions.

Thank you.

I have had so many problems with the idiosyncratic file-system usage of
flatpack, that I have chosen to not use it for anything.


I have done the same thing for the same reasons. It's nice to know I'm 
not alone.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Large Negative Account Total

2021-06-08 Thread Jack Frillman via gnucash-user


I have been using GNC for a few months now for my personal finances and 
I'm trying to understand some it's behavior. I'm no accountant and I'm 
sure I'm not following strict accounting rules. Again I'm using it only 
for my personal finances and overall I am satisfied with what I have set 
up. So the only changes I would make from here on I would consider tweeks.


I have the following account structure:

Investment Misc
    Expenses
    Fees A
    Fees B
    Income
    Interest
    Dividends
    LT Gains
    ST Gains

The parent account "Investment Misc" is an expense account and is marked 
as a place holder account.
The sub accounts, "Expenses" and "Income", are expense or income 
accounts and it's obvious which is which. They are also marked as a 
place holder accounts.
So the only accounts that have any transactions are the sub accounts to 
the "Expenses" and "Income" accounts. The vast majority of the 
transactions are made as split transactions from other accounts. Note: 
Account names have been disguised in my example.


In my account tabs the "Investment Misc" parent account shows a negative 
amount. (-$70 K range)
All of these accounts go back to 2003 and have never been reconciled. 
(Stop your screaming please..)


Questions:
+ What can I do to get the large negative amount for the Investment Misc 
parent account not to be negative?
+ Does it figure into the NET Assets that appear on the bottom of the 
GNU main window?


A couple of things I thought about trying.
+ Changing the Investment Misc parent account to a bank account.
+ Reconciled the sub accounts.

I didn't what to go willy-nilly changing things in fear of really 
messing things up.


Hope this all made sense.
Thanks.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

2021-06-03 Thread Jack Frillman via gnucash-user
Maybe because for those new to GNC, like myself, it's not a very 
intuitive process and is easy to screw up.
After two months I still muck it up from time to time especially when 
I'm trying to modify a duplicated transaction that has splits.
I'm not complaining but providing an explanation to your "I don't see 
why we continue to beat upon this subject" comment.


On 6/3/21 11:11 AM, David T. via gnucash-user wrote:
Given how easy it is to correct these problems (i.e., change the 
Account in the erroneous entry from Imbalance-XXX to some other 
account and press enter), I don't see why we continue to beat upon 
this subject.


On 6/3/2021 10:12 AM, Adam Funk wrote:

On 2021-06-01, DaveC49 wrote:


Laura,

The reason Imbalance entries exist is that it is a fundamental 
principle in

double entry accounting that the sum of the debits and credits to the
various accounts that make up a transaction must be zero.

The Imbalance results if a user creates and saves a transaction in 
which
this is not true. GNuCash tries to force your hand on this. You will 
notice
that if you create a transaction in which the sum of the debits and 
credits
is not zero, GnuCash will open a new line with an amount which will 
balance
that sum with no account selected in the account column. If you 
select an
account to assign that imbalance to, then the transaction is then 
balanced.
If you do not and save the transaction without specifically 
assigning an
account to it, GnuCash will assign the amount by which the 
transaction is
unbalanced to an Imbalance account in the currency of the accounts. 
If the
transaction involves more than one currency it will be in the 
currency which

is imbalanced in the transaction.

The only problem I have is that it is far too easy (IMO, IME!) to
accidentally create or use Orphan-* and Imbalance-* accounts just by
hitting the tab key one time too many. I'd prefer to be able to set an
option to disable that and to force me to balance the transaction
before leaving it.

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNUCash & Macros

2021-05-26 Thread Jack Frillman via gnucash-user

That's would be trouble then it's worth.
If GNUCash doesn't have it built in it's no big deal

On 5/26/21 8:26 PM, w...@theprescotts.com wrote:

The "Script Editor" found in the Applications->Utilities folder under Mac OS 
has some capabilities that might help. You can tell it to track a series of actions that 
turn into a script that can be edited for refinements and then used as a 'Macro'.

Will

On 2021 May 26, at 05-26 17:56:16, Jack Frillman via gnucash-user 
 wrote:

Unfortunately that's a Windows app.
I'm OSX or Linux user.

On 5/26/21 12:04 PM, Fross, Michael wrote:

You could look into AutoHotkey.  I use it to automate other non-GNUCash things, 
but I don't see why it couldn't work, especially if you can do what you need to 
do via keystrokes.

Michael

On Wed, May 26, 2021 at 10:15 AM Derek Atkins mailto:de...@ihtfp.com>> wrote:

HI,

On Wed, May 26, 2021 11:09 am, Jack Frillman wrote:
> I have repetitive task I do every day and I would like to reduce the
> number of steps to do that task.
>
> More specifically I import stock/mutual fund and precious metal
prices
> from a CSV file. Currently I go through the multi-step process
the GUI
> walks you through. This is easy enough but I can be ultra lazy
at times
> and would like to execute that import process using a macro if
possible.

Thank you for explaining what you'd like to do. Unfortunately, no,
there
is no way to automate those processes in the UI.  The closest
thing you
can do is write some scripts (in Python) to do the work.

-derek

--Derek Atkins 617-623-3745
de...@ihtfp.com <mailto:de...@ihtfp.com> www.ihtfp.com
<http://www.ihtfp.com>
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNUCash & Macros

2021-05-26 Thread Jack Frillman via gnucash-user

Unfortunately that's a Windows app.
I'm OSX or Linux user.

On 5/26/21 12:04 PM, Fross, Michael wrote:
You could look into AutoHotkey.  I use it to automate other 
non-GNUCash things, but I don't see why it couldn't work, 
especially if you can do what you need to do via keystrokes.


Michael

On Wed, May 26, 2021 at 10:15 AM Derek Atkins > wrote:


HI,

On Wed, May 26, 2021 11:09 am, Jack Frillman wrote:
> I have repetitive task I do every day and I would like to reduce the
> number of steps to do that task.
>
> More specifically I import stock/mutual fund and precious metal
prices
> from a CSV file. Currently I go through the multi-step process
the GUI
> walks you through. This is easy enough but I can be ultra lazy
at times
> and would like to execute that import process using a macro if
possible.

Thank you for explaining what you'd like to do. Unfortunately, no,
there
is no way to automate those processes in the UI.  The closest
thing you
can do is write some scripts (in Python) to do the work.

-derek

-- 
       Derek Atkins                 617-623-3745

de...@ihtfp.com  www.ihtfp.com

       Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNUCash & Macros

2021-05-26 Thread Jack Frillman via gnucash-user

Okay, that's what I thought.
Thanks.

On 5/26/21 11:14 AM, Derek Atkins wrote:

HI,

On Wed, May 26, 2021 11:09 am, Jack Frillman wrote:

I have repetitive task I do every day and I would like to reduce the
number of steps to do that task.

More specifically I import stock/mutual fund and precious metal prices
from a CSV file. Currently I go through the multi-step process the GUI
walks you through. This is easy enough but I can be ultra lazy at times
and would like to execute that import process using a macro if possible.

Thank you for explaining what you'd like to do.  Unfortunately, no, there
is no way to automate those processes in the UI.  The closest thing you
can do is write some scripts (in Python) to do the work.

-derek



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GNUCash & Macros

2021-05-26 Thread Jack Frillman via gnucash-user
I have repetitive task I do every day and I would like to reduce the 
number of steps to do that task.


More specifically I import stock/mutual fund and precious metal prices 
from a CSV file. Currently I go through the multi-step process the GUI 
walks you through. This is easy enough but I can be ultra lazy at times 
and would like to execute that import process using a macro if possible.


On 5/26/21 11:02 AM, Derek Atkins wrote:

Hi,

On Wed, May 26, 2021 10:52 am, Jack Frillman via gnucash-user wrote:

Does GNUCash have a macro feature?

I searched the documentation and I didn't see anything so I'm asking
just to make sure I didn't missing something.

Could you go into a bit more details about what, exactly, you want to use
"macros" to do?


Thanks.
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] GNUCash & Macros

2021-05-26 Thread Jack Frillman via gnucash-user



Does GNUCash have a macro feature?

I searched the documentation and I didn't see anything so I'm asking 
just to make sure I didn't missing something.


Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] When Do Account Totals Update When Updating Prices

2021-05-21 Thread Jack Frillman via gnucash-user



Deva,
I found this in my junk folder and I have no idea why it ended up there 
and all the others GNC emails didn't.


Your suggestion of doing the refresh does in fact update the account 
totals like I wanted.


A belated thanks for the suggestion.

Jack

On 4/8/21 7:23 AM, Deva - wrote:

Jack,

I don't exactly have an answer to your question, but I find that such 
mysterious behaviour goes away sometimes when I do View->Refresh. For 
instance, when I am switching datafiles, sometimes the accounts page 
shows all totals as zero (I am on Ubuntu GNC 3.10). All totals 
reappear when I do the View->Refresh action. Hopefully, this will 
solve your problem as well.


If this doesn't work, I'm afraid I don't have much else to offer you.

Cheers,
Deva


-

From: Jack Frillman 
To: Gnucash Users 
Subject: [GNC] When Do Account Totals Update When Updating Prices
Message-ID: <8b17fa76-f11f-8408-f985-5093b129f...@me.com>
Content-Type: text/plain; charset=utf-8; format=flowed


I have an IRA account set up where the parent account is a Bank Account
and under that are a number of Stock and Mutual Funds accounts.
When I update the prices by importing a CSV file the total $ amount for
the parent (IRA Account) account does not always update right away.
Sometimes it take a while and I'm a bit confused on what's going on.

What triggers the account totals to update?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous



--



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Jack Frillman via gnucash-user
And I wrote a Python scripts and a BASH script that scrapes the prices 
off of the webpage and creates csv file.


On 5/17/21 5:28 PM, Robin Chattopadhyay wrote:

I have a Python script that I've created that takes in a CSV file and loads
the prices into Gnucash. I would be willing to share it; I know it works
with the SQLite backend, I haven't tested it with any other backend.

Robin

On Mon, May 17, 2021 at 6:59 AM mike823  wrote:


I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code
bellow in Gnucash::GnucashCli::start . Is another developer already working
on the same functionality?



 if (m_quotes_cmd)
 {
 if (*m_quotes_cmd != "get")
 {
 std::cerr << bl::format (bl::translate("Unknown quotes command
'{1}'")) % *m_quotes_cmd << "\n\n"
 << *m_opt_desc_display.get();
 return 1;
 }

 if (!m_file_to_load || m_file_to_load->empty())
 {
 std::cerr << bl::translate("Missing data file parameter") <<
"\n\n"
   << *m_opt_desc_display.get();
 return 1;
 }
 else
 return Gnucash::add_quotes (m_file_to_load);
 }




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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnucash won't load

2021-04-30 Thread Jack Frillman via gnucash-user
Also to test you can try to launch it from your desktop. Then if it 
works close it then drag it to your /Applications folder.

I always do that for something new.

On 4/30/21 8:34 AM, Derek Atkins wrote:

Hi,

On Fri, April 30, 2021 8:10 am, Neil Campbell wrote:

Hi Derek

Thank for your prompt reply. OK. So I uninstalled the Gnucash.app with
Clean My Mac, and, strangely it left the Icon in the Apps folder, so I
removed the Icon to the Bin. I then downloaded the app from the website
(clicked Apple Mac OS >- 10.13 High Sierra. In my Downloads is
Gnucash-Intel-4.5.dmg. Double clicked it and got



I dragged Gnucash.app to the Apps folder on Dock. And it still won’t load.
BUT just noticed in my Apps folder on Finder, it shows Gnucash.app as
being 2KB - yes that is 2 kilobytes. I can’t imagine what went wrong!

No, don't drag to the Dock.. Open up Finder and drag it to /Applications
Once it's in /Applications, THEN you can drag it to the Dock.


Thanks again for your help.

Neil
neilcam...@gmail.com

-derek



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Thinking about Moving to MacOS from Win 10

2021-04-26 Thread Jack Frillman via gnucash-user

Just copy the main data file.
I copy it from my iMac to my Linux laptop for a backup and to a Windows 
10  laptop for a backup to my Linux laptop.

Any reports you create will require copying a different file though.


On 4/26/21 12:26 PM, Ed Fields wrote:

Is there a means to port my gnuCash financial data files?

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual fund quotes in the U. S.

2021-04-24 Thread Jack Frillman via gnucash-user
It can get the prices for both stocks and mutual funds. The lookup is 
done by ticker symbol.


GNUC's csv price importer requires a date to be present in the csv file 
so I'm not sure what you are asking in your second question.


Below is a sample of a couple of lines from the csv file. It's has the 
bare minimum of information the csv price importer requires.


This is the format of each line:
TICKER,PRICE,TYPE,DATE,CURRENCY

ARSIX,15.73,Ray Jay,2021/04/22,USD
BAFGX,35.07,Ray Jay,2021/04/22,USD


On 4/24/21 2:11 AM, David Carlson wrote:

Jack,

Your scripts offer an opportunity to massage the data, if needed.  Out 
of curiosity, can you import both stock prices and mutual fund 
prices?  And can you keep the timestamps in your CSV files?


On Fri, Apr 23, 2021 at 8:55 PM Jack Frillman <mailto:jcf_m_li...@me.com>> wrote:


It may be doing what I'm doing and making the date of the closing
price as the day the script is run.

I don't run it using cron. I run it manually and if I forget a day
I don't worry about it.
I just run one of these two commands from the terminal.

getquotes -y    <--   gets the prices from Yahoo
..OR.
getquotes -m   <--   gets the prices from Market Watch

Then I import the resulting csv file that appears on my desktop.

I have two places to get the quotes so if one is unreachable for
some reason I have a backup source.


On 4/23/21 9:43 PM, David Carlson wrote:

I am not sufficiently comfortable with BASH, Chron jobs, etc to
be willing to set up an outside utility to do that.  I manually
download prices inside the GnuCash price database using Yahoo as
JSON as the source.  If I forget to do it in the late evening I
sometimes try to do it in the morning before the market opens as
I have several stock prices that I am also tracking.  That is how
I discovered the incorrect dates on the mutual funds prices,  I
am not sure if, for example, GnuCash downloads a stock price
during the day, does it replace it with a closing price if it
downloads again after the market closes.  I suspect it may not
even keep the timestamps that come with the prices, so there may
not be any clue about that.

On Fri, Apr 23, 2021 at 8:18 PM Jack Frillman via gnucash-user
mailto:gnucash-user@gnucash.org>> wrote:

I'm not sure what you are using to updated the your prices
but I wrote a
python script & a bash script that get the quotes and put
them into a
csv file for importing into GNUCash and I don't have that
date issue. I
run the scrips in the evening when the markets are closed.

On 4/23/21 8:59 PM, David Carlson wrote:
> I noticed recently that if I download mutual fund prices
after about 7 AM
> central daylight time the prices are saved in GnuCash with
todays date even
> though they are still yesterday's closing NAV until
sometime after the
> markets close.  To reliably get the correct price posted on
the correct
> date it seems that I must wait until after 7PM Central time
but before 7AM
> the following morning.
>
> I would like to suggest an enhancement that if GnuCash
downloads a United
> States mutual fund price with a morning time stamp that it
presume it to be
> yesterday's closing NAV price.  I would like comments from
others about
> this.
>

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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


-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous



--
David Carlson


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual fund quotes in the U. S.

2021-04-23 Thread Jack Frillman via gnucash-user
It may be doing what I'm doing and making the date of the closing price 
as the day the script is run.


I don't run it using cron. I run it manually and if I forget a day I 
don't worry about it.

I just run one of these two commands from the terminal.

getquotes -y    <--   gets the prices from Yahoo
..OR.
getquotes -m   <--   gets the prices from Market Watch

Then I import the resulting csv file that appears on my desktop.

I have two places to get the quotes so if one is unreachable for some 
reason I have a backup source.



On 4/23/21 9:43 PM, David Carlson wrote:
I am not sufficiently comfortable with BASH, Chron jobs, etc to be 
willing to set up an outside utility to do that.  I manually download 
prices inside the GnuCash price database using Yahoo as JSON as the 
source.  If I forget to do it in the late evening I sometimes try to 
do it in the morning before the market opens as I have several stock 
prices that I am also tracking.  That is how I discovered the 
incorrect dates on the mutual funds prices,  I am not sure if, for 
example, GnuCash downloads a stock price during the day, does it 
replace it with a closing price if it downloads again after the market 
closes. I suspect it may not even keep the timestamps that come with 
the prices, so there may not be any clue about that.


On Fri, Apr 23, 2021 at 8:18 PM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


I'm not sure what you are using to updated the your prices but I
wrote a
python script & a bash script that get the quotes and put them into a
csv file for importing into GNUCash and I don't have that date
issue. I
run the scrips in the evening when the markets are closed.

On 4/23/21 8:59 PM, David Carlson wrote:
> I noticed recently that if I download mutual fund prices after
about 7 AM
> central daylight time the prices are saved in GnuCash with
todays date even
> though they are still yesterday's closing NAV until sometime
after the
> markets close.  To reliably get the correct price posted on the
correct
> date it seems that I must wait until after 7PM Central time but
before 7AM
> the following morning.
>
> I would like to suggest an enhancement that if GnuCash downloads
a United
> States mutual fund price with a morning time stamp that it
presume it to be
> yesterday's closing NAV price.  I would like comments from
others about
> this.
>

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mutual fund quotes in the U. S.

2021-04-23 Thread Jack Frillman via gnucash-user
I'm not sure what you are using to updated the your prices but I wrote a 
python script & a bash script that get the quotes and put them into a 
csv file for importing into GNUCash and I don't have that date issue. I 
run the scrips in the evening when the markets are closed.


On 4/23/21 8:59 PM, David Carlson wrote:

I noticed recently that if I download mutual fund prices after about 7 AM
central daylight time the prices are saved in GnuCash with todays date even
though they are still yesterday's closing NAV until sometime after the
markets close.  To reliably get the correct price posted on the correct
date it seems that I must wait until after 7PM Central time but before 7AM
the following morning.

I would like to suggest an enhancement that if GnuCash downloads a United
States mutual fund price with a morning time stamp that it presume it to be
yesterday's closing NAV price.  I would like comments from others about
this.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Trying to download Gnucash data Files

2021-04-11 Thread Jack Frillman via gnucash-user

What OS are you using?
It makes a difference where you find them.

For the down loading if your OS is Linux you can easily copy the files 
to another computer using ssh.  That's what I do to back my data files 
and config files from my Mac to my Linux laptop.


On 4/11/21 12:33 PM, Jose A. Lorido III wrote:

To whomever may be able to help,

I have been using Gnucash for my business as well as my personal accounting
on the HDD drive of my laptop. A few weeks ago, my HDD was damaged and
unfortunately, I had not backed up any of my data for the previous 3 years.

I sent my damaged HDD to SalvageData and they were able to recover a number
of files, some of these belonging to the Gnucash program.

The question would be to anyone that may be able to help me is:

1) Which files/folders contain my data files (what would be the extensions
I should look for)?

and

2) How would I go about downloading them into my new SSD drive on my
laptop, or I could also download them to my desktop which also contains the
Gnucash program?

Any help or guidance would be greatly appreciated,

Thanks,

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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Tracking Precious Metals

2021-04-10 Thread Jack Frillman via gnucash-user

Good to know. Thanks.

On 4/9/21 7:57 PM, Kevin Reid wrote:
On Fri, Apr 9, 2021 at 4:33 PM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


Then how do you set it up since silver or gold doesn't have ticker
symbol?


In GnuCash, choose “Currency” as the “Type” (in account setup) or 
"Namespace" (in the price editor), and “XAG" (silver) or "XAU" (gold) 
as the "currency" — all the precious metals are given codes starting 
with "X".


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Tracking Precious Metals

2021-04-09 Thread Jack Frillman via gnucash-user

Then how do you set it up since silver or gold doesn't have ticker symbol?

On 4/9/21 4:47 PM, John Ralls wrote:



On Apr 9, 2021, at 1:36 PM, Jack Frillman via gnucash-user 
 wrote:


What's the best way of tracking the value of your silver and gold holdings in 
GNUCash?

I guess I would have a Asset account but what do you when the process of an oz. 
varies like a stock does?

You treat it just like a stock. 
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html

Regards,
John Ralls



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Tracking Precious Metals

2021-04-09 Thread Jack Frillman via gnucash-user



What's the best way of tracking the value of your silver and gold 
holdings in GNUCash?


I guess I would have a Asset account but what do you when the process of 
an oz. varies like a stock does?


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] When Do Account Totals Update When Updating Prices

2021-04-07 Thread Jack Frillman via gnucash-user

I'm referring to the totals you see in the Accounts Tab.

On 4/7/21 8:41 PM, David Carlson wrote:
Thank you for bringing to my attention the existence of this 
relatively new feature.  I have not tried it so we together await help 
from users more familiar with it.


I would imagine that the answer, however, depends on where you are 
looking to see the updated prices.  Since many reports have different 
ways of choosing the price source in their settings, the answer might 
be more complex if you are using reports.


On Wed, Apr 7, 2021 at 7:16 PM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:



I have an IRA account set up where the parent account is a Bank
Account
and under that are a number of Stock and Mutual Funds accounts.
When I update the prices by importing a CSV file the total $
amount for
the parent (IRA Account) account does not always update right away.
Sometimes it take a while and I'm a bit confused on what's going on.

What triggers the account totals to update?

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] When Do Account Totals Update When Updating Prices

2021-04-07 Thread Jack Frillman via gnucash-user



I have an IRA account set up where the parent account is a Bank Account 
and under that are a number of Stock and Mutual Funds accounts.
When I update the prices by importing a CSV file the total $ amount for 
the parent (IRA Account) account does not always update right away. 
Sometimes it take a while and I'm a bit confused on what's going on.


What triggers the account totals to update?

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-05 Thread Jack Frillman via gnucash-user
I agree. It's kind of what I originally did except I didn't know the 
Since Last Run action.
Not very elegant but it does get the job done so it's probable be they I 
do it from now on.

Thanks.

On 4/4/21 6:23 PM, Stephen M. Butler wrote:

You will have to do some manual work. This is how I would do it:
1.  Edit the scheduled transaction to Create 15 days in advance.
2.  Run the schedule transactions since last run to create the entry 
in the journal and update the scheduler so it knows that transaction 
was already created.

3.  Modify the date on the just created transaction.
4.  Edit the scheduled transaction to revert the Create Days in 
Advance to original value.


That, to me, is the least painful method to get the entry to show up 
so you can edit it AND update the scheduler so it knows it was already 
generated for this month.



On 4/4/21 2:44 PM, Jack Frillman via gnucash-user wrote:
I have a transaction scheduled for the 15th  of every month. Today 
something occurred where I want to make that transaction today, the 
4th, and have it count as if the transaction occurred on the 15th and 
the next scheduled transaction date is the following month without 
having to go thought the process of adjusting the schedule dates 
manually.


On 4/4/21 12:25 PM, Michael Hendry wrote:
On 4 Apr 2021, at 15:30, Jack Frillman via gnucash-user 
 wrote:


That's not what I was trying to do.
Is this scheduled transaction (Sx) the first of a series (A), or is 
it part of an existing series which is to be paid earlier than 
normal? (B)


If (A): create the Sx with the early start date, and adjust the Sx 
after that date has past.


If (B): duplicate last month’s (already created) transaction, and 
put in the desired date. Adjust the Sx so that its first payment 
will be next month.


If neither (A) nor (B) please explain what you are trying to do.

Regards,

Michael







--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-04 Thread Jack Frillman via gnucash-user

I understand.

In the program I switched from using there is an option to commit a 
future scheduled transaction immediately without making any adjustments 
to the calendar. Based on the responses it doesn't look like it can be 
done that easily with GNUCash. Which is okay. I'm just inquiring if its 
possible or not because I didn't see an obvious way of doing it.


As for your suggestion of volunteering to work on the project I may be 
interested in doing that when I complete my current project in next month.


I have been looking for a code writing project since retiring.
What's involved in getting set up?




On 4/4/21 12:49 PM, David Carlson wrote:

Jack,

You are not the first user that believes the Scheduled Transaction 
workflow could be improved.  Over the years there have been 
suggestions for minor improvements to reduce the average number of 
keystrokes to implement each transaction to radical changes to the 
entire process.


The existing process works.  If it ain't broke

There has been no significant change in the last decade, so we are 
waiting for a volunteer to step up with a good idea and the time to 
devote to the project.


If you have some time...

On Sun, Apr 4, 2021 at 11:26 AM Michael Hendry 
mailto:hendry.mich...@gmail.com>> wrote:


> On 4 Apr 2021, at 15:30, Jack Frillman via gnucash-user
mailto:gnucash-user@gnucash.org>> wrote:
>
> That's not what I was trying to do.

Is this scheduled transaction (Sx) the first of a series (A), or
is it part of an existing series which is to be paid earlier than
normal? (B)

If (A): create the Sx with the early start date, and adjust the Sx
after that date has past.

If (B): duplicate last month’s (already created) transaction, and
put in the desired date. Adjust the Sx so that its first payment
will be next month.

If neither (A) nor (B) please explain what you are trying to do.

Regards,

Michael
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-04 Thread Jack Frillman via gnucash-user
I have a transaction scheduled for the 15th  of every month. Today 
something occurred where I want to make that transaction today, the 4th, 
and have it count as if the transaction occurred on the 15th and the 
next scheduled transaction date is the following month without having to 
go thought the process of adjusting the schedule dates manually.


On 4/4/21 12:25 PM, Michael Hendry wrote:

On 4 Apr 2021, at 15:30, Jack Frillman via gnucash-user 
 wrote:

That's not what I was trying to do.

Is this scheduled transaction (Sx) the first of a series (A), or is it part of 
an existing series which is to be paid earlier than normal? (B)

If (A): create the Sx with the early start date, and adjust the Sx after that 
date has past.

If (B): duplicate last month’s (already created) transaction, and put in the 
desired date. Adjust the Sx so that its first payment will be next month.

If neither (A) nor (B) please explain what you are trying to do.

Regards,

Michael


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-04 Thread Jack Frillman via gnucash-user
That didn't work because the transaction I wanted to enter early is 
scheduled for the 15th it doesn't show up in Since Last Run list. If 
fact nothing is listed when I run the Since Last Run.


On 4/4/21 3:09 PM, Vincent Fu wrote:

The way I would do this is:

1) Click on Actions->Scheduled Transactions->Since Last Run
2) Change the "Status" column for your transaction from "Reminder" to 
"To-Create"
3) Check the "Review created transactions" checkbox at the bottom of 
the window

4) Click on OK
5) Adjust the date in the new tab for the newly created scheduled 
transaction(s)


Hope this helps.

On 4/4/21 8:29 AM, Jack Frillman via gnucash-user wrote:


I have a scheduled transaction for the 15th of each month.
This month and only this one time I want to make it before it's 
scheduled date of the 15th.

How can easily I do that?

The only way I could see how to do it was going into the scheduled 
transactions options, adjusting the day ahead value, exit GNUCash, 
restart and change the day ahead value back to zero.


Thanks.



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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-04 Thread Jack Frillman via gnucash-user

That's not what I was trying to do.

On 4/4/21 9:24 AM, Glenn Fowler wrote:

I can think of two ways.
You can just leave it for the 15th and then after this month posts 
just manually edit to the desired date.
You can also start the scheduled transactions next month and do a 
manual entry this month.


On Sun, Apr 4, 2021, 8:29 AM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:



I have a scheduled transaction for the 15th of each month.
This month and only this one time I want to make it before it's
scheduled date of the 15th.
How can easily I do that?

The only way I could see how to do it was going into the scheduled
transactions options, adjusting the day ahead value, exit GNUCash,
restart and change the day ahead value back to zero.

Thanks.

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-04 Thread Jack Frillman via gnucash-user



On 4/4/21 8:54 AM, David Carlson wrote:
There are a couple of ways.  One is to set the Scheduled Transaction 
to Remind you several days early.   Then it will remind you as 
scheduled until you actually go through the Since Last Run list and 
convert the Reminder to To-Create.


That's essentially what I did and that's not what I want to do. If I 
have to go through that I might as well enter it manually.
I was look for doing something like double clicking on the scheduled 
transaction and having it commit right away.






It is not necessary to re-start GnuCaash to trigger the Since Last Run 
action.  Simply click Actions > Scheduled Transactions > Since Last 
Run...and the SLR assistant runs..


If you want to make another change to the settings, then click Actions 
> Scheduled Transaction Editor just above to make the change.



On Sun, Apr 4, 2021 at 7:30 AM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:



I have a scheduled transaction for the 15th of each month.
This month and only this one time I want to make it before it's
scheduled date of the 15th.
How can easily I do that?

The only way I could see how to do it was going into the scheduled
transactions options, adjusting the day ahead value, exit GNUCash,
restart and change the day ahead value back to zero.

Thanks.

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Entering A Scheduled Transaction Early

2021-04-04 Thread Jack Frillman via gnucash-user



I have a scheduled transaction for the 15th of each month.
This month and only this one time I want to make it before it's 
scheduled date of the 15th.

How can easily I do that?

The only way I could see how to do it was going into the scheduled 
transactions options, adjusting the day ahead value, exit GNUCash, 
restart and change the day ahead value back to zero.


Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-31 Thread Jack Frillman via gnucash-user




The tax part I've already covered. But I record the tips separately 
too. I've used this to great effect to refine my budgeting for dining 
dollars. Some may think it is overkill, but it helped me get it under 
control. It worked for me, but others may not need it.




Exactly.
I have been able to cut costs in several areas over the years by doing 
just this.




Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-31 Thread Jack Frillman via gnucash-user
I track it every time it's broken out on the receipt. The sales tax is 
the cost of Government not the cost of the item purchased.

To each his own.

On 3/31/21 12:33 PM, Stan Brown wrote:

On 2021-03-30 20:22, Jack Frillman via gnucash-user wrote:

Doesn't everyone track their sales tax as a separate expense item? Why
would you consider sales tax the same type of an expenditure as
groceries, gasoline or your electric bill?

As far as I'm concerned, taxes are part of the purchase price. Sometimes
they are disclosed, other times not. If they're not disclosed, then
obviously I can't account for them separately. When they are disclosed,
I suppose I could account for them separately; but that would create an
inconsistency in how I accounted for different categories of expenses
and assets.

For instance, in the US there are State and Federal excise taxes on
gasoline. But the price on the pump includes that excise tax amount; it
is what we actually pay. It would seem absurd to me to ferret out the
tax amounts and account for them separately.

I states that have a sales tax, my restaurant bill consists of the price
shown on the menu, the sales tax on that amount, and whatever gratuity I
choose to add. The sales tax is de jure part of the cost of my dinner;
the gratuity is de facto part of the cost because of longstanding
custom. Even though these are stated separately, it would seem absurd to
me to account for them separately.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] recording reinvested earnings

2021-03-30 Thread Jack Frillman via gnucash-user
I have been going through that and working through most of the questions 
I have had to date.
BTW Chapter 9 is about investments and I have that pretty much under 
control. I have even been able to semi automate the updating of my 
security prices with out having to go through Alpha Vantage or what ever 
it's called.


On 3/30/21 10:56 PM, David Carlson wrote:

Read the tutorial and Concepts guide, paying close attention to Chapter 9
and particularly to <
https://www.gnucash.org/viewdoc.phtml?rev=4=C=guide>

On Tue, Mar 30, 2021 at 9:46 PM Peter Parsons  wrote:


Is there a convenient way of recording dividend/interest income that is
reinvested in additional securities?( I could, of course, record an
imputed income-in transaction offset by an investment-out transaction)
Thanks
Peter Parsons

Sent from Mail for
Windows 10

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





--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user

I do know the difference between credit and a debt.

Doesn't everyone track their sales tax as a separate expense item? Why 
would you consider sales tax the same type of an expenditure as 
groceries, gasoline or your electric bill?


When I say a split 1 and split 2 I'm referring to  each separate item in 
a split transaction


I buy a pair of socks for $5 and a hammer for $10 and sales tax of $0.24 
for a total $15.24.

There's a split transaction that comprises of three items:
Socks  $5.00  makes an enter into the clothing account <- that's 
what I call split 1
Hammer $10.00 makes an entry into the tools account <-- that's what 
I call split 2
Sales tax $0.24 makes an entry into the state sales tax account <- 
that's what I call split 3


Maybe that's not the correct accounting term but then again I'm not an 
accountant. I'm just trying to track where I spend my money.



On 3/30/21 9:47 PM, Michael or Penny Novack wrote:

I'm going to break into bits as there are several things here


What's confusing me is that I was not forgetting to add any 
transactions in the split. GNUCash kept doubling the amount of the 
total and subtracting all my split transactions from that doubled 
total it invented and adding the difference to the Unbalanced-USD. I 
eventually figured out how to do it after much trial and error. Then 
when I got to this refund and tried to enter the splits it started 
doubling the total of the transaction again. I still don't understand 
why it does that.


1) It really would help if you knew what a journal entry looked like 
when bookkeeping was done pen and ink on paper. Because that is the 
"view" you are in, what the transaction entry would look like in the 
journal.


2) It would help if you knew debit from credit. Here the user friendly 
labels might not be your friend because they are account sensitive 
(change with account type) but when you are entering a split, just 
left/right   debit/credit   What is causing the behavior you find 
mysterious (what you see as doubling is because you still see the line 
you originally entered before you hit "split". THAT line is now (also) 
appearing in the "journal view" of the transaction that hitting 
"split" has opened for you.



The software I was using before handled the split transactions by 
adding each split to it's own account like GNUCash but the method of 
entry was more intuitive. You enter split 1 with it's associated 
account, then split 2 with it's associated account, then split 3 with 
it's associated account, hit enter and you have your total. With 
GNUCash I have to first enter the total amount* then enter split 1 
with it's associated account, then split 2 with it's associated 
account, then split 3 with it's associated account, close the split 
then hit enter. If I get one thing wrong it will invent an extra 
amount and add that to the Unbalanced-USD account. When that happens 
I delete the thing and start over.


Practice splits. I am not QUITE sure what you mean by "split1", 
"split2" etc. You are presumably entering ONE split transaction, 
meaning a transaction that has more than just one debit and one 
credit. Essentially gnucash is providing a short cut method of 
entering transactions where only one of each. The "journal view" entry 
of a transaction is how ALL transactions used to be entered in the 
days before computer assisted accounting.




Most of my transactions are split transactions because I even when 
purchase only one item there is also the sales tax which is it's own 
split transaction. 


Fair enough, but that's not a gnucash matter. I assume there is a good 
reason for you to be tracking sales tax expense separately from the 
ordinary expense of whatever was purchased. But again, use of the term 
"split". Say I write a check for $105 to buy a widget costing $100 and 
there was $5 sales tax on this purchase. That is ONE transaction, 
credit checking $105, debit widgets $100 and sales tax $5    Because 
more than one debit and one credit, can't use shortcut entry method 
but have to use "split" mode, or as I said "journal entry mode". 
There  are three LINES to this entry (one credit line and two debit 
lines) to this "split" transaction. The only reason you don't see two 
lines when entering a transaction that has exactly one debit and one 
credit is that you can use the shortcut method instead of "journal 
view" << but you COULD ask gnucash  to show you all transactions 
"journal view" --- go to some account. Look on the toolbar, "file" 
.."View"... and click on view to see your view options. TRY 
"journal view". Does what you see when you enter a "split" make any 
more sense


Michael D Novack

* PS -- that is with a ONE SIDED split and starting with the largest 
amount. If the transaction is split on both sides, more than one debt 
and more than one credit the amount for no account is going to be the 
"total" << although starting by "lying", starting with the total as 
the amount 

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user

Yes it's set to single line.
When I switched to Transaction Journal it just opened all the split 
transactions instead of me opening them individually with the SPLIT 
button up in the tool bar.
I have just been hitting the SPLIT butt up in the tool bar when I wanted 
to enter a split transaction. Doing the Auto-split it saw something that 
I may have been missing before.


On 3/30/21 9:40 PM, David Carlson wrote:

Jack,

If you happen to have the register display set to single line instead 
of double line or worse, set to basic ledger, you can find yourself 
getting lost just trying to make "missing" split lines appear.  I 
recommend setting the register view to Auto-split ledger or 
transaction journal and check the double line box until you are 
comfortable with the way the display works.


On Tue, Mar 30, 2021, 7:37 PM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


At first I was doing that.


On 3/30/21 4:37 PM, Derek Atkins wrote:
> I bet you hit the enter key...  That causes the transaction to
commit.
> You should use the arrow keys or tab keys to move around the
multi-split
> transaction until you're done.
>
> -derek
>
> On Tue, March 30, 2021 4:06 pm, Jack Frillman via gnucash-user
wrote:
>> I tried adding the minus sign and I still got the
Unbalanced-USD thing
>> but that doesn't I was doing it correctly.
>> Entering these split transactions had been the biggest issue I have
>> encountered switching to GNUCash.
>>
>> On 3/30/21 3:37 PM, Maf. King wrote:
>>> Purchased in error, rather than data-entry error.  ;-)
>>>
>>> I will note another possible way to flip the columns - just
put a - sign
>>> in
>>> before the value, then on tabbing-out of the column it will
flip to the
>>> other
    >>> side (and lose the minus sign!).
>>>
>>> Maf.
>>>
>>> On Tuesday, 30 March 2021 20:16:17 BST Jack Frillman via
gnucash-user
>>> wrote:
>>>> In the world I worked in before retiring there can be
different kinds
>>>> of
>>>> errors and they are often handled differently. That may not
apply in
>>>> accounting but it's my old habits and instincts kicking in.
>>>> So, I don't consider a refund an error but a kind normal
    transaction.
    >>>> An error has a completely different meaning to me.
>>>>
>>>> On 3/30/21 2:04 PM, David Carlson wrote:
>>>>> Is one kind of error different from others?
>>>>>
>>>>> On Tue, Mar 30, 2021 at 12:08 PM Jack Frillman via gnucash-user
>>>>>
>>>>> mailto:gnucash-user@gnucash.org>
<mailto:gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>>> wrote:
>>>>>       I never considered that option since the GNUCash
documentation
>>>>>       describes
>>>>>       it for correcting errors.
>>>>>
>>>>>       On 3/30/21 12:49 PM, Robin Chattopadhyay wrote:
>>>>>       > There’s another, even easier IMO, option to select
the Reverse
>>>>>
>>>>>       Transaction
    >>>>>
>>>>>       > option. That will duplicate the transaction and flip the
>>>>> amounts
>>>>>
>>>>>       at the
>>>>>
>>>>>       > same time.
>>>>>       >
>>>>>       > Robin
>>>>>       >
>>>>>       > On Tue, Mar 30, 2021 at 10:57 AM Cam Ellison
mailto:c...@ellisonet.ca>
>>>>>
>>>>>       <mailto:c...@ellisonet.ca <mailto:c...@ellisonet.ca>>>
wrote:
>>>>>       >> On 2021-03-30 8:43 a.m., Jack Frillman via
gnucash-user wrote:
>>>>>       >>> I'm trying to enter a refund split transaction to
a credit
>>>>> card
>>>>>       >>> account and every time I do I get an Imbalance-USD
amount.
>>>>>
>>>>>       (see screen
>>>>>
>>>>>       >>> shots below)
>>>>>       >>> Why is this happening?
>>>>>       >>
>>>>>       >> Screenshots don't work.
>>>>>       >>
>>>>>       >

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user

At first I was doing that.


On 3/30/21 4:37 PM, Derek Atkins wrote:

I bet you hit the enter key...  That causes the transaction to commit.
You should use the arrow keys or tab keys to move around the multi-split
transaction until you're done.

-derek

On Tue, March 30, 2021 4:06 pm, Jack Frillman via gnucash-user wrote:

I tried adding the minus sign and I still got the Unbalanced-USD thing
but that doesn't I was doing it correctly.
Entering these split transactions had been the biggest issue I have
encountered switching to GNUCash.

On 3/30/21 3:37 PM, Maf. King wrote:

Purchased in error, rather than data-entry error.  ;-)

I will note another possible way to flip the columns - just put a - sign
in
before the value, then on tabbing-out of the column it will flip to the
other
side (and lose the minus sign!).

Maf.

On Tuesday, 30 March 2021 20:16:17 BST Jack Frillman via gnucash-user
wrote:

In the world I worked in before retiring there can be different kinds
of
errors and they are often handled differently. That may not apply in
accounting but it's my old habits and instincts kicking in.
So, I don't consider a refund an error but a kind normal transaction.
An error has a completely different meaning to me.

On 3/30/21 2:04 PM, David Carlson wrote:

Is one kind of error different from others?

On Tue, Mar 30, 2021 at 12:08 PM Jack Frillman via gnucash-user

mailto:gnucash-user@gnucash.org>> wrote:
  I never considered that option since the GNUCash documentation
  describes
  it for correcting errors.

  On 3/30/21 12:49 PM, Robin Chattopadhyay wrote:
  > There’s another, even easier IMO, option to select the Reverse

  Transaction

  > option. That will duplicate the transaction and flip the
amounts

  at the

  > same time.
  >
  > Robin
  >
  > On Tue, Mar 30, 2021 at 10:57 AM Cam Ellison mailto:c...@ellisonet.ca>> wrote:
  >> On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:
  >>> I'm trying to enter a refund split transaction to a credit
card
  >>> account and every time I do I get an Imbalance-USD amount.

  (see screen

  >>> shots below)
  >>> Why is this happening?
  >>
  >> Screenshots don't work.
  >>
  >> Easiest way for me to do the reversal is to duplicate the

  transaction

  >> and then cut-and-paste each amount from one side of the

  register to the

  >> other. Don't use . If you use arrow keys or  to

  move between

  >> fields nothing will change, but the imbalance will show at the

  bottom -

  >> with no account assigned.
  >>
  >> HTH
  >>
  >> Cam
  >>
  >>
  >> ___
  >> gnucash-user mailing list
  >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
  >> To update your subscription preferences or to unsubscribe:
  >> https://lists.gnucash.org/mailman/listinfo/gnucash-user

  <https://lists.gnucash.org/mailman/listinfo/gnucash-user>

  >> If you are using Nabble or Gmane, please see
  >> https://wiki.gnucash.org/wiki/Mailing_Lists

  <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 <mailto:gnucash-user@gnucash.org>
  To update your subscription preferences or to unsubscribe:
  https://lists.gnucash.org/mailman/listinfo/gnucash-user
  <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
  If you are using Nabble or Gmane, please see
  https://wiki.gnucash.org/wiki/Mailing_Lists
  <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.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listin

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user

Thanks for the advice.

What's confusing me is that I was not forgetting to add any transactions 
in the split. GNUCash kept doubling the amount of the total and 
subtracting all my split transactions from that doubled total it 
invented and adding the difference to the Unbalanced-USD. I eventually 
figured out how to do it after much trial and error. Then when I got to 
this refund and tried to enter the splits it started doubling the total 
of the transaction again. I still don't understand why it does that.
The software I was using before handled the split transactions by adding 
each split to it's own account like GNUCash but the method of entry was 
more intuitive. You enter split 1 with it's associated account, then 
split 2 with it's associated account, then split 3 with it's associated 
account, hit enter and you have your total. With GNUCash I have to first 
enter the total amount then enter split 1 with it's associated account, 
then split 2 with it's associated account, then split 3 with it's 
associated account, close the split then hit enter. If I get one thing 
wrong it will invent an extra amount and add that to the Unbalanced-USD 
account. When that happens I delete the thing and start over.


Most of my transactions are split transactions because I even when 
purchase only one item there is also the sales tax which is it's own 
split transaction.


On 3/30/21 5:35 PM, Michael or Penny Novack wrote:

On 3/30/2021 4:06 PM, Jack Frillman via gnucash-user wrote:
I tried adding the minus sign and I still got the Unbalanced-USD 
thing but that doesn't I was doing it correctly.
Entering these split transactions had been the biggest issue I have 
encountered switching to GNUCash. 



Amounts ending up in the (special) Imbalance account mean you 
accidentally forgot to specify an account. Gnucash let you enter the 
transaction (instead of stopping you because not in balance). There 
are pros and cons about that. While gnucash will allow you to create 
an account on the fly (the reason you didn't specify an account might 
be that the proper account for this does not yet exist) I kind of like 
what gnucash does here. Often when I see the need fore that new 
account I realize that it's not going to be simply adding a new 
account but now dividing an existing one or something similar, a lot 
more work that I don;t want to do in the middle of dealing with a 
stack of transactions.


Splits --- this isn't a gnucash thing per se. In standard double entry 
bookkeeping there will always be at least two accounts involved with a 
transaction but there could be a lot more. This is one case where what 
gnucash does in having you enter transactions directly into one of the 
affected accounts (virtual journal) can get trickier than the other 
way around, enter into the journal and automatic post. But again, 
since MOST transactions are not splits (most affect only two 
accounts), this was a sensible choice the developers made. What you do 
most of the time should be quick/easy.


Which means you will need to learn how to do splits. I suggest you 
begin JUST with one sided splits (there is one debit, the credit side 
is split or one credit, the debit side is split. For these you begin 
entering the transaction in the account on the side that is not split. 
Only when you have gotten good at this attempt a two sided split.


PRACTICE -- remember that gnucash can maintain several sets of books 
for you. While a beginner with gnucash, or later when learning a new 
feature (when you are a beginner, it's all new) you can have a set of 
books named "test". This should be a fairly simple set of books, not a 
great many accounts or transactions in each account. Just enough for 
you to try things out. Like practicing entering split transactions. I 
will give you one hint for two way splits. LIE! It is a useful trick 
by entering a WRONG AMOUNT when starting the transaction. If you enter 
an amount a little too large, when you enter split mode, you can 
change that to the correct value and it will still leave you with an 
amount on that side of the transaction. For example, you can now 
change that amount to what will be correct for the other account on 
that side. I'll stop there, since if you have gotten this far you'll 
be able to figure out for yourself what to do if more accounts on that 
side.



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.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
gnucash-user mailing list
gnucash-user@g

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user
I tried adding the minus sign and I still got the Unbalanced-USD thing 
but that doesn't I was doing it correctly.
Entering these split transactions had been the biggest issue I have 
encountered switching to GNUCash.


On 3/30/21 3:37 PM, Maf. King wrote:

Purchased in error, rather than data-entry error.  ;-)

I will note another possible way to flip the columns - just put a - sign in
before the value, then on tabbing-out of the column it will flip to the other
side (and lose the minus sign!).

Maf.

On Tuesday, 30 March 2021 20:16:17 BST Jack Frillman via gnucash-user wrote:

In the world I worked in before retiring there can be different kinds of
errors and they are often handled differently. That may not apply in
accounting but it's my old habits and instincts kicking in.
So, I don't consider a refund an error but a kind normal transaction.
An error has a completely different meaning to me.

On 3/30/21 2:04 PM, David Carlson wrote:

Is one kind of error different from others?

On Tue, Mar 30, 2021 at 12:08 PM Jack Frillman via gnucash-user

mailto:gnucash-user@gnucash.org>> wrote:
 I never considered that option since the GNUCash documentation
 describes
 it for correcting errors.
 
 On 3/30/21 12:49 PM, Robin Chattopadhyay wrote:

 > There’s another, even easier IMO, option to select the Reverse
 
 Transaction
 
 > option. That will duplicate the transaction and flip the amounts
 
 at the
 
 > same time.

 >
 > Robin
 >
 > On Tue, Mar 30, 2021 at 10:57 AM Cam Ellison  
 <mailto:c...@ellisonet.ca>> wrote:

     >> On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:
 >>> I'm trying to enter a refund split transaction to a credit card
 >>> account and every time I do I get an Imbalance-USD amount.
 
 (see screen
 
 >>> shots below)

 >>> Why is this happening?
 >>
 >> Screenshots don't work.
 >>
 >> Easiest way for me to do the reversal is to duplicate the
 
 transaction
 
 >> and then cut-and-paste each amount from one side of the
 
 register to the
 
 >> other. Don't use . If you use arrow keys or  to
 
 move between
 
 >> fields nothing will change, but the imbalance will show at the
 
 bottom -
 
 >> with no account assigned.

 >>
 >> HTH
 >>
 >> Cam
 >>
 >>
 >> ___
 >> gnucash-user mailing list
 >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
 >> To update your subscription preferences or to unsubscribe:
 >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
 
 <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
 
 >> If you are using Nabble or Gmane, please see

 >> https://wiki.gnucash.org/wiki/Mailing_Lists
 
 <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 <mailto:gnucash-user@gnucash.org>
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
 If you are using Nabble or Gmane, please see
 https://wiki.gnucash.org/wiki/Mailing_Lists
 <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.


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user


In the world I worked in before retiring there can be different kinds of 
errors and they are often handled differently. That may not apply in 
accounting but it's my old habits and instincts kicking in.
So, I don't consider a refund an error but a kind normal transaction.  
An error has a completely different meaning to me.



On 3/30/21 2:04 PM, David Carlson wrote:

Is one kind of error different from others?

On Tue, Mar 30, 2021 at 12:08 PM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


I never considered that option since the GNUCash documentation
describes
it for correcting errors.

On 3/30/21 12:49 PM, Robin Chattopadhyay wrote:
> There’s another, even easier IMO, option to select the Reverse
Transaction
> option. That will duplicate the transaction and flip the amounts
at the
> same time.
>
> Robin
>
> On Tue, Mar 30, 2021 at 10:57 AM Cam Ellison mailto:c...@ellisonet.ca>> wrote:
>
    >> On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:
>>> I'm trying to enter a refund split transaction to a credit card
>>> account and every time I do I get an Imbalance-USD amount.
(see screen
>>> shots below)
>>> Why is this happening?
>>
>> Screenshots don't work.
>>
>> Easiest way for me to do the reversal is to duplicate the
transaction
>> and then cut-and-paste each amount from one side of the
register to the
>> other. Don't use . If you use arrow keys or  to
move between
>> fields nothing will change, but the imbalance will show at the
bottom -
>> with no account assigned.
>>
>> HTH
>>
>> Cam
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists
<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.
>>

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user
I never considered that option since the GNUCash documentation describes 
it for correcting errors.


On 3/30/21 12:49 PM, Robin Chattopadhyay wrote:

There’s another, even easier IMO, option to select the Reverse Transaction
option. That will duplicate the transaction and flip the amounts at the
same time.

Robin

On Tue, Mar 30, 2021 at 10:57 AM Cam Ellison  wrote:


On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:

I'm trying to enter a refund split transaction to a credit card
account and every time I do I get an Imbalance-USD amount. (see screen
shots below)
Why is this happening?


Screenshots don't work.

Easiest way for me to do the reversal is to duplicate the transaction
and then cut-and-paste each amount from one side of the register to the
other. Don't use . If you use arrow keys or  to move between
fields nothing will change, but the imbalance will show at the bottom -
with no account assigned.

HTH

Cam


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



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user

Looks like I finally got it to work.
While copying I had to delete the amount from the column I was copying 
from before pasting that value into the other column.


Thanks for the tip.

On 3/30/21 11:57 AM, Cam Ellison wrote:

On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote:


I'm trying to enter a refund split transaction to a credit card 
account and every time I do I get an Imbalance-USD amount. (see 
screen shots below)
Why is this happening? 



Screenshots don't work.

Easiest way for me to do the reversal is to duplicate the transaction 
and then cut-and-paste each amount from one side of the register to 
the other. Don't use . If you use arrow keys or  to move 
between fields nothing will change, but the imbalance will show at the 
bottom - with no account assigned.


HTH

Cam


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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Jack Frillman via gnucash-user



I'm trying to enter a refund split transaction to a credit card account 
and every time I do I get an Imbalance-USD amount. (see screen shots below)

Why is this happening?


Refund


Original Charge


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Report Printing

2021-03-26 Thread Jack Frillman via gnucash-user
I use GNUCash on Mac OSX 10.14 and I print by saving to a PDF file and 
then send the PDF to the printer.



On 3/26/21 3:05 PM, Tommy Trussell wrote:

On Fri, Mar 26, 2021 at 1:23 PM ZPBear  wrote:


Hello,My wife Jennifer has been using GnuCash for several years.Printing
reports has never worked.I installed 4.4 today and still no good.The title
shows 2020 (for the current tax year).When I choose Report / Account
Summary the report opens with zero values and a 2019 title.Please explain
why this is happening.


I never use that report myself, but I just opened it on this computer and
it looks like the default is for it to show transactions to the date you
have defined for the accounting period. I don't know why it would have 2019
as any sort of option, but you CAN use the report options to change the
date (look for Options on the toolbar, or Edit --> Report Options).

You also said "Printing reports has never worked" and that's a separate
issue. I don't know the current state of Windows versions of GnuCash, but
it could be that you will need to copy the report elsewhere, or print a PDF
version of the report first and print from there. On linux, whenever I go
to print I get to choose Print to File or Print to LPR (for the Flatpak
version of GnuCash). I don't think the LPR printer definition works, but I
haven't tried; since switching to Flatpak I always print to PDF first.

Please let us know (by copying the list) whether any of these comments are
helpful.



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


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Representation Of Negative Balances

2021-03-23 Thread Jack Frillman via gnucash-user


I just finished setting up GNUCash on a Windows 10 machine and it shows 
negative balances with ()'s like this -->  (2.23).

On my Linux or Mac it's displayed using a minus sign like this -->  -2.23 .

What preferences control this? I can't find it anywhere.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Investment Portfolio Report + Parent Cash Amount

2021-03-23 Thread Jack Frillman via gnucash-user
Not sure I follow you. I'm not looking to restructure anything just to 
consolidate information onto one report.


On 3/22/21 10:58 PM, Robin Chattopadhyay wrote:
You can simply create a generic asset account and set the commodity to 
US Dollars (since it's an IRA). It would have the same parent as the 
other securities. I name those accounts "Cash/Cash Equivalents" in my 
setup.


If the cash is invested in a money market mutual fund, you could also 
set the commodity to that asset as well.


On Mon, Mar 22, 2021 at 8:08 PM Jack Frillman via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:



I'm looking for a report that will give me the value of securities in
addition to the cash amount of their parent account.

For example if I have the following account structure:

IRA Account
    Security #1
    Security #2
    Security #3
    Security #4

The "IRA account" has a cash amount of x dollars.
When I run a Reports-->Assets & Liabilities --> Investment Portfolio
report it gives the details and totals for the four securities
under the
"IRA Account" but not the cash amount in the parent "IRA Account"
even
if I try to select it in the report options.
I'm trying to get this same report type of but with the cash
amount of
the parent account "IRA Account" included.

Any ideas how this can be done?

Thanks.

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Investment Portfolio Report + Parent Cash Amount

2021-03-22 Thread Jack Frillman via gnucash-user


I'm looking for a report that will give me the value of securities in 
addition to the cash amount of their parent account.


For example if I have the following account structure:

IRA Account
   Security #1
   Security #2
   Security #3
   Security #4

The "IRA account" has a cash amount of x dollars.
When I run a Reports-->Assets & Liabilities --> Investment Portfolio 
report it gives the details and totals for the four securities under the 
"IRA Account" but not the cash amount in the parent "IRA Account" even 
if I try to select it in the report options.
I'm trying to get this same report type of but with the cash amount of 
the parent account "IRA Account" included.


Any ideas how this can be done?

Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] namespaces vs import prices

2021-03-22 Thread Jack Frillman via gnucash-user
Yes there is a way of doing it in Version 4.4. I just did the same thing 
so I could put all my securities from my past 401K into a namespace I 
called STALE. I did that because I wasn't ever going to do anything with 
them again and I wanted them out of the way.


To move one security from one namespace to another namespace.
Bring up the Security Editor*Tools-->Security Editor*. This will bring 
up the *Securities* window.
In the *Securities *window select the security you want to move and hit 
the *EDIT* button. This will bring up the *Edit Security* tool.
The fourth item down is a drop-down list labeled *TYPE.* Select the one 
you want to put the selected security under then hit *OK*.


But first if you don't already have a namespace you want to move a 
security to, in your case *MISC*, you're going to have create one. This 
is how to do it.


When adding a new security *Tools -> Security Editor -> Add*, there is a 
drop-down to select the namespace labelled "Type". This field is also an 
input box, and the value for a new namespace can be typed into the field 
while creating the new security. When the security is added, a new 
namespace will appear on the list of *"*Types*"* in the future.


When I did this a created a temporary security called zxzx so I could 
created the new namespace. After I move a real security to it I then 
removed zxzx.


I think the namespace is there so you can categorize you securities. 
That can be very helpful when setting prices so a given security is 
easier to find.


Hope this helps.

Jack


On 3/21/21 10:09 PM, Steven Anter wrote:

The newer releases of gnucash now require a namespace to import prices from
a csv file.  This is rather cumbersome because my securities are spread out
over a few namespaces.   The notion of  "namespace" is irrelevant to the
way I use gnucash; if I could bypass I would.  Perhaps there is a way I can
change all securities to have the same namespace of "MISC"   If there is,
please let me know


On Sun, Mar 21, 2021 at 7:40 AM  wrote:


Send gnucash-user mailing list submissions to
 gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
 gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
 gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

1. Re:  Had to download application again (David Ridell)
2. Re:  CSV matching produces duplicates? (David Cousens)
3.  mortgage refinance (Parker Graham)
4. Re:  mortgage refinance (py...@cox.net)
5. Re:  mortgage refinance (Parker Graham)
6. Re:  mortgage refinance (D)
7. Re:  mortgage refinance (Peter West)
8. Re:  mortgage refinance (Derek Atkins)
9. Re:  mortgage refinance (Derek Atkins)
   10. Re:  mortgage refinance (Peter West)
   11. Re:  mortgage refinance (py...@cox.net)


--

Message: 1
Date: Fri, 19 Mar 2021 12:57:19 -0400
From: David Ridell 
To: John Ralls 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Had to download application again
Message-ID: <19e7dc05-6e5c-4e23-9cc5-fb238f5fe...@aol.com>
Content-Type: text/plain; charset=utf-8

Thank you!

David

Sent from my iPhone


On Mar 19, 2021, at 12:30 PM, John Ralls  wrote:

?


On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user <

gnucash-user@gnucash.org> wrote:

I had to reboot my MacBook Air. This caused my Gnucash

application/program file (is that the correct description?) to be deleted.
I had to re-download the application. Did I do something wrong when I
re-booted?

My Gnucash ?drive? appears to as an external drive??see attached screen

shot.

No, rebooting did not cause anything to be deleted. Your screenshot

didn't come through, but your external drive comment leads me to guess that
you were running GnuCash from the mounted disk image. You didn't need to
re-download it, you could remount it by double-clicking on
Gnucash-Intel-4.4-1.dmg in your Downloads folder.

But GnuCash doesn't work all that well from the dmg (no mac application

does) so you're supposed to drag it from there to the Applications folder
before running it. Once you've done that you can eject the disk image
(control click and select eject or use the eject symbol next to the disk
image name in Finder's sidebar).

Regards,
John Ralls




--

Message: 2
Date: Sun, 21 Mar 2021 01:09:25 -0500 (CDT)
From: David Cousens 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] CSV matching produces duplicates?
Message-ID: <1616306965440-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

The matching of the account names in the input records (whether transfer
accounts or the main account for the transaction) to the 

[GNC] Adding Namespace Item to Price Editor

2021-03-22 Thread Jack Frillman via gnucash-user


In the GNUCash Price Editor  you have to choose from a list of seven 
*Namespace* items:


Currencies, All non-currencies, AMEX, EUREX, FUND, NASDAQ, NYSE

Is there any way of adding an item to this list?

Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] namespaces vs import prices

2021-03-22 Thread Jack Frillman via gnucash-user
Yes there is a way of doing it in Version 4.4. I just did the same thing 
so I could put all my securities from my past 401K into a namespace I 
called STALE. I did that because I wasn't ever going to do anything with 
them again and I wanted them out of the way.


To move one security from one namespace to another namespace.
Bring up the Security Editor*Tools-->Security Editor*. This will bring 
up the *Securities* window.
In the *Securities *window select the security you want to move and hit 
the *EDIT* button. This will bring up the *Edit Security* tool.
The fourth item down is a drop-down list labeled *TYPE.* Select the one 
you want to put the selected security under then hit *OK*.


But first if you don't already have a namespace you want to move a 
security to, in your case *MISC*, you're going to have create one. This 
is how to do it.


When adding a new security *Tools -> Security Editor -> Add*, there is a 
drop-down to select the namespace labelled "Type". This field is also an 
input box, and the value for a new namespace can be typed into the field 
while creating the new security. When the security is added, a new 
namespace will appear on the list of *"*Types*"* in the future.


When I did this a created a temporary security called zxzx so I could 
created the new namespace. After I move a real security to it I then 
removed zxzx.


I think the namespace is there so you can categorize you securities. 
That can be very helpful when setting prices so a given security is 
easier to find.


Hope this helps.

Jack

On 3/22/21 12:26 AM, Steven Anter wrote:

John
I  have 60 securities that I'd like to move from various namespaces to a
single namespace called "MISC".  Do I have to do them individually? Or is
there a way to do them all at once?


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Mar 21, 2021 at 8:56 PM John Ralls  wrote:


Please don't reply when you want to start a new thread, especially not to
a digest.

No problem, you can arrange non-currency commodities in namespaces however
you like and you can change a non-currency commodity's namespace in
Tools>Security Editor.

Regards,
John Ralls



On Mar 21, 2021, at 7:09 PM, Steven Anter  wrote:

The newer releases of gnucash now require a namespace to import prices

from

a csv file.  This is rather cumbersome because my securities are spread

out

over a few namespaces.   The notion of  "namespace" is irrelevant to the
way I use gnucash; if I could bypass I would.  Perhaps there is a way I

can

change all securities to have the same namespace of "MISC"   If there is,
please let me know


On Sun, Mar 21, 2021 at 7:40 AM 

wrote:

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

   1. Re:  Had to download application again (David Ridell)
   2. Re:  CSV matching produces duplicates? (David Cousens)
   3.  mortgage refinance (Parker Graham)
   4. Re:  mortgage refinance (py...@cox.net)
   5. Re:  mortgage refinance (Parker Graham)
   6. Re:  mortgage refinance (D)
   7. Re:  mortgage refinance (Peter West)
   8. Re:  mortgage refinance (Derek Atkins)
   9. Re:  mortgage refinance (Derek Atkins)
  10. Re:  mortgage refinance (Peter West)
  11. Re:  mortgage refinance (py...@cox.net)


--

Message: 1
Date: Fri, 19 Mar 2021 12:57:19 -0400
From: David Ridell 
To: John Ralls 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Had to download application again
Message-ID: <19e7dc05-6e5c-4e23-9cc5-fb238f5fe...@aol.com>
Content-Type: text/plain; charset=utf-8

Thank you!

David

Sent from my iPhone


On Mar 19, 2021, at 12:30 PM, John Ralls  wrote:

?


On Mar 18, 2021, at 4:04 PM, David Ridell via gnucash-user <

gnucash-user@gnucash.org> wrote:

I had to reboot my MacBook Air. This caused my Gnucash

application/program file (is that the correct description?) to be

deleted.

I had to re-download the application. Did I do something wrong when I
re-booted?

My Gnucash ?drive? appears to as an external drive??see attached

screen

shot.

No, rebooting did not cause anything to be deleted. Your screenshot

didn't come through, but your external drive comment leads me to guess

that

you were running GnuCash from the mounted disk image. You didn't need to
re-download it, you could 

  1   2   >