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

[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 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 experts.
>
> Regards
>
> Geoff
> =
>
> On 9/06/2021 11:34 am, Christopher Lam wrote:
> > 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 handle
> > negative stock balances; the reports will bail out.
> > - it's likely very wrong to record a single transaction that sells more
> > stock than your current holding; you'll need to sell current balance
> > (and record cap gains/losses) *then* record a separate short-sell
> > transaction to achieve a negative balance.
> > - recent releases (4.5? or current daily builds) have an experimental
> > IFRS cost basis report which aims to calculate the average cost base,
> > according to some jurisdictions eg Canadian. It's not guaranteed correct
> > yet.
> >
> >
> > Note that I am not an accountant, but I think you should also book a
> > future liability for when the short falls due.
> >
> >
> > Why?
>
___
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] Enable Online Stock Price Updating in GnuCash

[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 experts.

Regards

Geoff
=

On 9/06/2021 11:34 am, Christopher Lam wrote:

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 handle 
negative stock balances; the reports will bail out.
- it's likely very wrong to record a single transaction that sells more 
stock than your current holding; you'll need to sell current balance 
(and record cap gains/losses) *then* record a separate short-sell 
transaction to achieve a negative balance.
- recent releases (4.5? or current daily builds) have an experimental 
IFRS cost basis report which aims to calculate the average cost base, 
according to some jurisdictions eg Canadian. It's not guaranteed correct 
yet.



Note that I am not an accountant, but I think you should also book a
future liability for when the short falls due.


Why?

___
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] Enable Online Stock Price Updating in GnuCash

[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 Online Price Retrieval for GnuCash" - from the Start 
Menu

 This time I let it run overnight - even though it looked like it was 
stalled after about 30 minutes

   In the morning it said that it succeeded

I ran the CMD Prompt

 Went to the directory:  C:\Program Files 
(x86)\gnucash\bin

I typed in:   "perl gnc-fq-check

 It showed several quote sites as being 
available



I would recommend that someone update the GnuCash Tutorial to reflect the above 
(for Windows)

  *   Main part was probably to wait overnight for the "Install Online Price 
Retrieval for GnuCash" to finish
  *   Also in the tutorial where it says to run "gnc-fq-update" in the shell 
(cmd) prompt - it would be better to say run it by typing "perl gnc-fq-update"





Different question:  Is there a way to properly record a stock that has been 
sold short?





Thanks,

Jai Rao







-Original Message-
From: Chris Good 
Sent: Monday, June 7, 2021 8:57 PM
To: gnucash-user@gnucash.org
Cc: jaib...@outlook.com
Subject: RE: Enable Online Stock Price Updating in GnuCash



Message: 11

Date: Fri, 4 Jun 2021 04:37:09 +

From: Jai Rao mailto:jaib...@outlook.com>>

To: "GnuCash-User@GnuCash.Org" 
mailto:GnuCash-User@GnuCash.Org>>

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

Message-ID:







Content-Type: text/plain; charset="us-ascii"



Sir / Madam,



I am trying to enable Online Stock Price Updating in GnuCash - (in Windows 10).



  *   I have installed Strawberry Perl



 *   Then I ran the "Install Online Price Retrieval for GnuCash" - from

the Start Menu



*   This goes thru a long process in the CMD Prompt (Shell) window



   *   It seems to make it to the end - see picture below:

   *   [cid:6644e8d2-a3a2-4004-9571-53b898113207]

   *   Then I open a new CMD Prompt and type:  "perldoc

Finance::Quote"



  *   It says that there is no documentation for this



  *   I then tried to go to the GnuCash Wiki page - but I was not able to

get anyhere.

I also could not figure out how to do the Root Shell to run "gnc-fq-update"



Can you please let me know what to do?

Thanks,

Jai Rao





-- next part --

A non-text attachment was scrubbed...

Name: image.png

Type: image/png

Size: 78003 bytes

Desc: image.png

URL:



-- next part --

A non-text attachment was scrubbed...

Name: Outlook-q35xlm5e.png

Type: image/png

Size: 68180 bytes

Desc: Outlook-q35xlm5e.png

URL:



-- next part --

A non-text attachment was scrubbed...

Name: Outlook-udrywjix.png

Type: image/png

Size: 68180 bytes

Desc: Outlook-udrywjix.png

URL:



-- next part --

A non-text attachment was scrubbed...

Name: Outlook-0cdyg2x0.png

Type: image/png

Size: 68180 bytes

Desc: Outlook-0cdyg2x0.png

URL:

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

[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 handle
negative stock balances; the reports will bail out.
- it's likely very wrong to record a single transaction that sells more
stock than your current holding; you'll need to sell current balance (and
record cap gains/losses) *then* record a separate short-sell transaction to
achieve a negative balance.
- recent releases (4.5? or current daily builds) have an experimental IFRS
cost basis report which aims to calculate the average cost base, according
to some jurisdictions eg Canadian. It's not guaranteed correct yet.


> Note that I am not an accountant, but I think you should also book a
> future liability for when the short falls due.
>

Why?
___
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] Large Negative Account Total

[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 17:23:55 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Large Negative Account Total

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 to get the large negative amount for the Investment 
> Misc parent account not to be negative?

Off the top of my head, I will guess that it is a sign that your 
investments are successful. Think about the signs of an expense-type 
account. You spend money, money goes out, the transaction has a positive 
sign. You get a refund, money comes in, the transaction has a negative 
sign. You get lots of refunds, you have a large credit in your 
expense-type account, you have a negative balance.

The parent account "Investment Misc" is a expense-type account. If the 
total of all transactions in its child accounts adds up to money coming 
in, then the "Investment Misc" account ought to show a negative balance, 
right?  It's a good thing! You have money!

Someone who knows accounting theory could probably explain this in terms 
of credits and debits to Equity and Assets. I think I have heard that 
Expense and Income, and positive and negative signs, are a layer of ease 
of use on top of these fundamentals.

An experiment to try would be to redesignate "Investment Misc" as an 
Income-type account. That might flip the sign of the account total.

> …I didn't what to go willy-nilly changing things in fear of really 
> messing things up.

Remember, every time you quit GnuCash, it makes a backup of your book 
file. If you want to try an experiment, you can:

1. Quit GnuCash.

2. Make a copy of the book file

3. Start GnuCash.

4. Try your experiment.

5. See if you like the results of the experiment.

6. If you do, keep using the new book. If you do not, then quit Gnucash, 
delete the most recent copy of your book file, and replace it with the 
copy you saved. Then restart GnuCash.

Best regards,
     —Jim DeLaHunt


___
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] Large Negative Account Total

[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. This is
necessary for the correct summation of the accounts in the generated reports
and perhaps also may be necessary for the accounting rules which are built
into GnuCash's coding to work correctly. It is likely your large negative
balance results from mixing the account sub-types. Most of the accounting
rules are enforced at the transaction level in terms of the sum of debits
and credits being zero, and only being able to select certain account types
in some cases.  

AFAIK the structure of GnuCash does not work in general with a general
placeholder accounts with sub- accounts which are of different types. It may
,but it is unlikely the reporting structure will and balance sheets and
similar reports are likely to be incorrect. A structure which will work
better with the reporting system and in-built accounting rules would be to
have an Investment Misc placeholder under each of the top level accounts.
This has come up in the discussions a number of times usually with regard to
a user operating a number of business activities where they need to have
separate information on each activity for management purposes. It is even
more the case that this will cause problems with the business features in
particular with accounts payable and receivable

Assets:Investments Misc:...subaccounts for each investment or investment
type as appropriate
Liabilities:Investments Misc: ... appropriate sub accounts for your needs
Equity:... Less necessary to have the substructure here but it can help in
defining where your wealth is held.
Income:Investements Misc: 
Income:Investements Misc:Interest
Income:Investements Misc:Dividends
Income:Investements Misc:LT Gains
Income:Investements Misc:ST Gains

Expenses:Investements Misc:Fees A
Expenses:Investements Misc:Fees B
Expenses:Fees

Then if you want to generate a report only about Investments Misc you would
select these placeholders and their sub accounts in each of the top level
categories in the report options.  

The above approach is generally used in standard accounting practice.
Accountants also sort assets and liabilities into categories like current
accounts and non-current accounts, the difference being that entries in the
current accounts would usually expected to be settled within a single
accounting period/financial year whereas non-current accounts deal with
items which are generally held and used and consumed over several accounting
periods.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Large Negative Account Total

[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 to get the large negative amount for the Investment 
Misc parent account not to be negative?


Off the top of my head, I will guess that it is a sign that your 
investments are successful. Think about the signs of an expense-type 
account. You spend money, money goes out, the transaction has a positive 
sign. You get a refund, money comes in, the transaction has a negative 
sign. You get lots of refunds, you have a large credit in your 
expense-type account, you have a negative balance.


The parent account "Investment Misc" is a expense-type account. If the 
total of all transactions in its child accounts adds up to money coming 
in, then the "Investment Misc" account ought to show a negative balance, 
right?  It's a good thing! You have money!


Someone who knows accounting theory could probably explain this in terms 
of credits and debits to Equity and Assets. I think I have heard that 
Expense and Income, and positive and negative signs, are a layer of ease 
of use on top of these fundamentals.


An experiment to try would be to redesignate "Investment Misc" as an 
Income-type account. That might flip the sign of the account total.


…I didn't what to go willy-nilly changing things in fear of really 
messing things up.


Remember, every time you quit GnuCash, it makes a backup of your book 
file. If you want to try an experiment, you can:


1. Quit GnuCash.

2. Make a copy of the book file

3. Start GnuCash.

4. Try your experiment.

5. See if you like the results of the experiment.

6. If you do, keep using the new book. If you do not, then quit Gnucash, 
delete the most recent copy of your book file, and replace it with the 
copy you saved. Then restart GnuCash.


Best regards,
    —Jim DeLaHunt


___
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] Transaction ordering on num field

[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 and still numbers the next check correctly if I use
non-numeric characters in transactions that do not represent checks.

Those are my preferences!

On Tue, Jun 8, 2021 at 1:37 PM John Ralls  wrote:

> 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 I've fixed
> his implementation and have it ready to push for GnuCash 4.6.
>
> So far so good, but it changes the order of transactions when the num
> field isn't all numeric and I want to know if the change will cause trouble
> for anyone.
>
> The current behavior is that a string beginning with a letter will have a
> sort value of 0 and one starting with a number will have a value equal to
> the numbers up to the first non-number character, so for example 12ab34
> will have a sort value of 12, up to ±(10^10 - 1). "abc" and "def" will sort
> equally so the compare would fall through to the next criterion; "abc"
> would sort between "-12ab34" and "12ab34".
>
> The new way is that if both strings are all numbers and there are fewer
> than 19 characters in each then the sort values will be their numeric
> values and the comparison will be numeric, so e.g. 2 sorts before 10. If
> those conditions aren't true then the two values will be string-compared,
> meaning a lexical sort: A very large number beginning with 2 will sort
> before a shorter number beginning with 3; "abc" will sort before "def" but
> after both "123" and "-123" because 1 and - sort before a. That's for an
> English locale; in order to accommodate UTF-8 strings the collation of the
> current locale.
>
> Will that break anyone's carefully-crafted transaction ordering?
>
> 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.
>


-- 
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] Large Negative Account Total

[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. So the only changes I would make from here on I would consider tweeks.


I have the following account structure:

Investment Misc
    Expenses
    Fees A
    Fees B
    Income
    Interest
    Dividends
    LT Gains
    ST Gains

The parent account "Investment Misc" is an expense account and is marked 
as a place holder account.
The sub accounts, "Expenses" and "Income", are expense or income 
accounts and it's obvious which is which. They are also marked as a 
place holder accounts.
So the only accounts that have any transactions are the sub accounts to 
the "Expenses" and "Income" accounts. The vast majority of the 
transactions are made as split transactions from other accounts. Note: 
Account names have been disguised in my example.


In my account tabs the "Investment Misc" parent account shows a negative 
amount. (-$70 K range)
All of these accounts go back to 2003 and have never been reconciled. 
(Stop your screaming please..)


Questions:
+ What can I do to get the large negative amount for the Investment Misc 
parent account not to be negative?
+ Does it figure into the NET Assets that appear on the bottom of the 
GNU main window?


A couple of things I thought about trying.
+ Changing the Investment Misc parent account to a bank account.
+ Reconciled the sub accounts.

I didn't what to go willy-nilly changing things in fear of really 
messing things up.


Hope this all made sense.
Thanks.



--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Transaction ordering on num field

[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 I've fixed his 
implementation and have it ready to push for GnuCash 4.6.

So far so good, but it changes the order of transactions when the num field 
isn't all numeric and I want to know if the change will cause trouble for 
anyone.

The current behavior is that a string beginning with a letter will have a sort 
value of 0 and one starting with a number will have a value equal to the 
numbers up to the first non-number character, so for example 12ab34 will have a 
sort value of 12, up to ±(10^10 - 1). "abc" and "def" will sort equally so the 
compare would fall through to the next criterion; "abc" would sort between 
"-12ab34" and "12ab34".

The new way is that if both strings are all numbers and there are fewer than 19 
characters in each then the sort values will be their numeric values and the 
comparison will be numeric, so e.g. 2 sorts before 10. If those conditions 
aren't true then the two values will be string-compared, meaning a lexical 
sort: A very large number beginning with 2 will sort before a shorter number 
beginning with 3; "abc" will sort before "def" but after both "123" and "-123" 
because 1 and - sort before a. That's for an English locale; in order to 
accommodate UTF-8 strings the collation of the current locale.

Will that break anyone's carefully-crafted transaction ordering?

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

[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 accounts is just not worth the
>>> grief.
>>> 
>>> Other software allows a category or class[ification] field on each
>>> transaction. Normally the field is even auto-populated based on say a
>>> payment by a tenant. One field is still not ideal because you might want
>>> multiple classifications on one transaction like bigger accounting packages
>>> offer (location, manager, supplier, owner, enterprise etc). The feature's
>>> been requested fairly frequently for ages:
>>> https://bugs.gnucash.org/show_bug.cgi?id=113772
>>> 
>>> Best thing you can do is change to different software. I use an old
>>> quickbooks version for my business to get that feature but you miss out on
>>> the open access to the database and potential reporting that brings. Say
>>> rental statements, performance per unit or property manager.
>>> 
>>> Maybe look at https://kmymoney.org/
>> 
>> 
>> I’m using GnuCash 4.4 on iMac with Catalina, and have 6 files in my 
>> Most-Recently-Used (MRU) list.
>> 
>> Some time ago I reported a bug in the updating of the MRU which was fixed in 
>> the next release, and it was about this time that the 6-item MRU became 
>> available on my system.
>> 
>> I can’t find a Preferences setting for the number of files in the MRU, but 
>> I’m sure John Ralls could point a finger in the right direction.
> 
> Not sure what MRU has to do with categories.

This has been a long thread, and earlier on there was a complaint about not 
being able to have > 4 files in the MRU list.

You had shared the magic “defaults write…” incantation with me, but I used it 
once (all that was necessary) and promptly forgot how I’d done it. 

Apologies for the noise!

Michael

> 
> The MRU list size preference isn't exposed in the GnuCash UI. Linux users can 
> get to it with dconf-editor and macOS users via defaults, e.g.
>  defaults write -app Gnucash /org/gnucash/history/maxfiles '6'
> Microsoft Windows users can get to it via regedit, it will be somewhere under 
> IIRC HKCU\Software\Gnucash.
> 
> 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] How to do property asset and loan when acquired in the past

[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 principle amounts based on the exact day (and probably the hour, 
minute, and second) they receive my payment, which I cannot know in advance. 
David T.


Speaking as somebody who has written programs to produce amortization 
tables. the reason for non-agreement with the bank (or whoever) isn't 
likely just a matter of the rule they are using to compute interest. And 
yes you COULD know that as will be specified in the loan document. But 
what you will not know are the things like:


a) Number of significant digits used in various places in the computation.

b) The method used (present value, "trial and error", etc.)

c) How the end of the loan (final payment) will be treated. Normally 
will NOT be coming out exactly.


d) The escrow payment amount is another complex calculation. The reason 
the amount seems to jump around year to year is that the balance in the 
escrow account has to remain above zero ALL THE TIME (not just net over 
the entire year)


e) As long as the payment you send is received on time, that will not 
affect anything. I have never seen a loan agreement where that would happen.


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] How to do property asset and loan when acquired in the past

[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 probably the hour, 
minute, and second) they receive my payment, which I cannot know in advance. 
David T. 


 Original Message 
From: David Carlson 
Sent: Tue Jun 08 08:34:33 EDT 2021
To: flywire 
Cc: Gnucash Users 
Subject: Re: [GNC] How to do property asset and loan when acquired in the past

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 you know the actual values .

On Tue, Jun 8, 2021 at 6:51 AM flywire  wrote:

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

___
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] How to do property asset and loan when acquired in the past

[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 you know the actual values .

On Tue, Jun 8, 2021 at 6:51 AM flywire  wrote:

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

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

[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
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] How to do property asset and loan when acquired in the past

[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 account with a beginning balance of $100 to capture the
value of the property.
2. create a liability account with a beginning balance of $25
3. track transactions on the loan, eg interests and payments moving forward

not an accounting expert.

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