Re: [GNC] NEw user assistance

[john]

GnuCash prioritizes direct prices over indirect ones, so if you have a single 
AAPL-CAD price in your price database and a bunch of AAPL-USD and USD-CAD ones 
the latter will be ignored when trying to price AAPL in CAD and you'll almost 
always get the single direct price.

Two more important considerations: Every transaction in GnuCash has a single 
transaction currency and all prices created by that transaction are to/from the 
transaction currency. The transaction currency is determined by the account 
whose register has focus when you create it or by the From account when using 
the Transfer Dialog.

If you're going to do multi-currency trading you want to enable Trading 
Accounts on the book. You do that on the first tab of File>Properties. One of 
the side effects of doing that is that the register shows amounts in the split 
account's currency instead of the Register account's currency. The following 
example will be written that way.

To avoid creating that AAPL-CAD price you need to create a possibly fake USD 
cash account. If you purchase of US stocks involve an actual USD cash account 
then use that. Once the accounts are in place, do the following. For an e.g. to 
have numbers I'll assume a purchase of 100 shares of AAPL at today's closing 
price of 129.62 and 1 USD = 1.34429 CAD. 100 shares of AAPL, assuming a 
no-fee/no-commission brokerage and that the ask is the close, will cost USD 
12,962.00, which is CAD 17,433.24. If you do this part from the CAD account you 
must use two transactions like so:

2023-01-06 Fund USD Cash for Purchase of 100 AAPL

Assets:Investment:Cash-CAD  
CAD 17,433.24

Assets:Investment:Cash-USD  USD 12,962.00

Now buy the stock in another transaction. Do this in either the AAPL or USD 
register to ensure that the transaction currency is USD!
2023-01-06 Buy AAPL 100

Assets:Investment:Stocks:Stocks-USD:AAPL100 129.62  
12,1962.00

Assets:Investment:Cash-USD  
12,962.00

If you start from the AAPL or Cash-USD account you can do it in a single 
transaction because the transaction currency will be USD, but you still need to 
do all four splits. Note that when you commit the transaction by pressing 
return or tabbing out of the blank split the Trading Accounts code will add 4 
more Trading Account splits.

A sell would be done the same way but in the other direction.

Regards,
John Ralls


> On Jan 6, 2023, at 1:45 PM, Karl  wrote:
> 
> Hi there John,
> 
> Thanks for the information. Very helpful! Perhaps I am setting up my foreign 
> (USD) investment accounts all wrong. I'm trying to follow the instructions 
> and examples in Chapters 9.5 and 9.6, but I can't reconcile the instructions 
> with your explanation.
> 
> So if I set-up the account structure as you described:
> 
> Assets
>   Investments
>   Stocks
>   Stocks-USD
>   AAPL
> 
>  ... when I go to make an initial purchase of AAPL shares/stock, do I enter 
> the transaction in CAD or USD? For example, AAPL closed at $129.62 USD today, 
> so if I bought 10 stocks, should my entry be:
> 
> DR AAPL stock  1,296.20 (USD)
>   CR Cash 1,296.20 (USD)
> 
> or should it be:
> 
> DR AALP stock  1,736.91 (CAD)
>   CR Cash  1,736.91 (CAD)
> 
> ???
> 
> CAD-USD was at $1.00 USD = $1.34 CAD.
> 
> 
> Ideally, when I run the "Advanced Portfolio" Report, I would like for what 
> I'm seeing to be in CAD. Is this possible?
> 
> Thanks again for your help. As you can probably tell, I'm terrible with 
> computers, but not too bad with accounting! haha
> 
> Regards,
> 
> Karl
> 
> 
> On Fri, 6 Jan 2023 at 13:12, john  > wrote:
>> That's a very long-running discussion with another Canadian CPA, see 
>> https://bugs.gnucash.org/show_bug.cgi?id=797796
>> and https://bugs.gnucash.org/show_bug.cgi?id=798004.
>> 
>> The simplest workaround is to set up an account structure that looks like
>> Assets
>>  Investments
>>  Stocks
>>  Stocks-USD
>>  AAPL
>> 
>> As long as you keep the priceDB updated with both CAD-USD exchange rates and 
>> AAPL prices the Stocks account will show the value of the AAPL shares in 
>> CAD. Unfortunately if you have several USD stocks and want to track them 
>> individually you'd need to do something like
>>  Stock-AAPL-CAD
>>  Stock-AAPL-USD
>> 

Re: [GNC] NEw user assistance

[Christopher Lam]

I would think that if your home currency is CAD and you buy some USD
stocks, you'd first transfer some cash from your CAD bank into your
brokerage account in USD, then immediately use the latter to purchase your
AAPL.

On Sat, 7 Jan 2023, 5:46 am Karl,  wrote:

> Hi there John,
>
> Thanks for the information. Very helpful! Perhaps I am setting up my
> foreign (USD) investment accounts all wrong. I'm trying to follow the
> instructions and examples in Chapters 9.5 and 9.6, but I can't
> reconcile the instructions with your explanation.
>
> So if I set-up the account structure as you described:
>
> Assets
> Investments
> Stocks
> Stocks-USD
> AAPL
>
>  ... when I go to make an initial purchase of AAPL shares/stock, do I enter
> the transaction in CAD or USD? For example, AAPL closed at $129.62 USD
> today, so if I bought 10 stocks, should my entry be:
>
> DR AAPL stock  1,296.20 (USD)
>   CR Cash 1,296.20 (USD)
>
> or should it be:
>
> DR AALP stock  1,736.91 (CAD)
>   CR Cash  1,736.91 (CAD)
>
> ???
>
> CAD-USD was at $1.00 USD = $1.34 CAD.
>
>
> Ideally, when I run the "Advanced Portfolio" Report, I would like for what
> I'm seeing to be in CAD. Is this possible?
>
> Thanks again for your help. As you can probably tell, I'm terrible with
> computers, but not too bad with accounting! haha
>
> Regards,
>
> *Karl*
>
>
> On Fri, 6 Jan 2023 at 13:12, john  wrote:
>
> > That's a very long-running discussion with another Canadian CPA, see
> > https://bugs.gnucash.org/show_bug.cgi?id=797796
> > and https://bugs.gnucash.org/show_bug.cgi?id=798004.
> >
> > The simplest workaround is to set up an account structure that looks like
> > Assets
> > Investments
> > Stocks
> > Stocks-USD
> > AAPL
> >
> > As long as you keep the priceDB updated with both CAD-USD exchange rates
> > and AAPL prices the Stocks account will show the value of the AAPL shares
> > in CAD. Unfortunately if you have several USD stocks and want to track
> them
> > individually you'd need to do something like
> > Stock-AAPL-CAD
> > Stock-AAPL-USD
> > AAPL
> > Stock-GOOG-CAD
> > Stock-GOOG-USD
> > GOOG
> >
> > Which could be a bit tiresome. An alternative is to set things up as you
> > would normally, i.e.
> > Assets
> > Investments
> > Cash
> > Stocks-USD
> > AAPL
> > GOOG
> >
> > and use the Advanced Portfolio Report to show the values in CAD.
> >
> > I don't understand what you mean by "the currency exchange function", but
> > if you want to retrieve the CAD-USD exchange rate you need to get an
> > Alphavantage API key. The issue in bug 798599 is resolved because
> > Alphavantage put currency exchange rates back to being available with a
> > free API key. F::Q version 1.53 switched to a different retrieval method
> > that broke retrieving precious metal rates (e.g. XAU-CAD) so if that's
> your
> > concern you need a F::Q version that isn't 1.53; the current release is
> > 1.54.
> >
> > Regards,
> > John Ralls
> >
> >
> > On Jan 6, 2023, at 6:05 AM, Karl  wrote:
> >
> > Hello David and everyone,
> >
> > Thank you for your messages. A little background about myself: I'm a
> > Canadian (born and raised), and a CPA. I have been using GnuCash for a
> > while now, but am interested in delving deeper into its functions that
> can
> > be useful to me. I use GnuCash only for personal and private use for my
> > household, not for business purposes in any way.
> >
> > I am currently running Microsoft Windows 10 Pro (Build 19045) on my main
> > machine at home, and am using GnuCash Version 4.10 with "Finance::Quote
> > 1.54" and perl (v5.32.1).
> >
> > I am enjoying the Chapter 9 - Investments part of GnuCash and have
> > successfully set up the Automatic Online Retrieval of Stock Quotes. What
> a
> > great function!
> >
> > The trouble is, I can't figure out a way to have any foreign investments
> > denominated in my local currency (CAD). For example, if I invest in,
> let's
> > say, Apple Inc (NASDAQ: AAPL), which is traded on the NASDAQ (a foreign
> > market for me), the share(s) value only shows up in the currency of the
> > market in which it is being traded (in this case, USD). How do I get
> > GnuCash to denominate and show me my foreign investments in my local
> > currency (CAD)?
> >
> > Not sure if this is related but, I also tried to set-up the currency
> > exchange function, but it appears that this is no longer functional due
> to
> > the API Key from Alphavantage. Is this true?
> > https://bugs.gnucash.org/show_bug.cgi?id=798599
> >
> > Thank you everyone. Happy to see that there is a supportive and
> > collaborative community here!
> >
> > Regards,
> >
> > *Karl*
> >
> >
> > On Thu, 5 Jan 2023 at 20:07, David H  wrote:
> >
> > Welcome to gnucash Karl.
> >
> > I think from memory Nabble went away during the pandemic about 12 months
> > ago, so maybe forget that one :-)  If you have any questions, post them
> > here to the gnucash user list (gnucash-user@gnucash.org) 

Re: [GNC] Register column sizing

[Fred Tydeman]

I find that doing a double left click on each column header,
going from right to left works just fine.

On Fri, Jan 6, 2023 at 7:11 PM peterb  wrote:

> I have been using Gnucash for many years and I still never know exactly
> what's going to happen when I try to resize a column. It is 120%
> infuriating - at least to me! - so I'm in favor of trying to make the
> behavior more sensible.
>
> It feels fundamentally weird to me to privilege the description column that
> way, because it means I constantly end up in situations where space is
> being added to the description column, which in the common case has plenty
> of room, and in the meantime my debit and credit columns are cutting off
> half the numbers in them.
>
> -Peter
>
> On Thu, Jan 5, 2023 at 10:42 PM john  wrote:
>
> > Users,
> >
> > There have been occasional complaints for many years about column width
> > sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> > Most users seem to eventually get used to it, but I wonder if anybody
> > really likes it.
> >
> > The problem boils down to the auto-sizing behavior of the Description
> > column, which causes that column to grow or shrink when you adjust the
> > window's width, and to make a horizontal scrollbar appear when you widen
> > another column. Occasionally someone will complain about the normally
> > hidden price column because it's possible to catch its handle and widen
> it
> > when you mean to widen the balance column.
> >
> > It would be really easy to turn off autosizing on the Description field
> > and only a little work to figure out another way to handle the price and
> > ditch that column. Would anyone miss it?
> >
> > Regards,
> > John Ralls
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please 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] Register column sizing

[peterb]

I have been using Gnucash for many years and I still never know exactly
what's going to happen when I try to resize a column. It is 120%
infuriating - at least to me! - so I'm in favor of trying to make the
behavior more sensible.

It feels fundamentally weird to me to privilege the description column that
way, because it means I constantly end up in situations where space is
being added to the description column, which in the common case has plenty
of room, and in the meantime my debit and credit columns are cutting off
half the numbers in them.

-Peter

On Thu, Jan 5, 2023 at 10:42 PM john  wrote:

> Users,
>
> There have been occasional complaints for many years about column width
> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> Most users seem to eventually get used to it, but I wonder if anybody
> really likes it.
>
> The problem boils down to the auto-sizing behavior of the Description
> column, which causes that column to grow or shrink when you adjust the
> window's width, and to make a horizontal scrollbar appear when you widen
> another column. Occasionally someone will complain about the normally
> hidden price column because it's possible to catch its handle and widen it
> when you mean to widen the balance column.
>
> It would be really easy to turn off autosizing on the Description field
> and only a little work to figure out another way to handle the price and
> ditch that column. Would anyone miss it?
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please 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] Request for Automatic Reconciliation Function

[Jim DeLaHunt]

Bite Gao:

Thank you for continuing this conversation. I am glad to have your ideas 
in this discussion.


While I think I understand what feature you are asking for, I do see 
some difficulties with it. For example, you say:


On 2023-01-06 17:22, Bite Gao wrote:
…For each split record in the GnuCash file, the program scan for its 
counterpart in the bank statement.… Personally, I do not found that 
how computer program could make mistake in this process.…


The obvious difficulty is that for a single transaction, the text in the 
GnuCash file is probably different than the text in its counterpart in 
the bank statement. For example, suppose I have a weekly purchase where 
I enter the description as "SPUD, Vancouver BC" and the date as January 
5, but the bank statement may say "Small Potatoes Delivery * Paypal" and 
the date as January 6.  It is difficult — not impossible, but difficult 
— for GnuCash to see that these two transactions are counterparts. Their 
description text and their dates differ.


It turns out that GnuCash's Import Matcher can successfully recognise 
the link between these two.  But it often makes mistakes in this process.


Best regards,
    —Jim DeLaHunt


On 2023-01-06 17:22, Bite Gao wrote:

GnuCash Developers and Maintainers:
  Hello! While you pinpoint out the possibility of a mistake in 
automated process, it did not eliminate the meaning of the automatic 
reconciliation.
  What an automatic reconciliation does is: the program concatenates 
the transaction's date, check number and the transaction amount from 
both the bank statement and the GnuCash file. For each split record in 
the GnuCash file, the program scan for its counterpart in the bank 
statement. And when the counterpart is found, the program marks the 
split as reconciled.
  Personally, I do not found that how computer program could make 
mistake in this process. If you believe that the computer could have 
that happen, I would like to learn the detail about it.


  Yours,

   Bite Gao
Jan 7th, 2021

On 2023/1/6 20:57, Adrien Monteleone wrote:

I understand your explanation, but if you aren't checking and 
verifying every transaction, how do you ever discover when the 
automated process makes a mistake?


Reconciliation was invented long before computers, but I appreciate 
that the process demands one to slow down, take your time, and 
methodically verify the information.


Think of it as proof-reading - the hard way. (I learned in school to 
read stuff backwards when proofing!)


That is a pretty good analogy too:

If you've ever used auto-correct with auto-checking for spelling and 
grammar, or auto-suggestion or auto-completion for entire words and 
have seen the embarrassment and/or nightmare that can produce when 
the computer 'gets it wrong', would you want something like that for 
your financial records?


Regards,
Adrien

On 1/5/23 7:50 PM, Bite Gao wrote:

GnuCash Developers and Maintainers:
   Hello! While you have mentioned the requirement of human 
intervene in the reconciliation process, I do not see it contradicts 
with the presence of automatically reconciliation system.
   In a reconcile process, the accountant check the record in the 
account book with the record in the bank statement (or statement 
from other institution). He (or she) may found out that two record 
are identical, or he (or she) may found that some record are not 
identical. Only the latter requires human notice, since there its no 
point wasting time on reconciled accounting transactions. An 
automatic reconciliation system can load the digital statement from 
the institution, compares the statement with the transaction in the 
accounting book, and pinpoints the discrepancies out. Then human 
accountant could step in and perform manual operations, such as 
checking other vouchers, contact with banks, etc. In the situation 
of single user, the automatic reconcile system have no reason to 
block manu

al reconciliation.
   Besides, when I means "human err", I means that the accountant 
overlook an discrepancy and regards it as identical. People do not 
spend too much time on identical records, since major of the 
transaction would be in that state. However, it could cause severe 
consequences if there do have a discrepancy.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 

Re: [GNC] Request for Automatic Reconciliation Function

[Dean Gibson]

You are asking for the impossible.  It is not possible to predict all 
the possible ways a computer program could make a mistake.  It's just 
not knowable.



On 2023-01-06 17:22, Bite Gao wrote:

GnuCash Developers and Maintainers:
  ...
  Personally, I do not found that how computer program could make 
mistake in this process. If you believe that the computer could have 
that happen, I would like to learn the detail about it.


  Yours,

   Bite Gao
Jan 7th, 2021


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Request for Automatic Reconciliation Function

[Bite Gao]

GnuCash Developers and Maintainers:
  Hello! While you pinpoint out the possibility of a mistake in 
automated process, it did not eliminate the meaning of the automatic 
reconciliation.
  What an automatic reconciliation does is: the program concatenates 
the transaction's date, check number and the transaction amount from 
both the bank statement and the GnuCash file. For each split record in 
the GnuCash file, the program scan for its counterpart in the bank 
statement. And when the counterpart is found, the program marks the 
split as reconciled.
  Personally, I do not found that how computer program could make 
mistake in this process. If you believe that the computer could have 
that happen, I would like to learn the detail about it.


  Yours,

   Bite Gao
Jan 7th, 2021

On 2023/1/6 20:57, Adrien Monteleone wrote:

I understand your explanation, but if you aren't checking and 
verifying every transaction, how do you ever discover when the 
automated process makes a mistake?


Reconciliation was invented long before computers, but I appreciate 
that the process demands one to slow down, take your time, and 
methodically verify the information.


Think of it as proof-reading - the hard way. (I learned in school to 
read stuff backwards when proofing!)


That is a pretty good analogy too:

If you've ever used auto-correct with auto-checking for spelling and 
grammar, or auto-suggestion or auto-completion for entire words and 
have seen the embarrassment and/or nightmare that can produce when the 
computer 'gets it wrong', would you want something like that for your 
financial records?


Regards,
Adrien

On 1/5/23 7:50 PM, Bite Gao wrote:

GnuCash Developers and Maintainers:
   Hello! While you have mentioned the requirement of human intervene 
in the reconciliation process, I do not see it contradicts with the 
presence of automatically reconciliation system.
   In a reconcile process, the accountant check the record in the 
account book with the record in the bank statement (or statement from 
other institution). He (or she) may found out that two record are 
identical, or he (or she) may found that some record are not 
identical. Only the latter requires human notice, since there its no 
point wasting time on reconciled accounting transactions. An 
automatic reconciliation system can load the digital statement from 
the institution, compares the statement with the transaction in the 
accounting book, and pinpoints the discrepancies out. Then human 
accountant could step in and perform manual operations, such as 
checking other vouchers, contact with banks, etc. In the situation of 
single user, the automatic reconcile system have no reason to block manu

al reconciliation.
   Besides, when I means "human err", I means that the accountant 
overlook an discrepancy and regards it as identical. People do not 
spend too much time on identical records, since major of the 
transaction would be in that state. However, it could cause severe 
consequences if there do have a discrepancy.


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

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

Re: [GNC] Register column sizing

[David Carlson]

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

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

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

Re: [GNC] Register column sizing

[Maf. King]

CAn I suggest that columns are given a notional minimum width, to stop the 
problem of the left and right dividers overlapping.  say 5 or 10px or 
something, it you are thiking of diddling around with that area of code?

"vanishing" columns seems to be another similar FAQ over the years.

Maf.


On Friday, 6 January 2023 19:30:05 GMT john wrote:
> With the exception of the Description field automatically resizing itself to
> fit the register in the window width, I think GnuCash does size columns the
> same way spreadsheets do: You put the pointer on the right-hand divider in
> the header and drag it, and double-click in the header to fit the width to
> the widest entry in that column. What do you think spreadsheets do
> differently?
> 
> Regards,
> John Ralls
> 
> > On Jan 6, 2023, at 5:37 AM, Thomas Forrester 
> > wrote:
> > 
> > I realize I'm answering a slightly different question, but I've never
> > understood why the GnuCash developers have never made column sizing (and
> > apparently hiding, too) work just like spreadsheets.  We already invented
> > that wheel, and people are *really* accustomed to how it works, hence the
> > grumbling when it's discovered by new GnuCash users that it doesn't work
> > that way here.  I think the vast majority would agree that the way
> > spreadsheet columns work is a very mature, and well understood
> > "technology" (for lack of a better word) that has become ubiquitous and
> > intuitive.  Note also that I said "spreadsheets" rather than, say,
> > "Excel" because the way spreadsheet columns work isn't specific to any
> > one spreadsheet program, and once again speaks to how universal handling
> > spreadsheet columns has become.
> > 
> > My guess is that what you're asking is likely just fine, but isn't it just
> > another band-aid that really would be better ripped off in favor of
> > spreadsheet-like resizing logic?
> > 
> > Tom
> > Thomas L. Forrester
> > Middleton, WI USA
> > 
> > On Thu, Jan 5, 2023 at 9:42 PM john mailto:jra...@ceridwen.us>> wrote:
> >> Users,
> >> 
> >> There have been occasional complaints for many years about column width
> >> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> >> Most users seem to eventually get used to it, but I wonder if anybody
> >> really likes it.
> >> 
> >> The problem boils down to the auto-sizing behavior of the Description
> >> column, which causes that column to grow or shrink when you adjust the
> >> window's width, and to make a horizontal scrollbar appear when you widen
> >> another column. Occasionally someone will complain about the normally
> >> hidden price column because it's possible to catch its handle and widen
> >> it when you mean to widen the balance column.
> >> 
> >> It would be really easy to turn off autosizing on the Description field
> >> and only a little work to figure out another way to handle the price and
> >> ditch that column. Would anyone miss it?
> >> 
> >> Regards,
> >> John Ralls
> >> 
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org 
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




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

Re: [GNC] Budget report fails in multiple currencies

[Adrien Monteleone]

Christopher Lamm had been working on various aspects of the Budget 
Report not long ago. He may be able to squeeze in a look at this. He'll 
likely be the one to see your bug report and maybe shed light on the 
math logic.


If I can find some time this weekend I'll test as well. I normally don't 
budget with multiple currencies, but I do use the Budget feature and 
report. (looking at your screenshot, I've never done a multi-year 
budget, so that will be interesting. I'll test too with a single year.)


Concerning the 'roll-up', if you leave the parent blank, it should work. 
(at least it does with a single currency) *But*, you can also put in a 
different value manually for the parent. I'm not sure if that is in play 
here or not. The parent has to be entirely blank, not just a "0" or "0.00"


*note, this is for the Budget itself, your screenshot showed the report 
result, but does the parent roll-up not work on the budget tab either?


With respect to the 'past-period memory', it could be buggy, but I'd be 
inclined to first look really carefully at my report options, *and* the 
budget period setup. (Edit > Budget Options, or Options toolbar button 
once a budget is already open - different from Options button on the 
report tab) I once made an odd mess here myself that produced strange 
numbers that didn't make sense.


Specifically with the Report Options, the General tab can make things 
messy with respect to custom ranges, and Accounts > Account Depth can 
produce odd results if not sufficiently deep, or if flattened.


Additionally, did you simply manually enter all budget values, or did 
you perhaps use the Estimate feature?


Finally, does this book have Trading Accounts enabled by chance? I think 
I understood from your first post that you aren't using them yet. (mine 
does, so I'll test with and without to see if there is difference)


-
I've been in the habit of hazarding guesses lately, so here's one for 
this topic:


Since the Budget Report does not have an option for commodity price 
source like other reports cognizant of other currencies, I'll 
hypothesize that budgets simply aren't (yet) capable of properly working 
with more than one, or any currency other than the book currency.


Regards,
Adrien

On 1/6/23 4:48 PM, ml enquirer wrote:

Dear all,

I've done some digging, and Gnucash totals seem to be wrongly reported for
budget reports with multi-currency sub-accounts. But I'm not an accountancy
expert at all, so perhaps someone can explain the accounting logic behind
it? Perhaps a report that can imply 1+1=3 should have a warning note?
Should we be ensuring that accounts add up across budget periods, or down
hierarchies within budget periods? Gnucash is doing the former, but it's
confusing since the display can imply only the latter is in action.

I built a local copy of gnucash and tracked the calls through budget.scm
back to the totalling and currency-conversion that happens in Account.cpp
and I see where the confusion arises. There is memory of previous budget
periods built into the reported totals under each asset class (see the
detail below and the picture attached).

Isn't it a bit counter-intuitive that the budget reports for 'parent'
account values in a given budget period, don't need to add up to the sum of
the 'child' account values when converted by the exchange rate relevant for
that budget period? I give lots of detail below, where it's clear the
report is not "buggy", but it is borderline misleading, particularly given
that the report can be restricted to a single budget period within which it
appears to say that 30,000 GBP is the sum of 10,000 GBP and 10,000 EUR,
when the exchange rate is 1GBP = 1EUR. 1+1=3?

Would love some expert input. Maybe I should report this as a bug and let
someone set me right there? :)

Cheers,
D

PS: Here's the detail:
I expected:
- reported actual "Groceries" total would be the sum of the reported "GBP"
and "EUR" account spends in that budget period, according to the relevant
FX rate.

But in reality:
- it's actually this year's change in the balance for that account compared
to the last budget period. That means that while the GBP or EUR rows always
change by 10,000 each year, and thus always show 10,000 in the budget
report, the sum of the two - the "Groceries" row - is not necessarily equal
to 10,000 GBP + 10,000 EUR. In my example, 1EUR = 0.5 GBP for the first two
budget periods, so the balance of "Groceries" by the end of the second
period was (10,000GBP+5,000GBP) + (10,000 GBP + 5,000 GBP) = 30,000 GBP.
But at the end of the third period, the three years' of spending meant that
the balance of "Groceries" was
(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP) = 60,000
GBP. Difference 30,000 GBP.

so 1 + 1 = 3.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] Is a screwed-up style sheet hiding somewhere?

[Adrien Monteleone]

Fair enough.

I see you managed to clear it up with a registry edit.

I did manage to get a similar looking invoice to yours by default 
though. That was via Reports > Business > Fancy Invoice.


The other options of Easy, Printable, & Tax Invoice are more sane looking.

You can change the 'default' Invoice template to Fancy (not that you'd 
want to now) via Preferences > Business > Report for printing. I'd bet 
you had it set for the Fancy template before your re-install and regedit 
attempt.


-
As a side note here, maybe take from a clean install, a copy of the 
settings location folders as a backup to do a quick restore. For the 
registry entries, I think you can export selected folders/keys as a 
subset that can be 're-imported' if needed rather than have to manually 
edit individual keys. (This is how installations work behind the scenes) 
I don't recall all of those steps as I haven't regularly used Windows in 
years, but I know it can be done.


Regards,
Adrien

On 1/6/23 4:16 PM, Dr. David Kirkby wrote:

Since installation was so quick, I thought removing all files from all the
directories listed in Help -> About was certain to solve the problem.

Your fix works for an invoice, but the next time I try to generate one, the
same problem persists. So I don't think that's an ideal solution. I don't
want to have to change it manually each time. Originally the default
invoice looked reasonable (no duplicated company name). I was messing
around with the style sheets a week or so ago when I caused the problem. I
know I created it, and also moving the accounts to a Linux workstation does
not show the problem. So the problem was caused by me on this Windows
laptop and remains on the laptop, not the .gnucash file. I have somehow
changed the default invoice (and bill), and left the changes in a location
I can't find.

I tried changing the location I saved files from the Documents folder to
the Desktop. But that does not solve the problem.

I'm 99% sure there was an uninstall program on version 4.12. But maybe
Windows put one in the GnuCash folder.

Looking at this

https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Windows

GnuCash uses files in HOME\AppData\Local. That's not listed on the help
menu.

You might laugh, but I'm going to uninstall again, and see if I can clear
out anything from HOME\AppData\Local. Perhaps then I can restore the
default behaviour to something sensible.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Is a screwed-up style sheet hiding somewhere?

[Dr. David Kirkby]

On Fri, 6 Jan 2023 at 22:12, David H  wrote:

> Dave,
>
> You might be overlooking the settings in the Windows Registry? Details at
> https://wiki.gnucash.org/wiki/Configuration_Locations - snippet below
>
> Cheers David H.
>


Thank you. Clearing the stuff from the registry with regedit cleared the
problem.

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] Budget report fails in multiple currencies

[ml enquirer]

Dear all,

I've done some digging, and Gnucash totals seem to be wrongly reported for
budget reports with multi-currency sub-accounts. But I'm not an accountancy
expert at all, so perhaps someone can explain the accounting logic behind
it? Perhaps a report that can imply 1+1=3 should have a warning note?
Should we be ensuring that accounts add up across budget periods, or down
hierarchies within budget periods? Gnucash is doing the former, but it's
confusing since the display can imply only the latter is in action.

I built a local copy of gnucash and tracked the calls through budget.scm
back to the totalling and currency-conversion that happens in Account.cpp
and I see where the confusion arises. There is memory of previous budget
periods built into the reported totals under each asset class (see the
detail below and the picture attached).

Isn't it a bit counter-intuitive that the budget reports for 'parent'
account values in a given budget period, don't need to add up to the sum of
the 'child' account values when converted by the exchange rate relevant for
that budget period? I give lots of detail below, where it's clear the
report is not "buggy", but it is borderline misleading, particularly given
that the report can be restricted to a single budget period within which it
appears to say that 30,000 GBP is the sum of 10,000 GBP and 10,000 EUR,
when the exchange rate is 1GBP = 1EUR. 1+1=3?

Would love some expert input. Maybe I should report this as a bug and let
someone set me right there? :)

Cheers,
D

PS: Here's the detail:
I expected:
- reported actual "Groceries" total would be the sum of the reported "GBP"
and "EUR" account spends in that budget period, according to the relevant
FX rate.

But in reality:
- it's actually this year's change in the balance for that account compared
to the last budget period. That means that while the GBP or EUR rows always
change by 10,000 each year, and thus always show 10,000 in the budget
report, the sum of the two - the "Groceries" row - is not necessarily equal
to 10,000 GBP + 10,000 EUR. In my example, 1EUR = 0.5 GBP for the first two
budget periods, so the balance of "Groceries" by the end of the second
period was (10,000GBP+5,000GBP) + (10,000 GBP + 5,000 GBP) = 30,000 GBP.
But at the end of the third period, the three years' of spending meant that
the balance of "Groceries" was
(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP) = 60,000
GBP. Difference 30,000 GBP.

so 1 + 1 = 3.



On Thu, Jan 5, 2023 at 9:37 PM ml enquirer  wrote:

> Hi!
>
> Any clues as to where to start to understand this odd budget report
> behaviour? Browsing the code, I wondered if I should start pulling the code
> apart here:
>
> https://github.com/Gnucash/gnucash/blob/master/gnucash/gnome/gnc-budget-view.c#L1011
>
> to understand why the totals would be combined in such an
> apparently-illogical (but presumably profoundly reasonable to a
> better-informed person!) way...
>
> Hints very much appreciated!
>
> On Mon, Jan 2, 2023 at 4:10 PM ml enquirer 
> wrote:
>
>> Dear all,
>>
>> I spend in two currencies and, historically, I chose to create separate
>> accounts under each expense line for each currency. In future I will do
>> this differently, employing trading accounts, but what I'm about to
>> describe should still work. I budget in my 'home' currency, and the budget
>> report would combine the "sub-spends" in each currency (using the price
>> database).
>>
>> However, the "Actual" budget totals don't behave as I expected. I've set
>> up a simple scenario to explain:
>> 1) I set up an assets and expense ("Groceries") account
>> Under each I set up a "GBP" and a "EUR" account
>> 3) On 1st Jan of 2020, 2021, 2022, 2023 I spend 10,000 EUR and 10,000 GBP
>> on "Groceries"
>> 4) I set up the price database with four entries, on 1st Jan:
>>  - 1/1/2020 1GBP = 1EUR
>>  - 1/1/2021 1GBP = 2EUR
>>  - 1/1/2022 1GBP = 1EUR
>>
>> I've attached a simple reproducer ("bugreport.gnucash", though perhaps
>> this is not a bug so filename might be inappropriate!).
>>
>> When I look at the default budget report, I see that the total per year
>> is always 10,000 of each currency in the sub-accounts, as expected, but the
>> budget's "Act" total under "Groceries" is:
>> 1/1/2020: £15,000 [I expect £20,000 because EUR=GBP on 1/1/20]
>> 1/1/2021: £15,000 [I expect £15,000 because 1EUR=0.5GBP on 1/1/21]
>> 1/1/2022: £30,000 [I expect £20,000 because 1EUR=1GBP on 1/1/22]
>> 1/1/2023: £20,000 [I expect £20,000 because 1EUR=1GBP on 1/1/23]
>>
>> Can someone explain where my naive expectation is wrong? Is GnuCash doing
>> some strange interpolation between exchange rate values?
>>
>> Many thanks in advance.
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do 

Re: [GNC] Select correct database for plot and explorer gui widgets

[Ben Pracht]

My apologies. I emailed wtong list

On Fri, Jan 6, 2023, 14:33 john  wrote:

>
>
> > On Jan 5, 2023, at 10:11 PM, Ben Pracht  wrote:
> >
> > Hi,
> >
> > I really like having the convenience of an inline plotter, but the plot
> > widget only allows me to select
> > the X and Y values from I think is the OOTB country database. How can I
> > select a different database for this widget? It seems like somewhere
> there
> > should be a database selection drop down for it.
>
> Is this posted to the wrong mailing list?
>
> If it's about GnuCash, what inline plotter and what's an OOTB country
> database?
>
> Regards,
> John Ralls
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is a screwed-up style sheet hiding somewhere?

[Dr. David Kirkby]

On Fri, 6 Jan 2023 at 21:28, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> You didn't like the looks of an invoice so you tried
> uninstall/re-install? Holy cow.
>
> Since you don't specify what about the invoice you don't like, the best
> I can do is guess:
>
> You're not a fan of your duplicated company name and info. That's
> certainly reasonable. I'm not sure why it would appear twice either.
> That's an easy fix though. (without a re-install or starting a new book!)
>

Since installation was so quick, I thought removing all files from all the
directories listed in Help -> About was certain to solve the problem.

Your fix works for an invoice, but the next time I try to generate one, the
same problem persists. So I don't think that's an ideal solution. I don't
want to have to change it manually each time. Originally the default
invoice looked reasonable (no duplicated company name). I was messing
around with the style sheets a week or so ago when I caused the problem. I
know I created it, and also moving the accounts to a Linux workstation does
not show the problem. So the problem was caused by me on this Windows
laptop and remains on the laptop, not the .gnucash file. I have somehow
changed the default invoice (and bill), and left the changes in a location
I can't find.

I tried changing the location I saved files from the Documents folder to
the Desktop. But that does not solve the problem.

I'm 99% sure there was an uninstall program on version 4.12. But maybe
Windows put one in the GnuCash folder.

Looking at this

https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Windows

GnuCash uses files in HOME\AppData\Local. That's not listed on the help
menu.

You might laugh, but I'm going to uninstall again, and see if I can clear
out anything from HOME\AppData\Local. Perhaps then I can restore the
default behaviour to something sensible.

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] Is a screwed-up style sheet hiding somewhere?

[David H]

Dave,

You might be overlooking the settings in the Windows Registry? Details at
https://wiki.gnucash.org/wiki/Configuration_Locations - snippet below

Cheers David H.

GSettings

Besides the directories and files described above GnuCash also stores a
number of user preferences in GSettings. This is a user level data store
for all kinds of preferences. Most of what is found under Edit->Preferences and
a few extra ones are stored in there. GSettings itself doesn't have a
particular location to store this information in. Instead it relies on
"backends" to do this on its behalf. Which backend is used depends on the
platform:
Linuxpristinedconf - there's no file location associated with this, data
can be viewed or edited with dconf-editor. For advanced options see dconf
help.Flatpak Since Gnucash 4.7keyfile —
file with settings in ini format 
 is $HOME/.var/app/org.gnucash.GnuCash/config/glib-2.0/settings/keyfile4.5
and 4.6keyfile — file with settings is
$HOME/.var/app/org.gnucash/config/glib-2.0/settings/keyfile4.4 and older
dconf — these versions share the settings on the host system so the same
location is used hereWindowsregistry — there's no file location associated
with this, data can be viewed or edited with *regedit*. In *regedit* the
GSettings data for gnucash can be found underSince Gnucash 4.7
HKEY_CURRENT_USER\Software\GSettings\org\gnucash\GnuCash.Up to Gnucash 4.6
HKEY_CURRENT_USER\Software\GSettings\org\gnucash.macOSplists — stored inSince
Gnucash 4.7$HOME/Library/Preferences/org.gnucash.GnuCash.plist,4.6 and older
$HOME/Library/Preferences/org.gnucash.plist.Copy the file for backing up or
transferring. But don't edit it directly, use *defaults*.



On Sat, 7 Jan 2023 at 07:11, Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> A week or two ago I managed to do something that meant invoices and bills
> looked silly. Today I upgraded to GnuCash 4.13 on Windoze, and the problem
> persisted. So I used the uninstall tool. That did not seem to delete all
> the directories, so I deleted the directories C:\Program
> Files(x86)\gnucash, as well as C:\Users\44719\AppData\Roading\GnuCash (For
> reasons I don't know, my use id on this laptop seems to be 44719. That's
> nothing specific to GnuCash).
>
> Then I reinstalled GnuCash 4.13 again. The bills and invoices still looked
> silly. So I created a new set of accounts, with some silly company names,
> and still they look silly - see attachment.
>
> I'm guessing there's some style sheet hiding somewhere, but I don't know
> where it is.
>
> BTW, I noticed that GnuCash version 4.13 does not have an uninstall
> program, whereas version 4.12 has. I'm not sure if that's intentional or
> not.
>
> Dr David Kirkby Ph.D
> Email: drkir...@kirkbymicrowave.co.uk Web:
> https://www.kirkbymicrowave.co.uk/
> Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
> Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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 assistance

[Karl]

Hi there John,

Thanks for the information. Very helpful! Perhaps I am setting up my
foreign (USD) investment accounts all wrong. I'm trying to follow the
instructions and examples in Chapters 9.5 and 9.6, but I can't
reconcile the instructions with your explanation.

So if I set-up the account structure as you described:

Assets
Investments
Stocks
Stocks-USD
AAPL

 ... when I go to make an initial purchase of AAPL shares/stock, do I enter
the transaction in CAD or USD? For example, AAPL closed at $129.62 USD
today, so if I bought 10 stocks, should my entry be:

DR AAPL stock  1,296.20 (USD)
  CR Cash 1,296.20 (USD)

or should it be:

DR AALP stock  1,736.91 (CAD)
  CR Cash  1,736.91 (CAD)

???

CAD-USD was at $1.00 USD = $1.34 CAD.


Ideally, when I run the "Advanced Portfolio" Report, I would like for what
I'm seeing to be in CAD. Is this possible?

Thanks again for your help. As you can probably tell, I'm terrible with
computers, but not too bad with accounting! haha

Regards,

*Karl*


On Fri, 6 Jan 2023 at 13:12, john  wrote:

> That's a very long-running discussion with another Canadian CPA, see
> https://bugs.gnucash.org/show_bug.cgi?id=797796
> and https://bugs.gnucash.org/show_bug.cgi?id=798004.
>
> The simplest workaround is to set up an account structure that looks like
> Assets
> Investments
> Stocks
> Stocks-USD
> AAPL
>
> As long as you keep the priceDB updated with both CAD-USD exchange rates
> and AAPL prices the Stocks account will show the value of the AAPL shares
> in CAD. Unfortunately if you have several USD stocks and want to track them
> individually you'd need to do something like
> Stock-AAPL-CAD
> Stock-AAPL-USD
> AAPL
> Stock-GOOG-CAD
> Stock-GOOG-USD
> GOOG
>
> Which could be a bit tiresome. An alternative is to set things up as you
> would normally, i.e.
> Assets
> Investments
> Cash
> Stocks-USD
> AAPL
> GOOG
>
> and use the Advanced Portfolio Report to show the values in CAD.
>
> I don't understand what you mean by "the currency exchange function", but
> if you want to retrieve the CAD-USD exchange rate you need to get an
> Alphavantage API key. The issue in bug 798599 is resolved because
> Alphavantage put currency exchange rates back to being available with a
> free API key. F::Q version 1.53 switched to a different retrieval method
> that broke retrieving precious metal rates (e.g. XAU-CAD) so if that's your
> concern you need a F::Q version that isn't 1.53; the current release is
> 1.54.
>
> Regards,
> John Ralls
>
>
> On Jan 6, 2023, at 6:05 AM, Karl  wrote:
>
> Hello David and everyone,
>
> Thank you for your messages. A little background about myself: I'm a
> Canadian (born and raised), and a CPA. I have been using GnuCash for a
> while now, but am interested in delving deeper into its functions that can
> be useful to me. I use GnuCash only for personal and private use for my
> household, not for business purposes in any way.
>
> I am currently running Microsoft Windows 10 Pro (Build 19045) on my main
> machine at home, and am using GnuCash Version 4.10 with "Finance::Quote
> 1.54" and perl (v5.32.1).
>
> I am enjoying the Chapter 9 - Investments part of GnuCash and have
> successfully set up the Automatic Online Retrieval of Stock Quotes. What a
> great function!
>
> The trouble is, I can't figure out a way to have any foreign investments
> denominated in my local currency (CAD). For example, if I invest in, let's
> say, Apple Inc (NASDAQ: AAPL), which is traded on the NASDAQ (a foreign
> market for me), the share(s) value only shows up in the currency of the
> market in which it is being traded (in this case, USD). How do I get
> GnuCash to denominate and show me my foreign investments in my local
> currency (CAD)?
>
> Not sure if this is related but, I also tried to set-up the currency
> exchange function, but it appears that this is no longer functional due to
> the API Key from Alphavantage. Is this true?
> https://bugs.gnucash.org/show_bug.cgi?id=798599
>
> Thank you everyone. Happy to see that there is a supportive and
> collaborative community here!
>
> Regards,
>
> *Karl*
>
>
> On Thu, 5 Jan 2023 at 20:07, David H  wrote:
>
> Welcome to gnucash Karl.
>
> I think from memory Nabble went away during the pandemic about 12 months
> ago, so maybe forget that one :-)  If you have any questions, post them
> here to the gnucash user list (gnucash-user@gnucash.org) and you'll get
> all the help you need.  Also just a heads up do NOT use reply to reply to
> individuals, use REPLY ALL so that everyone benefits and can contribute to
> the question at hand.  Also if you subscribe to the digest version and
> reply to something, update the subject to something meaningful don't just
> leave it as "Digest ..." which is pretty meaningless and trim any
> extraneous cruft out of the reply.
>
> Also it always helps to include what version of Gnucash you installed and
> on what OS as things vary a 

Re: [GNC] Request for Automatic Reconciliation Function

[Jim DeLaHunt]

Bite Gao:

Thank you for your feature request. And thank you for your second 
message, where you make your request clear enough that I finally 
understand it.


What I think you are requesting is that GnuCash's Reconciliation command 
add an option for GnuCash to read in a data file supplied by the bank. 
This data file has the same information as the bank's human-readable 
statement, but in a machine-readable form. GnuCash reads a starting and 
ending statement balance from the data file. Then GnuCash attempts to 
match each transaction in the data file with a transaction in the data 
file.  It does the equivalent of marking the matching transactions in 
the GnuCash register as tentatively reconciled, and ends by displaying a 
list of GnuCash and data file transactions which it could not match.  
This list might be empty. Then the human modifies the tentative 
reconciliations, or accepts them, and finishes the reconciliation. The 
final state of the Register after reconciliation with the aid of a data 
file is the same as after reconciliation by the human using the 
human-readable statement.


To me, the matching which this requires is not very different from what 
the Import Matcher does. So, if the data file is a format which GnuCash 
can read, say an OFX file or a CSV file with the right configuration, 
then it seems feasible to use a data file to help reconciliation. And, 
this request does not seem to require reading the human-readable content 
of a PDF file.


Bite Gao: do you have banks which provide statements as machine-readable 
data files?  If so, what format does the bank provide?   Do the start 
and end dates of the data file match the start and end dates of the 
human-readable statement? Does the bank certify that the data file has 
the same transaction and balance content as the human-readable 
statement, and is just as trustworthy?


Among my statements from banks, credit cards, and investment companies, 
all provide human-readable statements in PDF format. Most provide 
transaction data in CSV format, and only some provide data in OFX or QFX 
or QIF format.  Most provide data files with the same start and end 
dates as the human-readable statement, but some offer only my choice of 
arbitrary start and end date. I could choose dates  for a transaction 
data file which match a statement's dates. But none of my statement 
providers certify that the data files have the same content as the 
human-readable statement. If there were a difference, I am pretty sure 
they would tell me that the data file is wrong and the human-readable 
file is correct. And reconciling to an incorrect data file is not helpful.


Thus, I can imagine that — for me, with my present statements — reading 
in a transaction data file to help with reconciliation would turn a 
10-minute task into a 5-minute task in most cases, but not in all cases.


Bite Gao, do I understand you correctly?  What machine-readable data 
files do your banks provide? Maybe your banks offer options which mine 
do not offer.


Best regards,
    —Jim DeLaHunt

On 2023-01-05 17:50, Bite Gao wrote:

GnuCash Developers and Maintainers:
  Hello! While you have mentioned the requirement of human intervene 
in the reconciliation process, I do not see it contradicts with the 
presence of automatically reconciliation system.
  In a reconcile process, the accountant check the record in the 
account book with the record in the bank statement (or statement from 
other institution). He (or she) may found out that two record are 
identical, or he (or she) may found that some record are not 
identical. Only the latter requires human notice, since there its no 
point wasting time on reconciled accounting transactions. An automatic 
reconciliation system can load the digital statement from the 
institution, compares the statement with the transaction in the 
accounting book, and pinpoints the discrepancies out. Then human 
accountant could step in and perform manual operations, such as 
checking other vouchers, contact with banks, etc. In the situation of 
single user, the automatic reconcile system have no reason to block 
manual reconciliation.
  Besides, when I means "human err", I means that the accountant 
overlook an discrepancy and regards it as identical. People do not 
spend too much time on identical records, since major of the 
transaction would be in that state. However, it could cause severe 
consequences if there do have a discrepancy.

  Yours,

 Bite, Gao
Jan 6th, 2023

On 2023/1/5 12:03, Liz Dodd Wrote:

On Wed, 4 Jan 2023 15:42:41 +0800
Bite Gao  wrote:


    GnuCash Developers and Maintainers:
   Hello! While your software has done many tedious jobs previously
    done by
    accountants manually, it cannot automatically reconcile its
accounting data
    to the bank statement in its digital form. In my opinion, the
    automation of
    reconciliation is not only efficient but also accurate since it
reduces human-caused errors.
   I 

Re: [GNC] Is a screwed-up style sheet hiding somewhere?

[Adrien Monteleone]

You didn't like the looks of an invoice so you tried 
uninstall/re-install? Holy cow.


Since you don't specify what about the invoice you don't like, the best 
I can do is guess:


You're not a fan of your duplicated company name and info. That's 
certainly reasonable. I'm not sure why it would appear twice either. 
That's an easy fix though. (without a re-install or starting a new book!)


1. With the invoice report visible, click the Options button on the toolbar.

2. Open the Layout tab.

3. Set either Row 1 Left or Row 2 Right to 'empty space' as desired.

If you also don't like the fonts, that's handled in the CSS block and/or 
you may have set this intentionally via Edit > Stylesheets.


-
I don't think GnuCash ever had a specific 'uninstall' method outside of 
whatever your OS has. (in the case of Windows, that's in Settings > Apps 
- a.k.a 'add remove programs', then use the uninstall option)



Regards,
Adrien

Regards,
Adrien

On 1/6/23 3:10 PM, Dr. David Kirkby wrote:

A week or two ago I managed to do something that meant invoices and bills
looked silly. Today I upgraded to GnuCash 4.13 on Windoze, and the problem
persisted. So I used the uninstall tool. That did not seem to delete all
the directories, so I deleted the directories C:\Program
Files(x86)\gnucash, as well as C:\Users\44719\AppData\Roading\GnuCash (For
reasons I don't know, my use id on this laptop seems to be 44719. That's
nothing specific to GnuCash).

Then I reinstalled GnuCash 4.13 again. The bills and invoices still looked
silly. So I created a new set of accounts, with some silly company names,
and still they look silly - see attachment.

I'm guessing there's some style sheet hiding somewhere, but I don't know
where it is.

BTW, I noticed that GnuCash version 4.13 does not have an uninstall
program, whereas version 4.12 has. I'm not sure if that's intentional or
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] Where do I set the "Accounting Period" for reports?

[Adrien Monteleone]

There already is such a preference. It is the very first preference on 
the first tab.


Most reports (certainly annual ones) default to 'beginning of accounting 
period' and 'end of accounting period'.


The OP's issue is that preference by default is 'beginning/end of *this* 
year, and we're already in the year after the desired period for the 
reports. The solution is change the preference or used saved configs set 
to 'last year'. I have these called "Closing..." for each desired report 
and I know those are for the previous year. I only use them once a year 
in January.


Regards,
Adrien

On 1/6/23 2:41 PM, Stan Brown wrote:

I don't think there's a global setting for time period in reports. It
would be nice if there were -- why not enter an enhancement request?

I know it's a pain to set up a time period for each individual report,
but you only have to do it once (per report). And if you are smart about
it, you'll use settings like "start of previous month" or "end of
accounting period".

When you click "Save Report Configuration As", be sure to use some
reasonable naming convention, one that makes sense to 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.

[GNC] Is a screwed-up style sheet hiding somewhere?

[Dr. David Kirkby]

A week or two ago I managed to do something that meant invoices and bills
looked silly. Today I upgraded to GnuCash 4.13 on Windoze, and the problem
persisted. So I used the uninstall tool. That did not seem to delete all
the directories, so I deleted the directories C:\Program
Files(x86)\gnucash, as well as C:\Users\44719\AppData\Roading\GnuCash (For
reasons I don't know, my use id on this laptop seems to be 44719. That's
nothing specific to GnuCash).

Then I reinstalled GnuCash 4.13 again. The bills and invoices still looked
silly. So I created a new set of accounts, with some silly company names,
and still they look silly - see attachment.

I'm guessing there's some style sheet hiding somewhere, but I don't know
where it is.

BTW, I noticed that GnuCash version 4.13 does not have an uninstall
program, whereas version 4.12 has. I'm not sure if that's intentional or
not.

Dr David Kirkby Ph.D
Email: drkir...@kirkbymicrowave.co.uk Web:
https://www.kirkbymicrowave.co.uk/
Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.


Invoice-01-06_01_2023.pdf
Description: Adobe PDF document
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Adrien Monteleone]

Then set your accounting period to the desired range or else use Saved 
Configurations as needed.


But do note if you customize the Accounting Period to specific dates, 
you'll have to change it again next time.


The easiest option that requires the least amount of repetitive work is 
to leave the period as default, and used Saved Configs set to 'previous 
year'.


Regards,
Adrien

On 1/6/23 1:35 PM, Chris Green wrote:

On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote:

Chris,

Did you run a report then click on Options / General Tab - the reports I
run allow you to set the period for each report?


That's absolutely the last thing I want to do, I want the same period
for every report after entering it just once!



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Stan Brown]

On 2023-01-06 11:35, Chris Green wrote:
> On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote:
>> Chris,
>>
>> Did you run a report then click on Options / General Tab - the reports I
>> run allow you to set the period for each report?
>>
> That's absolutely the last thing I want to do, I want the same period
> for every report after entering it just once!

I don't think there's a global setting for time period in reports. It
would be nice if there were -- why not enter an enhancement request?

I know it's a pain to set up a time period for each individual report,
but you only have to do it once (per report). And if you are smart about
it, you'll use settings like "start of previous month" or "end of
accounting period".

When you click "Save Report Configuration As", be sure to use some
reasonable naming convention, one that makes sense to you.

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] Register column sizing

[Thomas Forrester]

To be honest, John, it's been a minute since I bothered to think about it.
For the most part, I guess I just leave columns alone.  I don't recall the
last time I've had to resize a column, and maybe that speaks kindly of the
width-memory the columns have at this point.  Or not.  Like I say, I don't
find myself needing to resize columns much.  But neither does that mean
I've never resized a column.  My recollection of those times is that it was
somewhat frustrating and counter intuitive.  As if it seemed to be doing
the sizing backwards or was somehow causing disruption to other column
widths.

I don't feel asking me what I think GnuCash is doing differently than
spreadsheets is going to give you any important information.  Rather, I
think you should be asking yourself, "what is GnuCash doing that is
different from how spreadsheets do it?"  After all, you came to us saying,
"There have been occasional complaints for many years about column width
sizing."  I hypothesize that at the root of these complaints is the
difference between the intuitive and well accepted behavior of spreadsheets
vs the, well, clumsy(?) way GnuCash is doing it.

If GnuCash starts behaving like a spreadsheet in this regard, I would
expect all the grumbling to go away.  Or at the very least you could say
you're standing on the shoulders of giants like Excel, LibreOffice Calc,
etc, in doing it how they do it so as to bring an established standard to
the table.

Thanks.
Tom


On Fri, Jan 6, 2023 at 1:31 PM john  wrote:

> With the exception of the Description field automatically resizing itself
> to fit the register in the window width, I think GnuCash does size columns
> the same way spreadsheets do: You put the pointer on the right-hand divider
> in the header and drag it, and double-click in the header to fit the width
> to the widest entry in that column. What do you think spreadsheets do
> differently?
>
> Regards,
> John Ralls
>
>
> On Jan 6, 2023, at 5:37 AM, Thomas Forrester 
> wrote:
>
> I realize I'm answering a slightly different question, but I've never
> understood why the GnuCash developers have never made column sizing (and
> apparently hiding, too) work just like spreadsheets.  We already invented
> that wheel, and people are *really* accustomed to how it works, hence the
> grumbling when it's discovered by new GnuCash users that it doesn't work
> that way here.  I think the vast majority would agree that the way
> spreadsheet columns work is a very mature, and well understood "technology"
> (for lack of a better word) that has become ubiquitous and intuitive.  Note
> also that I said "spreadsheets" rather than, say, "Excel" because the way
> spreadsheet columns work isn't specific to any one spreadsheet program, and
> once again speaks to how universal handling spreadsheet columns has become.
>
> My guess is that what you're asking is likely just fine, but isn't it just
> another band-aid that really would be better ripped off in favor of
> spreadsheet-like resizing logic?
>
> Tom
> Thomas L. Forrester
> Middleton, WI USA
>
>
> On Thu, Jan 5, 2023 at 9:42 PM john  wrote:
>
>> Users,
>>
>> There have been occasional complaints for many years about column width
>> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
>> Most users seem to eventually get used to it, but I wonder if anybody
>> really likes it.
>>
>> The problem boils down to the auto-sizing behavior of the Description
>> column, which causes that column to grow or shrink when you adjust the
>> window's width, and to make a horizontal scrollbar appear when you widen
>> another column. Occasionally someone will complain about the normally
>> hidden price column because it's possible to catch its handle and widen it
>> when you mean to widen the balance column.
>>
>> It would be really easy to turn off autosizing on the Description field
>> and only a little work to figure out another way to handle the price and
>> ditch that column. Would anyone miss it?
>>
>> Regards,
>> John Ralls
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bank reconciliation after messy migration

[David H]

This, with one minor change - If you're happy that everything is 100% just
reconcile up to your latest statement closing balance and date.  Ignore the
Gnucash generated starting balance because when all said and done it's all
about the final closing balance.

Cheers David H.


On Sat, 7 Jan 2023 at 04:59, Fred Tydeman  wrote:

> Here is a fast way to Reconcile everything (not what you asked for, but it
> might help)
>
> Reconcile
>  "t" in Statement date == Today
>  Left click OK
>  Ctrl-A == Select All items in Funds In column
>  Space == Mark as Reconciled
>  Tab == Move to Funds Out column
>  Ctrl-A == Select All items in Funds Out column
>  Space == Mark as Reconciled
>  Left click Finish
>
> On Fri, Jan 6, 2023 at 10:08 AM Eric Hammond  wrote:
>
> >
> > I have finally completed replacing Quicken with GnuCash.
> > One of the casualties is my ability to reconcile my bank account.
> > The account covers from 2014 to present, and matches all bank statements
> > and balances properly.
> > The reconciliation function opens but starts at some random date and
> > incorrect beginning balance.
> > Is there a way to reset the reconciliation to all unreconciled  and start
> > fresh?
> >
> > Alternatively, can I repair this using NotePad++?  Which entries need to
> > be changed, and which ones should not be messed with?
> > (I am fine with a bit of slow tedious work)
> >
> > Thanks for all help,
> > Eric H.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Chris Green]

On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote:
> Chris,
> 
> Did you run a report then click on Options / General Tab - the reports I
> run allow you to set the period for each report?
> 
That's absolutely the last thing I want to do, I want the same period
for every report after entering it just once!

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Select correct database for plot and explorer gui widgets

[john]

> On Jan 5, 2023, at 10:11 PM, Ben Pracht  wrote:
> 
> Hi,
> 
> I really like having the convenience of an inline plotter, but the plot
> widget only allows me to select
> the X and Y values from I think is the OOTB country database. How can I
> select a different database for this widget? It seems like somewhere there
> should be a database selection drop down for it.

Is this posted to the wrong mailing list?

If it's about GnuCash, what inline plotter and what's an OOTB country database?

Regards,
John Ralls

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

Re: [GNC] Register column sizing

[john]

With the exception of the Description field automatically resizing itself to 
fit the register in the window width, I think GnuCash does size columns the 
same way spreadsheets do: You put the pointer on the right-hand divider in the 
header and drag it, and double-click in the header to fit the width to the 
widest entry in that column. What do you think spreadsheets do differently?

Regards,
John Ralls


> On Jan 6, 2023, at 5:37 AM, Thomas Forrester  wrote:
> 
> I realize I'm answering a slightly different question, but I've never 
> understood why the GnuCash developers have never made column sizing (and 
> apparently hiding, too) work just like spreadsheets.  We already invented 
> that wheel, and people are *really* accustomed to how it works, hence the 
> grumbling when it's discovered by new GnuCash users that it doesn't work that 
> way here.  I think the vast majority would agree that the way spreadsheet 
> columns work is a very mature, and well understood "technology" (for lack of 
> a better word) that has become ubiquitous and intuitive.  Note also that I 
> said "spreadsheets" rather than, say, "Excel" because the way spreadsheet 
> columns work isn't specific to any one spreadsheet program, and once again 
> speaks to how universal handling spreadsheet columns has become.
> 
> My guess is that what you're asking is likely just fine, but isn't it just 
> another band-aid that really would be better ripped off in favor of 
> spreadsheet-like resizing logic?
> 
> Tom
> Thomas L. Forrester
> Middleton, WI USA
> 
> 
> On Thu, Jan 5, 2023 at 9:42 PM john  > wrote:
>> Users,
>> 
>> There have been occasional complaints for many years about column width 
>> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588. Most 
>> users seem to eventually get used to it, but I wonder if anybody really 
>> likes it.
>> 
>> The problem boils down to the auto-sizing behavior of the Description 
>> column, which causes that column to grow or shrink when you adjust the 
>> window's width, and to make a horizontal scrollbar appear when you widen 
>> another column. Occasionally someone will complain about the normally hidden 
>> price column because it's possible to catch its handle and widen it when you 
>> mean to widen the balance column.
>> 
>> It would be really easy to turn off autosizing on the Description field and 
>> only a little work to figure out another way to handle the price and ditch 
>> that column. Would anyone miss it?
>> 
>> Regards,
>> John Ralls
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Bank reconciliation after messy migration

[David Carlson]

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

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

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

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

Re: [GNC] NEw user assistance

[john]

That's a very long-running discussion with another Canadian CPA, see 
https://bugs.gnucash.org/show_bug.cgi?id=797796
and https://bugs.gnucash.org/show_bug.cgi?id=798004.

The simplest workaround is to set up an account structure that looks like
Assets
Investments
Stocks
Stocks-USD
AAPL

As long as you keep the priceDB updated with both CAD-USD exchange rates and 
AAPL prices the Stocks account will show the value of the AAPL shares in CAD. 
Unfortunately if you have several USD stocks and want to track them 
individually you'd need to do something like
Stock-AAPL-CAD
Stock-AAPL-USD
AAPL
Stock-GOOG-CAD
Stock-GOOG-USD
GOOG

Which could be a bit tiresome. An alternative is to set things up as you would 
normally, i.e.
Assets
Investments
Cash
Stocks-USD
AAPL
GOOG

and use the Advanced Portfolio Report to show the values in CAD.

I don't understand what you mean by "the currency exchange function", but if 
you want to retrieve the CAD-USD exchange rate you need to get an Alphavantage 
API key. The issue in bug 798599 is resolved because Alphavantage put currency 
exchange rates back to being available with a free API key. F::Q version 1.53 
switched to a different retrieval method that broke retrieving precious metal 
rates (e.g. XAU-CAD) so if that's your concern you need a F::Q version that 
isn't 1.53; the current release is 1.54.

Regards,
John Ralls


> On Jan 6, 2023, at 6:05 AM, Karl  wrote:
> 
> Hello David and everyone,
> 
> Thank you for your messages. A little background about myself: I'm a
> Canadian (born and raised), and a CPA. I have been using GnuCash for a
> while now, but am interested in delving deeper into its functions that can
> be useful to me. I use GnuCash only for personal and private use for my
> household, not for business purposes in any way.
> 
> I am currently running Microsoft Windows 10 Pro (Build 19045) on my main
> machine at home, and am using GnuCash Version 4.10 with "Finance::Quote
> 1.54" and perl (v5.32.1).
> 
> I am enjoying the Chapter 9 - Investments part of GnuCash and have
> successfully set up the Automatic Online Retrieval of Stock Quotes. What a
> great function!
> 
> The trouble is, I can't figure out a way to have any foreign investments
> denominated in my local currency (CAD). For example, if I invest in, let's
> say, Apple Inc (NASDAQ: AAPL), which is traded on the NASDAQ (a foreign
> market for me), the share(s) value only shows up in the currency of the
> market in which it is being traded (in this case, USD). How do I get
> GnuCash to denominate and show me my foreign investments in my local
> currency (CAD)?
> 
> Not sure if this is related but, I also tried to set-up the currency
> exchange function, but it appears that this is no longer functional due to
> the API Key from Alphavantage. Is this true?
> https://bugs.gnucash.org/show_bug.cgi?id=798599
> 
> Thank you everyone. Happy to see that there is a supportive and
> collaborative community here!
> 
> Regards,
> 
> *Karl*
> 
> 
> On Thu, 5 Jan 2023 at 20:07, David H  wrote:
> 
>> Welcome to gnucash Karl.
>> 
>> I think from memory Nabble went away during the pandemic about 12 months
>> ago, so maybe forget that one :-)  If you have any questions, post them
>> here to the gnucash user list (gnucash-user@gnucash.org) and you'll get
>> all the help you need.  Also just a heads up do NOT use reply to reply to
>> individuals, use REPLY ALL so that everyone benefits and can contribute to
>> the question at hand.  Also if you subscribe to the digest version and
>> reply to something, update the subject to something meaningful don't just
>> leave it as "Digest ..." which is pretty meaningless and trim any
>> extraneous cruft out of the reply.
>> 
>> Also it always helps to include what version of Gnucash you installed and
>> on what OS as things vary a little from Windows to Linux to MacOS - so lets
>> start there, which is it ?
>> 
>> Cheers David H.
>> 
>> ps don't forget that "Reply All". :-)
>> 
>> 
>> On Fri, 6 Jan 2023 at 11:31, Karl  wrote:
>> 
>>> Hello there!
>>> 
>>> I am a new user to GnuCash and am looking for some assistance. I have
>>> subscribed to the mailing list and am attempting to access the Web Forum
>>> (Nabble) for further assistance from other users.
>>> 
>>> Specifically, I am trying to set-up the online pricing list for stock
>>> quotes.
>>> 
>>> Please assist. Thank you for your assistance.
>>> 
>>> Regards,
>>> 
>>> *Karl*
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> 

Re: [GNC] Bank reconciliation after messy migration

[Fred Tydeman]

Here is a fast way to Reconcile everything (not what you asked for, but it
might help)

Reconcile
 "t" in Statement date == Today
 Left click OK
 Ctrl-A == Select All items in Funds In column
 Space == Mark as Reconciled
 Tab == Move to Funds Out column
 Ctrl-A == Select All items in Funds Out column
 Space == Mark as Reconciled
 Left click Finish

On Fri, Jan 6, 2023 at 10:08 AM Eric Hammond  wrote:

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

Re: [GNC] Bank reconciliation after messy migration

[Eric Hammond]

I have finally completed replacing Quicken with GnuCash.
One of the casualties is my ability to reconcile my bank account.
The account covers from 2014 to present, and matches all bank statements and 
balances properly.
The reconciliation function opens but starts at some random date and incorrect 
beginning balance.
Is there a way to reset the reconciliation to all unreconciled  and start fresh?

Alternatively, can I repair this using NotePad++?  Which entries need to be 
changed, and which ones should not be messed with?
(I am fine with a bit of slow tedious work)

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

Re: [GNC] Register column sizing

[Adrien Monteleone]

That's a good question and one I've had myself.

It is even more perplexing when I discovered the registers are based on 
code from the Gnumeric spreadsheet app.


My wild and very limited understanding guess is:

That part of the UI didn't get borrowed from Gnumeric, maybe for a good 
reason. A large portion of the GnuCash controlling code is not separate 
from the viewing code. Perhaps Gnumeric has the same issue. This is 
likely a manifestation of that problem for at least one if not both of 
those apps.


-
That aside, I'm glad GnuCash doesn't make me enter a column size in 
measuring units! (as *if* a spreadsheet will always be printed)


I could be reading wrong, but I don't think John was suggesting dropping 
the ability to double-click to auto-fit columns to data, but rather 
dropping the rubber-band auto-size effect for the Description column.


That would leave us with drag to size (like spreadsheets) or auto-fit. 
(which spreadsheets can now do but taking more clicks)


Regards,
Adrien

On 1/6/23 7:37 AM, Thomas Forrester wrote:

I realize I'm answering a slightly different question, but I've never
understood why the GnuCash developers have never made column sizing (and
apparently hiding, too) work just like spreadsheets.  We already invented
that wheel, and people are *really* accustomed to how it works, hence the
grumbling when it's discovered by new GnuCash users that it doesn't work
that way here.  I think the vast majority would agree that the way
spreadsheet columns work is a very mature, and well understood "technology"
(for lack of a better word) that has become ubiquitous and intuitive.  Note
also that I said "spreadsheets" rather than, say, "Excel" because the way
spreadsheet columns work isn't specific to any one spreadsheet program, and
once again speaks to how universal handling spreadsheet columns has become.

My guess is that what you're asking is likely just fine, but isn't it just
another band-aid that really would be better ripped off in favor of
spreadsheet-like resizing logic?


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

Re: [GNC] Sort order not being maintained

[Adrien Monteleone]

I just tested using 4.13 on Mac. It works properly there.

I tested closing the register I sorted, then re-opening.
I then tested closing GnuCash and re-opening.

In both cases, the sort order was retained. (I tested with your options 
of Date, Reverse, & Save)


Try 4.13?

Regards,
Adrien

On 1/6/23 8:46 AM, Dr. David Kirkby wrote:

I'm running GnuCash 4.12 on both linux and Windoze - mainly on Windoze
laptop, as my desktop PC uses 200 W of power when idle, plus whatever the
monitor uses.

I keep sorting the bank account, or other accounts, but the sort order
keeps being lost, despite me ticking the box to keep the sort order. See
attachment.

Is there anyway I can set this sort order for every account once and forget
it?


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

Re: [GNC] another beginner question

[Simon Roberts]

That does make sense, thanks again Derek.

Cheers,
Simon

On Thu, Jan 5, 2023 at 5:54 PM Derek Atkins  wrote:

> Well, if you put your O-B on all your Assets and Liabilities, then yes,
> that *IS* your current equity in the company.
>
> If you think the balance is too big, then most likely you haven't added
> all your liabilities.
>
> Keep in mind that Income and Expense are actually Equity-type accounts, in
> the sense that In & Ex affect your instantaneous equity.  So when you
> restart, you are rolling up a decade of equity built via Income (-
> Expense).
>
> Hope this helps,
>
> -derek
>
> On Thu, January 5, 2023 7:28 pm, Simon Roberts wrote:
> > Right now I have set up my transition from quickbucks to Gnc such that
> all
> > the bank accounts have an opening balance, which is drawn from
> > "Equity:Opening Balances". However, I think that's ... wrong/misleading,
> > in
> > that this is most definitely not money I just handed over to create the
> > business. It's been running 18 year, and it's just that the transition to
> > this software is happening now. it makes the balance sheet look like I
> > have
> > a bunch more equity in there than perhaps I really do (although I'm a
> > single-owner LLC, so I'm not really sure!)
> >
> > Is there a better way to create those opening balances that makes better
> > sense, or is this really the right way to do it?
> >
> > Thanks for any guidance/suggestions!
> > Simon
> >
> > --
> > Simon Roberts
> > (303) 249 3613
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>

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

Re: [GNC] Register column sizing

[William Prescott]

Another vote in favor of this change to the column width handling,

Best wishes,
Will


On Jan 6, 2023, at 08:45, Matthew Forbis via gnucash-user 
 wrote:

I'm fully in agreement of making the description column behave like all the 
others.
Matt
   On Thursday, January 5, 2023 at 09:41:58 PM CST, john  
wrote:  

Users,

There have been occasional complaints for many years about column width sizing. 
See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588. Most users seem 
to eventually get used to it, but I wonder if anybody really likes it.

The problem boils down to the auto-sizing behavior of the Description column, 
which causes that column to grow or shrink when you adjust the window's width, 
and to make a horizontal scrollbar appear when you widen another column. 
Occasionally someone will complain about the normally hidden price column 
because it's possible to catch its handle and widen it when you mean to widen 
the balance column.

It would be really easy to turn off autosizing on the Description field and 
only a little work to figure out another way to handle the price and ditch that 
column. Would anyone miss it?

Regards,
John Ralls

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

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

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

[GNC] Sort order not being maintained

[Dr. David Kirkby]

I'm running GnuCash 4.12 on both linux and Windoze - mainly on Windoze
laptop, as my desktop PC uses 200 W of power when idle, plus whatever the
monitor uses.

I keep sorting the bank account, or other accounts, but the sort order
keeps being lost, despite me ticking the box to keep the sort order. See
attachment.

Is there anyway I can set this sort order for every account once and forget
it?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Register column sizing

[Matthew Forbis via gnucash-user]

 I'm fully in agreement of making the description column behave like all the 
others.
Matt
On Thursday, January 5, 2023 at 09:41:58 PM CST, john  
wrote:  
 
 Users,

There have been occasional complaints for many years about column width sizing. 
See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588. Most users seem 
to eventually get used to it, but I wonder if anybody really likes it.

The problem boils down to the auto-sizing behavior of the Description column, 
which causes that column to grow or shrink when you adjust the window's width, 
and to make a horizontal scrollbar appear when you widen another column. 
Occasionally someone will complain about the normally hidden price column 
because it's possible to catch its handle and widen it when you mean to widen 
the balance column.

It would be really easy to turn off autosizing on the Description field and 
only a little work to figure out another way to handle the price and ditch that 
column. Would anyone miss it?

Regards,
John Ralls

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

Re: [GNC] Register column sizing

[ml]

I’m new to GnuCash so I admit I’m not sure I fully understand the question’s 
impacts.

I have figured out I can resize each column manually, but what does confuse me 
is why (at least on macOS) a double click (as opposed to a right-click) 
activates what I believe you’re referring to as autosizing. 

Nonetheless, I can get used to that. But, I would expect that if I double click 
on the column a second time, it should revert to the earlier size, no?

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

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

Re: [GNC] Where do I set the "Accounting Period" for reports?

[Michael or Penny Novack]

On 1/6/2023 6:11 AM, Chris Green wrote:

On Fri, Jan 06, 2023 at 12:31:46PM +0300, David T. via gnucash-user wrote:

There is also a setting in preferences somewhere to change the accounting
period. As I don't use the feature, I don't know where it is in either
the general preferences or the file preferences.


Yes, that's where it is.  Why isn't it with the other report options?


Gnucash is not necessarily running in real time.

It is much better/safer to assume that you will be setting the effective 
date of each report as you run it and not do this by "accounting 
period". If you used the latter, you would have to remember to reset 
that whenever NOT wanting "current accounting period". For example, I am 
rarely running year end reports New Year's Eve but instead, a couple 
days later.


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] Request for Automatic Reconciliation Function

[johnny]

hi

On 1/6/23 09:16, David T. via gnucash-user wrote:

Call me old school, but I want to check that the bank and I agree on the 
accounting, and I consider me to be the best judge of my transaction history.


isn't that the whole *point* of reconciliation after all ... ?

(so i would call you "careful" before "old school" (but i'm not prone to 
name caling anyway))

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

Re: [GNC] Register column sizing

[David T. via gnucash-user]

I think both changes would be excellent. As another person has noted, most 
people expect GnuCash columns to behave like a spreadsheet, and the Description 
column trips them up. And if the Price column doesn't have to be there, 
removing it will be beneficial as well. 

⁣David T. ​

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

Re: [GNC] Request for Automatic Reconciliation Function

[David T. via gnucash-user]

I agree with Adrien here fully, as well as with other points made elsewhere in 
the thread. 

As an open source software package, it's certainly possible for *someone* to 
write code for an automatic reconciliation, but I certainly wouldn't want the 
feature myself. Call me old school, but I want to check that the bank and I 
agree on the accounting, and I consider me to be the best judge of my 
transaction history. 

⁣David T. ​

On Jan 6, 2023, 3:59 PM, at 3:59 PM, Adrien Monteleone 
 wrote:
>I understand your explanation, but if you aren't checking and verifying
>
>every transaction, how do you ever discover when the automated process 
>makes a mistake?
>
>Reconciliation was invented long before computers, but I appreciate
>that 
>the process demands one to slow down, take your time, and methodically 
>verify the information.
>
>Think of it as proof-reading - the hard way. (I learned in school to 
>read stuff backwards when proofing!)
>
>That is a pretty good analogy too:
>
>If you've ever used auto-correct with auto-checking for spelling and 
>grammar, or auto-suggestion or auto-completion for entire words and
>have 
>seen the embarrassment and/or nightmare that can produce when the 
>computer 'gets it wrong', would you want something like that for your 
>financial records?
>
>Regards,
>Adrien
>
>On 1/5/23 7:50 PM, Bite Gao wrote:
>> GnuCash Developers and Maintainers:
>>    Hello! While you have mentioned the requirement of human intervene
>in 
>> the reconciliation process, I do not see it contradicts with the 
>> presence of automatically reconciliation system.
>>    In a reconcile process, the accountant check the record in the 
>> account book with the record in the bank statement (or statement from
>
>> other institution). He (or she) may found out that two record are 
>> identical, or he (or she) may found that some record are not
>identical. 
>> Only the latter requires human notice, since there its no point
>wasting 
>> time on reconciled accounting transactions. An automatic
>reconciliation 
>> system can load the digital statement from the institution, compares
>the 
>> statement with the transaction in the accounting book, and pinpoints
>the 
>> discrepancies out. Then human accountant could step in and perform 
>> manual operations, such as checking other vouchers, contact with
>banks, 
>> etc. In the situation of single user, the automatic reconcile system 
>> have no reason to block manu
>> al reconciliation.
>>    Besides, when I means "human err", I means that the accountant 
>> overlook an discrepancy and regards it as identical. People do not
>spend 
>> too much time on identical records, since major of the transaction
>would 
>> be in that state. However, it could cause severe consequences if
>there 
>> do have a discrepancy.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/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 assistance

[Karl]

Hello David and everyone,

Thank you for your messages. A little background about myself: I'm a
Canadian (born and raised), and a CPA. I have been using GnuCash for a
while now, but am interested in delving deeper into its functions that can
be useful to me. I use GnuCash only for personal and private use for my
household, not for business purposes in any way.

I am currently running Microsoft Windows 10 Pro (Build 19045) on my main
machine at home, and am using GnuCash Version 4.10 with "Finance::Quote
1.54" and perl (v5.32.1).

I am enjoying the Chapter 9 - Investments part of GnuCash and have
successfully set up the Automatic Online Retrieval of Stock Quotes. What a
great function!

The trouble is, I can't figure out a way to have any foreign investments
denominated in my local currency (CAD). For example, if I invest in, let's
say, Apple Inc (NASDAQ: AAPL), which is traded on the NASDAQ (a foreign
market for me), the share(s) value only shows up in the currency of the
market in which it is being traded (in this case, USD). How do I get
GnuCash to denominate and show me my foreign investments in my local
currency (CAD)?

Not sure if this is related but, I also tried to set-up the currency
exchange function, but it appears that this is no longer functional due to
the API Key from Alphavantage. Is this true?
https://bugs.gnucash.org/show_bug.cgi?id=798599

Thank you everyone. Happy to see that there is a supportive and
collaborative community here!

Regards,

*Karl*


On Thu, 5 Jan 2023 at 20:07, David H  wrote:

> Welcome to gnucash Karl.
>
> I think from memory Nabble went away during the pandemic about 12 months
> ago, so maybe forget that one :-)  If you have any questions, post them
> here to the gnucash user list (gnucash-user@gnucash.org) and you'll get
> all the help you need.  Also just a heads up do NOT use reply to reply to
> individuals, use REPLY ALL so that everyone benefits and can contribute to
> the question at hand.  Also if you subscribe to the digest version and
> reply to something, update the subject to something meaningful don't just
> leave it as "Digest ..." which is pretty meaningless and trim any
> extraneous cruft out of the reply.
>
> Also it always helps to include what version of Gnucash you installed and
> on what OS as things vary a little from Windows to Linux to MacOS - so lets
> start there, which is it ?
>
> Cheers David H.
>
> ps don't forget that "Reply All". :-)
>
>
> On Fri, 6 Jan 2023 at 11:31, Karl  wrote:
>
>> Hello there!
>>
>> I am a new user to GnuCash and am looking for some assistance. I have
>> subscribed to the mailing list and am attempting to access the Web Forum
>> (Nabble) for further assistance from other users.
>>
>> Specifically, I am trying to set-up the online pricing list for stock
>> quotes.
>>
>> Please assist. Thank you for your assistance.
>>
>> Regards,
>>
>> *Karl*
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Register column sizing

[Michael or Penny Novack]

On 1/6/2023 12:46 AM, David Carlson wrote:

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

This is essentially an artifact of being able to enter transactions in 
"register view" rather than in "journal view".


In the traditional journal entry (old days) there would be a header line 
with date (and check number in case a payment). Then indicated by a 
specified indentation a line for each debit account, then at a further 
indentation, a line for each credit account, then at a still further 
indentation, as many lines as wanted for the description. In other 
words, the indication that a debit account line, a credit account line, 
or description line indicated by the amount of indentation. This imposed 
no size limit on description. Now a bookkeeping app COULD have been 
coded to mirror that (and then when the transaction complete, auto-post 
to the ledger)


But people would miss the shortcut of being able to enter directly into 
the ledger as >90% of transactions only affecting two accounts and not 
having long descriptions.


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] Register column sizing

[Glenn Fowler]

Maybe a setting in Preferences -> Register Defaults  to toggle the option?


On Fri, Jan 6, 2023 at 8:32 AM Fross, Michael  wrote:

> Hi John.  I enjoy the ability to double click column headers to auto-size
> them.  I hope this is not impacted.
>
> For description autosizing, it did take a little getting used to, but I
> like it and use it.  I manage the other columns, mostly by double clicking
> the title, and then let the description column fill in the rest.
>
> Michael
>
>
> On Fri, Jan 6, 2023 at 6:32 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
> > I don't play with it too often these days, but if I do, I won't miss the
> > auto-size or accidentally exposing the price column.
> >
> > Regards,
> > Adrien
> >
> > On 1/5/23 9:40 PM, john wrote:
> > > It would be really easy to turn off autosizing on the Description field
> > and only a little work to figure out another way to handle the price and
> > ditch that column. Would anyone miss it?
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/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] Register column sizing

[Thomas Forrester]

I realize I'm answering a slightly different question, but I've never
understood why the GnuCash developers have never made column sizing (and
apparently hiding, too) work just like spreadsheets.  We already invented
that wheel, and people are *really* accustomed to how it works, hence the
grumbling when it's discovered by new GnuCash users that it doesn't work
that way here.  I think the vast majority would agree that the way
spreadsheet columns work is a very mature, and well understood "technology"
(for lack of a better word) that has become ubiquitous and intuitive.  Note
also that I said "spreadsheets" rather than, say, "Excel" because the way
spreadsheet columns work isn't specific to any one spreadsheet program, and
once again speaks to how universal handling spreadsheet columns has become.

My guess is that what you're asking is likely just fine, but isn't it just
another band-aid that really would be better ripped off in favor of
spreadsheet-like resizing logic?

Tom
Thomas L. Forrester
Middleton, WI USA


On Thu, Jan 5, 2023 at 9:42 PM john  wrote:

> Users,
>
> There have been occasional complaints for many years about column width
> sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
> Most users seem to eventually get used to it, but I wonder if anybody
> really likes it.
>
> The problem boils down to the auto-sizing behavior of the Description
> column, which causes that column to grow or shrink when you adjust the
> window's width, and to make a horizontal scrollbar appear when you widen
> another column. Occasionally someone will complain about the normally
> hidden price column because it's possible to catch its handle and widen it
> when you mean to widen the balance column.
>
> It would be really easy to turn off autosizing on the Description field
> and only a little work to figure out another way to handle the price and
> ditch that column. Would anyone miss it?
>
> Regards,
> John Ralls
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Register column sizing

[Fross, Michael]

Hi John.  I enjoy the ability to double click column headers to auto-size
them.  I hope this is not impacted.

For description autosizing, it did take a little getting used to, but I
like it and use it.  I manage the other columns, mostly by double clicking
the title, and then let the description column fill in the rest.

Michael


On Fri, Jan 6, 2023 at 6:32 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> I don't play with it too often these days, but if I do, I won't miss the
> auto-size or accidentally exposing the price column.
>
> Regards,
> Adrien
>
> On 1/5/23 9:40 PM, john wrote:
> > It would be really easy to turn off autosizing on the Description field
> and only a little work to figure out another way to handle the price and
> ditch that column. Would anyone miss it?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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] Where do I set the "Accounting Period" for reports?

[Adrien Monteleone]

That also happens to be the very FIRST preference overall.

First tab of Preferences, first preference.

You'd have to really not be looking top-down or in any order to miss it.

Regards,
Adrien

On 1/6/23 3:51 AM, David H wrote:

Yeah it's Prefs >> Accounting Period - not sure if that's used by reports
or just for registers ?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Request for Automatic Reconciliation Function

[Adrien Monteleone]

I understand your explanation, but if you aren't checking and verifying 
every transaction, how do you ever discover when the automated process 
makes a mistake?


Reconciliation was invented long before computers, but I appreciate that 
the process demands one to slow down, take your time, and methodically 
verify the information.


Think of it as proof-reading - the hard way. (I learned in school to 
read stuff backwards when proofing!)


That is a pretty good analogy too:

If you've ever used auto-correct with auto-checking for spelling and 
grammar, or auto-suggestion or auto-completion for entire words and have 
seen the embarrassment and/or nightmare that can produce when the 
computer 'gets it wrong', would you want something like that for your 
financial records?


Regards,
Adrien

On 1/5/23 7:50 PM, Bite Gao wrote:

GnuCash Developers and Maintainers:
   Hello! While you have mentioned the requirement of human intervene in 
the reconciliation process, I do not see it contradicts with the 
presence of automatically reconciliation system.
   In a reconcile process, the accountant check the record in the 
account book with the record in the bank statement (or statement from 
other institution). He (or she) may found out that two record are 
identical, or he (or she) may found that some record are not identical. 
Only the latter requires human notice, since there its no point wasting 
time on reconciled accounting transactions. An automatic reconciliation 
system can load the digital statement from the institution, compares the 
statement with the transaction in the accounting book, and pinpoints the 
discrepancies out. Then human accountant could step in and perform 
manual operations, such as checking other vouchers, contact with banks, 
etc. In the situation of single user, the automatic reconcile system 
have no reason to block manu

al reconciliation.
   Besides, when I means "human err", I means that the accountant 
overlook an discrepancy and regards it as identical. People do not spend 
too much time on identical records, since major of the transaction would 
be in that state. However, it could cause severe consequences if there 
do have a discrepancy.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Adrien Monteleone]

I'll follow up that if you've left the default Accounting Period defined 
as 'Start of this Year/End of this Year' and you try to run your annual 
reports in the following year, such as today for 2022, yes, the range 
will be wrong.


As I noted in my other reply, use Saved Report Configs. Get the other 
Options how you want them for this particular report, then set the 
General date range to be 'previous year start/end' and then you don't 
have to redo that every year, just run the saved config again.


Regards,
Adrien

On 1/6/23 3:06 AM, Chris Green wrote:

Every year when I want to print annual reports I have this problem.

I can never find where to set the 'accounting period' for reports.

Where is it please?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Adrien Monteleone]

No, if you set the period in Preferences, it remembers it. Do a test and 
set specific odd dates here and run an annual-style report before and 
after doing so.


If you change a report's Options to something other than "beginning/end 
of this period" which is usually the default for most reports, then no, 
of course it isn't sticky. You changed it for just that one report.


The Options button is *for just that report* already visible in the 
current tab.


If you want to save a set of options to reuse for a particular report, 
then create a Saved Report Configuration.


There are no generic Options you can customize for all reports at once, 
save whatever lives in Preferences.


Regards,
Adrien

On 1/6/23 5:10 AM, Chris Green wrote:

On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote:

Chris,

Did you run a report then click on Options / General Tab - the reports I
run allow you to set the period for each report?


... and then forgets it for the next report as far as I can see.



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

Re: [GNC] Why can't I set 'selcted' accounts for reports permananently?

[Adrien Monteleone]

That would depend on the report. For some, it makes sense that GnuCash 
doesn't know which accounts you want till you tell it. For others, there 
are sane defaults. (like the Income statement that already has Income & 
Expense accounts selected)


Some reports also behave a tad differently depending on how you invoke 
them. (from links in other reports, or from the Reports menu)


If this particular report will always require an account selection, and 
you want to save this, look into Saved Report Configurations. It is 
still a few more clicks to run a saved config, but not as bad as setting 
multiple options each time.


Regards,
Adrien

On 1/6/23 5:14 AM, Chris Green wrote:

Maybe I'm missing a setting somewhere, but every time I want to print
a report I have to go through the whole rigmarole of selecting all
accounts for the report.

Is there a way to get Gnucash to default to selecting *all* accounts
rather than no accounts?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Adrien Monteleone]

Maybe it is used for things other than reports?

Regards,
Adrien

On 1/6/23 5:11 AM, Chris Green wrote:

On Fri, Jan 06, 2023 at 12:31:46PM +0300, David T. via gnucash-user wrote:

There is also a setting in preferences somewhere to change the accounting
period. As I don't use the feature, I don't know where it is in either
the general preferences or the file preferences.


Yes, that's where it is.  Why isn't it with the other report options?



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

Re: [GNC] Register column sizing

[Adrien Monteleone]

I don't play with it too often these days, but if I do, I won't miss the 
auto-size or accidentally exposing the price column.


Regards,
Adrien

On 1/5/23 9:40 PM, john wrote:

It would be really easy to turn off autosizing on the Description field and 
only a little work to figure out another way to handle the price and ditch that 
column. Would anyone miss it?


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

Re: [GNC] QIF format for StkSplit

[ml]

Yes. In my GnuCash the original shares are removed in one transaction, and the 
newly calculated amount (based on the split) is added in a second transaction.

In my Quicken, when I recorded a split, the additional shares (in this case, a 
4 for 1 of APPL) were recorded. 

But my original question has more to do with what ratio I should put into the 
gif to properly record the split. What I’m getting to work is to multiply the 
ratio by 10 and that is what should be in the QIF.

For example, with Apple’s 4 for 1 split in 2020, the line in the QIF should be 
Q40.

> On Jan 5, 2023, at 19:24, Ken Farley  wrote:
> 
> When I was doing a bunch of Quicken conversions using QIF files, what 
> happened was pretty much what you described here, I think. My original shares 
> were removed in one transaction, while the split amount was added back. For 
> example, 200 shares that needed at 2 for 1 resulted in a 200 share removal 
> with a subsequent 400 share addition. Maybe this is how Quicken handled 
> splits "behind the scenes"?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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] Request for Automatic Reconciliation Function

[Dr. David Kirkby]

On Fri, 6 Jan 2023 at 01:50, Bite Gao  wrote:

> GnuCash Developers and Maintainers:


   Hello! While you have mentioned the requirement of human intervene in
the reconciliation process, I do not see it contradicts with the presence
of automatically reconciliation system.

   Yours,
>
>   Bite, Gao
> Jan 6th, 2023


I think this is a very tricky AI problem, and possibly the subject of a PhD
research degree.  There seems to be two aspects to this

1) Given a set of data from a bank, and a set of transactions entered into
GnuCash, is there any possibility that they could reconcile? Automatically
determining if reconciliation is impossible is probably not too tricky.

It might be computationally demanding, but a brute force method of trying
every possible combination of debits and credits could determine if
reconciliation is possible in one or more ways, or totally impossible.

No artificial intelligence is required - just brute force work. Some not
particularly difficult work could determine if reconciliation is impossible
without much work at all. For example, if a bank account has risen by more
than the sum of all the debts, ignoring all the credits.

2) Much more tricky would to determine if any possible combination of
matches is accurate. I think that would be a very tricky indeed.

Recently I had in my GnuCash account a payment to Mouser £113. The invoice
from Mouser said £113. A line in the bank statement showed £113, and said
Mouser on the same line. I reconciled that. Only later when I looked at the
PayPal account did I see that Mouser had been paid with PayPal. So the
money didn’t move directly from my bank account to Mouser, but via another
account I have. I suspect any automatic procedure would struggle with
issues like these unless all banks and similar places indicate information
in a well documented and internationally accepted manner.


Dave

> --
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] QIF format for StkSplit

[ml]

I appreciate the analysis of the code, and the confirmation of what I found 
through experimentation. I had tried searching the code for the answer, but I 
do not know C/C++ and I would not have been able to figure it out. 

I’d be happy to write a paragraph documenting how a QIF entry for a StkSplit 
import should be built, but I’m not sure where this should be included?

Tim


> On Jan 5, 2023, at 22:23, john  wrote:
> 
> gnc_numeric_create is a C function implemented in 
> libgnucash/engine/gnc-numeric.cpp and made available to Scheme by SWIG which 
> changes its name to gnc-numeric-create. It takes two int64_t arguments, 
> numerator and denominator.
> 
> There's a general convention that public functions defined in Scheme are 
> named gnc:foo. SWIG-wrapped functions have their same name in Scheme except 
> that underscores are replaced with hyphens. Aside from the original xacc  
> camel-case functions we generally follow the Gnome practice of beginning C 
> and C++ free functions with the gnc namespace followed by the class name, 
> separated by underscores. With only seven exceptions if the name is like 
> gnc-foo-bar then it's a wrapped C function while (with no exceptions) 
> gnc:foo-bar is defined in Scheme.
> 
> Note that n/ is defined in qif-to-gnc.scm: (define (n/ a b) (gnc-numeric-div 
> a b 0 GNC-DENOM-REDUCE)) and n* as (define (n* a b) (gnc-numeric-mul a b 0 
> GNC-DENOM-REDUCE)).
> 
> So in normal arithmetic notation, out_shares = inshares * (split_ratio / 10). 
>  That code was added in 
> https://github.com/Gnucash/gnucash/commit/00972f52311b3641c0bd4474334ff846501a3019#diff-fe1b1f57a35caf6ec4d0916b27f888c9bec88a4264248e4d1687d97cbabcc963
>  
> 
>  with no explanation of why the provided split ratio should be divided by 10.
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Jan 5, 2023, at 6:05 PM, David Reiser via gnucash-user 
>>  wrote:
>> 
>> bug, maybe?
>> 
>> import-export/qif-imp/qif-to-gnc.scm says:
>> 
>> ((stksplit)
>> (let* ((splitratio (n/ num-shares (gnc-numeric-create 10 1)))
>>(in-shares
>> (xaccAccountGetBalance near-acct))
>>(out-shares (n* in-shares splitratio)))
>>   (xaccSplitSetAmount gnc-near-split out-shares)
>>   (xaccSplitSetAmount gnc-far-split (n- in-shares))
>>   (xaccSplitSetValue gnc-near-split (n- split-amt))
>>   (xaccSplitSetValue gnc-far-split split-amt
>> 
>> 
>> num-shares is the value of the qif Q line, so it looks like the entered 
>> split ratio is being divided by 10. But I can’t find a definition of 
>> gnc-numeric-create. And my scheme (well, LISP, in my case) is so rusty it 
>> almost might be worse than not knowing it in the first place...
>> --
>> Dave Reiser
>> dbrei...@icloud.com
>> 
>> 
>> 
>> 
>> 
>>> On Jan 5, 2023, at 6:13 PM, m...@tgr66.me wrote:
>>> 
>>> So, the ratio * 10 does seem to be working. :man_shrugging:
>>> 
>>> For example, if it is a 4 for 1 split, 40
>>> If it is a 1 for 10 split, 1
>>> 
 On Jan 5, 2023, at 14:17, m...@tgr66.me wrote:
 
 Yes. I missed adding that to the list I’ve tried.
 
 In the full work minimal example below, the share balance ends up at 1.2
 
 !Account
 NAssets:Investments:Brokerage Account:Joint Brokerage
 TInvst
 ^
 !Type:Bank
 D01/11/2020
 NPayment/Deposit
 PTrf My Bank
 CX
 T1,000.00
 MDeposit
 LAssets:Current Assets:My Bank
 ^
 !Type:Invst
 D12/2/2021
 NBuy
 PXYZ, INC
 YXYZ
 I150
 T450
 Q3
 CR
 M3 shares @ 150; Nothing to see here
 ^
 !Type:Invst
 D1/1/2022
 NStkSplit
 PXYZ, INC
 YXYZ
 CR
 Q4
 M4 for 1 split
 ^
 
 Then I changed Q to 40 and while I end up with the correct balance 
 (GnuCash creates two transactions, one removing the original three shares, 
 and the second adding 12 shares), I have no idea if that is just luck or 
 if I’ve stumbled on new math :-)
 
 I’ll experiment some more.
 
 
> On Jan 5, 2023, at 14:02, David Reiser  wrote:
> 
> I’ve never used QIF for stock splits, but the obvious question is “Have 
> you tried Q4?” After all, 4/1 is numerically equal to 4 (a ratio reduced 
> to a single number).
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> 
> 
>> On Jan 5, 2023, at 2:51 PM, m...@tgr66.me wrote:
>> 
>> I’ve searched considerably, but if I missed it, I apologize.
>> 
>> Docs for QIF say the Q field should contain the split ratio. I’ve tried 
>> various options, but I’m not getting the expected results after import.
>> 
>> !Type:Invst
>> D8/31/2020
>> NStkSplit
>> PAPPLE INC
>> YAAPL
>> CR
>> M4 for 1 split; 

Re: [GNC] Where do I set the "Accounting Period" for reports?

[Phyllis Bruce]

Good question

On Fri, Jan 6, 2023 at 5:12 AM Chris Green  wrote:

> On Fri, Jan 06, 2023 at 12:31:46PM +0300, David T. via gnucash-user wrote:
> > There is also a setting in preferences somewhere to change the
> accounting
> > period. As I don't use the feature, I don't know where it is in either
> > the general preferences or the file preferences.
> >
> Yes, that's where it is.  Why isn't it with the other report options?
>
> --
> Chris Green
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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] Why can't I set 'selcted' accounts for reports permananently?

[Chris Green]

Maybe I'm missing a setting somewhere, but every time I want to print
a report I have to go through the whole rigmarole of selecting all
accounts for the report.

Is there a way to get Gnucash to default to selecting *all* accounts
rather than no accounts?

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Chris Green]

On Fri, Jan 06, 2023 at 12:31:46PM +0300, David T. via gnucash-user wrote:
> There is also a setting in preferences somewhere to change the accounting 
> period. As I don't use the feature, I don't know where it is in either 
> the general preferences or the file preferences. 
> 
Yes, that's where it is.  Why isn't it with the other report options?

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[Chris Green]

On Fri, Jan 06, 2023 at 07:17:46PM +1000, David H wrote:
> Chris,
> 
> Did you run a report then click on Options / General Tab - the reports I
> run allow you to set the period for each report?
> 
... and then forgets it for the next report as far as I can see.

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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 do I set the "Accounting Period" for reports?

[David T. via gnucash-user]

Probably depends on the report.

David T.​

On Jan 6, 2023, 12:52, at 12:52, David H  wrote:
>Yeah it's Prefs >> Accounting Period - not sure if that's used by
>reports
>or just for registers ?
>
>Cheers David H.
>
>
>On Fri, 6 Jan 2023 at 19:31, David T.  wrote:
>
>> There is also a setting in preferences somewhere to change the
>accounting
>> period. As I don't use the feature, I don't know where it is in
>either the
>> general preferences or the file preferences.
>>
>>
>> David T.
>> On Jan 6, 2023, at 12:19, David H  wrote:
>>>
>>> Chris,
>>>
>>> Did you run a report then click on Options / General Tab - the
>reports I
>>> run allow you to set the period for each report?
>>>
>>> Cheers David H.
>>>
>>>
>>> On Fri, 6 Jan 2023 at 19:06, Chris Green  wrote:
>>>
>>>  Every year when I want to print annual reports I have this problem.

  I can never find where to set the 'accounting period' for reports.

  Where is it please?

  --
  Chris Green
 --

  gnucash-user mailing list
  gnucash-user@gnucash.org
  To update your subscription preferences or to unsubscribe:
  https://lists.gnucash.org/mailman/listinfo/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] Where do I set the "Accounting Period" for reports?

[David H]

Yeah it's Prefs >> Accounting Period - not sure if that's used by reports
or just for registers ?

Cheers David H.


On Fri, 6 Jan 2023 at 19:31, David T.  wrote:

> There is also a setting in preferences somewhere to change the accounting
> period. As I don't use the feature, I don't know where it is in either the
> general preferences or the file preferences.
>
>
> David T.
> On Jan 6, 2023, at 12:19, David H  wrote:
>>
>> Chris,
>>
>> Did you run a report then click on Options / General Tab - the reports I
>> run allow you to set the period for each report?
>>
>> Cheers David H.
>>
>>
>> On Fri, 6 Jan 2023 at 19:06, Chris Green  wrote:
>>
>>  Every year when I want to print annual reports I have this problem.
>>>
>>>  I can never find where to set the 'accounting period' for reports.
>>>
>>>  Where is it please?
>>>
>>>  --
>>>  Chris Green
>>> --
>>>
>>>  gnucash-user mailing list
>>>  gnucash-user@gnucash.org
>>>  To update your subscription preferences or to unsubscribe:
>>>  https://lists.gnucash.org/mailman/listinfo/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] Where do I set the "Accounting Period" for reports?

[David T. via gnucash-user]

There is also a setting in preferences somewhere to change the accounting 
period. As I don't use the feature, I don't know where it is in either the 
general preferences or the file preferences.

⁣
David T.​

On Jan 6, 2023, 12:19, at 12:19, David H  wrote:
>Chris,
>
>Did you run a report then click on Options / General Tab - the reports
>I
>run allow you to set the period for each report?
>
>Cheers David H.
>
>
>On Fri, 6 Jan 2023 at 19:06, Chris Green  wrote:
>
>> Every year when I want to print annual reports I have this problem.
>>
>> I can never find where to set the 'accounting period' for reports.
>>
>> Where is it please?
>>
>> --
>> Chris Green
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/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] Where do I set the "Accounting Period" for reports?

[David H]

Chris,

Did you run a report then click on Options / General Tab - the reports I
run allow you to set the period for each report?

Cheers David H.


On Fri, 6 Jan 2023 at 19:06, Chris Green  wrote:

> Every year when I want to print annual reports I have this problem.
>
> I can never find where to set the 'accounting period' for reports.
>
> Where is it please?
>
> --
> Chris Green
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/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] Where do I set the "Accounting Period" for reports?

[Chris Green]

Every year when I want to print annual reports I have this problem.

I can never find where to set the 'accounting period' for reports.

Where is it please?

-- 
Chris Green
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/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] Select correct database for plot and explorer gui widgets

[Ben Pracht]

Hi,

I really like having the convenience of an inline plotter, but the plot
widget only allows me to select
the X and Y values from I think is the OOTB country database. How can I
select a different database for this widget? It seems like somewhere there
should be a database selection drop down for it.

Best Regards,
Ben Pracht
919.809.2439
ben.pra...@gmail.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.