Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Christopher Lam
Isn't this "unrealised gains/losses"? Jai: the "proper" way to record transactions during shorting is still unsolved, but should be similar to buying/selling stock, except the balances are negative. Broker expense fees remain positive. On Wed, 9 Jun 2021, 10:28 am Geoff, wrote: > Hi

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Geoff
Hi Christopher Thanks for pointing out these issues. My reasoning for the need to book a future liability for a short sell was to record the obligation to deliver the short sold stock at a future date. Perhaps "contingent liability" would be a better term? Anyway, I'll leave that to the

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Jai Rao
Chris & Geoff, Thanks for your help - I was able to get it to work 1. I went to https://www.alphavantage.co/support/#api-key I got a free API Key I went to GnuCash -> Edit -> Preferences -> Online Quotes -> and input the Alpha Vantage API Key 2. I re-ran the "Install

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Christopher Lam
Hi Geoff On Wed, 9 Jun 2021, 9:27 am Geoff, wrote: > > Gnucash will permit you to run a negative balance on a stock, see > attached screenshot. > The UI will allow you to record transactions when short-selling, but bear in mind: - the current portfolio and advanced portfolio reports cannot

Re: [GNC] Large Negative Account Total

2021-06-08 Thread D. via gnucash-user
Usually, income accounts and expense accounts are placed in different top level hierarchies (Income and Expenses, respectively). Rearranging the accounts to segregate these would be a first step to gaining some clarity. Original Message From: Jim DeLaHunt Sent: Tue Jun 08

Re: [GNC] Large Negative Account Total

2021-06-08 Thread DaveC49
Jack, GnuCash has by default, top level accounts for Assets, Liabilities, Income, Expanses and Liabilities. These are also the names of account types. All accounts of account type Assets should be somewhere under the top level Asset account and likewise for accounts of each other account type.

Re: [GNC] Large Negative Account Total

2021-06-08 Thread Jim DeLaHunt
Jack: On 2021-06-08 14:04, Jack Frillman via gnucash-user wrote: …The parent account "Investment Misc" is an expense account and is marked as a place holder account.… …In my account tabs the "Investment Misc" parent account shows a negative amount. (-$70 K range) … Questions: + What can I do

Re: [GNC] Transaction ordering on num field

2021-06-08 Thread David Carlson
I would prefer 999a to sort before 1000a and character sorts to be case insensitive, but I do not depend on that for any purpose. I do, however, depend on the auto numbering function ignoring strings containing non-numeric characters as it currently does, so it currently only increments numbers

[GNC] Large Negative Account Total

2021-06-08 Thread Jack Frillman via gnucash-user
I have been using GNC for a few months now for my personal finances and I'm trying to understand some it's behavior. I'm no accountant and I'm sure I'm not following strict accounting rules. Again I'm using it only for my personal finances and overall I am satisfied with what I have set up.

[GNC] Transaction ordering on num field

2021-06-08 Thread John Ralls
Really the effective num field because of the split-action option, but anyway... The submitter of PR#963 complained that sorting on the num field doesn't work right if the value is bigger than an int can hold; that's 9 digits. His knowledge of C wasn't quite up to the task of fixing it, but

Re: [GNC] Frustration

2021-06-08 Thread Michael Hendry
> On 7 Jun 2021, at 17:30, John Ralls wrote: > > > >> On Jun 6, 2021, at 11:22 PM, Michael Hendry wrote: >> >>> On 7 Jun 2021, at 06:57, flywire wrote: >>> >>> What you want is very simple, just not in GnuCash which is possibly the only >>> package without it. The workaround changing

Re: [GNC] How to do property asset and loan when acquired in the past

2021-06-08 Thread Michael or Penny Novack
On 6/8/2021 9:22 AM, D. via gnucash-user wrote: I'll just note that I have *never* in 15 years had a gnucash-generated loan transaction that matched the actual bank transaction. I have *always* had to adjust the amounts manually after the fact, because the bank will calculate interest and

Re: [GNC] How to do property asset and loan when acquired in the past

2021-06-08 Thread D. via gnucash-user
I'll just note that I have *never* in 15 years had a gnucash-generated loan transaction that matched the actual bank transaction. I have *always* had to adjust the amounts manually after the fact, because the bank will calculate interest and principle amounts based on the exact day (and

Re: [GNC] How to do property asset and loan when acquired in the past

2021-06-08 Thread David Carlson
The part about tracking loan payments when trying to create a partially paid down loan in GnuCash is tricky. GnuCash only does simple interest calculations, so many times the best you can do is get an estimated periodic payment transaction which you will have to correct manually each month after

Re: [GNC] How to do property asset and loan when acquired in the past

2021-06-08 Thread flywire
Work through https://gnucash.org/viewdoc.phtml?rev=4=C=guide It would have been simpler as a tutorial if it was only two accounts deep. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

[GNC] How to do property asset and loan when acquired in the past

2021-06-08 Thread Gio Bacareza
Hi guys, this is my scenario simplified with hypothetical figures: 1. I bought property ex valued at $100 5 years ago. 2. I start with GnuCash today 3. As of today, let's say I have paid off a part of the loan, and let's say I have $25 left to pay. Is this how you would do it? 1. create an asset