Re: How to deal with RRSP's (Canada)

[David T. via gnucash-user]

David—

I see where you are coming from on this. 

For reference, I accept your 5 assumptions; I believe they are accurate for 
many US retirement accounts as well.

The Income/Equity splits in Cam’s example are a mechanism that allow 
distributions to appear as income on reports, without affecting the transfer 
between asset accounts. This makes it easier to prepare reports for taxing 
agencies when needed. I see, however, how that might be finessed using reports 
instead of extra offsetting splits.

I guess, from a philosophical perspective, the question really is: when do 
these funds become income? Is it when you get paid, or is it when the money 
actually gets disbursed? It seems to me that most of us are looking at it from 
the first perspective, but that the taxing agencies are looking at it from the 
second. So, for example, I have paycheck transactions that document my 
retirement contributions, transferring to the retirement asset accounts from a 
special (retirement) income account.

Perhaps there is a sound accounting method for documenting that deferred amount 
as something other than income at the time it is diverted into retirement 
accounts? Then it could become income at the time of disbursement…

David

> On Jan 5, 2018, at 10:27 AM, DaveC49  wrote:
> 
> Cam,
> 
> I have been giving a bit of thought to the way one might account properly
> for Retirement funds. I am not sure how your CRA asks for information about
> income from your RRIFs. In Australia, I have specific questions in the tax
> return dialog at which I have to record the income from such funds and it is
> distinct from any ordinary income from other sources. If this is also the
> case in Canada then the following should be a reasonable treatment in
> accounting terms.
> 
> Assumptions:
>1. Contributions to the RRSP are from pre-tax income;
>2. Contributions to the RRSP are not taxed on payment into the fund 
> (i.e. the contributions are tax deductible against income at the time of
> their payment;
>3. Fund earnings are not taxed as they are earned;
>4. Withdrawals from the fund after retirement and conversion to RRIF are
> taxable at that time;
>5. Withdrawals from the RRIF are not taxed in the hands of the fund on
> withdrawal (i.e. no withholding tax) but the payment of tax is through the
> drawer’s personal income tax at whatever marginal rate applies.
> 
> The most obvious way of accounting for this, particularly if your income tax
> return has a specific entry for a total of RRIF (or converted RRSP)
> withdrawals, is simply to record the withdrawal as a transaction from an
> Asset:Fixed:RRIF account to a Asset:Bank:Savings (or Cheque) account. i.e.
> debit the Savings account and credit the RRIF account by the amount of the
> withdrawal. This is assuming no withholding tax applies.
> 
> A custom report which then listed and totalled all withdrawals from the RRIF
> account would provide the necessary information for completing such a tax
> return entry.
> 
> Even if there was no separate entry for RRIF withdrawals, the results of the
> above report could simply be added to your income entries at an appropriate
> point. (I have no familiarity with CRA tax processes so cannot suggest how
> this might appear .)
> 
> In the case where a withholding tax is applied by the institution
> administering the RRIF to any withdrawal how you record it will depend upon
> how you record your Tax liabilities generally. Taxes  are generally recorded 
> as Liabilities e.g in an account like Liabilities:Tax. To record withholding
> taxes, which are generally paid in advance of assessment of your tax
> liability you would normally use what is known as a contra account in
> accounting to record this. A typical account structure might look something
> like:
> 
> Liability:Tax  parent account;
> Liability:Tax Assessed  daughter account to record
> tax assessed by authority;
> Liability:Tax:Withholding daughter account to record tax
> withheld from income.
> 
> When withholding tax is paid to the tax authority by the account
> administrator (your bank for example),  you would record it as a debit to
> the Liability:Tax:Withholding account where as assessments of tax owing
> would be recorded as a credit to Liabilities:Tax:Assessed and the balance of
> Liability:Tax gives your overall tax liability position.  With this sort of
> structure for tax recording, then recording a withdrawal from an RRIF of
> $  with tax $  withheld, i.e. a nett payment of $ =$-$
> to your bank account would be recorded as:
> 
>Debit| Credit
> Asset:Fixed:RRIF   |  $
> Liability:Tax:Withholding $   |
> Asset:Bank:Savings   $| 
> 
> Must stress that the above is a suggested 

Re: How to deal with RRSP's (Canada)

[DaveC49]

Cam,

I have been giving a bit of thought to the way one might account properly
for Retirement funds. I am not sure how your CRA asks for information about
income from your RRIFs. In Australia, I have specific questions in the tax
return dialog at which I have to record the income from such funds and it is
distinct from any ordinary income from other sources. If this is also the
case in Canada then the following should be a reasonable treatment in
accounting terms.

Assumptions:
1. Contributions to the RRSP are from pre-tax income;
2. Contributions to the RRSP are not taxed on payment into the fund 
(i.e. the contributions are tax deductible against income at the time of
their payment;
3. Fund earnings are not taxed as they are earned;
4. Withdrawals from the fund after retirement and conversion to RRIF are
taxable at that time;
5. Withdrawals from the RRIF are not taxed in the hands of the fund on
withdrawal (i.e. no withholding tax) but the payment of tax is through the
drawer’s personal income tax at whatever marginal rate applies.

The most obvious way of accounting for this, particularly if your income tax
return has a specific entry for a total of RRIF (or converted RRSP)
withdrawals, is simply to record the withdrawal as a transaction from an
Asset:Fixed:RRIF account to a Asset:Bank:Savings (or Cheque) account. i.e.
debit the Savings account and credit the RRIF account by the amount of the
withdrawal. This is assuming no withholding tax applies.

A custom report which then listed and totalled all withdrawals from the RRIF
account would provide the necessary information for completing such a tax
return entry.

Even if there was no separate entry for RRIF withdrawals, the results of the
above report could simply be added to your income entries at an appropriate
point. (I have no familiarity with CRA tax processes so cannot suggest how
this might appear .)

In the case where a withholding tax is applied by the institution
administering the RRIF to any withdrawal how you record it will depend upon
how you record your Tax liabilities generally. Taxes  are generally recorded 
as Liabilities e.g in an account like Liabilities:Tax. To record withholding
taxes, which are generally paid in advance of assessment of your tax
liability you would normally use what is known as a contra account in
accounting to record this. A typical account structure might look something
like:

Liability:Tax  parent account;
Liability:Tax Assessed  daughter account to record
tax assessed by authority;
Liability:Tax:Withholding daughter account to record tax
withheld from income.

When withholding tax is paid to the tax authority by the account
administrator (your bank for example),  you would record it as a debit to
the Liability:Tax:Withholding account where as assessments of tax owing
would be recorded as a credit to Liabilities:Tax:Assessed and the balance of
Liability:Tax gives your overall tax liability position.  With this sort of
structure for tax recording, then recording a withdrawal from an RRIF of
$  with tax $  withheld, i.e. a nett payment of $ =$-$
to your bank account would be recorded as:

Debit| Credit
Asset:Fixed:RRIF   |  $
Liability:Tax:Withholding $   |
Asset:Bank:Savings   $| 

Must stress that the above is a suggested approach for accounting for such
funds but is not specific accounting advice. It may or may not need some
other adjustments to account for aspects of the enabling RRIF and taxation
legislation with which I claim no real familiarity. I have looked at some
info
http://accountingtoronto.ca/2017/09/15/registered-retirement-saving-plan-rrsp/,
https://en.wikipedia.org/wiki/Registered_Retirement_Savings_Plan,
http://www.wheatlandaccounting.com/rrsp.html to compare it with what I am
familiar with in my own jurisdiction (Australia) but only in broad
conceptual terms.

Cam  I don't think there is a need to use an equity or expense account as
the offset account for a withdrawal or even an expense account (recording an
existing balance against Equity:Opening Balances is not a problem when you
open/create a set of books). Expense accounts generally record the
expenditure on goods or services which are expected to be consumed within
the accounting period so it would be somewhat artificial to use an expense
account. The most logical offset account is the Asset account into which the
funds are paid, i.e a cheque/check  or savings account as you have converted
a fixed long term asset, the RRIF, into a current asset -cash in you bank
account, when you make a withdrawal.


David




-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user 

Re: GnuCash install on Windows 365

[Paul Makinen via gnucash-user]

I've never subscribed to this email reflector until just now, and I was 
speculating on a possible source of the confusion over the name "WIndows 
365," which puzzled me as well.


The person I'm asking for is by no means a computer expert, but she was 
quite sure "Windows 365" was what was on her computer.


Apologies for too many emails in succession.  I'll try to get an actual 
look at the computer in question before posting the problem again.


On 04.01.2018 21:26, David Carlson wrote:

I think this troll has been here before. I thought he was banned.

David C

On Thu, Jan 4, 2018 at 8:42 PM, Paul Makinen via gnucash-user 
> wrote:



Since July 2017, Microsoft has been selling something called
Microsoft 365 Enterprise
http://www.microsoft.com/en-us/microsoft-365-enterprise/home
,
which is a bundle of Office 365 and Windows 10, so this may be
where the confusion is coming from.



On 04.01.2018 20:29, Ken Pyzik wrote:

To the best of my knowledge - this person may be confusing
this with Office
365 -- which would have no effect at all on Gnucash.  The
usual OS for
Office 365 would probably be Windows 10 and Gnucash runs great
on Windows 10
-- which is what I am running it on.

-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01
=cox@gnucash.org
]
On Behalf Of David Carlson
Sent: Thursday, January 4, 2018 6:23 PM
To: lurker123 >
Cc: Gnucash Users >
Subject: Re: GnuCash install on Windows 365

According to my sources there is no such thing as Windows 365.

David C

On Thu, Jan 4, 2018 at 7:39 PM, lurker123 via gnucash-user <
gnucash-user@gnucash.org > wrote:

Are there any known tricks for successfully installing and
running
GnuCash on a Windows 365 machine?



--
Sent from:
http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




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

Re: GnuCash install on Windows 365

[David Carlson]

I think this troll has been here before. I thought he was banned.

David C

On Thu, Jan 4, 2018 at 8:42 PM, Paul Makinen via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> Since July 2017, Microsoft has been selling something called Microsoft 365
> Enterprise http://www.microsoft.com/en-us/microsoft-365-enterprise/home,
> which is a bundle of Office 365 and Windows 10, so this may be where the
> confusion is coming from.
>
>
>
> On 04.01.2018 20:29, Ken Pyzik wrote:
>
>> To the best of my knowledge - this person may be confusing this with
>> Office
>> 365 -- which would have no effect at all on Gnucash.   The usual OS for
>> Office 365 would probably be Windows 10 and Gnucash runs great on Windows
>> 10
>> -- which is what I am running it on.
>>
>> -Original Message-
>> From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org
>> ]
>> On Behalf Of David Carlson
>> Sent: Thursday, January 4, 2018 6:23 PM
>> To: lurker123 
>> Cc: Gnucash Users 
>> Subject: Re: GnuCash install on Windows 365
>>
>> According to my sources there is no such thing as Windows 365.
>>
>> David C
>>
>> On Thu, Jan 4, 2018 at 7:39 PM, lurker123 via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>> Are there any known tricks for successfully installing and running
>>> GnuCash on a Windows 365 machine?
>>>
>>>
>>>
>>> --
>>> Sent from:
>>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash install on Windows 365

[Paul Makinen via gnucash-user]

Since July 2017, Microsoft has been selling something called Microsoft 
365 Enterprise 
http://www.microsoft.com/en-us/microsoft-365-enterprise/home, which is a 
bundle of Office 365 and Windows 10, so this may be where the confusion 
is coming from.



On 04.01.2018 20:29, Ken Pyzik wrote:

To the best of my knowledge - this person may be confusing this with Office
365 -- which would have no effect at all on Gnucash.   The usual OS for
Office 365 would probably be Windows 10 and Gnucash runs great on Windows 10
-- which is what I am running it on.

-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org]
On Behalf Of David Carlson
Sent: Thursday, January 4, 2018 6:23 PM
To: lurker123 
Cc: Gnucash Users 
Subject: Re: GnuCash install on Windows 365

According to my sources there is no such thing as Windows 365.

David C

On Thu, Jan 4, 2018 at 7:39 PM, lurker123 via gnucash-user <
gnucash-user@gnucash.org> wrote:


Are there any known tricks for successfully installing and running
GnuCash on a Windows 365 machine?



--
Sent from:
http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


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




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

Re: GnuCash install on Windows 365

[Paul Makinen via gnucash-user]

I see a lot of queries at microsoft.com about "Windows 365," but none of 
the people responding to these queries mention the term...so there must 
be *something* out there in userland that is confusing people (I'm 
asking for someone else, and I haven't seen the actual computer the 
GnuCash attempt  was made on).





On 04.01.2018 20:22, David Carlson wrote:

According to my sources there is no such thing asWindows 365.

David C

On Thu, Jan 4, 2018 at 7:39 PM, lurker123 via gnucash-user 
> wrote:



Are there any known tricks for successfully installing and running
GnuCash
on a Windows 365 machine?



--
Sent from:
http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




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

RE: GnuCash install on Windows 365

[Ken Pyzik]

To the best of my knowledge - this person may be confusing this with Office
365 -- which would have no effect at all on Gnucash.   The usual OS for
Office 365 would probably be Windows 10 and Gnucash runs great on Windows 10
-- which is what I am running it on. 

-Original Message-
From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org]
On Behalf Of David Carlson
Sent: Thursday, January 4, 2018 6:23 PM
To: lurker123 
Cc: Gnucash Users 
Subject: Re: GnuCash install on Windows 365

According to my sources there is no such thing as Windows 365.

David C

On Thu, Jan 4, 2018 at 7:39 PM, lurker123 via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> Are there any known tricks for successfully installing and running 
> GnuCash on a Windows 365 machine?
>
>
>
> --
> Sent from: 
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: GnuCash install on Windows 365

[David Carlson]

According to my sources there is no such thing as Windows 365.

David C

On Thu, Jan 4, 2018 at 7:39 PM, lurker123 via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> Are there any known tricks for successfully installing and running GnuCash
> on a Windows 365 machine?
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

GnuCash install on Windows 365

[lurker123 via gnucash-user]

Are there any known tricks for successfully installing and running GnuCash
on a Windows 365 machine?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Retrieving quotes problems

[Dave H]

Check out
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
and see if that helps...

Cheers Dave H.

On 4 January 2018 at 20:49, rob  wrote:

> After a harddisk crash I try to restore everything on my computer. I
> installed Gnucash back and my gnucash data. Program starts up but have
> problems with quotes
>
> Only when i start gnucash in the *terminal* i can get quotes for EUREX .
>
> For currencies  CURRENCY:USD   CURRENCY:EUR no quotes at all
>
> I use Yahoo as JASON as quote source
>
> Configuration
> Linux mint 18.3 XFCE
> Perl 5.22
> finance quote 1.47
> libfinance-quote-perl  1.38-1
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Latest version update

[Jack Slater]

Aha! Lesson learned - thanks. It is a Windows machine. And its GREAT
software.  Thanks to all the developers (assuming its a joint venture!?)

On Thu, Jan 4, 2018 at 12:11 PM, John Ralls  wrote:

>
>
> > On Jan 4, 2018, at 9:28 AM, Jack Slater  wrote:
> >
> > I have downloaded 2.6.19 but just wanted to make sure as to
> install/update
> > process. I'm assuming I can just install over the top of 2.6.18 but I'd
> > like to confirm that assumption first!
>
> You neglected to mention the platform. If it's Mac or Windows, yes, just
> install it over the existing one. On Mac you can even rename one of them
> and install them next to each other or put them in separate directories. On
> Windows the installer will take care of removing the old one for you after
> asking permission to do so.
>
> Non-mac Unix is another matter: Our downloads are source tarballs that you
> have to build before you can install. Unless you're comfortable around
> compilers and build systems it's best to wait for your distro to provide
> the upgrade.
>
> Regards,
> John Ralls
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Latest version update

[John Ralls]

> On Jan 4, 2018, at 9:28 AM, Jack Slater  wrote:
> 
> I have downloaded 2.6.19 but just wanted to make sure as to install/update
> process. I'm assuming I can just install over the top of 2.6.18 but I'd
> like to confirm that assumption first!

You neglected to mention the platform. If it's Mac or Windows, yes, just 
install it over the existing one. On Mac you can even rename one of them and 
install them next to each other or put them in separate directories. On Windows 
the installer will take care of removing the old one for you after asking 
permission to do so.

Non-mac Unix is another matter: Our downloads are source tarballs that you have 
to build before you can install. Unless you're comfortable around compilers and 
build systems it's best to wait for your distro to provide the upgrade.

Regards,
John Ralls


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

Latest version update

[Jack Slater]

I have downloaded 2.6.19 but just wanted to make sure as to install/update
process. I'm assuming I can just install over the top of 2.6.18 but I'd
like to confirm that assumption first!
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Derek Atkins]

Hi,

Paul Neuwirth  writes:

[snip]
>> Thank you.
>> it was any account, any type and everywhere was Euro (EUR) set (not
>> changable in dialog).. I saw in the mysql table commodities, EUR
>> defined twice. when I imported transactions duplicate accounts where
>> made with the "other EUR currency". I replaced old commodity-guids in
>> all tables by the new guid..
>> 
>> update gnucash.transactions set
>> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
>> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
>> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
>> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
>> currency='2e2395017967d7799120dc8585cf4080' where currency =
>> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
>> currency='2e2395017967d7799120dc8585cf4080' where currency =
>> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
>> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
>> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
>> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
>> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
>> currency='2e2395017967d7799120dc8585cf4080' where currency =
>> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 
>> 
>> and deleted the old EUR currency... 
>> now everything is fine.. 
>> 
> Now I have the same issue with all foreign currency accounts...
>
> Execute:
>> SELECT * FROM gnucash.commodities
>
> + - + -- + - + - +
> -- + - + --- + - +
> - +
> | guid | namespace | mnemonic | fullname | cusip | fraction |
> | quote_flag | quote_source | quote_tz |
> + - + -- + - + - +
> -- + - + --- + - +
> - +
> | 090f9175bf272d914fc77cf8990ddde8 | CURRENCY | USD | US-Dollar | 840
> | | 100 | 1 | currency | |
> | 1669bedf79e858ba5ec3358346eee9b1 | CURRENCY | ZWL | Simbabwe-Dollar
> | | 716 | 100 | 0 | currency | |
> | 2d24b3b5c4ac803f1ef048f43801905c | CURRENCY | GBP | Pfund Sterling |
> | 826 | 100 | 1 | currency | |
> | 2e2395017967d7799120dc8585cf4080 | CURRENCY | EUR | Euro | 978 | 100
> | | 1 | currency | |
> | 4636ac6477efed452967bdb61c4a46ff | CURRENCY | PLN | Zloty | 985 |
> | 100 | 1 | currency | |
> | aad29cfc8037ac37b0a30fb16fad538a | template | template | template |
> | template | 1 | 0 | | |
> | bc7184bbbdac77765e615d7a3e2547d3 | CURRENCY | USD | US-Dollar | 840
> | | 100 | 1 | currency | |
> | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
> + - + -- + - + - +
> -- + - + --- + - +
> - + 8 rows
>
> what is bad at first entry for USD (old accounts), but new want the
> last line's USD...

This seems like a bug that there are multiple entries for a currency.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Printing Hard Copy

[Derek Atkins]

Matthew Pounsett  writes:

> On 3 January 2018 at 13:28, Derek Atkins  wrote:
>
>> Hi,
>>
>> rj ruble  writes:
>>
>> > How can I print my accounts to hard copy?
>>
>> Generate the appropriate report that shows the accounts as you want, and
>> then you can print the report.
>>
>>
> Is there a report that reproduces a Basic, Auto-Split, or Transaction
> Journal ledger?

Yes.  Open the register, configure it to how you want (the View menu is
your friend), and then run the Register Report.  That will give you a
printable report of the current register view.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Stock Quotes in Debian 9?

[David Carlson]

Has anyone been able to update F::Q in Debian 9 Stretch?  I get errors when
I try to get CPAN to do it for me.

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

Re: Falure to open gnucash

[Derek Atkins]

Hi,

First, please CC the list on all replies..

Jerome Kremen  writes:

> Thank you Mr. Atkins.
>
> I thought the user list overlord had irrevocably cancelled my hope of ever
> getting an answer from Gnucash users when he turned down my question nearly a
> month ago.  It's a mystery to me how the user list works and why I never get
> an answer to my applications to join a users list or to my questions.  I've
> been through this process a number of times since I started using Gnucash
> about 18 months ago and always end up with the same rejection or no answer at
> all.

There is no "application to join" the list.  You just need to
subscribe.  The only "application to join" is to the WIKI, and an
account there is only required to make changes to the wiki.  So yes,
those accounts are moderated and most are turned down.  However list
membership is 100% self-service at https://lists.gnucash.org/mailman/listinfo

I don't know what question was "turned down" a month ago.  It's possible
that the list moderator made a mistake and thought it was spam (she's
only human and does sometimes, albeit rarely, make a mistake).

> So I am really thankful for your answer.

Always here to help.  ;)

> Best Wishes,
>
> Jerry Kremen

-derek

> --
> From: Derek Atkins 
> To: Jerome Kremen 
> Cc: "gnucash-user@gnucash.org" 
> Sent: Wednesday, January 3, 2018 12:34 PM
> Subject: Re: Falure to open gnucash
>
> Hi,
>
> Jerome Kremen  writes:
>
>> Dear Members
>> I tried to access my gnucash accounts yesterday and got the cryptic
>> error message gnucash failed to open because of a problem.
>> I am using the Mac operating system which I recently upgraded to High
>> Sierra 10.13.2.  Can that be the cause of my failure to open Gnucash?
>> I then downloaded the latest version of gnucash but did not install it
>> because I didn’t know whether the new installation would wipe out my
>> company books.
>
> What version of GnuCash?  You need at least 2.6.18 for High Sierra.
>
>> Is it safe to install a new version?
>
> Yes.
>
>>   Will it preserve my accounts?
>
> Yes.
>
>> Your help would be much appreciated.  Since I am not sure how to
>> navigate the mailing lists and would not know where to find a reply,
>> please reply to jerry.kre...@engopt.com.
>> Best wishes,
>> Jerry kremen
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> -derek
> --
>   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>   Member, MIT Student Information Processing Board  (SIPB)
>   URL: http://web.mit.edu/warlord/   PP-ASEL-IAN1NWH
>   warl...@mit.eduPGP key available
>

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to deal with RRSP's (Canada)

[Matthew Pounsett]

On 3 January 2018 at 22:11, Cam Ellison  wrote:

>
>> The examples I used were (perhaps over-) simplifications. In practice, I
> actually have a number of stocks and money market accounts within two RIFs,
> like so:
>
> Assets:investments:RIF:Stock1
> Assets:Investments:RIF:Stock2
> Assets:Investments:RIF:MoneyMarket1
> Assets:Investments:RIF:Cash
> etc.
>

Mine are similar, without the cash account.  Looks like we're modelling
this part the same way.


>
>
> The offset account can't be a liability - that would double the impact of
> the withdrawal and screw up your balance sheet. It pretty much needs to be
> either an Equity or an Expense account. As I think about it more, there is
> a certain logic to the latter, since it was originally Income.



I see what you mean about Liability.. you're right, that wouldn't work.
Last night as I was thinking about this more, it occurred to me that a
non-taxable Income account would probably work best to balance out taxable
income.



> I think if your employer contributes to your RRSP or a fund or other
> instrument within it, that probably needs to be dealt with as Income. Also,
> it may count as a taxable benefit.


My recollection from the last time an employer did RRSP matching for me was
that it was tax deferred, just like any other RSP contribution.   But, I
was talking about self-contributing direct from payroll, which can happen
pre-tax (pre-withholding).
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Retrieving quotes problems

[rob]

After a harddisk crash I try to restore everything on my computer. I
installed Gnucash back and my gnucash data. Program starts up but have
problems with quotes

Only when i start gnucash in the *terminal* i can get quotes for EUREX .

For currencies  CURRENCY:USD   CURRENCY:EUR no quotes at all

I use Yahoo as JASON as quote source

Configuration
Linux mint 18.3 XFCE
Perl 5.22
finance quote 1.47
libfinance-quote-perl  1.38-1
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Printing Hard Copy

[rj ruble]

Thanks

On Jan 3, 2018 6:59 PM, "Maf. King"  wrote:

> On Wednesday, 3 January 2018 23:42:14 GMT Matthew Pounsett wrote:
>
> >
> > Is there a report that reproduces a Basic, Auto-Split, or Transaction
> > Journal ledger?
> >
>
>
> Hi,
>
> isn't this what the Account Report is for -  printing the details of a
> register view, as filtered / date limited etc.?
>
> Maf.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: Sorting options for Credit Card account

[John Rogers]

Thanks for the info.   I had a feeling that was going to be the answer.

Thanks again for taking the time to review and answer.

Sincerely,

John Rogers



-Original Message-
From: Derek Atkins [mailto:warl...@mit.edu] 
Sent: Wednesday, January 03, 2018 1:17 PM
To: John Rogers 
Cc: gnucash-user@gnucash.org
Subject: Re: Sorting options for Credit Card account

Hi,

"John Rogers"  writes:

> I have a rather active credit card account (approximately 6 charges per
day)
> that I'm trying to keep in sync with my bank.   I enter the transactions
as
> I see the receipts.   I also mark the transaction in the Reconcile column
> from n to c when I see it has cleared my bank's website.   I have the sort
> order set to Statement Date.  This seems to do what I want in that it 
> does move the transactions that have been cleared to the top and the ones
that
> are not cleared to the bottom.   However, the issue is that let's say that
I
> put in 6 transactions for 12/22/2017 in the register in a random order.
2
> of them have cleared and I have set them to a c.   They show at the top.
> However, the Balance that shows on the right side shows the balance in the
> order the transactions were entered, not by the cleared status.   Is there
> any way to show the transaction AND balance by the cleared status ?

The short answer is no.

The balance is a split-parameter computed based on the standard sort order.
Changing the sort order does not recompute the balance entries.
The balance is not "computed", because we don't want to show the "incorrect"
balance if you're only showing a subset of transactions.

> See attached screenshot.   The balance after adding in 26.34 to 1089.83
> should be 1116.17.   However, it shows 1250.34 which I'm assuming is
several
> of the other [un-cleared] transactions as well.

Correct.

> Thanks in advance for any assistance,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available

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