[GNC] multi-currency imports

2020-08-02 Thread Gio Bacareza
Hi, I read in this list some time ago that multi-currency imports is a known issue in gnucash. I just wanted to know if this has been fixed. Also, is there a best recommended format for import. I mean is CSV, QIF, etc, whichever format, is better in handling imports in general and multi-currency

[GNC] Installing on Windows 10 (with Defender)

2020-08-02 Thread Peter West
My brother-in-law in the US (I’m in Oz) tried on my recommendation to install Gnucash 4.1 from the gnucash.org site. The install was initially blocked by Defender, but he managed to overcome that. When he tried to run the program, the complaint was about missing .dll files

Re: [GNC] Matcher for qfx files

2020-08-02 Thread David Reiser via gnucash-user
It at least uses the , which is matched via the outside-account-to-gnucash-account list. And imports of multiple TIAA contracts containing multiple instances of the same fund do work correctly if the links are set up correctly. I’m currently using gnucash 4.1, but I don’t recall problems with

Re: [GNC] non-currency liabilities

2020-08-02 Thread Stan Brown
On 2020-08-02 17:39, Michael or Penny Novack wrote: > On 8/2/2020 8:00 PM, doncram wrote: >> If done that way in GnuCash, then increases (decreases) >> in value from stock market fluctuations would be included as gains >> (losses) >> within the regular Income Statement of each period. 

Re: [GNC] non-currency liabilities

2020-08-02 Thread Michael or Penny Novack
On 8/2/2020 8:00 PM, doncram wrote: I am not an expert about how personal financial accounting should be done, where that is different from business accounting... If done that way in GnuCash, then increases (decreases) in value from stock market fluctuations would be

Re: [GNC] non-currency liabilities

2020-08-02 Thread doncram
To Dann F et al. -- In my opinion, the informal College Fund you describe is neither a liability nor a short-term asset, but rather is a long-term asset, in my opinion. I am not an expert about how personal financial accounting should be done, where that is different from business accounting.

Re: [GNC] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Tim Quinn
> On Aug 2, 2020, at 6:26 PM, Christopher Lam wrote: > > Your changes are quite nice, but may be too obscure for general use! Indeed! I realize this is a very specialized use case and not many people would have the same requirement. And, just to be clear, we don’t send this enhanced invoice

Re: [GNC] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Christopher Lam
Your changes are quite nice, but may be too obscure for general use! - Instead of how=7 you can use GNC-HOW-RND-ROUND (ie change C's _ to guile's -) but equally easy to use (/ num denom) directly. - Instead of "lastInList" you can use "last" directly v4.2 will add the _ shim, which would make it

Re: [GNC] non-currency liabilities

2020-08-02 Thread Stephen M. Butler
On 8/2/20 8:35 AM, dann frazier wrote: > Thanks David - yeah, negative share balances are possible. But it's > seemingly not possible to track shares in a Liability account. You can always treat Liabilities as a negative Asset.  > > On Sun, Aug 2, 2020 at 2:41 AM David Carlson > wrote: >> I

Re: [GNC] non-currency liabilities

2020-08-02 Thread dann frazier
Thanks David - yeah, negative share balances are possible. But it's seemingly not possible to track shares in a Liability account. On Sun, Aug 2, 2020 at 2:41 AM David Carlson wrote: > > I meant no requirement to have a positive share balance. You should be able > to have a negative share

[GNC] Matcher for qfx files

2020-08-02 Thread Dale Alspach
When importing a .qfx file does the matcher use the tags and ? The issue is that I download transactions from TIAA which are from multiple accounts but are in the same download. There are some mutual funds which are held in more than one account. I recently upgraded to gnucash 3.8. I started to

Re: [GNC] non-currency liabilities

2020-08-02 Thread John Ralls
> On Aug 1, 2020, at 4:21 PM, dann frazier wrote: > > Hi, > > I'm trying to figure out the right way to represent a non-currency > debt in gnucash. That is, I'd like to be able to record that I *owe* > 20 shares of FooFund. I thought I'd just create a Mutual Fund > Liability account, but

Re: [GNC] non-currency liabilities

2020-08-02 Thread Michael or Penny Novack
On 8/2/2020 4:37 AM, David Carlson wrote: I believe there is no restriction to have a positive number of shares of a security. After all, it is common to sell stock short (Against the box) or not. We must not have many "bears" among our gnucash users. I imagine this is how you would have to

Re: [GNC] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Christopher Lam
Hello Glad you managed to make your report work. The _ could not be used anymore because in guile-3.0 it is a reserved symbol. Many modern Linux distros had moved to guile-3.0 necessitating this change. This change is not limited to experimental reports; all custom reports using _ were similarly

[GNC] 4.1 on Mac - undocumented breaking change in customized reports

2020-08-02 Thread Tim Quinn
When 4.0 arrived I was intrigued by the experimental new-owner-report.scm. I had customized the regular owner-report.scm several releases ago, and forward-ported my changes to create a customized new-owner-report.scm that I had working fine with 4.0. I’ve just installed 4.1 and I saw errors

Re: [GNC] non-currency liabilities

2020-08-02 Thread David Carlson
I meant no requirement to have a positive share balance. You should be able to have a negative share balance in a security account. On Sun, Aug 2, 2020 at 3:37 AM David Carlson wrote: > I believe there is no restriction to have a positive number of shares of a > security. After all, it is

Re: [GNC] non-currency liabilities

2020-08-02 Thread David Carlson
I believe there is no restriction to have a positive number of shares of a security. After all, it is common to sell stock short (Against the box) or not. David Carlson On Sun, Aug 2, 2020 at 2:48 AM dann frazier wrote: > Hi, > > I'm trying to figure out the right way to represent a

[GNC] non-currency liabilities

2020-08-02 Thread dann frazier
Hi, I'm trying to figure out the right way to represent a non-currency debt in gnucash. That is, I'd like to be able to record that I *owe* 20 shares of FooFund. I thought I'd just create a Mutual Fund Liability account, but apparently Mutual Funds and Liabilities are mutually exclusive. Is