Re: aqbanking / ofx downloads to wrong account and can't straighten out

[Bill Starrs]

Hi John,

Thanks for your response. I followed this and have the same situation.
The transactions and balance are correct for the account that I update
from, but the transactions still go to the other account, as well as the
reconciliation window opens for the other account.

Still scratching my head.  There has to be a way to manually fix it.

Thanks,

Bill


On Fri, Feb 16, 2018 at 02:05:02PM -0800, John Ralls wrote:




On Feb 16, 2018, at 12:08 PM, Bill Starrs  wrote:

Hello,

A few months ago I had to change a credit card # due to fraud and
reconfigure it through aqbanking.  When I did this, I accidentally
associated it with the wrong credit card account in gnucash.

After re-configuring it again, and again, and again, in the wizard, I
now have a situation where when I am sitting in the proper account and
download transactions, I get the preview of the charges for that card,
however in the "Account" column of the download reconciliation dialog,
it shows the other, mistaken account.  When I accept the transactions,
they are placed into that other account.  I then have to manually change
them to put them in the right account.  Account balancing also does not
work as it opens the balance dialog of the incorrect account.

I gave up on fixing with the ui and started looking through the .gnucash
and .aqbanking directories as well as the mariadb gnucash database to
manually fix this setting but have given up here too.



I haven't had to do this in a while, but IIRC you run the Online Banking Setup assistant, start and close the AQBanking 
wizard, and click "forward" on the GnuCash assistant. The next screen is a list of your AQBanking accounts. 
Double-click the one that you want to change and you'll get a Select Account dialog from which you can pick the new 
account. Once you have done that, the account name will appear in the middle column and the "New?" box will 
be checked. Click "Forward" and the "Apply".

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: Online quotes fetching latest stock price but incorrect date; currency exchange rate also not working

[John Ralls]

And by “operating system’s time zone is correct” he means “in Australia” (or 
Asia somewhere), because if you’re in America then the closing price really is 
from the 15th.

Regards,
John Ralls

> On Feb 17, 2018, at 7:32 PM, Ronal B Morse  wrote:
> 
> I guess the first step is to verify that the system time and date is correct 
> and the operating system's time zone setting is correct.
> 
> RBM
> 
> 
> 
> On 02/17/2018 07:10 PM, Justin Smith wrote:
>> Hi,
>> 
>> Gnucash is not updating stock quotes correctly for me. The stock price is
>> correct but an incorrect date is used.
>> 
>> This is confirmed when testing using gnc-fq-dump. E.g.
>> 
>> ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB.AX
>> Finance::Quote fields Gnucash uses:
>> symbol: NAB.AX   <=== required
>>   date: 02/15/2018   <=== recommended
>>   currency: AUD  <=== required
>>   last: 29.2200  <=\
>>nav:  <=== one of these
>>  price:  <=/
>>   timezone:  <=== optional
>> 
>> Today's date is Feb 18. The price is actually the closing price for last
>> Fri 16 Feb.
>> 
>> Gnucash then overwrites the historical price for Feb 15, with the price for
>> Feb 16.
>> 
>> This happens for all my ASX stocks.
>> 
>> At the same time, Gnucash is also consistently returning the error "Unable
>> to retrieve quotes for these items: CURRENCY:USD". This sounds unrelated if
>> it wasn't for the fact that it started happening at the same time as the
>> above date issue...
>> 
>> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (PPA). And Finance::Quote
>> 1.48 (installed from git).
>> 
>> Any ideas?
>> 
>> 
>> Thanks,
>> Justin.
>> ___
>> 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.

___
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: Online quotes fetching latest stock price but incorrect date; currency exchange rate also not working

[Ronal B Morse]

I guess the first step is to verify that the system time and date is 
correct and the operating system's time zone setting is correct.


RBM



On 02/17/2018 07:10 PM, Justin Smith wrote:

Hi,

Gnucash is not updating stock quotes correctly for me. The stock price is
correct but an incorrect date is used.

This is confirmed when testing using gnc-fq-dump. E.g.

ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB.AX
Finance::Quote fields Gnucash uses:
 symbol: NAB.AX   <=== required
   date: 02/15/2018   <=== recommended
   currency: AUD  <=== required
   last: 29.2200  <=\
nav:  <=== one of these
  price:  <=/
   timezone:  <=== optional

Today's date is Feb 18. The price is actually the closing price for last
Fri 16 Feb.

Gnucash then overwrites the historical price for Feb 15, with the price for
Feb 16.

This happens for all my ASX stocks.

At the same time, Gnucash is also consistently returning the error "Unable
to retrieve quotes for these items: CURRENCY:USD". This sounds unrelated if
it wasn't for the fact that it started happening at the same time as the
above date issue...

I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (PPA). And Finance::Quote
1.48 (installed from git).

Any ideas?


Thanks,
Justin.
___
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.

Online quotes fetching latest stock price but incorrect date; currency exchange rate also not working

[Justin Smith]

Hi,

Gnucash is not updating stock quotes correctly for me. The stock price is
correct but an incorrect date is used.

This is confirmed when testing using gnc-fq-dump. E.g.

ALPHAVANTAGE_API_KEY= gnc-fq-dump alphavantage NAB.AX
Finance::Quote fields Gnucash uses:
symbol: NAB.AX   <=== required
  date: 02/15/2018   <=== recommended
  currency: AUD  <=== required
  last: 29.2200  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

Today's date is Feb 18. The price is actually the closing price for last
Fri 16 Feb.

Gnucash then overwrites the historical price for Feb 15, with the price for
Feb 16.

This happens for all my ASX stocks.

At the same time, Gnucash is also consistently returning the error "Unable
to retrieve quotes for these items: CURRENCY:USD". This sounds unrelated if
it wasn't for the fact that it started happening at the same time as the
above date issue...

I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (PPA). And Finance::Quote
1.48 (installed from git).

Any ideas?


Thanks,
Justin.
___
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: How to account for a house purchase

[Tony Vanson]

Thank you all for your quick and useful advice. Cheers


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Feb 18, 2018 at 12:53 AM, John Ralls  wrote:

> Ron,
>
> You made the right choice. Barring a price-to-market accounting
> requirement that never applies to individuals, the book value is what you
> actually paid. When you get around to selling you’ll get taxed on the
> difference between the net selling price and that purchase price.
>
> If you want to see the “funny money” of market value you can create a
> “house” security and make Assets:House contain one of them, purchased at
> the price on the contract. Then you can get updated market price estimates
> and put them in the pricedb. The supposed market value will then show up on
> the Accounts page and in various reports.
>
> Regards,
> John Ralls
>
> > On Feb 17, 2018, at 9:01 AM, Ronal B Morse  wrote:
> >
> > That's what I did. I also had to set up a corresponding liability
> account for the mortgage, but that's a separate issue.
> >
> > I wasn't sure if I should use the purchase price or the appraised value
> as the value of the asset, but since I do everything else on a cash basis,
> I decided to use the cash price.  That does have some impact on net worth
> calculations, but I'll live with that.
> >
> > RBM
> >
> >
> > On 02/17/2018 07:56 AM, Robert Heller wrote:
> >> At Sat, 17 Feb 2018 21:31:54 +0700 Tony Vanson 
> wrote:
> >>
> >>> Hi all,
> >>> Hopefully someone can point me in the right direction on how to
> account for a house purchase in GNUCash.
> >>> I have contracted to buy a house and have paid a 10% deposit from my
> bank account, with the remainder becoming due within 2 months. I understand
> that the deposit amount is a debit against my bank account but I have no
> idea what the corresponding  double-entry should be. I assume when this
> purchase is completed it will be an asset?
> >>> Regards
> >> How about Assets:House ?
> >>
> >>>
> >>> Sent from Mail for Windows 10
> >>>
> >>>
> >>>
> >>> ---
> >>> This email has been checked for viruses by Avast antivirus software.
> >>> https://www.avast.com/antivirus
> >>> ___
> >>> 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.
>
> ___
> 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.
>



-- 
*Tony Vanson*

*The older I get,*
*the better I was*
___
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: Lock file issues

[Nelson Handcock]

No prob. Please remember to "reply-all", for the benefit of others who have
received your original email - that way everyone can see what's going on.

The LCK file can simply be deleted from the directory if the main Gnucash
file is not in use - assuming you aren't using a shared directory that
others can access.


Cheers for now



On Sun, Feb 18, 2018 at 10:00 AM, Christine  wrote:

> Its ok it has worked now, thanks
>
>
>
> *From:* Nelson Handcock [mailto:nelson.handc...@gmail.com]
> *Sent:* 17 February 2018 23:28
> *To:* Christine
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: Lock file issues
>
>
>
> Hi,
>
>
>
> The lock file is only there when the file is opened, and when you save and
> close (assuming this is done correctly and completely), then the lock file
> should be deleted.
>
>
>
> So if the LCK file is there while the Gnucash file is not being used, then
> this tells you the Gnucash application wasn't closed properly - perhaps
> your PC suffered a sudden loss of power or something similar?
>
>
>
> Anyway - you should be able to choose the option to "open anyway", and
> continue on with your work.
>
>
>
> Just make sure you check the file, because it's possible the last set of
> changes you made might not have been saved.
>
>
>
> It's always a good idea to deliberately save any changes, and then close
> the application as a separate activity. The LCK file should not be there
> once you have exited.
>
>
>
> Hope this helps
>
>
>
>
> Nelson Handcock
>
>
>
> On Sun, Feb 18, 2018 at 9:14 AM, Christine via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> When I tried to open my accounts on gnucash it stated that the lock file
> could not be opened. The lock file is still in the folder. What can I do?
>
> GnuCash could not obtain the lock for
> file://C:\Users\Polly\Desktop\hubb_main\HUBB_MAIN_ACCOUNTS.gnucash.
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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.
>
>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_9121902285614457695_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
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: Lock file issues

[Nelson Handcock]

Hi,

The lock file is only there when the file is opened, and when you save and
close (assuming this is done correctly and completely), then the lock file
should be deleted.

So if the LCK file is there while the Gnucash file is not being used, then
this tells you the Gnucash application wasn't closed properly - perhaps
your PC suffered a sudden loss of power or something similar?

Anyway - you should be able to choose the option to "open anyway", and
continue on with your work.

Just make sure you check the file, because it's possible the last set of
changes you made might not have been saved.

It's always a good idea to deliberately save any changes, and then close
the application as a separate activity. The LCK file should not be there
once you have exited.

Hope this helps


Nelson Handcock


On Sun, Feb 18, 2018 at 9:14 AM, Christine via gnucash-user <
gnucash-user@gnucash.org> wrote:

> When I tried to open my accounts on gnucash it stated that the lock file
> could not be opened. The lock file is still in the folder. What can I do?
>
> GnuCash could not obtain the lock for
> file://C:\Users\Polly\Desktop\hubb_main\HUBB_MAIN_ACCOUNTS.gnucash.
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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: Lock file issues

[Christine via gnucash-user]

When I tried to open my accounts on gnucash it stated that the lock file
could not be opened. The lock file is still in the folder. What can I do? 

GnuCash could not obtain the lock for
file://C:\Users\Polly\Desktop\hubb_main\HUBB_MAIN_ACCOUNTS.gnucash.



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: How to account for a house purchase

[John Ralls]

Ron,

You made the right choice. Barring a price-to-market accounting requirement 
that never applies to individuals, the book value is what you actually paid. 
When you get around to selling you’ll get taxed on the difference between the 
net selling price and that purchase price.

If you want to see the “funny money” of market value you can create a “house” 
security and make Assets:House contain one of them, purchased at the price on 
the contract. Then you can get updated market price estimates and put them in 
the pricedb. The supposed market value will then show up on the Accounts page 
and in various reports.

Regards,
John Ralls

> On Feb 17, 2018, at 9:01 AM, Ronal B Morse  wrote:
> 
> That's what I did. I also had to set up a corresponding liability account for 
> the mortgage, but that's a separate issue.
> 
> I wasn't sure if I should use the purchase price or the appraised value as 
> the value of the asset, but since I do everything else on a cash basis, I 
> decided to use the cash price.  That does have some impact on net worth 
> calculations, but I'll live with that.
> 
> RBM
> 
> 
> On 02/17/2018 07:56 AM, Robert Heller wrote:
>> At Sat, 17 Feb 2018 21:31:54 +0700 Tony Vanson  wrote:
>> 
>>> Hi all,
>>> Hopefully someone can point me in the right direction on how to account for 
>>> a house purchase in GNUCash.
>>> I have contracted to buy a house and have paid a 10% deposit from my bank 
>>> account, with the remainder becoming due within 2 months. I understand that 
>>> the deposit amount is a debit against my bank account but I have no idea 
>>> what the corresponding  double-entry should be. I assume when this purchase 
>>> is completed it will be an asset?
>>> Regards
>> How about Assets:House ?
>> 
>>> 
>>> Sent from Mail for Windows 10
>>> 
>>> 
>>> 
>>> ---
>>> This email has been checked for viruses by Avast antivirus software.
>>> https://www.avast.com/antivirus
>>> ___
>>> 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.

___
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: How to account for a house purchase

[Ronal B Morse]

That's what I did. I also had to set up a corresponding liability 
account for the mortgage, but that's a separate issue.


I wasn't sure if I should use the purchase price or the appraised value 
as the value of the asset, but since I do everything else on a cash 
basis, I decided to use the cash price.  That does have some impact on 
net worth calculations, but I'll live with that.


RBM


On 02/17/2018 07:56 AM, Robert Heller wrote:

At Sat, 17 Feb 2018 21:31:54 +0700 Tony Vanson  wrote:


Hi all,
Hopefully someone can point me in the right direction on how to account for a 
house purchase in GNUCash.
I have contracted to buy a house and have paid a 10% deposit from my bank 
account, with the remainder becoming due within 2 months. I understand that the 
deposit amount is a debit against my bank account but I have no idea what the 
corresponding  double-entry should be. I assume when this purchase is completed 
it will be an asset?
Regards

How about Assets:House ?



Sent from Mail for Windows 10



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: How to account for a house purchase

[Nith Valley Organics]

Or Assets:Fixed Assets:House - if you distinguish between fixed assets and 
current assets.

And yes, it is already an asset.  If the purchase should fall through and you 
get your deposit back the asset goes away and the money goes in your bank 
account.  Otherwise, it’s part of the cost basis for the house.  Presumably, 
you get to create

Liabilities:Mortgage 

as the source for part of the remainder.  

> On Feb 17, 2018, at 9:56 AM, Robert Heller  wrote:
> 
> At Sat, 17 Feb 2018 21:31:54 +0700 Tony Vanson  > wrote:
> 
>> 
>> Hi all,
>> Hopefully someone can point me in the right direction on how to account for 
>> a house purchase in GNUCash.
>> I have contracted to buy a house and have paid a 10% deposit from my bank 
>> account, with the remainder becoming due within 2 months. I understand that 
>> the deposit amount is a debit against my bank account but I have no idea 
>> what the corresponding  double-entry should be. I assume when this purchase 
>> is completed it will be an asset? 
>> Regards
> 
> How about Assets:House ?
> 
>> 
>> 
>> Sent from Mail for Windows 10
>> 
>> 
>> 
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> ___
>> 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.
>> 
>> 
> 
> -- 
> Robert Heller -- 978-544-6933
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/   -- Linux Administration 
> Services
> hel...@deepsoft.com    -- Webhosting Services
> 
> ___
> 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: How to account for a house purchase

[Robert Heller]

At Sat, 17 Feb 2018 21:31:54 +0700 Tony Vanson  wrote:

> 
> Hi all,
> Hopefully someone can point me in the right direction on how to account for a 
> house purchase in GNUCash.
> I have contracted to buy a house and have paid a 10% deposit from my bank 
> account, with the remainder becoming due within 2 months. I understand that 
> the deposit amount is a debit against my bank account but I have no idea what 
> the corresponding  double-entry should be. I assume when this purchase is 
> completed it will be an asset? 
> Regards

How about Assets:House ?

> 
> 
> Sent from Mail for Windows 10
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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.
> 
>

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
  
___
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.

How to account for a house purchase

[Tony Vanson]

Hi all,
Hopefully someone can point me in the right direction on how to account for a 
house purchase in GNUCash.
I have contracted to buy a house and have paid a 10% deposit from my bank 
account, with the remainder becoming due within 2 months. I understand that the 
deposit amount is a debit against my bank account but I have no idea what the 
corresponding  double-entry should be. I assume when this purchase is completed 
it will be an asset? 
Regards


Sent from Mail for Windows 10



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: trial balance - how to find mismatch question

[Deva -]

Thanks John. Last time you directed me to this bug report, I didn’t pay 
attention to the entire discussion - just browsed through to ensure I was 
adding my use case to the right bug. But this time, I went through all the 
*gory* details and I think I have a better understanding of what various price 
source options mean.

I was wrong when I said I have seen the imbalance in trial balance in previous 
versions - the huge imbalance appears only in 2.6.19 (other versions I am 
running are 2.6.11 and 2.6.6). When I go back to 2.6.6 or 2.6.11, there’s still 
a difference, but not a huge one - imbalance is only to the tune of few rupees 
(presumably due to rounding adjustments on 18 years of data).

I know now that my previous posting on mutual fund cost basis issue and this 
trial balance issue in 2.6.19 are connected, so sorry for taking up your time. 
I can already see that future releases will bring back the average cost 
computation as it was before 2.6.12, so this is not an issue, at least for me.

Cheers.

On 16-Feb-2018, at 9:02 PM, John Ralls 
> wrote:



On Feb 16, 2018, at 5:58 AM, Deva - 
> wrote:

I am seeing huge imbalances in my trial balance report as well. This is one 
report I have not been sending to my tax professional until I understand how to 
interpret it.

This behaviour is seen in 2.6.19 currently, but I am sure I have seen it in 
previous versions as well (I have been on GC since 2.6.6).

Though I started using GC only since 2015, I actually entered past 18 years of 
my transaction history from annual spreadsheets I used to maintain before. 
After reading this thread, I went back year after year change the end date 
until I hit the first mismatch between credits and debits - just over INR 70 as 
of Mar 2009. Progressively after that, this report now shows a difference of 
over INR 600,000!

There’s nothing in imbalance or orphan accounts and my entire datafile is in 
single currency (INR).

Only thing I can see from the time this first mismatch popped up in 2009 till 
now is that I have had capital gains from sale of shares since 2009. Though I 
recorded these gains carefully each year manually from statements, etc., the 
difference still shows up.

One reason I can think of is this -

When I run the trial balance report (or balance sheet report), the options 
given for commodity pricing are: average cost, weightage average, nearest in 
time and most recent. However, when computing capital gains, Indian tax 
authorities will only accept gains/losses computed on a FIFO basis (FIFO option 
can be selected when running Advanced Portfolio Report).

Since FIFO is not one of the options I can select for commodity pricing in 
trial balance and balance sheet reports, I am guessing the difference in 
credits and debits  is coming from cost basis determined by FIFO and average 
cost basis methods?

Deva,

See https://bugzilla.gnome.org/show_bug.cgi?id=775368.

“Average Cost” as a price source isn’t the same as “Average Cost” as a capital 
gains recognition policy. In GnuCash reports it means that the price used for 
converting one commodity to another is derived from the actual transactions, 
not from prices recorded in the price database. Read the bug for lots of gory 
details.

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: Employee Stock Option Grants

[David Carlson]

Greg,

It should be possible to track publicly traded options just like stocks if
you know the symbol and the exchange where it is traded.  However, I
personally have not tried that.  Since those options expire rather quickly,
the data would tend to clutter up and bloat your data file after time,
unless you set up special data files to segregate that data somehow.

For private options, the best you could do is to make up symbols and not
mark them for price retrieval.  Then manually enter a price from time to
time.

David C

On Fri, Feb 16, 2018 at 11:06 PM, Greg Grotsky  wrote:

> Hello Gnucash Users,
>
>  I've been using Gnucash for a while and I'm starting to feel like an
> accountant. :) Anyway, I've been interested in trying to map out employee
> stock option grants for a while to form a more complete financial view of
> all my investments.
>
>  I finally took a stab at it using the "stock" account type. It works
> really well to calculate the "real time" value of a number of shares.
> However, I realized quickly that I can't fathom a way to capture the strike
> price of the options (price to buy them at). This is a fixed value with
> which I purchase the shares from the company and needs to be subtracted
> from the "real time" price to get the actual gain at any given point in
> time.
>
>  I'm thinking I could just calculate the strike price as a fixed credit to
> the same account that the stocks are in but the problem with this is that
> the balance may go negative if the "real time" price of the shares drops
> below the strike price. In reality this means my gain/loss is zero and I
> just can't exercise those options for a gain.
>
>  Anyway, I'm guessing that most people who track their employee stock
> option grants probably don't track the actual shares that they hold. They
> probably only enter something into Gnucash when they perform a cashless
> execution. I'd like to be able to *see* my potential gains for shares that
> are "in the money", so to speak. If anyone has a suggestion, I'm all ears.
>
> Thanks,
> -Greg
> ___
> 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.