Re: [GNC] Unable to Refine Existing Search

[Patrick Skelton]

Hi Derek,

In the absence of tags in GnuCash, I thought I would use the *Number *field
as a pseudo tag since I am not using it for anything else.

So my search would be along the lines of *AFTER-dd/mm/yy AND
BEFORE-dd/yy/mm AND CONTAINS-STRING-[tag]*. Then what I'd want to do it run
the search again with the same date constraints but a different tag. So, it
appears your answer means I will simply have to re-enter the date range
every time.

I am an absolute amateur when it comes to accounts, but it does seem to me
that the GnuCash could be improved in this area. Tags would be great, as
would a bit more flexibility on custom reports.

Thank you for your answer.

Kind wishes - Patrick









On Wed, 15 May 2024 at 12:37, Derek Atkins  wrote:

> Hi,
>
> On Tue, May 14, 2024 3:24 am, Patrick Skelton wrote:
> > Hi,
> >
> > If I do a *Find* in GnuCash using a handful of criteria, it does what I'd
> > expect.
> >
> > If I then want to modify this existing *Find*, I cannot see how to do
> > this.
> > If I select the same operation again from the menu while the currently
> > active tab contains my current find results, and then I click on either
> > 'Refine current search' or 'Add results to current search', the original
> > criteria I set are gone, so basically I am just doing a new search and
> > have
> > to enter all the criteria again.
>
> No, the initial criteria are still there -- just inaccessible.  You're
> just appending to them with an additional AND statement (refine) or OR
> statement (add results).
>
> >
> > Is there a way to modify the search criteria already used or perhaps even
> > save a set of criteria so they can be re-run.
>
> No.
>
> > I realise what I am really wanting here is a custom report but I need it
> > to
> > contain only records containing a certain string and I can't see how to
> > get
> > the reporting to do this.
>
> Could you go into more details about what it is, exactly, you're trying to
> do?
>
> > Kind wishes - Patrick
>
> > 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.

[GNC] Unable to Refine Existing Search

[Patrick Skelton]

Hi,

If I do a *Find* in GnuCash using a handful of criteria, it does what I'd
expect.

If I then want to modify this existing *Find*, I cannot see how to do this.
If I select the same operation again from the menu while the currently
active tab contains my current find results, and then I click on either
'Refine current search' or 'Add results to current search', the original
criteria I set are gone, so basically I am just doing a new search and have
to enter all the criteria again.

Is there a way to modify the search criteria already used or perhaps even
save a set of criteria so they can be re-run.

I realise what I am really wanting here is a custom report but I need it to
contain only records containing a certain string and I can't see how to get
the reporting to do this.

Kind wishes - Patrick
___
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] Account Hierarchy

[Patrick Skelton]

Thank you for the reply, Frank.

To take the second half of your reply first, there won’t be many products.
I used the word ‘product’ for illustration; in actual fact, these are
product groups or types.

That said, your other suggestion, to treat shops as assets, is something I
will look into. My accountancy knowledge is basic to say the least. I will
attempt to find some reading material about this.

Thank you for the suggestion.

Kind wishes - Patrick

On Fri, 3 May 2024 at 21:56, Frank Ciani  wrote:

> This is where Tags would be great.  There are some work arounds to 'fake '
> tags into existence,  but they are cumbersome to use - my opinion.
>
> Shop A and Shop B aren't income/expense accounts.  They're locations
> comparable to assets.
>
> Why not setup asset accounts for Shop A and B.  Then sales by product and
> expenses  would be debited/credited to the appropriate Shop account.  Then
> it would be easy to generate Shop A reports vs. Shop B.
>
> Your proposed hierarchies would necessitate a lot of duplicate
> income/expense accounts which would become a nightmare to maintain.
>
> Another question is how many products do you plan to have?  If it's only a
> few, I think you'll be OK. If it's a lot,  perhaps you need a product that
> has an inventory capability.
>
>
> On Fri, May 3, 2024, 7:57 AM Patrick Skelton 
> wrote:
>
>> Hi,
>>
>> I am about to structure a new set of accounts for a business. GnuCash uses
>> a hierarchy, which I am currently trying to decide upon. Two
>> part-hierarchies come to mind:
>>
>> *FIRST*
>>
>> Sales
>>
>> Shop A
>>
>> Product 1
>>
>> Product 2
>>
>> Shop B
>>
>> Product 1
>>
>> Product 2
>>
>>
>> *SECOND*
>>
>> Sales
>>
>> Product 1
>>
>> Shop A
>>
>> Shop B
>>
>> Product 2
>>
>> Shop A
>>
>> Shop B
>>
>>
>> The first would make it easy to see sales for each shop but harder to find
>> out the sales for each product. The second would make it easy to see sales
>> for each product but harder to find out the sales for each shop.
>>
>> Both of these seem like reasonable questions to be able to ask of the
>> accounts. How do I choose which hierarchy to go with and is there any way
>> I
>> can answer both of these questions?
>>
>> Any advice would be most welcome as I am no accounting expert and have
>> only
>> basic knowledge of GnuCash.
>>
>> Kind wishes - Patrick
>> ___
>> 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] Account Hierarchy

[Patrick Skelton]

Hi,

I am about to structure a new set of accounts for a business. GnuCash uses
a hierarchy, which I am currently trying to decide upon. Two
part-hierarchies come to mind:

*FIRST*

Sales

Shop A

Product 1

Product 2

Shop B

Product 1

Product 2


*SECOND*

Sales

Product 1

Shop A

Shop B

Product 2

Shop A

Shop B


The first would make it easy to see sales for each shop but harder to find
out the sales for each product. The second would make it easy to see sales
for each product but harder to find out the sales for each shop.

Both of these seem like reasonable questions to be able to ask of the
accounts. How do I choose which hierarchy to go with and is there any way I
can answer both of these questions?

Any advice would be most welcome as I am no accounting expert and have only
basic knowledge of GnuCash.

Kind wishes - Patrick
___
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] Maddening!!!!!!!!

[Patrick James]

Save, Exit, and Reload will clear the rouge transactions.
 

> On 02/08/2024 8:54 AM PST Jack Slater  wrote:
>  
>  
> Anything coming soon to fix this?
> 
> On Thu, Jan 25, 2024 at 12:26 PM Patrick James  mailto:patrickjame...@comcast.net> wrote:
> 
> > This is bug 799093, and John Ralls has not asked additional questions after 
> > I was able to reliably reproduce (part of) the issue, so, hopefully, there 
> > is sufficient information to find the bug.
> > 
> > https://bugs.gnucash.org/show_bug.cgi?id=799093
> > 
> > s 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 error

[Patrick James]

I've been comparing and contrasting two options:

1. Reports -> Assets & Liabilities -> General Journal
2. Tools -> General Journal

If the second option is selected, which is the one I generally use, then 
sorting by date of entry puts the transactions in date order. The General 
Journal (option 2) is also subject to filters.

The General Journal Report (option 1) does not have any options, at least none 
that I've found, so it should include all data entry.


> On 02/08/2024 7:06 AM PST Derek Atkins  wrote:
> 
>  
> I presume you mean Tools -> General Journal ?
> 
> -derek
> 
> On Thu, February 8, 2024 9:58 am, Michael or Penny Novack wrote:
> > On 2/7/2024 11:11 PM, Adrien Monteleone wrote:
> >> Michael,
> >>
> >> Transaction Journal View is simply the same full transaction
> >> accessible via either 'Split' or 'Auto-Split' but for all transactions
> >> - *not* one at a time.
> >
> > Yes of course, can have on your screen "journal view" for all
> > transactions affecting the account. But that is NOT "full journal view".
> > Gnucash is "virtual journal" but you can get gnucash to show you that
> > (full journal).
> >
> > By "full journal" I mean something looking like what would have been
> > used in old pen and ink on paper days. The entries in date order no
> > matter what accounts were involved.
> >
> > See what the report "General Journal" gives 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.

Re: [GNC] New user error

[Patrick James]

Two questions:

1. What is "interactive mode," how does it differ from other modes, and where 
do I find the different modes?

> There IS however a report which will show you the journal (the date 
> ordered transactions) if for some reason you wanted to look at that.

2. While I understand reports have many options, and this discussion could 
quickly extend beyond the register view, if we (reasonably) keep it to the 
register, what's the difference between "Sort by" and select "Date of entry" 
versus the report?



> On 02/07/2024 2:26 PM PST Michael or Penny Novack 
>  wrote:
> 
>  
> On 2/7/2024 4:59 PM, R Losey wrote:
> > I was intrigued by the Transaction Journal mentioned, but I don't have a
> > Transaction Journal in my View menu...
> >
> > after additional digging, I discovered it doesn't show up on the Accounts
> > page; one must be in one of the accounts to see it.
> 
> Gnucash is "virtual journal". Those of us who learned in the old paper 
> and pen on paper days will remember we FIRST entered transactions in the 
> journal, then posted them to the ledger accounts. IF you select "journal 
> view" you can enter transactions that way, and when the entry is 
> complete, automatic posting. BUT except for one transaction at a time, 
> you can't see the journal directly while in interactive mode.
> 
> There IS however a report which will show you the journal (the date 
> ordered transactions) if for some reason you wanted to look at that.
> 
> This is not the time or place to discuss that some reports have 
> misleading names (in gnucash)
> 
> 
> Michael D Novack
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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 error (was: gnucash-user Digest, Vol 251, Issue 12)

[Patrick James]

After suggesting that the manual was read, and that "the double entry is 
understood," at some point the best answer becomes "it's time to hire an 
accountant."

> On 02/07/2024 10:50 AM PST sunfish62--- via gnucash-user 
>  wrote:
> 
>  
> Your register shows transactions. They add up to zero (as I and others have 
> noted)  and so don't show in the Chart of Accounts. 
> 
> RTFM
> 
> ⁣David T. ​
> 
> On Feb 7, 2024, 9:40 PM, at 9:40 PM, accounting Billing 
>  wrote:
> >I think this is a technical difficulty. Because none of the
> >transactions
> >are showing at all.
> >
> >On Wed, Feb 7, 2024 at 11:02 AM sunfis...@yahoo.com
> >
> >wrote:
> >
> >> You keep entering the second entry in your transaction **into the
> >same
> >> account you're in. **
> >>
> >> Think of it this way, you take $20 out of your right pocket, and then
> >put
> >> $20 into your right pocket. Assuming your right pocket started with
> >$20,
> >> how much is left after this transaction? ($20)
> >>
> >> GnuCash is recording *that* transaction, which is what you told it to
> >do.
> >>
> >> You say you've read the manual, but I'd recommend reviewing 2.2.3 and
> >5.3
> >> in the Guide, and section 6.2 in Help.
> >>
> >> David T.
> >> On Feb 7, 2024, at 5:43 PM, accounting Billing <
> >> account...@rapidroutelogistics.com> wrote:
> >>>
> >>> I did read the manual and understand the double entry. But how come
> >the
> >>> software is not recording and showing any transactions?
> >>>
> >>> If anyone can get a zoom call and help us to set this up. We will
> >donate
> >>> and compensate for their time.
> >>> My name is Beck, Cell 347-206-1096.
> >>>
> >>> On Wed, Feb 7, 2024 at 9:38 AM sunfis...@yahoo.com
> >
> >>> wrote:
> >>>
>  Also, you need to read the manual to understand double entry
> >accounting
>  and its implementation in GnuCash. (Stephen's previous reply to
> >your
>  question about Equity applies here as well.)
> 
>  And GnuCash list etiquette.
> 
>  David T.
>  On Feb 7, 2024, at 5:27 PM, accounting Billing <
>  account...@rapidroutelogistics.com> wrote:
> >
> > Also, When i try to record the expenses transactions, It is not
> >showing on
> > the dashboard.
> >
> > On Wed, Feb 7, 2024 at 9:16 AM 
> >wrote:
> >
> >  Send gnucash-user mailing list submissions to
> >>  gnucash-user@gnucash.org
> >>
> >>  To subscribe or unsubscribe via the World Wide Web, visit
> >>  https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>  or, via email, send a message with subject or body 'help' to
> >>  gnucash-user-requ...@gnucash.org
> >>
> >>  You can reach the person managing the list at
> >>  gnucash-user-ow...@gnucash.org
> >>
> >>  When replying, please edit your Subject line so it is more
> >specific
> >>  than "Re: Contents of gnucash-user digest..."
> >>
> >>
> >>  Today's Topics:
> >>
> >> 1. Re:  GNUCash 5.5 (Stan Brown (using GC 4.14))
> >> 2. Re:  Change Printed Invoice (Lester Bennett)
> >> 3. Re:  Change Printed Invoice (Michael or Penny Novack)
> >> 4.  GNUCash 5.5 (accounting Billing)
> >>
> >>
> >> --
> >>
> >>
> >>  Message: 1
> >>  Date: Tue, 6 Feb 2024 17:30:43 -0800
> >>  From: "Stan Brown (using GC 4.14)" 
> >>  To: gnucash-user@gnucash.org
> >>  Subject: Re: [GNC] GNUCash 5.5
> >>  Message-ID: <065b2fe8-8524-48c6-98c5-644030e7a...@fastmail.fm>
> >>  Content-Type: text/plain; charset=UTF-8
> >>
> >>
> >>  On 2024-02-06 16:51, accounting Billing wrote:
> >>
> >>>  From: accounting Billing 
> >>>  Date: Tue, Feb 6, 2024, 3:00?PM
> >>>  Subject: GNUCash 5.5
> >>>  To: , , <
> >>>  christopher@gmail.com>
> >>>
> >>>  We are willing to use GnuCash for our business accounting, But
> >we are
> >>>  facing some issues.
> >>>
> >>>  When I try to add any transactions. It is not showing on the
> >Accounts
> >>>  Total numbers.
> >>>
> >>>  When I try to put a transaction on the list, It is not showing
> >on the
> >>>
> >>  main
> >>
> >>>  page.
> >>>
> >>
> >>  You debited and credited Equity:Opening Balances for the same
> >amount, so
> >>  the net is zero, just as your attachment shows.  I don't
> >understand the
> >>  context of the I/O error; possibly the @ signs in your disk
> >names are a
> >>  problem.
> >>
> >>  Before you go further, may I strongly, strongly suggest that you
> >read
> >>  the Tutorial and Concepts Guide and actually work through the
> >examples
> >>  that are relevant to your particular situation.
> >>  
> >>
> >>  At bottom, GnuCash is just a computer replacement for keeping
> >books of
> >>  account in pen and ink. However, it has its own 

Re: [GNC] View - Double Line

[Patrick James]

I'm running GNUCash 5.4, because Windows.

My experience has been similar, but sometimes the register does display 
properly. Often when it does not display properly, if I arrow up, the situation 
is corrected.

I have not documented the behavior to the point where I could write a bug 
report, but I strongly suspect there is a bug.


> On 02/07/2024 9:19 AM PST dunop...@gmail.com wrote:
> 
>  
> Hello - I like to use the Double Line View so that I can put comments in
> each transaction. I have to click the Double Line View every time. Is there
> a setting or way to configure gnucash to always enable that setting?
> 
>  
> 
>  
> 
> Thank you,
> 
> Daniel Tran
> 
>  
> 
> ___
> 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 error (was: gnucash-user Digest, Vol 251, Issue 12)

[Patrick James]

This message is only about "recording and showing any transactions."

The recording of transactions is separate from the showing of transactions. 

The transactions could be recorded, but not shown. What I suggest is looking at 
all the options under the "View" pull-down menu, especially the "filter by" 
option.



> On 02/07/2024 6:43 AM PST accounting Billing 
>  wrote:
> 
>  
> I did read the manual and understand the double entry. But how come the
> software is not recording and showing any transactions?
> 
> If anyone can get a zoom call and help us to set this up. We will donate
> and compensate for their time.
> My name is Beck, Cell 347-206-1096.
> 
> On Wed, Feb 7, 2024 at 9:38 AM sunfis...@yahoo.com 
> wrote:
> 
> > Also, you need to read the manual to understand double entry accounting
> > and its implementation in GnuCash. (Stephen's previous reply to your
> > question about Equity applies here as well.)
> >
> > And GnuCash list etiquette.
> >
> > David T.
> > On Feb 7, 2024, at 5:27 PM, accounting Billing <
> > account...@rapidroutelogistics.com> wrote:
> >>
> >> Also, When i try to record the expenses transactions, It is not showing on
> >> the dashboard.
> >>
> >> On Wed, Feb 7, 2024 at 9:16 AM  wrote:
> >>
> >>  Send gnucash-user mailing list submissions to
> >>>  gnucash-user@gnucash.org
> >>>
> >>>  To subscribe or unsubscribe via the World Wide Web, visit
> >>>  https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>  or, via email, send a message with subject or body 'help' to
> >>>  gnucash-user-requ...@gnucash.org
> >>>
> >>>  You can reach the person managing the list at
> >>>  gnucash-user-ow...@gnucash.org
> >>>
> >>>  When replying, please edit your Subject line so it is more specific
> >>>  than "Re: Contents of gnucash-user digest..."
> >>>
> >>>
> >>>  Today's Topics:
> >>>
> >>> 1. Re:  GNUCash 5.5 (Stan Brown (using GC 4.14))
> >>> 2. Re:  Change Printed Invoice (Lester Bennett)
> >>> 3. Re:  Change Printed Invoice (Michael or Penny Novack)
> >>> 4.  GNUCash 5.5 (accounting Billing)
> >>>
> >>>
> >>> --
> >>>
> >>>
> >>>  Message: 1
> >>>  Date: Tue, 6 Feb 2024 17:30:43 -0800
> >>>  From: "Stan Brown (using GC 4.14)" 
> >>>  To: gnucash-user@gnucash.org
> >>>  Subject: Re: [GNC] GNUCash 5.5
> >>>  Message-ID: <065b2fe8-8524-48c6-98c5-644030e7a...@fastmail.fm>
> >>>  Content-Type: text/plain; charset=UTF-8
> >>>
> >>>
> >>>  On 2024-02-06 16:51, accounting Billing wrote:
> >>>
>   From: accounting Billing 
>   Date: Tue, Feb 6, 2024, 3:00?PM
>   Subject: GNUCash 5.5
>   To: , , <
>   christopher@gmail.com>
> 
>   We are willing to use GnuCash for our business accounting, But we are
>   facing some issues.
> 
>   When I try to add any transactions. It is not showing on the Accounts
>   Total numbers.
> 
>   When I try to put a transaction on the list, It is not showing on the
> 
> >>>  main
> >>>
>   page.
> 
> >>>
> >>>  You debited and credited Equity:Opening Balances for the same amount, so
> >>>  the net is zero, just as your attachment shows.  I don't understand the
> >>>  context of the I/O error; possibly the @ signs in your disk names are a
> >>>  problem.
> >>>
> >>>  Before you go further, may I strongly, strongly suggest that you read
> >>>  the Tutorial and Concepts Guide and actually work through the examples
> >>>  that are relevant to your particular situation.
> >>>  
> >>>
> >>>  At bottom, GnuCash is just a computer replacement for keeping books of
> >>>  account in pen and ink. However, it has its own special ways of doing
> >>>  things, and if you don't use the techniques as shown in the examples,
> >>>  results will not be as you expect and you'll get immensely frustrated.
> >>>
> >>>  Stan Brown
> >>>  Tehachapi, CA, USA
> >>>  https://BrownMath.com
> >>>
> >>>
> >>> --
> >>>
> >>>
> >>>  Message: 2
> >>>  Date: Wed, 7 Feb 2024 12:47:05 +1000
> >>>  From: Lester Bennett 
> >>>  To: John Ralls 
> >>>  Cc: Gnucash Users 
> >>>  Subject: Re: [GNC] Change Printed Invoice
> >>>  Message-ID: 
> >>>  Content-Type: text/plain; charset=UTF-8; format=flowed
> >>>
> >>>  Thanks John. I don't know why I didn't see the Custom Title options. I
> >>>  must have been through the configuration about 5 times. I guess I was
> >>>  blinkered and just looking for the word "Invoice".
> >>>
> >>>
> >>>  On 7/02/2024 10:27 am, John Ralls wrote:
> >>>
> 
> 
>   On Feb 6, 2024, at 4:01 PM, John Ralls  wrote:
> >
> >  Please remember to copy the list on all replies.
> >
> >  The tab is actually called "Printable Invoice". I've attached a
> >  screenshot.
> 
> 
> 
>   The screenshot apparently got eaten. Another try:
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>  --
> >>>  This email has been checked for viruses 

Re: [GNC] End of year

[Patrick James]

> On 01/30/2024 9:39 AM PST Michael or Penny Novack 
>  wrote:
> 
> ONE refers to closing all the accounts of type income and expense 
> (temporary accounts of fundamental type equity) into equity itself or 
> accounts under equity. You will have to be doing the latter if the 
> entity type isn't "sole" (personal books or a sole proprietorship) 
> because need to allocate to the individual partners or shareholders. 
> Just closing the accounts of type income and expense WILL start the new 
> year off with these at zero.

There are those who love the "Income Summary" account, and then there are those 
who would rather forget about 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.

Re: [GNC] How do you record the rounding of your netpay?

[Patrick James]

In my view it's going to be very difficult to justify spending any time 
tracking a whole bunch of zeroes with a contra equity account. I would not even 
want to see that on the books, much less spend time every pay period adjusting 
the contra account balance to some new amount less than 1.

At the end, the final paycheck, I'm betting the final paycheck is also rounded 
up, so that over the entire life of employment, the maximum "extra" paid is 
under 1, with an expected value of around 0.50.

This is all just a bunch of zeros, and the cost to track it is less than the 
value of the information.


> On 01/27/2024 3:14 PM PST David Cousens  wrote:
> 
>  
> If you really want to track this you could setup a contra account to your 
> Income acct which sums into the Income account e.g.
> 
> first month:
> 
> Income   Credit 1800.50
> Asset:Taxes withheld Debit   300.00
> Income::Pay rounding Credit0.50
> Asset:Bank   Debit  1501.00
> 
> second month:
> 
> Income   Credit 1800.30
> Asset:Taxes withheld Debit   300.00
> Income:Pay Rounding  Debit00.30
> Asset:Bank   Debit  1500.00
> 
> The balance in the Pay rounding account should hover around 0.00. and your 
> bank account will record the correct balance
> in the account at the bank.
> 
> 
> I cannot for the life of me understand why any payroll system would be 
> rounding to the nearest pound if they are using
> direct credit of your pay. To the nearest penny yes but not the nearest 
> pound. Seems like a hangover from when they paid
> in cash and didn't want to be bothered with coins.
> 
> David Cousens
> 
> On Sat, 2024-01-27 at 08:17 +, Oleander via gnucash-user wrote:
> > Hello everyone,
> > 
> > how do you record the rounding of your netpay?
> > 
> > After subtracting taxes from my gross pay, if the result of my net pay is a 
> > floating point number, my company rounds
> > this number up to the next integer then credits the amount to my bank 
> > account. But the rounding is just a loan, the
> > next month it will be charged from my gross pay along with taxes and if the 
> > result of my net pay again is a floating
> > point number, it will be rounded up to the next integer and then credited 
> > to my bank account and so on.
> > 
> > Eg:
> > 
> > 1st Month
> > 
> > Gross Pay = €1800.50
> > 
> > Taxes = €300
> > 
> > Netpay = 1500.50 --> 1501€ (amount credited to my bank account)
> > 
> > 2nd Month
> > 
> > Gross Pay = €1800.30
> > 
> > Taxes = €300
> > 
> > 1st Month Rounding = €0.50
> > 
> > Netpay = 1499.80 --> 1500€ (amount credited to my bank account)
> > 
> > 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.
> 
> ___
> 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] How do you record the rounding of your netpay?

[Patrick James]

This rounding is not material to your financial condition.

Tracking the rounding is not worth the time and effort necessary, so you could 
adjust your gross pay for the rounding.

First month would be an increase (in pay/earnings) of €0.50, and the second 
month would be a decrease by €0.30. Over time your recorded Salary on your 
books will never drift more than €1, as there is always an adjustment to trend 
toward a €0 difference.

1st Month

€1501 DR Cash
€300 DR Taxes
€1801 CR Salary

2nd Month

€1500 DR Cash
€300 DR Taxes
€1800 CR Salary



> On 01/27/2024 12:17 AM PST Oleander via gnucash-user 
>  wrote:
> 
>  
> Hello everyone,
> 
> how do you record the rounding of your netpay?
> 
> After subtracting taxes from my gross pay, if the result of my net pay is a 
> floating point number, my company rounds this number up to the next integer 
> then credits the amount to my bank account. But the rounding is just a loan, 
> the next month it will be charged from my gross pay along with taxes and if 
> the result of my net pay again is a floating point number, it will be rounded 
> up to the next integer and then credited to my bank account and so on.
> 
> Eg:
> 
> 1st Month
> 
> Gross Pay = €1800.50
> 
> Taxes = €300
> 
> Netpay = 1500.50 --> 1501€ (amount credited to my bank account)
> 
> 2nd Month
> 
> Gross Pay = €1800.30
> 
> Taxes = €300
> 
> 1st Month Rounding = €0.50
> 
> Netpay = 1499.80 --> 1500€ (amount credited to my bank account)
> 
> 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.
___
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] Maddening!!!!!!!!

[Patrick James]

This is bug 799093, and John Ralls has not asked additional questions after I 
was able to reliably reproduce (part of) the issue, so, hopefully, there is 
sufficient information to find the bug.

https://bugs.gnucash.org/show_bug.cgi?id=799093


> On 01/25/2024 10:02 AM PST Jack Slater  wrote:
> 
>  
> I'm back! Reconciling a credit card account today. Another "rogue"
> transaction created in the reconcile register (image attached).
> However it's NOT in the account ledger (image attached)!! When I try to
> edit the reconcile transaction I get an error message reading "Target split
> is currently hidden in this register" (also attached). I know I read a bug
> report on this action and I thought I could add more evidence in hopes of
> getting the issue resolved.
> 
> [image: there.jpg]
> [image: not there.jpg]
> 
> [image: error.jpg]
> 
> On Thu, Jan 11, 2024 at 5:48 PM Jim DeLaHunt  wrote:
> 
> > Jack:
> >
> > On 2024-01-11 09:11, Jack Slater wrote:
> > > 90 minutes of reconciling down the drain with a crash near the end of the
> > > final account
> > My commiserations. Yes, it is maddening to lose 90 minutes of work when
> > the tech decides to fail you.
> > > ... Oddly, even though GnuC auto saves periodically, it seems
> > > none of any add/delete/balance transactions were saved in any account!
> > Why
> > > would that be
> >
> > I can think of several interesting directions you could take this thread:
> >
> > Why didn't GnuCash seem to preserve any of the changes in my 90 minutes
> > of work?
> >
> > How can I change my workflow so that I lose less work when the tech
> > decides to fail me?
> >
> > How can I improve the way I write message to this list, so that I get
> > more helpful answers?
> >
> > How can I stop these tech failures from happening?
> >
> > On that last point, I can offer two concrete suggestions:
> >
> > 1. GnuCash has a "Check and Repair" feature which is useful to try when
> > you are concerned about "rogue" transactions and such. Try going to the
> > Accounts tab of the main window, and select menu item Actions -- Check
> > and Repair -- Repair All. This menu is described a little in the GnuCash
> > manual, section 4.2.1.4. "Account Tree - Actions Menu", at
> > <
> > https://www.gnucash.org/docs/v5/C/gnucash-manual/gui-acct-tree.html#AccTree-actions-menu
> > >.
> >
> > 2. The text in your "Entry Point Not Found" dialogue, which GnuCash
> > displays when it crashes, has been discussed on this list recently.  It
> > is described in a bug report at
> > . It is suspected to be
> > problem from GnuCash 5.4 leaving pieces behind when GnuCash 5.5
> > installs. There is a workaround there:
> >
> > a. Use the File Explorer to open "C:\Program Files (x86)\gnucash\bin\"
> >
> > b. If there is a file named "libxmlsec1.dll" present, but no file named
> > "libxmlsec.dll", then rename file "libxmlsec1.dll" to the name
> > "libxmlsec.dll" (without the trailing "1").
> >
> > I do not use GnuCash on Windows, so I have no experience with this
> > problem. I only know what I read. If you ask this list directly about
> > how to work around this bug, Windows users may be able to give you
> > better help.
> >
> > I hope this helps,
> >   —Jim DeLaHunt
> >
> >
> >
> ___
> 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] how to record tax credit for capital loss

[Patrick James]

> If I run out of past credits then that's a final gain, that's taxable
> the moment it's realized (and some brokers straightly withold it from
> the selling price!), it's not possible to offset with a future loss
> within the same year.

It should be total obvious that to minimize taxes if you were selling two 
different positions for a net of no gain or loss, then you'd better sell the 
loss on day 1 and the gain on day 2.

I would not want to risk my broker trading the gain a few seconds before the 
loss.
___
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 to record tax credit for capital loss

[Patrick James]

You mention picking the earliest year to minimize the tax liability (i.e. 
maximize the loss matching), but within a window of time.

> On 01/24/2024 7:53 AM PST Mattia Rizzolo  wrote:
> 
>  Besides, one offests losses by fist pickin the
> furtherst year first, so it's good to know how much is left to offset
> from each given year for each broker (it's common practice in Q4 to look
> at what's left over from 3-4 years before and evaluate what to do to not
> lose the credit).

The normal balance is CR in the equity account, but for tax purposes you're 
looking for a zero/DR balance. According to what you're suggesting, you can 
match current CRs (gains) to past DRs (losses), but you can only offset the DR 
balance within a given window of time (and there are some tax reporting periods 
in this discussion).

So if you have a DR balance in your Brokerage 1 2020 account, then you'd credit 
that account if you sold for a gain today, until the account balance is zero, 
and then you'd credit 2021 for the leftover CR amount, up to the 2021 DR 
balance, and so on and so forth.

Eventually you'll run out of gain, or you'll have to credit the remaining CR 
balance to the current year account (Brokerage 1 2024), which you might be able 
to offset with a future DR, if you sold something for a loss, and that future 
transaction meets the right windows of time.
___
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 to record tax credit for capital loss

[Patrick James]

Again keeping in mind that I am NOT a tax authority.

Now that we're on the equity side, let's move forward with your tracking.

I very much doubt that you need two separate accounts for the losses and gains; 
from what you're suggesting, you need to match some gains with some losses. I 
would match these in a single account " Capital Gains" where it is known 
that CR is "gain" (the expected/desired 'normal' balance) and DR is "loss." 
Just labeling an account "Capital" is difficult when looking back/keeping track 
of what is what. And one need not label it "Capital Gain or Loss," as the "or 
loss" part is understood based on the balance in the account.

Given what you are requesting, I'd have something like this:

Capital Gain
2017 Broker 1
2017 Broker 2
2018 Broker 1
2018 Broker 2

You would know what is best in terms of subaccounts.

Then run reports if you need some specific information, which could include 
separating the losses from the gains based on the debits and credits.

Keep in mind that I'm providing some ideas about how to use GNUCash as a tool, 
and I have no idea about your tax requirements.


> On 01/24/2024 3:11 AM PST Mattia Rizzolo  wrote:
> 
>  
> Thank you Patrick for your suggestion!
> 
> I see what you are suggesting here… Mh.
> 
> It could easily become very messy as the rules for offsetting gains is
> fairly annoying here: gains some financial instruments can offset losses
> only from some other particular financial instruments (i.e., "gains"
> from the dividends can *never* be offeset, or losses from stocks can't
> be offset by gain on ETFs, etc)…  Plus the fact that I'd need to split
> losses by years and brokers… it's going to be annoying to have an
> account clearly state the "correct" credit I'm due this way.
> 
> 
> But I think you may have pointed me to the right direction, of keeping
> everything within the equities, here is what I've done:
> (yes, I realize that income/expenses are "the same thing")
> 
> Expenses
>  |- Capital Loss
> |- Broker 1
> |- 2017
> |- 2020
> |- 2021
> |- 2023
> Income
>  |- Capital Gain
> 
> So, I changed my losses to be posted against the proper "capital loss"
> account instead of being a negative gain, and then I'm posting the
> future gains as compensation of that loss (and only for the part that
> can be compensated).
> This way indeed the balance of the Broker1 account does match with what
> the broker is showing me.
> 
> 
> Do anybody believe I may be missing something out when recording capital
> gains/losses this way?
> 
> 
> On Tue, Jan 23, 2024 at 03:43:03PM -0800, Patrick James wrote:
> > Let's start with your best bet is to work with your tax professional as to 
> > how best to keep track of what's needed for taxes.
> > 
> > In the US, what you call a "credit" generally would not be an asset 
> > account. The "credit" would be a potential offset to some future gain, if 
> > there is any future gain, so I would leave all this over on the equity side.
> > 
> > Day 0 Purchase:
> > 
> > Stock (asset) $100DR
> > Cash $100CR
> > Purchase of 100 shares of Stock Y for $1 per share
> > 
> > Day 365 Sale:
> > 
> > Cash $90DR
> > Capital Gain $10DR
> > Stock (asset) $100CR
> > Sale of 100 shares of Day 0 Stock Y for $0.90 per share.
> > 
> > NOTE: One hopes that capital gains has a CR (gain) balance, rather than the 
> > DR balance above (loss).
> > 
> > Later, if there was some sale for a gain, then the CR recorded to Capital 
> > Gain would offset some or all of the DR.
> > 
> > Also note that matching the shares as I have done above is not always as 
> > simple as this single stock sale where all shares are purchased on a single 
> > day and the entire holding is sold a year later.
> > 
> > Again, talk to your tax professional about how to best keep the records 
> > necessary for tax compliance.
> > 
> > 
> > > On 01/23/2024 1:43 PM PST Mattia Rizzolo  wrote:
> > > 
> > >  
> > > Hello,
> > > 
> > > I'd like some input on how to best record a tax credit due to capital
> > > loss, and possibly the following usage of such credit.
> > > Disclaimer: I'm not doing this for anything worth, it's a personal book
> > > that nobody but me sees, so I can take a few liberties and not follow
> > > whatever regulation to the letter.  Besides, I have no formal education
> > > on accounting.
> > > 
> > > 
> > > The case is the 

Re: [GNC] how to record tax credit for capital loss

[Patrick James]

Let's start with your best bet is to work with your tax professional as to how 
best to keep track of what's needed for taxes.

In the US, what you call a "credit" generally would not be an asset account. 
The "credit" would be a potential offset to some future gain, if there is any 
future gain, so I would leave all this over on the equity side.

Day 0 Purchase:

Stock (asset) $100DR
Cash $100CR
Purchase of 100 shares of Stock Y for $1 per share

Day 365 Sale:

Cash $90DR
Capital Gain $10DR
Stock (asset) $100CR
Sale of 100 shares of Day 0 Stock Y for $0.90 per share.

NOTE: One hopes that capital gains has a CR (gain) balance, rather than the DR 
balance above (loss).

Later, if there was some sale for a gain, then the CR recorded to Capital Gain 
would offset some or all of the DR.

Also note that matching the shares as I have done above is not always as simple 
as this single stock sale where all shares are purchased on a single day and 
the entire holding is sold a year later.

Again, talk to your tax professional about how to best keep the records 
necessary for tax compliance.


> On 01/23/2024 1:43 PM PST Mattia Rizzolo  wrote:
> 
>  
> Hello,
> 
> I'd like some input on how to best record a tax credit due to capital
> loss, and possibly the following usage of such credit.
> Disclaimer: I'm not doing this for anything worth, it's a personal book
> that nobody but me sees, so I can take a few liberties and not follow
> whatever regulation to the letter.  Besides, I have no formal education
> on accounting.
> 
> 
> The case is the following:
> 
> 1 buy security A, cost $100
> 2 buy security B, cost $100
> 3 sell security A, get $90
> 3a → record $10 loss
> 3b → get a $10 tax credit on following capital gains
> 4 sell security B, get $120
> 4a → record $20 gain
> 4b → offset $10 from 3b
> 4c → pay tax on the remaining $10 (26%, $2.6 over here)
> 
> I reckon all jurisdictions have something similar in concept, all with
> their differences in details.
> 
> This is a tad further complicated by the fact that each broker has its
> own "bucket" of credits (can't comingle losses and gains across
> different brokers).  Also the credits expire after 4 years, so I should
> record under which year they matured.  As such, I expect an addition to
> my CoA, such as:
> Assets
>   |- Credits
> |- Capital Loss credits
> |- broker 1
>  |- 2020
>  |- 2021
>  |- 2022
>  |- 2023
>  |- 2024
> |- broker 2
>  |- 2022
>  .
> 
> 
> 
> I've been using gnucash for ~3 years now, but I always procrastinated on
> figuring out the 3b/4b steps, just posting the resulting net tax
> transaction as computed by the broker.
> For me it's really not obvious what's the opposing account from where
> the money should come/go...
> How do people do it here? :)
> 
> 
> Thank you for all the hints!
> 
> -- 
> regards,
> Mattia Rizzolo
> 
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> More about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> ___
> 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] Compare two sets of accounts?

[Patrick James]

The --nofile parameter is fine as you are commanding GnuCash "Do not load the 
last file opened."

There is another option, which is to command GnuCash to open a specific file.

The command line structure is: gnucash [options] [datafile]

So if you add the datafile, GnuCash will open with that set of books ready to 
go.

See "Command line options" here:

https://wiki.gnucash.org/wiki/Logging

Your best option depends on your workflow. I'm running GnuCash on Windows, and 
for my two most commonly used datafiles, I placed separate icons on my desktop 
so I may easily and quickly open one or both of the data files.


> On 01/21/2024 8:05 AM PST Myron A Schroeder  wrote:
> 
>  
> Where do I find the " --nofile runtime parameter."
> 
> Looks like an interesting way to have more than one set of books on my
> computer.
> 
> Thanks for your help.
> 
> Myron Schroeder
> 
> On Fri, Jan 19, 2024 at 11:42 AM Gyle McCollam  wrote:
> 
> > The quick and dirty solution is to save a copy of what you send to the
> > accounts, under a different name (say: B4A) and when you get back the file
> > from the accountants review the accounts tab of the B4A with the returned
> > file.  That will tell you which accounts have a change in value.  You can
> > then open those accounts and see what changes/corrections they made.  ou
> > can then make those same changes in your current file.  Just make sure that
> > after you save a copy (B4A) that you aren't using that file going forward
> > as GC usually opens the last saved file.
> >
> >
> > Thank You,
> >
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > gmccol...@live.com   email
> >
> > 
> > From: gnucash-user  on
> > behalf of Simon Roberts 
> > Sent: Friday, January 19, 2024 8:50 AM
> > To: Gnucash Users 
> > Subject: [GNC] Compare two sets of accounts?
> >
> > Hi all,
> >
> > Does GNC provide any mechanism for comparing two versions of the same set
> > of accounts?
> >
> > I'll be sending my books to my accountant soon, and I imagine they will
> > have some corrections/adjustments. I'll be giving them a laptop with GNC
> > installed, so they can most easily browse, and it occurs to me that they
> > could also make their changes in place. But, unless they write down
> > separately every entry they create or change, I would need to somehow
> > re-integrate their work with my "master" file. Either that, or I'd have to
> > freeze my bookkeeping while they're working on things, and that's likely to
> > take too long to be acceptable.
> >
> > With the hostage-taker's rent-ware that I used to use, there was a specific
> > mechanism for an "accountant's copy" and a means to merge the changes back
> > automatically. But I've failed to find this in the docs for GNC (quite
> > possibly as a result of poor / uninspired searching!)
> >
> > Is this supported directly? Is this something folks have found an approach
> > for? I suppose, as a not quite worst case, I could simply diff the XML file
> > itself, but that's going to produce results that will be somewhat messy, at
> > best. But at least I'd know something about what changed.
> >
> > What ideas can you offer (or manual pages, if I've failed that
> > embarrassingly!)
> >
> > TIA,
> > Simon
> >
> >
> > --
> > Simon Roberts
> > 303 249 3613
> > https://www.youtube.com/@DancingCloudServices
> > https://www.linkedin.com/in/simonhgroberts/
> > ___
> > 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] Compare two sets of accounts?

[Patrick James]

I was extending to 2023 changes. For example, if Simon made some insignificant 
change to 2023, let's say a memo (debits = credits = none = memo only) that he 
believed was important, but this does not change the financial condition of 
2023 (or something else that is so insignificant that he can review after 
receiving his books back), then he'd have to track that.
 
I have not carefully studied the database structure, so maybe it's possible to 
capture for export my example of a 2023 memo that was entered in 2024?
 

> On 01/19/2024 1:02 PM PST Gyle McCollam  wrote:
>  
>  
> Assuming that the info sent to the accountants ended at 12/31/2023, Simon 
> could export all 2024 transactions in CSV format as you suggested.  He could 
> then import into the returned files from the accountants and he wouldn't have 
> to track any changes he made.
>  
> The log files are another option, but it would depend on how long they were 
> saved and how long the accountants took.
>  
> 
> Thank You,  
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com mailto:gmccol...@gyleshomes.com   email
> 
>  
> 
> ---------
> From: gnucash-user  on 
> behalf of Patrick James 
> Sent: Friday, January 19, 2024 12:24 PM
> To: Gnucash Users 
> Subject: Re: [GNC] Compare two sets of accounts?
>  
> One option might be to use the data log files, information in 2.5.2 here:
> 
> https://code.gnucash.org/docs/C/gnucash-guide/basics-backup1.html
> 
> I have not played around with those much, but I suspect you could backup your 
> master set of books (3-2-1 backup strategy might be used here), and then make 
> a copy of your master set to test the replay of the data log files (.log), as 
> described in the link above.
> 
> Another, separate, option might be for you to keep track of the changes you 
> made, and then export the changes in CSV formation, then import them to the 
> file that's returned from your accountant.
> 
> Check out the CSV import/export information here:
> 
> Export:
> https://gnucash.org/docs/v5/C/gnucash-manual/trans-export.html
> 
> Import:
> https://gnucash.org/docs/v5/C/gnucash-manual/trans-import.html
> 
> 
> 
> > On 01/19/2024 5:50 AM PST Simon Roberts  
> > wrote:
> >
> > 
> > Hi all,
> >
> > Does GNC provide any mechanism for comparing two versions of the same set
> > of accounts?
> >
> > I'll be sending my books to my accountant soon, and I imagine they will
> > have some corrections/adjustments. I'll be giving them a laptop with GNC
> > installed, so they can most easily browse, and it occurs to me that they
> > could also make their changes in place. But, unless they write down
> > separately every entry they create or change, I would need to somehow
> > re-integrate their work with my "master" file. Either that, or I'd have to
> > freeze my bookkeeping while they're working on things, and that's likely to
> > take too long to be acceptable.
> >
> > With the hostage-taker's rent-ware that I used to use, there was a specific
> > mechanism for an "accountant's copy" and a means to merge the changes back
> > automatically. But I've failed to find this in the docs for GNC (quite
> > possibly as a result of poor / uninspired searching!)
> >
> > Is this supported directly? Is this something folks have found an approach
> > for? I suppose, as a not quite worst case, I could simply diff the XML file
> > itself, but that's going to produce results that will be somewhat messy, at
> > best. But at least I'd know something about what changed.
> >
> > What ideas can you offer (or manual pages, if I've failed that
> > embarrassingly!)
> ___
> 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] Compare two sets of accounts?

[Patrick James]

One option might be to use the data log files, information in 2.5.2 here:

https://code.gnucash.org/docs/C/gnucash-guide/basics-backup1.html

I have not played around with those much, but I suspect you could backup your 
master set of books (3-2-1 backup strategy might be used here), and then make a 
copy of your master set to test the replay of the data log files (.log), as 
described in the link above.

Another, separate, option might be for you to keep track of the changes you 
made, and then export the changes in CSV formation, then import them to the 
file that's returned from your accountant. 

Check out the CSV import/export information here:

Export:
https://gnucash.org/docs/v5/C/gnucash-manual/trans-export.html

Import:
https://gnucash.org/docs/v5/C/gnucash-manual/trans-import.html



> On 01/19/2024 5:50 AM PST Simon Roberts  
> wrote:
> 
>  
> Hi all,
> 
> Does GNC provide any mechanism for comparing two versions of the same set
> of accounts?
> 
> I'll be sending my books to my accountant soon, and I imagine they will
> have some corrections/adjustments. I'll be giving them a laptop with GNC
> installed, so they can most easily browse, and it occurs to me that they
> could also make their changes in place. But, unless they write down
> separately every entry they create or change, I would need to somehow
> re-integrate their work with my "master" file. Either that, or I'd have to
> freeze my bookkeeping while they're working on things, and that's likely to
> take too long to be acceptable.
> 
> With the hostage-taker's rent-ware that I used to use, there was a specific
> mechanism for an "accountant's copy" and a means to merge the changes back
> automatically. But I've failed to find this in the docs for GNC (quite
> possibly as a result of poor / uninspired searching!)
> 
> Is this supported directly? Is this something folks have found an approach
> for? I suppose, as a not quite worst case, I could simply diff the XML file
> itself, but that's going to produce results that will be somewhat messy, at
> best. But at least I'd know something about what changed.
> 
> What ideas can you offer (or manual pages, if I've failed that
> embarrassingly!)
___
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] Error Windows 11 when running reports

[Patrick James]

There is a known bug with reports in GnuCash version 5.5 on a Windows machine. 

The bug is well-understood, but the fix is not so easy.

Moving down to 5.4 will fix the report problem.

> On 01/17/2024 3:29 PM PST Ignacio Ayuste  wrote:
> 
>  
> Hi All, for a lot reports i noticed the file generated in temp folder but
> the app crash, I run the app using winDbg and the error is:
> 
> (4130.c2c): Access violation - code c005 (!!! second chance !!!)
> eax= ebx=62f200a0 ecx= edx= esi=1049fff0
> edi=0004
> eip=62d400d3 esp=00bfe840 ebp=00bfe888 iopl=0 nv up ei pl nz na po
> nc
> cs=0023  ss=002b  ds=002b  es=002b  fs=0053  gs=002b
> efl=00210202
> libjavascriptcoregtk_3_0_0!ZN3JSC8JSObject27getOwnNonIndexPropertyNamesEPS0_PNS_9ExecStateERNS_17PropertyNameArrayENS_15EnumerationModeE+0x473:
> 62d400d3 8b49fc  mov ecx,dword ptr [ecx-4]
> ds:002b:fffc=
> 
> 0:000> !analyze -v
> ***
> *
>   *
> *Exception Analysis
>   *
> *
>   *
> ***
> 
> 
> KEY_VALUES_STRING: 1
> 
> Key  : AV.Fault
> Value: Read
> 
> Key  : Analysis.CPU.mSec
> Value: 2483
> 
> Key  : Analysis.Elapsed.mSec
> Value: 35877
> 
> Key  : Analysis.IO.Other.Mb
> Value: 80
> 
> Key  : Analysis.IO.Read.Mb
> Value: 1
> 
> Key  : Analysis.IO.Write.Mb
> Value: 117
> 
> Key  : Analysis.Init.CPU.mSec
> Value: 1046
> 
> Key  : Analysis.Init.Elapsed.mSec
> Value: 761028
> 
> Key  : Analysis.Memory.CommitPeak.Mb
> Value: 97
> 
> Key  : Failure.Bucket
> Value:
> INVALID_CLASS_PTR_READ_c005_libjavascriptcoregtk-3.0-0.dll!Unknown
> 
> Key  : Failure.Hash
> Value: {7c9c3c53-a28e-a583-683b-6075744558e7}
> 
> Key  : Timeline.OS.Boot.DeltaSec
> Value: 39191
> 
> Key  : Timeline.Process.Start.DeltaSec
> Value: 761
> 
> Key  : WER.OS.Branch
> Value: ni_release
> 
> Key  : WER.OS.Version
> Value: 10.0.22621.1
> 
> Key  : WER.Process.Version
> Value: 5.5.0.0
> 
> 
> NTGLOBALFLAG:  70
> 
> PROCESS_BAM_CURRENT_THROTTLED: 0
> 
> PROCESS_BAM_PREVIOUS_THROTTLED: 0
> 
> APPLICATION_VERIFIER_FLAGS:  0
> 
> EXCEPTION_RECORD:  (.exr -1)
> ExceptionAddress: 62d400d3
> (libjavascriptcoregtk_3_0_0!ZN3JSC8JSObject27getOwnNonIndexPropertyNamesEPS0_PNS_9ExecStateERNS_17PropertyNameArrayENS_15EnumerationModeE+0x0473)
>ExceptionCode: c005 (Access violation)
>   ExceptionFlags: 
> NumberParameters: 2
>Parameter[0]: 
>Parameter[1]: fffc
> Attempt to read from address fffc
> 
> FAULTING_THREAD:  0c2c
> 
> PROCESS_NAME:  gnucash.exe
> 
> READ_ADDRESS:  fffc
> 
> ERROR_CODE: (NTSTATUS) 0xc005 - The instruction at 0x%p referenced
> memory at 0x%p. The memory could not be %s.
> 
> EXCEPTION_CODE_STR:  c005
> 
> EXCEPTION_PARAMETER1:  
> 
> EXCEPTION_PARAMETER2:  fffc
> 
> STACK_TEXT:
> WARNING: Stack unwind information not available. Following frames may be
> wrong.
> 00bfe888 62d4794a 0c43bcd0 10e1fff0 
> libjavascriptcoregtk_3_0_0!ZN3JSC8JSObject27getOwnNonIndexPropertyNamesEPS0_PNS_9ExecStateERNS_17PropertyNameArrayENS_15EnumerationModeE+0x473
> 00bfe8b8 62d170db 0c43bcd0  0004
> libjavascriptcoregtk_3_0_0!ZN3JSC8JSObject20growOutOfLineStorageERNS_2VMEjj+0x3a
> 00bfe958 62d13f7c 0c43bcd0 00bfea88 
> libjavascriptcoregtk_3_0_0!ZN3JSC16InternalFunction14finishCreationERNS_2VMERKN3WTF6StringE+0xa0b
> 00bfe988 62d31db1 0c43bcd0 00bfea88 
> libjavascriptcoregtk_3_0_0!ZN3JSC17FunctionPrototype14finishCreationERNS_2VMERKN3WTF6StringE+0x1c
> 00bfeae8 62d398c0 0c43bcd0 1045f530 0c43bcd0
> libjavascriptcoregtk_3_0_0!ZN3JSC14JSGlobalObject5resetENS_7JSValueE+0x111
> 00bfeb18 6332e524 10dbffe0 0040 0c43bcd0
> libjavascriptcoregtk_3_0_0!ZN3JSC14JSGlobalObject4initEPNS_8JSObjectE+0xa0
> 00bfeb48 6332fe9c 0c43bcd0 10dbffe0 00bfeb98
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x3cb64
> 00bfeb98 63334d32 0c43bcd0 10dbffe0 00bfebe8
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x3e4dc
> 00bfec08 63334f9f 00bfec2c 002f 00bfec38
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x43372
> 00bfec38 63355d38 0c43bcd0 00bfec90 0c44bf88
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x435df
> 00bfecb8 633564e3 0c44bf88 f4830899 00bfed18
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x64378
> 00bfed08 63356912 0c44bf88 0c457f24 0c457f24
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x64b23
> 00bfedb8 63356a96 0c3c1e28 00bfee94 0c44bf88
> libwebkitgtk_3_0_0!webkit_authentication_widget_get_type+0x64f52
> 00bfedd8 63484033 0c3c1e28 00bfee94 0c458750
> 

Re: [GNC] Liability Balances - All payments disappeared

[Patrick James]

I suspect it is fair to say that the UI design results in different uses of the 
same English terms from accounting, thus a "split" in terminology.


> On 01/18/2024 12:03 PM PST Adrien Monteleone  
> wrote:
> 
>  
> Yes, this is an example where it isn't just the terminology of users, 
> but rather that the UI uses the term 'split' for two different meanings.
> 
> I too have memo transactions with only one split and no value.
> 
> Regards,
> Adrien
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Liability Balances - All payments disappeared

[Patrick James]

A "simple journal entry" is a journal entry that involves no more than two 
accounts.

A "compound journal entry" is a journal entry that involves more than two 
accounts.

That's the 'easy' part.

Now there are entries that involve multiple debits or multiple credits, or 
both, that only impact two accounts. This I personally call this a "split," as 
at least one debit or credit is being "split" into more than is necessary for 
the basics. Often the memos are important here.

When the "transaction journal" in GnuCash is selected, GnuCash shows all the 
impacted accounts, and if "Double Line" is also selected, then it shows the 
memo field too.

I'm not sure what the best use of "split" is, as this question reminds me of 
various seemingly simple questions, such as "Where does milk come from?"


> On 01/18/2024 8:56 AM PST Adrien Monteleone  
> wrote:
> 
>  
> Fair enough. We need a new term for one of these things. It is a 
> repeated source of confusion & consternation.
> 
> Regards,
> Adrien
> 
> On 1/18/24 9:54 AM, Michael or Penny Novack wrote:
> > Except I would never refer to a transaction that affect JUST TWO 
> > accounts to have any "splits". When I use the term "splits" I mean that 
> > either there is more than one debit account, more than one credit 
> > account, or both. ALL transactions involve at least two accounts, at 
> > least one debit and at least one credit. That is fundamental to double 
> > entry bookkeeping.
> 
> ___
> 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] Template Transactions Behavior in Scheduled Transaction Editor

[Patrick James]

>From the pulldown menus:

Actions -> Scheduled Transactions -> Since Last Run...

> On 01/12/2024 7:13 PM PST Liz  wrote:
>
> So would you like a button which gives an option to make a test run?
> 
> Liz
>  
> On Fri, 12 Jan 2024 12:08:14 -0600
> David Carlson  wrote:
> 
> > I consider the SX to be a graphical form of a script, and so I am not
> > sure how the editor could detect what is safe to call an expression
> > that could be evaluated while it is being edited.
> >
___
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] Maddening!!!!!!!!

[Patrick James]

I own a few, but I generally don't use timers.
 
What should I expect at 90 minutes, and at what point do I start the timer?
 

> On 01/12/2024 12:29 PM PST David Carlson  wrote:
>  
>  
> ...except when something happens after 90 minutes of that sort of activity 
> that creates a huge mess.
> 
> On Fri, Jan 12, 2024 at 2:11 PM Jack Slater  mailto:theillini...@gmail.com> wrote:
> 
> > I'd certainly agree.
> > 
> > On Fri, Jan 12, 2024 at 11:57 AM Patrick James  > mailto:patrickjame...@comcast.net>
> > wrote:
> > 
> > > My personal experience is that this "phantom transaction" problem began in
> > > 5.X.
> > >
> > > Using 4.X, I experienced no problems changing/adding/deleting transactions
> > > during a reconciliation.
> > >
> > >
> > > > On 01/12/2024 9:44 AM PST David Carlson  > > > mailto:david.carlson@gmail.com>
> > > wrote:
> > > >
> > > >
> > > > It sounds like you are entering new transactions while part way through
> > > > performing a reconciliation process.
> > > >
> > > > I suspect that could confuse the reconciliation.
> > > >
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org mailto:gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org mailto:gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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] Maddening!!!!!!!!

[Patrick James]

Jack,

This "log file" discussion seemed to get moved to a stack type of log. There is 
another log with GNUCash, which is somewhat unique in that programmers usually 
need the stack log (all programming).

The GNUCash data log file is explained in 2.5.2.

https://lists.gnucash.org/docs/C/gnucash-guide/basics-backup1.html

> On 01/11/2024 9:41 AM PST Jack Slater  wrote:
> 
>  
> Sorry Dale but I'd no idea how or what to look for or do.
>
___
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] Maddening!!!!!!!!

[Patrick James]

My personal experience is that this "phantom transaction" problem began in 5.X.

Using 4.X, I experienced no problems changing/adding/deleting transactions 
during a reconciliation.


> On 01/12/2024 9:44 AM PST David Carlson  wrote:
> 
>  
> It sounds like you are entering new transactions while part way through
> performing a reconciliation process.
> 
> I suspect that could confuse the reconciliation.
>
___
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] Find not working in Gnucash for Windows 5.0

[Patrick James]

Tute Terner,

Will you please upload your sample data set.


> On 04/07/2023 11:46 AM Adrien Monteleone  
> wrote:
> 
>  
> Do the splits *that match the open account register* have 'paid' in 
> their memos?
> 
> If the 'paid' text is in a memo assigned to some *other* account, you 
> will not get results. Memos are not for the open register, but only for 
> accounts matching *for that split*.
> 
> e.g.,
> 
> Dr. Expenses:Utilities100
>-(Memo = "paid")
>Cr. Assets:Checking100
>  -(Memo is blank)
> 
> And you do a search with the Checking account register in view, for 
> "paid" you will get no results, because there are no splits *assigned to 
> the Checking account* with that memo. The splits that have that memo, 
> are assigned (in this case) to Expenses:Utilities.
> 
> You can do the search from the Accounts page, and set additional 
> criteria as needed to refine the search.
> 
> Regards,
> Adrien
> 
> On 4/7/23 5:57 AM, Tute Terner wrote:
> > On 2023-04-05 07:18, Tute Terner wrote:
> >> /When I search in the Find dialog box using the Description field, 
> >> />/everything works. But when I search by the Memo field or the 
> >> />/'Description, Notes or Memo' field or the Action field the Search 
> >> />/Results always turn out empty, even though the search string is 
> >> present />/in the Memo or Action fields of some transactions.  I am 
> >> using Gnucash />/5.0 for Windows, but I have noticed this in some 
> >> previous versions too. />/Am I doing something incorrect or is this a 
> >> bug. I don't see that />/anybody has mentioned this behaviour in the 
> >> mailing list or in the bug />/list. Thank you. /
> > 
> > 
> > The specific search instance I had is this. I have a Gnucash file with 
> > accounts X, Y, and Z. X and Y have split Memo fields containing the 
> > search string 'paid'. I display account register X and search for 'paid' 
> > in the Memo field. Zero results. I then go to 'List of accounts' tree 
> > tab and search the same, using 'New Search' every time. I get results 
> > from both X and Y. So this works, but I don't want the result from Y.
> > 
> > So again I search from the accounts tree tab adding the 'and' condition 
> > of Account and set it to X. Again 0 results. I display account register 
> > Y and run the search on Memo field only. Again 0 results.
> > 
> > To make doubly sure I created a dummy gnucash file with accounts X, Y 
> > and Z as above. Same results. So looks like a bug to me.
> 
> ___
> 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] Find not working in Gnucash for Windows 5.0

[Patrick James]

I am not a programmer, but this has a similar behavior to the bug I reported, 
in that the selected tab makes a big difference.

Sure, I reported the bug as a "second search" as that is how I associated it at 
the time, but with this added information the bug might be more about the tab 
selected.

I added this to my bug report here:

https://bugs.gnucash.org/show_bug.cgi?id=798803


> On 04/07/2023 3:57 AM Tute Terner  wrote:
> 
>  
> On 2023-04-05 07:18, Tute Terner wrote:
> >/When I search in the Find dialog box using the Description field, 
> >/>/everything works. But when I search by the Memo field or the 
> >/>/'Description, Notes or Memo' field or the Action field the Search 
> >/>/Results always turn out empty, even though the search string is present 
> >/>/in the Memo or Action fields of some transactions.  I am using Gnucash 
> >/>/5.0 for Windows, but I have noticed this in some previous versions too. 
> >/>/Am I doing something incorrect or is this a bug. I don't see that 
> >/>/anybody has mentioned this behaviour in the mailing list or in the bug 
> >/>/list. Thank you. /
> 
> 
> The specific search instance I had is this. I have a Gnucash file with 
> accounts X, Y, and Z. X and Y have split Memo fields containing the 
> search string 'paid'. I display account register X and search for 'paid' 
> in the Memo field. Zero results. I then go to 'List of accounts' tree 
> tab and search the same, using 'New Search' every time. I get results 
> from both X and Y. So this works, but I don't want the result from Y.
> 
> So again I search from the accounts tree tab adding the 'and' condition 
> of Account and set it to X. Again 0 results. I display account register 
> Y and run the search on Memo field only. Again 0 results.
> 
> To make doubly sure I created a dummy gnucash file with accounts X, Y 
> and Z as above. Same results. So looks like a bug to me.
___
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] Find not working in Gnucash for Windows 5.0

[Patrick James]

Fair enough. My experience with the "Find..." is that it's buggy, and so you're 
right, I didn't spend a tremendous amount of effort sorting out the differences.

> On 04/06/2023 9:46 AM john  wrote:
> 
>  
> You're leaping to conclusions. The OP didn't say anything about it being a 
> second search.
> 
> Regards,
> John Ralls
> 
> 
> > On Apr 6, 2023, at 9:34 AM, Patrick James  
> > wrote:
> > 
> > This is a bug, and I reported it as Bug ID 798803.
> > 
> > https://bugs.gnucash.org/show_bug.cgi?id=798803
> > 
> > Selecting the "New Search" radio button should search as new, but alas, it 
> > does not.
> >
___
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] Find not working in Gnucash for Windows 5.0

[Patrick James]

This is a bug, and I reported it as Bug ID 798803.

https://bugs.gnucash.org/show_bug.cgi?id=798803

Selecting the "New Search" radio button should search as new, but alas, it does 
not.


> On 04/05/2023 11:07 PM Stan Brown  wrote:
> 
>  
> On 2023-04-05 07:18, Tute Terner wrote:
> > When I search in the Find dialog box using the Description field,
> > everything works. But when I search by the Memo field or the
> > 'Description, Notes or Memo' field or the Action field the Search
> > Results always turn out empty, even though the search string is present
> > in the Memo or Action fields of some transactions.  I am using Gnucash
> > 5.0 for Windows, but I have noticed this in some previous versions too.
> > Am I doing something incorrect or is this a bug. I don't see that
> > anybody has mentioned this behaviour in the mailing list or in the bug
> > list. Thank you.
> 
> Probably you already know this, but ...
> 
> Gnucash will only find transactions that are in the window that is on
> top when you initiate the Find.
> 
> Therefore, if you want to make sure of getting all matching transactions
> in all accounts rather than just one, you need to start your Find while
> the Accounts window (lost of accounts) is on top.
___
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] Site certificate expiry warning

[Patrick James]

About two months ago, there was a major ice storm in Austin, and the area was 
completely unprepared for such a storm. A friend of mine was without power for 
about 12 days. He has two small children, and he has good local resources, 
which were also impacted by the ice storm, and it was not easy on him.

From the other messages here, the web server is in Austin, and was impacted by 
the storm. The basic claim extends to the ISP in terms of recovery from the ice 
storm, which propagated to the GnuCash server.

No one here seems to have a philosophical problem with https, but when an ice 
storm bring the system down, well, that's a problem.

> On 03/30/2023 11:36 AM Tom Weichmann  wrote:
> 
>  
> I'm confused, is someone arguing against using HTTPS on gnucash.org?  Is
> there some cost that is trying to be avoided or something like that?  I use
> HTTPS on my little personal website because why have any data on the
> internet that isn't encrypted.  I can't think of a downside
> 
> On Thu, Mar 30, 2023 at 2:29 PM Dr. David Kirkby <
> drkir...@kirkbymicrowave.co.uk> wrote:
___
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] Site certificate expiry warning

[Patrick James]

I keep trying to figure out what to do with all my "likes" on various social 
media sites, and as of today, no one can really explain why I want/desire/need 
more "likes," or similar.


> On 03/30/2023 11:29 AM Dr. David Kirkby  
> wrote:
> 
> But that still means if you want to do well in Google, you maximise your
> chances if you use HTTPS. Even if you have a completely static website,
> with no possibility of a user entering even an email address or name.
> 
> 
> 
> Dave
___
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] Where to download 5.0

[Patrick James]

Here is where I downloaded my copy:

https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/5.0/


> On 03/29/2023 5:39 PM Gyle McCollam  wrote:
> 
>  
> Sorry, I'm sure this has been posted, but when I o to Gnucash.org website it 
> only shows 4.13 or 4.9.  I tried surgeforce, but the 5.0 download won't open 
> on windows.
> 
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   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.

Re: [GNC] 5.0-1 (Flathub) issue

[Patrick James]

Once the correct payee is highlighted, simply tab to the next field, and 5.0 
will fill it in as you desire. Also note that you may arrow up and down during 
the data entry to select your desired payee, and then click tab.

I have a few payees that are very similar, but are long, so the number of 
keystrokes has gone down by a significant amount for those situations. The 
other situations are the same number of keystrokes, or very close.


> On 03/29/2023 6:30 AM John J Egan  wrote:
>  
> Since this update, creating a entry in the register now pops-up a 
> 'similar entries' selection search result box, rather than just filling 
> in the payee as it used to. It's SO frustrating, and a lot more work now!
> 
> Please revert back this new "feature".
___
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] Exporting reports to spreadsheet

[Patrick James]

George,

This is a Windows 'feature,' as Windows has file extension associations.

If you do a quick online search, you should be able to find the instructions on 
how reassign the association of the ".ods" extension to LibreOffice Calc.

Alternatively, try right-clicking the icon and selecting "Open with" 

> On 03/29/2023 9:11 AM George Riner  wrote:
> 
>  
> The setting:
> 
> Windows 10
> Gnucash 4.13
> 
> When I Export a report I've been supplying a windows extension of 
> ".ods". Which I assumed would cause that exported report file to open in 
> some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc.
> 
> But it doesn't do that. I double-click the file to open it in the 
> default application and it opens in LibreOffice Writer.
___
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] Enhancement request: multi-currency accounts

[Patrick Pöndl]

Hi Jim,

actually, I completely understand the original proposal and I understand
why he wants to have that functionality, and why you have set up your
accounts the way you described. While planning my initial GnuCash setup,
this structure was the obvious one to me, too, when I first thought about
it. Then I did some testing on sample data like the one in my little
Argentina restaurant example (which for my purposes will in fact be a
significant problem).

So, while everyone naturally can and should choose the structure that
works for them, I just mentioned my example as a caveat to what COULD
happen when working with the mentioned structure, especially if GnuCash had
some kind of auto feature that facilitated such a structure. I realize the
problem will be relatively small as long as exchange rates of the relevant
currencies stay in a somewhat narrow corridor to each other. But with huge
and permanent changes like we have seen with ARS (since forever) and in
recent months even with most currencies against the USD, one at least needs
to be aware of this problem. Otherwise, you could spend all this work on
your GnuCash books and then realize a few years down the road that much of
the meaning of the numbers has been eliminated because one or more
currencies lost a lot of their value against the USD for example.

As far as I understand, one possible approach for people who don't want to
(or can't for regulatory purposes) convert to their main currency for every
single transaction could be this: Enter a transaction from the
expense/income account denominated in a non-base currency to the same
expense/income account denominated in your base currency every so often
(like once a year, or whenever exchange rates changed significantly) to
reset those accounts to zero. This way, at least the problem of ballooning
balances on the trading accounts would be solved and the degradation of
meaning of the numbers limited.

Maybe there should be a section in the manual / guide discussing the pros
and cons of using multi-currency accounts for expenses and income. I doubt
that a lot of people are aware of the associated problems.

Thoughts?

Patrick Poendl

Am Fr., 21. Okt. 2022 um 04:45 Uhr schrieb :

> -- Forwarded message --
> From: Jim DeLaHunt 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Thu, 20 Oct 2022 19:43:32 -0700
> Subject: Re: [GNC] Enhancement request: multi-currency accounts
> Hello, Patrick, welcome to GnuCash!
>
> On 2022-10-20 09:28, Patrick Pöndl wrote:
> > ...
> > - BUT: For income and expense accounts, multi-currency accounts seem to
> be
> > a total disaster. Why? Because all PAST transactions on both income and
> > expense accounts will be valued at the CURRENT exchange rates
>
> I think you are misunderstanding the original proposal.  Look below in
> the thread, to what Anton Tsyganenko wrote:
>
> On 2022-10-18 02:34, Anton Tsyganenko wrote:
> > ...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
>
> Thus, the "multi-currency" part is a placeholder. Transactions are not
> recorded in the placeholder, they are recorded in "sub-accounts for each
> currency". Once they are recorded in that currency, they are valued in
> that currency. Relationship to other currencies is established by means
> of trading accounts, which GnuCash already supports.
>
> As I read it, Anton is just proposing that GnuCash do automatically what
> I do manually. I have transactions denominated in CAD, USD, EUR, and
> various stocks and funds in my book today.
>
> What is the base-currency value of a book with transactions denominated
> in various currencies?  That is a separate question to the proposal for
> "multi-currency accounts". It is already an issue for books like mine.
> For some GnuCash users, accounting regulations will determine how they
> calculate base-currency value. For others, it can be whatever meets the
> information needs of the user.
>
> > ...Therefore, my current conclusion is that for all transaction that
> involve
> > income or expense accounts, the amount has to be converted into the base
> > currency using the exchange rate on the day the transaction occurred, or
> at
> > least closely
>
> OK, that is one way to deal with transactions in multiple currencies. It
> is not what I am required to do for tracking capital gains in US stocks
> when I report to Canadian authorities, or Canadian stocks when I report
> to US authorities.
>
> Or, are you saying that GnuCash should only allow me to record
> transactions in my base currency,

Re: [GNC] Valuation of multi-currency accounts

[Patrick Pöndl]

I guess it always depends on what you want to accomplish. If you are bound
by certain rules in your jurisdiction for tax purposes, you need to think
how to set up your accounts in GnuCash to obey those rules. If you are
bound by more than one jurisdiction with incompatible rules, maybe you even
need to keep track of the same transactions in two separate set of books in
order to stay sane.

I was just under the impression that the original poster who suggested that
GnuCash should automatically create multi-currency subaccounts for each
expense account was simply suggesting this in order to save time and
effort, but was not aware what that would do to the quality of the data the
more exchange rates change over time: ever larger balances on the trading
accounts (which tend to eliminate meaning from the numbers) and ever
smaller balances on the expense and income accounts in terms of the base
currency (which do give meaning to the numbers).

I guess one approach for people who don't want to (or can't for regulatory
purposes) convert to base currency for every single transaction would be
this: Enter a transaction from the expense/income account denominated in a
non-base currency to the same expense/income account denominated in your
base currency every so often (like once a year, or whenever exchange rates
changed significantly) to reset those accounts to zero. This way, at least
the problem of ballooning balances on the trading accounts would be solved
and the degradation of meaning of the numbers limited.

But as I said, I'm a newbie at GnuCash, and I don't have an accounting
background. I just realized that this problem exists while planning my own
initial setup of GnuCash, and I still hope that someone more experienced
shares a method that both minimizes work and the described problem.

Patrick Poendl

Am Fr., 21. Okt. 2022 um 04:45 Uhr schrieb :

>
> -- Forwarded message --
> From: Michael or Penny Novack 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Thu, 20 Oct 2022 17:59:20 -0400
> Subject: Re: [GNC] gnucash-user Digest, Vol 235, Issue 46
> On 10/20/2022 12:21 PM, Patrick Pöndl wrote:
>
> THAT is the major issue with trying to keep multiple currencies in the
> same set of books. WHEN is to be the time of evaluation (of one to the
> other in terms of exchange rates). This can even be an issue for
> accounts of type asset and liability for those who are rarely moving
> amounts between currencies << who have accounts in both places, who have
> income and expenses in both places --- say who live/work in one country
> part of the year and in another the rest of the year >>
>
> Since not applying to me, I have never investigated the rules of the
> various jurisdictions. You have income in country B but your primary tax
> country is A. What does A say about when "conversion" takes place (when
> evaluated for income in B, taxes paid in B for which A might give
> credit, etc.) OR if A allows you to choose the date (say the end of the
> reporting year) how do you do that unless separate books? << since you
> would NOT want evaluations to have been taking place as you went along >>
>
> Michael D Novack
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Valuation of multi-currency accounts

[Patrick Pöndl]

Hi Stan,

I realized my newbie mistake directly after sending, and then sent the same
message again with the original poster's subject line. Now people are
responding to both ;-)

Patrick Poendl


Am Fr., 21. Okt. 2022 um 04:45 Uhr schrieb :

>
> -- Forwarded message --
> From: Stan Brown 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Thu, 20 Oct 2022 16:32:07 -0700
> Subject: [GNC] Valuation of multi-currency accounts
> Just a reminder to all ... PLEASE don't use non-descriptive subject
> lines of the form GnuCash-user Digest Vol XXX Issue XX. If a newbie does
> it, please change the subject line to something more helpful when
> replying.  Thanks!
>
> 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.

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

[Patrick Pöndl]

I am a new GnuCash user and currently busy setting everything up. I have
done a lot of thinking and testing on the multi-currency issue in order to
hopefully get it right from the start.

So far my conclusion is this - and please, more experienced users, correct
me if there is a flaw in my thinking:

- For asset and liability accounts, multi-currency accounts make obviously
a lot of sense if you hold assets and liabilities denominated in multiple
currencies. Changes in value in respect to your base currency are perfectly
taken care of by using the automatic trading accounts.

- BUT: For income and expense accounts, multi-currency accounts seem to be
a total disaster. Why? Because all PAST transactions on both income and
expense accounts will be valued at the CURRENT exchange rates. Consider
an extreme example which illustrates the problem drastically: Imagine you
dined at a restaurant in Argentina in January 2018. You paid 250 ARS in
cash, which equaled about 11 EUR at the time. If you had recorded this on
an expense account denominated in ARS and you looked at your GnuCash book
today, it would show you that you spent only 0.88 EUR for that meal in
2018. The peso lost almost all of its value since then. Your data in
GnuCash will be almost worthless. GnuCash does record the difference
between 11 and 0.88 EUR in your trading accounts as a loss of value of
"your" ARS 250 (that you don't have any more because you spent them in
2018), but for all transactions that have been recorded in the ARS expense
account, it will only show just the total loss you have had over the years
in ARS vs EUR. If there were many transactions, you would have no idea what
you really paid in your base currency at the time of each transaction.
Trading accounts are meant to track changes in value of assets and
liabilities you are currently holding, but most definitely not for expenses
and income from the past, which has already happened and cannot be changed
anymore.

Therefore, my current conclusion is that for all transaction that involve
income or expense accounts, the amount has to be converted into the base
currency using the exchange rate on the day the transaction occurred, or at
least closely. Exchange rates normally do not move a lot from day to day,
but over many months or even years there can be huge moves - and those will
ruin the data in your GnuCash book if you don't consider this effect.

If somebody has another solution, please let me know, as the extra effort
to make the conversion for each transaction is obviously anything but fun.

Best regards,
Patrick Poendl

Am Mi., 19. Okt. 2022 um 02:47 Uhr schrieb :

>
> -- Forwarded message --
> From: Anton Tsyganenko 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Tue, 18 Oct 2022 13:34:13 +0400
> Subject: [GNC] Enhancement request: multi-currency accounts
> 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-

Re: [GNC] gnucash-user Digest, Vol 235, Issue 46

[Patrick Pöndl]

I am a new GnuCash user and currently busy setting everything up. I have
done a lot of thinking and testing on the multi-currency issue in order to
hopefully get it right from the start.

So far my conclusion is this - and please, more experienced users, correct
me if there is a flaw in my thinking:

- For asset and liability accounts, multi-currency accounts make obviously
a lot of sense if you hold assets and liabilities denominated in multiple
currencies. Changes in value in respect to your base currency are perfectly
taken care of by using the automatic trading accounts.

- BUT: For income and expense accounts, multi-currency accounts seem to be
a total disaster. Why? Because all PAST transactions on both income and
expense accounts will be valued at the CURRENT exchange rates. Consider
an extreme example which illustrates the problem drastically: Imagine you
dined at a restaurant in Argentina in January 2018. You paid 250 ARS in
cash, which equaled about 11 EUR at the time. If you had recorded this on
an expense account denominated in ARS and you looked at your GnuCash book
today, it would show you that you spent only 0.88 EUR for that meal in
2018. The peso lost almost all of its value since then. Your data in
GnuCash will be almost worthless. GnuCash does record the difference
between 11 and 0.88 EUR in your trading accounts as a loss of value of
"your" ARS 250 (that you don't have any more because you spent them in
2018), but for all transactions that have been recorded in the ARS expense
account, it will only show just the total loss you have had over the years
in ARS vs EUR. If there were many transactions, you would have no idea what
you really paid in your base currency at the time of each transaction.
Trading accounts are meant to track changes in value of assets and
liabilities you are currently holding, but most definitely not for expenses
and income from the past, which has already happened and cannot be changed
anymore.

Therefore, my current conclusion is that for all transaction that involve
income or expense accounts, the amount has to be converted into the base
currency using the exchange rate on the day the transaction occurred, or at
least closely. Exchange rates normally do not move a lot from day to day,
but over many months or even years there can be huge moves - and those will
ruin the data in your GnuCash book if you don't consider this effect.

If somebody has another solution, please let me know, as the extra effort
to make the conversion for each transaction is obviously anything but fun.

Best regards,
Patrick Poendl


Am Mi., 19. Okt. 2022 um 02:47 Uhr schrieb :

>
> -- Forwarded message --
> From: Anton Tsyganenko 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Tue, 18 Oct 2022 13:34:13 +0400
> Subject: [GNC] Enhancement request: multi-currency accounts
> 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-

[GNC] Another Beginner Accounting Question

[Patrick Skelton]

Hi,

Just when I was thinking I had accumulated all the pieces of the jigsaw I
need, I discovered the A/R account.

I have a shop that charges 50% margin on whatever they sell. So, if they
sell one candle for £12 then I will invoice them only for £6. They get 30
days credit, so ideally I'd use the A/R system. I've played around with
this and it seems to do what I expect to the Balance Sheet and Profit &
Loss Report except for one thing: I seem to lose any record of the 50% of
the total sales value that they have taken.

There is a Discount column in the invoice but this doesn't seem to show up
anywhere in the accounts. I'd like to have some record of the money I am
'losing' in sales commission, maybe as an expense.

Can anyone offer any advice on how this might best be approached, please?

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

[GNC] Beginner Accounting Question

[Patrick Skelton]

Hi,

I'm steadily 'getting' the double-entry idea. In my accounts (which I have
just begun experimenting with), I have an account that is called 'Personal
Money Used'. This is of type Cash. I use this account when I use my own
personal account (i.e. nothing to do with the business) to buy something
for the business.

I have two questions about this account:

1. What is the correct parent account for this? It feels to me like it is a
Liability - money the business owes me but I suspect liabilities are debts
to external entities (i.e. not me, the business owner).
2. Would I be better accounting for such purchases simply as money I put
into the business (i.e. as an increase in Owner's Equity)?

I'm trying hard to get into this but can't afford to pay for professional
lessons so any help at all would be very welcome.

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

Re: [GNC] Beginner Accounting Question Using GnuCash

[Patrick Skelton]

Thank you everyone for those replies. They have been extraordinarily
helpful. It is amazing how, when asking a question about something
specific, a single sentence or even just a phrase in the reply can cause a
lightbulb moment. I now have a much clearer understanding of how the basic
mechanics of this work.

I think next task is to play with some reports, to see if I can answer the
questions I might like to ask at the end of the year.

- Patrick

On Fri, 17 Dec 2021 at 17:41, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 12/17/2021 6:48 AM, Patrick Skelton wrote:
> > Hi, David,
> >
> > Thank you for that. I have actually just kind-of worked that bit out but
> I
> > would like the £8 spent on paper to become an asset. Is it simply then a
> > case of entering a transfer from Expenses-Stock Purchases to Assets -
> Stock
> > on Hand?
> >
> > Kind wishes - Patrick
>
> You were doing it correctly, Patrick. Your example appears to be a
> "stationery" business, so you correctly had the purchase of paper go
> into an asset "inventory" rather than being an expense. You also did the
> sales transaction correctly, recording not just the part with the
> customer but the part where you are now decreasing inventory and
> recording an expense for the cost of that pad sold.
>
> Michael D Novack
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Beginner Accounting Question Using GnuCash

[Patrick Skelton]

Hi, David,

Thank you for that. I have actually just kind-of worked that bit out but I
would like the £8 spent on paper to become an asset. Is it simply then a
case of entering a transfer from Expenses-Stock Purchases to Assets - Stock
on Hand?

Kind wishes - Patrick











On Fri, 17 Dec 2021 at 11:40, David H  wrote:

> Patrick,
>
> Look carefully at point 2, one side of your transaction should be an
> expense as you are expending funds to buy stock eg Expense >> Stock
> Purchases rather than Stock on Hand ?
>
> Cheers David H
>
>
>
> On Fri, 17 Dec 2021 at 21:20, Patrick Skelton 
> wrote:
>
>> Hi,
>>
>> I am trying to get my head around double-entry accounting. I think I have
>> kind-of got it. I have just set up a stripped down set of accounts and
>> tried a handful of transactions, to see how they affect profit-and-loss
>> and
>> the balance sheet. It all seems to make sense except that there is one
>> piece of information that seems to vanish, and I am worried this means I
>> am
>> doing something wrong.
>>
>> My transactions beginning with all zero balances are:
>>
>> (N*ote:* I have added some dates to give context to my later question)
>>
>>1. 1st Nov: I pay £100 into the business *Bank* financed by *Owner's
>>Equity*.
>>2. 2nd Nov: I buy some paper costing £12, which comes from *Bank* and
>>goes into *Stock on Hand*.
>>3. 3rd Dec: I sell a notepad for £12, which credits *Bank* and is
>>assigned to *Income - Sales*.
>>4. 4th Dec: I transfer the cost of the paper used to make the notepad
>>(£1.00) from *Stock on Hand* to *Expenses - Cost of Materials*.
>>
>> The Balance Sheet shows £111. Liabilities are zero. Retained Earnings are
>> £11, which gives total equity of £111. Thus the sheet is balanced.
>>
>> My question is that no matter what report I run using whatever dates, I
>> cannot see the £12 I spent on stock. All I ever see is the £1 that I
>> decided was the cost of the paper taken from stock.
>>
>> Even if I do reports only for the month of November, I don't see the £12 I
>> paid for stock because the money came from my bank and went into stock,
>> which are both Asset accounts.
>>
>> Is there a better way to do these transactions so that I could ask the
>> question: how much have I spent on stock this month?
>>
>> I am a complete newbie so would welcome any help or advice (short of 'get
>> an accountant', which I would love to but can't afford).
>>
>> Kind wishes - Patrick
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Beginner Accounting Question Using GnuCash

[Patrick Skelton]

Hi,

I am trying to get my head around double-entry accounting. I think I have
kind-of got it. I have just set up a stripped down set of accounts and
tried a handful of transactions, to see how they affect profit-and-loss and
the balance sheet. It all seems to make sense except that there is one
piece of information that seems to vanish, and I am worried this means I am
doing something wrong.

My transactions beginning with all zero balances are:

(N*ote:* I have added some dates to give context to my later question)

   1. 1st Nov: I pay £100 into the business *Bank* financed by *Owner's
   Equity*.
   2. 2nd Nov: I buy some paper costing £12, which comes from *Bank* and
   goes into *Stock on Hand*.
   3. 3rd Dec: I sell a notepad for £12, which credits *Bank* and is
   assigned to *Income - Sales*.
   4. 4th Dec: I transfer the cost of the paper used to make the notepad
   (£1.00) from *Stock on Hand* to *Expenses - Cost of Materials*.

The Balance Sheet shows £111. Liabilities are zero. Retained Earnings are
£11, which gives total equity of £111. Thus the sheet is balanced.

My question is that no matter what report I run using whatever dates, I
cannot see the £12 I spent on stock. All I ever see is the £1 that I
decided was the cost of the paper taken from stock.

Even if I do reports only for the month of November, I don't see the £12 I
paid for stock because the money came from my bank and went into stock,
which are both Asset accounts.

Is there a better way to do these transactions so that I could ask the
question: how much have I spent on stock this month?

I am a complete newbie so would welcome any help or advice (short of 'get
an accountant', which I would love to but can't afford).

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

[GNC] Find by Value No Longer Seems to Work

[Patrick Skelton]

Hi,

I've been using GnuCash for years and generally found it to be excellent.

In the past, I have never had any problem with using the Find feature. Now,
however, when I try a find-by-value, nothing is ever shown in the results.

I enter *Value -> has credits of debits -> equal to -> AMOUNT* and enter an
amount that I can see quite clearly in different accounts and nothing is
ever shown in the results box.

Can anyone suggest what I may be doing wrong?

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

Re: [GNC] Which file contains the account name map for the CSV import tool?

[Patrick]

Thank you, sir. I appreciate the help.

Regards,
Patrick

On Sun, Apr 12, 2020 at 11:45 AM John Ralls  wrote:

>
>
> > On Apr 12, 2020, at 9:31 AM, Patrick  wrote:
> >
> > I'd like to work on a gnucash file on a new machine. I'd like to transfer
> > the account name map that is used by the CSV import tool (see the bullet
> > "Match Import and GnuCash accounts") from the old machine to the new
> > machine. Is this mapping stored in a file that I can transfer to the new
> > machine?
> >
> > I have looked in the "Configuration Locations" section of the wiki, but
> it
> > wasn't clear to me if this contained the answer I was looking for.
>
> Those mappings are stored in your book (i.e. .gnucash) file.
>
> https://wiki.gnucash.org/wiki/Backup lists all of the files that you'll
> need to copy to the new machine.
>
> Regards,
> John Ralls
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Which file contains the account name map for the CSV import tool?

[Patrick]

I'd like to work on a gnucash file on a new machine. I'd like to transfer
the account name map that is used by the CSV import tool (see the bullet
"Match Import and GnuCash accounts") from the old machine to the new
machine. Is this mapping stored in a file that I can transfer to the new
machine?

I have looked in the "Configuration Locations" section of the wiki, but it
wasn't clear to me if this contained the answer I was looking for.

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

[GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

[Patrick Farrell]

Is there a "Canadian Version" of GnuCash as all the documentation in the 
current version of GnuCash 3.4+ (Build 2018-12-30) that I have read 
relates to the USA Tax System?


I immediately need to know how to set up automatically calculating how 
to add Canadian Harmonized Sales Tax ("HST") @ 13% to any Invoices I 
make up and send out to Clients/Customers, and then how to separately 
account for HST that I pay on any invoices that I receive from our 
vendors and subsequently pay. I then need to offset the HST received 
from Client/Customers versus the HST I have paid out to Vendors and do 
an official Government HST filing at least Quarterly, and pay them the 
difference if any!


Is there an "Update" software function in the program somewhere, as I 
have not been able to see any obvious place to do this? I see there is 
GnuCash 3.9 version offered on the website, but will I lose all existing 
data in my existing GnuCash 3.4+ if I download 3.9 on top of it or have 
to delete 3.4+ before I install version 3.9?


Any suggestions would be helpful.

P@ddy

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

[GNC] Job and Invoice

[Patrick Walker]

Just installed GNUCash in hopes of managing finances for my Home Owners 
Association. We have 218 homes which I set up as customers. we now wish to 
issue invoices for a reserve fund we are creating. Total due is $48 per home, 
payable at either six, twelve, or a one time intervals, of which each home has 
pre-elected their pay terms upon submitting their commitment letter. My thought 
is to create a "Job" for the $48 billing, then create terms of semiannual,  
annual or one time payment. 
First, am I on the right path? Second , do I print each invoice or can I bulk 
print all semiannual,  then all annual, then all one time payment invoices?
Thank you in advance!
Patrick


Sent from Mail for Windows 10

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

[GNC] Proposed change of "U+R" and "R" in the Import main matcher.

[Patrick]

> The csv import can import reconciliation info so in principle you could
import
reconciled transactions.

Sorry for the somewhat tangential comment, but since it is I think somewhat
relevant, and I thought it might be of interest to someone - when importing
transactions from a csv, GnuCash didn't seem to allow the first split in a
multi-split transaction to import as anything other than the "c" (cleared)
state, regardless of what the csv contents were. I ended up modifying the
source code to allow this, but maybe it is possible another way, and I just
couldn't find it. The bug linked below suggested to me that there might not
be a way.

References
https://bugs.gnucash.org/show_bug.cgi?id=796890
https://lists.gnucash.org/pipermail/gnucash-user/2019-July/085876.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Column Detection when Importing Transactions from CSV

[Patrick]

Sorry, I just saw this response. (I had unsubsribed to try to reduce
flow into inbox, and I just saw it when I was going back through the
archives. I will turn digest back on.)

Thank you for this additional helpful information.

73,
Patrick
ag4jq

On 6/26/19 12:31 PM, Patrick wrote:
>* When importing transactions from a CSV file, is there a way to have GnuCash
*>* automatically detect the meaning of the columns based on the CSV headers?
*>* The headers in my CSV file are "Date", "Description", "Account", etc., so I
*>* was wondering if GnuCash had the ability to determine what the columns were
*>* from these headers, so that I don't have to select them from the dropdown
*>* menus every time I do an import.
*>>* Regards,
*>* Patrick
*

The screen where you pick these has a field at the very top where you
can name this setup and then save it.

You will have to select this name on the next import but it will remember:

* The field assignments

* The account into which you are doing the import

* The date format

* How many lines to skip

It was a big help when I discovered that!

--Steve


-- 
Stephen M Butler, PMP, PSMStephen.M.Butler51 at gmail.com
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>kg7je at
arrl.net <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconcile Flag when Importing Transactions from CSV

[Patrick]

In case someone else comes across this and is looking for a temporary
workaround, this is what I did.

In my local copy, I changed this line

https://github.com/Gnucash/gnucash/blob/maint/gnucash/import-export/import-backend.c#L924

to use "NREC" instead of "CREC".

File: gnucash/import-export/import-backend.c
Function: gnc_import_process_trans_item()
case GNCImport_ADD

Old line
xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), CREC);

New line
xaccSplitSetReconcile(gnc_import_TransInfo_get_fsplit (trans_info), NREC);

On Tue, Jul 2, 2019 at 6:58 AM Patrick  wrote:

> I was looking through the bug reports on Bugzilla, and I think there might
> already be an outstanding request (#796890) to adjust this behavior.
>
> I think that means my best options are to be patient or to stare
> at gnc-imp-props-tx.cpp for a while.
>
> https://bugs.gnucash.org/show_bug.cgi?id=796890
>
> On Mon, Jul 1, 2019 at 7:33 AM Patrick  wrote:
>
>> When I am importing transactions from a CSV, I have a "Reconcile" column
>> that I select as the "Transfer Reconciled" column in the import wizard. I
>> have all of the entries marked as "n" in this column, but after importing
>> them, some of them seem to still show up as "c". Am I misunderstanding the
>> "Transfer Reconciled" option, or am I likely doing something else wrong?
>>
>> I'm not sure if it is relevant, but I am importing in multi-split mode.
>>
>> Regards,
>> Patrick
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Reconcile Flag when Importing Transactions from CSV

[Patrick]

When I am importing transactions from a CSV, I have a "Reconcile" column
that I select as the "Transfer Reconciled" column in the import wizard. I
have all of the entries marked as "n" in this column, but after importing
them, some of them seem to still show up as "c". Am I misunderstanding the
"Transfer Reconciled" option, or am I likely doing something else wrong?

I'm not sure if it is relevant, but I am importing in multi-split mode.

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

Re: [GNC] Column Detection when Importing Transactions from CSV

[Patrick]

Thank you for the response and for the helpful guidance.

I am using version 3.5, and I see now that there is an option to "Save
Settings" in the CSV importer.

Regards,
Patrick

On Wed, Jun 26, 2019 at 2:54 PM Geert Janssens 
wrote:

> Op woensdag 26 juni 2019 21:31:54 CEST schreef Patrick:
> > When importing transactions from a CSV file, is there a way to have
> GnuCash
> > automatically detect the meaning of the columns based on the CSV headers?
> > The headers in my CSV file are "Date", "Description", "Account", etc.,
> so I
> > was wondering if GnuCash had the ability to determine what the columns
> were
> > from these headers, so that I don't have to select them from the dropdown
> > menus every time I do an import.
> >
> > Regards,
> > Patrick
>
> GnuCash can't guess, but as of version 3.0 you can set the columns once
> and
> save this preset for a future import. So if the columns in your csv files
> are
> not changing this should reduce the amount of work on import.
>
> Regards,
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Example of multi-split feature of CSV importer?

[Patrick]

David, Geert,

Thank you for this helpful guidance. I hope to try this soon.

Regards,
Patrick

On Mon, Mar 25, 2019 at 5:18 AM Geert Janssens 
wrote:

> Op zondag 24 maart 2019 02:47:37 CET schreef David Cousens:
>
> > Patrick,
>
> >
>
> > When the Transaction is opened with the split button, the Description
> field
>
> > name should change to Memo. There are other changes in the headings as
>
> > described in the documentation (
>
> > https://www.gnucash.org/docs/v3/C/gnucash-help/trans-multi-enter.html).
> If
>
> > my understanding is correct, each split of a transaction has its own Memo
>
> > field while the Description field is attached to the transaction which
>
> > consists of 2 or more splits. The same description should also come up if
>
> > you open the transaction in another register that there is a split to.
> You
>
> > can enter different information in the Memo field if you wish.
>
> >
>
> > I think the importer matches on the Description field for the
> transaction by
>
> > tokenizing its content and matching to the tokenized forms of the
>
> > description field of existing transactions which is weighted along with
> the
>
> > matching of amounts, dates, etc. I don't think the Memo field is involved
>
> > in matching AFAIK but I haven't checked the code out to see. Geert may be
>
> > able to comment on that as he is more familiar with the code than I am.
>
> >
>
> > I think you can specify the Memo field in the multisplit format as well
> as
>
> > the Description field. I am away from home at the moment so I can't check
>
> > for sure.
>
> >
>
> > David
>
>
>
> That explains it very well indeed.
>
>
>
> In short: transactions have a description, splits have a memo. If you want
> each individual split to have some descriptive information, you can add
> this in the memo field (which is also supported by the importer). If you
> want the whole transaction to have some descriptive information, you can
> add this in the transaction's description field.
>
>
>
> And as David says, the csv importer will use the description field (and
> all other transaction related fields) to determine transaction boundaries.
> As the memo fields is a related to splits its contents will not affect this
> boundary detection.
>
>
>
> Geert
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Example of multi-split feature of CSV importer?

[Patrick]

Thank you again for this helpful information.

I did have one other question about this. When I enter a split transaction
directly into GnuCash (by using the "Split" button), it allows me to give
each split of that transaction its own description. Since - if I understood
your explanation properly - the CSV importer uses the "Description" field
to group consecutive transactions in the same split, does this mean that
when I am importing transactions using "multi-split," that I can't give
each split of the same transaction its own description, as I can when I am
entering them manually?

Regards,
Patrick

On Mon, Mar 18, 2019 at 11:36 AM Patrick  wrote:

> That makes sense. Thank you for the very helpful response and the example.
>
> Regards,
> Patrick
>
> On Mon, Mar 18, 2019 at 5:45 AM Geert Janssens 
> wrote:
>
>> Op zondag 17 maart 2019 00:55:38 CET schreef Patrick:
>>
>> > I would like to import split transacations from a CSV file. Based on the
>>
>> > help balloon for it, the "multi-split" option seems to be the way to do
>>
>> > this, but I am not sure how to use this option. Is there an example
>>
>> > somewhere of how to use this option?
>>
>> >
>>
>> > To be specific, what I don't understand is that when the multi-split
>> option
>>
>> > is disabled, I can set one column in the CSV to be the "Account", and
>>
>> > another column to be the "Transfer Account". Setting these two columns
>>
>> > allows me to specify the "credit" and "debit" accounts involved in the
>>
>> > transaction. However, when I enable the multi-split option, the option
>> to
>>
>> > set a "Transfer Account" goes away. So, I am not sure how to specify the
>>
>> > second of the two accounts involved with the transaction when
>> multi-split
>>
>> > is enabled.
>>
>>
>>
>> First off, strictly speaking each transaction is "multi-split" as even
>> the simplest transaction (a transfer from one account to another) has two
>> splits: one in the source account and one in the target account. The split
>> itself doesn't know about the transfer. It only knows which account it
>> belongs to.
>>
>>
>>
>> As a real example is always more helpful, let's assume a transaction that
>> transfers $100 from Account A to Account B. This would be represented with
>> two splits:
>>
>>
>>
>> Transaction date 2019-03-18
>>
>> Transaction description "Transfer"
>>
>> Split 1: Account A $100 (Withdrawal)
>>
>> Split 2: Account B $100 (Deposit)
>>
>>
>>
>> Converting this in a multi-split csv file that can be imported would
>> yield something like this:
>>
>> Date,Description,Account,Deposit,Withdrawal
>>
>> 2019-03-18,Transfer,Account A,,100
>>
>> 2019-03-18,Transfer,Account B,100,
>>
>>
>>
>> As you can see there is no need for a "Transfer Account" column in this
>> case. Each split is associated with one account, you only have to define
>> that account. GnuCash will use the transaction related fields (in this case
>> only "Date" and "Description") to detect transaction boundaries. As both
>> fields are identical on each line, GnuCash will assume both splits to be
>> part of the same transaction.
>>
>>
>>
>> The single-line import format is a shorthand that can only be used in
>> case of transactions with at most two splits. For that situation each line
>> represents such a full transaction and hence may hold information to define
>> two splits. For that reason it also provides two Account assignments
>> options (Account and Transfer Account) as each split in that transaction
>> can have one. So the above translated into a single line csv file would
>> look like this:
>>
>>
>>
>> Date,Description,Account,Transfer Account,Deposit
>>
>> 2019-03-18,Transfer,Account B,Account A,100
>>
>>
>>
>> You could say the single line import format is a special case to simplify
>> most imports from bank accounts while the multi-split format is more
>> generic and the only format that will ever be able to import multi-split
>> (that is more than two splits) transactions (1).
>>
>>
>>
>> Regards,
>>
>>
>>
>> Geert
>>
>>
>>
>> (1) Note there are currently issues with the csv importer for
>> multi-currency imports or stock imports. These will eventually be resolved
>> allowing the multi-split format to import every kind of transaction gnucash
>> supports internally.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Example of multi-split feature of CSV importer?

[Patrick]

That makes sense. Thank you for the very helpful response and the example.

Regards,
Patrick

On Mon, Mar 18, 2019 at 5:45 AM Geert Janssens 
wrote:

> Op zondag 17 maart 2019 00:55:38 CET schreef Patrick:
>
> > I would like to import split transacations from a CSV file. Based on the
>
> > help balloon for it, the "multi-split" option seems to be the way to do
>
> > this, but I am not sure how to use this option. Is there an example
>
> > somewhere of how to use this option?
>
> >
>
> > To be specific, what I don't understand is that when the multi-split
> option
>
> > is disabled, I can set one column in the CSV to be the "Account", and
>
> > another column to be the "Transfer Account". Setting these two columns
>
> > allows me to specify the "credit" and "debit" accounts involved in the
>
> > transaction. However, when I enable the multi-split option, the option to
>
> > set a "Transfer Account" goes away. So, I am not sure how to specify the
>
> > second of the two accounts involved with the transaction when multi-split
>
> > is enabled.
>
>
>
> First off, strictly speaking each transaction is "multi-split" as even the
> simplest transaction (a transfer from one account to another) has two
> splits: one in the source account and one in the target account. The split
> itself doesn't know about the transfer. It only knows which account it
> belongs to.
>
>
>
> As a real example is always more helpful, let's assume a transaction that
> transfers $100 from Account A to Account B. This would be represented with
> two splits:
>
>
>
> Transaction date 2019-03-18
>
> Transaction description "Transfer"
>
> Split 1: Account A $100 (Withdrawal)
>
> Split 2: Account B $100 (Deposit)
>
>
>
> Converting this in a multi-split csv file that can be imported would yield
> something like this:
>
> Date,Description,Account,Deposit,Withdrawal
>
> 2019-03-18,Transfer,Account A,,100
>
> 2019-03-18,Transfer,Account B,100,
>
>
>
> As you can see there is no need for a "Transfer Account" column in this
> case. Each split is associated with one account, you only have to define
> that account. GnuCash will use the transaction related fields (in this case
> only "Date" and "Description") to detect transaction boundaries. As both
> fields are identical on each line, GnuCash will assume both splits to be
> part of the same transaction.
>
>
>
> The single-line import format is a shorthand that can only be used in case
> of transactions with at most two splits. For that situation each line
> represents such a full transaction and hence may hold information to define
> two splits. For that reason it also provides two Account assignments
> options (Account and Transfer Account) as each split in that transaction
> can have one. So the above translated into a single line csv file would
> look like this:
>
>
>
> Date,Description,Account,Transfer Account,Deposit
>
> 2019-03-18,Transfer,Account B,Account A,100
>
>
>
> You could say the single line import format is a special case to simplify
> most imports from bank accounts while the multi-split format is more
> generic and the only format that will ever be able to import multi-split
> (that is more than two splits) transactions (1).
>
>
>
> Regards,
>
>
>
> Geert
>
>
>
> (1) Note there are currently issues with the csv importer for
> multi-currency imports or stock imports. These will eventually be resolved
> allowing the multi-split format to import every kind of transaction gnucash
> supports internally.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Example of multi-split feature of CSV importer?

[Patrick]

I would like to import split transacations from a CSV file. Based on the
help balloon for it, the "multi-split" option seems to be the way to do
this, but I am not sure how to use this option. Is there an example
somewhere of how to use this option?

To be specific, what I don't understand is that when the multi-split option
is disabled, I can set one column in the CSV to be the "Account", and
another column to be the "Transfer Account". Setting these two columns
allows me to specify the "credit" and "debit" accounts involved in the
transaction. However, when I enable the multi-split option, the option to
set a "Transfer Account" goes away. So, I am not sure how to specify the
second of the two accounts involved with the transaction when multi-split
is enabled.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quote on Debian

[Patrick Kelly]

Using Yahoo Jason not alphavantage

Get Outlook for iOS

  



On Mon, Mar 11, 2019 at 8:50 AM -0500, "Derek Atkins"  wrote:










"Patrick Kelly"  writes:

> How do get finance Quote to work on a Debian 9 system.   Everything appears
> to be installed, when I click get quotes, the cursor changes to a circle and
> never finishes.  As if it went off into space and never returns.  I have to
> force quit GnuCash to get out of it.

How many quotes are you trying to download?
Alphavantage only lets you get 5 quotes per minute.

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

[GNC] Finance Quote on Debian

[Patrick Kelly]

How do get finance Quote to work on a Debian 9 system.   Everything appears
to be installed, when I click get quotes, the cursor changes to a circle and
never finishes.  As if it went off into space and never returns.  I have to
force quit GnuCash to get out of it.

 

 

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

Re: [GNC] Copy a month's budget

[Patrick]

> For monitoring purposes, I use the Budget Report to do exactly that. You
> can set it up to see a period before and after your current account period
> (mine being set at a quarter), which will show your carryover.

I was hoping to get clarification on what exactly you meant by "carryover".

As an example, say I have a budget for each quarter and the budget has
a monthly budget period. Then I budget for two expense accounts - one
for food of $100 and one for rent of $200.  Say that in Jan, the
actual food spending was $30 under (i.e. I spent $70), and the actual
rent spending was $25 under (i.e. I spent $175). Then, for Feb, I
spent exactly $100 on food and exactly $200 on rent, and I did the
same in March. When I create my new budget for the next quarter, is
there a way to show in the new budget that I have $55 in excess left
over from my under-spending in Jan?

Thanks,
Patrick


On Fri, Jan 11, 2019 at 5:24 PM Patrick  wrote:

> Ok, thanks. Yes, I'd always appreciated that about top-posting - not
> having to scroll to the bottom. I'd just recalled in the past having used
> mailing lists that didn't allow it.
>
> Thanks,
> Patrick
>
> >Personal preference.
> >
> >For example, depending on the nature of the conversation, (like for
> multiple points/questions to discuss) I’ll use in-line, but I usually use
> top posting, as in this case.
> >
> >While I see it occasionally, bottom-posting is the least used in these
> parts as it means you have to scroll to read the reply.
> >
> >Regards,
> >Adrien
> >
> >> On Jan 11, 2019, at 11:08 AM, Patrick  wrote:
> >>
> >> Andre,
> >>
> >> Thanks for the advice. This definitely gives me some possible
> alternatives
> >> to consider.
> >>
> >> I am not able to find a page that gives the etiquette rules for this
> >> mailing list. Is top-posting preferred on this list? I noticed that some
> >> people do and some don't.
> >>
> >> Thanks,
> >> Patrick
> >>
> >> On Fri, Jan 11, 2019 at 6:24 AM Andre Powell 
> wrote:
> >>
> >>> Patrick,
> >>> The method that I use for budgeting is well "old-fashioned". My salary
> is
> >>> paid every fifteen days and my wife once a month, hence the two-week
> setup,
> >>> and the quarterly view because in my prior career we managed our P
> >>> monthly but with quarterly plans so mentally I am kind of used to that
> way
> >>> of thinking (or maybe I don't  want to scroll so much).
> >>>
> >>> When income comes in is when I actually use the budget to plan where
> the
> >>> money is going to go (a mixture of Dave Ramsey and YNAB). I use the
> >>> Bills/Invoice feature to keep track of the bills that need to be paid,
> but
> >>> they don't get paid until they are planned for.
> >>>
> >>> For monitoring purposes, I use the Budget Report to do exactly that.
> You
> >>> can set it up to see a period before and after your current account
> period
> >>> (mine being set at a quarter), which will show your carryover. I am
> always
> >>> striving for a balanced budget (move/spend less money to make sure
> that the
> >>> budget is balanced. But in theory, you could create a second report
> with a
> >>> longer view (perhaps yearly) to see your overall progress with the
> period
> >>> before.
> >>>
> >>> I hope this helps.
> >>>
> >>> On Thu, Jan 10, 2019 at 10:30 AM Patrick 
> wrote:
> >>>
> >>>> Andre,
> >>>>
> >>>> Thank you for the response. For each two-week period within the
> quarter,
> >>>> did you just have to copy the budget entries from each column to the
> next?
> >>>> That is what I would like to avoid, if possible.
> >>>>
> >>>> I would like to use one budget so that it is easy to see carryover
> from
> >>>> one budget period to the next. If I create a new budget for each
> quarter, I
> >>>> don't know of a way to get cumulative surplus/deficit for each budget
> >>>> category from the previous quarter.
> >>>>
> >>>> Thanks,
> >>>> Patrick
> >>>>
> >>>> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell  >
> >>>> wrote:
> >>>>
> >>>>> Patrick,
> >>>>> I made a template and under the Budget menu just make a
> duplicate/copy
> >>&g

Re: [GNC] Transfer Saved Report Configuration to Another Computer

[Patrick]

Thank you, John and Geert, for this helpful information.

Regards,
Patrick

On Sun, Jan 20, 2019 at 4:55 AM Geert Janssens 
wrote:

> Op zaterdag 19 januari 2019 23:50:10 CET schreef John Ralls:
> > > On Jan 19, 2019, at 11:02 AM, Patrick  wrote:
> > >
> > > Hello,
> > >
> > > I noticed that if I save my GnuCash folder containing my .gnucash files
> > > and
> > > move it to another machine, my saved report configurations don't get
> > > transferred. Where are the report configurations saved, so that I can
> > > transfer them also?
> >
> > https://wiki.gnucash.org/wiki/Configuration_Locations
> >
> > Regards,
> > John Ralls
> >
>
> And this page may be helpful as well:
> https://wiki.gnucash.org/wiki/Backup
>
> Regards,
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transfer Saved Report Configuration to Another Computer

[Patrick]

Hello,

I noticed that if I save my GnuCash folder containing my .gnucash files and
move it to another machine, my saved report configurations don't get
transferred. Where are the report configurations saved, so that I can
transfer them also?

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

Re: [GNC] Copy a month's budget

[Patrick]

Hello,

Thank you for the response. You are correct that that was the original
question. As far as I know, no one has yet offered a solution. Someone did
offer an alternative approach, but it would still be helpful for me if
there is a way to copy the entire column without doing it one entry at a
time, as you described.

Regards,
Patrick

On Mon, Jan 14, 2019 at 6:52 PM Jim Passmore  wrote:

> I don't think the original question has been addressed--did I miss the
> answer?  I understood the question to be "is there  a way to copy an entire
> column of budget values?"  Whether it's a month at a time, in a 12 month
> period, or two weeks at a time in a quarter, if you have several expense
> account parents, with sub-accounts underneath, it takes a while to copy the
> entire column one entry at a time [by memory it's arrow down, return, type
> value, return...and repeat for each account].  Surely there should be a way
> to duplicate a column?
>
> --
>
> *Jim Passmore*
>
>
>
> On Fri, Jan 11, 2019 at 12:09 PM Patrick  wrote:
>
>> Andre,
>>
>> Thanks for the advice. This definitely gives me some possible alternatives
>> to consider.
>>
>> I am not able to find a page that gives the etiquette rules for this
>> mailing list. Is top-posting preferred on this list? I noticed that some
>> people do and some don't.
>>
>> Thanks,
>> Patrick
>>
>> On Fri, Jan 11, 2019 at 6:24 AM Andre Powell 
>> wrote:
>>
>> > Patrick,
>> > The method that I use for budgeting is well "old-fashioned". My salary
>> is
>> > paid every fifteen days and my wife once a month, hence the two-week
>> setup,
>> > and the quarterly view because in my prior career we managed our P
>> > monthly but with quarterly plans so mentally I am kind of used to that
>> way
>> > of thinking (or maybe I don't  want to scroll so much).
>> >
>> > When income comes in is when I actually use the budget to plan where the
>> > money is going to go (a mixture of Dave Ramsey and YNAB). I use the
>> > Bills/Invoice feature to keep track of the bills that need to be paid,
>> but
>> > they don't get paid until they are planned for.
>> >
>> > For monitoring purposes, I use the Budget Report to do exactly that. You
>> > can set it up to see a period before and after your current account
>> period
>> > (mine being set at a quarter), which will show your carryover. I am
>> always
>> > striving for a balanced budget (move/spend less money to make sure that
>> the
>> > budget is balanced. But in theory, you could create a second report
>> with a
>> > longer view (perhaps yearly) to see your overall progress with the
>> period
>> > before.
>> >
>> > I hope this helps.
>> >
>> > On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:
>> >
>> >> Andre,
>> >>
>> >> Thank you for the response. For each two-week period within the
>> quarter,
>> >> did you just have to copy the budget entries from each column to the
>> next?
>> >> That is what I would like to avoid, if possible.
>> >>
>> >> I would like to use one budget so that it is easy to see carryover from
>> >> one budget period to the next. If I create a new budget for each
>> quarter, I
>> >> don't know of a way to get cumulative surplus/deficit for each budget
>> >> category from the previous quarter.
>> >>
>> >> Thanks,
>> >> Patrick
>> >>
>> >> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell 
>> >> wrote:
>> >>
>> >>> Patrick,
>> >>> I made a template and under the Budget menu just make a duplicate/copy
>> >>> as needed (my accounting period is quarterly and the budgets are
>> every two
>> >>> weeks).
>> >>>
>> >>>
>> >>> On Wed, Jan 9, 2019, 10:34 PM Patrick > >>>
>> >>>> Hello,
>> >>>>
>> >>>> I recently started using GnuCash. Is there a way to copy one month's
>> >>>> budget
>> >>>> to the next month? I have a budget with a large number of entries,
>> and
>> >>>> copying each entry individually is somewhat cumbersome.
>> >>>>
>> >>>> Any help is appeciated.
>> >>>>
>> >>>> Regards,
>> >>>> Patrick
>> >>>> __

Re: [GNC] Import a transaction from a CSV file with both the debit and credit account set

[Patrick]

Hello,

Yes, deselecting "Multi-split" allowed what I wanted. Thanks very much for
your help.

I think that one of the things that confused me before you helped is that
until I select and deselect one of the boxes (for example, "multi-split",
or one of the other option boxes shown), it doesn't seem to allow me to set
the column fields. I think when I had observed this before, I thought this
had meant that not selecting any of these boxes was an invalid mode, so I
had selected "multi-split", which then allowed me to categorize the
columns. I see now that if I select a box, and then deselect it, it allows
me to proceed with column categorization and gives me the "transfer
account" option, as you mentioned.

I did not see the "transfer amount" option you mentioned, but I used
"withdrawal", and that seemed to work.

Thanks again and Regards,
Patrick

On Sat, Jan 12, 2019 at 11:50 AM Geert Janssens 
wrote:

> Op zaterdag 12 januari 2019 18:21:34 CET schreef Patrick:
> > Thank you for the advice.
> >
> > I am using version 3.3. When I am using the import wizard and specifying
> > the contents of each column in the CSV file, I see "Date", "Description",
> > "Withdrawal" (amount), and "Account". But I don't see a way to specify
> the
> > other account. (I tried specifying a second "Account" column, but when I
> do
> > this, it deselects the previously selected "Account" column.)
> >
> That sounds as if you have enabled the "Multiline" checkbox ?
> If that checkbox is *not* checked, there should be some additional column
> types like "Transfer Account" and "Transfer Amount"
>
> But perhaps it's more useful if you post a sample of your csv data (you
> can
> anonymize it of course). That will make it easier to help you set the
> proper
> values.
>
> Geert
>
> > Regards,
> > Patrick
> >
> > On Sat, Jan 12, 2019 at 6:57 AM Geert Janssens <
> geert.gnuc...@kobaltwit.be>
> >
> > wrote:
> > > I'm pretty sure what you ask can be done in the new csv importer in
> > > GnuCash
> > > 3.x.
> > >
> > > What version of GnuCash are you using ?
> > >
> > > Regards,
> > >
> > > Geert
> > >
> > > Op zaterdag 12 januari 2019 00:34:06 CET schreef Patrick:
> > > > Hello,
> > > >
> > > > When I am importing transactions from a CSV, I see a way to set one
> of
> > >
> > > the
> > >
> > > > accounts involved with the transaction, but not the other account.
> The
> > >
> > > only
> > >
> > > > way I know to set the other account is to do it manually in the
> import
> > > > wizard for each transaction. Is there a way to set both accounts in
> the
> > >
> > > CSV
> > >
> > > > file so that I don't have to do it manually for each transaction?
> > > >
> > > > I like to keep a log of transactions in a CSV file separately from my
> > > > Gnucash file, and then import that CSV. If Gnucash doesn't allow
> setting
> > > > both accounts in a CSV file, maybe there is a way to use the QIF
> format
> > >
> > > to
> > >
> > > > set both accounts and then import the QIF file? I am open to that, if
> > >
> > > that
> > >
> > > > is possible.
> > > >
> > > > Regards
> > > > Patrick
> > > > ___
> > > > gnucash-user mailing list
> > > > gnucash-user@gnucash.org
> > > > To update your subscription preferences or to unsubscribe:
> > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > > If you are using Nabble or Gmane, please see
> > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> > > > Please remember to CC this list on all your replies.
> > > > You can do this by using Reply-To-List or Reply-All.
>
>
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import a transaction from a CSV file with both the debit and credit account set

[Patrick]

Thank you for the advice.

I am using version 3.3. When I am using the import wizard and specifying
the contents of each column in the CSV file, I see "Date", "Description",
"Withdrawal" (amount), and "Account". But I don't see a way to specify the
other account. (I tried specifying a second "Account" column, but when I do
this, it deselects the previously selected "Account" column.)

Regards,
Patrick

On Sat, Jan 12, 2019 at 6:57 AM Geert Janssens 
wrote:

> I'm pretty sure what you ask can be done in the new csv importer in
> GnuCash
> 3.x.
>
> What version of GnuCash are you using ?
>
> Regards,
>
> Geert
>
> Op zaterdag 12 januari 2019 00:34:06 CET schreef Patrick:
> > Hello,
> >
> > When I am importing transactions from a CSV, I see a way to set one of
> the
> > accounts involved with the transaction, but not the other account. The
> only
> > way I know to set the other account is to do it manually in the import
> > wizard for each transaction. Is there a way to set both accounts in the
> CSV
> > file so that I don't have to do it manually for each transaction?
> >
> > I like to keep a log of transactions in a CSV file separately from my
> > Gnucash file, and then import that CSV. If Gnucash doesn't allow setting
> > both accounts in a CSV file, maybe there is a way to use the QIF format
> to
> > set both accounts and then import the QIF file? I am open to that, if
> that
> > is possible.
> >
> > Regards
> > Patrick
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Import a transaction from a CSV file with both the debit and credit account set

[Patrick]

Hello,

When I am importing transactions from a CSV, I see a way to set one of the
accounts involved with the transaction, but not the other account. The only
way I know to set the other account is to do it manually in the import
wizard for each transaction. Is there a way to set both accounts in the CSV
file so that I don't have to do it manually for each transaction?

I like to keep a log of transactions in a CSV file separately from my
Gnucash file, and then import that CSV. If Gnucash doesn't allow setting
both accounts in a CSV file, maybe there is a way to use the QIF format to
set both accounts and then import the QIF file? I am open to that, if that
is possible.

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

Re: [GNC] Copy a month's budget

[Patrick]

Ok, thanks. Yes, I'd always appreciated that about top-posting - not having
to scroll to the bottom. I'd just recalled in the past having used mailing
lists that didn't allow it.

Thanks,
Patrick

>Personal preference.
>
>For example, depending on the nature of the conversation, (like for
multiple points/questions to discuss) I’ll use in-line, but I usually use
top posting, as in this case.
>
>While I see it occasionally, bottom-posting is the least used in these
parts as it means you have to scroll to read the reply.
>
>Regards,
>Adrien
>
>> On Jan 11, 2019, at 11:08 AM, Patrick  wrote:
>>
>> Andre,
>>
>> Thanks for the advice. This definitely gives me some possible
alternatives
>> to consider.
>>
>> I am not able to find a page that gives the etiquette rules for this
>> mailing list. Is top-posting preferred on this list? I noticed that some
>> people do and some don't.
>>
>> Thanks,
>> Patrick
>>
>> On Fri, Jan 11, 2019 at 6:24 AM Andre Powell 
wrote:
>>
>>> Patrick,
>>> The method that I use for budgeting is well "old-fashioned". My salary
is
>>> paid every fifteen days and my wife once a month, hence the two-week
setup,
>>> and the quarterly view because in my prior career we managed our P
>>> monthly but with quarterly plans so mentally I am kind of used to that
way
>>> of thinking (or maybe I don't  want to scroll so much).
>>>
>>> When income comes in is when I actually use the budget to plan where the
>>> money is going to go (a mixture of Dave Ramsey and YNAB). I use the
>>> Bills/Invoice feature to keep track of the bills that need to be paid,
but
>>> they don't get paid until they are planned for.
>>>
>>> For monitoring purposes, I use the Budget Report to do exactly that. You
>>> can set it up to see a period before and after your current account
period
>>> (mine being set at a quarter), which will show your carryover. I am
always
>>> striving for a balanced budget (move/spend less money to make sure that
the
>>> budget is balanced. But in theory, you could create a second report
with a
>>> longer view (perhaps yearly) to see your overall progress with the
period
>>> before.
>>>
>>> I hope this helps.
>>>
>>> On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:
>>>
>>>> Andre,
>>>>
>>>> Thank you for the response. For each two-week period within the
quarter,
>>>> did you just have to copy the budget entries from each column to the
next?
>>>> That is what I would like to avoid, if possible.
>>>>
>>>> I would like to use one budget so that it is easy to see carryover from
>>>> one budget period to the next. If I create a new budget for each
quarter, I
>>>> don't know of a way to get cumulative surplus/deficit for each budget
>>>> category from the previous quarter.
>>>>
>>>> Thanks,
>>>> Patrick
>>>>
>>>> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell 
>>>> wrote:
>>>>
>>>>> Patrick,
>>>>> I made a template and under the Budget menu just make a duplicate/copy
>>>>> as needed (my accounting period is quarterly and the budgets are
every two
>>>>> weeks).
>>>>>
>>>>>
>>>>> On Wed, Jan 9, 2019, 10:34 PM Patrick >>>>
>>>>>> Hello,
>>>>>>
>>>>>> I recently started using GnuCash. Is there a way to copy one month's
>>>>>> budget
>>>>>> to the next month? I have a budget with a large number of entries,
and
>>>>>> copying each entry individually is somewhat cumbersome.
>>>>>>
>>>>>> Any help is appeciated.
>>>>>>
>>>>>> Regards,
>>>>>> Patrick
>>>>>> ___
>>>>>> gnucash-user mailing list
>>>>>> gnucash-user at gnucash.org
>>>>>> To update your subscription preferences or to unsubscribe:
>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>> If you are using Nabble or Gmane, please see
>>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>>>> -
>>>>>> Please remember to CC this list on all your replies.
>>>>>> You can do this by using Reply-To-List or Reply-All.
>>>>>>
>>>>>
>>>
>>> --
>>> Andre
>>>
>>>
>>>
>> ___
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Copy a month's budget

[Patrick]

Andre,

Thanks for the advice. This definitely gives me some possible alternatives
to consider.

I am not able to find a page that gives the etiquette rules for this
mailing list. Is top-posting preferred on this list? I noticed that some
people do and some don't.

Thanks,
Patrick

On Fri, Jan 11, 2019 at 6:24 AM Andre Powell  wrote:

> Patrick,
> The method that I use for budgeting is well "old-fashioned". My salary is
> paid every fifteen days and my wife once a month, hence the two-week setup,
> and the quarterly view because in my prior career we managed our P
> monthly but with quarterly plans so mentally I am kind of used to that way
> of thinking (or maybe I don't  want to scroll so much).
>
> When income comes in is when I actually use the budget to plan where the
> money is going to go (a mixture of Dave Ramsey and YNAB). I use the
> Bills/Invoice feature to keep track of the bills that need to be paid, but
> they don't get paid until they are planned for.
>
> For monitoring purposes, I use the Budget Report to do exactly that. You
> can set it up to see a period before and after your current account period
> (mine being set at a quarter), which will show your carryover. I am always
> striving for a balanced budget (move/spend less money to make sure that the
> budget is balanced. But in theory, you could create a second report with a
> longer view (perhaps yearly) to see your overall progress with the period
> before.
>
> I hope this helps.
>
> On Thu, Jan 10, 2019 at 10:30 AM Patrick  wrote:
>
>> Andre,
>>
>> Thank you for the response. For each two-week period within the quarter,
>> did you just have to copy the budget entries from each column to the next?
>> That is what I would like to avoid, if possible.
>>
>> I would like to use one budget so that it is easy to see carryover from
>> one budget period to the next. If I create a new budget for each quarter, I
>> don't know of a way to get cumulative surplus/deficit for each budget
>> category from the previous quarter.
>>
>> Thanks,
>> Patrick
>>
>> On Thu, Jan 10, 2019 at 4:15 AM Andre Powell 
>> wrote:
>>
>>> Patrick,
>>> I made a template and under the Budget menu just make a duplicate/copy
>>> as needed (my accounting period is quarterly and the budgets are every two
>>> weeks).
>>>
>>>
>>> On Wed, Jan 9, 2019, 10:34 PM Patrick >>
>>>> Hello,
>>>>
>>>> I recently started using GnuCash. Is there a way to copy one month's
>>>> budget
>>>> to the next month? I have a budget with a large number of entries, and
>>>> copying each entry individually is somewhat cumbersome.
>>>>
>>>> Any help is appeciated.
>>>>
>>>> Regards,
>>>> Patrick
>>>> ___
>>>> gnucash-user mailing list
>>>> gnucash-user@gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>>
>
> --
> Andre
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Copy a month's budget

[Patrick]

Andre,

Thank you for the response. For each two-week period within the quarter,
did you just have to copy the budget entries from each column to the next?
That is what I would like to avoid, if possible.

I would like to use one budget so that it is easy to see carryover from one
budget period to the next. If I create a new budget for each quarter, I
don't know of a way to get cumulative surplus/deficit for each budget
category from the previous quarter.

Thanks,
Patrick

On Thu, Jan 10, 2019 at 4:15 AM Andre Powell  wrote:

> Patrick,
> I made a template and under the Budget menu just make a duplicate/copy as
> needed (my accounting period is quarterly and the budgets are every two
> weeks).
>
>
> On Wed, Jan 9, 2019, 10:34 PM Patrick 
>> Hello,
>>
>> I recently started using GnuCash. Is there a way to copy one month's
>> budget
>> to the next month? I have a budget with a large number of entries, and
>> copying each entry individually is somewhat cumbersome.
>>
>> Any help is appeciated.
>>
>> Regards,
>> Patrick
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Copy a month's budget

[Patrick]

Hello,

I recently started using GnuCash. Is there a way to copy one month's budget
to the next month? I have a budget with a large number of entries, and
copying each entry individually is somewhat cumbersome.

Any help is appeciated.

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

[GNC] No Disk error

[Patrick Murez]

Dear all I want to report a problem already submitted in this mailing list
with no answer so far:

Hi!

I am starting over with gnucash, and thought I'd do a clean re-install.
Note, I am on windows, and have removed all the gnucash files I could
find before installing 3.1.

However, now I am getting an annoying error message every time I try to
look at the preferences, as well as when I do "save as":

Gnucash.exe - No Disk
There is no disk in the drive. Please insert a disk into drive
\Device\Harddisk1\DR1.

I have the options Cancel, Try Again and Continue. Try Again just pops
up the message again, so do the other two too. However, if I click
enough times on Cancel or Continue, the message goes away.

Note, when I change something in Preferences, that change stays when I
quit and restart.

This is quite annoying, and if anybody could shed some light on what has
happened and how to get rid of said message, I'd be very happy.

Karin

your help will great.

Thanks

--

-- 
Patrick Murez, Ch. Eng.
Unit Manager Technical Trainings
Ruashi mining
Cel.:+243816179054
   +243995601060
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] I just looked at Debian Testing (buster)... and GC 3.2 is finally there.

[Patrick Byrne]

Yes I saw that.I have it installed via a backport thingy for now. Why is it
taking so long?

--
__̴ı ̡͌l̡̡̡ ̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡| ̲▫̲͡ π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡
̡͌l.___Patrick Byrne

On 31 July 2018 at 03:08, Lincoln A Baxter  wrote:

> I was mistaken... this is just the docs... :-( The rest of the GC is
> only in SID,
> On Mon, 2018-07-30 at 21:43 -0400, Lincoln A Baxter wrote:
> > For those trying to install 3.2 on distros based on debian testing
> > (currently buster), it looks like gnucach has finally made it in.
> >
> > Version: 3.2-1
> >
> > https://packages.debian.org/buster/gnucash-docs
> >
> > I usually run testing... but decided I was happy with what I had, and
> > would wait until it was back in testing before I did my next "dist-
> > upgrade."  It's been a while.
> >
> > :-D
> >
> > Lincoln
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash3.0 Crashing on Startup

[Patrick Byrne]

Hey, this new version works for me. Thanks, gnucash Gods!



--
__̴ı ̡͌l̡̡̡ ̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡| ̲▫̲͡ π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡
̡͌l.___Patrick Byrne

On 17 April 2018 at 13:49, Geert Janssens 
wrote:

> Op zondag 15 april 2018 17:05:12 CEST schreef Judi Atkinson:
> > I just installed GnuCash for the first time yesterday. No prior version
> > install on my Win 10Pro system. I have entered only 10 customers and
> about
> > 16 transactions, but more often than not, when I open the program, the
> lock
> > from the previous time I opened is still on and I cannot open it. It
> > usually takes about 5-10 tries of "Open Anyway", open as read only, etc.
> to
> > get the file to open. I have had the most success trying to open, letting
> > it crash and tell windows about the crash, then deleting the lock file,
> > reopening as read only and then saving as a different file name. Once I
> do
> > that, and it takes several tries, I can then open the original file as
> the
> > lock is off it. I have output all transactions to a CSV file and can't
> see
> > any errors (but as a newbie, I don't really know what I'm looking for!).
> > Any help is appreciated. This is too much work to make it worthwhile!
> > Judi
>
> I presume you are talking about gnucash 3.0. There are several issues in
> that
> version on Windows that can cause the behaviour you descibe.
> There is a nightly build with several fixes available here:
> https://wiki.gnucash.org/builds/win32/maint/gnucash-3.0-
> 2018-04-17-git-3.0-75-g87f94abc8+.setup.exe
> Can you test this version and let us know if this one works better ?
>
> Regards,
>
> Geert
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC Addition of Mailing List Subject Prefix

[Patrick Byrne]

I'm against it too. We use [] tags at work to indicate the relevant project
for an email thread, but with this mailing list gmail can use the
'gnucash-user' email to tag all mails from this thread. I would assume that
many other email clients also offer such facilities.

--
__̴ı ̡͌l̡̡̡ ̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡| ̲▫̲͡ π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡
̡͌l.___Patrick Byrne

On 10 April 2018 at 11:34, Mark Lawrence  wrote:

> On 09/04/18 13:41, Stephen Albert wrote:
>
>> I'd also prefer [GC] over [GNC].
>>
>>
> I prefer nothing.  The [GNC] looks quite dreadful as it is completely
> unneeded. I'm on gmane.comp.gnome.apps.gnucash.user, why do I need some
> stupid piece of data confirming something that I all ready know?
>
> --
> My fellow Pythonistas, ask not what our language can do for you, ask
> what you can do for our language.
>
> Mark Lawrence
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

On 11/28/2017 12:01 PM, John Ralls wrote:
> gnucash -log gnc.scm=debug

Thank you! This told me which stock symbol was causing the problem. It
turns out I missed one single stock which was still set to yahoo which
caused the error.

As a feature request, it would be incredibly useful if there was a
"default" source for online quotes, so the user can set individual
stocks to use the default source (alphavantage). This way when we want
to switch to a new quote source we just have to change where the default
setting points to.

Of course individual securities should still be able to be customized to
use a different source if needed. Such a feature would have saved me a
lot of time!

Anyway thanks for making this great software.

Patrick

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

Re: Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

I always start it from the command line. The --debug option didn't show 
anything in the log file related to quotes


On 11/28/2017 10:27 AM, John Ralls wrote:



On Nov 28, 2017, at 8:46 AM, Patrick Alken <al...@colorado.edu> wrote:

My OS is Ubuntu linux 17.10

and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok from the 
commandline with alphavantage)

On 11/28/2017 07:50 AM, John Ralls wrote:

On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:

Apologies if this has already been asked, but I couldn't find this exact
issue in the recent mailings.

I have:

gnucash: 2.6.17

F::Q: 1.47

My F::Q works from the command line:

--

$ gnc-fq-dump alphavantage CSCO
Finance::Quote fields Gnucash uses:
 symbol: CSCO <=== required
   date: 11/27/2017   <=== recommended
   currency: USD  <=== required
   last: 36.8700  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional
--

However inside gnucash price editor I still get the "unknown error when
retrieving price quotes".

I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
the security editor. However the price editor still gives me the same
error (unknown error).

gnucash --debug shows nothing related to quotes. I only get lines like this:



* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100



Can anyone advise how to diagnose the issue?

What OS and how did you install F::Q?


Do you normally start GnuCash from the command line? If not, does quote 
retrieval work if you do?

Regards,
John Ralls



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

Re: Alphavantage not working in gnucash 2.6.17

[Patrick Alken]

My OS is Ubuntu linux 17.10

and I installed F::Q via CPAN (gnc-fq-dump and gnc-fq-helper work ok 
from the commandline with alphavantage)


On 11/28/2017 07:50 AM, John Ralls wrote:



On Nov 27, 2017, at 9:57 PM, Patrick Alken <al...@colorado.edu> wrote:

Apologies if this has already been asked, but I couldn't find this exact
issue in the recent mailings.

I have:

gnucash: 2.6.17

F::Q: 1.47

My F::Q works from the command line:

--

$ gnc-fq-dump alphavantage CSCO
Finance::Quote fields Gnucash uses:
 symbol: CSCO <=== required
   date: 11/27/2017   <=== recommended
   currency: USD  <=== required
   last: 36.8700  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional
--

However inside gnucash price editor I still get the "unknown error when
retrieving price quotes".

I have unchecked the "Get Online Quotes" flag from ALL of my stocks in
the security editor. However the price editor still gives me the same
error (unknown error).

gnucash --debug shows nothing related to quotes. I only get lines like this:



* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/1
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100
* 22:34:53  INFO  [xaccAccountGetBalanceInCurrency]  baln=0/100



Can anyone advise how to diagnose the issue?

What OS and how did you install F::Q?

Regards,
John Ralls



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