Re: [GNC] Can someone tell me how A-L=Eq+(I-Ex) is correct?

2022-08-28 Thread David Carlson
When you are trying to extend the over-simplified formula you need to add
terms for income expense and retained income to name a few.  I do not know
the name of a good reference to help you.

On Sun, Aug 28, 2022 at 5:39 PM W. Neal Lewis  wrote:

> I will agree that by mathematical logic, Assets-(Liabilities)=Equity. ∴
> Assets+(Liabilites)-(Liabilities)=Equity+Liability, or stated more
> simply, A=Eq+L. I have added Liability to both sides ∴ both sides remain
> equal.
>
> However, although (A+L)=Eq, (A+L)≠Eq+(I+Ex). I have added a term to the
> right side that is most decidedly not on the left ∴ they cannot be equal.
>
> ∴ A and L must be terms that include other factors.
>
> Not good at accounting, I will ask what those other factors are.
>
> I want to use GnuCash but I am having trouble getting my mind to accept
> an equation that is not correct unless terms are redefined.
>
> Please help me with my (obviously) incorrect understandings.
>
> Thank you,
>
> Neal Lewis
> ___
> 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] A new start - somewhat strange

2022-08-31 Thread David Carlson
Narberth,

That message means that GnuCash did not find and open an existing data file
so it is expecting you to create a new one.  Thus Derek's answer.

On Wed, Aug 31, 2022, 7:11 AM Derek Atkins  wrote:

> Just create a new file:
>
>  File -> New File
>
> -derek
>
> On Wed, August 31, 2022 6:53 am, Norbert Klein wrote:
> > Self introduction: I am Norbert Klein, a 88 year old German, living
> > since 32 years in Cambodia.
> >
> > Some years ago, I had been using GnuCash on a computer running under
> > Ubuntu.
> >
> > Some months ago, I wanted to set up GnuCash again, this time on a
> > computer using Windows  -  but before I could move ahead, I had a
> > hard-disk failure and had to get a news hard-disk.
> >
> > Now I wanted to start again, Windows 10, GnuCash 4.11-1 setup
> > downloaded, I accepted all suggestions during setup; at the end I saw
> > the GnuCash icon on the desktop. I clicked on it, expecting some kind of
> > initial GnuCash program – but I got only this:
> >
> > “Unsaved Book – GnuCash”
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Before I might make some mistakes, I rather ask. Any suggestions? Please…
> >
> > Norbert – nhkl...@mgmx.net
> >
> >
> >
> >
> > ___
> > 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.
> >
>
>
> --
>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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] James Baxter, was mislabeled as gnucash-user Digest, Vol 234, Issue 6

2022-09-03 Thread David Carlson
First, please follow recommendations when starting a new topic do not
hijack old ones to get the email address,  use some normal method to get
the address.   Also,  give it a real subject,  never use the digest as a
topic.

I speak English as my native tongue and I have a real problem with people
who butcher it so badly to scramble nouns and verbs so that I cannot figure
out what you say is one instead of what?

Try using one noun and one verb per sentence.



On Sat, Sep 3, 2022, 7:25 AM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  I am James Baxter and I am playing with this and made a mistake with my
> with my checking account, as I found out what my problem was. Not entering
> income the right way.
> So I am looking to start buying stock and also Bonds.When I place the cost
> (say Tesla) of $285.50 (A fake number) the tell it the number of stock I
> want. it goes back to one.
>
> I am not doing this right. Can some one copy the parts or how ever you
> wish.
> ThanksJames Baxteremail. kangaro...@yahoo.com
>
> On Saturday, September 3, 2022 at 07:50:24 AM EDT, <
> gnucash-user-requ...@gnucash.org> 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:  Change Linked Document Path (Geoff Storer)
>
>
> --
>
> Message: 1
> Date: Sat, 3 Sep 2022 21:47:55 +1000
> From: Geoff Storer 
> To: Jim DeLaHunt 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Change Linked Document Path
> Message-ID:
> 
> Content-Type: text/plain; charset="utf-8"
>
> Hi Jim
> Answers to your questions
>
> Q: what exactly do you see that is not working for you? What do you see
> that makes you say, "[GnuCash] looks for the attached document in the
> windows document folder"?
>
> Ans: Error box pops up with following message
> GnuCash could not find the linked document.:
> C:\Users\jscmu\Documents\Globird Gas 220728.pdf
> See attached screenshot
>
> Q: When you open your GnuCash accounts book, and find a transaction with
> an attached document, what GnuCash operations do you do, in order to
> open or find that document?
>
> Ans: I go to a register for the account from where the payment was made and
> beneath
> the column headed "R" (for reconcile) click on the icon that signifies the
> document is present.
> Also included in attached screenshot
>
> Q: In that transaction, what does GnuCash display as the location of the
> document? (This is important, because the exact spelling will show us if
> the document path is relative or absolute.)
>
> Ans: C:\Users\jscmu\Documents\-document name-
>
> Q: What specifically did you try in GnuCash to point to the correct
> location of the documents? What do you mean by "editing the preferences"?
>
> Ans: In top menu bar selected
> edit/preferencesthen selectedGeneral from left hand options panel
> In that screen I then selected "Linked files" from the options displayed to
> the right
> I used the dropdown arrow in this option and navigated to the folder where
> copies of
> my invoices reside. See attached screenshot "Linked files".
>
> Q: What did the preferences say before you made this change?
>
> Ans: Good question. Not exactly sure what it said before I changed it. But
> when I
> now click the "Clear" button (to the right of the dropdown arrow) I see a
> message
> as per screenshot "Change linked Docs".
>
> Q: What do the preferences say now?
>
> Ans: As per "linked files" screenshot
> "Path Head for linked files Relative Path"  with option "GNU Invoices" (the
> name of my
> invoices folder)
>
> Q: What version of GnuCash are you using?
>
> Ans: I am using ver 4.11  Build ID:  4.11 (2022-06-25)
>
> Thanks for taking the time to look at this
>
> Geoff
>
>
>
>
>
>
>
> On Sat, Sep 3, 2022 at 6:46 AM Jim DeLaHunt  wrote:
>
> > Geoff:
> >
> > On 2022-09-01 20:04, Geoff Storer wrote:
> > > Ok, thanks.
> > >
> > > This is my first post!!
> > >
> > > On Fri, Sep 2, 2022 at 8:16 AM Jim DeLaHunt 
> > wrote:
> > >
> > >> Geoff:
> > >>
> > >> One tenet of GnuCash-user email list etiquette is to cc the
> gnucash-user
> > >> email list on all replies. We want this discussion to take place on
> the
> > >> list.
> > >>
> > >> Thus I am replying to you, and cc'ing the list, so that the thread
> stays
> > >> on the list.  I will reply to this message from the email that reaches
> > me
> > >> via the list.
> > >>  ?Jim DeLaHunt
> >
> > Thank you for replying to the list. I will carry on the conversation via
> > a reply

Re: [GNC] James Baxter, was mislabeled as gnucash-user Digest, Vol 234, Issue 6

2022-09-03 Thread David Carlson
Please reply to list by following the instructions at the bottom of the
email.  I am replying for you this time.

Chapter 6 iirc of the Tutorial and Concepts guide explains that.  If you
have any further questions reply to list and please use terms found in the
guide so users can understand your questions

If you forgot how to find the tutorial go the the Gnucash.org website and
look around

On Sat, Sep 3, 2022 at 10:09 AM James Baxter  wrote:

> David Carlson
> Sorry For that, I speak English as well. I am in The USA.
> What I am looking for is to setup the Stock (Tickers) items
> as they are not working for me. I am asking if anybody know ow to do that.
>
> Hope I am understood.
> James Baxter
> kangaro...@yahoo.com
> On Saturday, September 3, 2022 at 08:59:46 AM EDT, David Carlson <
> david.carlson@gmail.com> wrote:
>
>
> First, please follow recommendations when starting a new topic do not
> hijack old ones to get the email address,  use some normal method to get
> the address.   Also,  give it a real subject,  never use the digest as a
> topic.
>
> I speak English as my native tongue and I have a real problem with people
> who butcher it so badly to scramble nouns and verbs so that I cannot figure
> out what you say is one instead of what?
>
> Try using one noun and one verb per sentence.
>
>
>
> On Sat, Sep 3, 2022, 7:25 AM James Baxter via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>  I am James Baxter and I am playing with this and made a mistake with my
> with my checking account, as I found out what my problem was. Not entering
> income the right way.
> So I am looking to start buying stock and also Bonds.When I place the cost
> (say Tesla) of $285.50 (A fake number) the tell it the number of stock I
> want. it goes back to one.
>
> I am not doing this right. Can some one copy the parts or how ever you
> wish.
> ThanksJames Baxteremail. kangaro...@yahoo.com
>
> On Saturday, September 3, 2022 at 07:50:24 AM EDT, <
> gnucash-user-requ...@gnucash.org> 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:  Change Linked Document Path (Geoff Storer)
>
>
> --
>
> Message: 1
> Date: Sat, 3 Sep 2022 21:47:55 +1000
> From: Geoff Storer 
> To: Jim DeLaHunt 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Change Linked Document Path
> Message-ID:
> 
> Content-Type: text/plain; charset="utf-8"
>
> Hi Jim
> Answers to your questions
>
> Q: what exactly do you see that is not working for you? What do you see
> that makes you say, "[GnuCash] looks for the attached document in the
> windows document folder"?
>
> Ans: Error box pops up with following message
> GnuCash could not find the linked document.:
> C:\Users\jscmu\Documents\Globird Gas 220728.pdf
> See attached screenshot
>
> Q: When you open your GnuCash accounts book, and find a transaction with
> an attached document, what GnuCash operations do you do, in order to
> open or find that document?
>
> Ans: I go to a register for the account from where the payment was made and
> beneath
> the column headed "R" (for reconcile) click on the icon that signifies the
> document is present.
> Also included in attached screenshot
>
> Q: In that transaction, what does GnuCash display as the location of the
> document? (This is important, because the exact spelling will show us if
> the document path is relative or absolute.)
>
> Ans: C:\Users\jscmu\Documents\-document name-
>
> Q: What specifically did you try in GnuCash to point to the correct
> location of the documents? What do you mean by "editing the preferences"?
>
> Ans: In top menu bar selected
> edit/preferencesthen selectedGeneral from left hand options panel
> In that screen I then selected "Linked files" from the options displayed to
> the right
> I used the dropdown arrow in this option and navigated to the folder where
> copies of
> my invoices reside. See attached screenshot "Linked files".
>
> Q: What did the preferences say before you made this change?
>
> Ans: Good qu

Re: [GNC] A new start - somewhat strange

2022-09-04 Thread David Carlson
In Windows 10 you are only allowed to save files somewhere in your user
space.  We recommend putting it in it's own dedicated directory,  possibly
under the Documents folder.

On Sun, Sep 4, 2022, 6:23 AM Norbert Klein  wrote:

> Thanks - that helped me to do the next step:
>
> Just create a new file:
>
> File -> New File
>
> I followed the recommendations, at the end I gave a name, and should
> download everything to C:\Program Files
> (x86)\gnuucash\bin]\spf-total.gnucash
>
> BUT I got: ...may be on a read-only file system ... you may not have write
> permission... or your anti-virus software is preventing this action.
>
> Why? So what next?
>
> I see the whole range of directories have been created:
>
> *Assets*
>
> *Expenses*
>
> *Income*
>
> *Liabilities*
>
> but I cannot save what I created.
>
> I beg to be aware that I do not have any people around (in the Cambodian
> countryside, where I live) whom I could ask here...
>
> But I still have a previous unsolved question: Why did I have to take
> action (thanks for the advice!), initiating the creation of New Files - is
> this not part of the setup? Any problem on my side?
>
> Thanks for the help - we start moving.
>
> Norbert
>
> =
>
> On 8/31/2022 21:46, David Carlson wrote:
>
> Norbert,
>
> That message means that GnuCash did not find and open an existing data
> file so it is expecting you to create a new one.  Thus Derek's answer.
>
>
>
___
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 David Carlson
There are a couple of scenarios where it is desirable to post dividends in
the security account even though it does not affect the security,  it does
affect your ROI.  One is for certain report s and the other is when the
user reports dividends by ex dividend dates instead of payment dates.

On Mon, Sep 5, 2022, 12:00 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> 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.
>
___
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 David Carlson
If you had previous dividends open up one of those transactions, then while
the curser is sitting in the description box click Transaction > Duplicate
Transaction.  Set the date to the correct date, then tab down to the last
split line and add a split to the security account.  No need to enter any
values other than a memo describing why you did that.

On Mon, Sep 5, 2022 at 6:06 PM Jack Frillman via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>
> On 9/5/22 3:09 PM, John Ralls wrote:
> >> On Sep 5, 2022, at 10:32 AM, Adrien Monteleone <
> adrien.montele...@lusfiber.net> 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.
>


-- 
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 David Carlson
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 David Carlson
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 > >
>> 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 David Carlson
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 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-07 Thread David Carlson
I think it is 6 to 1 that it is ok to put a dividend payout in a security
account without buying or selling any shares if you want to do it that way.

On Wed, Sep 7, 2022 at 7:00 PM John Layman 
wrote:

> I disagree that there is no reason for a post-close dividend to affect the
> account of the investment.  Otherwise, the dividend is not attributed to
> the
> source and isn't reflected in its return.
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of Fred Bone
> Sent: Wednesday, September 7, 2022 4:54 AM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Mutual Fund Dividend After Sale
>
> On 06 September 2022 at 14:56, Jack Frillman said:
>
> [...]
> > 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 > >
>
> So there is no reason for it to affect the stock account, and specifically
> to affect the balance of the stock account. So what's the problem?
>
>
> ___
> 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] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-10 Thread David Carlson
Richard,

Are you using the windows installer as downloaded from the Gnucash.org
website for each gnucash version?

Do you let the installer delete the existing version or do you use another
method?




On Sat, Sep 10, 2022, 11:18 AM Gyle McCollam  wrote:

> Does gnucash open, just not your data file? If so,  once opened try file
> open and select your ???.gnucash file. I'm on windows 11 and gnucash 4.11
> with no issues.
>
>
>
> Sent from Samsung Galaxy smartphone.
>
>
>
>  Original message 
> From: Richard Clarkson via gnucash-user 
> Date: 9/10/22 12:04 PM (GMT-05:00)
> To: gnucash-user@gnucash.org
> Subject: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
>
> I previously posted (some time ago) about an issue opening GnuCash
> following
> upgrade to a newer version. I decided to wait to see if a newer version
> would overcome my problem.
>
>
>
> I am on a Windows 11 PC, and am able to use GnuCash 4.9. I have tried
> updating to GnuCash 4.10 and 4.11, unfortunately when  I try to open the
> gnucash.exe on anything above the 4.9 version then nothing happens (it
> doesn't make any difference if I start as an Administrator or not). Windows
> thinks for 2 seconds and then does nothing. I can see no GnuCash processes
> in Task Manager. Once I revert to version 4.9 everything works as it
> should.
>
>
>
> I have tried downloading from sourceforge and GitHub, in case there was an
> issue. I have tried turning of my Firewall and antivirus, but same issue.
>
>
>
> Did something drastic chance be between version 4.9 and 4.10 or is there
> anything else I can to see if I can overcome this problem? It's getting to
> be quite frustrating!
>
>
>
> Richard
>
> ___
> 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.
>
___
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] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-10 Thread David Carlson
Richard,
please use reply all or whatever your mail client requires to be sure <
gnucash-user@gnucash.org> gets a copy so others can see it.
That is important because I have to tell others that you have now gone
beyond my area of expertise as a long term user and you now need help from
someone who knows more about Gnucash on versions of windows newer than XP.
This time I am copying it to the list.




On Sat, Sep 10, 2022 at 11:38 AM Richard Clarkson 
wrote:

> David
>
>
>
> Thanks for responding!
>
>
>
> Yes I use the windows installer and I have tried letting the installer
> delete the previous version and have also tried deleting the previous
> version myself.
>
>
>
> Richard
>
>
>
> *From:* David Carlson 
> *Sent:* 10 September 2022 17:33
> *To:* Gyle McCollam 
> *Cc:* Richard Clarkson ; Gnucash Users <
> gnucash-user@gnucash.org>
> *Subject:* Re: [GNC] Issue Opening GnuCash in versions above 4.9 on
> Windows 11
>
>
>
> Richard,
>
>
>
> Are you using the windows installer as downloaded from the Gnucash.org
> website for each gnucash version?
>
>
>
> Do you let the installer delete the existing version or do you use another
> method?
>
>
>
>
>
>
>
>
>
> On Sat, Sep 10, 2022, 11:18 AM Gyle McCollam  wrote:
>
> Does gnucash open, just not your data file? If so,  once opened try file
> open and select your ???.gnucash file. I'm on windows 11 and gnucash 4.11
> with no issues.
>
>
>
> Sent from Samsung Galaxy smartphone.
>
>
>
>  Original message 
> From: Richard Clarkson via gnucash-user 
> Date: 9/10/22 12:04 PM (GMT-05:00)
> To: gnucash-user@gnucash.org
> Subject: [GNC] Issue Opening GnuCash in versions above 4.9 on Windows 11
>
> I previously posted (some time ago) about an issue opening GnuCash
> following
> upgrade to a newer version. I decided to wait to see if a newer version
> would overcome my problem.
>
>
>
> I am on a Windows 11 PC, and am able to use GnuCash 4.9. I have tried
> updating to GnuCash 4.10 and 4.11, unfortunately when  I try to open the
> gnucash.exe on anything above the 4.9 version then nothing happens (it
> doesn't make any difference if I start as an Administrator or not). Windows
> thinks for 2 seconds and then does nothing. I can see no GnuCash processes
> in Task Manager. Once I revert to version 4.9 everything works as it
> should.
>
>
>
> I have tried downloading from sourceforge and GitHub, in case there was an
> issue. I have tried turning of my Firewall and antivirus, but same issue.
>
>
>
> Did something drastic chance be between version 4.9 and 4.10 or is there
> anything else I can to see if I can overcome this problem? It's getting to
> be quite frustrating!
>
>
>
> Richard
>
> ___
> 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] new to Gnucash - help with general information

2022-09-10 Thread David Carlson
There has been discussion here in the past about how to save backups of the
information that GnuCash saves in other folders.  I do not recall there
being a nice answer for users that wish it was all in one folder.

That information does not change much after the first year or two so
eventually a quarterly manual copy to some backup folder suffices for most
users.



On Sat, Sep 10, 2022, 9:44 PM Gyle McCollam  wrote:

> Donna,
> I use the same Gnucash, but Windows 11.  1st, let me say that Geoff info
> was helpful. There are several folders on my system for gnucash, but all
> the data and backups reside in gnucash in my documents folder.  There are
> other files associated with gnucash that it puts in other places that I
> would not put in my main data files location.  When you say you have files
> in 3 locations, which files are you referring to?
>
> your questions:
>
>   1.  gnucash saves all data files in one location by default.  This
> includes your main data file, as .gnucash.  The log files that Goeff
> mentioned .gnucash.datetime.log and the lock file he mentioned
> .gnucash.LCK.
>   2.  As long as you didn't delete the .gnucash or any newer log files
> you should have been OK, but you probably deleted your current file and
> that is why you lost data.
>   3.  In the "Edit/Preferences/General", there is an Auto Save time
> Interval that you can set for it to create backups and a "Retain
> log/backups" for the number of days to save these backups.  This way it can
> do the deletions for you automatically and you don't have to worry about
> what files you are deleting.
>   4.  As Geoff said it will save the file to the same place it was
> retrieved from, unless you use "save as" and specify a different location.
>   5.  Geoff is also correct here that gnucash saves backup so you don't
> lose data, but backuping up to another media is always a good idea.
>
> Another helpful place to look is in "Help/Tutorial and  Concepts Guide".
> In the search box type "backing up and recovering data" enter and it will
> take you to the page explaining how to restore and helpful information
> about how every thing works.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of gra...@shaw.ca 
> Sent: Saturday, September 10, 2022 2:37 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] new to Gnucash - help with general information
>
> I am new to Gnucash and have a few questions regarding saving data.  I use
> Windows 10 and Gnucash Version: 4.11 Build ID: 4.11+(2022-06-25)
>
> 1.  I would like to save everything in one folder named Gnucash.  I
> think I will use the xml format.  Currently it seems there are files in
> three different folders.
> How do I make sure to save everything to one folder?
>
> 2.  Can I move everything I have (which is in 3 different folders) to a
> folder named Gnucash without harm to the data I have entered.  (I
> previously
> had entered data for 2021, then deleted a bunch of files and most of the
> data disappeared.  The file types were text and gnucash financial data)
>
> 3.  How long do you need to keep the different files?
> Are there certain files needed to keep the data in the Gnucash system?  I
> have looked at the FAQ but still not clear.
>
> 4.  When you click the save button when entering transactions, how do
> you know where it is being saved to?  I'd like it to be saved in Gnucash
> folder, as indicated above.
>
> 5.  Back ups - I have read a lot about the back ups but still unsure
> what to do.  Any suggestions would be appreciated.
>
> Thanks all
> Donna
>
> ___
> 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.
>
___
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] Opening Gnucash

2022-09-12 Thread David Carlson
Richard,

Do I understand correctly that after you download gnucash-4.11-1.setup.exe
from the link on gnucash.org and use it to install GnuCash.exe using
default  settings then the icon on the Windows 11 equivalent to the Windows
10 icon that is supposed to start GnuCash doesn't work?  Also clicking on
the data file icon in file manager manager doesn't work either?  Yet if you
then run gnucash-4.9.setup.exe to revert to release 4.9 then that release
starts as expected and opens the correctdata file?

If you are doing something different please explain.



On Sun, Sep 11, 2022, 5:36 PM Richard Clarkson via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Greg
>
> Thank you!
>
> As I mentioned GnuCash 4.9, Windows 11 (64 bit). Have tried opening from
> apps, from shortcut, directly from the GnuCash.exe in bin. I cannot open
> GnuCash from any version higher than 4.9. I see a circle for a few seconds
> while windows is try to open GnuCash and then nothing. I've tried opening
> from PowerShell too.
>
> Is there any way of seeing where the exe is getting stuck or if something
> is
> missing or if I need to update anything?
>
> I'm either go to have to stay on 4.9 or change to another program.
>
> Thanks you for your help.
>
> RIchard
>
> -Original Message-
> From: gnucash-user
>  On Behalf Of
> Greg Feneis
> Sent: 11 September 2022 14:59
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Opening Gnucash
>
> Richard,
>
> You may want to provide a few more details.  Perhaps mention the version of
> GnuCash you're using, which OS you're using.  How do you open GnuCash, by
> starting the application or by clicking on a saved file?  And so on.
>
> Kind regards,
>
> Greg Feneis
>
>
>
>
> On Sat, Sep 10, 2022 at 6:36 AM Richard Barmann  wrote:
>
> > When IO open Gnucash to make some entries in the checking account It
> > opens a page from the past. How can I open the latest page with the
> > entries up to date.
> >
> > Richard Barmann
> >
> > ___
> > 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.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Opening Gnucash

2022-09-12 Thread David Carlson
I see that there is a Richard Barmann having an issue with Gnucash opening
an old data file and a Richard Clarkson having an issue with versions more
recent than 4.9 failing to start.  In my email client their messages are
inextricably tangled.  I also see that now Richard Clarkson is discussing
his issue with another person who's name I cannot see while writing this
post but I recall that Mr. Clarkson's problem started last May when
migrating from 3.something to 4.0 and it got worse after that.

Mr Barmann, have you been able to solve your problem?

On Mon, Sep 12, 2022, 1:12 PM Richard Clarkson via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Thanks Gyle - no message, as GnuCash won't open. Tried opening data file
> with the GnuCash Program and still nothing.
>
> Richard
>
> -Original Message-
> From: gnucash-user
>  On Behalf Of
> Gyle McCollam
> Sent: 10 September 2022 15:25
> To: Richard Barmann ; gnucash-user@gnucash.org
> Subject: Re: [GNC] Opening Gnucash
>
> Richard,
> You may not have closed it correctly, however in that case you would have
> gotten a message that the file was locked with options on opening.  Gnucash
> opens the last file, so you may have lost some data.  To be sure you have
> the latest file use open/file and select the most recent ???.gnucash file
> not any of the log files or files with dates as part of the name.  Then try
> Help/Tutorial and  Concepts Guide.  In the search box type "log files"
> enter
> and it will take you to the page explaining how to restore.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of Richard Barmann 
> Sent: Saturday, September 10, 2022 9:35 AM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Opening Gnucash
>
> When IO open Gnucash to make some entries in the checking account It opens
> a
> page from the past. How can I open the latest page with the entries up to
> date.
>
> Richard Barmann
>
> ___
> 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.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Opening Gnucash

2022-09-12 Thread David Carlson
Now that I am back on a real tower computer which, alas, is presently
running Windows 10, I see that Mr Clarkson is currently working with
Kalpesh Patel in a different thread, so persons interested in his problem
can look for that thread.

On Mon, Sep 12, 2022 at 2:56 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Holy Cow.
>
> This thread is a disaster.
>
> Richard Clarkson, please, unless you can help Richard Barmann, do not
> reply any longer in this thread. Please, start a new one or if still
> applicable, reply in your own old thread.
>
> The two of you are replying to questions meant for the other and others
> offering advice aren't making it clear who they are talking to, and
> these two facts are combining to make things very confusing.
>
> Neither of you will get proper help with this confusion.
>
> So please keep the issues separate.
>
>  From what I can see so far:
>
> Richard Barmann (who it appears, started *this* thread) is using Win10
> and *can* open GnuCash, but is allegedly seeing 'old data' and any *new
> data* is apparently missing.
>
> Richard Clarkson is using Win11 and *cannot* open GnuCash *at all* using
> v4.11, but *can* using v4.9.
>
> These are two vastly separate issues from two different people. (or else
> it is I that am really lost)
>
> For everyone else, can we keep this thread about Richard Barmann's
> problem and save the Richard Clarkson problem for a more appropriate
> thread? If we do so, I suspect we can help both of them out in short
> order. (at least shorter than keeping things confounded!)
>
> Regards,
> Adrien
>
> On 9/12/22 1:06 PM, Richard Clarkson via gnucash-user wrote:
> > Thanks Michael.
> >
> > No it doesn't. The path is C:/Program Files (x86)/gnucash/bin/gnucash.exe
> >
> > My data file is GNUData.gnucash - there are of course backups. But even
> if I
> > try to open GnuData.gnucash with GnuCash Program File then nothing
> happens.
> >
> > Richard
> >
> > -Original Message-
> > From: gnucash-user
> >  On Behalf
> Of
> > Fross, Michael
> > Sent: 12 September 2022 18:35
> > To: Richard Barmann 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Opening Gnucash
> >
> > Richard, does your GNUCash file have a date string in the name?  If so,
> then
> > you are inadvertently using a backup file.  Your filename should be
> >
> > FILENAME.gnucash   (FILENAME is whatever you decided to call it)
> >
> > If it looks like:
> >
> > FILENAME.gnucash.20220909023225.gnucash  (insert a valid date time stamp)
> >
> > then it's a backup file and you are working on a backup.  This is not
> what
> > you want.
> >
> > If this is the case, do a File | SaveAs and call it NAME.gnucash and go
> from
> > there.
> >
> > Michael
>
>
> ___
> 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] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-12 Thread David Carlson
Also, in your thread started last May you mentioned an adventure with
release 4.0 and 4.10, after which you may not have had a clean uninstall.
Have you tried using either the Windows uninstaller or a third party
uninstaller?  I wish I could remember the name of the third party
uninstaller that used to work very well, at least several years ago.

On Mon, Sep 12, 2022 at 3:03 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Richard (Clarkson),
>
> You mentioned in the other thread that you also tried from PowerShell.
>
> Is there no output there when it fails to completely open?
>
> Have you tried to view the Windows Logs to see if any warnings or errors
> were reported about the time you tried to start GnuCash?
>
> Of course, if you can get a Trace File (see the wiki) and/or stack trace
> that might help too.
>
> And to confirm - you downloaded GnuCash *from* the links on gnucash.org,
> and not somewhere else? (which take you to the GnuCash SourceForge
> project page)
>
> Regards,
> Adrien
>
> On 9/10/22 6:03 PM, Richard Clarkson via gnucash-user wrote:
> >>> Yes I use the windows installer and I have tried letting the installer
> delete the previous version and have also tried deleting the previous
> version myself.
> >>>
> >>> From: David Carlson 
> >>> Sent: 10 September 2022 17:33
> >>> To: Gyle McCollam 
> >>> Cc: Richard Clarkson ; Gnucash Users <
> gnucash-user@gnucash.org>
> >>> Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on
> Windows 11
> >>>
> >>> Are you using the windows installer as downloaded from the Gnucash.org
> website for each gnucash version?
> >>>
> >>> Do you let the installer delete the existing version or do you use
> another method?
>
>
> ___
> 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] CSV Import Problem

2022-09-14 Thread David Carlson
There is a huge amount of flexibility in the CSV importer, and it has been
working well for a long time.

It is far more likely that there is an error in your configuration or the
source file.  Did you start with a small test file with just enough
transactions to verify that your configuration is doing what you expect?  I
am not familiar with Moneyspire so I don't know if you have many accounts,
perhaps a mix of assets and liabilities that could provide further
complication.

We would need more specific details to help you further.

On Wed, Sep 14, 2022 at 6:05 AM  wrote:

> Hi,
>
>
>
> I am running GNUcash version 4.11 on Windows 11.
>
>
>
> I have created a CSV file from Moneyspire and I want to import this into
> GNUcash however many of the credits to the bank accounts are treated as
> debits and debits treated as credits but not always.  I have inspected the
> CSV file with Excel and also Wordpad and it looks fine.  It would appear
> GNUcash has a problem with CSV files.
>
>
>
> Regards
>
> Charles Avery
>
> ___
> 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] Issue Opening GnuCash in versions above 4.9 on Windows 11

2022-09-14 Thread David Carlson
The developers are less than two weeks away from releasing 4.12, so they do
not have much time for addressing this issue.  It appears to be pointing to
a dll, which is a Windows module.  I don't know if Windows has a way to
verify whether it is damaged or not.

On Wed, Sep 14, 2022 at 8:50 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Richard,
>
> That one is out of my wheelhouse, but maybe one of the devs can make
> heads or tails of it.
>
> You still haven't clarified where you downloaded GnuCash from... (just
> for completeness sake)
>
> Regards,
> Adrien
>
> On 9/14/22 11:06 AM, Richard Clarkson via gnucash-user wrote:
> > Adrien
> >
> > Thank you for your suggestion. I am a novice, but I worked out how to
> view the Windows logs and think this is the relevant part:
> >
> > Sig[3].Name=Fault Module Name
> > Sig[3].Value=libgdk-3-0.dll
> > Sig[4].Name=Fault Module Version
> > Sig[4].Value=3.24.34.0
> > Sig[5].Name=Fault Module Timestamp
> > Sig[5].Value=
> > Sig[6].Name=Exception Code
> > Sig[6].Value=c005
> > Sig[7].Name=Exception Offset
> >
> > Does this mean I have to try and replace the highlighted dll?
> >
> > Richard
> >
> > -Original Message-
> > From: gnucash-user  btinternet@gnucash.org> On Behalf Of Richard Clarkson via gnucash-user
> > Sent: 13 September 2022 22:54
> > To: nvsoar 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on
> Windows 11
> >
> > David
> >
> > Thank you , I’ll have a look tomorrow.
> >
> > Richard
> >
> > Sent from my iPhone
> >
> >> On 13 Sep 2022, at 17:27, nvsoar  wrote:
> >>
> >> FWIW - Revo Uninstaller has worked well for me.  nvsoar
> >>
> >>> On 09/12/22 13:20, David Carlson wrote:
> >>> Also, in your thread started last May you mentioned an adventure with
> >>> release 4.0 and 4.10, after which you may not have had a clean
> uninstall.
> >>> Have you tried using either the Windows uninstaller or a third party
> >>> uninstaller?  I wish I could remember the name of the third party
> >>> uninstaller that used to work very well, at least several years ago.
> >>>
> >>> On Mon, Sep 12, 2022 at 3:03 PM Adrien Monteleone <
> >>> adrien.montele...@lusfiber.net> wrote:
> >>>
> >>>> Richard (Clarkson),
> >>>>
> >>>> You mentioned in the other thread that you also tried from PowerShell.
> >>>>
> >>>> Is there no output there when it fails to completely open?
> >>>>
> >>>> Have you tried to view the Windows Logs to see if any warnings or
> >>>> errors were reported about the time you tried to start GnuCash?
> >>>>
> >>>> Of course, if you can get a Trace File (see the wiki) and/or stack
> >>>> trace that might help too.
> >>>>
> >>>> And to confirm - you downloaded GnuCash *from* the links on
> >>>> gnucash.org, and not somewhere else? (which take you to the GnuCash
> >>>> SourceForge project page)
> >>>>
> >>>> Regards,
> >>>> Adrien
> >>>>
> >>>> On 9/10/22 6:03 PM, Richard Clarkson via gnucash-user wrote:
> >>>>>>> Yes I use the windows installer and I have tried letting the
> >>>>>>> installer
> >>>> delete the previous version and have also tried deleting the
> >>>> previous version myself.
> >>>>>>> From: David Carlson 
> >>>>>>> Sent: 10 September 2022 17:33
> >>>>>>> To: Gyle McCollam 
> >>>>>>> Cc: Richard Clarkson ; Gnucash Users <
> >>>> gnucash-user@gnucash.org>
> >>>>>>> Subject: Re: [GNC] Issue Opening GnuCash in versions above 4.9 on
> >>>> Windows 11
> >>>>>>> Are you using the windows installer as downloaded from the
> >>>>>>> Gnucash.org
> >>>> website for each gnucash version?
> >>>>>>> Do you let the installer delete the existing version or do you
> >>>>>>> use
> >>>> another method?
> >>>>
> >>>>
> >>>> ___
> >>>> gnucash-user mailing list
> >>>> gnucash-user@gnucash.org
> &g

Re: [GNC] android app was gnucash-user Digest, Vol 234, Issue 39

2022-09-18 Thread David Carlson
I just checked and found that the Android app called GnuCash is still in
the Google Play Store.   It has not been supported for several years now.
The developer has effectively abandoned it.  I think it was intended to be
a portable bucket to collect transactions for later import into the real
GnuCash.   Our developers are not supporting it.

On Sun, Sep 18, 2022, 11:18 AM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> I found an app of Google to do with Gnucash. As I down loaded it. Can I
> get it to come over to my cell phone.
> thanksJames baxterkangaro...@yahoo.com
> On Sunday, September 18, 2022 at 12:00:27 PM EDT,
> gnucash-user-requ...@gnucash.org 
> 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:  Wrong Regedit key in Wiki for setting MRU maxfiles on
>   Windows version 4.11 (Vincent Dawans)
>
>
> --
>
> Message: 1
> Date: Sat, 17 Sep 2022 09:06:05 -0700
> From: Vincent Dawans 
> To: "Fross, Michael" 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Wrong Regedit key in Wiki for setting MRU maxfiles
> on Windows version 4.11
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
>
> Thank you Michael. You are right, I found this in the release 4.7 changelog
> "Change the preferences path to org.gnucash.GnuCash to comply with flatpak
> requirements and migrate existing preferences to the new paths. This won't
> provide for automatic sync between a system-installed GnuCash and a flatpak
> one unless the system-installed one is GnuCash 4.7 or later. Please see the
> Wiki for more information and a procedure to convert your existing
> preferences."
> I will update the Wiki FAQ
>
> On Thu, Sep 15, 2022 at 5:05 AM Fross, Michael  wrote:
>
> > Hello all.  I don't believe this "doubling" is a mistake.  Think of
> > "org.gnucash" as the "manufacturer" and "GnuCash" as the product.  If
> they
> > make another tool, it would be "org.gnucash.NewTool"
> >
> > Michael
> >
> > On Thu, Sep 15, 2022 at 3:25 AM Vincent Dawans 
> wrote:
> >
> >> FYI somebody on Linux also confirmed that they have the double
> >> /org/gnucash/GnuCash/history  path as well.
> >>
> >>
> https://www.reddit.com/r/GnuCash/comments/xe3xty/possible_to_change_recently_opened_from_4_to_5/
> >>
> >> On Wed, Sep 14, 2022 at 9:58 AM Vincent Dawans 
> wrote:
> >>
> >> > Was happy to see it is now possible to change the number of recent
> files
> >> > in the menu as per instructions in the FAQ
> >> >
> >> >
> >>
> https://wiki.gnucash.org/wiki/FAQ#Q:_I_have_deleted_a_gnucash_file_from_my_computer._How_can_I_remove_that_file_from_the_File_menu.27s_short_list_.28MRU.29_as_well.3F
> >> >
> >> > However the FAQ says to create a DWord in
> >> > Computer\HKEY_CURRENT_USER\SOFTWARE\GSettings\org\gnucash\history
> >> >
> >> > Although I do have a history key in that location, it seems to have
> been
> >> > created from an earlier version. In the latest version 4.11, it was
> >> moved
> >> > to
> >> >
> >>
> Computer\HKEY_CURRENT_USER\SOFTWARE\GSettings\org\gnucash\GnuCash\history
> >> > (notice the double \gnucash\GnuCash\)
> >> > That is where I had to create the DWord for it to work
> >> >
> >> > I get a sense that the registry tree might have been moved by mistake
> >> with
> >> > an added GnuCash level in the recent version but that's where it is as
> >> of
> >> > version 4.11 on Windows. If possible please update the FAQ to mention
> >> this
> >> > second location based on version number
> >> >
> >> > I have been using gnuCash for years but this is my first email to the
> >> > list. A big thank you for all the hard work.
> >> >
> >> > Vincent Dawans
> >> >
> >> ___
> >> 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.
> >>
> >
>
>
> --
>
> Subject: Digest Footer
>
> ___
>
> 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] Fwd.: A new start - somewhat strange

2022-09-22 Thread David Carlson
The place where you enter the currency name for an alternative currency is
in the settings for the accounts where you plan to use that currency.

If you plan to track groceries in that currency create a groceries expense
account in that currency.

If you plan to track a lot of things in a second currency you may want to
set up a separate set of books.



On Thu, Sep 22, 2022, 7:17 AM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> I use multi currency account and trading accounts in my books, is the
> following query still open if so let me know what exactly you need and i
> can walk you through
>
> ==
> But I have not yet found the place where I can enter my second currency
> KHR - I only see the many things I will be able to do AFTER I will have
> entered it.
>
> Can you please help me trough this step?
> ===
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of Norbert Klein 
> Sent: Wednesday, September 21, 2022 8:39 AM
> To: gnucash-user@gnucash.org ; gnuc...@jdlh.com
> 
> Cc: gnucash-user@gnucash.org 
> Subject: [GNC] Fwd.: A new start - somewhat strange
>
> My advice to you:
>
> 1. Do read the GnuCash concepts and tutorial guide, especially Chapter
> 12 /Multiple Currencies/
> .
>
> = =
> To enable them go to File → Properties+Accounts tab and check the Use
> Trading Accounts checkbox.
> DONE
> = =
>
> 2. Do enable Trading Accounts, as described in 12. /Automatically
> Recording Currency Transactions using Trading Accounts/
> <
> https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html
> >.
>
> I have always used them. (In fact, I cannot tell you what happens if you
>
> do not use them, because I have not tried.
>
> = =
>
> But I have not yet found the place where I can enter my second currency
> KHR - I only see the many things I will be able to do AFTER I will have
> entered it.
>
> Can you please help me trough this step?
>
> = =
>
> 3. I second Paul Kroitor's excellent advice that you make a "test book"
> for practice and experiments. Accept a default chart of accounts. Make a
> few accounts in KHR currency. Enter a few test transactions. See how
> things work.  Then set up your real book.
>
>
> Of course I will do this.
>
>
> 4. I use the one currency structure for my asset accounts, and a
> different currency structure for my expense accounts. See if either of
> these makes sense for you.
>
> I hope this is helpful.  Have fun with the experiments!
>
> Best regards,
>
>—Jim DeLaHunt, Vancouver, Canada
>
> Yes it is very helpful, Thanks, Norbert
>
>
> ___
> 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.
>
___
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] Price Source "Last up through Report Date" issue

2022-09-26 Thread David Carlson
I finally had a real test for this price source while running an account
report for May 31, 2022 in release 4.8, which I only recently adopted.
Unfortunately, it took prices from May 30 for this report, which is not
exactly as described by the title.  Has this been corrected since release
4.8?

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


[GNC] Fwd: Price Source "Last up through Report Date" issue

2022-09-26 Thread David Carlson
This is odd.  While prices that were picked by GnuCash for the Tuesday, May
31 dated account balance sheet report were actually the last prices in the
data before May 31, possibly several days earlier when there were prices
for every security actually dated May 31, the report which I created later
for Thursday June 30 picked the prices actually dated June 30.  There were
also prices dated June 29 and July 1 in the data for most or all the
securities in the report. Why is May 31 an outlier?

-- Forwarded message -
From: David Carlson 
Date: Mon, Sep 26, 2022 at 4:15 PM
Subject: Price Source "Last up through Report Date" issue
To: gnucash-user@gnucash.org 


I finally had a real test for this price source while running an account
report for May 31, 2022 in release 4.8, which I only recently adopted.
Unfortunately, it took prices from May 30 for this report, which is not
exactly as described by the title.  Has this been corrected since release
4.8?

-- 
David Carlson


-- 
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] Fwd: Price Source "Last up through Report Date" issue

2022-09-26 Thread David Carlson
Geoff,

Interesting theory and perhaps that is the source of this anomaly.  I
cannot see these timestamps in the normal price database view, but I can
say that most of the price records that were involved in both reports were
probably collected online by the Finance-Quote method, usually between
10:00 pm and 2:00 am Central time.  I think that I ran the May 31 report
this morning and the June 30 report tonight.

However, if that turns out to be the case, I would expect GnuCash to
perform the calculations on normalized dates with the times truncated out
so this would not affect the reports.  I have created a bug report <
https://bugs.gnucash.org/show_bug.cgi?id=798622> so that we can track the
problem.

On Mon, Sep 26, 2022 at 11:35 PM Geoff  wrote:

> Hi David
>
> This is a longshot: I noticed that records in the Prices table have a
> timestamp, see attached screenshot.
>
> So, perhaps, you ran the report for the 31st in the morning and the
> prices had an afternoon timestamp?
>
> You could inspect your Prices and run the report at different times of
> the day to test this conjecture.
>
> Regards
>
> Geoff
> =
>
> On 27/09/2022 2:17 pm, David Carlson wrote:
> > This is odd.  While prices that were picked by GnuCash for the Tuesday,
> May
> > 31 dated account balance sheet report were actually the last prices in
> the
> > data before May 31, possibly several days earlier when there were prices
> > for every security actually dated May 31, the report which I created
> later
> > for Thursday June 30 picked the prices actually dated June 30.  There
> were
> > also prices dated June 29 and July 1 in the data for most or all the
> > securities in the report. Why is May 31 an outlier?
> >
> > -- Forwarded message -
> > From: David Carlson 
> > Date: Mon, Sep 26, 2022 at 4:15 PM
> > Subject: Price Source "Last up through Report Date" issue
> > To: gnucash-user@gnucash.org 
> >
> >
> > I finally had a real test for this price source while running an account
> > report for May 31, 2022 in release 4.8, which I only recently adopted.
> > Unfortunately, it took prices from May 30 for this report, which is not
> > exactly as described by the title.  Has this been corrected since release
> > 4.8?
> >



-- 
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] Reconciliation Report

2022-10-04 Thread David Carlson
Nathan,  Are there actually no transactions in the share account for that
period?  I am surprised that the reconciliation dialog doesn't pop up
anyway to set the start and end balances.

On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal 
wrote:

> I maintain 2 accounts for an organization I belong to - a checking
> account at one bank and a share account at a credit union. Each of them
> has an account in gnucash. When I reconcile the accounts, the checking
> account reconciliation works properly but the share account
> reconciliation fails with a "no transactions in the specified period"
> error message even though I use the same period (monthly) for both
> accounts.
>
> I believe I have set them up properly. I am using ver 4.12 under Windows
> 10. All other functions seem to work properly.
> ___
> 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.


[GNC] Fwd: Reconciliation Report

2022-10-04 Thread David Carlson
Nathan,

Please reply to all so the group can follow the thread.  This time, since I
missed that you didn't, I will forward this to the group.

-- Forwarded message -
From: David Carlson 
Date: Tue, Oct 4, 2022 at 6:45 PM
Subject: Re: [GNC] Reconciliation Report
To: Nathan Rosenthal 


Once a transaction is reconciled it never appears in a subsequent
reconciliation unless it has been unreconciled.

Apparently I have never tried running a Reconciliation on an account where
there were no unreconciled transactions at all, which must be what you are
seeing,  Try creating a test transaction in that account to see if it
appears when you run the reconciliation..  The date would not be critical
as long as it is newly entered and not reconciled.

On Tue, Oct 4, 2022 at 6:25 PM Nathan Rosenthal 
wrote:

> Yes there were transactions during the month. In fact I got the same
> response when I used a longer time frame. There was a deposit on 9/12, a
> withdrawal on 9/15, and an interest payment on 9/30. It is really puzzling
> since the reconciliation process works correctly on two checking accounts.
>
> I can set the opening and closing balances and the start and end dates but
> the program still reports no transactions in this account. It is not a
> serious problem because I can always use a spreadsheet to do the
> reconciliation. It would be nice, though, to figure out why I get this
> result.
>
> Nathan
>
>
>
> On 10/4/2022 7:13 PM, David Carlson wrote:
>
> Nathan,  Are there actually no transactions in the share account for that
> period?  I am surprised that the reconciliation dialog doesn't pop up
> anyway to set the start and end balances.
>
> On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal 
> wrote:
>
>> I maintain 2 accounts for an organization I belong to - a checking
>> account at one bank and a share account at a credit union. Each of them
>> has an account in gnucash. When I reconcile the accounts, the checking
>> account reconciliation works properly but the share account
>> reconciliation fails with a "no transactions in the specified period"
>> error message even though I use the same period (monthly) for both
>> accounts.
>>
>> I believe I have set them up properly. I am using ver 4.12 under Windows
>> 10. All other functions seem to work properly.
>> ___
>> 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
>
>
>

-- 
David Carlson


-- 
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] Reconciliation Report

2022-10-05 Thread David Carlson
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


On Wed, Oct 5, 2022, 9:53 AM Nathan Rosenthal  wrote:

> The first sentence in your reply explains why going back further than the
> previous month did not produce any results.
>
> I will wait until the end of the month when there will be new unreconciled
> transactions in the account.
>
> Nathan
>
> On 10/4/2022 7:45 PM, David Carlson wrote:
>
> Once a transaction is reconciled it never appears in a subsequent
> reconciliation unless it has been unreconciled.
>
> Apparently I have never tried running a Reconciliation on an account where
> there were no unreconciled transactions at all, which must be what you are
> seeing,  Try creating a test transaction in that account to see if it
> appears when you run the reconciliation..  The date would not be critical
> as long as it is newly entered and not reconciled.
>
> On Tue, Oct 4, 2022 at 6:25 PM Nathan Rosenthal 
> wrote:
>
>> Yes there were transactions during the month. In fact I got the same
>> response when I used a longer time frame. There was a deposit on 9/12, a
>> withdrawal on 9/15, and an interest payment on 9/30. It is really puzzling
>> since the reconciliation process works correctly on two checking accounts.
>>
>> I can set the opening and closing balances and the start and end dates
>> but the program still reports no transactions in this account. It is not a
>> serious problem because I can always use a spreadsheet to do the
>> reconciliation. It would be nice, though, to figure out why I get this
>> result.
>>
>> Nathan
>>
>>
>>
>> On 10/4/2022 7:13 PM, David Carlson wrote:
>>
>> Nathan,  Are there actually no transactions in the share account for that
>> period?  I am surprised that the reconciliation dialog doesn't pop up
>> anyway to set the start and end balances.
>>
>> On Tue, Oct 4, 2022 at 4:21 PM Nathan Rosenthal 
>> wrote:
>>
>>> I maintain 2 accounts for an organization I belong to - a checking
>>> account at one bank and a share account at a credit union. Each of them
>>> has an account in gnucash. When I reconcile the accounts, the checking
>>> account reconciliation works properly but the share account
>>> reconciliation fails with a "no transactions in the specified period"
>>> error message even though I use the same period (monthly) for both
>>> accounts.
>>>
>>> I believe I have set them up properly. I am using ver 4.12 under Windows
>>> 10. All other functions seem to work properly.
>>> ___
>>> 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
>>
>>
>>
>
> --
> 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] Import CSV transactions into GC

2022-10-05 Thread David Carlson
CSV imports are less likely to catch all duplicates, especially if there is
little or no history of training.  Hopefully, though, amount and payee will
match closely enough to usually offer matches in the comparison step of the
import.

In 2021 Discover card offered QFX exports which include a unique
transaction identifier number in each transaction which allows GnuCash to
immediately discard transactions that are duplicates of previously imported
transactions.  I do not use that card enough to know if it still does offer
QFX. I prefer that format when it is available.

On Wed, Oct 5, 2022 at 9:18 PM David Cousens 
wrote:

> Carl
>
> If you had previously imported the September transactions, then the Import
> Matcher should recognize all of them as duplicates and not import them. In
> this
> case the A checkbox and U+C checkbox should both be unchecked and the 'C'
> checkbox set to indicate that the transactions match existing transactions
> and
> won't be imported, but the existing transactions will be marked as cleared
> (not
> reconciled).
>
> If the CSV file contained some data which differed from that which was in
> the
> in the QFX files, the U+C checkbox may be checked instead of the  C
> checkbox
> which indicates that the transaction matches an existing transaction and
> won't
> be imported again but the data which is different will be updated form the
> CSV
> import file.  The A checkbox should not be checked if the transactions
> already
> exist in your data file, only if they are new transactions.
>
> It is deliberately designed so as to not allow importing duplicate
> transactions
> as transactions can only be deleted individually from the account register.
>
> If you are experimenting with the import, a good idea is to create a dummy
> test
> set of books and experiment with importing into that firstrather than your
> main
> set of books. The dummy doesn't have to have your full account tree, just
> the
> accounts you will use during the import process. Once you have the import
> working as you want then import to your main set of books. It also helps to
> create a dummy CSV file which only has a few typical transactions in it to
> get
> the setup right. Avoids having to delete large numbers of transaction
> while you
> are experimenting if you don't get it right first time round.
>
> David Cousens
>
> On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
> > Discover Card (a credit card) as of last week stopped providing the
> > download of Discover card transactions in QDFmuch to my displeasure.
> >
> > They do provide a download of transactions in CSV format.
> >
> > I'm trying to figure out how to do a reliable importation of my credit
> > card transactions into GC in my Discover Card acct in GC.  This all
> > assumes I'll have to work with the downloaded CSV files now.
> >
> > For experimentation reasons I'm working on importing in csv format the
> > transactions for the entire month of September just to see how the
> > actual process is done.  Previously, I had already imported the Discover
> > card transactions in QDF for September (before Discover Card ended the
> > QDF download).  Next I'm importing the CSV transactions to see how they
> > are recognized and matched by GC.
> >
> > I've been somewhat successful in using  the
> > FileImport-Transactions from CSV and getting to the Match
> > Transactions screen which presents the transactions to be imported.  I
> > understand what the Reconcile (auto match) transactions are but many of
> > the transactions when imported to the account end up as duplicates since
> > previously they had been added in QDF.
> >
> > So, I'm confused and want to make the importation process as easy as
> > possible.  The A  U+C  C options make matters worsefor me.
> >
> > Also, I've tried, or rather, have attempted to get working, various
> > csv2ODF converters.  For me too many error messages was enough to stay
> > away from them.
> >
> > Any help is much appreciated...
> >
> > Car Smith
> > ___
> > 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 u

Re: [GNC] Import CSV transactions into GC

2022-10-05 Thread David Carlson
e matters worsefor me.
> >>
> >> Also, I've tried, or rather, have attempted to get working, various
> >> csv2ODF converters.  For me too many error messages was enough to stay
> >> away from them.
> >>
> >> Any help is much appreciated...
> >>
> >> Car Smith
> >> ___
> >> 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.
>
>
> ___
> 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] Import CSV transactions into GC

2022-10-06 Thread David Carlson
OK.  I just checked and now they only offer PDF, Spreadsheet(whatever that
means) and CSV download formats for my account.  I guess they don't need
our business.

On Thu, Oct 6, 2022 at 7:51 AM Carl S.  wrote:

> Whooops.you're right  QFX and not QDF
> --
> *From:* David Carlson [mailto:david.carlson@gmail.com
> ]
> *Subject:* [GNC] Import CSV transactions into GC
> *Date:* Thursday, October 6, 2022 at 12:17 AM
> *To:* Carl S.
> *Cc:* gnucash-user@gnucash.org
>
> What is QDF format?  That would not be the same as QFX.
>
> On Wed, Oct 5, 2022 at 10:57 PM Carl S.  wrote:
>
>> David,
>>
>> Thanks for the recommendations.  I've been working on this way too long
>> but think that I figured out some of the difficulties.  'Just reconciled
>> a credit card statement and got all of the old mess behind so that I can
>> begin anew by downloading csv transactions every few days or so.
>>
>> I think I figured out why and how I got duplicates-  in the Match
>> Transactions window there were several transactions that had the A box
>> checked and in the Additional Comments column area there were the words,
>> New, transfer $25.75 to (auto) "E:Food"  My guess is that GC was
>> telling me, "you already have this transaction in the register and
>> here's the amount and the account name".  So the solution was to tell GC
>> to NOT import the transaction by unchecking the A box which would turn
>> the line color red.  You're correct also that if the C box is checked
>> that particular transaction wont be imported.
>>
>> Thank you for the help...
>>
>> Carl Smith
>>
>> On 10/5/22 22:17, David Cousens wrote:
>> > Carl
>> >
>> > If you had previously imported the September transactions, then the
>> Import
>> > Matcher should recognize all of them as duplicates and not import them.
>> In this
>> > case the A checkbox and U+C checkbox should both be unchecked and the
>> 'C'
>> > checkbox set to indicate that the transactions match existing
>> transactions and
>> > won't be imported, but the existing transactions will be marked as
>> cleared (not
>> > reconciled).
>> >
>> > If the CSV file contained some data which differed from that which was
>> in the
>> > in the QFX files, the U+C checkbox may be checked instead of the  C
>> checkbox
>> > which indicates that the transaction matches an existing transaction
>> and won't
>> > be imported again but the data which is different will be updated form
>> the CSV
>> > import file.  The A checkbox should not be checked if the transactions
>> already
>> > exist in your data file, only if they are new transactions.
>> >
>> > It is deliberately designed so as to not allow importing duplicate
>> transactions
>> > as transactions can only be deleted individually from the account
>> register.
>> >
>> > If you are experimenting with the import, a good idea is to create a
>> dummy test
>> > set of books and experiment with importing into that firstrather than
>> your main
>> > set of books. The dummy doesn't have to have your full account tree,
>> just the
>> > accounts you will use during the import process. Once you have the
>> import
>> > working as you want then import to your main set of books. It also
>> helps to
>> > create a dummy CSV file which only has a few typical transactions in it
>> to get
>> > the setup right. Avoids having to delete large numbers of transaction
>> while you
>> > are experimenting if you don't get it right first time round.
>> >
>> > David Cousens
>> >
>> > On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
>> >> Discover Card (a credit card) as of last week stopped providing the
>> >> download of Discover card transactions in QDFmuch to my
>> displeasure.
>> >>
>> >> They do provide a download of transactions in CSV format.
>> >>
>> >> I'm trying to figure out how to do a reliable importation of my credit
>> >> card transactions into GC in my Discover Card acct in GC.  This all
>> >> assumes I'll have to work with the downloaded CSV files now.
>> >>
>> >> For experimentation reasons I'm working on importing in csv format the
>> >> transactions for the entire month of September just to see how the
>> >> actual process is do

[GNC] CSV transaction import settings

2022-10-06 Thread David Carlson
Where are the settings stored?  I thought I copied all the GnuCash stuff
from one computer to another Ubuntu machine.  I got my memorized reports
but not the CSV Transactions import settings.

-- 
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] HELP!!! How to purge everything from my windows pc before attempting a new re-install

2022-10-06 Thread David Carlson
Before resorting to such invasive surgery, have you used Task Manager to
verify that "Nothing happens" or is Gnucash doing something in the
background?

On Thu, Oct 6, 2022 at 9:32 AM  wrote:

> Somehow my gnucash is behaving very badly. a lot of the functionality from
> the main menu does not work.  For example, if I select export the account
> tree - nothing happens.
>
> If I selected add an account or edit an account nothing happens.
>
>
>
> I tried to uninstall and reinstall everything I could think of.  I did a
> search throughout my file system for any gnu-related files and removed them
> etc.  then did a re-install.
>
>
>
> I was surprised that gnucash actually remembered my recent files that were
> open, so I must be missing something when I tried to delete gnucash from my
> system before doing a reinstall .
>
>
>
> Can someone tell me how to remove EVERYTHING like all the configuration
> files, the ini files, registry entries etc?
>
>
>
> Or if you have a quick solution that would work???
>
>
>
> Installed gnucash 4.12, Windows 11 Home version 22H2
>
>
>
> Thank you
>
> ___
> 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] CSV transaction import settings

2022-10-06 Thread David Carlson
I went through that part of the FAQ  and I got lost with locations  and
paths and relative paths but no hard filename to search for with my
filemanager. If it is there I gave up in frustration before I found it.

On Thu, Oct 6, 2022 at 1:08 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> David,
>
> The Wiki FAQ has a section on file locations. I don't have the exact
> answer off-hand, but I'm sure one of those locations has what you are
> looking for. (allegedly, there are no other places used by GnuCash)
>
> Regards,
> Adrien
>
> On 10/6/22 8:49 AM, David Carlson wrote:
> > Where are the settings stored?  I thought I copied all the GnuCash stuff
> > from one computer to another Ubuntu machine.  I got my memorized reports
> > but not the CSV Transactions import settings.
> >
>
>
> ___
> 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] CSV transaction import settings

2022-10-06 Thread David Carlson
I didn't find that diagram. Thanks.  Maybe what I want is under

USER_CONFIG_HOME


On Thu, Oct 6, 2022 at 4:27 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> David,
>
> It looks like you want the chart here:
>
> https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
>
> 1. /home//.local/share/gnucash
> 2. /home//.local/share/gtk-3.0
> 3. /home//.config/gnucash
> 4. /home//.config/gtk-3.0
>
> One of those four directories should have the file you are looking for.
>
> Based on the expected files listed in that chart, I'd hazard that either
> #1 or #3 is the proper location.
>
> Regards,
> Adrien
>
> On 10/6/22 3:16 PM, David Carlson wrote:
> > I went through that part of the FAQ  and I got lost with locations  and
> > paths and relative paths but no hard filename to search for with my
> > filemanager. If it is there I gave up in frustration before I found 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
> -
> 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] CSV transaction import settings

2022-10-06 Thread David Carlson
Thanks Geoff.  Looks like there will be an editing task to get that into
the computer that doesn't have it.

On Thu, Oct 6, 2022 at 7:28 PM Geoff  wrote:

> Hi David
>
> On Windows 10**, there is a directory called:
>
> C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\
>
> Which contains a file for each set of books called:
>
> {BOOK_NAME}.gnucash.gcm
>
> In that file, there are, inter alia, sections for your saved CSV Import
> configurations that look like this:
>
> [Import csv,transaction - {BLAH BLAH}]
> Name={BLAH BLAH}
> SkipStartLines=1
> SkipEndLines=0
> SkipAltLines=false
> CsvFormat=true
> Separators=,
> DateFormat=1
> CurrencyFormat=0
> Encoding=UTF-8
> MultiSplit=true
> ColumnTypes=Date;Num;Description;Transaction
> Commodity;Action;Account;Deposit;Price;
>
>
> ** So, on Linux you will need to find that file using something like this:
>
> sudo find / -name {BOOK_NAME}.gnucash.gcm -print
>
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 7/10/2022 12:49 am, David Carlson wrote:
> > Where are the settings stored?  I thought I copied all the GnuCash stuff
> > from one computer to another Ubuntu machine.  I got my memorized reports
> > but not the CSV Transactions import settings.
> >
>


-- 
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] Problem with missing balance in a parent account

2022-10-07 Thread David Carlson
What version of GnuCash do you have now and is it the same as before?



On Fri, Oct 7, 2022, 11:44 AM Jay Ridgley  wrote:

> Good Morning,
>
> BRAND NEW to the list, have been using GnuCash on my Ubuntu system for
> over 20 years, this is the first problem I have encountered that I have
> not been able to resolve.
>
> I discovered that the balance amount that should appear in a the parent
> account for my bank is missing. Therefore I am unable to do this month's
> reconcile.
>
> The account was proper last month, and I was able to balance my
> checkbook successfully. In the meantime I upgraded to Ubuntu 22.04 LTS
> from 20.04 LTS every thing seems to running properly, otherwise,
> including GnuCash.
>
> Today when I tried to reconcile my bank account I discovered the amount
> of the balance is missing and the reconcile button is grayed
> out(naturally since nothing shows).
>
> All the sub accounts point to the parent account and when I list my
> accounts the balance appears there and is correct.
>
> What happened and how can I get it back?
>
> GREAT PACKAGE!
>
> Help please, thank Yyou
> Jay
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] graphing the price database vs. time

2022-10-07 Thread David Carlson
If you want prices instead of security value over time, that is easier to
get directly from Yahoo or Google finance.

For your securities use use the assets over time reports.



On Fri, Oct 7, 2022, 12:02 PM Elmar  wrote:

> I am looking through the various reports and cannot see how to graph the
> price database for the various investment entries as a function of
> time.  So either I need to know how to export the price database to csv
> for import to a spreadsheet program, or I need to know how to do a line
> chart in GC for the database.  Any ideas on how to accomplish this?
> Thanks. - Elmar
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] graphing the price database vs. time

2022-10-07 Thread David Carlson
That is another setting.  I like the stacked bar chart where I can get 10
or so bars, you might like something else.



On Fri, Oct 7, 2022 at 3:31 PM Elmar  wrote:

> Looked at that, but it lumps them all together, i.e. I have a half dozen
> stocks under retirement accounts.  I select children and all I get is one
> line.  It won't do a multi-line plot by investment.  The stacked bar plot
> is close but not what I want.  where and how is the price database
> encoded/stored in GC?
>
> - Elmar
> On 10/7/22 16:16, David Carlson wrote:
>
> If you want prices instead of security value over time, that is easier to
> get directly from Yahoo or Google finance.
>
> For your securities use use the assets over time reports.
>
>
>
> On Fri, Oct 7, 2022, 12:02 PM Elmar  wrote:
>
>> I am looking through the various reports and cannot see how to graph the
>> price database for the various investment entries as a function of
>> time.  So either I need to know how to export the price database to csv
>> for import to a spreadsheet program, or I need to know how to do a line
>> chart in GC for the database.  Any ideas on how to accomplish this?
>> Thanks. - Elmar
>> ___
>> 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] Move transactions from one account to another

2022-10-07 Thread David Carlson
Yes.  Edit Account A to make it a sub-Account of Account B.  Then delete
A.  You will be asked if you want Account A's transactions moved to B!!

On Fri, Oct 7, 2022 at 6:46 PM Carl S.  wrote:

> I want to move all of Account A's transactions into Account B.  Then
> delete Account B.
>
> Is there an easy way to do it?
>
> Thanks,
>
> Carl Smith
>
> ___
> 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] Stock/tickers Geoff

2022-10-09 Thread David Carlson
Those screenshots give more information than you realize.  I see that you
have installed GnuCash in the Linux Mint operating system.  While I have
not used  Linux Mint myself, I see from information available on
DistroWatch that Mint does not come with GnuCash pre-installed but it uses
the Debian package manager.  Thus you may have any of several different
versions of GnuCash and, in fact, any of several different versions of
Linux Mint.  Since you finally stated that you have GnuCash version 4.12,
it is possible that you have a flatpack version, which may have some quirks
different than versions available through the package manager.  While the
general principles of documenting securities in GnuCash have not changed,
some details have, so it is still of value to know the precise versions you
are using.  One area in particular that has been having  issues recently,
if you have been watching the maillist, is in downloading security prices
through the Finance/Quote module.

Your screenshots show that you have not completed the setup of a brokerage
account to contain your securities and to manage the currency transactions
that you need to purchase and sell securities as outlined in the chapter of
the help manual describing security investments.  You need to read that
chapter.  If you cannot access the manual with the F1 key, a common problem
with some GnuCash installations in Linux, you should go to the GnuCash
website and read it there.  Then you  can ask specific questions one
screenshot at a time and get good answers from the users and developers
that watch this maillist.

On Sun, Oct 9, 2022 at 3:08 PM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Geoff.I know we all make mistakes. As I am 76 years old/young. As I love
> the email you sent. I am going to read it again.i have Gnucash 4.12. As I
> know when the program was writen. it is not the same. As we need to stop
> and looking, see if we can do better.
>
> Below are some of the screen shots. I have about 8 in them. but only
> listed a few of them in the Gnucash.
> So for know. have a nice night or day.
> thanksJames baxterkangaro...@yahoo.com
> ___
> 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] Stock/tickers

2022-10-10 Thread David Carlson
James, you are still not replying to the list, so other users and
developers can provide the benefit of their experience.

Now we cannot tell if you tried to follow Geoff's suggestions and if so,
were you able to understand them.  It appears that you did not understand
all of it, but you did not ask for clarification of any of those steps, so
you will not get any clarification.

On Mon, Oct 10, 2022 at 6:09 PM Geoff  wrote:

> You are welcome James.
>
> Have a great day.
>
> Regards
>
> Geoff
> =
>
> On 11/10/2022 1:59 am, James Baxter wrote:
> > Geoff.
> > I don't know if I can thanks you enough. Also David Carlson was in here
> > as well.
> > I have 12 pices of Stock/tickers in Gnucash.
> >
> > I enter each into the stock, But I am finding that I have stock in two
> > places. "WHY" well that is to been seen. Where you add the stock to get
> > the prices. I when down the list and turned the arrows down. I can see
> > what I am looking for. I have 12 listed. worth over $23.000.
> >
> > Thanks Again
> > James Baxter
> > kangaro...@yahoo.com
> >
> > I replyed to this. Hope all is ok
> >
> >
> > On Monday, October 10, 2022 at 12:52:29 AM EDT, Geoff
> >  wrote:
> >
> >
> > Hello again James Baxter
> >
> >  >I know we all make mistakes.
> > Yes, don't worry, I make far more than my share of my very own mistakes
> > - just ask my wife about me!
> >
> >
> > Thank you very much for sending through those three screenshots.  That
> > is a good achievement, because many people on this GnuCash list have a
> > lot of difficulty in sending screenshots.  Well done you!
> >
> > In return, I am sending you four screenshots attached to this email.  I
> > am trying to show you how to record your purchase of 300 Amazon shares
> > at $113 each.  Please try and follow these four easy steps as follows:-
> >
> > (1) SCREENSHOT: gnc_jb1__Add_Security
> > The very first step is to open the Security Editor from the "Tools"
> > menu, then click "Add" to create a new Security for Amazon.
> > Please make sure you enter the details exactly as I have shown in this
> > screenshot.
> >
> > (2) SCREENSHOT: gnc_jb2__Link_Account_to_Security
> > The second step is to create a new Account (by clicking on the "New"
> > button) and linking it to your newly created Amazon Security.
> > Again, please enter the details exactly as I have shown.  This Account
> > must have a "Account Type" of "Stock".
> >
> > (3) SCREENSHOT: gnc_jb3__Get_Quotes
> > The third step is optional, but it gives us the opportunity to see if
> > you have successfully installed the Finance Quote module.
> > In this step, you open the Price Database from the "Tools" menu, then
> > click on the "Get Quotes" button and wait a minute or two to see if any
> > prices are retrieved.
> > DO NOT BE CONCERNED IF NOTHING HAPPENS OR YOU GET AN ERROR.
> >
> > (4) SCREENSHOT: gnc_jb4__Buy_Your_Shares
> > In the last step, you finally get to enter the details of your share
> > purchase.  Open up your newly created Amazon Account (by double clicking
> > on it) and enter the purchase transaction exactly as I have shown.
> > The Debit entry is to your Amazon stock account.
> > The Credit entry is to your bank account where the funds came from.
> >
> >
> > So James Baxter, I very much hope that these instructions and the
> > attached screenshots will enable you to make a little more progress on
> > your GnuCash journey.
> >
> >
> >  > As we need to stop and looking, see if we can do better.
> > And thank you too for this very good advice - I will indeed try to do
> > better.
> >
> > Please report back with your progress at your leisure.
> >
> > Best regards
> >
> > Geoff
> > =
> >
> >
> > On 10/10/2022 7:35 am, James Baxter via gnucash-user wrote:
> >  > Geoff.I know we all make mistakes. As I am 76 years old/young. As I
> > love the email you sent. I am going to read it again.i have Gnucash
> > 4.12. As I know when the program was writen. it is not the same. As we
> > need to stop and looking, see if we can do better.
> >  >
> >  > Below are some of the screen shots. I have about 8 in them. but only
> > listed a few of them in the Gnucash.
> >  > So for know. have a nice night or day.
> >  > thanksJames baxterkangaro...@yahoo.com
> > <mailto:baxterkangaro...@yahoo.com>
> >
> 

Re: [GNC] Enhancement request: multi-currency accounts

2022-10-18 Thread David Carlson
This is interesting and it might be an optional configuration for the
automatic account creation wizard, but not for most users who use a single
currency in their accounting.  Also, this is not the usual place to propose
enhancements, but it would be a good place to refine a concept prior to
making an actual proposal.

What do others think?

On Tue, Oct 18, 2022 at 3:54 PM Anton Tsyganenko 
wrote:

> Let's take a look on accounts that are created in gnucash by default.
> Generally most of the accounts may be multi-currency, i. e. not bond to
> a specific currency: you may have cash in multiple currencies, your
> opening balances may be in multiple currencies, you may have incomes and
> expenses in multiple currencies. Bank accounts generally have only one
> currency, but there are some banks that offer multi-currency cards and
> deposits. These surely can be considered as just a few different
> accounts, but it may be more convenient to group them together.Now I
> solve that by creating sub-accounts for each currency I need for each
> account where I need it. It looks like:
> Expenses:Dining:USD
> Expenses:Dining:EUR
> Expenses:Dining:CAD
> Expenses:Transport:USD
> Expenses:Transport:EUR
> Expenses:Transport:CAD
>
> It's very painful to create all of them. I know that I may have only one
> account in my _main_ currency, but I prefer all currencies to be equal
> and not perform redundant currency conversions, for example when I spend
> CAD cash for dining in Canada.
>
> So my proposal is:
>
> All accounts that user creates are "multi-currency", like placeholder
> accounts without any specific currency. Sub-accounts for each currency
> are created automatically, when the first operation in this currency in
> this account is made. If a multi-currency account is deleted and
> operations are moved to another account, operations in all the
> subaccounts are moved to the corresponding subaccounts of the second
> account. Balances can be shown as a sum of (non-null) amounts in
> different currencies (but sometimes can be converted to one currency).
> In a multi-currency account's view (basic ledger) there should be just
> an additional column -- currency of an operation (editable as a
> drop-down menu). So user opens account "cash" and sees something like:
>
> Date | Description | Transfer | Debit | Credit | Currency | Balance
>
> 2022-10-18 | Dinner in a restaurant | Expenses:Dining | | 25 | EUR | 100
> USD + 55 EUR
>
> That operation is a transfer of 25 EUR from Assets:Cash:EUR to
> Expenses:Dining:EUR.
>
> I would be happy to discuss the concept.
> ___
> 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] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-19 Thread David Carlson
First, you need to locate your last backup before your upgrade.  As has
been described here before, you need to start in the FAQ at 3.5 (
https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade)
and read the precautions.  Depending on your specific data it is usually a
good idea to go through the intermediate major versions and run check and
repair at each step, keeping backups at each step.  In some cases that can
take a very long time (hours) and GnuCash may appear to be frozen when it
is still cranking, so it behooves you to use a task manager to verify that
it is still working before concluding that it is stuck.  There is more
specific information somewhere else but I don't recall where it is.
Perhaps another user remembers where the more detailed instructions reside.

Good luck!


On Wed, Oct 19, 2022 at 7:12 AM Rosepetals  wrote:

> Hi all,
>
> I’m running Windows 11.
>
> I was running Gnucash 2.3.4 for years and finally decided to upgrade to the
> latest stable release of 4.12 so I can export to a spreadsheet.
>
> The setup needed to uninstall 2.3.4 which went fine and then 4.12 finished
> installing.
>
> I opened Gnucash 4.12 and opened my Gnucash database. It notified me I
> needed to upgrade the database to the new version which worked fine and I
> was able to access all my data. I made a few entries and closed Gnucash
> without any issues.
>
> Later I opened Gnucash again but this time it didn’t auto open the database
> and I'm left with a blank screen. I proceed to locate and open the database
> but after waiting for it to load, nothing appears. I try to load it
> manually in other ways but eventually Gnucash crashes.
>
> If it helps, the database is 30MB in size.
>
> Please help. I have 13 years of data here.
>
> Thanks for looking!
> ___
> 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] CSV transaction import settings

2022-10-19 Thread David Carlson
Geoff,

I finally found time to fire up the other computer that has the CSV import
settings for that data file and the needed GCM file.  I didn't want the
rest of the settings copied to the other computer, so I just copied out the
three import configurations and pasted them into the GCM in the other
computer.  Then I found them when I tried to import CSV files from those
financial institutions.

Again, thanks for your help.

On Thu, Oct 6, 2022 at 7:28 PM Geoff  wrote:

> Hi David
>
> On Windows 10**, there is a directory called:
>
> C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\
>
> Which contains a file for each set of books called:
>
> {BOOK_NAME}.gnucash.gcm
>
> In that file, there are, inter alia, sections for your saved CSV Import
> configurations that look like this:
>
> [Import csv,transaction - {BLAH BLAH}]
> Name={BLAH BLAH}
> SkipStartLines=1
> SkipEndLines=0
> SkipAltLines=false
> CsvFormat=true
> Separators=,
> DateFormat=1
> CurrencyFormat=0
> Encoding=UTF-8
> MultiSplit=true
> ColumnTypes=Date;Num;Description;Transaction
> Commodity;Action;Account;Deposit;Price;
>
>
> ** So, on Linux you will need to find that file using something like this:
>
> sudo find / -name {BOOK_NAME}.gnucash.gcm -print
>
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 7/10/2022 12:49 am, David Carlson wrote:
> > Where are the settings stored?  I thought I copied all the GnuCash stuff
> > from one computer to another Ubuntu machine.  I got my memorized reports
> > but not the CSV Transactions import settings.
> >
>


-- 
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] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-26 Thread David Carlson
Rosepetals,

I am not sure how the log files were constructed in that very early version
but since release 2.6-something they only contain changed information, so
they are usually less than a megabyte, depending on how often you do a file
save or allow or force the automatic backup.  A few times they can get
huge, one being after a check and repair or another  after a large 'Since
Last Run" execution.  The fact that you have several huge log files
suggests that your data file may not be getting saved after GnuCash starts
running.  On my computer I have turned off the automatic Since Last Run
execution on startup to gain better control when opening stale data files.

David Carlson

On Wed, Oct 26, 2022 at 7:17 AM Rosepetals  wrote:

> No worries. Thanks heaps for responding and your suggestions. It is much
> appreciated!
>
> Yes I presume they’re quite large because I’ve been using Gnucash for some
> time.
>
> A friend introduced it to me back then to help manage finances and I’ve
> been using it since.
>
> Thanks again!
>
> On Thu, 20 Oct 2022 at 11:28 pm, David T.  wrote:
>
> > I don't profess to have any great ideas, but I see from the one
> screenshot
> > that your file opens, but appears to be empty, and I see from the other
> > that you have numerous large log files (9mb or so) on every day of the
> > display. Many of them appear to be only a few days old.
> >
> > Personally, my log files are very small (measured in kilobytes, not
> > megabytes), so I am curious what you have been doing to get such large
> > files.
> >
> > David T.
> >
> > P.S. -- I can't imagine how you ended up using a development version of
> > GnuCash, and am sad to hear you've been using it all these years.
> > On Oct 20, 2022, at 2:05 PM, Rosepetals  wrote:
> >>
> >> Hi,
> >>
> >> Yes it was silly of me. I recall years ago checking if I could update
> to a
> >> newer version but the official site said it was not advised. Then I
> checked
> >> recently and it said yes it was possible so I went on my merry way
> thinking
> >> it would be more streamlined.
> >>
> >> I may have a backup from 2 years ago on version 2.3.4 but of course that
> >> would mean I wouldn’t have the recent 2 years of transactions.
> >>
> >> The file type is simply File so it may be XML but upon opening it in
> >> Notepad it mentions SQLite among the garbled text.
> >>
> >> I’ll try the trace tonight. For now I’ve left it running on 4.12 for
> about
> >> 30 mins and no result in opening the file as shown in the pic below.
> I’ve
> >> reinstalled 2.3.4 and tried opening the file but it’s stuck on reading.
> >> Will leave this for a while.
> >>
> >> Thank for your reply.
> >>
> >>
> >> On Thu, 20 Oct 2022 at 4:12 pm, David Cousens  >
> >> wrote:
> >>
> >>
> >>>  As Adrien pointed out anytime you do an upgrade of GNuCash you should
> >>>  ALWAYS
> >>>  make a backup copy of the data file before starting the upgrade and
> keep
> >>>  it at
> >>>  least until everything is working. It is a good practice to regularly
> make
> >>>  a
> >>>  backup copy of your data file in any case, preferrably to another
> computer,
> >>>  network storage or a cloud (online) storage, usb stick etc. If you
> have
> >>>  problems
> >>>  then you can always copy (not move) the file from your backup to your
> data
> >>>  directory and start again. Are you using the xml file (a text file)
> or an
> >>>  actual database backend?
> >>>
> >>>  The datafile format sometimes has to be changed to accomodate new
> features
> >>>  and
> >>>  fix some bugs. If such changes occur it is usually when changing from
> the
> >>>  last
> >>>  version of a major series to the first version of the next. Version
> 4.x
> >>>  will
> >>>  assume that the file has already been upgraded from version 2 to
> version
> >>>  3. Each
> >>>  new major version of GnuCash includes a procedure for updating the
> >>>  datafile the
> >>>  first time it is run with a higher version.
> >>>
> >>>  As well as changes in the datafile itself, there are sometimes
> changes in
> >>>  the
> >>>  locations where stored reports and user preference data etc are
> located.
> >>>  These
> >>>  are usually translated by the installation procedure f

Re: [GNC] Lost my checking account, my backup won't work

2022-10-27 Thread David Carlson
It is impossible to help when you do not provide any technical details
about your problem.

On Thu, Oct 27, 2022 at 3:25 AM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Yesterday as I was looking to add items to my check account. I noticed
> that it won't open. My stock/tickers will. I do backup my laptop every
> night. But for some reason.  It won't work or back up.
> Need helpJames Baxter kangaro...@yahoo.com
>
> Sent from Yahoo Mail on Android
> ___
> 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] Lost my checking account, my backup won't work

2022-10-27 Thread David Carlson
James,

Do not reply to individuals, only reply to list.  See the text at the end
of any message in the list for instructions.

>From your screenshot I do not see any checking account in your account
list.  That would explain why you cannot add checking transactions.  I have
no idea what "it" is that was asking for folders, but it is not GnuCash.  I
would also suggest turning off your spellchecker, as it is garbling up your
messages.

On Thu, Oct 27, 2022 at 1:18 PM James Baxter  wrote:

> Geoff and David.
> Gentlemen. As I hope you don't mind me send you an email. So I hope you
> are getting the screen shot. And thanks Geoff for you idea.
>
> I was looking over the screen shots you gave me. As i don't fine the
> checking account listen. I have my backup drive in for know. As when
> Gnucash opened. It was asking me for some folders, I did not understand
> that, As I only have one laptop.
>
> Yes, I tried to backup from the drive, But that did not work. I was
> looking at going to current assets and making a new item like the checking
> account. But I don't know if that will work.
>
> When I entered Stock/tickers. That is what I did.
>
> as for know. I don't know. As I hope you two don't mind.
> thanks
> James Baxter
> kangaro...@yahoo.com
> On Thursday, October 27, 2022 at 06:26:27 AM EDT, Geoff <
> cleanoutmys...@gmail.com> wrote:
>
>
> Hello James
>
> I am pleased that you backup your laptop every night.  This is a prudent
> and sensible practice to adopt.
>
> Now to the problem with your missing check account.  As David said in
> his reply to you, it is difficult for us to assist you in this case
> unless you include a screenshot.
>
> But I am going to make a guess.  Please try these three easy steps and
> see if it works:-
>
> 1. Click on the "View" menu
> 2. Click on the "New Accounts Page" option
> 3. Expand your Assets until your Check Account appears.
>
> I have attached a screenshot which shows you those 3 steps, and I hope
> that it will assist you to solve your problem.
>
> Nice to hear from you again!
>
> Regards
>
> Geoff
> =
>
> On 27/10/2022 10:25 am, James Baxter via gnucash-user wrote:
> > Yesterday as I was looking to add items to my check account. I noticed
> that it won't open. My stock/tickers will. I do backup my laptop every
> night. But for some reason.  It won't work or back up.
> > Need helpJames Baxter kangaro...@yahoo.com
> >
> > Sent from Yahoo Mail on Android
>
> > ___
> > 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] Unable to import CSV with charges and payments

2022-10-28 Thread David Carlson
I have found that some financial institutions do not structure their CSV
files with opposite positive or negative values for charges vs payments.
Then it becomes a challenge for GnuCash to make the differentiation for
us.  It might be necessary to pre process your file by changing the sign
for one of the types manually before importing it.  I am "lucky" that the
one such company that I import from also exports in QRM, oops, I mean QFX
format, but it reverses the sign for both charges and payments in that
format.  Oh, well.

On Fri, Oct 28, 2022 at 5:42 PM R C  wrote:

> How do I import a csv with both charges and payments.  When I try, it only
> imports one type and puts everything in there.
>
> --
>
> ~
> The problem isn't how much you make, it's how much you spend.
> "I have not failed. I've just found 10,000 ways that won't work." - Thomas
> Edison
> ___
> 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] Entires in 'Receive' and 'Spend' in my cash account are inversed...how to correct?

2022-10-30 Thread David Carlson
Claire,

No, you cannot change the sign of a group of existing transactions.  You
must enter minus signs one at a time, but it goes reasonably fast once you
figure out your finger placement and develop a rhythm (really,I have to do
it every month for one credit card account that always imports backward).
I start by setting the view to Transaction Journal so I can monitor my
progress more easily.

On Sun, Oct 30, 2022 at 5:56 PM David Cousens 
wrote:

> Claire,
>
> You might want to check the Preference Settings (Menu_>Edit->Preferences)
> in the
> Account tab. I think the default is only to have reverse balances selected
> on
> credit card accounts. It is meant to deal with situations where banks
> (which
> normally provide data and statements from their internal accounting
> perspective)
> supply data from customers accounting perspective.
>
> David Cousens
>
> On Sun, 2022-10-30 at 22:12 +, Claire Light via gnucash-user wrote:
> > Hello,
> >
> > I was opening a few new credit card and personal accounts yesterday, for
> which
> > there was no issue but my cash account is now reversed for a lack of a
> better
> > word. I have no idea what happened.
> >
> > Is there any way that I can change the name of the columns in my cash
> account,
> > since they are now reversed? Replace 'receive' with 'spend' and vice
> versa?
> > ...or can I copy and paste the 'receive' entries into the 'spend' column.
> > There are few actual 'receive' entries that I could copy and paste
> manually.
> >
> > Thank you for your attention..any assistance would be appreciated.
> > Claire Light
> >
> > Sent with [Proton Mail](https://proton.me/) secure email.
> > ___
> > 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] XML or database?

2022-11-01 Thread David Carlson
Besides the reminder on exit, if a file has unsaved data, there is an
asterisk to the left of the filename in the titlebar and the "Save" icon is
*NOT* greyed out.

On Tue, Nov 1, 2022 at 2:01 AM John Layman 
wrote:

> I initially configured GnuCash for periodic backups, but found the
> disruption annoying.  You are free to save the file at will, and, yes, if
> the file is "dirty" you'll get a reminder when you exit the program.
>
> -Original Message-
> From: gnucash-user 
> On Behalf Of R Losey
> Sent: Monday, October 31, 2022 11:15 AM
> To: Derek Atkins 
> Cc: Gnucash Users 
> Subject: Re: [GNC] XML or database?
>
> That helps - thanks!
>
> I assume that if I attempt to quit GnuCash with unsaved data, it will
> remind
> me to save... but the current indications of unsaved data files have been
> sufficient to remind me to save the data.
>
> If you have data going back 15 years, I'm just getting started with 6 years
> (heh).
>
>
>
> On Mon, Oct 31, 2022 at 8:31 AM Derek Atkins  wrote:
>
> > Hi,
> >
> > On Mon, October 31, 2022 9:14 am, R Losey wrote:
> > > This question may have been asked before, but I'm relatively new to
> > > this mailing list.
> > >
> > > Is there any advantage to switching to the database format? Would it
> > > use less space? My ".gnucash" file is about 1.5M currently, and
> > > opening it takes mere seconds.
> >
> > The main advantage of using the SQL backend is that all changes are
> > "saved" immediately, so you wont lose data because you "forgot to save"
> >
> > But no, the DB is most definitely NOT smaller; the XML file is
> > compressed on save, so that 1.5MB would probably be more like 10-20MB of
> DB.
> >
> > > Long ago in my Quicken days, I would generally keep about 3 years of
> > data
> > > and then "archive" transactions older than that... I don't know if
> > GnuCash
> > > has (or needs) any similar feature.
> >
> > For what it's worth, I have data going back to like 2007 in my file.
> > GnuCash does not really have an "archive" function (although there
> > have been 3rd party tools that do that.
> >
> > Hope that helps!
> >
> >  _
> > > Richard Losey
> > > rlo...@gmail.com
> >
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > --
> >Derek Atkins 617-623-3745
> >de...@ihtfp.com www.ihtfp.com
> >Computer and Internet Security Consultant
> >
> >
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> 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] Looking for stock prices over the web

2022-11-01 Thread David Carlson
What is your question?

On Tue, Nov 1, 2022 at 4:16 PM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> As I go to see what the prices are over the web.  As I was told by Geoff
> to get screen shots. I tried to get a screen shot of the one, Sorry. there
> was a problem. As it did not take one. As I am hopping this one works.It
> shows the last one from 10/14/2022. (I think that is right) I open up the
> items/Stock on two of them.So It wont do it by itself.
> thanksJames baxterkangaro...@yahoo.com
> ___
> 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] Gnu Cash / UNrealised Losses in Trial balance

2022-11-04 Thread David Carlson
You are on the right track.  The unrealized losses probably came from some
transaction involving another currency exchange with your primary currency
or, as Derek hinted, two or more transactions involving a security or other
commodity.  You can adjust the date range of the report to narrow down the
group of transactions to search for the source of the issue.  To eliminate
the loss you would need to add a transaction to convert the unrealized loss
to a realized loss.  Others here can give specific advice once you have
found the offending transactions.

On Fri, Nov 4, 2022 at 8:26 AM Eid Eid  wrote:

> Thank you,
>
> In my case, this seems to be related to the EUR/USD rate.
> When I print a trial Balance, and I change which rate to use "Nearest in
> time, Last recorded price, etc.." this figure (UNrealised losses) is
> changing. I do not have inventory.
>
> So I feel this is "Difference of Exchange" . Is my understanding correct?
>
> Thanks,
>
> EE
>
>
> -Original Message-
> From: Derek Atkins 
> Sent: Tuesday, November 1, 2022 8:16 PM
> To: Eid Eid 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Gnu Cash / UNrealised Losses in Trial balance
>
> Hi,
>
> On Tue, November 1, 2022 1:53 pm, Eid Eid wrote:
> > HI to all.
> > I am getting an amount as Unrealized losses in my trial balance, and
> > this is popping up while enot being related to a given
> > registry/account. It seems to be generated by the system, and by
> > playing around, I am convinced it is related to Difference of Exchange.
> > Can someone explain to me what this is, and how to get rid of it?
> >
> > Thank you,
>
> You buy 10 widgets at $10 each.
> You sell 5 widgets at $15 each.
>
> You need to account for that (realized) gain.
>
> Now the widget price increases to $20 each.  That would be unrealized
> gain..
>
> >
> > Eid E. Eid
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] Found a bug, accounts gone haywire.

2022-11-05 Thread David Carlson
Over the years my most serious problems with GnuCash or even other programs
like office or spreadsheets have often been traced to hardware problems
like running out of hard drive space or RAM, etc.  It's worth trying to
eliminate such possibilities while you still have good backups off line.

On Sat, Nov 5, 2022 at 7:12 PM Michael Davis  wrote:

> Thanks, but what do you mean by file verification? In the Tools menu I
> found Check and Repair, I ran that but it didn’t help.
>
> cheers
> MD
>
> > On Nov 5, 2022, at 3:53 PM, R Losey  wrote:
> >
> > I've not seen this problem (I've been using GnuCash for 6 years, and my
> data files is about 1.6M).
> >
> > Have you done a file verification?
> >
> > Do you routinely update GnuCash as updates come out?
> >
> >
> >
> > On Fri, Nov 4, 2022 at 6:10 PM Michael Davis  wrote:
> > Hi all,
> >
> > I just joined this group to report this problem. I’ve been using GnuCash
> for more than 15 years and I’ve never before had a problem with it.
> >
> > It does have more than 15 years of data in it, the file size is 2.4MB.
> >
> > When I opened it a couple of days ago, some of the accounts were messed
> up. For example, I’ve got a liability account for my credit card, the
> balance should be a credit of a couple of thousand. But now it’s a debit of
> over 600,000. Looking at the transactions, it starts at zero and adds every
> transaction as a debit, sort of like this:
> >
> >
> > debit | credit  | balance
> >   | | 0.00
> > 10.00 | | 10.00
> >   | 20.00   | 30.00
> > …
> >   | | 621,245.35
> >
> >
> > Has anyone else seen this?
> >
> > thanks
> > Michael Davis
> > Ottawa, Canada
> >
> >
> >
> > ___
> > 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.
> >
> >
> > --
> > _
> > Richard Losey
> > rlo...@gmail.com
> > Micah 6:8
>
> ___
> 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] edit stock/tickers

2022-11-06 Thread David Carlson
Geoff created a very nice wiki page detailing how to add a security
https://wiki.gnucash.org/wiki/Stocks/add_stock.

Note that the parent account for a security account cannot be a security
account.  It would normally be an asset account.

 Usually you choose the asset account that represents your brokerage
account or a sub account of that account if you want more detail.  The
Tutorial shows several asset sub accounts under the brokerage account with
the stocks and other commodities distributed under those but you aren't
required to have that extra layer..  I put my security accounts directly
under the asset account that represents my brokerage account.  You do need
to choose the parent account first before choosing the security when
setting up the security account.

On Sun, Nov 6, 2022 at 10:28 AM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I am looking at editing the stock/tickers. As I started with Amzn. As I
> was looking for a screen shot of the item that showed up. As it did not do
> that. So, The screen shows the AMZN and I click on the stock. As AMZN is
> the 1st one to show.
> When I click on "OK" the msge shows up, "You must choose a valid parent
> account". So. Am I looking for something I don't really need. Does one of
> the item need to be checked.
> Thanks for your help.James baxterkangaro...@yahoo.com
> ___
> 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] getting stock/ticker prices

2022-11-10 Thread David Carlson
Read John Layman's response to your email from yesterday.

On Thu, Nov 10, 2022 at 7:23 AM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> AS I read some of items that was left about stock/tickers. So if the
> system is not working, I know I can go to Google fincances and get what I
> need. So can Gnucash be set to work with Google or Yahoo.
>
> ThanksJames Baxter
> ___
> 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] getting stock/ticker prices

2022-11-10 Thread David Carlson
*Please reply to list.*


*Read section 5.4.2 of the help manual.*

On Thu, Nov 10, 2022 at 12:56 PM James Baxter  wrote:

> David Carlson
> Sir, thanks. But how do you get Yahoo into the Gnucash.
>
> Thanks
> James Baxter
>
> Sent from Yahoo Mail on Android
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
> On Thu, Nov 10, 2022 at 1:47 PM, David Carlson
>  wrote:
> Read John Layman's response to your email from yesterday.
>
> On Thu, Nov 10, 2022 at 7:23 AM James Baxter via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> AS I read some of items that was left about stock/tickers. So if the
> system is not working, I know I can go to Google fincances and get what I
> need. So can Gnucash be set to work with Google or Yahoo.
>
> ThanksJames Baxter
>
> ___
> 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
>
>

-- 
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] Tracking Travel expenses

2022-11-14 Thread David Carlson
back when I was travelling for business I set up accounts to match the
expense forms that my company used.

On Mon, Nov 14, 2022 at 2:10 PM Esteban Maringolo 
wrote:

> What is the recommended account setup and procedure to track
> travel expenses (and refund of these) when I use my personal accounts
> (cash/credit card) to pay these?
>
> I don't want the travel expenses to mix with my regular "monthly" expenses,
> although I'd like to split them into different categories (food, gas,
> hotel, etc.).
>
> Thanks!
>
> Esteban A. Maringolo
> ___
> 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] How do I install recent version on Ubuntu?

2022-11-17 Thread David Carlson
You can get release .4.8 as a PPA for Ubuntu 22.04.  I think that is fairly
close to current, dated last February 9.  IIRC, I got it from the main
Ububntu Jammy PPA .

On Wed, Nov 16, 2022 at 9:49 PM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Thu, 17 Nov 2022 at 00:20, David H  wrote:
>
> > You can either compile it yourself  (
> > https://wiki.gnucash.org/wiki/Building_On_Linux) or use the pre-compiled
> > flatpak version (https://wiki.gnucash.org/wiki/Flatpak) otherwise you're
> > stuck with whatever is packaged with your Ubuntu release. I use the
> Flatpak
> > version - so much easier :-)
> >
> > Cheers David H.
> >
>
> Thank you. I did see information on the web about using flatpack, but it
> was not mentioned on the GnuCash website, so I was a bit reluctant to take
> that route.
>
> I will install the flatpack for now. I might look at the possibility of
> adding some cryptocurrencies if I built from source code.
>
> Dave.
>
>
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] can't find gnucash on my computer

2022-11-20 Thread David Carlson
Sally,

GnuCash has advanced considerably since release 3.11.  If your Quicken file
is large you should expect to find that the migration process has lots of
bumps and may be very time consuming.  Then the migration to a more current
version of GnuCash in a different OS would be additional work.  I suggest
postponing the Quicken import until after you have release 4.8 or newer of
GnuCash running in whatever OS you are planning on migrating to.  GnuCash
runs nicely in several different flavors of Linux.  I am running 4.8 in
both Lubuntu 22.04 and Ubuntu 22.04.

On Sun, Nov 20, 2022 at 4:00 PM Stan Brown 
wrote:

> It's a while since I installed GnuCash on Windows 7, but I think I
> remember that the installation doesn't create an icon. (Or it does
> create one, but only if that option is checked during the install, and
> you didn't do that.)
>
> Did you receive any error messages during installation? I'm assuming no,
> but if you did then please tell us what they were.
>
> If you received no errors, go to Control Panel » Programs and Features
> and verify that GnuCash is in the list of installed programs. If it's
> not, then reinstall GnuCash and watch carefully for any options during
> install.
>
> If GnuCash is in the Programs and Features list, then you probably need
> to create an icon yourself.
>
> 1. Go to C:\Program Files (x86)\gnucash. (If that doesn't exist, go to
> C:\Program Files\GnuCash.) Double-click the "bin" folder.
>
> 2. In the file list, locate GnuCash.exe. If you don't see it, but see
> one or more files called GnuCash, identify the one that has type
> Application.
>
> 3. Right-click that file, and drag it to an empty spot on the desktop.
> When you release the right-hand mouse button, select Create Shortcut
> Here in the menu that pops up.
>
> 4. If you just want a desktop icon, you're done. Move it to wherever you
> want it on the desktop.
>
> 5. If you want an entry in the Start Menu, copy this exact text with
> Ctrl+C and then paste it into Explorer's location bar with Ctrl+V:
> %ProgramData%\Microsoft\Windows\Start Menu
>
> 6. That opens your Start Menu in a File Explorer view. Move or copy the
> icon from your desktop to wherever you want it in your Start Menu.
>
> The change in the menu should be effective immediately, but worst case
> is you'd need to log off and log on again.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
>
> On 2022-11-20 12:00, Sally Abrams via gnucash-user wrote:
> > I’m using windows 7.  I downloaded the one they said was for windows
> 7-10. 3.11.  Thanks for any help.
> >
> >> On Nov 20, 2022, at 11:46 AM, Stephen M. Butler <
> stephen.m.butle...@gmail.com> wrote:
> >>
> >> What O/S?  Windows, Mac, Linux (flavor)?  Which version of O/S?
> >>
> >> Which version of GnuCash did you download?
> >>
> >>> On 11/20/22 11:29, Sally Abrams via gnucash-user wrote:
> >>> I downloaded gnucash.  Ran the set up, even tried restarting my
> computer but no icon and when I search my computer only the setup file
> shows up.  Its not showing up in programs.  When I ran set up again, it
> told me program was on my computer and it uninstalled it so it could
> reinstall it but my computer still can't find it.  i'm on windows 7.  I'm
> planning on upgrading my computer but first want to move my data from
> quicken to gnucash.  thanks for any help.
> ___________
> 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] Automatic Price Updates

2022-11-25 Thread David Carlson
Is your price update so slow that you cannot wait for it to finish before
proceeding with other tasks?

Even when l immediately execute a File Save right after an update it only
takes ten or fifteen seconds or so, far more than the actual data download
time with my data file.




On Fri, Nov 25, 2022, 9:27 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> >
> > I have noticed that when I have GC open interactively, I can start an
> > update in the price database window and let it run in the background
> > while I continue to work in the registers.
>
> Just an alert.
>
> When we say that while gnucash is safe for multiple sequential users but
> not for multiple simultaneous users this is not to be saying that "user"
> implies a human user. In the general case, a user could be a process.
> Look at what you are doing in those terms.
>
> Are you SURE that it is absolutely impossible that you would be doing
> anything while working in a register that would involve one of those
> prices that are being updated? Ignore that might be very low
> probability, never means never, because an error resulting from a
> "concurrent processing error" is not something the support team will be
> in a position to debug for you*.
>
> Michael D Novack
>
> * Exceedingly difficult to reproduce as timing critical. In other words,
> bugs of this sort are to be avoided rather than fixed. Do no concurrent
> processing unless the application is running under the control of a DBM
> (database manager)
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] getting price quotes

2022-11-28 Thread David Carlson
For securities traded on U. S. Exchanges it usually works well to use Yahoo
as JSON as your source.

On Mon, Nov 28, 2022, 8:17 AM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> When I go for the stock prices, I get a, Cant get stock prices.  I when to
> the where the stock/tickers are. As I edited three of them. As I notice
> they are going/looking at Alphavantage, US.  so I did something wrong or
> not.
> ThanksJames baxterkangaro...@yahoo.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] can't create a transaction report

2022-11-28 Thread David Carlson
I think these numbering conventions have been in place almost as long as
Microsoft has used local time for time stamps in MS-DOS.  I think they
should not be abandoned until the respective media are abandoned.

On Mon, Nov 28, 2022 at 4:32 PM William Prescott 
wrote:

> While I agree that 4.01, 4.02, ... 4.10, 4.11, 4.12 would be more
> rational, in fact  it is traditional or at least extremely common in
> version numbering to use: 4.1, 4.2,... 4.9, 4.10, 4.11, 4.12 etc.
>
> In fact, 4.01 would have different implications about the nature of the
> release than 4.1. 4.01 would likely be a bug fix on 4.0 rather than a new
> release with more major changes.
>
> Will
>
> On Nov 28, 2022, at 15:18, R Losey  wrote:
>
> This brings up a good point; perhaps GnuCash should always use two-digit
> numbering; instead of 4.1, 4.2,... 4.9, 4.10, 4.11, use
>
> 4.01, 4.02,... and so on.
>
> That way, people won't confuse 4.1 and 4.10 (or think that 4.2 is newer
> than 4.12 because 4.2 is a bigger number than 4.12).
>
>
>
> On Sun, Nov 27, 2022 at 7:14 PM ph hermes  wrote:
>
> > i looked on the apple store and there was no gnu cash. i thought 4.2 was
> > more recent than 4.12...
> >
> > but i'll try that anyway.
> >
> > thanks.
> >
> >   ph
> >
> > ~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:
> > writer ~:~ photographer ~:~ book designer
> > resident manager
> > paulahendricks.com
> >
> >
> > On Sun, Nov 27, 2022 at 1:01 PM David H  wrote:
> >
> >> Why don't you install 4.12 which was released recently - lots of fixes
> > and
> >> improvements since 4.2 
> >>
> >> Cheers David H.
> >>
> >>
> >> On Mon, 28 Nov 2022 at 06:34, ph hermes 
> wrote:
> >>
> >>> hi all
> >>>
> >>> i'm using gnu cash 4.2 on  my mac ventura 13.0, and can't create a
> >>> transaction report (which i've done many times before today).
> >>>
> >>> i'm trying to create a report for 2021.
> >>>
> >>> i start the process (reports, transaction reports) then go into options
> > to
> >>> select accounts, type of report, date etc.). when i hit any of those
> >>> options the transaction blinks out. or it takes 1 selection but not
> all.
> >>> and the general accounts page option disappears too.
> >>>
> >>> i've tried quitting gnucash, starting over (it opens with bad
> > transaction
> >>> report options rather than accounts).
> >>>
> >>> i've tried restarting my mac and completing shutting it down and
> > starting
> >>> over.
> >>>
> >>> what am i missing? any help appreciated.
> >>>
> >>> thanks.
> >>>
> >>>ph
> >>>
> >>> ~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:
> >>> writer ~:~ photographer ~:~ book designer
> >>> resident manager
> >>> paulahendricks.com
> >>> ___
> >>> 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.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> 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] How can I enter all fixed assets?

2022-11-29 Thread David Carlson
In the U. S. each of those assets would be depreciated on it's own
schedule, so each would have it's separate table of depreciation if you are
planning on tracking that.

On Tue, Nov 29, 2022, 7:19 PM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> I want to start using GnuCash for a company I set up several years ago. The
> company has some assets - mainly electronic test equipment. Let’s
> hypothetically assume
>
> VNA £1000
> Signal generator £500
> Frequency counter £250
> Calibration kit £2000
>
> Total is £3750
>
>
> Is there a way of entering the individual items into GnuCash? I realise
> that I can create an account
>
> Assets -> Test equipment
>
> with an opening balance of £3750, but that doesn’t itemise individual
> items.
>
> It would be a bit tedious to create accounts for every item individually
>
> Assets -> Test equipment -> VNA
> Assets -> Test equipment -> Signal generator
> Assets -> Test equipment -> Frequency counter
>
> and set each to have an appropriate opening balance.
>
>
>
>
>
>
>
>
>
>
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Disabling Lots Manager

2022-12-04 Thread David Carlson
David, IIRC for databases that have never had the lots functionality
enabled,  it remains disabled.   This leads to the hope that it would be
possible to disable it, but that may or may not work.  At least,  in my
case I never enabled it outside of one dedicated test case and it seems to
remain disabled as far as I can tell.

>From your description,  it appears to be fraught with problems, so let's
hope that it's affects can be purged from a database.   In a perfect world
there would be a simple setting or procedure to accomplish that.

Can a developer or other user help with this?



On Sun, Dec 4, 2022, 5:04 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> Gnucash 4.11 Windows 10
>
> Having struggled once again with the extremely unreliable aspects of the
> Lots Manager, I am resigned to the fact that, while an admirable
> endeavor in concept, the Lots Manager is more trouble than it is worth,
> and leads to books that cannot be considered accurate over the long term.
>
> For the worst of these, see
> https://bugs.gnucash.org/show_bug.cgi?id=798583 regarding how the Lots
> Manager will change RECONCILED GAINS TRANSACTIONS silently. A second
> complaint I have is that if there is a Lot-generated gain transaction in
> the register, deleting this gain transaction ALSO DELETES THE SALE
> TRANSACTION. I can't imagine why this would be considered an appropriate
> linkage to embed in the code, and there's nothing in the register to
> indicate this linkage. I'm also not pleased that I have had frequent
> crashes using the Lot Manager, to the extent that I have had to
> reconcile the same accounts multiple times in a single day. That gets
> old faster than I do.
>
> Today, I'm hoping for two things:
>
> First, I'd like to be able to determine which accounts in my books have
> lots embedded in them, so that I can go through and remove the lots and
> ensure that my books don't get corrupted YET AGAIN by this code. Any
> ideas on how to expose (and root out and eliminate) these lots is welcome.
>
> Second, I would like to find a way to disable the Lots manager entirely
> for my books, so that I don't EVER make the mistaken assumption that the
> Lot Manager is a tool I can use with confidence. I recognize that this
> second ask is unlikely to be possible, but I am nevertheless curious to
> know how complicated it might be to strip out the code altogether in my
> own fork so that it doesn't cause me any more anguish.
>
> David T.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread David Carlson
Scott,

If I understand correctly, what you expected was a chart of accounts with
one asset account for checking and all other accounts lumped under
expenses.  Maybe one account for income.

You should be able to get to that result with an import from Quicken  but
it may take some or perhaps a lot of manipulation depending on the
condition of your source.  You don't really need to reduce all the expense
accounts into one because they are already collected under the single top
account called Expense.

Good luck

On Sun, Dec 4, 2022, 11:57 AM Fred Bone  wrote:

> On 04 December 2022 at 11:54, Scott Traurig said:
>
> > I do understand double-entry accounting and that it is the GnuCash
> > paradigm.
> >
> > What I didn't understand is that on the import GnuCash did create the
> > requisite checking account, plus all the expense accounts. I did not see
> > the checking account as it was lost in a sea of expense accounts.
> >
> > Now that I've gotten that far, is there any way to move accounts en masse
> > into a top level "Expenses" account? Or do I have to laboriously edit
> each
> > and every one?
>
> What *might* work is to delete the unwanted accounts.
>
> When you delete an account, Gnucash will ask what you want to do with the
> transactions in it. You can move them to another (already existing)
> account. This will let you (for example) consolidate the grocery
> transactions, with 17 different vendors, into one "Expenses:Grocery"
> account.
>
> If you really want all the expenses in a single account then I suggest
> you don't want an accounting system and Gnucash is not the solution you
> are looking for.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account

2022-12-04 Thread David Carlson
What you need to do is start a new file and position those expenses
correctly under the the top expense level during the import process.  That
is not really very hard with a couple of expendable tries to see how it
works.



On Sun, Dec 4, 2022, 12:17 PM Scott Traurig  wrote:

> Nope, sorry, you gents did not understand my question.
>
> I don't have any unwanted accounts. Indeed, all of my categories in Quicken
> were well thought out and organized, and well replicated as separate
> expense accounts in GnuCash via the import process.
>
> But with some 100 different, well organized and well thought out expense
> accounts, I don't want them all at the top level, which is where GnuCash
> puts them upon import.
>
> In the GnuCash paradigm, I now have top level placeholder accounts for
> assets, liabilities, income and expenses. For income, assets and
> liabilities it was not much of a chore to move those few accounts that were
> imported to be under their proper, respective placeholders in
> the hierarchy. But now I need to move all 100 or so expense accounts,
> intact, from the top level to underneath the top level, placeholder expense
> account. That's a huge PITA if I have to edit the properties of each one
> individually. Drag and drop would be a modern UI method for this, alas it
> does not exist in GnuCash.
>
> Is there an easy way to do this, or just grunt it out?
>
> Thanks,
>
> Scott
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] [GNC-dev] URGENT: Fake gnucash website with fake download, most likely compromised file

2022-12-09 Thread David Carlson
Mystery deepens!  When I tried to open this fake website it was not
available in Tor browser but pinging it revealed a response from IPV6
address 2606:4700:3030::6815:5f93.  That IP does not seem to be registered

On Fri, Dec 9, 2022 at 5:40 PM Vincent Dawans  wrote:

> Added screenshot showing fake gnucash site ad at top of google results.
>
> On Fri, Dec 9, 2022 at 3:31 PM Vincent Dawans  wrote:
>
> > Precision: the link to the fake site reported below is actually
> > https://gnu-cash.org/main.php -- you need the full page link to see the
> > fake site that shows in the google ad.
> >
> > On Fri, Dec 9, 2022 at 3:24 PM Vincent Dawans  wrote:
> >
> >> I just typed gnucash in google and the first hit was an ad pointing to
> >> gnu-cash.org (with a dash). It is a fake site that is a carbon copy of
> >> the official site but the download link goes to a setup.exe that is most
> >> likely a corrupted virus file.
> >>
> >> We need this removed ASAP. There is an option in google to report the
> >> site and mark it as spam/phishing. I imagine if more people do this it
> will
> >> get removed faster hopefully.
> >>
> >
> ___________
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
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] unable to import simple investment transaction from qif

2022-12-11 Thread David Carlson
If you are using a recent release of GnuCash, ie 4.something, the csv
transaction import feature has been greatly improved and includes the
ability to save and re-use settings .

It definitely works to import investment transactions previously exported
from GnuCash,  so it should work with generic files as well, possibly with
some massage.

I don't know if the qif import process can handle investments even though
Quicken can export them in that format it requires split transactions which
qif importer seems to choke on.



On Sun, Dec 11, 2022, 7:25 PM ar  wrote:

> Hi,
>
> I am trying to import avery simple transaction from qif: just 2 buy
> transaction for the same account, containing  mutual fund 
>
> The 'Assets:Investments:X' is gnu cash account tracking shares of ,
> 'Asserts:Investments:' is a gnucash cash account.
>
> If I do not provide security symbol as below, the import fails when it
> requires to enter the security.
>
> !Account
> NAssets:Investments:X
> TInvst
> ^
> !Type:Invst
> D07/16'2022
> NBuy
> LAssets:Investments:Y
> Q34.107
> T-77.58
> ^
> D07/15'2022
> NBuy
> LAssets:Investments:Y
> Q7.638
> T-37.7
> ^
>
> I provide security as Y, the import creates account
> Assets:Investments:X: that conflicts with
> 'Assets:Investments:X'
>
> 1. Does this feature works? If Yes are there usage examples.
> 2. I do not insist on using qif format, is it possible to use .csv for
> import, are there examples?
> 3. It seems that csv import requires a lot of manual selections to be made
> for every imported file, am I getting it right?
>
> Thank you,
>
> Aleksey
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] unable to import simple investment transaction from qif

2022-12-12 Thread David Carlson
Ar,
Please reply to all so others can see and perhaps provide additional
information. I have done that for you this time.

I do not have an example but you can create one by exporting an existing
transaction.

On Mon, Dec 12, 2022, 7:34 AM ar  wrote:

> Hi David,
>
> I am using 4.12 unfortunately I was not able to find any example of using
> the greatly improved csv for the import of investment data.
>
> I would appreciate a pointer.
>
> Thank you,
>
> Aleksey
>
>
> On Sun, Dec 11, 2022 at 9:19 PM David Carlson 
> wrote:
>
>> If you are using a recent release of GnuCash, ie 4.something, the csv
>> transaction import feature has been greatly improved and includes the
>> ability to save and re-use settings .
>>
>> It definitely works to import investment transactions previously exported
>> from GnuCash,  so it should work with generic files as well, possibly with
>> some massage.
>>
>> I don't know if the qif import process can handle investments even though
>> Quicken can export them in that format it requires split transactions which
>> qif importer seems to choke on.
>>
>>
>>
>> On Sun, Dec 11, 2022, 7:25 PM ar  wrote:
>>
>>> Hi,
>>>
>>> I am trying to import avery simple transaction from qif: just 2 buy
>>> transaction for the same account, containing  mutual fund 
>>>
>>> The 'Assets:Investments:X' is gnu cash account tracking shares of
>>> ,
>>> 'Asserts:Investments:' is a gnucash cash account.
>>>
>>> If I do not provide security symbol as below, the import fails when it
>>> requires to enter the security.
>>>
>>> !Account
>>> NAssets:Investments:X
>>> TInvst
>>> ^
>>> !Type:Invst
>>> D07/16'2022
>>> NBuy
>>> LAssets:Investments:Y
>>> Q34.107
>>> T-77.58
>>> ^
>>> D07/15'2022
>>> NBuy
>>> LAssets:Investments:Y
>>> Q7.638
>>> T-37.7
>>> ^
>>>
>>> I provide security as Y, the import creates account
>>> Assets:Investments:X: that conflicts with
>>> 'Assets:Investments:X'
>>>
>>> 1. Does this feature works? If Yes are there usage examples.
>>> 2. I do not insist on using qif format, is it possible to use .csv for
>>> import, are there examples?
>>> 3. It seems that csv import requires a lot of manual selections to be
>>> made
>>> for every imported file, am I getting it right?
>>>
>>> Thank you,
>>>
>>> Aleksey
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] accounts list

2022-12-12 Thread David Carlson
Orinth,

I am assuming that you are using a computer that has a Windows 10 or 11
operating system.  GnuCash works somewhat like Word or LibreOffice.  You
create one data file. You need to save it with a unique name in a subfolder
under your user data folder.  It will have all the accounts that the
GnuCash setup assistant provides when you select the best account tree for
your use.  Then you may add some accounts and/or rename some.  Save it
again.  Now you can quit GnuCash and the next time you start GnuCash it
will open that same data file.

In Linux it works in a similar way,   but on a Mac it is a little
different,  but someone else can describe the difference.

On Mon, Dec 12, 2022, 10:09 AM Orith  wrote:

> I have to enter and create each file on its on.  there is no tree.
> OrithC
>
> On Mon, 12 Dec 2022 at 17:56, Maf. King  wrote:
>
> > On Monday, 12 December 2022 15:42:40 GMT Orith wrote:
> > > It seems I missed explaining myself. It is not the data files that I
> > > am looking for. It's a new year and I can start from scratch to fill
> the
> > > files.  When I downloaded GnuCash from the beginning it did not give me
> > the
> > > opportunity to build a new accounting files tree. It always did before.
> > > This time I have to do it one by one on my own.
> > > Is that the new format of GnuCash 4.12?
> > > OrithC
> >
> > What happens if you choose File -> New File ?
> >
> > Maf.
> >
> >
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Mutual fund price computation incorrect

2022-12-13 Thread David Carlson
GnuCash uses that factional expression for security prices because it is
actually more accurate than the floating point alternative that we humans
are used to seeing.
It has been using that form for some time now, but I recall when the change
was made there were several complaints in this maillist before the setting
to show numbers the common way was implemented.  That was difficult at the
time because the numbers must still be actually stored as fractions.
If you enter that fractional number into a calculator you will see that the
display is usually the same as the number expressed decimally, but there is
actually a rounding error which can sometimes propagate to a large value in
some computations.  That is why GnuCash will allow us mortals to select a
setting to see the numbers in the form that we learned in elementary school.

On Tue, Dec 13, 2022 at 2:06 PM David H  wrote:

> Yes it's the Preferences >> Numbers, Date, Time >> Force Prices to display
> as decimals checkbox I think although mine is unchecked and I'm not seeing
> any issues :-)
>
> Cheers David H.
>
>
> On Wed, 14 Dec 2022 at 05:58, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > There's a setting to force decimal display that somehow is changed on the
> > new installation.
> >
> > ⁣
> > David T.​
> >
> > On Dec 13, 2022, 22:31, at 22:31, Dean Jagels 
> wrote:
> > >I recently moved from a native installation of GnuCash 4.2 to a
> > >Flatpack
> > >installation of 4.12.
> > >
> > >Now, when I look at my mutual fund transactions, the prices are all odd
> > >arithmetic formulas that show no relation to the input shares and
> > >buy/sell
> > >numbers, and those formulas yield incorrect prices.
> > >
> > >For example, entering 474.228 shares and a Buy amount of 11153.85, I
> > >see a
> > >Price field that reads "1101/79038".
> > >
> > >Any hints on what's up?
> > >
> > >Thanks,
> > >Dean
> > >___
> > >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.
> >
> ___
> 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] Buying with PayPal - how do I split the transaction?

2022-12-13 Thread David Carlson
I think that documentation might best be generalized to apply to Venmo and
other payment services besides the :"traditional" credit cards.

On Tue, Dec 13, 2022 at 11:05 PM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Given the length of this thread and the apparent confusion documenting
> PayPal in GnuCash, it might be helpful for someone to add a section to the
> wiki page at "Using GnuCash" on the different methods people have outlined.
> IMHO, the Guide and Help cover the overall concepts well enough.
>
> ⁣David T. ​
>
> On Dec 14, 2022, 6:41 AM, at 6:41 AM, R Losey  wrote:
> >True... I don't get income via Paypal... I just pay for stuff using it.
> >
> >
> >On Mon, Dec 12, 2022 at 10:45 PM Dr. David Kirkby <
> >drkir...@kirkbymicrowave.co.uk> wrote:
> >
> >> On Mon, 12 Dec 2022 at 23:01, R Losey  wrote:
> >>
> >> > I'm very simple-minded, I guess.
> >> >
> >> > I treat Paypal just an an expense... so, for the transaction above,
> >I
> >> > would enter in the Bank account
> >> >
> >> > Payee: Paypal (Google)
> >> > with the expense category Expenses->Utilities->Internet
> >> >
> >>
> >> I would have suggested that the GnuCash documentation should have
> >something
> >> about how to handle PayPal, but it seems as though   multiple people
> >handle
> >> it multiple different ways. You treat PayPal as an expensive, but I
> >see it
> >> as an asset.
> >>
> >> Dave
> >> --
> >> Dr. David Kirkby,
> >> Kirkby Microwave Ltd,
> >> drkir...@kirkbymicrowave.co.uk
> >> https://www.kirkbymicrowave.co.uk/
> >> Telephone 01621-680100./ +44 1621 680100
> >>
> >> Registered in England & Wales, company number 08914892.
> >> Registered office:
> >> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT,
> >United
> >> Kingdom
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> >
> >--
> >_
> >Richard Losey
> >rlo...@gmail.com
> >Micah 6:8
> >___
> >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] QIF Import troubles

2022-12-14 Thread David Carlson
Hi Steve,

As Michael suggested, it is best to start with baby steps to learn how to
get good results with the import process.  If you import more than one
account at a time you risk getting duplicates if both accounts in a
transaction are in the same import.  There is a step in the import process
that attempts to detect this but it must work on one transaction at a time.

Good luck.

On Tue, Dec 13, 2022 at 7:17 PM Fross, Michael  wrote:

> Hi Steve,
>
> I was in the same situation when I first started about 7 years ago.  Read
> through the guide.  It's really well written, easy to read, and answers a
> lot of questions.
>
> As for the imports, do some tests until you get comfortable.  I would just
> export your checking account, then import that.  Figure out that
> categories are now other accounts and instead of assigning a transaction to
> a category for reporting, you debit one account and credit another.
> Understand splits and you'll be set.  It's also a great time to really
> think through your account strategy.
>
> It's really not hard, but read through the guide and you'll get it.
>
> Michael
>
> On Tue, Dec 13, 2022 at 6:52 PM Steve Butler  >
> wrote:
>
> > That is the classic double entry bookkeeping system that GnuCash uses.
> >
> > If you don't want that you need to use some other software.
> >
> > On Tue, Dec 13, 2022, 16:35 Steve Silva via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> > > Hi All,
> > > I am trying out gnucash to replace Quicken.  I have Quicken convert my
> > > accounts into a QIF file and import that to gnucash.  The whole process
> > > seems to go well until I see the result.  It seems like all or most of
> > the
> > > register entries are duplicated, each with a debit and credit of the
> same
> > > amount.  I have tried various permutations of exporting and importing
> but
> > > these split transactions keeps showing up.  Is there someone who has
> seen
> > > this issue and figured out a way around it?
> > > 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
> > > -
> > > 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.
> >
> ___
> 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] Open banking platform support

2022-12-14 Thread David Carlson
Is that open banking platform a different way to get a list of
transactions?  If so, how does it work?

On Wed, Dec 14, 2022 at 5:26 PM Phyllis Bruce  wrote:

> Kalpesh, I found that QFX works as well.
>
> > On Dec 14, 2022, at 5:08 PM, Kalpesh Patel 
> wrote:
> >
> > 
> >
> > Bank of America is one of the banks that has stopped supporting OFX
> method,
> > in addition to Chase Bank, for transaction download via direct connect
> as of
> > early Nov and moved to the open banking platform. Is there any roadmap to
> > get that supported as part of the GNC native method for download of
> > transactions?
> >
> >
> >
> > ___
> > 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] QIF Import troubles

2022-12-14 Thread David Carlson
"Double Entry" is an accounting method that makes it more difficult to make
mistakes that cannot be easily found and corrected during the process of
data entry.  You don't actually see the 'other side' later unless you
deliberately look for it.  It is not at all odd, in fact it is universally
used by professional accountants.

On Wed, Dec 14, 2022 at 6:04 PM R Losey  wrote:

> I had used Quicken for only about 10 years when I changed over to GnuCash.
> I just didn't bother to import anything (it didn't work at the time
> anyway). I just kept Quicken data ending in year "X" and started fresh with
> GnuCash in year "X+1". If I needed something from before X+1, I brought up
> my Quicken... but, as time went on, I have less and less need to ever refer
> to anything in Quicken.
>
> There were some things that I did enter history from Quicken - mostly
> investment information, if it wasn't too much...
>
> But for the checking, credit cards, savings I just entered the balance
> at the start of the year and went forward.
>
>
> On Wed, Dec 14, 2022 at 4:27 PM Steve Silva via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>>  Hi All,
>> Thanks a lot for your input.  Based on your observations, I really don't
>> think I am going to make gnucash work for me, I have nearly 30 years worth
>> of QIF data files and it seems like this odd double entry method is
>> something I can't control, nor can I go back through 30 years of data and
>> try to correct it.  Trying to get away from quicken sure is a chore and I
>> am not going to pay for their program every year.  I appreciated your time.
>> Steve
>> On Wednesday, December 14, 2022 at 12:11:07 PM CST, David Carlson <
>> david.carlson@gmail.com> wrote:
>>
>>  Hi Steve,
>>
>> As Michael suggested, it is best to start with baby steps to learn how to
>> get good results with the import process.  If you import more than one
>> account at a time you risk getting duplicates if both accounts in a
>> transaction are in the same import.  There is a step in the import process
>> that attempts to detect this but it must work on one transaction at a
>> time.
>>
>> Good luck.
>>
>> On Tue, Dec 13, 2022 at 7:17 PM Fross, Michael  wrote:
>>
>> > Hi Steve,
>> >
>> > I was in the same situation when I first started about 7 years ago.
>> Read
>> > through the guide.  It's really well written, easy to read, and answers
>> a
>> > lot of questions.
>> >
>> > As for the imports, do some tests until you get comfortable.  I would
>> just
>> > export your checking account, then import that.  Figure out that
>> > categories are now other accounts and instead of assigning a
>> transaction to
>> > a category for reporting, you debit one account and credit another.
>> > Understand splits and you'll be set.  It's also a great time to really
>> > think through your account strategy.
>> >
>> > It's really not hard, but read through the guide and you'll get it.
>> >
>> > Michael
>> >
>> > On Tue, Dec 13, 2022 at 6:52 PM Steve Butler <
>> stephen.m.butle...@gmail.com
>> > >
>> > wrote:
>> >
>> > > That is the classic double entry bookkeeping system that GnuCash uses.
>> > >
>> > > If you don't want that you need to use some other software.
>> > >
>> > > On Tue, Dec 13, 2022, 16:35 Steve Silva via gnucash-user <
>> > > gnucash-user@gnucash.org> wrote:
>> > >
>> > > > Hi All,
>> > > > I am trying out gnucash to replace Quicken.  I have Quicken convert
>> my
>> > > > accounts into a QIF file and import that to gnucash.  The whole
>> process
>> > > > seems to go well until I see the result.  It seems like all or most
>> of
>> > > the
>> > > > register entries are duplicated, each with a debit and credit of the
>> > same
>> > > > amount.  I have tried various permutations of exporting and
>> importing
>> > but
>> > > > these split transactions keeps showing up.  Is there someone who has
>> > seen
>> > > > this issue and figured out a way around it?
>> > > > Thanks, Steve
>> > > > ___
>> > > > gnucash-user mailing list
>> > > > gnucash-user@gnucash.org
>> > > > To update your subs

Re: [GNC] GNUcash is using 538MB

2022-12-15 Thread David Carlson
Maybe you have a lot of security price history.   Maybe you are not storing
your data in compressed XML form.  Maybe you just give every transaction a
lengthy description.   Maybe you have thirty years of history  in your file.

I can go on.

On Thu, Dec 15, 2022, 5:28 AM Ed  wrote:

> How can this be?! I'm using version 4.11 under w10.
>
> This seems WAY over the top to me, hard to believe.
>
> I'm only recording my own expenses, nothing fancy!
>
> How can I reduce this space usage. I've searched for answers, but found
> nothing.
>
> Thanks in advance!
>
>  Ed
>
> p.s. apart from that, it's a great program :)
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Importing GIF: Unable to complete

2022-12-22 Thread David Carlson
Amar,

do you have a data file from a previous version of GnuCash?

On Thu, Dec 22, 2022 at 4:05 PM John Ralls  wrote:

> Please remember to copy the list on all replies.
>
> Looks like you had a ton of errors so it didn't load the file.
>
> Regards,
> John Ralls
>
>
> > On Dec 22, 2022, at 1:48 PM, Amar Khalifeh 
> wrote:
> >
> > The file selection was done in the previous step, and I got the
> impression that it was actually loaded
> > 
> >
> > On Thu, Dec 22, 2022 at 3:06 PM John Ralls  wrote:
> >
> >
> > > On Dec 22, 2022, at 8:41 AM, Amar Khalifeh 
> wrote:
> > >
> > > I just downloaded version 4.13 and am trying to import my QIF history.
> I go
> > > through the import process and it seems to be working fine, but when I
> get
> > > to the step where it asks if I want to load another file or continue
> (with
> > > "Next"), I find "Next" grayed out and none of the clickable buttons
> work.
> > > Any ideas why this is happening?
> > > I was able to load QIF files in the past from the same source in
> earlier
> > > attempts to use Gnu Cash.
> > > Thank you for your help.
> > >
> > > [image: image.png]
> >
> > The screenshot shows that you haven't selected any files to import. Use
> the "load another file" button to select one. You can keep using that
> button to build up a list of QIF files to import into the same GnuCash
> account that you selected in the previous step.
> >
> > The Next button will enable once you've selected at least one file.
> >
> > 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.
>


-- 
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] Importing GIF: Unable to complete

2022-12-22 Thread David Carlson
Amar,
Just sayin'  If you imported your data into GnuCash 4.12 a month ago, then
you only need to open that data file and import a months' data into GnuCash
4.13, not the whole thing.


On Thu, Dec 22, 2022 at 9:50 PM Amar Khalifeh 
wrote:

> I think the QIF file is fine.
> I was able to import it into Moneyspire and Acemoney just now
> I was able to import a similar file (exported from Moneydance) into GnuCash
> less than a month ago.
>
> On Thu, Dec 22, 2022 at 4:01 PM David H  wrote:
>
> > Amar,
> >
> > Please use "Reply All" to keep the conversation on the mailing list
> > so other users can chip in and help.  I rarely use any importers and are
> > just offering suggestions that may or may not help :-)  See John Ralls's
> > reply which is probably more germane than mine.  To me it looks like your
> > file is rubbish - are you sure it's a QIF file ?  Or as John suggested
> have
> > you actually selected a file ?
> >
> > Cheers David H.
> >
> >
> > On Fri, 23 Dec 2022 at 07:46, Amar Khalifeh 
> > wrote:
> >
> >> The file is 1536 KB.
> >> I'm running Windows 11.
> >> 
> >>
> >> As a follow up, I tried again, and this time I examined the import
> status
> >> window.
> >> This is what I got. Does this provide any clues?
> >> [image: image.png]
> >>
> >> On Thu, Dec 22, 2022 at 2:56 PM David H  wrote:
> >>
> >>> What OS ? How large is your QIF history file - perhaps it's still
> >>> working on it and you need to give it more time ?  Have you clicked on
> >>> another Window and taken the focus away from you dialog ?
> >>>
> >>> Cheers David H.
> >>>
> >>> On Fri, 23 Dec 2022 at 06:50, Amar Khalifeh 
> >>> wrote:
> >>>
> >>>> I just downloaded version 4.13 and am trying to import my QIF history.
> >>>> I go
> >>>> through the import process and it seems to be working fine, but when I
> >>>> get
> >>>> to the step where it asks if I want to load another file or continue
> >>>> (with
> >>>> "Next"), I find "Next" grayed out and none of the clickable buttons
> >>>> work.
> >>>> Any ideas why this is happening?
> >>>> I was able to load QIF files in the past from the same source in
> earlier
> >>>> attempts to use Gnu Cash.
> >>>> Thank you for your help.
> >>>>
> >>>> [image: image.png]
> >>>> ___
> >>>> 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] Transactions Buy/Sell

2022-12-24 Thread David Carlson
There are many reasons to have transactions in security accounts besides
buy and sell.  I always include a reference to the security with each
dividend entry and when there is a reallized gain or loss there is no buy
or sell in that entry.  Then there are other miscellaneous things that may
happen now and then.

On Sat, Dec 24, 2022 at 1:04 PM Charles Gagnon via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I run GnuCash using a MySQL DB backend.
>
> According to the schema docs, the "action" (Buy/Sell) in splits for
> stocks/ETFs/funds should always include a "Buy" or "Sell" value. I noticed
> that in my database, there are many transactions with that field empty. I'm
> confused as to how this impacts other reports. In the DB, the price and
> quantity are unchanged, so this value is needed to build a portfolio view.
>
> Interestingly, if I quickly edit and re-save the transaction, it often
> fills that value.
>
> Should I fill out a bug, or has this a known behavior?
>
> Tks
>
> --
> Charles Gagnon
> charlesg at unixrealm.com
> ___
> 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] Feature request - prevent a transaction with todays date

2022-12-26 Thread David Carlson
When entering more than one transaction in a session,  new transactions
default to the same date last used, so the existing shortcuts metioned in a
previous comment often work.

If it happens that you are editing multiple historical transactions,  they
are likely close together as well.

If I had that sort of switch,  I would be forgetting to reset it when done.



On Mon, Dec 26, 2022, 6:07 PM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Mon, 26 Dec 2022 at 19:22, William Prescott 
> wrote:
>
> > Your post puzzles me.
> >
> > > I am trying to enter some transactions from March. Every now and again
> I
> > > forget to change the date on something, so I get today’s date. Then I
> > have
> > > to go back to a backup file.
> >
> >
> > Why? Can't you just edit the date on the transaction and change it.
>
>
> I thought one wasn’t supposed to do that - at least in formula accounting.
>
> >
> >
> > > It would be nice when entering historical
> > > transactions if it was impossible to use todays date - one is forced to
> > > change the date is something in preferences prevented todays date being
> > > used.
> >
> > I must be missing something. Not being able to use today's day would make
> > it impossible to enter transactions on the day they occurred. Are you
> > asking for some switch that could be set before entering historical
> > transactions? It seems like a cumbersome solution to a non-problem.
>
>
> Yes, a switch for entering historical transactions.
>
> >
> > Will
>
>
> Dave
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Feature request - prevent a transaction with todays date

2022-12-26 Thread David Carlson
I admit that I do not use business features.   I don't know how they work.

On Mon, Dec 26, 2022, 11:51 PM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Tue, 27 Dec 2022 at 00:27, David Carlson 
> wrote:
>
>> When entering more than one transaction in a session,  new transactions
>> default to the same date last used, so the existing shortcuts metioned in a
>> previous comment often work.
>>
>
> If you create a bill, then entering multiple items then defaults to the
> original date. However, once posted, the next thing to do is pay it. The
> payment date defaults to the current date.
>
>>
>> If it happens that you are editing multiple historical transactions,
>> they are likely close together as well.
>>
>
> Yes they are, but after posting a bill or invoice, it’s easy to pay it 6
> months later by mistake.
>
>
>> If I had that sort of switch,  I would be forgetting to reset it when
>> done.
>>
>
> It would only need a window that pops up and says “You have configured
> GnuCash not enter todays date. Change that by selecting Preferences…”
>
> Dave
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT,
> United Kingdom
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Feature request - prevent a transaction with todays date

2022-12-27 Thread David Carlson
Stan, I did forget to include the same session reference, that is a good
point.  I think it has worked that way since much further back than
2.6.19!!!

David Kirby appears to be complaining about the behavior of some business
features which seem to not be following that same general behavior.  I
think that would be a valid concern.  I don't use those features so I
cannot discuss them intelligently.  I will say that if they behave
differently for a specific reason, maybe those features need some
additional setting.

On Tue, Dec 27, 2022 at 10:44 AM Stan Brown 
wrote:

> On 2022-12-26 16:27, David Carlson wrote:
> > When entering more than one transaction in a session,  new transactions
> > default to the same date last used, so the existing shortcuts metioned
> in a
> > previous comment often work.
>
> I think that should be "new transactions default to the same date last
> used _in_the_same_register_ in that session." At least that's been my
> experience with 2.6.19, though it could have changed in later GC versions.
>
> > If it happens that you are editing multiple historical transactions,
> they> are likely close together as well.
>
> And there is also the option to run a Ctrl+F query, then make any needed
> edits right in the results register. That's a "live" register like any
> other, not a static read-only view into the database.
>
> > If I had that sort of switch,  I would be forgetting to reset it when
> done.
>
> I agree wholeheartedly. Such an "switch" sounds to me like a classic
> case of bloating the product with a feature of _very_ limited
> applicability.
>
> A related feature I _would_ like to see is the ability to specify a date
> range within which no new transactions could be entered. I would use
> that to prevent myself from unintentionally changing transactions from
> prior years. The existing mechanism, where the only form of date range
> is N days before today, doesn't seem very helpful to me, since I have to
> change the value of N every day.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> 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] Changing registers in the middle of entering or editing a transaction

2022-12-28 Thread David Carlson
Over the years I have filed more than one bug report looking at various
aspects of the issue of not being able to ascertain which pending edit was
preventing the manual file save action, but today I was only able to find
this one:  https://bugs.gnucash.org/show_bug.cgi?id=686051.  There should
be another one where I enumerate possible work-arounds to find the lost
pending edit(s)
I recall one suggestion was to improve the warning by listing a link to the
pending edit transaction in the warning.

On Wed, Dec 28, 2022 at 10:20 AM R Losey  wrote:

> There are times when I want to check the accounts list in the middle of
> entering a transaction, and I have occasionally (to verify amounts) wanted
> to check with another register. I'd be okay with the change below as long
> as there were three, not two choices: 1) Save changes 2) Discard the
> transaction in progress 3) Continue with the register change.
>
> As an example of changing: when dealing with investments via brokerage
> accounts, there is typically a "sweep" fund that holds the cash in the
> account. When a purchase is made, the funds are normally taken out of the
> sweep account within a few business days. However, I will usually go ahead
> and enter the sweep transaction early, and I will swap to the register with
> the purchase transaction to make sure I enter the amount properly.
>
> On Tue, Dec 27, 2022 at 7:05 PM William Prescott 
> wrote:
>
> > That highlights a point about Gnucash function that I find annoying. It
> > will let you switch registers in the middle of editing a transaction,
> > leaving the changed transaction uncommitted.
> >
> > Would it be an improvement to have the program prevent that. When you try
> > to switch registers with an open transaction it could ask you if you want
> > to save changes or cancel the editing of the transaction.
> >
> > I can't think of a situation where I would like to pause in the middle of
> > entering or editing a transaction in one register and go to another
> > register.
> >
> > Sometimes when I try to quit the App, it tells me I have an open
> > transaction somewhere and it is always because I never committed some
> > transaction. And at that point I don't remember what transaction nor if I
> > wanted to save the changes.
> >
> > Will
> > ___
> > 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.
> >
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> 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] Deleting Transaction from Reconcile Deletes Wrong Transaction

2022-12-29 Thread David Carlson
I haven't needed to do a reconciliation yet since this thread started, but
perhaps in the next few days.

In the meantime,  I didn't even realize that you could right click split
lines in that screen and do things.  If that works successfully, wonderful.

I have always used the menu to navigate to the transaction in the register
view and perform my edits there.

Finally,  I  subscribe to the theory to save a backup just before starting
any significant activity such as a reconciliation or import. That is one
reason I am not using a database file format and I won't until the
application has a way to undo several recent actions.  My cat does
occasionally walk across the keyboard.

On Thu, Dec 29, 2022, 9:47 PM Thomas Forrester 
wrote:

> I guess you didn't read what I wrote.  So, let me say it again (via the
> magic of copy/paste):
>
> "I was right-clicking on a transaction in the right (credit) column.  It
> was already highlighted, and there was no other transaction highlighted.
> The right-click context menu appeared alongside the mouse pointer which was
> positioned on the highlighted credit transaction.  From that menu I
> selected and confirmed the delete of the highlighted credit transaction.  A
> debit transaction was deleted instead."
>
> Reverting to a backup after doing as much work as I had leading up to that
> reconciliation in that session would have been a multitude of times more
> painful.  Bad stuff always happens after lots of other stuff has happened -
> Murphy's Law.  The backup is for truly catastrophic stuff, or maybe if
> you're just lucky and haven't done anything else yet.
>
> This is hardly and interface error.  And checking the 4.13 change log
> reveals nothing addressing this or any related reconciliation bug.  The
> known issues list doesn't even identify it.  I don't think it's on anyone's
> radar.
>
> On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > That sounds like a GTK bug. You were raising a context menu on what was
> > selected, not where the mouse pointer was located. If you had a line in
> > the left pane selected, that is what got deleted.
> >
> > Maybe reverting to a backup file and making it your main file would be
> > in order for restoring your books to a sane state then starting the
> > reconciliation over.
> >
> > As for the bug, I suppose you can file it, but I wouldn't be surprised
> > if it is a GTK rather than GnuCash problem.
> >
> > But before you do, try GnuCash 4.13 first. I think the GTK version was
> > just bumped on that release.
> >
> > Regards,
> > Adrien
> >
> > On 12/29/22 3:36 PM, Thomas Forrester wrote:
> > > I was reconciling several credit card statements for the same card and
> > had
> > > noticed that a subscription payment I had set up as an automatic entry
> > was
> > > showing up even though I had canceled the subscription.  Clearly, I
> > hadn't
> > > discontinued the automatic transaction entry in GnuCash.  I ignored
> > several
> > > of the subscription transactions while reconciling, but then I thought
> I
> > > might as well just delete them in the Reconcile screen since you can
> > > right-click and delete transactions right there.  With the first ot 3
> of
> > > the transactions highlighted, I right-clicked on it and selected
> > delete.  I
> > > clicked OK to the confirmation message affirming I was sure I wanted to
> > > delete the transaction. I rather mindlessly repeated that action a
> couple
> > > of times, then realized the transactions weren't deleting.  Much to my
> > > horror, I realized transactions on the left (debit) column for the
> > > reconciliation was getting shorter, not the right (credit) column where
> > the
> > > highlighted item I was trying to delete was.
> > >
> > > Again, I'm going to stress this: I was right-clicking on a transaction
> in
> > > the right (credit) column.  It was already highlighted, and there was
> no
> > > other transaction highlighted.  The right-click context menu appeared
> > > alongside the mouse pointer which was positioned on the highlighted
> > credit
> > > transaction.  From that menu I selected and confirmed the delete of the
> > > highlighted credit transaction.  A debit transaction was deleted
> instead.
> > >
> > > Obviously, this is not correct behavior.
> > >
> > > This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB
> backend.
> >
> > ___
> > 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
> -
>

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

2022-12-29 Thread David Carlson
I just performed a trivial test in release 4.8 (Build ID: 4.8a+(2021-09-28)
in Lubuntu 22.04 by adding a bogus transaction to a register then saving
the file, opening the reconciliation window, right clicking the desired
split in the right panel of the reconciliation window, and clicking
delete.  The correct entire transaction was deleted.  So, from my
perspective, if the current release does not work the same way, there has
been a regression since 4.8.

On Thu, Dec 29, 2022 at 11:08 PM David Carlson 
wrote:

> I haven't needed to do a reconciliation yet since this thread started, but
> perhaps in the next few days.
>
> In the meantime,  I didn't even realize that you could right click split
> lines in that screen and do things.  If that works successfully, wonderful.
>
> I have always used the menu to navigate to the transaction in the register
> view and perform my edits there.
>
> Finally,  I  subscribe to the theory to save a backup just before starting
> any significant activity such as a reconciliation or import. That is one
> reason I am not using a database file format and I won't until the
> application has a way to undo several recent actions.  My cat does
> occasionally walk across the keyboard.
>
> On Thu, Dec 29, 2022, 9:47 PM Thomas Forrester 
> wrote:
>
>> I guess you didn't read what I wrote.  So, let me say it again (via the
>> magic of copy/paste):
>>
>> "I was right-clicking on a transaction in the right (credit) column.  It
>> was already highlighted, and there was no other transaction highlighted.
>> The right-click context menu appeared alongside the mouse pointer which
>> was
>> positioned on the highlighted credit transaction.  From that menu I
>> selected and confirmed the delete of the highlighted credit transaction.
>> A
>> debit transaction was deleted instead."
>>
>> Reverting to a backup after doing as much work as I had leading up to that
>> reconciliation in that session would have been a multitude of times more
>> painful.  Bad stuff always happens after lots of other stuff has happened
>> -
>> Murphy's Law.  The backup is for truly catastrophic stuff, or maybe if
>> you're just lucky and haven't done anything else yet.
>>
>> This is hardly and interface error.  And checking the 4.13 change log
>> reveals nothing addressing this or any related reconciliation bug.  The
>> known issues list doesn't even identify it.  I don't think it's on
>> anyone's
>> radar.
>>
>> On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>>
>> > That sounds like a GTK bug. You were raising a context menu on what was
>> > selected, not where the mouse pointer was located. If you had a line in
>> > the left pane selected, that is what got deleted.
>> >
>> > Maybe reverting to a backup file and making it your main file would be
>> > in order for restoring your books to a sane state then starting the
>> > reconciliation over.
>> >
>> > As for the bug, I suppose you can file it, but I wouldn't be surprised
>> > if it is a GTK rather than GnuCash problem.
>> >
>> > But before you do, try GnuCash 4.13 first. I think the GTK version was
>> > just bumped on that release.
>> >
>> > Regards,
>> > Adrien
>> >
>> > On 12/29/22 3:36 PM, Thomas Forrester wrote:
>> > > I was reconciling several credit card statements for the same card and
>> > had
>> > > noticed that a subscription payment I had set up as an automatic entry
>> > was
>> > > showing up even though I had canceled the subscription.  Clearly, I
>> > hadn't
>> > > discontinued the automatic transaction entry in GnuCash.  I ignored
>> > several
>> > > of the subscription transactions while reconciling, but then I
>> thought I
>> > > might as well just delete them in the Reconcile screen since you can
>> > > right-click and delete transactions right there.  With the first ot 3
>> of
>> > > the transactions highlighted, I right-clicked on it and selected
>> > delete.  I
>> > > clicked OK to the confirmation message affirming I was sure I wanted
>> to
>> > > delete the transaction. I rather mindlessly repeated that action a
>> couple
>> > > of times, then realized the transactions weren't deleting.  Much to my
>> > > horror, I realized transactions on the left (debit) column for the
>> > > reconciliation was getting shorter, not 

Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction

2022-12-30 Thread David Carlson
Thomas

Unless you take the time to try to replicate the problem and create a bug
report,  the rest of us will quickly forget about it.  If we don't see it
happening with our data sets we will conclude that yours was a case of
operator error.

On Fri, Dec 30, 2022, 3:17 PM Thomas Forrester 
wrote:

> I won't actually be experimenting on copies of databases, not because I
> don't want to be helpful or contribute to the community, but because I
> simply don't have that kind of free  time.  I've noted a problem, and can
> agree that I was doing something rather mindless - i.e., right-clicking and
> choosing to delete a transaction multiple times because there were three
> identical transactions.  That I didn't realize something was going wrong is
> somewhat explainable by the fact that, once one (should have been) deleted,
> another would have moved up to take its place since they appeared one after
> the other, so the row currently being deleted would look just like the
> last.  When I deleted three, then I came to realize I still had three
> left.  That realization was followed by the realization that the left side
> of the screen was looking a little shorter on transactions than before.
> And sure enough, stuff had been deleted from the wrong side.  I don't know
> why,  My purpose here is to get it on the radar of the developers so they
> can review the code to see if there's a problem with the selection logic.
> And I'm sorry I won't be able to contribute more than that.
>
> 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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] OFX import date questions

2022-12-30 Thread David Carlson
I interpret the OP's question as that the date imported from the OFX file
doesn't match the date printed on the statement.   Some banks try to get
fancy and print the date that you deposited a check on your statement but
then use the date that the funds arrived from the clearing house or the
date that they will let you withdraw the funds in their OFX export s.
There can be many variations on this theme. He could ask someone at the
bank to explain why if there is a discrepancy of this type.

On Fri, Dec 30, 2022, 4:48 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> That's a matching problem on the import if I recall correctly. You have
> to fix it there. I've seen threads on the topic, but since I don't use
> it, the details are not sticky in my brain.
>
> If I understand properly, GnuCash *should* be able to match existing
> transactions and simply set the 'c' flag for them.
>
> Regards,
> Adrien
>
> On 12/30/22 4:20 PM, Phyllis Bruce wrote:
> > Jean and  Adrien, I use QFX and reconciling is a pain!  When I import and
> > data from my bank and begin reconciliation I often find the GNC has
> ignored
> > the existing unreconciled transactions and created new cleared ones.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] OFX import date questions

2022-12-31 Thread David Carlson
ing received and being acted on?
> > > >
> > > > Can someone tell me what I should do to fix this? Is there a way to
> > > "tweek"
> > > > the OFX import, or do I need to use CSV? Or is this something else
> > > entirely
> > > > that's gone amiss?
> > > >
> > > > Thanks for any hints,
> > > > Cheers,
> > > > Simon
> > > >
> > > > Background in case it's relevant:
> > > >
> > > > I'm a refugee from Intuit, and very early in my learning process.
> > > >
> > > > I"m not a bookkeeper, I'm a programmer. Conversely, my bookkeeper
> > isn't a
> > > > software person--she would have continued paying the annual ransom to
> > > > Intuit but I'm sick of their hostage taking. Of course this means I
> > need
> > > to
> > > > do a decent part of the legwork for this transition.
> > > >
> > > > Of course because I'm not a bookkeeper, I don't understand the
> > accounting
> > > > side of this stuff, and likely won't know how to ask/phrase the
> > > questions.
> > > >
> > > > Neither of us are going to be great at searching the documentation
> > since
> > > it
> > > > seems like the terminology is different between GC and QB (and I
> don't
> > > > really know the terminology anyway)
> > > >
> > > > So, please forgive the idiot question, and if the simple answer to a
> > > > question is RTFM, we're very happy to do so, but likely are asking as
> > > we've
> > > > failed to find the relevant part of said references.
> > > >
> > > > Anyway, thanks for your indulgence :)
> > > > ___
> > > > 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.
> > >
> >
> >
> > --
> > Simon Roberts
> > (303) 249 3613
> > ___
> > 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] Generic Import Matcher GUI

2023-01-04 Thread David Carlson
ws double clicking to open a
> > > window but discards the transfer account information, shows one side
> of a
> > > transaction, and does not show any means to add a transfer account.
> > >
> > > This seems to me to be a bug. Am I missing something?
> > >
> > > Dale
> > > ___
> > > 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.
> >
> >
> >
> ___
> 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] Scheduled transactions

2023-01-04 Thread David Carlson
I thought that you put that there to see if anyone was  reading!!  You
outlined a very comprehensive procedure to effectively utilize the somewhat
awkward UI of the Since Last Run Druid.

On Wed, Jan 4, 2023 at 3:11 PM Tommy Trussell 
wrote:

> > 15+3=19 days
> oops
> 18 days for those who can add.
>
> On Wed, Jan 4, 2023 at 3:05 PM Tommy Trussell 
> wrote:
>
> > I enter scheduled transactions from the future all the time. For example,
> > when I receive a utility bill or a credit card that will draft my bank
> > account on the (future) draft date.
> >
> > The secret is to use the "Remind in advance" field in scheduled
> > transactions. For my bills, the statement might usually come on the 15th
> of
> > the month and draft on the 3rd day of the NEXT month. SO I have my
> reminder
> > ("remind in advance") come up about 15+3=19 days before the draft date.
> It
> > takes a few months to figure out about when the bills are usually "in
> hand"
> > (online or by mail) but I adjust them for the usual, and note the bill
> > dates in the name of the Scheduled Transaction. (For example: "Water
> > bill/15 due/3").
> >
> > If an unusual situation (such as a February?) makes the bills available a
> > few days sooner than usual before the draft date, I can either wait until
> > the later date or temporarily increase the "remind in advance" field.
> >
> > Obviously if the amount doesn't change, such as a mortgage payment, you
> > could use the "Create in advance" field, even months in advance, maybe to
> > help you monitor cash flow.
> >
> > When the Since Last Run dialog comes up, HERE is where you have a
> "pop-up"
> > you were looking for. The status of each transaction will be listed along
> > with a little chevron to remind you the status can be changed. Change the
> > ones you want to enter now to "To Create." If somehow you've gotten ahead
> > of yourself (or behind the times), change the ones you're not ready from
> > "To Create" to "Reminder."
> >
> > I am tempted to add a tip about using variables, but I'll stop here.
> >
> > On Tue, Jan 3, 2023 at 12:52 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> Is this just a one-off? I'd just enter the transaction. If it is
> >> complicated and you already have an instance in a register, duplicate
> it.
> >>
> >> If it hasn't ever occurred, and you don't want to manually enter it,
> >> edit to run today, click Actions > Since Last Run to fire it off, then
> >> edit to revert to your future date.
> >>
> >> But no, there is no way I can see to otherwise execute it.
> >>
> >> Regards,
> >> Adrien
> >>
> >> On 1/3/23 12:36 AM, Fred Tydeman wrote:
> >> > I looked in the Help: Tutorial and Concepts Guide in GC 4.13 for the
> >> term:
> >> > "scheduled transaction" and got no hits.
> >> >
> >> > My question is:  Is it possible to select a scheduled transaction from
> >> the
> >> > future and have it be done now?  I was hoping I could click on the
> >> calendar
> >> > entry and get a popup offering choices:  Skip, Run now, Edit, ...
> >>
> >> ___
> >> 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] Register column sizing

2023-01-05 Thread David Carlson
I feel that the register column sizing is complicated by the fact that the
register  view is constrained by the requirement that the data input window
has to appear to blend in to the rest of the register view.  If the data
input area was separated from the register view each of the areas could be
optimized for it's respective purpose.



On Thu, Jan 5, 2023, 10:13 PM Glenn Fowler  wrote:

> Hi,
>
> I think it would be an improvement to get rid of autosizing because of the
> recurring issues people have with it and it wouldn't affect those users
> that do know how autosizing works by taking it away.
>
> On Thu, Jan 5, 2023 at 10:40 PM john  wrote:
>
> > Users,
> >
> > There have been occasional complaints for many years about column width
> > sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> > Most users seem to eventually get used to it, but I wonder if anybody
> > really likes it.
> >
> > The problem boils down to the auto-sizing behavior of the Description
> > column, which causes that column to grow or shrink when you adjust the
> > window's width, and to make a horizontal scrollbar appear when you widen
> > another column. Occasionally someone will complain about the normally
> > hidden price column because it's possible to catch its handle and widen
> it
> > when you mean to widen the balance column.
> >
> > It would be really easy to turn off autosizing on the Description field
> > and only a little work to figure out another way to handle the price and
> > ditch that column. Would anyone miss it?
> >
> > 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.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Bank reconciliation after messy migration

2023-01-06 Thread David Carlson
There isn't an easy way to unreconcile many transactions,   but because
reconciliation dates aren't very easy to see or care about once they get
old, many users will ignore starting dates and balances if they know that
there is a reason that they don't match the bank statement this month.

One point to keep in mind is that reconciliations are only concerning the
split lines involving that account,  so, if for example there are
transactions that involve both a bank account and a credit card account,
ignore the 'other' side during the reconciliation.  Those transactions may
have dates that don't match both sides.

On Fri, Jan 6, 2023, 12:08 PM Eric Hammond  wrote:

>
> I have finally completed replacing Quicken with GnuCash.
> One of the casualties is my ability to reconcile my bank account.
> The account covers from 2014 to present, and matches all bank statements
> and balances properly.
> The reconciliation function opens but starts at some random date and
> incorrect beginning balance.
> Is there a way to reset the reconciliation to all unreconciled  and start
> fresh?
>
> Alternatively, can I repair this using NotePad++?  Which entries need to
> be changed, and which ones should not be messed with?
> (I am fine with a bit of slow tedious work)
>
> Thanks for all help,
> Eric H.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Register column sizing

2023-01-06 Thread David Carlson
I do find that when I move between computers with different display
resolutions, if I copy the user preferences,  then I have to fiddle with
widths on the new machine.   If the defaults were good enough so that there
was no need to port over the column widths,  there would still be other
settings like csv import settings and custom reports to port over, so if
these items can be separated so users can pick and choose what to keep, it
would be greatly appreciated.

On Fri, Jan 6, 2023 at 2:05 PM Thomas Forrester 
wrote:

> To be honest, John, it's been a minute since I bothered to think about it.
> For the most part, I guess I just leave columns alone.  I don't recall the
> last time I've had to resize a column, and maybe that speaks kindly of the
> width-memory the columns have at this point.  Or not.  Like I say, I don't
> find myself needing to resize columns much.  But neither does that mean
> I've never resized a column.  My recollection of those times is that it was
> somewhat frustrating and counter intuitive.  As if it seemed to be doing
> the sizing backwards or was somehow causing disruption to other column
> widths.
>
> I don't feel asking me what I think GnuCash is doing differently than
> spreadsheets is going to give you any important information.  Rather, I
> think you should be asking yourself, "what is GnuCash doing that is
> different from how spreadsheets do it?"  After all, you came to us saying,
> "There have been occasional complaints for many years about column width
> sizing."  I hypothesize that at the root of these complaints is the
> difference between the intuitive and well accepted behavior of spreadsheets
> vs the, well, clumsy(?) way GnuCash is doing it.
>
> If GnuCash starts behaving like a spreadsheet in this regard, I would
> expect all the grumbling to go away.  Or at the very least you could say
> you're standing on the shoulders of giants like Excel, LibreOffice Calc,
> etc, in doing it how they do it so as to bring an established standard to
> the table.
>
> Thanks.
> Tom
>
>
> On Fri, Jan 6, 2023 at 1:31 PM john  wrote:
>
> > With the exception of the Description field automatically resizing itself
> > to fit the register in the window width, I think GnuCash does size
> columns
> > the same way spreadsheets do: You put the pointer on the right-hand
> divider
> > in the header and drag it, and double-click in the header to fit the
> width
> > to the widest entry in that column. What do you think spreadsheets do
> > differently?
> >
> > Regards,
> > John Ralls
> >
> >
> > On Jan 6, 2023, at 5:37 AM, Thomas Forrester 
> > wrote:
> >
> > I realize I'm answering a slightly different question, but I've never
> > understood why the GnuCash developers have never made column sizing (and
> > apparently hiding, too) work just like spreadsheets.  We already invented
> > that wheel, and people are *really* accustomed to how it works, hence the
> > grumbling when it's discovered by new GnuCash users that it doesn't work
> > that way here.  I think the vast majority would agree that the way
> > spreadsheet columns work is a very mature, and well understood
> "technology"
> > (for lack of a better word) that has become ubiquitous and intuitive.
> Note
> > also that I said "spreadsheets" rather than, say, "Excel" because the way
> > spreadsheet columns work isn't specific to any one spreadsheet program,
> and
> > once again speaks to how universal handling spreadsheet columns has
> become.
> >
> > My guess is that what you're asking is likely just fine, but isn't it
> just
> > another band-aid that really would be better ripped off in favor of
> > spreadsheet-like resizing logic?
> >
> > Tom
> > Thomas L. Forrester
> > Middleton, WI USA
> >
> >
> > On Thu, Jan 5, 2023 at 9:42 PM john  wrote:
> >
> >> Users,
> >>
> >> There have been occasional complaints for many years about column width
> >> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> >> Most users seem to eventually get used to it, but I wonder if anybody
> >> really likes it.
> >>
> >> The problem boils down to the auto-sizing behavior of the Description
> >> column, which causes that column to grow or shrink when you adjust the
> >> window's width, and to make a horizontal scrollbar appear when you widen
> >> another column. Occasionally someone will complain about the normally
> >> hidden price column because it's possible to catch its handle and widen
> it
> >> when you mean to widen the balance column.
> >>
> >> It would be really easy to turn off autosizing on the Description field
> >> and only a little work to figure out another way to handle the price and
> >> ditch that column. Would anyone miss it?
> >>
> >> 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 r

Re: [GNC] GnuCash 4.900 Released

2023-01-09 Thread David Carlson
25 years young!

Thanks to all the developers for their tireless efforts.

It looks like there are a bunch of changes under the hood in anticipation
of future releases.

On Mon, Jan 9, 2023 at 11:03 PM John Ralls  wrote:

> The GnuCash development team announces GnuCash 4.900, the first unstable
> release leading to GnuCash 5.0.
>
> This is an unstable release for testing purposes. Do not use it with
> production data! Make a copy of your book to test this release.
>
>
-- 
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] Recommended Method of Entry for IRA Distributions

2023-01-11 Thread David Carlson
You probably noticed that the answers here lead to multi account splits
that resemble a simplified paycheck transaction.
If it happens that you are also tracking the qualified account details in a
brokerage account, possibly even with variations for traditional accounts
vs Roth accounts you may need to include extra accounts to make it easier
to track tax status, which is not discussed here.

On Wed, Jan 11, 2023 at 6:35 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> +1
>
> Regards,
> Adrien
>
> On 1/11/23 6:29 PM, Stan Brown wrote:
> > How would you do it in a pen-and-ink ledger? The answer is the same for
> > GnuCash.
> >
> > So many people seem to be under the impression that GnuCash does
> > accounting ion its own special way. It's much more helpful, in my
> > opinion, to think of GnuCash as an automated version of the pen-and-ink
> > ledger methods that are taught in basic bookkeeping courses (or used to
> be).
>
> ___
> 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] Sort order not being maintained

2023-01-11 Thread David Carlson
I think that register sort order, register window size/column widths,
memorized reports, open report window details and memorized CSV import
settings all only get saved when doing a manual program Quit, but not when
dining a File Save or when the program crashes.

On Wed, Jan 11, 2023 at 10:28 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Oddly, after an unrelated crash, upon restarting GnuCash, the sort order
> was back to what I had tested, rather than what I had last used. I had
> to change the order again with the 'save' preference checkbox, exit
> GnuCash cleanly, then re-open for it to stick. (so far)
>
> I suppose I shouldn't expect such prefs to persist after a crash...
>
> Regards,
> Adrien
>
> On 1/6/23 9:28 AM, Adrien Monteleone wrote:
> > I just tested using 4.13 on Mac. It works properly there.
> >
> > I tested closing the register I sorted, then re-opening.
> > I then tested closing GnuCash and re-opening.
> >
> > In both cases, the sort order was retained. (I tested with your options
> > of Date, Reverse, & Save)
> >
> > Try 4.13?
> >
> > Regards,
> > Adrien
> >
> > On 1/6/23 8:46 AM, Dr. David Kirkby wrote:
> >> I'm running GnuCash 4.12 on both linux and Windoze - mainly on Windoze
> >> laptop, as my desktop PC uses 200 W of power when idle, plus whatever
> the
> >> monitor uses.
> >>
> >> I keep sorting the bank account, or other accounts, but the sort order
> >> keeps being lost, despite me ticking the box to keep the sort order. See
> >> attachment.
> >>
> >> Is there anyway I can set this sort order for every account once and
> >> forget
> >> 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
> -
> 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] Sort order not being maintained

2023-01-12 Thread David Carlson
Be very careful with sort order in release 4.13.  I have a problem with a
nightly build made on Jan 7 where it is not possible to correctly restore
the sort back to the standard order after making a change.  I am not sure
if that issue started after 4.13 was released.  Luckily  it was on a test
file so I didn't need to go to a backup to recover.

On Thu, Jan 12, 2023 at 2:38 AM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> On Thu, 12 Jan 2023 at 04:27, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > Oddly, after an unrelated crash, upon restarting GnuCash, the sort order
> > was back to what I had tested, rather than what I had last used. I had
> > to change the order again with the 'save'  .
>
>
> (so far)
> >
> > I suppose I shouldn't expect such prefs to persist after a crash...
> >
> > Regards,
> > Adrien
>
>
>
> Il am losing the sort order even if the program doesn’t crash. I should
> have replied earlier to state I was still getting the problem in 4.13.
>
> I did look at the release notes in 4.13 and didn’t see any significant
> differences to 4.12, so that’s why I didn’t bother upgrading until you
> suggested that I did so. Initially I thought the upgrade had solved the
> problem, but it hasn’t.
>
> Dave
> --
> Dr. David Kirkby,
> Kirkby Microwave Ltd,
> drkir...@kirkbymicrowave.co.uk
> https://www.kirkbymicrowave.co.uk/
> Telephone 01621-680100./ +44 1621 680100
>
> Registered in England & Wales, company number 08914892.
> Registered office:
> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
> Kingdom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] Why is this entry "in and out"

2023-01-12 Thread David Carlson
If you change your register view to two lines, it is easier to see what's
going on.

On Thu, Jan 12, 2023, 9:02 AM Joseph St. Denis via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello Murugan
>
> On the ribbon locate the spilt icon and press it you should be able to see
> if the spilt is to different locations one should be the account name and
> the other should be interest. If they are the same you get two entries a
> add and subtraction to the same account.
>
> I hope this helps you.
>
> Joseph St Denis
>
> Get Outlook for Android
> 
> From: gnucash-user 
> on behalf of Murugan Muruganandam 
> Sent: Thursday, January 12, 2023 9:49:03 AM
> To: Mahon Finbar 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Why is this entry "in and out"
>
> Hi Mahon
>
> You need to give more details of the entry, possibly a screen shot as it
> is not clear
>
> When entering interest in the account create a new transaction with
> transfer account as income:interest
>
>
> Regard
>
> Murugan
>
>
> > On 12-01-2023, at 11:28, Mahon Finbar  wrote:
> >
> > Hi,
> >
> > I have an account for a savings a/c and I want to add the latest
> interest entry. However, when I click the entry title it open with the
> balance, but when I add the interest it fills in the amount as an addition
> and then a subtraction and the balance doesn't change
> >
> > Have a the wrong a/c type?In the transfer column it is headed
> Equity:Opening Balances
> >
> > Thanks, Finbar
> >
> > ___
> > 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.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Scheduled Transactions Question

2023-01-13 Thread David Carlson
David,

Which version of GnuCash are you using?

On Fri, Jan 13, 2023, 10:49 AM David T. via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> Gnucash 4.13 Windows 10. Long time user.
>
> I am trying out using a variable in a scheduled transaction for the
> first time, and it's not behaving the way I expect. I am creating a
> multi-entry transaction that transfers a single amount between two pairs
> of accounts. in other words:
>
> DB Checking TOTALAMT
> CR Asset TOTALAMT
> CR Income A TOTALAMT
> DB Income B TOTALAMT
>
> [This is testing out how to create a transaction to track an IRA
> distribution]
>
> I expect GnuCash to prompt me for the TOTALAMT figure once when the
> transaction is created, but GnuCash prompts me for *each* TOTALAMT entry
> in the transaction (i.e., four times). Is there a way to have just one
> request that gets assigned four times?
>
> David T.
>
> ___
> 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.


<    1   2   3   4   5   6   7   8   9   10   >