[GNC] multi-currency imports

[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 imports in particular?

-- 
cheers,

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

[GNC] Installing on Windows 10 (with Defender)

[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 in 
C:\Program files (x86)\gnucash\bin\

As I don’t know about Windows 10, can someone please tell me the way to perform 
the install correctly in this case?

Thanks.



--
Peter West
p...@pbw.id.au 
When he went ashore he saw a great crowd, and he had compassion on them and 
healed their sick.

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

Re: [GNC] Matcher for qfx files

[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 3.8 specifically. There was one version where changes in the 
matcher resulted in requests to re-establish links to the various TIAA accounts 
and funds.

I frequently have to undo my choices when I get one of those dialogs because 
I’m not careful enough at reading the exact language at the top of the dialog. 
I haven’t made many changes lately, but I think you’ll get a request to 
identify a security, but that usually also includes a statement about which 
TIAA contract is involved. Then (? hmm, not sure of the order…) it’ll ask you 
for a gnucash account to associate with a specific TIAA contract. Somewhere 
along the way, there’s a question about which account to associate income from 
the various contracts and/or funds. Most of that used to get rolled up inside 
the TIAA/CREF funds, but now at least one of our contracts splits out a special 
fee/credit that is something like the net difference between dividends and fees 
for several of the funds.

If your employer hasn’t done an administrative change that would kick some 
extra transactions into your ofx stream (and there appears to be a lot of 
pressure from somewhere to do that), then having gnucash ask for additional 
matching info is a bit strange. One other possibility is that your employer’s 
plan has qualified for a better version of the same fund you’ve had for a while 
(R3 vs R2 fee levels, higher digit is lower fees). One example is CREF stock R3 
(QCSTIX in public symbol world) vs CREF stock R2 (QCSTPX).

Since there have been a few import transaction matcher changes lately, I’d 
recommend giving gnucash version 4.1 a try if you can. I’m unfamiliar with the 
version availability in the linux prepackaged realm.
--
Dave Reiser
dbrei...@icloud.com




> On Aug 2, 2020, at 1:53 PM, Dale Alspach  wrote:
> 
> 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 do an import in gnucash
> 3.8 (linux mint 20) and was asked to match a fund to an account but was
> only given the cusip number. which refers to a security which could be in
> any one of 3 gnucash accounts.
> If I recall correctly older versions of gnucash gave the name of the fund
> and the TIAA contract number.
> 
> Dale

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

Re: [GNC] non-currency liabilities

[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.  And for tax
>> purposes,
>> that would be proper:  you will have to pay income tax on the gains,
>> because it is only an informal, personally-defined thing of yours.
> 
> Most people are able to report personal income on the "cash basis" so
> gains from appreciated assets not any sort of income until realized and
> then may be either regular income or capital gains 

Well, yes and no. In the US, it's different for different types of
assets. (I assume we are not talking about a qualified retirement
account, which has different rules.) For example, shares of stock
typically pay dividends, and those are taxable when received. Mutual
funds probably pay dividends, and may also realize capital gains as they
buy and sell shares of stock, and these are also taxable to the owners
of shares in the mutual fund, even though they have not sold any shares
of the mutual fund. But, as you say, rises in the share price of stock
or mutual funds are not taxable until the gains are "realized" by
selling the shares for more than one paid.

> and may even depend
> on how disposed of << appreciated asset donated to charity and depending
> on type of asset, maybe only taxed conditionally*>> ALSO -- he said this
> was for a "college fund". There are tax advantage possibilities involved
> with that, too.

That is an excellent, excellent point. The person setting up this fund
should look at
https://www.sec.gov/reportspubs/investor-publications/investorpubsintro529htm.html
as a starting point.

> AND --- I will add, I was referring to the US. Anything taxes are
> involved always must be in reference to some specific jurisdiction.

Absolutely!  (And isn't it interesting that in the US we have special
tax advantages for savings for health care, or education, or retirement,
whereas civilized countries cover these things out of the revenue from
taxes?)

> Michael D Novack
> 
> * Thus whether capital gains from sale of primary residence is taxed
> depends on whether one has bought another primary residence within a
> certain amount of time.

And on the amount of profit on the sale;
And on whether one had lived in the sold residence a certain time;
And probably other things that don't come immediately to mind.

Fortunately, the IRS website, though not exactly light reading, is
comprehensible by almost anyone who is willing to take a deep breath and
wade through it.

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

Re: [GNC] non-currency liabilities

[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 included as gains (losses)
within the regular Income Statement of each period.  And for tax purposes,
that would be proper:  you will have to pay income tax on the gains,
because it is only an informal, personally-defined thing of yours.


If you lack the "qualifications" to be a tax advisor, don't say tings 
like that


Most people are able to report personal income on the "cash basis" so 
gains from appreciated assets not any sort of income until realized and 
then may be either regular income or capital gains and may even depend 
on how disposed of << appreciated asset donated to charity and depending 
on type of asset, maybe only taxed conditionally*>> ALSO -- he said this 
was for a "college fund". There are tax advantage possibilities involved 
with that, too.


AND --- I will add, I was referring to the US. Anything taxes are 
involved always must be in reference to some specific jurisdiction.


Michael D Novack

* Thus whether capital gains from sale of primary residence is taxed 
depends on whether one has bought another primary residence within a 
certain amount of time.




Michael D Novack

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

Re: [GNC] non-currency liabilities

[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.  But is like retirement funds and I think it should be
accounted for the same way, which is (i think):  just stated as one of your
assets, but clearly labelled as to its purpose.  I think it should be
included under a Long Term Assets "placeholder account" in GnuCash. I'd
like to see some examples of proper statements for individual financial
reporting though.  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.  And for tax purposes,
that would be proper:  you will have to pay income tax on the gains,
because it is only an informal, personally-defined thing of yours.

For businesses, in more full-fledged accounting systems, GAAP accounting
would allow the gains (losses) to be kept aside, and only reported in what
is called the Other Comprehensive Income statement.

If you really had a formal, contractual, legal obligation to pay for the
entire college education of a current minor, I suppose that could be
reflected in a long-term liability, at the estimated present value of the
future cost which must be paid.  Like how for firms having a defined
benefit pension program will have an estimated Pension Liability.  And they
will also have a Pension Assets account, which hopefully should be similar
in magnitude.  And there are requirements for how to show re-estimates of
the pension liability, etc.  But in your case, I don't believe you have an
absolute obligation to pay all the college costs no matter what they might
turn out to be;  it sounds like you are taking on a moral obligation to pay
whatever funds have accumulated in your college fund account.

If the purpose of creating a liability would be to highlight the value and
its restricted purpose, i don't think that is necessary:  statement of the
asset, properly labelled as to its purpose, suffices.

But better than doing an informal program of your own, if u are in the U.S.
you could get tax benefits from using a formal 529 plan:
"529 plans are named after Section 529 of the Internal Revenue Code (IRC),
which was added in 1996 to authorize tax-free status for 'qualified tuition
programs'. Earnings in 529 plans accumulate on a tax-deferred basis and
distributions are not taxed federally when used for qualified higher
education expenses
.
The definition of qualified higher education expenses was expanded in 2015
to include computers, in 2017 to include up to $10,000 annually in K-12
tuition and in 2019 to include student loan payments and costs of
apprenticeship programs. " from SavingForCollege.com

Somewhat similarly, a nonprofit may have a restricted asset, e.g. the
invested funds received from a foundation or other donor, which may only be
spent for a specified purpose.  Simple accounting for this (as opposed to
full formal Funds Flow Accounting for nonprofits and governments which is
more complicated) would show the asset, sensibly labelled, on a regular
balance sheet for the nonprofit.  If job costing were available, it would
be designated as a job, and in each period an income statement (or Revenues
less Expenses) statement would show new receipts of funds from the donor
and perhaps interest earnings, and it would document eligible expenses.

Hope this helps
Don

On Sun, Aug 2, 2020 at 4:53 PM Stephen M. Butler  wrote:

> 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 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 <
> david.carlson@gmail.com> 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.
> >>>
> >>> 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 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 that restriction by design?
> 
>    One of the reasons I want to do this is for a college fund. I'd like

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

[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 to clients although we could. We wanted a quick way to convert 
remaining balance to hours, and the owner report was the existing report that 
seemed to have almost all the logic we needed. (The receivable aging report was 
another candidate but I have not tried modifying that one yet.)

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

Nice. I’ve already changed the customization in this way. Thanks for the 
suggestions.

- Tim

> 
> v4.2 will add the _ shim, which would make it work unless you used guile-3.0 
> onwards. Thanks for your report!
> 
> On Sun, 2 Aug 2020 at 22:20, Tim Quinn  > wrote:
> Hi, Christopher.
> 
> Thanks for the response.
> 
> I do get that libraries evolve, and GC must do so with them. I’m just saying 
> it would have been helpful if the GC release notes for 4.1 noted this change 
> so those of us who do customize reports were not caught off-guard.
> 
> Because revising old reports to change “_” to “G_” is so straightforward, 
> speaking for myself I’m not sure the shim is worth it now that 4.1 is out 
> without it. 
> 
> I’ve attached the modified .scm file and also included a diff.
> 
> Here’s what the customizations do. My wife charges clients by the hour, and 
> offers a discounted rate if they prepay for multiple hours. The customized 
> report:
> 
> -  identifies the most recent customer invoice (skipping credit memos),
> -  extracts the hourly rate from the last line in the invoice, 
> -  calculates the number of prepaid hours remaining by dividing by any 
> remaining credit by that rate, and
> -  includes that as an addition line in the summary section of the report.
> 
> As I mentioned earlier, I feel as if I have learned just enough to accomplish 
> what I wanted. There might be better or more efficient ways to accomplish 
> this and I’d welcome any suggestions for improvement. 
> 
> - Tim
> 
> 
> 
> 
>> On Aug 2, 2020, at 9:32 AM, Christopher Lam > > wrote:
>> 
>> 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 affected. 
>> If you're willing to share your customised owner-report.scm we can certainly 
>> add new features. If possible we'll add a guile-2.2 specific shim to pass _ 
>> through (and encourage its change to G_).
>> C
>> 
>> On Sun, 2 Aug 2020 at 13:50, Tim Quinn > > wrote:
>> 
>> 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 when Gnucash tried to load the 
>> report.
>> 
>> Comparing that report’s source in 4.0 vs. that in 4.1, I see that uses of 
>> “(_” have become “(G_”. I made those corresponding changes in my customized 
>> copy and now it seems to be working with 4.1.
>> 
>> Now, I understand that experimental reports are just that — experimental — 
>> and not guaranteed to work in a future release. But this same change was 
>> made in the non-experimental owner-report.scm from 4.0 to 4.1 (and, I 
>> assume, other reports — I have not checked). 
>> 
>> I also freely admit that I’ve customized reports by learning just barely 
>> enough about reporting to accomplish what I need, not by mastering all of 
>> the reporting infrastructure. So maybe this is something that would be 
>> obvious to people with a more thorough understanding of all that.
>> 
>> Still, I think anyone who has customized reports will run into this and I 
>> was a little surprised seeing a breaking change in a dot release and no 
>> release note about it.
>> 
>> If there *was* something in the release notes that I’ve missed, I apologize 
>> and please point me to it.
>> 
>> Thanks.
>> 
>> - Tim
>> 
>> 
>> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> 
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>> 

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

[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 work unless you used
guile-3.0 onwards. Thanks for your report!

On Sun, 2 Aug 2020 at 22:20, Tim Quinn  wrote:

> Hi, Christopher.
>
> Thanks for the response.
>
> I do get that libraries evolve, and GC must do so with them. I’m just
> saying it would have been helpful if the GC release notes for 4.1 noted
> this change so those of us who do customize reports were not caught
> off-guard.
>
> Because revising old reports to change “_” to “G_” is so straightforward,
> speaking for myself I’m not sure the shim is worth it now that 4.1 is out
> without it.
>
> I’ve attached the modified .scm file and also included a diff.
>
> Here’s what the customizations do. My wife charges clients by the hour,
> and offers a discounted rate if they prepay for multiple hours. The
> customized report:
>
> -  identifies the most recent customer invoice (skipping credit memos),
> -  extracts the hourly rate from the last line in the invoice,
> -  calculates the number of prepaid hours remaining by dividing by any
> remaining credit by that rate, and
> -  includes that as an addition line in the summary section of the report.
>
> As I mentioned earlier, I feel as if I have learned just enough to
> accomplish what I wanted. There might be better or more efficient ways to
> accomplish this and I’d welcome any suggestions for improvement.
>
> - Tim
>
>
>
>
> On Aug 2, 2020, at 9:32 AM, Christopher Lam 
> wrote:
>
> 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 affected.
> If you're willing to share your customised owner-report.scm we can
> certainly add new features. If possible we'll add a guile-2.2 specific shim
> to pass _ through (and encourage its change to G_).
> C
>
> On Sun, 2 Aug 2020 at 13:50, Tim Quinn  wrote:
>
>>
>> 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 when Gnucash tried to load the
>> report.
>>
>> Comparing that report’s source in 4.0 vs. that in 4.1, I see that uses of
>> “(_” have become “(G_”. I made those corresponding changes in my customized
>> copy and now it seems to be working with 4.1.
>>
>> Now, I understand that experimental reports are just that — experimental
>> — and not guaranteed to work in a future release. But this same change was
>> made in the non-experimental owner-report.scm from 4.0 to 4.1 (and, I
>> assume, other reports — I have not checked).
>>
>> I also freely admit that I’ve customized reports by learning just barely
>> enough about reporting to accomplish what I need, not by mastering all of
>> the reporting infrastructure. So maybe this is something that would be
>> obvious to people with a more thorough understanding of all that.
>>
>> Still, I think anyone who has customized reports will run into this and I
>> was a little surprised seeing a breaking change in a dot release and no
>> release note about it.
>>
>> If there *was* something in the release notes that I’ve missed, I
>> apologize and please point me to it.
>>
>> Thanks.
>>
>> - Tim
>>
>>
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] non-currency liabilities

[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 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 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 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 that restriction by design?

   One of the reasons I want to do this is for a college fund. I'd like
 to keep track of the fund value in an account, but also "keep it off
 the books" in a sense when it comes to Asset vs. Liability
 calculations, as I consider it both something I have and something I
 owe. I tried doing this by creating an Asset account and a Liability
 account that grow together, and cancel each other out, but I couldn't
 get that to work since it won't let me make the Liability a security.
 Is there a better way to do this?

   -dann
 ___

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

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

Re: [GNC] non-currency liabilities

[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 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 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 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 that restriction by design?
>>>
>>>   One of the reasons I want to do this is for a college fund. I'd like
>>> to keep track of the fund value in an account, but also "keep it off
>>> the books" in a sense when it comes to Asset vs. Liability
>>> calculations, as I consider it both something I have and something I
>>> owe. I tried doing this by creating an Asset account and a Liability
>>> account that grow together, and cancel each other out, but I couldn't
>>> get that to work since it won't let me make the Liability a security.
>>> Is there a better way to do this?
>>>
>>>   -dann
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>> --
>> David Carlson
>
>
>
> --
> David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Matcher for qfx files

[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 do an import in gnucash
3.8 (linux mint 20) and was asked to match a fund to an account but was
only given the cusip number. which refers to a security which could be in
any one of 3 gnucash accounts.
If I recall correctly older versions of gnucash gave the name of the fund
and the TIAA contract number.

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

Re: [GNC] non-currency liabilities

[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 apparently Mutual Funds and Liabilities are
> mutually exclusive. Is that restriction by design?
> 
>  One of the reasons I want to do this is for a college fund. I'd like
> to keep track of the fund value in an account, but also "keep it off
> the books" in a sense when it comes to Asset vs. Liability
> calculations, as I consider it both something I have and something I
> owe. I tried doing this by creating an Asset account and a Liability
> account that grow together, and cancel each other out, but I couldn't
> get that to work since it won't let me make the Liability a security.
> Is there a better way to do this?

Yes, only Asset accounts of type Stock and Fund can have non-currency 
commodities. GnuCash doesn't support barter.

You could do that with two Asset accounts, one with a positive balance and the 
other with an equal negative balance.

However, if what you're modeling is your kid's college fund it would be more 
correct to create a separate book for it, particularly if it's a tax-advantaged 
fund like a US 529 fund or a court-supervised entity like a trust or 
guardianship.

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

Re: [GNC] non-currency liabilities

[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 deal with a "short" securities" transaction.


Michael

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

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

[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 affected.
If you're willing to share your customised owner-report.scm we can
certainly add new features. If possible we'll add a guile-2.2 specific shim
to pass _ through (and encourage its change to G_).
C

On Sun, 2 Aug 2020 at 13:50, Tim Quinn  wrote:

>
> 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 when Gnucash tried to load the
> report.
>
> Comparing that report’s source in 4.0 vs. that in 4.1, I see that uses of
> “(_” have become “(G_”. I made those corresponding changes in my customized
> copy and now it seems to be working with 4.1.
>
> Now, I understand that experimental reports are just that — experimental —
> and not guaranteed to work in a future release. But this same change was
> made in the non-experimental owner-report.scm from 4.0 to 4.1 (and, I
> assume, other reports — I have not checked).
>
> I also freely admit that I’ve customized reports by learning just barely
> enough about reporting to accomplish what I need, not by mastering all of
> the reporting infrastructure. So maybe this is something that would be
> obvious to people with a more thorough understanding of all that.
>
> Still, I think anyone who has customized reports will run into this and I
> was a little surprised seeing a breaking change in a dot release and no
> release note about it.
>
> If there *was* something in the release notes that I’ve missed, I
> apologize and please point me to it.
>
> Thanks.
>
> - Tim
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 when Gnucash tried to load the report.

Comparing that report’s source in 4.0 vs. that in 4.1, I see that uses of “(_” 
have become “(G_”. I made those corresponding changes in my customized copy and 
now it seems to be working with 4.1.

Now, I understand that experimental reports are just that — experimental — and 
not guaranteed to work in a future release. But this same change was made in 
the non-experimental owner-report.scm from 4.0 to 4.1 (and, I assume, other 
reports — I have not checked). 

I also freely admit that I’ve customized reports by learning just barely enough 
about reporting to accomplish what I need, not by mastering all of the 
reporting infrastructure. So maybe this is something that would be obvious to 
people with a more thorough understanding of all that.

Still, I think anyone who has customized reports will run into this and I was a 
little surprised seeing a breaking change in a dot release and no release note 
about it.

If there *was* something in the release notes that I’ve missed, I apologize and 
please point me to it.

Thanks.

- Tim




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

Re: [GNC] non-currency liabilities

[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 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 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 that restriction by design?
>>
>>   One of the reasons I want to do this is for a college fund. I'd like
>> to keep track of the fund value in an account, but also "keep it off
>> the books" in a sense when it comes to Asset vs. Liability
>> calculations, as I consider it both something I have and something I
>> owe. I tried doing this by creating an Asset account and a Liability
>> account that grow together, and cancel each other out, but I couldn't
>> get that to work since it won't let me make the Liability a security.
>> Is there a better way to do this?
>>
>>   -dann
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
> --
> David Carlson
>


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

Re: [GNC] non-currency liabilities

[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 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 that restriction by design?
>
>   One of the reasons I want to do this is for a college fund. I'd like
> to keep track of the fund value in an account, but also "keep it off
> the books" in a sense when it comes to Asset vs. Liability
> calculations, as I consider it both something I have and something I
> owe. I tried doing this by creating an Asset account and a Liability
> account that grow together, and cancel each other out, but I couldn't
> get that to work since it won't let me make the Liability a security.
> Is there a better way to do this?
>
>   -dann
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

[GNC] non-currency liabilities

[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 that restriction by design?

  One of the reasons I want to do this is for a college fund. I'd like
to keep track of the fund value in an account, but also "keep it off
the books" in a sense when it comes to Asset vs. Liability
calculations, as I consider it both something I have and something I
owe. I tried doing this by creating an Asset account and a Liability
account that grow together, and cancel each other out, but I couldn't
get that to work since it won't let me make the Liability a security.
Is there a better way to do this?

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